latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2021-08-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
611 | 611 | Alameda | Alameda | 1 | 2021-08-23 | 100511 | 1257 | |
612 | 612 | Berkeley | Alameda | 1 | 2021-08-23 | 4348 | 52 | |
613 | 613 | Alpine | Alpine | 3 | 2021-08-23 | 89 | 0 | TRUE |
614 | 614 | Amador | Amador | 5 | 2021-08-23 | 4317 | 50 | |
615 | 615 | Butte | Butte | 7 | 2021-08-23 | 14942 | 205 | |
616 | 616 | Calaveras | Calaveras | 9 | 2021-08-23 | 2660 | 61 | |
617 | 617 | Colusa | Colusa | 11 | 2021-08-23 | 2655 | 18 | |
618 | 618 | Contra Costa | Contra Costa | 13 | 2021-08-23 | 85019 | 854 | |
619 | 619 | Del Norte | Del Norte | 15 | 2021-08-23 | 2447 | 15 | TRUE |
620 | 620 | El Dorado | El Dorado | 17 | 2021-08-23 | 12747 | 122 | |
621 | 621 | Fresno | Fresno | 19 | 2021-08-23 | 112057 | 1759 | |
622 | 622 | Glenn | Glenn | 21 | 2021-08-23 | 2516 | 27 | |
623 | 623 | Humboldt | Humboldt | 23 | 2021-08-23 | 6529 | 62 | |
624 | 624 | Imperial | Imperial | 25 | 2021-08-23 | 29447 | 749 | TRUE |
625 | 625 | Inyo | Inyo | 27 | 2021-08-23 | 1520 | 39 | |
626 | 626 | Kern | Kern | 29 | 2021-08-23 | 120857 | 1448 | |
627 | 627 | Kings | Kings | 31 | 2021-08-23 | 25541 | 258 | |
628 | 628 | Lake | Lake | 33 | 2021-08-23 | 5069 | 69 | |
629 | 629 | Lassen | Lassen | 35 | 2021-08-23 | 6122 | 27 | TRUE |
630 | 630 | Long Beach | Los Angeles | 37 | 2021-08-23 | 59716 | 966 | |
631 | 631 | Los Angeles | Los Angeles | 37 | 2021-08-23 | 1313497 | 23761 | |
632 | 632 | Pasadena | Los Angeles | 37 | 2021-08-23 | 12571 | 354 | |
633 | 633 | Madera | Madera | 39 | 2021-08-23 | 17718 | 249 | TRUE |
634 | 634 | Marin | Marin | 41 | 2021-08-23 | 15977 | 215 | |
635 | 635 | Mariposa | Mariposa | 43 | 2021-08-23 | 740 | 10 | |
636 | 636 | Mendocino | Mendocino | 45 | 2021-08-23 | 5605 | 57 | TRUE |
637 | 637 | Merced | Merced | 47 | 2021-08-23 | 35648 | 499 | |
638 | 638 | Modoc | Modoc | 49 | 2021-08-23 | 593 | 7 | TRUE |
639 | 639 | Mono | Mono | 51 | 2021-08-23 | 1427 | 5 | |
640 | 640 | Monterey | Monterey | 53 | 2021-08-23 | 45945 | 541 | |
641 | 641 | Napa | Napa | 55 | 2021-08-23 | 11279 | 85 | |
642 | 642 | Nevada | Nevada | 57 | 2021-08-23 | 6784 | 81 | |
643 | 643 | Orange | Orange | 59 | 2021-08-23 | 281092 | 5178 | |
644 | 644 | Placer | Placer | 61 | 2021-08-23 | 28008 | 313 | TRUE |
645 | 645 | Plumas | Plumas | 63 | 2021-08-23 | 902 | 6 | TRUE |
646 | 646 | Riverside | Riverside | 65 | 2021-08-23 | 327971 | 4701 | |
647 | 647 | Sacramento | Sacramento | 67 | 2021-08-23 | 128340 | 1853 | |
648 | 648 | San Benito | San Benito | 69 | 2021-08-23 | 6598 | 64 | |
649 | 649 | San Bernardino | San Bernardino | 71 | 2021-08-23 | 323047 | 4899 | |
650 | 650 | San Diego | San Diego | 73 | 2021-08-23 | 324537 | 3848 | |
651 | 651 | San Francisco | San Francisco | 75 | 2021-08-23 | 45310 | 577 | |
652 | 652 | San Joaquin | San Joaquin | 77 | 2021-08-23 | 83121 | 1498 | |
653 | 653 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-23 | 24162 | 274 | TRUE |
654 | 654 | San Mateo | San Mateo | 81 | 2021-08-23 | 47635 | 594 | |
655 | 655 | Santa Barbara | Santa Barbara | 83 | 2021-08-23 | 38302 | 473 | |
656 | 656 | Santa Clara | Santa Clara | 85 | 2021-08-23 | 130978 | 1721 | |
657 | 657 | Santa Cruz | Santa Cruz | 87 | 2021-08-23 | 17792 | 209 | |
658 | 658 | Shasta | Shasta | 89 | 2021-08-23 | 14591 | 251 | |
659 | 659 | Sierra | Sierra | 91 | 2021-08-23 | 174 | 0 | |
660 | 660 | Siskiyou | Siskiyou | 93 | 2021-08-23 | 3014 | 40 | |
661 | 661 | Solano | Solano | 95 | 2021-08-23 | 39002 | 264 | |
662 | 662 | Sonoma | Sonoma | 97 | 2021-08-23 | 35664 | 344 | |
663 | 663 | Stanislaus | Stanislaus | 99 | 2021-08-23 | 64417 | 1118 | |
664 | 664 | Sutter | Sutter | 101 | 2021-08-23 | 11427 | 118 | |
665 | 665 | Tehama | Tehama | 103 | 2021-08-23 | 6503 | 66 | TRUE |
666 | 666 | Trinity | Trinity | 105 | 2021-08-23 | 584 | 8 | |
667 | 667 | Tulare | Tulare | 107 | 2021-08-23 | 53029 | 855 | |
668 | 668 | Tuolumne | Tuolumne | 109 | 2021-08-23 | 5403 | 83 | |
669 | 669 | Ventura | Ventura | 111 | 2021-08-23 | 88980 | 1059 | |
670 | 670 | Yolo | Yolo | 113 | 2021-08-23 | 16368 | 224 | |
671 | 671 | Yuba | Yuba | 115 | 2021-08-23 | 8075 | 46 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );