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-05-16 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 |
---|---|---|---|---|---|---|---|---|
6650 | 6650 | Alameda | Alameda | 1 | 2021-05-16 | 84625 | 1217 | |
6651 | 6651 | Berkeley | Alameda | 1 | 2021-05-16 | 3605 | 46 | |
6652 | 6652 | Alpine | Alpine | 3 | 2021-05-16 | 88 | 0 | TRUE |
6653 | 6653 | Amador | Amador | 5 | 2021-05-16 | 3631 | 47 | TRUE |
6654 | 6654 | Butte | Butte | 7 | 2021-05-16 | 12140 | 183 | TRUE |
6655 | 6655 | Calaveras | Calaveras | 9 | 2021-05-16 | 2136 | 54 | TRUE |
6656 | 6656 | Colusa | Colusa | 11 | 2021-05-16 | 2236 | 16 | TRUE |
6657 | 6657 | Contra Costa | Contra Costa | 13 | 2021-05-16 | 68976 | 793 | |
6658 | 6658 | Del Norte | Del Norte | 15 | 2021-05-16 | 1398 | 7 | TRUE |
6659 | 6659 | El Dorado | El Dorado | 17 | 2021-05-16 | 10193 | 113 | TRUE |
6660 | 6660 | Fresno | Fresno | 19 | 2021-05-16 | 101474 | 1690 | |
6661 | 6661 | Glenn | Glenn | 21 | 2021-05-16 | 2336 | 25 | TRUE |
6662 | 6662 | Humboldt | Humboldt | 23 | 2021-05-16 | 4072 | 42 | TRUE |
6663 | 6663 | Imperial | Imperial | 25 | 2021-05-16 | 27887 | 725 | TRUE |
6664 | 6664 | Inyo | Inyo | 27 | 2021-05-16 | 1428 | 38 | TRUE |
6665 | 6665 | Kern | Kern | 29 | 2021-05-16 | 109298 | 1376 | |
6666 | 6666 | Kings | Kings | 31 | 2021-05-16 | 23016 | 246 | |
6667 | 6667 | Lake | Lake | 33 | 2021-05-16 | 3467 | 43 | TRUE |
6668 | 6668 | Lassen | Lassen | 35 | 2021-05-16 | 5706 | 24 | TRUE |
6669 | 6669 | Long Beach | Los Angeles | 37 | 2021-05-16 | 53223 | 934 | TRUE |
6670 | 6670 | Los Angeles | Los Angeles | 37 | 2021-05-16 | 1172920 | 22814 | |
6671 | 6671 | Pasadena | Los Angeles | 37 | 2021-05-16 | 11268 | 346 | TRUE |
6672 | 6672 | Madera | Madera | 39 | 2021-05-16 | 16375 | 242 | TRUE |
6673 | 6673 | Marin | Marin | 41 | 2021-05-16 | 14079 | 211 | |
6674 | 6674 | Mariposa | Mariposa | 43 | 2021-05-16 | 450 | 7 | TRUE |
6675 | 6675 | Mendocino | Mendocino | 45 | 2021-05-16 | 4108 | 49 | TRUE |
6676 | 6676 | Merced | Merced | 47 | 2021-05-16 | 31919 | 461 | TRUE |
6677 | 6677 | Modoc | Modoc | 49 | 2021-05-16 | 501 | 4 | TRUE |
6678 | 6678 | Mono | Mono | 51 | 2021-05-16 | 1284 | 4 | TRUE |
6679 | 6679 | Monterey | Monterey | 53 | 2021-05-16 | 43662 | 382 | TRUE |
6680 | 6680 | Napa | Napa | 55 | 2021-05-16 | 9882 | 78 | TRUE |
6681 | 6681 | Nevada | Nevada | 57 | 2021-05-16 | 4751 | 75 | TRUE |
6682 | 6682 | Orange | Orange | 59 | 2021-05-16 | 254744 | 5031 | |
6683 | 6683 | Placer | Placer | 61 | 2021-05-16 | 22679 | 292 | TRUE |
6684 | 6684 | Plumas | Plumas | 63 | 2021-05-16 | 718 | 6 | TRUE |
6685 | 6685 | Riverside | Riverside | 65 | 2021-05-16 | 299793 | 4593 | TRUE |
6686 | 6686 | Sacramento | Sacramento | 67 | 2021-05-16 | 104958 | 1691 | TRUE |
6687 | 6687 | San Benito | San Benito | 69 | 2021-05-16 | 6068 | 63 | TRUE |
6688 | 6688 | San Bernardino | San Bernardino | 71 | 2021-05-16 | 297165 | 4812 | TRUE |
6689 | 6689 | San Diego | San Diego | 73 | 2021-05-16 | 279098 | 3742 | |
6690 | 6690 | San Francisco | San Francisco | 75 | 2021-05-16 | 36487 | 540 | |
6691 | 6691 | San Joaquin | San Joaquin | 77 | 2021-05-16 | 73310 | 1394 | TRUE |
6692 | 6692 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-16 | 21208 | 260 | TRUE |
6693 | 6693 | San Mateo | San Mateo | 81 | 2021-05-16 | 41909 | 570 | TRUE |
6694 | 6694 | Santa Barbara | Santa Barbara | 83 | 2021-05-16 | 34391 | 450 | |
6695 | 6695 | Santa Clara | Santa Clara | 85 | 2021-05-16 | 117991 | 1688 | |
6696 | 6696 | Santa Cruz | Santa Cruz | 87 | 2021-05-16 | 16154 | 206 | TRUE |
6697 | 6697 | Shasta | Shasta | 89 | 2021-05-16 | 12175 | 226 | TRUE |
6698 | 6698 | Sierra | Sierra | 91 | 2021-05-16 | 112 | 0 | TRUE |
6699 | 6699 | Siskiyou | Siskiyou | 93 | 2021-05-16 | 2255 | 25 | TRUE |
6700 | 6700 | Solano | Solano | 95 | 2021-05-16 | 32974 | 217 | TRUE |
6701 | 6701 | Sonoma | Sonoma | 97 | 2021-05-16 | 30067 | 314 | |
6702 | 6702 | Stanislaus | Stanislaus | 99 | 2021-05-16 | 55677 | 1061 | TRUE |
6703 | 6703 | Sutter | Sutter | 101 | 2021-05-16 | 9441 | 106 | TRUE |
6704 | 6704 | Tehama | Tehama | 103 | 2021-05-16 | 5590 | 59 | TRUE |
6705 | 6705 | Trinity | Trinity | 105 | 2021-05-16 | 402 | 5 | TRUE |
6706 | 6706 | Tulare | Tulare | 107 | 2021-05-16 | 49758 | 840 | TRUE |
6707 | 6707 | Tuolumne | Tuolumne | 109 | 2021-05-16 | 4139 | 67 | TRUE |
6708 | 6708 | Ventura | Ventura | 111 | 2021-05-16 | 81033 | 1016 | |
6709 | 6709 | Yolo | Yolo | 113 | 2021-05-16 | 13856 | 208 | TRUE |
6710 | 6710 | Yuba | Yuba | 115 | 2021-05-16 | 6285 | 41 | TRUE |
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 );