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-11-25
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_pfizer_doses, new_moderna_doses, new_partially_vaccinated, new_fully_vaccinated, date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44197 | 44197 | 2020-11-25 | Alameda | 1 | 1643700.0 | 132 | 1 | 115.0 | 0 | 13.0 | 0 | 4.0 | 1 | 26.0 | 0 | 81.0 | 1 | 55.0 | 1 | 1.5817971649327736e-05 | 4.927906552290564e-05 | 3.34610938735779e-05 |
44198 | 44198 | 2020-11-25 | 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 |
44199 | 44199 | 2020-11-25 | Amador | 5 | 37829.0 | 3 | 0 | 1.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 5.286949165983769e-05 | 5.286949165983769e-05 | 0.0 |
44200 | 44200 | 2020-11-25 | Butte | 7 | 227075.0 | 25 | 0 | 13.0 | 0 | 12.0 | 0 | 0.0 | 0 | 13.0 | 0 | 19.0 | 0 | 6.0 | 0 | 5.724980733237917e-05 | 8.367279533193878e-05 | 2.6422987999559612e-05 |
44201 | 44201 | 2020-11-25 | Calaveras | 9 | 45235.0 | 6 | 0 | 4.0 | 0 | 2.0 | 0 | 0.0 | 0 | 4.0 | 0 | 5.0 | 0 | 1.0 | 0 | 8.842710290704101e-05 | 0.0001105338786338 | 2.2106775726760254e-05 |
44202 | 44202 | 2020-11-25 | 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 |
44203 | 44203 | 2020-11-25 | Contra Costa | 13 | 1133247.0 | 135 | 0 | 115.0 | 0 | 15.0 | 0 | 5.0 | 0 | 23.0 | 0 | 80.0 | 0 | 57.0 | 0 | 2.0295663699087667e-05 | 7.059361286639188e-05 | 5.029794916730421e-05 |
44204 | 44204 | 2020-11-25 | 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 |
44205 | 44205 | 2020-11-25 | El Dorado | 17 | 186661.0 | 22 | 0 | 10.0 | 0 | 12.0 | 0 | 0.0 | 0 | 7.0 | 0 | 14.0 | 0 | 7.0 | 0 | 3.750113842741655e-05 | 7.50022768548331e-05 | 3.750113842741655e-05 |
44206 | 44206 | 2020-11-25 | Fresno | 19 | 978130.0 | 18 | 0 | 12.0 | 0 | 6.0 | 0 | 0.0 | 0 | 10.0 | 0 | 14.0 | 0 | 4.0 | 0 | 1.0223589911361476e-05 | 1.4313025875906066e-05 | 4.08943596454459e-06 |
44207 | 44207 | 2020-11-25 | 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 |
44208 | 44208 | 2020-11-25 | Humboldt | 23 | 135768.0 | 3 | 0 | 3.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 2.2096517588828e-05 | 2.2096517588828e-05 | 0.0 |
44209 | 44209 | 2020-11-25 | Imperial | 25 | 180216.0 | 15 | 0 | 4.0 | 0 | 10.0 | 0 | 1.0 | 0 | 10.0 | 0 | 13.0 | 0 | 3.0 | 0 | 5.548896879300395e-05 | 7.213565943090513e-05 | 1.6646690637901184e-05 |
44210 | 44210 | 2020-11-25 | Inyo | 27 | 18085.0 | 3 | 0 | 0.0 | 0 | 3.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 0.0001658833287254 | 0.0001658833287254 | 0.0 |
44211 | 44211 | 2020-11-25 | Kern | 29 | 883053.0 | 12 | 0 | 8.0 | 0 | 4.0 | 0 | 0.0 | 0 | 10.0 | 0 | 11.0 | 0 | 1.0 | 0 | 1.1324348595157936e-05 | 1.2456783454673728e-05 | 1.1324348595157936e-06 |
44212 | 44212 | 2020-11-25 | Kings | 31 | 150075.0 | 2 | 1 | 1.0 | 0 | 1.0 | 1 | 0.0 | 0 | 2.0 | 1 | 2.0 | 1 | 0.0 | 0 | 1.3326669998334166e-05 | 1.3326669998334166e-05 | 0.0 |
44213 | 44213 | 2020-11-25 | Lake | 33 | 64148.0 | 4 | 0 | 3.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 3.11779011036977e-05 | 4.676685165554655e-05 | 1.558895055184885e-05 |
44214 | 44214 | 2020-11-25 | Lassen | 35 | 31185.0 | 4 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 6.41333974667308e-05 | 6.41333974667308e-05 |
44215 | 44215 | 2020-11-25 | Los Angeles | 37 | 10098052.0 | 1234 | 0 | 930.0 | 0 | 201.0 | 0 | 103.0 | 0 | 287.0 | 0 | 808.0 | 0 | 521.0 | 0 | 2.842132324135388e-05 | 8.001543267949106e-05 | 5.1594109438137176e-05 |
44216 | 44216 | 2020-11-25 | Madera | 39 | 155013.0 | 3 | 0 | 1.0 | 0 | 1.0 | 0 | 1.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 1.2902143691174288e-05 | 1.9353215536761432e-05 | 6.451071845587144e-06 |
44217 | 44217 | 2020-11-25 | Marin | 41 | 260295.0 | 19 | 0 | 15.0 | 0 | 3.0 | 0 | 1.0 | 0 | 8.0 | 0 | 14.0 | 0 | 6.0 | 0 | 3.0734359092568046e-05 | 5.3785128411994086e-05 | 2.305076931942604e-05 |
44218 | 44218 | 2020-11-25 | Mariposa | 43 | 17540.0 | 5 | 0 | 5.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 3.0 | 0 | 2.0 | 0 | 5.701254275940707e-05 | 0.0001710376282782 | 0.0001140250855188 |
44219 | 44219 | 2020-11-25 | Mendocino | 45 | 87422.0 | 5 | 0 | 3.0 | 0 | 2.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 5.719384136716158e-05 | 5.719384136716158e-05 | 0.0 |
44220 | 44220 | 2020-11-25 | Merced | 47 | 269075.0 | 11 | 0 | 9.0 | 0 | 2.0 | 0 | 0.0 | 0 | 5.0 | 0 | 8.0 | 0 | 3.0 | 0 | 1.85821796896776e-05 | 2.973148750348416e-05 | 1.114930781380656e-05 |
44221 | 44221 | 2020-11-25 | 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 |
44222 | 44222 | 2020-11-25 | 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 |
44223 | 44223 | 2020-11-25 | Monterey | 53 | 433212.0 | 8 | 0 | 2.0 | 0 | 6.0 | 0 | 0.0 | 0 | 6.0 | 0 | 7.0 | 0 | 1.0 | 0 | 1.3850031855073266e-05 | 1.615837049758548e-05 | 2.308338642512211e-06 |
44224 | 44224 | 2020-11-25 | Napa | 55 | 140530.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 1.423183661851562e-05 | 1.423183661851562e-05 | 0.0 |
44225 | 44225 | 2020-11-25 | Nevada | 57 | 99092.0 | 4 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 2.018326403746014e-05 | 3.0274896056190207e-05 | 1.009163201873007e-05 |
44226 | 44226 | 2020-11-25 | Orange | 59 | 3164182.0 | 319 | 1 | 219.0 | 0 | 61.0 | 1 | 39.0 | 0 | 92.0 | 1 | 223.0 | 1 | 131.0 | 0 | 2.907544509133798e-05 | 7.047635060183011e-05 | 4.1400905510492126e-05 |
44227 | 44227 | 2020-11-25 | Placer | 61 | 380077.0 | 44 | 1 | 34.0 | 1 | 10.0 | 0 | 0.0 | 0 | 6.0 | 1 | 25.0 | 1 | 19.0 | 0 | 1.5786274886404598e-05 | 6.577614536001915e-05 | 4.998987047361456e-05 |
44228 | 44228 | 2020-11-25 | 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 |
44229 | 44229 | 2020-11-25 | Riverside | 65 | 2383286.0 | 109 | 0 | 42.0 | 0 | 63.0 | 0 | 4.0 | 0 | 24.0 | 0 | 68.0 | 0 | 44.0 | 0 | 1.0070130064121554e-05 | 2.853203518167773e-05 | 1.846190511755618e-05 |
44230 | 44230 | 2020-11-25 | Sacramento | 67 | 1510023.0 | 337 | 2 | 241.0 | 2 | 94.0 | 0 | 2.0 | 0 | 42.0 | 1 | 190.0 | 1 | 148.0 | 1 | 2.7814145877248227e-05 | 0.0001258258980161 | 9.801175213887472e-05 |
44231 | 44231 | 2020-11-25 | San Benito | 69 | 59416.0 | 3 | 0 | 3.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 2.0 | 0 | 1.0 | 0 | 1.6830483371482428e-05 | 3.3660966742964855e-05 | 1.6830483371482428e-05 |
44232 | 44232 | 2020-11-25 | San Bernardino | 71 | 2135413.0 | 63 | 1 | 22.0 | 0 | 36.0 | 1 | 5.0 | 0 | 25.0 | 1 | 46.0 | 1 | 21.0 | 0 | 1.1707337175525296e-05 | 2.1541500402966547e-05 | 9.834163227441249e-06 |
44233 | 44233 | 2020-11-25 | San Diego | 73 | 3302833.0 | 885 | 5 | 313.0 | 1 | 502.0 | 0 | 70.0 | 4 | 82.0 | 1 | 516.0 | 5 | 434.0 | 4 | 2.482717109826625e-05 | 0.0001562295156915 | 0.0001314023445932 |
44234 | 44234 | 2020-11-25 | San Francisco | 75 | 870044.0 | 78 | 0 | 51.0 | 0 | 21.0 | 0 | 6.0 | 0 | 14.0 | 0 | 49.0 | 0 | 35.0 | 0 | 1.6091140218195862e-05 | 5.631899076368552e-05 | 4.0227850545489657e-05 |
44235 | 44235 | 2020-11-25 | San Joaquin | 77 | 732212.0 | 36 | 0 | 24.0 | 0 | 9.0 | 0 | 3.0 | 0 | 15.0 | 0 | 27.0 | 0 | 12.0 | 0 | 2.048587021245213e-05 | 3.687456638241384e-05 | 1.6388696169961705e-05 |
44236 | 44236 | 2020-11-25 | San Luis Obispo | 79 | 281455.0 | 10 | 1 | 2.0 | 0 | 7.0 | 1 | 1.0 | 0 | 5.0 | 0 | 8.0 | 0 | 3.0 | 1 | 1.7764829191167326e-05 | 2.842372670586772e-05 | 1.0658897514700396e-05 |
44237 | 44237 | 2020-11-25 | San Mateo | 81 | 765935.0 | 71 | 1 | 49.0 | 1 | 11.0 | 0 | 11.0 | 0 | 18.0 | 1 | 50.0 | 1 | 32.0 | 0 | 2.3500688700738317e-05 | 6.52796908353842e-05 | 4.177900213464589e-05 |
44238 | 44238 | 2020-11-25 | Santa Barbara | 83 | 443738.0 | 13 | 2 | 10.0 | 0 | 1.0 | 0 | 2.0 | 2 | 5.0 | 0 | 10.0 | 2 | 5.0 | 2 | 1.126791034349098e-05 | 2.253582068698196e-05 | 1.126791034349098e-05 |
44239 | 44239 | 2020-11-25 | Santa Clara | 85 | 1922200.0 | 211 | 1 | 168.0 | 0 | 20.0 | 0 | 23.0 | 1 | 48.0 | 0 | 141.0 | 1 | 93.0 | 1 | 2.497138695245032e-05 | 7.335344917282281e-05 | 4.838206222037249e-05 |
44240 | 44240 | 2020-11-25 | Santa Cruz | 87 | 273765.0 | 9 | 0 | 5.0 | 0 | 3.0 | 0 | 1.0 | 0 | 4.0 | 0 | 7.0 | 0 | 3.0 | 0 | 1.4611071539459023e-05 | 2.556937519405329e-05 | 1.095830365459427e-05 |
44241 | 44241 | 2020-11-25 | Shasta | 89 | 179085.0 | 347 | 0 | 134.0 | 0 | 213.0 | 0 | 0.0 | 0 | 9.0 | 0 | 178.0 | 0 | 169.0 | 0 | 5.02554652818494e-05 | 0.0009939414244632 | 0.0009436859591813 |
44242 | 44242 | 2020-11-25 | 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 |
44243 | 44243 | 2020-11-25 | Siskiyou | 93 | 43540.0 | 16 | 0 | 8.0 | 0 | 7.0 | 0 | 1.0 | 0 | 1.0 | 0 | 9.0 | 0 | 8.0 | 0 | 2.296738631143776e-05 | 0.0002067064768029 | 0.0001837390904915 |
44244 | 44244 | 2020-11-25 | Solano | 95 | 438530.0 | 19 | 1 | 11.0 | 0 | 8.0 | 1 | 0.0 | 0 | 7.0 | 1 | 13.0 | 1 | 6.0 | 0 | 1.5962419902857274e-05 | 2.964449410530637e-05 | 1.3682074202449092e-05 |
44245 | 44245 | 2020-11-25 | Sonoma | 97 | 501317.0 | 18 | 0 | 11.0 | 0 | 7.0 | 0 | 0.0 | 0 | 14.0 | 0 | 16.0 | 0 | 2.0 | 0 | 2.7926441752424117e-05 | 3.1915933431341846e-05 | 3.989491678917731e-06 |
44246 | 44246 | 2020-11-25 | Stanislaus | 99 | 539301.0 | 30 | 0 | 20.0 | 0 | 10.0 | 0 | 0.0 | 0 | 18.0 | 0 | 24.0 | 0 | 6.0 | 0 | 3.33765374067543e-05 | 4.45020498756724e-05 | 1.11255124689181e-05 |
44247 | 44247 | 2020-11-25 | Sutter | 101 | 95872.0 | 6 | 0 | 2.0 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 3.12917222963952e-05 | 3.12917222963952e-05 |
44248 | 44248 | 2020-11-25 | Tehama | 103 | 63373.0 | 26 | 0 | 7.0 | 0 | 19.0 | 0 | 0.0 | 0 | 2.0 | 0 | 14.0 | 0 | 12.0 | 0 | 3.1559181354835657e-05 | 0.0002209142694838 | 0.000189355088129 |
44249 | 44249 | 2020-11-25 | 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 |
44250 | 44250 | 2020-11-25 | Tulare | 107 | 460477.0 | 5 | 0 | 0.0 | 0 | 5.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 1.085830562655681e-05 | 1.085830562655681e-05 | 0.0 |
44251 | 44251 | 2020-11-25 | Tuolumne | 109 | 53932.0 | 5 | 0 | 2.0 | 0 | 3.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 9.27093376844916e-05 | 9.27093376844916e-05 | 0.0 |
44252 | 44252 | 2020-11-25 | Ventura | 111 | 848112.0 | 53 | 1 | 34.0 | 1 | 16.0 | 0 | 3.0 | 0 | 14.0 | 0 | 35.0 | 0 | 21.0 | 1 | 1.6507253758937497e-05 | 4.126813439734375e-05 | 2.476088063840625e-05 |
44253 | 44253 | 2020-11-25 | Yolo | 113 | 214977.0 | 89 | 0 | 67.0 | 0 | 22.0 | 0 | 0.0 | 0 | 8.0 | 0 | 48.0 | 0 | 40.0 | 0 | 3.721328328146732e-05 | 0.0002232796996888 | 0.0001860664164073 |
44254 | 44254 | 2020-11-25 | 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 );