COVID-19 Cases, Tests, and Deaths by ZIP Code - Historical
data.cityofchicago.org | Last Updated 23 May 2024NOTE: 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)
This dataset has the following 21 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ZIP Code | zip_code | text | Home ZIP Code of the cases and people tested. | 60601 60602 60603 60604 60605 view top 100 |
| Week Number | week_number | number | A sequential count of weeks, starting at the beginning of 2020. These numbers are aligned to CDC MMWR weeks. | 20 17 10 13 16 view top 100 |
| Week Start | week_start | calendar_date | The first date of the week. | 2024-05-12T00:00:00.000 2020-03-08T00:00:00.000 2020-03-15T00:00:00.000 2020-03-22T00:00:00.000 2020-03-29T00:00:00.000 view top 100 |
| Week End | week_end | calendar_date | The last date of the week. | 2024-05-18T00:00:00.000 2020-03-14T00:00:00.000 2020-03-21T00:00:00.000 2020-03-28T00:00:00.000 2020-04-04T00:00:00.000 view top 100 |
| 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. | 0 1 2 5 3 view top 100 |
| 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. | 12 13 11 23 15 view top 100 |
| Case Rate - Weekly | case_rate_weekly | number | Case rate per 100,000 population in the week. | 0 85.2 7 80.4 127.9 view top 100 |
| Case Rate - Cumulative | case_rate_cumulative | number | Total case rate per 100,000 population through the week. | 0 64450.1 40755.6 6814.3 511.1 view top 100 |
| Tests - Weekly | tests_weekly | number | Number of tests in the week. Please note data limitations in the dataset description. | 0 3 2 4 1 view top 100 |
| Tests - Cumulative | tests_cumulative | number | Total number of tests through the week. Please note data limitations in the dataset description. | 0 807 4388 813 811 view top 100 |
| 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. | 0 255.5 895.1 767.3 241.2 view top 100 |
| 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. | 0 2823.9 10200.1 2844.9 2837.9 view top 100 |
| 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. | 0 0.031 0.034 0.026 0.025 view top 100 |
| 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. | 0 0.051 0.05 0.054 0.059 view top 100 |
| Deaths - Weekly | deaths_weekly | number | Number of deaths in the week. | 0 1 2 3 4 view top 100 |
| Deaths - Cumulative | deaths_cumulative | number | Number of deaths through the week. | 0 2 9 3 15 view top 100 |
| Death Rate - Weekly | death_rate_weekly | number | Death rate per 100,000 population in the week. | 0 1.1 1.4 3.4 2.1 view top 100 |
| Death Rate - Cumulative | death_rate_cumulative | number | Death rate per 100,000 population through the week. | 0 20.1 241.2 66.5 153.5 view top 100 |
| Population | population | number | ZIP Code population. | 0 782 1174 1244 3101 view top 100 |
| Row ID | row_id | text | 60601-2020-11 60601-2020-12 60601-2020-13 60601-2020-14 60601-2020-15 view top 100 | |
| 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. | {"coordinates":[-87.629029,41.878153],"type":"Point"} {"coordinates":[-87.670366,41.849879],"type":"Point"} {"coordinates":[-87.771902,41.787032],"type":"Point"} {"coordinates":[-87.761826,41.993931],"type":"Point"} {"coordinates":[-87.661343,41.953742],"type":"Point"} view top 100 |