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,284
- Alameda 850
- Orange 452
- Santa Clara 452
- San Benito 447
- Humboldt 430
- Sacramento 430
- Solano 426
- Calaveras 425
- Contra Costa 425
- Marin 425
- Placer 425
- Riverside 425
- San Diego 425
- San Francisco 425
- San Mateo 425
- Santa Cruz 425
- Shasta 425
- Sonoma 425
- Stanislaus 425
- Ventura 425
- Yolo 425
- Fresno 421
- San Joaquin 417
- Madera 411
- Imperial 407
- Tulare 407
- Amador 405
- San Luis Obispo 404
- San Bernardino 403
- …
agency >30
- Los Angeles 452
- Orange 452
- Santa Clara 452
- San Benito 447
- Humboldt 430
- Sacramento 430
- Solano 426
- Alameda 425
- Berkeley 425
- Calaveras 425
- Contra Costa 425
- Long Beach 425
- Marin 425
- Placer 425
- Riverside 425
- San Diego 425
- San Francisco 425
- San Mateo 425
- Santa Cruz 425
- Shasta 425
- Sonoma 425
- Stanislaus 425
- Ventura 425
- Yolo 425
- Fresno 421
- San Joaquin 417
- Madera 411
- Imperial 407
- Pasadena 407
- Tulare 407
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
8175 | 8175 | Alameda | Alameda | 1 | 2021-04-21 | 82683 | 1216 | |
8176 | 8176 | Berkeley | Alameda | 1 | 2021-04-21 | 3535 | 46 | |
8177 | 8177 | Alpine | Alpine | 3 | 2021-04-21 | 88 | 0 | |
8178 | 8178 | Amador | Amador | 5 | 2021-04-21 | 3598 | 46 | |
8179 | 8179 | Butte | Butte | 7 | 2021-04-21 | 11643 | 181 | |
8180 | 8180 | Calaveras | Calaveras | 9 | 2021-04-21 | 2064 | 52 | |
8181 | 8181 | Colusa | Colusa | 11 | 2021-04-21 | 2208 | 16 | |
8182 | 8182 | Contra Costa | Contra Costa | 13 | 2021-04-21 | 67223 | 768 | |
8183 | 8183 | Del Norte | Del Norte | 15 | 2021-04-21 | 1291 | 7 | |
8184 | 8184 | El Dorado | El Dorado | 17 | 2021-04-21 | 9818 | 109 | |
8185 | 8185 | Fresno | Fresno | 19 | 2021-04-21 | 100351 | 1650 | |
8186 | 8186 | Glenn | Glenn | 21 | 2021-04-21 | 2300 | 25 | TRUE |
8187 | 8187 | Humboldt | Humboldt | 23 | 2021-04-21 | 3659 | 38 | |
8188 | 8188 | Imperial | Imperial | 25 | 2021-04-21 | 27672 | 718 | |
8189 | 8189 | Inyo | Inyo | 27 | 2021-04-21 | 1418 | 38 | |
8190 | 8190 | Kern | Kern | 29 | 2021-04-21 | 108061 | 1333 | |
8191 | 8191 | Kings | Kings | 31 | 2021-04-21 | 22796 | 246 | |
8192 | 8192 | Lake | Lake | 33 | 2021-04-21 | 3403 | 43 | |
8193 | 8193 | Lassen | Lassen | 35 | 2021-04-21 | 5679 | 24 | |
8194 | 8194 | Long Beach | Los Angeles | 37 | 2021-04-21 | 52714 | 928 | |
8195 | 8195 | Los Angeles | Los Angeles | 37 | 2021-04-21 | 1166100 | 22434 | |
8196 | 8196 | Pasadena | Los Angeles | 37 | 2021-04-21 | 11203 | 340 | |
8197 | 8197 | Madera | Madera | 39 | 2021-04-21 | 16210 | 240 | |
8198 | 8198 | Marin | Marin | 41 | 2021-04-21 | 13880 | 208 | |
8199 | 8199 | Mariposa | Mariposa | 43 | 2021-04-21 | 429 | 7 | |
8200 | 8200 | Mendocino | Mendocino | 45 | 2021-04-21 | 3996 | 47 | |
8201 | 8201 | Merced | Merced | 47 | 2021-04-21 | 31321 | 454 | |
8202 | 8202 | Modoc | Modoc | 49 | 2021-04-21 | 492 | 4 | |
8203 | 8203 | Mono | Mono | 51 | 2021-04-21 | 1274 | 4 | |
8204 | 8204 | Monterey | Monterey | 53 | 2021-04-21 | 43332 | 379 | |
8205 | 8205 | Napa | Napa | 55 | 2021-04-21 | 9725 | 75 | |
8206 | 8206 | Nevada | Nevada | 57 | 2021-04-21 | 4502 | 75 | |
8207 | 8207 | Orange | Orange | 59 | 2021-04-21 | 253206 | 4902 | |
8208 | 8208 | Placer | Placer | 61 | 2021-04-21 | 21957 | 283 | |
8209 | 8209 | Plumas | Plumas | 63 | 2021-04-21 | 693 | 6 | TRUE |
8210 | 8210 | Riverside | Riverside | 65 | 2021-04-21 | 297631 | 4547 | |
8211 | 8211 | Sacramento | Sacramento | 67 | 2021-04-21 | 101787 | 1651 | |
8212 | 8212 | San Benito | San Benito | 69 | 2021-04-21 | 5987 | 63 | |
8213 | 8213 | San Bernardino | San Bernardino | 71 | 2021-04-21 | 295131 | 4784 | |
8214 | 8214 | San Diego | San Diego | 73 | 2021-04-21 | 275251 | 3681 | |
8215 | 8215 | San Francisco | San Francisco | 75 | 2021-04-21 | 35850 | 528 | |
8216 | 8216 | San Joaquin | San Joaquin | 77 | 2021-04-21 | 71813 | 1340 | |
8217 | 8217 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-21 | 21010 | 258 | |
8218 | 8218 | San Mateo | San Mateo | 81 | 2021-04-21 | 41221 | 560 | |
8219 | 8219 | Santa Barbara | Santa Barbara | 83 | 2021-04-21 | 33926 | 445 | TRUE |
8220 | 8220 | Santa Clara | Santa Clara | 85 | 2021-04-21 | 116524 | 1673 | |
8221 | 8221 | Santa Cruz | Santa Cruz | 87 | 2021-04-21 | 15719 | 203 | |
8222 | 8222 | Shasta | Shasta | 89 | 2021-04-21 | 11743 | 219 | |
8223 | 8223 | Sierra | Sierra | 91 | 2021-04-21 | 110 | 0 | |
8224 | 8224 | Siskiyou | Siskiyou | 93 | 2021-04-21 | 1976 | 21 | |
8225 | 8225 | Solano | Solano | 95 | 2021-04-21 | 32086 | 212 | |
8226 | 8226 | Sonoma | Sonoma | 97 | 2021-04-21 | 29734 | 312 | |
8227 | 8227 | Stanislaus | Stanislaus | 99 | 2021-04-21 | 54158 | 1035 | |
8228 | 8228 | Sutter | Sutter | 101 | 2021-04-21 | 9314 | 104 | |
8229 | 8229 | Tehama | Tehama | 103 | 2021-04-21 | 5453 | 56 | |
8230 | 8230 | Trinity | Trinity | 105 | 2021-04-21 | 398 | 5 | |
8231 | 8231 | Tulare | Tulare | 107 | 2021-04-21 | 49444 | 831 | |
8232 | 8232 | Tuolumne | Tuolumne | 109 | 2021-04-21 | 4089 | 64 | |
8233 | 8233 | Ventura | Ventura | 111 | 2021-04-21 | 80360 | 1002 | |
8234 | 8234 | Yolo | Yolo | 113 | 2021-04-21 | 13532 | 200 | |
8235 | 8235 | Yuba | Yuba | 115 | 2021-04-21 | 6136 | 40 | |
8236 | 8236 | Alameda | Alameda | 1 | 2021-04-20 | 82608 | 1214 | |
8237 | 8237 | Berkeley | Alameda | 1 | 2021-04-20 | 3529 | 46 | |
8238 | 8238 | Alpine | Alpine | 3 | 2021-04-20 | 88 | 0 | TRUE |
8239 | 8239 | Amador | Amador | 5 | 2021-04-20 | 3597 | 46 | |
8240 | 8240 | Butte | Butte | 7 | 2021-04-20 | 11619 | 181 | |
8241 | 8241 | Calaveras | Calaveras | 9 | 2021-04-20 | 2062 | 52 | |
8242 | 8242 | Colusa | Colusa | 11 | 2021-04-20 | 2204 | 16 | |
8243 | 8243 | Contra Costa | Contra Costa | 13 | 2021-04-20 | 67157 | 768 | |
8244 | 8244 | Del Norte | Del Norte | 15 | 2021-04-20 | 1290 | 7 | |
8245 | 8245 | El Dorado | El Dorado | 17 | 2021-04-20 | 9797 | 109 | |
8246 | 8246 | Fresno | Fresno | 19 | 2021-04-20 | 100294 | 1646 | |
8247 | 8247 | Glenn | Glenn | 21 | 2021-04-20 | 2300 | 25 | |
8248 | 8248 | Humboldt | Humboldt | 23 | 2021-04-20 | 3631 | 38 | |
8249 | 8249 | Imperial | Imperial | 25 | 2021-04-20 | 27665 | 718 | |
8250 | 8250 | Inyo | Inyo | 27 | 2021-04-20 | 1418 | 38 | |
8251 | 8251 | Kern | Kern | 29 | 2021-04-20 | 108013 | 1331 | |
8252 | 8252 | Kings | Kings | 31 | 2021-04-20 | 22781 | 245 | |
8253 | 8253 | Lake | Lake | 33 | 2021-04-20 | 3403 | 43 | |
8254 | 8254 | Lassen | Lassen | 35 | 2021-04-20 | 5679 | 24 | |
8255 | 8255 | Long Beach | Los Angeles | 37 | 2021-04-20 | 52700 | 928 | |
8256 | 8256 | Los Angeles | Los Angeles | 37 | 2021-04-20 | 1165462 | 22373 | |
8257 | 8257 | Pasadena | Los Angeles | 37 | 2021-04-20 | 11198 | 340 | |
8258 | 8258 | Madera | Madera | 39 | 2021-04-20 | 16205 | 240 | |
8259 | 8259 | Marin | Marin | 41 | 2021-04-20 | 13868 | 208 | |
8260 | 8260 | Mariposa | Mariposa | 43 | 2021-04-20 | 428 | 7 | |
8261 | 8261 | Mendocino | Mendocino | 45 | 2021-04-20 | 3993 | 47 | |
8262 | 8262 | Merced | Merced | 47 | 2021-04-20 | 31289 | 453 | |
8263 | 8263 | Modoc | Modoc | 49 | 2021-04-20 | 490 | 4 | TRUE |
8264 | 8264 | Mono | Mono | 51 | 2021-04-20 | 1274 | 4 | |
8265 | 8265 | Monterey | Monterey | 53 | 2021-04-20 | 43301 | 364 | |
8266 | 8266 | Napa | Napa | 55 | 2021-04-20 | 9715 | 75 | |
8267 | 8267 | Nevada | Nevada | 57 | 2021-04-20 | 4489 | 75 | |
8268 | 8268 | Orange | Orange | 59 | 2021-04-20 | 253153 | 4900 | |
8269 | 8269 | Placer | Placer | 61 | 2021-04-20 | 21908 | 283 | |
8270 | 8270 | Plumas | Plumas | 63 | 2021-04-20 | 693 | 6 | TRUE |
8271 | 8271 | Riverside | Riverside | 65 | 2021-04-20 | 297620 | 4547 | |
8272 | 8272 | Sacramento | Sacramento | 67 | 2021-04-20 | 101665 | 1647 | |
8273 | 8273 | San Benito | San Benito | 69 | 2021-04-20 | 5984 | 63 | |
8274 | 8274 | San Bernardino | San Bernardino | 71 | 2021-04-20 | 294973 | 4780 |
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 );