Age-specific cause of death by decade for England and Wales

Table ID:
COD_AGE_EW_1921_71     (57359)
Contents:
Age-specific cause of death by decade for England and Wales
Approx. number of rows:
71,915
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Administrative County
   Local Government District
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.
Dates and times are identified by:
   Year

Sources:

  1. [Details for 1921 and 1931 to be added]
  2. The 1941 data are taken from the Registrar General's Statistical Review of England and Wales for the Year 1941, Part I, Tables, Medical, 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).
  3. The 1951 data are taken from the Registrar General's Statistical Review of England and Wales for the Year 1951, Part I, Tables, Medical, 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). This covers the Metropolitan Boroughs, then the County Boroughs and lastly the urban and rural aggregates for each administrative county. NB from 1952 Table 20 was "suspended", although it remains part of the numbering sequence even in 1973.
  4. The 1961 data are taken from the Registrar General's Statistical Review of England and Wales for the Year 1961, Part I, Tables, Medical, 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). The specific units are: "England and Wales", "Northern Region", "Tyneside Conurbation", "East and West Ridings Region", "West Yorkshire Conurbation", "North Western Region", "South East Lancashire Conurbation", "Merseyside Conurbation", "North Midland Region", "Midland Region", "West Midlands Conurbation", "Eastern Region", "London and South Eastern Region", "Greater London", "Southern Region", "South Western Region", "Wales I (South East)", "Wales II (remainder)", "Conurbations", "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 populations under 50,000", "Rural districts". 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.
  5. The 1971 data are taken from the Registrar General's Statistical Review of England and Wales for the Year 1971, Part I, Tables, Medical, 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). The specific units are: "England and Wales", "North", "Tyneside Conurbation", "Yorkshire and Humberside", "West Yorkshire Conurbation", "North West", "South East Lancashire Conurbation", "Merseyside Conurbation", "East Midlands", "West Midlands", "West Midlands Conurbation", "East Anglia", "South East", "Greater London", "South West", "Wales I (South East)", "Wales II (remainder)", "Conurbations", "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 populations under 50,000", "Rural districts", Newcastle Hospital Region, Leeds Hospital Region, Sheffield Hospital Region, East Anglian Hospital Region, North West Metropolitan Hospital Region, North East Metropolitan Hospital Region, South EastMetropolitan Hospital Region, South West Metropolitan Hospital Region, Wessex Hospital Region, Oxford Hospital Region, South Western Hospital Region, Welsh Hospital Region, Birmingham Hospital Region, Manchester Hospital Region, Liverpool Hospital Region.


Notes:

  1. This data was input by the digitisation team at the Centre for Data Digitisation and Analysis, at Queen's University, Belfast.
  2. This table covers London Metropolitan 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).
  3. Note on table: Classified in accordance with the International Abbreviated List with certain sub-divisions.
  4. When loading the table into Postgres the data for 1971 was missing a numeric column therefore an extra column was added to the end. However the d_75_up column was blank whilst there were numbers in the imr column and the final column. The figures were all moved across one column for 1971 so figures given in the imr column became the d_75_up figures, and the unnamed end column data was moved into the imr column. This needs checking against the original table to determine the correct column names for the data.


Checking:

  1. [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]
  2. No matching to the AUO gazetteer has been attempted. These files have been altered to run on Postgres, but otherwise are exactly the same as they were on the oracle server.


Indices:

IndexTypeColumn(s) indexed
cod_age_ew_1921_71_pkey Primary key rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
cod_age_ew_1921_71_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
year Integer number. Inter-censal period, for example 1911-21='1921'.
adm_cnty Text string (max.len.=34). Name of Administrative County in which the district was located.
lg_dist Text string (max.len.=64). Name of Local Government District to which data relate.
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 Administrative Region (including Hospital regions) for later figures taken in 1961 and 1971 to which data relate.
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 disease of all ages.
d_0_4weeks Integer number. Deaths due to specific cause during first four weeks of life (1951).
d_4weeks_1year Integer number. Deaths due to specific cause between four weeks and one year (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).
rec_num Integer number. Unique number identifying row in table.