About this Dataset

COVID-19 Vaccine Progress Dashboard Data

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.

On 6/16/2023 CDPH replaced the booster measures with a new “Up to Date” measure based on CDC’s new recommendations, replacing the primary series, boosted, and bivalent booster metrics The definition of “primary series complete” has not changed and is based on previous recommendations that CDC has since simplified. A person cannot complete their primary series with a single dose of an updated vaccine. Whereas the booster measures were calculated using the eligible population as the denominator, the new up to date measure uses the total estimated population. Please note that the rates for some groups may change since the up to date measure is calculated differently than the previous booster and bivalent measures.

This data is from the same source as the Vaccine Progress Dashboard at https://covid19.ca.gov/vaccination-progress-data/ which summarizes vaccination data at the county level by county of residence. Where county of residence was not reported in a vaccination record, the county of provider that vaccinated the resident is included. This applies to less than 1% of vaccination records. The sum of county-level vaccinations does not equal statewide total vaccinations due to out-of-state residents vaccinated in California.

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.

Totals for the Vaccine Progress Dashboard and this dataset may not match, as the Dashboard totals doses by Report Date and this dataset totals doses by Administration Date. Dose numbers may also change for a particular Administration Date as data is updated.

Previous updates:

On March 3, 2023, with the release of HPI 3.0 in 2022, the previous equity scores have been updated to reflect more recent community survey information. This change represents an improvement to the way CDPH monitors health equity by using the latest and most accurate community data available. The HPI uses a collection of data sources and indicators to calculate a measure of community conditions ranging from the most to the least healthy based on economic, housing, and environmental measures.
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 16+ and age 5+ denominators have been uploaded as archived tables.
Starting on May 29, 2021 the methodology for calculating on-hand inventory in the shipped/delivered/on-hand dataset has changed. Please see the accompanying data dictionary for details. In addition, this dataset is now down to the ZIP code level.
Organization: State of California
Last updated: 2024-11-26T22:07:49.880150
Tags: age, california-department-of-public-health, covid, covid-19, covid19, delivered, demographics, equity, gender, race-ethnicity, shipped, vaccines

Tables

COVID-19 Vaccines Administered By Demographics

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics

1.17 MB
34706 rows
13 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics (
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT
);

