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 2020-10-07 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 |
---|---|---|---|---|---|---|---|---|
20131 | 20131 | Alameda | Alameda | 1 | 2020-10-07 | 21122 | 426 | |
20132 | 20132 | Berkeley | Alameda | 1 | 2020-10-07 | 721 | 10 | |
20133 | 20133 | Alpine | Alpine | 3 | 2020-10-07 | 3 | 0 | TRUE |
20134 | 20134 | Amador | Amador | 5 | 2020-10-07 | 265 | 15 | |
20135 | 20135 | Butte | Butte | 7 | 2020-10-07 | 2927 | 45 | |
20136 | 20136 | Calaveras | Calaveras | 9 | 2020-10-07 | 329 | 14 | TRUE |
20137 | 20137 | Colusa | Colusa | 11 | 2020-10-07 | 541 | 6 | |
20138 | 20138 | Contra Costa | Contra Costa | 13 | 2020-10-07 | 17420 | 224 | |
20139 | 20139 | Del Norte | Del Norte | 15 | 2020-10-07 | 160 | 1 | |
20140 | 20140 | El Dorado | El Dorado | 17 | 2020-10-07 | 1229 | 4 | |
20141 | 20141 | Fresno | Fresno | 19 | 2020-10-07 | 31476 | 406 | |
20142 | 20142 | Glenn | Glenn | 21 | 2020-10-07 | 621 | 3 | |
20143 | 20143 | Humboldt | Humboldt | 23 | 2020-10-07 | 527 | 8 | |
20144 | 20144 | Imperial | Imperial | 25 | 2020-10-07 | 12120 | 327 | |
20145 | 20145 | Inyo | Inyo | 27 | 2020-10-07 | 199 | 15 | |
20146 | 20146 | Kern | Kern | 29 | 2020-10-07 | 32674 | 387 | |
20147 | 20147 | Kings | Kings | 31 | 2020-10-07 | 7938 | 82 | |
20148 | 20148 | Lake | Lake | 33 | 2020-10-07 | 597 | 12 | |
20149 | 20149 | Lassen | Lassen | 35 | 2020-10-07 | 748 | 0 | |
20150 | 20150 | Long Beach | Los Angeles | 37 | 2020-10-07 | 12217 | 249 | |
20151 | 20151 | Los Angeles | Los Angeles | 37 | 2020-10-07 | 262634 | 6332 | |
20152 | 20152 | Pasadena | Los Angeles | 37 | 2020-10-07 | 2636 | 128 | |
20153 | 20153 | Madera | Madera | 39 | 2020-10-07 | 4720 | 70 | |
20154 | 20154 | Marin | Marin | 41 | 2020-10-07 | 6828 | 124 | |
20155 | 20155 | Mariposa | Mariposa | 43 | 2020-10-07 | 77 | 2 | |
20156 | 20156 | Mendocino | Mendocino | 45 | 2020-10-07 | 1025 | 21 | |
20157 | 20157 | Merced | Merced | 47 | 2020-10-07 | 9111 | 149 | |
20158 | 20158 | Modoc | Modoc | 49 | 2020-10-07 | 27 | 0 | TRUE |
20159 | 20159 | Mono | Mono | 51 | 2020-10-07 | 169 | 2 | |
20160 | 20160 | Monterey | Monterey | 53 | 2020-10-07 | 10475 | 78 | |
20161 | 20161 | Napa | Napa | 55 | 2020-10-07 | 1770 | 12 | |
20162 | 20162 | Nevada | Nevada | 57 | 2020-10-07 | 554 | 7 | |
20163 | 20163 | Orange | Orange | 59 | 2020-10-07 | 55042 | 1292 | |
20164 | 20164 | Placer | Placer | 61 | 2020-10-07 | 3710 | 51 | |
20165 | 20165 | Plumas | Plumas | 63 | 2020-10-07 | 52 | 0 | TRUE |
20166 | 20166 | Riverside | Riverside | 65 | 2020-10-07 | 61133 | 1247 | |
20167 | 20167 | Sacramento | Sacramento | 67 | 2020-10-07 | 23420 | 445 | |
20168 | 20168 | San Benito | San Benito | 69 | 2020-10-07 | 1372 | 13 | |
20169 | 20169 | San Bernardino | San Bernardino | 71 | 2020-10-07 | 56823 | 1146 | |
20170 | 20170 | San Diego | San Diego | 73 | 2020-10-07 | 49175 | 813 | |
20171 | 20171 | San Francisco | San Francisco | 75 | 2020-10-07 | 11533 | 114 | |
20172 | 20172 | San Joaquin | San Joaquin | 77 | 2020-10-07 | 20779 | 473 | |
20173 | 20173 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-07 | 3779 | 31 | |
20174 | 20174 | San Mateo | San Mateo | 81 | 2020-10-07 | 10347 | 154 | |
20175 | 20175 | Santa Barbara | Santa Barbara | 83 | 2020-10-07 | 9363 | 115 | |
20176 | 20176 | Santa Clara | Santa Clara | 85 | 2020-10-07 | 22521 | 330 | |
20177 | 20177 | Santa Cruz | Santa Cruz | 87 | 2020-10-07 | 2535 | 18 | |
20178 | 20178 | Shasta | Shasta | 89 | 2020-10-07 | 1242 | 22 | |
20179 | 20179 | Sierra | Sierra | 91 | 2020-10-07 | 6 | 0 | |
20180 | 20180 | Siskiyou | Siskiyou | 93 | 2020-10-07 | 172 | 0 | |
20181 | 20181 | Solano | Solano | 95 | 2020-10-07 | 6658 | 74 | |
20182 | 20182 | Sonoma | Sonoma | 97 | 2020-10-07 | 8083 | 126 | |
20183 | 20183 | Stanislaus | Stanislaus | 99 | 2020-10-07 | 16804 | 379 | |
20184 | 20184 | Sutter | Sutter | 101 | 2020-10-07 | 1770 | 12 | |
20185 | 20185 | Tehama | Tehama | 103 | 2020-10-07 | 660 | 7 | |
20186 | 20186 | Trinity | Trinity | 105 | 2020-10-07 | 19 | 0 | |
20187 | 20187 | Tulare | Tulare | 107 | 2020-10-07 | 16634 | 267 | |
20188 | 20188 | Tuolumne | Tuolumne | 109 | 2020-10-07 | 234 | 4 | |
20189 | 20189 | Ventura | Ventura | 111 | 2020-10-07 | 13147 | 157 | |
20190 | 20190 | Yolo | Yolo | 113 | 2020-10-07 | 2909 | 56 | |
20191 | 20191 | Yuba | Yuba | 115 | 2020-10-07 | 1217 | 10 |
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 );