NIOSHTIC-2 Publications Search

Electronic merger of large health care data sets: cautionary notes from a study of agricultural morbidity in New York State.

Scott EE; Krupa NL; Sorensen J; Jenkins PL
J Agromedicine 2013 Oct; 18(4):334-339
Agriculture ranks among industries with the highest rates of occupational injury and fatality. Administrative medical data sets have long been thought to have potential for occupational injury surveillance. This research explores the feasibility of establishing an agricultural injury surveillance system in New York State that combines data from existing electronic sources. Prehospital Care Report (PCR) data containing the nature of the accident, type of injury, time and date, and patient disposition were received. Researchers also obtained both hospital inpatient and emergency department (ED) records for 2007 through 2009 from the Statewide Planning and Research Cooperative System (SPARCS). For SPARCS data, a computer algorithm identified all potential cases of agricultural injury using International Classification of Diseases (ICD)-9 codes. An attempt was then made to match PCR and SPARCS data using accident date, gender, age, and admitting hospital. Of the PCR records that were matched to SPARCS, 46.8% were found on subsequent inspection to not actually relate to the same incident. Total PCR counts for 2007 and 2008 showed considerable fluctuation, at 2,512,828 and 2,948,841, respectively. A total of 1275, 1336, and 1393 farm injuries were identified in the SPARCS records for 2007, 2008, and 2009, respectively. This study demonstrates that accurate matching of PCR and SPARCS records requires the use of unique personal identifiers. Further, annual fluctuations in PCR counts preclude their current use in a surveillance system. An electronic data set consisting of SPARCS data could be used for surveillance, but would benefit from the addition of PCR data as these become more consistent.
Agriculture; Agricultural-workers; Farmers; Injuries; Surveillance-programs; Information-retrieval-systems; Administration; Agricultural-industry; Morbidity-rates; Accident-statistics; Emergency-care; Medical-services; Computer-models; Demographic-characteristics; Author Keywords: Agricultural injury; existing data sets; surveillance
Erika E. Scott, MS, New York Center for Agricultural Medicine and Health, One Atwell Road, Cooperstown, NY 13326, USA
Publication Date
Document Type
Journal Article
Email Address
Funding Type
Cooperative Agreement
Fiscal Year
Identifying No.
Issue of Publication
Priority Area
Agriculture, Forestry and Fishing
Source Name
Journal of Agromedicine
Performing Organization
Mary Imogene Bassett Hospital, Cooperstown, New York
Page last reviewed: May 13, 2022
Content source: National Institute for Occupational Safety and Health Education and Information Division