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-10 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 |
---|---|---|---|---|---|---|---|---|
14336 | 14336 | Alameda | Alameda | 1 | 2021-01-10 | 59023 | 947 | |
14337 | 14337 | Berkeley | Alameda | 1 | 2021-01-10 | 2200 | 41 | |
14338 | 14338 | Alpine | Alpine | 3 | 2021-01-10 | 72 | 0 | TRUE |
14339 | 14339 | Amador | Amador | 5 | 2021-01-10 | 2824 | 26 | |
14340 | 14340 | Butte | Butte | 7 | 2021-01-10 | 8665 | 111 | TRUE |
14341 | 14341 | Calaveras | Calaveras | 9 | 2021-01-10 | 922 | 22 | TRUE |
14342 | 14342 | Colusa | Colusa | 11 | 2021-01-10 | 1565 | 9 | TRUE |
14343 | 14343 | Contra Costa | Contra Costa | 13 | 2021-01-10 | 47315 | 392 | |
14344 | 14344 | Del Norte | Del Norte | 15 | 2021-01-10 | 816 | 2 | TRUE |
14345 | 14345 | El Dorado | El Dorado | 17 | 2021-01-10 | 6642 | 33 | TRUE |
14346 | 14346 | Fresno | Fresno | 19 | 2021-01-10 | 81047 | 711 | TRUE |
14347 | 14347 | Glenn | Glenn | 21 | 2021-01-10 | 1630 | 18 | TRUE |
14348 | 14348 | Humboldt | Humboldt | 23 | 2021-01-10 | 2031 | 23 | TRUE |
14349 | 14349 | Imperial | Imperial | 25 | 2021-01-10 | 23472 | 446 | TRUE |
14350 | 14350 | Inyo | Inyo | 27 | 2021-01-10 | 811 | 27 | TRUE |
14351 | 14351 | Kern | Kern | 29 | 2021-01-10 | 78832 | 542 | |
14352 | 14352 | Kings | Kings | 31 | 2021-01-10 | 17711 | 110 | TRUE |
14353 | 14353 | Lake | Lake | 33 | 2021-01-10 | 2120 | 26 | TRUE |
14354 | 14354 | Lassen | Lassen | 35 | 2021-01-10 | 4972 | 12 | TRUE |
14355 | 14355 | Long Beach | Los Angeles | 37 | 2021-01-10 | 38470 | 460 | TRUE |
14356 | 14356 | Los Angeles | Los Angeles | 37 | 2021-01-10 | 873457 | 11617 | |
14357 | 14357 | Pasadena | Los Angeles | 37 | 2021-01-10 | 8397 | 175 | |
14358 | 14358 | Madera | Madera | 39 | 2021-01-10 | 11645 | 126 | TRUE |
14359 | 14359 | Marin | Marin | 41 | 2021-01-10 | 10811 | 144 | |
14360 | 14360 | Mariposa | Mariposa | 43 | 2021-01-10 | 322 | 4 | |
14361 | 14361 | Mendocino | Mendocino | 45 | 2021-01-10 | 2914 | 31 | |
14362 | 14362 | Merced | Merced | 47 | 2021-01-10 | 21506 | 279 | TRUE |
14363 | 14363 | Modoc | Modoc | 49 | 2021-01-10 | 366 | 3 | |
14364 | 14364 | Mono | Mono | 51 | 2021-01-10 | 969 | 4 | TRUE |
14365 | 14365 | Monterey | Monterey | 53 | 2021-01-10 | 32394 | 242 | TRUE |
14366 | 14366 | Napa | Napa | 55 | 2021-01-10 | 6476 | 35 | TRUE |
14367 | 14367 | Nevada | Nevada | 57 | 2021-01-10 | 2888 | 50 | TRUE |
14368 | 14368 | Orange | Orange | 59 | 2021-01-10 | 188602 | 2091 | |
14369 | 14369 | Placer | Placer | 61 | 2021-01-10 | 15454 | 159 | TRUE |
14370 | 14370 | Plumas | Plumas | 63 | 2021-01-10 | 544 | 5 | TRUE |
14371 | 14371 | Riverside | Riverside | 65 | 2021-01-10 | 207841 | 2218 | TRUE |
14372 | 14372 | Sacramento | Sacramento | 67 | 2021-01-10 | 71841 | 977 | TRUE |
14373 | 14373 | San Benito | San Benito | 69 | 2021-01-10 | 4403 | 36 | |
14374 | 14374 | San Bernardino | San Bernardino | 71 | 2021-01-10 | 228315 | 3284 | |
14375 | 14375 | San Diego | San Diego | 73 | 2021-01-10 | 191888 | 1857 | |
14376 | 14376 | San Francisco | San Francisco | 75 | 2021-01-10 | 26282 | 233 | |
14377 | 14377 | San Joaquin | San Joaquin | 77 | 2021-01-10 | 51523 | 712 | TRUE |
14378 | 14378 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-10 | 12891 | 101 | TRUE |
14379 | 14379 | San Mateo | San Mateo | 81 | 2021-01-10 | 27754 | 255 | TRUE |
14380 | 14380 | Santa Barbara | Santa Barbara | 83 | 2021-01-10 | 21323 | 197 | |
14381 | 14381 | Santa Clara | Santa Clara | 85 | 2021-01-10 | 87150 | 1049 | |
14382 | 14382 | Santa Cruz | Santa Cruz | 87 | 2021-01-10 | 10108 | 104 | TRUE |
14383 | 14383 | Shasta | Shasta | 89 | 2021-01-10 | 8917 | 99 | TRUE |
14384 | 14384 | Sierra | Sierra | 91 | 2021-01-10 | 63 | 0 | TRUE |
14385 | 14385 | Siskiyou | Siskiyou | 93 | 2021-01-10 | 1311 | 12 | TRUE |
14386 | 14386 | Solano | Solano | 95 | 2021-01-10 | 22232 | 102 | TRUE |
14387 | 14387 | Sonoma | Sonoma | 97 | 2021-01-10 | 21463 | 218 | |
14388 | 14388 | Stanislaus | Stanislaus | 99 | 2021-01-10 | 38851 | 675 | |
14389 | 14389 | Sutter | Sutter | 101 | 2021-01-10 | 7018 | 70 | TRUE |
14390 | 14390 | Tehama | Tehama | 103 | 2021-01-10 | 3752 | 41 | TRUE |
14391 | 14391 | Trinity | Trinity | 105 | 2021-01-10 | 292 | 4 | TRUE |
14392 | 14392 | Tulare | Tulare | 107 | 2021-01-10 | 36936 | 455 | TRUE |
14393 | 14393 | Tuolumne | Tuolumne | 109 | 2021-01-10 | 3180 | 33 | TRUE |
14394 | 14394 | Ventura | Ventura | 111 | 2021-01-10 | 48317 | 334 | TRUE |
14395 | 14395 | Yolo | Yolo | 113 | 2021-01-10 | 9291 | 127 | |
14396 | 14396 | Yuba | Yuba | 115 | 2021-01-10 | 4440 | 25 | 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 );