Births and infant deaths for local authorities in the United Kingdom, 2010 onwards

Table ID:
INF_MORT_UK_MODERN     (61017)
Contents:
Births and infant deaths for local authorities in the United Kingdom, 2010 onwards
Approx. number of rows:
2,278
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 2010 to 2014.
Dates and times are identified by:
   Year

Sources:

  1. All data on deaths taken from Table 1a in each of the series of datasets titled "Deaths Registered by Area of Usual Residence, UK", downloaded from https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsregisteredbyareaofusualresidenceenglandandwales on 22nd January 2017. On that date the most recent year covered was 2014. Although downloads were available for years prior to 2010, they were ZIP archives, not workbooks, and the 2009 set did not contain an equivalent table.
  2. Data on numbers of births for districts, counties and regions within England and Wales were added from the series of datasets titled "Birth Summary Tables - England and Wales", downloaded from https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/livebirths/datasets/birthsummarytables on 21st of January 2017. On that date the most recent year covered was 2015, and data were available in almost the same format, lacking stillbirths, back to 2009 (2008 differs only in using an earlier local government geography). This full set of years was loaded into a temporary table, but data were then copied across to the final dataset only for the years included in the mortality data.
  3. Numbers of births in each of the districts of Scotland were copied across from mort_scot_modern. Districts in N. Ireland lack this data.


Notes:

  1. This table contains data for districts, Unitary Authorities, counties, regions and nations. All rows have been matched to the AUO except for:
    • Cornwall and the Isles of Scilly are always treated as a single district, on the grounds that the Isles of Scilly have too little data to be separately reported. This merged unit does not exist in the AUO, so g_unit is null. However, matching on name has been used to add births data for this unit.
    • In 2010-12 inclusive, Hackney and the City of London are similarly reported as a single unit, which cannot be assigned a g_unit values, but which has had births data added by name matching. In 2013, they are listed separately in the mortality table, but are still merged in the births table so they lack births data for that year, In 2014, they are listed separately in both tables.
    • The table as a whole reports persons dying based on where they were unsually resident, and consequently includes rows labelled as "Outside England and Wales", which cannot be given a g_unit value.
  2. The mortality table also includes national totals for "ENGLAND AND WALES", "NORTHERN IRELAND", "UNITED KINGDOM" and "WALES". These currently lack data on births, although some could be given them with more work.
  3. A note to the 2014 reports says: "The age-standardised mortality rates for 2014 are standardised to the 2013 European Standard Population, expressed per 100,000 population. Age-standardised rates are used to allow comparison between populations which may contain different proportions of people of different ages. Age-standardised mortality rates (ASMRs) for Scotland and Northern Ireland will differ from those published by National Records of Scotland and Northern Ireland Statistics and Research Agency as their published ASMRs are based on only population data. ASMRs published here use live births instead of the population under 1."
  4. All mortality rates columns have associated "note" columns to identify rates which are either included but unreliable, or have been excluded as too unreliable. A note to the 2014 report says: "Rates are not calculated where there are fewer than 3 deaths in a cell, denoted by (u). It is ONS practice not to calculate rates where there are fewer than 3 deaths in a cell, as rates based on such low numbers are susceptible to inaccurate interpretation. ... Rates in tables calculated from fewer than 20 deaths are denoted by (u) as a warning to the user that their reliability as a measure may be affected by the small number of events."


Checking:

  1. The statistical data are as downloaded and have not been checked.


Columns within table:

ColumnTypeContents
year Integer number. Calendar year to which the report relates.
area_name Text string (max.len.=38). Name of the area as it appeared in the original table. Includes "UA" at the end for unitary authorities.
g_unit_type Text string (max.len.=12). Unit type ID from the AUO, added manually by us before loading, i.e. MOD_DIST, MOD_CNTY, MOD_REG or COUNTRY. In the original listings, the types of units were indicated by capitalisation and emboldening.
g_unit Integer number. Unique ID number for the unit from the AUO gazetteer.
pop_tot Floating point number. Population at all ages (thousands): Persons.
pop_m Floating point number. Population at all ages (thousands): Males.
pop_f Floating point number. Population at all ages (thousands): Females.
deaths_tot Integer number. Number of deaths at all ages: Persons.
deaths_m Integer number. Number of deaths at all ages: Males.
deaths_f Integer number. Number of deaths at all ages: Females.
infant Integer number. Number of infant deaths (under 1 year).
neonatal Integer number. Number of neonatal deaths (under 4 weeks).
perinatal Integer number. Number of perinatal deaths (stillbirths and deaths under 1 week).
crude_rate Floating point number. Crude death rate (deaths per 1,000 population).
asmr_tot Floating point number. Age­standardised mortality rate: Persons (see note above).
asmr_m Floating point number. Age-standardised mortality rate: Males (see note above).
asmr_m_note Text string (max.len.=5). Holds "u" to identify "low reliability, and otherwise empty.
asmr_f Floating point number. Age-standardised mortality rate: Females (see note above).
asmr_f_note Text string (max.len.=5). Holds "u" to identify "low reliability, and otherwise empty.
im_rate Floating point number. Infant mortality rate (per 1,000 live births).
im_rate_note Text string (max.len.=5). Holds "u" to identify "low reliability, and otherwise empty.
neo_rate Floating point number. Neonatal mortality rate (per 1,000 live births).
neo_rate_note Text string (max.len.=5). Holds "u" to identify "low reliability, and otherwise empty.
peri_rate Floating point number. Perinatal mortality rate (per 1,000 births and stillbirths).
peri_rate_note Text string (max.len.=5). Holds "u" to identify "low reliability, and otherwise empty.
total_births Integer number. Total live births.
gen_fertility_rate Floating point number. General Fertility Rate: the number of live births per 1,000 women aged 15 to 44, computed using mid-year population estimates.
tot_fertility_rate Floating point number. Total Fertility Rate (TFR): the average number of live children that a group of women would bear if they experienced the age-specific fertility rates of the calendar year in question throughout their childbearing lifespan.
rec_num Integer number. Unique number keeping rows in original order.