latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 58
- 37 586
- 59 585
- 85 585
- 69 579
- 23 563
- 67 563
- 13 559
- 41 559
- 113 559
- 1 558
- 9 558
- 65 558
- 75 558
- 81 558
- 89 558
- 99 558
- 111 558
- 73 557
- 95 557
- 97 557
- 61 556
- 87 556
- 19 555
- 77 547
- 39 541
- 107 541
- 5 538
- 25 538
- 71 536
- 83 536
- 29 534
- 53 534
- 57 534
- 79 534
- 45 532
- 17 531
- 51 530
- 115 530
- 47 529
- 55 529
- 93 529
- 101 526
- 31 525
- 21 524
- 27 524
- 109 522
- 11 521
- 7 520
- 103 519
- 15 518
- 63 517
- 33 516
- 3 515
- 43 492
- 105 492
- 49 490
- 35 489
- 91 489
county 58
- Los Angeles 586
- Orange 585
- Santa Clara 585
- San Benito 579
- Humboldt 563
- Sacramento 563
- Contra Costa 559
- Marin 559
- Yolo 559
- Alameda 558
- Calaveras 558
- Riverside 558
- San Francisco 558
- San Mateo 558
- Shasta 558
- Stanislaus 558
- Ventura 558
- San Diego 557
- Solano 557
- Sonoma 557
- Placer 556
- Santa Cruz 556
- Fresno 555
- San Joaquin 547
- Madera 541
- Tulare 541
- Amador 538
- Imperial 538
- San Bernardino 536
- Santa Barbara 536
- Kern 534
- Monterey 534
- Nevada 534
- San Luis Obispo 534
- Mendocino 532
- El Dorado 531
- Mono 530
- Yuba 530
- Merced 529
- Napa 529
- Siskiyou 529
- Sutter 526
- Kings 525
- Glenn 524
- Inyo 524
- Tuolumne 522
- Colusa 521
- Butte 520
- Tehama 519
- Del Norte 518
- Plumas 517
- Lake 516
- Alpine 515
- Mariposa 492
- Trinity 492
- Modoc 490
- Lassen 489
- Sierra 489
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
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 |
292 | 292 | 2021-08-28 | Alpine | 3 | 89 | 0 | 0 | 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 |
298 | 298 | 2021-08-28 | Del Norte | 15 | 2805 | 22 | 0 | 0 |
299 | 299 | 2021-08-28 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
301 | 301 | 2021-08-28 | Glenn | 21 | 2590 | 28 | 0 | 0 |
302 | 302 | 2021-08-28 | Humboldt | 23 | 6874 | 71 | 0 | 0 |
303 | 303 | 2021-08-28 | Imperial | 25 | 29719 | 751 | 0 | 0 |
304 | 304 | 2021-08-28 | Inyo | 27 | 1555 | 39 | 0 | 0 |
305 | 305 | 2021-08-28 | Kern | 29 | 122950 | 1458 | 0 | 0 |
306 | 306 | 2021-08-28 | Kings | 31 | 26031 | 262 | 0 | 0 |
308 | 308 | 2021-08-28 | Lassen | 35 | 6239 | 27 | 0 | 0 |
310 | 310 | 2021-08-28 | Madera | 39 | 18129 | 250 | 0 | 0 |
312 | 312 | 2021-08-28 | Mariposa | 43 | 781 | 10 | 0 | 0 |
314 | 314 | 2021-08-28 | Merced | 47 | 36352 | 506 | 0 | 0 |
315 | 315 | 2021-08-28 | Modoc | 49 | 606 | 7 | 0 | 0 |
316 | 316 | 2021-08-28 | Mono | 51 | 1433 | 5 | 0 | 0 |
317 | 317 | 2021-08-28 | Monterey | 53 | 46340 | 542 | 0 | 0 |
318 | 318 | 2021-08-28 | Napa | 55 | 11487 | 86 | 0 | 0 |
319 | 319 | 2021-08-28 | Nevada | 57 | 7034 | 85 | 0 | 0 |
320 | 320 | 2021-08-28 | Orange | 59 | 283573 | 5202 | 0 | 0 |
321 | 321 | 2021-08-28 | Placer | 61 | 28948 | 316 | 0 | 0 |
322 | 322 | 2021-08-28 | Plumas | 63 | 983 | 6 | 0 | 0 |
323 | 323 | 2021-08-28 | Riverside | 65 | 332499 | 4727 | 0 | 0 |
324 | 324 | 2021-08-28 | Sacramento | 67 | 131011 | 1900 | 0 | 0 |
325 | 325 | 2021-08-28 | San Benito | 69 | 6657 | 65 | 0 | 0 |
326 | 326 | 2021-08-28 | San Bernardino | 71 | 327755 | 4910 | 0 | 0 |
329 | 329 | 2021-08-28 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
330 | 330 | 2021-08-28 | San Luis Obispo | 79 | 25137 | 281 | 0 | 0 |
331 | 331 | 2021-08-28 | San Mateo | 81 | 48061 | 595 | 0 | 0 |
332 | 332 | 2021-08-28 | Santa Barbara | 83 | 38791 | 475 | 0 | 0 |
333 | 333 | 2021-08-28 | Santa Clara | 85 | 132504 | 1731 | 0 | 0 |
334 | 334 | 2021-08-28 | Santa Cruz | 87 | 18095 | 210 | 0 | 0 |
335 | 335 | 2021-08-28 | Shasta | 89 | 15201 | 252 | 0 | 0 |
336 | 336 | 2021-08-28 | Sierra | 91 | 188 | 0 | 0 | 0 |
337 | 337 | 2021-08-28 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
338 | 338 | 2021-08-28 | Solano | 95 | 39800 | 266 | 0 | 0 |
340 | 340 | 2021-08-28 | Stanislaus | 99 | 65640 | 1133 | 0 | 0 |
341 | 341 | 2021-08-28 | Sutter | 101 | 11764 | 120 | 0 | 0 |
343 | 343 | 2021-08-28 | Trinity | 105 | 632 | 8 | 0 | 0 |
344 | 344 | 2021-08-28 | Tulare | 107 | 54015 | 867 | 0 | 0 |
345 | 345 | 2021-08-28 | Tuolumne | 109 | 5603 | 87 | 0 | 0 |
346 | 346 | 2021-08-28 | Ventura | 111 | 89866 | 1072 | 0 | 0 |
347 | 347 | 2021-08-28 | Yolo | 113 | 16760 | 229 | 0 | 0 |
348 | 348 | 2021-08-28 | Yuba | 115 | 8417 | 50 | 0 | 0 |
350 | 350 | 2021-08-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
354 | 354 | 2021-08-27 | Colusa | 11 | 2655 | 18 | 0 | 0 |
361 | 361 | 2021-08-27 | Imperial | 25 | 29719 | 751 | 0 | 0 |
366 | 366 | 2021-08-27 | Lassen | 35 | 6239 | 27 | 0 | 0 |
368 | 368 | 2021-08-27 | Madera | 39 | 18129 | 250 | 0 | 0 |
373 | 373 | 2021-08-27 | Modoc | 49 | 606 | 7 | 0 | 0 |
379 | 379 | 2021-08-27 | Placer | 61 | 28948 | 316 | 0 | 0 |
380 | 380 | 2021-08-27 | Plumas | 63 | 983 | 6 | 0 | 0 |
392 | 392 | 2021-08-27 | Santa Cruz | 87 | 18095 | 210 | 0 | 0 |
394 | 394 | 2021-08-27 | Sierra | 91 | 188 | 0 | 0 | 0 |
397 | 397 | 2021-08-27 | Sonoma | 97 | 36158 | 349 | 0 | 0 |
408 | 408 | 2021-08-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
412 | 412 | 2021-08-26 | Colusa | 11 | 2655 | 18 | 0 | 0 |
414 | 414 | 2021-08-26 | Del Norte | 15 | 2682 | 18 | 0 | 0 |
417 | 417 | 2021-08-26 | Glenn | 21 | 2585 | 28 | 0 | 1 |
426 | 426 | 2021-08-26 | Madera | 39 | 18129 | 250 | 0 | 0 |
445 | 445 | 2021-08-26 | San Joaquin | 77 | 83466 | 1499 | 0 | 0 |
446 | 446 | 2021-08-26 | San Luis Obispo | 79 | 24622 | 279 | 0 | 0 |
454 | 454 | 2021-08-26 | Solano | 95 | 39329 | 266 | 0 | 0 |
466 | 466 | 2021-08-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
470 | 470 | 2021-08-25 | Colusa | 11 | 2655 | 18 | 0 | 0 |
475 | 475 | 2021-08-25 | Glenn | 21 | 2585 | 27 | 0 | 0 |
477 | 477 | 2021-08-25 | Imperial | 25 | 29669 | 751 | 0 | 0 |
478 | 478 | 2021-08-25 | Inyo | 27 | 1520 | 39 | 0 | 0 |
484 | 484 | 2021-08-25 | Madera | 39 | 18129 | 250 | 0 | 0 |
490 | 490 | 2021-08-25 | Mono | 51 | 1428 | 5 | 0 | 0 |
495 | 495 | 2021-08-25 | Placer | 61 | 28665 | 316 | 0 | 0 |
496 | 496 | 2021-08-25 | Plumas | 63 | 929 | 6 | 0 | 0 |
501 | 501 | 2021-08-25 | San Diego | 73 | 325823 | 3851 | 0 | 0 |
504 | 504 | 2021-08-25 | San Luis Obispo | 79 | 24622 | 279 | 0 | 0 |
508 | 508 | 2021-08-25 | Santa Cruz | 87 | 17792 | 209 | 0 | 0 |
524 | 524 | 2021-08-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
528 | 528 | 2021-08-24 | Colusa | 11 | 2655 | 18 | 0 | 0 |
536 | 536 | 2021-08-24 | Inyo | 27 | 1520 | 39 | 0 | 0 |
540 | 540 | 2021-08-24 | Lassen | 35 | 6122 | 27 | 0 | 0 |
561 | 561 | 2021-08-24 | San Joaquin | 77 | 83121 | 1498 | 0 | 0 |
566 | 566 | 2021-08-24 | Santa Cruz | 87 | 17792 | 209 | 0 | 0 |
568 | 568 | 2021-08-24 | Sierra | 91 | 174 | 0 | 0 | 0 |
570 | 570 | 2021-08-24 | Solano | 95 | 39002 | 264 | 0 | 0 |
571 | 571 | 2021-08-24 | Sonoma | 97 | 35664 | 344 | 0 | 0 |
582 | 582 | 2021-08-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
588 | 588 | 2021-08-23 | Del Norte | 15 | 2447 | 15 | 0 | 0 |
593 | 593 | 2021-08-23 | Imperial | 25 | 29447 | 749 | 0 | 0 |
598 | 598 | 2021-08-23 | Lassen | 35 | 6122 | 27 | 0 | 0 |
600 | 600 | 2021-08-23 | Madera | 39 | 17718 | 249 | 0 | 0 |
603 | 603 | 2021-08-23 | Mendocino | 45 | 5605 | 57 | 0 | 0 |
605 | 605 | 2021-08-23 | Modoc | 49 | 593 | 7 | 0 | 0 |
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 );