COVID-19 cases, hospitalizations and deaths at Long Term Care Facilities

The dataset provides information on cases among residents and staff at LTCFs, which are a critical part of the continuum of health care. LTCFs include skilled nursing, independent living, assisted living and board and care facilities. Source: California Reportable Disease Information Exchange. Data Notes: These data may represent ongoing investigations and as such may change as additional information are collected. The count of facilities is the number of facilities in each type of care that have at least one COVID-19 case.

This table was updated for the last time on May 20, 2021.

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 \"sccgov/covid19-cases-hospitalizations-and-deaths-at-long-kb5s-tppg\".\"covid19_cases_hospitalizations_and_deaths_at_long\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.