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-04-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|
8053 | 8053 | Alameda | Alameda | 1 | 2021-04-23 | 82909 | 1217 | |
8054 | 8054 | Berkeley | Alameda | 1 | 2021-04-23 | 3547 | 46 | TRUE |
8055 | 8055 | Alpine | Alpine | 3 | 2021-04-23 | 88 | 0 | TRUE |
8056 | 8056 | Amador | Amador | 5 | 2021-04-23 | 3602 | 47 | |
8057 | 8057 | Butte | Butte | 7 | 2021-04-23 | 11672 | 181 | |
8058 | 8058 | Calaveras | Calaveras | 9 | 2021-04-23 | 2070 | 52 | |
8059 | 8059 | Colusa | Colusa | 11 | 2021-04-23 | 2210 | 16 | |
8060 | 8060 | Contra Costa | Contra Costa | 13 | 2021-04-23 | 67435 | 771 | |
8061 | 8061 | Del Norte | Del Norte | 15 | 2021-04-23 | 1293 | 7 | |
8062 | 8062 | El Dorado | El Dorado | 17 | 2021-04-23 | 9845 | 109 | |
8063 | 8063 | Fresno | Fresno | 19 | 2021-04-23 | 100450 | 1657 | |
8064 | 8064 | Glenn | Glenn | 21 | 2021-04-23 | 2302 | 25 | TRUE |
8065 | 8065 | Humboldt | Humboldt | 23 | 2021-04-23 | 3717 | 38 | |
8066 | 8066 | Imperial | Imperial | 25 | 2021-04-23 | 27725 | 718 | |
8067 | 8067 | Inyo | Inyo | 27 | 2021-04-23 | 1420 | 38 | |
8068 | 8068 | Kern | Kern | 29 | 2021-04-23 | 108195 | 1345 | |
8069 | 8069 | Kings | Kings | 31 | 2021-04-23 | 22821 | 246 | |
8070 | 8070 | Lake | Lake | 33 | 2021-04-23 | 3406 | 43 | |
8071 | 8071 | Lassen | Lassen | 35 | 2021-04-23 | 5685 | 24 | TRUE |
8072 | 8072 | Long Beach | Los Angeles | 37 | 2021-04-23 | 52777 | 928 | |
8073 | 8073 | Los Angeles | Los Angeles | 37 | 2021-04-23 | 1166833 | 22491 | |
8074 | 8074 | Pasadena | Los Angeles | 37 | 2021-04-23 | 11205 | 340 | |
8075 | 8075 | Madera | Madera | 39 | 2021-04-23 | 16228 | 240 | |
8076 | 8076 | Marin | Marin | 41 | 2021-04-23 | 13894 | 208 | |
8077 | 8077 | Mariposa | Mariposa | 43 | 2021-04-23 | 431 | 7 | |
8078 | 8078 | Mendocino | Mendocino | 45 | 2021-04-23 | 4001 | 47 | |
8079 | 8079 | Merced | Merced | 47 | 2021-04-23 | 31400 | 454 | |
8080 | 8080 | Modoc | Modoc | 49 | 2021-04-23 | 492 | 4 | TRUE |
8081 | 8081 | Mono | Mono | 51 | 2021-04-23 | 1276 | 4 | |
8082 | 8082 | Monterey | Monterey | 53 | 2021-04-23 | 43366 | 380 | |
8083 | 8083 | Napa | Napa | 55 | 2021-04-23 | 9747 | 75 | |
8084 | 8084 | Nevada | Nevada | 57 | 2021-04-23 | 4512 | 75 | |
8085 | 8085 | Orange | Orange | 59 | 2021-04-23 | 253340 | 4918 | |
8086 | 8086 | Placer | Placer | 61 | 2021-04-23 | 22028 | 284 | |
8087 | 8087 | Plumas | Plumas | 63 | 2021-04-23 | 697 | 6 | TRUE |
8088 | 8088 | Riverside | Riverside | 65 | 2021-04-23 | 297881 | 4559 | |
8089 | 8089 | Sacramento | Sacramento | 67 | 2021-04-23 | 102071 | 1654 | |
8090 | 8090 | San Benito | San Benito | 69 | 2021-04-23 | 5994 | 63 | |
8091 | 8091 | San Bernardino | San Bernardino | 71 | 2021-04-23 | 295390 | 4785 | |
8092 | 8092 | San Diego | San Diego | 73 | 2021-04-23 | 275251 | 3684 | |
8093 | 8093 | San Francisco | San Francisco | 75 | 2021-04-23 | 35893 | 531 | |
8094 | 8094 | San Joaquin | San Joaquin | 77 | 2021-04-23 | 71972 | 1340 | |
8095 | 8095 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-23 | 21071 | 260 | |
8096 | 8096 | San Mateo | San Mateo | 81 | 2021-04-23 | 41292 | 564 | |
8097 | 8097 | Santa Barbara | Santa Barbara | 83 | 2021-04-23 | 34017 | 448 | |
8098 | 8098 | Santa Clara | Santa Clara | 85 | 2021-04-23 | 116698 | 1674 | |
8099 | 8099 | Santa Cruz | Santa Cruz | 87 | 2021-04-23 | 15831 | 204 | |
8100 | 8100 | Shasta | Shasta | 89 | 2021-04-23 | 11801 | 220 | |
8101 | 8101 | Sierra | Sierra | 91 | 2021-04-23 | 110 | 0 | TRUE |
8102 | 8102 | Siskiyou | Siskiyou | 93 | 2021-04-23 | 1987 | 21 | |
8103 | 8103 | Solano | Solano | 95 | 2021-04-23 | 32126 | 212 | |
8104 | 8104 | Sonoma | Sonoma | 97 | 2021-04-23 | 29747 | 312 | TRUE |
8105 | 8105 | Stanislaus | Stanislaus | 99 | 2021-04-23 | 54247 | 1036 | |
8106 | 8106 | Sutter | Sutter | 101 | 2021-04-23 | 9326 | 104 | |
8107 | 8107 | Tehama | Tehama | 103 | 2021-04-23 | 5468 | 57 | |
8108 | 8108 | Trinity | Trinity | 105 | 2021-04-23 | 398 | 5 | TRUE |
8109 | 8109 | Tulare | Tulare | 107 | 2021-04-23 | 49471 | 832 | |
8110 | 8110 | Tuolumne | Tuolumne | 109 | 2021-04-23 | 4093 | 64 | |
8111 | 8111 | Ventura | Ventura | 111 | 2021-04-23 | 80430 | 1006 | |
8112 | 8112 | Yolo | Yolo | 113 | 2021-04-23 | 13573 | 205 | |
8113 | 8113 | Yuba | Yuba | 115 | 2021-04-23 | 6142 | 40 |
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 );