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-08-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
428 | 428 | Alameda | Alameda | 1 | 2021-08-26 | 102015 | 1259 | |
429 | 429 | Berkeley | Alameda | 1 | 2021-08-26 | 4416 | 53 | |
430 | 430 | Alpine | Alpine | 3 | 2021-08-26 | 89 | 0 | TRUE |
431 | 431 | Amador | Amador | 5 | 2021-08-26 | 4377 | 53 | |
432 | 432 | Butte | Butte | 7 | 2021-08-26 | 15271 | 208 | |
433 | 433 | Calaveras | Calaveras | 9 | 2021-08-26 | 2729 | 61 | |
434 | 434 | Colusa | Colusa | 11 | 2021-08-26 | 2655 | 18 | TRUE |
435 | 435 | Contra Costa | Contra Costa | 13 | 2021-08-26 | 86188 | 863 | |
436 | 436 | Del Norte | Del Norte | 15 | 2021-08-26 | 2682 | 18 | TRUE |
437 | 437 | El Dorado | El Dorado | 17 | 2021-08-26 | 12919 | 122 | |
438 | 438 | Fresno | Fresno | 19 | 2021-08-26 | 113384 | 1761 | |
439 | 439 | Glenn | Glenn | 21 | 2021-08-26 | 2585 | 28 | |
440 | 440 | Humboldt | Humboldt | 23 | 2021-08-26 | 6855 | 65 | |
441 | 441 | Imperial | Imperial | 25 | 2021-08-26 | 29719 | 751 | |
442 | 442 | Inyo | Inyo | 27 | 2021-08-26 | 1538 | 39 | |
443 | 443 | Kern | Kern | 29 | 2021-08-26 | 122336 | 1453 | |
444 | 444 | Kings | Kings | 31 | 2021-08-26 | 25914 | 262 | |
445 | 445 | Lake | Lake | 33 | 2021-08-26 | 5163 | 74 | |
446 | 446 | Lassen | Lassen | 35 | 2021-08-26 | 6239 | 27 | |
447 | 447 | Long Beach | Los Angeles | 37 | 2021-08-26 | 60464 | 972 | |
448 | 448 | Los Angeles | Los Angeles | 37 | 2021-08-26 | 1321522 | 23856 | |
449 | 449 | Pasadena | Los Angeles | 37 | 2021-08-26 | 12646 | 354 | |
450 | 450 | Madera | Madera | 39 | 2021-08-26 | 18129 | 250 | TRUE |
451 | 451 | Marin | Marin | 41 | 2021-08-26 | 16128 | 215 | |
452 | 452 | Mariposa | Mariposa | 43 | 2021-08-26 | 769 | 10 | |
453 | 453 | Mendocino | Mendocino | 45 | 2021-08-26 | 5825 | 60 | |
454 | 454 | Merced | Merced | 47 | 2021-08-26 | 36113 | 506 | |
455 | 455 | Modoc | Modoc | 49 | 2021-08-26 | 606 | 7 | |
456 | 456 | Mono | Mono | 51 | 2021-08-26 | 1432 | 5 | |
457 | 457 | Monterey | Monterey | 53 | 2021-08-26 | 46197 | 542 | |
458 | 458 | Napa | Napa | 55 | 2021-08-26 | 11405 | 85 | |
459 | 459 | Nevada | Nevada | 57 | 2021-08-26 | 7011 | 85 | |
460 | 460 | Orange | Orange | 59 | 2021-08-26 | 282643 | 5197 | |
461 | 461 | Placer | Placer | 61 | 2021-08-26 | 28948 | 316 | |
462 | 462 | Plumas | Plumas | 63 | 2021-08-26 | 983 | 6 | |
463 | 463 | Riverside | Riverside | 65 | 2021-08-26 | 331416 | 4719 | |
464 | 464 | Sacramento | Sacramento | 67 | 2021-08-26 | 130125 | 1892 | |
465 | 465 | San Benito | San Benito | 69 | 2021-08-26 | 6636 | 65 | |
466 | 466 | San Bernardino | San Bernardino | 71 | 2021-08-26 | 326982 | 4908 | |
467 | 467 | San Diego | San Diego | 73 | 2021-08-26 | 328276 | 3869 | |
468 | 468 | San Francisco | San Francisco | 75 | 2021-08-26 | 45923 | 581 | |
469 | 469 | San Joaquin | San Joaquin | 77 | 2021-08-26 | 83466 | 1499 | TRUE |
470 | 470 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-26 | 24622 | 279 | TRUE |
471 | 471 | San Mateo | San Mateo | 81 | 2021-08-26 | 47875 | 594 | |
472 | 472 | Santa Barbara | Santa Barbara | 83 | 2021-08-26 | 38682 | 475 | |
473 | 473 | Santa Clara | Santa Clara | 85 | 2021-08-26 | 131941 | 1721 | |
474 | 474 | Santa Cruz | Santa Cruz | 87 | 2021-08-26 | 18095 | 210 | |
475 | 475 | Shasta | Shasta | 89 | 2021-08-26 | 15060 | 252 | |
476 | 476 | Sierra | Sierra | 91 | 2021-08-26 | 188 | 0 | |
477 | 477 | Siskiyou | Siskiyou | 93 | 2021-08-26 | 3159 | 40 | |
478 | 478 | Solano | Solano | 95 | 2021-08-26 | 39329 | 266 | TRUE |
479 | 479 | Sonoma | Sonoma | 97 | 2021-08-26 | 36158 | 349 | |
480 | 480 | Stanislaus | Stanislaus | 99 | 2021-08-26 | 65282 | 1129 | |
481 | 481 | Sutter | Sutter | 101 | 2021-08-26 | 11673 | 119 | |
482 | 482 | Tehama | Tehama | 103 | 2021-08-26 | 6682 | 68 | |
483 | 483 | Trinity | Trinity | 105 | 2021-08-26 | 622 | 8 | |
484 | 484 | Tulare | Tulare | 107 | 2021-08-26 | 53919 | 867 | |
485 | 485 | Tuolumne | Tuolumne | 109 | 2021-08-26 | 5569 | 87 | |
486 | 486 | Ventura | Ventura | 111 | 2021-08-26 | 89683 | 1068 | |
487 | 487 | Yolo | Yolo | 113 | 2021-08-26 | 16642 | 229 | |
488 | 488 | Yuba | Yuba | 115 | 2021-08-26 | 8317 | 49 |
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 );