COVID-19 Nursing Home Data

The Nursing Home COVID-19 Public File includes data reported by nursing homes to the CDC’s National Healthcare Safety Network (NHSN) Long Term Care Facility (LTCF) COVID-19 Module: Surveillance Reporting Pathways and COVID-19 Vaccinations.

On September 15, 2023, the Centers for Disease Control (CDC) updated its recommendation regarding what is required for individuals to be up to date with their COVID-19 vaccine. The COVID-19 vaccination rates now reflect the new definition of up to date. Initial findings should be interpreted with caution while providers are learning how to report COVID-19 vaccination status based on the new up to date definition. The data may initially show that few long-term care residents and staff have up to date vaccination status; these percentages will increase over time as residents and staff receive the updated COVID-19 vaccine.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ramseycounty-us/covid19-nursing-home-data-gcjp-su5y\".\"covid19_nursing_home_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.