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-09 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29342 | 29342 | Alameda | Alameda | 1 | 2020-05-09 | 1972 | 104 | |
29343 | 29343 | Berkeley | Alameda | 1 | 2020-05-09 | 67 | 1 | |
29344 | 29344 | Alpine | Alpine | 3 | 2020-05-09 | 1 | 0 | TRUE |
29345 | 29345 | Amador | Amador | 5 | 2020-05-09 | 8 | 0 | TRUE |
29346 | 29346 | Butte | Butte | 7 | 2020-05-09 | 18 | 0 | TRUE |
29347 | 29347 | Calaveras | Calaveras | 9 | 2020-05-09 | 13 | 0 | TRUE |
29348 | 29348 | Colusa | Colusa | 11 | 2020-05-09 | 3 | 0 | TRUE |
29349 | 29349 | Contra Costa | Contra Costa | 13 | 2020-05-09 | 1031 | 31 | |
29350 | 29350 | Del Norte | Del Norte | 15 | 2020-05-09 | 3 | 0 | TRUE |
29351 | 29351 | El Dorado | El Dorado | 17 | 2020-05-09 | 54 | 0 | TRUE |
29352 | 29352 | Fresno | Fresno | 19 | 2020-05-09 | 1582 | 9 | |
29353 | 29353 | Glenn | Glenn | 21 | 2020-05-09 | 6 | 0 | TRUE |
29354 | 29354 | Humboldt | Humboldt | 23 | 2020-05-09 | 57 | 0 | |
29355 | 29355 | Imperial | Imperial | 25 | 2020-05-09 | 512 | 12 | TRUE |
29356 | 29356 | Inyo | Inyo | 27 | 2020-05-09 | 19 | 1 | TRUE |
29357 | 29357 | Kern | Kern | 29 | 2020-05-09 | 1228 | 15 | |
29358 | 29358 | Kings | Kings | 31 | 2020-05-09 | 275 | 1 | |
29359 | 29359 | Lake | Lake | 33 | 2020-05-09 | 8 | 0 | TRUE |
29360 | 29360 | Lassen | Lassen | 35 | 2020-05-09 | 0 | 0 | TRUE |
29361 | 29361 | Long Beach | Los Angeles | 37 | 2020-05-09 | 931 | 43 | |
29362 | 29362 | Los Angeles | Los Angeles | 37 | 2020-05-09 | 29768 | 1407 | |
29363 | 29363 | Pasadena | Los Angeles | 37 | 2020-05-09 | 542 | 65 | |
29364 | 29364 | Madera | Madera | 39 | 2020-05-09 | 67 | 2 | |
29365 | 29365 | Marin | Marin | 41 | 2020-05-09 | 259 | 14 | |
29366 | 29366 | Mariposa | Mariposa | 43 | 2020-05-09 | 15 | 0 | TRUE |
29367 | 29367 | Mendocino | Mendocino | 45 | 2020-05-09 | 12 | 0 | TRUE |
29368 | 29368 | Merced | Merced | 47 | 2020-05-09 | 163 | 3 | TRUE |
29369 | 29369 | Modoc | Modoc | 49 | 2020-05-09 | 0 | 0 | TRUE |
29370 | 29370 | Mono | Mono | 51 | 2020-05-09 | 29 | 1 | TRUE |
29371 | 29371 | Monterey | Monterey | 53 | 2020-05-09 | 277 | 6 | |
29372 | 29372 | Napa | Napa | 55 | 2020-05-09 | 79 | 2 | |
29373 | 29373 | Nevada | Nevada | 57 | 2020-05-09 | 41 | 1 | TRUE |
29374 | 29374 | Orange | Orange | 59 | 2020-05-09 | 3380 | 74 | |
29375 | 29375 | Placer | Placer | 61 | 2020-05-09 | 168 | 8 | |
29376 | 29376 | Plumas | Plumas | 63 | 2020-05-09 | 4 | 0 | TRUE |
29377 | 29377 | Riverside | Riverside | 65 | 2020-05-09 | 4992 | 204 | |
29378 | 29378 | Sacramento | Sacramento | 67 | 2020-05-09 | 1165 | 50 | |
29379 | 29379 | San Benito | San Benito | 69 | 2020-05-09 | 55 | 2 | |
29380 | 29380 | San Bernardino | San Bernardino | 71 | 2020-05-09 | 2902 | 143 | |
29381 | 29381 | San Diego | San Diego | 73 | 2020-05-09 | 4776 | 175 | |
29382 | 29382 | San Francisco | San Francisco | 75 | 2020-05-09 | 1891 | 33 | |
29383 | 29383 | San Joaquin | San Joaquin | 77 | 2020-05-09 | 604 | 28 | |
29384 | 29384 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-09 | 214 | 1 | |
29385 | 29385 | San Mateo | San Mateo | 81 | 2020-05-09 | 1425 | 56 | |
29386 | 29386 | Santa Barbara | Santa Barbara | 83 | 2020-05-09 | 1250 | 11 | |
29387 | 29387 | Santa Clara | Santa Clara | 85 | 2020-05-09 | 2371 | 128 | |
29388 | 29388 | Santa Cruz | Santa Cruz | 87 | 2020-05-09 | 141 | 2 | |
29389 | 29389 | Shasta | Shasta | 89 | 2020-05-09 | 31 | 4 | |
29390 | 29390 | Sierra | Sierra | 91 | 2020-05-09 | 0 | 0 | TRUE |
29391 | 29391 | Siskiyou | Siskiyou | 93 | 2020-05-09 | 5 | 0 | |
29392 | 29392 | Solano | Solano | 95 | 2020-05-09 | 351 | 7 | TRUE |
29393 | 29393 | Sonoma | Sonoma | 97 | 2020-05-09 | 309 | 3 | |
29394 | 29394 | Stanislaus | Stanislaus | 99 | 2020-05-09 | 496 | 20 | |
29395 | 29395 | Sutter | Sutter | 101 | 2020-05-09 | 33 | 2 | |
29396 | 29396 | Tehama | Tehama | 103 | 2020-05-09 | 1 | 1 | TRUE |
29397 | 29397 | Trinity | Trinity | 105 | 2020-05-09 | 1 | 0 | |
29398 | 29398 | Tulare | Tulare | 107 | 2020-05-09 | 1079 | 46 | |
29399 | 29399 | Tuolumne | Tuolumne | 109 | 2020-05-09 | 2 | 0 | TRUE |
29400 | 29400 | Ventura | Ventura | 111 | 2020-05-09 | 666 | 19 | |
29401 | 29401 | Yolo | Yolo | 113 | 2020-05-09 | 172 | 20 | |
29402 | 29402 | Yuba | Yuba | 115 | 2020-05-09 | 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 );