IE6600 Hackathon

The Nursing Home Covid-19 public file, provided by CMS includes data reported by nursing homes to the CDC's National Healthcare Safety Network. This data includes Resident Impact, Facility Capacity, Staff and Personnel, supplies and Personal Protection Equipment and Ventilator Capacity and Supplies data elements. This dataset gives us an opportunity to analyze nursing home data and create Visualizations to communicate the resource constraints faced by nursing homes.

Problem 1

Here we can observe that the state of Texas has the highest Nursing Home Facilities, followed by California and Ohio. On the other hand, Vermont, Delaware, and New Hampshire are the states with the least number of Nursing Home Facilities.

Within Texas, the county Harris has the most number of Nursing Home Facilities, followed by Dallas and Tarrant.

Problem 2

Here we have displayed the shortage of staff and aides represented by the facilities shortage index. Minnesota and Kansas are the states that faced the maximum shortage in aides and staff. California, Massachusetts, and New Jersey are few of the states that stand out and face the least shortage in medical aides and staff.

Facility Shortage Index is calculated by adding the shortage of aides, clinical staff, nursing staff and other staff, divided by 43 (total number of weeks that the shortage is faced further divided by 4 (no. of parameters the shortage is experienced in)

Shortage of Staff and Aides at Nation Level

Referring the comparison of Shortages at a national level shown on the right, we can infer that on an average, the highest shortage is experienced to be the most for Aides, i.e. 7 weeks on an average, followed by Nursing Staff with 6 weeks on an average, then Other staff, and finally Clinical staff which experiences the least shortage with an average of 1 week.

Comparison of Shortages at County Level

The average shortages in Aides and Staff by number of Counties are displayed by the help of histograms and depicted above.

Here, we have listed the 10 facilities that face the most shortages in Aides and Staff.

Problem 3

Here we have displayed the medical supply shortage represented by the facilities shortage index. Maine and New Hampshire are the states that faced the maximum shortage in aides and staff. Utah, Nevada and Oregon are few of the states that stand out and face the least shortage in supply of medical equipment.

Supply Shortage Index is calculated by adding the shortage in 1 week supplies of eye protection gear, gloves, hand sanitizers, N95 masks, surgical masks and ventilator supplies, divided by 43 (total number of weeks that the shortage is faced further divided by 6 (no. of parameters the shortage is experienced in)

Shortage of One-week Supplies at Nation Level

Referring the comparison of Shortages at a national level shown on the right, we can infer that on an average, the highest shortage is experienced to be the most for N95 masks, i.e. 4 weeks on an average, followed by Eye Protection Gear and Surgical Masks, with 2 weeks on an average, then Gloves and Hand Sanitizers, and finally Ventilator which experiences no shortage at all.

Here, we have listed the 10 facilities that face the most shortages in Medical Supplies.

Problem 4

As we can see from the visualization above, evidently Texas, Illinois and California have the most number of beds available given the high number of Nursing Facilities and low amounts of shortages faced in medical staff, aides and supplies.

Here, we have listed the Facilities that have the highest utilization of Ventilators for Covid-19, from the total number of ventilators available at the facility.

Problem 5

From the graph above, it is evident that the shortage in Aides and Nursing Staff increased significantly during the months of November and December and then started decreasing drastically starting from January, till mid of March.

The shortage in supplies was greatly felt towards the end of July and peaked in August, before constantly decreasing starting September, right till March.

The number of bed's increased slowly till October, before drastically increasing and peaked during January 2021 and then again decreased slightly after that.

In June 2020, maximum number of ventilators were used for the Covid-19 pandemic, at about 16% and July onwards it dropped to 12% and then had a slight increase or decrease with a deviation of about 2%, till the end of March 2021.

Page updated

Google Sites

Report abuse