Chicago

Author: Jonathan Levy
Description: NOTE: This dataset has been retired and marked as historical-only. Only Chicago residents are included based on the home ZIP Code as provided by the medical provider. If a ZIP was missing or was not valid, it is displayed as "Unknown". Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the week the test specimen was collected. For privacy reasons, until a ZIP Code reaches five cumulative cases, both the weekly and cumulative case counts will be blank. Therefore, summing the “Cases - Weekly” column is not a reliable way to determine case totals. Deaths are those that have occurred among cases based on the week of death. For tests, each test is counted once, based on the week the test specimen was collected. Tests performed prior to 3/1/2020 are not included. Test counts include multiple tests for the same person (a change made on 10/29/2020). PCR and antigen tests reported to Chicago Department of Public Health (CDPH) through electronic lab reporting are included. Electronic lab reporting has taken time to onboard and testing availability has shifted over time, so these counts are likely an underestimate of community infection. The “Percent Tested Positive” columns are calculated by dividing the number of positive tests by the number of total tests . Because of the data limitations for the Tests columns, such as persons being tested multiple times as a requirement for employment, these percentages may vary in either direction from the actual disease prevalence in the ZIP Code. All data are provisional and subject to change. Information is updated as additional details are received. To compare ZIP Codes to Chicago Community Areas, please see http://data.cmap.illinois.gov/opendata/uploads/CKAN/NONCENSUS/ADMINISTRATIVE_POLITICAL_BOUNDARIES/CCAzip.pdf. Both ZIP Codes and Community Areas are also geographic datasets on this data portal. Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, Illinois Vital Records, American Community Survey (2018)
Category: Health & Human Services
Tags: covid-19, health, public health, death, zip code, link to article present, historical
Rating: Current value: 0 out of 5
Data Provided By: City of Chicago
Source Link: https://chicago.gov/coronavirus
License: See Terms of Use

COVID-19 Cases, Tests, and Deaths by ZIP Code - HistoricalNOTE: This dataset has been retired and marked as historical-only. Only Chicago residents are included based on the home ZIP Code as provided by the medical provider. If a ZIP was missing or was not valid, it is displayed as "Unknown". Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the week the test specimen was collected. For privacy reasons, until a ZIP Code reaches five cumulative cases, both the weekly and cumulative case counts will be blank. Therefore, summing the “Cases - Weekly” column is not a reliable way to determine case totals. Deaths are those that have occurred among cases based on the week of death. For tests, each test is counted once, based on the week the test specimen was collected. Tests performed prior to 3/1/2020 are not included. Test counts include multiple tests for the same person (a change made on 10/29/2020). PCR and antigen tests reported to Chicago Department of Public Health (CDPH) through electronic lab reporting are included. Electronic lab reporting has taken time to onboard and testing availability has shifted over time, so these counts are likely an underestimate of community infection. The “Percent Tested Positive” columns are calculated by dividing the number of positive tests by the number of total tests . Because of the data limitations for the Tests columns, such as persons being tested multiple times as a requirement for employment, these percentages may vary in either direction from the actual disease prevalence in the ZIP Code. All data are provisional and subject to change. Information is updated as additional details are received. To compare ZIP Codes to Chicago Community Areas, please see http://data.cmap.illinois.gov/opendata/uploads/CKAN/NONCENSUS/ADMINISTRATIVE_POLITICAL_BOUNDARIES/CCAzip.pdf. Both ZIP Codes and Community Areas are also geographic datasets on this data portal. Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, Illinois Vital Records, American Community Survey (2018)Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><p style="margin-bottom:3px"><a href="https://data.cityofchicago.org/Health-Human-Services/COVID-19-Cases-Tests-and-Deaths-by-ZIP-Code-Histor/yhhz-zm2v" target="_blank" style="font-size:12px;font-weight:bold;text-decoration:none;color:#333333;font-family:arial;">COVID-19 Cases, Tests, and Deaths by ZIP Code - Historical</a></p><iframe width="_width_px" title="COVID-19 Cases, Tests, and Deaths by ZIP Code - Historical" height="_height_px" src="https://data.cityofchicago.org/w/yhhz-zm2v/3q3f-6823?cur=y5dXJ91gwQr&from=2l68_8iAeqk" frameborder="0"scrolling="no"><a href="https://data.cityofchicago.org/Health-Human-Services/COVID-19-Cases-Tests-and-Deaths-by-ZIP-Code-Histor/yhhz-zm2v" title="COVID-19 Cases, Tests, and Deaths by ZIP Code - Historical" target="_blank">COVID-19 Cases, Tests, and Deaths by ZIP Code - Historical</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ZIP Code: zip_code
Week Number: week_number
Week Start: week_start
Week End: week_end
Cases - Weekly: cases_weekly
Cases - Cumulative: cases_cumulative
Case Rate - Weekly: case_rate_weekly
Case Rate - Cumulative: case_rate_cumulative
Tests - Weekly: tests_weekly
Tests - Cumulative: tests_cumulative
Test Rate - Weekly: test_rate_weekly
Test Rate - Cumulative: test_rate_cumulative
Percent Tested Positive - Weekly: percent_tested_positive_weekly
Percent Tested Positive - Cumulative: percent_tested_positive_cumulative
Deaths - Weekly: deaths_weekly
Deaths - Cumulative: deaths_cumulative
Death Rate - Weekly: death_rate_weekly
Death Rate - Cumulative: death_rate_cumulative
Population: population
Row ID: row_id
ZIP Code Location: zip_code_location
Boundaries - ZIP Codes: :@computed_region_rpca_8um6
Community Areas: :@computed_region_vrxf_vc4k
Zip Codes: :@computed_region_6mkv_f3dw
Census Tracts: :@computed_region_bdys_3d7i
Wards: :@computed_region_43wa_7qmu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

Chicago

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.cityofchicago.org.

Notice