Go back to the interactive dataset

Hospital Inpatient Discharges (SPARCS De-Identified): 2012

Row numberHospital Service AreaHospital CountyOperating Certificate NumberFacility IdFacility NameAge GroupZip Code - 3 digitsGenderRaceEthnicityLength of StayAdmit Day of WeekType of AdmissionPatient DispositionDischarge YearDischarge Day of WeekCCS Diagnosis CodeCCS Diagnosis DescriptionCCS Procedure CodeCCS Procedure DescriptionAPR DRG CodeAPR DRG DescriptionAPR MDC CodeAPR MDC DescriptionAPR Severity of Illness CodeAPR Severity of Illness DescriptionAPR Risk of MortalityAPR Medical Surgical DescriptionSource of Payment 1Source of Payment 2Source of Payment 3Attending Provider License NumberOperating Provider License NumberOther Provider License NumberBirth WeightAbortion Edit IndicatorEmergency Department IndicatorTotal Charges
2529401Abortion Record - Facility Name Redacted30 to 49148FWhiteNot Span/Hispanic1FRIElectiveHome or Self Care2012SAT181OTHR PREGNANCY COMPL137OT PRCS TO ASSIST DELIV564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalSelf-PaySelf-Pay0YN$2520.25
2529402Abortion Record - Facility Name Redacted30 to 49148FWhiteNot Span/Hispanic1TUEEmergencyHome or Self Care2012TUE181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalBlue CrossSelf-Pay0YY$2732.75
2529403Abortion Record - Facility Name Redacted18 to 29130FWhiteNot Span/Hispanic1FRIUrgentShort-term Hospital2012SAT181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorModerateSurgicalInsurance CompanySelf-Pay0YN$14114.25
2529404Abortion Record - Facility Name Redacted18 to 29148FBlack/African AmericanNot Span/Hispanic2FRIElectiveHome or Self Care2012SUN177SPONTANEOUS ABORTION137OT PRCS TO ASSIST DELIV564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalInsurance Company0YN$4229.79
2529405Abortion Record - Facility Name Redacted18 to 29138FWhiteNot Span/Hispanic1THUElectiveHome or Self Care2012FRI178INDUCED ABORTION111OT NON-OR THER PRC URIN564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateModerateMedicalMedicareMedicaidSelf-Pay0YN$8023.23
2529406Abortion Record - Facility Name Redacted30 to 49122FWhiteNot Span/Hispanic1MONElectiveHome or Self Care2012TUE181OTHR PREGNANCY COMPL111OT NON-OR THER PRC URIN564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalBlue CrossSelf-Pay0YN$13662.17
2529407Abortion Record - Facility Name Redacted30 to 49121FWhiteNot Span/Hispanic4WEDElectiveHome or Self Care2012SUN182PREGNANCY HEMORRHAG231OTHER THERAPEUTIC PRCS560VAGINAL DELIVERY14Pregnancy, Childbirth and the Puerperium3MajorModerateMedicalInsurance CompanyMedicaidUnknown0YN$28181.19
2529408Abortion Record - Facility Name Redacted18 to 29120FWhiteNot Span/Hispanic1THUElectiveHome or Self Care2012FRI181OTHR PREGNANCY COMPL111OT NON-OR THER PRC URIN564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium1MinorMinorMedicalInsurance CompanyMedicaidSelf-Pay0YN$10203.34
2529409Abortion Record - Facility Name Redacted30 to 49121FWhiteNot Span/Hispanic7TUEElectiveHome or Self Care2012TUE181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMinorSurgicalInsurance CompanySelf-Pay0YN$25060.30
2529410Abortion Record - Facility Name Redacted30 to 49120FWhiteNot Span/Hispanic1WEDElectiveHome or Self Care2012THU178INDUCED ABORTION126ABORTION (TERM OF PREG)564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium1MinorMinorMedicalMedicaidSelf-Pay0YN$3700.23
2529411Abortion Record - Facility Name Redacted30 to 49120FWhiteNot Span/Hispanic2SUNElectiveHome or Self Care2012TUE191POLYHYDRAMNIOS ET AL126ABORTION (TERM OF PREG)566OTHER ANTEPARTUM DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalBlue CrossSelf-Pay0YN$12596.85
2529412Abortion Record - Facility Name Redacted18 to 29124FWhiteNot Span/Hispanic5WEDElectiveHome or Self Care2012MON178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorModerateSurgicalInsurance CompanyMedicaidSelf-Pay0YN$26223.98
2529413Abortion Record - Facility Name Redacted30 to 49122FOther RaceNot Span/Hispanic8WEDElectiveHome or Self Care2012THU181OTHR PREGNANCY COMPL126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMajorSurgicalBlue CrossSelf-Pay0YN$50683.31
2529414Abortion Record - Facility Name Redacted30 to 49121FOther RaceSpanish/Hispanic1TUEElectiveHome or Self Care2012TUE178INDUCED ABORTION111OT NON-OR THER PRC URIN564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium3MajorMinorMedicalInsurance CompanySelf-Pay0YN$7296.28
2529415Abortion Record - Facility Name Redacted30 to 49123FBlack/African AmericanNot Span/Hispanic4WEDElectiveHome or Self Care2012SUN177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalBlue CrossSelf-Pay0YN$23176.08
2529416Abortion Record - Facility Name Redacted30 to 49122FBlack/African AmericanNot Span/Hispanic1THUUrgentPsychiatric Hospital or Unit of Hosp2012FRI178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalMedicaidSelf-Pay0YN$3335.91
2529417Abortion Record - Facility Name Redacted18 to 29125FWhiteNot Span/Hispanic1MONUrgentHome or Self Care2012MON181OTHR PREGNANCY COMPL000NO PROC564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalBlue CrossSelf-Pay0YN$17248.25
2529418Abortion Record - Facility Name Redacted18 to 29128FWhiteNot Span/Hispanic1FRIUrgentHome or Self Care2012SAT177SPONTANEOUS ABORTION131OT NON-OR THER PRC; FEM564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalInsurance CompanyMedicaidSelf-Pay0YN$8977.39
2529419Abortion Record - Facility Name Redacted18 to 29138FWhiteNot Span/Hispanic1MONElectiveHome or Self Care2012TUE195OTH COMP BIRTH/PUERPRM126ABORTION (TERM OF PREG)566OTHER ANTEPARTUM DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorMedicalMedicaidSelf-Pay0YN$8622.43
2529420Abortion Record - Facility Name Redacted18 to 29128FWhiteNot Span/Hispanic2THUElectiveHome or Self Care2012SAT178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalUnknownUnknown0YN$33717.86
2529421Abortion Record - Facility Name Redacted30 to 49122FBlack/African AmericanNot Span/Hispanic4TUEUrgentHome or Self Care2012SAT178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMinorSurgicalMedicareMedicaidSelf-Pay0YN$120440.19
2529422Abortion Record - Facility Name Redacted30 to 49122FWhiteNot Span/Hispanic1SATUrgentHome or Self Care2012SUN177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalBlue CrossSelf-Pay0YN$7040.33

