la-times: cdph-vaccination-county-by-race-ethnicity: 1 row where "date" is on date 2022-12-20 and partially

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 "date" is on date 2022-12-20 and partially_vaccinated = "1070.0"

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
207	207	asian	Marin	41	2022-12-20	1070.0	15413.0	14343.0	16471	15085	0.0649626616477445	0.070931388796818	0.9357658915669964	0.999	0.870803229919252	0.9508120649651972	Asian or Pacific Islander

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