Johns Hopkins
Surgery Center for Outcomes Research 

American College of Surgeons National Surgical Quality Improvement Program (NSQIP)

The NSQIP contains a large amount of clinical data on a systematic sample of major surgical procedures performed on adult patients at participating hospitals around the U.S. The NSQIP does not include trauma surgery or transplants. The database contains demographic data, comorbidities, lab values, CPT codes of procedures performed, and 30-day complications, mortality, re-hospitalizations, and re-operations. JSCOR owns NSQIP data from 2006 through 2018. In addition, JSCOR has the Pediatric NSQIP, and Procedure Targeted files for Colectomy, Vascular Surgery, Pancreatectomy, Hepatectomy, Hysterectomy, and Gynecology Reconstruction. The Procedure Targeted files contain additional variables specific to those procedures and can be linked to the main NSQIP. See below for more details:

https://www.facs.org/quality-programs/acs-nsqip/participant-use

https://www.facs.org/-/media/files/quality-programs/nsqip/nsqip_puf_userguide_2019.ashx

​

American College of Surgeons National Trauma Data Bank (NTDB)

The NTDB contains a large amount of clinical data on a convenience sample of trauma cases from over 900 trauma centers around the U.S. Registrars at participating centers collect data on all trauma cases for a four month period each year. The database contains demographic data, transport information, use of protective devices, vital signs, emergency department information, comorbidities, complications, and discharge status. Injuries are coded using both ICD-9 diagnosis codes and AIS codes. ICD-9 procedure codes are also included. JSCOR owns NTDB data from 2002 through 2017. Since there was a significant change in data collection procedures between 2006 and 2007 and between 2016 and 2017, users generally analyze data from 2007 through 2016. See below for more details:

https://www.facs.org/quality-programs/trauma/tqp/center-programs/ntdb/datasets

https://www.facs.org/-/media/files/quality-programs/trauma/tqp/tqp_puf_user_manual.ashx

 

Healthcare Cost and Utilization Project National (Nationwide) Inpatient Sample (HCUP-NIS)

The NIS is an all-payor database of U.S. inpatient hospital stays. Starting in 2012 the NIS contains data on a 20% sample of all hospitalizations in the U.S. Prior to 2012 it contained data on all hospitalizations from a 20% sample of hospitals. The NIS database includes basic demographic information, insurance coverage, length of stay, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics. JSCOR owns NIS data for 2000 through 2017. See below for a complete variable list:

http://www.hcup-us.ahrq.gov/db/nation/nis/nisdde.jsp 

​

Healthcare Cost and Utilization Project Nationwide Emergency Department Sample (HCUP-NEDS)

The NEDS is an all-payor database of U.S. emergency department visits. The NEDS contains data on all ED visits from a 20% sample of hospitals with emergency departments. The NIS database includes basic demographic information (except for race), insurance coverage, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics. If the patient was admitted to the same hospital upon discharge from the ED, the NEDS includes information on their hospital stay. JSCOR owns NEDS data for 2006 through 2017. See below for a complete variable list:

http://www.hcup-us.ahrq.gov/db/nation/neds/nedsdde.jsp

 

Healthcare Cost and Utilization Project Kids’ Inpatient Database (HCUP-KID)

The KID is an all-payor database of U.S. pediatric inpatient stays. The KID contains data on a 10% sample of uncomplicated births and an 80% sample of complicated births and other pediatric admissions from all hospitals in the U.S. that serve pediatric patients. The KID database includes basic demographic information, insurance coverage, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics. The KID is produced every three years and JSCOR owns KID data for 2000-2016. See below for a complete variable list:

http://www.hcup-us.ahrq.gov/db/nation/kid/kiddde.jsp

​

Healthcare Cost and Utilization Project Nationwide Readmissions Database (HCUP-NRD)

The NRD is an all-payor database of state inpatient data from about 20 states which provide identifiers that allow linkage of patients over time. The NRD database includes similar data points as that found in the NIS: basic demographic information, insurance coverage, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics. JSCOR owns NRD data for 2010-2017. See below for a complete list:

https://www.hcup-us.ahrq.gov/db/nation/nrd/nrddde.jsp 

​

Healthcare Cost and Utilization Project State Inpatient Database (HCUP-SID) for Maryland

The Maryland SID is an all-payor database of all inpatient hospital stays in Maryland. Like the NIS, the SID database includes basic demographic information, insurance coverage, length of stay, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics. In addition, it has more detailed information on charges, providers, and geographic locations. Starting in 2012 the Maryland SID contains information for linking patients across hospital stays for the purpose of estimating readmission rates and patient-based utilization. JSCOR owns Maryland SID data for 2008 through 2012.

See below for more details:

https://www.hcup-us.ahrq.gov/db/state/siddbdocumentation.jsp

​

Healthcare Cost and Utilization Project State Inpatient Database (HCUP-SID) for California

The California SID is an all-payor database of all inpatient hospital stays in California.  Like the NIS, the SID database includes basic demographic information, insurance coverage, length of stay, discharge disposition, ICD-9 diagnosis and procedure codes, charges, and hospital characteristics.  In addition, it has more detailed information on charges, providers, and geographic locations. The California SID contains information for linking patients across hospital stays, ED visits, and outpatient procedures for the purpose of estimating readmission rates and patient-based utilization. JSCOR owns California SID data for 2003 through 2011.

See below for more details: 

https://www.hcup-us.ahrq.gov/db/state/siddbdocumentation.jsp

​

Maryland Health Services Cost Review Commission (HSCRC) Public Use Dataset

The Maryland HSCRC database is an all-payor database of all inpatient hospital stays and hospital outpatient services in Maryland. The HSCRC inpatient data contains the same cases as the Maryland SID database, but includes additional information on cost, patient residence, and patient comorbidities. Starting in 2012 the Maryland HSCRC contains information for linking patients across hospital stays for the purpose of estimating readmission rates and patient-based utilization. See here for more details: https://hscrc.maryland.gov/pages/default.aspx.

JSCOR owns Maryland HSCRC inpatient data for 2008 through 2020 and outpatient data for 2012 through 2020. JSCOR can also obtain inpatient data prior to 2008 through the Hopkins DataMart system. JSCOR has permission from the HSCRC to undertake projects covering a wide variety of surgical procedures, outcomes, and study designs.

 

MarketScan Commercial Claims and Encounters Database and the Laboratory Database, from Truven Health Analytics (2010-2017)

These data comprise a nationally representative sample of individuals in the U.S. with employer-sponsored private health insurance, as well as their spouses and dependents. This claims database captures the full continuum of care in all settings: physician office visits, hospital stays, retail, mail order, and specialty pharmacies; and carve-out care services. The included patients are not a random sample of all Americans and have no patients over age 64 years. These are data on 45 million patients.