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-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29281 | 29281 | Alameda | Alameda | 1 | 2020-05-10 | 2005 | 105 | |
29282 | 29282 | Berkeley | Alameda | 1 | 2020-05-10 | 67 | 1 | TRUE |
29283 | 29283 | Alpine | Alpine | 3 | 2020-05-10 | 1 | 0 | TRUE |
29284 | 29284 | Amador | Amador | 5 | 2020-05-10 | 8 | 0 | |
29285 | 29285 | Butte | Butte | 7 | 2020-05-10 | 18 | 0 | TRUE |
29286 | 29286 | Calaveras | Calaveras | 9 | 2020-05-10 | 13 | 0 | TRUE |
29287 | 29287 | Colusa | Colusa | 11 | 2020-05-10 | 3 | 0 | TRUE |
29288 | 29288 | Contra Costa | Contra Costa | 13 | 2020-05-10 | 1042 | 31 | |
29289 | 29289 | Del Norte | Del Norte | 15 | 2020-05-10 | 3 | 0 | TRUE |
29290 | 29290 | El Dorado | El Dorado | 17 | 2020-05-10 | 54 | 0 | TRUE |
29291 | 29291 | Fresno | Fresno | 19 | 2020-05-10 | 1618 | 9 | TRUE |
29292 | 29292 | Glenn | Glenn | 21 | 2020-05-10 | 6 | 0 | TRUE |
29293 | 29293 | Humboldt | Humboldt | 23 | 2020-05-10 | 57 | 0 | TRUE |
29294 | 29294 | Imperial | Imperial | 25 | 2020-05-10 | 512 | 12 | TRUE |
29295 | 29295 | Inyo | Inyo | 27 | 2020-05-10 | 19 | 1 | TRUE |
29296 | 29296 | Kern | Kern | 29 | 2020-05-10 | 1254 | 15 | |
29297 | 29297 | Kings | Kings | 31 | 2020-05-10 | 287 | 1 | |
29298 | 29298 | Lake | Lake | 33 | 2020-05-10 | 8 | 0 | TRUE |
29299 | 29299 | Lassen | Lassen | 35 | 2020-05-10 | 0 | 0 | TRUE |
29300 | 29300 | Long Beach | Los Angeles | 37 | 2020-05-10 | 948 | 44 | |
29301 | 29301 | Los Angeles | Los Angeles | 37 | 2020-05-10 | 30204 | 1422 | |
29302 | 29302 | Pasadena | Los Angeles | 37 | 2020-05-10 | 551 | 65 | |
29303 | 29303 | Madera | Madera | 39 | 2020-05-10 | 67 | 2 | |
29304 | 29304 | Marin | Marin | 41 | 2020-05-10 | 261 | 14 | |
29305 | 29305 | Mariposa | Mariposa | 43 | 2020-05-10 | 15 | 0 | TRUE |
29306 | 29306 | Mendocino | Mendocino | 45 | 2020-05-10 | 12 | 0 | TRUE |
29307 | 29307 | Merced | Merced | 47 | 2020-05-10 | 163 | 3 | TRUE |
29308 | 29308 | Modoc | Modoc | 49 | 2020-05-10 | 0 | 0 | TRUE |
29309 | 29309 | Mono | Mono | 51 | 2020-05-10 | 29 | 1 | TRUE |
29310 | 29310 | Monterey | Monterey | 53 | 2020-05-10 | 279 | 6 | |
29311 | 29311 | Napa | Napa | 55 | 2020-05-10 | 79 | 2 | TRUE |
29312 | 29312 | Nevada | Nevada | 57 | 2020-05-10 | 41 | 1 | TRUE |
29313 | 29313 | Orange | Orange | 59 | 2020-05-10 | 3502 | 76 | |
29314 | 29314 | Placer | Placer | 61 | 2020-05-10 | 169 | 8 | |
29315 | 29315 | Plumas | Plumas | 63 | 2020-05-10 | 4 | 0 | TRUE |
29316 | 29316 | Riverside | Riverside | 65 | 2020-05-10 | 5039 | 205 | |
29317 | 29317 | Sacramento | Sacramento | 67 | 2020-05-10 | 1167 | 50 | |
29318 | 29318 | San Benito | San Benito | 69 | 2020-05-10 | 55 | 2 | |
29319 | 29319 | San Bernardino | San Bernardino | 71 | 2020-05-10 | 2964 | 147 | |
29320 | 29320 | San Diego | San Diego | 73 | 2020-05-10 | 4926 | 175 | |
29321 | 29321 | San Francisco | San Francisco | 75 | 2020-05-10 | 1943 | 34 | |
29322 | 29322 | San Joaquin | San Joaquin | 77 | 2020-05-10 | 613 | 29 | |
29323 | 29323 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-10 | 220 | 1 | |
29324 | 29324 | San Mateo | San Mateo | 81 | 2020-05-10 | 1425 | 56 | TRUE |
29325 | 29325 | Santa Barbara | Santa Barbara | 83 | 2020-05-10 | 1308 | 11 | |
29326 | 29326 | Santa Clara | Santa Clara | 85 | 2020-05-10 | 2374 | 130 | |
29327 | 29327 | Santa Cruz | Santa Cruz | 87 | 2020-05-10 | 141 | 2 | |
29328 | 29328 | Shasta | Shasta | 89 | 2020-05-10 | 31 | 4 | |
29329 | 29329 | Sierra | Sierra | 91 | 2020-05-10 | 0 | 0 | TRUE |
29330 | 29330 | Siskiyou | Siskiyou | 93 | 2020-05-10 | 5 | 0 | |
29331 | 29331 | Solano | Solano | 95 | 2020-05-10 | 351 | 7 | TRUE |
29332 | 29332 | Sonoma | Sonoma | 97 | 2020-05-10 | 309 | 3 | |
29333 | 29333 | Stanislaus | Stanislaus | 99 | 2020-05-10 | 501 | 21 | |
29334 | 29334 | Sutter | Sutter | 101 | 2020-05-10 | 33 | 2 | |
29335 | 29335 | Tehama | Tehama | 103 | 2020-05-10 | 1 | 1 | TRUE |
29336 | 29336 | Trinity | Trinity | 105 | 2020-05-10 | 1 | 0 | TRUE |
29337 | 29337 | Tulare | Tulare | 107 | 2020-05-10 | 1140 | 48 | |
29338 | 29338 | Tuolumne | Tuolumne | 109 | 2020-05-10 | 2 | 0 | TRUE |
29339 | 29339 | Ventura | Ventura | 111 | 2020-05-10 | 666 | 19 | TRUE |
29340 | 29340 | Yolo | Yolo | 113 | 2020-05-10 | 173 | 20 | |
29341 | 29341 | Yuba | Yuba | 115 | 2020-05-10 | 20 | 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 );