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-10
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_doses_administered, moderna_doses, new_partially_vaccinated, at_least_one_dose, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48605 | 48605 | 2020-09-10 | Alameda | 1 | 1643700.0 | 68 | 3 | 64.0 | 3 | 4.0 | 0 | 0.0 | 0 | 28.0 | 2 | 48.0 | 2 | 20.0 | 1 | 1.7034738699276024e-05 | 2.9202409198758895e-05 | 1.2167670499482874e-05 |
48606 | 48606 | 2020-09-10 | 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 |
48607 | 48607 | 2020-09-10 | 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 |
48608 | 48608 | 2020-09-10 | Butte | 7 | 227075.0 | 11 | 0 | 4.0 | 0 | 7.0 | 0 | 0.0 | 0 | 11.0 | 0 | 11.0 | 0 | 0.0 | 0 | 4.84421446658593e-05 | 4.84421446658593e-05 | 0.0 |
48609 | 48609 | 2020-09-10 | Calaveras | 9 | 45235.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.2106775726760254e-05 | 2.2106775726760254e-05 | 0.0 |
48610 | 48610 | 2020-09-10 | 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 |
48611 | 48611 | 2020-09-10 | Contra Costa | 13 | 1133247.0 | 69 | 2 | 65.0 | 2 | 4.0 | 0 | 0.0 | 0 | 31.0 | 0 | 50.0 | 0 | 19.0 | 2 | 2.735502498572685e-05 | 4.4121008041494926e-05 | 1.6765983055768072e-05 |
48612 | 48612 | 2020-09-10 | Del Norte | 15 | 27424.0 | 2 | 0 | 2.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 7.292882147024503e-05 | 7.292882147024503e-05 | 0.0 |
48613 | 48613 | 2020-09-10 | El Dorado | 17 | 186661.0 | 7 | 0 | 3.0 | 0 | 4.0 | 0 | 0.0 | 0 | 3.0 | 0 | 5.0 | 0 | 2.0 | 0 | 1.6071916468892806e-05 | 2.678652744815468e-05 | 1.0714610979261871e-05 |
48614 | 48614 | 2020-09-10 | Fresno | 19 | 978130.0 | 4 | 0 | 3.0 | 0 | 1.0 | 0 | 0.0 | 0 | 4.0 | 0 | 4.0 | 0 | 0.0 | 0 | 4.08943596454459e-06 | 4.08943596454459e-06 | 0.0 |
48615 | 48615 | 2020-09-10 | Glenn | 21 | 27897.0 | 3 | 0 | 1.0 | 0 | 2.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 0.000107538444994 | 0.000107538444994 | 0.0 |
48616 | 48616 | 2020-09-10 | 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 |
48617 | 48617 | 2020-09-10 | Imperial | 25 | 180216.0 | 5 | 0 | 0.0 | 0 | 5.0 | 0 | 0.0 | 0 | 1.0 | 0 | 3.0 | 0 | 2.0 | 0 | 5.548896879300395e-06 | 1.6646690637901184e-05 | 1.109779375860079e-05 |
48618 | 48618 | 2020-09-10 | 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 |
48619 | 48619 | 2020-09-10 | Kern | 29 | 883053.0 | 6 | 0 | 5.0 | 0 | 1.0 | 0 | 0.0 | 0 | 6.0 | 0 | 6.0 | 0 | 0.0 | 0 | 6.794609157094761e-06 | 6.794609157094761e-06 | 0.0 |
48620 | 48620 | 2020-09-10 | 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 |
48621 | 48621 | 2020-09-10 | 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 |
48622 | 48622 | 2020-09-10 | 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 |
48623 | 48623 | 2020-09-10 | Los Angeles | 37 | 10098052.0 | 352 | 28 | 296.0 | 23 | 56.0 | 5 | 0.0 | 0 | 280.0 | 17 | 316.0 | 17 | 36.0 | 11 | 2.77281202354672e-05 | 3.129316426574155e-05 | 3.565044030274354e-06 |
48624 | 48624 | 2020-09-10 | 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 |
48625 | 48625 | 2020-09-10 | Marin | 41 | 260295.0 | 7 | 2 | 5.0 | 2 | 2.0 | 0 | 0.0 | 0 | 5.0 | 1 | 6.0 | 1 | 1.0 | 1 | 1.920897443285503e-05 | 2.305076931942604e-05 | 3.841794886571006e-06 |
48626 | 48626 | 2020-09-10 | 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 |
48627 | 48627 | 2020-09-10 | 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 |
48628 | 48628 | 2020-09-10 | Merced | 47 | 269075.0 | 4 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 7.43287187587104e-06 | 1.114930781380656e-05 | 3.71643593793552e-06 |
48629 | 48629 | 2020-09-10 | 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 |
48630 | 48630 | 2020-09-10 | 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 |
48631 | 48631 | 2020-09-10 | Monterey | 53 | 433212.0 | 2 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 2.0 | 0 | 2.0 | 0 | 0.0 | 0 | 4.616677285024422e-06 | 4.616677285024422e-06 | 0.0 |
48632 | 48632 | 2020-09-10 | 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 |
48633 | 48633 | 2020-09-10 | Nevada | 57 | 99092.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.009163201873007e-05 | 1.009163201873007e-05 | 0.0 |
48634 | 48634 | 2020-09-10 | Orange | 59 | 3164182.0 | 92 | 5 | 75.0 | 4 | 17.0 | 1 | 0.0 | 0 | 60.0 | 1 | 76.0 | 1 | 16.0 | 4 | 1.8962246798698684e-05 | 2.4018845945018333e-05 | 5.056599146319649e-06 |
48635 | 48635 | 2020-09-10 | Placer | 61 | 380077.0 | 16 | 0 | 10.0 | 0 | 6.0 | 0 | 0.0 | 0 | 12.0 | 0 | 14.0 | 0 | 2.0 | 0 | 3.1572549772809195e-05 | 3.683464140161073e-05 | 5.2620916288015326e-06 |
48636 | 48636 | 2020-09-10 | 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 |
48637 | 48637 | 2020-09-10 | Riverside | 65 | 2383286.0 | 44 | 2 | 9.0 | 1 | 35.0 | 1 | 0.0 | 0 | 22.0 | 1 | 33.0 | 1 | 11.0 | 1 | 9.23095255877809e-06 | 1.3846428838167136e-05 | 4.615476279389045e-06 |
48638 | 48638 | 2020-09-10 | Sacramento | 67 | 1510023.0 | 124 | 7 | 81.0 | 7 | 43.0 | 0 | 0.0 | 0 | 98.0 | 6 | 111.0 | 6 | 13.0 | 1 | 6.489967371357919e-05 | 7.350881410415602e-05 | 8.609140390576832e-06 |
48639 | 48639 | 2020-09-10 | San Benito | 69 | 59416.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.6830483371482428e-05 | 1.6830483371482428e-05 | 0.0 |
48640 | 48640 | 2020-09-10 | San Bernardino | 71 | 2135413.0 | 24 | 1 | 9.0 | 1 | 15.0 | 0 | 0.0 | 0 | 14.0 | 1 | 19.0 | 1 | 5.0 | 0 | 6.556108818294166e-06 | 8.897576253399226e-06 | 2.3414674351050597e-06 |
48641 | 48641 | 2020-09-10 | San Diego | 73 | 3302833.0 | 386 | 18 | 129.0 | 5 | 257.0 | 13 | 0.0 | 0 | 217.0 | 5 | 300.0 | 5 | 83.0 | 13 | 6.57011722966314e-05 | 9.08311137741448e-05 | 2.5129941477513394e-05 |
48642 | 48642 | 2020-09-10 | San Francisco | 75 | 870044.0 | 24 | 0 | 16.0 | 0 | 8.0 | 0 | 0.0 | 0 | 12.0 | 0 | 18.0 | 0 | 6.0 | 0 | 1.3792405901310738e-05 | 2.0688608851966107e-05 | 6.896202950655369e-06 |
48643 | 48643 | 2020-09-10 | San Joaquin | 77 | 732212.0 | 13 | 2 | 7.0 | 2 | 6.0 | 0 | 0.0 | 0 | 7.0 | 1 | 10.0 | 1 | 3.0 | 1 | 9.560072765810995e-06 | 1.3657246808301422e-05 | 4.097174042490426e-06 |
48644 | 48644 | 2020-09-10 | 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 |
48645 | 48645 | 2020-09-10 | San Mateo | 81 | 765935.0 | 29 | 0 | 25.0 | 0 | 4.0 | 0 | 0.0 | 0 | 17.0 | 0 | 23.0 | 0 | 6.0 | 0 | 2.219509488403063e-05 | 3.0028657784276732e-05 | 7.833562900246105e-06 |
48646 | 48646 | 2020-09-10 | Santa Barbara | 83 | 443738.0 | 5 | 0 | 5.0 | 0 | 0.0 | 0 | 0.0 | 0 | 5.0 | 0 | 5.0 | 0 | 0.0 | 0 | 1.126791034349098e-05 | 1.126791034349098e-05 | 0.0 |
48647 | 48647 | 2020-09-10 | Santa Clara | 85 | 1922200.0 | 81 | 5 | 75.0 | 5 | 6.0 | 0 | 0.0 | 0 | 45.0 | 3 | 63.0 | 3 | 18.0 | 2 | 2.3410675267922174e-05 | 3.2774945375091044e-05 | 9.364270107168867e-06 |
48648 | 48648 | 2020-09-10 | Santa Cruz | 87 | 273765.0 | 4 | 0 | 4.0 | 0 | 0.0 | 0 | 0.0 | 0 | 2.0 | 0 | 3.0 | 0 | 1.0 | 0 | 7.305535769729512e-06 | 1.095830365459427e-05 | 3.652767884864756e-06 |
48649 | 48649 | 2020-09-10 | Shasta | 89 | 179085.0 | 195 | 8 | 77.0 | 1 | 118.0 | 7 | 0.0 | 0 | 101.0 | 6 | 148.0 | 6 | 47.0 | 2 | 0.000563977999274 | 0.000826423206857 | 0.0002624452075829 |
48650 | 48650 | 2020-09-10 | 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 |
48651 | 48651 | 2020-09-10 | Siskiyou | 93 | 43540.0 | 6 | 1 | 4.0 | 0 | 2.0 | 1 | 0.0 | 0 | 4.0 | 1 | 5.0 | 1 | 1.0 | 0 | 9.186954524575104e-05 | 0.0001148369315571 | 2.296738631143776e-05 |
48652 | 48652 | 2020-09-10 | Solano | 95 | 438530.0 | 5 | 1 | 4.0 | 0 | 1.0 | 1 | 0.0 | 0 | 3.0 | 1 | 4.0 | 1 | 1.0 | 0 | 6.841037101224546e-06 | 9.121382801632728e-06 | 2.280345700408182e-06 |
48653 | 48653 | 2020-09-10 | Sonoma | 97 | 501317.0 | 3 | 0 | 1.0 | 0 | 2.0 | 0 | 0.0 | 0 | 3.0 | 0 | 3.0 | 0 | 0.0 | 0 | 5.984237518376596e-06 | 5.984237518376596e-06 | 0.0 |
48654 | 48654 | 2020-09-10 | Stanislaus | 99 | 539301.0 | 11 | 0 | 9.0 | 0 | 2.0 | 0 | 0.0 | 0 | 11.0 | 0 | 11.0 | 0 | 0.0 | 0 | 2.0396772859683185e-05 | 2.0396772859683185e-05 | 0.0 |
48655 | 48655 | 2020-09-10 | Sutter | 101 | 95872.0 | 1 | 0 | 1.0 | 0 | 0.0 | 0 | 0.0 | 0 | 1.0 | 0 | 1.0 | 0 | 0.0 | 0 | 1.0430574098798398e-05 | 1.0430574098798398e-05 | 0.0 |
48656 | 48656 | 2020-09-10 | Tehama | 103 | 63373.0 | 17 | 0 | 5.0 | 0 | 12.0 | 0 | 0.0 | 0 | 9.0 | 0 | 13.0 | 0 | 4.0 | 0 | 0.0001420163160967 | 0.0002051346788064 | 6.311836270967131e-05 |
48657 | 48657 | 2020-09-10 | 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 |
48658 | 48658 | 2020-09-10 | 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 |
48659 | 48659 | 2020-09-10 | 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 |
48660 | 48660 | 2020-09-10 | Ventura | 111 | 848112.0 | 13 | 0 | 10.0 | 0 | 3.0 | 0 | 0.0 | 0 | 9.0 | 0 | 11.0 | 0 | 2.0 | 0 | 1.0611805987888391e-05 | 1.2969985096308034e-05 | 2.3581791084196427e-06 |
48661 | 48661 | 2020-09-10 | Yolo | 113 | 214977.0 | 31 | 1 | 18.0 | 1 | 13.0 | 0 | 0.0 | 0 | 27.0 | 1 | 29.0 | 1 | 2.0 | 0 | 0.0001255948310749 | 0.0001348981518953 | 9.30332082036683e-06 |
48662 | 48662 | 2020-09-10 | Yuba | 115 | 75493.0 | 3 | 0 | 0.0 | 0 | 3.0 | 0 | 0.0 | 0 | 1.0 | 0 | 2.0 | 0 | 1.0 | 0 | 1.3246261242764227e-05 | 2.6492522485528455e-05 | 1.3246261242764227e-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 );