cityofchicago/covid19-daily-testing-by-person-t4hh-4ku9

 
External

COVID-19 Daily Testing - By Person

  • covid-19
  • ethnicity
  • gender
  • health
  • public health
  • And 2 more...

COVID-19 Daily Testing - By Person

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.

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
People Tested - Age Unknownpeople_tested_age_unknownpeople_tested_age_unknownNumber
People Tested - Age 30-39people_tested_age_30_39people_tested_age_30_39Number
People Not-Positive - Age 18-29people_not_positive_age_18_29people_not_positive_age_18_29Number
People Positive - Age 30-30people_positive_age_30_39people_positive_age_30_39Number
People Tested - Unknown Race/Ethnicitypeople_tested_unknown_race_ethnicitypeople_tested_unknown_race_ethnicityNumber
People Tested - Other Race Non-Latinxpeople_tested_other_race_non_latinxpeople_tested_other_race_non_latinxNumber
People Tested - Black Non-Latinxpeople_tested_black_non_latinxpeople_tested_black_non_latinxNumber
People Tested - Age 60-69people_tested_age_60_69people_tested_age_60_69Number
People Tested - Age 50-59people_tested_age_50_59people_tested_age_50_59Number
People Not-Positive - Age Unknownpeople_not_positive_age_unknownpeople_not_positive_age_unknownNumber
People Positive - Age 80+peoplepositive_age_80peoplepositive_age_80Number
People Positive - Age 50-59people_positive_age_50_59people_positive_age_50_59Number
People Tested - Asian Non-Latinxpeople_tested_asian_non_latinxpeople_tested_asian_non_latinxNumber
People Positive - Age Unknownpeople_positive_age_unknownpeople_positive_age_unknownNumber
People Tested - Malepeople_tested_malepeople_tested_maleNumber
People Positive - Age 18-29people_positive_age_18_29people_positive_age_18_29Number
People Positive - Gender Unknownpeople_positive_gender_unknownpeople_positive_gender_unknownNumber
People Positive - Latinxpeople_positive_latinxpeople_positive_latinxNumber
People Positive - White Non-Latinxpeople_positive_white_non_latinxpeople_positive_white_non_latinxNumber
People Not-Positive - Latinxpeople_not_positive_latinxpeople_not_positive_latinxNumber
DaydaydayTextDay of the week.
People Positive - Totalpeople_positive_totalpeople_positive_totalNumber
DatedatedateCalendar dateTest specimen collection date. Blank indicates unknown date. Note that although a positive test in this dataset will correspond to a case in other datasets, the dates will not necessarily match.
People Tested - Totalpeople_tested_totalpeople_tested_totalNumber
People Tested - Age 40-49people_tested_age_40_49people_tested_age_40_49Number
People Positive - Other Race Non-Latinxpeople_positive_other_race_non_latinxpeople_positive_other_race_non_latinxNumber
People Not-Positive - Totalpeople_not_positive_totalpeople_not_positive_totalNumberNot-positive tests are not necessarily negative tests. See the dataset description for specific limitations.
People Tested - Age 18-29people_tested_age_18_29people_tested_age_18_29Number
People Tested - White Non-Latinxpeople_tested_white_non_latinxpeople_tested_white_non_latinxNumber
People Positive - Age 60-69people_positive_age_60_69people_positive_age_60_69Number
People Tested - Latinxpeople_tested_latinxpeople_tested_latinxNumber
People Tested - Age 0-17people_tested_age_0_17people_tested_age_0_17Number
People Positive - Age 0-17people_positive_age_0_17people_positive_age_0_17Number
People Not-Positive - Age 70-79people_not_positive_age_70_79people_not_positive_age_70_79Number
People Positive - Unknown Race/Ethnicitypeople_positive_unknown_race_ethnicitypeople_positive_unknown_race_ethnicityNumber
People Tested - Age 70-79people_tested_age_70_79people_tested_age_70_79Number
People Positive - Age 40-49people_positive_age_40_49people_positive_age_40_49Number
People Positive - Asian Non-Latinxpeople_positive_asian_non_latinxpeople_positive_asian_non_latinxNumber
People Not-Positive - Age 0-17people_not_positive_age_0_17people_not_positive_age_0_17Number
People Not-Positive - Age 50-59people_not_positive_age_50_59people_not_positive_age_50_59Number
People Tested - Age 80+peopletested_age_80peopletested_age_80Number
People Not-Positive - Gender Unknownpeople_not_positive_gender_unknownpeople_not_positive_gender_unknownNumber
People Not-Positive - White Non-Latinxpeople_not_positive_white_non_latinxpeople_not_positive_white_non_latinxNumber
People Positive - Femalepeople_positive_femalepeople_positive_femaleNumber
People Not-Positive - Age 30-39people_not_positive_age_30_39people_not_positive_age_30_39Number
People Not-Positive - Femalepeople_not_positive_femalepeople_not_positive_femaleNumber
People Not-Positive - Asian Non-Latinxpeople_not_positive_asian_non_latinxpeople_not_positive_asian_non_latinxNumber
People Not-Positive - Unknown Race/Ethnicitypeople_not_positive_unknown_race_ethnicitypeople_not_positive_unknown_race_ethnicityNumber
People Not-Positive - Other Race Non-Latinxpeople_not_positive_other_race_non_latinxpeople_not_positive_other_race_non_latinxNumber
People Not-Positive - Black Non-Latinxpeople_not_positive_black_non_latinxpeople_not_positive_black_non_latinxNumber
People Not-Positive - Malepeople_not_positive_malepeople_not_positive_maleNumber
People Not-Positive - Age 80+peoplenot_positive_age_80peoplenot_positive_age_80Number
People Not-Positive - Age 60-69people_not_positive_age_60_69people_not_positive_age_60_69Number
People Not-Positive - Age 40-49people_not_positive_age_40_49people_not_positive_age_40_49Number
People Positive - Black Non-Latinxpeople_positive_black_non_latinxpeople_positive_black_non_latinxNumber
People Positive - Malepeople_positive_malepeople_positive_maleNumber
People Positive - Age 70-79people_positive_age_70_79people_positive_age_70_79Number
People Tested - Gender Unknownpeople_tested_gender_unknownpeople_tested_gender_unknownNumber
People Tested - Femalepeople_tested_femalepeople_tested_femaleNumber

Upstream Metadata