ADR Metadata Catalogue

ADR  > Annual District Death Extract (ADDE) @ 316

https://saildatabank.com/about-us/, https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsregisteredinenglandandwalesseriesdrreferencetables, https://docs.hiru.swan.ac.uk/display/SATP/ADDE+-+Annual+District+Death+Extract

Office for National Statistics (ONS) register of all deaths relating to Welsh residents, including those that died outside of Wales.

The data are collected from death registrations.

This dataset requires additional governance approvals from the data provider before data can be provisioned to a SAIL project.

SAIL Databank (Wales)

Digital Health and Care Wales

DEC_STATS_PREV_CENSUS_HEALTH_ORG_PREV_CD

The Office for National Statistics (ONS) Annual District Death Extract (ADDE) is a register of all deaths relating to Welsh residents, including those that died out of Wales. To aid in user needs, timely but provisional counts of death registrations in England and Wales are pubilshed weekly, monthly, and quarterly. Annual mortality statistics (based on deaths registered in a calendar year) are published in separate packages to enable the timely release of statistics. From 1974 to 2005, mortality statistics were published in the annual reference volumns, DH1, DH2, and DH4. From 1993 to 2005, figures were based on deaths occurring annually in England and Wales in the reference year. Prior to 1993, figures were based on deaths registered in England and Wales in the reference year. In 2006, these three volumes were replaced by a single publication, Mortality statistics: deaths registered in England and Wales (Series DR) based on deaths registered in a reference year.

DEATHS

This field identifies the nature of injury when the underlying cause of death (defined by ICD-10 OR ICD-9) is an external cause. It is possible to have more than one nature of injury code for a single death. This covers all records where the underlying cause of death is an external cause from 2001 onwards [using ICD-10 coding ONLY], and from 1993-2000 [using ICD-9 coding ONLY]. Sometimes information on injuries is derived from coroner forms that are supplied to ONS, in particular coroner certificates of cause of death after inquest. NOTE - Because the revised form no longer includes specific questions about type of injury and parts of body injured, some coroners now often provide less detail than before. The result is that some deaths are assigned to residual codes for nature of injury. For example, in ICD-10 the statement &amp;amp;ldquo;head injury&amp;amp;rdquo; is coded to &amp;amp;ldquo;unspecified injury of head&amp;amp;rdquo; (S09.9), whereas with more detail it might be assigned to &amp;amp;ldquo;fracture of skull and facial bones&amp;amp;rdquo; (S02.n). The move from ICD-9 to ICD-10 had an impact on the allocation of secondary causes. ONS published an assessment of this impact (Griffiths and Rooney 2003). In ICD-10, when more than one body region is involved, coding is made to the relevant category of injuries involving multiple body regions (T00&amp;amp;ndash;T07). Therefore, in the above example of an occupant injured in a transport accident, under ICD-10 the secondary cause would be classified as &amp;amp;ldquo;other specified injuries involving multiple body regions&amp;amp;rdquo; (T06.8), whereas under ICD-9 the secondary cause would be more specifically classified as a fracture of the skull (ICD-9 800). Missing Values and imputation: Field is blank for deaths at age under 28 days.

DEATHCAUSE_DIAG_SEC_CAUSE_CD

Lower Super Output Area [LSOA] code of the residence of the deceased. The LSOA code has been derived from the postcode of usual residence of deceased.

DEC_LSOA_CD

Local Authority code in which the deceased is/was resident, based on the previous census.

DEC_STATS_PREV_CENSUS_LA_CD

Socio-economic classification code; National Statistics Socio-economic Classification operational category for mother of deceased juvenile. Covers all records after 2001; codes are derived during the online coding and validation process from a pre-existing field that contains the values 1-40 of the operational categories of the National Statistics Socioeconomic Classification based on Standard Occupational Classification.

DEC_OR_MOTHER_SOCIOECONOMIC_CLASS_CD

District code of usual residence of deceased. These geographies will differ across the UK, based on time. In Wales, this is/was a subdivision of Counties at the time.. In Wales, a District is/was a subdivision of Counties at the time.

DEC_COUNTYDISTRICT_CD

COUNT_DEATH

Coded cause of death, this is coded to ICD9 for deaths from 1993-2000 and ICD10 for deaths from 2001- Onwards

DEATHCAUSE_DIAG_7_CD

DEC_CCG_CD

No postcode is present when deceased&amp;amp;#039;s area of usual residence is outside of the UK. Where the deceased&amp;amp;#039;s usual residence is within England and Wales and the postcode is not present or is considered invalid, a postcode will be imputed (PCDIND = 1). The indicator is set to 1 automatically if a valid postcode is not present when data are received. This field is blank if the postcode has otherwise not been imputed. Data present throughout except 1998.

DEATH_POSTCODE_IMPUTATION_IND_CD

ICD-9 or ICD-10 code to understand underlying [secondary] or external cause of death.

DEATHCAUSE_ROWPOS_6_CD

Communal establishment code of residence; coding ranges 00000-99999 [see communal establishment list for full description]. Covers all records where the deceased died in a communal establishment with a stay of over 6 months [e.g. nursing home]. Specific derivation: where a deceased person dies in a communal establishment and their length of stay is over 6 months which will populate the field CESTSTAY with a value of 2. The CESTRSSR code is applied in relation to that specific communal establishment where they lived. Missing Values and imputation, or where blank, will have &amp;amp;quot;&amp;amp;quot;.

DEATH_COMMUNAL_ESTABLISHMENT_CD_E

Coded sex of deceased. This is derived from the death certificate; data is loaded in with M, F, I, X, Y, Z which are then recoded so, M and Y = 1, F and Z=2 and I and X=3. In published tables, 1 and 3 are classed as males and 2 is classed as female.

DEC_SEX_CD

Date when the data made available i.e. date of loading into database.

AVAIL_FROM_DT

The urban/rural classification code, included to the extent that this could be entered using information via ONS statistical records, derived from the postcode of usual residence of deceased. NOTE - there will have been cases where the postcode that was recorded when the death was registered did not exist by the time urban/rural codes were to be added retrospectively, and it was not known into which urban/rural category that postcode would have falled. Urban/rural classification codes are available for all but an odd case for 1999 onwards. The reliability of the classification will decrease the further back one goes, because the nature of any given area changes with time and development.

DEC_URBANRURAL_CD

Retired indicator for deceased or mother [in case of child]. Value=1 for &amp;amp;quot;retired&amp;amp;quot;, black if otherwise.

DEC_OR_MOTHER_RETIRED_IND_CD

DEATH_CCG_CD

Organisation Code for the Local Health Board (LHB) where the deceased is/was a resident, based upon the previous census. Identified via the NHS Postcode Directory.

DEC_STATS_PREV_CENSUS_HEALTH_ORG_CD

DEC_SHA_CD

DEATHCAUSE_DIAG_1_CD

DEATHCAUSE_DIAG_3_CD

DEATHCAUSE_DIAG_6_CD

DEATHCAUSE_ROWPOS_2_CD

Date of death day. Value Labels/Coding: 00-31=day. This is derived from the death certificate. If the value is unknown or omitted then it is populated with 0.

DEATH_DT

Coded underlying cause of death. Automated cause coding is used to allocate an International Classification of Diseases (ICD) code for each medical condition on the certificate and to identify the underlying cause, with approximately 90% of records being automatically coded using IRIS (2014 to present).

DEATHCAUSE_DIAG_UNDERLYING_CD

DEATHCAUSE_DIAG_4_CD

Anonymised Linking Field (ALF), Encrypted. This field is derived from by double encryption after splitting demographic information and clinical information; the first encryption occurs in NHS Wales Informatics Service (NWIS), and the second in SAIL. If the NHS number is not supplied in the data extract, then matching methods are applied; please refer to ALF_MTCH_PCT.

ALF_E

DEATHCAUSE_ROWPOS_3_CD

Lower Super Output Area [LSOA] code of the place of death of the deceased, based upon the previous census.

DEATHSTATS_PREV_CENSUS_LSOA_CD

Standard Occupation Classification code for deceased or mother of deceased juvenile. From 1993 to 2000, occupation was coded using the Standard Occupational Classification SOC90. For 2001 to 2010, occupation was coded using the Standard Occupational Classification SOC2000. The National Statistics Socio-economic Classification (NS-SEC) categorised the socio-economic classification of people. For 2011 onwards, occupation was coded using the Standard Occupational Classification SOC2010.

DEC_OR_MOTHER_OCC_CLASS_CD

The urban/rural classification code at place of death, included to the extent that this could be entered using information via ONS statistical records. For example, there will have been cases where the postcode that was recorded when the event was registered did not exist by the time urban/rural codes were to be added retrospectively, and it was not known into which urban/rural category that postcode would have falled. Urban/rural classification codes are available for all but an odd case for 1999 onwards. The reliability of the classification will decrease the further back one goes, because the nature of any given area changes with time and development.

DEATH_URBANRURAL_CD

Government office region of usual residence of deceased. This should usually be &amp;amp;quot;W&amp;amp;quot; for Wales.

DEC_GOVERNMENTOFFICE_REGION_CD

DEATHCAUSE_ROWPOS_7_CD

Establishment type where birth occurred [e.g. NHS facility or other/elsewhere]. Value labels/coding/range 01-83,99; see communal establishment list. Covers all records where death took place in communal establishment. Derived in the Communal Establishment Coding process which uses the entity code held in CESTRSS [Communal Establishment Code] to find establishment type on the OGSS Communal Establishment file.

DEATH_ESTABLISHMENT_TYPE_CD

DEATHSTATS_PREV_CENSUS_HEALTH_ORG_PREV_CD

DEATHCAUSE_DIAG_5_CD

DEATHSTATS_PREV_CENSUS_LA_PREV_CD

Organisation Code for the Local Health Board (LHB) for the place of the deceased , based upon the previous census. Identified via the NHS Postcode Directory.

DEATHSTATS_PREV_CENSUS_HEALTH_ORG_CD

Organisation Code for the Local Health Board (LHB) where the deceased is/was a resident, identified via the NHS Postcode Directory.

DEATH_HEALTH_ORG_CD

DEATHCAUSE_ROWPOS_5_CD

Retired indicator for husband or father [in case of child]. Value=1 for &amp;amp;quot;retired&amp;amp;quot;, black if otherwise.

DEC_HUSBAND_OR_FATHER_RETIRED_IND_CD

DEATH_REG_DT_VALID

Lower Super Output Area [LSOA] code of the residence of the deceased, based upon the previous census. This has been derived from the postcode taken from the previous census.

DEC_STATS_PREV_CENSUS_LSOA_CD

DEC_STATS_PREV_CENSUS_LA_PREV_CD

Anonymised Linked Field Status Code. This is assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

Neonatal death indicator. Neonatal is defined as being in the first 27 completed days of life 9&amp;amp;gt;0 and &amp;amp;lt;672 hours old at death. Value of 0 = non-neo; Value of 1 = Neonate.

NEONATAL_IND_FLG

DEATHCAUSE_DIAG_8_CD

Occupation code of the deceased. For 2001 onwards, Standard Occupational Classification [SOC] codes apply. For 1986-2000 use OCC90M codes. For 1982-1985 use OCC codes. 1986-1990 values are coded to Classification of occupations 1980. For further information on all codes, see ONS website. Only 10% of live births have occupation of mother and father coded, while 100% of stillbirths have occupation coded for both the mother and father where present. ALL codes are coded automatically where possible from details held in the occupation text field and the industry text field recorded at birth registration. Records which cannot be automatically coded are manually coded instead.

DEC_OCC_TYPE_CD

Country code in which the deceased is/was resident, based on the previous census. For 2007 onwards, the National Statistics Country Classification [NSCC] has been used to code country of birth. The classification is available online via NSCC. For dates 1982-2006, country of birth code lists for this period is provided in separate excel file.

