la-times: cdph-vaccination-zipcode-totals: 6 rows where at_least_one_dose_percent = "0.92", "date" is on date 2022-08-30 and partially_vaccinated

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.

6 rows where at_least_one_dose_percent = "0.92", "date" is on date 2022-08-30 and partially_vaccinated_percent = "0.06"

✖

descending

✎ 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
80578	80578	2022-08-30	90056	Los Angeles	37	7795.0	498	7163	6665	0.06	0.92	0.86
81462	81462	2022-08-30	94501	Alameda	1	63843.0	3643	58677	55034	0.06	0.92	0.86
81537	81537	2022-08-30	94597	Contra Costa	13	22734.0	1303	20995	19692	0.06	0.92	0.87
81541	81541	2022-08-30	94602	Alameda	1	29933.0	1685	27499	25814	0.06	0.92	0.86
81558	81558	2022-08-30	94706	Alameda	1	21040.0	1276	19303	18027	0.06	0.92	0.86
81654	81654	2022-08-30	95131	Santa Clara	85	31170.0	1880	28832	26952	0.06	0.92	0.86

Advanced export

JSON shape: default, array, newline-delimited

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
);