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-15 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 |
---|---|---|---|---|---|---|---|---|
6711 | 6711 | Alameda | Alameda | 1 | 2021-05-15 | 84584 | 1217 | TRUE |
6712 | 6712 | Berkeley | Alameda | 1 | 2021-05-15 | 3603 | 46 | TRUE |
6713 | 6713 | Alpine | Alpine | 3 | 2021-05-15 | 88 | 0 | TRUE |
6714 | 6714 | Amador | Amador | 5 | 2021-05-15 | 3631 | 47 | TRUE |
6715 | 6715 | Butte | Butte | 7 | 2021-05-15 | 12095 | 183 | TRUE |
6716 | 6716 | Calaveras | Calaveras | 9 | 2021-05-15 | 2136 | 54 | TRUE |
6717 | 6717 | Colusa | Colusa | 11 | 2021-05-15 | 2236 | 16 | TRUE |
6718 | 6718 | Contra Costa | Contra Costa | 13 | 2021-05-15 | 68942 | 793 | |
6719 | 6719 | Del Norte | Del Norte | 15 | 2021-05-15 | 1398 | 7 | TRUE |
6720 | 6720 | El Dorado | El Dorado | 17 | 2021-05-15 | 10193 | 113 | TRUE |
6721 | 6721 | Fresno | Fresno | 19 | 2021-05-15 | 101439 | 1688 | |
6722 | 6722 | Glenn | Glenn | 21 | 2021-05-15 | 2336 | 25 | TRUE |
6723 | 6723 | Humboldt | Humboldt | 23 | 2021-05-15 | 4072 | 42 | TRUE |
6724 | 6724 | Imperial | Imperial | 25 | 2021-05-15 | 27887 | 725 | TRUE |
6725 | 6725 | Inyo | Inyo | 27 | 2021-05-15 | 1428 | 38 | TRUE |
6726 | 6726 | Kern | Kern | 29 | 2021-05-15 | 109272 | 1376 | |
6727 | 6727 | Kings | Kings | 31 | 2021-05-15 | 23013 | 246 | |
6728 | 6728 | Lake | Lake | 33 | 2021-05-15 | 3467 | 43 | TRUE |
6729 | 6729 | Lassen | Lassen | 35 | 2021-05-15 | 5706 | 24 | TRUE |
6730 | 6730 | Long Beach | Los Angeles | 37 | 2021-05-15 | 53223 | 934 | TRUE |
6731 | 6731 | Los Angeles | Los Angeles | 37 | 2021-05-15 | 1172782 | 22809 | |
6732 | 6732 | Pasadena | Los Angeles | 37 | 2021-05-15 | 11268 | 346 | TRUE |
6733 | 6733 | Madera | Madera | 39 | 2021-05-15 | 16375 | 242 | TRUE |
6734 | 6734 | Marin | Marin | 41 | 2021-05-15 | 14072 | 211 | |
6735 | 6735 | Mariposa | Mariposa | 43 | 2021-05-15 | 450 | 7 | TRUE |
6736 | 6736 | Mendocino | Mendocino | 45 | 2021-05-15 | 4108 | 49 | TRUE |
6737 | 6737 | Merced | Merced | 47 | 2021-05-15 | 31919 | 461 | TRUE |
6738 | 6738 | Modoc | Modoc | 49 | 2021-05-15 | 501 | 4 | TRUE |
6739 | 6739 | Mono | Mono | 51 | 2021-05-15 | 1284 | 4 | TRUE |
6740 | 6740 | Monterey | Monterey | 53 | 2021-05-15 | 43662 | 382 | TRUE |
6741 | 6741 | Napa | Napa | 55 | 2021-05-15 | 9882 | 78 | TRUE |
6742 | 6742 | Nevada | Nevada | 57 | 2021-05-15 | 4751 | 75 | TRUE |
6743 | 6743 | Orange | Orange | 59 | 2021-05-15 | 254692 | 5030 | |
6744 | 6744 | Placer | Placer | 61 | 2021-05-15 | 22679 | 292 | TRUE |
6745 | 6745 | Plumas | Plumas | 63 | 2021-05-15 | 718 | 6 | TRUE |
6746 | 6746 | Riverside | Riverside | 65 | 2021-05-15 | 299793 | 4593 | TRUE |
6747 | 6747 | Sacramento | Sacramento | 67 | 2021-05-15 | 104958 | 1691 | TRUE |
6748 | 6748 | San Benito | San Benito | 69 | 2021-05-15 | 6068 | 63 | TRUE |
6749 | 6749 | San Bernardino | San Bernardino | 71 | 2021-05-15 | 297165 | 4812 | |
6750 | 6750 | San Diego | San Diego | 73 | 2021-05-15 | 278990 | 3737 | |
6751 | 6751 | San Francisco | San Francisco | 75 | 2021-05-15 | 36482 | 540 | |
6752 | 6752 | San Joaquin | San Joaquin | 77 | 2021-05-15 | 73310 | 1394 | TRUE |
6753 | 6753 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-15 | 21208 | 260 | TRUE |
6754 | 6754 | San Mateo | San Mateo | 81 | 2021-05-15 | 41909 | 570 | TRUE |
6755 | 6755 | Santa Barbara | Santa Barbara | 83 | 2021-05-15 | 34378 | 450 | |
6756 | 6756 | Santa Clara | Santa Clara | 85 | 2021-05-15 | 117963 | 1687 | |
6757 | 6757 | Santa Cruz | Santa Cruz | 87 | 2021-05-15 | 16153 | 206 | TRUE |
6758 | 6758 | Shasta | Shasta | 89 | 2021-05-15 | 12175 | 226 | TRUE |
6759 | 6759 | Sierra | Sierra | 91 | 2021-05-15 | 112 | 0 | TRUE |
6760 | 6760 | Siskiyou | Siskiyou | 93 | 2021-05-15 | 2255 | 25 | TRUE |
6761 | 6761 | Solano | Solano | 95 | 2021-05-15 | 32974 | 217 | TRUE |
6762 | 6762 | Sonoma | Sonoma | 97 | 2021-05-15 | 30053 | 314 | TRUE |
6763 | 6763 | Stanislaus | Stanislaus | 99 | 2021-05-15 | 55677 | 1061 | |
6764 | 6764 | Sutter | Sutter | 101 | 2021-05-15 | 9441 | 106 | TRUE |
6765 | 6765 | Tehama | Tehama | 103 | 2021-05-15 | 5590 | 59 | TRUE |
6766 | 6766 | Trinity | Trinity | 105 | 2021-05-15 | 402 | 5 | TRUE |
6767 | 6767 | Tulare | Tulare | 107 | 2021-05-15 | 49758 | 840 | TRUE |
6768 | 6768 | Tuolumne | Tuolumne | 109 | 2021-05-15 | 4139 | 67 | TRUE |
6769 | 6769 | Ventura | Ventura | 111 | 2021-05-15 | 81033 | 1016 | |
6770 | 6770 | Yolo | Yolo | 113 | 2021-05-15 | 13856 | 208 | TRUE |
6771 | 6771 | Yuba | Yuba | 115 | 2021-05-15 | 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 );