cdph-county-cases-deaths

Table actions

The county-level totals of cases and deaths logged by the California Department of Public Health.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

county
The name of the county where the agency is based.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
date
The date when the data were retrieved in ISO 8601 format.
confirmed_cases
The cumulative number of coronavirus cases that were confirmed as of that time. This is sometimes called the episode date by other sources.
reported_cases
The cumulative number of coronavirus cases that were reported as of that time. This reflects when cases were first announced by the state.
probable_cases
The cumulative number of probable coronavirus cases that were confirmed as of that time. This reflects the results of antigen tests, a rapid testing technique different from the standard test.
reported_and_probable_cases
The cumulative number of reported and probable coronavirus cases as of that time.
reported_deaths
The cumulative number of deaths reported at that time.

61,538 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date county fips population confirmed_cases reported_cases probable_cases reported_and_probable_cases reported_deaths
1 1 2022-12-27 Alameda 1 1643700 367947 367954 21599 389553 2094
2 2 2022-12-27 Alpine 3 1148 138 138 3 141 0
3 3 2022-12-27 Amador 5 37829 10312 10313 960 11273 96
4 4 2022-12-27 Butte 7 227075 41018 41018 9796 50814 474
5 5 2022-12-27 Calaveras 9 45235 8818 8818 628 9446 135
6 6 2022-12-27 Colusa 11 21464 3904 3906 1317 5223 22
7 7 2022-12-27 Contra Costa 13 1133247 264445 264448 21945 286393 1502
8 8 2022-12-27 Del Norte 15 27424 7644 7645 435 8080 56
9 9 2022-12-27 El Dorado 17 186661 33865 33865 4471 38336 236
10 10 2022-12-27 Fresno 19 978130 285440 285444 33451 318895 2918
11 11 2022-12-27 Glenn 21 27897 5719 5719 1969 7688 58
12 12 2022-12-27 Humboldt 23 135768 22832 22835 5570 28405 163
13 13 2022-12-27 Imperial 25 180216 68622 68622 18297 86919 963
14 14 2022-12-27 Inyo 27 18085 4670 4670 1206 5876 62
15 15 2022-12-27 Kern 29 883053 225654 225659 68783 294442 2450
16 16 2022-12-27 Kings 31 150075 61692 61692 4366 66058 466
17 17 2022-12-27 Lake 33 64148 13312 13312 1287 14599 149
18 18 2022-12-27 Lassen 35 31185 10172 10172 1032 11204 66
19 19 2022-12-27 Los Angeles 37 10098052 3420119 3420383 203950 3624333 34360
20 20 2022-12-27 Madera 39 155013 45446 45448 8666 54114 377
21 21 2022-12-27 Marin 41 260295 47682 47686 5607 53293 317
22 22 2022-12-27 Mariposa 43 17540 3211 3211 400 3611 32
23 23 2022-12-27 Mendocino 45 87422 16508 16508 4737 21245 137
24 24 2022-12-27 Merced 47 269075 74728 74732 12395 87127 883
25 25 2022-12-27 Modoc 49 8938 931 931 363 1294 11
26 26 2022-12-27 Mono 51 14174 3274 3274 292 3566 8
27 27 2022-12-27 Monterey 53 433212 96379 96380 22388 118768 776
28 28 2022-12-27 Napa 55 140530 33533 33534 1506 35040 163
29 29 2022-12-27 Nevada 57 99092 19769 19774 2207 21981 132
30 30 2022-12-27 Orange 59 3164182 694079 694080 71202 765282 7656
31 31 2022-12-27 Placer 61 380077 79154 79154 10042 89196 672
32 32 2022-12-27 Plumas 63 18699 3787 3787 453 4240 13
33 33 2022-12-27 Riverside 65 2383286 720377 720437 39137 759574 6738
34 34 2022-12-27 Sacramento 67 1510023 362662 362664 36161 398825 3414
35 35 2022-12-27 San Benito 69 59416 17209 17211 1086 18297 108
36 36 2022-12-27 San Bernardino 71 2135413 696415 696472 33533 730005 8142
37 37 2022-12-27 San Diego 73 3302833 962601 962601 77349 1039950 5641
38 38 2022-12-27 San Francisco 75 870044 190004 190012 12931 202943 1104
39 39 2022-12-27 San Joaquin 77 732212 205459 205467 16226 221693 2363
40 40 2022-12-27 San Luis Obispo 79 281455 64965 64966 7775 72741 536
41 41 2022-12-27 San Mateo 81 765935 177700 177703 11225 188928 749
42 42 2022-12-27 Santa Barbara 83 443738 109576 109576 7391 116967 747
43 43 2022-12-27 Santa Clara 85 1922200 461517 461535 20879 482414 2587
44 44 2022-12-27 Santa Cruz 87 273765 66735 66735 3711 70446 276
45 45 2022-12-27 Shasta 89 179085 35950 35950 8167 44117 602
46 46 2022-12-27 Sierra 91 2930 309 309 62 371 5
47 47 2022-12-27 Siskiyou 93 43540 5355 5355 3409 8764 95
48 48 2022-12-27 Solano 95 438530 110577 110589 8284 118873 475
49 49 2022-12-27 Sonoma 97 501317 111088 111095 5639 116734 536
50 50 2022-12-27 Stanislaus 99 539301 142372 142392 22362 164754 1795
51 51 2022-12-27 Sutter 101 95872 25202 25207 2510 27717 235
52 52 2022-12-27 Tehama 103 63373 14187 14187 3358 17545 219
53 53 2022-12-27 Trinity 105 12862 1442 1442 476 1918 23
54 54 2022-12-27 Tulare 107 460477 125303 125303 38856 164159 1546
55 55 2022-12-27 Tuolumne 109 53932 16339 16340 1013 17353 211
56 56 2022-12-27 Ventura 111 848112 216324 216327 17290 233617 1605
57 57 2022-12-27 Yolo 113 214977 48970 48970 4792 53762 426
58 58 2022-12-27 Yuba 115 75493 19650 19654 1803 21457 132
59 59 2022-12-26 Alameda 1 1643700 367947 366018 21599 387617 2088
60 60 2022-12-26 Alpine 3 1148 138 138 3 141 0
61 61 2022-12-26 Amador 5 37829 10312 10269 960 11229 96
62 62 2022-12-26 Butte 7 227075 41018 40923 9796 50719 473
63 63 2022-12-26 Calaveras 9 45235 8818 8794 628 9422 135
64 64 2022-12-26 Colusa 11 21464 3904 3891 1317 5208 22
65 65 2022-12-26 Contra Costa 13 1133247 264445 262951 21945 284896 1492
66 66 2022-12-26 Del Norte 15 27424 7644 7612 435 8047 56
67 67 2022-12-26 El Dorado 17 186661 33865 33729 4471 38200 236
68 68 2022-12-26 Fresno 19 978130 285440 284361 33451 317812 2907
69 69 2022-12-26 Glenn 21 27897 5719 5702 1969 7671 58
70 70 2022-12-26 Humboldt 23 135768 22832 22760 5570 28330 161
71 71 2022-12-26 Imperial 25 180216 68622 68403 18297 86700 963
72 72 2022-12-26 Inyo 27 18085 4670 4655 1206 5861 60
73 73 2022-12-26 Kern 29 883053 225654 224945 68783 293728 2446
74 74 2022-12-26 Kings 31 150075 61692 61461 4366 65827 467
75 75 2022-12-26 Lake 33 64148 13312 13254 1287 14541 149
76 76 2022-12-26 Lassen 35 31185 10172 10151 1032 11183 66
77 77 2022-12-26 Los Angeles 37 10098052 3420119 3399852 203950 3603802 34170
78 78 2022-12-26 Madera 39 155013 45446 45290 8666 53956 377
79 79 2022-12-26 Marin 41 260295 47682 47457 5607 53064 315
80 80 2022-12-26 Mariposa 43 17540 3211 3201 400 3601 32
81 81 2022-12-26 Mendocino 45 87422 16508 16435 4737 21172 137
82 82 2022-12-26 Merced 47 269075 74728 74498 12395 86893 880
83 83 2022-12-26 Modoc 49 8938 931 927 363 1290 11
84 84 2022-12-26 Mono 51 14174 3274 3264 292 3556 8
85 85 2022-12-26 Monterey 53 433212 96379 96192 22388 118580 776
86 86 2022-12-26 Napa 55 140530 33533 33370 1506 34876 163
87 87 2022-12-26 Nevada 57 99092 19769 19696 2207 21903 132
88 88 2022-12-26 Orange 59 3164182 694079 690845 71202 762047 7628
89 89 2022-12-26 Placer 61 380077 79154 78813 10042 88855 669
90 90 2022-12-26 Plumas 63 18699 3787 3778 453 4231 13
91 91 2022-12-26 Riverside 65 2383286 720377 717576 39137 756713 6738
92 92 2022-12-26 Sacramento 67 1510023 362662 361095 36161 397256 3407
93 93 2022-12-26 San Benito 69 59416 17209 17109 1086 18195 108
94 94 2022-12-26 San Bernardino 71 2135413 696415 693567 33533 727100 8136
95 95 2022-12-26 San Diego 73 3302833 962601 957866 77349 1035215 5626
96 96 2022-12-26 San Francisco 75 870044 190004 188947 12931 201878 1095
97 97 2022-12-26 San Joaquin 77 732212 205459 204712 16226 220938 2353
98 98 2022-12-26 San Luis Obispo 79 281455 64965 64748 7775 72523 536
99 99 2022-12-26 San Mateo 81 765935 177700 176920 11225 188145 748
100 100 2022-12-26 Santa Barbara 83 443738 109576 109074 7391 116465 744

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-county-cases-deaths" (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [population] INTEGER,
   [confirmed_cases] INTEGER,
   [reported_cases] INTEGER,
   [probable_cases] INTEGER,
   [reported_and_probable_cases] INTEGER,
   [reported_deaths] INTEGER
);