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-25 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 |
---|---|---|---|---|---|---|---|---|
15312 | 15312 | Alameda | Alameda | 1 | 2020-12-25 | 46528 | 752 | TRUE |
15313 | 15313 | Berkeley | Alameda | 1 | 2020-12-25 | 1794 | 29 | TRUE |
15314 | 15314 | Alpine | Alpine | 3 | 2020-12-25 | 64 | 0 | TRUE |
15315 | 15315 | Amador | Amador | 5 | 2020-12-25 | 2219 | 23 | |
15316 | 15316 | Butte | Butte | 7 | 2020-12-25 | 6873 | 83 | TRUE |
15317 | 15317 | Calaveras | Calaveras | 9 | 2020-12-25 | 754 | 22 | TRUE |
15318 | 15318 | Colusa | Colusa | 11 | 2020-12-25 | 1214 | 8 | TRUE |
15319 | 15319 | Contra Costa | Contra Costa | 13 | 2020-12-25 | 37610 | 321 | |
15320 | 15320 | Del Norte | Del Norte | 15 | 2020-12-25 | 695 | 2 | TRUE |
15321 | 15321 | El Dorado | El Dorado | 17 | 2020-12-25 | 5095 | 13 | TRUE |
15322 | 15322 | Fresno | Fresno | 19 | 2020-12-25 | 66349 | 646 | TRUE |
15323 | 15323 | Glenn | Glenn | 21 | 2020-12-25 | 1336 | 14 | TRUE |
15324 | 15324 | Humboldt | Humboldt | 23 | 2020-12-25 | 1539 | 17 | TRUE |
15325 | 15325 | Imperial | Imperial | 25 | 2020-12-25 | 21241 | 406 | TRUE |
15326 | 15326 | Inyo | Inyo | 27 | 2020-12-25 | 575 | 20 | |
15327 | 15327 | Kern | Kern | 29 | 2020-12-25 | 63044 | 485 | |
15328 | 15328 | Kings | Kings | 31 | 2020-12-25 | 15491 | 110 | |
15329 | 15329 | Lake | Lake | 33 | 2020-12-25 | 1688 | 23 | |
15330 | 15330 | Lassen | Lassen | 35 | 2020-12-25 | 4180 | 8 | TRUE |
15331 | 15331 | Long Beach | Los Angeles | 37 | 2020-12-25 | 28460 | 347 | TRUE |
15332 | 15332 | Los Angeles | Los Angeles | 37 | 2020-12-25 | 643688 | 8808 | TRUE |
15333 | 15333 | Pasadena | Los Angeles | 37 | 2020-12-25 | 5892 | 150 | TRUE |
15334 | 15334 | Madera | Madera | 39 | 2020-12-25 | 9305 | 116 | TRUE |
15335 | 15335 | Marin | Marin | 41 | 2020-12-25 | 9449 | 136 | |
15336 | 15336 | Mariposa | Mariposa | 43 | 2020-12-25 | 212 | 4 | TRUE |
15337 | 15337 | Mendocino | Mendocino | 45 | 2020-12-25 | 2314 | 25 | TRUE |
15338 | 15338 | Merced | Merced | 47 | 2020-12-25 | 17785 | 232 | TRUE |
15339 | 15339 | Modoc | Modoc | 49 | 2020-12-25 | 293 | 0 | TRUE |
15340 | 15340 | Mono | Mono | 51 | 2020-12-25 | 857 | 4 | |
15341 | 15341 | Monterey | Monterey | 53 | 2020-12-25 | 24538 | 185 | TRUE |
15342 | 15342 | Napa | Napa | 55 | 2020-12-25 | 5091 | 26 | TRUE |
15343 | 15343 | Nevada | Nevada | 57 | 2020-12-25 | 2415 | 44 | TRUE |
15344 | 15344 | Orange | Orange | 59 | 2020-12-25 | 138310 | 1782 | TRUE |
15345 | 15345 | Placer | Placer | 61 | 2020-12-25 | 12262 | 120 | TRUE |
15346 | 15346 | Plumas | Plumas | 63 | 2020-12-25 | 443 | 2 | TRUE |
15347 | 15347 | Riverside | Riverside | 65 | 2020-12-25 | 158110 | 1829 | |
15348 | 15348 | Sacramento | Sacramento | 67 | 2020-12-25 | 59770 | 809 | TRUE |
15349 | 15349 | San Benito | San Benito | 69 | 2020-12-25 | 3288 | 26 | |
15350 | 15350 | San Bernardino | San Bernardino | 71 | 2020-12-25 | 174091 | 2369 | TRUE |
15351 | 15351 | San Diego | San Diego | 73 | 2020-12-25 | 139961 | 1402 | |
15352 | 15352 | San Francisco | San Francisco | 75 | 2020-12-25 | 21709 | 181 | |
15353 | 15353 | San Joaquin | San Joaquin | 77 | 2020-12-25 | 41104 | 618 | TRUE |
15354 | 15354 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-25 | 9471 | 67 | TRUE |
15355 | 15355 | San Mateo | San Mateo | 81 | 2020-12-25 | 22241 | 212 | TRUE |
15356 | 15356 | Santa Barbara | Santa Barbara | 83 | 2020-12-25 | 15657 | 151 | TRUE |
15357 | 15357 | Santa Clara | Santa Clara | 85 | 2020-12-25 | 66440 | 739 | TRUE |
15358 | 15358 | Santa Cruz | Santa Cruz | 87 | 2020-12-25 | 7352 | 76 | TRUE |
15359 | 15359 | Shasta | Shasta | 89 | 2020-12-25 | 7567 | 70 | TRUE |
15360 | 15360 | Sierra | Sierra | 91 | 2020-12-25 | 34 | 0 | TRUE |
15361 | 15361 | Siskiyou | Siskiyou | 93 | 2020-12-25 | 1076 | 8 | TRUE |
15362 | 15362 | Solano | Solano | 95 | 2020-12-25 | 17330 | 95 | TRUE |
15363 | 15363 | Sonoma | Sonoma | 97 | 2020-12-25 | 17903 | 181 | |
15364 | 15364 | Stanislaus | Stanislaus | 99 | 2020-12-25 | 31914 | 565 | TRUE |
15365 | 15365 | Sutter | Sutter | 101 | 2020-12-25 | 6037 | 46 | TRUE |
15366 | 15366 | Tehama | Tehama | 103 | 2020-12-25 | 3017 | 34 | |
15367 | 15367 | Trinity | Trinity | 105 | 2020-12-25 | 265 | 2 | TRUE |
15368 | 15368 | Tulare | Tulare | 107 | 2020-12-25 | 30422 | 373 | TRUE |
15369 | 15369 | Tuolumne | Tuolumne | 109 | 2020-12-25 | 2704 | 21 | TRUE |
15370 | 15370 | Ventura | Ventura | 111 | 2020-12-25 | 33401 | 233 | TRUE |
15371 | 15371 | Yolo | Yolo | 113 | 2020-12-25 | 7501 | 109 | TRUE |
15372 | 15372 | Yuba | Yuba | 115 | 2020-12-25 | 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 );