COVID-19 Test Results By Date Of Specimen Collection (By County) - ARCHIVE by US Government | Healthcare

About this Dataset

COVID-19 Test Results By Date Of Specimen Collection (By County) - 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 test results by date of specimen collection, including total, positive, negative, and indeterminate for molecular and antigen tests. Molecular tests reported include polymerase chain reaction (PCR) and nucleic acid amplicfication (NAAT) tests.

Test results may be reported several days after the result. Data are incomplete for the most recent days. Data from previous dates are routinely updated. Records with a null date field summarize tests reported that were missing the date of collection.

Starting in July 2020, this dataset will be updated every weekday.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:20.647916
Tags: covid-archive

Tables

Table 1

@usgov.state_of_connecticut_covid_19_test_results_by_date_of__d9f97b30.table_1

111.49 KB
7704 rows
10 columns


CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "county" VARCHAR,
  "number_of_molecular_tests" BIGINT,
  "number_of_molecular_positives" BIGINT,
  "number_of_molecular_negatives" BIGINT,
  "number_of_molecular_indeterminates" BIGINT,
  "number_of_antigen_tests" BIGINT,
  "number_of_antigen_positives" BIGINT,
  "number_of_antigen_negatives" BIGINT,
  "number_of_antigen_indeterminates" BIGINT
);