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-23 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 |
---|---|---|---|---|---|---|---|---|
19155 | 19155 | Alameda | Alameda | 1 | 2020-10-23 | 22386 | 442 | |
19156 | 19156 | Berkeley | Alameda | 1 | 2020-10-23 | 753 | 10 | |
19157 | 19157 | Alpine | Alpine | 3 | 2020-10-23 | 3 | 0 | TRUE |
19158 | 19158 | Amador | Amador | 5 | 2020-10-23 | 291 | 15 | |
19159 | 19159 | Butte | Butte | 7 | 2020-10-23 | 3059 | 52 | |
19160 | 19160 | Calaveras | Calaveras | 9 | 2020-10-23 | 342 | 18 | |
19161 | 19161 | Colusa | Colusa | 11 | 2020-10-23 | 550 | 6 | |
19162 | 19162 | Contra Costa | Contra Costa | 13 | 2020-10-23 | 18523 | 241 | |
19163 | 19163 | Del Norte | Del Norte | 15 | 2020-10-23 | 178 | 1 | |
19164 | 19164 | El Dorado | El Dorado | 17 | 2020-10-23 | 1315 | 4 | |
19165 | 19165 | Fresno | Fresno | 19 | 2020-10-23 | 33097 | 436 | |
19166 | 19166 | Glenn | Glenn | 21 | 2020-10-23 | 657 | 3 | |
19167 | 19167 | Humboldt | Humboldt | 23 | 2020-10-23 | 562 | 9 | |
19168 | 19168 | Imperial | Imperial | 25 | 2020-10-23 | 12700 | 336 | |
19169 | 19169 | Inyo | Inyo | 27 | 2020-10-23 | 227 | 15 | TRUE |
19170 | 19170 | Kern | Kern | 29 | 2020-10-23 | 33775 | 416 | |
19171 | 19171 | Kings | Kings | 31 | 2020-10-23 | 8196 | 83 | |
19172 | 19172 | Lake | Lake | 33 | 2020-10-23 | 689 | 15 | |
19173 | 19173 | Lassen | Lassen | 35 | 2020-10-23 | 766 | 1 | |
19174 | 19174 | Long Beach | Los Angeles | 37 | 2020-10-23 | 12954 | 255 | |
19175 | 19175 | Los Angeles | Los Angeles | 37 | 2020-10-23 | 281230 | 6590 | |
19176 | 19176 | Pasadena | Los Angeles | 37 | 2020-10-23 | 2746 | 129 | |
19177 | 19177 | Madera | Madera | 39 | 2020-10-23 | 4981 | 74 | |
19178 | 19178 | Marin | Marin | 41 | 2020-10-23 | 7057 | 128 | |
19179 | 19179 | Mariposa | Mariposa | 43 | 2020-10-23 | 78 | 2 | |
19180 | 19180 | Mendocino | Mendocino | 45 | 2020-10-23 | 1124 | 21 | |
19181 | 19181 | Merced | Merced | 47 | 2020-10-23 | 9465 | 155 | |
19182 | 19182 | Modoc | Modoc | 49 | 2020-10-23 | 29 | 0 | TRUE |
19183 | 19183 | Mono | Mono | 51 | 2020-10-23 | 187 | 2 | |
19184 | 19184 | Monterey | Monterey | 53 | 2020-10-23 | 11321 | 89 | |
19185 | 19185 | Napa | Napa | 55 | 2020-10-23 | 1937 | 14 | |
19186 | 19186 | Nevada | Nevada | 57 | 2020-10-23 | 608 | 8 | |
19187 | 19187 | Orange | Orange | 59 | 2020-10-23 | 58010 | 1440 | |
19188 | 19188 | Placer | Placer | 61 | 2020-10-23 | 4088 | 57 | |
19189 | 19189 | Plumas | Plumas | 63 | 2020-10-23 | 68 | 0 | |
19190 | 19190 | Riverside | Riverside | 65 | 2020-10-23 | 65757 | 1279 | |
19191 | 19191 | Sacramento | Sacramento | 67 | 2020-10-23 | 25264 | 484 | |
19192 | 19192 | San Benito | San Benito | 69 | 2020-10-23 | 1432 | 15 | |
19193 | 19193 | San Bernardino | San Bernardino | 71 | 2020-10-23 | 61726 | 1198 | |
19194 | 19194 | San Diego | San Diego | 73 | 2020-10-23 | 53928 | 867 | |
19195 | 19195 | San Francisco | San Francisco | 75 | 2020-10-23 | 12032 | 140 | |
19196 | 19196 | San Joaquin | San Joaquin | 77 | 2020-10-23 | 21630 | 489 | |
19197 | 19197 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-23 | 4141 | 32 | |
19198 | 19198 | San Mateo | San Mateo | 81 | 2020-10-23 | 11002 | 159 | |
19199 | 19199 | Santa Barbara | Santa Barbara | 83 | 2020-10-23 | 9760 | 120 | |
19200 | 19200 | Santa Clara | Santa Clara | 85 | 2020-10-23 | 24462 | 353 | |
19201 | 19201 | Santa Cruz | Santa Cruz | 87 | 2020-10-23 | 2771 | 25 | |
19202 | 19202 | Shasta | Shasta | 89 | 2020-10-23 | 1834 | 30 | |
19203 | 19203 | Sierra | Sierra | 91 | 2020-10-23 | 6 | 0 | TRUE |
19204 | 19204 | Siskiyou | Siskiyou | 93 | 2020-10-23 | 193 | 0 | |
19205 | 19205 | Solano | Solano | 95 | 2020-10-23 | 7286 | 74 | |
19206 | 19206 | Sonoma | Sonoma | 97 | 2020-10-23 | 9163 | 134 | |
19207 | 19207 | Stanislaus | Stanislaus | 99 | 2020-10-23 | 17509 | 396 | |
19208 | 19208 | Sutter | Sutter | 101 | 2020-10-23 | 1837 | 12 | |
19209 | 19209 | Tehama | Tehama | 103 | 2020-10-23 | 848 | 8 | |
19210 | 19210 | Trinity | Trinity | 105 | 2020-10-23 | 25 | 0 | |
19211 | 19211 | Tulare | Tulare | 107 | 2020-10-23 | 17495 | 286 | |
19212 | 19212 | Tuolumne | Tuolumne | 109 | 2020-10-23 | 268 | 4 | |
19213 | 19213 | Ventura | Ventura | 111 | 2020-10-23 | 14020 | 164 | |
19214 | 19214 | Yolo | Yolo | 113 | 2020-10-23 | 3144 | 58 | |
19215 | 19215 | Yuba | Yuba | 115 | 2020-10-23 | 1293 | 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 );