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-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29403 | 29403 | Alameda | Alameda | 1 | 2020-05-08 | 1909 | 103 | |
29404 | 29404 | Berkeley | Alameda | 1 | 2020-05-08 | 66 | 1 | |
29405 | 29405 | Alpine | Alpine | 3 | 2020-05-08 | 1 | 0 | TRUE |
29406 | 29406 | Amador | Amador | 5 | 2020-05-08 | 8 | 0 | |
29407 | 29407 | Butte | Butte | 7 | 2020-05-08 | 18 | 0 | |
29408 | 29408 | Calaveras | Calaveras | 9 | 2020-05-08 | 13 | 0 | |
29409 | 29409 | Colusa | Colusa | 11 | 2020-05-08 | 3 | 0 | |
29410 | 29410 | Contra Costa | Contra Costa | 13 | 2020-05-08 | 1006 | 29 | |
29411 | 29411 | Del Norte | Del Norte | 15 | 2020-05-08 | 3 | 0 | |
29412 | 29412 | El Dorado | El Dorado | 17 | 2020-05-08 | 54 | 0 | |
29413 | 29413 | Fresno | Fresno | 19 | 2020-05-08 | 1550 | 9 | |
29414 | 29414 | Glenn | Glenn | 21 | 2020-05-08 | 6 | 0 | |
29415 | 29415 | Humboldt | Humboldt | 23 | 2020-05-08 | 55 | 0 | |
29416 | 29416 | Imperial | Imperial | 25 | 2020-05-08 | 512 | 12 | |
29417 | 29417 | Inyo | Inyo | 27 | 2020-05-08 | 19 | 1 | |
29418 | 29418 | Kern | Kern | 29 | 2020-05-08 | 1166 | 15 | |
29419 | 29419 | Kings | Kings | 31 | 2020-05-08 | 265 | 1 | |
29420 | 29420 | Lake | Lake | 33 | 2020-05-08 | 8 | 0 | |
29421 | 29421 | Lassen | Lassen | 35 | 2020-05-08 | 0 | 0 | |
29422 | 29422 | Long Beach | Los Angeles | 37 | 2020-05-08 | 898 | 40 | |
29423 | 29423 | Los Angeles | Los Angeles | 37 | 2020-05-08 | 28905 | 1365 | |
29424 | 29424 | Pasadena | Los Angeles | 37 | 2020-05-08 | 531 | 65 | |
29425 | 29425 | Madera | Madera | 39 | 2020-05-08 | 66 | 2 | |
29426 | 29426 | Marin | Marin | 41 | 2020-05-08 | 257 | 14 | |
29427 | 29427 | Mariposa | Mariposa | 43 | 2020-05-08 | 15 | 0 | |
29428 | 29428 | Mendocino | Mendocino | 45 | 2020-05-08 | 12 | 0 | |
29429 | 29429 | Merced | Merced | 47 | 2020-05-08 | 163 | 3 | |
29430 | 29430 | Modoc | Modoc | 49 | 2020-05-08 | 0 | 0 | TRUE |
29431 | 29431 | Mono | Mono | 51 | 2020-05-08 | 29 | 1 | |
29432 | 29432 | Monterey | Monterey | 53 | 2020-05-08 | 267 | 6 | |
29433 | 29433 | Napa | Napa | 55 | 2020-05-08 | 78 | 2 | |
29434 | 29434 | Nevada | Nevada | 57 | 2020-05-08 | 41 | 1 | |
29435 | 29435 | Orange | Orange | 59 | 2020-05-08 | 3234 | 71 | |
29436 | 29436 | Placer | Placer | 61 | 2020-05-08 | 165 | 8 | |
29437 | 29437 | Plumas | Plumas | 63 | 2020-05-08 | 4 | 0 | |
29438 | 29438 | Riverside | Riverside | 65 | 2020-05-08 | 4817 | 204 | |
29439 | 29439 | Sacramento | Sacramento | 67 | 2020-05-08 | 1160 | 50 | |
29440 | 29440 | San Benito | San Benito | 69 | 2020-05-08 | 55 | 2 | |
29441 | 29441 | San Bernardino | San Bernardino | 71 | 2020-05-08 | 2629 | 138 | |
29442 | 29442 | San Diego | San Diego | 73 | 2020-05-08 | 4662 | 169 | |
29443 | 29443 | San Francisco | San Francisco | 75 | 2020-05-08 | 1853 | 33 | |
29444 | 29444 | San Joaquin | San Joaquin | 77 | 2020-05-08 | 598 | 28 | |
29445 | 29445 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-08 | 212 | 1 | |
29446 | 29446 | San Mateo | San Mateo | 81 | 2020-05-08 | 1397 | 56 | |
29447 | 29447 | Santa Barbara | Santa Barbara | 83 | 2020-05-08 | 1032 | 11 | |
29448 | 29448 | Santa Clara | Santa Clara | 85 | 2020-05-08 | 2360 | 127 | |
29449 | 29449 | Santa Cruz | Santa Cruz | 87 | 2020-05-08 | 140 | 2 | |
29450 | 29450 | Shasta | Shasta | 89 | 2020-05-08 | 31 | 4 | |
29451 | 29451 | Sierra | Sierra | 91 | 2020-05-08 | 0 | 0 | |
29452 | 29452 | Siskiyou | Siskiyou | 93 | 2020-05-08 | 5 | 0 | |
29453 | 29453 | Solano | Solano | 95 | 2020-05-08 | 351 | 7 | |
29454 | 29454 | Sonoma | Sonoma | 97 | 2020-05-08 | 300 | 3 | |
29455 | 29455 | Stanislaus | Stanislaus | 99 | 2020-05-08 | 488 | 19 | |
29456 | 29456 | Sutter | Sutter | 101 | 2020-05-08 | 32 | 2 | |
29457 | 29457 | Tehama | Tehama | 103 | 2020-05-08 | 1 | 1 | |
29458 | 29458 | Trinity | Trinity | 105 | 2020-05-08 | 0 | 0 | |
29459 | 29459 | Tulare | Tulare | 107 | 2020-05-08 | 1013 | 44 | |
29460 | 29460 | Tuolumne | Tuolumne | 109 | 2020-05-08 | 2 | 0 | TRUE |
29461 | 29461 | Ventura | Ventura | 111 | 2020-05-08 | 652 | 19 | |
29462 | 29462 | Yolo | Yolo | 113 | 2020-05-08 | 172 | 20 | |
29463 | 29463 | Yuba | Yuba | 115 | 2020-05-08 | 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 );