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-10-02 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 |
---|---|---|---|---|---|---|---|---|
20436 | 20436 | Alameda | Alameda | 1 | 2020-10-02 | 20812 | 425 | |
20437 | 20437 | Berkeley | Alameda | 1 | 2020-10-02 | 713 | 10 | |
20438 | 20438 | Alpine | Alpine | 3 | 2020-10-02 | 2 | 0 | TRUE |
20439 | 20439 | Amador | Amador | 5 | 2020-10-02 | 259 | 15 | |
20440 | 20440 | Butte | Butte | 7 | 2020-10-02 | 2879 | 45 | |
20441 | 20441 | Calaveras | Calaveras | 9 | 2020-10-02 | 324 | 14 | |
20442 | 20442 | Colusa | Colusa | 11 | 2020-10-02 | 538 | 6 | |
20443 | 20443 | Contra Costa | Contra Costa | 13 | 2020-10-02 | 17069 | 211 | |
20444 | 20444 | Del Norte | Del Norte | 15 | 2020-10-02 | 146 | 1 | |
20445 | 20445 | El Dorado | El Dorado | 17 | 2020-10-02 | 1180 | 4 | |
20446 | 20446 | Fresno | Fresno | 19 | 2020-10-02 | 30953 | 399 | |
20447 | 20447 | Glenn | Glenn | 21 | 2020-10-02 | 603 | 3 | |
20448 | 20448 | Humboldt | Humboldt | 23 | 2020-10-02 | 518 | 8 | |
20449 | 20449 | Imperial | Imperial | 25 | 2020-10-02 | 12002 | 323 | |
20450 | 20450 | Inyo | Inyo | 27 | 2020-10-02 | 191 | 15 | |
20451 | 20451 | Kern | Kern | 29 | 2020-10-02 | 32343 | 381 | |
20452 | 20452 | Kings | Kings | 31 | 2020-10-02 | 7682 | 80 | |
20453 | 20453 | Lake | Lake | 33 | 2020-10-02 | 581 | 11 | |
20454 | 20454 | Lassen | Lassen | 35 | 2020-10-02 | 742 | 0 | |
20455 | 20455 | Long Beach | Los Angeles | 37 | 2020-10-02 | 12003 | 248 | |
20456 | 20456 | Los Angeles | Los Angeles | 37 | 2020-10-02 | 258051 | 6253 | |
20457 | 20457 | Pasadena | Los Angeles | 37 | 2020-10-02 | 2605 | 124 | |
20458 | 20458 | Madera | Madera | 39 | 2020-10-02 | 4642 | 70 | |
20459 | 20459 | Marin | Marin | 41 | 2020-10-02 | 6762 | 119 | |
20460 | 20460 | Mariposa | Mariposa | 43 | 2020-10-02 | 76 | 2 | |
20461 | 20461 | Mendocino | Mendocino | 45 | 2020-10-02 | 988 | 19 | |
20462 | 20462 | Merced | Merced | 47 | 2020-10-02 | 9033 | 145 | |
20463 | 20463 | Modoc | Modoc | 49 | 2020-10-02 | 27 | 0 | |
20464 | 20464 | Mono | Mono | 51 | 2020-10-02 | 169 | 2 | |
20465 | 20465 | Monterey | Monterey | 53 | 2020-10-02 | 10219 | 74 | |
20466 | 20466 | Napa | Napa | 55 | 2020-10-02 | 1734 | 12 | |
20467 | 20467 | Nevada | Nevada | 57 | 2020-10-02 | 543 | 7 | |
20468 | 20468 | Orange | Orange | 59 | 2020-10-02 | 54118 | 1281 | |
20469 | 20469 | Placer | Placer | 61 | 2020-10-02 | 3628 | 49 | |
20470 | 20470 | Plumas | Plumas | 63 | 2020-10-02 | 51 | 0 | |
20471 | 20471 | Riverside | Riverside | 65 | 2020-10-02 | 59934 | 1231 | |
20472 | 20472 | Sacramento | Sacramento | 67 | 2020-10-02 | 22855 | 430 | |
20473 | 20473 | San Benito | San Benito | 69 | 2020-10-02 | 1358 | 11 | |
20474 | 20474 | San Bernardino | San Bernardino | 71 | 2020-10-02 | 55671 | 1123 | |
20475 | 20475 | San Diego | San Diego | 73 | 2020-10-02 | 47791 | 794 | |
20476 | 20476 | San Francisco | San Francisco | 75 | 2020-10-02 | 11360 | 107 | |
20477 | 20477 | San Joaquin | San Joaquin | 77 | 2020-10-02 | 20485 | 470 | |
20478 | 20478 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-02 | 3685 | 31 | |
20479 | 20479 | San Mateo | San Mateo | 81 | 2020-10-02 | 10126 | 152 | |
20480 | 20480 | Santa Barbara | Santa Barbara | 83 | 2020-10-02 | 9249 | 115 | |
20481 | 20481 | Santa Clara | Santa Clara | 85 | 2020-10-02 | 22048 | 317 | |
20482 | 20482 | Santa Cruz | Santa Cruz | 87 | 2020-10-02 | 2481 | 12 | |
20483 | 20483 | Shasta | Shasta | 89 | 2020-10-02 | 953 | 22 | |
20484 | 20484 | Sierra | Sierra | 91 | 2020-10-02 | 6 | 0 | |
20485 | 20485 | Siskiyou | Siskiyou | 93 | 2020-10-02 | 167 | 0 | |
20486 | 20486 | Solano | Solano | 95 | 2020-10-02 | 6520 | 71 | |
20487 | 20487 | Sonoma | Sonoma | 97 | 2020-10-02 | 7752 | 122 | |
20488 | 20488 | Stanislaus | Stanislaus | 99 | 2020-10-02 | 16628 | 368 | |
20489 | 20489 | Sutter | Sutter | 101 | 2020-10-02 | 1748 | 11 | |
20490 | 20490 | Tehama | Tehama | 103 | 2020-10-02 | 605 | 6 | |
20491 | 20491 | Trinity | Trinity | 105 | 2020-10-02 | 16 | 0 | |
20492 | 20492 | Tulare | Tulare | 107 | 2020-10-02 | 16399 | 265 | |
20493 | 20493 | Tuolumne | Tuolumne | 109 | 2020-10-02 | 230 | 4 | |
20494 | 20494 | Ventura | Ventura | 111 | 2020-10-02 | 12943 | 153 | |
20495 | 20495 | Yolo | Yolo | 113 | 2020-10-02 | 2847 | 55 | |
20496 | 20496 | Yuba | Yuba | 115 | 2020-10-02 | 1188 | 9 |
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 );