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-09 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 |
---|---|---|---|---|---|---|---|---|
16288 | 16288 | Alameda | Alameda | 1 | 2020-12-09 | 34033 | 587 | |
16289 | 16289 | Berkeley | Alameda | 1 | 2020-12-09 | 1427 | 15 | |
16290 | 16290 | Alpine | Alpine | 3 | 2020-12-09 | 57 | 0 | TRUE |
16291 | 16291 | Amador | Amador | 5 | 2020-12-09 | 1203 | 18 | |
16292 | 16292 | Butte | Butte | 7 | 2020-12-09 | 4733 | 62 | |
16293 | 16293 | Calaveras | Calaveras | 9 | 2020-12-09 | 588 | 22 | TRUE |
16294 | 16294 | Colusa | Colusa | 11 | 2020-12-09 | 895 | 7 | |
16295 | 16295 | Contra Costa | Contra Costa | 13 | 2020-12-09 | 28391 | 270 | |
16296 | 16296 | Del Norte | Del Norte | 15 | 2020-12-09 | 506 | 1 | |
16297 | 16297 | El Dorado | El Dorado | 17 | 2020-12-09 | 3529 | 8 | |
16298 | 16298 | Fresno | Fresno | 19 | 2020-12-09 | 52591 | 514 | |
16299 | 16299 | Glenn | Glenn | 21 | 2020-12-09 | 1117 | 11 | |
16300 | 16300 | Humboldt | Humboldt | 23 | 2020-12-09 | 1163 | 10 | |
16301 | 16301 | Imperial | Imperial | 25 | 2020-12-09 | 17733 | 367 | |
16302 | 16302 | Inyo | Inyo | 27 | 2020-12-09 | 357 | 16 | |
16303 | 16303 | Kern | Kern | 29 | 2020-12-09 | 47411 | 463 | |
16304 | 16304 | Kings | Kings | 31 | 2020-12-09 | 12716 | 97 | |
16305 | 16305 | Lake | Lake | 33 | 2020-12-09 | 1161 | 21 | |
16306 | 16306 | Lassen | Lassen | 35 | 2020-12-09 | 2930 | 5 | |
16307 | 16307 | Long Beach | Los Angeles | 37 | 2020-12-09 | 19608 | 288 | |
16308 | 16308 | Los Angeles | Los Angeles | 37 | 2020-12-09 | 451756 | 7651 | |
16309 | 16309 | Pasadena | Los Angeles | 37 | 2020-12-09 | 4414 | 138 | |
16310 | 16310 | Madera | Madera | 39 | 2020-12-09 | 7251 | 107 | |
16311 | 16311 | Marin | Marin | 41 | 2020-12-09 | 8249 | 132 | |
16312 | 16312 | Mariposa | Mariposa | 43 | 2020-12-09 | 167 | 4 | |
16313 | 16313 | Mendocino | Mendocino | 45 | 2020-12-09 | 1873 | 24 | |
16314 | 16314 | Merced | Merced | 47 | 2020-12-09 | 14058 | 201 | |
16315 | 16315 | Modoc | Modoc | 49 | 2020-12-09 | 212 | 0 | |
16316 | 16316 | Mono | Mono | 51 | 2020-12-09 | 656 | 3 | |
16317 | 16317 | Monterey | Monterey | 53 | 2020-12-09 | 16966 | 146 | |
16318 | 16318 | Napa | Napa | 55 | 2020-12-09 | 3813 | 22 | |
16319 | 16319 | Nevada | Nevada | 57 | 2020-12-09 | 1895 | 19 | |
16320 | 16320 | Orange | Orange | 59 | 2020-12-09 | 93126 | 1633 | |
16321 | 16321 | Placer | Placer | 61 | 2020-12-09 | 8544 | 85 | |
16322 | 16322 | Plumas | Plumas | 63 | 2020-12-09 | 311 | 0 | |
16323 | 16323 | Riverside | Riverside | 65 | 2020-12-09 | 107324 | 1539 | |
16324 | 16324 | Sacramento | Sacramento | 67 | 2020-12-09 | 45336 | 646 | |
16325 | 16325 | San Benito | San Benito | 69 | 2020-12-09 | 2264 | 19 | |
16326 | 16326 | San Bernardino | San Bernardino | 71 | 2020-12-09 | 111518 | 1695 | |
16327 | 16327 | San Diego | San Diego | 73 | 2020-12-09 | 97549 | 1103 | |
16328 | 16328 | San Francisco | San Francisco | 75 | 2020-12-09 | 17384 | 164 | |
16329 | 16329 | San Joaquin | San Joaquin | 77 | 2020-12-09 | 30579 | 532 | |
16330 | 16330 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-09 | 7071 | 45 | |
16331 | 16331 | San Mateo | San Mateo | 81 | 2020-12-09 | 16666 | 177 | |
16332 | 16332 | Santa Barbara | Santa Barbara | 83 | 2020-12-09 | 12636 | 139 | |
16333 | 16333 | Santa Clara | Santa Clara | 85 | 2020-12-09 | 48256 | 502 | |
16334 | 16334 | Santa Cruz | Santa Cruz | 87 | 2020-12-09 | 5388 | 47 | |
16335 | 16335 | Shasta | Shasta | 89 | 2020-12-09 | 6135 | 54 | |
16336 | 16336 | Sierra | Sierra | 91 | 2020-12-09 | 25 | 0 | |
16337 | 16337 | Siskiyou | Siskiyou | 93 | 2020-12-09 | 863 | 7 | |
16338 | 16338 | Solano | Solano | 95 | 2020-12-09 | 12123 | 90 | |
16339 | 16339 | Sonoma | Sonoma | 97 | 2020-12-09 | 13912 | 162 | |
16340 | 16340 | Stanislaus | Stanislaus | 99 | 2020-12-09 | 25271 | 454 | |
16341 | 16341 | Sutter | Sutter | 101 | 2020-12-09 | 4502 | 30 | |
16342 | 16342 | Tehama | Tehama | 103 | 2020-12-09 | 2148 | 30 | |
16343 | 16343 | Trinity | Trinity | 105 | 2020-12-09 | 217 | 1 | |
16344 | 16344 | Tulare | Tulare | 107 | 2020-12-09 | 24239 | 323 | |
16345 | 16345 | Tuolumne | Tuolumne | 109 | 2020-12-09 | 1458 | 15 | |
16346 | 16346 | Ventura | Ventura | 111 | 2020-12-09 | 23643 | 197 | |
16347 | 16347 | Yolo | Yolo | 113 | 2020-12-09 | 5639 | 88 | |
16348 | 16348 | Yuba | Yuba | 115 | 2020-12-09 | 2700 | 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 );