Others titles
- Details on Inpatient Discharges
- Healthcare Discharges in New York State
- Deidentified Patient Detailed Information in Hospital Discharges
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
Hospital Inpatient Treatment Discharges 2018
This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2018.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
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.
About this Dataset
Data Info
Date Created | 2022 |
---|---|
Last Modified | 2022-09-17 |
Version | 2022-09-17 |
Update Frequency |
Annual |
Temporal Coverage |
2018 |
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 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Health_Service_Area | Area of New York state where the service was provided. | string | - |
County | County where hospital is located. | string | - |
Operating_Certificate_Number | Certificate number for operating facility. | string | - |
Facility_ID | Number identifier of the facility. | string | - |
Facility_Name | Indicates the name of the hospital. | string | - |
Age_Group | Age group of the patient. | string | - |
Zip_Code | Three digit or "Out Of State (OOS)" zip codes. | string | - |
Gender | Indicates the gender of the patient. | string | - |
Race | Indicates the race of the patient. | string | enum : Array ( [0] => Black/African American [1] => Multi-racial [2] => Other Race [3] => White ) |
Ethnicity | Indicates ethnicity of the patient. | string | enum : Array ( [0] => Not Span/Hispanic [1] => Spanish/Hispanic [2] => Multi-ethnic [3] => Unknown ) |
Length_Of_Stay | Number of days spent at the hospital. Days include 1-120+. | string | - |
Type_Of_Admission | Indicates the type of admission registered. | string | - |
Patient_Disposition | Health professional in charge of the patient. | string | - |
Diagnosis_Code | Indicates the code of the diagnoses. | string | - |
Diagnosis_Description | Indicates the description of the diagnosis. | string | - |
Procedure_Code | Indicates the code of the procedure is followed. | string | - |
Procedure_Description | Description of the followed procedure. | string | - |
APR_DRG_Code | All patient refined (APR) diagnosis related group (DRG) code. | string | - |
APR_DRG_Description | All patient refined (APR) diagnosis related group (DRG) description. | string | - |
APR_MDC_Code | All patient refined (APR) major diagnostic category (MDC) code. | string | - |
APR_MDC_Description | All patient refined (APR) major diagnostic category (MDC) description. | string | - |
APR_Severity_Of_Illness_Code | All patient refined (APR) code for the severity of the illness. | integer | level : Nominal |
APR_Severity_Of_Illness_Description | All patient refined (APR) code for the severity of the illness | string | enum : Array ( [0] => Extreme [1] => Major [2] => Minor [3] => Moderate ) |
APR_Risk_Of_Mortality | All patient refined (APR) risk of mortality. | string | enum : Array ( [0] => Extreme [1] => Major [2] => Minor [3] => Moderate ) |
APR_Medical_Surgical_Description | All patient refined (APR) medical and surgical description. | string | - |
Payment_Typology_1 | Indicates the source of payment for typology 1 and provides the description of the type of payment for this occurrence. | string | - |
Payment_Typology_2 | Indicates the source of payment for typology 2 and provides the description of the type of payment for this occurrence. | string | - |
Payment_Typology_3 | Indicates the source of payment for typology 3 and provides the description of the type of payment for this occurrence. | string | - |
Birth_Weight | The neonate birth weight in grams; rounded to nearest 100g. | integer | level : Ratio |
Is_Emergency_Department_Indicator | Indicator of emergency. | boolean | - |
Total_Charges | Indicates the total charges of the discharge. | number | - |
Total_Cost | Indicates the total costs of the discharge. | number | - |
Data Preview
Health Service Area | County | Operating Certificate Number | Facility ID | Facility Name | Age Group | Zip Code | Gender | Race | Ethnicity | Length Of Stay | Type Of Admission | Patient Disposition | Diagnosis Code | Diagnosis Description | Procedure Code | 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 | Payment Typology 1 | Payment Typology 2 | Payment Typology 3 | Birth Weight | Is Emergency Department Indicator | Total Charges | Total Cost |
Capital/Adirond | Columbia | 1001000 | 146 | Columbia Memorial Hospital | 50 to 69 | 125 | F | White | Not Span/Hispanic | 2 | Elective | Short-term Hospital | CIR020 | CEREBRAL INFARCTION | 45 | CVA & PRECEREBRAL OCCLUSION W INFARCT | 1 | DISEASES AND DISORDERS OF THE NERVOUS SYSTEM | 3 | Major | Major | Medical | Managed Care, Unspecified | Self-Pay | True | 17591.41 | 3570.06 | ||||
New York City | Manhattan | 7002009 | 1445 | Harlem Hospital Center | 50 to 69 | 100 | F | Black/African American | Not Span/Hispanic | 16 | Emergency | Short-term Hospital | RSP017 | POSTPROCEDURAL OR POSTOPERATIVE RESPIRATORY SYSTEM COMPLICATION | ESA003 | MECHANICAL VENTILATION | 121 | OTHER RESPIRATORY & CHEST PROCEDURES | 4 | DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM | 4 | Extreme | Extreme | Surgical | Medicare | Medicaid | True | 106190.21 | 78913.24 | ||
New York City | Manhattan | 7002009 | 1445 | Harlem Hospital Center | 50 to 69 | 100 | F | Black/African American | Not Span/Hispanic | 4 | Emergency | Home or Self Care | MBD003 | BIPOLAR AND RELATED DISORDERS | MHT001 | PHARMACOTHERAPY FOR MENTAL HEALTH (EXCLUDING SUBSTANCE USE) | 753 | BIPOLAR DISORDERS | 19 | MENTAL DISEASES AND DISORDERS | 2 | Moderate | Minor | Medical | Medicaid | False | 5600.0 | 4161.53 | |||
New York City | Kings | 7001016 | 1301 | Kings County Hospital Center | 18 to 29 | 112 | M | Black/African American | Not Span/Hispanic | 2 | Emergency | Home or Self Care | CIR017 | CARDIAC DYSRHYTHMIAS | IMG008 | ULTRASONOGRAPHY | 201 | CARDIAC ARRHYTHMIA & CONDUCTION DISORDERS | 5 | DISEASES AND DISORDERS OF THE CIRCULATORY SYSTEM | 2 | Moderate | Minor | Medical | Medicaid | Medicaid | True | 15965.54 | 11341.3 | ||
New York City | Manhattan | 7002054 | 1464 | New York-Presbyterian Hospital - Columbia Presbyterian Center | 0 to 17 | 104 | M | Multi-racial | Not Span/Hispanic | 2 | Emergency | Home or Self Care | RSP002 | PNEUMONIA (EXCEPT THAT CAUSED BY TUBERCULOSIS) | 139 | OTHER PNEUMONIA | 4 | DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM | 3 | Major | Moderate | Medical | Medicaid | Medicaid | Self-Pay | True | 36846.83 | 10240.02 | |||
New York City | Kings | 7001016 | 1301 | Kings County Hospital Center | 50 to 69 | 112 | M | Black/African American | Not Span/Hispanic | 2 | Emergency | Home w/ Home Health Services | SKN001 | SKIN AND SUBCUTANEOUS TISSUE INFECTIONS | MST005 | INCISION AND DRAINAGE OF SUBCUTANEOUS TISSUE AND FASCIA | 364 | OTHER SKIN, SUBCUTANEOUS TISSUE & RELATED PROCEDURES | 9 | DISEASES AND DISORDERS OF THE SKIN, SUBCUTANEOUS TISSUE AND BREAST | 2 | Moderate | Moderate | Surgical | Medicare | True | 33626.54 | 23886.98 | |||
New York City | Manhattan | 7002009 | 1445 | Harlem Hospital Center | 50 to 69 | 100 | F | Black/African American | Not Span/Hispanic | 2 | Emergency | Home or Self Care | CIR012 | NONSPECIFIC CHEST PAIN | 203 | CHEST PAIN | 5 | DISEASES AND DISORDERS OF THE CIRCULATORY SYSTEM | 1 | Minor | Minor | Medical | Medicare | Medicaid | True | 12290.21 | 9133.24 | ||||
New York City | Manhattan | 7002009 | 1445 | Harlem Hospital Center | 18 to 29 | 100 | F | Black/African American | Not Span/Hispanic | 1 | Emergency | Home or Self Care | GEN006 | OTHER SPECIFIED AND UNSPECIFIED DISEASES OF KIDNEY AND URETERS | URN003 | URETER AND OTHER URINARY TRACT DILATION | 465 | URINARY STONES & ACQUIRED UPPER URINARY TRACT OBSTRUCTION | 11 | DISEASES AND DISORDERS OF THE KIDNEY AND URINARY TRACT | 2 | Moderate | Minor | Medical | Medicaid | True | 6440.21 | 4785.92 | |||
New York City | Kings | 7001016 | 1301 | Kings County Hospital Center | 50 to 69 | 112 | F | Black/African American | Not Span/Hispanic | 1 | Emergency | Left Against Medical Advice | SYM013 | RESPIRATORY SIGNS AND SYMPTOMS | ESA004 | NON-INVASIVE VENTILATION | 145 | ACUTE BRONCHITIS AND RELATED SYMPTOMS | 4 | DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM | 3 | Major | Major | Medical | Medicaid | Medicaid | True | 10666.99 | 7577.41 | ||
New York City | Kings | 7001020 | 1305 | Maimonides Medical Center | 0 to 17 | 112 | F | Other Race | Not Span/Hispanic | 1 | Emergency | Home or Self Care | RSP002 | PNEUMONIA (EXCEPT THAT CAUSED BY TUBERCULOSIS) | ADM017 | ADMINISTRATION OF NUTRITIONAL AND ELECTROLYTIC SUBSTANCES | 139 | OTHER PNEUMONIA | 4 | DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM | 2 | Moderate | Minor | Medical | Medicaid | Medicaid | Self-Pay | False | 7983.0 | 3447.96 |