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-06-28 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 |
---|---|---|---|---|---|---|---|---|
26292 | 26292 | Alameda | Alameda | 1 | 2020-06-28 | 5621 | 176 | |
26293 | 26293 | Berkeley | Alameda | 1 | 2020-06-28 | 150 | 2 | |
26294 | 26294 | Alpine | Alpine | 3 | 2020-06-28 | 1 | 0 | TRUE |
26295 | 26295 | Amador | Amador | 5 | 2020-06-28 | 21 | 0 | |
26296 | 26296 | Butte | Butte | 7 | 2020-06-28 | 150 | 2 | TRUE |
26297 | 26297 | Calaveras | Calaveras | 9 | 2020-06-28 | 32 | 0 | TRUE |
26298 | 26298 | Colusa | Colusa | 11 | 2020-06-28 | 17 | 0 | TRUE |
26299 | 26299 | Contra Costa | Contra Costa | 13 | 2020-06-28 | 2808 | 74 | |
26300 | 26300 | Del Norte | Del Norte | 15 | 2020-06-28 | 50 | 0 | TRUE |
26301 | 26301 | El Dorado | El Dorado | 17 | 2020-06-28 | 158 | 0 | TRUE |
26302 | 26302 | Fresno | Fresno | 19 | 2020-06-28 | 9057 | 72 | TRUE |
26303 | 26303 | Glenn | Glenn | 21 | 2020-06-28 | 87 | 0 | TRUE |
26304 | 26304 | Humboldt | Humboldt | 23 | 2020-06-28 | 129 | 4 | TRUE |
26305 | 26305 | Imperial | Imperial | 25 | 2020-06-28 | 6041 | 81 | TRUE |
26306 | 26306 | Inyo | Inyo | 27 | 2020-06-28 | 30 | 1 | TRUE |
26307 | 26307 | Kern | Kern | 29 | 2020-06-28 | 4478 | 67 | |
26308 | 26308 | Kings | Kings | 31 | 2020-06-28 | 2350 | 24 | |
26309 | 26309 | Lake | Lake | 33 | 2020-06-28 | 54 | 0 | |
26310 | 26310 | Lassen | Lassen | 35 | 2020-06-28 | 220 | 0 | |
26311 | 26311 | Long Beach | Los Angeles | 37 | 2020-06-28 | 3643 | 125 | TRUE |
26312 | 26312 | Los Angeles | Los Angeles | 37 | 2020-06-28 | 92999 | 3091 | |
26313 | 26313 | Pasadena | Los Angeles | 37 | 2020-06-28 | 1276 | 89 | |
26314 | 26314 | Madera | Madera | 39 | 2020-06-28 | 415 | 5 | TRUE |
26315 | 26315 | Marin | Marin | 41 | 2020-06-28 | 1998 | 18 | |
26316 | 26316 | Mariposa | Mariposa | 43 | 2020-06-28 | 23 | 1 | TRUE |
26317 | 26317 | Mendocino | Mendocino | 45 | 2020-06-28 | 76 | 0 | TRUE |
26318 | 26318 | Merced | Merced | 47 | 2020-06-28 | 824 | 11 | TRUE |
26319 | 26319 | Modoc | Modoc | 49 | 2020-06-28 | 0 | 0 | TRUE |
26320 | 26320 | Mono | Mono | 51 | 2020-06-28 | 40 | 1 | TRUE |
26321 | 26321 | Monterey | Monterey | 53 | 2020-06-28 | 1548 | 13 | |
26322 | 26322 | Napa | Napa | 55 | 2020-06-28 | 270 | 4 | TRUE |
26323 | 26323 | Nevada | Nevada | 57 | 2020-06-28 | 108 | 1 | TRUE |
26324 | 26324 | Orange | Orange | 59 | 2020-06-28 | 12608 | 326 | |
26325 | 26325 | Placer | Placer | 61 | 2020-06-28 | 627 | 11 | |
26326 | 26326 | Plumas | Plumas | 63 | 2020-06-28 | 7 | 0 | TRUE |
26327 | 26327 | Riverside | Riverside | 65 | 2020-06-28 | 15643 | 438 | TRUE |
26328 | 26328 | Sacramento | Sacramento | 67 | 2020-06-28 | 2776 | 66 | |
26329 | 26329 | San Benito | San Benito | 69 | 2020-06-28 | 206 | 2 | |
26330 | 26330 | San Bernardino | San Bernardino | 71 | 2020-06-28 | 11501 | 310 | |
26331 | 26331 | San Diego | San Diego | 73 | 2020-06-28 | 13334 | 361 | |
26332 | 26332 | San Francisco | San Francisco | 75 | 2020-06-28 | 3512 | 50 | |
26333 | 26333 | San Joaquin | San Joaquin | 77 | 2020-06-28 | 3417 | 52 | |
26334 | 26334 | San Luis Obispo | San Luis Obispo | 79 | 2020-06-28 | 508 | 1 | TRUE |
26335 | 26335 | San Mateo | San Mateo | 81 | 2020-06-28 | 3083 | 106 | TRUE |
26336 | 26336 | Santa Barbara | Santa Barbara | 83 | 2020-06-28 | 2712 | 28 | TRUE |
26337 | 26337 | Santa Clara | Santa Clara | 85 | 2020-06-28 | 4779 | 155 | |
26338 | 26338 | Santa Cruz | Santa Cruz | 87 | 2020-06-28 | 349 | 3 | |
26339 | 26339 | Shasta | Shasta | 89 | 2020-06-28 | 105 | 4 | |
26340 | 26340 | Sierra | Sierra | 91 | 2020-06-28 | 1 | 0 | TRUE |
26341 | 26341 | Siskiyou | Siskiyou | 93 | 2020-06-28 | 27 | 0 | |
26342 | 26342 | Solano | Solano | 95 | 2020-06-28 | 1118 | 23 | TRUE |
26343 | 26343 | Sonoma | Sonoma | 97 | 2020-06-28 | 1118 | 5 | |
26344 | 26344 | Stanislaus | Stanislaus | 99 | 2020-06-28 | 2115 | 41 | |
26345 | 26345 | Sutter | Sutter | 101 | 2020-06-28 | 160 | 3 | |
26346 | 26346 | Tehama | Tehama | 103 | 2020-06-28 | 62 | 1 | TRUE |
26347 | 26347 | Trinity | Trinity | 105 | 2020-06-28 | 2 | 0 | TRUE |
26348 | 26348 | Tulare | Tulare | 107 | 2020-06-28 | 3705 | 122 | TRUE |
26349 | 26349 | Tuolumne | Tuolumne | 109 | 2020-06-28 | 28 | 0 | |
26350 | 26350 | Ventura | Ventura | 111 | 2020-06-28 | 2336 | 44 | TRUE |
26351 | 26351 | Yolo | Yolo | 113 | 2020-06-28 | 479 | 24 | |
26352 | 26352 | Yuba | Yuba | 115 | 2020-06-28 | 65 | 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 );