Introduction

Purveyor: Agency for Healthcare Research and Quality

Years in the DataCore: 1997, 2000, 2003, 2006, 2009, 2012, 2016 

Years of data owned: 1997, 2000, 2003, 2006, 2009, 2012, 2016

Unit of data: Hospital discharge

Dataset website: https://www.hcup-us.ahrq.gov/db/nation/kid/kiddbdocumentation.jsp 

Public-facing data dictionary: https://www.hcup-us.ahrq.gov/db/nation/kid/kiddde.jsp 

General description: The KID is the largest publicly available all-payer pediatric inpatient care database in the United States. Unweighted, it contains data from approximately 3 million pediatric discharges each year. Weighted, it estimates roughly 7 million hospitalizations. 

As a uniform, multi-state database, the KID promotes comparative studies of health care services and supports health care policy research on a variety of topics, including

  • Utilization of health services by special populations
  • Hospital stays for rare conditions
  • Variations in medical practice
  • Health care cost inflation
  • Medical treatment effectiveness
  • Regional and national analyses
  • Quality of care
  • Impact of health policy changes
  • Access to care

Common Key Linking Variables

Hospital Linking

  • KID Hospital Number (2012, 2016)
  • HCUP Hospital ID (2000, 2003, 2006, 2009)
  • American Hospital Association ID (2000, 2003, 2006, 2009)

Patient Linking

  • HCUP record number (RECNUM) 1997, 2003, 2006, 2009, 2012, 2016
  • Unique Record Identifier (KEY) 2000

Geographic Linking

  • Region (1997, 2000, 2003, 2006, 2009, 2012, 2016)
  • Address (1997, 2000, 2003, 2006, 2009)

Licensing and Access

All users of HCUP data must complete the HCUP Data Use Agreement (DUA) Training Course and sign an HCUP DUA before receipt of the data. See this website for further information: https://www.hcup-us.ahrq.gov/tech_assist/dua.jsp.

KID Structure

Core 1997, 2000, 2003, 2006, 2009, 2012, 2016

Every row of the Core dataset is a hospital discharge.

The primary key of the Core table is:

  • HCUP record number (RECNUM) 1997, 2003, 2006, 2009, 2012, 2016
  • Unique Record Identifier (KEY) 2000

Hospital 1997, 2000, 2003, 2006, 2009, 2012, 2016

Every row of NIS Hospital is a hospital.

The Primary Key of the Hospital table is:

  • HCUP hospital identification number (HOSPID) 2000, 2003, 2006, 2009
  • KID hospital number (HOSP_KIS) 2012, 2016

Severity 2003, 2006, 2009, 2012, 2016

Every Row of severity is All Patient Refined DRG codes in 2016; however, severity also contains comorbidity data before that. The severity table can be directly mapped to the Core or Hospital tables.

The Primary Key of the Severity table is RECNUM.

DX_PR_GRPS 2006, 2009, 2012

Diagnosis and Procedure information contains data about diagnosis and procedures performed during an admission. It can also be mapped to the Core of Hospital tables. 

The Primary Key of the DX_PR_GRPS table is RECNUM.

DataCore Staff Errata

5/28/2019: No data errata, data exceptions or data corrections have been issued.

DataCore Purveyor Errata

5/28/2019: No data errata, data exceptions or data corrections have been implemented.

Provenance

The data from HCUP was sent in ascii files (.asc) with associated file specification files. It was found that these file specifications offered an accurate depiction of the data. 

For the code used for these processes, email datacore@osumc.edu.

  1. Stata .do files provided by HCUP were used to load the .asc files into Stata. These files were then exported in tab separated value files (.tsv). For 1997, 2000, 2003 data, Stata load files were created following the same structure as the provided .do files in order to load the data into Stata to explore it as .tsv.
  2. The provided file specification files were used in order to create SQL tables to fit the data.
  3. A bulk copy program (BCP) was used in order to upload the .tsv into SQL. 
  4. The website https://www.hcup-us.ahrq.gov/db/nation/kid/kiddde.jsp was used generate metadata about the dataset fields and was used to generate the data dictionary. 

Subscribe. Get just the right amount of health and wellness in your inbox.