About this Dataset

COVID-19 Daily Testing - By Person - Historical

This dataset is historical only and ends at 5/7/2021. For more information, please see http://dev.cityofchicago.org/open%20data/data%20portal/2021/05/04/covid-19-testing-by-person.html. The recommended alternative dataset for similar data beyond that date is https://data.cityofchicago.org/Health-Human-Services/COVID-19-Daily-Testing-By-Test/gkdw-2tgv.

This is the source data for some of the metrics available at https://www.chicago.gov/city/en/sites/covid-19/home/latest-data.html.

For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.

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

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

Molecular (PCR) and antigen tests are included, and only one test is counted for each individual. 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.

Demographic data are more complete for those who test positive; care should be taken when calculating percentage positivity among demographic groups.

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

Data Source: Illinois National Electronic Disease Surveillance System
Organization: City of Chicago
Last updated: 2020-11-10T16:55:24.542834
Tags: covid-19, ethnicity, gender, health, historical, link-to-article-present, public-health, race, testing

Tables

Table 1

@usgov.city_of_chicago_covid_19_daily_testing_by_person.table_1

139.71 kB
434 rows
59 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "people_tested_total" BIGINT  -- People Tested - Total,
  "people_positive_total" BIGINT  -- People Positive - Total,
  "people_not_positive_total" BIGINT  -- People Not-Positive - Total,
  "people_tested_age_0_17" BIGINT  -- People Tested - Age 0-17,
  "people_tested_age_18_29" BIGINT  -- People Tested - Age 18-29,
  "people_tested_age_30_39" BIGINT  -- People Tested - Age 30-39,
  "people_tested_age_40_49" BIGINT  -- People Tested - Age 40-49,
  "people_tested_age_50_59" BIGINT  -- People Tested - Age 50-59,
  "people_tested_age_60_69" BIGINT  -- People Tested - Age 60-69,
  "people_tested_age_70_79" BIGINT  -- People Tested - Age 70-79,
  "people_tested_age_80" BIGINT  -- People Tested - Age 80+,
  "people_tested_age_unknown" BIGINT  -- People Tested - Age Unknown,
  "people_tested_female" BIGINT  -- People Tested - Female,
  "people_tested_male" BIGINT  -- People Tested - Male,
  "people_tested_gender_unknown" BIGINT  -- People Tested - Gender Unknown,
  "people_tested_latinx" BIGINT  -- People Tested - Latinx,
  "people_tested_asian_non_latinx" BIGINT  -- People Tested - Asian Non-Latinx,
  "people_tested_black_non_latinx" BIGINT  -- People Tested - Black Non-Latinx,
  "people_tested_white_non_latinx" BIGINT  -- People Tested - White Non-Latinx,
  "people_tested_other_race_non_latinx" BIGINT  -- People Tested - Other Race Non-Latinx,
  "people_tested_unknown_race_ethnicity" BIGINT  -- People Tested - Unknown Race/Ethnicity,
  "people_positive_age_0_17" BIGINT  -- People Positive - Age 0-17,
  "people_positive_age_18_29" BIGINT  -- People Positive - Age 18-29,
  "people_positive_age_30_30" BIGINT  -- People Positive - Age 30-30,
  "people_positive_age_40_49" BIGINT  -- People Positive - Age 40-49,
  "people_positive_age_50_59" BIGINT  -- People Positive - Age 50-59,
  "people_positive_age_60_69" BIGINT  -- People Positive - Age 60-69,
  "people_positive_age_70_79" BIGINT  -- People Positive - Age 70-79,
  "people_positive_age_80" BIGINT  -- People Positive - Age 80+,
  "people_positive_age_unknown" BIGINT  -- People Positive - Age Unknown,
  "people_positive_female" BIGINT  -- People Positive - Female,
  "people_positive_male" BIGINT  -- People Positive - Male,
  "people_positive_gender_unknown" BIGINT  -- People Positive - Gender Unknown,
  "people_positive_latinx" BIGINT  -- People Positive - Latinx,
  "people_positive_asian_non_latinx" BIGINT  -- People Positive - Asian Non-Latinx,
  "people_positive_black_non_latinx" BIGINT  -- People Positive - Black Non-Latinx,
  "people_positive_white_non_latinx" BIGINT  -- People Positive - White Non-Latinx,
  "people_positive_other_race_non_latinx" BIGINT  -- People Positive - Other Race Non-Latinx,
  "people_positive_unknown_race_ethnicity" BIGINT  -- People Positive - Unknown Race/Ethnicity,
  "people_not_positive_age_0_17" BIGINT  -- People Not-Positive - Age 0-17,
  "people_not_positive_age_18_29" BIGINT  -- People Not-Positive - Age 18-29,
  "people_not_positive_age_30_39" BIGINT  -- People Not-Positive - Age 30-39,
  "people_not_positive_age_40_49" BIGINT  -- People Not-Positive - Age 40-49,
  "people_not_positive_age_50_59" BIGINT  -- People Not-Positive - Age 50-59,
  "people_not_positive_age_60_69" BIGINT  -- People Not-Positive - Age 60-69,
  "people_not_positive_age_70_79" BIGINT  -- People Not-Positive - Age 70-79,
  "people_not_positive_age_80" BIGINT  -- People Not-Positive - Age 80+,
  "people_not_positive_age_unknown" BIGINT  -- People Not-Positive - Age Unknown,
  "people_not_positive_female" BIGINT  -- People Not-Positive - Female,
  "people_not_positive_male" BIGINT  -- People Not-Positive - Male,
  "people_not_positive_gender_unknown" BIGINT  -- People Not-Positive - Gender Unknown,
  "people_not_positive_latinx" BIGINT  -- People Not-Positive - Latinx,
  "people_not_positive_asian_non_latinx" BIGINT  -- People Not-Positive - Asian Non-Latinx,
  "people_not_positive_black_non_latinx" BIGINT  -- People Not-Positive - Black Non-Latinx,
  "people_not_positive_white_non_latinx" BIGINT  -- People Not-Positive - White Non-Latinx,
  "people_not_positive_other_race_non_latinx" BIGINT  -- People Not-Positive - Other Race Non-Latinx,
  "people_not_positive_unknown_race_ethnicity" BIGINT  -- People Not-Positive - Unknown Race/Ethnicity
);