latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
255 rows where deaths = 10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips >30
county >30
- Yuba 70
- Sutter 27
- Marin 15
- Mariposa 14
- Del Norte 13
- Mendocino 13
- Monterey 11
- San Benito 10
- Shasta 10
- Humboldt 5
- Lake 5
- Calaveras 4
- Colusa 4
- Lassen 4
- San Mateo 4
- Ventura 4
- Napa 3
- Placer 3
- Trinity 3
- Amador 2
- Glenn 2
- Kings 2
- Nevada 2
- Sacramento 2
- San Francisco 2
- Santa Clara 2
- Sonoma 2
- Yolo 2
- Alameda 1
- El Dorado 1
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
22 | 22 | 2021-09-02 | Mariposa | 43 | 833 | 10 | 8 | 0 |
53 | 53 | 2021-09-02 | Trinity | 105 | 692 | 10 | 17 | 0 |
80 | 80 | 2021-09-01 | Mariposa | 43 | 825 | 10 | 9 | 0 |
111 | 111 | 2021-09-01 | Trinity | 105 | 675 | 10 | 22 | 0 |
138 | 138 | 2021-08-31 | Mariposa | 43 | 816 | 10 | 13 | 0 |
169 | 169 | 2021-08-31 | Trinity | 105 | 653 | 10 | 12 | 2 |
196 | 196 | 2021-08-30 | Mariposa | 43 | 803 | 10 | 22 | 0 |
254 | 254 | 2021-08-29 | Mariposa | 43 | 781 | 10 | 0 | 0 |
312 | 312 | 2021-08-28 | Mariposa | 43 | 781 | 10 | 0 | 0 |
370 | 370 | 2021-08-27 | Mariposa | 43 | 781 | 10 | 12 | 0 |
428 | 428 | 2021-08-26 | Mariposa | 43 | 769 | 10 | 15 | 0 |
486 | 486 | 2021-08-25 | Mariposa | 43 | 754 | 10 | 5 | 0 |
544 | 544 | 2021-08-24 | Mariposa | 43 | 749 | 10 | 9 | 0 |
602 | 602 | 2021-08-23 | Mariposa | 43 | 740 | 10 | 40 | 0 |
660 | 660 | 2021-08-22 | Mariposa | 43 | 700 | 10 | 0 | 0 |
718 | 718 | 2021-08-21 | Mariposa | 43 | 700 | 10 | 0 | 0 |
776 | 776 | 2021-08-20 | Mariposa | 43 | 700 | 10 | 6 | 2 |
1052 | 1052 | 2021-08-15 | Del Norte | 15 | 2060 | 10 | 0 | 0 |
1110 | 1110 | 2021-08-14 | Del Norte | 15 | 2060 | 10 | 0 | 0 |
1168 | 1168 | 2021-08-13 | Del Norte | 15 | 2060 | 10 | 34 | 0 |
1226 | 1226 | 2021-08-12 | Del Norte | 15 | 2026 | 10 | 54 | 0 |
1284 | 1284 | 2021-08-11 | Del Norte | 15 | 1972 | 10 | 26 | 0 |
1342 | 1342 | 2021-08-10 | Del Norte | 15 | 1946 | 10 | 27 | 0 |
1400 | 1400 | 2021-08-09 | Del Norte | 15 | 1919 | 10 | 81 | 0 |
1458 | 1458 | 2021-08-08 | Del Norte | 15 | 1838 | 10 | 0 | 0 |
1516 | 1516 | 2021-08-07 | Del Norte | 15 | 1838 | 10 | 0 | 0 |
1574 | 1574 | 2021-08-06 | Del Norte | 15 | 1838 | 10 | 39 | 0 |
1632 | 1632 | 2021-08-05 | Del Norte | 15 | 1799 | 10 | 22 | 0 |
1690 | 1690 | 2021-08-04 | Del Norte | 15 | 1777 | 10 | 30 | 0 |
1748 | 1748 | 2021-08-03 | Del Norte | 15 | 1747 | 10 | 15 | 1 |
12360 | 12360 | 2021-02-01 | Colusa | 11 | 1952 | 10 | 17 | 0 |
12418 | 12418 | 2021-01-31 | Colusa | 11 | 1935 | 10 | 0 | 0 |
12476 | 12476 | 2021-01-30 | Colusa | 11 | 1935 | 10 | 0 | 0 |
12534 | 12534 | 2021-01-29 | Colusa | 11 | 1935 | 10 | 4 | 1 |
14054 | 14054 | 2021-01-03 | Lassen | 35 | 4691 | 10 | 0 | 0 |
14112 | 14112 | 2021-01-02 | Lassen | 35 | 4691 | 10 | 0 | 0 |
14170 | 14170 | 2021-01-01 | Lassen | 35 | 4691 | 10 | 0 | 0 |
14228 | 14228 | 2020-12-31 | Lassen | 35 | 4691 | 10 | 76 | 1 |
14373 | 14373 | 2020-12-29 | Siskiyou | 93 | 1132 | 10 | 21 | 1 |
14799 | 14799 | 2020-12-21 | El Dorado | 17 | 4877 | 10 | 465 | 2 |
15266 | 15266 | 2020-12-13 | Humboldt | 23 | 1231 | 10 | 0 | 0 |
15312 | 15312 | 2020-12-13 | Yuba | 115 | 2820 | 10 | 0 | 0 |
15324 | 15324 | 2020-12-12 | Humboldt | 23 | 1231 | 10 | 0 | 0 |
15370 | 15370 | 2020-12-12 | Yuba | 115 | 2820 | 10 | 0 | 0 |
15382 | 15382 | 2020-12-11 | Humboldt | 23 | 1231 | 10 | 36 | 0 |
15428 | 15428 | 2020-12-11 | Yuba | 115 | 2820 | 10 | 40 | 0 |
15440 | 15440 | 2020-12-10 | Humboldt | 23 | 1195 | 10 | 32 | 0 |
15486 | 15486 | 2020-12-10 | Yuba | 115 | 2780 | 10 | 80 | 0 |
15498 | 15498 | 2020-12-09 | Humboldt | 23 | 1163 | 10 | 26 | 1 |
15544 | 15544 | 2020-12-09 | Yuba | 115 | 2700 | 10 | 50 | 0 |
15602 | 15602 | 2020-12-08 | Yuba | 115 | 2650 | 10 | 78 | 0 |
15660 | 15660 | 2020-12-07 | Yuba | 115 | 2572 | 10 | 169 | 0 |
15718 | 15718 | 2020-12-06 | Yuba | 115 | 2403 | 10 | 0 | 0 |
15776 | 15776 | 2020-12-05 | Yuba | 115 | 2403 | 10 | 0 | 0 |
15834 | 15834 | 2020-12-04 | Yuba | 115 | 2403 | 10 | 46 | 0 |
15892 | 15892 | 2020-12-03 | Yuba | 115 | 2357 | 10 | 47 | 0 |
15921 | 15921 | 2020-12-02 | Nevada | 57 | 1455 | 10 | 41 | 0 |
15950 | 15950 | 2020-12-02 | Yuba | 115 | 2310 | 10 | 89 | 0 |
15961 | 15961 | 2020-12-01 | Glenn | 21 | 985 | 10 | 41 | 0 |
15979 | 15979 | 2020-12-01 | Nevada | 57 | 1414 | 10 | 66 | 1 |
16008 | 16008 | 2020-12-01 | Yuba | 115 | 2221 | 10 | 63 | 0 |
16019 | 16019 | 2020-11-30 | Glenn | 21 | 944 | 10 | 60 | 2 |
16066 | 16066 | 2020-11-30 | Yuba | 115 | 2158 | 10 | 122 | 0 |
16124 | 16124 | 2020-11-29 | Yuba | 115 | 2036 | 10 | 0 | 0 |
16182 | 16182 | 2020-11-28 | Yuba | 115 | 2036 | 10 | 55 | 0 |
16240 | 16240 | 2020-11-27 | Yuba | 115 | 1981 | 10 | 0 | 0 |
16298 | 16298 | 2020-11-26 | Yuba | 115 | 1981 | 10 | 0 | 0 |
16356 | 16356 | 2020-11-25 | Yuba | 115 | 1981 | 10 | 33 | 0 |
16414 | 16414 | 2020-11-24 | Yuba | 115 | 1948 | 10 | 82 | 0 |
16472 | 16472 | 2020-11-23 | Yuba | 115 | 1866 | 10 | 134 | 0 |
16530 | 16530 | 2020-11-22 | Yuba | 115 | 1732 | 10 | 0 | 0 |
16588 | 16588 | 2020-11-21 | Yuba | 115 | 1732 | 10 | 0 | 0 |
16646 | 16646 | 2020-11-20 | Yuba | 115 | 1732 | 10 | 26 | 0 |
16704 | 16704 | 2020-11-19 | Yuba | 115 | 1706 | 10 | 41 | 0 |
16762 | 16762 | 2020-11-18 | Yuba | 115 | 1665 | 10 | 22 | 0 |
16820 | 16820 | 2020-11-17 | Yuba | 115 | 1643 | 10 | 25 | 0 |
16878 | 16878 | 2020-11-16 | Yuba | 115 | 1618 | 10 | 69 | 0 |
16936 | 16936 | 2020-11-15 | Yuba | 115 | 1549 | 10 | 0 | 0 |
16994 | 16994 | 2020-11-14 | Yuba | 115 | 1549 | 10 | 20 | 0 |
17052 | 17052 | 2020-11-13 | Yuba | 115 | 1529 | 10 | 26 | 0 |
17110 | 17110 | 2020-11-12 | Yuba | 115 | 1503 | 10 | 9 | 0 |
17168 | 17168 | 2020-11-11 | Yuba | 115 | 1494 | 10 | 0 | 0 |
17226 | 17226 | 2020-11-10 | Yuba | 115 | 1494 | 10 | 8 | 0 |
17284 | 17284 | 2020-11-09 | Yuba | 115 | 1486 | 10 | 52 | 0 |
17342 | 17342 | 2020-11-08 | Yuba | 115 | 1434 | 10 | 0 | 0 |
17400 | 17400 | 2020-11-07 | Yuba | 115 | 1434 | 10 | 0 | 0 |
17458 | 17458 | 2020-11-06 | Yuba | 115 | 1434 | 10 | 6 | 0 |
17516 | 17516 | 2020-11-05 | Yuba | 115 | 1428 | 10 | 17 | 0 |
17574 | 17574 | 2020-11-04 | Yuba | 115 | 1411 | 10 | 13 | 0 |
17632 | 17632 | 2020-11-03 | Yuba | 115 | 1398 | 10 | 15 | 0 |
17690 | 17690 | 2020-11-02 | Yuba | 115 | 1383 | 10 | 30 | 0 |
17748 | 17748 | 2020-11-01 | Yuba | 115 | 1353 | 10 | 0 | 0 |
17806 | 17806 | 2020-10-31 | Yuba | 115 | 1353 | 10 | 0 | 0 |
17864 | 17864 | 2020-10-30 | Yuba | 115 | 1353 | 10 | 7 | 0 |
17922 | 17922 | 2020-10-29 | Yuba | 115 | 1346 | 10 | 8 | 0 |
17980 | 17980 | 2020-10-28 | Yuba | 115 | 1338 | 10 | 4 | 0 |
18038 | 18038 | 2020-10-27 | Yuba | 115 | 1334 | 10 | 11 | 0 |
18096 | 18096 | 2020-10-26 | Yuba | 115 | 1323 | 10 | 30 | 0 |
18154 | 18154 | 2020-10-25 | Yuba | 115 | 1293 | 10 | 0 | 0 |
18212 | 18212 | 2020-10-24 | Yuba | 115 | 1293 | 10 | 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 );