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-24 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
550 | 550 | Alameda | Alameda | 1 | 2021-08-24 | 101111 | 1258 | |
551 | 551 | Berkeley | Alameda | 1 | 2021-08-24 | 4360 | 53 | |
552 | 552 | Alpine | Alpine | 3 | 2021-08-24 | 89 | 0 | TRUE |
553 | 553 | Amador | Amador | 5 | 2021-08-24 | 4342 | 50 | |
554 | 554 | Butte | Butte | 7 | 2021-08-24 | 15076 | 208 | |
555 | 555 | Calaveras | Calaveras | 9 | 2021-08-24 | 2688 | 61 | |
556 | 556 | Colusa | Colusa | 11 | 2021-08-24 | 2655 | 18 | TRUE |
557 | 557 | Contra Costa | Contra Costa | 13 | 2021-08-24 | 85338 | 854 | |
558 | 558 | Del Norte | Del Norte | 15 | 2021-08-24 | 2635 | 18 | |
559 | 559 | El Dorado | El Dorado | 17 | 2021-08-24 | 12798 | 122 | |
560 | 560 | Fresno | Fresno | 19 | 2021-08-24 | 112445 | 1759 | |
561 | 561 | Glenn | Glenn | 21 | 2021-08-24 | 2585 | 27 | |
562 | 562 | Humboldt | Humboldt | 23 | 2021-08-24 | 6643 | 62 | |
563 | 563 | Imperial | Imperial | 25 | 2021-08-24 | 29669 | 751 | |
564 | 564 | Inyo | Inyo | 27 | 2021-08-24 | 1520 | 39 | TRUE |
565 | 565 | Kern | Kern | 29 | 2021-08-24 | 121299 | 1448 | |
566 | 566 | Kings | Kings | 31 | 2021-08-24 | 25705 | 259 | |
567 | 567 | Lake | Lake | 33 | 2021-08-24 | 5099 | 69 | |
568 | 568 | Lassen | Lassen | 35 | 2021-08-24 | 6122 | 27 | TRUE |
569 | 569 | Long Beach | Los Angeles | 37 | 2021-08-24 | 60215 | 969 | |
570 | 570 | Los Angeles | Los Angeles | 37 | 2021-08-24 | 1315856 | 23794 | |
571 | 571 | Pasadena | Los Angeles | 37 | 2021-08-24 | 12601 | 354 | |
572 | 572 | Madera | Madera | 39 | 2021-08-24 | 18129 | 250 | |
573 | 573 | Marin | Marin | 41 | 2021-08-24 | 16033 | 215 | |
574 | 574 | Mariposa | Mariposa | 43 | 2021-08-24 | 749 | 10 | |
575 | 575 | Mendocino | Mendocino | 45 | 2021-08-24 | 5729 | 58 | |
576 | 576 | Merced | Merced | 47 | 2021-08-24 | 35820 | 502 | |
577 | 577 | Modoc | Modoc | 49 | 2021-08-24 | 599 | 7 | |
578 | 578 | Mono | Mono | 51 | 2021-08-24 | 1428 | 5 | |
579 | 579 | Monterey | Monterey | 53 | 2021-08-24 | 46035 | 542 | |
580 | 580 | Napa | Napa | 55 | 2021-08-24 | 11327 | 85 | |
581 | 581 | Nevada | Nevada | 57 | 2021-08-24 | 6785 | 81 | |
582 | 582 | Orange | Orange | 59 | 2021-08-24 | 281609 | 5184 | |
583 | 583 | Placer | Placer | 61 | 2021-08-24 | 28665 | 316 | |
584 | 584 | Plumas | Plumas | 63 | 2021-08-24 | 929 | 6 | |
585 | 585 | Riverside | Riverside | 65 | 2021-08-24 | 329184 | 4707 | |
586 | 586 | Sacramento | Sacramento | 67 | 2021-08-24 | 128853 | 1862 | |
587 | 587 | San Benito | San Benito | 69 | 2021-08-24 | 6610 | 65 | |
588 | 588 | San Bernardino | San Bernardino | 71 | 2021-08-24 | 325337 | 4901 | |
589 | 589 | San Diego | San Diego | 73 | 2021-08-24 | 325823 | 3851 | |
590 | 590 | San Francisco | San Francisco | 75 | 2021-08-24 | 45707 | 577 | |
591 | 591 | San Joaquin | San Joaquin | 77 | 2021-08-24 | 83121 | 1498 | TRUE |
592 | 592 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-24 | 24622 | 279 | |
593 | 593 | San Mateo | San Mateo | 81 | 2021-08-24 | 47703 | 594 | |
594 | 594 | Santa Barbara | Santa Barbara | 83 | 2021-08-24 | 38414 | 473 | |
595 | 595 | Santa Clara | Santa Clara | 85 | 2021-08-24 | 131272 | 1721 | |
596 | 596 | Santa Cruz | Santa Cruz | 87 | 2021-08-24 | 17792 | 209 | TRUE |
597 | 597 | Shasta | Shasta | 89 | 2021-08-24 | 14766 | 252 | |
598 | 598 | Sierra | Sierra | 91 | 2021-08-24 | 174 | 0 | TRUE |
599 | 599 | Siskiyou | Siskiyou | 93 | 2021-08-24 | 3059 | 40 | |
600 | 600 | Solano | Solano | 95 | 2021-08-24 | 39002 | 264 | TRUE |
601 | 601 | Sonoma | Sonoma | 97 | 2021-08-24 | 35664 | 344 | TRUE |
602 | 602 | Stanislaus | Stanislaus | 99 | 2021-08-24 | 64706 | 1120 | |
603 | 603 | Sutter | Sutter | 101 | 2021-08-24 | 11519 | 118 | |
604 | 604 | Tehama | Tehama | 103 | 2021-08-24 | 6605 | 67 | |
605 | 605 | Trinity | Trinity | 105 | 2021-08-24 | 597 | 8 | |
606 | 606 | Tulare | Tulare | 107 | 2021-08-24 | 53129 | 855 | |
607 | 607 | Tuolumne | Tuolumne | 109 | 2021-08-24 | 5465 | 87 | |
608 | 608 | Ventura | Ventura | 111 | 2021-08-24 | 89239 | 1061 | |
609 | 609 | Yolo | Yolo | 113 | 2021-08-24 | 16458 | 229 | |
610 | 610 | Yuba | Yuba | 115 | 2021-08-24 | 8179 | 47 |
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 );