Vision of Britain | GBHDB | Table: mort_age_ew_lgd

GB Historical DB

Age-specific mortality by decade for Local Govt. Dists. in England and Wales

Table ID:: MORT_AGE_EW_LGD_DEC (1251668)
Contents:: Age-specific mortality by decade for Local Govt. Dists. in England and Wales
Approx. number of rows:: 469
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 1930.
Dates and times are identified by:
Decade

Sources:

Data for 1911-20 come from the Registrar General's Decennial Supplement 1911-1920, Part III: Tables: Estimated Population, Births, Deaths and Marriages (London: HMSO, 1933), Table 24, "Deaths in the Decennium 1911-1920, by Sex and Age (Civilians only 1915-1920)", for "England and Wales, Classes of Area -- Metropolitan Boroughs, County Boroughs, and Aggregates of Urban and Rural Districts in Administrative Counties" (pp. 299-320). NB this table also include a break down of deaths in the first year of life into "under 1 month", "1-3 months", "3-6 months", "6-12 months", which has not been input.
The data for 1921-30 come from the Registrar General's Decennial Supplement. England and Wales 1931. Part III: Estimates of Population, Statistics of Marriage, Births and Deaths 1921-30 (London: HMSO, 1952), Table 25, "Deaths, Death Rates and Infant Mortality (All Causes) in the Decennium 1921-30, by Sex and Age", for "England and Wales, Geographical Divisions; London, Each Metropolitan and County Borough; County Aggregates of Urban and of Rural Districts" (pp. 344-65). This table does not include figures for the number of deaths in individual years under 5.

Notes:

This table covers London Boroughs, County Boroughs, the aggregate of all other urban districts in each county (i.e. Municipal Boroughs and Urban Districts), and the aggregate of all Rural Districts in each county.
This table was renamed from 'mort_age_lgd' to 'mort_age_ew_lgd_dec' in December 2020 to more accurately describe the contents.

Checking:

That, for each sex, the number of deaths in each age group sum to the stated total.
The counties, County Boroughs and Metropolitan Boroughs have been matched to the AUO. The county aggregates for Rural Districts and for other urban units have not been matched because these entities are not defined in the AUO.
The County and Metropolitan Boroughs have been checked against the GIS coverages, comparing the 1910s with the 1921 LGD polygons and the 1920s with 1931. The only discrepancies are (i) the 1910s include data for Devonport CB, missing from the polygons as it was merged with Plymouth in 1914; and (ii) the 1920s include data for the Inner and Middles Temples within London, which lack a polygon in the GIS.

Indices:

Index	Type	Column(s) indexed
mort_age_ew_lgd_dec_pkey	Primary key	rec_num
mort_age_ew_lgd_dec_idx	Unique	lg_dist, lg_type, adm_cnty, decade

Constraints:

The table has the following associated constraints:

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

Columns within table:

Column	Type	Contents
decade	Integer number.	Inter-censal period, for example 1911-20='1910'.
lg_dist	Text string (max.len.=44).	Name of Local Government District to which data relate. Where the figures are for urban or rural district aggregates, this is set equal to the county name.
lg_type	Text string (max.len.=8).	Type of Local Government District to which data relate. NB these codes include 'UDA' for aggregate of all other urban units, and 'RDA' for aggregate of all Rural Districts.
adm_cnty	Text string (max.len.=28).	Name of Administrative County in which the district was located.
deaths	Integer number.	Total number of deaths.
m_deaths	Integer number.	Total number of male deaths.
m_0	Integer number.	Deaths of males aged under 1.
m_1	Integer number.	Deaths of males aged 1 and under 2.
m_2	Integer number.	Deaths of males aged 2 and under 3.
m_3	Integer number.	Deaths of males aged 3 and under 4.
m_4	Integer number.	Deaths of males aged 4 and under 5.
m_0_4	Integer number.	Deaths of males aged 0 to 4.
m_5_9	Integer number.	Deaths of males aged 5 to 9.
m_10_14	Integer number.	Deaths of males aged 10 to 14.
m_15_19	Integer number.	Deaths of males aged 15 to 19.
m_20_24	Integer number.	Deaths of males aged 20 to 24.
m_25_29	Integer number.	Deaths of males aged 25 to 29.
m_30_34	Integer number.	Deaths of males aged 30 to 34.
m_35_39	Integer number.	Deaths of males aged 35 to 39.
m_40_44	Integer number.	Deaths of males aged 40 to 44.
m_45_49	Integer number.	Deaths of males aged 45 to 49.
m_50_54	Integer number.	Deaths of males aged 50 to 54.
m_55_59	Integer number.	Deaths of males aged 55 to 59.
m_60_64	Integer number.	Deaths of males aged 60 to 64.
m_65_69	Integer number.	Deaths of males aged 65 to 69.
m_70_74	Integer number.	Deaths of males aged 70 to 74.
m_75_up	Integer number.	Deaths of males aged 75 and upwards.
m_75_79	Integer number.	Deaths of males aged 75 to 79.
m_80_84	Integer number.	Deaths of males aged 80 to 84.
m_85_up	Integer number.	Deaths of males aged 85 and upwards.
f_deaths	Integer number.	Total number of female deaths.
f_0	Integer number.	Deaths of females aged under 1.
f_1	Integer number.	Deaths of females aged 1 and under 2.
f_2	Integer number.	Deaths of females aged 2 and under 3.
f_3	Integer number.	Deaths of females aged 3 and under 4.
f_4	Integer number.	Deaths of females aged 4 and under 5.
f_0_4	Integer number.	Deaths of females aged 0 to 4.
f_5_9	Integer number.	Deaths of females aged 5 to 9.
f_10_14	Integer number.	Deaths of females aged 10 to 14.
f_15_19	Integer number.	Deaths of females aged 15 to 19.
f_20_24	Integer number.	Deaths of females aged 20 to 24.
f_25_29	Integer number.	Deaths of females aged 25 to 29.
f_30_34	Integer number.	Deaths of females aged 30 to 34.
f_35_39	Integer number.	Deaths of females aged 35 to 39.
f_40_44	Integer number.	Deaths of females aged 40 to 44.
f_45_49	Integer number.	Deaths of females aged 45 to 49.
f_50_54	Integer number.	Deaths of females aged 50 to 54.
f_55_59	Integer number.	Deaths of females aged 55 to 59.
f_60_64	Integer number.	Deaths of females aged 60 to 64.
f_65_69	Integer number.	Deaths of females aged 65 to 69.
f_70_74	Integer number.	Deaths of females aged 70 to 74.
f_75_up	Integer number.	Deaths of females aged 75 and upwards.
f_75_79	Integer number.	Deaths of females aged 75 to 79.
f_80_84	Integer number.	Deaths of females aged 80 to 84.
f_85_up	Integer number.	Deaths of females aged 85 and upwards.
im_male	Floating point number.	Male Infant Mortality (NB this label needs to be checked against the source).
im_female	Floating point number.	Female Infant Mortality (NB this label needs to be checked against the source).
im_tot	Floating point number.	Total Infant Mortality (NB this label needs to be checked against the source).
adm_cnty_unit	Integer number.	Unique identifier for the Administrative County, as defined in the GBH GIS Administrative Unit Ontology.
lg_dist_unit	Integer number.	Unique identifier for the Local Government District, as defined in the GBH GIS Administrative Unit Ontology.
rec_num	Integer number.	Unique number identifying row in table.