cityofchicago/covid19-daily-testing-by-test-gkdw-2tgv

 
External

COVID-19 Daily Testing - By Test

  • covid-19
  • health
  • public health
  • testing

COVID-19 Daily Testing - By Test

NOTE: Starting 2/8/2021, this dataset has been modified to include cases with positive antigen tests. This change may impact historical numbers for individual days going back to 3/1/2020.

NOTE: Starting 10/29/2020, this dataset contains demographic breakdowns of tests. It also removes the "Percent Positive Tests" column. This value can be calculated from other columns present. -- This is the place to look for important information about how to use this dataset, so please expand this box and read on!

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Positive Tests - Age 50-59positive_tests_age_50_59positive_tests_age_50_59Number
Positive Tests - White Non-Latinxpositive_tests_white_non_latinxpositive_tests_white_non_latinxNumber
Positive Tests - Latinxpositive_tests_latinxpositive_tests_latinxNumber
Positive Tests - Femalepositive_tests_femalepositive_tests_femaleNumber
Not-Positive Tests - Age 18-29not_positive_tests_age_18_29not_positive_tests_age_18_29Number
Not-Positive Tests - Unknown Race/Ethnicitynot_positive_tests_unknown_race_ethnicitynot_positive_tests_unknown_race_ethnicityNumber
Tests - Age 40-49tests_age_40_49tests_age_40_49Number
Not Positive Testsnot_positive_testsnot_positive_testsNumberNumber of tests with a not positive result.
Tests - Black Non-Latinxtests_black_non_latinxtests_black_non_latinxNumber
Tests - Other Race Non-Latinxtests_other_race_non_latinxtests_other_race_non_latinxNumber
Positive Tests - Age 18-29positive_tests_age_18_29positive_tests_age_18_29Number
Not-Positive Tests - Femalenot_positive_tests_femalenot_positive_tests_femaleNumber
Positive Tests - Asian Non-Latinxpositive_tests_asian_non_latinxpositive_tests_asian_non_latinxNumber
Tests - Age 60-69tests_age_60_69tests_age_60_69Number
Not-Positive Tests - Age 30-39not_positive_tests_age_30_39not_positive_tests_age_30_39Number
Not-Positive Tests - Age 0-17not_positive_tests_age_0_17not_positive_tests_age_0_17Number
Not-Positive Tests - Other Race Non-Latinxnot_positive_tests_other_race_non_latinxnot_positive_tests_other_race_non_latinxNumber
Tests - Femaletests_femaletests_femaleNumber
Tests - Age 18-29tests_age_18_29tests_age_18_29Number
DatedatedateCalendar dateTest specimen collection date. Blank indicates unknown date.
Positive Tests - Age 60-69positive_tests_age_60_69positive_tests_age_60_69Number
Tests - White Non-Latinxtests_white_non_latinxtests_white_non_latinxNumber
Positive Tests - Unknown Race/Ethnicitypositive_tests_unknown_race_ethnicitypositive_tests_unknown_race_ethnicityNumber
Tests - Age 70-79tests_age_70_79tests_age_70_79Number
Not-Positive Tests - White Non-Latinxnot_positive_tests_white_non_latinxnot_positive_tests_white_non_latinxNumber
Positive Tests - Age 80+positivetests_age_80positivetests_age_80Number
Not-Positive Tests - Asian Non-Latinxnot_positive_tests_asian_non_latinxnot_positive_tests_asian_non_latinxNumber
Tests - Age 30-39tests_age_30_39tests_age_30_39Number
Tests - Age Unknowntests_age_unknowntests_age_unknownNumber
Tests - Unknown Race/Ethnicitytests_unknown_race_ethnicitytests_unknown_race_ethnicityNumber
Positive Tests - Other Race Non-Latinxpositive_tests_other_race_non_latinxpositive_tests_other_race_non_latinxNumber
Not-Positive Tests - Age 70-79not_positive_tests_age_70_79not_positive_tests_age_70_79Number
Tests - Maletests_maletests_maleNumber
Tests - Age 0-17tests_age_0_17tests_age_0_17Number
DaydaydayTextDay of the week.
Not-Positive Tests - Age 60-69not_positive_tests_age_60_69not_positive_tests_age_60_69Number
Tests - Age 50-59tests_age_50_59tests_age_50_59Number
Tests - Gender Unknowntests_gender_unknowntests_gender_unknownNumber
Not-Positive Tests - Age 40-49not_positive_tests_age_40_49not_positive_tests_age_40_49Number
Positive Tests - Age 40-49positive_tests_age_40_49positive_tests_age_40_49Number
Tests - Latinxtests_latinxtests_latinxNumber
Not-Positive Tests - Age 80+notpositive_tests_age_80notpositive_tests_age_80Number
Not-Positive Tests - Age 50-59not_positive_tests_age_50_59not_positive_tests_age_50_59Number
Positive Tests - Age Unknownpositive_tests_age_unknownpositive_tests_age_unknownNumber
Not-Positive Tests - Black Non-Latinxnot_positive_tests_black_non_latinxnot_positive_tests_black_non_latinxNumber
Positive Tests - Malepositive_tests_malepositive_tests_maleNumber
Not-Positive Tests - Malenot_positive_tests_malenot_positive_tests_maleNumber
Tests - Age 80+testsage_80testsage_80Number
Total Teststotal_teststotal_testsNumberTotal number of tests (positive plus not positive).
Tests - Asian Non-Latinxtests_asian_non_latinxtests_asian_non_latinxNumber
Positive Tests - Age 0-17positive_tests_age_0_17positive_tests_age_0_17Number
Positive Tests - Black Non-Latinxpositive_tests_black_non_latinxpositive_tests_black_non_latinxNumber
Positive Tests - Age 30-39positive_tests_age_30_39positive_tests_age_30_39Number
Not-Positive Tests - Age Unknownnot_positive_tests_age_unknownnot_positive_tests_age_unknownNumber
Not-Positive Tests - Latinxnot_positive_tests_latinxnot_positive_tests_latinxNumber
Not-Positive Tests - Gender Unknownnot_positive_tests_gender_unknownnot_positive_tests_gender_unknownNumber
Positive Testspositive_testspositive_testsNumberNumber of tests with a positive result.
Positive Tests - Unknown Genderpositive_tests_unknown_genderpositive_tests_unknown_genderNumber
Positive Tests - Age 70-79positive_tests_age_70_79positive_tests_age_70_79Number

Upstream Metadata