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 2017
This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2017.
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 | 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 |
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 | enum : Array ( [0] => Male [1] => Female [2] => Unknown ) |
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+. | integer | level : Ratio |
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. | integer | level : Nominal |
Diagnosis_Description | Indicates the description of the diagnosis. | string | - |
Procedure_Code | Indicates the code of the procedure is followed. | integer | level : Nominal |
Procedure_Description | Description of the followed procedure. | string | - |
APR_DRG_Code | All patient refined (APR) diagnosis related group (DRG) code. | integer | level : Nominal |
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. | integer | level : Nominal |
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 | enum : Array ( [0] => Medical [1] => Surgical ) |
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_Abortion_Edit_Indicator | Indicator of abortion. | boolean | - |
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 Abortion Edit Indicator | Is Emergency Department Indicator | Total Charges | Total Cost |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 30 to 49 | Male | White | Not Span/Hispanic | 21 | Elective | Home or Self Care | 659 | Schizophrenia and other psychotic disorders | NO PROC | 750 | Schizophrenia | 19 | Mental Diseases and Disorders | 2 | Moderate | Minor | Medical | Medicare | Medicare | Self-Pay | False | False | 114168.0 | 40464.04 | |||
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 50 to 69 | 105.0 | Male | White | Spanish/Hispanic | 8 | Emergency | Skilled Nursing Home | 99 | Hypertension with complications and secondary hypertension | 108.0 | INDWELLING CATHETER | 194 | Heart failure | 5 | Diseases and Disorders of the Circulatory System | 3 | Major | Moderate | Medical | Medicaid | Medicaid | Self-Pay | False | False | 58517.0 | 26046.5 | |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 30 to 49 | 105.0 | Female | White | Unknown | 6 | Emergency | Court/Law Enforcement | 161 | Other diseases of kidney and ureters | 102.0 | URETERAL CATHETERIZATN | 465 | Urinary stones & acquired upper urinary tract obstruction | 11 | Diseases and Disorders of the Kidney and Urinary Tract | 2 | Moderate | Moderate | Medical | Department of Corrections | Self-Pay | False | False | 39647.04 | 17397.59 | ||
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 50 to 69 | 105.0 | Female | White | Not Span/Hispanic | 4 | Emergency | Skilled Nursing Home | 238 | Complications of surgical procedures or medical care | 222.0 | BLOOD TRANSFUSION | 721 | Post-operative, post-traumatic, other device infections | 18 | Infectious and Parasitic Diseases, Systemic or Unspecified Sites | 2 | Moderate | Moderate | Medical | Medicaid | Medicaid | Self-Pay | False | False | 36031.09 | 16118.84 | |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 18 to 29 | 105.0 | Female | White | Spanish/Hispanic | 4 | Emergency | Court/Law Enforcement | 2 | Septicemia (except in labor) | NO PROC | 720 | Septicemia & disseminated infections | 18 | Infectious and Parasitic Diseases, Systemic or Unspecified Sites | 2 | Moderate | Minor | Medical | Department of Corrections | Self-Pay | False | False | 30534.0 | 11921.05 | |||
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 50 to 69 | 105.0 | Male | Black/African American | Not Span/Hispanic | 3 | Emergency | Short-term Hospital | 660 | Alcohol-related disorders | 222.0 | BLOOD TRANSFUSION | 280 | Alcoholic liver disease | 7 | Diseases and Disorders of the Hepatobiliary System and Pancreas | 3 | Major | Major | Medical | Medicare | Medicare | Self-Pay | False | False | 49290.08 | 18503.26 | |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 30 to 49 | 105.0 | Female | Black/African American | Not Span/Hispanic | 3 | Emergency | Court/Law Enforcement | 102 | Nonspecific chest pain | NO PROC | 203 | Chest pain | 5 | Diseases and Disorders of the Circulatory System | 2 | Moderate | Minor | Medical | Medicaid | Self-Pay | False | False | 20511.0 | 9103.8 | |||
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 30 to 49 | 105.0 | Female | Black/African American | Unknown | 4 | Emergency | Home or Self Care | 50 | Diabetes mellitus with complications | 222.0 | BLOOD TRANSFUSION | 420 | Diabetes | 10 | Endocrine, Nutritional and Metabolic Diseases and Disorders | 3 | Major | Major | Medical | Medicaid | Medicaid | Medicaid | False | False | 55172.0 | 17682.94 | |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 50 to 69 | 105.0 | Male | Black/African American | Not Span/Hispanic | 4 | Emergency | Home or Self Care | 245 | Syncope | 231.0 | OTHER THERAPEUTIC PRCS | 204 | Syncope & collapse | 5 | Diseases and Disorders of the Circulatory System | 1 | Minor | Minor | Medical | Medicaid | Medicaid | Self-Pay | False | False | 31034.0 | 12649.61 | |
Hudson Valley | Westchester | 5903001 | 1061 | Montefiore Mount Vernon Hospital | 50 to 69 | 107.0 | Female | Black/African American | Not Span/Hispanic | 3 | Emergency | Home or Self Care | 245 | Syncope | NO PROC | 204 | Syncope & collapse | 5 | Diseases and Disorders of the Circulatory System | 1 | Minor | Minor | Medical | Private Health Insurance | Private Health Insurance | Self-Pay | False | False | 25027.0 | 9751.06 |