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-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
30294 | 30294 | Alameda | Alameda | 1 | 2020-04-23 | 1334 | 87 | |
30295 | 30295 | Berkeley | Alameda | 1 | 2020-04-23 | 47 | 1 | |
30296 | 30296 | Alpine | Alpine | 3 | 2020-04-23 | 1 | 0 | TRUE |
30297 | 30297 | Amador | Amador | 5 | 2020-04-23 | 8 | 0 | |
30298 | 30298 | Butte | Butte | 7 | 2020-04-23 | 15 | 0 | |
30299 | 30299 | Calaveras | Calaveras | 9 | 2020-04-23 | 13 | 0 | |
30300 | 30300 | Colusa | Colusa | 11 | 2020-04-23 | 3 | 0 | |
30301 | 30301 | Contra Costa | Contra Costa | 13 | 2020-04-23 | 779 | 23 | |
30302 | 30302 | Del Norte | Del Norte | 15 | 2020-04-23 | 2 | 0 | |
30303 | 30303 | El Dorado | El Dorado | 17 | 2020-04-23 | 40 | 0 | |
30304 | 30304 | Fresno | Fresno | 19 | 2020-04-23 | 717 | 7 | |
30305 | 30305 | Glenn | Glenn | 21 | 2020-04-23 | 5 | 0 | |
30306 | 30306 | Humboldt | Humboldt | 23 | 2020-04-23 | 52 | 0 | |
30307 | 30307 | Imperial | Imperial | 25 | 2020-04-23 | 232 | 8 | |
30308 | 30308 | Inyo | Inyo | 27 | 2020-04-23 | 19 | 0 | |
30309 | 30309 | Kern | Kern | 29 | 2020-04-23 | 699 | 4 | |
30310 | 30310 | Kings | Kings | 31 | 2020-04-23 | 35 | 1 | |
30311 | 30311 | Lake | Lake | 33 | 2020-04-23 | 6 | 0 | |
30312 | 30312 | Long Beach | Los Angeles | 37 | 2020-04-23 | 518 | 27 | |
30313 | 30313 | Los Angeles | Los Angeles | 37 | 2020-04-23 | 16756 | 742 | |
30314 | 30314 | Pasadena | Los Angeles | 37 | 2020-04-23 | 293 | 29 | |
30315 | 30315 | Madera | Madera | 39 | 2020-04-23 | 39 | 2 | |
30316 | 30316 | Marin | Marin | 41 | 2020-04-23 | 209 | 11 | |
30317 | 30317 | Mendocino | Mendocino | 45 | 2020-04-23 | 8 | 0 | |
30318 | 30318 | Merced | Merced | 47 | 2020-04-23 | 100 | 3 | |
30319 | 30319 | Mono | Mono | 51 | 2020-04-23 | 24 | 1 | |
30320 | 30320 | Monterey | Monterey | 53 | 2020-04-23 | 164 | 4 | |
30321 | 30321 | Napa | Napa | 55 | 2020-04-23 | 57 | 2 | |
30322 | 30322 | Nevada | Nevada | 57 | 2020-04-23 | 38 | 1 | |
30323 | 30323 | Orange | Orange | 59 | 2020-04-23 | 1803 | 36 | |
30324 | 30324 | Placer | Placer | 61 | 2020-04-23 | 136 | 8 | |
30325 | 30325 | Plumas | Plumas | 63 | 2020-04-23 | 4 | 0 | |
30326 | 30326 | Riverside | Riverside | 65 | 2020-04-23 | 3218 | 100 | |
30327 | 30327 | Sacramento | Sacramento | 67 | 2020-04-23 | 987 | 41 | |
30328 | 30328 | San Benito | San Benito | 69 | 2020-04-23 | 47 | 2 | |
30329 | 30329 | San Bernardino | San Bernardino | 71 | 2020-04-23 | 1608 | 87 | |
30330 | 30330 | San Diego | San Diego | 73 | 2020-04-23 | 2643 | 100 | |
30331 | 30331 | San Francisco | San Francisco | 75 | 2020-04-23 | 1302 | 21 | |
30332 | 30332 | San Joaquin | San Joaquin | 77 | 2020-04-23 | 469 | 22 | |
30333 | 30333 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-23 | 149 | 1 | |
30334 | 30334 | San Mateo | San Mateo | 81 | 2020-04-23 | 966 | 39 | |
30335 | 30335 | Santa Barbara | Santa Barbara | 83 | 2020-04-23 | 451 | 5 | |
30336 | 30336 | Santa Clara | Santa Clara | 85 | 2020-04-23 | 2083 | 100 | |
30337 | 30337 | Santa Cruz | Santa Cruz | 87 | 2020-04-23 | 114 | 2 | |
30338 | 30338 | Shasta | Shasta | 89 | 2020-04-23 | 28 | 3 | |
30339 | 30339 | Siskiyou | Siskiyou | 93 | 2020-04-23 | 5 | 0 | |
30340 | 30340 | Solano | Solano | 95 | 2020-04-23 | 191 | 4 | |
30341 | 30341 | Sonoma | Sonoma | 97 | 2020-04-23 | 216 | 2 | |
30342 | 30342 | Stanislaus | Stanislaus | 99 | 2020-04-23 | 258 | 5 | |
30343 | 30343 | Sutter | Sutter | 101 | 2020-04-23 | 28 | 2 | |
30344 | 30344 | Tehama | Tehama | 103 | 2020-04-23 | 1 | 1 | TRUE |
30345 | 30345 | Tulare | Tulare | 107 | 2020-04-23 | 453 | 25 | |
30346 | 30346 | Tuolumne | Tuolumne | 109 | 2020-04-23 | 2 | 0 | |
30347 | 30347 | Ventura | Ventura | 111 | 2020-04-23 | 465 | 16 | |
30348 | 30348 | Yolo | Yolo | 113 | 2020-04-23 | 155 | 12 | |
30349 | 30349 | Yuba | Yuba | 115 | 2020-04-23 | 16 | 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 );