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-01-31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update
agency 61
- Alameda 1
- Alpine 1
- Amador 1
- Berkeley 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Long Beach 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Pasadena 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
fips 58
county 58
- Los Angeles 3
- Alameda 2
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
13055 | 13055 | Alameda | Alameda | 1 | 2021-01-31 | 71397 | 1117 | |
13056 | 13056 | Berkeley | Alameda | 1 | 2021-01-31 | 2688 | 43 | |
13057 | 13057 | Alpine | Alpine | 3 | 2021-01-31 | 74 | 0 | TRUE |
13058 | 13058 | Amador | Amador | 5 | 2021-01-31 | 3199 | 33 | |
13059 | 13059 | Butte | Butte | 7 | 2021-01-31 | 10215 | 138 | TRUE |
13060 | 13060 | Calaveras | Calaveras | 9 | 2021-01-31 | 1637 | 23 | TRUE |
13061 | 13061 | Colusa | Colusa | 11 | 2021-01-31 | 1935 | 10 | TRUE |
13062 | 13062 | Contra Costa | Contra Costa | 13 | 2021-01-31 | 57337 | 529 | |
13063 | 13063 | Del Norte | Del Norte | 15 | 2021-01-31 | 883 | 3 | TRUE |
13064 | 13064 | El Dorado | El Dorado | 17 | 2021-01-31 | 8359 | 79 | TRUE |
13065 | 13065 | Fresno | Fresno | 19 | 2021-01-31 | 90888 | 1137 | TRUE |
13066 | 13066 | Glenn | Glenn | 21 | 2021-01-31 | 1998 | 23 | TRUE |
13067 | 13067 | Humboldt | Humboldt | 23 | 2021-01-31 | 2754 | 30 | TRUE |
13068 | 13068 | Imperial | Imperial | 25 | 2021-01-31 | 25948 | 532 | TRUE |
13069 | 13069 | Inyo | Inyo | 27 | 2021-01-31 | 1083 | 29 | TRUE |
13070 | 13070 | Kern | Kern | 29 | 2021-01-31 | 94113 | 624 | |
13071 | 13071 | Kings | Kings | 31 | 2021-01-31 | 20773 | 174 | |
13072 | 13072 | Lake | Lake | 33 | 2021-01-31 | 2748 | 32 | TRUE |
13073 | 13073 | Lassen | Lassen | 35 | 2021-01-31 | 5393 | 16 | TRUE |
13074 | 13074 | Long Beach | Los Angeles | 37 | 2021-01-31 | 48096 | 666 | TRUE |
13075 | 13075 | Los Angeles | Los Angeles | 37 | 2021-01-31 | 1058640 | 15851 | |
13076 | 13076 | Pasadena | Los Angeles | 37 | 2021-01-31 | 10212 | 253 | |
13077 | 13077 | Madera | Madera | 39 | 2021-01-31 | 14250 | 175 | TRUE |
13078 | 13078 | Marin | Marin | 41 | 2021-01-31 | 12346 | 172 | |
13079 | 13079 | Mariposa | Mariposa | 43 | 2021-01-31 | 367 | 5 | |
13080 | 13080 | Mendocino | Mendocino | 45 | 2021-01-31 | 3434 | 38 | |
13081 | 13081 | Merced | Merced | 47 | 2021-01-31 | 26230 | 350 | TRUE |
13082 | 13082 | Modoc | Modoc | 49 | 2021-01-31 | 407 | 4 | |
13083 | 13083 | Mono | Mono | 51 | 2021-01-31 | 1165 | 4 | |
13084 | 13084 | Monterey | Monterey | 53 | 2021-01-31 | 39425 | 285 | TRUE |
13085 | 13085 | Napa | Napa | 55 | 2021-01-31 | 8198 | 52 | TRUE |
13086 | 13086 | Nevada | Nevada | 57 | 2021-01-31 | 3454 | 74 | TRUE |
13087 | 13087 | Orange | Orange | 59 | 2021-01-31 | 232391 | 3062 | |
13088 | 13088 | Placer | Placer | 61 | 2021-01-31 | 18399 | 199 | TRUE |
13089 | 13089 | Plumas | Plumas | 63 | 2021-01-31 | 626 | 6 | TRUE |
13090 | 13090 | Riverside | Riverside | 65 | 2021-01-31 | 271910 | 3091 | TRUE |
13091 | 13091 | Sacramento | Sacramento | 67 | 2021-01-31 | 85392 | 1239 | TRUE |
13092 | 13092 | San Benito | San Benito | 69 | 2021-01-31 | 5328 | 52 | |
13093 | 13093 | San Bernardino | San Bernardino | 71 | 2021-01-31 | 274429 | 4157 | |
13094 | 13094 | San Diego | San Diego | 73 | 2021-01-31 | 238042 | 2619 | |
13095 | 13095 | San Francisco | San Francisco | 75 | 2021-01-31 | 31111 | 324 | |
13096 | 13096 | San Joaquin | San Joaquin | 77 | 2021-01-31 | 61901 | 853 | TRUE |
13097 | 13097 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-31 | 17605 | 168 | TRUE |
13098 | 13098 | San Mateo | San Mateo | 81 | 2021-01-31 | 35466 | 382 | TRUE |
13099 | 13099 | Santa Barbara | Santa Barbara | 83 | 2021-01-31 | 28567 | 291 | |
13100 | 13100 | Santa Clara | Santa Clara | 85 | 2021-01-31 | 102566 | 1384 | |
13101 | 13101 | Santa Cruz | Santa Cruz | 87 | 2021-01-31 | 13321 | 148 | TRUE |
13102 | 13102 | Shasta | Shasta | 89 | 2021-01-31 | 10333 | 142 | TRUE |
13103 | 13103 | Sierra | Sierra | 91 | 2021-01-31 | 95 | 0 | TRUE |
13104 | 13104 | Siskiyou | Siskiyou | 93 | 2021-01-31 | 1532 | 13 | TRUE |
13105 | 13105 | Solano | Solano | 95 | 2021-01-31 | 27706 | 122 | TRUE |
13106 | 13106 | Sonoma | Sonoma | 97 | 2021-01-31 | 26108 | 260 | |
13107 | 13107 | Stanislaus | Stanislaus | 99 | 2021-01-31 | 46122 | 828 | |
13108 | 13108 | Sutter | Sutter | 101 | 2021-01-31 | 8264 | 86 | TRUE |
13109 | 13109 | Tehama | Tehama | 103 | 2021-01-31 | 4660 | 47 | TRUE |
13110 | 13110 | Trinity | Trinity | 105 | 2021-01-31 | 307 | 5 | TRUE |
13111 | 13111 | Tulare | Tulare | 107 | 2021-01-31 | 44518 | 588 | TRUE |
13112 | 13112 | Tuolumne | Tuolumne | 109 | 2021-01-31 | 3549 | 49 | TRUE |
13113 | 13113 | Ventura | Ventura | 111 | 2021-01-31 | 69050 | 598 | TRUE |
13114 | 13114 | Yolo | Yolo | 113 | 2021-01-31 | 11602 | 149 | |
13115 | 13115 | Yuba | Yuba | 115 | 2021-01-31 | 5324 | 31 | 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 );