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-11-26 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 |
---|---|---|---|---|---|---|---|---|
17081 | 17081 | Alameda | Alameda | 1 | 2020-11-26 | 28070 | 507 | TRUE |
17082 | 17082 | Berkeley | Alameda | 1 | 2020-11-26 | 1127 | 10 | TRUE |
17083 | 17083 | Alpine | Alpine | 3 | 2020-11-26 | 47 | 0 | TRUE |
17084 | 17084 | Amador | Amador | 5 | 2020-11-26 | 520 | 15 | |
17085 | 17085 | Butte | Butte | 7 | 2020-11-26 | 3894 | 59 | TRUE |
17086 | 17086 | Calaveras | Calaveras | 9 | 2020-11-26 | 450 | 22 | TRUE |
17087 | 17087 | Colusa | Colusa | 11 | 2020-11-26 | 694 | 6 | TRUE |
17088 | 17088 | Contra Costa | Contra Costa | 13 | 2020-11-26 | 23571 | 261 | |
17089 | 17089 | Del Norte | Del Norte | 15 | 2020-11-26 | 313 | 1 | TRUE |
17090 | 17090 | El Dorado | El Dorado | 17 | 2020-11-26 | 2130 | 4 | TRUE |
17091 | 17091 | Fresno | Fresno | 19 | 2020-11-26 | 42322 | 477 | TRUE |
17092 | 17092 | Glenn | Glenn | 21 | 2020-11-26 | 884 | 8 | TRUE |
17093 | 17093 | Humboldt | Humboldt | 23 | 2020-11-26 | 819 | 9 | |
17094 | 17094 | Imperial | Imperial | 25 | 2020-11-26 | 15725 | 356 | TRUE |
17095 | 17095 | Inyo | Inyo | 27 | 2020-11-26 | 290 | 16 | TRUE |
17096 | 17096 | Kern | Kern | 29 | 2020-11-26 | 40337 | 448 | |
17097 | 17097 | Kings | Kings | 31 | 2020-11-26 | 10440 | 87 | TRUE |
17098 | 17098 | Lake | Lake | 33 | 2020-11-26 | 886 | 19 | TRUE |
17099 | 17099 | Lassen | Lassen | 35 | 2020-11-26 | 1773 | 3 | TRUE |
17100 | 17100 | Long Beach | Los Angeles | 37 | 2020-11-26 | 15522 | 274 | TRUE |
17101 | 17101 | Los Angeles | Los Angeles | 37 | 2020-11-26 | 364261 | 7174 | |
17102 | 17102 | Pasadena | Los Angeles | 37 | 2020-11-26 | 3492 | 132 | TRUE |
17103 | 17103 | Madera | Madera | 39 | 2020-11-26 | 6047 | 85 | TRUE |
17104 | 17104 | Marin | Marin | 41 | 2020-11-26 | 7628 | 129 | TRUE |
17105 | 17105 | Mariposa | Mariposa | 43 | 2020-11-26 | 126 | 2 | |
17106 | 17106 | Mendocino | Mendocino | 45 | 2020-11-26 | 1485 | 22 | TRUE |
17107 | 17107 | Merced | Merced | 47 | 2020-11-26 | 11537 | 179 | TRUE |
17108 | 17108 | Modoc | Modoc | 49 | 2020-11-26 | 125 | 0 | |
17109 | 17109 | Mono | Mono | 51 | 2020-11-26 | 527 | 3 | |
17110 | 17110 | Monterey | Monterey | 53 | 2020-11-26 | 14369 | 116 | TRUE |
17111 | 17111 | Napa | Napa | 55 | 2020-11-26 | 2931 | 16 | TRUE |
17112 | 17112 | Nevada | Nevada | 57 | 2020-11-26 | 1183 | 9 | TRUE |
17113 | 17113 | Orange | Orange | 59 | 2020-11-26 | 73152 | 1559 | TRUE |
17114 | 17114 | Placer | Placer | 61 | 2020-11-26 | 6224 | 68 | TRUE |
17115 | 17115 | Plumas | Plumas | 63 | 2020-11-26 | 205 | 0 | TRUE |
17116 | 17116 | Riverside | Riverside | 65 | 2020-11-26 | 81943 | 1434 | TRUE |
17117 | 17117 | Sacramento | Sacramento | 67 | 2020-11-26 | 35739 | 566 | TRUE |
17118 | 17118 | San Benito | San Benito | 69 | 2020-11-26 | 1813 | 16 | |
17119 | 17119 | San Bernardino | San Bernardino | 71 | 2020-11-26 | 88453 | 1428 | TRUE |
17120 | 17120 | San Diego | San Diego | 73 | 2020-11-26 | 75305 | 988 | TRUE |
17121 | 17121 | San Francisco | San Francisco | 75 | 2020-11-26 | 15001 | 160 | |
17122 | 17122 | San Joaquin | San Joaquin | 77 | 2020-11-26 | 25675 | 502 | TRUE |
17123 | 17123 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-26 | 5956 | 35 | TRUE |
17124 | 17124 | San Mateo | San Mateo | 81 | 2020-11-26 | 13707 | 170 | TRUE |
17125 | 17125 | Santa Barbara | Santa Barbara | 83 | 2020-11-26 | 11205 | 135 | TRUE |
17126 | 17126 | Santa Clara | Santa Clara | 85 | 2020-11-26 | 34912 | 425 | |
17127 | 17127 | Santa Cruz | Santa Cruz | 87 | 2020-11-26 | 4198 | 28 | TRUE |
17128 | 17128 | Shasta | Shasta | 89 | 2020-11-26 | 4601 | 47 | TRUE |
17129 | 17129 | Sierra | Sierra | 91 | 2020-11-26 | 19 | 0 | TRUE |
17130 | 17130 | Siskiyou | Siskiyou | 93 | 2020-11-26 | 624 | 2 | TRUE |
17131 | 17131 | Solano | Solano | 95 | 2020-11-26 | 10036 | 81 | TRUE |
17132 | 17132 | Sonoma | Sonoma | 97 | 2020-11-26 | 11846 | 157 | TRUE |
17133 | 17133 | Stanislaus | Stanislaus | 99 | 2020-11-26 | 21145 | 422 | TRUE |
17134 | 17134 | Sutter | Sutter | 101 | 2020-11-26 | 3144 | 15 | TRUE |
17135 | 17135 | Tehama | Tehama | 103 | 2020-11-26 | 1589 | 25 | |
17136 | 17136 | Trinity | Trinity | 105 | 2020-11-26 | 139 | 0 | TRUE |
17137 | 17137 | Tulare | Tulare | 107 | 2020-11-26 | 20550 | 308 | TRUE |
17138 | 17138 | Tuolumne | Tuolumne | 109 | 2020-11-26 | 908 | 8 | TRUE |
17139 | 17139 | Ventura | Ventura | 111 | 2020-11-26 | 18394 | 175 | TRUE |
17140 | 17140 | Yolo | Yolo | 113 | 2020-11-26 | 4561 | 74 | |
17141 | 17141 | Yuba | Yuba | 115 | 2020-11-26 | 1981 | 10 | TRUE |
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 );