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-02 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
9334 | 9334 | Alameda | Alameda | 1 | 2021-04-02 | 80800 | 1204 | |
9335 | 9335 | Berkeley | Alameda | 1 | 2021-04-02 | 3462 | 46 | |
9336 | 9336 | Alpine | Alpine | 3 | 2021-04-02 | 88 | 0 | TRUE |
9337 | 9337 | Amador | Amador | 5 | 2021-04-02 | 3539 | 45 | |
9338 | 9338 | Butte | Butte | 7 | 2021-04-02 | 11350 | 178 | |
9339 | 9339 | Calaveras | Calaveras | 9 | 2021-04-02 | 2018 | 51 | |
9340 | 9340 | Colusa | Colusa | 11 | 2021-04-02 | 2165 | 16 | |
9341 | 9341 | Contra Costa | Contra Costa | 13 | 2021-04-02 | 65559 | 760 | |
9342 | 9342 | Del Norte | Del Norte | 15 | 2021-04-02 | 1213 | 5 | |
9343 | 9343 | El Dorado | El Dorado | 17 | 2021-04-02 | 9488 | 108 | |
9344 | 9344 | Fresno | Fresno | 19 | 2021-04-02 | 99242 | 1597 | |
9345 | 9345 | Glenn | Glenn | 21 | 2021-04-02 | 2270 | 25 | |
9346 | 9346 | Humboldt | Humboldt | 23 | 2021-04-02 | 3492 | 36 | |
9347 | 9347 | Imperial | Imperial | 25 | 2021-04-02 | 27209 | 715 | |
9348 | 9348 | Inyo | Inyo | 27 | 2021-04-02 | 1401 | 38 | |
9349 | 9349 | Kern | Kern | 29 | 2021-04-02 | 106329 | 1277 | |
9350 | 9350 | Kings | Kings | 31 | 2021-04-02 | 22659 | 241 | |
9351 | 9351 | Lake | Lake | 33 | 2021-04-02 | 3322 | 43 | |
9352 | 9352 | Lassen | Lassen | 35 | 2021-04-02 | 5652 | 24 | TRUE |
9353 | 9353 | Long Beach | Los Angeles | 37 | 2021-04-02 | 52255 | 913 | |
9354 | 9354 | Los Angeles | Los Angeles | 37 | 2021-04-02 | 1157487 | 21988 | |
9355 | 9355 | Pasadena | Los Angeles | 37 | 2021-04-02 | 11151 | 335 | |
9356 | 9356 | Madera | Madera | 39 | 2021-04-02 | 15944 | 234 | |
9357 | 9357 | Marin | Marin | 41 | 2021-04-02 | 13713 | 203 | |
9358 | 9358 | Mariposa | Mariposa | 43 | 2021-04-02 | 410 | 7 | |
9359 | 9359 | Mendocino | Mendocino | 45 | 2021-04-02 | 3949 | 46 | |
9360 | 9360 | Merced | Merced | 47 | 2021-04-02 | 30687 | 439 | |
9361 | 9361 | Modoc | Modoc | 49 | 2021-04-02 | 474 | 4 | TRUE |
9362 | 9362 | Mono | Mono | 51 | 2021-04-02 | 1268 | 4 | |
9363 | 9363 | Monterey | Monterey | 53 | 2021-04-02 | 42979 | 342 | |
9364 | 9364 | Napa | Napa | 55 | 2021-04-02 | 9453 | 78 | |
9365 | 9365 | Nevada | Nevada | 57 | 2021-04-02 | 4316 | 74 | |
9366 | 9366 | Orange | Orange | 59 | 2021-04-02 | 250854 | 4761 | |
9367 | 9367 | Placer | Placer | 61 | 2021-04-02 | 21095 | 276 | |
9368 | 9368 | Plumas | Plumas | 63 | 2021-04-02 | 685 | 6 | |
9369 | 9369 | Riverside | Riverside | 65 | 2021-04-02 | 294736 | 4362 | |
9370 | 9370 | Sacramento | Sacramento | 67 | 2021-04-02 | 98488 | 1613 | |
9371 | 9371 | San Benito | San Benito | 69 | 2021-04-02 | 5875 | 61 | |
9372 | 9372 | San Bernardino | San Bernardino | 71 | 2021-04-02 | 291199 | 4744 | |
9373 | 9373 | San Diego | San Diego | 73 | 2021-04-02 | 271035 | 3568 | |
9374 | 9374 | San Francisco | San Francisco | 75 | 2021-04-02 | 35170 | 474 | |
9375 | 9375 | San Joaquin | San Joaquin | 77 | 2021-04-02 | 70117 | 1310 | |
9376 | 9376 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-02 | 20547 | 256 | |
9377 | 9377 | San Mateo | San Mateo | 81 | 2021-04-02 | 40462 | 553 | |
9378 | 9378 | Santa Barbara | Santa Barbara | 83 | 2021-04-02 | 33270 | 440 | |
9379 | 9379 | Santa Clara | Santa Clara | 85 | 2021-04-02 | 114182 | 1653 | |
9380 | 9380 | Santa Cruz | Santa Cruz | 87 | 2021-04-02 | 15247 | 200 | TRUE |
9381 | 9381 | Shasta | Shasta | 89 | 2021-04-02 | 11399 | 208 | |
9382 | 9382 | Sierra | Sierra | 91 | 2021-04-02 | 106 | 0 | |
9383 | 9383 | Siskiyou | Siskiyou | 93 | 2021-04-02 | 1885 | 16 | |
9384 | 9384 | Solano | Solano | 95 | 2021-04-02 | 31301 | 197 | |
9385 | 9385 | Sonoma | Sonoma | 97 | 2021-04-02 | 29257 | 309 | |
9386 | 9386 | Stanislaus | Stanislaus | 99 | 2021-04-02 | 52913 | 1003 | |
9387 | 9387 | Sutter | Sutter | 101 | 2021-04-02 | 9175 | 102 | |
9388 | 9388 | Tehama | Tehama | 103 | 2021-04-02 | 5310 | 54 | |
9389 | 9389 | Trinity | Trinity | 105 | 2021-04-02 | 392 | 5 | |
9390 | 9390 | Tulare | Tulare | 107 | 2021-04-02 | 49100 | 813 | |
9391 | 9391 | Tuolumne | Tuolumne | 109 | 2021-04-02 | 4043 | 62 | |
9392 | 9392 | Ventura | Ventura | 111 | 2021-04-02 | 79774 | 986 | |
9393 | 9393 | Yolo | Yolo | 113 | 2021-04-02 | 13233 | 198 | |
9394 | 9394 | Yuba | Yuba | 115 | 2021-04-02 | 6021 | 40 |
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 );