About this Dataset

COVID-19 Vaccine Progress Dashboard Data By ZIP Code

Note: In these datasets, a person is defined as up to date if they have received at least one dose of an updated COVID-19 vaccine. The Centers for Disease Control and Prevention (CDC) recommends that certain groups, including adults ages 65 years and older, receive additional doses.

Starting on July 13, 2022, the denominator for calculating vaccine coverage has been changed from age 5+ to all ages to reflect new vaccine eligibility criteria. Previously the denominator was changed from age 16+ to age 12+ on May 18, 2021, then changed from age 12+ to age 5+ on November 10, 2021, to reflect previous changes in vaccine eligibility criteria. The previous datasets based on age 12+ and age 5+ denominators have been uploaded as archived tables.

Starting June 30, 2021, the dataset has been reconfigured so that all updates are appended to one dataset to make it easier for API and other interfaces. In addition, historical data has been extended back to January 5, 2021.

This dataset shows full, partial, and at least 1 dose coverage rates by zip code tabulation area (ZCTA) for the state of California. Data sources include the California Immunization Registry and the American Community Survey’s 2015-2019 5-Year data.

This is the data table for the LHJ Vaccine Equity Performance dashboard. However, this data table also includes ZTCAs that do not have a VEM score.

This dataset also includes Vaccine Equity Metric score quartiles (when applicable), which combine the Public Health Alliance of Southern California’s Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. ZTCAs range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4.

The Vaccine Equity Metric is for weekly vaccination allocation and reporting purposes only. CDPH-derived quartiles should not be considered as indicative of the HPI score for these zip codes. CDPH-derived quartiles were assigned to zip codes excluded from the HPI score produced by the Public Health Alliance of Southern California due to concerns with statistical reliability and validity in populations smaller than 1,500 or where more than 50% of the population resides in a group setting.

These data do not include doses administered by the following federal agencies who received vaccine allocated directly from CDC: Indian Health Service, Veterans Health Administration, Department of Defense, and the Federal Bureau of Prisons.

For some ZTCAs, vaccination coverage may exceed 100%. This may be a result of many people from outside the county coming to that ZTCA to get their vaccine and providers reporting the county of administration as the county of residence, and/or the DOF estimates of the population in that ZTCA are too low. Please note that population numbers provided by DOF are projections and so may not be accurate, especially given unprecedented shifts in population as a result of the pandemic.
Organization: State of California
Last updated: 2025-07-23T14:32:37.128333
Tags: california-department-of-public-health, covid, covid-19, covid19, vaccines, zip-code

Tables

COVID-19 Vaccines Shipped, Delivered, On Hand, By County & Zip

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.covid_19_vaccines_shipped_delivered_on_hand_by_county_zip

10.5 MB
2237696 rows
30 columns


CREATE TABLE covid_19_vaccines_shipped_delivered_on_hand_by_county_zip (
  "date" TIMESTAMP,
  "county" VARCHAR,
  "zip" BIGINT,
  "doses_shipped" BIGINT,
  "cumulative_doses_shipped" DOUBLE,
  "doses_delivered" BIGINT,
  "cumulative_doses_delivered" DOUBLE,
  "cdc_pharmacy_doses_delivered" BIGINT,
  "cumulative_cdc_pharmacy_doses_delivered" DOUBLE,
  "doses_on_hand" BIGINT,
  "pfizer_doses_shipped" BIGINT,
  "cumulative_pfizer_doses_shipped" DOUBLE,
  "pfizer_doses_delivered" BIGINT,
  "cumulative_pfizer_doses_delivered" DOUBLE,
  "pfizer_doses_on_hand" BIGINT,
  "moderna_doses_shipped" BIGINT,
  "cumulative_moderna_doses_shipped" DOUBLE,
  "moderna_doses_delivered" BIGINT,
  "cumulative_moderna_doses_delivered" DOUBLE,
  "moderna_doses_on_hand" BIGINT,
  "jj_doses_shipped" BIGINT,
  "cumulative_jj_doses_shipped" DOUBLE,
  "jj_doses_delivered" BIGINT,
  "cumulative_jj_doses_delivered" DOUBLE,
  "jj_doses_on_hand" BIGINT,
  "pfizer_pediatric_doses_shipped" BIGINT,
  "cumulative_pfizer_pediatric_doses_shipped" DOUBLE,
  "pfizer_pediatric_doses_delivered" BIGINT,
  "cumulative_pfizer_pediatric_doses_delivered" DOUBLE,
  "pfizer_pediatric_doses_on_hand" BIGINT
);

