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 2021-04-03 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 |
---|---|---|---|---|---|---|---|---|
9273 | 9273 | Alameda | Alameda | 1 | 2021-04-03 | 80885 | 1204 | |
9274 | 9274 | Berkeley | Alameda | 1 | 2021-04-03 | 3466 | 46 | |
9275 | 9275 | Alpine | Alpine | 3 | 2021-04-03 | 88 | 0 | TRUE |
9276 | 9276 | Amador | Amador | 5 | 2021-04-03 | 3539 | 45 | TRUE |
9277 | 9277 | Butte | Butte | 7 | 2021-04-03 | 11359 | 178 | TRUE |
9278 | 9278 | Calaveras | Calaveras | 9 | 2021-04-03 | 2018 | 51 | TRUE |
9279 | 9279 | Colusa | Colusa | 11 | 2021-04-03 | 2165 | 16 | TRUE |
9280 | 9280 | Contra Costa | Contra Costa | 13 | 2021-04-03 | 65598 | 760 | |
9281 | 9281 | Del Norte | Del Norte | 15 | 2021-04-03 | 1218 | 5 | |
9282 | 9282 | El Dorado | El Dorado | 17 | 2021-04-03 | 9488 | 108 | TRUE |
9283 | 9283 | Fresno | Fresno | 19 | 2021-04-03 | 99296 | 1597 | |
9284 | 9284 | Glenn | Glenn | 21 | 2021-04-03 | 2270 | 25 | TRUE |
9285 | 9285 | Humboldt | Humboldt | 23 | 2021-04-03 | 3492 | 36 | TRUE |
9286 | 9286 | Imperial | Imperial | 25 | 2021-04-03 | 27209 | 715 | TRUE |
9287 | 9287 | Inyo | Inyo | 27 | 2021-04-03 | 1401 | 38 | |
9288 | 9288 | Kern | Kern | 29 | 2021-04-03 | 106420 | 1281 | |
9289 | 9289 | Kings | Kings | 31 | 2021-04-03 | 22666 | 241 | |
9290 | 9290 | Lake | Lake | 33 | 2021-04-03 | 3322 | 43 | TRUE |
9291 | 9291 | Lassen | Lassen | 35 | 2021-04-03 | 5652 | 24 | TRUE |
9292 | 9292 | Long Beach | Los Angeles | 37 | 2021-04-03 | 52293 | 913 | TRUE |
9293 | 9293 | Los Angeles | Los Angeles | 37 | 2021-04-03 | 1157848 | 22026 | TRUE |
9294 | 9294 | Pasadena | Los Angeles | 37 | 2021-04-03 | 11151 | 335 | TRUE |
9295 | 9295 | Madera | Madera | 39 | 2021-04-03 | 15944 | 234 | TRUE |
9296 | 9296 | Marin | Marin | 41 | 2021-04-03 | 13719 | 203 | |
9297 | 9297 | Mariposa | Mariposa | 43 | 2021-04-03 | 410 | 7 | TRUE |
9298 | 9298 | Mendocino | Mendocino | 45 | 2021-04-03 | 3949 | 46 | TRUE |
9299 | 9299 | Merced | Merced | 47 | 2021-04-03 | 30687 | 439 | TRUE |
9300 | 9300 | Modoc | Modoc | 49 | 2021-04-03 | 474 | 4 | TRUE |
9301 | 9301 | Mono | Mono | 51 | 2021-04-03 | 1268 | 4 | TRUE |
9302 | 9302 | Monterey | Monterey | 53 | 2021-04-03 | 43002 | 342 | |
9303 | 9303 | Napa | Napa | 55 | 2021-04-03 | 9453 | 78 | TRUE |
9304 | 9304 | Nevada | Nevada | 57 | 2021-04-03 | 4316 | 74 | TRUE |
9305 | 9305 | Orange | Orange | 59 | 2021-04-03 | 251102 | 4768 | |
9306 | 9306 | Placer | Placer | 61 | 2021-04-03 | 21095 | 276 | TRUE |
9307 | 9307 | Plumas | Plumas | 63 | 2021-04-03 | 685 | 6 | |
9308 | 9308 | Riverside | Riverside | 65 | 2021-04-03 | 294736 | 4362 | TRUE |
9309 | 9309 | Sacramento | Sacramento | 67 | 2021-04-03 | 98488 | 1613 | TRUE |
9310 | 9310 | San Benito | San Benito | 69 | 2021-04-03 | 5879 | 61 | |
9311 | 9311 | San Bernardino | San Bernardino | 71 | 2021-04-03 | 291360 | 4747 | |
9312 | 9312 | San Diego | San Diego | 73 | 2021-04-03 | 271334 | 3571 | |
9313 | 9313 | San Francisco | San Francisco | 75 | 2021-04-03 | 35220 | 476 | |
9314 | 9314 | San Joaquin | San Joaquin | 77 | 2021-04-03 | 70117 | 1310 | TRUE |
9315 | 9315 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-03 | 20547 | 256 | TRUE |
9316 | 9316 | San Mateo | San Mateo | 81 | 2021-04-03 | 40542 | 553 | |
9317 | 9317 | Santa Barbara | Santa Barbara | 83 | 2021-04-03 | 33297 | 440 | |
9318 | 9318 | Santa Clara | Santa Clara | 85 | 2021-04-03 | 114254 | 1655 | |
9319 | 9319 | Santa Cruz | Santa Cruz | 87 | 2021-04-03 | 15247 | 200 | TRUE |
9320 | 9320 | Shasta | Shasta | 89 | 2021-04-03 | 11399 | 208 | TRUE |
9321 | 9321 | Sierra | Sierra | 91 | 2021-04-03 | 106 | 0 | TRUE |
9322 | 9322 | Siskiyou | Siskiyou | 93 | 2021-04-03 | 1885 | 16 | TRUE |
9323 | 9323 | Solano | Solano | 95 | 2021-04-03 | 31301 | 197 | TRUE |
9324 | 9324 | Sonoma | Sonoma | 97 | 2021-04-03 | 29310 | 309 | |
9325 | 9325 | Stanislaus | Stanislaus | 99 | 2021-04-03 | 52966 | 1003 | |
9326 | 9326 | Sutter | Sutter | 101 | 2021-04-03 | 9175 | 102 | |
9327 | 9327 | Tehama | Tehama | 103 | 2021-04-03 | 5324 | 54 | |
9328 | 9328 | Trinity | Trinity | 105 | 2021-04-03 | 392 | 5 | |
9329 | 9329 | Tulare | Tulare | 107 | 2021-04-03 | 49100 | 813 | TRUE |
9330 | 9330 | Tuolumne | Tuolumne | 109 | 2021-04-03 | 4043 | 62 | TRUE |
9331 | 9331 | Ventura | Ventura | 111 | 2021-04-03 | 79774 | 986 | TRUE |
9332 | 9332 | Yolo | Yolo | 113 | 2021-04-03 | 13233 | 198 | TRUE |
9333 | 9333 | Yuba | Yuba | 115 | 2021-04-03 | 6021 | 40 | TRUE |
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 );