Vision of Britain | GBHDB | Table: age

GB Historical DB

Age/sex structure data from the Census of Population redistricted to 2011 Local Authority Districts

Table ID:: AGE_REDISTRICTED (1246580)
Contents:: Age/sex structure data from the Census of Population redistricted to 2011 Local Authority Districts
Approx. number of rows:: 8,138
Table type:: Raw Data
Documentation Author:: Humphrey Southall
Chronology:: The data cover the period 1801 to 2011.
Dates and times are identified by:
Year

Sources:

This table was generated from data from various years held in the tables 'age_reg_ew, 'age_lgd_ew' and age_dist_s, plus data taken directly from the 2011 census.
The table currently covers England and Wales for 1851, 1861, 1881, 1891, 1911, 1921, 1931, 1951, 1961, 1971, 1991 and 2011, and Scotland for 1931, 1951, 1971, 1991 and 2011. Data on the individual years under 5 are not available for Scotland, or for England and Wales in 1991 and 2011.

Checking:

Derived data: the scripts used to generate these data have been checked carefully.

Indices:

Index	Type	Column(s) indexed
age_redistricted_pkey	Primary key	year, g_unit

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
age_redistricted_pkey	Primary Key	See details above for primary key index
age_redistricted_area_type_check	Check	((((area_type)::text = 'COUNTRY'::text) OR ((area_type)::text = 'DISTRICT'::text) OR ((area_type)::text = 'GOR'::text) OR ((area_type)::text = 'MOD_REG'::text) OR ((area_type)::text = 'MOD_CNTY'::text) OR ((area_type)::text = 'NATION'::text)))
age_redistricted_nat_source_check	Check	((((nat_source)::text = 'Reported_total'::text) OR ((nat_source)::text = 'Sum_of_redist'::text) OR ((nat_source)::text = 'Sum_of_raw_Par'::text) OR ((nat_source)::text = 'Sum_of_raw_Ward'::text) OR ((nat_source)::text = 'Sum_of_EW_and_Scot'::text)))

Columns within table:

Column	Type	Contents
g_unit	Integer number.	Unique ID number for local government district unit.
area_code	Text string (max.len.=18).	Alphanumeric ID for district as used by the census offices.
area_name	Text string (max.len.=40).	Name of the district or region.
area_type	Text string (max.len.=16).	This column identifies the geographical level: DISTRICT, i.e. an individual local authority. MOD_CNTY, i.e. an English county. GOR, i.e. computed total for a Government Office Region (or Wales). NATIONAL, i.e. an overall total for England and Wales, Scotland or Great Britain. The nat_source column records how such totals were obtained.
nation	Text string (max.len.=6).	One or two-letter code identifying the part of the UK.
nat_source	Text string (max.len.=28).	Appears only for rows which are national totals, and then identifies how it was derived. This will ideally be "Reported_total".
geogcode_1991	Text string (max.len.=13).	This column holds the census office identifier for the district as used in 1991, but only if we know the district had the same boundaries in 1991 and 2011. This is currently set only for the London Boroughs.
year	Integer number.	Year in which census was taken.
area_h	Floating point number.	Area of the unit in hectares. NB this is inserted into rows for all years, but is always the area as reported by the 2011 census, as listed in our tables lau_2011_ew and lau_2011_s.
tot_pop	Floating point number.	Total population.
tot_male	Floating point number.	Total male population.
m_0	Floating point number.	Males aged under 1.
m_1	Floating point number.	Males aged between 1 and 2.
m_2	Floating point number.	Males aged between 2 and 3.
m_3	Floating point number.	Males aged between 3 and 4.
m_4	Floating point number.	Males aged between 4 and 5.
m_0_4	Floating point number.	Males aged 0 to 4.
m_5_9	Floating point number.	Males aged 5 to 9.
m_10_14	Floating point number.	Males aged 10 to 14.
m_15_19	Floating point number.	Males aged 15 to 19.
m_20_24	Floating point number.	Males aged 20 to 24.
m_25_29	Floating point number.	Males aged 25 to 29.
m_30_34	Floating point number.	Males aged 30 to 34.
m_35_39	Floating point number.	Males aged 35 to 39.
m_40_44	Floating point number.	Males aged 40 to 44.
m_45_49	Floating point number.	Males aged 45 to 49.
m_50_54	Floating point number.	Males aged 50 to 54.
m_55_59	Floating point number.	Males aged 55 to 59.
m_60_64	Floating point number.	Males aged 60 to 64.
m_65_69	Floating point number.	Males aged 65 to 69.
m_70_74	Floating point number.	Males aged 70 to 74.
m_75_79	Floating point number.	Males aged 75 to 79.
m_80_84	Floating point number.	Males aged 80 to 84.
m_85_up	Floating point number.	Males aged 85 and over.
m_0_14	Floating point number.	Derived value: Summed males aged 0 to 14.
m_15_64	Floating point number.	Derived value: Summed males aged 15 to 64.
m_65_up	Floating point number.	Derived value: Summed males aged 65 and over.
tot_fem	Floating point number.	Total female population.
f_0	Floating point number.	Females aged under 1.
f_1	Floating point number.	Females aged between 1 and 2.
f_2	Floating point number.	Females aged between 2 and 3.
f_3	Floating point number.	Females aged between 3 and 4.
f_4	Floating point number.	Females aged between 4 and 5.
f_0_4	Floating point number.	Females aged 0 to 4.
f_5_9	Floating point number.	Females aged 5 to 9.
f_10_14	Floating point number.	Females aged 10 to 14.
f_15_19	Floating point number.	Females aged 15 to 19.
f_20_24	Floating point number.	Females aged 20 to 24.
f_25_29	Floating point number.	Females aged 25 to 29.
f_30_34	Floating point number.	Females aged 30 to 34.
f_35_39	Floating point number.	Females aged 35 to 39.
f_40_44	Floating point number.	Females aged 40 to 44.
f_45_49	Floating point number.	Females aged 45 to 49.
f_50_54	Floating point number.	Females aged 50 to 54.
f_55_59	Floating point number.	Females aged 55 to 59.
f_60_64	Floating point number.	Females aged 60 to 64.
f_65_69	Floating point number.	Females aged 65 to 69.
f_70_74	Floating point number.	Females aged 70 to 74.
f_75_79	Floating point number.	Females aged 75 to 79.
f_80_84	Floating point number.	Females aged 80 to 84.
f_85_up	Floating point number.	Females aged 85 and over.
f_0_14	Floating point number.	Derived value: Summed females aged 0 to 14.
f_15_64	Floating point number.	Derived value: Summed females aged 15 to 64.
f_65_up	Floating point number.	Derived value: Summed females aged 65 and over.
f_fertile	Floating point number.	Derived value: Summed females aged 20 to 49.
g_data_status	Text string (max.len.=6).	Flag indicating access status. Current set to P for Public for all rows.
g_data_precision	Text string (max.len.=8).	Flag indicating basis for calculation. Currently GBR for all rows except 2011 and those 1991 rows for which geogcode_1991 is not null.
rec_num	Integer number.	Sequence number created as rows were inserted into the table.