File Name: Hospital Inpatient Discharges (SPARCS De-Identified): 2012

Size: 896 MB

Time Period: 2012

Dataset Type: CSV

DataSource: https://health.data.ny.gov/api/views/pyhr-5eas/rows.csv?accessType=DOWNLOAD

1. How many females ?

Data Counts: 13,76,493

2. Average length of stay of female?
Data Counts : 5.04

3. How many males ?
Data Counts: 10,73,976

4. What is the average length of stay of females vs males?

Data Counts: 5.04 &5.768

5. Breakdown discharges on weekend?
Data Counts: 8,73,079 

6. How Many Patients took admission per day of the week ?
Data Counts: “MON”: 4,02,509 “TUE”: 4,08,174 “WED”: 3,90,424 “THU”: 3,85,909 “FRI”: 3,73,079 “SAT”: 2,50,075 “SUN”:2,40,360 

7. How Many Patients Discharge per day of the week.
Data Counts: “MON”: 3,59,692 “TUE”: 3,74,721 “WED”: 3,80,930 “THU”:3,96,039 “FRI”: 4,57,997 “SAT”: 2,67,606 “SUN”: 2,13,545 “SUN”: 2,13,545

8. Average length of stay of male?
Data Counts: 10,73,976

Interesting to see that:

1. “far lesser people get admitted in the hospital over the weekend.”

2. “far lesser people get discharged from the hospital over the weekend.”

3. “As the week progresses, less people get admitted, however more get discharged.”

4. “women spend lesser time at the hospital than men.”