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-10-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
18728 | 18728 | Alameda | Alameda | 1 | 2020-10-30 | 22981 | 446 | |
18729 | 18729 | Berkeley | Alameda | 1 | 2020-10-30 | 779 | 10 | |
18730 | 18730 | Alpine | Alpine | 3 | 2020-10-30 | 8 | 0 | TRUE |
18731 | 18731 | Amador | Amador | 5 | 2020-10-30 | 311 | 15 | |
18732 | 18732 | Butte | Butte | 7 | 2020-10-30 | 3160 | 53 | |
18733 | 18733 | Calaveras | Calaveras | 9 | 2020-10-30 | 354 | 21 | |
18734 | 18734 | Colusa | Colusa | 11 | 2020-10-30 | 557 | 6 | |
18735 | 18735 | Contra Costa | Contra Costa | 13 | 2020-10-30 | 19086 | 246 | |
18736 | 18736 | Del Norte | Del Norte | 15 | 2020-10-30 | 181 | 1 | |
18737 | 18737 | El Dorado | El Dorado | 17 | 2020-10-30 | 1388 | 4 | |
18738 | 18738 | Fresno | Fresno | 19 | 2020-10-30 | 33853 | 443 | |
18739 | 18739 | Glenn | Glenn | 21 | 2020-10-30 | 685 | 3 | |
18740 | 18740 | Humboldt | Humboldt | 23 | 2020-10-30 | 571 | 9 | |
18741 | 18741 | Imperial | Imperial | 25 | 2020-10-30 | 13038 | 338 | |
18742 | 18742 | Inyo | Inyo | 27 | 2020-10-30 | 241 | 15 | |
18743 | 18743 | Kern | Kern | 29 | 2020-10-30 | 34308 | 423 | |
18744 | 18744 | Kings | Kings | 31 | 2020-10-30 | 8456 | 83 | |
18745 | 18745 | Lake | Lake | 33 | 2020-10-30 | 703 | 17 | TRUE |
18746 | 18746 | Lassen | Lassen | 35 | 2020-10-30 | 771 | 1 | |
18747 | 18747 | Long Beach | Los Angeles | 37 | 2020-10-30 | 13280 | 259 | |
18748 | 18748 | Los Angeles | Los Angeles | 37 | 2020-10-30 | 290278 | 6669 | |
18749 | 18749 | Pasadena | Los Angeles | 37 | 2020-10-30 | 2830 | 129 | |
18750 | 18750 | Madera | Madera | 39 | 2020-10-30 | 5094 | 76 | |
18751 | 18751 | Marin | Marin | 41 | 2020-10-30 | 7131 | 127 | |
18752 | 18752 | Mariposa | Mariposa | 43 | 2020-10-30 | 81 | 2 | |
18753 | 18753 | Mendocino | Mendocino | 45 | 2020-10-30 | 1165 | 21 | |
18754 | 18754 | Merced | Merced | 47 | 2020-10-30 | 9674 | 156 | |
18755 | 18755 | Modoc | Modoc | 49 | 2020-10-30 | 50 | 0 | |
18756 | 18756 | Mono | Mono | 51 | 2020-10-30 | 258 | 2 | |
18757 | 18757 | Monterey | Monterey | 53 | 2020-10-30 | 11705 | 95 | |
18758 | 18758 | Napa | Napa | 55 | 2020-10-30 | 2021 | 15 | |
18759 | 18759 | Nevada | Nevada | 57 | 2020-10-30 | 642 | 9 | |
18760 | 18760 | Orange | Orange | 59 | 2020-10-30 | 59718 | 1475 | |
18761 | 18761 | Placer | Placer | 61 | 2020-10-30 | 4353 | 59 | |
18762 | 18762 | Plumas | Plumas | 63 | 2020-10-30 | 85 | 0 | |
18763 | 18763 | Riverside | Riverside | 65 | 2020-10-30 | 68050 | 1319 | |
18764 | 18764 | Sacramento | Sacramento | 67 | 2020-10-30 | 26185 | 500 | |
18765 | 18765 | San Benito | San Benito | 69 | 2020-10-30 | 1461 | 15 | |
18766 | 18766 | San Bernardino | San Bernardino | 71 | 2020-10-30 | 64367 | 1227 | |
18767 | 18767 | San Diego | San Diego | 73 | 2020-10-30 | 56369 | 888 | |
18768 | 18768 | San Francisco | San Francisco | 75 | 2020-10-30 | 12320 | 147 | |
18769 | 18769 | San Joaquin | San Joaquin | 77 | 2020-10-30 | 22106 | 494 | |
18770 | 18770 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-30 | 4298 | 32 | |
18771 | 18771 | San Mateo | San Mateo | 81 | 2020-10-30 | 11341 | 161 | |
18772 | 18772 | Santa Barbara | Santa Barbara | 83 | 2020-10-30 | 9944 | 128 | |
18773 | 18773 | Santa Clara | Santa Clara | 85 | 2020-10-30 | 25406 | 362 | |
18774 | 18774 | Santa Cruz | Santa Cruz | 87 | 2020-10-30 | 2884 | 26 | |
18775 | 18775 | Shasta | Shasta | 89 | 2020-10-30 | 2046 | 31 | |
18776 | 18776 | Sierra | Sierra | 91 | 2020-10-30 | 6 | 0 | |
18777 | 18777 | Siskiyou | Siskiyou | 93 | 2020-10-30 | 241 | 0 | |
18778 | 18778 | Solano | Solano | 95 | 2020-10-30 | 7634 | 76 | |
18779 | 18779 | Sonoma | Sonoma | 97 | 2020-10-30 | 9646 | 136 | |
18780 | 18780 | Stanislaus | Stanislaus | 99 | 2020-10-30 | 17872 | 401 | |
18781 | 18781 | Sutter | Sutter | 101 | 2020-10-30 | 1912 | 12 | |
18782 | 18782 | Tehama | Tehama | 103 | 2020-10-30 | 921 | 9 | |
18783 | 18783 | Trinity | Trinity | 105 | 2020-10-30 | 33 | 0 | |
18784 | 18784 | Tulare | Tulare | 107 | 2020-10-30 | 17852 | 293 | |
18785 | 18785 | Tuolumne | Tuolumne | 109 | 2020-10-30 | 291 | 6 | |
18786 | 18786 | Ventura | Ventura | 111 | 2020-10-30 | 14410 | 166 | |
18787 | 18787 | Yolo | Yolo | 113 | 2020-10-30 | 3266 | 60 | |
18788 | 18788 | Yuba | Yuba | 115 | 2020-10-30 | 1353 | 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 );