GB Historical DB

Age/sex structure data for Local Government Districts 1911-71.

Table ID:
AGE_LGD_EW     (1246561)
Contents:
Age/sex structure data for Local Government Districts 1911-71.
Approx. number of rows:
9,777
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   Administrative County
   Local Government District
   Local Government District Type
Chronology:
The data cover the period 1911 to 1971.
Dates and times are identified by:
   Year

Sources:

  1. 1911: All LGDs in England and Wales (1,841 records in all). These data were transcribed from table 8, "Ages of Persons, Males and Females at each year of age under 21 and in Quninquennial Age-Groups in each Administrative County (inclusive and exclusive of County Boroughs), of County Boroughs, and of Rural Districts. Also Ages of Males and Females in each County Borough, Municipal Borough, other Urban District and Rural District, 1911", pp.15-201(??) in Volume VII of the 1911 Census Report, Ages and Condition as to Marriage, BPP ?? [Cd.6610]. National totals added from Table 29, 'England and Wales. Condition as to marriage of persons, males and females, at each year of age and in quinquennial age groups, 1911', in Summary tables, England and Wales, 1911.
  2. 1921: All LGDs in England and Wales (1,827 records in all). These data were transcribed from table 14 and 14A, "Ages (Quinquennial groups) and marital condition" in each of the county reports of the 1921 Census. NB table 14A, covering smaller towns and rural districts, gives less detailed data on marital status than does table 14 for the larger towns, but our transcription ignores this data on marital status hence identical information was taken from both 14 and 14A. Funding for this work was provided by the Population Investigation Committee. National totals added from Table 32, 'Ages (Individual Years) and Marital Conditions' (individual years under 5), and Table 33, 'Ages (Quinquennial Groups) and Marital Conditions' (all other data) in General tables, England and Wales, 1921.
  3. 1931: All LGDs in England and Wales (1,800 records in all). These data were transcribed from table 14 and 15, "Ages (Grouped) by marital condition" in each of the county reports of the 1931 Census. NB table 15, covering smaller towns and rural districts, gives less detailed data on marital status than does table 14 for the larger towns, but our transcription ignores this data on marital status hence identical information was taken from both 14 and 15. Funding for this work was provided by the Population Investigation Committee. National totals added from Table 17, 'Ages (Individual Years)', pp.125-6 in General tables, England and Wales, 1931.
  4. 1951: All LGDs in England and Wales (1,470 records in all). These data were transcribed from table 21, "Ages (quinary) by Marital Condition", for Administrative Counties, County Boroughs and Urban Areas with 50,000 population or more, and from table 22, "Ages (quinary) and Marital Condition", for urban centres of less than 50,000 and Rural Districts, in each of the county reports of the 1951 Census. Funding for this work was provided by the JISC 'Knowledge Gallery' initiative. National totals added from Table 17, 'Age (individual years) by marital condition', pp.60-1 in Census 1951 England and Wales: General Tables.
  5. 1961: All LGDs in England and Wales (1,467 records in all). These data were transcribed from Table 6, "Age and Marital Condition -- Local Authority Areas, Conurbation Centres" in each of the county reports of the 1961 Census. The data were transcribed by Eileen Longland at QMW in March 1998 using funding from the JISC 'Knowledge Gallery' initiative. National totals added from Table 8, 'Age (single years) and marital condition', pp.27-29 in Census 1961 England and Wales: Age, Marital condition and General Tables
  6. 1971: All LGDs in England and Wales (1,366 records in all). The data for were input from table 8, 'Population by sex, age and marital condition' for 'County, local authority areas, conurbation centres' in the County Reports of the 1971 census. National totals added from Table 9, 'Population by sex, age (single years) and marital condition', pp.28-9 in Census 1971 Great Britain: Age, Marital Condition and General Tables:

