Vision of Britain | GBHDB | Table: age_2011

GB Historical DB

Age structure data for Local Authorities in England and Wales in 2011.

Table ID:: AGE_2011_EW (1246548)
Contents:: Age structure data for Local Authorities in England and Wales in 2011.
Approx. number of rows:: 348
Table type:: Raw Data
Documentation Author:: Paula Aucott
Geography:: Reporting units are identified by:
Local Government District Type
Chronology:: The data are for the single year 2011.

Sources:

These data were obtained from table "QS103EW - Age by Single Year" for Local Authorities from the 2011 Census of Population. The data was downloaded on 22nd October 2015 in spreadsheet format from the Census part of the Topics section on the Neighbourhood Statistics website operated by the Office for National Statistics. The data are under Crown Copyright, but are made available for use under an Open Government Licence.

Notes:

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."

Checking:

The statistical data have not been checked
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.

Indices:

Index	Type	Column(s) indexed
age_2011_ew_pkey	Primary key	rec_num
age_2011_ew_g_unit_idx	Unique	g_unit, rec_num
age_2011_ew_lau_idx	Unique	g_name, lg_type, rec_num

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
age_2011_ew_pkey	Primary Key	See details above for primary key index

Columns within table:

Column	Type	Contents
lau_code	Text string (max.len.=24).	ONS Code for the Local Authority as it appeared in the original table.
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 Local Government District.
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).
tot_pop	Integer number.	Total population.
p_0	Integer number.	Persons aged under 1.
p_1	Integer number.	Persons aged 1.
p_2	Integer number.	Persons aged 2.
p_3	Integer number.	Persons aged 3.
p_4	Integer number.	Persons aged 4.
p_5	Integer number.	Persons aged 5.
p_6	Integer number.	Persons aged 6.
p_7	Integer number.	Persons aged 7.
p_8	Integer number.	Persons aged 8.
p_9	Integer number.	Persons aged 9.
p_10	Integer number.	Persons aged 10.
p_11	Integer number.	Persons aged 11.
p_12	Integer number.	Persons aged 12.
p_13	Integer number.	Persons aged 13.
p_14	Integer number.	Persons aged 14.
p_15	Integer number.	Persons aged 15.
p_16	Integer number.	Persons aged 16.
p_17	Integer number.	Persons aged 17.
p_18	Integer number.	Persons aged 18.
p_19	Integer number.	Persons aged 19.
p_20	Integer number.	Persons aged 20.
p_21	Integer number.	Persons aged 21.
p_22	Integer number.	Persons aged 22.
p_23	Integer number.	Persons aged 23.
p_24	Integer number.	Persons aged 24.
p_25	Integer number.	Persons aged 25.
p_26	Integer number.	Persons aged 26.
p_27	Integer number.	Persons aged 27.
p_28	Integer number.	Persons aged 28.
p_29	Integer number.	Persons aged 29.
p_30	Integer number.	Persons aged 30.
p_31	Integer number.	Persons aged 31.
p_32	Integer number.	Persons aged 32.
p_33	Integer number.	Persons aged 33.
p_34	Integer number.	Persons aged 34.
p_35	Integer number.	Persons aged 35.
p_36	Integer number.	Persons aged 36.
p_37	Integer number.	Persons aged 37.
p_38	Integer number.	Persons aged 38.
p_39	Integer number.	Persons aged 39.
p_40	Integer number.	Persons aged 40.
p_41	Integer number.	Persons aged 41.
p_42	Integer number.	Persons aged 42.
p_43	Integer number.	Persons aged 43.
p_44	Integer number.	Persons aged 44.
p_45	Integer number.	Persons aged 45.
p_46	Integer number.	Persons aged 46.
p_47	Integer number.	Persons aged 47.
p_48	Integer number.	Persons aged 48.
p_49	Integer number.	Persons aged 49.
p_50	Integer number.	Persons aged 50.
p_51	Integer number.	Persons aged 51.
p_52	Integer number.	Persons aged 52.
p_53	Integer number.	Persons aged 53.
p_54	Integer number.	Persons aged 54.
p_55	Integer number.	Persons aged 55.
p_56	Integer number.	Persons aged 56.
p_57	Integer number.	Persons aged 57.
p_58	Integer number.	Persons aged 58.
p_59	Integer number.	Persons aged 59.
p_60	Integer number.	Persons aged 60.
p_61	Integer number.	Persons aged 61.
p_62	Integer number.	Persons aged 62.
p_63	Integer number.	Persons aged 63.
p_64	Integer number.	Persons aged 64.
p_65	Integer number.	Persons aged 65.
p_66	Integer number.	Persons aged 66.
p_67	Integer number.	Persons aged 67.
p_68	Integer number.	Persons aged 68.
p_69	Integer number.	Persons aged 69.
p_70	Integer number.	Persons aged 70.
p_71	Integer number.	Persons aged 71.
p_72	Integer number.	Persons aged 72.
p_73	Integer number.	Persons aged 73.
p_74	Integer number.	Persons aged 74.
p_75	Integer number.	Persons aged 75.
p_76	Integer number.	Persons aged 76.
p_77	Integer number.	Persons aged 77.
p_78	Integer number.	Persons aged 78.
p_79	Integer number.	Persons aged 79.
p_80	Integer number.	Persons aged 80.
p_81	Integer number.	Persons aged 81.
p_82	Integer number.	Persons aged 82.
p_83	Integer number.	Persons aged 83.
p_84	Integer number.	Persons aged 84.
p_85	Integer number.	Persons aged 85.
p_86	Integer number.	Persons aged 86.
p_87	Integer number.	Persons aged 87.
p_88	Integer number.	Persons aged 88.
p_89	Integer number.	Persons aged 89.
p_90	Integer number.	Persons aged 90.
p_91	Integer number.	Persons aged 91.
p_92	Integer number.	Persons aged 92.
p_93	Integer number.	Persons aged 93.
p_94	Integer number.	Persons aged 94.
p_95	Integer number.	Persons aged 95.
p_96	Integer number.	Persons aged 96.
p_97	Integer number.	Persons aged 97.
p_98	Integer number.	Persons aged 98.
p_99	Integer number.	Persons aged 99.
p_100_up	Integer number.	Persons aged 100 and over.
p_0_4	Integer number.	Persons aged 0 to 4 [derived].
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].
p_85_up	Integer number.	Persons aged 85 and over to match the top age band in earlier years. [derived].
p_95_up	Integer number.	Persons aged 95 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.