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-01-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
13604 | 13604 | Alameda | Alameda | 1 | 2021-01-22 | 67272 | 1063 | |
13605 | 13605 | Berkeley | Alameda | 1 | 2021-01-22 | 2481 | 42 | |
13606 | 13606 | Alpine | Alpine | 3 | 2021-01-22 | 73 | 0 | |
13607 | 13607 | Amador | Amador | 5 | 2021-01-22 | 3008 | 32 | |
13608 | 13608 | Butte | Butte | 7 | 2021-01-22 | 9711 | 134 | |
13609 | 13609 | Calaveras | Calaveras | 9 | 2021-01-22 | 1407 | 23 | |
13610 | 13610 | Colusa | Colusa | 11 | 2021-01-22 | 1854 | 9 | |
13611 | 13611 | Contra Costa | Contra Costa | 13 | 2021-01-22 | 54140 | 484 | |
13612 | 13612 | Del Norte | Del Norte | 15 | 2021-01-22 | 870 | 2 | |
13613 | 13613 | El Dorado | El Dorado | 17 | 2021-01-22 | 8002 | 59 | |
13614 | 13614 | Fresno | Fresno | 19 | 2021-01-22 | 88243 | 1043 | |
13615 | 13615 | Glenn | Glenn | 21 | 2021-01-22 | 1904 | 20 | TRUE |
13616 | 13616 | Humboldt | Humboldt | 23 | 2021-01-22 | 2494 | 25 | |
13617 | 13617 | Imperial | Imperial | 25 | 2021-01-22 | 25445 | 493 | |
13618 | 13618 | Inyo | Inyo | 27 | 2021-01-22 | 1007 | 29 | |
13619 | 13619 | Kern | Kern | 29 | 2021-01-22 | 88399 | 587 | |
13620 | 13620 | Kings | Kings | 31 | 2021-01-22 | 19703 | 160 | TRUE |
13621 | 13621 | Lake | Lake | 33 | 2021-01-22 | 2656 | 32 | |
13622 | 13622 | Lassen | Lassen | 35 | 2021-01-22 | 5224 | 16 | TRUE |
13623 | 13623 | Long Beach | Los Angeles | 37 | 2021-01-22 | 45739 | 586 | |
13624 | 13624 | Los Angeles | Los Angeles | 37 | 2021-01-22 | 999760 | 14114 | |
13625 | 13625 | Pasadena | Los Angeles | 37 | 2021-01-22 | 9655 | 212 | |
13626 | 13626 | Madera | Madera | 39 | 2021-01-22 | 13583 | 151 | |
13627 | 13627 | Marin | Marin | 41 | 2021-01-22 | 11898 | 163 | |
13628 | 13628 | Mariposa | Mariposa | 43 | 2021-01-22 | 346 | 4 | |
13629 | 13629 | Mendocino | Mendocino | 45 | 2021-01-22 | 3234 | 33 | |
13630 | 13630 | Merced | Merced | 47 | 2021-01-22 | 25048 | 324 | |
13631 | 13631 | Modoc | Modoc | 49 | 2021-01-22 | 386 | 3 | |
13632 | 13632 | Mono | Mono | 51 | 2021-01-22 | 1135 | 4 | |
13633 | 13633 | Monterey | Monterey | 53 | 2021-01-22 | 36950 | 259 | |
13634 | 13634 | Napa | Napa | 55 | 2021-01-22 | 7761 | 45 | |
13635 | 13635 | Nevada | Nevada | 57 | 2021-01-22 | 3292 | 73 | |
13636 | 13636 | Orange | Orange | 59 | 2021-01-22 | 218741 | 2547 | |
13637 | 13637 | Placer | Placer | 61 | 2021-01-22 | 17675 | 188 | |
13638 | 13638 | Plumas | Plumas | 63 | 2021-01-22 | 605 | 5 | |
13639 | 13639 | Riverside | Riverside | 65 | 2021-01-22 | 258352 | 2777 | |
13640 | 13640 | Sacramento | Sacramento | 67 | 2021-01-22 | 82066 | 1157 | |
13641 | 13641 | San Benito | San Benito | 69 | 2021-01-22 | 5101 | 48 | |
13642 | 13642 | San Bernardino | San Bernardino | 71 | 2021-01-22 | 261199 | 3868 | |
13643 | 13643 | San Diego | San Diego | 73 | 2021-01-22 | 222578 | 2301 | |
13644 | 13644 | San Francisco | San Francisco | 75 | 2021-01-22 | 29490 | 275 | |
13645 | 13645 | San Joaquin | San Joaquin | 77 | 2021-01-22 | 59395 | 808 | |
13646 | 13646 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-22 | 16437 | 151 | |
13647 | 13647 | San Mateo | San Mateo | 81 | 2021-01-22 | 33468 | 340 | |
13648 | 13648 | Santa Barbara | Santa Barbara | 83 | 2021-01-22 | 25986 | 260 | |
13649 | 13649 | Santa Clara | Santa Clara | 85 | 2021-01-22 | 98519 | 1274 | |
13650 | 13650 | Santa Cruz | Santa Cruz | 87 | 2021-01-22 | 12649 | 130 | |
13651 | 13651 | Shasta | Shasta | 89 | 2021-01-22 | 9920 | 129 | |
13652 | 13652 | Sierra | Sierra | 91 | 2021-01-22 | 88 | 0 | |
13653 | 13653 | Siskiyou | Siskiyou | 93 | 2021-01-22 | 1484 | 13 | |
13654 | 13654 | Solano | Solano | 95 | 2021-01-22 | 26494 | 111 | |
13655 | 13655 | Sonoma | Sonoma | 97 | 2021-01-22 | 24571 | 245 | |
13656 | 13656 | Stanislaus | Stanislaus | 99 | 2021-01-22 | 43644 | 782 | |
13657 | 13657 | Sutter | Sutter | 101 | 2021-01-22 | 7927 | 83 | |
13658 | 13658 | Tehama | Tehama | 103 | 2021-01-22 | 4408 | 44 | |
13659 | 13659 | Trinity | Trinity | 105 | 2021-01-22 | 305 | 4 | TRUE |
13660 | 13660 | Tulare | Tulare | 107 | 2021-01-22 | 42759 | 531 | |
13661 | 13661 | Tuolumne | Tuolumne | 109 | 2021-01-22 | 3443 | 40 | |
13662 | 13662 | Ventura | Ventura | 111 | 2021-01-22 | 63893 | 507 | |
13663 | 13663 | Yolo | Yolo | 113 | 2021-01-22 | 10842 | 138 | |
13664 | 13664 | Yuba | Yuba | 115 | 2021-01-22 | 5049 | 29 |
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 );