COVID-19 Vaccinations by ZIP Code - Historical

NOTE: This dataset has been retired and marked as historical-only. The recommended dataset to use in its place is https://data.cityofchicago.org/Health-Human-Services/COVID-19-Vaccination-Coverage-ZIP-Code/2ani-ic5x.

NOTE, 3/30/2023: We have added columns for bivalent (updated) doses to this dataset. We have also added age group columns for 0-17 and 18-64 and stopped updating the 5+ and 12+ columns, although previously published values remain for those columns.

COVID-19 vaccinations administered to Chicago residents based on the home ZIP Code of the person vaccinated, as provided by the medical provider in the Illinois Comprehensive Automated Immunization Registry Exchange (I-CARE). The ZIP Code where a person lives is not necessarily the same ZIP Code where the vaccine was administered.

Definitions:

·People with at least one vaccine dose: Number of people who have received at least one dose of any COVID-19 vaccine, including the single-dose Johnson & Johnson COVID-19 vaccine.

·People with a completed vaccine series: Number of people who have completed a primary COVID-19 vaccine series. Requirements vary depending on age and type of primary vaccine series received.

·People with a bivalent dose: Number of people who received a bivalent (updated) dose of vaccine. Updated, bivalent doses became available in Fall 2022 and were created with the original strain of COVID-19 and newer Omicron variant strains.

·Total doses administered: Number of all COVID-19 vaccine doses administered.

Data Notes:

Daily counts are shown for the total number of doses administered, number of people with at least one vaccine dose, number of people who have a completed vaccine series, and number of people who have received a bivalent dose. Cumulative totals for each measure as of that date are also provided. Vaccinations are counted based on the day the vaccine was administered.

Coverage percentages are calculated based on cumulative number of people who have received at least one vaccine dose, cumulative number of people who have a completed vaccine series, and cumulative number of people who have received a bivalent dose in each ZIP Code.

Population counts are from the U.S. Census Bureau American Community Survey 2015-2019 5-year estimates and can be seen in the ZIP Code, 2019 rows of the Chicago Population Counts dataset (https://data.cityofchicago.org/d/85cm-7uqa).

Actual counts may exceed population estimates and lead to >100% coverage, especially in areas with small population sizes. Additionally, the medical provider may report a work address or incorrect home address for the person receiving the vaccination which may lead to over or under estimates of vaccination coverage by geography. 

All data are provisional and subject to change. Information is updated as additional details are received and it is, in fact, very common for recent dates to be incomplete and to be updated as time goes on. At any given time, this dataset reflects data currently known to CDPH.

Numbers in this dataset may differ from other public sources due to when data are reported and how City of Chicago boundaries are defined.

For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.

Data Source: Illinois Comprehensive Automated Immunization Registry Exchange (I-CARE), U.S. Census Bureau American Community Survey

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/covid19-vaccinations-by-zip-code-historical-553k-3xzc\".\"covid19_vaccinations_by_zip_code_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.