COVID-19 cases at Long Term Care Facilities by date

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: Cases are reported by the earliest of either the symptoms onset date, date of specimen collection or lab result date. These data may represent ongoing investigations and as such may change as additional information are collected. Only LTCFs within Santa Clara County are listed. Hospitalizations are only determined at the time a case was reported to the Public Health Department and do not represent patients that are currently or have ever been hospitalized.

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-at-long-term-care-facilities-by-date-ksyb-fnbm\".\"covid19_cases_at_long_term_care_facilities_by_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.