Data cleaning and management protocols for linked perinatal research data: a good practice example from the Smoking MUMS (Maternal Use of Medications and Safety) Study

Tran, Duong Thuy; Havard, Alys; Jorm, Louisa R.

doi:10.1186/s12874-017-0385-6

Table 1 Descriptions of data sets

From: Data cleaning and management protocols for linked perinatal research data: a good practice example from the Smoking MUMS (Maternal Use of Medications and Safety) Study

Data type	Jurisdiction	Description	Number of records and persons prior to cleaning	Dates covered
Perinatal^a
Perinatal Data Collection (PDC)	NSW	Notifications of all livebirths and stillbirths of at least 20 weeks of gestation or at least 400 g birthweight in NSW and WA.	N records: 1155,207^b N persons: 595,457 mothers 937,345 babies	1/1/2003–31/12/2012^b
Midwives Notification System (MNS)	WA		N records: 371155^b N persons: 188,014 mothers 295,095 babies	1/1/2003–31/12/2012^b
Hospital admission^a
Admitted Patient Data Collection (APDC)	NSW	All hospital discharges from all public and private hospitals in NSW and WA.	Mother: 2,708,607 Baby: 1,835,852	Mother: 1/7/2001–30/6/2014 Baby: 1/1/2003–30/6/2014
Hospital Morbidity Data Collection (HMDC)	WA		Mother: 1,245,018 Baby: 307,620	Mother: 1/1/1980–30/6/2013 Baby: 1/1/2003–30/6/2013
Emergency department attendance
Emergency Department Data Collection (EDDC)	NSW	ED attendances at all EDs in metropolitan areas and majority of EDs in regional areas in NSW and WA.	Mother: 1,518,745 Baby: 2,564,429	1/1/2005–31/12/2014
Emergency Department Data Collection (EDDC)	WA		Mother: 854,050 Baby: 1,017,206	Mother: 1/1/2002–30/11/2013 Baby: 1/1/2003–30/11/2013
Death data
NSW Registry of Births, Deaths and Marriages (RBDM)	NSW	Date of deaths registered in NSW	Mother: 1337 Baby: 4271	1/1/2003–31/12/2014
Causes Of Death Unit Record File (COD URF)	NSW	Underlying and contributing causes of death for those registered in NSW	Mother: 881 Baby: 3897	1/1/2003–31/12/2012^c
WA death registration and COD URF	WA	Date of death, underlying and contributing causes of death for those registered in WA	Mother: 478 Baby: 3345	1/1/2003–31/12/2013
Congenital Conditions
Register of Congenital Conditions (RoCC)	NSW	Congenital conditions detected during pregnancy or at birth, or diagnosed in infants up to 1 year of age	Baby: 9976	1/1/2004–31/12/2009
PBS links mapping tables and claims data
Mapping table between PBS PATIDs and NSW mumPPNs	Federal	All identified matches wherein the weight of the match ≥ 17 ^d	1,006,960 matches
Mapping table between PBS PATIDs and WA mumPPNs	Federal		226,817 matches
PBS claim records, NSW or Australian Capital Territory (ACT)^e is the State of the pharmacies	Federal	Claims made in NSW and ACT for all PATIDs included in the NSW mapping table^e	17,470,068 claim records	1/1/2003–31/12/2013
PBS claim records, WA is the State of the pharmacies	Federal	Claims made in WA for all PATIDs included in the WA mapping table^e	3,364,490 claim records	1/1/2003–31/12/2013

^aA child birth generates one birth notification (≥2 notifications if plural births), one hospital separation record for the mother, and one hospital separation record for the newborn (≥2 hospital records for the newborns if plural births)
^bRecords of pre-2003 deliveries (from 1994 in NSW, 1980 in WA) were included in the linkage for the mothers
^cThe NSW COD URF data are not available for the same duration as the RBDM death registrations due to the time needed for coding causes of death
^dThe recommended threshold weight to accept the matches to NSW mumPPNs and WA mumPPNs was 29 and 28, respectively
^eThe Australian Capital Territory (population 385,996) is geographically surrounded by NSW. PBS claims data for NSW women included those dispensed in NSW and the ACT and covered a wider range of pharmaceutical items than claims data for WA mothers

Back to article page

ISSN: 1471-2288

Contact us

General enquiries: journalsubmissions@springernature.com

BMC Medical Research Methodology

Contact us