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-04 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 |
---|---|---|---|---|---|---|---|---|
20314 | 20314 | Alameda | Alameda | 1 | 2020-10-04 | 20980 | 426 | |
20315 | 20315 | Berkeley | Alameda | 1 | 2020-10-04 | 717 | 10 | TRUE |
20316 | 20316 | Alpine | Alpine | 3 | 2020-10-04 | 2 | 0 | TRUE |
20317 | 20317 | Amador | Amador | 5 | 2020-10-04 | 259 | 15 | TRUE |
20318 | 20318 | Butte | Butte | 7 | 2020-10-04 | 2903 | 45 | TRUE |
20319 | 20319 | Calaveras | Calaveras | 9 | 2020-10-04 | 324 | 14 | TRUE |
20320 | 20320 | Colusa | Colusa | 11 | 2020-10-04 | 538 | 6 | TRUE |
20321 | 20321 | Contra Costa | Contra Costa | 13 | 2020-10-04 | 17263 | 212 | |
20322 | 20322 | Del Norte | Del Norte | 15 | 2020-10-04 | 146 | 1 | TRUE |
20323 | 20323 | El Dorado | El Dorado | 17 | 2020-10-04 | 1180 | 4 | TRUE |
20324 | 20324 | Fresno | Fresno | 19 | 2020-10-04 | 31095 | 399 | TRUE |
20325 | 20325 | Glenn | Glenn | 21 | 2020-10-04 | 603 | 3 | TRUE |
20326 | 20326 | Humboldt | Humboldt | 23 | 2020-10-04 | 518 | 8 | TRUE |
20327 | 20327 | Imperial | Imperial | 25 | 2020-10-04 | 12047 | 326 | TRUE |
20328 | 20328 | Inyo | Inyo | 27 | 2020-10-04 | 191 | 15 | TRUE |
20329 | 20329 | Kern | Kern | 29 | 2020-10-04 | 32491 | 386 | |
20330 | 20330 | Kings | Kings | 31 | 2020-10-04 | 7912 | 82 | |
20331 | 20331 | Lake | Lake | 33 | 2020-10-04 | 581 | 11 | TRUE |
20332 | 20332 | Lassen | Lassen | 35 | 2020-10-04 | 742 | 0 | TRUE |
20333 | 20333 | Long Beach | Los Angeles | 37 | 2020-10-04 | 12053 | 248 | TRUE |
20334 | 20334 | Los Angeles | Los Angeles | 37 | 2020-10-04 | 259896 | 6274 | |
20335 | 20335 | Pasadena | Los Angeles | 37 | 2020-10-04 | 2618 | 124 | |
20336 | 20336 | Madera | Madera | 39 | 2020-10-04 | 4642 | 70 | TRUE |
20337 | 20337 | Marin | Marin | 41 | 2020-10-04 | 6781 | 119 | |
20338 | 20338 | Mariposa | Mariposa | 43 | 2020-10-04 | 76 | 2 | TRUE |
20339 | 20339 | Mendocino | Mendocino | 45 | 2020-10-04 | 1005 | 20 | |
20340 | 20340 | Merced | Merced | 47 | 2020-10-04 | 9033 | 145 | TRUE |
20341 | 20341 | Modoc | Modoc | 49 | 2020-10-04 | 27 | 0 | TRUE |
20342 | 20342 | Mono | Mono | 51 | 2020-10-04 | 169 | 2 | TRUE |
20343 | 20343 | Monterey | Monterey | 53 | 2020-10-04 | 10359 | 75 | |
20344 | 20344 | Napa | Napa | 55 | 2020-10-04 | 1734 | 12 | TRUE |
20345 | 20345 | Nevada | Nevada | 57 | 2020-10-04 | 543 | 7 | TRUE |
20346 | 20346 | Orange | Orange | 59 | 2020-10-04 | 54640 | 1286 | |
20347 | 20347 | Placer | Placer | 61 | 2020-10-04 | 3628 | 49 | TRUE |
20348 | 20348 | Plumas | Plumas | 63 | 2020-10-04 | 51 | 0 | TRUE |
20349 | 20349 | Riverside | Riverside | 65 | 2020-10-04 | 59934 | 1231 | TRUE |
20350 | 20350 | Sacramento | Sacramento | 67 | 2020-10-04 | 22855 | 430 | TRUE |
20351 | 20351 | San Benito | San Benito | 69 | 2020-10-04 | 1365 | 11 | |
20352 | 20352 | San Bernardino | San Bernardino | 71 | 2020-10-04 | 56275 | 1131 | |
20353 | 20353 | San Diego | San Diego | 73 | 2020-10-04 | 48436 | 803 | |
20354 | 20354 | San Francisco | San Francisco | 75 | 2020-10-04 | 11464 | 108 | |
20355 | 20355 | San Joaquin | San Joaquin | 77 | 2020-10-04 | 20485 | 470 | TRUE |
20356 | 20356 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-04 | 3685 | 31 | TRUE |
20357 | 20357 | San Mateo | San Mateo | 81 | 2020-10-04 | 10207 | 152 | TRUE |
20358 | 20358 | Santa Barbara | Santa Barbara | 83 | 2020-10-04 | 9249 | 115 | TRUE |
20359 | 20359 | Santa Clara | Santa Clara | 85 | 2020-10-04 | 22157 | 322 | |
20360 | 20360 | Santa Cruz | Santa Cruz | 87 | 2020-10-04 | 2501 | 12 | |
20361 | 20361 | Shasta | Shasta | 89 | 2020-10-04 | 953 | 22 | TRUE |
20362 | 20362 | Sierra | Sierra | 91 | 2020-10-04 | 6 | 0 | TRUE |
20363 | 20363 | Siskiyou | Siskiyou | 93 | 2020-10-04 | 167 | 0 | TRUE |
20364 | 20364 | Solano | Solano | 95 | 2020-10-04 | 6520 | 71 | TRUE |
20365 | 20365 | Sonoma | Sonoma | 97 | 2020-10-04 | 7861 | 122 | |
20366 | 20366 | Stanislaus | Stanislaus | 99 | 2020-10-04 | 16737 | 372 | |
20367 | 20367 | Sutter | Sutter | 101 | 2020-10-04 | 1748 | 11 | TRUE |
20368 | 20368 | Tehama | Tehama | 103 | 2020-10-04 | 618 | 7 | TRUE |
20369 | 20369 | Trinity | Trinity | 105 | 2020-10-04 | 19 | 0 | TRUE |
20370 | 20370 | Tulare | Tulare | 107 | 2020-10-04 | 16399 | 265 | TRUE |
20371 | 20371 | Tuolumne | Tuolumne | 109 | 2020-10-04 | 230 | 4 | TRUE |
20372 | 20372 | Ventura | Ventura | 111 | 2020-10-04 | 12943 | 153 | TRUE |
20373 | 20373 | Yolo | Yolo | 113 | 2020-10-04 | 2879 | 56 | |
20374 | 20374 | Yuba | Yuba | 115 | 2020-10-04 | 1188 | 9 | 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 );