DPH is updating and streamlining the COVID-19 cases, deaths, and testing data. As of 6/27/2022, the data will be published in four tables instead of twelve. The COVID-19 Cases, Deaths, and Tests by Day dataset contains cases and test data by date of sample submission. The death data are by date of death. This dataset is updated daily and contains information back to the beginning of the pandemic. The data can be found at https://data.ct.gov/Health-and-Human-Services/COVID-19-Cases-Deaths-and-Tests-by-Day/g9vi-2ahj. The COVID-19 State Metrics dataset contains over 93 columns of data. This dataset is updated daily and currently contains information starting June 21, 2022 to the present. The data can be found at https://data.ct.gov/Health-and-Human-Services/COVID-19-State-Level-Data/qmgw-5kp6 . The COVID-19 County Metrics dataset contains 25 columns of data. This dataset is updated daily and currently contains information starting June 16, 2022 to the present. The data can be found at https://data.ct.gov/Health-and-Human-Services/COVID-19-County-Level-Data/ujiq-dy22 . The COVID-19 Town Metrics dataset contains 16 columns of data. This dataset is updated daily and currently contains information starting June 16, 2022 to the present. The data can be found at https://data.ct.gov/Health-and-Human-Services/COVID-19-Town-Level-Data/icxw-cada . To protect confidentiality, if a town has fewer than 5 cases or positive NAAT tests over the past 7 days, those data will be suppressed. COVID-19 cases, tests, and associated deaths from COVID-19 that have been reported among Connecticut residents. All data in this report are preliminary; data for previous dates will be updated as new reports are received and data errors are corrected. Deaths reported to the either the Office of the Chief Medical Examiner (OCME) or Department of Public Health (DPH) are included in the daily COVID-19 update. The case rate per 100,000 includes probable and confirmed cases. Probable and confirmed are defined using the CSTE case definition, which is available online: https://cdn.ymaws.com/www.cste.org/resource/resmgr/2020ps/Interim-20-ID-01_COVID-19.pdf The population data used to calculate rates is based on the CT DPH population statistics for 2019, which is available online here: https://portal.ct.gov/DPH/Health-Information-Systems--Reporting/Population/Population-Statistics. Prior to 5/10/2021, the population estimates from 2018 were used. Data on Connecticut deaths were obtained from the Connecticut Deaths Registry maintained by the DPH Office of Vital Records. Cause of death was determined by a death certifier (e.g., physician, APRN, medical examiner) using their best clinical judgment. Additionally, all COVID-19 deaths, including suspected or related, are required to be reported to OCME. On April 4, 2020, CT DPH and OCME released a joint memo to providers and facilities within Connecticut providing guidelines for certifying deaths due to COVID-19 that were consistent with the CDC’s guidelines and a reminder of the required reporting to OCME.25,26 As of July 1, 2021, OCME had reviewed every case reported and performed additional investigation on about one-third of reported deaths to better ascertain if COVID-19 did or did not cause or contribute to the death. Some of these investigations resulted in the OCME performing postmortem swabs for PCR testing on individuals whose deaths were suspected to be due to COVID-19, but antemortem diagnosis was unable to be made.31 The OCME issued or re-issued about 10% of COVID-19 death certificates and, when appropriate, removed COVID-19 from the death certificate. For standardization and tabulation of mortality statistics, written cause of death statements made by the certifiers on death certificates are sent to the National Center for Health Statistics (NCHS) at the CDC which assigns cause of death codes according to the International Causes of Disease 10th Revision (ICD-10) classification system.25,26 COVID-19 deaths in this report are defined as those for which the death certificate has an ICD-10 code of U07.1 as either a primary (underlying) or a contributing cause of death. More information on COVID-19 mortality can be found at the following link: https://portal.ct.gov/DPH/Health-Information-Systems--Reporting/Mortality/Mortality-Statistics Data are reported daily, with timestamps indicated in the daily briefings posted at: portal.ct.gov/coronavirus. Data are subject to future revision as reporting changes. Starting in July 2020, this dataset will be updated every weekday. Additional notes: Due to an issue with the town-level data dated 1/17/2021, the data was temporarily unavailable; as of 11:19 AM on 1/19/2021 the data has been restored. As of 11/5/2020, CT DPH has added antigen testing for SARS-CoV-2 to reported test counts in this dataset. The tests included in this dataset include both molecular and antigen datasets. Molecular tests reported include polymerase chain reaction (PCR) and nucleic acid amplicfication (NAAT) tests. A delay in the data pull schedule occurred on 06/23/2020. Data from 06/22/2020 was processed on 06/23/2020 at 3:30 PM. The normal data cycle resumed with the data for 06/23/2020. A network outage on 05/19/2020 resulted in a change in the data pull schedule. Data from 5/19/2020 was processed on 05/20/2020 at 12:00 PM. Data from 5/20/2020 was processed on 5/20/2020 8:30 PM. The normal data cycle resumed on 05/20/2020 with the 8:30 PM data pull. As a result of the network outage, the timestamp on the datasets on the Open Data Portal differ from the timestamp in DPH's daily PDF reports. Starting 5/10/2021, the date field will represent the date this data was updated on data.ct.gov. Previously the date the data was pulled by DPH was listed, which typically coincided with the date before the data was published on data.ct.gov. This change was made to standardize the COVID-19 data sets on data.ct.gov. On 5/16/2022, 8,622 historical cases were included in the data. The date range for these cases were from August 2021 – April 2022.”
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Last update date | lastupdatedate | calendar_date | Date dataset was last updated | 2020-03-24T00:00:00.000 2020-03-25T00:00:00.000 2020-03-26T00:00:00.000 2020-03-27T00:00:00.000 2020-03-28T00:00:00.000 view top 100 |
Town number | town_no | number | Town number | 33 117 124 29 3 view top 100 |
Town | town | text | Town name | Warren Voluntown Sharon Bristol Woodstock view top 100 |
Total cases | towntotalcases | number | Sum of confirmed and probable COVID-19 cases | 0 5 2 6 9 view top 100 |
Confirmed cases | townconfirmedcases | number | Number of laboratory-confirmed COVID-19 cases | 13 5 15 14 6 view top 100 |
Probable cases | townprobablecases | number | Number of probable COVID-19 cases | 0 1 2 3 4 view top 100 |
Case rate | towncaserate | number | Rate of cases per 100,000 | 0 595 278 357 670 view top 100 |
Total deaths | towntotaldeaths | number | Sum of confirmed and probable COVID-19-associated deaths | 0 1 2 3 5 view top 100 |
Confirmed deaths | townconfirmeddeaths | number | Number of confirmed COVID-19-associated deaths | 0 2 1 3 4 view top 100 |
Probable deaths | townprobabledeaths | number | Number of probable COVID-19-associated deaths | 0 1 2 3 5 view top 100 |
People tested | peopletested | number | Number of people tested | 357 358 335 339 737 view top 100 |
Rate tested per 100k | ratetested100k | number | Rate of people tested per 100,000 | 33903 33998 32194 45215 31374 view top 100 |
Number of tests | numberoftests | number | Number of molecular COVID-19 tests reported | 182 646 468 419 687 view top 100 |
Number of positives | numberofpositives | number | Number of positive tests | 6 9 18 14 32 view top 100 |
Number of negatives | numberofnegatives | number | Number of negative tests | 238 108 301 1085 72 view top 100 |
Number of indeterminates | numberofindeterminates | number | Number of indeterminate tests | 0 1 2 4 3 view top 100 |