Data Dictionary - COVID-19 Vaccines Shipped, Delivered, On Hand, By County & Zip

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.n__dictionary_covid_19_vaccines_shipped_delivered_on_h_ff5d16fe

3.52 KB
30 rows
4 columns


CREATE TABLE n__dictionary_covid_19_vaccines_shipped_delivered_on_h_ff5d16fe (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Statewide COVID-19 Vaccines Administered By Zip Code (Age 5+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.n__dictionary_statewide_covid_19_vaccines_administered_235cb94d

3.53 KB
15 rows
4 columns


CREATE TABLE n__dictionary_statewide_covid_19_vaccines_administered_235cb94d (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Statewide COVID-19 Vaccines Administered By Zip Code (Age 12+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.n__dictionary_statewide_covid_19_vaccines_administered_97496777

3.5 KB
13 rows
4 columns


CREATE TABLE n__dictionary_statewide_covid_19_vaccines_administered_97496777 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Statewide COVID-19 Vaccines Administered By Zip Code

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.n__dictionary_statewide_covid_19_vaccines_administered_cacb19b1

3.55 KB
16 rows
4 columns


CREATE TABLE n__dictionary_statewide_covid_19_vaccines_administered_cacb19b1 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Statewide COVID-19 Vaccines Administered By Zip Code (Age 5+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.statewide_covid_19_vaccines_administered_by_zip_code_a_5c588fc6

4.93 MB
139356 rows
15 columns


CREATE TABLE statewide_covid_19_vaccines_administered_by_zip_code_a_5c588fc6 (
  "as_of_date" TIMESTAMP,
  "zip_code_tabulation_area" BIGINT,
  "local_health_jurisdiction" VARCHAR,
  "county" VARCHAR,
  "vaccine_equity_metric_quartile" DOUBLE,
  "vem_source" VARCHAR,
  "age12_plus_population" DOUBLE,
  "age5_plus_population" BIGINT,
  "persons_fully_vaccinated" DOUBLE,
  "persons_partially_vaccinated" DOUBLE,
  "percent_of_population_fully_vaccinated" DOUBLE,
  "percent_of_population_partially_vaccinated" DOUBLE,
  "percent_of_population_with_1_plus_dose" DOUBLE,
  "booster_recip_count" DOUBLE,
  "redacted" VARCHAR
);

Statewide COVID-19 Vaccines Administered By Zip Code (Age 12+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_by_zip_code_edd80.statewide_covid_19_vaccines_administered_by_zip_code_a_e61c3f81

2.57 MB
77616 rows
13 columns


CREATE TABLE statewide_covid_19_vaccines_administered_by_zip_code_a_e61c3f81 (
  "as_of_date" TIMESTAMP,
  "zip_code_tabulation_area" BIGINT,
  "local_health_jurisdiction" VARCHAR,
  "county" VARCHAR,
  "vaccine_equity_metric_quartile" DOUBLE,
  "vem_source" VARCHAR,
  "age12_plus_population" DOUBLE,
  "persons_fully_vaccinated" DOUBLE,
  "persons_partially_vaccinated" DOUBLE,
  "percent_of_population_fully_vaccinated" DOUBLE,
  "percent_of_population_partially_vaccinated" DOUBLE,
  "percent_of_population_with_1_plus_dose" DOUBLE,
  "redacted" VARCHAR
);