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-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
733 | 733 | Alameda | Alameda | 1 | 2021-08-21 | 100343 | 1257 | |
734 | 734 | Berkeley | Alameda | 1 | 2021-08-21 | 4318 | 52 | |
735 | 735 | Alpine | Alpine | 3 | 2021-08-21 | 89 | 0 | TRUE |
736 | 736 | Amador | Amador | 5 | 2021-08-21 | 4283 | 50 | TRUE |
737 | 737 | Butte | Butte | 7 | 2021-08-21 | 14699 | 205 | TRUE |
738 | 738 | Calaveras | Calaveras | 9 | 2021-08-21 | 2636 | 61 | TRUE |
739 | 739 | Colusa | Colusa | 11 | 2021-08-21 | 2565 | 18 | TRUE |
740 | 740 | Contra Costa | Contra Costa | 13 | 2021-08-21 | 84491 | 854 | |
741 | 741 | Del Norte | Del Norte | 15 | 2021-08-21 | 2447 | 15 | TRUE |
742 | 742 | El Dorado | El Dorado | 17 | 2021-08-21 | 12545 | 122 | TRUE |
743 | 743 | Fresno | Fresno | 19 | 2021-08-21 | 111315 | 1759 | |
744 | 744 | Glenn | Glenn | 21 | 2021-08-21 | 2502 | 27 | TRUE |
745 | 745 | Humboldt | Humboldt | 23 | 2021-08-21 | 6427 | 61 | TRUE |
746 | 746 | Imperial | Imperial | 25 | 2021-08-21 | 29447 | 749 | TRUE |
747 | 747 | Inyo | Inyo | 27 | 2021-08-21 | 1518 | 39 | TRUE |
748 | 748 | Kern | Kern | 29 | 2021-08-21 | 119708 | 1445 | TRUE |
749 | 749 | Kings | Kings | 31 | 2021-08-21 | 25388 | 258 | |
750 | 750 | Lake | Lake | 33 | 2021-08-21 | 5024 | 69 | |
751 | 751 | Lassen | Lassen | 35 | 2021-08-21 | 6122 | 26 | TRUE |
752 | 752 | Long Beach | Los Angeles | 37 | 2021-08-21 | 59520 | 963 | TRUE |
753 | 753 | Los Angeles | Los Angeles | 37 | 2021-08-21 | 1308407 | 23744 | |
754 | 754 | Pasadena | Los Angeles | 37 | 2021-08-21 | 12488 | 354 | TRUE |
755 | 755 | Madera | Madera | 39 | 2021-08-21 | 17718 | 249 | TRUE |
756 | 756 | Marin | Marin | 41 | 2021-08-21 | 15917 | 215 | |
757 | 757 | Mariposa | Mariposa | 43 | 2021-08-21 | 700 | 10 | TRUE |
758 | 758 | Mendocino | Mendocino | 45 | 2021-08-21 | 5605 | 57 | |
759 | 759 | Merced | Merced | 47 | 2021-08-21 | 35485 | 499 | TRUE |
760 | 760 | Modoc | Modoc | 49 | 2021-08-21 | 593 | 7 | TRUE |
761 | 761 | Mono | Mono | 51 | 2021-08-21 | 1419 | 5 | |
762 | 762 | Monterey | Monterey | 53 | 2021-08-21 | 45753 | 541 | TRUE |
763 | 763 | Napa | Napa | 55 | 2021-08-21 | 11169 | 84 | TRUE |
764 | 764 | Nevada | Nevada | 57 | 2021-08-21 | 6683 | 81 | TRUE |
765 | 765 | Orange | Orange | 59 | 2021-08-21 | 279237 | 5176 | TRUE |
766 | 766 | Placer | Placer | 61 | 2021-08-21 | 28008 | 313 | TRUE |
767 | 767 | Plumas | Plumas | 63 | 2021-08-21 | 902 | 6 | TRUE |
768 | 768 | Riverside | Riverside | 65 | 2021-08-21 | 325944 | 4697 | TRUE |
769 | 769 | Sacramento | Sacramento | 67 | 2021-08-21 | 126643 | 1843 | TRUE |
770 | 770 | San Benito | San Benito | 69 | 2021-08-21 | 6564 | 64 | |
771 | 771 | San Bernardino | San Bernardino | 71 | 2021-08-21 | 322112 | 4893 | TRUE |
772 | 772 | San Diego | San Diego | 73 | 2021-08-21 | 321102 | 3846 | TRUE |
773 | 773 | San Francisco | San Francisco | 75 | 2021-08-21 | 45110 | 577 | |
774 | 774 | San Joaquin | San Joaquin | 77 | 2021-08-21 | 82047 | 1491 | TRUE |
775 | 775 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-21 | 24162 | 274 | TRUE |
776 | 776 | San Mateo | San Mateo | 81 | 2021-08-21 | 47185 | 594 | TRUE |
777 | 777 | Santa Barbara | Santa Barbara | 83 | 2021-08-21 | 37913 | 472 | TRUE |
778 | 778 | Santa Clara | Santa Clara | 85 | 2021-08-21 | 130007 | 1721 | TRUE |
779 | 779 | Santa Cruz | Santa Cruz | 87 | 2021-08-21 | 17663 | 209 | TRUE |
780 | 780 | Shasta | Shasta | 89 | 2021-08-21 | 14322 | 251 | TRUE |
781 | 781 | Sierra | Sierra | 91 | 2021-08-21 | 160 | 0 | TRUE |
782 | 782 | Siskiyou | Siskiyou | 93 | 2021-08-21 | 2944 | 40 | TRUE |
783 | 783 | Solano | Solano | 95 | 2021-08-21 | 38764 | 262 | TRUE |
784 | 784 | Sonoma | Sonoma | 97 | 2021-08-21 | 35558 | 344 | |
785 | 785 | Stanislaus | Stanislaus | 99 | 2021-08-21 | 63719 | 1117 | TRUE |
786 | 786 | Sutter | Sutter | 101 | 2021-08-21 | 11243 | 117 | TRUE |
787 | 787 | Tehama | Tehama | 103 | 2021-08-21 | 6503 | 66 | |
788 | 788 | Trinity | Trinity | 105 | 2021-08-21 | 565 | 8 | TRUE |
789 | 789 | Tulare | Tulare | 107 | 2021-08-21 | 52615 | 855 | TRUE |
790 | 790 | Tuolumne | Tuolumne | 109 | 2021-08-21 | 5303 | 82 | TRUE |
791 | 791 | Ventura | Ventura | 111 | 2021-08-21 | 88279 | 1055 | TRUE |
792 | 792 | Yolo | Yolo | 113 | 2021-08-21 | 16165 | 223 | TRUE |
793 | 793 | Yuba | Yuba | 115 | 2021-08-21 | 7945 | 45 |
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 );