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 2021-05-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
agency 61
- Alameda 1
- Alpine 1
- Amador 1
- Berkeley 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Long Beach 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Pasadena 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
fips 58
county 58
- Los Angeles 3
- Alameda 2
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6467 | 6467 | Alameda | Alameda | 1 | 2021-05-19 | 84750 | 1217 | |
6468 | 6468 | Berkeley | Alameda | 1 | 2021-05-19 | 3609 | 46 | |
6469 | 6469 | Alpine | Alpine | 3 | 2021-05-19 | 88 | 0 | TRUE |
6470 | 6470 | Amador | Amador | 5 | 2021-05-19 | 3633 | 47 | TRUE |
6471 | 6471 | Butte | Butte | 7 | 2021-05-19 | 12198 | 187 | |
6472 | 6472 | Calaveras | Calaveras | 9 | 2021-05-19 | 2148 | 55 | |
6473 | 6473 | Colusa | Colusa | 11 | 2021-05-19 | 2246 | 18 | |
6474 | 6474 | Contra Costa | Contra Costa | 13 | 2021-05-19 | 69120 | 796 | |
6475 | 6475 | Del Norte | Del Norte | 15 | 2021-05-19 | 1410 | 7 | |
6476 | 6476 | El Dorado | El Dorado | 17 | 2021-05-19 | 10224 | 113 | |
6477 | 6477 | Fresno | Fresno | 19 | 2021-05-19 | 101597 | 1690 | |
6478 | 6478 | Glenn | Glenn | 21 | 2021-05-19 | 2340 | 25 | |
6479 | 6479 | Humboldt | Humboldt | 23 | 2021-05-19 | 4166 | 42 | |
6480 | 6480 | Imperial | Imperial | 25 | 2021-05-19 | 28045 | 730 | |
6481 | 6481 | Inyo | Inyo | 27 | 2021-05-19 | 1429 | 38 | |
6482 | 6482 | Kern | Kern | 29 | 2021-05-19 | 109424 | 1379 | |
6483 | 6483 | Kings | Kings | 31 | 2021-05-19 | 23019 | 247 | |
6484 | 6484 | Lake | Lake | 33 | 2021-05-19 | 3479 | 43 | |
6485 | 6485 | Lassen | Lassen | 35 | 2021-05-19 | 5720 | 24 | |
6486 | 6486 | Long Beach | Los Angeles | 37 | 2021-05-19 | 53250 | 934 | |
6487 | 6487 | Los Angeles | Los Angeles | 37 | 2021-05-19 | 1173384 | 22837 | |
6488 | 6488 | Pasadena | Los Angeles | 37 | 2021-05-19 | 11276 | 346 | |
6489 | 6489 | Madera | Madera | 39 | 2021-05-19 | 16394 | 243 | |
6490 | 6490 | Marin | Marin | 41 | 2021-05-19 | 14094 | 211 | |
6491 | 6491 | Mariposa | Mariposa | 43 | 2021-05-19 | 450 | 7 | |
6492 | 6492 | Mendocino | Mendocino | 45 | 2021-05-19 | 4147 | 49 | |
6493 | 6493 | Merced | Merced | 47 | 2021-05-19 | 31959 | 467 | |
6494 | 6494 | Modoc | Modoc | 49 | 2021-05-19 | 502 | 4 | |
6495 | 6495 | Mono | Mono | 51 | 2021-05-19 | 1287 | 4 | |
6496 | 6496 | Monterey | Monterey | 53 | 2021-05-19 | 43662 | 385 | |
6497 | 6497 | Napa | Napa | 55 | 2021-05-19 | 9905 | 78 | |
6498 | 6498 | Nevada | Nevada | 57 | 2021-05-19 | 4771 | 75 | |
6499 | 6499 | Orange | Orange | 59 | 2021-05-19 | 254882 | 5034 | |
6500 | 6500 | Placer | Placer | 61 | 2021-05-19 | 22801 | 295 | |
6501 | 6501 | Plumas | Plumas | 63 | 2021-05-19 | 720 | 6 | TRUE |
6502 | 6502 | Riverside | Riverside | 65 | 2021-05-19 | 300126 | 4602 | |
6503 | 6503 | Sacramento | Sacramento | 67 | 2021-05-19 | 105374 | 1693 | |
6504 | 6504 | San Benito | San Benito | 69 | 2021-05-19 | 6081 | 63 | |
6505 | 6505 | San Bernardino | San Bernardino | 71 | 2021-05-19 | 297349 | 4815 | |
6506 | 6506 | San Diego | San Diego | 73 | 2021-05-19 | 279344 | 3746 | |
6507 | 6507 | San Francisco | San Francisco | 75 | 2021-05-19 | 36505 | 541 | |
6508 | 6508 | San Joaquin | San Joaquin | 77 | 2021-05-19 | 73440 | 1400 | |
6509 | 6509 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-19 | 21234 | 261 | |
6510 | 6510 | San Mateo | San Mateo | 81 | 2021-05-19 | 41961 | 570 | |
6511 | 6511 | Santa Barbara | Santa Barbara | 83 | 2021-05-19 | 34412 | 450 | |
6512 | 6512 | Santa Clara | Santa Clara | 85 | 2021-05-19 | 118086 | 1688 | |
6513 | 6513 | Santa Cruz | Santa Cruz | 87 | 2021-05-19 | 16159 | 206 | TRUE |
6514 | 6514 | Shasta | Shasta | 89 | 2021-05-19 | 12252 | 226 | |
6515 | 6515 | Sierra | Sierra | 91 | 2021-05-19 | 112 | 0 | |
6516 | 6516 | Siskiyou | Siskiyou | 93 | 2021-05-19 | 2288 | 26 | |
6517 | 6517 | Solano | Solano | 95 | 2021-05-19 | 33086 | 230 | |
6518 | 6518 | Sonoma | Sonoma | 97 | 2021-05-19 | 30104 | 314 | |
6519 | 6519 | Stanislaus | Stanislaus | 99 | 2021-05-19 | 55807 | 1063 | |
6520 | 6520 | Sutter | Sutter | 101 | 2021-05-19 | 9472 | 106 | |
6521 | 6521 | Tehama | Tehama | 103 | 2021-05-19 | 5590 | 59 | TRUE |
6522 | 6522 | Trinity | Trinity | 105 | 2021-05-19 | 406 | 5 | |
6523 | 6523 | Tulare | Tulare | 107 | 2021-05-19 | 49758 | 842 | |
6524 | 6524 | Tuolumne | Tuolumne | 109 | 2021-05-19 | 4152 | 67 | |
6525 | 6525 | Ventura | Ventura | 111 | 2021-05-19 | 81145 | 1016 | |
6526 | 6526 | Yolo | Yolo | 113 | 2021-05-19 | 13891 | 208 | |
6527 | 6527 | Yuba | Yuba | 115 | 2021-05-19 | 6309 | 41 |
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 );