About this Dataset

COVID-19 Daily Testing - By Test - Historical

NOTE: This dataset has been retired and marked as historical-only.

This dataset contains counts of unique tests and results for COVID-19. This dataset differs from https://data.cityofchicago.org/d/t4hh-4ku9 in that each person is in that dataset only once, even if tested multiple times. In this dataset, each test is counted, even if multiple tests are performed on the same person, although a person should not appear in this dataset more than once on the same day unless he/she had both a positive and not-positive test.

The positivity rate displayed in this dataset uses the method most commonly used by other jurisdictions in the United States.

Only Chicago residents are included based on the home address as provided by the medical provider.

Molecular (PCR) and antigen tests received through electronic lab reporting are included. Individuals may be tested multiple times. Tests are counted on the day the specimen was collected. A small number of tests collected prior to 3/1/2020 are not included in the table.

Not-positive lab results include negative results, invalid results, and tests not performed due to improper collection. Chicago Department of Public Health (CDPH) does not receive all not-positive results.

All data are provisional and subject to change. Information is updated as additional details are received.

Data Source: Illinois Department of Public Health Electronic Lab Reports
Organization: City of Chicago
Last updated: 2020-11-10T16:54:57.402397
Tags: covid-19, health, historical, link-to-article-present, public-health, testing

Tables

Table 1

@usgov.city_of_chicago_covid_19_daily_testing_by_test.table_1

353.36 kB
1,540 rows
59 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "positive_tests" BIGINT,
  "not_positive_tests" BIGINT,
  "total_tests" BIGINT,
  "tests_age_0_17" BIGINT  -- Tests - Age 0-17,
  "tests_age_18_29" BIGINT  -- Tests - Age 18-29,
  "tests_age_30_39" BIGINT  -- Tests - Age 30-39,
  "tests_age_40_49" BIGINT  -- Tests - Age 40-49,
  "tests_age_50_59" BIGINT  -- Tests - Age 50-59,
  "tests_age_60_69" BIGINT  -- Tests - Age 60-69,
  "tests_age_70_79" BIGINT  -- Tests - Age 70-79,
  "tests_age_80" BIGINT  -- Tests - Age 80+,
  "tests_age_unknown" BIGINT  -- Tests - Age Unknown,
  "tests_female" BIGINT  -- Tests - Female,
  "tests_male" BIGINT  -- Tests - Male,
  "tests_gender_unknown" BIGINT  -- Tests - Gender Unknown,
  "tests_latinx" BIGINT  -- Tests - Latinx,
  "tests_asian_non_latinx" BIGINT  -- Tests - Asian Non-Latinx,
  "tests_black_non_latinx" BIGINT  -- Tests - Black Non-Latinx,
  "tests_white_non_latinx" BIGINT  -- Tests - White Non-Latinx,
  "tests_other_race_non_latinx" BIGINT  -- Tests - Other Race Non-Latinx,
  "tests_unknown_race_ethnicity" BIGINT  -- Tests - Unknown Race/Ethnicity,
  "positive_tests_age_0_17" BIGINT  -- Positive Tests - Age 0-17,
  "positive_tests_age_18_29" BIGINT  -- Positive Tests - Age 18-29,
  "positive_tests_age_30_39" BIGINT  -- Positive Tests - Age 30-39,
  "positive_tests_age_40_49" BIGINT  -- Positive Tests - Age 40-49,
  "positive_tests_age_50_59" BIGINT  -- Positive Tests - Age 50-59,
  "positive_tests_age_60_69" BIGINT  -- Positive Tests - Age 60-69,
  "positive_tests_age_70_79" BIGINT  -- Positive Tests - Age 70-79,
  "positive_tests_age_80" BIGINT  -- Positive Tests - Age 80+,
  "positive_tests_age_unknown" BIGINT  -- Positive Tests - Age Unknown,
  "positive_tests_female" BIGINT  -- Positive Tests - Female,
  "positive_tests_male" BIGINT  -- Positive Tests - Male,
  "positive_tests_unknown_gender" BIGINT  -- Positive Tests - Unknown Gender,
  "positive_tests_latinx" BIGINT  -- Positive Tests - Latinx,
  "positive_tests_asian_non_latinx" BIGINT  -- Positive Tests - Asian Non-Latinx,
  "positive_tests_black_non_latinx" BIGINT  -- Positive Tests - Black Non-Latinx,
  "positive_tests_white_non_latinx" BIGINT  -- Positive Tests - White Non-Latinx,
  "positive_tests_other_race_non_latinx" BIGINT  -- Positive Tests - Other Race Non-Latinx,
  "positive_tests_unknown_race_ethnicity" BIGINT  -- Positive Tests - Unknown Race/Ethnicity,
  "not_positive_tests_age_0_17" BIGINT  -- Not-Positive Tests - Age 0-17,
  "not_positive_tests_age_18_29" BIGINT  -- Not-Positive Tests - Age 18-29,
  "not_positive_tests_age_30_39" BIGINT  -- Not-Positive Tests - Age 30-39,
  "not_positive_tests_age_40_49" BIGINT  -- Not-Positive Tests - Age 40-49,
  "not_positive_tests_age_50_59" BIGINT  -- Not-Positive Tests - Age 50-59,
  "not_positive_tests_age_60_69" BIGINT  -- Not-Positive Tests - Age 60-69,
  "not_positive_tests_age_70_79" BIGINT  -- Not-Positive Tests - Age 70-79,
  "not_positive_tests_age_80" BIGINT  -- Not-Positive Tests - Age 80+,
  "not_positive_tests_age_unknown" BIGINT  -- Not-Positive Tests - Age Unknown,
  "not_positive_tests_female" BIGINT  -- Not-Positive Tests - Female,
  "not_positive_tests_male" BIGINT  -- Not-Positive Tests - Male,
  "not_positive_tests_gender_unknown" BIGINT  -- Not-Positive Tests - Gender Unknown,
  "not_positive_tests_latinx" BIGINT  -- Not-Positive Tests - Latinx,
  "not_positive_tests_asian_non_latinx" BIGINT  -- Not-Positive Tests - Asian Non-Latinx,
  "not_positive_tests_black_non_latinx" BIGINT  -- Not-Positive Tests - Black Non-Latinx,
  "not_positive_tests_white_non_latinx" BIGINT  -- Not-Positive Tests - White Non-Latinx,
  "not_positive_tests_other_race_non_latinx" BIGINT  -- Not-Positive Tests - Other Race Non-Latinx,
  "not_positive_tests_unknown_race_ethnicity" BIGINT  -- Not-Positive Tests - Unknown Race/Ethnicity
);