Annual age-specific cause of death for England and Wales 1921-71
- Table ID:
- CAUSE_AGE_EW_LGD
(1246784)
- Contents:
- Annual age-specific cause of death for England and Wales 1921-71
- Approx. number of rows:
- 71,966
- 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
1921 to 1971.
Dates and times are identified by:
Year
Sources:
- [Details for 1921 to be added]
- [Details for 1931 to be added]
- 1941:
Table 24, "Causes of Death, 1941,
classified in accordance with the Abridged List at Different Periods
of Life", for "England and Wales, Geographical Regions. London and
Metropolitan Boroughs, County Boroughs. Aggregates of other Urban
and Rural Districts in each Administrative County."
"(Non-civilian deaths are excluded)" (pp. 169-260),
in the Registrar General's
Statistical Review of England and Wales for the Year 1941,
Part I, Tables, Medical.
- 1951:
Table 20, "Causes of Death by Sex at Different Periods of Life, 1951,
classified in accordance with the Abridged List" for
"London and Metropolitan Boroughs, County Boroughs, Aggregates
of other Urban and of Rural Districts in each Administrative County" (pp. 238-356),
in the Registrar General's
Statistical Review of England and Wales for the Year 1951,
Part I, Tables, Medical.
NB from 1952 Table 20 was "suspended", although it remains part of the
numbering sequence even in 1973.
- 1961:
Table 19, "Causes of death by sex at different periods of life, 1961
(including, for England and Wales only, crude death rates per million living)."
for "England and Wales, standard regions, Wales, conurbations, urban
and rural aggregates outside conurbations",
"Classified in accordance with the International Abbreviated List
with certain sub-divisions" (pp. 182-229),
in the Registrar General's
Statistical Review of England and Wales for the Year 1961,
Part I, Tables, Medical.
See below for listing of areas covered.
Table 21 in this report provides more geographical detail, including
individual County and Metropolitan Boroughs, but deaths are broken
down only by sex, not age.
- 1971:
Table 19, "Deaths by cause, sex and age-group and Standardised Mortality Ratios, 1971"
for "England and Wales, standard regions, Wales, conurbations, urban and
rural aggregates, hospital regions" (pp. 232-305),
in the Registrar General's
Statistical Review of England and Wales for the Year 1971,
Part I, Tables, Medical.
- All the above data were input by the digitisation team at the Centre for Data
Digitisation and Analysis, at Queen's University, Belfast.
Notes:
- This table is based on a series of large tables in the Registrar-General's
reports for each year.
There is a source table for each reporting area, and each table breaks
down deaths with rows for each combination of cause and gender,
and columns for each age group.
The causes of death are
"Classified in accordance with the International
Abbreviated List with certain sub-divisions".
- Although the structure of the individual source tables is
consistent over the run of years, the set of reporting areas
is not.
Between 1921 and 1951, the data cover all County Boroughs,
all Metropolitan Boroughs in London, and then for each
Administrative County the aggregates of all other urban districts
(i.e. including all Municipal Boroughs as well as Urban Districts),
and the aggregates of all Rural Districts.
For 1961 and 1971, the data cover Regions, Conurbations and
Hospital Regions, as detailed below.
- No attempt has been made to match the 1961 and 1971 data to the AUO.
For 1921 to 1951, with the exception of data for "Greater London" in 1921,
all rows have been matched to a county, and all rows for Metropolitan
or County Boroughs have been assigned a district ID.
This should mean that aggregating the data by adm_cnty_unit should
give correct county totals, but this has not been checked.
- This table was originally called "cod_age_ew_1921_71" but was renamed
in December 2020 to more accurately describe the contents.
Checking:
- [This data has not been fully error checked.
342 numerical errors exist between the overall deaths per cause
per location and the summed total of deaths per age
for that location.]
- When loading the table into Postgres the data for 1971 was
missing a label for the final numeric column, which came after the final column for 1961.
An extra column 'unknownfig' was therefore added as a stop-gap measure.
It is unclear how the columns became misaligned over time.
This needs checking against the original table to determine which
columns these figures should relate to.
Indices:
Index | Type | Column(s) indexed |
cause_age_ew_lgd_pkey |
Primary key |
rec_num |
cause_age_ew_lgd_idx |
Unique |
lg_dist, lg_type, adm_cnty, year, cause, sex |
Constraints:
The table has the following associated constraints:
Constraint | Type | Details |
cause_age_ew_lgd_pkey |
Primary Key |
See details above for primary key index
|
Columns within table:
Column | Type | Contents |
year |
Integer number. |
Year. NB the table currently includes data only for census years.
|
adm_cnty |
Text string (max.len.=34). |
Name of Administrative County in which the district was located.
Null for 1961 and 1971.
|
lg_dist |
Text string (max.len.=64). |
Name of Local Government District to which data relate.
Null for 1961 and 1971.
|
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.
|
region |
Text string (max.len.=84). |
Name of the region, conurbation, hospital region etc.
for 1961 and 1971. See below for actual values appearing here.
|
cause |
Text string (max.len.=104). |
Cause of Death.
|
sex |
Text string (max.len.=6). |
'M' = Male, 'F' = Female.
|
d_all_ages |
Integer number. |
Total deaths due to specified cause for all ages.
|
d_0_4weeks |
Integer number. |
Deaths due to specific cause during first four weeks of life (only in 1951).
|
d_4weeks_1year |
Integer number. |
Deaths due to specific cause between four weeks and one year (only in 1951).
|
d_0 |
Integer number. |
Deaths due to specific cause under one year.
This figure is derived for 1951 by adding together columns A_0_4weeks and A_4weeks_1year.
|
d_1_or_1_4 |
Integer number. |
Deaths due to specific cause aged 1 and under 2 (1921, 1931)
or aged 1 and under 5 (1941, 1951, 1961, 1971).
|
d_2_4 |
Integer number. |
Deaths due to specific cause aged 2 and under 5 (1921, 1931).
|
d_5_14 |
Integer number. |
Deaths due to specific cause aged 5 and under 15.
|
d_15_24_or_15_44 |
Integer number. |
Deaths due to specific cause aged 15 and under 25 (1921, 1931, 1951, 1961, 1971)
or aged 15 and under 45 (1941).
|
d_25_34_or_25_44 |
Integer number. |
Deaths due to specific cause aged 25 and under 35 (1931, 1961, 1971)
or aged 25 and under 45 (1921, 1951).
|
d_35_44 |
Integer number. |
Deaths due to specific cause aged 35 and under 45 (1931, 1961, 1971).
|
d_45_54_or_45_64 |
Integer number. |
Deaths due to specific cause aged 45 and under 55 (1931, 1961, 1971)
or aged 45 and under 65 (1921, 1941, 1951).
|
d_55_64 |
Integer number. |
Deaths due to specific cause aged 55 and under 65 (1931, 1961, 1971).
|
d_65_74_or_65_up |
Integer number. |
Deaths due to specific cause aged 65 and under 75 (1921, 1931, 1951, 1961, 1971)
or aged 65 and over (1941).
|
d_75_up |
Integer number. |
Deaths due to specific cause aged 75 and over (1921, 1931, 1951, 1961, 1971).
|
imr |
Integer number. |
Infant mortality rate: deaths aged under 1 year per thousand live births (1971).
|
unknownfig |
Integer number. |
Unidentified number, only appearing in 1971. Needs checking against the original to identify.
|
adm_cnty_unit |
Integer number. |
ID number for the Administrative County containing the
district or aggregate, as defined in the GBHGIS AUO.
Set only for 1921-51.
|
lg_dist_unit |
Integer number. |
ID number for the local government district, as defined in the GBHGIS AUO.
Set only for County Boroughs and Metropolitan Boroughs in 1921-51.
|
rec_num |
Integer number. |
Unique number identifying row in table.
|
Additional Notes:
The actual reporting areas used post-1951 are as follows:
1961
"England and Wales",
"East and West Ridings Region",
"Eastern Region",
"London and South Eastern Region",
"Midland Region",
"Northern Region",
"North Midland Region",
"North Western Region",
"Southern Region",
"South Western Region",
"Wales I (South East)",
"Wales Ii (Remainder)",
"Conurbations",
"Greater London",
"Merseyside Conurbation",
"South East Lancashire Conurbation",
"Tyneside Conurbation",
"West Midlands Conurbation",
"West Yorkshire Conurbation",
"Urban areas outside Conurbations with populations of 100,000 and over",
"Urban areas outside Conurbations with populations of 50,000 and under 100,000",
"Urban areas outside Conurbations with population under 50,000",
"Rural Districts".
1971:
"England and Wales",
"East Anglia",
"East Midlands",
"North",
"North West",
"South East",
"South West",
"Wales I (South East)",
"Wales Ii (Remainder)",
"West Midlands",
"Yorkshire and Humberside",
"Conurbations",
"Greater London",
"Merseyside Conurbation",
"South East Lancashire",
"Tyneside Conurbation",
"West Midlands Conurbation",
"West Yorkshire Conurbation",
"Urban area outside Conurbations with populations of 100,000 and over",
"Urban areas outside Conurbations with populations of 50,000 and under 100,000",
"Urban areas outside Conurbations with populations under 50,000",
"Rural Districts",
"Birmingham Hospital Region",
"East Anglian Hospital Region",
"Leeds Hospital Region",
"Liverpool Hospital Region",
"Manchester Hospital Region",
"Newcastle Hospital Region",
"North East Metropolitan Hospital Region",
"North West Metropolitan Hospital Region",
"Oxford Hospital Region",
"Sheffield Hospital Region",
"South East Metropolitan Hospital Region",
"South West Metropolitan Hospital Region",
"South Western Hospital Region",
"Welsh Hospital Region",
"Wessex Hospital Region"