CMS COVID-19 Nursing Home Dataset

The Nursing Home COVID-19 Public File from the Centers for Medicare & Medicaid Services, filtered for Connecticut. View the full dataset and detailed metadata <a href="https://data.cms.gov/covid-19/covid-19-nursing-home-data">here</a>.

The Nursing Home COVID-19 Public File includes data reported by nursing homes to the CDC’s National Healthcare Safety Network (NHSN) system COVID-19 Long Term Care Facility Module, including Resident Impact, Facility Capacity, Staff & Personnel, and Supplies & Personal Protective Equipment, and Ventilator Capacity and Supplies Data Elements.

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 \"ct-gov/cms-covid19-nursing-home-dataset-w8wc-65i5\".\"cms_covid19_nursing_home_dataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.