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-12-11
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_pfizer_doses, fully_vaccinated, new_fully_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43269 | 43269 | 2020-12-11 | Alameda | 1 | 1643700.0 | 174 | 4 | 139.0 | 2 | 22.0 | 1 | 13.0 | 1 | 59.0 | 3 | 122.0 | 4 | 63.0 | 1 | 3.589462797347448e-05 | 7.422279004684553e-05 | 3.832816207337105e-05 |
43270 | 43270 | 2020-12-11 | 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 |
43271 | 43271 | 2020-12-11 | Amador | 5 | 37829.0 | 6 | 0 | 4.0 | 0 | 2.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 0.0001321737291495 | 0.0001321737291495 | 0.0 |
43272 | 43272 | 2020-12-11 | Butte | 7 | 227075.0 | 28 | 0 | 14.0 | 0 | 14.0 | 0 | 0.0 | 0 | 16.0 | 0 | 22.0 | 0 | 6.0 | 0 | 7.046130133215897e-05 | 9.68842893317186e-05 | 2.6422987999559612e-05 |
43273 | 43273 | 2020-12-11 | Calaveras | 9 | 45235.0 | 10 | 0 | 6.0 | 0 | 4.0 | 0 | 0.0 | 0 | 8.0 | 0 | 9.0 | 0 | 1.0 | 0 | 0.000176854205814 | 0.0001989609815408 | 2.2106775726760254e-05 |
43274 | 43274 | 2020-12-11 | Colusa | 11 | 21464.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 9.317927692881104e-05 | 9.317927692881104e-05 | 0.0 |
43275 | 43275 | 2020-12-11 | Contra Costa | 13 | 1133247.0 | 162 | 1 | 130.0 | 0 | 22.0 | 0 | 10.0 | 1 | 45.0 | 0 | 107.0 | 1 | 62.0 | 1 | 3.970890723734544e-05 | 9.441895720879914e-05 | 5.471004997145371e-05 |
43276 | 43276 | 2020-12-11 | Del Norte | 15 | 27424.0 | 9 | 0 | 6.0 | 0 | 2.0 | 0 | 1.0 | 0 | 2.0 | 0 | 6.0 | 0 | 4.0 | 0 | 7.292882147024503e-05 | 0.0002187864644107 | 0.0001458576429404 |
43277 | 43277 | 2020-12-11 | El Dorado | 17 | 186661.0 | 30 | 0 | 11.0 | 0 | 17.0 | 0 | 2.0 | 0 | 13.0 | 0 | 22.0 | 0 | 9.0 | 0 | 6.964497136520215e-05 | 0.0001178607207718 | 4.8215749406678415e-05 |
43278 | 43278 | 2020-12-11 | Fresno | 19 | 978130.0 | 38 | 3 | 23.0 | 2 | 14.0 | 1 | 1.0 | 0 | 27.0 | 3 | 33.0 | 3 | 6.0 | 0 | 2.7603692760675983e-05 | 3.373784670749287e-05 | 6.134153946816885e-06 |
43279 | 43279 | 2020-12-11 | Glenn | 21 | 27897.0 | 6 | 0 | 2.0 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0.000107538444994 | 0.000107538444994 |
43280 | 43280 | 2020-12-11 | Humboldt | 23 | 135768.0 | 8 | 0 | 6.0 | 0 | 2.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 5.892404690354133e-05 | 5.892404690354133e-05 | 0.0 |
43281 | 43281 | 2020-12-11 | Imperial | 25 | 180216.0 | 17 | 0 | 5.0 | 0 | 11.0 | 0 | 1.0 | 0 | 12.0 | 0 | 15.0 | 0 | 3.0 | 0 | 6.658676255160474e-05 | 8.323345318950592e-05 | 1.6646690637901184e-05 |
43282 | 43282 | 2020-12-11 | Inyo | 27 | 18085.0 | 4 | 0 | 1.0 | 0 | 3.0 | 0 | 0.0 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0002211777716339 | 0.0002211777716339 | 0.0 |
43283 | 43283 | 2020-12-11 | Kern | 29 | 883053.0 | 19 | 0 | 12.0 | 0 | 6.0 | 0 | 1.0 | 0 | 16.0 | 0 | 18.0 | 0 | 2.0 | 0 | 1.8118957752252698e-05 | 2.0383827471284284e-05 | 2.264869719031587e-06 |
43284 | 43284 | 2020-12-11 | Kings | 31 | 150075.0 | 5 | 1 | 4.0 | 1 | 1.0 | 0 | 0.0 | 0 | 5.0 | 1 | 5.0 | 1 | 0.0 | 0 | 3.3316674995835414e-05 | 3.3316674995835414e-05 | 0.0 |
43285 | 43285 | 2020-12-11 | Lake | 33 | 64148.0 | 5 | 0 | 4.0 | 0 | 1.0 | 0 | 0.0 | 0 | 3.0 | 0 | 4.0 | 0 | 1.0 | 0 | 4.676685165554655e-05 | 6.23558022073954e-05 | 1.558895055184885e-05 |
43286 | 43286 | 2020-12-11 | Lassen | 35 | 31185.0 | 5 | 0 | 2.0 | 0 | 3.0 | 0 | 0.0 | 0 | 1.0 | 0 | 3.0 | 0 | 2.0 | 0 | 3.20666987333654e-05 | 9.62000962000962e-05 | 6.41333974667308e-05 |
43287 | 43287 | 2020-12-11 | Los Angeles | 37 | 10098052.0 | 1697 | 36 | 1184.0 | 12 | 313.0 | 5 | 200.0 | 19 | 630.0 | 17 | 1256.0 | 36 | 626.0 | 19 | 6.23882705298012e-05 | 0.0001243804250562 | 6.199215452643738e-05 |
43288 | 43288 | 2020-12-11 | Madera | 39 | 155013.0 | 7 | 1 | 4.0 | 1 | 2.0 | 0 | 1.0 | 0 | 6.0 | 1 | 7.0 | 1 | 1.0 | 0 | 3.8706431073522864e-05 | 4.515750291911001e-05 | 6.451071845587144e-06 |
43289 | 43289 | 2020-12-11 | Marin | 41 | 260295.0 | 29 | 0 | 19.0 | 0 | 8.0 | 0 | 2.0 | 0 | 17.0 | 0 | 24.0 | 0 | 7.0 | 0 | 6.53105130717071e-05 | 9.220307727770414e-05 | 2.6892564205997043e-05 |
43290 | 43290 | 2020-12-11 | Mariposa | 43 | 17540.0 | 6 | 0 | 6.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 4.0 | 0 | 2.0 | 0 | 0.0001140250855188 | 0.0002280501710376 | 0.0001140250855188 |
43291 | 43291 | 2020-12-11 | Mendocino | 45 | 87422.0 | 8 | 0 | 6.0 | 0 | 2.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 9.151014618745854e-05 | 9.151014618745854e-05 | 0.0 |
43292 | 43292 | 2020-12-11 | Merced | 47 | 269075.0 | 19 | 0 | 13.0 | 0 | 6.0 | 0 | 0.0 | 0 | 9.0 | 0 | 14.0 | 0 | 5.0 | 0 | 3.344792344141968e-05 | 5.203010313109728e-05 | 1.85821796896776e-05 |
43293 | 43293 | 2020-12-11 | 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 |
43294 | 43294 | 2020-12-11 | Mono | 51 | 14174.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0001411034288133 | 0.0001411034288133 | 0.0 |
43295 | 43295 | 2020-12-11 | Monterey | 53 | 433212.0 | 13 | 1 | 6.0 | 1 | 6.0 | 0 | 1.0 | 0 | 10.0 | 1 | 12.0 | 1 | 2.0 | 0 | 2.308338642512211e-05 | 2.770006371014653e-05 | 4.616677285024422e-06 |
43296 | 43296 | 2020-12-11 | Napa | 55 | 140530.0 | 6 | 0 | 5.0 | 0 | 1.0 | 0 | 0.0 | 0 | 6.0 | 0 | 6.0 | 0 | 0.0 | 0 | 4.269550985554686e-05 | 4.269550985554686e-05 | 0.0 |
43297 | 43297 | 2020-12-11 | Nevada | 57 | 99092.0 | 5 | 1 | 3.0 | 1 | 2.0 | 0 | 0.0 | 0 | 3.0 | 1 | 4.0 | 1 | 1.0 | 0 | 3.0274896056190207e-05 | 4.036652807492028e-05 | 1.009163201873007e-05 |
43298 | 43298 | 2020-12-11 | Orange | 59 | 3164182.0 | 489 | 8 | 309.0 | 4 | 101.0 | 1 | 79.0 | 3 | 204.0 | 5 | 384.0 | 8 | 180.0 | 3 | 6.447163911557553e-05 | 0.0001213583795116 | 5.688674039609605e-05 |
43299 | 43299 | 2020-12-11 | Placer | 61 | 380077.0 | 49 | 1 | 37.0 | 0 | 12.0 | 1 | 0.0 | 0 | 11.0 | 1 | 30.0 | 1 | 19.0 | 0 | 2.8941503958408427e-05 | 7.893137443202298e-05 | 4.998987047361456e-05 |
43300 | 43300 | 2020-12-11 | Plumas | 63 | 18699.0 | 5 | 0 | 1.0 | 0 | 4.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 0.0002673939782876 | 0.0002673939782876 | 0.0 |
43301 | 43301 | 2020-12-11 | Riverside | 65 | 2383286.0 | 157 | 0 | 75.0 | 0 | 75.0 | 0 | 7.0 | 0 | 66.0 | 0 | 114.0 | 0 | 48.0 | 0 | 2.7692857676334276e-05 | 4.783311780457738e-05 | 2.0140260128243107e-05 |
43302 | 43302 | 2020-12-11 | Sacramento | 67 | 1510023.0 | 380 | 5 | 265.0 | 2 | 106.0 | 0 | 9.0 | 3 | 70.0 | 2 | 229.0 | 5 | 159.0 | 3 | 4.635690979541371e-05 | 0.0001516533191878 | 0.0001052964093924 |
43303 | 43303 | 2020-12-11 | San Benito | 69 | 59416.0 | 4 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 3.3660966742964855e-05 | 5.049145011444729e-05 | 1.6830483371482428e-05 |
43304 | 43304 | 2020-12-11 | San Bernardino | 71 | 2135413.0 | 99 | 4 | 38.0 | 2 | 55.0 | 2 | 6.0 | 0 | 58.0 | 4 | 81.0 | 4 | 23.0 | 0 | 2.7161022247218688e-05 | 3.793177244870196e-05 | 1.0770750201483272e-05 |
43305 | 43305 | 2020-12-11 | San Diego | 73 | 3302833.0 | 1116 | 17 | 413.0 | 4 | 550.0 | 3 | 153.0 | 10 | 222.0 | 7 | 743.0 | 17 | 521.0 | 10 | 6.721502419286715e-05 | 0.0002249583917806 | 0.0001577433675877 |
43306 | 43306 | 2020-12-11 | San Francisco | 75 | 870044.0 | 113 | 3 | 68.0 | 0 | 33.0 | 2 | 12.0 | 1 | 43.0 | 2 | 84.0 | 3 | 41.0 | 1 | 4.942278781303015e-05 | 9.654684130917516e-05 | 4.712405349614503e-05 |
43307 | 43307 | 2020-12-11 | San Joaquin | 77 | 732212.0 | 60 | 3 | 40.0 | 2 | 17.0 | 1 | 3.0 | 0 | 37.0 | 3 | 50.0 | 3 | 13.0 | 0 | 5.053181319071526e-05 | 6.82862340415071e-05 | 1.7754420850791848e-05 |
43308 | 43308 | 2020-12-11 | San Luis Obispo | 79 | 281455.0 | 26 | 1 | 6.0 | 0 | 18.0 | 1 | 2.0 | 0 | 20.0 | 1 | 24.0 | 1 | 4.0 | 0 | 7.10593167646693e-05 | 8.527118011760317e-05 | 1.421186335293386e-05 |
43309 | 43309 | 2020-12-11 | San Mateo | 81 | 765935.0 | 116 | 3 | 72.0 | 0 | 19.0 | 0 | 25.0 | 3 | 47.0 | 0 | 94.0 | 3 | 47.0 | 3 | 6.136290938526114e-05 | 0.0001227258187705 | 6.136290938526114e-05 |
43310 | 43310 | 2020-12-11 | Santa Barbara | 83 | 443738.0 | 24 | 0 | 15.0 | 0 | 6.0 | 0 | 3.0 | 0 | 15.0 | 0 | 21.0 | 0 | 6.0 | 0 | 3.380373103047294e-05 | 4.732522344266211e-05 | 1.3521492412189174e-05 |
43311 | 43311 | 2020-12-11 | Santa Clara | 85 | 1922200.0 | 299 | 2 | 223.0 | 0 | 34.0 | 0 | 42.0 | 2 | 101.0 | 0 | 221.0 | 2 | 120.0 | 2 | 5.254396004578088e-05 | 0.0001149724274269 | 6.242846738112579e-05 |
43312 | 43312 | 2020-12-11 | Santa Cruz | 87 | 273765.0 | 18 | 0 | 8.0 | 0 | 6.0 | 0 | 4.0 | 0 | 10.0 | 0 | 16.0 | 0 | 6.0 | 0 | 3.652767884864756e-05 | 5.84442861578361e-05 | 2.191660730918854e-05 |
43313 | 43313 | 2020-12-11 | Shasta | 89 | 179085.0 | 348 | 0 | 135.0 | 0 | 213.0 | 0 | 0.0 | 0 | 8.0 | 0 | 178.0 | 0 | 170.0 | 0 | 4.4671524694977245e-05 | 0.0009939414244632 | 0.0009492698997682 |
43314 | 43314 | 2020-12-11 | Sierra | 91 | 2930.0 | 1 | 0 | 0.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0003412969283276 | 0.0003412969283276 | 0.0 |
43315 | 43315 | 2020-12-11 | Siskiyou | 93 | 43540.0 | 17 | 0 | 9.0 | 0 | 7.0 | 0 | 1.0 | 0 | 2.0 | 0 | 10.0 | 0 | 8.0 | 0 | 4.593477262287552e-05 | 0.0002296738631143 | 0.0001837390904915 |
43316 | 43316 | 2020-12-11 | Solano | 95 | 438530.0 | 28 | 1 | 16.0 | 0 | 11.0 | 0 | 1.0 | 1 | 15.0 | 0 | 22.0 | 1 | 7.0 | 1 | 3.4205185506122726e-05 | 5.016760540898e-05 | 1.5962419902857274e-05 |
43317 | 43317 | 2020-12-11 | Sonoma | 97 | 501317.0 | 40 | 0 | 27.0 | 0 | 12.0 | 0 | 1.0 | 0 | 35.0 | 0 | 38.0 | 0 | 3.0 | 0 | 6.981610438106028e-05 | 7.580034189943689e-05 | 5.984237518376596e-06 |
43318 | 43318 | 2020-12-11 | Stanislaus | 99 | 539301.0 | 57 | 2 | 42.0 | 2 | 15.0 | 0 | 0.0 | 0 | 43.0 | 2 | 50.0 | 2 | 7.0 | 0 | 7.973283936057971e-05 | 9.271260390765085e-05 | 1.2979764547071115e-05 |
43319 | 43319 | 2020-12-11 | Sutter | 101 | 95872.0 | 7 | 0 | 3.0 | 0 | 4.0 | 0 | 0.0 | 0 | 1.0 | 0 | 4.0 | 0 | 3.0 | 0 | 1.0430574098798398e-05 | 4.172229639519359e-05 | 3.12917222963952e-05 |
43320 | 43320 | 2020-12-11 | Tehama | 103 | 63373.0 | 27 | 1 | 8.0 | 1 | 19.0 | 0 | 0.0 | 0 | 1.0 | 0 | 14.0 | 0 | 13.0 | 1 | 1.5779590677417828e-05 | 0.0002209142694838 | 0.0002051346788064 |
43321 | 43321 | 2020-12-11 | 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 |
43322 | 43322 | 2020-12-11 | Tulare | 107 | 460477.0 | 7 | 1 | 1.0 | 1 | 6.0 | 0 | 0.0 | 0 | 7.0 | 1 | 7.0 | 1 | 0.0 | 0 | 1.5201627877179532e-05 | 1.5201627877179532e-05 | 0.0 |
43323 | 43323 | 2020-12-11 | Tuolumne | 109 | 53932.0 | 8 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 0.0001483349402951 | 0.0001483349402951 | 0.0 |
43324 | 43324 | 2020-12-11 | Ventura | 111 | 848112.0 | 79 | 1 | 52.0 | 1 | 20.0 | 0 | 7.0 | 0 | 34.0 | 1 | 60.0 | 1 | 26.0 | 0 | 4.008904484313393e-05 | 7.074537325258928e-05 | 3.065632840945536e-05 |
43325 | 43325 | 2020-12-11 | Yolo | 113 | 214977.0 | 92 | 0 | 68.0 | 0 | 24.0 | 0 | 0.0 | 0 | 11.0 | 0 | 51.0 | 0 | 40.0 | 0 | 5.116826451201756e-05 | 0.0002372346809193 | 0.0001860664164073 |
43326 | 43326 | 2020-12-11 | Yuba | 115 | 75493.0 | 7 | 0 | 2.0 | 0 | 5.0 | 0 | 0.0 | 0 | 1.0 | 0 | 4.0 | 0 | 3.0 | 0 | 1.3246261242764227e-05 | 5.298504497105692e-05 | 3.973878372829269e-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 );