Age/sex data for Local Authorities in England and Wales 2011.

Table ID:
AGE_SEX_2011_EW     (6561981)
Contents:
Age/sex data for Local Authorities in England and Wales 2011.
Approx. number of rows:
1,044
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. These data were obtained from table "DC1104EW - Residence type by sex by age" for Local Authorities from the 2011 Census of Population. The data was obtained from NOMIS via Census marketing on 6th November 2015 in spreadsheet format. It came from the detailed characteristics part of the 2011 Census section of the nomis website operated by the University of Durham on behalf of the Office for National Statistics. The data are under Crown Copyright, but are made available for use under an Open Government Licence.


Notes:

  1. The data contained a caveat about accuracy due to data protection which may affect results from the check sums. "In order to protect against disclosure of personal information from the 2011 Census, there has been swapping of records in the Census database between different geographic areas, and so some counts will be affected. In the main, the greatest effects will be at the lowest geographies, since the record swapping is targeted towards those households with unusual characteristics in small areas. More details on the ONS Census disclosure control strategy may be found at Census Results / Statistical Disclosure Control.
  2. The data relates to all usual residents.


Checking:

  1. The statistical data have not been checked
  2. The geographical units have been cross-checked against the GBHGIS administrative unit gazetteer to ensure that all units are correctly identified. The unit names and types have been standardised. Each unit has a unique unit ID assigned to it and this can be used to cross-reference against other data-sets.
  3. The cross-check of geographical units identified 2 units which did not match. Firstly King's Lynn and West Norfolk where the apostrophe was causing the issue. Secondly Rhonnda, Cynon, Taff where both the commas and the spelling of Taff with a double ff instead of a single one was causing issues. The datasets downloaded from Neighbourhood Statistics all spell the unit name as "TAF" as does the website for the boroguh council. We therefore have assumed this is a typo in the datasets available from NOMIS only and have manually edited the names in this dataset.


Indices:

IndexTypeColumn(s) indexed
age_sex_2011_ew_pkey Primary key rec_num
age_sex_2011_ew_g_unit_idx Unique g_unit, rec_num
age_sex_2011_ew_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
age_sex_2011_ew_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
lau_name Text string (max.len.=104). Name of the Local Authority as it appeared in the original table.
lg_type Text string (max.len.=16). Type of unit.
g_unit Integer number. Unique ID number for local authority unit from the auo gazetteer.
g_name Text string (max.len.=104). Standardised name of local authority (preferred English name as given in the auo gazetteer).
sex Text string (max.len.=6). Sex: 'F'=Row refers to women; 'M'=Row refers to men; 'T'=Row is a total for men and women.
source Text string (max.len.=20). Source table from which the data derive: 'DC1104EW' = Residence type by sex by agetable.
tot_pop Integer number. Total population.
p_0_4 Integer number. Persons aged 0 to 4.
p_5_7 Integer number. Persons aged 5 to 7.
p_8_9 Integer number. Persons aged 8 and 9.
p_10_14 Integer number. Persons aged 10 to 14.
p_15 Integer number. Persons aged 15.
p_16_17 Integer number. Persons aged 16 and 17.
p_18_19 Integer number. Persons aged 18 and 19.
p_20_24 Integer number. Persons aged 20 to 24.
p_25_29 Integer number. Persons aged 25 to 29.
p_30_34 Integer number. Persons aged 30 to 34.
p_35_39 Integer number. Persons aged 35 to 39.
p_40_44 Integer number. Persons aged 40 to 44.
p_45_49 Integer number. Persons aged 45 to 49.
p_50_54 Integer number. Persons aged 50 to 54.
p_55_59 Integer number. Persons aged 55 to 59.
p_60_64 Integer number. Persons aged 60 to 64.
p_65_69 Integer number. Persons aged 65 to 69.
p_70_74 Integer number. Persons aged 70 to 74.
p_75_79 Integer number. Persons aged 75 to 79.
p_80_84 Integer number. Persons aged 80 to 84.
p_85_up Integer number. Persons aged 85 and over.
p_0_14 Integer number. Persons aged 0 to 14 [derived].
p_15_64 Integer number. Persons aged 15 to 64 [derived].
p_65_up Integer number. Persons aged 65 and over [derived].
p_75_up Integer number. Persons aged 75 and over to match the top age band in earlier years. [derived].
notes Text string (max.len.=4004). Notes.
rec_num Integer number. Unique number identifying row in table.