latimes-county-totals
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 confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
201 | 201 | 2021-08-30 | Monterey | 53 | 46424 | 542 | 84 | 0 |
202 | 202 | 2021-08-30 | Napa | 55 | 11604 | 86 | 117 | 0 |
203 | 203 | 2021-08-30 | Nevada | 57 | 7156 | 85 | 122 | 0 |
204 | 204 | 2021-08-30 | Orange | 59 | 285098 | 5220 | 1525 | 18 |
205 | 205 | 2021-08-30 | Placer | 61 | 28948 | 316 | 0 | 0 |
206 | 206 | 2021-08-30 | Plumas | 63 | 1017 | 6 | 34 | 0 |
207 | 207 | 2021-08-30 | Riverside | 65 | 334846 | 4727 | 2347 | 0 |
208 | 208 | 2021-08-30 | Sacramento | 67 | 133480 | 1907 | 2469 | 7 |
209 | 209 | 2021-08-30 | San Benito | 69 | 6696 | 65 | 39 | 0 |
210 | 210 | 2021-08-30 | San Bernardino | 71 | 328780 | 4914 | 1025 | 4 |
211 | 211 | 2021-08-30 | San Diego | 73 | 333011 | 3885 | 1681 | 5 |
212 | 212 | 2021-08-30 | San Francisco | 75 | 46500 | 584 | 187 | 1 |
213 | 213 | 2021-08-30 | San Joaquin | 77 | 85922 | 1528 | 1493 | 15 |
214 | 214 | 2021-08-30 | San Luis Obispo | 79 | 25137 | 279 | 0 | -2 |
215 | 215 | 2021-08-30 | San Mateo | 81 | 48545 | 595 | 484 | 0 |
216 | 216 | 2021-08-30 | Santa Barbara | 83 | 39118 | 476 | 327 | 1 |
217 | 217 | 2021-08-30 | Santa Clara | 85 | 133780 | 1731 | 1276 | 0 |
218 | 218 | 2021-08-30 | Santa Cruz | 87 | 18340 | 210 | 245 | 0 |
219 | 219 | 2021-08-30 | Shasta | 89 | 15353 | 254 | 152 | 2 |
220 | 220 | 2021-08-30 | Sierra | 91 | 188 | 0 | 0 | 0 |
221 | 221 | 2021-08-30 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
222 | 222 | 2021-08-30 | Solano | 95 | 40477 | 270 | 677 | 4 |
223 | 223 | 2021-08-30 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
224 | 224 | 2021-08-30 | Stanislaus | 99 | 66642 | 1139 | 1002 | 6 |
225 | 225 | 2021-08-30 | Sutter | 101 | 11961 | 121 | 197 | 1 |
226 | 226 | 2021-08-30 | Tehama | 103 | 6864 | 71 | 0 | 0 |
227 | 227 | 2021-08-30 | Trinity | 105 | 641 | 8 | 9 | 0 |
228 | 228 | 2021-08-30 | Tulare | 107 | 54523 | 869 | 508 | 2 |
229 | 229 | 2021-08-30 | Tuolumne | 109 | 5660 | 88 | 57 | 1 |
230 | 230 | 2021-08-30 | Ventura | 111 | 90335 | 1074 | 469 | 2 |
231 | 231 | 2021-08-30 | Yolo | 113 | 16925 | 229 | 165 | 0 |
232 | 232 | 2021-08-30 | Yuba | 115 | 8551 | 50 | 134 | 0 |
233 | 233 | 2021-08-29 | Alameda | 1 | 107492 | 1312 | 78 | 0 |
234 | 234 | 2021-08-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
235 | 235 | 2021-08-29 | Amador | 5 | 4454 | 53 | 0 | 0 |
236 | 236 | 2021-08-29 | Butte | 7 | 15401 | 208 | 0 | 0 |
237 | 237 | 2021-08-29 | Calaveras | 9 | 2764 | 61 | 0 | 0 |
238 | 238 | 2021-08-29 | Colusa | 11 | 2655 | 18 | 0 | 0 |
239 | 239 | 2021-08-29 | Contra Costa | 13 | 87806 | 869 | 508 | 0 |
240 | 240 | 2021-08-29 | Del Norte | 15 | 2805 | 22 | 0 | 0 |
241 | 241 | 2021-08-29 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
242 | 242 | 2021-08-29 | Fresno | 19 | 115079 | 1792 | 598 | 18 |
243 | 243 | 2021-08-29 | Glenn | 21 | 2590 | 28 | 0 | 0 |
244 | 244 | 2021-08-29 | Humboldt | 23 | 6874 | 71 | 0 | 0 |
245 | 245 | 2021-08-29 | Imperial | 25 | 29719 | 751 | 0 | 0 |
246 | 246 | 2021-08-29 | Inyo | 27 | 1555 | 39 | 0 | 0 |
247 | 247 | 2021-08-29 | Kern | 29 | 122950 | 1458 | 0 | 0 |
248 | 248 | 2021-08-29 | Kings | 31 | 26195 | 264 | 164 | 2 |
249 | 249 | 2021-08-29 | Lake | 33 | 5267 | 74 | 39 | 0 |
250 | 250 | 2021-08-29 | Lassen | 35 | 6239 | 27 | 0 | 0 |
251 | 251 | 2021-08-29 | Los Angeles | 37 | 1403053 | 25245 | 2216 | 5 |
252 | 252 | 2021-08-29 | Madera | 39 | 18129 | 250 | 0 | 0 |
253 | 253 | 2021-08-29 | Marin | 41 | 16250 | 215 | 17 | 0 |
254 | 254 | 2021-08-29 | Mariposa | 43 | 781 | 10 | 0 | 0 |
255 | 255 | 2021-08-29 | Mendocino | 45 | 5927 | 61 | 0 | 0 |
256 | 256 | 2021-08-29 | Merced | 47 | 36352 | 506 | 0 | 0 |
257 | 257 | 2021-08-29 | Modoc | 49 | 606 | 7 | 0 | 0 |
258 | 258 | 2021-08-29 | Mono | 51 | 1433 | 5 | 0 | 0 |
259 | 259 | 2021-08-29 | Monterey | 53 | 46340 | 542 | 0 | 0 |
260 | 260 | 2021-08-29 | Napa | 55 | 11487 | 86 | 0 | 0 |
261 | 261 | 2021-08-29 | Nevada | 57 | 7034 | 85 | 0 | 0 |
262 | 262 | 2021-08-29 | Orange | 59 | 283573 | 5202 | 0 | 0 |
263 | 263 | 2021-08-29 | Placer | 61 | 28948 | 316 | 0 | 0 |
264 | 264 | 2021-08-29 | Plumas | 63 | 983 | 6 | 0 | 0 |
265 | 265 | 2021-08-29 | Riverside | 65 | 332499 | 4727 | 0 | 0 |
266 | 266 | 2021-08-29 | Sacramento | 67 | 131011 | 1900 | 0 | 0 |
267 | 267 | 2021-08-29 | San Benito | 69 | 6657 | 65 | 0 | 0 |
268 | 268 | 2021-08-29 | San Bernardino | 71 | 327755 | 4910 | 0 | 0 |
269 | 269 | 2021-08-29 | San Diego | 73 | 331330 | 3880 | 0 | 0 |
270 | 270 | 2021-08-29 | San Francisco | 75 | 46313 | 583 | 0 | 0 |
271 | 271 | 2021-08-29 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
272 | 272 | 2021-08-29 | San Luis Obispo | 79 | 25137 | 281 | 0 | 0 |
273 | 273 | 2021-08-29 | San Mateo | 81 | 48061 | 595 | 0 | 0 |
274 | 274 | 2021-08-29 | Santa Barbara | 83 | 38791 | 475 | 0 | 0 |
275 | 275 | 2021-08-29 | Santa Clara | 85 | 132504 | 1731 | 0 | 0 |
276 | 276 | 2021-08-29 | Santa Cruz | 87 | 18095 | 210 | 0 | 0 |
277 | 277 | 2021-08-29 | Shasta | 89 | 15201 | 252 | 0 | 0 |
278 | 278 | 2021-08-29 | Sierra | 91 | 188 | 0 | 0 | 0 |
279 | 279 | 2021-08-29 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
280 | 280 | 2021-08-29 | Solano | 95 | 39800 | 266 | 0 | 0 |
281 | 281 | 2021-08-29 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
282 | 282 | 2021-08-29 | Stanislaus | 99 | 65640 | 1133 | 0 | 0 |
283 | 283 | 2021-08-29 | Sutter | 101 | 11764 | 120 | 0 | 0 |
284 | 284 | 2021-08-29 | Tehama | 103 | 6864 | 71 | 0 | 0 |
285 | 285 | 2021-08-29 | Trinity | 105 | 632 | 8 | 0 | 0 |
286 | 286 | 2021-08-29 | Tulare | 107 | 54015 | 867 | 0 | 0 |
287 | 287 | 2021-08-29 | Tuolumne | 109 | 5603 | 87 | 0 | 0 |
288 | 288 | 2021-08-29 | Ventura | 111 | 89866 | 1072 | 0 | 0 |
289 | 289 | 2021-08-29 | Yolo | 113 | 16760 | 229 | 0 | 0 |
290 | 290 | 2021-08-29 | Yuba | 115 | 8417 | 50 | 0 | 0 |
291 | 291 | 2021-08-28 | Alameda | 1 | 107414 | 1312 | 611 | 0 |
292 | 292 | 2021-08-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
293 | 293 | 2021-08-28 | Amador | 5 | 4454 | 53 | 42 | 0 |
294 | 294 | 2021-08-28 | Butte | 7 | 15401 | 208 | 0 | 0 |
295 | 295 | 2021-08-28 | Calaveras | 9 | 2764 | 61 | 0 | 0 |
296 | 296 | 2021-08-28 | Colusa | 11 | 2655 | 18 | 0 | 0 |
297 | 297 | 2021-08-28 | Contra Costa | 13 | 87298 | 869 | 561 | 0 |
298 | 298 | 2021-08-28 | Del Norte | 15 | 2805 | 22 | 0 | 0 |
299 | 299 | 2021-08-28 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
300 | 300 | 2021-08-28 | Fresno | 19 | 114481 | 1774 | 627 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );