ADR Metadata Catalogue

ADR  > Annual District Death Daily (ADDD) - Legacy @ 323

https://saildatabank.com/about-us/, https://docs.hiru.swan.ac.uk/display/SATP/ADDD+-+Annual+District+Death+Daily

ADDD is a project specific dataset which was for specific COVID-19 related projects only. Data relating to deaths are available from the ADDE dataset.

Daily version of Annual District Deaths Datasets. 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.

Legacy dataset - no longer available, however the Annual District Death Extract (ADDE) is a separate dataset and is still available.

Approx 70-80% coverage of Welsh population through GP registrations.

SAIL Databank (Wales)

Digital Health and Care Wales

CORONER_AREA

Currently this dataset is exclusively for projects designated National Covid Emergency Response.

Daily version of Annual District Deaths Datasets. 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.

DF_ONS_DEATHSDAILY

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

ALF_STS_CD

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

CAUSE_CD_7

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

CAUSE_ROW_8

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

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.

AGE_C_UNIT

CTYR

CAUSE_CD_5

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

RETINHF

CAUSE_ROW_5

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.

SOC2KDM

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.

SECCATHF

CAUSE_CD_4

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

RETINDM

CAUSE_ROW_2

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.

DT_REG

PLACE_OF_DEATH_CD

SHA_OF_RESIDENCE

CAUSE_CD_3

CAUSE_CD_2

INQUEST_DATE

CAUSE_ROW_1

CAUSE_CD_8

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.

SOC2KHF

The date the death was last updated in this dataset.

LASTUPDATED

CAUSE_ROW_6

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).

UNDERLYING_CAUSE

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.

NHS_IND

UTLA9R

CAUSE_ROW_7

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.

SECCATDM

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

GOR9R

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

AVAIL_FROM_DT

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.

ESTTYPED

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.

AGE_C

CCCG9R

CAUSE_CD_6

PCT_OF_RESIDENCE

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.

CAUSE_CD_1

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.

WARD9R

CAUSE_ROW_4

CAUSE_ROW_3

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

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.

LSOAR

ICD10SC

The date the death was first inderted into this dataset.

FIRSTINSERTED

Daily version of Annual District Death Dataset which was previously available to COVID-19 response projects. Legacy dataset - no longer available, however the Annual District Death Extract (ADDE) is a separate dataset and is still available.

Annual District Death Daily (ADDD) - Legacy

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin