Assisted Living Facilities with Residents Positive for COVID-19 - ARCHIVE

Note: This dataset is no longer being maintained and will not be updated going forward.

The weekly and cumulative number of residents with confirmed COVID-19 and with COVID-19 associated deaths is obtained from data self-reported by individual assisted living facilities to the Long Term Care Mutual Aid Plan web-based reporting system (www.mutualaidplan.org/ct). Both confirmed and suspect deaths are included.

Confirmed deaths include those among persons who tested positive for COVID-19. Suspected deaths include those among persons with signs and symptoms suggestive of COVID-19 but who did not have a laboratory positive COVID-19 test. Due to differing data collection and processing methods between LTC-MAP and the death data sources used previously, cumulative death data for residents was re-baselined on July 14, 2020. The resident death data before and after July 14, 2020 should not be added due to the differing definitions of COVID-19 associated deaths used and the possibility of duplication of deaths among prior and current data.

The cumulative number of deaths among assisted living residents is based upon data reported by the Office of the Chief Medical Examiner. For public health surveillance, COVID-19-associated deaths include persons who tested positive for COVID-19 around the time of death (laboratory-confirmed) and persons whose death certificate lists COVID-19 disease as a cause of death or a significant condition contributing to death (probable). As of 7/15/20 deaths reported by the Office of the Chief Medical Examiner are no longer being updated on a weekly basis.

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/assisted-living-facilities-with-residents-positive-wjua-euxh\".\"assisted_living_facilities_with_residents_positive\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.