COVID-19 Cases, Tests, and Deaths by ZIP Code
COVID-19 Cases, Tests, and Deaths by ZIP Code
NOTE: Starting 2/9/2021, this dataset will be 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 1/5/2021, the pattern used to populate the unique Row ID column is changing but values will still be unique. Please see http://dev.cityofchicago.org/open%20data/data%20portal/2021/01/05/covid-by-zip-rowid.html for more information.
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.
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)
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Deaths - Weekly | deaths_weekly | deaths_weekly | Number | Number of deaths in the week. |
| Test Rate - Weekly | test_rate_weekly | test_rate_weekly | Number | Test rate per 100,000 population in the week. Because, as described in the dataset description, not all tests are reported, this rate is a low-end estimate. The true rate may be higher. |
| Population | population | population | Number | ZIP Code population. |
| Case Rate - Cumulative | case_rate_cumulative | case_rate_cumulative | Number | Total case rate per 100,000 population through the week. |
| Cases - Cumulative | cases_cumulative | cases_cumulative | Number | Total number of cases through the week. Values less than 5 are removed for privacy. A blank indicates a suppressed number from 0 to 4. |
| Row ID | row_id | row_id | Text | |
| Cases - Weekly | cases_weekly | cases_weekly | Number | Number of cases in the week. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases. A blank indicates a suppressed number from 0 to 4. |
| ZIP Code | zip_code | zip_code | Text | Home ZIP Code of the cases and people tested. |
| Tests - Cumulative | tests_cumulative | tests_cumulative | Number | Total number of tests through the week. Please note data limitations in the dataset description. |
| Week End | week_end | week_end | Calendar date | The last date of the week. |
| Week Number | week_number | week_number | Number | A sequential count of weeks, starting at the beginning of 2020. These numbers are aligned to CDC MMWR weeks. |
| Percent Tested Positive - Cumulative | percent_tested_positive_cumulative | percent_tested_positive_cumulative | Number | Percentage of tests returning positive results through the week based on specimen collection date. Because, as described in the dataset description, some not-positive tests may not be received, this rate is a high-end estimate. The true rate may be lower. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases. |
| Death Rate - Cumulative | death_rate_cumulative | death_rate_cumulative | Number | Death rate per 100,000 population through the week. |
| Case Rate - Weekly | case_rate_weekly | case_rate_weekly | Number | Case rate per 100,000 population in the week. |
| Death Rate - Weekly | death_rate_weekly | death_rate_weekly | Number | Death rate per 100,000 population in the week. |
| Percent Tested Positive - Weekly | percent_tested_positive_weekly | percent_tested_positive_weekly | Number | Percentage of tests returning positive results in the week based on specimen collection date. Because, as described in the dataset description, some not-positive tests may not be received, this rate is a high-end estimate. The true rate may be lower. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases. |
| Test Rate - Cumulative | test_rate_cumulative | test_rate_cumulative | Number | Total test rate per 100,000 population through the week. Because, as described in the dataset description, not all tests are reported, this rate is a low-end estimate. The true rate may be higher. |
| Tests - Weekly | tests_weekly | tests_weekly | Number | Number of tests in the week. Please note data limitations in the dataset description. |
| Week Start | week_start | week_start | Calendar date | The first date of the week. |
| ZIP Code Location | zip_code_location | zip_code_location | Point | A point within the ZIP Code to allow for geographic analysis. The precise point shown has no other meaning. |
| Zip Codes | :@computed_region_6mkv_f3dw | :@computed_region_6mkv_f3dw | Number | |
| Census Tracts | :@computed_region_bdys_3d7i | :@computed_region_bdys_3d7i | Number | |
| Wards | :@computed_region_43wa_7qmu | :@computed_region_43wa_7qmu | Number | |
| Community Areas | :@computed_region_vrxf_vc4k | :@computed_region_vrxf_vc4k | Number | |
| Boundaries - ZIP Codes | :@computed_region_rpca_8um6 | :@computed_region_rpca_8um6 | Number | |
| Deaths - Cumulative | deaths_cumulative | deaths_cumulative | Number | Number of deaths through the week. |