Icon for Socrata external plugin
Open repository in Console
Updated 2 years ago
Indexed 20 minutes ago

COVID-19 Daily Testing - By Person - Historical

This dataset is historical only and ends at 5/7/2021. For more information, please see The recommended alternative dataset for similar data beyond that date is

This is the source data for some of the metrics available at

For all datasets related to COVID-19, see

This dataset contains counts of people tested for COVID-19 and their results. This dataset differs from 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

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofchicago/covid19-daily-testing-by-person-historical-t4hh-4ku9\".\"covid19_daily_testing_by_person_historical\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_daily_testing_by_person_historical
Upstream Metadata