ADR Metadata Catalogue

ADR  > Annual District Birth Extract (ADBE) @ 321

https://popdatasci.swan.ac.uk/centres-of-excellence/sail/, https://saildatabank.com/, https://saildatabank.com/about-us/, https://docs.hiru.swan.ac.uk/display/SATP/ADBE+-+Annual+District+Birth+Extract

Office for National Statistics (ONS) register of all births in Wales. These data are obtained from the Office for National Statistics and are derived from information collected during civil registration, which is a legal requirement.

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

SAIL Databank (Wales)

Code used to identify type of multiple birth, e.g. Code &amp;amp;amp;amp;#039;5&amp;amp;amp;amp;#039; refers to &amp;amp;amp;amp;#039;1 live female, 1 still male&amp;amp;amp;amp;#039;. This field is blank on singleton births.

MULTIPLEBIRTH_TYPE_CD

The Office for National Statistics (ONS) Annual District Birth Extract (ADBE) is a register of all births relating to Welsh residents, including those born out of Wales and subsequently registered in Wales. Birth statistics are derived from information recorded when live births and stillbirths are registered as part of civil registration, a legal requirement; these data represent the most complete data source available. The registration of births is a service carried out by the Local Registration Service in partnership with the General Register Office (GRO) in England and Wales. ONS produces five birth statistical releases between July and November each year. These releases include statistics about births that occurred during the previous year. This is all data related to the ONS Annual District Birth Extract. The registration of life events (births, deaths, marriages and civil partnerships) is a service carried out by the Local Registration Service in partnership with the General Register Office (GRO) in Southport, England. The provision of life events data by GRO is formally defined by a service level agreement between GRO and ONS

BIRTHS

This field can contain original stillbirth cause of death code according to the 9th or 10th Revision of the International Classification of Disease (ICD-9 or ICD-10) depending upon the year. These fields are only present for stillbirths. ICD-9 is used for 1993-2000 and ICD10 is used for 2001 onwards. These multiple fields contain each cause mentioned on the stillbirth certificate translated into ICD codes. Up to 15 causes can be stored on the dataset, in separate columns. For 1993 to 2000 only 8 original cause of death codes are stored.

STILLBIRTH_DIAG_2_CD

Stillbirth indicator. This indicator is set to 1 for stillbirths. This indicator is blank on live births. NOTE - In section 41 of the Births and Deaths Registration Act 1953, a stillbirth is defined as &amp;amp;amp;amp;ldquo;a child which has issued forth from its mother after the 28th week of pregnancy and which did not at any time after being completely expelled from its mother breathe or show other signs of life&amp;amp;amp;amp;rdquo;. This definition was used up to 30 September 1992. On 1 October 1992 the Still-Birth (Definition) Act 1992 came into force, altering the above definition of a stillbirth to 24 or more weeks completed gestation. Figures for stillbirths from 1993 are thus not fully comparable with those for previous years. The effect of this change on figures for 1992 is analysed in the annual volume for that year (OPCS,1994).

STILLBIRTH_IND

STILLBIRTH_CAUSE_15_CD

STILLBIRTH_CAUSE_10_CD

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

MOTHERSTATS_PREV_CENSUS_LSOA_CD

District code for the place of birth. 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.

BIRTH_COUNTY_DISTRICT_CD

Occupation code of mother. 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.

MOTHER_OCC_CLASS_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

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 place of birth. NOTE - there will have been cases where the postcode that was recorded for the mother 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.

BIRTH_URBANRURAL_CD

District code of usual residence of mother. 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.

MOTHER_COUNTYDISTRICT_CD

STILLBIRTH_CAUSE_1_CD

STILLBIRTH_DIAG_7_CD

Socio-economic classification of mother. Socio-economic classification is only coded on 10% of live births. Only 10% of live births have socio-economic status coded, while 100% of stillbirths have socio-economic status coded. Live births where employment status has not been coded will have SEC90F and SEC90M blank. Records where no father/second parent is present on the birth registration will also have SEC90M blank.

MOTHER_SOCIOECONOMIC_CLASS_CD

STILLBIRTH_CAUSE_5_CD

COUNTBIRTH

STILLBIRTH_DIAG_15_CD

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

ALF_STS_CD

Country code in which the mother is resident, based on the current 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.

MOTHERSTATS_CURR_CENSUS_COUNTRY_CD

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

MOTHER_WARD_CD

Country code in which the mother is 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.

