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-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
19704 | 19704 | Alameda | Alameda | 1 | 2020-10-14 | 21602 | 428 | |
19705 | 19705 | Berkeley | Alameda | 1 | 2020-10-14 | 733 | 10 | |
19706 | 19706 | Alpine | Alpine | 3 | 2020-10-14 | 3 | 0 | TRUE |
19707 | 19707 | Amador | Amador | 5 | 2020-10-14 | 271 | 15 | |
19708 | 19708 | Butte | Butte | 7 | 2020-10-14 | 2995 | 50 | |
19709 | 19709 | Calaveras | Calaveras | 9 | 2020-10-14 | 331 | 16 | TRUE |
19710 | 19710 | Colusa | Colusa | 11 | 2020-10-14 | 545 | 6 | |
19711 | 19711 | Contra Costa | Contra Costa | 13 | 2020-10-14 | 17866 | 233 | |
19712 | 19712 | Del Norte | Del Norte | 15 | 2020-10-14 | 171 | 1 | |
19713 | 19713 | El Dorado | El Dorado | 17 | 2020-10-14 | 1263 | 4 | |
19714 | 19714 | Fresno | Fresno | 19 | 2020-10-14 | 32228 | 424 | |
19715 | 19715 | Glenn | Glenn | 21 | 2020-10-14 | 635 | 3 | |
19716 | 19716 | Humboldt | Humboldt | 23 | 2020-10-14 | 542 | 8 | |
19717 | 19717 | Imperial | Imperial | 25 | 2020-10-14 | 12334 | 335 | |
19718 | 19718 | Inyo | Inyo | 27 | 2020-10-14 | 209 | 15 | |
19719 | 19719 | Kern | Kern | 29 | 2020-10-14 | 33145 | 406 | |
19720 | 19720 | Kings | Kings | 31 | 2020-10-14 | 8103 | 82 | |
19721 | 19721 | Lake | Lake | 33 | 2020-10-14 | 639 | 14 | |
19722 | 19722 | Lassen | Lassen | 35 | 2020-10-14 | 751 | 1 | |
19723 | 19723 | Long Beach | Los Angeles | 37 | 2020-10-14 | 12517 | 254 | |
19724 | 19724 | Los Angeles | Los Angeles | 37 | 2020-10-14 | 269839 | 6429 | |
19725 | 19725 | Pasadena | Los Angeles | 37 | 2020-10-14 | 2660 | 129 | |
19726 | 19726 | Madera | Madera | 39 | 2020-10-14 | 4808 | 73 | |
19727 | 19727 | Marin | Marin | 41 | 2020-10-14 | 6940 | 124 | |
19728 | 19728 | Mariposa | Mariposa | 43 | 2020-10-14 | 77 | 2 | |
19729 | 19729 | Mendocino | Mendocino | 45 | 2020-10-14 | 1063 | 21 | |
19730 | 19730 | Merced | Merced | 47 | 2020-10-14 | 9286 | 152 | |
19731 | 19731 | Modoc | Modoc | 49 | 2020-10-14 | 27 | 0 | TRUE |
19732 | 19732 | Mono | Mono | 51 | 2020-10-14 | 173 | 2 | TRUE |
19733 | 19733 | Monterey | Monterey | 53 | 2020-10-14 | 10827 | 81 | |
19734 | 19734 | Napa | Napa | 55 | 2020-10-14 | 1832 | 13 | |
19735 | 19735 | Nevada | Nevada | 57 | 2020-10-14 | 576 | 8 | |
19736 | 19736 | Orange | Orange | 59 | 2020-10-14 | 56283 | 1360 | |
19737 | 19737 | Placer | Placer | 61 | 2020-10-14 | 3845 | 51 | |
19738 | 19738 | Plumas | Plumas | 63 | 2020-10-14 | 53 | 0 | TRUE |
19739 | 19739 | Riverside | Riverside | 65 | 2020-10-14 | 62900 | 1264 | |
19740 | 19740 | Sacramento | Sacramento | 67 | 2020-10-14 | 24060 | 462 | |
19741 | 19741 | San Benito | San Benito | 69 | 2020-10-14 | 1390 | 13 | |
19742 | 19742 | San Bernardino | San Bernardino | 71 | 2020-10-14 | 58936 | 1171 | |
19743 | 19743 | San Diego | San Diego | 73 | 2020-10-14 | 51327 | 844 | |
19744 | 19744 | San Francisco | San Francisco | 75 | 2020-10-14 | 11712 | 123 | |
19745 | 19745 | San Joaquin | San Joaquin | 77 | 2020-10-14 | 21100 | 483 | |
19746 | 19746 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-14 | 3933 | 32 | |
19747 | 19747 | San Mateo | San Mateo | 81 | 2020-10-14 | 10622 | 155 | |
19748 | 19748 | Santa Barbara | Santa Barbara | 83 | 2020-10-14 | 9520 | 117 | |
19749 | 19749 | Santa Clara | Santa Clara | 85 | 2020-10-14 | 23322 | 337 | |
19750 | 19750 | Santa Cruz | Santa Cruz | 87 | 2020-10-14 | 2633 | 23 | |
19751 | 19751 | Shasta | Shasta | 89 | 2020-10-14 | 1623 | 28 | |
19752 | 19752 | Sierra | Sierra | 91 | 2020-10-14 | 6 | 0 | TRUE |
19753 | 19753 | Siskiyou | Siskiyou | 93 | 2020-10-14 | 183 | 0 | |
19754 | 19754 | Solano | Solano | 95 | 2020-10-14 | 6908 | 74 | |
19755 | 19755 | Sonoma | Sonoma | 97 | 2020-10-14 | 8615 | 128 | |
19756 | 19756 | Stanislaus | Stanislaus | 99 | 2020-10-14 | 17130 | 388 | |
19757 | 19757 | Sutter | Sutter | 101 | 2020-10-14 | 1785 | 12 | |
19758 | 19758 | Tehama | Tehama | 103 | 2020-10-14 | 722 | 8 | |
19759 | 19759 | Trinity | Trinity | 105 | 2020-10-14 | 20 | 0 | TRUE |
19760 | 19760 | Tulare | Tulare | 107 | 2020-10-14 | 17015 | 273 | |
19761 | 19761 | Tuolumne | Tuolumne | 109 | 2020-10-14 | 242 | 4 | |
19762 | 19762 | Ventura | Ventura | 111 | 2020-10-14 | 13491 | 158 | |
19763 | 19763 | Yolo | Yolo | 113 | 2020-10-14 | 3010 | 56 | |
19764 | 19764 | Yuba | Yuba | 115 | 2020-10-14 | 1243 | 10 |
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 );