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-05-11 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 |
---|---|---|---|---|---|---|---|---|
29220 | 29220 | Alameda | Alameda | 1 | 2020-05-11 | 2039 | 108 | |
29221 | 29221 | Berkeley | Alameda | 1 | 2020-05-11 | 67 | 1 | |
29222 | 29222 | Alpine | Alpine | 3 | 2020-05-11 | 1 | 0 | TRUE |
29223 | 29223 | Amador | Amador | 5 | 2020-05-11 | 8 | 0 | TRUE |
29224 | 29224 | Butte | Butte | 7 | 2020-05-11 | 19 | 0 | |
29225 | 29225 | Calaveras | Calaveras | 9 | 2020-05-11 | 13 | 0 | TRUE |
29226 | 29226 | Colusa | Colusa | 11 | 2020-05-11 | 3 | 0 | |
29227 | 29227 | Contra Costa | Contra Costa | 13 | 2020-05-11 | 1045 | 32 | |
29228 | 29228 | Del Norte | Del Norte | 15 | 2020-05-11 | 3 | 0 | |
29229 | 29229 | El Dorado | El Dorado | 17 | 2020-05-11 | 56 | 0 | |
29230 | 29230 | Fresno | Fresno | 19 | 2020-05-11 | 1693 | 9 | |
29231 | 29231 | Glenn | Glenn | 21 | 2020-05-11 | 6 | 0 | |
29232 | 29232 | Humboldt | Humboldt | 23 | 2020-05-11 | 61 | 0 | |
29233 | 29233 | Imperial | Imperial | 25 | 2020-05-11 | 564 | 12 | |
29234 | 29234 | Inyo | Inyo | 27 | 2020-05-11 | 19 | 1 | |
29235 | 29235 | Kern | Kern | 29 | 2020-05-11 | 1286 | 15 | |
29236 | 29236 | Kings | Kings | 31 | 2020-05-11 | 319 | 1 | |
29237 | 29237 | Lake | Lake | 33 | 2020-05-11 | 8 | 0 | |
29238 | 29238 | Lassen | Lassen | 35 | 2020-05-11 | 0 | 0 | TRUE |
29239 | 29239 | Long Beach | Los Angeles | 37 | 2020-05-11 | 953 | 45 | |
29240 | 29240 | Los Angeles | Los Angeles | 37 | 2020-05-11 | 30759 | 1460 | |
29241 | 29241 | Pasadena | Los Angeles | 37 | 2020-05-11 | 557 | 65 | |
29242 | 29242 | Madera | Madera | 39 | 2020-05-11 | 67 | 2 | |
29243 | 29243 | Marin | Marin | 41 | 2020-05-11 | 265 | 14 | |
29244 | 29244 | Mariposa | Mariposa | 43 | 2020-05-11 | 15 | 0 | |
29245 | 29245 | Mendocino | Mendocino | 45 | 2020-05-11 | 12 | 0 | |
29246 | 29246 | Merced | Merced | 47 | 2020-05-11 | 173 | 3 | |
29247 | 29247 | Modoc | Modoc | 49 | 2020-05-11 | 0 | 0 | TRUE |
29248 | 29248 | Mono | Mono | 51 | 2020-05-11 | 32 | 1 | |
29249 | 29249 | Monterey | Monterey | 53 | 2020-05-11 | 288 | 6 | |
29250 | 29250 | Napa | Napa | 55 | 2020-05-11 | 79 | 3 | |
29251 | 29251 | Nevada | Nevada | 57 | 2020-05-11 | 41 | 1 | |
29252 | 29252 | Orange | Orange | 59 | 2020-05-11 | 3557 | 76 | |
29253 | 29253 | Placer | Placer | 61 | 2020-05-11 | 170 | 8 | |
29254 | 29254 | Plumas | Plumas | 63 | 2020-05-11 | 4 | 0 | |
29255 | 29255 | Riverside | Riverside | 65 | 2020-05-11 | 5189 | 217 | |
29256 | 29256 | Sacramento | Sacramento | 67 | 2020-05-11 | 1173 | 50 | |
29257 | 29257 | San Benito | San Benito | 69 | 2020-05-11 | 56 | 2 | |
29258 | 29258 | San Bernardino | San Bernardino | 71 | 2020-05-11 | 3015 | 152 | |
29259 | 29259 | San Diego | San Diego | 73 | 2020-05-11 | 5065 | 175 | |
29260 | 29260 | San Francisco | San Francisco | 75 | 2020-05-11 | 1954 | 35 | |
29261 | 29261 | San Joaquin | San Joaquin | 77 | 2020-05-11 | 620 | 29 | |
29262 | 29262 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-11 | 226 | 1 | |
29263 | 29263 | San Mateo | San Mateo | 81 | 2020-05-11 | 1464 | 56 | |
29264 | 29264 | Santa Barbara | Santa Barbara | 83 | 2020-05-11 | 1362 | 11 | |
29265 | 29265 | Santa Clara | Santa Clara | 85 | 2020-05-11 | 2394 | 130 | |
29266 | 29266 | Santa Cruz | Santa Cruz | 87 | 2020-05-11 | 141 | 2 | |
29267 | 29267 | Shasta | Shasta | 89 | 2020-05-11 | 32 | 4 | |
29268 | 29268 | Sierra | Sierra | 91 | 2020-05-11 | 0 | 0 | TRUE |
29269 | 29269 | Siskiyou | Siskiyou | 93 | 2020-05-11 | 5 | 0 | |
29270 | 29270 | Solano | Solano | 95 | 2020-05-11 | 379 | 10 | |
29271 | 29271 | Sonoma | Sonoma | 97 | 2020-05-11 | 312 | 4 | |
29272 | 29272 | Stanislaus | Stanislaus | 99 | 2020-05-11 | 508 | 21 | |
29273 | 29273 | Sutter | Sutter | 101 | 2020-05-11 | 34 | 2 | |
29274 | 29274 | Tehama | Tehama | 103 | 2020-05-11 | 1 | 1 | |
29275 | 29275 | Trinity | Trinity | 105 | 2020-05-11 | 1 | 0 | |
29276 | 29276 | Tulare | Tulare | 107 | 2020-05-11 | 1159 | 50 | |
29277 | 29277 | Tuolumne | Tuolumne | 109 | 2020-05-11 | 2 | 0 | |
29278 | 29278 | Ventura | Ventura | 111 | 2020-05-11 | 678 | 19 | |
29279 | 29279 | Yolo | Yolo | 113 | 2020-05-11 | 174 | 20 | |
29280 | 29280 | Yuba | Yuba | 115 | 2020-05-11 | 21 | 1 |
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 );