latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
1,319 rows where new_deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Santa Clara 78
- Alameda 76
- Stanislaus 65
- Tulare 59
- Contra Costa 56
- Orange 54
- Sacramento 53
- Merced 49
- San Bernardino 48
- Kern 47
- Imperial 41
- Monterey 40
- San Francisco 39
- Santa Barbara 39
- Ventura 36
- Kings 33
- San Diego 32
- Riverside 31
- San Joaquin 30
- Butte 28
- Sonoma 28
- Yolo 24
- Fresno 23
- Marin 23
- Shasta 23
- Placer 22
- Solano 22
- San Luis Obispo 21
- Madera 18
- San Mateo 18
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-09-02 | Alameda | 1 | 109537 | 1316 | 655 | 2 |
8 | 8 | 2021-09-02 | Del Norte | 15 | 3012 | 25 | 44 | 2 |
59 | 59 | 2021-09-01 | Alameda | 1 | 108882 | 1314 | 1200 | 2 |
63 | 63 | 2021-09-01 | Calaveras | 9 | 2923 | 63 | 59 | 2 |
79 | 79 | 2021-09-01 | Marin | 41 | 16332 | 217 | 21 | 2 |
100 | 100 | 2021-09-01 | Santa Barbara | 83 | 39389 | 480 | 175 | 2 |
109 | 109 | 2021-09-01 | Sutter | 101 | 12086 | 123 | 53 | 2 |
116 | 116 | 2021-09-01 | Yuba | 115 | 8784 | 52 | 233 | 2 |
129 | 129 | 2021-08-31 | Imperial | 25 | 29974 | 753 | 255 | 2 |
158 | 158 | 2021-08-31 | Santa Barbara | 83 | 39214 | 478 | 96 | 2 |
166 | 166 | 2021-08-31 | Stanislaus | 99 | 67474 | 1141 | 832 | 2 |
169 | 169 | 2021-08-31 | Trinity | 105 | 653 | 10 | 12 | 2 |
172 | 172 | 2021-08-31 | Ventura | 111 | 90577 | 1076 | 242 | 2 |
173 | 173 | 2021-08-31 | Yolo | 113 | 17050 | 231 | 125 | 2 |
185 | 185 | 2021-08-30 | Glenn | 21 | 2602 | 30 | 12 | 2 |
193 | 193 | 2021-08-30 | Los Angeles | 37 | 1403195 | 25247 | 142 | 2 |
198 | 198 | 2021-08-30 | Merced | 47 | 36740 | 508 | 388 | 2 |
219 | 219 | 2021-08-30 | Shasta | 89 | 15353 | 254 | 152 | 2 |
228 | 228 | 2021-08-30 | Tulare | 107 | 54523 | 869 | 508 | 2 |
230 | 230 | 2021-08-30 | Ventura | 111 | 90335 | 1074 | 469 | 2 |
248 | 248 | 2021-08-29 | Kings | 31 | 26195 | 264 | 164 | 2 |
384 | 384 | 2021-08-27 | San Bernardino | 71 | 327755 | 4910 | 773 | 2 |
386 | 386 | 2021-08-27 | San Francisco | 75 | 46108 | 583 | 185 | 2 |
388 | 388 | 2021-08-27 | San Luis Obispo | 79 | 25137 | 281 | 515 | 2 |
423 | 423 | 2021-08-26 | Lake | 33 | 5163 | 74 | 28 | 2 |
430 | 430 | 2021-08-26 | Merced | 47 | 36113 | 506 | 112 | 2 |
435 | 435 | 2021-08-26 | Nevada | 57 | 7011 | 85 | 78 | 2 |
455 | 455 | 2021-08-26 | Sonoma | 97 | 36158 | 349 | 342 | 2 |
460 | 460 | 2021-08-26 | Tulare | 107 | 53919 | 867 | 328 | 2 |
474 | 474 | 2021-08-25 | Fresno | 19 | 113024 | 1761 | 579 | 2 |
488 | 488 | 2021-08-25 | Merced | 47 | 36001 | 504 | 181 | 2 |
493 | 493 | 2021-08-25 | Nevada | 57 | 6933 | 83 | 148 | 2 |
512 | 512 | 2021-08-25 | Solano | 95 | 39329 | 266 | 327 | 2 |
523 | 523 | 2021-08-24 | Alameda | 1 | 105471 | 1311 | 612 | 2 |
535 | 535 | 2021-08-24 | Imperial | 25 | 29669 | 751 | 222 | 2 |
558 | 558 | 2021-08-24 | San Bernardino | 71 | 325337 | 4901 | 2290 | 2 |
572 | 572 | 2021-08-24 | Stanislaus | 99 | 64706 | 1120 | 289 | 2 |
578 | 578 | 2021-08-24 | Ventura | 111 | 89239 | 1061 | 259 | 2 |
610 | 610 | 2021-08-23 | Orange | 59 | 281092 | 5178 | 1855 | 2 |
628 | 628 | 2021-08-23 | Solano | 95 | 39002 | 264 | 238 | 2 |
675 | 675 | 2021-08-22 | San Diego | 73 | 322620 | 3848 | 1518 | 2 |
734 | 734 | 2021-08-21 | San Francisco | 75 | 45110 | 577 | 242 | 2 |
766 | 766 | 2021-08-20 | Humboldt | 23 | 6427 | 61 | 86 | 2 |
769 | 769 | 2021-08-20 | Kern | 29 | 119708 | 1445 | 431 | 2 |
776 | 776 | 2021-08-20 | Mariposa | 43 | 700 | 10 | 6 | 2 |
782 | 782 | 2021-08-20 | Napa | 55 | 11169 | 84 | 49 | 2 |
793 | 793 | 2021-08-20 | San Joaquin | 77 | 82047 | 1491 | 747 | 2 |
827 | 827 | 2021-08-19 | Kern | 29 | 119277 | 1443 | 483 | 2 |
853 | 853 | 2021-08-19 | San Mateo | 81 | 47185 | 594 | 281 | 2 |
880 | 880 | 2021-08-18 | Fresno | 19 | 110263 | 1755 | 640 | 2 |
886 | 886 | 2021-08-18 | Kings | 31 | 25056 | 258 | 53 | 2 |
912 | 912 | 2021-08-18 | Santa Barbara | 83 | 37700 | 472 | 134 | 2 |
941 | 941 | 2021-08-17 | Imperial | 25 | 29396 | 748 | 159 | 2 |
968 | 968 | 2021-08-17 | San Luis Obispo | 79 | 23737 | 273 | 378 | 2 |
977 | 977 | 2021-08-17 | Sonoma | 97 | 34992 | 340 | 153 | 2 |
984 | 984 | 2021-08-17 | Ventura | 111 | 87202 | 1050 | 225 | 2 |
1001 | 1001 | 2021-08-16 | Kern | 29 | 118025 | 1436 | 924 | 2 |
1015 | 1015 | 2021-08-16 | Nevada | 57 | 6417 | 79 | 133 | 2 |
1016 | 1016 | 2021-08-16 | Orange | 59 | 275964 | 5158 | 2117 | 2 |
1036 | 1036 | 2021-08-16 | Stanislaus | 99 | 62520 | 1108 | 740 | 2 |
1042 | 1042 | 2021-08-16 | Ventura | 111 | 86977 | 1048 | 537 | 2 |
1103 | 1103 | 2021-08-14 | Alameda | 1 | 101473 | 1301 | 313 | 2 |
1170 | 1170 | 2021-08-13 | Fresno | 19 | 108193 | 1753 | 420 | 2 |
1190 | 1190 | 2021-08-13 | Orange | 59 | 273847 | 5156 | 933 | 2 |
1200 | 1200 | 2021-08-13 | San Luis Obispo | 79 | 23359 | 271 | 400 | 2 |
1202 | 1202 | 2021-08-13 | Santa Barbara | 83 | 37133 | 470 | 147 | 2 |
1222 | 1222 | 2021-08-12 | Butte | 7 | 14006 | 202 | 101 | 2 |
1225 | 1225 | 2021-08-12 | Contra Costa | 13 | 81090 | 843 | 462 | 2 |
1248 | 1248 | 2021-08-12 | Orange | 59 | 272914 | 5154 | 465 | 2 |
1310 | 1310 | 2021-08-11 | Sacramento | 67 | 121258 | 1808 | 421 | 2 |
1312 | 1312 | 2021-08-11 | San Bernardino | 71 | 314430 | 4867 | 1281 | 2 |
1326 | 1326 | 2021-08-11 | Stanislaus | 99 | 61228 | 1102 | 167 | 2 |
1364 | 1364 | 2021-08-10 | Orange | 59 | 271837 | 5152 | 640 | 2 |
1367 | 1367 | 2021-08-10 | Riverside | 65 | 316405 | 4669 | 1543 | 2 |
1374 | 1374 | 2021-08-10 | San Luis Obispo | 79 | 22959 | 269 | 603 | 2 |
1415 | 1415 | 2021-08-09 | Mendocino | 45 | 5024 | 54 | 132 | 2 |
1422 | 1422 | 2021-08-09 | Orange | 59 | 271197 | 5150 | 2181 | 2 |
1436 | 1436 | 2021-08-09 | Santa Cruz | 87 | 17014 | 209 | 113 | 2 |
1596 | 1596 | 2021-08-06 | Orange | 59 | 269016 | 5148 | 1108 | 2 |
1600 | 1600 | 2021-08-06 | Sacramento | 67 | 118928 | 1797 | 421 | 2 |
1604 | 1604 | 2021-08-06 | San Francisco | 75 | 41890 | 567 | 215 | 2 |
1609 | 1609 | 2021-08-06 | Santa Clara | 85 | 125235 | 1711 | 281 | 2 |
1682 | 1682 | 2021-08-05 | Yuba | 115 | 7213 | 44 | 65 | 2 |
1716 | 1716 | 2021-08-04 | Sacramento | 67 | 117831 | 1790 | 288 | 2 |
1718 | 1718 | 2021-08-04 | San Bernardino | 71 | 309502 | 4858 | 622 | 2 |
1719 | 1719 | 2021-08-04 | San Diego | 73 | 301100 | 3805 | 911 | 2 |
1780 | 1780 | 2021-08-03 | San Luis Obispo | 79 | 22356 | 267 | 386 | 2 |
1828 | 1828 | 2021-08-02 | Orange | 59 | 266167 | 5143 | 1996 | 2 |
1836 | 1836 | 2021-08-02 | San Francisco | 75 | 40689 | 565 | 145 | 2 |
1848 | 1848 | 2021-08-02 | Stanislaus | 99 | 59636 | 1097 | 410 | 2 |
1952 | 1952 | 2021-07-31 | San Francisco | 75 | 40285 | 563 | 266 | 2 |
2015 | 2015 | 2021-07-30 | Santa Clara | 85 | 123404 | 1709 | 321 | 2 |
2031 | 2031 | 2021-07-29 | Alameda | 1 | 95826 | 1282 | 287 | 2 |
2057 | 2057 | 2021-07-29 | Monterey | 53 | 44484 | 528 | 46 | 2 |
2064 | 2064 | 2021-07-29 | Sacramento | 67 | 115200 | 1777 | 548 | 2 |
2095 | 2095 | 2021-07-28 | Contra Costa | 13 | 75842 | 830 | 262 | 2 |
2147 | 2147 | 2021-07-27 | Alameda | 1 | 95243 | 1274 | 447 | 2 |
2150 | 2150 | 2021-07-27 | Butte | 7 | 13127 | 200 | 45 | 2 |
2173 | 2173 | 2021-07-27 | Monterey | 53 | 44396 | 526 | 40 | 2 |
2219 | 2219 | 2021-07-26 | Kern | 29 | 112623 | 1419 | 305 | 2 |
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 );