cdph-vaccination-county-totals
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.
- 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.
- doses_administered
- The total number of doses given as of this date.
- new_doses_administered
- The number of new doses compared to the previous date.
- pfizer_doses
- The total number of Pfizer doses given as of this date.
- new_pfizer_doses
- The number of new Pfizer doses compared to the previous date.
- moderna_doses
- The total number of Moderna doses given as of this date.
- new_moderna_doses
- The number of new Moderna doses compared to the previous date.
- jj_doses
- The total number of Johnson & Johnson doses given as of this date.
- new_jj_doses
- The number of new Johnson & Johnson doses compared to the previous date.
- partially_vaccinated
- The total number of partially vaccinated people as of this date.
- new_partially_vaccinated
- The number of new partially vaccinated people compared to the previous date.
- at_least_one_dose
- The total number of people who have received at least one dose any vaccine given as of this date.
- new_at_least_one_dose
- The number of new people who have received at least one dose any vaccine compared to the previous date.
- fully_vaccinated
- The total number of fully vaccinated people as of this date.
- new_fully_vaccinated
- The number of new fully vaccinated people compared to the previous 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.
58 rows where "date" is on date 2020-08-29
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | population | doses_administered | new_doses_administered | pfizer_doses | new_pfizer_doses | moderna_doses | new_moderna_doses | jj_doses | new_jj_doses | partially_vaccinated | new_partially_vaccinated | at_least_one_dose | new_at_least_one_dose | fully_vaccinated | new_fully_vaccinated | partially_vaccinated_percent | at_least_one_dose_percent | fully_vaccinated_percent |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49301 | 49301 | 2020-08-29 | Alameda | 1 | 1643700.0 | 37 | 0 | 34.0 | 0 | 3.0 | 0 | 0.0 | 0 | 37.0 | 0 | 37.0 | 0 | 0.0 | 0 | 2.251019042404332e-05 | 2.251019042404332e-05 | 0.0 |
49302 | 49302 | 2020-08-29 | Alpine | 3 | 1148.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49303 | 49303 | 2020-08-29 | Amador | 5 | 37829.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.643474582991885e-05 | 2.643474582991885e-05 | 0.0 |
49304 | 49304 | 2020-08-29 | Butte | 7 | 227075.0 | 6 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 6.0 | 0 | 6.0 | 0 | 0.0 | 0 | 2.6422987999559612e-05 | 2.6422987999559612e-05 | 0.0 |
49305 | 49305 | 2020-08-29 | Calaveras | 9 | 45235.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49306 | 49306 | 2020-08-29 | Colusa | 11 | 21464.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49307 | 49307 | 2020-08-29 | Contra Costa | 13 | 1133247.0 | 40 | 0 | 38.0 | 0 | 2.0 | 0 | 0.0 | 0 | 34.0 | 0 | 37.0 | 0 | 3.0 | 0 | 3.000228546821655e-05 | 3.2649545950706246e-05 | 2.647260482489696e-06 |
49308 | 49308 | 2020-08-29 | Del Norte | 15 | 27424.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 7.292882147024503e-05 | 7.292882147024503e-05 | 0.0 |
49309 | 49309 | 2020-08-29 | El Dorado | 17 | 186661.0 | 3 | 0 | 0.0 | 0 | 3.0 | 0 | 0.0 | 0 | 1.0 | 0 | 2.0 | 0 | 1.0 | 0 | 5.357305489630936e-06 | 1.0714610979261871e-05 | 5.357305489630936e-06 |
49310 | 49310 | 2020-08-29 | Fresno | 19 | 978130.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.044717982272295e-06 | 2.044717982272295e-06 | 0.0 |
49311 | 49311 | 2020-08-29 | Glenn | 21 | 27897.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 7.169229666272359e-05 | 7.169229666272359e-05 | 0.0 |
49312 | 49312 | 2020-08-29 | Humboldt | 23 | 135768.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 7.365505862942667e-06 | 7.365505862942667e-06 | 0.0 |
49313 | 49313 | 2020-08-29 | Imperial | 25 | 180216.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 1.109779375860079e-05 | 1.109779375860079e-05 | 0.0 |
49314 | 49314 | 2020-08-29 | Inyo | 27 | 18085.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49315 | 49315 | 2020-08-29 | Kern | 29 | 883053.0 | 4 | 0 | 3.0 | 0 | 1.0 | 0 | 0.0 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 4.529739438063174e-06 | 4.529739438063174e-06 | 0.0 |
49316 | 49316 | 2020-08-29 | Kings | 31 | 150075.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 6.663334999167083e-06 | 6.663334999167083e-06 | 0.0 |
49317 | 49317 | 2020-08-29 | Lake | 33 | 64148.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49318 | 49318 | 2020-08-29 | Lassen | 35 | 31185.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 3.20666987333654e-05 | 3.20666987333654e-05 | 0.0 |
49319 | 49319 | 2020-08-29 | Los Angeles | 37 | 10098052.0 | 160 | 9 | 131.0 | 7 | 29.0 | 2 | 0.0 | 0 | 142.0 | 9 | 151.0 | 9 | 9.0 | 0 | 1.4062118119415508e-05 | 1.4953379126984095e-05 | 8.912610075685885e-07 |
49320 | 49320 | 2020-08-29 | Madera | 39 | 155013.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49321 | 49321 | 2020-08-29 | Marin | 41 | 260295.0 | 3 | 0 | 1.0 | 0 | 2.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 1.1525384659713018e-05 | 1.1525384659713018e-05 | 0.0 |
49322 | 49322 | 2020-08-29 | Mariposa | 43 | 17540.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49323 | 49323 | 2020-08-29 | Mendocino | 45 | 87422.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.1438768273432316e-05 | 1.1438768273432316e-05 | 0.0 |
49324 | 49324 | 2020-08-29 | Merced | 47 | 269075.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 3.71643593793552e-06 | 3.71643593793552e-06 | 0.0 |
49325 | 49325 | 2020-08-29 | Modoc | 49 | 8938.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49326 | 49326 | 2020-08-29 | Mono | 51 | 14174.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49327 | 49327 | 2020-08-29 | Monterey | 53 | 433212.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.308338642512211e-06 | 2.308338642512211e-06 | 0.0 |
49328 | 49328 | 2020-08-29 | Napa | 55 | 140530.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49329 | 49329 | 2020-08-29 | Nevada | 57 | 99092.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49330 | 49330 | 2020-08-29 | Orange | 59 | 3164182.0 | 46 | 0 | 35.0 | 0 | 11.0 | 0 | 0.0 | 0 | 36.0 | 0 | 41.0 | 0 | 5.0 | 0 | 1.137734807921921e-05 | 1.29575353124441e-05 | 1.5801872332248903e-06 |
49331 | 49331 | 2020-08-29 | Placer | 61 | 380077.0 | 8 | 0 | 5.0 | 0 | 3.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 2.104836651520613e-05 | 2.104836651520613e-05 | 0.0 |
49332 | 49332 | 2020-08-29 | Plumas | 63 | 18699.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49333 | 49333 | 2020-08-29 | Riverside | 65 | 2383286.0 | 28 | 1 | 3.0 | 0 | 25.0 | 1 | 0.0 | 0 | 24.0 | 0 | 26.0 | 0 | 2.0 | 1 | 1.0070130064121554e-05 | 1.0909307569465016e-05 | 8.391775053434627e-07 |
49334 | 49334 | 2020-08-29 | Sacramento | 67 | 1510023.0 | 66 | 1 | 33.0 | 1 | 33.0 | 0 | 0.0 | 0 | 56.0 | 1 | 61.0 | 1 | 5.0 | 0 | 3.708552783633097e-05 | 4.039673567886052e-05 | 3.311207842529551e-06 |
49335 | 49335 | 2020-08-29 | San Benito | 69 | 59416.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49336 | 49336 | 2020-08-29 | San Bernardino | 71 | 2135413.0 | 14 | 0 | 4.0 | 0 | 10.0 | 0 | 0.0 | 0 | 12.0 | 0 | 13.0 | 0 | 1.0 | 0 | 5.619521844252142e-06 | 6.087815331273154e-06 | 4.682934870210119e-07 |
49337 | 49337 | 2020-08-29 | San Diego | 73 | 3302833.0 | 214 | 4 | 61.0 | 0 | 153.0 | 4 | 0.0 | 0 | 183.0 | 4 | 198.0 | 4 | 15.0 | 0 | 5.540697940222833e-05 | 5.994853509093557e-05 | 4.54155568870724e-06 |
49338 | 49338 | 2020-08-29 | San Francisco | 75 | 870044.0 | 11 | 0 | 8.0 | 0 | 3.0 | 0 | 0.0 | 0 | 11.0 | 0 | 11.0 | 0 | 0.0 | 0 | 1.2643038742868176e-05 | 1.2643038742868176e-05 | 0.0 |
49339 | 49339 | 2020-08-29 | San Joaquin | 77 | 732212.0 | 8 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 4.0 | 0 | 6.0 | 0 | 2.0 | 0 | 5.4628987233205685e-06 | 8.194348084980852e-06 | 2.731449361660284e-06 |
49340 | 49340 | 2020-08-29 | San Luis Obispo | 79 | 281455.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 7.10593167646693e-06 | 7.10593167646693e-06 | 0.0 |
49341 | 49341 | 2020-08-29 | San Mateo | 81 | 765935.0 | 17 | 0 | 15.0 | 0 | 2.0 | 0 | 0.0 | 0 | 17.0 | 0 | 17.0 | 0 | 0.0 | 0 | 2.219509488403063e-05 | 2.219509488403063e-05 | 0.0 |
49342 | 49342 | 2020-08-29 | Santa Barbara | 83 | 443738.0 | 3 | 0 | 3.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 6.760746206094587e-06 | 6.760746206094587e-06 | 0.0 |
49343 | 49343 | 2020-08-29 | Santa Clara | 85 | 1922200.0 | 40 | 0 | 36.0 | 0 | 4.0 | 0 | 0.0 | 0 | 40.0 | 0 | 40.0 | 0 | 0.0 | 0 | 2.080948912704193e-05 | 2.080948912704193e-05 | 0.0 |
49344 | 49344 | 2020-08-29 | Santa Cruz | 87 | 273765.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 7.305535769729512e-06 | 7.305535769729512e-06 | 0.0 |
49345 | 49345 | 2020-08-29 | Shasta | 89 | 179085.0 | 111 | 0 | 41.0 | 0 | 70.0 | 0 | 0.0 | 0 | 111.0 | 0 | 111.0 | 0 | 0.0 | 0 | 0.0006198174051428 | 0.0006198174051428 | 0.0 |
49346 | 49346 | 2020-08-29 | Sierra | 91 | 2930.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49347 | 49347 | 2020-08-29 | Siskiyou | 93 | 43540.0 | 3 | 0 | 3.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 6.890215893431327e-05 | 6.890215893431327e-05 | 0.0 |
49348 | 49348 | 2020-08-29 | Solano | 95 | 438530.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 4.560691400816364e-06 | 4.560691400816364e-06 | 0.0 |
49349 | 49349 | 2020-08-29 | Sonoma | 97 | 501317.0 | 2 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 3.989491678917731e-06 | 3.989491678917731e-06 | 0.0 |
49350 | 49350 | 2020-08-29 | Stanislaus | 99 | 539301.0 | 8 | 0 | 6.0 | 0 | 2.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 1.4834016625224132e-05 | 1.4834016625224132e-05 | 0.0 |
49351 | 49351 | 2020-08-29 | Sutter | 101 | 95872.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49352 | 49352 | 2020-08-29 | Tehama | 103 | 63373.0 | 8 | 0 | 2.0 | 0 | 6.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 0.0001262367254193 | 0.0001262367254193 | 0.0 |
49353 | 49353 | 2020-08-29 | Trinity | 105 | 12862.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 7.774840615767377e-05 | 7.774840615767377e-05 | 0.0 |
49354 | 49354 | 2020-08-29 | Tulare | 107 | 460477.0 | 0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 |
49355 | 49355 | 2020-08-29 | Tuolumne | 109 | 53932.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.854186753689832e-05 | 1.854186753689832e-05 | 0.0 |
49356 | 49356 | 2020-08-29 | Ventura | 111 | 848112.0 | 7 | 0 | 5.0 | 0 | 2.0 | 0 | 0.0 | 0 | 3.0 | 0 | 5.0 | 0 | 2.0 | 0 | 3.537268662629464e-06 | 5.895447771049107e-06 | 2.3581791084196427e-06 |
49357 | 49357 | 2020-08-29 | Yolo | 113 | 214977.0 | 21 | 0 | 8.0 | 0 | 13.0 | 0 | 0.0 | 0 | 17.0 | 0 | 19.0 | 0 | 2.0 | 0 | 7.907822697311805e-05 | 8.838154779348488e-05 | 9.30332082036683e-06 |
49358 | 49358 | 2020-08-29 | Yuba | 115 | 75493.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.3246261242764227e-05 | 1.3246261242764227e-05 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-vaccination-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [population] FLOAT, [doses_administered] INTEGER, [new_doses_administered] INTEGER, [pfizer_doses] FLOAT, [new_pfizer_doses] INTEGER, [moderna_doses] FLOAT, [new_moderna_doses] INTEGER, [jj_doses] FLOAT, [new_jj_doses] INTEGER, [partially_vaccinated] FLOAT, [new_partially_vaccinated] INTEGER, [at_least_one_dose] FLOAT, [new_at_least_one_dose] INTEGER, [fully_vaccinated] FLOAT, [new_fully_vaccinated] INTEGER, [partially_vaccinated_percent] FLOAT, [at_least_one_dose_percent] FLOAT, [fully_vaccinated_percent] FLOAT );