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 2021-02-26 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 |
---|---|---|---|---|---|---|---|---|
11469 | 11469 | Alameda | Alameda | 1 | 2021-02-26 | 77478 | 1174 | |
11470 | 11470 | Berkeley | Alameda | 1 | 2021-02-26 | 3253 | 45 | |
11471 | 11471 | Alpine | Alpine | 3 | 2021-02-26 | 82 | 0 | |
11472 | 11472 | Amador | Amador | 5 | 2021-02-26 | 3408 | 41 | |
11473 | 11473 | Butte | Butte | 7 | 2021-02-26 | 10941 | 160 | |
11474 | 11474 | Calaveras | Calaveras | 9 | 2021-02-26 | 1905 | 47 | |
11475 | 11475 | Colusa | Colusa | 11 | 2021-02-26 | 2129 | 13 | |
11476 | 11476 | Contra Costa | Contra Costa | 13 | 2021-02-26 | 62367 | 674 | |
11477 | 11477 | Del Norte | Del Norte | 15 | 2021-02-26 | 994 | 5 | |
11478 | 11478 | El Dorado | El Dorado | 17 | 2021-02-26 | 9120 | 100 | |
11479 | 11479 | Fresno | Fresno | 19 | 2021-02-26 | 95635 | 1422 | |
11480 | 11480 | Glenn | Glenn | 21 | 2021-02-26 | 2181 | 23 | |
11481 | 11481 | Humboldt | Humboldt | 23 | 2021-02-26 | 3180 | 33 | |
11482 | 11482 | Imperial | Imperial | 25 | 2021-02-26 | 26594 | 593 | |
11483 | 11483 | Inyo | Inyo | 27 | 2021-02-26 | 1298 | 37 | |
11484 | 11484 | Kern | Kern | 29 | 2021-02-26 | 102998 | 826 | |
11485 | 11485 | Kings | Kings | 31 | 2021-02-26 | 22003 | 218 | |
11486 | 11486 | Lake | Lake | 33 | 2021-02-26 | 3117 | 41 | |
11487 | 11487 | Lassen | Lassen | 35 | 2021-02-26 | 5601 | 19 | |
11488 | 11488 | Long Beach | Los Angeles | 37 | 2021-02-26 | 51195 | 832 | |
11489 | 11489 | Los Angeles | Los Angeles | 37 | 2021-02-26 | 1127306 | 20100 | |
11490 | 11490 | Pasadena | Los Angeles | 37 | 2021-02-26 | 10862 | 314 | |
11491 | 11491 | Madera | Madera | 39 | 2021-02-26 | 15356 | 209 | |
11492 | 11492 | Marin | Marin | 41 | 2021-02-26 | 13178 | 197 | |
11493 | 11493 | Mariposa | Mariposa | 43 | 2021-02-26 | 395 | 7 | |
11494 | 11494 | Mendocino | Mendocino | 45 | 2021-02-26 | 3801 | 43 | |
11495 | 11495 | Merced | Merced | 47 | 2021-02-26 | 28971 | 397 | |
11496 | 11496 | Modoc | Modoc | 49 | 2021-02-26 | 453 | 4 | |
11497 | 11497 | Mono | Mono | 51 | 2021-02-26 | 1211 | 4 | TRUE |
11498 | 11498 | Monterey | Monterey | 53 | 2021-02-26 | 42199 | 328 | |
11499 | 11499 | Napa | Napa | 55 | 2021-02-26 | 8973 | 66 | |
11500 | 11500 | Nevada | Nevada | 57 | 2021-02-26 | 3940 | 74 | |
11501 | 11501 | Orange | Orange | 59 | 2021-02-26 | 245983 | 3892 | |
11502 | 11502 | Placer | Placer | 61 | 2021-02-26 | 19763 | 232 | |
11503 | 11503 | Plumas | Plumas | 63 | 2021-02-26 | 653 | 6 | TRUE |
11504 | 11504 | Riverside | Riverside | 65 | 2021-02-26 | 289450 | 3767 | |
11505 | 11505 | Sacramento | Sacramento | 67 | 2021-02-26 | 93160 | 1472 | |
11506 | 11506 | San Benito | San Benito | 69 | 2021-02-26 | 5671 | 59 | |
11507 | 11507 | San Bernardino | San Bernardino | 71 | 2021-02-26 | 286077 | 4606 | |
11508 | 11508 | San Diego | San Diego | 73 | 2021-02-26 | 259644 | 3271 | |
11509 | 11509 | San Francisco | San Francisco | 75 | 2021-02-26 | 33910 | 410 | |
11510 | 11510 | San Joaquin | San Joaquin | 77 | 2021-02-26 | 66709 | 1101 | |
11511 | 11511 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-26 | 19643 | 227 | |
11512 | 11512 | San Mateo | San Mateo | 81 | 2021-02-26 | 38674 | 515 | TRUE |
11513 | 11513 | Santa Barbara | Santa Barbara | 83 | 2021-02-26 | 31867 | 409 | |
11514 | 11514 | Santa Clara | Santa Clara | 85 | 2021-02-26 | 109919 | 1585 | |
11515 | 11515 | Santa Cruz | Santa Cruz | 87 | 2021-02-26 | 14628 | 183 | |
11516 | 11516 | Shasta | Shasta | 89 | 2021-02-26 | 10996 | 174 | |
11517 | 11517 | Sierra | Sierra | 91 | 2021-02-26 | 99 | 0 | |
11518 | 11518 | Siskiyou | Siskiyou | 93 | 2021-02-26 | 1755 | 14 | |
11519 | 11519 | Solano | Solano | 95 | 2021-02-26 | 30024 | 164 | |
11520 | 11520 | Sonoma | Sonoma | 97 | 2021-02-26 | 27925 | 298 | TRUE |
11521 | 11521 | Stanislaus | Stanislaus | 99 | 2021-02-26 | 50303 | 946 | |
11522 | 11522 | Sutter | Sutter | 101 | 2021-02-26 | 8860 | 97 | |
11523 | 11523 | Tehama | Tehama | 103 | 2021-02-26 | 5086 | 52 | |
11524 | 11524 | Trinity | Trinity | 105 | 2021-02-26 | 370 | 5 | |
11525 | 11525 | Tulare | Tulare | 107 | 2021-02-26 | 47869 | 758 | |
11526 | 11526 | Tuolumne | Tuolumne | 109 | 2021-02-26 | 3950 | 59 | |
11527 | 11527 | Ventura | Ventura | 111 | 2021-02-26 | 77256 | 844 | |
11528 | 11528 | Yolo | Yolo | 113 | 2021-02-26 | 12661 | 185 | |
11529 | 11529 | Yuba | Yuba | 115 | 2021-02-26 | 5750 | 37 |
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 );