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-25 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 |
---|---|---|---|---|---|---|---|---|
28366 | 28366 | Alameda | Alameda | 1 | 2020-05-25 | 2843 | 120 | |
28367 | 28367 | Berkeley | Alameda | 1 | 2020-05-25 | 88 | 2 | |
28368 | 28368 | Alpine | Alpine | 3 | 2020-05-25 | 1 | 0 | TRUE |
28369 | 28369 | Amador | Amador | 5 | 2020-05-25 | 10 | 0 | TRUE |
28370 | 28370 | Butte | Butte | 7 | 2020-05-25 | 37 | 0 | TRUE |
28371 | 28371 | Calaveras | Calaveras | 9 | 2020-05-25 | 13 | 0 | TRUE |
28372 | 28372 | Colusa | Colusa | 11 | 2020-05-25 | 5 | 0 | TRUE |
28373 | 28373 | Contra Costa | Contra Costa | 13 | 2020-05-25 | 1325 | 37 | |
28374 | 28374 | Del Norte | Del Norte | 15 | 2020-05-25 | 37 | 0 | |
28375 | 28375 | El Dorado | El Dorado | 17 | 2020-05-25 | 78 | 0 | |
28376 | 28376 | Fresno | Fresno | 19 | 2020-05-25 | 2675 | 22 | TRUE |
28377 | 28377 | Glenn | Glenn | 21 | 2020-05-25 | 12 | 0 | TRUE |
28378 | 28378 | Humboldt | Humboldt | 23 | 2020-05-25 | 94 | 2 | |
28379 | 28379 | Imperial | Imperial | 25 | 2020-05-25 | 1274 | 23 | |
28380 | 28380 | Inyo | Inyo | 27 | 2020-05-25 | 19 | 1 | TRUE |
28381 | 28381 | Kern | Kern | 29 | 2020-05-25 | 1871 | 29 | |
28382 | 28382 | Kings | Kings | 31 | 2020-05-25 | 688 | 2 | |
28383 | 28383 | Lake | Lake | 33 | 2020-05-25 | 12 | 0 | TRUE |
28384 | 28384 | Lassen | Lassen | 35 | 2020-05-25 | 4 | 0 | TRUE |
28385 | 28385 | Long Beach | Los Angeles | 37 | 2020-05-25 | 1582 | 73 | |
28386 | 28386 | Los Angeles | Los Angeles | 37 | 2020-05-25 | 43588 | 1961 | |
28387 | 28387 | Pasadena | Los Angeles | 37 | 2020-05-25 | 853 | 82 | |
28388 | 28388 | Madera | Madera | 39 | 2020-05-25 | 85 | 2 | |
28389 | 28389 | Marin | Marin | 41 | 2020-05-25 | 417 | 14 | |
28390 | 28390 | Mariposa | Mariposa | 43 | 2020-05-25 | 15 | 1 | TRUE |
28391 | 28391 | Mendocino | Mendocino | 45 | 2020-05-25 | 22 | 0 | |
28392 | 28392 | Merced | Merced | 47 | 2020-05-25 | 268 | 7 | |
28393 | 28393 | Modoc | Modoc | 49 | 2020-05-25 | 0 | 0 | TRUE |
28394 | 28394 | Mono | Mono | 51 | 2020-05-25 | 34 | 1 | TRUE |
28395 | 28395 | Monterey | Monterey | 53 | 2020-05-25 | 413 | 8 | |
28396 | 28396 | Napa | Napa | 55 | 2020-05-25 | 101 | 3 | TRUE |
28397 | 28397 | Nevada | Nevada | 57 | 2020-05-25 | 41 | 1 | |
28398 | 28398 | Orange | Orange | 59 | 2020-05-25 | 5469 | 131 | |
28399 | 28399 | Placer | Placer | 61 | 2020-05-25 | 185 | 9 | |
28400 | 28400 | Plumas | Plumas | 63 | 2020-05-25 | 4 | 0 | TRUE |
28401 | 28401 | Riverside | Riverside | 65 | 2020-05-25 | 7004 | 292 | |
28402 | 28402 | Sacramento | Sacramento | 67 | 2020-05-25 | 1302 | 56 | |
28403 | 28403 | San Benito | San Benito | 69 | 2020-05-25 | 72 | 2 | |
28404 | 28404 | San Bernardino | San Bernardino | 71 | 2020-05-25 | 4365 | 196 | TRUE |
28405 | 28405 | San Diego | San Diego | 73 | 2020-05-25 | 6797 | 249 | |
28406 | 28406 | San Francisco | San Francisco | 75 | 2020-05-25 | 2386 | 40 | |
28407 | 28407 | San Joaquin | San Joaquin | 77 | 2020-05-25 | 809 | 33 | |
28408 | 28408 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-25 | 259 | 1 | |
28409 | 28409 | San Mateo | San Mateo | 81 | 2020-05-25 | 1833 | 76 | TRUE |
28410 | 28410 | Santa Barbara | Santa Barbara | 83 | 2020-05-25 | 1551 | 12 | TRUE |
28411 | 28411 | Santa Clara | Santa Clara | 85 | 2020-05-25 | 2682 | 137 | |
28412 | 28412 | Santa Cruz | Santa Cruz | 87 | 2020-05-25 | 200 | 2 | |
28413 | 28413 | Shasta | Shasta | 89 | 2020-05-25 | 36 | 4 | |
28414 | 28414 | Sierra | Sierra | 91 | 2020-05-25 | 1 | 0 | TRUE |
28415 | 28415 | Siskiyou | Siskiyou | 93 | 2020-05-25 | 6 | 0 | |
28416 | 28416 | Solano | Solano | 95 | 2020-05-25 | 455 | 20 | TRUE |
28417 | 28417 | Sonoma | Sonoma | 97 | 2020-05-25 | 515 | 4 | |
28418 | 28418 | Stanislaus | Stanislaus | 99 | 2020-05-25 | 659 | 28 | |
28419 | 28419 | Sutter | Sutter | 101 | 2020-05-25 | 42 | 2 | |
28420 | 28420 | Tehama | Tehama | 103 | 2020-05-25 | 3 | 1 | TRUE |
28421 | 28421 | Trinity | Trinity | 105 | 2020-05-25 | 1 | 0 | TRUE |
28422 | 28422 | Tulare | Tulare | 107 | 2020-05-25 | 1641 | 75 | TRUE |
28423 | 28423 | Tuolumne | Tuolumne | 109 | 2020-05-25 | 3 | 0 | TRUE |
28424 | 28424 | Ventura | Ventura | 111 | 2020-05-25 | 912 | 30 | TRUE |
28425 | 28425 | Yolo | Yolo | 113 | 2020-05-25 | 198 | 22 | |
28426 | 28426 | Yuba | Yuba | 115 | 2020-05-25 | 28 | 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 );