DEATHSTATS_PREV_CENSUS_COUNTRY_CD

County and district code of place of death of deceased. These geographies will differ across the UK, based on time. In Wales, this is/was a subdivision of Counties at the time.

DEATH_COUNTYANDDISTRICT_CD

Date the death was registered. Value Labels/Coding: dates are in the format YYYYMMDD for example 24 February 2015 would be 20150224. This date is derived from the death certificate.

DEATH_REG_DT

Socio-economic classification code; National Statistics Socio-economic Classification operational category for husband or father of deceased juvenile. Covers all records after 2001; codes are derived during the online coding and validation process from a pre-existing field that contains the values 1-40 of the operational categories of the National Statistics Socioeconomic Classification based on Standard Occupational Classification.

DEC_HUSBAND_OR_FATHER_SOCIOECONOMIC_CLASS_CD

Country code of place of birth of the deceased. For 2007 onwards, the National Statistics Country Classification [NSCC] has been used to code country of birth. The classification is available online via NSCC. For dates 1982-2006, country of birth code lists for this period is provided in separate excel file.

DEC_BIRTHCOUNTRY_CD

DEATHCAUSE_ROWPOS_8_CD

DEATHCAUSE_ROWPOS_4_CD

NHS establishment indicator for place of death. This is a code derived during the Communal Establishment coding process from the Communal Establishment file, using the entity code of place of death in CESTRSS. Not present if CESTRSS is H or E. Values are 1: NHS establishment; 2: Non-NHS establishment.

DEATH_NHS_ESTABLISHMENT_IND_CD

Local Authority code for the place of death of the deceased, based on the previous census.

DEATHSTATS_PREV_CENSUS_LA_CD

DEC_HEALTH_ORG_CD

Calculated age unit [unit of age]. This is derived from the caclucated age. Value Labels/Coding: 1=years; 2=months; 3=weeks; 4=days. For deaths occurring under 24 hours, the registrar provides different details of the age at death in a separate column/coding system.

DEC_AGE_UNIT_CD

The electoral ward [also known as neighbourhood] code of the residence of the deceased. The ward code has been derived from the postcode of usual residence of deceased.

DEC_WARD_CD

DEATH_ANNUALRECORD_IND_CD

DEATH_DT_VALID

Standard Occupation Classification code for husband or father/parent of deceased juvenile. From 1993 to 2000, occupation was coded using the Standard Occupational Classification SOC90. For 2001 to 2010, occupation was coded using the Standard Occupational Classification SOC2000. The National Statistics Socio-economic Classification (NS-SEC) categorised the socio-economic classification of people. For 2011 onwards, occupation was coded using the Standard Occupational Classification SOC2010.

DEC_HUSBAND_OR_FATHER_OCC_CLASS_CD

County and district code of usual residence of deceased. These geographies will differ across the UK, based on time. In Wales, this is/was a subdivision of Counties at the time.

DEC_COUNTYANDDISTRICT_CD

DEATHCAUSE_DIAG_2_CD

Calculated age of the deceased. This will range from 000 - 120, so anything outside this range is to be flagged. Age is derived by subtraction of the date of birth from the data of death [supplied by the informant in most cases, except after inquest, where the coroner supplies this information]. Where a year of birth or year of death are recorded as 9999 (missing) the value in DEC_AGE will be copied to DEC_AGE_UNIT_CD. Where dates of birth and/or death are invalid the record will fail validation and require online coding by the Miscellaneous Coding Team.

DEC_AGE

County code of usual residence of deceased. These geographies will differ across the UK, based on time. In Wales, counties can be ceremonial, historic, or preserved; most changed into Local Authorities.

DEC_COUNTY_CD

DEATHCAUSE_ROWPOS_1_CD

DEC_STATS_PREV_CENSUS_COUNTRY_CD

Register of all deaths relating to Welsh residents, including those that died out of Wales.

Annual District Death Extract (ADDE)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin