Total COVID-19 cases by 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. Only LTCFs within Santa Clara County are listed. Residents and staff working at these facilities and who are residents of Santa Clara County are included in these counts.

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/total-covid19-cases-by-long-term-care-facilities-xtg3-85g6\".\"total_covid19_cases_by_long_term_care_facilities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.