latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
811 rows where new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- San Bernardino 62
- Stanislaus 49
- San Diego 41
- Contra Costa 39
- Orange 38
- Alameda 36
- Ventura 36
- Santa Clara 35
- Fresno 33
- Tulare 30
- Imperial 28
- Sacramento 27
- San Joaquin 27
- San Francisco 26
- Kern 25
- Sonoma 24
- Merced 20
- Riverside 19
- San Mateo 17
- Shasta 17
- Solano 15
- Butte 14
- Los Angeles 14
- Kings 13
- Monterey 13
- San Luis Obispo 12
- Marin 11
- Santa Barbara 10
- Madera 9
- Santa Cruz 9
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
17 | 17 | 2021-09-02 | Lake | 33 | 5396 | 77 | 37 | 3 |
56 | 56 | 2021-09-02 | Ventura | 111 | 90731 | 1084 | 0 | 3 |
65 | 65 | 2021-09-01 | Contra Costa | 13 | 90247 | 872 | 293 | 3 |
82 | 82 | 2021-09-01 | Merced | 47 | 37087 | 512 | 170 | 3 |
96 | 96 | 2021-09-01 | San Francisco | 75 | 47255 | 587 | 382 | 3 |
106 | 106 | 2021-09-01 | Solano | 95 | 41521 | 273 | 1044 | 3 |
107 | 107 | 2021-09-01 | Sonoma | 97 | 36806 | 356 | 291 | 3 |
113 | 113 | 2021-09-01 | Tuolumne | 109 | 5732 | 92 | 34 | 3 |
131 | 131 | 2021-08-31 | Kern | 29 | 124943 | 1465 | 511 | 3 |
139 | 139 | 2021-08-31 | Mendocino | 45 | 6027 | 64 | 100 | 3 |
152 | 152 | 2021-08-31 | San Bernardino | 71 | 330909 | 4917 | 2129 | 3 |
153 | 153 | 2021-08-31 | San Diego | 73 | 334377 | 3888 | 1366 | 3 |
327 | 327 | 2021-08-28 | San Diego | 73 | 331330 | 3880 | 1168 | 3 |
342 | 342 | 2021-08-28 | Tehama | 103 | 6864 | 71 | 77 | 3 |
413 | 413 | 2021-08-26 | Contra Costa | 13 | 86188 | 863 | 489 | 3 |
422 | 422 | 2021-08-26 | Kings | 31 | 25914 | 262 | 161 | 3 |
442 | 442 | 2021-08-26 | San Bernardino | 71 | 326982 | 4908 | 589 | 3 |
467 | 467 | 2021-08-25 | Amador | 5 | 4359 | 53 | 17 | 3 |
476 | 476 | 2021-08-25 | Humboldt | 23 | 6741 | 65 | 98 | 3 |
481 | 481 | 2021-08-25 | Lake | 33 | 5135 | 72 | 36 | 3 |
513 | 513 | 2021-08-25 | Sonoma | 97 | 35816 | 347 | 152 | 3 |
520 | 520 | 2021-08-25 | Ventura | 111 | 89435 | 1064 | 196 | 3 |
526 | 526 | 2021-08-24 | Butte | 7 | 15076 | 208 | 134 | 3 |
530 | 530 | 2021-08-24 | Del Norte | 15 | 2635 | 18 | 188 | 3 |
546 | 546 | 2021-08-24 | Merced | 47 | 35820 | 502 | 172 | 3 |
553 | 553 | 2021-08-24 | Placer | 61 | 28665 | 316 | 657 | 3 |
559 | 559 | 2021-08-24 | San Diego | 73 | 325823 | 3851 | 1286 | 3 |
595 | 595 | 2021-08-23 | Kern | 29 | 120857 | 1448 | 1149 | 3 |
802 | 802 | 2021-08-20 | Solano | 95 | 38764 | 262 | 470 | 3 |
810 | 810 | 2021-08-20 | Ventura | 111 | 88279 | 1055 | 598 | 3 |
819 | 819 | 2021-08-19 | Contra Costa | 13 | 83651 | 849 | 801 | 3 |
848 | 848 | 2021-08-19 | San Bernardino | 71 | 321155 | 4878 | 2317 | 3 |
903 | 903 | 2021-08-18 | Riverside | 65 | 323578 | 4689 | 1327 | 3 |
915 | 915 | 2021-08-18 | Shasta | 89 | 14100 | 250 | 99 | 3 |
920 | 920 | 2021-08-18 | Stanislaus | 99 | 63114 | 1112 | 231 | 3 |
929 | 929 | 2021-08-17 | Alameda | 1 | 102751 | 1305 | 650 | 3 |
932 | 932 | 2021-08-17 | Butte | 7 | 14448 | 205 | 81 | 3 |
958 | 958 | 2021-08-17 | Orange | 59 | 276632 | 5161 | 668 | 3 |
973 | 973 | 2021-08-17 | Shasta | 89 | 14001 | 247 | 84 | 3 |
991 | 991 | 2021-08-16 | Calaveras | 9 | 2556 | 61 | 19 | 3 |
994 | 994 | 2021-08-16 | Del Norte | 15 | 2240 | 13 | 180 | 3 |
1020 | 1020 | 2021-08-16 | Sacramento | 67 | 123853 | 1815 | 1450 | 3 |
1041 | 1041 | 2021-08-16 | Tuolumne | 109 | 5148 | 78 | 95 | 3 |
1139 | 1139 | 2021-08-14 | San Diego | 73 | 313589 | 3824 | 1295 | 3 |
1140 | 1140 | 2021-08-14 | San Francisco | 75 | 43787 | 570 | 345 | 3 |
1167 | 1167 | 2021-08-13 | Contra Costa | 13 | 81406 | 846 | 316 | 3 |
1194 | 1194 | 2021-08-13 | Sacramento | 67 | 122403 | 1812 | 606 | 3 |
1219 | 1219 | 2021-08-12 | Alameda | 1 | 100772 | 1299 | 280 | 3 |
1255 | 1255 | 2021-08-12 | San Diego | 73 | 310596 | 3821 | 1190 | 3 |
1268 | 1268 | 2021-08-12 | Stanislaus | 99 | 61483 | 1105 | 255 | 3 |
1283 | 1283 | 2021-08-11 | Contra Costa | 13 | 80628 | 841 | 260 | 3 |
1313 | 1313 | 2021-08-11 | San Diego | 73 | 309406 | 3818 | 1118 | 3 |
1370 | 1370 | 2021-08-10 | San Bernardino | 71 | 313149 | 4865 | 1567 | 3 |
1426 | 1426 | 2021-08-09 | Sacramento | 67 | 120417 | 1800 | 1489 | 3 |
1441 | 1441 | 2021-08-09 | Sonoma | 97 | 34023 | 337 | 270 | 3 |
1590 | 1590 | 2021-08-06 | Merced | 47 | 33761 | 488 | 440 | 3 |
1654 | 1654 | 2021-08-05 | Orange | 59 | 267908 | 5146 | 777 | 3 |
1660 | 1660 | 2021-08-05 | San Bernardino | 71 | 309803 | 4861 | 301 | 3 |
1673 | 1673 | 2021-08-05 | Sonoma | 97 | 33564 | 334 | 150 | 3 |
1681 | 1681 | 2021-08-05 | Yolo | 113 | 15208 | 216 | 76 | 3 |
1832 | 1832 | 2021-08-02 | Sacramento | 67 | 117126 | 1784 | 1394 | 3 |
1854 | 1854 | 2021-08-02 | Ventura | 111 | 84320 | 1039 | 451 | 3 |
1875 | 1875 | 2021-08-01 | Los Angeles | 37 | 1303343 | 24685 | 3030 | 3 |
1979 | 1979 | 2021-07-30 | Contra Costa | 13 | 76676 | 833 | 470 | 3 |
2005 | 2005 | 2021-07-30 | Riverside | 65 | 308546 | 4662 | 624 | 3 |
2080 | 2080 | 2021-07-29 | Stanislaus | 99 | 59060 | 1091 | 162 | 3 |
2138 | 2138 | 2021-07-28 | Stanislaus | 99 | 58898 | 1088 | 88 | 3 |
2177 | 2177 | 2021-07-27 | Placer | 61 | 24955 | 307 | 472 | 3 |
2443 | 2443 | 2021-07-22 | Contra Costa | 13 | 74030 | 828 | 368 | 3 |
2571 | 2571 | 2021-07-20 | Los Angeles | 37 | 1271179 | 24588 | 1962 | 3 |
2644 | 2644 | 2021-07-19 | Sacramento | 67 | 111553 | 1762 | 650 | 3 |
2971 | 2971 | 2021-07-13 | Imperial | 25 | 28559 | 745 | 76 | 3 |
2998 | 2998 | 2021-07-13 | San Luis Obispo | 79 | 21588 | 264 | 70 | 3 |
3031 | 3031 | 2021-07-12 | Kern | 29 | 111437 | 1412 | 96 | 3 |
3052 | 3052 | 2021-07-12 | San Bernardino | 71 | 300996 | 4853 | 360 | 3 |
3200 | 3200 | 2021-07-09 | Fresno | 19 | 102805 | 1730 | 28 | 3 |
3209 | 3209 | 2021-07-09 | Los Angeles | 37 | 1255446 | 24530 | 1044 | 3 |
3293 | 3293 | 2021-07-08 | Shasta | 89 | 12605 | 238 | 0 | 3 |
3337 | 3337 | 2021-07-07 | Placer | 61 | 23943 | 303 | 97 | 3 |
3615 | 3615 | 2021-07-02 | Los Angeles | 37 | 1251259 | 24492 | 512 | 3 |
3629 | 3629 | 2021-07-02 | Riverside | 65 | 301820 | 4640 | 46 | 3 |
3748 | 3748 | 2021-06-30 | San Bernardino | 71 | 299763 | 4844 | 33 | 3 |
3774 | 3774 | 2021-06-29 | Butte | 7 | 12669 | 197 | -28 | 3 |
3847 | 3847 | 2021-06-28 | Los Angeles | 37 | 1249572 | 24480 | 268 | 3 |
3905 | 3905 | 2021-06-27 | Los Angeles | 37 | 1249304 | 24477 | 239 | 3 |
4012 | 4012 | 2021-06-25 | Fresno | 19 | 102442 | 1727 | 18 | 3 |
4212 | 4212 | 2021-06-22 | San Bernardino | 71 | 299320 | 4840 | 31 | 3 |
4253 | 4253 | 2021-06-21 | Los Angeles | 37 | 1247744 | 24444 | 126 | 3 |
4415 | 4415 | 2021-06-18 | Contra Costa | 13 | 70561 | 811 | 83 | 3 |
4505 | 4505 | 2021-06-17 | San Joaquin | 77 | 74629 | 1438 | 33 | 3 |
4534 | 4534 | 2021-06-16 | Fresno | 19 | 102235 | 1722 | 26 | 3 |
4621 | 4621 | 2021-06-15 | San Joaquin | 77 | 74559 | 1435 | 140 | 3 |
4794 | 4794 | 2021-06-12 | San Francisco | 75 | 36839 | 550 | 15 | 3 |
4844 | 4844 | 2021-06-11 | Orange | 59 | 255588 | 5095 | 18 | 3 |
4853 | 4853 | 2021-06-11 | San Joaquin | 77 | 74401 | 1432 | 51 | 3 |
5027 | 5027 | 2021-06-08 | San Joaquin | 77 | 74257 | 1426 | 96 | 3 |
5065 | 5065 | 2021-06-07 | Los Angeles | 37 | 1245267 | 24392 | 147 | 3 |
5172 | 5172 | 2021-06-05 | Fresno | 19 | 101995 | 1712 | 16 | 3 |
5250 | 5250 | 2021-06-04 | Orange | 59 | 255371 | 5073 | 24 | 3 |
5261 | 5261 | 2021-06-04 | San Mateo | 81 | 42106 | 579 | 9 | 3 |
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 );