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-07-15 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 |
---|---|---|---|---|---|---|---|---|
25255 | 25255 | Alameda | Alameda | 1 | 2020-07-15 | 8380 | 203 | |
25256 | 25256 | Berkeley | Alameda | 1 | 2020-07-15 | 299 | 5 | |
25257 | 25257 | Alpine | Alpine | 3 | 2020-07-15 | 1 | 0 | TRUE |
25258 | 25258 | Amador | Amador | 5 | 2020-07-15 | 48 | 0 | |
25259 | 25259 | Butte | Butte | 7 | 2020-07-15 | 420 | 4 | |
25260 | 25260 | Calaveras | Calaveras | 9 | 2020-07-15 | 75 | 0 | TRUE |
25261 | 25261 | Colusa | Colusa | 11 | 2020-07-15 | 140 | 0 | |
25262 | 25262 | Contra Costa | Contra Costa | 13 | 2020-07-15 | 5235 | 92 | |
25263 | 25263 | Del Norte | Del Norte | 15 | 2020-07-15 | 61 | 0 | TRUE |
25264 | 25264 | El Dorado | El Dorado | 17 | 2020-07-15 | 363 | 0 | |
25265 | 25265 | Fresno | Fresno | 19 | 2020-07-15 | 15932 | 91 | |
25266 | 25266 | Glenn | Glenn | 21 | 2020-07-15 | 190 | 1 | |
25267 | 25267 | Humboldt | Humboldt | 23 | 2020-07-15 | 175 | 4 | |
25268 | 25268 | Imperial | Imperial | 25 | 2020-07-15 | 8145 | 148 | |
25269 | 25269 | Inyo | Inyo | 27 | 2020-07-15 | 37 | 1 | TRUE |
25270 | 25270 | Kern | Kern | 29 | 2020-07-15 | 6921 | 98 | |
25271 | 25271 | Kings | Kings | 31 | 2020-07-15 | 3108 | 41 | |
25272 | 25272 | Lake | Lake | 33 | 2020-07-15 | 133 | 1 | |
25273 | 25273 | Lassen | Lassen | 35 | 2020-07-15 | 473 | 0 | |
25274 | 25274 | Long Beach | Los Angeles | 37 | 2020-07-15 | 6042 | 156 | |
25275 | 25275 | Los Angeles | Los Angeles | 37 | 2020-07-15 | 135580 | 3684 | |
25276 | 25276 | Pasadena | Los Angeles | 37 | 2020-07-15 | 1585 | 101 | |
25277 | 25277 | Madera | Madera | 39 | 2020-07-15 | 1054 | 10 | |
25278 | 25278 | Marin | Marin | 41 | 2020-07-15 | 3947 | 40 | |
25279 | 25279 | Mariposa | Mariposa | 43 | 2020-07-15 | 35 | 1 | |
25280 | 25280 | Mendocino | Mendocino | 45 | 2020-07-15 | 165 | 1 | |
25281 | 25281 | Merced | Merced | 47 | 2020-07-15 | 2260 | 15 | |
25282 | 25282 | Modoc | Modoc | 49 | 2020-07-15 | 0 | 0 | TRUE |
25283 | 25283 | Mono | Mono | 51 | 2020-07-15 | 54 | 1 | |
25284 | 25284 | Monterey | Monterey | 53 | 2020-07-15 | 2913 | 18 | |
25285 | 25285 | Napa | Napa | 55 | 2020-07-15 | 561 | 4 | |
25286 | 25286 | Nevada | Nevada | 57 | 2020-07-15 | 185 | 1 | |
25287 | 25287 | Orange | Orange | 59 | 2020-07-15 | 27031 | 455 | |
25288 | 25288 | Placer | Placer | 61 | 2020-07-15 | 1167 | 11 | |
25289 | 25289 | Plumas | Plumas | 63 | 2020-07-15 | 21 | 0 | |
25290 | 25290 | Riverside | Riverside | 65 | 2020-07-15 | 27371 | 577 | |
25291 | 25291 | Sacramento | Sacramento | 67 | 2020-07-15 | 6174 | 92 | |
25292 | 25292 | San Benito | San Benito | 69 | 2020-07-15 | 408 | 2 | |
25293 | 25293 | San Bernardino | San Bernardino | 71 | 2020-07-15 | 21468 | 467 | |
25294 | 25294 | San Diego | San Diego | 73 | 2020-07-15 | 21446 | 448 | |
25295 | 25295 | San Francisco | San Francisco | 75 | 2020-07-15 | 4696 | 50 | |
25296 | 25296 | San Joaquin | San Joaquin | 77 | 2020-07-15 | 7428 | 73 | |
25297 | 25297 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-15 | 1112 | 6 | |
25298 | 25298 | San Mateo | San Mateo | 81 | 2020-07-15 | 4254 | 114 | |
25299 | 25299 | Santa Barbara | Santa Barbara | 83 | 2020-07-15 | 4412 | 32 | |
25300 | 25300 | Santa Clara | Santa Clara | 85 | 2020-07-15 | 8302 | 175 | |
25301 | 25301 | Santa Cruz | Santa Cruz | 87 | 2020-07-15 | 602 | 3 | |
25302 | 25302 | Shasta | Shasta | 89 | 2020-07-15 | 215 | 6 | |
25303 | 25303 | Sierra | Sierra | 91 | 2020-07-15 | 1 | 0 | |
25304 | 25304 | Siskiyou | Siskiyou | 93 | 2020-07-15 | 43 | 0 | |
25305 | 25305 | Solano | Solano | 95 | 2020-07-15 | 2407 | 31 | |
25306 | 25306 | Sonoma | Sonoma | 97 | 2020-07-15 | 1941 | 16 | TRUE |
25307 | 25307 | Stanislaus | Stanislaus | 99 | 2020-07-15 | 5517 | 61 | |
25308 | 25308 | Sutter | Sutter | 101 | 2020-07-15 | 454 | 4 | |
25309 | 25309 | Tehama | Tehama | 103 | 2020-07-15 | 126 | 1 | |
25310 | 25310 | Trinity | Trinity | 105 | 2020-07-15 | 2 | 0 | |
25311 | 25311 | Tulare | Tulare | 107 | 2020-07-15 | 6332 | 153 | |
25312 | 25312 | Tuolumne | Tuolumne | 109 | 2020-07-15 | 80 | 0 | |
25313 | 25313 | Ventura | Ventura | 111 | 2020-07-15 | 4884 | 56 | |
25314 | 25314 | Yolo | Yolo | 113 | 2020-07-15 | 1023 | 30 | |
25315 | 25315 | Yuba | Yuba | 115 | 2020-07-15 | 231 | 3 |
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 );