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-22 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 |
---|---|---|---|---|---|---|---|---|
19216 | 19216 | Alameda | Alameda | 1 | 2020-10-22 | 22276 | 440 | |
19217 | 19217 | Berkeley | Alameda | 1 | 2020-10-22 | 747 | 10 | |
19218 | 19218 | Alpine | Alpine | 3 | 2020-10-22 | 3 | 0 | TRUE |
19219 | 19219 | Amador | Amador | 5 | 2020-10-22 | 287 | 15 | |
19220 | 19220 | Butte | Butte | 7 | 2020-10-22 | 3046 | 52 | |
19221 | 19221 | Calaveras | Calaveras | 9 | 2020-10-22 | 339 | 17 | TRUE |
19222 | 19222 | Colusa | Colusa | 11 | 2020-10-22 | 549 | 6 | |
19223 | 19223 | Contra Costa | Contra Costa | 13 | 2020-10-22 | 18413 | 240 | |
19224 | 19224 | Del Norte | Del Norte | 15 | 2020-10-22 | 178 | 1 | |
19225 | 19225 | El Dorado | El Dorado | 17 | 2020-10-22 | 1308 | 4 | |
19226 | 19226 | Fresno | Fresno | 19 | 2020-10-22 | 32990 | 430 | |
19227 | 19227 | Glenn | Glenn | 21 | 2020-10-22 | 652 | 3 | |
19228 | 19228 | Humboldt | Humboldt | 23 | 2020-10-22 | 561 | 9 | |
19229 | 19229 | Imperial | Imperial | 25 | 2020-10-22 | 12668 | 336 | |
19230 | 19230 | Inyo | Inyo | 27 | 2020-10-22 | 227 | 15 | |
19231 | 19231 | Kern | Kern | 29 | 2020-10-22 | 33669 | 416 | |
19232 | 19232 | Kings | Kings | 31 | 2020-10-22 | 8180 | 83 | |
19233 | 19233 | Lake | Lake | 33 | 2020-10-22 | 679 | 15 | |
19234 | 19234 | Lassen | Lassen | 35 | 2020-10-22 | 762 | 1 | |
19235 | 19235 | Long Beach | Los Angeles | 37 | 2020-10-22 | 12870 | 255 | |
19236 | 19236 | Los Angeles | Los Angeles | 37 | 2020-10-22 | 278547 | 6572 | |
19237 | 19237 | Pasadena | Los Angeles | 37 | 2020-10-22 | 2721 | 129 | |
19238 | 19238 | Madera | Madera | 39 | 2020-10-22 | 4945 | 74 | |
19239 | 19239 | Marin | Marin | 41 | 2020-10-22 | 7045 | 128 | |
19240 | 19240 | Mariposa | Mariposa | 43 | 2020-10-22 | 78 | 2 | |
19241 | 19241 | Mendocino | Mendocino | 45 | 2020-10-22 | 1121 | 21 | |
19242 | 19242 | Merced | Merced | 47 | 2020-10-22 | 9439 | 154 | |
19243 | 19243 | Modoc | Modoc | 49 | 2020-10-22 | 29 | 0 | |
19244 | 19244 | Mono | Mono | 51 | 2020-10-22 | 181 | 2 | |
19245 | 19245 | Monterey | Monterey | 53 | 2020-10-22 | 11284 | 87 | |
19246 | 19246 | Napa | Napa | 55 | 2020-10-22 | 1923 | 14 | |
19247 | 19247 | Nevada | Nevada | 57 | 2020-10-22 | 603 | 8 | |
19248 | 19248 | Orange | Orange | 59 | 2020-10-22 | 57848 | 1434 | |
19249 | 19249 | Placer | Placer | 61 | 2020-10-22 | 4052 | 57 | |
19250 | 19250 | Plumas | Plumas | 63 | 2020-10-22 | 63 | 0 | TRUE |
19251 | 19251 | Riverside | Riverside | 65 | 2020-10-22 | 65386 | 1279 | |
19252 | 19252 | Sacramento | Sacramento | 67 | 2020-10-22 | 25094 | 482 | |
19253 | 19253 | San Benito | San Benito | 69 | 2020-10-22 | 1419 | 15 | |
19254 | 19254 | San Bernardino | San Bernardino | 71 | 2020-10-22 | 61550 | 1192 | |
19255 | 19255 | San Diego | San Diego | 73 | 2020-10-22 | 53498 | 866 | |
19256 | 19256 | San Francisco | San Francisco | 75 | 2020-10-22 | 12000 | 138 | |
19257 | 19257 | San Joaquin | San Joaquin | 77 | 2020-10-22 | 21528 | 488 | |
19258 | 19258 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-22 | 4121 | 32 | |
19259 | 19259 | San Mateo | San Mateo | 81 | 2020-10-22 | 10961 | 157 | |
19260 | 19260 | Santa Barbara | Santa Barbara | 83 | 2020-10-22 | 9715 | 120 | |
19261 | 19261 | Santa Clara | Santa Clara | 85 | 2020-10-22 | 24317 | 349 | |
19262 | 19262 | Santa Cruz | Santa Cruz | 87 | 2020-10-22 | 2753 | 25 | |
19263 | 19263 | Shasta | Shasta | 89 | 2020-10-22 | 1834 | 30 | |
19264 | 19264 | Sierra | Sierra | 91 | 2020-10-22 | 6 | 0 | |
19265 | 19265 | Siskiyou | Siskiyou | 93 | 2020-10-22 | 188 | 0 | |
19266 | 19266 | Solano | Solano | 95 | 2020-10-22 | 7249 | 74 | |
19267 | 19267 | Sonoma | Sonoma | 97 | 2020-10-22 | 9099 | 134 | |
19268 | 19268 | Stanislaus | Stanislaus | 99 | 2020-10-22 | 17455 | 395 | |
19269 | 19269 | Sutter | Sutter | 101 | 2020-10-22 | 1837 | 12 | |
19270 | 19270 | Tehama | Tehama | 103 | 2020-10-22 | 828 | 8 | |
19271 | 19271 | Trinity | Trinity | 105 | 2020-10-22 | 25 | 0 | |
19272 | 19272 | Tulare | Tulare | 107 | 2020-10-22 | 17425 | 284 | |
19273 | 19273 | Tuolumne | Tuolumne | 109 | 2020-10-22 | 262 | 4 | |
19274 | 19274 | Ventura | Ventura | 111 | 2020-10-22 | 13949 | 162 | |
19275 | 19275 | Yolo | Yolo | 113 | 2020-10-22 | 3119 | 58 | |
19276 | 19276 | Yuba | Yuba | 115 | 2020-10-22 | 1293 | 10 |
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 );