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-09-03 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 |
---|---|---|---|---|---|---|---|---|
22205 | 22205 | Alameda | Alameda | 1 | 2020-09-03 | 18300 | 386 | |
22206 | 22206 | Berkeley | Alameda | 1 | 2020-09-03 | 570 | 10 | |
22207 | 22207 | Alpine | Alpine | 3 | 2020-09-03 | 2 | 0 | TRUE |
22208 | 22208 | Amador | Amador | 5 | 2020-09-03 | 237 | 15 | |
22209 | 22209 | Butte | Butte | 7 | 2020-09-03 | 2274 | 23 | |
22210 | 22210 | Calaveras | Calaveras | 9 | 2020-09-03 | 257 | 2 | TRUE |
22211 | 22211 | Colusa | Colusa | 11 | 2020-09-03 | 467 | 6 | |
22212 | 22212 | Contra Costa | Contra Costa | 13 | 2020-09-03 | 14212 | 183 | |
22213 | 22213 | Del Norte | Del Norte | 15 | 2020-09-03 | 124 | 1 | |
22214 | 22214 | El Dorado | El Dorado | 17 | 2020-09-03 | 988 | 2 | |
22215 | 22215 | Fresno | Fresno | 19 | 2020-09-03 | 28291 | 290 | |
22216 | 22216 | Glenn | Glenn | 21 | 2020-09-03 | 470 | 3 | |
22217 | 22217 | Humboldt | Humboldt | 23 | 2020-09-03 | 403 | 4 | |
22218 | 22218 | Imperial | Imperial | 25 | 2020-09-03 | 10773 | 296 | |
22219 | 22219 | Inyo | Inyo | 27 | 2020-09-03 | 182 | 13 | |
22220 | 22220 | Kern | Kern | 29 | 2020-09-03 | 29763 | 294 | |
22221 | 22221 | Kings | Kings | 31 | 2020-09-03 | 6422 | 76 | |
22222 | 22222 | Lake | Lake | 33 | 2020-09-03 | 350 | 5 | |
22223 | 22223 | Lassen | Lassen | 35 | 2020-09-03 | 715 | 0 | |
22224 | 22224 | Long Beach | Los Angeles | 37 | 2020-09-03 | 10815 | 223 | |
22225 | 22225 | Los Angeles | Los Angeles | 37 | 2020-09-03 | 231869 | 5594 | |
22226 | 22226 | Pasadena | Los Angeles | 37 | 2020-09-03 | 2411 | 117 | |
22227 | 22227 | Madera | Madera | 39 | 2020-09-03 | 3889 | 57 | |
22228 | 22228 | Marin | Marin | 41 | 2020-09-03 | 6285 | 96 | |
22229 | 22229 | Mariposa | Mariposa | 43 | 2020-09-03 | 74 | 2 | |
22230 | 22230 | Mendocino | Mendocino | 45 | 2020-09-03 | 724 | 17 | |
22231 | 22231 | Merced | Merced | 47 | 2020-09-03 | 8202 | 120 | |
22232 | 22232 | Modoc | Modoc | 49 | 2020-09-03 | 16 | 0 | |
22233 | 22233 | Mono | Mono | 51 | 2020-09-03 | 162 | 2 | |
22234 | 22234 | Monterey | Monterey | 53 | 2020-09-03 | 8244 | 58 | |
22235 | 22235 | Napa | Napa | 55 | 2020-09-03 | 1456 | 12 | |
22236 | 22236 | Nevada | Nevada | 57 | 2020-09-03 | 450 | 5 | |
22237 | 22237 | Orange | Orange | 59 | 2020-09-03 | 48945 | 1018 | |
22238 | 22238 | Placer | Placer | 61 | 2020-09-03 | 3083 | 34 | |
22239 | 22239 | Plumas | Plumas | 63 | 2020-09-03 | 45 | 0 | |
22240 | 22240 | Riverside | Riverside | 65 | 2020-09-03 | 53703 | 1053 | |
22241 | 22241 | Sacramento | Sacramento | 67 | 2020-09-03 | 18607 | 317 | |
22242 | 22242 | San Benito | San Benito | 69 | 2020-09-03 | 1146 | 8 | |
22243 | 22243 | San Bernardino | San Bernardino | 71 | 2020-09-03 | 48615 | 1007 | |
22244 | 22244 | San Diego | San Diego | 73 | 2020-09-03 | 39446 | 700 | |
22245 | 22245 | San Francisco | San Francisco | 75 | 2020-09-03 | 9696 | 84 | |
22246 | 22246 | San Joaquin | San Joaquin | 77 | 2020-09-03 | 18000 | 361 | |
22247 | 22247 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-03 | 3047 | 20 | |
22248 | 22248 | San Mateo | San Mateo | 81 | 2020-09-03 | 8390 | 132 | |
22249 | 22249 | Santa Barbara | Santa Barbara | 83 | 2020-09-03 | 8300 | 97 | |
22250 | 22250 | Santa Clara | Santa Clara | 85 | 2020-09-03 | 18658 | 260 | |
22251 | 22251 | Santa Cruz | Santa Cruz | 87 | 2020-09-03 | 1896 | 7 | |
22252 | 22252 | Shasta | Shasta | 89 | 2020-09-03 | 578 | 12 | |
22253 | 22253 | Sierra | Sierra | 91 | 2020-09-03 | 6 | 0 | |
22254 | 22254 | Siskiyou | Siskiyou | 93 | 2020-09-03 | 143 | 0 | |
22255 | 22255 | Solano | Solano | 95 | 2020-09-03 | 5631 | 47 | |
22256 | 22256 | Sonoma | Sonoma | 97 | 2020-09-03 | 6142 | 93 | |
22257 | 22257 | Stanislaus | Stanislaus | 99 | 2020-09-03 | 15021 | 273 | |
22258 | 22258 | Sutter | Sutter | 101 | 2020-09-03 | 1461 | 10 | |
22259 | 22259 | Tehama | Tehama | 103 | 2020-09-03 | 430 | 1 | |
22260 | 22260 | Trinity | Trinity | 105 | 2020-09-03 | 13 | 0 | |
22261 | 22261 | Tulare | Tulare | 107 | 2020-09-03 | 14552 | 243 | |
22262 | 22262 | Tuolumne | Tuolumne | 109 | 2020-09-03 | 187 | 2 | |
22263 | 22263 | Ventura | Ventura | 111 | 2020-09-03 | 10890 | 116 | |
22264 | 22264 | Yolo | Yolo | 113 | 2020-09-03 | 2478 | 53 | |
22265 | 22265 | Yuba | Yuba | 115 | 2020-09-03 | 975 | 6 |
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 );