COVID-19 Insights and Nursing Home Data

Tyler Technologies has centralized all of the COVID-19 related data in one location to support local and state governments to contextualize, and conduct statistical analysis to mitigate COVID-19 effects and to enable economic recovery. The Consolidate COVID-19 data can be utilized to identify communities for poor COVID-19 outcomes, communities that could benefit from the Coronavirus Aid, Relief and Economic Security (CARES) Act and to make decisions when to open state and local government buildings based on the criteria set by the president of the United States.

Center for Medicare & Medicaid Services (CMS) Nursing Home Data

Nursing homes throughout the country have been devastated as a result of COVID-19.  Tyler Technologies is making Nursing Home data available weekly at the county and state level. The data contains: nursing home providers' information, resident and staff confirmed, suspected, and deaths from COVID-19. As well as facilities' ventilator utilization, personal protective equipment supply inventory, nursing home staff shortage information and more.
You can leverage nursing home data in conjunction with other data sources to visualize and gain context about nursing homes in your county such as how many people are affected with COVID-19 vs influenza, or where to direct personal protective equipment supplies and to make a decision about when it is safe to open state and local governments as well as businesses.
The dataset is available for download here and can be accessed through the Socrata platform API endpoint for application development. See here for documentation on accessing the dataset via API.

Embeddable Nursing Home COVID-19 Tracker

To embed this on a Perspectives page on your domain go to the dashboard page and click on your state in the map to bring up a more detailed view. Then click the "Share" button in the top right-hand corner and copy the URL; this will look like https://tylertech.plotly.com/?scope=PA?selected=CCB?display=statewide.
From your Perspectives page, you can then add a rich media content block and click Insert->HTML Embed. Embed the following text to add the dashboard, substituting the URL from above for https://tylertech.plotly.com:
<!DOCTYPE html><iframe src="https://tylertech.plotly.com" style="border:0px #FFFFFF none;" name="myiFrame" scrolling="yes" frameborder="1" marginheight="0px" marginwidth="0px" height="1000px" width="100%" allowfullscreen></iframe>
For more information about embedding content in a Perspectives story, review the videos in this article.

Using the Data on Socrata Domain

A number of different analyses and visualizations can be performed with this data. For more information on creating visualizations, see here.
In this dataset, each row in the data represents outcomes from one facility in a given week. The data includes variables such as resident/staff case counts, suspected case counts, and deaths as well as other key facility information (e.g. does the facility have surgical masks, is there a shortage of staff?). Note that case/death information is provided as both weekly and overall totals.
Mapping nursing homes
How to recreate this visualization:
  1. Add fly-out details for relevant fields
  2. Optionally add filters for certain characteristics, specify color/point size by various characteristics

Mapping total cases/deaths within geographies
How to recreate this visualization:
  1. Create a spatial lens based on the boundaries you want to map: neighborhoods, census tracts, etc.
  2. Create a map visualization off the nursing home data and choose "Region Map," then find the spatial lens boundary you created
  3. Choose the statistic(s) you'd like to map by

Creating other visualizations
You can also create visualizations beyond those on the main CMS page to gain additional insights.
How to recreate this visualization:
  1. Create a bar chart visualization
  2. Set the dimension to "Provider State" (other dimensions are also possible if you want a more localized view)
  3. Set the Measure to "Residents Weekly Confirmed COVID-19" (or the metric you're interested in)
  4. Group Dimensions by "Shortage of Clinical Staff" (or the dis-aggregate you're interested in)


Additional Data Sources

John Hopkins COVID-19 data
It's possible to get even more value out of the CMS nursing home data by using it in conjunction with other COVID-19 data. For example, the data provided by John Hopkins University Center for Systems Science and Engineering. Johns Hopkins University aggregates COVID-19 datasets from multiple sources to track the spread of COVID-19. This dataset contains numbers of confirmed, active, recovered, fatal COVID-19 cases and the deltas at the world, state and county level.  This data is updated once a day. 
Accessing the data
The Johns Hopkins University Center for Center for Systems Science and Engineering data can be found here. You can access the Johns Hopkins University data and other COVID-19 data from provide by different sources through Socrata's COVID-19 tracker Gateway plug-in as well as the API endpoint.
Questions you can answer using this data
  1. How many total COVID-19 cases and deaths are from nursing homes?
  2. How do trends in nursing home cases align with case trends among the general population?
Using the data
One possible visualization that can be created using the CMS Nursing Home and Johns Hopkins COVID case data is demonstrated below: 


The New COVID-19 Tracking Project
The COVID-19 Project collects and aggregates COVID-19 data that they publish every day. Every day the organization collects COVID-19 test and patient outcomes from all 50 states, 5 territories, and District of Columbia. The data contains and is not limited to: covid-19 test results (confirmed, negative, pending), total test results, number of people in hospitalization currently and cumulative, on ventilator currently and cumulative. You can use this data in conjunction with the nursing home data, John Hopkins COVID-19 and Definitive healthcare hospital bed capacity data to figure out states that need additional ventilators.
Accessing the data
The New COVID-19 Tracking Project data can be found here and is available through the Socrata COVID-19 Tracker Gateway plug-in as well as the API endpoint.
Questions you can answer using this dataset
  1. What state hospitals are under utilizing ventilators, ?
  2. Are hospitals with little ventilator usage in states with high COVID-19 rates?
Using the data
One possible visualization that can be created using the CMS Nursing and The New COVID-19 Tracking Project data is demonstrated below: 
Definitive Healthcare Hospital Data
Definitive Healthcare provides intelligence on the number of licensed beds, staffed beds, ICU beds, and bed utilization rate for hospitals in the United States. This data is not updated in real-time. However, the hospital bed information is important to understand the impact of bed utilization in regards to COVID-19. Definitive Healthcare Hospital data contains: hospital types, hospital name and location, number of beds, number of beds in utilization, number of ICU beds, staff per bed, and more.
Accessing the data
The Definitive Healthcare Hospital data can be found here and is available through the Socrata COVID-19 Tracker Gateway plug-in as well as the API endpoint.
Questions you can answer using this dataset
  1. What medical resources are available near nursing homes in the most need?
  2. Are hospitals with high utilization rates near nursing homes with high case counts?
Using the data
One possible visualization that can be created using the CMS Nursing and Definitive Healthcare Hospital data is demonstrated below:
American Community Survey
The American Community Survey (ACS) is an annual survey by the US Census Bureau to help local officials, community leaders, and businesses understand the changes taking place in their communities. It is the premier source for detailed population and housing information in the United States. 
Note that this data works best for providing baseline and contextual information.
Accessing the data
The ACS contains a large number of demographic, housing, and economic variables. You can use https://data.census.gov/cedsci/ to find information about available variables.  
The autocensus package is a python wrapper to pull data from the American Community Survey's API in a consistent format. The package includes functions to load ACS datasets onto your Socrata domain.
Documentation for the package is available here.
Questions you can answer using this data
  1. What is the total population of seniors with independent living difficulties in areas with nursing homes?
  2. Do poorer areas contain nursing homes with higher case counts?
Using the data
One possible visualization that can be created using the CMS Nursing and American Community Survey (in this case, the total population older than 65 with independent living difficulties) is demonstrated below: 
Additional COVID-19 Resources
U.S. County-Level Utilization Forecasting
COVID-19 Exist Strategy
Influenza-Like Illness Dataset