latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 445
- Orange 445
- Santa Clara 445
- San Benito 440
- Humboldt 423
- Sacramento 423
- Solano 419
- Alameda 418
- Calaveras 418
- Contra Costa 418
- Marin 418
- Placer 418
- Riverside 418
- San Diego 418
- San Francisco 418
- San Mateo 418
- Santa Cruz 418
- Shasta 418
- Sonoma 418
- Stanislaus 418
- Ventura 418
- Yolo 418
- Fresno 414
- San Joaquin 410
- Madera 404
- Imperial 400
- Tulare 400
- Amador 398
- San Luis Obispo 397
- San Bernardino 396
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
8179 | 8179 | 2021-04-14 | Alameda | 1 | 85496 | 1254 | 83 | 0 |
8180 | 8180 | 2021-04-14 | Alpine | 3 | 88 | 0 | 0 | 0 |
8181 | 8181 | 2021-04-14 | Amador | 5 | 3581 | 46 | 5 | 0 |
8182 | 8182 | 2021-04-14 | Butte | 7 | 11513 | 181 | 16 | 0 |
8183 | 8183 | 2021-04-14 | Calaveras | 9 | 2048 | 51 | 3 | 0 |
8184 | 8184 | 2021-04-14 | Colusa | 11 | 2189 | 16 | 1 | 0 |
8185 | 8185 | 2021-04-14 | Contra Costa | 13 | 66666 | 767 | 99 | 3 |
8186 | 8186 | 2021-04-14 | Del Norte | 15 | 1271 | 7 | 8 | 0 |
8187 | 8187 | 2021-04-14 | El Dorado | 17 | 9677 | 108 | 15 | 0 |
8188 | 8188 | 2021-04-14 | Fresno | 19 | 99974 | 1636 | 80 | 3 |
8189 | 8189 | 2021-04-14 | Glenn | 21 | 2292 | 25 | 0 | 0 |
8190 | 8190 | 2021-04-14 | Humboldt | 23 | 3572 | 36 | 12 | 0 |
8191 | 8191 | 2021-04-14 | Imperial | 25 | 27515 | 716 | 3 | 0 |
8192 | 8192 | 2021-04-14 | Inyo | 27 | 1417 | 38 | 1 | 0 |
8193 | 8193 | 2021-04-14 | Kern | 29 | 107591 | 1306 | 157 | 0 |
8194 | 8194 | 2021-04-14 | Kings | 31 | 22730 | 245 | 7 | 0 |
8195 | 8195 | 2021-04-14 | Lake | 33 | 3375 | 43 | 16 | 0 |
8196 | 8196 | 2021-04-14 | Lassen | 35 | 5666 | 24 | 0 | 0 |
8197 | 8197 | 2021-04-14 | Los Angeles | 37 | 1227002 | 23554 | 375 | 54 |
8198 | 8198 | 2021-04-14 | Madera | 39 | 16122 | 239 | 12 | 0 |
8199 | 8199 | 2021-04-14 | Marin | 41 | 13815 | 205 | 0 | 0 |
8200 | 8200 | 2021-04-14 | Mariposa | 43 | 417 | 7 | 0 | 0 |
8201 | 8201 | 2021-04-14 | Mendocino | 45 | 3977 | 47 | 0 | 0 |
8202 | 8202 | 2021-04-14 | Merced | 47 | 31128 | 450 | 23 | 1 |
8203 | 8203 | 2021-04-14 | Modoc | 49 | 488 | 4 | 1 | 0 |
8204 | 8204 | 2021-04-14 | Mono | 51 | 1273 | 4 | 1 | 0 |
8205 | 8205 | 2021-04-14 | Monterey | 53 | 43226 | 348 | 17 | 0 |
8206 | 8206 | 2021-04-14 | Napa | 55 | 9636 | 75 | 18 | 0 |
8207 | 8207 | 2021-04-14 | Nevada | 57 | 4425 | 75 | 7 | 0 |
8208 | 8208 | 2021-04-14 | Orange | 59 | 252627 | 4862 | 89 | 13 |
8209 | 8209 | 2021-04-14 | Placer | 61 | 21644 | 281 | 44 | 0 |
8210 | 8210 | 2021-04-14 | Plumas | 63 | 688 | 6 | 0 | 0 |
8211 | 8211 | 2021-04-14 | Riverside | 65 | 296908 | 4514 | 107 | 10 |
8212 | 8212 | 2021-04-14 | Sacramento | 67 | 100726 | 1644 | 139 | 0 |
8213 | 8213 | 2021-04-14 | San Benito | 69 | 5944 | 63 | 8 | 1 |
8214 | 8214 | 2021-04-14 | San Bernardino | 71 | 294101 | 4772 | 176 | 2 |
8215 | 8215 | 2021-04-14 | San Diego | 73 | 273968 | 3648 | 260 | 25 |
8216 | 8216 | 2021-04-14 | San Francisco | 75 | 35634 | 507 | 35 | 5 |
8217 | 8217 | 2021-04-14 | San Joaquin | 77 | 71229 | 1334 | 51 | 0 |
8218 | 8218 | 2021-04-14 | San Luis Obispo | 79 | 20857 | 256 | 30 | 0 |
8219 | 8219 | 2021-04-14 | San Mateo | 81 | 40951 | 556 | 41 | 0 |
8220 | 8220 | 2021-04-14 | Santa Barbara | 83 | 33774 | 443 | 38 | 2 |
8221 | 8221 | 2021-04-14 | Santa Clara | 85 | 115714 | 1669 | 149 | 0 |
8222 | 8222 | 2021-04-14 | Santa Cruz | 87 | 15466 | 202 | 34 | 0 |
8223 | 8223 | 2021-04-14 | Shasta | 89 | 11627 | 216 | 57 | 2 |
8224 | 8224 | 2021-04-14 | Sierra | 91 | 108 | 0 | 0 | 0 |
8225 | 8225 | 2021-04-14 | Siskiyou | 93 | 1924 | 21 | 15 | 1 |
8226 | 8226 | 2021-04-14 | Solano | 95 | 31734 | 209 | 32 | 0 |
8227 | 8227 | 2021-04-14 | Sonoma | 97 | 29573 | 311 | 0 | 0 |
8228 | 8228 | 2021-04-14 | Stanislaus | 99 | 53692 | 1023 | 42 | 3 |
8229 | 8229 | 2021-04-14 | Sutter | 101 | 9253 | 104 | 8 | 1 |
8230 | 8230 | 2021-04-14 | Tehama | 103 | 5393 | 56 | 0 | 0 |
8231 | 8231 | 2021-04-14 | Trinity | 105 | 398 | 5 | 0 | 0 |
8232 | 8232 | 2021-04-14 | Tulare | 107 | 49318 | 825 | 18 | 2 |
8233 | 8233 | 2021-04-14 | Tuolumne | 109 | 4062 | 64 | 4 | 0 |
8234 | 8234 | 2021-04-14 | Ventura | 111 | 80156 | 992 | 44 | 2 |
8235 | 8235 | 2021-04-14 | Yolo | 113 | 13431 | 199 | 13 | 0 |
8236 | 8236 | 2021-04-14 | Yuba | 115 | 6084 | 40 | 1 | 0 |
8237 | 8237 | 2021-04-13 | Alameda | 1 | 85413 | 1254 | 90 | 0 |
8238 | 8238 | 2021-04-13 | Alpine | 3 | 88 | 0 | 0 | 0 |
8239 | 8239 | 2021-04-13 | Amador | 5 | 3576 | 46 | 0 | 0 |
8240 | 8240 | 2021-04-13 | Butte | 7 | 11497 | 181 | 9 | 0 |
8241 | 8241 | 2021-04-13 | Calaveras | 9 | 2045 | 51 | 4 | 0 |
8242 | 8242 | 2021-04-13 | Colusa | 11 | 2188 | 16 | 4 | 0 |
8243 | 8243 | 2021-04-13 | Contra Costa | 13 | 66567 | 764 | 125 | 0 |
8244 | 8244 | 2021-04-13 | Del Norte | 15 | 1263 | 7 | 9 | 0 |
8245 | 8245 | 2021-04-13 | El Dorado | 17 | 9662 | 108 | 21 | 0 |
8246 | 8246 | 2021-04-13 | Fresno | 19 | 99894 | 1633 | 61 | 0 |
8247 | 8247 | 2021-04-13 | Glenn | 21 | 2292 | 25 | 2 | 0 |
8248 | 8248 | 2021-04-13 | Humboldt | 23 | 3560 | 36 | 7 | 0 |
8249 | 8249 | 2021-04-13 | Imperial | 25 | 27512 | 716 | 18 | 0 |
8250 | 8250 | 2021-04-13 | Inyo | 27 | 1416 | 38 | 1 | 0 |
8251 | 8251 | 2021-04-13 | Kern | 29 | 107434 | 1306 | 60 | 2 |
8252 | 8252 | 2021-04-13 | Kings | 31 | 22723 | 245 | 15 | 2 |
8253 | 8253 | 2021-04-13 | Lake | 33 | 3359 | 43 | 7 | 0 |
8254 | 8254 | 2021-04-13 | Lassen | 35 | 5666 | 24 | 0 | 0 |
8255 | 8255 | 2021-04-13 | Los Angeles | 37 | 1226627 | 23500 | 408 | 21 |
8256 | 8256 | 2021-04-13 | Madera | 39 | 16110 | 239 | 33 | 3 |
8257 | 8257 | 2021-04-13 | Marin | 41 | 13815 | 205 | 2 | 0 |
8258 | 8258 | 2021-04-13 | Mariposa | 43 | 417 | 7 | 1 | 0 |
8259 | 8259 | 2021-04-13 | Mendocino | 45 | 3977 | 47 | 3 | 0 |
8260 | 8260 | 2021-04-13 | Merced | 47 | 31105 | 449 | 35 | 1 |
8261 | 8261 | 2021-04-13 | Modoc | 49 | 487 | 4 | 0 | 0 |
8262 | 8262 | 2021-04-13 | Mono | 51 | 1272 | 4 | 0 | 0 |
8263 | 8263 | 2021-04-13 | Monterey | 53 | 43209 | 348 | 52 | 1 |
8264 | 8264 | 2021-04-13 | Napa | 55 | 9618 | 75 | 21 | 0 |
8265 | 8265 | 2021-04-13 | Nevada | 57 | 4418 | 75 | 7 | 0 |
8266 | 8266 | 2021-04-13 | Orange | 59 | 252538 | 4849 | 102 | 10 |
8267 | 8267 | 2021-04-13 | Placer | 61 | 21600 | 281 | 60 | 2 |
8268 | 8268 | 2021-04-13 | Plumas | 63 | 688 | 6 | 0 | 0 |
8269 | 8269 | 2021-04-13 | Riverside | 65 | 296801 | 4504 | 166 | 12 |
8270 | 8270 | 2021-04-13 | Sacramento | 67 | 100587 | 1644 | 222 | 4 |
8271 | 8271 | 2021-04-13 | San Benito | 69 | 5936 | 62 | 8 | 0 |
8272 | 8272 | 2021-04-13 | San Bernardino | 71 | 293925 | 4770 | 90 | 3 |
8273 | 8273 | 2021-04-13 | San Diego | 73 | 273708 | 3623 | 278 | 2 |
8274 | 8274 | 2021-04-13 | San Francisco | 75 | 35599 | 502 | 23 | 0 |
8275 | 8275 | 2021-04-13 | San Joaquin | 77 | 71178 | 1334 | 184 | 0 |
8276 | 8276 | 2021-04-13 | San Luis Obispo | 79 | 20827 | 256 | 73 | 0 |
8277 | 8277 | 2021-04-13 | San Mateo | 81 | 40910 | 556 | 30 | 0 |
8278 | 8278 | 2021-04-13 | Santa Barbara | 83 | 33736 | 441 | 9 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );