Mortality totals for local authorities in England and Wales, 2008-2015

Table ID:
MORT_EW_LAD_MODERN     (61476)
Contents:
Mortality totals for local authorities in England and Wales, 2008-2015
Approx. number of rows:
3,212
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 2008 to 2015.
Dates and times are identified by:
   Year

Sources:

  1. All data are taken from Table 3 in each of the annual series of "Death registrations summary tables - England and Wales" for 2008-15, as downloaded from https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathregistrationssummarytablesenglandandwalesreferencetables on 15th January 2017. Where more than one set of tables was available for a year, we used the Final version. The original tables for 2014 and 2015 also include data for Local Health Boards in Wales, but they are not included here.


Notes:

  1. Table 3 is the only table in these sets to provide data for local authorities. 2008 is the earliest table available, but it is for a significantly different reporting geography than the later years.
  2. This table contains data for districts, Unitary Authorities, counties, regions and nations. All rows have been matched to the AUO except for:
    • Units abolished in 2009: in matching to the AUO, we specified that units must exist in 2011. The 2009 and 2010 listings include units labelled as "former districts", as identified here by the ?? flag, but the 2008 data use the earlier geography without any flagging. In practice, this table can be treated as following "2011 census geography", but only if the 2008 data are excluded.
    • 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. At least for now, this unit is being matched to Cornwall and DOES have a g_unit value.
    • In 2009-13 inclusive, Hackney and the City of London are similarly reported as a single unit.
    • The table as a whole reports persons dying in England and Wales based on where they are unsually resident, and consequently includes rows labelled as "Normal residence outside England and Wales" or "Usual residence outside England and Wales". For the same reason, the overall total from 2010 onwards is labelled "ENGLAND? WALES AND ELSEWHERE" (NB the table includes totals for England and for Wales). None of these rows can be given a unit ID.


Checking:

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


Columns within table:

ColumnTypeContents
year Integer number. Calendar year to which the report relates.
ons_code Text string (max.len.=13). ONS Code for the area as it appeared in the original table. Only present for 2015.
area_name Text string (max.len.=104). Name of the area as it appeared in the original table.
area_status Text string (max.len.=24). Information about unit status as listed in original tables. Currently holds 'UA' for Unitary Authorities and 'Met County' for Metropolitan Counties.
flagged_as_former Text string (max.len.=6). [No description available]
area_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.
deaths_p Integer number. Total number of deaths during year: Persons.
deaths_m Integer number. Total number of deaths during year: Males.
deaths_f Integer number. Total number of deaths during year: Females.
smr_p Integer number. Standardised Mortality Ratio: Persons.
smr_m Integer number. Standardised Mortality Ratio: Males.
smr_f Integer number. Standardised Mortality Ratio: Females.
asm_rate_p Floating point number. Age-Standardised mortality rate: Persons. Only in the data set for 2015.
asm_rate_m Floating point number. Age-Standardised mortality rate: Males. Only in the data set for 2015.
asm_rate_f Floating point number. Age-Standardised mortality rate: Females. Only in the data set for 2015.
rec_num Integer number. Unique number keeping rows in original order.