latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 1,677
- Alameda 1,110
- Orange 583
- Santa Clara 583
- San Benito 578
- Sacramento 561
- Humboldt 560
- Solano 557
- Marin 556
- Placer 556
- Riverside 556
- San Diego 556
- San Francisco 556
- San Mateo 556
- Santa Cruz 556
- Shasta 556
- Sonoma 556
- Stanislaus 556
- Ventura 556
- Yolo 556
- Calaveras 555
- Contra Costa 555
- Fresno 551
- San Joaquin 548
- Madera 542
- Tulare 538
- Imperial 537
- Amador 535
- San Luis Obispo 535
- San Bernardino 534
- …
agency >30
- Los Angeles 583
- Orange 583
- Santa Clara 583
- San Benito 578
- Sacramento 561
- Humboldt 560
- Solano 557
- Long Beach 556
- Marin 556
- Placer 556
- Riverside 556
- San Diego 556
- San Francisco 556
- San Mateo 556
- Santa Cruz 556
- Shasta 556
- Sonoma 556
- Stanislaus 556
- Ventura 556
- Yolo 556
- Alameda 555
- Berkeley 555
- Calaveras 555
- Contra Costa 555
- Fresno 551
- San Joaquin 548
- Madera 542
- Pasadena 538
- Tulare 538
- Imperial 537
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
201 | 201 | Lake | Lake | 33 | 2021-08-30 | 5293 | 74 | |
202 | 202 | Lassen | Lassen | 35 | 2021-08-30 | 6265 | 27 | |
203 | 203 | Long Beach | Los Angeles | 37 | 2021-08-30 | 60773 | 977 | |
204 | 204 | Los Angeles | Los Angeles | 37 | 2021-08-30 | 1329699 | 23916 | TRUE |
205 | 205 | Pasadena | Los Angeles | 37 | 2021-08-30 | 12723 | 354 | |
206 | 206 | Madera | Madera | 39 | 2021-08-30 | 18129 | 250 | TRUE |
207 | 207 | Marin | Marin | 41 | 2021-08-30 | 16290 | 215 | |
208 | 208 | Mariposa | Mariposa | 43 | 2021-08-30 | 803 | 10 | |
209 | 209 | Mendocino | Mendocino | 45 | 2021-08-30 | 5927 | 61 | TRUE |
210 | 210 | Merced | Merced | 47 | 2021-08-30 | 36740 | 508 | |
211 | 211 | Modoc | Modoc | 49 | 2021-08-30 | 606 | 7 | TRUE |
212 | 212 | Mono | Mono | 51 | 2021-08-30 | 1445 | 5 | |
213 | 213 | Monterey | Monterey | 53 | 2021-08-30 | 46424 | 542 | |
214 | 214 | Napa | Napa | 55 | 2021-08-30 | 11604 | 86 | |
215 | 215 | Nevada | Nevada | 57 | 2021-08-30 | 7156 | 85 | |
216 | 216 | Orange | Orange | 59 | 2021-08-30 | 285098 | 5220 | |
217 | 217 | Placer | Placer | 61 | 2021-08-30 | 28948 | 316 | TRUE |
218 | 218 | Plumas | Plumas | 63 | 2021-08-30 | 1017 | 6 | |
219 | 219 | Riverside | Riverside | 65 | 2021-08-30 | 334846 | 4727 | |
220 | 220 | Sacramento | Sacramento | 67 | 2021-08-30 | 133480 | 1907 | |
221 | 221 | San Benito | San Benito | 69 | 2021-08-30 | 6696 | 65 | |
222 | 222 | San Bernardino | San Bernardino | 71 | 2021-08-30 | 328780 | 4914 | |
223 | 223 | San Diego | San Diego | 73 | 2021-08-30 | 333011 | 3885 | |
224 | 224 | San Francisco | San Francisco | 75 | 2021-08-30 | 46500 | 584 | |
225 | 225 | San Joaquin | San Joaquin | 77 | 2021-08-30 | 85922 | 1528 | |
226 | 226 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-30 | 25137 | 279 | TRUE |
227 | 227 | San Mateo | San Mateo | 81 | 2021-08-30 | 48545 | 595 | |
228 | 228 | Santa Barbara | Santa Barbara | 83 | 2021-08-30 | 39118 | 476 | |
229 | 229 | Santa Clara | Santa Clara | 85 | 2021-08-30 | 133780 | 1731 | |
230 | 230 | Santa Cruz | Santa Cruz | 87 | 2021-08-30 | 18340 | 210 | |
231 | 231 | Shasta | Shasta | 89 | 2021-08-30 | 15353 | 254 | |
232 | 232 | Sierra | Sierra | 91 | 2021-08-30 | 188 | 0 | TRUE |
233 | 233 | Siskiyou | Siskiyou | 93 | 2021-08-30 | 3203 | 40 | TRUE |
234 | 234 | Solano | Solano | 95 | 2021-08-30 | 40477 | 270 | |
235 | 235 | Sonoma | Sonoma | 97 | 2021-08-30 | 36498 | 353 | TRUE |
236 | 236 | Stanislaus | Stanislaus | 99 | 2021-08-30 | 66642 | 1139 | |
237 | 237 | Sutter | Sutter | 101 | 2021-08-30 | 11961 | 121 | |
238 | 238 | Tehama | Tehama | 103 | 2021-08-30 | 6864 | 71 | TRUE |
239 | 239 | Trinity | Trinity | 105 | 2021-08-30 | 641 | 8 | |
240 | 240 | Tulare | Tulare | 107 | 2021-08-30 | 54523 | 869 | |
241 | 241 | Tuolumne | Tuolumne | 109 | 2021-08-30 | 5660 | 88 | |
242 | 242 | Ventura | Ventura | 111 | 2021-08-30 | 90335 | 1074 | |
243 | 243 | Yolo | Yolo | 113 | 2021-08-30 | 16925 | 229 | |
244 | 244 | Yuba | Yuba | 115 | 2021-08-30 | 8551 | 50 | |
245 | 245 | Alameda | Alameda | 1 | 2021-08-29 | 102991 | 1259 | |
246 | 246 | Berkeley | Alameda | 1 | 2021-08-29 | 4501 | 53 | |
247 | 247 | Alpine | Alpine | 3 | 2021-08-29 | 89 | 0 | TRUE |
248 | 248 | Amador | Amador | 5 | 2021-08-29 | 4454 | 53 | TRUE |
249 | 249 | Butte | Butte | 7 | 2021-08-29 | 15401 | 208 | TRUE |
250 | 250 | Calaveras | Calaveras | 9 | 2021-08-29 | 2764 | 61 | TRUE |
251 | 251 | Colusa | Colusa | 11 | 2021-08-29 | 2655 | 18 | TRUE |
252 | 252 | Contra Costa | Contra Costa | 13 | 2021-08-29 | 87806 | 869 | |
253 | 253 | Del Norte | Del Norte | 15 | 2021-08-29 | 2805 | 22 | TRUE |
254 | 254 | El Dorado | El Dorado | 17 | 2021-08-29 | 13011 | 122 | TRUE |
255 | 255 | Fresno | Fresno | 19 | 2021-08-29 | 115079 | 1792 | |
256 | 256 | Glenn | Glenn | 21 | 2021-08-29 | 2590 | 28 | TRUE |
257 | 257 | Humboldt | Humboldt | 23 | 2021-08-29 | 6874 | 71 | TRUE |
258 | 258 | Imperial | Imperial | 25 | 2021-08-29 | 29719 | 751 | TRUE |
259 | 259 | Inyo | Inyo | 27 | 2021-08-29 | 1555 | 39 | TRUE |
260 | 260 | Kern | Kern | 29 | 2021-08-29 | 122950 | 1458 | TRUE |
261 | 261 | Kings | Kings | 31 | 2021-08-29 | 26195 | 264 | |
262 | 262 | Lake | Lake | 33 | 2021-08-29 | 5267 | 74 | |
263 | 263 | Lassen | Lassen | 35 | 2021-08-29 | 6239 | 27 | TRUE |
264 | 264 | Long Beach | Los Angeles | 37 | 2021-08-29 | 60683 | 975 | TRUE |
265 | 265 | Los Angeles | Los Angeles | 37 | 2021-08-29 | 1329699 | 23916 | |
266 | 266 | Pasadena | Los Angeles | 37 | 2021-08-29 | 12671 | 354 | TRUE |
267 | 267 | Madera | Madera | 39 | 2021-08-29 | 18129 | 250 | TRUE |
268 | 268 | Marin | Marin | 41 | 2021-08-29 | 16250 | 215 | |
269 | 269 | Mariposa | Mariposa | 43 | 2021-08-29 | 781 | 10 | |
270 | 270 | Mendocino | Mendocino | 45 | 2021-08-29 | 5927 | 61 | TRUE |
271 | 271 | Merced | Merced | 47 | 2021-08-29 | 36352 | 506 | TRUE |
272 | 272 | Modoc | Modoc | 49 | 2021-08-29 | 606 | 7 | TRUE |
273 | 273 | Mono | Mono | 51 | 2021-08-29 | 1433 | 5 | TRUE |
274 | 274 | Monterey | Monterey | 53 | 2021-08-29 | 46340 | 542 | |
275 | 275 | Napa | Napa | 55 | 2021-08-29 | 11487 | 86 | TRUE |
276 | 276 | Nevada | Nevada | 57 | 2021-08-29 | 7034 | 85 | TRUE |
277 | 277 | Orange | Orange | 59 | 2021-08-29 | 283573 | 5202 | TRUE |
278 | 278 | Placer | Placer | 61 | 2021-08-29 | 28948 | 316 | TRUE |
279 | 279 | Plumas | Plumas | 63 | 2021-08-29 | 983 | 6 | TRUE |
280 | 280 | Riverside | Riverside | 65 | 2021-08-29 | 332499 | 4727 | TRUE |
281 | 281 | Sacramento | Sacramento | 67 | 2021-08-29 | 131011 | 1900 | TRUE |
282 | 282 | San Benito | San Benito | 69 | 2021-08-29 | 6657 | 65 | TRUE |
283 | 283 | San Bernardino | San Bernardino | 71 | 2021-08-29 | 327755 | 4910 | TRUE |
284 | 284 | San Diego | San Diego | 73 | 2021-08-29 | 331330 | 3880 | TRUE |
285 | 285 | San Francisco | San Francisco | 75 | 2021-08-29 | 46313 | 583 | TRUE |
286 | 286 | San Joaquin | San Joaquin | 77 | 2021-08-29 | 84429 | 1513 | TRUE |
287 | 287 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-29 | 25137 | 281 | TRUE |
288 | 288 | San Mateo | San Mateo | 81 | 2021-08-29 | 48061 | 595 | TRUE |
289 | 289 | Santa Barbara | Santa Barbara | 83 | 2021-08-29 | 38791 | 475 | TRUE |
290 | 290 | Santa Clara | Santa Clara | 85 | 2021-08-29 | 132504 | 1731 | TRUE |
291 | 291 | Santa Cruz | Santa Cruz | 87 | 2021-08-29 | 18095 | 210 | TRUE |
292 | 292 | Shasta | Shasta | 89 | 2021-08-29 | 15201 | 252 | TRUE |
293 | 293 | Sierra | Sierra | 91 | 2021-08-29 | 188 | 0 | TRUE |
294 | 294 | Siskiyou | Siskiyou | 93 | 2021-08-29 | 3203 | 40 | TRUE |
295 | 295 | Solano | Solano | 95 | 2021-08-29 | 39800 | 266 | TRUE |
296 | 296 | Sonoma | Sonoma | 97 | 2021-08-29 | 36498 | 353 | TRUE |
297 | 297 | Stanislaus | Stanislaus | 99 | 2021-08-29 | 65640 | 1133 | TRUE |
298 | 298 | Sutter | Sutter | 101 | 2021-08-29 | 11764 | 120 | TRUE |
299 | 299 | Tehama | Tehama | 103 | 2021-08-29 | 6864 | 71 | TRUE |
300 | 300 | Trinity | Trinity | 105 | 2021-08-29 | 632 | 8 | 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 );