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-02
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43791 | 43791 | 2020-12-02 | Alameda | 1 | 1643700.0 | 148 | 4 | 126.0 | 4 | 15.0 | 0 | 7.0 | 0 | 39.0 | 4 | 96.0 | 4 | 57.0 | 0 | 2.3726957473991605e-05 | 5.84048183975178e-05 | 3.467786092352619e-05 |
43792 | 43792 | 2020-12-02 | 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 |
43793 | 43793 | 2020-12-02 | 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 |
43794 | 43794 | 2020-12-02 | Butte | 7 | 227075.0 | 27 | 0 | 14.0 | 0 | 13.0 | 0 | 0.0 | 0 | 15.0 | 0 | 21.0 | 0 | 6.0 | 0 | 6.605746999889905e-05 | 9.248045799845864e-05 | 2.6422987999559612e-05 |
43795 | 43795 | 2020-12-02 | Calaveras | 9 | 45235.0 | 8 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 6.0 | 0 | 7.0 | 0 | 1.0 | 0 | 0.0001326406543605 | 0.0001547474300873 | 2.2106775726760254e-05 |
43796 | 43796 | 2020-12-02 | Colusa | 11 | 21464.0 | 1 | 1 | 0.0 | 0 | 1.0 | 1 | 0.0 | 0 | 1.0 | 1 | 1.0 | 1 | 0.0 | 0 | 4.658963846440552e-05 | 4.658963846440552e-05 | 0.0 |
43797 | 43797 | 2020-12-02 | Contra Costa | 13 | 1133247.0 | 145 | 3 | 122.0 | 2 | 18.0 | 1 | 5.0 | 0 | 33.0 | 3 | 90.0 | 3 | 57.0 | 0 | 2.911986530738665e-05 | 7.941781447469087e-05 | 5.029794916730421e-05 |
43798 | 43798 | 2020-12-02 | 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 |
43799 | 43799 | 2020-12-02 | El Dorado | 17 | 186661.0 | 28 | 2 | 11.0 | 1 | 16.0 | 0 | 1.0 | 1 | 12.0 | 1 | 20.0 | 2 | 8.0 | 1 | 6.428766587557122e-05 | 0.0001071461097926 | 4.2858443917047485e-05 |
43800 | 43800 | 2020-12-02 | Fresno | 19 | 978130.0 | 27 | 2 | 18.0 | 2 | 8.0 | 0 | 1.0 | 0 | 18.0 | 2 | 23.0 | 2 | 5.0 | 0 | 1.8402461840450656e-05 | 2.3514256796131392e-05 | 5.111794955680738e-06 |
43801 | 43801 | 2020-12-02 | 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 |
43802 | 43802 | 2020-12-02 | Humboldt | 23 | 135768.0 | 6 | 1 | 5.0 | 1 | 1.0 | 0 | 0.0 | 0 | 6.0 | 1 | 6.0 | 1 | 0.0 | 0 | 4.4193035177656e-05 | 4.4193035177656e-05 | 0.0 |
43803 | 43803 | 2020-12-02 | 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 |
43804 | 43804 | 2020-12-02 | 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 |
43805 | 43805 | 2020-12-02 | Kern | 29 | 883053.0 | 15 | 0 | 10.0 | 0 | 4.0 | 0 | 1.0 | 0 | 12.0 | 0 | 14.0 | 0 | 2.0 | 0 | 1.3589218314189522e-05 | 1.5854088033221108e-05 | 2.264869719031587e-06 |
43806 | 43806 | 2020-12-02 | Kings | 31 | 150075.0 | 3 | 1 | 2.0 | 1 | 1.0 | 0 | 0.0 | 0 | 3.0 | 1 | 3.0 | 1 | 0.0 | 0 | 1.999000499750125e-05 | 1.999000499750125e-05 | 0.0 |
43807 | 43807 | 2020-12-02 | Lake | 33 | 64148.0 | 5 | 1 | 4.0 | 1 | 1.0 | 0 | 0.0 | 0 | 3.0 | 1 | 4.0 | 1 | 1.0 | 0 | 4.676685165554655e-05 | 6.23558022073954e-05 | 1.558895055184885e-05 |
43808 | 43808 | 2020-12-02 | 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 |
43809 | 43809 | 2020-12-02 | Los Angeles | 37 | 10098052.0 | 1438 | 34 | 1068.0 | 26 | 244.0 | 1 | 126.0 | 7 | 456.0 | 27 | 1004.0 | 33 | 548.0 | 6 | 4.515722438347515e-05 | 9.942511684431808e-05 | 5.426789246084294e-05 |
43810 | 43810 | 2020-12-02 | Madera | 39 | 155013.0 | 4 | 0 | 2.0 | 0 | 1.0 | 0 | 1.0 | 0 | 3.0 | 0 | 4.0 | 0 | 1.0 | 0 | 1.9353215536761432e-05 | 2.5804287382348576e-05 | 6.451071845587144e-06 |
43811 | 43811 | 2020-12-02 | Marin | 41 | 260295.0 | 26 | 2 | 17.0 | 0 | 7.0 | 1 | 2.0 | 1 | 14.0 | 1 | 21.0 | 2 | 7.0 | 1 | 5.3785128411994086e-05 | 8.067769261799113e-05 | 2.6892564205997043e-05 |
43812 | 43812 | 2020-12-02 | 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 |
43813 | 43813 | 2020-12-02 | 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 |
43814 | 43814 | 2020-12-02 | Merced | 47 | 269075.0 | 15 | 0 | 11.0 | 0 | 4.0 | 0 | 0.0 | 0 | 7.0 | 0 | 11.0 | 0 | 4.0 | 0 | 2.601505156554864e-05 | 4.088079531729072e-05 | 1.486574375174208e-05 |
43815 | 43815 | 2020-12-02 | 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 |
43816 | 43816 | 2020-12-02 | 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 |
43817 | 43817 | 2020-12-02 | Monterey | 53 | 433212.0 | 10 | 0 | 3.0 | 0 | 6.0 | 0 | 1.0 | 0 | 7.0 | 0 | 9.0 | 0 | 2.0 | 0 | 1.615837049758548e-05 | 2.07750477826099e-05 | 4.616677285024422e-06 |
43818 | 43818 | 2020-12-02 | Napa | 55 | 140530.0 | 4 | 0 | 3.0 | 0 | 1.0 | 0 | 0.0 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 2.846367323703124e-05 | 2.846367323703124e-05 | 0.0 |
43819 | 43819 | 2020-12-02 | 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 |
43820 | 43820 | 2020-12-02 | Orange | 59 | 3164182.0 | 413 | 5 | 278.0 | 4 | 84.0 | 1 | 51.0 | 0 | 156.0 | 4 | 308.0 | 4 | 152.0 | 1 | 4.930184167661658e-05 | 9.733953356665325e-05 | 4.8037691890036666e-05 |
43821 | 43821 | 2020-12-02 | Placer | 61 | 380077.0 | 47 | 1 | 36.0 | 0 | 11.0 | 1 | 0.0 | 0 | 9.0 | 1 | 28.0 | 1 | 19.0 | 0 | 2.367941232960689e-05 | 7.366928280322145e-05 | 4.998987047361456e-05 |
43822 | 43822 | 2020-12-02 | 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 |
43823 | 43823 | 2020-12-02 | Riverside | 65 | 2383286.0 | 132 | 5 | 58.0 | 4 | 68.0 | 1 | 6.0 | 0 | 42.0 | 5 | 89.0 | 5 | 47.0 | 0 | 1.7622727612212718e-05 | 3.7343398987784094e-05 | 1.9720671375571376e-05 |
43824 | 43824 | 2020-12-02 | Sacramento | 67 | 1510023.0 | 354 | 6 | 252.0 | 4 | 99.0 | 2 | 3.0 | 0 | 54.0 | 4 | 205.0 | 4 | 151.0 | 2 | 3.576104469931915e-05 | 0.0001357595215437 | 9.999847684439244e-05 |
43825 | 43825 | 2020-12-02 | San Benito | 69 | 59416.0 | 4 | 1 | 4.0 | 1 | 0.0 | 0 | 0.0 | 0 | 2.0 | 1 | 3.0 | 1 | 1.0 | 0 | 3.3660966742964855e-05 | 5.049145011444729e-05 | 1.6830483371482428e-05 |
43826 | 43826 | 2020-12-02 | San Bernardino | 71 | 2135413.0 | 79 | 4 | 31.0 | 4 | 43.0 | 0 | 5.0 | 0 | 39.0 | 4 | 61.0 | 4 | 22.0 | 0 | 1.8263445993819463e-05 | 2.8565902708281723e-05 | 1.030245671446226e-05 |
43827 | 43827 | 2020-12-02 | San Diego | 73 | 3302833.0 | 994 | 16 | 370.0 | 7 | 532.0 | 2 | 92.0 | 7 | 164.0 | 9 | 623.0 | 16 | 459.0 | 7 | 4.965434219653249e-05 | 0.0001886259462709 | 0.0001389716040744 |
43828 | 43828 | 2020-12-02 | San Francisco | 75 | 870044.0 | 94 | 5 | 63.0 | 4 | 24.0 | 0 | 7.0 | 1 | 29.0 | 4 | 65.0 | 5 | 36.0 | 1 | 3.333164759483429e-05 | 7.47088652987665e-05 | 4.137721770393221e-05 |
43829 | 43829 | 2020-12-02 | San Joaquin | 77 | 732212.0 | 46 | 2 | 33.0 | 2 | 10.0 | 0 | 3.0 | 0 | 23.0 | 2 | 36.0 | 2 | 13.0 | 0 | 3.141166765909327e-05 | 4.916608850988512e-05 | 1.7754420850791848e-05 |
43830 | 43830 | 2020-12-02 | San Luis Obispo | 79 | 281455.0 | 21 | 1 | 5.0 | 0 | 15.0 | 1 | 1.0 | 0 | 16.0 | 1 | 19.0 | 1 | 3.0 | 0 | 5.684745341173544e-05 | 6.750635092643585e-05 | 1.0658897514700396e-05 |
43831 | 43831 | 2020-12-02 | San Mateo | 81 | 765935.0 | 88 | 8 | 61.0 | 4 | 14.0 | 2 | 13.0 | 2 | 31.0 | 6 | 66.0 | 8 | 35.0 | 2 | 4.047340831793821e-05 | 8.616919190270715e-05 | 4.569578358476895e-05 |
43832 | 43832 | 2020-12-02 | Santa Barbara | 83 | 443738.0 | 22 | 1 | 14.0 | 1 | 6.0 | 0 | 2.0 | 0 | 14.0 | 1 | 19.0 | 1 | 5.0 | 0 | 3.155014896177474e-05 | 4.281805930526572e-05 | 1.126791034349098e-05 |
43833 | 43833 | 2020-12-02 | Santa Clara | 85 | 1922200.0 | 250 | 13 | 197.0 | 12 | 26.0 | 1 | 27.0 | 0 | 79.0 | 11 | 178.0 | 11 | 99.0 | 2 | 4.1098741025907816e-05 | 9.26022266153366e-05 | 5.150348558942878e-05 |
43834 | 43834 | 2020-12-02 | Santa Cruz | 87 | 273765.0 | 12 | 0 | 7.0 | 0 | 3.0 | 0 | 2.0 | 0 | 6.0 | 0 | 10.0 | 0 | 4.0 | 0 | 2.191660730918854e-05 | 3.652767884864756e-05 | 1.4611071539459023e-05 |
43835 | 43835 | 2020-12-02 | 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 |
43836 | 43836 | 2020-12-02 | 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 |
43837 | 43837 | 2020-12-02 | 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 |
43838 | 43838 | 2020-12-02 | Solano | 95 | 438530.0 | 23 | 0 | 13.0 | 0 | 10.0 | 0 | 0.0 | 0 | 11.0 | 0 | 17.0 | 0 | 6.0 | 0 | 2.508380270449e-05 | 3.876587690693909e-05 | 1.3682074202449092e-05 |
43839 | 43839 | 2020-12-02 | Sonoma | 97 | 501317.0 | 37 | 2 | 26.0 | 2 | 11.0 | 0 | 0.0 | 0 | 33.0 | 2 | 35.0 | 2 | 2.0 | 0 | 6.582661270214255e-05 | 6.981610438106028e-05 | 3.989491678917731e-06 |
43840 | 43840 | 2020-12-02 | Stanislaus | 99 | 539301.0 | 46 | 6 | 32.0 | 5 | 14.0 | 1 | 0.0 | 0 | 32.0 | 5 | 39.0 | 5 | 7.0 | 1 | 5.933606650089653e-05 | 7.231583104796765e-05 | 1.2979764547071115e-05 |
43841 | 43841 | 2020-12-02 | 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 |
43842 | 43842 | 2020-12-02 | 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 |
43843 | 43843 | 2020-12-02 | 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 |
43844 | 43844 | 2020-12-02 | Tulare | 107 | 460477.0 | 6 | 0 | 0.0 | 0 | 6.0 | 0 | 0.0 | 0 | 6.0 | 0 | 6.0 | 0 | 0.0 | 0 | 1.3029966751868171e-05 | 1.3029966751868171e-05 | 0.0 |
43845 | 43845 | 2020-12-02 | Tuolumne | 109 | 53932.0 | 7 | 1 | 3.0 | 1 | 4.0 | 0 | 0.0 | 0 | 7.0 | 1 | 7.0 | 1 | 0.0 | 0 | 0.0001297930727582 | 0.0001297930727582 | 0.0 |
43846 | 43846 | 2020-12-02 | Ventura | 111 | 848112.0 | 67 | 3 | 45.0 | 2 | 18.0 | 1 | 4.0 | 0 | 25.0 | 3 | 48.0 | 3 | 23.0 | 0 | 2.947723885524553e-05 | 5.659629860207143e-05 | 2.711905974682589e-05 |
43847 | 43847 | 2020-12-02 | Yolo | 113 | 214977.0 | 90 | 1 | 68.0 | 1 | 22.0 | 0 | 0.0 | 0 | 9.0 | 1 | 49.0 | 1 | 40.0 | 0 | 4.1864943691650734e-05 | 0.0002279313600989 | 0.0001860664164073 |
43848 | 43848 | 2020-12-02 | 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 );