COVID-19 Daily Vaccinations - Chicago Residents - 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 home address, as reported by medical providers in the Illinois Comprehensive Automated Immunization Registry Exchange (I-CARE). I-CARE includes doses administered in Illinois and some doses administered outside of Illinois and reported in I-CARE by Illinois providers.

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.

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

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, number of people with a monovalent booster dose, and number of people with a bivalent dose. Cumulative totals are also provided for each measure as of that date. Vaccinations are counted based on the day the vaccine was administered.

Coverage percentages for the City of Chicago are calculated based on cumulative number of people with that vaccination status.

Daily totals of all doses, number of people with at least one vaccine dose, number of people who have completed a vaccine series, number of people with a booster dose, and number of people with a bivalent dose are shown by age group, gender, and race/ethnicity.

Denominators are from the U.S. Census Bureau American Community Survey 1-year estimate for 2019 and can be seen in the Citywide, 2019 row of the Chicago Population Counts dataset (https://data.cityofchicago.org/d/85cm-7uqa).

The Chicago Department of Health (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 can be linked to their record, such as someone receiving a vaccine dose in another state, the number of people with a completed series or a booster dose is underestimated. Inconsistencies in records of separate doses administered to the same person, such as slight variations in dates of birth, can result in duplicate first dose records for a person and overestimate of the number of people with at least one dose and underestimate the number of people with a completed series or booster dose.

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

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-daily-vaccinations-chicago-residents-2vhs-cf6b\".\"covid19_daily_vaccinations_chicago_residents\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.