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-03-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10615 | 10615 | Alameda | Alameda | 1 | 2021-03-12 | 78967 | 1188 | |
10616 | 10616 | Berkeley | Alameda | 1 | 2021-03-12 | 3356 | 45 | |
10617 | 10617 | Alpine | Alpine | 3 | 2021-03-12 | 85 | 0 | TRUE |
10618 | 10618 | Amador | Amador | 5 | 2021-03-12 | 3471 | 44 | |
10619 | 10619 | Butte | Butte | 7 | 2021-03-12 | 11126 | 170 | |
10620 | 10620 | Calaveras | Calaveras | 9 | 2021-03-12 | 1944 | 50 | |
10621 | 10621 | Colusa | Colusa | 11 | 2021-03-12 | 2155 | 14 | |
10622 | 10622 | Contra Costa | Contra Costa | 13 | 2021-03-12 | 63830 | 716 | |
10623 | 10623 | Del Norte | Del Norte | 15 | 2021-03-12 | 1056 | 5 | |
10624 | 10624 | El Dorado | El Dorado | 17 | 2021-03-12 | 9277 | 105 | |
10625 | 10625 | Fresno | Fresno | 19 | 2021-03-12 | 97376 | 1527 | |
10626 | 10626 | Glenn | Glenn | 21 | 2021-03-12 | 2214 | 23 | |
10627 | 10627 | Humboldt | Humboldt | 23 | 2021-03-12 | 3349 | 34 | |
10628 | 10628 | Imperial | Imperial | 25 | 2021-03-12 | 26749 | 680 | |
10629 | 10629 | Inyo | Inyo | 27 | 2021-03-12 | 1362 | 37 | |
10630 | 10630 | Kern | Kern | 29 | 2021-03-12 | 104763 | 982 | |
10631 | 10631 | Kings | Kings | 31 | 2021-03-12 | 22320 | 235 | |
10632 | 10632 | Lake | Lake | 33 | 2021-03-12 | 3207 | 42 | |
10633 | 10633 | Lassen | Lassen | 35 | 2021-03-12 | 5629 | 24 | |
10634 | 10634 | Long Beach | Los Angeles | 37 | 2021-03-12 | 51600 | 882 | |
10635 | 10635 | Los Angeles | Los Angeles | 37 | 2021-03-12 | 1146331 | 21198 | |
10636 | 10636 | Pasadena | Los Angeles | 37 | 2021-03-12 | 11018 | 327 | |
10637 | 10637 | Madera | Madera | 39 | 2021-03-12 | 15667 | 222 | |
10638 | 10638 | Marin | Marin | 41 | 2021-03-12 | 13434 | 198 | |
10639 | 10639 | Mariposa | Mariposa | 43 | 2021-03-12 | 396 | 7 | |
10640 | 10640 | Mendocino | Mendocino | 45 | 2021-03-12 | 3871 | 45 | |
10641 | 10641 | Merced | Merced | 47 | 2021-03-12 | 29796 | 421 | |
10642 | 10642 | Modoc | Modoc | 49 | 2021-03-12 | 463 | 4 | |
10643 | 10643 | Mono | Mono | 51 | 2021-03-12 | 1225 | 4 | |
10644 | 10644 | Monterey | Monterey | 53 | 2021-03-12 | 42551 | 333 | |
10645 | 10645 | Napa | Napa | 55 | 2021-03-12 | 9161 | 72 | |
10646 | 10646 | Nevada | Nevada | 57 | 2021-03-12 | 4097 | 74 | |
10647 | 10647 | Orange | Orange | 59 | 2021-03-12 | 248389 | 4408 | |
10648 | 10648 | Placer | Placer | 61 | 2021-03-12 | 20273 | 232 | |
10649 | 10649 | Plumas | Plumas | 63 | 2021-03-12 | 660 | 6 | |
10650 | 10650 | Riverside | Riverside | 65 | 2021-03-12 | 291866 | 3971 | |
10651 | 10651 | Sacramento | Sacramento | 67 | 2021-03-12 | 95088 | 1541 | |
10652 | 10652 | San Benito | San Benito | 69 | 2021-03-12 | 5769 | 61 | |
10653 | 10653 | San Bernardino | San Bernardino | 71 | 2021-03-12 | 288364 | 4684 | |
10654 | 10654 | San Diego | San Diego | 73 | 2021-03-12 | 264527 | 3422 | |
10655 | 10655 | San Francisco | San Francisco | 75 | 2021-03-12 | 34495 | 445 | |
10656 | 10656 | San Joaquin | San Joaquin | 77 | 2021-03-12 | 67817 | 1210 | |
10657 | 10657 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-12 | 20041 | 251 | |
10658 | 10658 | San Mateo | San Mateo | 81 | 2021-03-12 | 39349 | 534 | |
10659 | 10659 | Santa Barbara | Santa Barbara | 83 | 2021-03-12 | 32573 | 428 | |
10660 | 10660 | Santa Clara | Santa Clara | 85 | 2021-03-12 | 111924 | 1626 | |
10661 | 10661 | Santa Cruz | Santa Cruz | 87 | 2021-03-12 | 15023 | 193 | |
10662 | 10662 | Shasta | Shasta | 89 | 2021-03-12 | 11084 | 190 | |
10663 | 10663 | Sierra | Sierra | 91 | 2021-03-12 | 100 | 0 | |
10664 | 10664 | Siskiyou | Siskiyou | 93 | 2021-03-12 | 1831 | 14 | |
10665 | 10665 | Solano | Solano | 95 | 2021-03-12 | 30517 | 177 | |
10666 | 10666 | Sonoma | Sonoma | 97 | 2021-03-12 | 28622 | 306 | |
10667 | 10667 | Stanislaus | Stanislaus | 99 | 2021-03-12 | 51594 | 966 | |
10668 | 10668 | Sutter | Sutter | 101 | 2021-03-12 | 8977 | 99 | |
10669 | 10669 | Tehama | Tehama | 103 | 2021-03-12 | 5146 | 53 | TRUE |
10670 | 10670 | Trinity | Trinity | 105 | 2021-03-12 | 377 | 5 | |
10671 | 10671 | Tulare | Tulare | 107 | 2021-03-12 | 48550 | 784 | |
10672 | 10672 | Tuolumne | Tuolumne | 109 | 2021-03-12 | 3991 | 59 | |
10673 | 10673 | Ventura | Ventura | 111 | 2021-03-12 | 78713 | 925 | |
10674 | 10674 | Yolo | Yolo | 113 | 2021-03-12 | 12919 | 190 | |
10675 | 10675 | Yuba | Yuba | 115 | 2021-03-12 | 5854 | 40 |
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 );