GB Historical DB

Age-Sex structure (quinquennial bands) for Registration sub-Districts

Table ID:
AGE_SUB_EW     (1246661)
Contents:
Age-Sex structure (quinquennial bands) for Registration sub-Districts
Approx. number of rows:
8,754
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   Registration County
   Registration District
   Registration District Number
   Suffix to Registration District Number
   Registration County Number
   Registration sub-District
   Registration sub-District Number
Chronology:
The data cover the period 1851 to 1881.
Dates and times are identified by:
   Year

Sources:

  1. 1851 data transcribed from Census of Great Britain, 1851: Population Tables: Ages, Civil Condition, Occupations and Birth-Place of the People, Volume I and 2, 'Ages of Males and Females enumerated March 31st, 1851 - In Sub-Districts'.
  2. 1861 data transcribed from Census of England and Wales for the year 1861. Tables of I.- Areas, Houses, and Population; and II. Ages, Civil condition, Occupations, and Birth-Places of the People with the Numbers and ages of the blind, the deaf-and-dumb, and the inmates of workhouses, etc., Table 3, 'Ages of Males and Females in Sub-Districts'.
  3. 1871 data were digitised from Census of England and Wales - 1861 Table 3 - Ages of Males and Females in Registrars Sub-Districts.
  4. 1881: Table 3, 'Ages of Males and Females in Registration Sub-Districts' in each of the sets of divisional tables in Volume III of the 1881 Census Report, Ages, Condition as to Marriage, Occupations, and Birth Places of the People, BPP 1883 LXXX [C.3722].

Notes:

  1. The 1881 data were transcribed by Eileen Longland at QMW in November 1997. The data for 1851, 1861 and 1871 were transcribed by the Centre for Data Digitisation and Analysis at Queen's University, Belfast.
  2. This transcription covers England and Wales only.

Checking:

  1. The data have been checked to ensure that computed totals for males and females in each sub-District match those given in the report. NB three rows currently fail this requirement, all for females in 1871:
    • For Burton-upon-Trent sub-District within Burton-upon-Trent District, the listed total of females is 12,729 but the categories sum to 12,728.
    • For Horncastle sub-District within Horncastle District, the listed total of females is 4,628 but the categories sum to 4,627.
    • For Dukinfield sub-District within Ashton-Under-Lyne District, the listed total of females is 14,145 but the categories sum to 14,125.
  2. The geographical units have been cross-checked against the GBHGIS administrative unit gazetteer (auo) to ensure that all units are correctly identified. Each unit in this table has a unique unit ID assigned to it and this ID can be used to cross-reference against other datasets.

Indices:

IndexTypeColumn(s) indexed
age_sub_ew_cnty_ix Unique reg_cnty, rec_num
age_sub_ew_dist_idx Unique reg_cnty_unit, reg_dist, rec_num
age_sub_ew_idx Unique year, sub_dist, reg_dist, reg_cnty
age_sub_ew_subd_idx Unique reg_dist_unit, sub_dist, rec_num

Columns within table:

ColumnTypeContents
year Integer number. Year in which census was taken.
cnty_name Text string (max.len.=39). Name of Registration County in table in which the sub-District was located
dist_name Text string (max.len.=84). Name of Registration District in table.
subd_name Text string (max.len.=64). Name of Registration sub-District in table.
regc_num Integer number. Number identifying each Registration County, and placing it in order. Not populated for 1881 and London does not have numbers in any year.
reg_cnty Text string (max.len.=39). Standardised name of Registration County
reg_num Integer number. Number identifying each Registration District, and placing it in order
reg_sfx Text string (max.len.=8). Suffix to identifying number; handles numbers such as '431A'.
reg_dist Text string (max.len.=84). Standardised name of Registration District.
sub_num Integer number. Sequence number placing each sub-District in order within a given Registration District.
sub_dist Text string (max.len.=64). Standardised name of Registration sub-District.
reg_cnty_unit Integer number. ID number for the Registration County containing the sub-District, as defined in the AUO.
reg_dist_unit Integer number. ID number for the Registration District containing the sub-District, as defined in the AUO.
g_unit Integer number. ID number for the sub-District itself, as defined in the AUO.
tot_pop Integer number. Total population.
tot_male Integer number. Total male population.
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_90_94 Integer number. Males aged 90 to 94.
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_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_90_94 Integer number. Females aged 90 to 94.
f_95_99 Integer number. Females aged 95 to 99.
f_100_up Integer number. Females aged 100 and over.
m_95_up Integer number. Males aged 95 and over; Calculated for better comparability with C20 data [derived].
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_95_up Integer number. Females aged 95 and over; Calculated for better comparability with C20 data [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].
notes Long text. Notes.
rec_num Integer number. Sequence number added on loading, to keep the rows in order.