Skip to main content
Top
Published in: BMC Public Health 1/2015

Open Access 01-12-2015 | Research article

Novel use of three administrative datasets to establish a cohort for environmental health research

Authors: Lucy F Telfar Barnard, Michael G Baker, Simon Hales, Philippa Howden-Chapman

Published in: BMC Public Health | Issue 1/2015

Login to get access

Abstract

Background

In recent years publications have called for increased use of administrative data for research; predicted that use would rise; and discussed possible ethical parameters for that use. This paper describes the novel combination of three administrative datasets to create a population cohort for environmental health research, and investigates the potential use of a national health register as a total population denominator.

Methods

We matched a national health register (the New Zealand national health index or NHI) to Quotable Value New Zealand Ltd (QV) nationwide residential dwelling data, and to hospital admissions data, to create a national matched cohort with health outcomes for the period 2000 – 2006. We then compared population distribution and hospitalisation rates by gender, age, ethnic group and Census Area Unit-based socio-economic deprivation index across the Census, NHI and matched cohort populations.

Results

The NHI population was 23% larger than the Census. Differences between the NHI and Census were most marked in those aged over 90 years; with ethnicity unknown or an unassigned Census area unit; and in Asian Peoples aged under 30 years. The match rate between QV and NHI data was 70%. There were further differences between the NHI and matched cohort populations, particularly for rural areas and older age groups. Compared to Census-based rates, NHI and cohort-based hospitalisation rates were higher in those aged 75 and over, differed by ethnicity, and had less socio-economic gradient.

Conclusions

