la-times: cdph-vaccination-county-by-race-ethnicity: 1 row where population_12_and

California's Department of Public Health releases county-level vaccination totals segemented by race and ethnicity. The racial groups provided by the state have been simplified to the categories commonly used by Los Angeles Times.

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

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.
date: The date for which data were reported in ISO 8601 format.
race_ethnicity: The race group being tallied.
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.
population_total: The number of people who live in the county.
population_12_and_up: The number of people 12 years or older who live in the county.
partially_vaccinated_percent: The percentage of people who were partially vaccinated as of this date.
partially_vaccinated_percent_12_and_up: The percentage of people 12 and up 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.
at_least_one_dose_percent_12_and_up: The percentage of people 12 and up 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.
fully_vaccinated_percent_12_and_up: The percentage of people 12 and up who were fully vaccinated as of this date.

1 row where population_12_and_up = 78302

descending

✎ View and edit SQL

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

Link	rowid ▼	race_ethnicity	county	fips	date	partially_vaccinated	at_least_one_dose	fully_vaccinated	population_total	population_12_and_up	partially_vaccinated_percent	partially_vaccinated_percent_12_and_up	at_least_one_dose_percent	at_least_one_dose_percent_12_and_up	fully_vaccinated_percent	fully_vaccinated_percent_12_and_up	race_label
151	151	unknown	Sacramento	67	2022-12-20	21828.0	159022.0	137194.0	100954	78302	0.2162172870812449	0.2787668258792878	0.999	0.999	0.999	0.999	Unknown

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "cdph-vaccination-county-by-race-ethnicity" (
   [race_ethnicity] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [partially_vaccinated] FLOAT,
   [at_least_one_dose] FLOAT,
   [fully_vaccinated] FLOAT,
   [population_total] INTEGER,
   [population_12_and_up] INTEGER,
   [partially_vaccinated_percent] FLOAT,
   [partially_vaccinated_percent_12_and_up] FLOAT,
   [at_least_one_dose_percent] FLOAT,
   [at_least_one_dose_percent_12_and_up] FLOAT,
   [fully_vaccinated_percent] FLOAT,
   [fully_vaccinated_percent_12_and_up] FLOAT,
   [race_label] TEXT
);