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-01-21 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 |
---|---|---|---|---|---|---|---|---|
13665 | 13665 | Alameda | Alameda | 1 | 2021-01-21 | 66931 | 1050 | |
13666 | 13666 | Berkeley | Alameda | 1 | 2021-01-21 | 2453 | 42 | |
13667 | 13667 | Alpine | Alpine | 3 | 2021-01-21 | 73 | 0 | |
13668 | 13668 | Amador | Amador | 5 | 2021-01-21 | 2996 | 32 | |
13669 | 13669 | Butte | Butte | 7 | 2021-01-21 | 9643 | 130 | |
13670 | 13670 | Calaveras | Calaveras | 9 | 2021-01-21 | 1389 | 23 | |
13671 | 13671 | Colusa | Colusa | 11 | 2021-01-21 | 1853 | 9 | |
13672 | 13672 | Contra Costa | Contra Costa | 13 | 2021-01-21 | 53844 | 478 | |
13673 | 13673 | Del Norte | Del Norte | 15 | 2021-01-21 | 869 | 2 | |
13674 | 13674 | El Dorado | El Dorado | 17 | 2021-01-21 | 7949 | 53 | |
13675 | 13675 | Fresno | Fresno | 19 | 2021-01-21 | 87840 | 1020 | |
13676 | 13676 | Glenn | Glenn | 21 | 2021-01-21 | 1904 | 20 | |
13677 | 13677 | Humboldt | Humboldt | 23 | 2021-01-21 | 2458 | 25 | |
13678 | 13678 | Imperial | Imperial | 25 | 2021-01-21 | 25324 | 486 | |
13679 | 13679 | Inyo | Inyo | 27 | 2021-01-21 | 993 | 29 | |
13680 | 13680 | Kern | Kern | 29 | 2021-01-21 | 87714 | 583 | |
13681 | 13681 | Kings | Kings | 31 | 2021-01-21 | 19703 | 160 | |
13682 | 13682 | Lake | Lake | 33 | 2021-01-21 | 2639 | 31 | |
13683 | 13683 | Lassen | Lassen | 35 | 2021-01-21 | 5224 | 16 | |
13684 | 13684 | Long Beach | Los Angeles | 37 | 2021-01-21 | 45483 | 577 | |
13685 | 13685 | Los Angeles | Los Angeles | 37 | 2021-01-21 | 991549 | 13882 | |
13686 | 13686 | Pasadena | Los Angeles | 37 | 2021-01-21 | 9559 | 203 | |
13687 | 13687 | Madera | Madera | 39 | 2021-01-21 | 13498 | 151 | |
13688 | 13688 | Marin | Marin | 41 | 2021-01-21 | 11810 | 163 | |
13689 | 13689 | Mariposa | Mariposa | 43 | 2021-01-21 | 346 | 4 | |
13690 | 13690 | Mendocino | Mendocino | 45 | 2021-01-21 | 3206 | 32 | |
13691 | 13691 | Merced | Merced | 47 | 2021-01-21 | 24788 | 320 | |
13692 | 13692 | Modoc | Modoc | 49 | 2021-01-21 | 385 | 3 | |
13693 | 13693 | Mono | Mono | 51 | 2021-01-21 | 1125 | 4 | |
13694 | 13694 | Monterey | Monterey | 53 | 2021-01-21 | 36668 | 259 | |
13695 | 13695 | Napa | Napa | 55 | 2021-01-21 | 7696 | 45 | |
13696 | 13696 | Nevada | Nevada | 57 | 2021-01-21 | 3257 | 73 | |
13697 | 13697 | Orange | Orange | 59 | 2021-01-21 | 217849 | 2546 | |
13698 | 13698 | Placer | Placer | 61 | 2021-01-21 | 17584 | 186 | |
13699 | 13699 | Plumas | Plumas | 63 | 2021-01-21 | 600 | 5 | |
13700 | 13700 | Riverside | Riverside | 65 | 2021-01-21 | 255808 | 2739 | |
13701 | 13701 | Sacramento | Sacramento | 67 | 2021-01-21 | 81637 | 1145 | |
13702 | 13702 | San Benito | San Benito | 69 | 2021-01-21 | 5042 | 46 | |
13703 | 13703 | San Bernardino | San Bernardino | 71 | 2021-01-21 | 258742 | 3826 | |
13704 | 13704 | San Diego | San Diego | 73 | 2021-01-21 | 219731 | 2222 | |
13705 | 13705 | San Francisco | San Francisco | 75 | 2021-01-21 | 29362 | 274 | |
13706 | 13706 | San Joaquin | San Joaquin | 77 | 2021-01-21 | 59096 | 806 | |
13707 | 13707 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-21 | 16228 | 151 | |
13708 | 13708 | San Mateo | San Mateo | 81 | 2021-01-21 | 33207 | 309 | |
13709 | 13709 | Santa Barbara | Santa Barbara | 83 | 2021-01-21 | 25751 | 249 | |
13710 | 13710 | Santa Clara | Santa Clara | 85 | 2021-01-21 | 97900 | 1257 | |
13711 | 13711 | Santa Cruz | Santa Cruz | 87 | 2021-01-21 | 12533 | 120 | |
13712 | 13712 | Shasta | Shasta | 89 | 2021-01-21 | 9834 | 126 | |
13713 | 13713 | Sierra | Sierra | 91 | 2021-01-21 | 82 | 0 | |
13714 | 13714 | Siskiyou | Siskiyou | 93 | 2021-01-21 | 1463 | 13 | |
13715 | 13715 | Solano | Solano | 95 | 2021-01-21 | 26191 | 108 | |
13716 | 13716 | Sonoma | Sonoma | 97 | 2021-01-21 | 24469 | 245 | |
13717 | 13717 | Stanislaus | Stanislaus | 99 | 2021-01-21 | 43492 | 773 | |
13718 | 13718 | Sutter | Sutter | 101 | 2021-01-21 | 7855 | 82 | |
13719 | 13719 | Tehama | Tehama | 103 | 2021-01-21 | 4340 | 44 | |
13720 | 13720 | Trinity | Trinity | 105 | 2021-01-21 | 305 | 4 | |
13721 | 13721 | Tulare | Tulare | 107 | 2021-01-21 | 42541 | 529 | |
13722 | 13722 | Tuolumne | Tuolumne | 109 | 2021-01-21 | 3417 | 40 | |
13723 | 13723 | Ventura | Ventura | 111 | 2021-01-21 | 63608 | 491 | |
13724 | 13724 | Yolo | Yolo | 113 | 2021-01-21 | 10772 | 138 | |
13725 | 13725 | Yuba | Yuba | 115 | 2021-01-21 | 5013 | 29 |
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 );