Hospital Inpatient Treatment Discharges 2017

$179 / year

This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2017.

Complexity

The Statewide Planning and Research Cooperative System (SPARCS) is a comprehensive all payer data reporting system established in 1979 as a result of cooperation between the healthcare industry and government. The system was initially created to collect information on discharges from hospitals. SPARCS currently collects patient level detail on patient characteristics, diagnoses and treatments, services, and charges for each hospital inpatient stay and outpatient (ambulatory surgery, emergency department, and outpatient services) visit; and each ambulatory surgery and outpatient services visit to a hospital extension clinic and diagnostic and treatment center licensed to provide ambulatory surgery services. SPARCS Inpatient De-identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, charges and costs. This dataset contains basic record level detail regarding the discharge; however, the data does not contain protected health information (PHI) under Health Insurance Portability and Accountability Act (HIPAA). The health information is not individually identifiable; all data elements considered identifiable have been redacted.

Date Created

2017-07-12

Last Modified

2019-10-02

Version

2019-10-02

Update Frequency

Annual

Temporal Coverage

2017

Spatial Coverage

United States

Source

John Snow Labs; Data State of New York;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Hospital Inpatient Discharges, New York Hospital Discharges, Patient Discharges Details, Healthcare Deidentified Dataset, New York State Hospital Cost, Comprehensive All Payer Data NY, SPARCS Inpatient De-identified Data, New York Health Information, New York Hospital Discharges, Health Insurance Portability, Ambulatory Surgery Services

Other Titles

Details on Inpatient Discharges, Healthcare Discharges in New York State, Deidentified Patient Detailed Information in Hospital Discharges

