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-20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49823 | 49823 | 2020-08-20 | Alameda | 1 | 1643700.0 | 22 | 4 | 20.0 | 4 | 2.0 | 0 | 0.0 | 0 | 22.0 | 4 | 22.0 | 4 | 0.0 | 0 | 1.3384437549431162e-05 | 1.3384437549431162e-05 | 0.0 |
49824 | 49824 | 2020-08-20 | 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 |
49825 | 49825 | 2020-08-20 | 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 |
49826 | 49826 | 2020-08-20 | Butte | 7 | 227075.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 8.807662666519872e-06 | 8.807662666519872e-06 | 0.0 |
49827 | 49827 | 2020-08-20 | 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 |
49828 | 49828 | 2020-08-20 | 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 |
49829 | 49829 | 2020-08-20 | Contra Costa | 13 | 1133247.0 | 22 | 2 | 21.0 | 1 | 1.0 | 1 | 0.0 | 0 | 22.0 | 2 | 22.0 | 2 | 0.0 | 0 | 1.941324353825777e-05 | 1.941324353825777e-05 | 0.0 |
49830 | 49830 | 2020-08-20 | Del Norte | 15 | 27424.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 |
49831 | 49831 | 2020-08-20 | El Dorado | 17 | 186661.0 | 2 | 0 | 0.0 | 0 | 2.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 1.0714610979261871e-05 | 1.0714610979261871e-05 | 0.0 |
49832 | 49832 | 2020-08-20 | 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 |
49833 | 49833 | 2020-08-20 | Glenn | 21 | 27897.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 |
49834 | 49834 | 2020-08-20 | 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 |
49835 | 49835 | 2020-08-20 | 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 |
49836 | 49836 | 2020-08-20 | 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 |
49837 | 49837 | 2020-08-20 | 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 |
49838 | 49838 | 2020-08-20 | 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 |
49839 | 49839 | 2020-08-20 | 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 |
49840 | 49840 | 2020-08-20 | 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 |
49841 | 49841 | 2020-08-20 | Los Angeles | 37 | 10098052.0 | 61 | 8 | 46.0 | 8 | 15.0 | 0 | 0.0 | 0 | 61.0 | 8 | 61.0 | 8 | 0.0 | 0 | 6.040769051298211e-06 | 6.040769051298211e-06 | 0.0 |
49842 | 49842 | 2020-08-20 | 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 |
49843 | 49843 | 2020-08-20 | Marin | 41 | 260295.0 | 3 | 1 | 1.0 | 1 | 2.0 | 0 | 0.0 | 0 | 3.0 | 1 | 3.0 | 1 | 0.0 | 0 | 1.1525384659713018e-05 | 1.1525384659713018e-05 | 0.0 |
49844 | 49844 | 2020-08-20 | 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 |
49845 | 49845 | 2020-08-20 | 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 |
49846 | 49846 | 2020-08-20 | Merced | 47 | 269075.0 | 1 | 1 | 1.0 | 1 | 0.0 | 0 | 0.0 | 0 | 1.0 | 1 | 1.0 | 1 | 0.0 | 0 | 3.71643593793552e-06 | 3.71643593793552e-06 | 0.0 |
49847 | 49847 | 2020-08-20 | 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 |
49848 | 49848 | 2020-08-20 | 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 |
49849 | 49849 | 2020-08-20 | 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 |
49850 | 49850 | 2020-08-20 | 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 |
49851 | 49851 | 2020-08-20 | 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 |
49852 | 49852 | 2020-08-20 | Orange | 59 | 3164182.0 | 27 | 6 | 21.0 | 4 | 6.0 | 2 | 0.0 | 0 | 27.0 | 6 | 27.0 | 6 | 0.0 | 0 | 8.533011059414407e-06 | 8.533011059414407e-06 | 0.0 |
49853 | 49853 | 2020-08-20 | Placer | 61 | 380077.0 | 3 | 0 | 0.0 | 0 | 3.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 7.893137443202299e-06 | 7.893137443202299e-06 | 0.0 |
49854 | 49854 | 2020-08-20 | 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 |
49855 | 49855 | 2020-08-20 | Riverside | 65 | 2383286.0 | 19 | 2 | 1.0 | 0 | 18.0 | 2 | 0.0 | 0 | 19.0 | 2 | 19.0 | 2 | 0.0 | 0 | 7.972186300762897e-06 | 7.972186300762897e-06 | 0.0 |
49856 | 49856 | 2020-08-20 | Sacramento | 67 | 1510023.0 | 29 | 3 | 6.0 | 2 | 23.0 | 1 | 0.0 | 0 | 29.0 | 3 | 29.0 | 3 | 0.0 | 0 | 1.92050054866714e-05 | 1.92050054866714e-05 | 0.0 |
49857 | 49857 | 2020-08-20 | 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 |
49858 | 49858 | 2020-08-20 | San Bernardino | 71 | 2135413.0 | 11 | 1 | 3.0 | 1 | 8.0 | 0 | 0.0 | 0 | 11.0 | 1 | 11.0 | 1 | 0.0 | 0 | 5.15122835723113e-06 | 5.15122835723113e-06 | 0.0 |
49859 | 49859 | 2020-08-20 | San Diego | 73 | 3302833.0 | 118 | 4 | 25.0 | 0 | 93.0 | 4 | 0.0 | 0 | 116.0 | 4 | 117.0 | 4 | 1.0 | 0 | 3.512136399266932e-05 | 3.542413437191647e-05 | 3.0277037924714934e-07 |
49860 | 49860 | 2020-08-20 | San Francisco | 75 | 870044.0 | 8 | 0 | 5.0 | 0 | 3.0 | 0 | 0.0 | 0 | 8.0 | 0 | 8.0 | 0 | 0.0 | 0 | 9.194937267540491e-06 | 9.194937267540491e-06 | 0.0 |
49861 | 49861 | 2020-08-20 | San Joaquin | 77 | 732212.0 | 5 | 0 | 2.0 | 0 | 3.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 6.828623404150711e-06 | 6.828623404150711e-06 | 0.0 |
49862 | 49862 | 2020-08-20 | 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 |
49863 | 49863 | 2020-08-20 | San Mateo | 81 | 765935.0 | 9 | 0 | 7.0 | 0 | 2.0 | 0 | 0.0 | 0 | 9.0 | 0 | 9.0 | 0 | 0.0 | 0 | 1.1750344350369157e-05 | 1.1750344350369157e-05 | 0.0 |
49864 | 49864 | 2020-08-20 | Santa Barbara | 83 | 443738.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 4.507164137396392e-06 | 4.507164137396392e-06 | 0.0 |
49865 | 49865 | 2020-08-20 | Santa Clara | 85 | 1922200.0 | 25 | 3 | 22.0 | 3 | 3.0 | 0 | 0.0 | 0 | 25.0 | 3 | 25.0 | 3 | 0.0 | 0 | 1.3005930704401207e-05 | 1.3005930704401207e-05 | 0.0 |
49866 | 49866 | 2020-08-20 | Santa Cruz | 87 | 273765.0 | 1 | 1 | 1.0 | 1 | 0.0 | 0 | 0.0 | 0 | 1.0 | 1 | 1.0 | 1 | 0.0 | 0 | 3.652767884864756e-06 | 3.652767884864756e-06 | 0.0 |
49867 | 49867 | 2020-08-20 | Shasta | 89 | 179085.0 | 72 | 9 | 27.0 | 5 | 45.0 | 4 | 0.0 | 0 | 72.0 | 9 | 72.0 | 9 | 0.0 | 0 | 0.0004020437222547 | 0.0004020437222547 | 0.0 |
49868 | 49868 | 2020-08-20 | 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 |
49869 | 49869 | 2020-08-20 | Siskiyou | 93 | 43540.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.296738631143776e-05 | 2.296738631143776e-05 | 0.0 |
49870 | 49870 | 2020-08-20 | Solano | 95 | 438530.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.280345700408182e-06 | 2.280345700408182e-06 | 0.0 |
49871 | 49871 | 2020-08-20 | Sonoma | 97 | 501317.0 | 2 | 1 | 1.0 | 0 | 1.0 | 1 | 0.0 | 0 | 2.0 | 1 | 2.0 | 1 | 0.0 | 0 | 3.989491678917731e-06 | 3.989491678917731e-06 | 0.0 |
49872 | 49872 | 2020-08-20 | Stanislaus | 99 | 539301.0 | 5 | 0 | 3.0 | 0 | 2.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 9.271260390765084e-06 | 9.271260390765084e-06 | 0.0 |
49873 | 49873 | 2020-08-20 | 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 |
49874 | 49874 | 2020-08-20 | Tehama | 103 | 63373.0 | 5 | 0 | 2.0 | 0 | 3.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 7.889795338708914e-05 | 7.889795338708914e-05 | 0.0 |
49875 | 49875 | 2020-08-20 | 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 |
49876 | 49876 | 2020-08-20 | 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 |
49877 | 49877 | 2020-08-20 | 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 |
49878 | 49878 | 2020-08-20 | Ventura | 111 | 848112.0 | 4 | 0 | 3.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 2.3581791084196427e-06 | 3.537268662629464e-06 | 1.1790895542098214e-06 |
49879 | 49879 | 2020-08-20 | Yolo | 113 | 214977.0 | 7 | 1 | 0.0 | 0 | 7.0 | 1 | 0.0 | 0 | 7.0 | 1 | 7.0 | 1 | 0.0 | 0 | 3.2561622871283904e-05 | 3.2561622871283904e-05 | 0.0 |
49880 | 49880 | 2020-08-20 | 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 );