latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
56 rows where "date" is on date 2020-04-07 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
31190 | 31190 | Alameda | Alameda | 1 | 2020-04-07 | 652 | 50 | |
31191 | 31191 | Berkeley | Alameda | 1 | 2020-04-07 | 31 | 1 | |
31192 | 31192 | Alpine | Alpine | 3 | 2020-04-07 | 1 | 0 | TRUE |
31193 | 31193 | Amador | Amador | 5 | 2020-04-07 | 3 | 0 | |
31194 | 31194 | Butte | Butte | 7 | 2020-04-07 | 11 | 0 | |
31195 | 31195 | Calaveras | Calaveras | 9 | 2020-04-07 | 5 | 0 | |
31196 | 31196 | Colusa | Colusa | 11 | 2020-04-07 | 3 | 0 | TRUE |
31197 | 31197 | Contra Costa | Contra Costa | 13 | 2020-04-07 | 461 | 7 | |
31198 | 31198 | Del Norte | Del Norte | 15 | 2020-04-07 | 2 | 0 | |
31199 | 31199 | El Dorado | El Dorado | 17 | 2020-04-07 | 28 | 0 | |
31200 | 31200 | Fresno | Fresno | 19 | 2020-04-07 | 357 | 3 | |
31201 | 31201 | Glenn | Glenn | 21 | 2020-04-07 | 2 | 0 | |
31202 | 31202 | Humboldt | Humboldt | 23 | 2020-04-07 | 50 | 0 | |
31203 | 31203 | Imperial | Imperial | 25 | 2020-04-07 | 73 | 3 | |
31204 | 31204 | Inyo | Inyo | 27 | 2020-04-07 | 11 | 0 | |
31205 | 31205 | Kern | Kern | 29 | 2020-04-07 | 261 | 2 | |
31206 | 31206 | Kings | Kings | 31 | 2020-04-07 | 5 | 0 | |
31207 | 31207 | Lake | Lake | 33 | 2020-04-07 | 2 | 0 | |
31208 | 31208 | Long Beach | Los Angeles | 37 | 2020-04-07 | 256 | 6 | |
31209 | 31209 | Los Angeles | Los Angeles | 37 | 2020-04-07 | 6608 | 164 | |
31210 | 31210 | Pasadena | Los Angeles | 37 | 2020-04-07 | 80 | 3 | |
31211 | 31211 | Madera | Madera | 39 | 2020-04-07 | 28 | 1 | |
31212 | 31212 | Marin | Marin | 41 | 2020-04-07 | 148 | 10 | |
31213 | 31213 | Mendocino | Mendocino | 45 | 2020-04-07 | 4 | 0 | TRUE |
31214 | 31214 | Merced | Merced | 47 | 2020-04-07 | 34 | 1 | |
31215 | 31215 | Mono | Mono | 51 | 2020-04-07 | 19 | 1 | |
31216 | 31216 | Monterey | Monterey | 53 | 2020-04-07 | 64 | 2 | |
31217 | 31217 | Napa | Napa | 55 | 2020-04-07 | 23 | 2 | |
31218 | 31218 | Nevada | Nevada | 57 | 2020-04-07 | 34 | 1 | |
31219 | 31219 | Orange | Orange | 59 | 2020-04-07 | 909 | 15 | |
31220 | 31220 | Placer | Placer | 61 | 2020-04-07 | 115 | 3 | |
31221 | 31221 | Plumas | Plumas | 63 | 2020-04-07 | 3 | 0 | |
31222 | 31222 | Riverside | Riverside | 65 | 2020-04-07 | 1016 | 28 | |
31223 | 31223 | Sacramento | Sacramento | 67 | 2020-04-07 | 525 | 21 | |
31224 | 31224 | San Benito | San Benito | 69 | 2020-04-07 | 31 | 2 | |
31225 | 31225 | San Bernardino | San Bernardino | 71 | 2020-04-07 | 547 | 25 | |
31226 | 31226 | San Diego | San Diego | 73 | 2020-04-07 | 1454 | 31 | |
31227 | 31227 | San Francisco | San Francisco | 75 | 2020-04-07 | 622 | 9 | |
31228 | 31228 | San Joaquin | San Joaquin | 77 | 2020-04-07 | 216 | 13 | |
31229 | 31229 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-07 | 99 | 1 | |
31230 | 31230 | San Mateo | San Mateo | 81 | 2020-04-07 | 589 | 21 | |
31231 | 31231 | Santa Barbara | Santa Barbara | 83 | 2020-04-07 | 218 | 2 | |
31232 | 31232 | Santa Clara | Santa Clara | 85 | 2020-04-07 | 1463 | 49 | |
31233 | 31233 | Santa Cruz | Santa Cruz | 87 | 2020-04-07 | 76 | 1 | |
31234 | 31234 | Shasta | Shasta | 89 | 2020-04-07 | 23 | 3 | |
31235 | 31235 | Siskiyou | Siskiyou | 93 | 2020-04-07 | 4 | 0 | |
31236 | 31236 | Solano | Solano | 95 | 2020-04-07 | 99 | 2 | |
31237 | 31237 | Sonoma | Sonoma | 97 | 2020-04-07 | 120 | 1 | |
31238 | 31238 | Stanislaus | Stanislaus | 99 | 2020-04-07 | 90 | 0 | |
31239 | 31239 | Sutter | Sutter | 101 | 2020-04-07 | 19 | 2 | |
31240 | 31240 | Tehama | Tehama | 103 | 2020-04-07 | 1 | 0 | |
31241 | 31241 | Tulare | Tulare | 107 | 2020-04-07 | 157 | 6 | |
31242 | 31242 | Tuolumne | Tuolumne | 109 | 2020-04-07 | 1 | 0 | |
31243 | 31243 | Ventura | Ventura | 111 | 2020-04-07 | 243 | 6 | |
31244 | 31244 | Yolo | Yolo | 113 | 2020-04-07 | 56 | 2 | |
31245 | 31245 | Yuba | Yuba | 115 | 2020-04-07 | 13 | 0 |
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 );