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-08-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
23547 | 23547 | Alameda | Alameda | 1 | 2020-08-12 | 13817 | 274 | |
23548 | 23548 | Berkeley | Alameda | 1 | 2020-08-12 | 452 | 8 | |
23549 | 23549 | Alpine | Alpine | 3 | 2020-08-12 | 2 | 0 | TRUE |
23550 | 23550 | Amador | Amador | 5 | 2020-08-12 | 198 | 10 | |
23551 | 23551 | Butte | Butte | 7 | 2020-08-12 | 1317 | 8 | |
23552 | 23552 | Calaveras | Calaveras | 9 | 2020-08-12 | 161 | 1 | TRUE |
23553 | 23553 | Colusa | Colusa | 11 | 2020-08-12 | 397 | 5 | |
23554 | 23554 | Contra Costa | Contra Costa | 13 | 2020-08-12 | 10103 | 149 | |
23555 | 23555 | Del Norte | Del Norte | 15 | 2020-08-12 | 104 | 0 | |
23556 | 23556 | El Dorado | El Dorado | 17 | 2020-08-12 | 793 | 2 | |
23557 | 23557 | Fresno | Fresno | 19 | 2020-08-12 | 24586 | 191 | |
23558 | 23558 | Glenn | Glenn | 21 | 2020-08-12 | 403 | 3 | |
23559 | 23559 | Humboldt | Humboldt | 23 | 2020-08-12 | 299 | 4 | |
23560 | 23560 | Imperial | Imperial | 25 | 2020-08-12 | 9919 | 252 | |
23561 | 23561 | Inyo | Inyo | 27 | 2020-08-12 | 115 | 5 | |
23562 | 23562 | Kern | Kern | 29 | 2020-08-12 | 25179 | 183 | |
23563 | 23563 | Kings | Kings | 31 | 2020-08-12 | 5127 | 62 | |
23564 | 23564 | Lake | Lake | 33 | 2020-08-12 | 260 | 2 | |
23565 | 23565 | Lassen | Lassen | 35 | 2020-08-12 | 694 | 0 | |
23566 | 23566 | Long Beach | Los Angeles | 37 | 2020-08-12 | 9283 | 187 | |
23567 | 23567 | Los Angeles | Los Angeles | 37 | 2020-08-12 | 202854 | 4814 | |
23568 | 23568 | Pasadena | Los Angeles | 37 | 2020-08-12 | 2146 | 111 | |
23569 | 23569 | Madera | Madera | 39 | 2020-08-12 | 2759 | 44 | |
23570 | 23570 | Marin | Marin | 41 | 2020-08-12 | 5583 | 81 | |
23571 | 23571 | Mariposa | Mariposa | 43 | 2020-08-12 | 63 | 2 | |
23572 | 23572 | Mendocino | Mendocino | 45 | 2020-08-12 | 489 | 10 | |
23573 | 23573 | Merced | Merced | 47 | 2020-08-12 | 6224 | 74 | |
23574 | 23574 | Modoc | Modoc | 49 | 2020-08-12 | 5 | 0 | |
23575 | 23575 | Mono | Mono | 51 | 2020-08-12 | 160 | 1 | |
23576 | 23576 | Monterey | Monterey | 53 | 2020-08-12 | 5628 | 39 | |
23577 | 23577 | Napa | Napa | 55 | 2020-08-12 | 1142 | 11 | |
23578 | 23578 | Nevada | Nevada | 57 | 2020-08-12 | 357 | 1 | |
23579 | 23579 | Orange | Orange | 59 | 2020-08-12 | 41823 | 745 | |
23580 | 23580 | Placer | Placer | 61 | 2020-08-12 | 2413 | 26 | |
23581 | 23581 | Plumas | Plumas | 63 | 2020-08-12 | 38 | 0 | |
23582 | 23582 | Riverside | Riverside | 65 | 2020-08-12 | 43983 | 853 | |
23583 | 23583 | Sacramento | Sacramento | 67 | 2020-08-12 | 12478 | 186 | |
23584 | 23584 | San Benito | San Benito | 69 | 2020-08-12 | 773 | 4 | |
23585 | 23585 | San Bernardino | San Bernardino | 71 | 2020-08-12 | 38290 | 840 | |
23586 | 23586 | San Diego | San Diego | 73 | 2020-08-12 | 33393 | 608 | |
23587 | 23587 | San Francisco | San Francisco | 75 | 2020-08-12 | 7834 | 67 | |
23588 | 23588 | San Joaquin | San Joaquin | 77 | 2020-08-12 | 14026 | 239 | |
23589 | 23589 | San Luis Obispo | San Luis Obispo | 79 | 2020-08-12 | 2300 | 17 | |
23590 | 23590 | San Mateo | San Mateo | 81 | 2020-08-12 | 6535 | 122 | |
23591 | 23591 | Santa Barbara | Santa Barbara | 83 | 2020-08-12 | 7083 | 73 | |
23592 | 23592 | Santa Clara | Santa Clara | 85 | 2020-08-12 | 14742 | 210 | |
23593 | 23593 | Santa Cruz | Santa Cruz | 87 | 2020-08-12 | 1316 | 6 | |
23594 | 23594 | Shasta | Shasta | 89 | 2020-08-12 | 476 | 10 | |
23595 | 23595 | Sierra | Sierra | 91 | 2020-08-12 | 5 | 0 | |
23596 | 23596 | Siskiyou | Siskiyou | 93 | 2020-08-12 | 108 | 0 | |
23597 | 23597 | Solano | Solano | 95 | 2020-08-12 | 4414 | 41 | |
23598 | 23598 | Sonoma | Sonoma | 97 | 2020-08-12 | 3825 | 51 | TRUE |
23599 | 23599 | Stanislaus | Stanislaus | 99 | 2020-08-12 | 11592 | 182 | |
23600 | 23600 | Sutter | Sutter | 101 | 2020-08-12 | 1041 | 7 | |
23601 | 23601 | Tehama | Tehama | 103 | 2020-08-12 | 304 | 1 | |
23602 | 23602 | Trinity | Trinity | 105 | 2020-08-12 | 6 | 0 | |
23603 | 23603 | Tulare | Tulare | 107 | 2020-08-12 | 11643 | 205 | |
23604 | 23604 | Tuolumne | Tuolumne | 109 | 2020-08-12 | 159 | 2 | |
23605 | 23605 | Ventura | Ventura | 111 | 2020-08-12 | 8790 | 93 | |
23606 | 23606 | Yolo | Yolo | 113 | 2020-08-12 | 1918 | 45 | |
23607 | 23607 | Yuba | Yuba | 115 | 2020-08-12 | 688 | 4 |
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 );