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-19 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 |
---|---|---|---|---|---|---|---|---|
25011 | 25011 | Alameda | Alameda | 1 | 2020-07-19 | 8994 | 213 | |
25012 | 25012 | Berkeley | Alameda | 1 | 2020-07-19 | 321 | 5 | |
25013 | 25013 | Alpine | Alpine | 3 | 2020-07-19 | 2 | 0 | TRUE |
25014 | 25014 | Amador | Amador | 5 | 2020-07-19 | 54 | 0 | |
25015 | 25015 | Butte | Butte | 7 | 2020-07-19 | 555 | 4 | TRUE |
25016 | 25016 | Calaveras | Calaveras | 9 | 2020-07-19 | 87 | 0 | TRUE |
25017 | 25017 | Colusa | Colusa | 11 | 2020-07-19 | 173 | 0 | TRUE |
25018 | 25018 | Contra Costa | Contra Costa | 13 | 2020-07-19 | 5681 | 98 | |
25019 | 25019 | Del Norte | Del Norte | 15 | 2020-07-19 | 66 | 0 | TRUE |
25020 | 25020 | El Dorado | El Dorado | 17 | 2020-07-19 | 394 | 1 | TRUE |
25021 | 25021 | Fresno | Fresno | 19 | 2020-07-19 | 17463 | 100 | TRUE |
25022 | 25022 | Glenn | Glenn | 21 | 2020-07-19 | 214 | 1 | TRUE |
25023 | 25023 | Humboldt | Humboldt | 23 | 2020-07-19 | 181 | 4 | TRUE |
25024 | 25024 | Imperial | Imperial | 25 | 2020-07-19 | 8531 | 161 | TRUE |
25025 | 25025 | Inyo | Inyo | 27 | 2020-07-19 | 37 | 1 | TRUE |
25026 | 25026 | Kern | Kern | 29 | 2020-07-19 | 8447 | 105 | |
25027 | 25027 | Kings | Kings | 31 | 2020-07-19 | 3280 | 41 | |
25028 | 25028 | Lake | Lake | 33 | 2020-07-19 | 140 | 1 | TRUE |
25029 | 25029 | Lassen | Lassen | 35 | 2020-07-19 | 508 | 0 | |
25030 | 25030 | Long Beach | Los Angeles | 37 | 2020-07-19 | 6445 | 158 | |
25031 | 25031 | Los Angeles | Los Angeles | 37 | 2020-07-19 | 147772 | 3836 | |
25032 | 25032 | Pasadena | Los Angeles | 37 | 2020-07-19 | 1700 | 102 | |
25033 | 25033 | Madera | Madera | 39 | 2020-07-19 | 1368 | 11 | TRUE |
25034 | 25034 | Marin | Marin | 41 | 2020-07-19 | 4314 | 42 | |
25035 | 25035 | Mariposa | Mariposa | 43 | 2020-07-19 | 37 | 1 | |
25036 | 25036 | Mendocino | Mendocino | 45 | 2020-07-19 | 199 | 3 | |
25037 | 25037 | Merced | Merced | 47 | 2020-07-19 | 2403 | 15 | TRUE |
25038 | 25038 | Modoc | Modoc | 49 | 2020-07-19 | 0 | 0 | TRUE |
25039 | 25039 | Mono | Mono | 51 | 2020-07-19 | 79 | 1 | |
25040 | 25040 | Monterey | Monterey | 53 | 2020-07-19 | 3228 | 18 | |
25041 | 25041 | Napa | Napa | 55 | 2020-07-19 | 583 | 5 | TRUE |
25042 | 25042 | Nevada | Nevada | 57 | 2020-07-19 | 204 | 1 | TRUE |
25043 | 25043 | Orange | Orange | 59 | 2020-07-19 | 29426 | 492 | |
25044 | 25044 | Placer | Placer | 61 | 2020-07-19 | 1363 | 11 | |
25045 | 25045 | Plumas | Plumas | 63 | 2020-07-19 | 23 | 0 | TRUE |
25046 | 25046 | Riverside | Riverside | 65 | 2020-07-19 | 28695 | 587 | TRUE |
25047 | 25047 | Sacramento | Sacramento | 67 | 2020-07-19 | 6935 | 96 | |
25048 | 25048 | San Benito | San Benito | 69 | 2020-07-19 | 448 | 2 | |
25049 | 25049 | San Bernardino | San Bernardino | 71 | 2020-07-19 | 23772 | 520 | |
25050 | 25050 | San Diego | San Diego | 73 | 2020-07-19 | 23682 | 478 | |
25051 | 25051 | San Francisco | San Francisco | 75 | 2020-07-19 | 5202 | 52 | |
25052 | 25052 | San Joaquin | San Joaquin | 77 | 2020-07-19 | 7819 | 83 | TRUE |
25053 | 25053 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-19 | 1213 | 6 | TRUE |
25054 | 25054 | San Mateo | San Mateo | 81 | 2020-07-19 | 4465 | 114 | TRUE |
25055 | 25055 | Santa Barbara | Santa Barbara | 83 | 2020-07-19 | 4759 | 32 | TRUE |
25056 | 25056 | Santa Clara | Santa Clara | 85 | 2020-07-19 | 9198 | 181 | |
25057 | 25057 | Santa Cruz | Santa Cruz | 87 | 2020-07-19 | 772 | 3 | TRUE |
25058 | 25058 | Shasta | Shasta | 89 | 2020-07-19 | 242 | 7 | |
25059 | 25059 | Sierra | Sierra | 91 | 2020-07-19 | 1 | 0 | TRUE |
25060 | 25060 | Siskiyou | Siskiyou | 93 | 2020-07-19 | 44 | 0 | TRUE |
25061 | 25061 | Solano | Solano | 95 | 2020-07-19 | 2554 | 31 | TRUE |
25062 | 25062 | Sonoma | Sonoma | 97 | 2020-07-19 | 2169 | 20 | |
25063 | 25063 | Stanislaus | Stanislaus | 99 | 2020-07-19 | 6344 | 63 | |
25064 | 25064 | Sutter | Sutter | 101 | 2020-07-19 | 520 | 4 | |
25065 | 25065 | Tehama | Tehama | 103 | 2020-07-19 | 134 | 1 | TRUE |
25066 | 25066 | Trinity | Trinity | 105 | 2020-07-19 | 2 | 0 | TRUE |
25067 | 25067 | Tulare | Tulare | 107 | 2020-07-19 | 6683 | 165 | TRUE |
25068 | 25068 | Tuolumne | Tuolumne | 109 | 2020-07-19 | 85 | 0 | TRUE |
25069 | 25069 | Ventura | Ventura | 111 | 2020-07-19 | 5192 | 57 | TRUE |
25070 | 25070 | Yolo | Yolo | 113 | 2020-07-19 | 1162 | 32 | |
25071 | 25071 | Yuba | Yuba | 115 | 2020-07-19 | 270 | 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 );