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 2020-07-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
24889 | 24889 | Alameda | Alameda | 1 | 2020-07-21 | 9474 | 221 | |
24890 | 24890 | Berkeley | Alameda | 1 | 2020-07-21 | 337 | 6 | |
24891 | 24891 | Alpine | Alpine | 3 | 2020-07-21 | 2 | 0 | |
24892 | 24892 | Amador | Amador | 5 | 2020-07-21 | 62 | 0 | |
24893 | 24893 | Butte | Butte | 7 | 2020-07-21 | 659 | 5 | |
24894 | 24894 | Calaveras | Calaveras | 9 | 2020-07-21 | 94 | 1 | |
24895 | 24895 | Colusa | Colusa | 11 | 2020-07-21 | 234 | 1 | |
24896 | 24896 | Contra Costa | Contra Costa | 13 | 2020-07-21 | 6188 | 102 | |
24897 | 24897 | Del Norte | Del Norte | 15 | 2020-07-21 | 68 | 0 | |
24898 | 24898 | El Dorado | El Dorado | 17 | 2020-07-21 | 464 | 1 | |
24899 | 24899 | Fresno | Fresno | 19 | 2020-07-21 | 18426 | 104 | |
24900 | 24900 | Glenn | Glenn | 21 | 2020-07-21 | 237 | 1 | |
24901 | 24901 | Humboldt | Humboldt | 23 | 2020-07-21 | 195 | 4 | |
24902 | 24902 | Imperial | Imperial | 25 | 2020-07-21 | 8606 | 163 | TRUE |
24903 | 24903 | Inyo | Inyo | 27 | 2020-07-21 | 40 | 1 | TRUE |
24904 | 24904 | Kern | Kern | 29 | 2020-07-21 | 10068 | 105 | |
24905 | 24905 | Kings | Kings | 31 | 2020-07-21 | 3465 | 42 | |
24906 | 24906 | Lake | Lake | 33 | 2020-07-21 | 156 | 1 | |
24907 | 24907 | Lassen | Lassen | 35 | 2020-07-21 | 515 | 0 | |
24908 | 24908 | Long Beach | Los Angeles | 37 | 2020-07-21 | 6843 | 160 | |
24909 | 24909 | Los Angeles | Los Angeles | 37 | 2020-07-21 | 153424 | 3893 | |
24910 | 24910 | Pasadena | Los Angeles | 37 | 2020-07-21 | 1758 | 102 | |
24911 | 24911 | Madera | Madera | 39 | 2020-07-21 | 1439 | 13 | |
24912 | 24912 | Marin | Marin | 41 | 2020-07-21 | 4427 | 47 | |
24913 | 24913 | Mariposa | Mariposa | 43 | 2020-07-21 | 41 | 1 | |
24914 | 24914 | Mendocino | Mendocino | 45 | 2020-07-21 | 217 | 3 | |
24915 | 24915 | Merced | Merced | 47 | 2020-07-21 | 2813 | 22 | |
24916 | 24916 | Modoc | Modoc | 49 | 2020-07-21 | 0 | 0 | TRUE |
24917 | 24917 | Mono | Mono | 51 | 2020-07-21 | 84 | 1 | |
24918 | 24918 | Monterey | Monterey | 53 | 2020-07-21 | 3379 | 21 | |
24919 | 24919 | Napa | Napa | 55 | 2020-07-21 | 661 | 7 | |
24920 | 24920 | Nevada | Nevada | 57 | 2020-07-21 | 231 | 1 | |
24921 | 24921 | Orange | Orange | 59 | 2020-07-21 | 30976 | 513 | |
24922 | 24922 | Placer | Placer | 61 | 2020-07-21 | 1442 | 12 | |
24923 | 24923 | Plumas | Plumas | 63 | 2020-07-21 | 25 | 0 | |
24924 | 24924 | Riverside | Riverside | 65 | 2020-07-21 | 30890 | 589 | |
24925 | 24925 | Sacramento | Sacramento | 67 | 2020-07-21 | 7686 | 96 | |
24926 | 24926 | San Benito | San Benito | 69 | 2020-07-21 | 486 | 2 | |
24927 | 24927 | San Bernardino | San Bernardino | 71 | 2020-07-21 | 25067 | 554 | |
24928 | 24928 | San Diego | San Diego | 73 | 2020-07-21 | 24520 | 487 | |
24929 | 24929 | San Francisco | San Francisco | 75 | 2020-07-21 | 5363 | 53 | |
24930 | 24930 | San Joaquin | San Joaquin | 77 | 2020-07-21 | 8799 | 95 | |
24931 | 24931 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-21 | 1369 | 7 | |
24932 | 24932 | San Mateo | San Mateo | 81 | 2020-07-21 | 4674 | 114 | |
24933 | 24933 | Santa Barbara | Santa Barbara | 83 | 2020-07-21 | 5124 | 32 | |
24934 | 24934 | Santa Clara | Santa Clara | 85 | 2020-07-21 | 9726 | 183 | |
24935 | 24935 | Santa Cruz | Santa Cruz | 87 | 2020-07-21 | 830 | 3 | |
24936 | 24936 | Shasta | Shasta | 89 | 2020-07-21 | 255 | 7 | |
24937 | 24937 | Sierra | Sierra | 91 | 2020-07-21 | 1 | 0 | |
24938 | 24938 | Siskiyou | Siskiyou | 93 | 2020-07-21 | 53 | 0 | |
24939 | 24939 | Solano | Solano | 95 | 2020-07-21 | 2857 | 35 | |
24940 | 24940 | Sonoma | Sonoma | 97 | 2020-07-21 | 2241 | 22 | |
24941 | 24941 | Stanislaus | Stanislaus | 99 | 2020-07-21 | 6835 | 73 | |
24942 | 24942 | Sutter | Sutter | 101 | 2020-07-21 | 553 | 4 | |
24943 | 24943 | Tehama | Tehama | 103 | 2020-07-21 | 151 | 1 | TRUE |
24944 | 24944 | Trinity | Trinity | 105 | 2020-07-21 | 3 | 0 | |
24945 | 24945 | Tulare | Tulare | 107 | 2020-07-21 | 7120 | 168 | |
24946 | 24946 | Tuolumne | Tuolumne | 109 | 2020-07-21 | 104 | 0 | |
24947 | 24947 | Ventura | Ventura | 111 | 2020-07-21 | 5955 | 62 | |
24948 | 24948 | Yolo | Yolo | 113 | 2020-07-21 | 1200 | 34 | |
24949 | 24949 | Yuba | Yuba | 115 | 2020-07-21 | 309 | 3 |
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 );