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-11 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 |
---|---|---|---|---|---|---|---|---|
17996 | 17996 | Alameda | Alameda | 1 | 2020-11-11 | 24449 | 462 | |
17997 | 17997 | Berkeley | Alameda | 1 | 2020-11-11 | 852 | 10 | |
17998 | 17998 | Alpine | Alpine | 3 | 2020-11-11 | 26 | 0 | TRUE |
17999 | 17999 | Amador | Amador | 5 | 2020-11-11 | 353 | 15 | TRUE |
18000 | 18000 | Butte | Butte | 7 | 2020-11-11 | 3348 | 56 | TRUE |
18001 | 18001 | Calaveras | Calaveras | 9 | 2020-11-11 | 373 | 21 | TRUE |
18002 | 18002 | Colusa | Colusa | 11 | 2020-11-11 | 591 | 6 | TRUE |
18003 | 18003 | Contra Costa | Contra Costa | 13 | 2020-11-11 | 20418 | 252 | |
18004 | 18004 | Del Norte | Del Norte | 15 | 2020-11-11 | 204 | 1 | TRUE |
18005 | 18005 | El Dorado | El Dorado | 17 | 2020-11-11 | 1558 | 4 | TRUE |
18006 | 18006 | Fresno | Fresno | 19 | 2020-11-11 | 36596 | 456 | TRUE |
18007 | 18007 | Glenn | Glenn | 21 | 2020-11-11 | 733 | 5 | TRUE |
18008 | 18008 | Humboldt | Humboldt | 23 | 2020-11-11 | 624 | 9 | TRUE |
18009 | 18009 | Imperial | Imperial | 25 | 2020-11-11 | 13697 | 341 | TRUE |
18010 | 18010 | Inyo | Inyo | 27 | 2020-11-11 | 256 | 15 | TRUE |
18011 | 18011 | Kern | Kern | 29 | 2020-11-11 | 35818 | 429 | |
18012 | 18012 | Kings | Kings | 31 | 2020-11-11 | 9108 | 86 | TRUE |
18013 | 18013 | Lake | Lake | 33 | 2020-11-11 | 763 | 17 | TRUE |
18014 | 18014 | Lassen | Lassen | 35 | 2020-11-11 | 906 | 1 | |
18015 | 18015 | Long Beach | Los Angeles | 37 | 2020-11-11 | 13967 | 265 | |
18016 | 18016 | Los Angeles | Los Angeles | 37 | 2020-11-11 | 311083 | 6824 | |
18017 | 18017 | Pasadena | Los Angeles | 37 | 2020-11-11 | 3008 | 129 | |
18018 | 18018 | Madera | Madera | 39 | 2020-11-11 | 5330 | 76 | TRUE |
18019 | 18019 | Marin | Marin | 41 | 2020-11-11 | 7284 | 127 | TRUE |
18020 | 18020 | Mariposa | Mariposa | 43 | 2020-11-11 | 88 | 2 | |
18021 | 18021 | Mendocino | Mendocino | 45 | 2020-11-11 | 1242 | 22 | TRUE |
18022 | 18022 | Merced | Merced | 47 | 2020-11-11 | 10193 | 164 | TRUE |
18023 | 18023 | Modoc | Modoc | 49 | 2020-11-11 | 86 | 0 | |
18024 | 18024 | Mono | Mono | 51 | 2020-11-11 | 470 | 2 | TRUE |
18025 | 18025 | Monterey | Monterey | 53 | 2020-11-11 | 12534 | 103 | |
18026 | 18026 | Napa | Napa | 55 | 2020-11-11 | 2331 | 16 | TRUE |
18027 | 18027 | Nevada | Nevada | 57 | 2020-11-11 | 733 | 9 | TRUE |
18028 | 18028 | Orange | Orange | 59 | 2020-11-11 | 63165 | 1514 | |
18029 | 18029 | Placer | Placer | 61 | 2020-11-11 | 4993 | 60 | |
18030 | 18030 | Plumas | Plumas | 63 | 2020-11-11 | 119 | 0 | |
18031 | 18031 | Riverside | Riverside | 65 | 2020-11-11 | 72341 | 1352 | TRUE |
18032 | 18032 | Sacramento | Sacramento | 67 | 2020-11-11 | 29014 | 514 | |
18033 | 18033 | San Benito | San Benito | 69 | 2020-11-11 | 1540 | 15 | |
18034 | 18034 | San Bernardino | San Bernardino | 71 | 2020-11-11 | 71072 | 1292 | |
18035 | 18035 | San Diego | San Diego | 73 | 2020-11-11 | 61053 | 915 | TRUE |
18036 | 18036 | San Francisco | San Francisco | 75 | 2020-11-11 | 13209 | 152 | |
18037 | 18037 | San Joaquin | San Joaquin | 77 | 2020-11-11 | 22993 | 500 | TRUE |
18038 | 18038 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-11 | 4846 | 33 | TRUE |
18039 | 18039 | San Mateo | San Mateo | 81 | 2020-11-11 | 12127 | 165 | |
18040 | 18040 | Santa Barbara | Santa Barbara | 83 | 2020-11-11 | 10260 | 131 | TRUE |
18041 | 18041 | Santa Clara | Santa Clara | 85 | 2020-11-11 | 28250 | 388 | |
18042 | 18042 | Santa Cruz | Santa Cruz | 87 | 2020-11-11 | 3227 | 26 | TRUE |
18043 | 18043 | Shasta | Shasta | 89 | 2020-11-11 | 2741 | 34 | TRUE |
18044 | 18044 | Sierra | Sierra | 91 | 2020-11-11 | 11 | 0 | TRUE |
18045 | 18045 | Siskiyou | Siskiyou | 93 | 2020-11-11 | 321 | 1 | TRUE |
18046 | 18046 | Solano | Solano | 95 | 2020-11-11 | 8430 | 79 | TRUE |
18047 | 18047 | Sonoma | Sonoma | 97 | 2020-11-11 | 10606 | 149 | |
18048 | 18048 | Stanislaus | Stanislaus | 99 | 2020-11-11 | 18711 | 410 | |
18049 | 18049 | Sutter | Sutter | 101 | 2020-11-11 | 2089 | 12 | TRUE |
18050 | 18050 | Tehama | Tehama | 103 | 2020-11-11 | 1084 | 19 | |
18051 | 18051 | Trinity | Trinity | 105 | 2020-11-11 | 62 | 0 | TRUE |
18052 | 18052 | Tulare | Tulare | 107 | 2020-11-11 | 18610 | 299 | TRUE |
18053 | 18053 | Tuolumne | Tuolumne | 109 | 2020-11-11 | 388 | 8 | |
18054 | 18054 | Ventura | Ventura | 111 | 2020-11-11 | 15459 | 171 | TRUE |
18055 | 18055 | Yolo | Yolo | 113 | 2020-11-11 | 3612 | 64 | |
18056 | 18056 | Yuba | Yuba | 115 | 2020-11-11 | 1494 | 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 );