COVID-19 Tests, Cases, and Deaths (By Town) - ARCHIVE

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.”

DPH正在更新并精简COVID-19病例、死亡和检测数据。截至2022年6月27日，数据将以四个表格的形式发布，而非之前的十二个表格。《按日统计的COVID-19病例、死亡和检测数据集》包含了按样本提交日期统计的病例和检测数据。死亡数据按死亡日期统计。该数据集每日更新，并包含自疫情初期以来的信息。数据可从https://data.ct.gov/Health-and-Human-Services/COVID-19-Cases-Deaths-and-Tests-by-Day/g9vi-2ahj获取。《COVID-19州级指标数据集》包含超过93个数据列。该数据集每日更新，并目前包含自2022年6月21日起至现在的信息。数据可从https://data.ct.gov/Health-and-Human-Services/COVID-19-State-Level-Data/qmgw-5kp6获取。《COVID-19县级指标数据集》包含25个数据列。该数据集每日更新，并目前包含自2022年6月16日起至现在的信息。数据可从https://data.ct.gov/Health-and-Human-Services/COVID-19-County-Level-Data/ujiq-dy22获取。《COVID-19镇级指标数据集》包含16个数据列。该数据集每日更新，并目前包含自2022年6月16日起至现在的信息。数据可从https://data.ct.gov/Health-and-Human-Services/COVID-19-Town-Level-Data/icxw-cada获取。为了保护隐私，如果一个镇在过去7天内病例或阳性NAAT检测少于5例，则相关数据将被抑制。

报告中的COVID-19病例、检测以及与COVID-19相关的死亡数据均来自康涅狄格州居民。本报告中的所有数据均为初步数据；在收到新报告和纠正数据错误后，先前日期的数据将进行更新。报告给首席医学检察官办公室（OCME）或公共卫生部（DPH）的死亡将被纳入每日COVID-19更新中。

每10万人中的病例率包括可能和确诊病例。可能和确诊病例的定义使用CSTE病例定义，该定义可在网上找到：https://cdn.ymaws.com/www.cste.org/resource/resmgr/2020ps/Interim-20-ID-01_COVID-19.pdf

用于计算比率的人口数据基于2019年CT DPH人口统计数据，该数据可在网上找到：https://portal.ct.gov/DPH/Health-Information-Systems--Reporting/Population/Population-Statistics。在2021年5月10日之前，使用了2018年的人口估计值。

康涅狄格州死亡数据是从DPH生命记录办公室维护的康涅狄格州死亡登记处获得的。死亡原因由死亡证明人（例如，医生、注册护士、医学检验员）根据其最佳临床判断确定。此外，所有COVID-19死亡，包括疑似或相关死亡，都要求报告给OCME。2020年4月4日，CT DPH和OCME发布了联合备忘录，向康涅狄格州内的提供者和设施提供有关证明由于COVID-19而死亡的标准，并提醒必须向OCME报告。截至2021年7月1日，OCME审查了所有报告的案例，并对约三分之一的报告死亡进行了额外调查，以更好地确定COVID-19是否导致或促进了死亡。其中一些调查导致OCME对那些生前诊断无法确定，但疑似死于COVID-19的个人进行了尸检PCR检测。OCME发布了或重新发布了约10%的COVID-19死亡证明书，并在适当的情况下，从死亡证明书中移除了COVID-19。为了标准化和编制死亡率统计数据，死亡证明书上证明人书写的死亡原因陈述被发送到CDC的国家卫生统计中心（NCHS），该中心根据国际疾病分类第10版（ICD-10）分类系统分配死亡原因代码。本报告中的COVID-19死亡定义为死亡证明书中ICD-10代码为U07.1，作为主要（基础）或死亡原因的伴随原因。有关COVID-19死亡率的更多信息，请参阅以下链接：https://portal.ct.gov/DPH/Health-Information-Systems--Reporting/Mortality/Mortality-Statistics

数据每日报告，时间戳在每日简报中显示，简报可在portal.ct.gov/coronavirus获取。数据可能在未来进行修订。

从2020年7月开始，此数据集将在每周工作日更新。

附加说明：
由于2021年1月17日镇级数据的故障问题，数据临时不可用；截至2021年1月19日上午11:19，数据已恢复。

截至2020年11月5日，CT DPH已将SARS-CoV-2的抗原检测添加到本数据集中的报告检测计数中。本数据集中的检测包括分子和抗原数据集。报告的分子检测包括聚合酶链反应（PCR）和核酸扩增（NAAT）检测。

2020年6月23日发生了数据提取计划延误。2020年6月22日的数据于2020年6月23日下午3:30处理。正常的数据周期于2020年6月23日恢复。

2020年5月19日发生网络故障，导致数据提取计划变更。2020年5月19日的数据于2020年5月20日上午12:00处理。2020年5月20日的数据于2020年5月20日晚上8:30处理。正常的数据周期于2020年5月20日晚上8:30的数据提取中恢复。由于网络故障，开放数据门户上的数据集时间戳与DPH每日PDF报告中的时间戳不同。

从2021年5月10日起，日期字段将表示在data.ct.gov上更新数据的日期。之前，列出的日期是DPH提取数据的日期，这通常与在data.ct.gov上发布数据的前一天相符。此更改是为了在data.ct.gov上标准化COVID-19数据集。

在2022年5月16日，数据中包含了8,622个历史病例。这些病例的日期范围为2021年8月至2022年4月。”
}