The NHI was larger than the Census due to record duplication and entries for people residing overseas remaining on file under New Zealand addresses. NHI and QV matching was incomplete due to NHI address data being poor quality or not suitable for matching. To better approximate true hospitalisation rates, studies using the NHI as a cohort should exclude those aged over 90 years; or with ethnic group or Census area unit unknown. Cohort hospitalisation rates should also be adjusted for differences from the Census, particularly the lower hospitalisation rates for those aged 75 and over, and other differences by age, ethnic group and socio-economic deprivation.
Literature
2.
go back to reference Jutte DP, Roos LL, Brownell MD. Administrative record linkage as a tool for public health research. Annu Rev Public Health. 2011;32:91–108.CrossRefPubMed Jutte DP, Roos LL, Brownell MD. Administrative record linkage as a tool for public health research. Annu Rev Public Health. 2011;32:91–108.CrossRefPubMed
3.
go back to reference Stiles PG, Boothroyd RA, Robst J, Ray JV. Ethically using administrative data in research: medicaid administrators’ current practices and best practice recommendations. Adm Soc. 2011;43(2):171–92.CrossRef Stiles PG, Boothroyd RA, Robst J, Ray JV. Ethically using administrative data in research: medicaid administrators’ current practices and best practice recommendations. Adm Soc. 2011;43(2):171–92.CrossRef
5.
go back to reference Gini R, Francesconi P, Mazzaglia G, Cricelli I, Pasqua A, Gallina P, et al. Chronic disease prevalence from Italian administrative databases in the VALORE project: a validation through comparison of population estimates with general practice databases and national survey. BMC Public Health. 2013;13:15.CrossRefPubMed Gini R, Francesconi P, Mazzaglia G, Cricelli I, Pasqua A, Gallina P, et al. Chronic disease prevalence from Italian administrative databases in the VALORE project: a validation through comparison of population estimates with general practice databases and national survey. BMC Public Health. 2013;13:15.CrossRefPubMed
6.
go back to reference Hennessy S. Use of health care databses in pharmacoepidemiology. Basic Clin Pharmacol Toxicol. 2006;98(3):311–3.CrossRefPubMed Hennessy S. Use of health care databses in pharmacoepidemiology. Basic Clin Pharmacol Toxicol. 2006;98(3):311–3.CrossRefPubMed
7.
go back to reference Tricco AC, Pham B, Rawson NSB. Manitoba and Saskatchewan administrative health care utilization databases are used differently to answer epidemiologic research questions. J Clin Epidemiol. 2008;61(2):192–7.CrossRefPubMed Tricco AC, Pham B, Rawson NSB. Manitoba and Saskatchewan administrative health care utilization databases are used differently to answer epidemiologic research questions. J Clin Epidemiol. 2008;61(2):192–7.CrossRefPubMed
8.
go back to reference Thompson SC, Woods JA, Katzenellenbogen JM. The quality of Indigenous identification in administrative health data in Australia: insights from studies using data linkage. BMC Med Inform Decis Mak. 2012;12:133.CrossRefPubMed Thompson SC, Woods JA, Katzenellenbogen JM. The quality of Indigenous identification in administrative health data in Australia: insights from studies using data linkage. BMC Med Inform Decis Mak. 2012;12:133.CrossRefPubMed
9.
go back to reference Thygesen LC, Daasnes C, Thaulow I, Brønnum-Hansen H. Introduction to Danish (nationwide) registers on health and social issues: structure, access, legislation, and archiving. Scand J Publ Health. 2011;39(7 Suppl):12–6.CrossRef Thygesen LC, Daasnes C, Thaulow I, Brønnum-Hansen H. Introduction to Danish (nationwide) registers on health and social issues: structure, access, legislation, and archiving. Scand J Publ Health. 2011;39(7 Suppl):12–6.CrossRef
10.
go back to reference Sortsø C, Thygesen LC, Brønnum-Hansen H. Database on Danish population-based registers for public health and welfare research. Scand J Publ Health. 2011;39(7 Suppl):17–9.CrossRef Sortsø C, Thygesen LC, Brønnum-Hansen H. Database on Danish population-based registers for public health and welfare research. Scand J Publ Health. 2011;39(7 Suppl):17–9.CrossRef
11.
go back to reference Kool B, Chelimo C, Robinson E, Ameratunga S. Deaths and hospital admissions as a result of home injuries among young and middle-aged New Zealand adults. N Z Med J. 2011;124(1347):16–26.PubMed Kool B, Chelimo C, Robinson E, Ameratunga S. Deaths and hospital admissions as a result of home injuries among young and middle-aged New Zealand adults. N Z Med J. 2011;124(1347):16–26.PubMed
12.
go back to reference Tukuitonga CR, Bell S, Robinson E. Hospial admission among pacific children Auckland 1992–97. N Z Med J. 2000;113(1116):358–61.PubMed Tukuitonga CR, Bell S, Robinson E. Hospial admission among pacific children Auckland 1992–97. N Z Med J. 2000;113(1116):358–61.PubMed
13.
go back to reference Baker MG, Telfar Barnard L, Kvalsvig A, Verrall A, Zhang J, Keall M, et al. Increasing incidence of serious infectious diseases and inequalities in New Zealand: a national epidemiological study. Lancet. 2012;379(9821):1112–9.CrossRefPubMed Baker MG, Telfar Barnard L, Kvalsvig A, Verrall A, Zhang J, Keall M, et al. Increasing incidence of serious infectious diseases and inequalities in New Zealand: a national epidemiological study. Lancet. 2012;379(9821):1112–9.CrossRefPubMed
14.
go back to reference Barnett R, Lauer G. Urban deprivation and public hospital admissions in Christchurch, New Zealand, 1990–1997. Health Soc Care Commun. 2003;11(4):299–313.CrossRef Barnett R, Lauer G. Urban deprivation and public hospital admissions in Christchurch, New Zealand, 1990–1997. Health Soc Care Commun. 2003;11(4):299–313.CrossRef
15.
go back to reference Chan WC, Wright C, Riddell T, Wells S, Kerr AJ, Gala G, et al. Ethnic and socioeconomic disparities in the prevalence of cardiovascular disease in New Zealand. N Z Med J. 2008;121(1285):11–20.PubMed Chan WC, Wright C, Riddell T, Wells S, Kerr AJ, Gala G, et al. Ethnic and socioeconomic disparities in the prevalence of cardiovascular disease in New Zealand. N Z Med J. 2008;121(1285):11–20.PubMed
16.
go back to reference Atkinson J, Shaw C, Blakely T, Stanley J, Sloane K. Linkage of Census and Cancer Registrations 1981–2004: CancerTrends Technical Report: Number 1. Wellington: Department of Public Health, University of Otago; 2010. Atkinson J, Shaw C, Blakely T, Stanley J, Sloane K. Linkage of Census and Cancer Registrations 1981–2004: CancerTrends Technical Report: Number 1. Wellington: Department of Public Health, University of Otago; 2010.
17.
go back to reference Telfar Barnard L. Home Truths and Cool Admissions: New Zealand Housing Attributes and Excess Winter Hospitalisation. Wellington: University of Otago; 2010. Telfar Barnard L. Home Truths and Cool Admissions: New Zealand Housing Attributes and Excess Winter Hospitalisation. Wellington: University of Otago; 2010.
18.
go back to reference Telfar Barnard L, Preval N, Howden-Chapman P, Arnold R, Young C, Denne T. The Impact of Retrofitted Insulation and New Heaters on Health Services Utilisation and Costs, Pharmaceutical Costs and Mortality. Wellington: Ministry of Economic Development, MED; 2011. Telfar Barnard L, Preval N, Howden-Chapman P, Arnold R, Young C, Denne T. The Impact of Retrofitted Insulation and New Heaters on Health Services Utilisation and Costs, Pharmaceutical Costs and Mortality. Wellington: Ministry of Economic Development, MED; 2011.
19.
go back to reference Salmond C, Crampton P, Atkinson J. NZDep2006 Index of Deprivation. Wellington: Department of Public Health, University of Otago; 2007. Salmond C, Crampton P, Atkinson J. NZDep2006 Index of Deprivation. Wellington: Department of Public Health, University of Otago; 2007.
20.
go back to reference Johnson A. Room for Improvement: Current New Zealand Housing Policies and Their Implications for Our Children. Auckland: Child Poverty Action Group; 2003. Johnson A. Room for Improvement: Current New Zealand Housing Policies and Their Implications for Our Children. Auckland: Child Poverty Action Group; 2003.
22.
go back to reference Malcolm L. Towards a reliable and accurate ethnicity database at district and national levels: progress in Canterbury. N Z Med J. 2010;123(1314):43–8.PubMed Malcolm L. Towards a reliable and accurate ethnicity database at district and national levels: progress in Canterbury. N Z Med J. 2010;123(1314):43–8.PubMed
Metadata
Title
Novel use of three administrative datasets to establish a cohort for environmental health research
Authors
Lucy F Telfar Barnard
Michael G Baker
Simon Hales
Philippa Howden-Chapman
Publication date
01-12-2015
Publisher
BioMed Central
Published in
BMC Public Health / Issue 1/2015
Electronic ISSN: 1471-2458
DOI
https://doi.org/10.1186/s12889-015-1580-1

Other articles of this Issue 1/2015

BMC Public Health 1/2015 Go to the issue