Notes:

  1. The 1971 data for the West Riding were manually input by Paula Aucott in Portsmouth, December 2000, because the estimates created using Danny Dorling's data were particularly problematic for that county: one district was completely missing and another had its total population wrong by 500%. The remainder of the table was input by Harold Price in Portsmouth in April 2017.
  2. Originally 1971 data except for the West Riding were estimated from data held in 'age_wards_1971' and 'pop_lgd_1971'. The former was the main source, but the totals for persons, men and women were taken from the latter, and all figures for individual age groups scaled to reflect any difference between the enumerated numbers of men or women given in 'pop_lgd_1971_ew' and the computed total for the gender in 'age_wards'. In general the two totals are very similar but there are differences to these totals. This 1971 data grouped into 1981 wards was supplied by Danny Dorling and is held in 'age_wards_1971'. The data in 'age_wards_1971' is no longer used to build this table.
  3. National totals for England and Wales combined were added to this table in 2017. They can be identified as (a) lg_type = 'NAT' and (b) cnty_name is null.
  4. Local Government District types used in this table are:
    • NAT = National
    • LCC = London City Corporate
    • MetB = Metropolitan Boroughs
    • LB = London Boroughs
    • CB = County Boroughs
    • MB = Municipal Boroughs
    • UD = Urban Districts
    • RD = Rural Districts

Checking:

  1. The data have been checked to confirm that the totals for men and for women equal the sum of the respective age categories; see constraints below. This check could not be applied to the 1971 data as they have been rounded to the nearest five to preserve confidentiality.
  2. Known problem: the reported total female population of Ryton UD, Durham in 1951 differs from the computed total by 1.
  3. For each year which has national totals, the sum of tot_pop for all rows where g_unit is not null and lg_type is not 'NAT' has been computed, and confirmed to exactly match the value of tot_pop where lg_type = 'NAT'. THIS IS CURRENTLY NOT TRUE OF 1971.
  4. 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:

IndexTypeColumn(s) indexed
age_lgd__ew_dist_idx Unique adm_cnty, dist_name, lg_type, year, rec_num
age_lgd_ew_cnty_idx Unique adm_cnty, year, rec_num
age_lgd_ew_g_unit_idx Unique g_unit, rec_num

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ck_age_lgd_ew_f_tot Check ((((tot_fem - (((((((((((((((((f_0_4 + f_5_9) + f_10_14) + f_15_19) + f_20_24) + f_25_29) + f_30_34) + f_35_39) + f_40_44) + f_45_49) + f_50_54) + f_55_59) + f_60_64) + f_65_69) + f_70_74) + f_75_79) + f_80_84) + f_85_up)) * correct) = 0))
ck_age_lgd_ew_f_u5 Check ((((((f_0 + f_1) + f_2) + f_3) + f_4) = f_0_4))
ck_age_lgd_ew_m_tot Check ((((tot_male - (((((((((((((((((m_0_4 + m_5_9) + m_10_14) + m_15_19) + m_20_24) + m_25_29) + m_30_34) + m_35_39) + m_40_44) + m_45_49) + m_50_54) + m_55_59) + m_60_64) + m_65_69) + m_70_74) + m_75_79) + m_80_84) + m_85_up)) * correct) = 0))
ck_age_lgd_ew_m_u5 Check ((((((m_0 + m_1) + m_2) + m_3) + m_4) = m_0_4))


Columns within table:

ColumnTypeContents
year Integer number. Year in which census was taken.
cnty_name Text string (max.len.=44). Name of Administrative County unit as it appeared in the original report.
adm_cnty Text string (max.len.=44). Standardised name of Administrative county.
dist_name Text string (max.len.=64). Name of Local Government District unit as it appeared in the original report.
lg_dist Text string (max.len.=64). Standardised name of local government district.
lg_type Text string (max.len.=16). Type of Local Government District.
adm_cnty_unit Integer number. Unique ID number for county unit.
g_unit Integer number. Unique ID number for local government district unit.
part_of Text string (max.len.=5). A 'P' in this column indicates that data for only part of the place is recorded. It may be that another part is recorded in a different county.
tot_pop Integer number. Total population.
tot_male Integer number. Total male population.
m_0 Integer number. Males aged under 1.
m_1 Integer number. Males aged between 1 and 2.
m_2 Integer number. Males aged between 2 and 3.
m_3 Integer number. Males aged between 3 and 4.
m_4 Integer number. Males aged between 4 and 5.
m_0_4 Integer number. Males aged 0 to 4.
m_5_9 Integer number. Males aged 5 to 9.
m_10_14 Integer number. Males aged 10 to 14.
m_15_19 Integer number. Males aged 15 to 19.
m_20_24 Integer number. Males aged 20 to 24.
m_25_29 Integer number. Males aged 25 to 29.
m_30_34 Integer number. Males aged 30 to 34.
m_35_39 Integer number. Males aged 35 to 39.
m_40_44 Integer number. Males aged 40 to 44.
m_45_49 Integer number. Males aged 45 to 49.
m_50_54 Integer number. Males aged 50 to 54.
m_55_59 Integer number. Males aged 55 to 59.
m_60_64 Integer number. Males aged 60 to 64.
m_65_69 Integer number. Males aged 65 to 69.
m_70_74 Integer number. Males aged 70 to 74.
m_75_79 Integer number. Males aged 75 to 79.
m_80_84 Integer number. Males aged 80 to 84.
m_85_89 Integer number. Males aged 85 to 89.
m_85_up Integer number. Males aged 85 and over. This is the top age band for 1971; for earlier years it is derived.
m_90_94 Integer number. Males aged 90 to 94.
m_95_up Integer number. Males aged 95 and over.
m_95_99 Integer number. Males aged 95 to 99.
m_100_up Integer number. Males aged 100 and over.
tot_fem Integer number. Total female population.
f_0 Integer number. Females aged under 1.
f_1 Integer number. Females aged between 1 and 2.
f_2 Integer number. Females aged between 2 and 3.
f_3 Integer number. Females aged between 3 and 4.
f_4 Integer number. Females aged between 4 and 5.
f_0_4 Integer number. Females aged 0 to 4.
f_5_9 Integer number. Females aged 5 to 9.
f_10_14 Integer number. Females aged 10 to 14.
f_15_19 Integer number. Females aged 15 to 19.
f_20_24 Integer number. Females aged 20 to 24.
f_25_29 Integer number. Females aged 25 to 29.
f_30_34 Integer number. Females aged 30 to 34.
f_35_39 Integer number. Females aged 35 to 39.
f_40_44 Integer number. Females aged 40 to 44.
f_45_49 Integer number. Females aged 45 to 49.
f_50_54 Integer number. Females aged 50 to 54.
f_55_59 Integer number. Females aged 55 to 59.
f_60_64 Integer number. Females aged 60 to 64.
f_65_69 Integer number. Females aged 65 to 69.
f_70_74 Integer number. Females aged 70 to 74.
f_75_79 Integer number. Females aged 75 to 79.
f_80_84 Integer number. Females aged 80 to 84.
f_85_89 Integer number. Females aged 85 to 89.
f_85_up Integer number. Females aged 85 and over. This is the top age band for 1971; for earlier years it is derived.
f_90_94 Integer number. Females aged 90 to 94.
f_95_up Integer number. Females aged 95 and over.
f_95_99 Integer number. Females aged 95 to 99.
f_100_up Integer number. Females aged 100 and over.
m_0_14 Integer number. Males aged 0 to 14 [derived].
m_15_64 Integer number. Males aged 15 to 64 [derived].
m_65_up Integer number. Males aged 65 and over [derived].
f_0_14 Integer number. Females aged 0 to 14 [derived].
f_15_64 Integer number. Females aged 15 to 64 [derived].
f_65_up Integer number. Females aged 65 and over [derived].
correct Integer number. Flag field supporting check constraints: Set equal to 0 if there is an uncorrectable error, and to 1 otherwise.
notes Text string (max.len.=4004). Notes.
rec_num Integer number. Unique number identifying row in table.