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 2021-02-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
12201 | 12201 | Alameda | Alameda | 1 | 2021-02-14 | 75425 | 1160 | |
12202 | 12202 | Berkeley | Alameda | 1 | 2021-02-14 | 3140 | 45 | |
12203 | 12203 | Alpine | Alpine | 3 | 2021-02-14 | 79 | 0 | TRUE |
12204 | 12204 | Amador | Amador | 5 | 2021-02-14 | 3342 | 38 | |
12205 | 12205 | Butte | Butte | 7 | 2021-02-14 | 10717 | 149 | TRUE |
12206 | 12206 | Calaveras | Calaveras | 9 | 2021-02-14 | 1825 | 25 | TRUE |
12207 | 12207 | Colusa | Colusa | 11 | 2021-02-14 | 2069 | 11 | TRUE |
12208 | 12208 | Contra Costa | Contra Costa | 13 | 2021-02-14 | 60537 | 622 | |
12209 | 12209 | Del Norte | Del Norte | 15 | 2021-02-14 | 929 | 4 | TRUE |
12210 | 12210 | El Dorado | El Dorado | 17 | 2021-02-14 | 8855 | 90 | TRUE |
12211 | 12211 | Fresno | Fresno | 19 | 2021-02-14 | 93823 | 1291 | TRUE |
12212 | 12212 | Glenn | Glenn | 21 | 2021-02-14 | 2138 | 23 | TRUE |
12213 | 12213 | Humboldt | Humboldt | 23 | 2021-02-14 | 3009 | 32 | TRUE |
12214 | 12214 | Imperial | Imperial | 25 | 2021-02-14 | 26574 | 584 | TRUE |
12215 | 12215 | Inyo | Inyo | 27 | 2021-02-14 | 1193 | 34 | TRUE |
12216 | 12216 | Kern | Kern | 29 | 2021-02-14 | 100290 | 687 | |
12217 | 12217 | Kings | Kings | 31 | 2021-02-14 | 21610 | 208 | |
12218 | 12218 | Lake | Lake | 33 | 2021-02-14 | 2970 | 37 | TRUE |
12219 | 12219 | Lassen | Lassen | 35 | 2021-02-14 | 5498 | 19 | TRUE |
12220 | 12220 | Long Beach | Los Angeles | 37 | 2021-02-14 | 50284 | 776 | TRUE |
12221 | 12221 | Los Angeles | Los Angeles | 37 | 2021-02-14 | 1105615 | 17996 | |
12222 | 12222 | Pasadena | Los Angeles | 37 | 2021-02-14 | 10653 | 296 | |
12223 | 12223 | Madera | Madera | 39 | 2021-02-14 | 14966 | 189 | TRUE |
12224 | 12224 | Marin | Marin | 41 | 2021-02-14 | 12843 | 184 | |
12225 | 12225 | Mariposa | Mariposa | 43 | 2021-02-14 | 388 | 5 | |
12226 | 12226 | Mendocino | Mendocino | 45 | 2021-02-14 | 3723 | 40 | |
12227 | 12227 | Merced | Merced | 47 | 2021-02-14 | 27701 | 375 | TRUE |
12228 | 12228 | Modoc | Modoc | 49 | 2021-02-14 | 441 | 4 | TRUE |
12229 | 12229 | Mono | Mono | 51 | 2021-02-14 | 1198 | 4 | TRUE |
12230 | 12230 | Monterey | Monterey | 53 | 2021-02-14 | 41341 | 307 | TRUE |
12231 | 12231 | Napa | Napa | 55 | 2021-02-14 | 8726 | 59 | TRUE |
12232 | 12232 | Nevada | Nevada | 57 | 2021-02-14 | 3729 | 74 | TRUE |
12233 | 12233 | Orange | Orange | 59 | 2021-02-14 | 242505 | 3577 | |
12234 | 12234 | Placer | Placer | 61 | 2021-02-14 | 19175 | 222 | TRUE |
12235 | 12235 | Plumas | Plumas | 63 | 2021-02-14 | 641 | 6 | TRUE |
12236 | 12236 | Riverside | Riverside | 65 | 2021-02-14 | 285414 | 3524 | TRUE |
12237 | 12237 | Sacramento | Sacramento | 67 | 2021-02-14 | 89965 | 1372 | TRUE |
12238 | 12238 | San Benito | San Benito | 69 | 2021-02-14 | 5558 | 57 | |
12239 | 12239 | San Bernardino | San Bernardino | 71 | 2021-02-14 | 282169 | 4481 | |
12240 | 12240 | San Diego | San Diego | 73 | 2021-02-14 | 252250 | 3037 | |
12241 | 12241 | San Francisco | San Francisco | 75 | 2021-02-14 | 33030 | 366 | |
12242 | 12242 | San Joaquin | San Joaquin | 77 | 2021-02-14 | 64969 | 992 | TRUE |
12243 | 12243 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-14 | 18889 | 205 | TRUE |
12244 | 12244 | San Mateo | San Mateo | 81 | 2021-02-14 | 37621 | 474 | TRUE |
12245 | 12245 | Santa Barbara | Santa Barbara | 83 | 2021-02-14 | 30862 | 372 | |
12246 | 12246 | Santa Clara | Santa Clara | 85 | 2021-02-14 | 107320 | 1519 | |
12247 | 12247 | Santa Cruz | Santa Cruz | 87 | 2021-02-14 | 14232 | 168 | TRUE |
12248 | 12248 | Shasta | Shasta | 89 | 2021-02-14 | 10718 | 170 | TRUE |
12249 | 12249 | Sierra | Sierra | 91 | 2021-02-14 | 97 | 0 | TRUE |
12250 | 12250 | Siskiyou | Siskiyou | 93 | 2021-02-14 | 1664 | 13 | TRUE |
12251 | 12251 | Solano | Solano | 95 | 2021-02-14 | 29251 | 140 | TRUE |
12252 | 12252 | Sonoma | Sonoma | 97 | 2021-02-14 | 27249 | 287 | |
12253 | 12253 | Stanislaus | Stanislaus | 99 | 2021-02-14 | 48842 | 899 | |
12254 | 12254 | Sutter | Sutter | 101 | 2021-02-14 | 8656 | 93 | TRUE |
12255 | 12255 | Tehama | Tehama | 103 | 2021-02-14 | 4930 | 51 | TRUE |
12256 | 12256 | Trinity | Trinity | 105 | 2021-02-14 | 321 | 5 | TRUE |
12257 | 12257 | Tulare | Tulare | 107 | 2021-02-14 | 46714 | 691 | TRUE |
12258 | 12258 | Tuolumne | Tuolumne | 109 | 2021-02-14 | 3800 | 52 | TRUE |
12259 | 12259 | Ventura | Ventura | 111 | 2021-02-14 | 74671 | 732 | TRUE |
12260 | 12260 | Yolo | Yolo | 113 | 2021-02-14 | 12208 | 172 | TRUE |
12261 | 12261 | Yuba | Yuba | 115 | 2021-02-14 | 5583 | 36 | 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 );