About this Dataset

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
Organization: City of Chicago
Last updated: 2021-08-07T17:59:49.127508
Tags: covid-19, gender, health, historical, link-to-article-present, public-health, vaccination

Tables

Table 1

@usgov.city_of_chicago_covid_19_daily_vaccinations_chicago_residents.table_1

505.4 kB
1,003 rows
155 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "total_doses_daily" BIGINT  -- Total Doses - Daily,
  "total_doses_cumulative" BIGINT  -- Total Doses - Cumulative,
  "n_1st_dose_daily" BIGINT  -- 1st Dose - Daily,
  "n_1st_dose_cumulative" BIGINT  -- 1st Dose - Cumulative,
  "n_1st_dose_percent_population" DOUBLE  -- 1st Dose - Percent Population,
  "vaccine_series_completed_daily" BIGINT  -- Vaccine Series Completed - Daily,
  "vaccine_series_completed_cumulative" BIGINT  -- Vaccine Series Completed - Cumulative,
  "vaccine_series_completed_percent_population" DOUBLE  -- Vaccine Series Completed - Percent Population,
  "booster_daily" BIGINT  -- Booster - Daily,
  "booster_cumulative" BIGINT  -- Booster - Cumulative,
  "booster_percent_population" DOUBLE  -- Booster - Percent Population,
  "bivalent_daily" BIGINT  -- Bivalent - Daily,
  "bivalent_cumulative" BIGINT  -- Bivalent - Cumulative,
  "bivalent_percent_population" DOUBLE  -- Bivalent - Percent Population,
  "total_doses_daily_age_0_17" BIGINT  -- Total Doses - Daily - Age 0-17,
  "total_doses_daily_age_18_29" BIGINT  -- Total Doses - Daily - Age 18-29,
  "total_doses_daily_age_30_39" BIGINT  -- Total Doses - Daily - Age 30-39,
  "total_doses_daily_age_40_49" BIGINT  -- Total Doses - Daily - Age 40-49,
  "total_doses_daily_age_50_59" BIGINT  -- Total Doses - Daily - Age 50-59,
  "total_doses_daily_age_60_69" BIGINT  -- Total Doses - Daily - Age 60-69,
  "total_doses_daily_age_70_79" BIGINT  -- Total Doses - Daily - Age 70-79,
  "total_doses_daily_age_80" BIGINT  -- Total Doses - Daily - Age 80+,
  "total_doses_daily_age_0_4" BIGINT  -- Total Doses - Daily - Age 0-4,
  "total_doses_daily_age_5_11" BIGINT  -- Total Doses - Daily - Age 5-11,
  "total_doses_daily_age_12_17" BIGINT  -- Total Doses - Daily - Age 12-17,
  "total_doses_daily_age_5" BIGINT  -- Total Doses - Daily - Age 5+,
  "total_doses_daily_age_12" BIGINT  -- Total Doses - Daily - Age 12+,
  "total_doses_daily_age_18" BIGINT  -- Total Doses - Daily - Age 18+,
  "total_doses_daily_age_65" BIGINT  -- Total Doses - Daily - Age 65+,
  "total_doses_daily_age_75" BIGINT  -- Total Doses - Daily - Age 75+,
  "total_doses_daily_unknown_age" BIGINT  -- Total Doses - Daily - Unknown Age,
  "total_doses_daily_female" BIGINT  -- Total Doses - Daily - Female,
  "total_doses_daily_male" BIGINT  -- Total Doses - Daily - Male,
  "total_doses_daily_unknown_gender" BIGINT  -- Total Doses - Daily - Unknown Gender,
  "total_doses_daily_latinx" BIGINT  -- Total Doses - Daily - Latinx,
  "total_doses_daily_asian_non_latinx" BIGINT  -- Total Doses - Daily - Asian Non-Latinx,
  "total_doses_daily_black_non_latinx" BIGINT  -- Total Doses - Daily - Black Non-Latinx,
  "total_doses_daily_white_non_latinx" BIGINT  -- Total Doses - Daily - White Non-Latinx,
  "total_doses_daily_american_indian_alaska_native_non_latinx" BIGINT  -- Total Doses - Daily - American Indian/Alaska Native Non-Latinx,
  "total_doses_daily_pacific_islander_hawaiian_native_non_latinx" BIGINT  -- Total Doses - Daily - Pacific Islander/Hawaiian Native Non-Latinx,
  "total_doses_daily_other_non_latinx" BIGINT  -- Total Doses - Daily - Other Non-Latinx,
  "total_doses_daily_unknown_race_ethnicity" BIGINT  -- Total Doses - Daily - Unknown Race/Ethnicity,
  "n_1st_dose_daily_age_0_17" BIGINT  -- 1st Dose - Daily - Age 0-17,
  "n_1st_dose_daily_age_18_29" BIGINT  -- 1st Dose - Daily - Age 18-29,
  "n_1st_dose_daily_age_30_39" BIGINT  -- 1st Dose - Daily - Age 30-39,
  "n_1st_dose_daily_age_40_49" BIGINT  -- 1st Dose - Daily - Age 40-49,
  "n_1st_dose_daily_age_50_59" BIGINT  -- 1st Dose - Daily - Age 50-59,
  "n_1st_dose_daily_age_60_69" BIGINT  -- 1st Dose - Daily - Age 60-69,
  "n_1st_dose_daily_age_70_79" BIGINT  -- 1st Dose - Daily - Age 70-79,
  "n_1st_dose_daily_age_80" BIGINT  -- 1st Dose - Daily - Age 80+,
  "n_1st_dose_daily_age_0_4" BIGINT  -- 1st Dose - Daily - Age 0-4,
  "n_1st_dose_daily_age_5_11" BIGINT  -- 1st Dose - Daily - Age 5-11,
  "n_1st_dose_daily_age_12_17" BIGINT  -- 1st Dose - Daily - Age 12-17,
  "n_1st_dose_daily_age_5" BIGINT  -- 1st Dose - Daily - Age 5+,
  "n_1st_dose_daily_age_12" BIGINT  -- 1st Dose - Daily - Age 12+,
  "n_1st_dose_daily_age_18" BIGINT  -- 1st Dose - Daily - Age 18+,
  "n_1st_dose_daily_age_65" BIGINT  -- 1st Dose - Daily - Age 65+,
  "n_1st_dose_daily_age_75" BIGINT  -- 1st Dose - Daily - Age 75+,
  "n_1st_dose_daily_unknown_age" BIGINT  -- 1st Dose - Daily - Unknown Age,
  "n_1st_dose_daily_female" BIGINT  -- 1st Dose - Daily - Female,
  "n_1st_dose_daily_male" BIGINT  -- 1st Dose - Daily - Male,
  "n_1st_dose_daily_unknown_gender" BIGINT  -- 1st Dose - Daily - Unknown Gender,
  "n_1st_dose_daily_latinx" BIGINT  -- 1st Dose - Daily - Latinx,
  "n_1st_dose_daily_asian_non_latinx" BIGINT  -- 1st Dose - Daily - Asian Non-Latinx,
  "n_1st_dose_daily_black_non_latinx" BIGINT  -- 1st Dose - Daily - Black Non-Latinx,
  "n_1st_dose_daily_white_non_latinx" BIGINT  -- 1st Dose - Daily - White Non-Latinx,
  "n_1st_dose_daily_american_indian_alaska_native_non_latinx" BIGINT  -- 1st Dose - Daily - American Indian/Alaska Native Non-Latinx,
  "n_1st_dose_daily_pacific_islander_hawaiian_native_non_latinx" BIGINT  -- 1st Dose - Daily - Pacific Islander/Hawaiian Native Non-Latinx,
  "n_1st_dose_daily_other_race_non_latinx" BIGINT  -- 1st Dose - Daily - Other Race Non-Latinx,
  "n_1st_dose_daily_unknown_race_ethnicity" BIGINT  -- 1st Dose - Daily - Unknown Race/Ethnicity,
  "vaccine_series_completed_daily_age_0_17" BIGINT  -- Vaccine Series Completed - Daily - Age 0-17,
  "vaccine_series_completed_daily_age_18_29" BIGINT  -- Vaccine Series Completed - Daily - Age 18-29,
  "vaccine_series_completed_daily_age_30_39" BIGINT  -- Vaccine Series Completed - Daily - Age 30-39,
  "vaccine_series_completed_daily_age_40_49" BIGINT  -- Vaccine Series Completed - Daily - Age 40-49,
  "vaccine_series_completed_daily_age_50_59" BIGINT  -- Vaccine Series Completed - Daily - Age 50-59,
  "vaccine_series_completed_daily_age_60_69" BIGINT  -- Vaccine Series Completed - Daily - Age 60-69,
  "vaccine_series_completed_daily_age_70_79" BIGINT  -- Vaccine Series Completed - Daily - Age 70-79,
  "vaccine_series_completed_daily_age_80" BIGINT  -- Vaccine Series Completed - Daily - Age 80+,
  "vaccine_series_completed_daily_age_0_4" BIGINT  -- Vaccine Series Completed - Daily - Age 0-4,
  "vaccine_series_completed_daily_age_5_11" BIGINT  -- Vaccine Series Completed - Daily - Age 5-11,
  "vaccine_series_completed_daily_age_12_17" BIGINT  -- Vaccine Series Completed - Daily - Age 12-17,
  "vaccine_series_completed_daily_age_5" BIGINT  -- Vaccine Series Completed - Daily - Age 5+,
  "vaccine_series_completed_daily_age_12" BIGINT  -- Vaccine Series Completed - Daily - Age 12+,
  "vaccine_series_completed_daily_age_18" BIGINT  -- Vaccine Series Completed - Daily - Age 18+,
  "vaccine_series_completed_daily_age_65" BIGINT  -- Vaccine Series Completed - Daily - Age 65+,
  "vaccine_series_completed_daily_age_75" BIGINT  -- Vaccine Series Completed - Daily - Age 75+,
  "vaccine_series_completed_daily_unknown_age" BIGINT  -- Vaccine Series Completed - Daily - Unknown Age,
  "vaccine_series_completed_daily_female" BIGINT  -- Vaccine Series Completed - Daily - Female,
  "vaccine_series_completed_daily_male" BIGINT  -- Vaccine Series Completed - Daily - Male,
  "vaccine_series_completed_daily_unknown_gender" BIGINT  -- Vaccine Series Completed - Daily - Unknown Gender,
  "vaccine_series_completed_daily_latinx" BIGINT  -- Vaccine Series Completed - Daily - Latinx,
  "vaccine_series_completed_daily_asian_non_latinx" BIGINT  -- Vaccine Series Completed - Daily - Asian Non-Latinx,
  "vaccine_series_completed_daily_black_non_latinx" BIGINT  -- Vaccine Series Completed - Daily - Black Non-Latinx,
  "vaccine_series_completed_daily_white_non_latinx" BIGINT  -- Vaccine Series Completed - Daily - White Non-Latinx,
  "vaccine_series_completed_daily_american_indian_alaska__42213b49" BIGINT  -- Vaccine Series Completed - Daily - American Indian/Alaska Native Non-Latinx,
  "vaccine_series_completed_daily_pacific_islander_hawaii_fbb89576" BIGINT  -- Vaccine Series Completed - Daily - Pacific Islander/Hawaiian Native Non-Latinx,
  "vaccine_series_completed_daily_other_race_non_latinx" BIGINT  -- Vaccine Series Completed - Daily - Other Race Non-Latinx,
  "vaccine_series_completed_daily_unknown_race_ethnicity" BIGINT  -- Vaccine Series Completed - Daily - Unknown Race/Ethnicity,
  "booster_daily_age_0_17" BIGINT  -- Booster - Daily - Age 0-17
);