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-09-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_partially_vaccinated
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47445 | 47445 | 2020-09-30 | Alameda | 1 | 1643700.0 | 105 | 5 | 98.0 | 4 | 7.0 | 1 | 0.0 | 0 | 13.0 | 1 | 59.0 | 1 | 46.0 | 4 | 7.908985824663868e-06 | 3.589462797347448e-05 | 2.798564214881061e-05 |
47446 | 47446 | 2020-09-30 | 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 |
47447 | 47447 | 2020-09-30 | Amador | 5 | 37829.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.643474582991885e-05 | 2.643474582991885e-05 | 0.0 |
47448 | 47448 | 2020-09-30 | Butte | 7 | 227075.0 | 17 | 0 | 7.0 | 0 | 10.0 | 0 | 0.0 | 0 | 9.0 | 0 | 13.0 | 0 | 4.0 | 0 | 3.963448199933943e-05 | 5.724980733237917e-05 | 1.7615325333039744e-05 |
47449 | 47449 | 2020-09-30 | Calaveras | 9 | 45235.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 2.2106775726760254e-05 | 2.2106775726760254e-05 |
47450 | 47450 | 2020-09-30 | 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 |
47451 | 47451 | 2020-09-30 | Contra Costa | 13 | 1133247.0 | 103 | 2 | 96.0 | 2 | 6.0 | 0 | 1.0 | 0 | 9.0 | 0 | 56.0 | 0 | 47.0 | 2 | 7.941781447469087e-06 | 4.941552900647432e-05 | 4.147374755900523e-05 |
47452 | 47452 | 2020-09-30 | Del Norte | 15 | 27424.0 | 4 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 7.292882147024503e-05 | 7.292882147024503e-05 |
47453 | 47453 | 2020-09-30 | El Dorado | 17 | 186661.0 | 11 | 1 | 7.0 | 1 | 4.0 | 0 | 0.0 | 0 | 1.0 | 0 | 6.0 | 0 | 5.0 | 1 | 5.357305489630936e-06 | 3.214383293778561e-05 | 2.678652744815468e-05 |
47454 | 47454 | 2020-09-30 | Fresno | 19 | 978130.0 | 5 | 0 | 4.0 | 0 | 1.0 | 0 | 0.0 | 0 | 3.0 | 0 | 4.0 | 0 | 1.0 | 0 | 3.0670769734084427e-06 | 4.08943596454459e-06 | 1.0223589911361476e-06 |
47455 | 47455 | 2020-09-30 | Glenn | 21 | 27897.0 | 6 | 1 | 2.0 | 0 | 4.0 | 1 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 1 | 0.0 | 0.000107538444994 | 0.000107538444994 |
47456 | 47456 | 2020-09-30 | 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 |
47457 | 47457 | 2020-09-30 | Imperial | 25 | 180216.0 | 6 | 0 | 0.0 | 0 | 6.0 | 0 | 0.0 | 0 | 2.0 | 0 | 4.0 | 0 | 2.0 | 0 | 1.109779375860079e-05 | 2.219558751720158e-05 | 1.109779375860079e-05 |
47458 | 47458 | 2020-09-30 | Inyo | 27 | 18085.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 5.52944429084877e-05 | 5.52944429084877e-05 | 0.0 |
47459 | 47459 | 2020-09-30 | Kern | 29 | 883053.0 | 7 | 0 | 6.0 | 0 | 1.0 | 0 | 0.0 | 0 | 5.0 | 0 | 6.0 | 0 | 1.0 | 0 | 5.662174297578967e-06 | 6.794609157094761e-06 | 1.1324348595157936e-06 |
47460 | 47460 | 2020-09-30 | 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 |
47461 | 47461 | 2020-09-30 | 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 |
47462 | 47462 | 2020-09-30 | Lassen | 35 | 31185.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 3.20666987333654e-05 | 3.20666987333654e-05 |
47463 | 47463 | 2020-09-30 | Los Angeles | 37 | 10098052.0 | 691 | 9 | 599.0 | 8 | 89.0 | 0 | 3.0 | 1 | 218.0 | 0 | 455.0 | 1 | 237.0 | 9 | 2.158832218332803e-05 | 4.505819538263419e-05 | 2.3469873199306165e-05 |
47464 | 47464 | 2020-09-30 | Madera | 39 | 155013.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 6.451071845587144e-06 | 6.451071845587144e-06 | 0.0 |
47465 | 47465 | 2020-09-30 | Marin | 41 | 260295.0 | 13 | 1 | 11.0 | 1 | 2.0 | 0 | 0.0 | 0 | 5.0 | 0 | 9.0 | 0 | 4.0 | 1 | 1.920897443285503e-05 | 3.457615397913905e-05 | 1.5367179546284023e-05 |
47466 | 47466 | 2020-09-30 | Mariposa | 43 | 17540.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 5.701254275940707e-05 | 5.701254275940707e-05 | 0.0 |
47467 | 47467 | 2020-09-30 | Mendocino | 45 | 87422.0 | 2 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.2877536546864634e-05 | 2.2877536546864634e-05 | 0.0 |
47468 | 47468 | 2020-09-30 | Merced | 47 | 269075.0 | 6 | 0 | 6.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 1.114930781380656e-05 | 1.114930781380656e-05 |
47469 | 47469 | 2020-09-30 | 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 |
47470 | 47470 | 2020-09-30 | 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 |
47471 | 47471 | 2020-09-30 | Monterey | 53 | 433212.0 | 3 | 0 | 2.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 2.0 | 0 | 1.0 | 0 | 2.308338642512211e-06 | 4.616677285024422e-06 | 2.308338642512211e-06 |
47472 | 47472 | 2020-09-30 | 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 |
47473 | 47473 | 2020-09-30 | Nevada | 57 | 99092.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 1.009163201873007e-05 | 1.009163201873007e-05 |
47474 | 47474 | 2020-09-30 | Orange | 59 | 3164182.0 | 163 | 2 | 134.0 | 0 | 28.0 | 1 | 1.0 | 1 | 52.0 | 1 | 108.0 | 2 | 56.0 | 1 | 1.643394722553886e-05 | 3.413204423765763e-05 | 1.7698097012118772e-05 |
47475 | 47475 | 2020-09-30 | Placer | 61 | 380077.0 | 31 | 1 | 24.0 | 1 | 7.0 | 0 | 0.0 | 0 | 7.0 | 0 | 19.0 | 0 | 12.0 | 1 | 1.841732070080536e-05 | 4.998987047361456e-05 | 3.1572549772809195e-05 |
47476 | 47476 | 2020-09-30 | Plumas | 63 | 18699.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 5.3478795657521794e-05 | 5.3478795657521794e-05 | 0.0 |
47477 | 47477 | 2020-09-30 | Riverside | 65 | 2383286.0 | 70 | 2 | 22.0 | 1 | 48.0 | 1 | 0.0 | 0 | 18.0 | 2 | 44.0 | 2 | 26.0 | 0 | 7.552597548091165e-06 | 1.846190511755618e-05 | 1.0909307569465016e-05 |
47478 | 47478 | 2020-09-30 | Sacramento | 67 | 1510023.0 | 256 | 12 | 181.0 | 11 | 75.0 | 1 | 0.0 | 0 | 64.0 | 2 | 160.0 | 2 | 96.0 | 10 | 4.238346038437825e-05 | 0.0001059586509609 | 6.357519057656737e-05 |
47479 | 47479 | 2020-09-30 | San Benito | 69 | 59416.0 | 2 | 1 | 2.0 | 1 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 1 | 0.0 | 1.6830483371482428e-05 | 1.6830483371482428e-05 |
47480 | 47480 | 2020-09-30 | San Bernardino | 71 | 2135413.0 | 36 | 0 | 15.0 | 0 | 21.0 | 0 | 0.0 | 0 | 13.0 | 0 | 24.0 | 0 | 11.0 | 0 | 6.087815331273154e-06 | 1.1239043688504285e-05 | 5.15122835723113e-06 |
47481 | 47481 | 2020-09-30 | San Diego | 73 | 3302833.0 | 591 | 5 | 214.0 | 1 | 377.0 | 4 | 0.0 | 0 | 106.0 | 1 | 347.0 | 1 | 241.0 | 4 | 3.209366020019783e-05 | 0.0001050613215987 | 7.296766139856299e-05 |
47482 | 47482 | 2020-09-30 | San Francisco | 75 | 870044.0 | 44 | 2 | 29.0 | 0 | 14.0 | 2 | 1.0 | 0 | 13.0 | 0 | 29.0 | 0 | 16.0 | 2 | 1.49417730597533e-05 | 3.333164759483429e-05 | 1.8389874535080983e-05 |
47483 | 47483 | 2020-09-30 | San Joaquin | 77 | 732212.0 | 20 | 1 | 12.0 | 1 | 8.0 | 0 | 0.0 | 0 | 4.0 | 0 | 12.0 | 0 | 8.0 | 1 | 5.4628987233205685e-06 | 1.6388696169961705e-05 | 1.0925797446641135e-05 |
47484 | 47484 | 2020-09-30 | San Luis Obispo | 79 | 281455.0 | 4 | 0 | 1.0 | 0 | 3.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 7.10593167646693e-06 | 1.0658897514700396e-05 | 3.552965838233465e-06 |
47485 | 47485 | 2020-09-30 | San Mateo | 81 | 765935.0 | 47 | 0 | 41.0 | 0 | 6.0 | 0 | 0.0 | 0 | 11.0 | 0 | 29.0 | 0 | 18.0 | 0 | 1.4361531983784524e-05 | 3.786222068452284e-05 | 2.3500688700738317e-05 |
47486 | 47486 | 2020-09-30 | Santa Barbara | 83 | 443738.0 | 8 | 0 | 8.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 5.0 | 0 | 3.0 | 0 | 4.507164137396392e-06 | 1.126791034349098e-05 | 6.760746206094587e-06 |
47487 | 47487 | 2020-09-30 | Santa Clara | 85 | 1922200.0 | 132 | 6 | 122.0 | 6 | 10.0 | 0 | 0.0 | 0 | 28.0 | 1 | 80.0 | 1 | 52.0 | 5 | 1.4566642388929352e-05 | 4.161897825408386e-05 | 2.705233586515451e-05 |
47488 | 47488 | 2020-09-30 | Santa Cruz | 87 | 273765.0 | 5 | 0 | 5.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 3.0 | 0 | 2.0 | 0 | 3.652767884864756e-06 | 1.095830365459427e-05 | 7.305535769729512e-06 |
47489 | 47489 | 2020-09-30 | Shasta | 89 | 179085.0 | 290 | 4 | 101.0 | 0 | 189.0 | 4 | 0.0 | 0 | 28.0 | 0 | 159.0 | 0 | 131.0 | 4 | 0.0001563503364324 | 0.0008878465533126 | 0.0007314962168802 |
47490 | 47490 | 2020-09-30 | 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 |
47491 | 47491 | 2020-09-30 | Siskiyou | 93 | 43540.0 | 10 | 0 | 6.0 | 0 | 4.0 | 0 | 0.0 | 0 | 2.0 | 0 | 6.0 | 0 | 4.0 | 0 | 4.593477262287552e-05 | 0.0001378043178686 | 9.186954524575104e-05 |
47492 | 47492 | 2020-09-30 | Solano | 95 | 438530.0 | 9 | 0 | 8.0 | 0 | 1.0 | 0 | 0.0 | 0 | 3.0 | 0 | 6.0 | 0 | 3.0 | 0 | 6.841037101224546e-06 | 1.3682074202449092e-05 | 6.841037101224546e-06 |
47493 | 47493 | 2020-09-30 | Sonoma | 97 | 501317.0 | 6 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 6.0 | 0 | 6.0 | 0 | 0.0 | 0 | 1.1968475036753192e-05 | 1.1968475036753192e-05 | 0.0 |
47494 | 47494 | 2020-09-30 | Stanislaus | 99 | 539301.0 | 20 | 0 | 15.0 | 0 | 5.0 | 0 | 0.0 | 0 | 12.0 | 0 | 16.0 | 0 | 4.0 | 0 | 2.22510249378362e-05 | 2.9668033250448264e-05 | 7.417008312612066e-06 |
47495 | 47495 | 2020-09-30 | Sutter | 101 | 95872.0 | 4 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 2.0861148197596795e-05 | 3.12917222963952e-05 | 1.0430574098798398e-05 |
47496 | 47496 | 2020-09-30 | Tehama | 103 | 63373.0 | 25 | 2 | 6.0 | 0 | 19.0 | 2 | 0.0 | 0 | 1.0 | 0 | 13.0 | 0 | 12.0 | 2 | 1.5779590677417828e-05 | 0.0002051346788064 | 0.000189355088129 |
47497 | 47497 | 2020-09-30 | Trinity | 105 | 12862.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 7.774840615767377e-05 | 7.774840615767377e-05 |
47498 | 47498 | 2020-09-30 | 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 |
47499 | 47499 | 2020-09-30 | Tuolumne | 109 | 53932.0 | 2 | 1 | 1.0 | 0 | 1.0 | 1 | 0.0 | 0 | 2.0 | 1 | 2.0 | 1 | 0.0 | 0 | 3.708373507379664e-05 | 3.708373507379664e-05 | 0.0 |
47500 | 47500 | 2020-09-30 | Ventura | 111 | 848112.0 | 27 | 1 | 20.0 | 1 | 7.0 | 0 | 0.0 | 0 | 7.0 | 0 | 17.0 | 0 | 10.0 | 1 | 8.253626879468749e-06 | 2.0044522421566964e-05 | 1.1790895542098214e-05 |
47501 | 47501 | 2020-09-30 | Yolo | 113 | 214977.0 | 67 | 0 | 46.0 | 0 | 21.0 | 0 | 0.0 | 0 | 15.0 | 0 | 41.0 | 0 | 26.0 | 0 | 6.977490615275122e-05 | 0.0001907180768175 | 0.0001209431706647 |
47502 | 47502 | 2020-09-30 | Yuba | 115 | 75493.0 | 5 | 0 | 1.0 | 0 | 4.0 | 0 | 0.0 | 0 | 1.0 | 0 | 3.0 | 0 | 2.0 | 0 | 1.3246261242764227e-05 | 3.973878372829269e-05 | 2.6492522485528455e-05 |
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 );