COVID-19 Vaccines Administered By Demographics (2023-2024 Updated Vaccine Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_2023_20_02a9551e

1.05 MB
28679 rows
13 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_2023_20_02a9551e (
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT
);

COVID-19 Vaccines Administered By Demographics (Booster Metric Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_booster_2c3220fd

1.34 MB
18697 rows
23 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_booster_2c3220fd (
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "pfizer_doses" BIGINT,
  "cumulative_pfizer_doses" BIGINT,
  "moderna_doses" BIGINT,
  "cumulative_moderna_doses" BIGINT,
  "jj_doses" BIGINT,
  "cumulative_jj_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "booster_recip_count" BIGINT,
  "bivalent_booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "cumulative_bivalent_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT,
  "bivalent_booster_eligible_population" BIGINT
);

COVID-19 Vaccines Administered By Demographics By County (2023-2024 Updated Vaccine Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_by_coun_6757291f

26.21 MB
2240180 rows
21 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_by_coun_6757291f (
  "county" VARCHAR,
  "county_type" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "est_population" DOUBLE,
  "est_age_12plus_pop" DOUBLE,
  "est_age_5plus_pop" DOUBLE,
  "administered_date" TIMESTAMP,
  "partially_vaccinated" DOUBLE,
  "total_partially_vaccinated" DOUBLE,
  "fully_vaccinated" DOUBLE,
  "cumulative_fully_vaccinated" DOUBLE,
  "at_least_one_dose" DOUBLE,
  "cumulative_at_least_one_dose" DOUBLE,
  "cumulative_unvax_total_pop" DOUBLE,
  "cumulative_unvax_12plus_pop" DOUBLE,
  "cumulative_unvax_5plus_pop" DOUBLE,
  "suppress_data" BOOLEAN,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT,
  "administered_year" BIGINT
);

COVID-19 Vaccines Administered By Demographics By County (Booster Metric Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_by_coun_8c116917

28.13 MB
1565487 rows
25 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_by_coun_8c116917 (
  "county" VARCHAR,
  "county_type" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "est_population" DOUBLE,
  "est_age_12plus_pop" DOUBLE,
  "est_age_5plus_pop" DOUBLE,
  "administered_date" TIMESTAMP,
  "partially_vaccinated" DOUBLE,
  "total_partially_vaccinated" DOUBLE,
  "fully_vaccinated" DOUBLE,
  "cumulative_fully_vaccinated" DOUBLE,
  "at_least_one_dose" DOUBLE,
  "cumulative_at_least_one_dose" DOUBLE,
  "cumulative_unvax_total_pop" DOUBLE,
  "cumulative_unvax_12plus_pop" DOUBLE,
  "cumulative_unvax_5plus_pop" DOUBLE,
  "suppress_data" BOOLEAN,
  "booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "bivalent_booster_recip_count" BIGINT,
  "cumulative_bivalent_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT,
  "bivalent_booster_eligible_population" BIGINT,
  "administered_year" BIGINT
);

COVID-19 Vaccines Administered By Demographics By County (Age 5+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_by_coun_a6dd502f

11.27 MB
799517 rows
21 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_by_coun_a6dd502f (
  "county" VARCHAR,
  "county_type" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "est_population" DOUBLE,
  "est_age_12plus_pop" DOUBLE,
  "est_age_5plus_pop" DOUBLE,
  "administered_date" TIMESTAMP,
  "partially_vaccinated" DOUBLE,
  "total_partially_vaccinated" DOUBLE,
  "fully_vaccinated" DOUBLE,
  "cumulative_fully_vaccinated" DOUBLE,
  "at_least_one_dose" DOUBLE,
  "cumulative_at_least_one_dose" DOUBLE,
  "cumulative_unvax_total_pop" DOUBLE,
  "cumulative_unvax_12plus_pop" DOUBLE,
  "cumulative_unvax_5plus_pop" DOUBLE,
  "suppress_data" BOOLEAN,
  "booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT
);

COVID-19 Vaccines Administered By Demographics By County (Age 16+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_by_coun_de4a6abb

3.19 MB
154462 rows
16 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_by_coun_de4a6abb (
  "county" VARCHAR,
  "county_type" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "est_population" DOUBLE,
  "est_age_16plus_pop" DOUBLE,
  "administered_date" TIMESTAMP,
  "partially_vaccinated" DOUBLE,
  "total_partially_vaccinated" DOUBLE,
  "fully_vaccinated" DOUBLE,
  "cumulative_fully_vaccinated" DOUBLE,
  "at_least_one_dose" DOUBLE,
  "cumulative_at_least_one_dose" DOUBLE,
  "cumulative_unvax_total_pop" DOUBLE,
  "cumulative_unvax_16plus_pop" DOUBLE,
  "suppress_data" BOOLEAN
);

COVID-19 Vaccines Administered By Demographics By County

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_demographics_by_county

28.77 MB
2708440 rows
21 columns


CREATE TABLE covid_19_vaccines_administered_by_demographics_by_county (
  "county" VARCHAR,
  "county_type" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_value" VARCHAR,
  "est_population" DOUBLE,
  "est_age_12plus_pop" DOUBLE,
  "est_age_5plus_pop" DOUBLE,
  "administered_date" TIMESTAMP,
  "partially_vaccinated" DOUBLE,
  "total_partially_vaccinated" DOUBLE,
  "fully_vaccinated" DOUBLE,
  "cumulative_fully_vaccinated" DOUBLE,
  "at_least_one_dose" DOUBLE,
  "cumulative_at_least_one_dose" DOUBLE,
  "cumulative_unvax_total_pop" DOUBLE,
  "cumulative_unvax_12plus_pop" DOUBLE,
  "cumulative_unvax_5plus_pop" DOUBLE,
  "suppress_data" BOOLEAN,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT,
  "administered_year" BIGINT
);

COVID-19 Vaccines Administered By HPI Quartile

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_hpi_quartile

509.15 KB
7366 rows
24 columns


CREATE TABLE covid_19_vaccines_administered_by_hpi_quartile (
  "hpiquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age12pop_partially_vaccinated" VARCHAR,
  "pct_age5pop_partially_vaccinated" VARCHAR,
  "pct_totpop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age12pop_fully_vaccinated" VARCHAR,
  "pct_age5pop_fully_vaccinated" VARCHAR,
  "pct_totpop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age12pop_at_least_one_dose" VARCHAR,
  "pct_age5pop_at_least_one_dose" VARCHAR,
  "pct_totpop_at_least_one_dose" DOUBLE,
  "age12_population" VARCHAR,
  "age5_population" VARCHAR,
  "tot_population" BIGINT,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT
);

COVID-19 Vaccines Administered By HPI Quartile (2023-2024 Updated Vaccine Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_hpi_quartile_2023_20_0a9895e6

451.05 KB
6084 rows
24 columns


CREATE TABLE covid_19_vaccines_administered_by_hpi_quartile_2023_20_0a9895e6 (
  "hpiquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age12pop_partially_vaccinated" VARCHAR,
  "pct_age5pop_partially_vaccinated" VARCHAR,
  "pct_totpop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age12pop_fully_vaccinated" VARCHAR,
  "pct_age5pop_fully_vaccinated" VARCHAR,
  "pct_totpop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age12pop_at_least_one_dose" VARCHAR,
  "pct_age5pop_at_least_one_dose" VARCHAR,
  "pct_totpop_at_least_one_dose" DOUBLE,
  "age12_population" VARCHAR,
  "age5_population" VARCHAR,
  "tot_population" BIGINT,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT
);

COVID-19 Vaccines Administered By HPI Quartile (Booster Metric Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_hpi_quartile_booster_7561dc79

497.4 KB
4238 rows
34 columns


CREATE TABLE covid_19_vaccines_administered_by_hpi_quartile_booster_7561dc79 (
  "hpiquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "pfizer_doses" BIGINT,
  "cumulative_pfizer_doses" BIGINT,
  "moderna_doses" BIGINT,
  "cumulative_moderna_doses" BIGINT,
  "jj_doses" BIGINT,
  "cumulative_jj_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age12pop_partially_vaccinated" VARCHAR,
  "pct_age5pop_partially_vaccinated" VARCHAR,
  "pct_totpop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age12pop_fully_vaccinated" VARCHAR,
  "pct_age5pop_fully_vaccinated" VARCHAR,
  "pct_totpop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age12pop_at_least_one_dose" VARCHAR,
  "pct_age5pop_at_least_one_dose" VARCHAR,
  "pct_totpop_at_least_one_dose" DOUBLE,
  "age12_population" VARCHAR,
  "age5_population" VARCHAR,
  "tot_population" BIGINT,
  "booster_recip_count" BIGINT,
  "bivalent_booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "cumulative_bivalent_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT,
  "bivalent_booster_eligible_population" BIGINT
);

COVID-19 Vaccines Administered By VEM Quartile

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_vem_quartile

839.75 KB
7364 rows
22 columns


CREATE TABLE covid_19_vaccines_administered_by_vem_quartile (
  "vemquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age12pop_partially_vaccinated" DOUBLE,
  "pct_age5pop_partially_vaccinated" DOUBLE,
  "pct_totpop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age12pop_fully_vaccinated" DOUBLE,
  "pct_age5pop_fully_vaccinated" DOUBLE,
  "pct_totpop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age12pop_at_least_one_dose" DOUBLE,
  "pct_age5pop_at_least_one_dose" DOUBLE,
  "pct_totpop_at_least_one_dose" DOUBLE,
  "age12_population" BIGINT,
  "age5_population" BIGINT,
  "tot_population" BIGINT
);

COVID-19 Vaccines Administered By VEM Quartile (Age 16+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_vem_quartile_age_16_archived

79.88 KB
616 rows
20 columns


CREATE TABLE covid_19_vaccines_administered_by_vem_quartile_age_16_archived (
  "vemquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "pfizer_doses" BIGINT,
  "cumulative_pfizer_doses" BIGINT,
  "moderna_doses" BIGINT,
  "cumulative_moderna_doses" BIGINT,
  "jj_doses" BIGINT,
  "cumulative_jj_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age16pop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age16pop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age16pop_at_least_one_dose" DOUBLE,
  "age16_population" BIGINT
);

COVID-19 Vaccines Administered By VEM Quartile (Age 5+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_administered_by_vem_quartile_age_5_archived

383.18 KB
2821 rows
27 columns


CREATE TABLE covid_19_vaccines_administered_by_vem_quartile_age_5_archived (
  "vemquartile" BIGINT,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "pfizer_doses" BIGINT,
  "cumulative_pfizer_doses" BIGINT,
  "moderna_doses" BIGINT,
  "cumulative_moderna_doses" BIGINT,
  "jj_doses" BIGINT,
  "cumulative_jj_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "pct_age12pop_partially_vaccinated" DOUBLE,
  "pct_age5pop_partially_vaccinated" DOUBLE,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "pct_age12pop_fully_vaccinated" DOUBLE,
  "pct_age5pop_fully_vaccinated" DOUBLE,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "pct_age12pop_at_least_one_dose" DOUBLE,
  "pct_age5pop_at_least_one_dose" DOUBLE,
  "age12_population" BIGINT,
  "age5_population" BIGINT,
  "booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT
);

COVID-19 Vaccines Shipped, Delivered, On Hand (archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.covid_19_vaccines_shipped_delivered_on_hand_archived

96.42 KB
927 rows
28 columns


CREATE TABLE covid_19_vaccines_shipped_delivered_on_hand_archived (
  "date" TIMESTAMP,
  "doses_shipped" BIGINT,
  "cumulative_doses_shipped" BIGINT,
  "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" BIGINT,
  "pfizer_doses_delivered" BIGINT,
  "cumulative_pfizer_doses_delivered" DOUBLE,
  "pfizer_doses_on_hand" BIGINT,
  "moderna_doses_shipped" BIGINT,
  "cumulative_moderna_doses_shipped" BIGINT,
  "moderna_doses_delivered" BIGINT,
  "cumulative_moderna_doses_delivered" DOUBLE,
  "moderna_doses_on_hand" BIGINT,
  "jj_doses_shipped" BIGINT,
  "cumulative_jj_doses_shipped" BIGINT,
  "jj_doses_delivered" BIGINT,
  "cumulative_jj_doses_delivered" DOUBLE,
  "jj_doses_on_hand" BIGINT,
  "pfizer_pediatric_doses_shipped" BIGINT,
  "cumulative_pfizer_pediatric_doses_shipped" BIGINT,
  "pfizer_pediatric_doses_delivered" BIGINT,
  "cumulative_pfizer_pediatric_doses_delivered" DOUBLE,
  "pfizer_pediatric_doses_on_hand" BIGINT
);

Data Dictionary - COVID-19 Vaccines Administered By Demographics By County (Age 5+ Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.n__dictionary_covid_19_vaccines_administered_by_demogr_39c39220

3.57 KB
21 rows
4 columns


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

Data Dictionary - COVID-19 Vaccines Administered By Demographics

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.n__dictionary_covid_19_vaccines_administered_by_demographics

3.41 KB
13 rows
4 columns


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

Data Dictionary - Statewide COVID-19 Vaccines Administered By County (Booster Metric Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.n__dictionary_statewide_covid_19_vaccines_administered_673e502f

3.56 KB
23 rows
4 columns


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

Data Dictionary - Statewide COVID-19 Vaccines Administered By County (2023-2024 Updated Vaccine Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.n__dictionary_statewide_covid_19_vaccines_administered_bf297759

3.4 KB
13 rows
4 columns


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

Statewide COVID-19 Vaccines Administered By County (2023-2024 Updated Vaccine Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.statewide_covid_19_vaccines_administered_by_county_202_9384301e

2.44 MB
94674 rows
13 columns


CREATE TABLE statewide_covid_19_vaccines_administered_by_county_202_9384301e (
  "county" VARCHAR,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "california_flag" VARCHAR,
  "up_to_date_count" BIGINT,
  "cumulative_up_to_date_count" BIGINT
);

Statewide COVID-19 Vaccines Administered By County (Booster Metric Archived)

@usgov.ca_gov_covid_19_vaccine_progress_dashboard_data_b9673.statewide_covid_19_vaccines_administered_by_county_boo_486095e5

3.27 MB
66092 rows
23 columns


CREATE TABLE statewide_covid_19_vaccines_administered_by_county_boo_486095e5 (
  "county" VARCHAR,
  "administered_date" TIMESTAMP,
  "total_doses" BIGINT,
  "cumulative_total_doses" BIGINT,
  "pfizer_doses" BIGINT,
  "cumulative_pfizer_doses" BIGINT,
  "moderna_doses" BIGINT,
  "cumulative_moderna_doses" BIGINT,
  "jj_doses" BIGINT,
  "cumulative_jj_doses" BIGINT,
  "partially_vaccinated" BIGINT,
  "total_partially_vaccinated" BIGINT,
  "fully_vaccinated" BIGINT,
  "cumulative_fully_vaccinated" BIGINT,
  "at_least_one_dose" BIGINT,
  "cumulative_at_least_one_dose" BIGINT,
  "california_flag" VARCHAR,
  "booster_recip_count" BIGINT,
  "bivalent_booster_recip_count" BIGINT,
  "cumulative_booster_recip_count" BIGINT,
  "cumulative_bivalent_booster_recip_count" BIGINT,
  "booster_eligible_population" BIGINT,
  "bivalent_booster_eligible_population" BIGINT
);