cdph-county-cases-deaths
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 2022-12-26 | Santa Clara | 85 | 1922200 | 461517 | 459089 | 20879 | 479968 | 2579 |
102 | 102 | 2022-12-26 | Santa Cruz | 87 | 273765 | 66735 | 66560 | 3711 | 70271 | 277 |
103 | 103 | 2022-12-26 | Shasta | 89 | 179085 | 35950 | 35856 | 8167 | 44023 | 601 |
104 | 104 | 2022-12-26 | Sierra | 91 | 2930 | 309 | 308 | 62 | 370 | 5 |
105 | 105 | 2022-12-26 | Siskiyou | 93 | 43540 | 5355 | 5334 | 3409 | 8743 | 95 |
106 | 106 | 2022-12-26 | Solano | 95 | 438530 | 110577 | 109900 | 8284 | 118184 | 474 |
107 | 107 | 2022-12-26 | Sonoma | 97 | 501317 | 111088 | 110643 | 5639 | 116282 | 536 |
108 | 108 | 2022-12-26 | Stanislaus | 99 | 539301 | 142372 | 141956 | 22362 | 164318 | 1795 |
109 | 109 | 2022-12-26 | Sutter | 101 | 95872 | 25202 | 25088 | 2510 | 27598 | 235 |
110 | 110 | 2022-12-26 | Tehama | 103 | 63373 | 14187 | 14127 | 3358 | 17485 | 218 |
111 | 111 | 2022-12-26 | Trinity | 105 | 12862 | 1442 | 1438 | 476 | 1914 | 23 |
112 | 112 | 2022-12-26 | Tulare | 107 | 460477 | 125303 | 124848 | 38856 | 163704 | 1546 |
113 | 113 | 2022-12-26 | Tuolumne | 109 | 53932 | 16339 | 16261 | 1013 | 17274 | 209 |
114 | 114 | 2022-12-26 | Ventura | 111 | 848112 | 216324 | 215497 | 17290 | 232787 | 1604 |
115 | 115 | 2022-12-26 | Yolo | 113 | 214977 | 48970 | 48842 | 4792 | 53634 | 422 |
116 | 116 | 2022-12-26 | Yuba | 115 | 75493 | 19650 | 19553 | 1803 | 21356 | 132 |
117 | 117 | 2022-12-25 | Alameda | 1 | 1643700 | 367801 | 366018 | 21599 | 387617 | 2088 |
118 | 118 | 2022-12-25 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
119 | 119 | 2022-12-25 | Amador | 5 | 37829 | 10311 | 10269 | 960 | 11229 | 96 |
120 | 120 | 2022-12-25 | Butte | 7 | 227075 | 41012 | 40923 | 9796 | 50719 | 473 |
121 | 121 | 2022-12-25 | Calaveras | 9 | 45235 | 8815 | 8794 | 628 | 9422 | 135 |
122 | 122 | 2022-12-25 | Colusa | 11 | 21464 | 3903 | 3891 | 1317 | 5208 | 22 |
123 | 123 | 2022-12-25 | Contra Costa | 13 | 1133247 | 264323 | 262951 | 21945 | 284896 | 1492 |
124 | 124 | 2022-12-25 | Del Norte | 15 | 27424 | 7641 | 7612 | 435 | 8047 | 56 |
125 | 125 | 2022-12-25 | El Dorado | 17 | 186661 | 33856 | 33729 | 4471 | 38200 | 236 |
126 | 126 | 2022-12-25 | Fresno | 19 | 978130 | 285410 | 284361 | 33451 | 317812 | 2907 |
127 | 127 | 2022-12-25 | Glenn | 21 | 27897 | 5719 | 5702 | 1969 | 7671 | 58 |
128 | 128 | 2022-12-25 | Humboldt | 23 | 135768 | 22828 | 22760 | 5570 | 28330 | 161 |
129 | 129 | 2022-12-25 | Imperial | 25 | 180216 | 68602 | 68403 | 18297 | 86700 | 963 |
130 | 130 | 2022-12-25 | Inyo | 27 | 18085 | 4667 | 4655 | 1206 | 5861 | 60 |
131 | 131 | 2022-12-25 | Kern | 29 | 883053 | 225641 | 224945 | 68783 | 293728 | 2446 |
132 | 132 | 2022-12-25 | Kings | 31 | 150075 | 61663 | 61461 | 4366 | 65827 | 467 |
133 | 133 | 2022-12-25 | Lake | 33 | 64148 | 13309 | 13254 | 1287 | 14541 | 149 |
134 | 134 | 2022-12-25 | Lassen | 35 | 31185 | 10171 | 10151 | 1032 | 11183 | 66 |
135 | 135 | 2022-12-25 | Los Angeles | 37 | 10098052 | 3420005 | 3399852 | 203934 | 3603786 | 34170 |
136 | 136 | 2022-12-25 | Madera | 39 | 155013 | 45437 | 45290 | 8666 | 53956 | 377 |
137 | 137 | 2022-12-25 | Marin | 41 | 260295 | 47666 | 47457 | 5607 | 53064 | 315 |
138 | 138 | 2022-12-25 | Mariposa | 43 | 17540 | 3211 | 3201 | 400 | 3601 | 32 |
139 | 139 | 2022-12-25 | Mendocino | 45 | 87422 | 16503 | 16435 | 4737 | 21172 | 137 |
140 | 140 | 2022-12-25 | Merced | 47 | 269075 | 74716 | 74498 | 12395 | 86893 | 880 |
141 | 141 | 2022-12-25 | Modoc | 49 | 8938 | 930 | 927 | 363 | 1290 | 11 |
142 | 142 | 2022-12-25 | Mono | 51 | 14174 | 3269 | 3264 | 292 | 3556 | 8 |
143 | 143 | 2022-12-25 | Monterey | 53 | 433212 | 96368 | 96192 | 22388 | 118580 | 776 |
144 | 144 | 2022-12-25 | Napa | 55 | 140530 | 33514 | 33370 | 1506 | 34876 | 163 |
145 | 145 | 2022-12-25 | Nevada | 57 | 99092 | 19769 | 19696 | 2207 | 21903 | 132 |
146 | 146 | 2022-12-25 | Orange | 59 | 3164182 | 693924 | 690845 | 71202 | 762047 | 7628 |
147 | 147 | 2022-12-25 | Placer | 61 | 380077 | 79128 | 78813 | 10042 | 88855 | 669 |
148 | 148 | 2022-12-25 | Plumas | 63 | 18699 | 3787 | 3778 | 453 | 4231 | 13 |
149 | 149 | 2022-12-25 | Riverside | 65 | 2383286 | 720326 | 717576 | 39137 | 756713 | 6738 |
150 | 150 | 2022-12-25 | Sacramento | 67 | 1510023 | 362592 | 361095 | 36161 | 397256 | 3407 |
151 | 151 | 2022-12-25 | San Benito | 69 | 59416 | 17203 | 17109 | 1086 | 18195 | 108 |
152 | 152 | 2022-12-25 | San Bernardino | 71 | 2135413 | 696352 | 693567 | 33533 | 727100 | 8136 |
153 | 153 | 2022-12-25 | San Diego | 73 | 3302833 | 962471 | 957866 | 77322 | 1035188 | 5626 |
154 | 154 | 2022-12-25 | San Francisco | 75 | 870044 | 189941 | 188947 | 12931 | 201878 | 1095 |
155 | 155 | 2022-12-25 | San Joaquin | 77 | 732212 | 205432 | 204712 | 16226 | 220938 | 2353 |
156 | 156 | 2022-12-25 | San Luis Obispo | 79 | 281455 | 64954 | 64748 | 7775 | 72523 | 536 |
157 | 157 | 2022-12-25 | San Mateo | 81 | 765935 | 177668 | 176920 | 11225 | 188145 | 748 |
158 | 158 | 2022-12-25 | Santa Barbara | 83 | 443738 | 109552 | 109074 | 7391 | 116465 | 744 |
159 | 159 | 2022-12-25 | Santa Clara | 85 | 1922200 | 461363 | 459089 | 20879 | 479968 | 2579 |
160 | 160 | 2022-12-25 | Santa Cruz | 87 | 273765 | 66733 | 66560 | 3711 | 70271 | 277 |
161 | 161 | 2022-12-25 | Shasta | 89 | 179085 | 35949 | 35856 | 8167 | 44023 | 601 |
162 | 162 | 2022-12-25 | Sierra | 91 | 2930 | 309 | 308 | 62 | 370 | 5 |
163 | 163 | 2022-12-25 | Siskiyou | 93 | 43540 | 5352 | 5334 | 3409 | 8743 | 95 |
164 | 164 | 2022-12-25 | Solano | 95 | 438530 | 110520 | 109900 | 8284 | 118184 | 474 |
165 | 165 | 2022-12-25 | Sonoma | 97 | 501317 | 111049 | 110643 | 5639 | 116282 | 536 |
166 | 166 | 2022-12-25 | Stanislaus | 99 | 539301 | 142353 | 141956 | 22362 | 164318 | 1795 |
167 | 167 | 2022-12-25 | Sutter | 101 | 95872 | 25190 | 25088 | 2510 | 27598 | 235 |
168 | 168 | 2022-12-25 | Tehama | 103 | 63373 | 14187 | 14127 | 3358 | 17485 | 218 |
169 | 169 | 2022-12-25 | Trinity | 105 | 12862 | 1442 | 1438 | 476 | 1914 | 23 |
170 | 170 | 2022-12-25 | Tulare | 107 | 460477 | 125284 | 124848 | 38856 | 163704 | 1546 |
171 | 171 | 2022-12-25 | Tuolumne | 109 | 53932 | 16333 | 16261 | 1013 | 17274 | 209 |
172 | 172 | 2022-12-25 | Ventura | 111 | 848112 | 216283 | 215497 | 17290 | 232787 | 1604 |
173 | 173 | 2022-12-25 | Yolo | 113 | 214977 | 48962 | 48842 | 4792 | 53634 | 422 |
174 | 174 | 2022-12-25 | Yuba | 115 | 75493 | 19643 | 19553 | 1803 | 21356 | 132 |
175 | 175 | 2022-12-24 | Alameda | 1 | 1643700 | 367725 | 366018 | 21599 | 387617 | 2088 |
176 | 176 | 2022-12-24 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
177 | 177 | 2022-12-24 | Amador | 5 | 37829 | 10310 | 10269 | 960 | 11229 | 96 |
178 | 178 | 2022-12-24 | Butte | 7 | 227075 | 41012 | 40923 | 9796 | 50719 | 473 |
179 | 179 | 2022-12-24 | Calaveras | 9 | 45235 | 8814 | 8794 | 628 | 9422 | 135 |
180 | 180 | 2022-12-24 | Colusa | 11 | 21464 | 3903 | 3891 | 1317 | 5208 | 22 |
181 | 181 | 2022-12-24 | Contra Costa | 13 | 1133247 | 264273 | 262951 | 21945 | 284896 | 1492 |
182 | 182 | 2022-12-24 | Del Norte | 15 | 27424 | 7638 | 7612 | 435 | 8047 | 56 |
183 | 183 | 2022-12-24 | El Dorado | 17 | 186661 | 33852 | 33729 | 4471 | 38200 | 236 |
184 | 184 | 2022-12-24 | Fresno | 19 | 978130 | 285352 | 284361 | 33451 | 317812 | 2907 |
185 | 185 | 2022-12-24 | Glenn | 21 | 27897 | 5719 | 5702 | 1969 | 7671 | 58 |
186 | 186 | 2022-12-24 | Humboldt | 23 | 135768 | 22824 | 22760 | 5570 | 28330 | 161 |
187 | 187 | 2022-12-24 | Imperial | 25 | 180216 | 68593 | 68403 | 18297 | 86700 | 963 |
188 | 188 | 2022-12-24 | Inyo | 27 | 18085 | 4666 | 4655 | 1206 | 5861 | 60 |
189 | 189 | 2022-12-24 | Kern | 29 | 883053 | 225624 | 224945 | 68783 | 293728 | 2446 |
190 | 190 | 2022-12-24 | Kings | 31 | 150075 | 61658 | 61461 | 4366 | 65827 | 467 |
191 | 191 | 2022-12-24 | Lake | 33 | 64148 | 13300 | 13254 | 1287 | 14541 | 149 |
192 | 192 | 2022-12-24 | Lassen | 35 | 31185 | 10170 | 10151 | 1032 | 11183 | 66 |
193 | 193 | 2022-12-24 | Los Angeles | 37 | 10098052 | 3419672 | 3399852 | 203902 | 3603754 | 34170 |
194 | 194 | 2022-12-24 | Madera | 39 | 155013 | 45434 | 45290 | 8666 | 53956 | 377 |
195 | 195 | 2022-12-24 | Marin | 41 | 260295 | 47661 | 47457 | 5607 | 53064 | 315 |
196 | 196 | 2022-12-24 | Mariposa | 43 | 17540 | 3210 | 3201 | 400 | 3601 | 32 |
197 | 197 | 2022-12-24 | Mendocino | 45 | 87422 | 16499 | 16435 | 4737 | 21172 | 137 |
198 | 198 | 2022-12-24 | Merced | 47 | 269075 | 74711 | 74498 | 12395 | 86893 | 880 |
199 | 199 | 2022-12-24 | Modoc | 49 | 8938 | 930 | 927 | 363 | 1290 | 11 |
200 | 200 | 2022-12-24 | Mono | 51 | 14174 | 3267 | 3264 | 292 | 3556 | 8 |
Advanced export
JSON shape: default, array, newline-delimited
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 );