latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 1,386
- Alameda 918
- Santa Clara 487
- Orange 486
- San Benito 481
- Humboldt 464
- Sacramento 464
- Solano 461
- San Mateo 460
- Santa Cruz 460
- Shasta 460
- Sonoma 460
- Stanislaus 460
- Ventura 460
- Yolo 460
- Calaveras 459
- Contra Costa 459
- Marin 459
- Placer 459
- Riverside 459
- San Diego 459
- San Francisco 459
- Fresno 455
- San Joaquin 451
- Madera 445
- Tulare 442
- Imperial 441
- Amador 439
- San Luis Obispo 439
- Santa Barbara 438
- …
agency >30
- Santa Clara 487
- Los Angeles 486
- Orange 486
- San Benito 481
- Humboldt 464
- Sacramento 464
- Solano 461
- San Mateo 460
- Santa Cruz 460
- Shasta 460
- Sonoma 460
- Stanislaus 460
- Ventura 460
- Yolo 460
- Alameda 459
- Berkeley 459
- Calaveras 459
- Contra Costa 459
- Long Beach 459
- Marin 459
- Placer 459
- Riverside 459
- San Diego 459
- San Francisco 459
- Fresno 455
- San Joaquin 451
- Madera 445
- Tulare 442
- Imperial 441
- Pasadena 441
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6082 | 6082 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-26 | 21291 | 261 | |
6083 | 6083 | San Mateo | San Mateo | 81 | 2021-05-26 | 42043 | 573 | |
6084 | 6084 | Santa Barbara | Santa Barbara | 83 | 2021-05-26 | 34470 | 450 | |
6085 | 6085 | Santa Clara | Santa Clara | 85 | 2021-05-26 | 118275 | 1690 | |
6086 | 6086 | Santa Cruz | Santa Cruz | 87 | 2021-05-26 | 16169 | 206 | TRUE |
6087 | 6087 | Shasta | Shasta | 89 | 2021-05-26 | 12382 | 229 | |
6088 | 6088 | Sierra | Sierra | 91 | 2021-05-26 | 112 | 0 | |
6089 | 6089 | Siskiyou | Siskiyou | 93 | 2021-05-26 | 2341 | 29 | |
6090 | 6090 | Solano | Solano | 95 | 2021-05-26 | 33218 | 234 | |
6091 | 6091 | Sonoma | Sonoma | 97 | 2021-05-26 | 30257 | 315 | |
6092 | 6092 | Stanislaus | Stanislaus | 99 | 2021-05-26 | 56070 | 1066 | |
6093 | 6093 | Sutter | Sutter | 101 | 2021-05-26 | 9513 | 106 | |
6094 | 6094 | Tehama | Tehama | 103 | 2021-05-26 | 5656 | 59 | |
6095 | 6095 | Trinity | Trinity | 105 | 2021-05-26 | 411 | 5 | |
6096 | 6096 | Tulare | Tulare | 107 | 2021-05-26 | 49758 | 843 | |
6097 | 6097 | Tuolumne | Tuolumne | 109 | 2021-05-26 | 4163 | 67 | |
6098 | 6098 | Ventura | Ventura | 111 | 2021-05-26 | 81295 | 1018 | |
6099 | 6099 | Yolo | Yolo | 113 | 2021-05-26 | 13957 | 208 | |
6100 | 6100 | Yuba | Yuba | 115 | 2021-05-26 | 6351 | 41 | |
6101 | 6101 | Alameda | Alameda | 1 | 2021-05-25 | 85047 | 1217 | |
6102 | 6102 | Berkeley | Alameda | 1 | 2021-05-25 | 3618 | 46 | |
6103 | 6103 | Alpine | Alpine | 3 | 2021-05-25 | 89 | 0 | TRUE |
6104 | 6104 | Amador | Amador | 5 | 2021-05-25 | 3643 | 47 | |
6105 | 6105 | Butte | Butte | 7 | 2021-05-25 | 12295 | 188 | |
6106 | 6106 | Calaveras | Calaveras | 9 | 2021-05-25 | 2161 | 56 | |
6107 | 6107 | Colusa | Colusa | 11 | 2021-05-25 | 2259 | 18 | |
6108 | 6108 | Contra Costa | Contra Costa | 13 | 2021-05-25 | 69454 | 796 | |
6109 | 6109 | Del Norte | Del Norte | 15 | 2021-05-25 | 1425 | 7 | |
6110 | 6110 | El Dorado | El Dorado | 17 | 2021-05-25 | 10278 | 113 | |
6111 | 6111 | Fresno | Fresno | 19 | 2021-05-25 | 101771 | 1698 | |
6112 | 6112 | Glenn | Glenn | 21 | 2021-05-25 | 2341 | 25 | TRUE |
6113 | 6113 | Humboldt | Humboldt | 23 | 2021-05-25 | 4253 | 43 | |
6114 | 6114 | Imperial | Imperial | 25 | 2021-05-25 | 28088 | 731 | |
6115 | 6115 | Inyo | Inyo | 27 | 2021-05-25 | 1429 | 38 | |
6116 | 6116 | Kern | Kern | 29 | 2021-05-25 | 109738 | 1385 | |
6117 | 6117 | Kings | Kings | 31 | 2021-05-25 | 23042 | 247 | |
6118 | 6118 | Lake | Lake | 33 | 2021-05-25 | 3491 | 43 | |
6119 | 6119 | Lassen | Lassen | 35 | 2021-05-25 | 5726 | 24 | TRUE |
6120 | 6120 | Long Beach | Los Angeles | 37 | 2021-05-25 | 53328 | 937 | |
6121 | 6121 | Los Angeles | Los Angeles | 37 | 2021-05-25 | 1174513 | 22903 | |
6122 | 6122 | Pasadena | Los Angeles | 37 | 2021-05-25 | 11286 | 346 | |
6123 | 6123 | Madera | Madera | 39 | 2021-05-25 | 16420 | 244 | |
6124 | 6124 | Marin | Marin | 41 | 2021-05-25 | 14114 | 211 | |
6125 | 6125 | Mariposa | Mariposa | 43 | 2021-05-25 | 454 | 7 | |
6126 | 6126 | Mendocino | Mendocino | 45 | 2021-05-25 | 4182 | 49 | |
6127 | 6127 | Merced | Merced | 47 | 2021-05-25 | 32093 | 468 | |
6128 | 6128 | Modoc | Modoc | 49 | 2021-05-25 | 511 | 4 | |
6129 | 6129 | Mono | Mono | 51 | 2021-05-25 | 1293 | 4 | |
6130 | 6130 | Monterey | Monterey | 53 | 2021-05-25 | 43698 | 385 | |
6131 | 6131 | Napa | Napa | 55 | 2021-05-25 | 9926 | 78 | |
6132 | 6132 | Nevada | Nevada | 57 | 2021-05-25 | 4798 | 75 | |
6133 | 6133 | Orange | Orange | 59 | 2021-05-25 | 255070 | 5054 | |
6134 | 6134 | Placer | Placer | 61 | 2021-05-25 | 22942 | 295 | |
6135 | 6135 | Plumas | Plumas | 63 | 2021-05-25 | 723 | 6 | TRUE |
6136 | 6136 | Riverside | Riverside | 65 | 2021-05-25 | 300476 | 4608 | |
6137 | 6137 | Sacramento | Sacramento | 67 | 2021-05-25 | 105963 | 1700 | |
6138 | 6138 | San Benito | San Benito | 69 | 2021-05-25 | 6088 | 63 | |
6139 | 6139 | San Bernardino | San Bernardino | 71 | 2021-05-25 | 297688 | 4823 | |
6140 | 6140 | San Diego | San Diego | 73 | 2021-05-25 | 279785 | 3753 | |
6141 | 6141 | San Francisco | San Francisco | 75 | 2021-05-25 | 36605 | 542 | |
6142 | 6142 | San Joaquin | San Joaquin | 77 | 2021-05-25 | 73717 | 1419 | |
6143 | 6143 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-25 | 21284 | 261 | |
6144 | 6144 | San Mateo | San Mateo | 81 | 2021-05-25 | 42029 | 573 | |
6145 | 6145 | Santa Barbara | Santa Barbara | 83 | 2021-05-25 | 34462 | 450 | |
6146 | 6146 | Santa Clara | Santa Clara | 85 | 2021-05-25 | 118253 | 1689 | |
6147 | 6147 | Santa Cruz | Santa Cruz | 87 | 2021-05-25 | 16169 | 206 | |
6148 | 6148 | Shasta | Shasta | 89 | 2021-05-25 | 12382 | 228 | |
6149 | 6149 | Sierra | Sierra | 91 | 2021-05-25 | 112 | 0 | |
6150 | 6150 | Siskiyou | Siskiyou | 93 | 2021-05-25 | 2337 | 29 | |
6151 | 6151 | Solano | Solano | 95 | 2021-05-25 | 33202 | 234 | |
6152 | 6152 | Sonoma | Sonoma | 97 | 2021-05-25 | 30170 | 315 | |
6153 | 6153 | Stanislaus | Stanislaus | 99 | 2021-05-25 | 56043 | 1066 | |
6154 | 6154 | Sutter | Sutter | 101 | 2021-05-25 | 9509 | 106 | |
6155 | 6155 | Tehama | Tehama | 103 | 2021-05-25 | 5648 | 59 | |
6156 | 6156 | Trinity | Trinity | 105 | 2021-05-25 | 410 | 5 | |
6157 | 6157 | Tulare | Tulare | 107 | 2021-05-25 | 49758 | 842 | |
6158 | 6158 | Tuolumne | Tuolumne | 109 | 2021-05-25 | 4161 | 67 | |
6159 | 6159 | Ventura | Ventura | 111 | 2021-05-25 | 81280 | 1018 | |
6160 | 6160 | Yolo | Yolo | 113 | 2021-05-25 | 13939 | 208 | |
6161 | 6161 | Yuba | Yuba | 115 | 2021-05-25 | 6344 | 41 | |
6162 | 6162 | Alameda | Alameda | 1 | 2021-05-24 | 85002 | 1217 | |
6163 | 6163 | Berkeley | Alameda | 1 | 2021-05-24 | 3618 | 46 | |
6164 | 6164 | Alpine | Alpine | 3 | 2021-05-24 | 89 | 0 | |
6165 | 6165 | Amador | Amador | 5 | 2021-05-24 | 3637 | 47 | TRUE |
6166 | 6166 | Butte | Butte | 7 | 2021-05-24 | 12279 | 187 | |
6167 | 6167 | Calaveras | Calaveras | 9 | 2021-05-24 | 2159 | 56 | |
6168 | 6168 | Colusa | Colusa | 11 | 2021-05-24 | 2254 | 18 | |
6169 | 6169 | Contra Costa | Contra Costa | 13 | 2021-05-24 | 69392 | 796 | |
6170 | 6170 | Del Norte | Del Norte | 15 | 2021-05-24 | 1423 | 7 | |
6171 | 6171 | El Dorado | El Dorado | 17 | 2021-05-24 | 10266 | 113 | |
6172 | 6172 | Fresno | Fresno | 19 | 2021-05-24 | 101732 | 1698 | |
6173 | 6173 | Glenn | Glenn | 21 | 2021-05-24 | 2341 | 25 | TRUE |
6174 | 6174 | Humboldt | Humboldt | 23 | 2021-05-24 | 4248 | 43 | |
6175 | 6175 | Imperial | Imperial | 25 | 2021-05-24 | 28088 | 731 | |
6176 | 6176 | Inyo | Inyo | 27 | 2021-05-24 | 1429 | 38 | |
6177 | 6177 | Kern | Kern | 29 | 2021-05-24 | 109676 | 1383 | |
6178 | 6178 | Kings | Kings | 31 | 2021-05-24 | 23038 | 247 | |
6179 | 6179 | Lake | Lake | 33 | 2021-05-24 | 3488 | 43 | |
6180 | 6180 | Lassen | Lassen | 35 | 2021-05-24 | 5726 | 24 | |
6181 | 6181 | Long Beach | Los Angeles | 37 | 2021-05-24 | 53295 | 935 |
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 );