ANALYZING NURSING HOME DATA

Thomas George Thomas, Shounak Dahale, Aakash Musale

MISSION


The mission is to use the Center for Medicare & Medicaid Services' (CMS) nursing facility data to generate visuals that highlight the nursing homes' resource limits.


INTRODUCTION

In combating the pandemic of Covid-19, there were multiple sectors responsible for this battle to be won. In our study, This study analyzes the various factors influencing the rise in deaths due to Covid 19 at the state level is divided into two Parts:

In Part 1, The following is taken into account and their effects mapped to the Covid-19 deaths in their presence and absence. Along with that, The shortages of the following factors were looked at from a state level:

  • Shortage of medical aides

  • Nursing staff shortage

  • Clinical staff shortage

  • Other staff shortage

In Part 2 of the analysis consists of the weekly availability of protective equipment for the front-line workers on a state level. The following protective equipment were taken as a part of the study:


  • Eye protection

  • Gloves

  • N95 masks

  • Surgical masks


The data for this analysis is taken from CMS regarding COVID-19 Nursing home Data from May 31, 2020 to March 20, 2022.

PART I

Exploring Trends at a holistic level

Exploring Trends at State level

United States has experienced a tremendous shortfall of Aides during the pandemic in majority of the states. The graph above suggests that the state experiencing the highest Shortages of aides is Ohio i.e., about 26K followed by Minnesota, Iowa and Illinois.

Between the years 2020 to 2022, the country has experienced a slight Shortage of Clinical Staff. The states Ohio, New York, Texas and Illinois needed the most Clinical Staff.

The above bar graph suggests the state wise analysis of shortage of Nursing Staff in United States. It is observed that the states Ohio(24K), Minnesota(13K), Iowa(13K) and Missouri(12K) had the highest shortage of Nursing Staff.

From the chart above it can be observed that some states had a shortage of Other Staff too. Ohio, Minnesota, Iowa and Missouri have experienced high shortages of other staff during the years 2020-2022.

PART II

From the above visualization, it is observed that Alcohol-Based Hand Rub (ABHR) which could be used in sanitizers were mostly available in all the states. The ratio of sanitizers not being available to available sanitizer in all the states was only 0.96%.

It was observed that Ohio and Florida states were on both the lists of states where Sanitizers were available and not available in large numbers. Michigan had the highest shortage of Sanitizers. Meanwhile, Texas had the highest availability of Sanitizers.

While computing the availability of N95 Respirators on a weekly basis, it was observed that the states of Texas, California, Ohio and Florida had availability of N95 Respirators on a weekly basis.

It was found that the state of Illinois had a significant shortage of N95 respirators followed by California.

Face masks were vital to combat the spread of Covid 19.

The states of Illinois, California, Texas, Missouri and Minnesota had faced a shortage in supplying it's citizens with Face masks.

It was observed that the number of facilities in Texas, California and Ohio were well equipped with protective gear for eyes.


Illinois had faced a shortage of eye protection in significant numbers.

The majority of the states were well equipped with Gloves during the pandemic.

Although, The facilities in the states of Illinois and California ran of out of gloves more frequently than they would have liked.

Conclusion

From the analysis in Part 1, it is observed that Oklahoma and Minnesota consistently displayed highest shortages for medical aide, nursing staff, clinical and other staff. On the other hand, the state that handled the shortages in the best possible manner were Alaska and Washington DC.


From the analysis in Part 2, it is observed that the majority of the states were well equipped to handle the pandemic as it progressed. The facilities in the states of Texas, California and Ohio had a good supply of protective gear like gloves, eye protective gear and N95 respiratory masks. The facilities in the states of Illinois and Michigan had issues procuring sanitizers and face masks.