Go back to the interactive dataset

Hospital Inpatient Discharges (SPARCS De-Identified): 2011

Row numberHealth 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 ChargesTotal Costs
2584751Abortion Record - Facility Name Redacted30 to 49146FBlack/African AmericanNot Span/Hispanic1EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalMedicaidMedicaid0YY$8700.30$5012.53
2584752Abortion Record - Facility Name Redacted30 to 49112FBlack/African AmericanNot Span/Hispanic1UrgentHome or Self Care2011178INDUCED ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalInsurance CompanySelf-Pay0YN$3737.68$2531.41
2584753Abortion Record - Facility Name Redacted18 to 29146FWhiteNot Span/Hispanic3EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalSelf-Pay0YY$16708.03$10087.55
2584754Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic5UrgentHome w/ Home Health Services2011178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMinorSurgicalSelf-PaySelf-Pay0YN$11461.28$6980.30
2584755Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic1UrgentHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalMedicaidSelf-Pay0YY$8257.70$5248.51
2584756Abortion Record - Facility Name Redacted30 to 49145FWhiteNot Span/Hispanic5UrgentHome or Self Care2011178INDUCED ABORTION126ABORTION (TERM OF PREG)544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorModerateSurgicalBlue CrossSelf-Pay0YN$17655.38$9063.09
2584757Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic1EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalSelf-PaySelf-Pay0YY$7060.83$4537.29
2584758Abortion Record - Facility Name Redacted30 to 49144FWhiteNot Span/Hispanic2EmergencyHome or Self Care2011178INDUCED ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMinorSurgicalBlue CrossSelf-Pay0YY$10201.60$5657.77
2584759Abortion Record - Facility Name Redacted30 to 49144FWhiteNot Span/Hispanic1UrgentHome or Self Care2011181OTHR PREGNANCY COMPL137OT PRCS TO ASSIST DELIV564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium1MinorMinorMedicalInsurance CompanySelf-Pay0YN$6540.91$3797.33
2584760Abortion Record - Facility Name Redacted18 to 29149FWhiteNot Span/Hispanic3ElectiveHome or Self Care2011178INDUCED ABORTION131OT NON-OR THER PRC; FEM564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium2ModerateMinorMedicalMedicaidSelf-Pay0YN$9220.05$6338.46
2584761Abortion Record - Facility Name Redacted18 to 29145FWhiteNot Span/Hispanic2UrgentHome or Self Care2011181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalInsurance CompanySelf-Pay0YN$14653.35$8063.86
2584762Abortion Record - Facility Name Redacted30 to 49146FWhiteNot Span/Hispanic1EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalInsurance CompanySelf-Pay0YY$5967.76$4048.90
2584763Abortion Record - Facility Name Redacted30 to 49146FWhiteSpanish/Hispanic1EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalSelf-PaySelf-Pay0YY$7765.41$5363.61
2584764Abortion Record - Facility Name Redacted30 to 49146FWhiteSpanish/Hispanic1EmergencyHome or Self Care2011177SPONTANEOUS ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalMedicaidMedicaid0YY$6790.49$4170.95
2584765Abortion Record - Facility Name Redacted30 to 49146FWhiteSpanish/Hispanic5UrgentHome or Self Care2011181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium3MajorMinorSurgicalMedicaidMedicaid0YN$39457.63$20587.61
2584766Abortion Record - Facility Name Redacted30 to 49146FOther RaceNot Span/Hispanic1EmergencyHome or Self Care2011178INDUCED ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium1MinorMinorSurgicalBlue CrossSelf-Pay0YY$8980.94$4784.49
2584767Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic1EmergencyHome or Self Care2011181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalMedicaidMedicaid0YY$6461.39$3920.86
2584768Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic1EmergencyHome or Self Care2011181OTHR PREGNANCY COMPL127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalMedicaidMedicaid0YY$6552.52$4176.62
2584769Abortion Record - Facility Name Redacted18 to 29146FBlack/African AmericanNot Span/Hispanic1UrgentHome or Self Care2011177SPONTANEOUS ABORTION000NO PROC564ABORTION W/O D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY14Pregnancy, Childbirth and the Puerperium1MinorMinorMedicalMedicaidMedicaid0YN$4796.16$2793.92
2584770Abortion Record - Facility Name Redacted18 to 29114FWhiteSpanish/Hispanic1EmergencyHome or Self Care2011178INDUCED ABORTION127D&C; ASPIR AFT DLV/ABOR544D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY FOR OBSTETRIC DIAGNOSES14Pregnancy, Childbirth and the Puerperium2ModerateMinorSurgicalBlue CrossSelf-Pay0YY$6846.18$4392.42

About

Open Data NY - DOH Open Data NY - DOH

created Jul 15, 2013

updated Mar 11, 2015

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, charges and costs.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/6wke-9zsb. 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
Raters
0
Visits
12594
Downloads
1161
Comments
0
Contributors
0
Meta
Category
Health
Permissions
Public
Tags
sparcs, hospital, discharge, inpatient, quality-safety-costs
Row Label
Row Count
2584770
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
2011
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; Facility ID, Facility Name, Health Service Area, Hospital County, Operating Certificate, Admission and Discharge Day of Week, and all provider license numbers. Patient zip code is limited to the first three digits. Zip codes for population size less than 20,000 are blank. Out of State are “OOS’. Patient age is presented in age groups: 0 to 17, 18 to 29, 30 to 49, 50 to 69, and 70 or Older.
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 dataset 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. When interpreting New York’s data, it is important to keep in mind that variations in cost may be attributed to many factors. Some of these include overall volume, teaching hospital status, facility specific attributes, geographic region and quality of care provided. Additionally, costs derived from billing data are based upon a ratio that is submitted by a facility to the state and may not necessary reflect a final price of the service delivered. Cost data presented in this dataset was calculated using facility specific 2010 audited RCCs file.
Dataset Information
Agency
Health, Department of

Filter

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

Sort

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

Search

Saved Views

Sharing

This dataset is public

Publishing

See Preview