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-31 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 |
---|---|---|---|---|---|---|---|---|
24279 | 24279 | Alameda | Alameda | 1 | 2020-07-31 | 11099 | 231 | TRUE |
24280 | 24280 | Berkeley | Alameda | 1 | 2020-07-31 | 401 | 8 | |
24281 | 24281 | Alpine | Alpine | 3 | 2020-07-31 | 2 | 0 | TRUE |
24282 | 24282 | Amador | Amador | 5 | 2020-07-31 | 125 | 0 | |
24283 | 24283 | Butte | Butte | 7 | 2020-07-31 | 925 | 7 | |
24284 | 24284 | Calaveras | Calaveras | 9 | 2020-07-31 | 125 | 1 | |
24285 | 24285 | Colusa | Colusa | 11 | 2020-07-31 | 323 | 4 | |
24286 | 24286 | Contra Costa | Contra Costa | 13 | 2020-07-31 | 7670 | 119 | |
24287 | 24287 | Del Norte | Del Norte | 15 | 2020-07-31 | 88 | 0 | |
24288 | 24288 | El Dorado | El Dorado | 17 | 2020-07-31 | 637 | 1 | |
24289 | 24289 | Fresno | Fresno | 19 | 2020-07-31 | 21644 | 138 | |
24290 | 24290 | Glenn | Glenn | 21 | 2020-07-31 | 325 | 1 | |
24291 | 24291 | Humboldt | Humboldt | 23 | 2020-07-31 | 233 | 4 | |
24292 | 24292 | Imperial | Imperial | 25 | 2020-07-31 | 9366 | 210 | |
24293 | 24293 | Inyo | Inyo | 27 | 2020-07-31 | 51 | 1 | |
24294 | 24294 | Kern | Kern | 29 | 2020-07-31 | 19335 | 140 | |
24295 | 24295 | Kings | Kings | 31 | 2020-07-31 | 4380 | 56 | |
24296 | 24296 | Lake | Lake | 33 | 2020-07-31 | 195 | 1 | |
24297 | 24297 | Lassen | Lassen | 35 | 2020-07-31 | 594 | 0 | |
24298 | 24298 | Long Beach | Los Angeles | 37 | 2020-07-31 | 8142 | 177 | |
24299 | 24299 | Los Angeles | Los Angeles | 37 | 2020-07-31 | 178426 | 4339 | |
24300 | 24300 | Pasadena | Los Angeles | 37 | 2020-07-31 | 1973 | 108 | |
24301 | 24301 | Madera | Madera | 39 | 2020-07-31 | 1943 | 30 | |
24302 | 24302 | Marin | Marin | 41 | 2020-07-31 | 4938 | 70 | |
24303 | 24303 | Mariposa | Mariposa | 43 | 2020-07-31 | 54 | 2 | |
24304 | 24304 | Mendocino | Mendocino | 45 | 2020-07-31 | 312 | 9 | |
24305 | 24305 | Merced | Merced | 47 | 2020-07-31 | 4285 | 50 | |
24306 | 24306 | Modoc | Modoc | 49 | 2020-07-31 | 2 | 0 | TRUE |
24307 | 24307 | Mono | Mono | 51 | 2020-07-31 | 141 | 1 | |
24308 | 24308 | Monterey | Monterey | 53 | 2020-07-31 | 4542 | 26 | |
24309 | 24309 | Napa | Napa | 55 | 2020-07-31 | 888 | 8 | |
24310 | 24310 | Nevada | Nevada | 57 | 2020-07-31 | 299 | 1 | |
24311 | 24311 | Orange | Orange | 59 | 2020-07-31 | 36196 | 618 | |
24312 | 24312 | Placer | Placer | 61 | 2020-07-31 | 1876 | 15 | |
24313 | 24313 | Plumas | Plumas | 63 | 2020-07-31 | 33 | 0 | |
24314 | 24314 | Riverside | Riverside | 65 | 2020-07-31 | 37011 | 695 | |
24315 | 24315 | Sacramento | Sacramento | 67 | 2020-07-31 | 9820 | 133 | |
24316 | 24316 | San Benito | San Benito | 69 | 2020-07-31 | 622 | 4 | |
24317 | 24317 | San Bernardino | San Bernardino | 71 | 2020-07-31 | 32230 | 701 | |
24318 | 24318 | San Diego | San Diego | 73 | 2020-07-31 | 29048 | 561 | |
24319 | 24319 | San Francisco | San Francisco | 75 | 2020-07-31 | 6575 | 59 | |
24320 | 24320 | San Joaquin | San Joaquin | 77 | 2020-07-31 | 11483 | 168 | |
24321 | 24321 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-31 | 1783 | 15 | |
24322 | 24322 | San Mateo | San Mateo | 81 | 2020-07-31 | 5469 | 119 | |
24323 | 24323 | Santa Barbara | Santa Barbara | 83 | 2020-07-31 | 6167 | 60 | |
24324 | 24324 | Santa Clara | Santa Clara | 85 | 2020-07-31 | 12019 | 195 | |
24325 | 24325 | Santa Cruz | Santa Cruz | 87 | 2020-07-31 | 1109 | 4 | |
24326 | 24326 | Shasta | Shasta | 89 | 2020-07-31 | 369 | 9 | |
24327 | 24327 | Sierra | Sierra | 91 | 2020-07-31 | 2 | 0 | |
24328 | 24328 | Siskiyou | Siskiyou | 93 | 2020-07-31 | 73 | 0 | |
24329 | 24329 | Solano | Solano | 95 | 2020-07-31 | 3611 | 37 | |
24330 | 24330 | Sonoma | Sonoma | 97 | 2020-07-31 | 2944 | 36 | |
24331 | 24331 | Stanislaus | Stanislaus | 99 | 2020-07-31 | 8890 | 104 | |
24332 | 24332 | Sutter | Sutter | 101 | 2020-07-31 | 768 | 6 | |
24333 | 24333 | Tehama | Tehama | 103 | 2020-07-31 | 226 | 1 | |
24334 | 24334 | Trinity | Trinity | 105 | 2020-07-31 | 5 | 0 | |
24335 | 24335 | Tulare | Tulare | 107 | 2020-07-31 | 9454 | 178 | |
24336 | 24336 | Tuolumne | Tuolumne | 109 | 2020-07-31 | 141 | 2 | |
24337 | 24337 | Ventura | Ventura | 111 | 2020-07-31 | 7344 | 76 | |
24338 | 24338 | Yolo | Yolo | 113 | 2020-07-31 | 1510 | 41 | |
24339 | 24339 | Yuba | Yuba | 115 | 2020-07-31 | 471 | 4 |
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 );