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-01 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 |
---|---|---|---|---|---|---|---|---|
12994 | 12994 | Alameda | Alameda | 1 | 2021-02-01 | 71761 | 1119 | |
12995 | 12995 | Berkeley | Alameda | 1 | 2021-02-01 | 2709 | 43 | |
12996 | 12996 | Alpine | Alpine | 3 | 2021-02-01 | 74 | 0 | |
12997 | 12997 | Amador | Amador | 5 | 2021-02-01 | 3227 | 34 | |
12998 | 12998 | Butte | Butte | 7 | 2021-02-01 | 10263 | 142 | |
12999 | 12999 | Calaveras | Calaveras | 9 | 2021-02-01 | 1739 | 23 | |
13000 | 13000 | Colusa | Colusa | 11 | 2021-02-01 | 1952 | 10 | |
13001 | 13001 | Contra Costa | Contra Costa | 13 | 2021-02-01 | 57580 | 529 | |
13002 | 13002 | Del Norte | Del Norte | 15 | 2021-02-01 | 884 | 3 | |
13003 | 13003 | El Dorado | El Dorado | 17 | 2021-02-01 | 8443 | 81 | |
13004 | 13004 | Fresno | Fresno | 19 | 2021-02-01 | 91202 | 1173 | |
13005 | 13005 | Glenn | Glenn | 21 | 2021-02-01 | 2016 | 23 | |
13006 | 13006 | Humboldt | Humboldt | 23 | 2021-02-01 | 2815 | 30 | |
13007 | 13007 | Imperial | Imperial | 25 | 2021-02-01 | 26157 | 549 | |
13008 | 13008 | Inyo | Inyo | 27 | 2021-02-01 | 1087 | 29 | |
13009 | 13009 | Kern | Kern | 29 | 2021-02-01 | 94467 | 624 | |
13010 | 13010 | Kings | Kings | 31 | 2021-02-01 | 20812 | 177 | |
13011 | 13011 | Lake | Lake | 33 | 2021-02-01 | 2781 | 33 | |
13012 | 13012 | Lassen | Lassen | 35 | 2021-02-01 | 5413 | 17 | |
13013 | 13013 | Long Beach | Los Angeles | 37 | 2021-02-01 | 48259 | 666 | |
13014 | 13014 | Los Angeles | Los Angeles | 37 | 2021-02-01 | 1062587 | 15935 | |
13015 | 13015 | Pasadena | Los Angeles | 37 | 2021-02-01 | 10261 | 256 | |
13016 | 13016 | Madera | Madera | 39 | 2021-02-01 | 14452 | 175 | |
13017 | 13017 | Marin | Marin | 41 | 2021-02-01 | 12372 | 173 | |
13018 | 13018 | Mariposa | Mariposa | 43 | 2021-02-01 | 368 | 5 | |
13019 | 13019 | Mendocino | Mendocino | 45 | 2021-02-01 | 3453 | 38 | |
13020 | 13020 | Merced | Merced | 47 | 2021-02-01 | 26674 | 354 | |
13021 | 13021 | Modoc | Modoc | 49 | 2021-02-01 | 411 | 4 | |
13022 | 13022 | Mono | Mono | 51 | 2021-02-01 | 1166 | 4 | |
13023 | 13023 | Monterey | Monterey | 53 | 2021-02-01 | 39425 | 285 | |
13024 | 13024 | Napa | Napa | 55 | 2021-02-01 | 8373 | 53 | |
13025 | 13025 | Nevada | Nevada | 57 | 2021-02-01 | 3528 | 74 | |
13026 | 13026 | Orange | Orange | 59 | 2021-02-01 | 233394 | 3109 | |
13027 | 13027 | Placer | Placer | 61 | 2021-02-01 | 18608 | 201 | |
13028 | 13028 | Plumas | Plumas | 63 | 2021-02-01 | 626 | 6 | TRUE |
13029 | 13029 | Riverside | Riverside | 65 | 2021-02-01 | 275872 | 3171 | |
13030 | 13030 | Sacramento | Sacramento | 67 | 2021-02-01 | 86471 | 1262 | |
13031 | 13031 | San Benito | San Benito | 69 | 2021-02-01 | 5351 | 54 | |
13032 | 13032 | San Bernardino | San Bernardino | 71 | 2021-02-01 | 275076 | 4198 | |
13033 | 13033 | San Diego | San Diego | 73 | 2021-02-01 | 239124 | 2619 | |
13034 | 13034 | San Francisco | San Francisco | 75 | 2021-02-01 | 31259 | 324 | |
13035 | 13035 | San Joaquin | San Joaquin | 77 | 2021-02-01 | 62146 | 870 | |
13036 | 13036 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-01 | 17887 | 177 | |
13037 | 13037 | San Mateo | San Mateo | 81 | 2021-02-01 | 35882 | 382 | |
13038 | 13038 | Santa Barbara | Santa Barbara | 83 | 2021-02-01 | 28830 | 298 | |
13039 | 13039 | Santa Clara | Santa Clara | 85 | 2021-02-01 | 103112 | 1400 | |
13040 | 13040 | Santa Cruz | Santa Cruz | 87 | 2021-02-01 | 13606 | 148 | |
13041 | 13041 | Shasta | Shasta | 89 | 2021-02-01 | 10438 | 145 | |
13042 | 13042 | Sierra | Sierra | 91 | 2021-02-01 | 95 | 0 | |
13043 | 13043 | Siskiyou | Siskiyou | 93 | 2021-02-01 | 1558 | 13 | |
13044 | 13044 | Solano | Solano | 95 | 2021-02-01 | 28191 | 122 | |
13045 | 13045 | Sonoma | Sonoma | 97 | 2021-02-01 | 26189 | 265 | |
13046 | 13046 | Stanislaus | Stanislaus | 99 | 2021-02-01 | 46268 | 834 | |
13047 | 13047 | Sutter | Sutter | 101 | 2021-02-01 | 8355 | 89 | |
13048 | 13048 | Tehama | Tehama | 103 | 2021-02-01 | 4660 | 47 | TRUE |
13049 | 13049 | Trinity | Trinity | 105 | 2021-02-01 | 308 | 5 | |
13050 | 13050 | Tulare | Tulare | 107 | 2021-02-01 | 45243 | 598 | |
13051 | 13051 | Tuolumne | Tuolumne | 109 | 2021-02-01 | 3594 | 49 | |
13052 | 13052 | Ventura | Ventura | 111 | 2021-02-01 | 70799 | 618 | |
13053 | 13053 | Yolo | Yolo | 113 | 2021-02-01 | 11666 | 149 | |
13054 | 13054 | Yuba | Yuba | 115 | 2021-02-01 | 5389 | 32 |
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 );