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-07-07 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 |
---|---|---|---|---|---|---|---|---|
3478 | 3478 | Alameda | Alameda | 1 | 2021-07-07 | 86800 | 1217 | |
3479 | 3479 | Berkeley | Alameda | 1 | 2021-07-07 | 3683 | 50 | |
3480 | 3480 | Alpine | Alpine | 3 | 2021-07-07 | 89 | 0 | TRUE |
3481 | 3481 | Amador | Amador | 5 | 2021-07-07 | 3738 | 47 | TRUE |
3482 | 3482 | Butte | Butte | 7 | 2021-07-07 | 12750 | 198 | TRUE |
3483 | 3483 | Calaveras | Calaveras | 9 | 2021-07-07 | 2228 | 58 | |
3484 | 3484 | Colusa | Colusa | 11 | 2021-07-07 | 2308 | 18 | |
3485 | 3485 | Contra Costa | Contra Costa | 13 | 2021-07-07 | 71694 | 819 | |
3486 | 3486 | Del Norte | Del Norte | 15 | 2021-07-07 | 1491 | 8 | |
3487 | 3487 | El Dorado | El Dorado | 17 | 2021-07-07 | 10533 | 118 | |
3488 | 3488 | Fresno | Fresno | 19 | 2021-07-07 | 102746 | 1727 | TRUE |
3489 | 3489 | Glenn | Glenn | 21 | 2021-07-07 | 2373 | 27 | TRUE |
3490 | 3490 | Humboldt | Humboldt | 23 | 2021-07-07 | 4614 | 51 | |
3491 | 3491 | Imperial | Imperial | 25 | 2021-07-07 | 28452 | 742 | |
3492 | 3492 | Inyo | Inyo | 27 | 2021-07-07 | 1441 | 38 | TRUE |
3493 | 3493 | Kern | Kern | 29 | 2021-07-07 | 111273 | 1409 | |
3494 | 3494 | Kings | Kings | 31 | 2021-07-07 | 23134 | 247 | TRUE |
3495 | 3495 | Lake | Lake | 33 | 2021-07-07 | 3607 | 62 | TRUE |
3496 | 3496 | Lassen | Lassen | 35 | 2021-07-07 | 5829 | 26 | |
3497 | 3497 | Long Beach | Los Angeles | 37 | 2021-07-07 | 53811 | 945 | |
3498 | 3498 | Los Angeles | Los Angeles | 37 | 2021-07-07 | 1188414 | 23219 | |
3499 | 3499 | Pasadena | Los Angeles | 37 | 2021-07-07 | 11397 | 350 | |
3500 | 3500 | Madera | Madera | 39 | 2021-07-07 | 16622 | 246 | TRUE |
3501 | 3501 | Marin | Marin | 41 | 2021-07-07 | 14290 | 212 | |
3502 | 3502 | Mariposa | Mariposa | 43 | 2021-07-07 | 468 | 7 | |
3503 | 3503 | Mendocino | Mendocino | 45 | 2021-07-07 | 4412 | 50 | TRUE |
3504 | 3504 | Merced | Merced | 47 | 2021-07-07 | 32444 | 482 | |
3505 | 3505 | Modoc | Modoc | 49 | 2021-07-07 | 571 | 6 | |
3506 | 3506 | Mono | Mono | 51 | 2021-07-07 | 1300 | 4 | |
3507 | 3507 | Monterey | Monterey | 53 | 2021-07-07 | 43974 | 497 | |
3508 | 3508 | Napa | Napa | 55 | 2021-07-07 | 10093 | 80 | |
3509 | 3509 | Nevada | Nevada | 57 | 2021-07-07 | 5001 | 75 | |
3510 | 3510 | Orange | Orange | 59 | 2021-07-07 | 256776 | 5124 | TRUE |
3511 | 3511 | Placer | Placer | 61 | 2021-07-07 | 23943 | 303 | |
3512 | 3512 | Plumas | Plumas | 63 | 2021-07-07 | 742 | 6 | TRUE |
3513 | 3513 | Riverside | Riverside | 65 | 2021-07-07 | 302069 | 4647 | |
3514 | 3514 | Sacramento | Sacramento | 67 | 2021-07-07 | 109393 | 1748 | |
3515 | 3515 | San Benito | San Benito | 69 | 2021-07-07 | 6156 | 63 | |
3516 | 3516 | San Bernardino | San Bernardino | 71 | 2021-07-07 | 300218 | 4848 | |
3517 | 3517 | San Diego | San Diego | 73 | 2021-07-07 | 283376 | 3782 | |
3518 | 3518 | San Francisco | San Francisco | 75 | 2021-07-07 | 37242 | 555 | |
3519 | 3519 | San Joaquin | San Joaquin | 77 | 2021-07-07 | 75133 | 1442 | |
3520 | 3520 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-07 | 21518 | 261 | |
3521 | 3521 | San Mateo | San Mateo | 81 | 2021-07-07 | 42624 | 581 | |
3522 | 3522 | Santa Barbara | Santa Barbara | 83 | 2021-07-07 | 34703 | 457 | |
3523 | 3523 | Santa Clara | Santa Clara | 85 | 2021-07-07 | 119678 | 1698 | |
3524 | 3524 | Santa Cruz | Santa Cruz | 87 | 2021-07-07 | 16306 | 207 | |
3525 | 3525 | Shasta | Shasta | 89 | 2021-07-07 | 12605 | 235 | TRUE |
3526 | 3526 | Sierra | Sierra | 91 | 2021-07-07 | 122 | 0 | TRUE |
3527 | 3527 | Siskiyou | Siskiyou | 93 | 2021-07-07 | 2423 | 40 | |
3528 | 3528 | Solano | Solano | 95 | 2021-07-07 | 34149 | 245 | |
3529 | 3529 | Sonoma | Sonoma | 97 | 2021-07-07 | 31160 | 318 | TRUE |
3530 | 3530 | Stanislaus | Stanislaus | 99 | 2021-07-07 | 57365 | 1077 | |
3531 | 3531 | Sutter | Sutter | 101 | 2021-07-07 | 9756 | 108 | |
3532 | 3532 | Tehama | Tehama | 103 | 2021-07-07 | 5766 | 59 | |
3533 | 3533 | Trinity | Trinity | 105 | 2021-07-07 | 428 | 6 | TRUE |
3534 | 3534 | Tulare | Tulare | 107 | 2021-07-07 | 49915 | 852 | |
3535 | 3535 | Tuolumne | Tuolumne | 109 | 2021-07-07 | 4258 | 72 | |
3536 | 3536 | Ventura | Ventura | 111 | 2021-07-07 | 81972 | 1032 | |
3537 | 3537 | Yolo | Yolo | 113 | 2021-07-07 | 14180 | 210 | |
3538 | 3538 | Yuba | Yuba | 115 | 2021-07-07 | 6577 | 41 |
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 );