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 2010

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

Log in to download
Complexity

Get The Data

For getting access to data download links please read and accept the end-user license agreement.
Your Data License
  • Research
    Non-Commercial, Share-Alike, Attribution Free Forever
  • Commercial
    Commercial 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

2013-10-02

Last Modified

2016-05-02

Version

2016-05-02

Update Frequency

Annual

Temporal Coverage

2010

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_AreaAre of New York state where the service was providedstring-
CountyCounty where hospital is locatedstring-
Operating_Certificate_NumberCertificate number for operating facilityintegerlevel : Nominal
Facility_IDNumber identifier of the facilityintegerlevel : Nominal
Facility_NameName of the hospitalstringrequired : 1
Age_GroupAge group of the patientstringrequired : 1
Zip_CodeThree digit ZIP codeintegerlevel : Nominal
GenderGender of the patientstringrequired : 1
RaceRace of the patientstringrequired : 1
EthnicityEthnicity of the patientstringrequired : 1
Length_Of_StayNumber of days spent at the hospital. Days include 1-120+.integerrequired : 1level : Ratio
Admit_Day_Of_WeekDay of the week in which the patient was admittedstring-
Type_Of_AdmissionType of admission registeredstringrequired : 1
Patient_DispositionHealth professional in charge of the patientstring-
Discharge_Day_Of_WeekDay of the week in which the discharge was operatedstring-
Diagnosis_CodeCode of the diagnosesintegerlevel : Nominal
Diagnosis_DescriptionDescription of the diagnosisstring-
Procedure_CodeCode of the procedure followedintegerlevel : Nominal
Procedure_DescriptionDescription of the followed procedurestring-
APR_DRG_CodeAll patient refined (APR) diagnosis related group (DRG) codeintegerrequired : 1level : Nominal
APR_DRG_DescriptionAll patient refined (APR) diagnosis related group (DRG) descriptionstringrequired : 1
APR_MDC_CodeAll patient refined (APR) major diagnostic category (MDC) codeintegerrequired : 1level : Nominal
APR_MDC_DescriptionAll patient refined (APR) major diagnostic category (MDC) descriptionstringrequired : 1
APR_Severity_Of_Illness_CodeAll patient refined (APR) code for the severity of the illnessintegerrequired : 1level : Nominal
APR_Severity_Of_Illness_DescriptionAll patient refined (APR) code for the severity of the illnessstring-
APR_Risk_Of_MortalityAll patient refined (APR) risk of mortalitystring-
APR_Medical_Surgical_DescriptionAll patient refined (APR) medical and surgical descriptionstringrequired : 1
Payment_Typology_1Indicates the source of payment for typology 1 and provides the description of the type of payment for this occurrence.stringrequired : 1
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-
Attending_Provider_License_NumberLicense number of provider attending the dischargeintegerlevel : Nominal
Operating_Provider_License_NumberLicense number of provider operating the dischargeintegerlevel : Nominal
Other_Provider_License_NumberOther license numbers of provider operating the dischargeintegerlevel : Nominal
Birth_WeightThe neonate birth weight in grams; rounded to nearest 100g.numberlevel : Ratio
Is_Abortion_Edit_IndicatorIndicator of abortionbooleanrequired : 1
Is_Emergency_Department_IndicatorIndicator of emergencybooleanrequired : 1
Total_ChargesTotal charges of the dischargenumberrequired : 1
Total_CostTotal costs of the dischargenumberrequired : 1

Data Preview

Health Service AreaCountyOperating Certificate NumberFacility IDFacility NameAge GroupZip CodeGenderRaceEthnicityLength Of StayAdmit Day Of WeekType Of AdmissionPatient DispositionDischarge Day Of WeekDiagnosis 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 3Attending Provider License NumberOperating Provider License NumberOther Provider License NumberBirth WeightIs Abortion Edit IndicatorIs Emergency Department IndicatorTotal ChargesTotal Cost
Finger LakesChemung701000116Arnot Ogden Medical Center0 to 17MaleWhiteUnknown2MONNewbornHome or Self CareWED218LIVEBORN115CIRCUMCISION640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalInsurance Company250317217490.090420583.03700.0FalseFalse1995.121282.64
Central NYOnondaga3301003630St Josephs Hospital Health Center0 to 17MaleWhiteNot Span/Hispanic2WEDNewbornHome or Self CareFRI218LIVEBORN115CIRCUMCISION640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period2ModerateMinorMedicalBlue CrossSelf-Pay205563205563.04400.0FalseFalse2442.71603.66
Hudson ValleyOrange3523000699Orange Regional Medical Center-Goshen Campus0 to 17MaleWhiteNot Span/Hispanic3SUNEmergencyHome or Self CareWED125BRONCHITIS0NO PROC138BRONCHIOLITIS & RSV PNEUMONIA4Diseases and Disorders of the Respiratory System2ModerateMinorMedicalBlue CrossSelf-Pay239003250199.0FalseTrue13455.753599.48
New York CityKings70010171302SUNY Downstate Medical Center at LICH0 to 17MaleWhiteNot Span/Hispanic2THUNewbornHome or Self CareSAT218LIVEBORN220OPHTHALM-/OT-OLOGIC DX633NEONATE BIRTHWT >2499G W MAJOR ANOMALY15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalBlue CrossSelf-Pay208829208829.0208829.03500.0FalseFalse6003.03602.18
New York CityManhattan70020001437New York Downtown Hospital0 to 17MaleWhiteNot Span/Hispanic2TUENewbornHome or Self CareTHU218LIVEBORN228PROPHYLACTIC VAC/INOCUL640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalMedicaidSelf-Pay244842189487.03500.0FalseFalse2125.581337.46
New York CityManhattan70020001437New York Downtown Hospital0 to 17MaleWhiteNot Span/Hispanic1MONNewbornHome or Self CareTUE218LIVEBORN228PROPHYLACTIC VAC/INOCUL640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalInsurance CompanySelf-Pay244842189487.03500.0FalseFalse1515.15792.65
New York CityManhattan70020001437New York Downtown Hospital0 to 17MaleWhiteNot Span/Hispanic2WEDNewbornHome or Self CareFRI218LIVEBORN228PROPHYLACTIC VAC/INOCUL640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalInsurance CompanySelf-Pay244842244842.04000.0FalseFalse2125.581340.73
New York CityManhattan70020001437New York Downtown Hospital0 to 17MaleWhiteNot Span/Hispanic3TUENewbornHome or Self CareFRI218LIVEBORN115CIRCUMCISION640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalInsurance CompanySelf-Pay189487189487.03000.0FalseFalse6647.183339.05
New York CityManhattan70020001437New York Downtown Hospital0 to 17MaleWhiteNot Span/Hispanic2WEDNewbornHome or Self CareFRI218LIVEBORN220OPHTHALM-/OT-OLOGIC DX640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalBlue CrossSelf-Pay189487189487.04200.0FalseFalse2120.241333.15
New York CityManhattan70020021439Beth Israel Medical Center/Petrie Campus0 to 17MaleWhiteNot Span/Hispanic4TUENewbornHome or Self CareSAT218LIVEBORN0NO PROC640NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM15Newborns and Other Neonates with Conditions Originating in the Perinatal Period1MinorMinorMedicalInsurance CompanySelf-Pay1900793100.0FalseFalse9271.83618.61