latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
56 rows where "date" is on date 2020-04-22 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 |
---|---|---|---|---|---|---|---|---|
30350 | 30350 | Alameda | Alameda | 1 | 2020-04-22 | 1293 | 83 | |
30351 | 30351 | Berkeley | Alameda | 1 | 2020-04-22 | 47 | 1 | |
30352 | 30352 | Alpine | Alpine | 3 | 2020-04-22 | 1 | 0 | TRUE |
30353 | 30353 | Amador | Amador | 5 | 2020-04-22 | 8 | 0 | |
30354 | 30354 | Butte | Butte | 7 | 2020-04-22 | 15 | 0 | |
30355 | 30355 | Calaveras | Calaveras | 9 | 2020-04-22 | 12 | 0 | TRUE |
30356 | 30356 | Colusa | Colusa | 11 | 2020-04-22 | 3 | 0 | |
30357 | 30357 | Contra Costa | Contra Costa | 13 | 2020-04-22 | 775 | 22 | |
30358 | 30358 | Del Norte | Del Norte | 15 | 2020-04-22 | 2 | 0 | |
30359 | 30359 | El Dorado | El Dorado | 17 | 2020-04-22 | 39 | 0 | |
30360 | 30360 | Fresno | Fresno | 19 | 2020-04-22 | 683 | 7 | |
30361 | 30361 | Glenn | Glenn | 21 | 2020-04-22 | 4 | 0 | |
30362 | 30362 | Humboldt | Humboldt | 23 | 2020-04-22 | 52 | 0 | |
30363 | 30363 | Imperial | Imperial | 25 | 2020-04-22 | 214 | 6 | |
30364 | 30364 | Inyo | Inyo | 27 | 2020-04-22 | 19 | 0 | |
30365 | 30365 | Kern | Kern | 29 | 2020-04-22 | 683 | 4 | |
30366 | 30366 | Kings | Kings | 31 | 2020-04-22 | 32 | 1 | |
30367 | 30367 | Lake | Lake | 33 | 2020-04-22 | 6 | 0 | |
30368 | 30368 | Long Beach | Los Angeles | 37 | 2020-04-22 | 489 | 27 | |
30369 | 30369 | Los Angeles | Los Angeles | 37 | 2020-04-22 | 15697 | 677 | |
30370 | 30370 | Pasadena | Los Angeles | 37 | 2020-04-22 | 263 | 28 | |
30371 | 30371 | Madera | Madera | 39 | 2020-04-22 | 36 | 2 | |
30372 | 30372 | Marin | Marin | 41 | 2020-04-22 | 203 | 11 | |
30373 | 30373 | Mendocino | Mendocino | 45 | 2020-04-22 | 5 | 0 | |
30374 | 30374 | Merced | Merced | 47 | 2020-04-22 | 94 | 3 | |
30375 | 30375 | Mono | Mono | 51 | 2020-04-22 | 24 | 1 | |
30376 | 30376 | Monterey | Monterey | 53 | 2020-04-22 | 154 | 4 | |
30377 | 30377 | Napa | Napa | 55 | 2020-04-22 | 57 | 2 | |
30378 | 30378 | Nevada | Nevada | 57 | 2020-04-22 | 38 | 1 | |
30379 | 30379 | Orange | Orange | 59 | 2020-04-22 | 1736 | 34 | |
30380 | 30380 | Placer | Placer | 61 | 2020-04-22 | 133 | 8 | |
30381 | 30381 | Plumas | Plumas | 63 | 2020-04-22 | 4 | 0 | |
30382 | 30382 | Riverside | Riverside | 65 | 2020-04-22 | 3084 | 99 | |
30383 | 30383 | Sacramento | Sacramento | 67 | 2020-04-22 | 971 | 36 | |
30384 | 30384 | San Benito | San Benito | 69 | 2020-04-22 | 46 | 2 | |
30385 | 30385 | San Bernardino | San Bernardino | 71 | 2020-04-22 | 1578 | 83 | |
30386 | 30386 | San Diego | San Diego | 73 | 2020-04-22 | 2491 | 96 | |
30387 | 30387 | San Francisco | San Francisco | 75 | 2020-04-22 | 1233 | 21 | |
30388 | 30388 | San Joaquin | San Joaquin | 77 | 2020-04-22 | 455 | 20 | |
30389 | 30389 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-22 | 142 | 1 | |
30390 | 30390 | San Mateo | San Mateo | 81 | 2020-04-22 | 958 | 39 | |
30391 | 30391 | Santa Barbara | Santa Barbara | 83 | 2020-04-22 | 440 | 5 | |
30392 | 30392 | Santa Clara | Santa Clara | 85 | 2020-04-22 | 2063 | 99 | |
30393 | 30393 | Santa Cruz | Santa Cruz | 87 | 2020-04-22 | 111 | 2 | |
30394 | 30394 | Shasta | Shasta | 89 | 2020-04-22 | 27 | 3 | |
30395 | 30395 | Siskiyou | Siskiyou | 93 | 2020-04-22 | 5 | 0 | |
30396 | 30396 | Solano | Solano | 95 | 2020-04-22 | 186 | 3 | |
30397 | 30397 | Sonoma | Sonoma | 97 | 2020-04-22 | 194 | 2 | |
30398 | 30398 | Stanislaus | Stanislaus | 99 | 2020-04-22 | 251 | 5 | |
30399 | 30399 | Sutter | Sutter | 101 | 2020-04-22 | 26 | 2 | |
30400 | 30400 | Tehama | Tehama | 103 | 2020-04-22 | 1 | 1 | |
30401 | 30401 | Tulare | Tulare | 107 | 2020-04-22 | 441 | 25 | |
30402 | 30402 | Tuolumne | Tuolumne | 109 | 2020-04-22 | 2 | 0 | |
30403 | 30403 | Ventura | Ventura | 111 | 2020-04-22 | 451 | 14 | |
30404 | 30404 | Yolo | Yolo | 113 | 2020-04-22 | 151 | 12 | |
30405 | 30405 | Yuba | Yuba | 115 | 2020-04-22 | 16 | 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 );