COVID-19 Vaccination Coverage, Citywide

NOTE: This dataset replaces two previous ones. Please see below.

Chicago residents who are up to date with COVID-19 vaccines, based on the reported address, race-ethnicity, sex, and age group of the person vaccinated, as provided by the medical provider in the Illinois Comprehensive Automated Immunization Registry Exchange (I-CARE).

“Up to date” refers to individuals who meet the CDC’s updated COVID-19 vaccination criteria based on their age and prior vaccination history. For surveillance purposes, up to date is defined based on the following criteria:

People ages 5 years and older:

· Are up to date when they receive a single dose of an updates (2023-2024 formula) vaccine (Pfizer-BioNTech, Moderna, or Novavax) regardless of their prior vaccination history

Children aged 6 months to 4 years:

· Children who have received at least two prior COVID-19 vaccine doses are up to date when they receive one additional dose of updated COVID-19 vaccine (2023-2024 formula), regardless of vaccine product.

· Children who have received only one prior COVID-19 vaccine dose are up to date when they receive one additional dose of updated Moderna COVID-19 vaccine (2023-2024 formula) or two additional doses of updated Pfizer-BioNTech COVID-19 vaccine (2023-2024 formula).

· Children who have never received a COVID-19 vaccination are up to date when they receive either two doses of the updated Moderna vaccine (2023-2024 formula) or three doses of the updated Pfizer-BioNTech vaccine (2023-2024 formula)

This dataset takes the place of two previous datasets, which cover doses administered from December 15, 2020 through September 13, 2023 and will be marked as historical shortly after the launch of this dataset:

• https://data.cityofchicago.org/Health-Human-Services/COVID-19-Daily-Vaccinations-Chicago-Residents/2vhs-cf6b

• https://data.cityofchicago.org/Health-Human-Services/COVID-19-Vaccinations-by-Age-and-Race-Ethnicity/37ac-bbe3.

Data Notes:

Weekly cumulative totals of people up to date are shown for each combination of race-ethnicity, sex, and age group. Note that race-ethnicity, age, and sex all have an option for “All” so care should be taken when summing rows.

Coverage percentages are calculated based on the cumulative number of people in each race-ethnicity/age/sex population subgroup who are considered up to date as of the week ending date divided by the estimated number of people in that subgroup. Population counts are obtained from the 2020 U.S. Decennial Census. Actual counts may exceed population estimates and lead to coverage estimates that are greater than 100%, especially in smaller demographic groupings with smaller populations. Additionally, the medical provider may report incorrect demographic information for the person receiving the vaccination, which may lead to over- or underestimation of vaccination coverage. All coverage percentages are capped at 99%.

Weekly cumulative counts and coverage percentages are reported from the week ending Saturday, September 16, 2023 onward through the Saturday prior to the dataset being updated.

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.

CDPH uses the most complete data available to estimate COVID-19 vaccination coverage among Chicagoans, but there are several limitations that impact our estimates. Data reported in I-CARE only included doses administered in Illinois and some doses administered outside of Illinois reported historically by Illinois providers. Due to people receiving vaccinations that are not recorded in I-CARE that can be linked to their record, such as someone receiving a vaccine dose in anoth

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-vaccination-coverage-citywide-6859-spec\".\"covid19_vaccination_coverage_citywide\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.