latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 1,026
- Alameda 678
- Orange 366
- Santa Clara 366
- San Benito 361
- Humboldt 344
- Sacramento 344
- Solano 340
- Calaveras 339
- Contra Costa 339
- Marin 339
- Placer 339
- Riverside 339
- San Diego 339
- San Francisco 339
- San Mateo 339
- Santa Cruz 339
- Shasta 339
- Sonoma 339
- Stanislaus 339
- Ventura 339
- Yolo 339
- Fresno 335
- San Joaquin 331
- Madera 325
- Imperial 321
- Tulare 321
- Amador 319
- San Luis Obispo 318
- San Bernardino 317
- …
agency >30
- Los Angeles 366
- Orange 366
- Santa Clara 366
- San Benito 361
- Humboldt 344
- Sacramento 344
- Solano 340
- Alameda 339
- Berkeley 339
- Calaveras 339
- Contra Costa 339
- Long Beach 339
- Marin 339
- Placer 339
- Riverside 339
- San Diego 339
- San Francisco 339
- San Mateo 339
- Santa Cruz 339
- Shasta 339
- Sonoma 339
- Stanislaus 339
- Ventura 339
- Yolo 339
- Fresno 335
- San Joaquin 331
- Madera 325
- Imperial 321
- Pasadena 321
- Tulare 321
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
13421 | 13421 | Alameda | Alameda | 1 | 2021-01-25 | 68821 | 1083 | |
13422 | 13422 | Berkeley | Alameda | 1 | 2021-01-25 | 2549 | 42 | |
13423 | 13423 | Alpine | Alpine | 3 | 2021-01-25 | 73 | 0 | |
13424 | 13424 | Amador | Amador | 5 | 2021-01-25 | 3067 | 33 | |
13425 | 13425 | Butte | Butte | 7 | 2021-01-25 | 9865 | 136 | |
13426 | 13426 | Calaveras | Calaveras | 9 | 2021-01-25 | 1598 | 23 | |
13427 | 13427 | Colusa | Colusa | 11 | 2021-01-25 | 1871 | 9 | |
13428 | 13428 | Contra Costa | Contra Costa | 13 | 2021-01-25 | 55245 | 489 | |
13429 | 13429 | Del Norte | Del Norte | 15 | 2021-01-25 | 874 | 2 | |
13430 | 13430 | El Dorado | El Dorado | 17 | 2021-01-25 | 8184 | 62 | |
13431 | 13431 | Fresno | Fresno | 19 | 2021-01-25 | 89198 | 1067 | |
13432 | 13432 | Glenn | Glenn | 21 | 2021-01-25 | 1965 | 22 | |
13433 | 13433 | Humboldt | Humboldt | 23 | 2021-01-25 | 2624 | 27 | |
13434 | 13434 | Imperial | Imperial | 25 | 2021-01-25 | 25646 | 510 | |
13435 | 13435 | Inyo | Inyo | 27 | 2021-01-25 | 1051 | 29 | |
13436 | 13436 | Kern | Kern | 29 | 2021-01-25 | 90564 | 591 | |
13437 | 13437 | Kings | Kings | 31 | 2021-01-25 | 20138 | 161 | |
13438 | 13438 | Lake | Lake | 33 | 2021-01-25 | 2705 | 32 | |
13439 | 13439 | Lassen | Lassen | 35 | 2021-01-25 | 5269 | 16 | TRUE |
13440 | 13440 | Long Beach | Los Angeles | 37 | 2021-01-25 | 46477 | 596 | |
13441 | 13441 | Los Angeles | Los Angeles | 37 | 2021-01-25 | 1023339 | 14481 | |
13442 | 13442 | Pasadena | Los Angeles | 37 | 2021-01-25 | 9856 | 237 | |
13443 | 13443 | Madera | Madera | 39 | 2021-01-25 | 13943 | 151 | |
13444 | 13444 | Marin | Marin | 41 | 2021-01-25 | 12024 | 165 | |
13445 | 13445 | Mariposa | Mariposa | 43 | 2021-01-25 | 355 | 5 | |
13446 | 13446 | Mendocino | Mendocino | 45 | 2021-01-25 | 3293 | 36 | |
13447 | 13447 | Merced | Merced | 47 | 2021-01-25 | 25575 | 331 | |
13448 | 13448 | Modoc | Modoc | 49 | 2021-01-25 | 390 | 3 | TRUE |
13449 | 13449 | Mono | Mono | 51 | 2021-01-25 | 1145 | 4 | |
13450 | 13450 | Monterey | Monterey | 53 | 2021-01-25 | 37285 | 259 | TRUE |
13451 | 13451 | Napa | Napa | 55 | 2021-01-25 | 7987 | 48 | |
13452 | 13452 | Nevada | Nevada | 57 | 2021-01-25 | 3355 | 73 | |
13453 | 13453 | Orange | Orange | 59 | 2021-01-25 | 224618 | 2704 | |
13454 | 13454 | Placer | Placer | 61 | 2021-01-25 | 17675 | 188 | TRUE |
13455 | 13455 | Plumas | Plumas | 63 | 2021-01-25 | 613 | 5 | |
13456 | 13456 | Riverside | Riverside | 65 | 2021-01-25 | 264363 | 2857 | |
13457 | 13457 | Sacramento | Sacramento | 67 | 2021-01-25 | 83530 | 1185 | |
13458 | 13458 | San Benito | San Benito | 69 | 2021-01-25 | 5172 | 51 | |
13459 | 13459 | San Bernardino | San Bernardino | 71 | 2021-01-25 | 266028 | 3963 | |
13460 | 13460 | San Diego | San Diego | 73 | 2021-01-25 | 228632 | 2375 | |
13461 | 13461 | San Francisco | San Francisco | 75 | 2021-01-25 | 29991 | 293 | |
13462 | 13462 | San Joaquin | San Joaquin | 77 | 2021-01-25 | 59665 | 835 | |
13463 | 13463 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-25 | 16957 | 158 | |
13464 | 13464 | San Mateo | San Mateo | 81 | 2021-01-25 | 34294 | 340 | |
13465 | 13465 | Santa Barbara | Santa Barbara | 83 | 2021-01-25 | 27149 | 267 | |
13466 | 13466 | Santa Clara | Santa Clara | 85 | 2021-01-25 | 99911 | 1312 | |
13467 | 13467 | Santa Cruz | Santa Cruz | 87 | 2021-01-25 | 13009 | 135 | |
13468 | 13468 | Shasta | Shasta | 89 | 2021-01-25 | 10054 | 129 | |
13469 | 13469 | Sierra | Sierra | 91 | 2021-01-25 | 95 | 0 | |
13470 | 13470 | Siskiyou | Siskiyou | 93 | 2021-01-25 | 1499 | 13 | |
13471 | 13471 | Solano | Solano | 95 | 2021-01-25 | 27041 | 115 | |
13472 | 13472 | Sonoma | Sonoma | 97 | 2021-01-25 | 25141 | 251 | |
13473 | 13473 | Stanislaus | Stanislaus | 99 | 2021-01-25 | 44442 | 796 | |
13474 | 13474 | Sutter | Sutter | 101 | 2021-01-25 | 8069 | 83 | |
13475 | 13475 | Tehama | Tehama | 103 | 2021-01-25 | 4468 | 46 | TRUE |
13476 | 13476 | Trinity | Trinity | 105 | 2021-01-25 | 306 | 5 | |
13477 | 13477 | Tulare | Tulare | 107 | 2021-01-25 | 43574 | 542 | |
13478 | 13478 | Tuolumne | Tuolumne | 109 | 2021-01-25 | 3477 | 40 | |
13479 | 13479 | Ventura | Ventura | 111 | 2021-01-25 | 66402 | 525 | |
13480 | 13480 | Yolo | Yolo | 113 | 2021-01-25 | 11096 | 138 | |
13481 | 13481 | Yuba | Yuba | 115 | 2021-01-25 | 5176 | 30 | |
13482 | 13482 | Alameda | Alameda | 1 | 2021-01-24 | 68411 | 1073 | |
13483 | 13483 | Berkeley | Alameda | 1 | 2021-01-24 | 2530 | 42 | |
13484 | 13484 | Alpine | Alpine | 3 | 2021-01-24 | 73 | 0 | TRUE |
13485 | 13485 | Amador | Amador | 5 | 2021-01-24 | 3045 | 32 | |
13486 | 13486 | Butte | Butte | 7 | 2021-01-24 | 9820 | 134 | TRUE |
13487 | 13487 | Calaveras | Calaveras | 9 | 2021-01-24 | 1407 | 23 | TRUE |
13488 | 13488 | Colusa | Colusa | 11 | 2021-01-24 | 1854 | 9 | TRUE |
13489 | 13489 | Contra Costa | Contra Costa | 13 | 2021-01-24 | 54951 | 489 | |
13490 | 13490 | Del Norte | Del Norte | 15 | 2021-01-24 | 873 | 2 | |
13491 | 13491 | El Dorado | El Dorado | 17 | 2021-01-24 | 8002 | 59 | TRUE |
13492 | 13492 | Fresno | Fresno | 19 | 2021-01-24 | 88761 | 1043 | TRUE |
13493 | 13493 | Glenn | Glenn | 21 | 2021-01-24 | 1927 | 22 | TRUE |
13494 | 13494 | Humboldt | Humboldt | 23 | 2021-01-24 | 2494 | 25 | TRUE |
13495 | 13495 | Imperial | Imperial | 25 | 2021-01-24 | 25445 | 493 | TRUE |
13496 | 13496 | Inyo | Inyo | 27 | 2021-01-24 | 1007 | 29 | TRUE |
13497 | 13497 | Kern | Kern | 29 | 2021-01-24 | 90213 | 590 | |
13498 | 13498 | Kings | Kings | 31 | 2021-01-24 | 19703 | 160 | TRUE |
13499 | 13499 | Lake | Lake | 33 | 2021-01-24 | 2656 | 32 | TRUE |
13500 | 13500 | Lassen | Lassen | 35 | 2021-01-24 | 5269 | 16 | TRUE |
13501 | 13501 | Long Beach | Los Angeles | 37 | 2021-01-24 | 46281 | 596 | TRUE |
13502 | 13502 | Los Angeles | Los Angeles | 37 | 2021-01-24 | 1017099 | 14440 | |
13503 | 13503 | Pasadena | Los Angeles | 37 | 2021-01-24 | 9776 | 226 | |
13504 | 13504 | Madera | Madera | 39 | 2021-01-24 | 13583 | 151 | TRUE |
13505 | 13505 | Marin | Marin | 41 | 2021-01-24 | 11954 | 163 | |
13506 | 13506 | Mariposa | Mariposa | 43 | 2021-01-24 | 351 | 4 | |
13507 | 13507 | Mendocino | Mendocino | 45 | 2021-01-24 | 3277 | 36 | |
13508 | 13508 | Merced | Merced | 47 | 2021-01-24 | 25048 | 324 | TRUE |
13509 | 13509 | Modoc | Modoc | 49 | 2021-01-24 | 390 | 3 | |
13510 | 13510 | Mono | Mono | 51 | 2021-01-24 | 1135 | 4 | TRUE |
13511 | 13511 | Monterey | Monterey | 53 | 2021-01-24 | 37285 | 259 | TRUE |
13512 | 13512 | Napa | Napa | 55 | 2021-01-24 | 7761 | 45 | TRUE |
13513 | 13513 | Nevada | Nevada | 57 | 2021-01-24 | 3292 | 73 | TRUE |
13514 | 13514 | Orange | Orange | 59 | 2021-01-24 | 223288 | 2638 | |
13515 | 13515 | Placer | Placer | 61 | 2021-01-24 | 17675 | 188 | TRUE |
13516 | 13516 | Plumas | Plumas | 63 | 2021-01-24 | 605 | 5 | TRUE |
13517 | 13517 | Riverside | Riverside | 65 | 2021-01-24 | 258352 | 2777 | TRUE |
13518 | 13518 | Sacramento | Sacramento | 67 | 2021-01-24 | 82066 | 1157 | TRUE |
13519 | 13519 | San Benito | San Benito | 69 | 2021-01-24 | 5156 | 48 | |
13520 | 13520 | San Bernardino | San Bernardino | 71 | 2021-01-24 | 264457 | 3929 |
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 );