NameDescriptionTypeConstraints
Health_Service_AreaArea of New York state where the service was provided.string-
CountyCounty where hospital is located.string-
Operating_Certificate_NumberCertificate number for operating facility.string-
Facility_IDNumber identifier of the facility.string-
Facility_NameIndicates the name of the hospital.string-
Age_GroupAge group of the patient.string-
Zip_CodeThree digit or "Out Of State (OOS)" zip codes.string-
GenderIndicates the gender of the patient.stringenum : Array
RaceIndicates the race of the patient.stringenum : Array
EthnicityIndicates ethnicity of the patient.stringenum : Array
Length_Of_StayNumber of days spent at the hospital. Days include 1-120+.integerlevel : Ratio
Type_Of_AdmissionIndicates the type of admission registered.string-
Patient_DispositionHealth professional in charge of the patient.string-
Diagnosis_CodeIndicates the code of the diagnoses.integerlevel : Nominal
Diagnosis_DescriptionIndicates the description of the diagnosis.string-
Procedure_CodeIndicates the code of the procedure is followed.integerlevel : Nominal
Procedure_DescriptionDescription of the followed procedure.string-
APR_DRG_CodeAll patient refined (APR) diagnosis related group (DRG) code.integerlevel : Nominal
APR_DRG_DescriptionAll patient refined (APR) diagnosis related group (DRG) description.string-
APR_MDC_CodeAll patient refined (APR) major diagnostic category (MDC) code.integerlevel : Nominal
APR_MDC_DescriptionAll patient refined (APR) major diagnostic category (MDC) description.string-
APR_Severity_Of_Illness_CodeAll patient refined (APR) code for the severity of the illness.integerlevel : Nominal
APR_Severity_Of_Illness_DescriptionAll patient refined (APR) code for the severity of the illnessstringenum : Array
APR_Risk_Of_MortalityAll patient refined (APR) risk of mortality.stringenum : Array
APR_Medical_Surgical_DescriptionAll patient refined (APR) medical and surgical description.stringenum : Array
Payment_Typology_1Indicates the source of payment for typology 1 and provides the description of the type of payment for this occurrence.string-
Payment_Typology_2Indicates the source of payment for typology 2 and provides the description of the type of payment for this occurrence.string-
Payment_Typology_3Indicates the source of payment for typology 3 and provides the description of the type of payment for this occurrence.string-
Birth_WeightThe neonate birth weight in grams; rounded to nearest 100g.integerlevel : Ratio
Is_Abortion_Edit_IndicatorIndicator of abortion.boolean-
Is_Emergency_Department_IndicatorIndicator of emergency.boolean-
Total_ChargesIndicates the total charges of the discharge.number-
Total_CostIndicates the total costs of the discharge.number-
Health Service AreaCountyOperating Certificate NumberFacility IDFacility NameAge GroupZip CodeGenderRaceEthnicityLength Of StayType Of AdmissionPatient DispositionDiagnosis CodeDiagnosis DescriptionProcedure CodeProcedure DescriptionAPR DRG CodeAPR DRG DescriptionAPR MDC CodeAPR MDC DescriptionAPR Severity Of Illness CodeAPR Severity Of Illness DescriptionAPR Risk Of MortalityAPR Medical Surgical DescriptionPayment Typology 1Payment Typology 2Payment Typology 3Birth WeightIs Abortion Edit IndicatorIs Emergency Department IndicatorTotal ChargesTotal Cost
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital30 to 49MaleWhiteNot Span/Hispanic21ElectiveHome or Self Care659Schizophrenia and other psychotic disordersNO PROC750Schizophrenia19Mental Diseases and Disorders2ModerateMinorMedicalMedicareMedicareSelf-PayFalseFalse114168.040464.04
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital50 to 69105.0MaleWhiteSpanish/Hispanic8EmergencySkilled Nursing Home99Hypertension with complications and secondary hypertension108.0INDWELLING CATHETER194Heart failure5Diseases and Disorders of the Circulatory System3MajorModerateMedicalMedicaidMedicaidSelf-PayFalseFalse58517.026046.5
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital30 to 49105.0FemaleWhiteUnknown6EmergencyCourt/Law Enforcement161Other diseases of kidney and ureters102.0URETERAL CATHETERIZATN465Urinary stones & acquired upper urinary tract obstruction11Diseases and Disorders of the Kidney and Urinary Tract2ModerateModerateMedicalDepartment of CorrectionsSelf-PayFalseFalse39647.0417397.59
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital50 to 69105.0FemaleWhiteNot Span/Hispanic4EmergencySkilled Nursing Home238Complications of surgical procedures or medical care222.0BLOOD TRANSFUSION721Post-operative, post-traumatic, other device infections18Infectious and Parasitic Diseases, Systemic or Unspecified Sites2ModerateModerateMedicalMedicaidMedicaidSelf-PayFalseFalse36031.0916118.84
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital18 to 29105.0FemaleWhiteSpanish/Hispanic4EmergencyCourt/Law Enforcement2Septicemia (except in labor)NO PROC720Septicemia & disseminated infections18Infectious and Parasitic Diseases, Systemic or Unspecified Sites2ModerateMinorMedicalDepartment of CorrectionsSelf-PayFalseFalse30534.011921.05
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital50 to 69105.0MaleBlack/African AmericanNot Span/Hispanic3EmergencyShort-term Hospital660Alcohol-related disorders222.0BLOOD TRANSFUSION280Alcoholic liver disease7Diseases and Disorders of the Hepatobiliary System and Pancreas3MajorMajorMedicalMedicareMedicareSelf-PayFalseFalse49290.0818503.26
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital30 to 49105.0FemaleBlack/African AmericanNot Span/Hispanic3EmergencyCourt/Law Enforcement102Nonspecific chest painNO PROC203Chest pain5Diseases and Disorders of the Circulatory System2ModerateMinorMedicalMedicaidSelf-PayFalseFalse20511.09103.8
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital30 to 49105.0FemaleBlack/African AmericanUnknown4EmergencyHome or Self Care50Diabetes mellitus with complications222.0BLOOD TRANSFUSION420Diabetes10Endocrine, Nutritional and Metabolic Diseases and Disorders3MajorMajorMedicalMedicaidMedicaidMedicaidFalseFalse55172.017682.94
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital50 to 69105.0MaleBlack/African AmericanNot Span/Hispanic4EmergencyHome or Self Care245Syncope231.0OTHER THERAPEUTIC PRCS204Syncope & collapse5Diseases and Disorders of the Circulatory System1MinorMinorMedicalMedicaidMedicaidSelf-PayFalseFalse31034.012649.61
Hudson ValleyWestchester59030011061Montefiore Mount Vernon Hospital50 to 69107.0FemaleBlack/African AmericanNot Span/Hispanic3EmergencyHome or Self Care245SyncopeNO PROC204Syncope & collapse5Diseases and Disorders of the Circulatory System1MinorMinorMedicalPrivate Health InsurancePrivate Health InsuranceSelf-PayFalseFalse25027.09751.06