MOTHERSTATS_PREV_CENSUS_COUNTRY_CD

STILLBIRTH_CAUSE_14_CD

BIRTH_SHA_CD

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

BIRTHSTATS_PREV_CENSUS_LSOA_CD

BIRTH_REG_DT_VALID

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

AVAIL_FROM_DT

Organisation Code for the Local Health Board (LHB) for the place of birth, identified via the NHS Postcode Directory.

BIRTH_HEALTH_ORG_CD

The date of the Monday that occurs prior, or on, the actual date of birth. Access to this data item is limited, however, as it can be used to calculate age at specific events. Possible errors in extract may include patients with events and event dates before WOB.

STILLBIRTH_CAUSE_2_CD

STILLBIRTH_CAUSE_6_CD

Marital/civil partnership status of parents and Registration type. This field is derived based on whether marriage/civil partnership details are recorded at birth registration and from 1986 onwards whether the addresses of the mother and father/second parent are the same.  To determine whether a birth registration outside of marriage prior to 1986 is a joint registration or a sole registration you need to look to see whether father&amp;amp;amp;amp;rsquo;s details are recorded on the birth registration. Prior to 1986 it is not possible to determine whether for joint registrations the parents were living at the same address or at different addresses. Marital/civil partnership status of parents and registration type. From 1 September 2009, births could be registered under the Human Fertilisation and Embryology Act 2008 by a same sex female couple (records where the variable PIND [second female parent indicator] = 1), these births could be registered within or outside of a civil partnership/marriage. Marriages of same sex couples could take place in England and Wales from 29 March 2014. NOTE - there are separate indicators to denote multiple or previous marriage/civil partnerships.

BIRTH_MARRIAGE_IND_CD

STILLBIRTH_DIAG_4_CD

STILLBIRTH_DIAG_12_CD

STILLBIRTH_DIAG_9_CD

MOTHER_SHA_CD

MOTHER_CCG_CD

ANNUALRECORD_IND

If the birth occurred in a communal establishment then the code is allocated at the time the birth is registered. The code is not presented to the screen, it is generated as a result of the establishment address being input. If the birth occurred at the mother&amp;amp;amp;amp;#039;s usual address then an &amp;amp;amp;amp;#039;H&amp;amp;amp;amp;#039; (at home) will be present. If the event did not take place at home nor in a communal establishment then an &amp;amp;amp;amp;#039;E&amp;amp;amp;amp;#039; (Elsewhere) will be present.

COMMUNAL_ESTABLISHMENT_CD_E

STILLBIRTH_CAUSE_11_CD

MOTHERSTATS_CURR_CENSUS_HEALTH_ORG_PREV_CD

When a birth registration is one of a multiple birth maternity the multiple birth indicator is set to 1. This indicator is assigned by ONS. Values: 1 = multiple birth; this field is blank on singleton births. This data is good from 1993 onwards. Prior to 1993 MULTIPLEBIRTH_TYPE_CD needs to be used to identify multiple births.

MULTIPLEBIRTH_IND_CD

STILLBIRTH_DIAG_8_CD

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

MOTHERSTATS_PREV_CENSUS_HEALTH_ORG_CD

Establishment type where birth occurred [e.g. NHS facility or other/elsewhere]. Derived from CESTRSS [Communal Establishment Code]; data available from 1993 onwards.

BIRTH_ESTABLISHMENT_TYPE_CD

STILLBIRTH_DIAG_5_CD

No postcode is present when mother&amp;amp;amp;amp;rsquo;s area of usual residence is outside of the UK. Where the mother&amp;amp;amp;amp;rsquo;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.

MOTHER_POSTCODE_IMPUTATION_IND_CD

MOTHERSTATS_PREV_CENSUS_HEALTH_ORG_PREV_CD

STILLBIRTH_DIAG_11_CD

STILLBIRTH_CAUSE_12_CD

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

MOTHER_LSOA_CD

Country code of place of birth of father/second parent. 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.

FATHER_BIRTHCOUNTRY_CD

MATERNITYTABULATION_IND_CD

Sex of child; Code &amp;amp;amp;amp;#039;1&amp;amp;amp;amp;#039; = Male, Code &amp;amp;amp;amp;#039;2&amp;amp;amp;amp;#039; = Female. Each year there may be a record which is received with indeterminate sex. This is changed to Male.

NENONATE_SEX_CD

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 mother. NOTE - there will have been cases where the postcode that was recorded for the mother 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.

MOTHER_URBANRURAL_CD

