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 2019
This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2019.
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 | 2023-07-26 |
Version | 2023-07-26 |
Update Frequency |
Annual |
Temporal Coverage |
2019 |
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 |
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 30 to 49 | 106 | M | Other Race | Not Span/Hispanic | 2 | Emergency | Home or Self Care | INF008 | VIRAL INFECTION | 723 | VIRAL ILLNESS | 18 | INFECTIOUS AND PARASITIC DISEASES (SYSTEMIC OR UNSPECIFIED SITES) | 2 | Moderate | Minor | Medical | Private Health Insurance | True | 26507 | 4773.11 | |||||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 70 or Older | 105 | F | Black/African American | Not Span/Hispanic | 3 | Emergency | Home or Self Care | GEN002 | ACUTE AND UNSPECIFIED RENAL FAILURE | 469 | ACUTE KIDNEY INJURY | 11 | DISEASES AND DISORDERS OF THE KIDNEY AND URINARY TRACT | 2 | Moderate | Moderate | Medical | Medicare | True | 20693 | 5631.3 | |||||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 50 to 69 | 105 | F | Other Race | Not Span/Hispanic | 7 | Elective | Home or Self Care | GEN006 | OTHER SPECIFIED AND UNSPECIFIED DISEASES OF KIDNEY AND URETERS | GIS005 | EXPLORATION OF PERITONEAL CAVITY | 443 | KIDNEY & URINARY TRACT PROCEDURES FOR NONMALIGNANCY | 11 | DISEASES AND DISORDERS OF THE KIDNEY AND URINARY TRACT | 4 | Extreme | Extreme | Surgical | Medicare | Blue Cross/Blue Shield | False | 138252 | 29848.69 | ||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 50 to 69 | 106 | F | Black/African American | Not Span/Hispanic | 1 | Emergency | Left Against Medical Advice | RSP009 | ASTHMA | 141 | ASTHMA | 4 | DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM | 2 | Moderate | Minor | Medical | Medicare | Medicaid | True | 11799 | 2595.72 | ||||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 70 or Older | 105 | F | Other Race | Not Span/Hispanic | 3 | Emergency | Psychiatric Hospital or Unit of Hosp | MBD012 | SUICIDAL IDEATION/ATTEMPT/INTENTIONAL SELF-HARM | MST007 | HIP ARTHROPLASTY | 817 | OVERDOSE | 21 | INJURIES, POISONINGS AND TOXIC EFFECTS OF DRUGS | 2 | Moderate | Moderate | Medical | Medicare | Private Health Insurance | True | 52711 | 11355.62 | ||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 50 to 69 | 105 | M | Other Race | Not Span/Hispanic | 5 | Emergency | Home or Self Care | END003 | DIABETES MELLITUS WITH COMPLICATION | MST020 | SUBCUTANEOUS TISSUE AND FASCIA EXCISION | 344 | OSTEOMYELITIS, SEPTIC ARTHRITIS & OTHER MUSCULOSKELETAL INFECTIONS | 8 | DISEASES AND DISORDERS OF THE MUSCULOSKELETAL SYSTEM AND CONNECTIVE TISSUE | 2 | Moderate | Moderate | Medical | Private Health Insurance | True | 51161 | 12017.19 | |||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 70 or Older | OOS | F | Other Race | Not Span/Hispanic | 9 | Emergency | Home or Self Care | DIG012 | INTESTINAL OBSTRUCTION AND ILEUS | GIS022 | GI SYSTEM LYSIS OF ADHESIONS | 223 | OTHER SMALL & LARGE BOWEL PROCEDURES | 6 | DISEASES AND DISORDERS OF THE DIGESTIVE SYSTEM | 3 | Major | Major | Surgical | Medicare | True | 96700 | 18905.83 | |||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 50 to 69 | 105 | F | Other Race | Not Span/Hispanic | 3 | 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 | Major | Medical | Medicare | Medicaid | True | 28909 | 6740.04 | ||||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 50 to 69 | 106 | M | Black/African American | Not Span/Hispanic | 1 | Emergency | Home or Self Care | CIR012 | NONSPECIFIC CHEST PAIN | 203 | CHEST PAIN | 5 | DISEASES AND DISORDERS OF THE CIRCULATORY SYSTEM | 2 | Moderate | Minor | Medical | Medicare | True | 26740 | 5209.08 | |||||
Hudson Valley | Westchester | 5902001 | 1045 | White Plains Hospital Center | 70 or Older | 105 | F | Other Race | Not Span/Hispanic | 4 | Emergency | Home w/ Home Health Services | SKN001 | SKIN AND SUBCUTANEOUS TISSUE INFECTIONS | 383 | CELLULITIS & OTHER SKIN INFECTIONS | 9 | DISEASES AND DISORDERS OF THE SKIN, SUBCUTANEOUS TISSUE AND BREAST | 2 | Moderate | Moderate | Medical | Medicare | Private Health Insurance | True | 32346 | 6999.27 |