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-07-29 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 |
---|---|---|---|---|---|---|---|---|
24401 | 24401 | Alameda | Alameda | 1 | 2020-07-29 | 10795 | 228 | |
24402 | 24402 | Berkeley | Alameda | 1 | 2020-07-29 | 388 | 7 | |
24403 | 24403 | Alpine | Alpine | 3 | 2020-07-29 | 2 | 0 | TRUE |
24404 | 24404 | Amador | Amador | 5 | 2020-07-29 | 110 | 0 | |
24405 | 24405 | Butte | Butte | 7 | 2020-07-29 | 889 | 7 | |
24406 | 24406 | Calaveras | Calaveras | 9 | 2020-07-29 | 108 | 1 | TRUE |
24407 | 24407 | Colusa | Colusa | 11 | 2020-07-29 | 304 | 3 | |
24408 | 24408 | Contra Costa | Contra Costa | 13 | 2020-07-29 | 7491 | 116 | |
24409 | 24409 | Del Norte | Del Norte | 15 | 2020-07-29 | 88 | 0 | |
24410 | 24410 | El Dorado | El Dorado | 17 | 2020-07-29 | 589 | 1 | |
24411 | 24411 | Fresno | Fresno | 19 | 2020-07-29 | 21019 | 120 | |
24412 | 24412 | Glenn | Glenn | 21 | 2020-07-29 | 311 | 1 | |
24413 | 24413 | Humboldt | Humboldt | 23 | 2020-07-29 | 228 | 4 | |
24414 | 24414 | Imperial | Imperial | 25 | 2020-07-29 | 9241 | 188 | |
24415 | 24415 | Inyo | Inyo | 27 | 2020-07-29 | 47 | 1 | |
24416 | 24416 | Kern | Kern | 29 | 2020-07-29 | 17344 | 135 | |
24417 | 24417 | Kings | Kings | 31 | 2020-07-29 | 4106 | 51 | |
24418 | 24418 | Lake | Lake | 33 | 2020-07-29 | 181 | 1 | |
24419 | 24419 | Lassen | Lassen | 35 | 2020-07-29 | 594 | 0 | |
24420 | 24420 | Long Beach | Los Angeles | 37 | 2020-07-29 | 7948 | 170 | |
24421 | 24421 | Los Angeles | Los Angeles | 37 | 2020-07-29 | 173565 | 4243 | |
24422 | 24422 | Pasadena | Los Angeles | 37 | 2020-07-29 | 1943 | 105 | |
24423 | 24423 | Madera | Madera | 39 | 2020-07-29 | 1850 | 28 | |
24424 | 24424 | Marin | Marin | 41 | 2020-07-29 | 4874 | 64 | |
24425 | 24425 | Mariposa | Mariposa | 43 | 2020-07-29 | 51 | 2 | |
24426 | 24426 | Mendocino | Mendocino | 45 | 2020-07-29 | 293 | 6 | |
24427 | 24427 | Merced | Merced | 47 | 2020-07-29 | 3906 | 35 | |
24428 | 24428 | Modoc | Modoc | 49 | 2020-07-29 | 2 | 0 | |
24429 | 24429 | Mono | Mono | 51 | 2020-07-29 | 124 | 1 | |
24430 | 24430 | Monterey | Monterey | 53 | 2020-07-29 | 4288 | 26 | |
24431 | 24431 | Napa | Napa | 55 | 2020-07-29 | 860 | 8 | |
24432 | 24432 | Nevada | Nevada | 57 | 2020-07-29 | 288 | 1 | |
24433 | 24433 | Orange | Orange | 59 | 2020-07-29 | 35272 | 587 | |
24434 | 24434 | Placer | Placer | 61 | 2020-07-29 | 1790 | 15 | |
24435 | 24435 | Plumas | Plumas | 63 | 2020-07-29 | 31 | 0 | |
24436 | 24436 | Riverside | Riverside | 65 | 2020-07-29 | 36159 | 682 | |
24437 | 24437 | Sacramento | Sacramento | 67 | 2020-07-29 | 9514 | 126 | |
24438 | 24438 | San Benito | San Benito | 69 | 2020-07-29 | 601 | 4 | |
24439 | 24439 | San Bernardino | San Bernardino | 71 | 2020-07-29 | 30825 | 682 | |
24440 | 24440 | San Diego | San Diego | 73 | 2020-07-29 | 28287 | 552 | |
24441 | 24441 | San Francisco | San Francisco | 75 | 2020-07-29 | 6197 | 57 | |
24442 | 24442 | San Joaquin | San Joaquin | 77 | 2020-07-29 | 11209 | 146 | |
24443 | 24443 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-29 | 1710 | 12 | |
24444 | 24444 | San Mateo | San Mateo | 81 | 2020-07-29 | 5306 | 118 | |
24445 | 24445 | Santa Barbara | Santa Barbara | 83 | 2020-07-29 | 6021 | 32 | |
24446 | 24446 | Santa Clara | Santa Clara | 85 | 2020-07-29 | 11515 | 194 | |
24447 | 24447 | Santa Cruz | Santa Cruz | 87 | 2020-07-29 | 1030 | 4 | |
24448 | 24448 | Shasta | Shasta | 89 | 2020-07-29 | 348 | 8 | |
24449 | 24449 | Sierra | Sierra | 91 | 2020-07-29 | 2 | 0 | |
24450 | 24450 | Siskiyou | Siskiyou | 93 | 2020-07-29 | 69 | 0 | |
24451 | 24451 | Solano | Solano | 95 | 2020-07-29 | 3462 | 37 | |
24452 | 24452 | Sonoma | Sonoma | 97 | 2020-07-29 | 2748 | 31 | |
24453 | 24453 | Stanislaus | Stanislaus | 99 | 2020-07-29 | 8492 | 103 | |
24454 | 24454 | Sutter | Sutter | 101 | 2020-07-29 | 731 | 6 | |
24455 | 24455 | Tehama | Tehama | 103 | 2020-07-29 | 219 | 1 | |
24456 | 24456 | Trinity | Trinity | 105 | 2020-07-29 | 4 | 0 | |
24457 | 24457 | Tulare | Tulare | 107 | 2020-07-29 | 9076 | 173 | |
24458 | 24458 | Tuolumne | Tuolumne | 109 | 2020-07-29 | 132 | 2 | |
24459 | 24459 | Ventura | Ventura | 111 | 2020-07-29 | 6997 | 73 | |
24460 | 24460 | Yolo | Yolo | 113 | 2020-07-29 | 1477 | 41 | |
24461 | 24461 | Yuba | Yuba | 115 | 2020-07-29 | 441 | 4 |
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 );