Socio-economic classification of father/second parent.Socio-economic classification is only coded on 10% of live births. Only 10% of live births have socio-economic status coded, while 100% of stillbirths have socio-economic status coded. Live births where employment status has not been coded will have SEC90F and SEC90M blank. Records where no father/second parent is present on the birth registration will also have SEC90M blank. NOTE - codes 2001 onwards will DIFFER from codes from 1993-2000.

FATHER_SOCIOECONOMIC_CLASS_CD

Local Authority code in which the mother is resident, based on the current census.

MOTHERSTATS_CURR_CENSUS_LA_CD

Country code ofplace of birth of mother. 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.

MOTHER_BIRTHCOUNTRY_CD

STILLBIRTH_DIAG_6_CD

Country code of the place of birth, based on the current 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.

BIRTHSTATS_CURR_CENSUS_COUNTRY_CD

Date of registration of birth. Value: For 1993 onwards, YYYYMMDD for example 18 December 2013 would be 20131218. For 1982-1992, REGMTH (1-12) and REGYR (YYYY) need to be used in combination. Thus, prior to 1993 only the month and year of registration are available.

BIRTH_REG_DT

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

MOTHER_COUNTYANDCOUNTYDISTRICT_CD

Birthweight is measured in grams. For live birth registrations received on RON, birthweight is passed electronically to us from the notification by the midwife or doctor in attendance at the birth. These details are then supplied to the registrar. For stillbirths, details of the weight of the foetus are supplied on a certificate by a doctor or midwife. The certificate is Birth History True Birth Order Registration Birth Order Marital Birth Order First birth while cohabiting with man A 1 Not recorded Not applicable Second birth while married to man B 2 1 1 Third birth while cohabiting with man C 3 Not recorded Not applicable Fourth birth after marriage to man C 4 3 2 Office for National Statistics 20 Birth Statistics: Metadata then taken by an informant to the registrar. If the birthweight is missing, but the registration is linked to the birth notification then the birthweight from the notification is taken. In cases where no birthweight is recorded, the birth is included in the total &amp;amp;amp;amp;lsquo;all weights&amp;amp;amp;amp;rsquo; but not distributed among the individual categories. Table H provides figures for records where no birthweight was recorded.

BIRTH_WEIGHT

STILLBIRTH_DIAG_10_CD

MOTHERSTATS_PREV_CENSUS_LA_PREV_CD

Local Authority code in which the mother is resident, based on the previous census.

MOTHERSTATS_PREV_CENSUS_LA_CD

STILLBIRTH_CAUSE_9_CD

BIRTH_CCG_CD

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

BIRTHSTATS_PREV_CENSUS_HEALTH_ORG_CD

Local Authority code of the place of birth, based on the previous census.

BIRTHSTATS_PREV_CENSUS_LA_CD

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

BIRTHSTATS_CURR_CENSUS_HEALTH_ORG_CD

MOTHERSTATS_CURR_CENSUS_LA_PREV_CD

BIRTHSTATS_CURR_CENSUS_HEALTH_ORG_PREV_CD

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

MOTHER_GOVERNMENTOFFICEREGION_CD

STILLBIRTH_DIAG_3_CD

BIRTHSTATS_CURR_CENSUS_LA_PREV_CD

STILLBIRTH_CAUSE_8_CD

Country code of the place of birth, 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.

BIRTHSTATS_PREV_CENSUS_COUNTRY_CD

STILLBIRTH_DIAG_14_CD

STILLBIRTH_CAUSE_3_CD

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

BIRTH_COUNTY_CD

BIRTHSTATS_PREV_CENSUS_LA_PREV_CD

STILLBIRTH_CAUSE_13_CD

Local Authority code of the place of birth, based on the current census.

BIRTHSTATS_CURR_CENSUS_LA_CD

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

MOTHER_COUNTY_CD

BIRTHSTATS_PREV_CENSUS_HEALTH_ORG_PREV_CD

Organisation Code for the Local Health Board (LHB) of the residence of the mother. Identified via the NHS Postcode Directory.

MOTHER_HEALTH_ORG_CD

STILLBIRTH_DIAG_1_CD

Occupation code of father/second parent. 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.

FATHER_OCC_CLASS_CD

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

BIRTH_COUNTYANDCOUNTY_DISTRICT_CD

STILLBIRTH_CAUSE_4_CD

STILLBIRTH_DIAG_13_CD

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

Annual District Birth Extract (ADBE)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin