cdph-vaccination-zipcode-totals

Table actions

California's Department of Public Health is releasing zipcode-level vaccination totals. Our team extracts and logs the data each day. Population estimates from the U.S. Census Bureau, gathered by The Times, are used to calculate the percentage of the total population that is vaccinated.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date for which data were reported in ISO 8601 format.
id
The unique identifer of the ZIP Code.
county
The name of the county.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
population
The number of people who live in the county.
partially_vaccinated
The total number of partially vaccinated people as of this date.
at_least_one_dose
The total number of people who have received at least one dose any vaccine given as of this date.
fully_vaccinated
The total number of fully vaccinated people as of this date.
partially_vaccinated_percent
The percentage of people who were partially vaccinated as of this date.
at_least_one_dose_percent
The percentage of people who received at least one dose any vaccine as of this date.
fully_vaccinated_percent
The percentage of people who were fully vaccinated as of this date.

13 rows where at_least_one_dose_percent = "0.97" and "date" is on date 2022-07-12

✖
✖
✖

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid ▼ date id county fips population partially_vaccinated at_least_one_dose fully_vaccinated partially_vaccinated_percent at_least_one_dose_percent fully_vaccinated_percent
69401 69401 2022-07-12 90001 Los Angeles 37 58975.0 13334 57219 43885 0.23 0.97 0.74
69460 69460 2022-07-12 90069 Los Angeles 37 20435.0 2296 19923 17627 0.11 0.97 0.86
69826 69826 2022-07-12 92274 Riverside 65 15118.0 2043 14589 12546 0.14 0.97 0.83
69956 69956 2022-07-12 92657 Orange 59 9670.0 859 9337 8478 0.09 0.97 0.88
70264 70264 2022-07-12 94010 San Mateo 81 42730.0 3129 41554 38425 0.07 0.97 0.9
70278 70278 2022-07-12 94040 Santa Clara 85 35845.0 2827 34891 32064 0.08 0.97 0.89
70289 70289 2022-07-12 94074 San Mateo 81 197.0 23 191 168 0.12 0.97 0.85
70418 70418 2022-07-12 94611 Alameda 1 39384.0 2533 38274 35741 0.06 0.97 0.91
70432 70432 2022-07-12 94801 Contra Costa 13 29958.0 2071 29001 26930 0.07 0.97 0.9
70439 70439 2022-07-12 94904 Marin 41 12590.0 858 12222 11364 0.07 0.97 0.9
70451 70451 2022-07-12 94939 Marin 41 7108.0 480 6924 6444 0.07 0.97 0.91
70623 70623 2022-07-12 95377 San Joaquin 77 32501.0 2464 31519 29055 0.08 0.97 0.89
70717 70717 2022-07-12 95560 Humboldt 23 1466.0 135 1419 1284 0.09 0.97 0.88

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-vaccination-zipcode-totals" (
   [date] TEXT,
   [id] INTEGER,
   [county] TEXT,
   [fips] INTEGER,
   [population] FLOAT,
   [partially_vaccinated] INTEGER,
   [at_least_one_dose] INTEGER,
   [fully_vaccinated] INTEGER,
   [partially_vaccinated_percent] FLOAT,
   [at_least_one_dose_percent] FLOAT,
   [fully_vaccinated_percent] FLOAT
);