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
- Santa Clara 444
- Los Angeles 443
- Orange 443
- San Benito 438
- Humboldt 421
- Sacramento 421
- Solano 418
- Santa Cruz 417
- Shasta 417
- Sonoma 417
- Stanislaus 417
- Ventura 417
- Yolo 417
- Alameda 416
- Calaveras 416
- Contra Costa 416
- Marin 416
- Placer 416
- Riverside 416
- San Diego 416
- San Francisco 416
- San Mateo 416
- Fresno 412
- San Joaquin 408
- Madera 402
- Tulare 399
- Imperial 398
- Amador 396
- San Luis Obispo 395
- San Bernardino 394
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
8279 | 8279 | 2021-04-13 | Santa Clara | 85 | 115565 | 1669 | 120 | 0 |
8280 | 8280 | 2021-04-13 | Santa Cruz | 87 | 15432 | 202 | 38 | 0 |
8281 | 8281 | 2021-04-13 | Shasta | 89 | 11570 | 214 | 31 | 0 |
8282 | 8282 | 2021-04-13 | Sierra | 91 | 108 | 0 | 0 | 0 |
8283 | 8283 | 2021-04-13 | Siskiyou | 93 | 1909 | 20 | 5 | 1 |
8284 | 8284 | 2021-04-13 | Solano | 95 | 31702 | 209 | 29 | 0 |
8285 | 8285 | 2021-04-13 | Sonoma | 97 | 29573 | 311 | 37 | 2 |
8286 | 8286 | 2021-04-13 | Stanislaus | 99 | 53650 | 1020 | 74 | 2 |
8287 | 8287 | 2021-04-13 | Sutter | 101 | 9245 | 103 | 3 | 0 |
8288 | 8288 | 2021-04-13 | Tehama | 103 | 5393 | 56 | 0 | 0 |
8289 | 8289 | 2021-04-13 | Trinity | 105 | 398 | 5 | 1 | 0 |
8290 | 8290 | 2021-04-13 | Tulare | 107 | 49300 | 823 | 28 | 0 |
8291 | 8291 | 2021-04-13 | Tuolumne | 109 | 4058 | 64 | 2 | 0 |
8292 | 8292 | 2021-04-13 | Ventura | 111 | 80112 | 990 | 34 | 0 |
8293 | 8293 | 2021-04-13 | Yolo | 113 | 13418 | 199 | 16 | 0 |
8294 | 8294 | 2021-04-13 | Yuba | 115 | 6083 | 40 | 10 | 0 |
8295 | 8295 | 2021-04-12 | Alameda | 1 | 85323 | 1254 | 65 | 1 |
8296 | 8296 | 2021-04-12 | Alpine | 3 | 88 | 0 | 0 | 0 |
8297 | 8297 | 2021-04-12 | Amador | 5 | 3576 | 46 | 3 | 0 |
8298 | 8298 | 2021-04-12 | Butte | 7 | 11488 | 181 | 1 | 3 |
8299 | 8299 | 2021-04-12 | Calaveras | 9 | 2041 | 51 | 5 | 0 |
8300 | 8300 | 2021-04-12 | Colusa | 11 | 2184 | 16 | 6 | 0 |
8301 | 8301 | 2021-04-12 | Contra Costa | 13 | 66442 | 764 | 73 | 0 |
8302 | 8302 | 2021-04-12 | Del Norte | 15 | 1254 | 7 | 9 | 2 |
8303 | 8303 | 2021-04-12 | El Dorado | 17 | 9641 | 108 | 61 | 0 |
8304 | 8304 | 2021-04-12 | Fresno | 19 | 99833 | 1633 | 66 | 3 |
8305 | 8305 | 2021-04-12 | Glenn | 21 | 2290 | 25 | 6 | 0 |
8306 | 8306 | 2021-04-12 | Humboldt | 23 | 3553 | 36 | 35 | 0 |
8307 | 8307 | 2021-04-12 | Imperial | 25 | 27494 | 716 | 93 | 0 |
8308 | 8308 | 2021-04-12 | Inyo | 27 | 1415 | 38 | 3 | 0 |
8309 | 8309 | 2021-04-12 | Kern | 29 | 107374 | 1304 | 33 | 0 |
8310 | 8310 | 2021-04-12 | Kings | 31 | 22708 | 243 | 3 | 0 |
8311 | 8311 | 2021-04-12 | Lake | 33 | 3352 | 43 | 12 | 0 |
8312 | 8312 | 2021-04-12 | Lassen | 35 | 5666 | 24 | 6 | 0 |
8313 | 8313 | 2021-04-12 | Los Angeles | 37 | 1226219 | 23479 | 423 | 2 |
8314 | 8314 | 2021-04-12 | Madera | 39 | 16077 | 236 | 48 | 0 |
8315 | 8315 | 2021-04-12 | Marin | 41 | 13813 | 205 | 7 | 0 |
8316 | 8316 | 2021-04-12 | Mariposa | 43 | 416 | 7 | 1 | 0 |
8317 | 8317 | 2021-04-12 | Mendocino | 45 | 3974 | 47 | 8 | 0 |
8318 | 8318 | 2021-04-12 | Merced | 47 | 31070 | 448 | 61 | 0 |
8319 | 8319 | 2021-04-12 | Modoc | 49 | 487 | 4 | 5 | 0 |
8320 | 8320 | 2021-04-12 | Mono | 51 | 1272 | 4 | 2 | 0 |
8321 | 8321 | 2021-04-12 | Monterey | 53 | 43157 | 347 | 0 | 0 |
8322 | 8322 | 2021-04-12 | Napa | 55 | 9597 | 75 | 50 | 0 |
8323 | 8323 | 2021-04-12 | Nevada | 57 | 4411 | 75 | 32 | 0 |
8324 | 8324 | 2021-04-12 | Orange | 59 | 252436 | 4839 | 120 | 0 |
8325 | 8325 | 2021-04-12 | Placer | 61 | 21540 | 279 | 151 | 0 |
8326 | 8326 | 2021-04-12 | Plumas | 63 | 688 | 6 | 1 | 0 |
8327 | 8327 | 2021-04-12 | Riverside | 65 | 296635 | 4492 | 545 | 11 |
8328 | 8328 | 2021-04-12 | Sacramento | 67 | 100365 | 1640 | 697 | 2 |
8329 | 8329 | 2021-04-12 | San Benito | 69 | 5928 | 62 | 5 | 0 |
8330 | 8330 | 2021-04-12 | San Bernardino | 71 | 293835 | 4767 | 197 | 1 |
8331 | 8331 | 2021-04-12 | San Diego | 73 | 273430 | 3621 | 144 | 0 |
8332 | 8332 | 2021-04-12 | San Francisco | 75 | 35576 | 502 | 94 | 6 |
8333 | 8333 | 2021-04-12 | San Joaquin | 77 | 70994 | 1334 | 248 | 6 |
8334 | 8334 | 2021-04-12 | San Luis Obispo | 79 | 20754 | 256 | 31 | 0 |
8335 | 8335 | 2021-04-12 | San Mateo | 81 | 40880 | 556 | 126 | 0 |
8336 | 8336 | 2021-04-12 | Santa Barbara | 83 | 33727 | 441 | 23 | 0 |
8337 | 8337 | 2021-04-12 | Santa Clara | 85 | 115445 | 1669 | 143 | 1 |
8338 | 8338 | 2021-04-12 | Santa Cruz | 87 | 15394 | 202 | 60 | 0 |
8339 | 8339 | 2021-04-12 | Shasta | 89 | 11539 | 214 | 30 | 1 |
8340 | 8340 | 2021-04-12 | Sierra | 91 | 108 | 0 | 1 | 0 |
8341 | 8341 | 2021-04-12 | Siskiyou | 93 | 1904 | 19 | 5 | 0 |
8342 | 8342 | 2021-04-12 | Solano | 95 | 31673 | 209 | 146 | 6 |
8343 | 8343 | 2021-04-12 | Sonoma | 97 | 29536 | 309 | 35 | 0 |
8344 | 8344 | 2021-04-12 | Stanislaus | 99 | 53576 | 1018 | 131 | 1 |
8345 | 8345 | 2021-04-12 | Sutter | 101 | 9242 | 103 | 17 | 1 |
8346 | 8346 | 2021-04-12 | Tehama | 103 | 5393 | 56 | 34 | 0 |
8347 | 8347 | 2021-04-12 | Trinity | 105 | 397 | 5 | 2 | 0 |
8348 | 8348 | 2021-04-12 | Tulare | 107 | 49272 | 823 | 41 | 2 |
8349 | 8349 | 2021-04-12 | Tuolumne | 109 | 4056 | 64 | 4 | 0 |
8350 | 8350 | 2021-04-12 | Ventura | 111 | 80078 | 990 | 115 | 0 |
8351 | 8351 | 2021-04-12 | Yolo | 113 | 13402 | 199 | 38 | 0 |
8352 | 8352 | 2021-04-12 | Yuba | 115 | 6073 | 40 | 9 | 0 |
8353 | 8353 | 2021-04-11 | Alameda | 1 | 85258 | 1253 | 131 | 0 |
8354 | 8354 | 2021-04-11 | Alpine | 3 | 88 | 0 | 0 | 0 |
8355 | 8355 | 2021-04-11 | Amador | 5 | 3573 | 46 | 4 | 0 |
8356 | 8356 | 2021-04-11 | Butte | 7 | 11487 | 178 | 5 | 0 |
8357 | 8357 | 2021-04-11 | Calaveras | 9 | 2036 | 51 | 0 | 0 |
8358 | 8358 | 2021-04-11 | Colusa | 11 | 2178 | 16 | 0 | 0 |
8359 | 8359 | 2021-04-11 | Contra Costa | 13 | 66369 | 764 | 107 | 0 |
8360 | 8360 | 2021-04-11 | Del Norte | 15 | 1245 | 5 | 0 | 0 |
8361 | 8361 | 2021-04-11 | El Dorado | 17 | 9580 | 108 | 0 | 0 |
8362 | 8362 | 2021-04-11 | Fresno | 19 | 99767 | 1630 | 33 | 0 |
8363 | 8363 | 2021-04-11 | Glenn | 21 | 2284 | 25 | 0 | 0 |
8364 | 8364 | 2021-04-11 | Humboldt | 23 | 3518 | 36 | 0 | 0 |
8365 | 8365 | 2021-04-11 | Imperial | 25 | 27401 | 716 | 0 | 0 |
8366 | 8366 | 2021-04-11 | Inyo | 27 | 1412 | 38 | 0 | 0 |
8367 | 8367 | 2021-04-11 | Kern | 29 | 107341 | 1304 | 169 | 0 |
8368 | 8368 | 2021-04-11 | Kings | 31 | 22705 | 243 | 4 | 0 |
8369 | 8369 | 2021-04-11 | Lake | 33 | 3340 | 43 | 0 | 0 |
8370 | 8370 | 2021-04-11 | Lassen | 35 | 5660 | 24 | 0 | 0 |
8371 | 8371 | 2021-04-11 | Los Angeles | 37 | 1225796 | 23477 | 497 | 10 |
8372 | 8372 | 2021-04-11 | Madera | 39 | 16029 | 236 | 0 | 0 |
8373 | 8373 | 2021-04-11 | Marin | 41 | 13806 | 205 | 9 | 0 |
8374 | 8374 | 2021-04-11 | Mariposa | 43 | 415 | 7 | 0 | 0 |
8375 | 8375 | 2021-04-11 | Mendocino | 45 | 3966 | 47 | 0 | 0 |
8376 | 8376 | 2021-04-11 | Merced | 47 | 31009 | 448 | 0 | 0 |
8377 | 8377 | 2021-04-11 | Modoc | 49 | 482 | 4 | 0 | 0 |
8378 | 8378 | 2021-04-11 | Mono | 51 | 1270 | 4 | 0 | 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 );