Age-specific mortality data by decade for Registration Districts in England and Wales

Table ID:
MORT_AGE_REG     (61471)
Contents:
Age-specific mortality data by decade for Registration Districts in England and Wales
Approx. number of rows:
3,144
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
Chronology:
The data cover the period 1881 to 1911.
Dates and times are identified by:
   Decade

Sources:

  1. 1851-60: All RDs in England and Wales. For this decade, deaths of persons aged over 75 were divided into 75-84 and 85 upwards. To ensure consistency with other years, m_75_up and f_75_up were computed from the more detailed figures as the data were loaded. (626 records in all).
  2. 1861-70: All RDs in England and Wales. Data on numbers of births (see below) and footnotes from the Decennial Supplement were similarly added and certain errors removed. (620 records in all).
  3. 1871-80: The Registrar General's Decennial Supplement for the 1870s did not tabulate age-specific mortality separately for men and for women, so the raw data for this decade are held separately in 'mort_age_1870s'. The figures for the 1870s in this table are estimates, computed as follows: For most Districts, we take the non-sex specific data for the decade from 'mort_age_1870s' and estimating the proportions of men and of women in the district as the average of the proportions for the same RD in the 1860s and the 1880s. Where this method fails, because the district was not in continuous existence over all three decades, the gender division for an RD is estimated by using the gender division for the relevant county, computed in the same way.
  4. 1881-90: All RDs in England and Wales. (632 records in all).
  5. 1891-1900: All RDs in England and Wales. (635 records in all).
  6. 1901-10: All RDs in England and Wales. In this report, deaths of children aged 2 to 4 were grouped together rather than recorded by individual year of age. (634 records in all).


Notes:

  1. The full tables in the Registrar General's Decennial Supplements from which the transcriptions were taken classify the number of deaths for each age/sex group by cause, plus average population figures which are adjusted for boundary changes and standardised death rates for each age group. They also provide an additional more detailed age break-down for children: under 1 year, 1-2, 2-3, 3-4 and 4-5 years. Our transcription is limited to the total number of deaths for each age and sex group, plus the numbers of births. A fuller transcription of the cause of death statistics should be available from other researchers while the average population figures can be re-computed from the data in the 'age_reg' table.
  2. The figures cover a period of ten calendar years, and therefore the total number of births and deaths will differ slightly from those in the 'pop_chan' table which precisely covers inter-censal periods.
  3. The Decennial Supplements covering the 1850s and 1860s do not list births, and figures for total, male and female births over these decades were transcribed from pp.200-17 of the RG's 23rd Annual Report for 1860 and pp.240-57 of the 33rd Annual Report for 1870, respectively. These tables in general provide precisely the figures required, but in a few cases the Registration Districts used were not identical to those in the Decennial Supplement. These special cases were treated with some care, drawing on additional data from the Annual Reports including the total number of births listed for the component sub-Districts. Details of these adjustments can be found in the spreadsheets used for data entry.


Checking:

  1. That the numbers of male and female births equalled total births.
  2. That deaths of male children aged under 5 by individual year equalled the total for the age group.
  3. That deaths of males by five- or ten-year bands equalled the total number of male deaths.
  4. That deaths of female children aged under 5 by individual year equalled the total for the age group.
  5. That deaths of females by five- or ten-year bands equalled the total number of female deaths.
  6. 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. N.B. The 1870s data is not loading as the matching requires 2 old gazetteer tables gis1_gaz and gis2_gaz. These tables have not been moved across to postgres yet so this table will need re-running when they are or alternatively need matching to the AUO.


Acknowledgments:


We are extremely grateful to the following:

  1. Eilidh Garrett: The values in this table for 1901-10 were partly transcribed by Eilidh Garrett.
  2. David Allan Gatley: The values in this table for 1851-60 were all supplied by David Gatley.
  3. Robert Woods: The values in this table for 1861-70 were mostly extracted from the complete transcription of the individual RD tables in the 1861-70 Decennial Supplement created by Robert Woods, supplied to the database via the Essex Data Archive. Data for districts 284-323 and 605-623 was missing and was therefore independently input at QMW.


Indices:

IndexTypeColumn(s) indexed
mort_age_reg_pkey Primary key rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
mort_age_reg_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
decade Integer number. Inter-censal period, for example 1901-11='1900'.
reg_num Integer number. Number identifying each RD, and placing it in order.
reg_sfx Text string (max.len.=8). Suffix to ID number, allowing IDs such as '431A'.
reg_dist Text string (max.len.=44). Name of Registration District to which data relate.
reg_cnty Text string (max.len.=24). Name of Registration County in which the district was located.
births Integer number. Total number of births.
deaths Integer number. Total number of deaths.
m_births Integer number. Total number of male births.
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_2_4 Integer number. Deaths of males aged 2 and under 5 (1901-10 only).
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_34 Integer number. Deaths of males aged 25 to 34.
m_35_44 Integer number. Deaths of males aged 35 to 44.
m_45_54 Integer number. Deaths of males aged 45 to 54.
m_55_64 Integer number. Deaths of males aged 55 to 64.
m_65_74 Integer number. Deaths of males aged 65 to 74.
m_75_up Integer number. Deaths of males aged 75 and upwards.
m_75_84 Integer number. Deaths of males aged 75 to 84. (1851-60 only)
m_85_up Integer number. Deaths of males aged 85 and upwards (1851-60 only).
f_births Integer number. Total number of female births.
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_2_4 Integer number. Deaths of females aged 2 and under 5 (1901-10 only).
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_34 Integer number. Deaths of females aged 25 to 34.
f_35_44 Integer number. Deaths of females aged 35 to 44.
f_45_54 Integer number. Deaths of females aged 45 to 54.
f_55_64 Integer number. Deaths of females aged 55 to 64.
f_65_74 Integer number. Deaths of females aged 65 to 74.
f_75_up Integer number. Deaths of females aged 75 and upwards.
f_75_84 Integer number. Deaths of females aged 75 to 84. (1851-60 only)
f_85_up Integer number. Deaths of females aged 85 and upwards (1851-60 only).
notes Text string (max.len.=304). Comments transcribed from source.
rec_num Integer number. Unique number identifying row in table.