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-05-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
28305 | 28305 | Alameda | Alameda | 1 | 2020-05-26 | 2904 | 121 | |
28306 | 28306 | Berkeley | Alameda | 1 | 2020-05-26 | 88 | 2 | |
28307 | 28307 | Alpine | Alpine | 3 | 2020-05-26 | 1 | 0 | TRUE |
28308 | 28308 | Amador | Amador | 5 | 2020-05-26 | 10 | 0 | |
28309 | 28309 | Butte | Butte | 7 | 2020-05-26 | 37 | 0 | |
28310 | 28310 | Calaveras | Calaveras | 9 | 2020-05-26 | 15 | 0 | |
28311 | 28311 | Colusa | Colusa | 11 | 2020-05-26 | 5 | 0 | |
28312 | 28312 | Contra Costa | Contra Costa | 13 | 2020-05-26 | 1340 | 37 | |
28313 | 28313 | Del Norte | Del Norte | 15 | 2020-05-26 | 40 | 0 | |
28314 | 28314 | El Dorado | El Dorado | 17 | 2020-05-26 | 80 | 0 | |
28315 | 28315 | Fresno | Fresno | 19 | 2020-05-26 | 2775 | 26 | |
28316 | 28316 | Glenn | Glenn | 21 | 2020-05-26 | 13 | 0 | |
28317 | 28317 | Humboldt | Humboldt | 23 | 2020-05-26 | 94 | 2 | |
28318 | 28318 | Imperial | Imperial | 25 | 2020-05-26 | 1352 | 24 | |
28319 | 28319 | Inyo | Inyo | 27 | 2020-05-26 | 19 | 1 | |
28320 | 28320 | Kern | Kern | 29 | 2020-05-26 | 1876 | 29 | |
28321 | 28321 | Kings | Kings | 31 | 2020-05-26 | 698 | 3 | |
28322 | 28322 | Lake | Lake | 33 | 2020-05-26 | 14 | 0 | |
28323 | 28323 | Lassen | Lassen | 35 | 2020-05-26 | 4 | 0 | |
28324 | 28324 | Long Beach | Los Angeles | 37 | 2020-05-26 | 1605 | 75 | |
28325 | 28325 | Los Angeles | Los Angeles | 37 | 2020-05-26 | 45387 | 1988 | |
28326 | 28326 | Pasadena | Los Angeles | 37 | 2020-05-26 | 883 | 82 | |
28327 | 28327 | Madera | Madera | 39 | 2020-05-26 | 90 | 2 | |
28328 | 28328 | Marin | Marin | 41 | 2020-05-26 | 420 | 14 | |
28329 | 28329 | Mariposa | Mariposa | 43 | 2020-05-26 | 16 | 1 | |
28330 | 28330 | Mendocino | Mendocino | 45 | 2020-05-26 | 23 | 0 | |
28331 | 28331 | Merced | Merced | 47 | 2020-05-26 | 273 | 7 | |
28332 | 28332 | Modoc | Modoc | 49 | 2020-05-26 | 0 | 0 | |
28333 | 28333 | Mono | Mono | 51 | 2020-05-26 | 35 | 1 | |
28334 | 28334 | Monterey | Monterey | 53 | 2020-05-26 | 429 | 8 | |
28335 | 28335 | Napa | Napa | 55 | 2020-05-26 | 109 | 3 | |
28336 | 28336 | Nevada | Nevada | 57 | 2020-05-26 | 41 | 1 | |
28337 | 28337 | Orange | Orange | 59 | 2020-05-26 | 5578 | 131 | |
28338 | 28338 | Placer | Placer | 61 | 2020-05-26 | 188 | 9 | |
28339 | 28339 | Plumas | Plumas | 63 | 2020-05-26 | 4 | 0 | |
28340 | 28340 | Riverside | Riverside | 65 | 2020-05-26 | 7139 | 303 | |
28341 | 28341 | Sacramento | Sacramento | 67 | 2020-05-26 | 1310 | 56 | |
28342 | 28342 | San Benito | San Benito | 69 | 2020-05-26 | 76 | 2 | |
28343 | 28343 | San Bernardino | San Bernardino | 71 | 2020-05-26 | 4567 | 199 | |
28344 | 28344 | San Diego | San Diego | 73 | 2020-05-26 | 6882 | 249 | |
28345 | 28345 | San Francisco | San Francisco | 75 | 2020-05-26 | 2399 | 40 | |
28346 | 28346 | San Joaquin | San Joaquin | 77 | 2020-05-26 | 812 | 33 | |
28347 | 28347 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-26 | 263 | 1 | |
28348 | 28348 | San Mateo | San Mateo | 81 | 2020-05-26 | 1904 | 82 | |
28349 | 28349 | Santa Barbara | Santa Barbara | 83 | 2020-05-26 | 1604 | 12 | |
28350 | 28350 | Santa Clara | Santa Clara | 85 | 2020-05-26 | 2714 | 137 | |
28351 | 28351 | Santa Cruz | Santa Cruz | 87 | 2020-05-26 | 200 | 2 | |
28352 | 28352 | Shasta | Shasta | 89 | 2020-05-26 | 36 | 4 | |
28353 | 28353 | Sierra | Sierra | 91 | 2020-05-26 | 1 | 0 | |
28354 | 28354 | Siskiyou | Siskiyou | 93 | 2020-05-26 | 6 | 0 | |
28355 | 28355 | Solano | Solano | 95 | 2020-05-26 | 499 | 20 | |
28356 | 28356 | Sonoma | Sonoma | 97 | 2020-05-26 | 524 | 4 | |
28357 | 28357 | Stanislaus | Stanislaus | 99 | 2020-05-26 | 670 | 28 | |
28358 | 28358 | Sutter | Sutter | 101 | 2020-05-26 | 42 | 2 | |
28359 | 28359 | Tehama | Tehama | 103 | 2020-05-26 | 4 | 1 | |
28360 | 28360 | Trinity | Trinity | 105 | 2020-05-26 | 1 | 0 | |
28361 | 28361 | Tulare | Tulare | 107 | 2020-05-26 | 1771 | 79 | |
28362 | 28362 | Tuolumne | Tuolumne | 109 | 2020-05-26 | 4 | 0 | |
28363 | 28363 | Ventura | Ventura | 111 | 2020-05-26 | 1017 | 32 | |
28364 | 28364 | Yolo | Yolo | 113 | 2020-05-26 | 200 | 22 | |
28365 | 28365 | Yuba | Yuba | 115 | 2020-05-26 | 28 | 1 |
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 );