Age Structure (quinquennial bands) for Urban and Rural Sanitary Districts

Table ID:
AGE_SAN_EW     (6561956)
Contents:
Age Structure (quinquennial bands) for Urban and Rural Sanitary Districts
Approx. number of rows:
1,635
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   Census Division
   Registration County
   Sanitary District
   Type of Sanitary District
Chronology:
The data cover the period 1881 to 1911.
Dates and times are identified by:
   Year

Sources:

  1. 1891: Table 3, 'Ages of Males and females in Sanitary Areas'. A separate table was published for each of the 11 census divisions of England, and this transcription includes all data from each of these with the exception of the totals given for each division. These data were digitised by the Centre for Data Digitisation and Analysis, The Queen's University of Belfast.


Notes:

  1. This table currently holds data only for 1891, but the 1881 census also published age structure data for Sanitary Districts, in Table 6 of Vol. III, Age, Marriage, Occupation, Birth-place. Prior to this, similar data was published for Registration sub-Districts.
  2. The following districts were divided between two different Census Divisions, and consequently have two separate rows in the data:
    • Bristol USD: divided between West Midland and South Western.
    • Lewisham London Sanitary District: the Civil Parish of Penge was in the South Eastern Division, and the remainder in London.
    • Mossley USD: divided between North Western and Yorkshire.
    • Oxford USD: divided between South Eastern and South Midland.
    • Stockton on Tees USD: divided between Northern and Yorkshire.
    • Todmorden USD: divided between North Western and Yorkshire.
    Because of these rows, the data must be grouped by g_unit to extract overall figures for whole Districts.


Checking:

  1. The numeric data was verified for males and for females for each case by summing each 5 year age grouping and comparing the sum with total males or total females as recorded in the original table. The yearly age group data for male and female children under 5 was similarly verified for each case by summing these 5 fields and comparing them with a separate field giving the total males or females aged under 5 years.
  2. One row fails the above checks, and explains why there is not a check constraint on the main set of mail categories: the listed total male population of Mottram in Longdendale USD in the North Western Division was 1,530, but the individual categories sum only to 1,529.


Indices:

IndexTypeColumn(s) indexed
age_san_ew_pkey Primary key year, g_unit, cen_div


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
age_san_ew_pkey Primary Key See details above for primary key index
check_fem 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_89) + f_90_94) + f_95_99) + f_100_up))
check_fem_u5 Check (f_0_4 = ((((f_0 + f_1) + f_2) + f_3) + f_4))
check_male_u5 Check (m_0_4 = ((((m_0 + m_1) + m_2) + m_3) + m_4))



Columns within table:

ColumnTypeContents
year Integer number. Year in which census was taken. This is currently always 1891.
cen_div Text string (max.len.=64). Name of Census Division in which the Sanitary District was located.
reg_cnty Text string (max.len.=28). Name of the Registration County containing the District. NB this information was added by Humphrey Southall in December 2003 to assist in cross-checking the data against the age_reg table, and was done mainly from the par_1891 table.
san_dist Text string (max.len.=84). Name of the Sanitary District.
san_type Text string (max.len.=14). Type of Sanitary District: 'USD'= Urban, 'RSD'= Rural, 'Lon_SDist' = London (sanitary) District.
part_of Text string (max.len.=8). Flag field, containing 'P' when the district had parts listed in two separate Divisions, and null otherwise.
div_unit Integer number. ID number of the Census Division containing the district, as defined in the AUO.
g_unit Integer number. ID number for the district as defined in the AUO. NB these values are not unique, as where a district was split between Divisions there will be two separate rows in the table. See note above.
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 1 to 2.
m_2 Integer number. Males aged 2 to 3.
m_3 Integer number. Males aged 3 to 4.
m_4 Integer number. Males aged 4 to 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_90_94 Integer number. Males aged 90 to 94.
m_95_up Integer number. Males aged 95 and over; this is a derived value, included for better comparability with C20 data.
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 1 to 2.
f_2 Integer number. Females aged 2 to 3.
f_3 Integer number. Females aged 3 to 4.
f_4 Integer number. Females aged 4 to 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_90_94 Integer number. Females aged 90 to 94.
f_95_up Integer number. Females aged 95 and over; this is a derived value, included for better comparability with C20 data.
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].
notes Text string (max.len.=2004). Notes, giving details of Districts divided between Divisions.
rec_num Integer number. Sequence number preserving original order of the data.