About

Open Data NY - DOH Open Data NY - DOH

created Oct 02, 2013

updated Mar 20, 2014

View Full Page
Description

The Statewide Planning and Research Cooperative System (SPARCS) Inpatient De-identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, and charges. This data 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. For example, the direct identifiers regarding a date have the day and month portion of the date removed. A downloadable file with this data is available for ease of download at: https://health.data.ny.gov/Health/Hospital-Inpatient-Discharges-SPARCS-De-Identified/3m9u-ws8e. For more information check out: http://www.health.ny.gov/statistics/sparcs/ or go to the “About” tab.

Activity
Community Rating
Current value: 0.0 out of 5
Your Rating
Current value: out of 5
Raters
0
Visits
6489
Downloads
1726
Comments
0
Contributors
0
Meta
Category
Health
Permissions
Public
Tags
sparcs, hospital, discharge, inpatient
Row Count
2529422
Licensing and Attribution
Data Provided By
New York State Department of Health
Source Link
http://www.health.ny.gov/statistics/sparcs/
Dataset Summary
Organization
Office of Quality and Patient Safety
Time Period
2012
Posting Frequency
Annually
Data Frequency
Monthly
Dataset Owner
Bureau of Health Informatics
Coverage
Statewide
Granularity
Discharge
Units
Discharge
Notes
Notes
Discharges that are identified as Abortion will have some information redacted; Zip Code, Age, Facility ID, Facility Name, Health Service Area, Hospital County, Operating Certificate, and all provider license numbers. Patient zip code is limited to the first three digits. For population size less than 20,000 then blank.
Disclaimers
Limitations
The de-identified data contains basic record level detail; it does not contain data that is protected health information (PHI) under HIPAA. The health information contained in the file is not individually identifiable; all data elements that are considered identifiable have been redacted. Secondary diagnoses and procedures, as well as revenue codes have been excluded from this file.
Dataset Information
Agency
Health, Department of

Filter

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Sort

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Search

Saved Views

Sharing

This dataset is public

Publishing

See Preview