State of Connecticut

Close
Author
Gary Archambault
Description
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.
Category
Health and Human Services
Tags
covid-19, assisted living facilities
Rating
Current value: 0 out of 5
Data Provided By
Department of Public Health
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Date last updated
date_last_updated
Town
town
Assisted living facility
assisted_living_facility
Total number of beds
total_number_of_beds
Current census
current_census
Cumulative number of residents with laboratory confirmed COVID-19
residents_with_confirmed_covid
Number of new confirmed cases among residents reported in past week
number_of_new_confirmed_cases_reported_in_past_week
Number of COVID-19 associated deaths among residents through July 14, 2020: laboratory confirmed (OCME data)
covid_19_associated_deaths_confirmed
Number of COVID-19 associated deaths among residents through July 14, 2020: probable (OCME data)
covid_19_associated_deaths_probable
Cumulative number of COVID-associated deaths among residents through July 14, 2020: laboratory confirmed and probable (OCME data)
cumulative_covid_associated_deaths_among_residents_through_july_14_2020
Cumulative number of COVID-associated deaths among residents since July 15, 2020 (LTC-MAP data)
cumulative_covid_associated_deaths_among_residents_since_july_15_2020
Number of new COVID-associated deaths among residents reported in past week (LTC-MAP data)
new_covid_associated_deaths_among_residents_reported_in_past_week
Cumulative number of staff with laboratory confirmed COVID-19 since July 1, 2020
cumulative_number_of_staff_with_laboratory_confirmed_covid_19_since_july_1
Number of new confirmed cases among staff reported in past week
number_of_new_confirmed_cases_among_staff_reported_in_past_week
Cumulative number of COVID-associated deaths among staff since July 1, 2020
cumulative_number_of_covid_associated_deaths_among_staff_since_july_1_2020_
Number of new COVID-associated deaths among staff reported in past week
number_of_new_covid_associated_deaths_among_staff_reported_in_past_week

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.