latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
4,358 rows where deaths = 0 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips >30
county >30
- Alpine 522
- Sierra 492
- Plumas 258
- Modoc 244
- Siskiyou 235
- Trinity 222
- Lassen 163
- Calaveras 150
- Amador 146
- Del Norte 137
- El Dorado 120
- Mendocino 119
- Tuolumne 119
- Colusa 116
- Glenn 110
- Humboldt 91
- Lake 89
- Butte 72
- Orange 58
- Stanislaus 48
- Los Angeles 45
- San Benito 45
- Solano 41
- Fresno 37
- Santa Cruz 36
- Marin 34
- Shasta 32
- San Francisco 31
- Inyo 30
- San Diego 29
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
2 | 2 | 2021-09-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
46 | 46 | 2021-09-02 | Sierra | 91 | 198 | 0 | 7 | 0 |
60 | 60 | 2021-09-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
104 | 104 | 2021-09-01 | Sierra | 91 | 191 | 0 | 3 | 0 |
118 | 118 | 2021-08-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
162 | 162 | 2021-08-31 | Sierra | 91 | 188 | 0 | 0 | 0 |
176 | 176 | 2021-08-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
220 | 220 | 2021-08-30 | Sierra | 91 | 188 | 0 | 0 | 0 |
234 | 234 | 2021-08-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
278 | 278 | 2021-08-29 | Sierra | 91 | 188 | 0 | 0 | 0 |
292 | 292 | 2021-08-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
336 | 336 | 2021-08-28 | Sierra | 91 | 188 | 0 | 0 | 0 |
350 | 350 | 2021-08-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
394 | 394 | 2021-08-27 | Sierra | 91 | 188 | 0 | 0 | 0 |
408 | 408 | 2021-08-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
452 | 452 | 2021-08-26 | Sierra | 91 | 188 | 0 | 13 | 0 |
466 | 466 | 2021-08-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
510 | 510 | 2021-08-25 | Sierra | 91 | 175 | 0 | 1 | 0 |
524 | 524 | 2021-08-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
568 | 568 | 2021-08-24 | Sierra | 91 | 174 | 0 | 0 | 0 |
582 | 582 | 2021-08-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
626 | 626 | 2021-08-23 | Sierra | 91 | 174 | 0 | 14 | 0 |
640 | 640 | 2021-08-22 | Alpine | 3 | 89 | 0 | 0 | 0 |
684 | 684 | 2021-08-22 | Sierra | 91 | 160 | 0 | 0 | 0 |
698 | 698 | 2021-08-21 | Alpine | 3 | 89 | 0 | 0 | 0 |
742 | 742 | 2021-08-21 | Sierra | 91 | 160 | 0 | 0 | 0 |
756 | 756 | 2021-08-20 | Alpine | 3 | 89 | 0 | 0 | 0 |
800 | 800 | 2021-08-20 | Sierra | 91 | 160 | 0 | 2 | 0 |
814 | 814 | 2021-08-19 | Alpine | 3 | 89 | 0 | 0 | 0 |
858 | 858 | 2021-08-19 | Sierra | 91 | 158 | 0 | 4 | 0 |
872 | 872 | 2021-08-18 | Alpine | 3 | 89 | 0 | 0 | 0 |
916 | 916 | 2021-08-18 | Sierra | 91 | 154 | 0 | 0 | 0 |
930 | 930 | 2021-08-17 | Alpine | 3 | 89 | 0 | 0 | 0 |
974 | 974 | 2021-08-17 | Sierra | 91 | 154 | 0 | 2 | 0 |
988 | 988 | 2021-08-16 | Alpine | 3 | 89 | 0 | 0 | 0 |
1032 | 1032 | 2021-08-16 | Sierra | 91 | 152 | 0 | 2 | 0 |
1046 | 1046 | 2021-08-15 | Alpine | 3 | 89 | 0 | 0 | 0 |
1090 | 1090 | 2021-08-15 | Sierra | 91 | 150 | 0 | 0 | 0 |
1104 | 1104 | 2021-08-14 | Alpine | 3 | 89 | 0 | 0 | 0 |
1148 | 1148 | 2021-08-14 | Sierra | 91 | 150 | 0 | 0 | 0 |
1162 | 1162 | 2021-08-13 | Alpine | 3 | 89 | 0 | 0 | 0 |
1206 | 1206 | 2021-08-13 | Sierra | 91 | 150 | 0 | 0 | 0 |
1220 | 1220 | 2021-08-12 | Alpine | 3 | 89 | 0 | 0 | 0 |
1264 | 1264 | 2021-08-12 | Sierra | 91 | 150 | 0 | 4 | 0 |
1278 | 1278 | 2021-08-11 | Alpine | 3 | 89 | 0 | 0 | 0 |
1322 | 1322 | 2021-08-11 | Sierra | 91 | 146 | 0 | 3 | 0 |
1336 | 1336 | 2021-08-10 | Alpine | 3 | 89 | 0 | 0 | 0 |
1380 | 1380 | 2021-08-10 | Sierra | 91 | 143 | 0 | 3 | 0 |
1394 | 1394 | 2021-08-09 | Alpine | 3 | 89 | 0 | 0 | 0 |
1438 | 1438 | 2021-08-09 | Sierra | 91 | 140 | 0 | 2 | 0 |
1452 | 1452 | 2021-08-08 | Alpine | 3 | 89 | 0 | 0 | 0 |
1496 | 1496 | 2021-08-08 | Sierra | 91 | 138 | 0 | 0 | 0 |
1510 | 1510 | 2021-08-07 | Alpine | 3 | 89 | 0 | 0 | 0 |
1554 | 1554 | 2021-08-07 | Sierra | 91 | 138 | 0 | 0 | 0 |
1568 | 1568 | 2021-08-06 | Alpine | 3 | 89 | 0 | 0 | 0 |
1612 | 1612 | 2021-08-06 | Sierra | 91 | 138 | 0 | 0 | 0 |
1626 | 1626 | 2021-08-05 | Alpine | 3 | 89 | 0 | 0 | 0 |
1670 | 1670 | 2021-08-05 | Sierra | 91 | 138 | 0 | 1 | 0 |
1684 | 1684 | 2021-08-04 | Alpine | 3 | 89 | 0 | 0 | 0 |
1728 | 1728 | 2021-08-04 | Sierra | 91 | 137 | 0 | 0 | 0 |
1742 | 1742 | 2021-08-03 | Alpine | 3 | 89 | 0 | 0 | 0 |
1786 | 1786 | 2021-08-03 | Sierra | 91 | 137 | 0 | 4 | 0 |
1800 | 1800 | 2021-08-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
1844 | 1844 | 2021-08-02 | Sierra | 91 | 133 | 0 | 2 | 0 |
1858 | 1858 | 2021-08-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
1902 | 1902 | 2021-08-01 | Sierra | 91 | 131 | 0 | 0 | 0 |
1916 | 1916 | 2021-07-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
1960 | 1960 | 2021-07-31 | Sierra | 91 | 131 | 0 | 0 | 0 |
1974 | 1974 | 2021-07-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
2018 | 2018 | 2021-07-30 | Sierra | 91 | 131 | 0 | 2 | 0 |
2032 | 2032 | 2021-07-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
2076 | 2076 | 2021-07-29 | Sierra | 91 | 129 | 0 | 3 | 0 |
2090 | 2090 | 2021-07-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
2134 | 2134 | 2021-07-28 | Sierra | 91 | 126 | 0 | 0 | 0 |
2148 | 2148 | 2021-07-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
2192 | 2192 | 2021-07-27 | Sierra | 91 | 126 | 0 | 0 | 0 |
2206 | 2206 | 2021-07-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
2250 | 2250 | 2021-07-26 | Sierra | 91 | 126 | 0 | 1 | 0 |
2264 | 2264 | 2021-07-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
2308 | 2308 | 2021-07-25 | Sierra | 91 | 125 | 0 | 0 | 0 |
2322 | 2322 | 2021-07-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
2366 | 2366 | 2021-07-24 | Sierra | 91 | 125 | 0 | 0 | 0 |
2380 | 2380 | 2021-07-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
2424 | 2424 | 2021-07-23 | Sierra | 91 | 125 | 0 | 1 | 0 |
2438 | 2438 | 2021-07-22 | Alpine | 3 | 89 | 0 | 0 | 0 |
2482 | 2482 | 2021-07-22 | Sierra | 91 | 124 | 0 | 0 | 0 |
2496 | 2496 | 2021-07-21 | Alpine | 3 | 89 | 0 | 0 | 0 |
2540 | 2540 | 2021-07-21 | Sierra | 91 | 124 | 0 | 0 | 0 |
2554 | 2554 | 2021-07-20 | Alpine | 3 | 89 | 0 | 0 | 0 |
2598 | 2598 | 2021-07-20 | Sierra | 91 | 124 | 0 | 0 | 0 |
2612 | 2612 | 2021-07-19 | Alpine | 3 | 89 | 0 | 0 | 0 |
2656 | 2656 | 2021-07-19 | Sierra | 91 | 124 | 0 | 0 | 0 |
2670 | 2670 | 2021-07-18 | Alpine | 3 | 89 | 0 | 0 | 0 |
2714 | 2714 | 2021-07-18 | Sierra | 91 | 124 | 0 | 0 | 0 |
2728 | 2728 | 2021-07-17 | Alpine | 3 | 89 | 0 | 0 | 0 |
2772 | 2772 | 2021-07-17 | Sierra | 91 | 124 | 0 | 0 | 0 |
2786 | 2786 | 2021-07-16 | Alpine | 3 | 89 | 0 | 0 | 0 |
2830 | 2830 | 2021-07-16 | Sierra | 91 | 124 | 0 | 0 | 0 |
2844 | 2844 | 2021-07-15 | Alpine | 3 | 89 | 0 | 0 | 0 |
2888 | 2888 | 2021-07-15 | Sierra | 91 | 124 | 0 | 1 | 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 );