About this Dataset

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.
Organization: State of Connecticut
Last updated: 2020-11-12T14:58:20.469340
Tags: assisted-living-facilities, covid-19, covid-archive, covid-congregate-settings

Tables

Table 1

@usgov.state_of_connecticut_assisted_living_facilities_with_r_d5279ad6.table_1

48.17 kB
7,084 rows
16 columns

CREATE TABLE table_1 (
  "date_last_updated" TIMESTAMP,
  "town" VARCHAR,
  "assisted_living_facility" VARCHAR,
  "total_number_of_beds" DOUBLE,
  "current_census" DOUBLE,
  "cumulative_number_of_residents_with_laboratory_confirm_44e4ad39" DOUBLE  -- Cumulative Number Of Residents With Laboratory Confirmed COVID-19,
  "number_of_new_confirmed_cases_among_residents_reported_3ec09e23" DOUBLE  -- Number Of New Confirmed Cases Among Residents Reported In Past Week,
  "number_of_covid_19_associated_deaths_among_residents_t_19aea567" DOUBLE  -- Number Of COVID-19 Associated Deaths Among Residents Through July 14, 2020: Laboratory Confirmed (OCME Data),
  "number_of_covid_19_associated_deaths_among_residents_t_f93d2c86" DOUBLE  -- Number Of COVID-19 Associated Deaths Among Residents Through July 14, 2020: Probable (OCME Data),
  "cumulative_number_of_covid_associated_deaths_among_res_2803324b" DOUBLE  -- Cumulative Number Of COVID-associated Deaths Among Residents Through July 14, 2020: Laboratory Confirmed And Probable (OCME Data),
  "cumulative_number_of_covid_associated_deaths_among_res_cd7d708a" DOUBLE  -- Cumulative Number Of COVID-associated Deaths Among Residents Since July 15, 2020 (LTC-MAP Data),
  "number_of_new_covid_associated_deaths_among_residents__18f82d08" DOUBLE  -- Number Of New COVID-associated Deaths Among Residents Reported In Past Week (LTC-MAP Data),
  "cumulative_number_of_staff_with_laboratory_confirmed_c_d55ffc44" DOUBLE  -- Cumulative Number Of Staff With Laboratory Confirmed COVID-19 Since July 1, 2020,
  "number_of_new_confirmed_cases_among_staff_reported_in_past_week" DOUBLE,
  "cumulative_number_of_covid_associated_deaths_among_sta_ebdbb998" DOUBLE  -- Cumulative Number Of COVID-associated Deaths Among Staff Since July 1, 2020,
  "number_of_new_covid_associated_deaths_among_staff_repo_03221de6" DOUBLE  -- Number Of New COVID-associated Deaths Among Staff Reported In Past Week
);