Skip to content
CourtneyEpstein edited this page Nov 3, 2015 · 2 revisions

Hospital inpatient discharges 2012-2013: datasets. When you open the dataset on the website you can access the definitions of each variables directly.

More information about the Clinical Classification Software (CCS) may be found here.

All Patient Refined Diagnosis Related Groups and Major Diagnostics Category (APR-DRG and APR-MDC) information are here.

The Emergency Department Indicator is set based on the submitted revenue codes. If the record contained an emergency department revenue code of 045X, the indicator is set to Y, otherwise it will be N.

SPARCS 2012 (Hospital_Inpatient_Discharges__SPARCS_De-Identified___2012.csv): 2,529,422 rows and 38 columns 963.3 Mo.

SPARCS 2013 (Hospital_Inpatient_Discharges__SPARCS_De-Identified___2013.csv): 2,418,874 rows and 38 columns 913.5 Mo.

Columns of Discrete Variables

  • Health_Service_Area
  • Hospital_County
  • Operating_Certificate_Number
  • Facility_Id
  • Facility_Name
  • Age_Group
  • Zip_Code_3_digits
  • Gender
  • Race
  • Ethnicity
  • Admit_Day_of_Week
  • Type_of_Admission
  • Patient_Disposition
  • Discharge_Year
  • Discharge_Day_of_Week
  • CCS_Diagnosis_Code
  • CCS_Diagnosis_Description
  • CCS_Procedure_Code
  • CCS_Procedure_Description
  • APR_DRG_Code
  • APR_DRG_Description
  • APR_MDC_Code
  • APR_MDC_Description
  • APR_Severity_of_Illness_Code
  • APR_Severity_of_Illness_Description
  • APR_Risk_of_Mortality
  • APR_Medical_Surgical_Description
  • Source_of_Payment_1
  • Source_of_Payment_2
  • Source_of_Payment_3
  • Attending_Provider_License_Number
  • Operating_Provider_License_Number
  • Other_Provider_License_Number
  • Abortion_Edit_Indicator
  • Emergency_Department_Indicator

CCS= Clinical Classification.

APR_DRG= All Patient Refined Diagnosis Related Groups.

APR_MDC=All Patient Refined Major Diagnostics Category is set based on the submitted revenue codes. If the record contained an Emergency Department revenue code of 045X, the indicator is set to "Y", otherwise it will be "N".

Columns of Continuous Variables

  • Length_of_Stay
  • Birth_Weight
  • Total_Charges

Return to the main dataset documentation page