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-20 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 |
---|---|---|---|---|---|---|---|---|
794 | 794 | Alameda | Alameda | 1 | 2021-08-20 | 99782 | 1257 | |
795 | 795 | Berkeley | Alameda | 1 | 2021-08-20 | 4300 | 52 | |
796 | 796 | Alpine | Alpine | 3 | 2021-08-20 | 89 | 0 | TRUE |
797 | 797 | Amador | Amador | 5 | 2021-08-20 | 4283 | 50 | |
798 | 798 | Butte | Butte | 7 | 2021-08-20 | 14699 | 205 | |
799 | 799 | Calaveras | Calaveras | 9 | 2021-08-20 | 2636 | 61 | |
800 | 800 | Colusa | Colusa | 11 | 2021-08-20 | 2565 | 18 | TRUE |
801 | 801 | Contra Costa | Contra Costa | 13 | 2021-08-20 | 84082 | 854 | |
802 | 802 | Del Norte | Del Norte | 15 | 2021-08-20 | 2447 | 15 | |
803 | 803 | El Dorado | El Dorado | 17 | 2021-08-20 | 12545 | 122 | |
804 | 804 | Fresno | Fresno | 19 | 2021-08-20 | 110947 | 1759 | |
805 | 805 | Glenn | Glenn | 21 | 2021-08-20 | 2502 | 27 | |
806 | 806 | Humboldt | Humboldt | 23 | 2021-08-20 | 6427 | 61 | |
807 | 807 | Imperial | Imperial | 25 | 2021-08-20 | 29447 | 749 | |
808 | 808 | Inyo | Inyo | 27 | 2021-08-20 | 1518 | 39 | TRUE |
809 | 809 | Kern | Kern | 29 | 2021-08-20 | 119708 | 1445 | |
810 | 810 | Kings | Kings | 31 | 2021-08-20 | 25314 | 258 | |
811 | 811 | Lake | Lake | 33 | 2021-08-20 | 4991 | 69 | |
812 | 812 | Lassen | Lassen | 35 | 2021-08-20 | 6122 | 26 | |
813 | 813 | Long Beach | Los Angeles | 37 | 2021-08-20 | 59520 | 963 | |
814 | 814 | Los Angeles | Los Angeles | 37 | 2021-08-20 | 1304670 | 23716 | |
815 | 815 | Pasadena | Los Angeles | 37 | 2021-08-20 | 12488 | 354 | |
816 | 816 | Madera | Madera | 39 | 2021-08-20 | 17718 | 249 | TRUE |
817 | 817 | Marin | Marin | 41 | 2021-08-20 | 15864 | 215 | |
818 | 818 | Mariposa | Mariposa | 43 | 2021-08-20 | 700 | 10 | |
819 | 819 | Mendocino | Mendocino | 45 | 2021-08-20 | 5554 | 56 | TRUE |
820 | 820 | Merced | Merced | 47 | 2021-08-20 | 35485 | 499 | |
821 | 821 | Modoc | Modoc | 49 | 2021-08-20 | 593 | 7 | TRUE |
822 | 822 | Mono | Mono | 51 | 2021-08-20 | 1413 | 5 | |
823 | 823 | Monterey | Monterey | 53 | 2021-08-20 | 45753 | 541 | |
824 | 824 | Napa | Napa | 55 | 2021-08-20 | 11169 | 84 | |
825 | 825 | Nevada | Nevada | 57 | 2021-08-20 | 6683 | 81 | |
826 | 826 | Orange | Orange | 59 | 2021-08-20 | 279237 | 5176 | |
827 | 827 | Placer | Placer | 61 | 2021-08-20 | 28008 | 313 | TRUE |
828 | 828 | Plumas | Plumas | 63 | 2021-08-20 | 902 | 6 | TRUE |
829 | 829 | Riverside | Riverside | 65 | 2021-08-20 | 325944 | 4697 | |
830 | 830 | Sacramento | Sacramento | 67 | 2021-08-20 | 126643 | 1843 | |
831 | 831 | San Benito | San Benito | 69 | 2021-08-20 | 6523 | 64 | TRUE |
832 | 832 | San Bernardino | San Bernardino | 71 | 2021-08-20 | 322112 | 4893 | |
833 | 833 | San Diego | San Diego | 73 | 2021-08-20 | 321102 | 3846 | |
834 | 834 | San Francisco | San Francisco | 75 | 2021-08-20 | 44868 | 575 | |
835 | 835 | San Joaquin | San Joaquin | 77 | 2021-08-20 | 82047 | 1491 | |
836 | 836 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-20 | 24162 | 274 | |
837 | 837 | San Mateo | San Mateo | 81 | 2021-08-20 | 47185 | 594 | |
838 | 838 | Santa Barbara | Santa Barbara | 83 | 2021-08-20 | 37913 | 472 | |
839 | 839 | Santa Clara | Santa Clara | 85 | 2021-08-20 | 130007 | 1721 | |
840 | 840 | Santa Cruz | Santa Cruz | 87 | 2021-08-20 | 17663 | 209 | |
841 | 841 | Shasta | Shasta | 89 | 2021-08-20 | 14322 | 251 | |
842 | 842 | Sierra | Sierra | 91 | 2021-08-20 | 160 | 0 | |
843 | 843 | Siskiyou | Siskiyou | 93 | 2021-08-20 | 2944 | 40 | |
844 | 844 | Solano | Solano | 95 | 2021-08-20 | 38764 | 262 | |
845 | 845 | Sonoma | Sonoma | 97 | 2021-08-20 | 35210 | 344 | |
846 | 846 | Stanislaus | Stanislaus | 99 | 2021-08-20 | 63719 | 1117 | |
847 | 847 | Sutter | Sutter | 101 | 2021-08-20 | 11243 | 117 | |
848 | 848 | Tehama | Tehama | 103 | 2021-08-20 | 6458 | 66 | |
849 | 849 | Trinity | Trinity | 105 | 2021-08-20 | 565 | 8 | |
850 | 850 | Tulare | Tulare | 107 | 2021-08-20 | 52615 | 855 | |
851 | 851 | Tuolumne | Tuolumne | 109 | 2021-08-20 | 5303 | 82 | |
852 | 852 | Ventura | Ventura | 111 | 2021-08-20 | 88279 | 1055 | |
853 | 853 | Yolo | Yolo | 113 | 2021-08-20 | 16165 | 223 | |
854 | 854 | Yuba | Yuba | 115 | 2021-08-20 | 7860 | 44 |
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 );