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-12-26 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 |
---|---|---|---|---|---|---|---|---|
15251 | 15251 | Alameda | Alameda | 1 | 2020-12-26 | 47224 | 763 | |
15252 | 15252 | Berkeley | Alameda | 1 | 2020-12-26 | 1804 | 29 | TRUE |
15253 | 15253 | Alpine | Alpine | 3 | 2020-12-26 | 64 | 0 | TRUE |
15254 | 15254 | Amador | Amador | 5 | 2020-12-26 | 2281 | 23 | |
15255 | 15255 | Butte | Butte | 7 | 2020-12-26 | 6968 | 83 | TRUE |
15256 | 15256 | Calaveras | Calaveras | 9 | 2020-12-26 | 754 | 22 | TRUE |
15257 | 15257 | Colusa | Colusa | 11 | 2020-12-26 | 1214 | 8 | TRUE |
15258 | 15258 | Contra Costa | Contra Costa | 13 | 2020-12-26 | 38138 | 321 | |
15259 | 15259 | Del Norte | Del Norte | 15 | 2020-12-26 | 695 | 2 | TRUE |
15260 | 15260 | El Dorado | El Dorado | 17 | 2020-12-26 | 5095 | 13 | TRUE |
15261 | 15261 | Fresno | Fresno | 19 | 2020-12-26 | 67210 | 646 | |
15262 | 15262 | Glenn | Glenn | 21 | 2020-12-26 | 1336 | 14 | TRUE |
15263 | 15263 | Humboldt | Humboldt | 23 | 2020-12-26 | 1584 | 18 | |
15264 | 15264 | Imperial | Imperial | 25 | 2020-12-26 | 21241 | 406 | TRUE |
15265 | 15265 | Inyo | Inyo | 27 | 2020-12-26 | 575 | 20 | TRUE |
15266 | 15266 | Kern | Kern | 29 | 2020-12-26 | 63557 | 485 | |
15267 | 15267 | Kings | Kings | 31 | 2020-12-26 | 15548 | 110 | |
15268 | 15268 | Lake | Lake | 33 | 2020-12-26 | 1688 | 23 | TRUE |
15269 | 15269 | Lassen | Lassen | 35 | 2020-12-26 | 4180 | 8 | TRUE |
15270 | 15270 | Long Beach | Los Angeles | 37 | 2020-12-26 | 29197 | 349 | |
15271 | 15271 | Los Angeles | Los Angeles | 37 | 2020-12-26 | 672096 | 8941 | |
15272 | 15272 | Pasadena | Los Angeles | 37 | 2020-12-26 | 6170 | 151 | |
15273 | 15273 | Madera | Madera | 39 | 2020-12-26 | 9305 | 116 | TRUE |
15274 | 15274 | Marin | Marin | 41 | 2020-12-26 | 9505 | 136 | |
15275 | 15275 | Mariposa | Mariposa | 43 | 2020-12-26 | 219 | 4 | |
15276 | 15276 | Mendocino | Mendocino | 45 | 2020-12-26 | 2382 | 25 | TRUE |
15277 | 15277 | Merced | Merced | 47 | 2020-12-26 | 17785 | 232 | TRUE |
15278 | 15278 | Modoc | Modoc | 49 | 2020-12-26 | 307 | 0 | |
15279 | 15279 | Mono | Mono | 51 | 2020-12-26 | 857 | 4 | TRUE |
15280 | 15280 | Monterey | Monterey | 53 | 2020-12-26 | 25519 | 186 | |
15281 | 15281 | Napa | Napa | 55 | 2020-12-26 | 5091 | 26 | TRUE |
15282 | 15282 | Nevada | Nevada | 57 | 2020-12-26 | 2415 | 44 | TRUE |
15283 | 15283 | Orange | Orange | 59 | 2020-12-26 | 144263 | 1845 | |
15284 | 15284 | Placer | Placer | 61 | 2020-12-26 | 12262 | 120 | TRUE |
15285 | 15285 | Plumas | Plumas | 63 | 2020-12-26 | 455 | 2 | |
15286 | 15286 | Riverside | Riverside | 65 | 2020-12-26 | 158110 | 1829 | TRUE |
15287 | 15287 | Sacramento | Sacramento | 67 | 2020-12-26 | 59770 | 809 | TRUE |
15288 | 15288 | San Benito | San Benito | 69 | 2020-12-26 | 3365 | 26 | |
15289 | 15289 | San Bernardino | San Bernardino | 71 | 2020-12-26 | 178480 | 2425 | |
15290 | 15290 | San Diego | San Diego | 73 | 2020-12-26 | 142647 | 1402 | |
15291 | 15291 | San Francisco | San Francisco | 75 | 2020-12-26 | 21975 | 181 | |
15292 | 15292 | San Joaquin | San Joaquin | 77 | 2020-12-26 | 41104 | 618 | TRUE |
15293 | 15293 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-26 | 9471 | 67 | TRUE |
15294 | 15294 | San Mateo | San Mateo | 81 | 2020-12-26 | 22241 | 212 | TRUE |
15295 | 15295 | Santa Barbara | Santa Barbara | 83 | 2020-12-26 | 16083 | 153 | |
15296 | 15296 | Santa Clara | Santa Clara | 85 | 2020-12-26 | 67435 | 758 | |
15297 | 15297 | Santa Cruz | Santa Cruz | 87 | 2020-12-26 | 7352 | 76 | TRUE |
15298 | 15298 | Shasta | Shasta | 89 | 2020-12-26 | 7567 | 70 | TRUE |
15299 | 15299 | Sierra | Sierra | 91 | 2020-12-26 | 34 | 0 | TRUE |
15300 | 15300 | Siskiyou | Siskiyou | 93 | 2020-12-26 | 1076 | 8 | TRUE |
15301 | 15301 | Solano | Solano | 95 | 2020-12-26 | 17330 | 95 | TRUE |
15302 | 15302 | Sonoma | Sonoma | 97 | 2020-12-26 | 18147 | 182 | |
15303 | 15303 | Stanislaus | Stanislaus | 99 | 2020-12-26 | 32881 | 572 | |
15304 | 15304 | Sutter | Sutter | 101 | 2020-12-26 | 6037 | 46 | TRUE |
15305 | 15305 | Tehama | Tehama | 103 | 2020-12-26 | 3017 | 34 | TRUE |
15306 | 15306 | Trinity | Trinity | 105 | 2020-12-26 | 265 | 2 | TRUE |
15307 | 15307 | Tulare | Tulare | 107 | 2020-12-26 | 30422 | 373 | TRUE |
15308 | 15308 | Tuolumne | Tuolumne | 109 | 2020-12-26 | 2704 | 21 | TRUE |
15309 | 15309 | Ventura | Ventura | 111 | 2020-12-26 | 33401 | 233 | TRUE |
15310 | 15310 | Yolo | Yolo | 113 | 2020-12-26 | 7604 | 109 | |
15311 | 15311 | Yuba | Yuba | 115 | 2020-12-26 | 3628 | 17 | 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 );