ct-gov/nursing-homes-with-residents-positive-for-covid19-wyn3-qphu
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 8 months ago
Indexed 1 month ago

Nursing Homes with Residents Positive for COVID-19, April - June 2020 - Archive

Nursing homes with residents positive for COVID-19 from 4/22/2020 to 6/19/2020.

Starting in July 2020, this dataset will no longer be updated and will be replaced by the CMS COVID-19 Nursing Home Dataset, available at the following link: https://data.ct.gov/Health-and-Human-Services/CMS-COVID-19-Nursing-Home-Dataset/w8wc-65i5.

Methods:

1) Laboratory-confirmed case counts are based upon data reported via the FLIS web portal. Nursing homes were asked to provide cumulative totals of residents with laboratory confirmed covid. This includes residents currently in-house, in the hospital, or who are deceased. Residents were excluded if they tested positive prior to initial admission to the nursing home.

2) The cumulative number of deaths among nursing home 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).

Limitations:

1) As of the week of 5/10/20, Point Prevalence Survey testing is being offered to all asymptomatic nursing home residents to inform infection prevention efforts. Point prevalence surveys will be conducted over a period of several weeks. Some nursing homes had adequate testing resources available to conduct surveys prior to this date. Differences in survey timing will impact the number of positive results that a nursing home reports.

2) Cumulative totals of residents testing positive are being collected rather than individual resident data. Thus we cannot verify the counts, de-duplicate, and/or verify whether there is a record of a positive lab test. This may result in either under- or over-counting.

3) The number of COVID-19 positive residents and the number of confirmed deaths among residents are tabulated from different data sources. Due to the timing of availability of test results for deceased residents, it is not appropriate to calculate the percent of cases who died due to COVID-19 at any particular facility based upon this data.

4) The count of deaths reported for 4/14 are not included in this dataset, as they were not broken out by laboratory-confirmed or probable. They can be viewed in the DPH Report here: https://portal.ct.gov/-/media/Coronavirus/CTDPHCOVID19summary4162020.pdf?la=en

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/nursing-homes-with-residents-positive-for-covid19-wyn3-qphu\".\"nursing_homes_with_residents_positive_for_covid19\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • nursing_homes_with_residents_positive_for_covid19
     
     
     
     
     
Upstream Metadata