COVID-19 Vaccinations by Age and Race-Ethnicity - 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-Citywide/6859-spec.

COVID-19 vaccinations administered to Chicago residents based on the reported race-ethnicity and age group of the person vaccinated, as provided by the medical provider in the Illinois Comprehensive Automated Immunization Registry Exchange (I-CARE).

Vaccination Status 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 an original booster dose: Number of people who have a completed vaccine series and have received at least one additional monovalent dose. This includes people who received a monovalent booster dose and immunocompromised people who received an additional primary dose of COVID-19 vaccine. Monovalent doses were created from the original strain of the virus that causes COVID-19.

• 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.

Weekly cumulative totals by vaccination status are shown for each combination of race-ethnicity and age group. Note that each age group has a row where race-ethnicity is "All" so care should be taken when summing rows.

Vaccinations are counted based on the date on which they were administered. Weekly cumulative totals are reported from the week ending Saturday, December 19, 2020 onward (after December 15, when vaccines were first administered in Chicago) through the Saturday prior to the dataset being updated.

Population counts are from the U.S. Census Bureau American Community Survey (ACS) 2019 1-year estimates. For some of the age groups by which COVID-19 vaccine has been authorized in the United States, race-ethnicity distributions were specifically reported in the ACS estimates. For others, race-ethnicity distributions were estimated by the Chicago Department of Public Health (CDPH) by weighting the available race-ethnicity distributions, using proportions of constituent age groups.

Coverage percentages are calculated based on the cumulative number of people in each population subgroup (age group by race-ethnicity) who have each vaccination status as of the date, divided by the estimated number of Chicago residents in each subgroup.

Actual counts may exceed population estimates and lead to >100% coverage, especially in small race-ethnicity subgroups of each age group. All coverage percentages are capped at 99%.

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 include doses administered in Illinois and some doses administered outside of Illinois reported historically by Illinois providers. Doses administered by the federal Bureau of Prisons and Department of Defense are also not currently reported in I-CARE. The Veterans Health Administration began reporting doses in I-CARE beginning September 2022. Due to people receiving vaccinations that are not recorded in I-CARE that c

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-age-and-raceethnicity-37ac-bbe3\".\"covid19_vaccinations_by_age_and_raceethnicity\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.