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-08-08 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 |
---|---|---|---|---|---|---|---|---|
1526 | 1526 | Alameda | Alameda | 1 | 2021-08-08 | 95376 | 1241 | |
1527 | 1527 | Berkeley | Alameda | 1 | 2021-08-08 | 4108 | 50 | |
1528 | 1528 | Alpine | Alpine | 3 | 2021-08-08 | 89 | 0 | TRUE |
1529 | 1529 | Amador | Amador | 5 | 2021-08-08 | 4025 | 48 | |
1530 | 1530 | Butte | Butte | 7 | 2021-08-08 | 13791 | 200 | TRUE |
1531 | 1531 | Calaveras | Calaveras | 9 | 2021-08-08 | 2406 | 58 | TRUE |
1532 | 1532 | Colusa | Colusa | 11 | 2021-08-08 | 2381 | 18 | TRUE |
1533 | 1533 | Contra Costa | Contra Costa | 13 | 2021-08-08 | 79814 | 838 | |
1534 | 1534 | Del Norte | Del Norte | 15 | 2021-08-08 | 1838 | 10 | TRUE |
1535 | 1535 | El Dorado | El Dorado | 17 | 2021-08-08 | 11566 | 121 | TRUE |
1536 | 1536 | Fresno | Fresno | 19 | 2021-08-08 | 106861 | 1747 | |
1537 | 1537 | Glenn | Glenn | 21 | 2021-08-08 | 2420 | 27 | TRUE |
1538 | 1538 | Humboldt | Humboldt | 23 | 2021-08-08 | 5501 | 56 | TRUE |
1539 | 1539 | Imperial | Imperial | 25 | 2021-08-08 | 29078 | 746 | TRUE |
1540 | 1540 | Inyo | Inyo | 27 | 2021-08-08 | 1498 | 39 | TRUE |
1541 | 1541 | Kern | Kern | 29 | 2021-08-08 | 115007 | 1429 | TRUE |
1542 | 1542 | Kings | Kings | 31 | 2021-08-08 | 24161 | 252 | |
1543 | 1543 | Lake | Lake | 33 | 2021-08-08 | 4613 | 66 | |
1544 | 1544 | Lassen | Lassen | 35 | 2021-08-08 | 5935 | 26 | TRUE |
1545 | 1545 | Long Beach | Los Angeles | 37 | 2021-08-08 | 57263 | 956 | TRUE |
1546 | 1546 | Los Angeles | Los Angeles | 37 | 2021-08-08 | 1257021 | 23468 | |
1547 | 1547 | Pasadena | Los Angeles | 37 | 2021-08-08 | 12077 | 353 | TRUE |
1548 | 1548 | Madera | Madera | 39 | 2021-08-08 | 17120 | 249 | TRUE |
1549 | 1549 | Marin | Marin | 41 | 2021-08-08 | 15271 | 214 | |
1550 | 1550 | Mariposa | Mariposa | 43 | 2021-08-08 | 559 | 7 | TRUE |
1551 | 1551 | Mendocino | Mendocino | 45 | 2021-08-08 | 4892 | 52 | TRUE |
1552 | 1552 | Merced | Merced | 47 | 2021-08-08 | 33761 | 488 | TRUE |
1553 | 1553 | Modoc | Modoc | 49 | 2021-08-08 | 577 | 7 | TRUE |
1554 | 1554 | Mono | Mono | 51 | 2021-08-08 | 1339 | 5 | TRUE |
1555 | 1555 | Monterey | Monterey | 53 | 2021-08-08 | 44837 | 530 | TRUE |
1556 | 1556 | Napa | Napa | 55 | 2021-08-08 | 10640 | 81 | TRUE |
1557 | 1557 | Nevada | Nevada | 57 | 2021-08-08 | 5771 | 75 | TRUE |
1558 | 1558 | Orange | Orange | 59 | 2021-08-08 | 269016 | 5148 | TRUE |
1559 | 1559 | Placer | Placer | 61 | 2021-08-08 | 26004 | 307 | TRUE |
1560 | 1560 | Plumas | Plumas | 63 | 2021-08-08 | 812 | 6 | TRUE |
1561 | 1561 | Riverside | Riverside | 65 | 2021-08-08 | 313931 | 4667 | TRUE |
1562 | 1562 | Sacramento | Sacramento | 67 | 2021-08-08 | 118928 | 1797 | TRUE |
1563 | 1563 | San Benito | San Benito | 69 | 2021-08-08 | 6342 | 64 | TRUE |
1564 | 1564 | San Bernardino | San Bernardino | 71 | 2021-08-08 | 310500 | 4861 | TRUE |
1565 | 1565 | San Diego | San Diego | 73 | 2021-08-08 | 305983 | 3811 | |
1566 | 1566 | San Francisco | San Francisco | 75 | 2021-08-08 | 42441 | 567 | |
1567 | 1567 | San Joaquin | San Joaquin | 77 | 2021-08-08 | 78119 | 1474 | TRUE |
1568 | 1568 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-08 | 22356 | 267 | TRUE |
1569 | 1569 | San Mateo | San Mateo | 81 | 2021-08-08 | 45316 | 588 | TRUE |
1570 | 1570 | Santa Barbara | Santa Barbara | 83 | 2021-08-08 | 36308 | 465 | TRUE |
1571 | 1571 | Santa Clara | Santa Clara | 85 | 2021-08-08 | 125235 | 1711 | TRUE |
1572 | 1572 | Santa Cruz | Santa Cruz | 87 | 2021-08-08 | 16901 | 207 | TRUE |
1573 | 1573 | Shasta | Shasta | 89 | 2021-08-08 | 13382 | 243 | TRUE |
1574 | 1574 | Sierra | Sierra | 91 | 2021-08-08 | 138 | 0 | TRUE |
1575 | 1575 | Siskiyou | Siskiyou | 93 | 2021-08-08 | 2634 | 40 | TRUE |
1576 | 1576 | Solano | Solano | 95 | 2021-08-08 | 36848 | 249 | TRUE |
1577 | 1577 | Sonoma | Sonoma | 97 | 2021-08-08 | 33753 | 334 | |
1578 | 1578 | Stanislaus | Stanislaus | 99 | 2021-08-08 | 60321 | 1099 | TRUE |
1579 | 1579 | Sutter | Sutter | 101 | 2021-08-08 | 10498 | 112 | TRUE |
1580 | 1580 | Tehama | Tehama | 103 | 2021-08-08 | 6016 | 66 | TRUE |
1581 | 1581 | Trinity | Trinity | 105 | 2021-08-08 | 495 | 6 | TRUE |
1582 | 1582 | Tulare | Tulare | 107 | 2021-08-08 | 50946 | 853 | TRUE |
1583 | 1583 | Tuolumne | Tuolumne | 109 | 2021-08-08 | 4817 | 73 | TRUE |
1584 | 1584 | Ventura | Ventura | 111 | 2021-08-08 | 85074 | 1039 | TRUE |
1585 | 1585 | Yolo | Yolo | 113 | 2021-08-08 | 15252 | 216 | TRUE |
1586 | 1586 | Yuba | Yuba | 115 | 2021-08-08 | 7268 | 44 | TRUE |
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 );