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-11-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|---|
18362 | 18362 | Alameda | Alameda | 1 | 2020-11-05 | 23579 | 454 | |
18363 | 18363 | Berkeley | Alameda | 1 | 2020-11-05 | 818 | 10 | |
18364 | 18364 | Alpine | Alpine | 3 | 2020-11-05 | 22 | 0 | |
18365 | 18365 | Amador | Amador | 5 | 2020-11-05 | 332 | 15 | |
18366 | 18366 | Butte | Butte | 7 | 2020-11-05 | 3239 | 54 | |
18367 | 18367 | Calaveras | Calaveras | 9 | 2020-11-05 | 361 | 21 | TRUE |
18368 | 18368 | Colusa | Colusa | 11 | 2020-11-05 | 576 | 6 | |
18369 | 18369 | Contra Costa | Contra Costa | 13 | 2020-11-05 | 19685 | 250 | |
18370 | 18370 | Del Norte | Del Norte | 15 | 2020-11-05 | 201 | 1 | |
18371 | 18371 | El Dorado | El Dorado | 17 | 2020-11-05 | 1469 | 4 | |
18372 | 18372 | Fresno | Fresno | 19 | 2020-11-05 | 35117 | 447 | |
18373 | 18373 | Glenn | Glenn | 21 | 2020-11-05 | 714 | 3 | |
18374 | 18374 | Humboldt | Humboldt | 23 | 2020-11-05 | 599 | 9 | |
18375 | 18375 | Imperial | Imperial | 25 | 2020-11-05 | 13330 | 340 | |
18376 | 18376 | Inyo | Inyo | 27 | 2020-11-05 | 247 | 15 | |
18377 | 18377 | Kern | Kern | 29 | 2020-11-05 | 34973 | 428 | |
18378 | 18378 | Kings | Kings | 31 | 2020-11-05 | 8745 | 84 | |
18379 | 18379 | Lake | Lake | 33 | 2020-11-05 | 740 | 17 | |
18380 | 18380 | Lassen | Lassen | 35 | 2020-11-05 | 780 | 1 | |
18381 | 18381 | Long Beach | Los Angeles | 37 | 2020-11-05 | 13550 | 260 | |
18382 | 18382 | Los Angeles | Los Angeles | 37 | 2020-11-05 | 299175 | 6751 | |
18383 | 18383 | Pasadena | Los Angeles | 37 | 2020-11-05 | 2890 | 129 | |
18384 | 18384 | Madera | Madera | 39 | 2020-11-05 | 5219 | 76 | |
18385 | 18385 | Marin | Marin | 41 | 2020-11-05 | 7204 | 127 | |
18386 | 18386 | Mariposa | Mariposa | 43 | 2020-11-05 | 81 | 2 | |
18387 | 18387 | Mendocino | Mendocino | 45 | 2020-11-05 | 1213 | 21 | |
18388 | 18388 | Merced | Merced | 47 | 2020-11-05 | 9916 | 163 | |
18389 | 18389 | Modoc | Modoc | 49 | 2020-11-05 | 68 | 0 | |
18390 | 18390 | Mono | Mono | 51 | 2020-11-05 | 450 | 2 | |
18391 | 18391 | Monterey | Monterey | 53 | 2020-11-05 | 11998 | 99 | |
18392 | 18392 | Napa | Napa | 55 | 2020-11-05 | 2149 | 15 | |
18393 | 18393 | Nevada | Nevada | 57 | 2020-11-05 | 688 | 9 | |
18394 | 18394 | Orange | Orange | 59 | 2020-11-05 | 61112 | 1494 | |
18395 | 18395 | Placer | Placer | 61 | 2020-11-05 | 4640 | 60 | |
18396 | 18396 | Plumas | Plumas | 63 | 2020-11-05 | 94 | 0 | |
18397 | 18397 | Riverside | Riverside | 65 | 2020-11-05 | 70309 | 1331 | |
18398 | 18398 | Sacramento | Sacramento | 67 | 2020-11-05 | 27278 | 506 | |
18399 | 18399 | San Benito | San Benito | 69 | 2020-11-05 | 1491 | 15 | |
18400 | 18400 | San Bernardino | San Bernardino | 71 | 2020-11-05 | 67196 | 1259 | |
18401 | 18401 | San Diego | San Diego | 73 | 2020-11-05 | 58636 | 904 | |
18402 | 18402 | San Francisco | San Francisco | 75 | 2020-11-05 | 12666 | 149 | |
18403 | 18403 | San Joaquin | San Joaquin | 77 | 2020-11-05 | 22556 | 494 | |
18404 | 18404 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-05 | 4496 | 33 | |
18405 | 18405 | San Mateo | San Mateo | 81 | 2020-11-05 | 11629 | 161 | |
18406 | 18406 | Santa Barbara | Santa Barbara | 83 | 2020-11-05 | 10089 | 130 | |
18407 | 18407 | Santa Clara | Santa Clara | 85 | 2020-11-05 | 26623 | 379 | |
18408 | 18408 | Santa Cruz | Santa Cruz | 87 | 2020-11-05 | 3031 | 26 | |
18409 | 18409 | Shasta | Shasta | 89 | 2020-11-05 | 2375 | 33 | |
18410 | 18410 | Sierra | Sierra | 91 | 2020-11-05 | 7 | 0 | |
18411 | 18411 | Siskiyou | Siskiyou | 93 | 2020-11-05 | 287 | 0 | |
18412 | 18412 | Solano | Solano | 95 | 2020-11-05 | 7996 | 76 | |
18413 | 18413 | Sonoma | Sonoma | 97 | 2020-11-05 | 10116 | 146 | |
18414 | 18414 | Stanislaus | Stanislaus | 99 | 2020-11-05 | 18204 | 405 | |
18415 | 18415 | Sutter | Sutter | 101 | 2020-11-05 | 1977 | 12 | |
18416 | 18416 | Tehama | Tehama | 103 | 2020-11-05 | 1008 | 17 | |
18417 | 18417 | Trinity | Trinity | 105 | 2020-11-05 | 41 | 0 | |
18418 | 18418 | Tulare | Tulare | 107 | 2020-11-05 | 18208 | 297 | |
18419 | 18419 | Tuolumne | Tuolumne | 109 | 2020-11-05 | 318 | 7 | |
18420 | 18420 | Ventura | Ventura | 111 | 2020-11-05 | 14901 | 169 | |
18421 | 18421 | Yolo | Yolo | 113 | 2020-11-05 | 3395 | 62 | |
18422 | 18422 | Yuba | Yuba | 115 | 2020-11-05 | 1428 | 10 |
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 );