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-01 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
18606 | 18606 | Alameda | Alameda | 1 | 2020-11-01 | 23218 | 451 | |
18607 | 18607 | Berkeley | Alameda | 1 | 2020-11-01 | 792 | 10 | |
18608 | 18608 | Alpine | Alpine | 3 | 2020-11-01 | 8 | 0 | TRUE |
18609 | 18609 | Amador | Amador | 5 | 2020-11-01 | 311 | 15 | TRUE |
18610 | 18610 | Butte | Butte | 7 | 2020-11-01 | 3185 | 53 | TRUE |
18611 | 18611 | Calaveras | Calaveras | 9 | 2020-11-01 | 354 | 21 | TRUE |
18612 | 18612 | Colusa | Colusa | 11 | 2020-11-01 | 557 | 6 | TRUE |
18613 | 18613 | Contra Costa | Contra Costa | 13 | 2020-11-01 | 19254 | 247 | |
18614 | 18614 | Del Norte | Del Norte | 15 | 2020-11-01 | 181 | 1 | TRUE |
18615 | 18615 | El Dorado | El Dorado | 17 | 2020-11-01 | 1388 | 4 | TRUE |
18616 | 18616 | Fresno | Fresno | 19 | 2020-11-01 | 34109 | 443 | |
18617 | 18617 | Glenn | Glenn | 21 | 2020-11-01 | 685 | 3 | TRUE |
18618 | 18618 | Humboldt | Humboldt | 23 | 2020-11-01 | 571 | 9 | TRUE |
18619 | 18619 | Imperial | Imperial | 25 | 2020-11-01 | 13038 | 338 | TRUE |
18620 | 18620 | Inyo | Inyo | 27 | 2020-11-01 | 241 | 15 | TRUE |
18621 | 18621 | Kern | Kern | 29 | 2020-11-01 | 34457 | 424 | |
18622 | 18622 | Kings | Kings | 31 | 2020-11-01 | 8539 | 83 | |
18623 | 18623 | Lake | Lake | 33 | 2020-11-01 | 727 | 17 | TRUE |
18624 | 18624 | Lassen | Lassen | 35 | 2020-11-01 | 771 | 1 | TRUE |
18625 | 18625 | Long Beach | Los Angeles | 37 | 2020-11-01 | 13354 | 259 | TRUE |
18626 | 18626 | Los Angeles | Los Angeles | 37 | 2020-11-01 | 292998 | 6686 | |
18627 | 18627 | Pasadena | Los Angeles | 37 | 2020-11-01 | 2845 | 129 | |
18628 | 18628 | Madera | Madera | 39 | 2020-11-01 | 5094 | 76 | TRUE |
18629 | 18629 | Marin | Marin | 41 | 2020-11-01 | 7157 | 127 | |
18630 | 18630 | Mariposa | Mariposa | 43 | 2020-11-01 | 81 | 2 | TRUE |
18631 | 18631 | Mendocino | Mendocino | 45 | 2020-11-01 | 1176 | 21 | |
18632 | 18632 | Merced | Merced | 47 | 2020-11-01 | 9674 | 156 | TRUE |
18633 | 18633 | Modoc | Modoc | 49 | 2020-11-01 | 51 | 0 | TRUE |
18634 | 18634 | Mono | Mono | 51 | 2020-11-01 | 421 | 2 | TRUE |
18635 | 18635 | Monterey | Monterey | 53 | 2020-11-01 | 11802 | 96 | |
18636 | 18636 | Napa | Napa | 55 | 2020-11-01 | 2021 | 15 | TRUE |
18637 | 18637 | Nevada | Nevada | 57 | 2020-11-01 | 642 | 9 | TRUE |
18638 | 18638 | Orange | Orange | 59 | 2020-11-01 | 60115 | 1483 | |
18639 | 18639 | Placer | Placer | 61 | 2020-11-01 | 4353 | 59 | TRUE |
18640 | 18640 | Plumas | Plumas | 63 | 2020-11-01 | 85 | 0 | TRUE |
18641 | 18641 | Riverside | Riverside | 65 | 2020-11-01 | 68050 | 1319 | TRUE |
18642 | 18642 | Sacramento | Sacramento | 67 | 2020-11-01 | 26185 | 500 | TRUE |
18643 | 18643 | San Benito | San Benito | 69 | 2020-11-01 | 1473 | 15 | |
18644 | 18644 | San Bernardino | San Bernardino | 71 | 2020-11-01 | 65207 | 1238 | |
18645 | 18645 | San Diego | San Diego | 73 | 2020-11-01 | 57102 | 891 | |
18646 | 18646 | San Francisco | San Francisco | 75 | 2020-11-01 | 12454 | 148 | |
18647 | 18647 | San Joaquin | San Joaquin | 77 | 2020-11-01 | 22106 | 494 | TRUE |
18648 | 18648 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-01 | 4298 | 32 | TRUE |
18649 | 18649 | San Mateo | San Mateo | 81 | 2020-11-01 | 11371 | 161 | TRUE |
18650 | 18650 | Santa Barbara | Santa Barbara | 83 | 2020-11-01 | 9944 | 128 | TRUE |
18651 | 18651 | Santa Clara | Santa Clara | 85 | 2020-11-01 | 25560 | 367 | |
18652 | 18652 | Santa Cruz | Santa Cruz | 87 | 2020-11-01 | 2884 | 26 | TRUE |
18653 | 18653 | Shasta | Shasta | 89 | 2020-11-01 | 2046 | 31 | TRUE |
18654 | 18654 | Sierra | Sierra | 91 | 2020-11-01 | 6 | 0 | TRUE |
18655 | 18655 | Siskiyou | Siskiyou | 93 | 2020-11-01 | 241 | 0 | TRUE |
18656 | 18656 | Solano | Solano | 95 | 2020-11-01 | 7634 | 76 | TRUE |
18657 | 18657 | Sonoma | Sonoma | 97 | 2020-11-01 | 9686 | 136 | TRUE |
18658 | 18658 | Stanislaus | Stanislaus | 99 | 2020-11-01 | 17979 | 401 | |
18659 | 18659 | Sutter | Sutter | 101 | 2020-11-01 | 1912 | 12 | TRUE |
18660 | 18660 | Tehama | Tehama | 103 | 2020-11-01 | 929 | 14 | TRUE |
18661 | 18661 | Trinity | Trinity | 105 | 2020-11-01 | 33 | 0 | TRUE |
18662 | 18662 | Tulare | Tulare | 107 | 2020-11-01 | 17852 | 293 | TRUE |
18663 | 18663 | Tuolumne | Tuolumne | 109 | 2020-11-01 | 291 | 6 | TRUE |
18664 | 18664 | Ventura | Ventura | 111 | 2020-11-01 | 14410 | 166 | TRUE |
18665 | 18665 | Yolo | Yolo | 113 | 2020-11-01 | 3303 | 60 | |
18666 | 18666 | Yuba | Yuba | 115 | 2020-11-01 | 1353 | 10 | 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 );