latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
214 rows where deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths
fips >30
county >30
- Humboldt 51
- Nevada 32
- Placer 32
- Colusa 25
- Fresno 8
- Shasta 8
- Imperial 6
- Mendocino 6
- Santa Cruz 6
- Napa 4
- Tehama 4
- Merced 3
- San Benito 3
- Yuba 3
- Inyo 2
- Lassen 2
- Sacramento 2
- San Francisco 2
- Santa Barbara 2
- Contra Costa 1
- Del Norte 1
- Kings 1
- Madera 1
- Marin 1
- Riverside 1
- San Bernardino 1
- San Diego 1
- San Luis Obispo 1
- Siskiyou 1
- Tulare 1
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1806 | 1806 | 2021-08-02 | Del Norte | 15 | 1732 | 9 | 64 | 1 |
12592 | 12592 | 2021-01-28 | Colusa | 11 | 1931 | 9 | 14 | 0 |
12650 | 12650 | 2021-01-27 | Colusa | 11 | 1917 | 9 | 10 | 0 |
12708 | 12708 | 2021-01-26 | Colusa | 11 | 1907 | 9 | 36 | 0 |
12766 | 12766 | 2021-01-25 | Colusa | 11 | 1871 | 9 | 17 | 0 |
12824 | 12824 | 2021-01-24 | Colusa | 11 | 1854 | 9 | 0 | 0 |
12882 | 12882 | 2021-01-23 | Colusa | 11 | 1854 | 9 | 0 | 0 |
12940 | 12940 | 2021-01-22 | Colusa | 11 | 1854 | 9 | 1 | 0 |
12998 | 12998 | 2021-01-21 | Colusa | 11 | 1853 | 9 | 57 | 0 |
13056 | 13056 | 2021-01-20 | Colusa | 11 | 1796 | 9 | 63 | 0 |
13114 | 13114 | 2021-01-19 | Colusa | 11 | 1733 | 9 | 42 | 0 |
13172 | 13172 | 2021-01-18 | Colusa | 11 | 1691 | 9 | 0 | 0 |
13230 | 13230 | 2021-01-17 | Colusa | 11 | 1691 | 9 | 0 | 0 |
13288 | 13288 | 2021-01-16 | Colusa | 11 | 1691 | 9 | 0 | 0 |
13346 | 13346 | 2021-01-15 | Colusa | 11 | 1691 | 9 | 7 | 0 |
13404 | 13404 | 2021-01-14 | Colusa | 11 | 1684 | 9 | 17 | 0 |
13462 | 13462 | 2021-01-13 | Colusa | 11 | 1667 | 9 | 24 | 0 |
13520 | 13520 | 2021-01-12 | Colusa | 11 | 1643 | 9 | 30 | 0 |
13578 | 13578 | 2021-01-11 | Colusa | 11 | 1613 | 9 | 48 | 0 |
13636 | 13636 | 2021-01-10 | Colusa | 11 | 1565 | 9 | 0 | 0 |
13694 | 13694 | 2021-01-09 | Colusa | 11 | 1565 | 9 | 0 | 0 |
13752 | 13752 | 2021-01-08 | Colusa | 11 | 1565 | 9 | 36 | 0 |
13810 | 13810 | 2021-01-07 | Colusa | 11 | 1529 | 9 | 61 | 0 |
13868 | 13868 | 2021-01-06 | Colusa | 11 | 1468 | 9 | 30 | 0 |
13926 | 13926 | 2021-01-05 | Colusa | 11 | 1438 | 9 | 42 | 0 |
13984 | 13984 | 2021-01-04 | Colusa | 11 | 1396 | 9 | 45 | 1 |
14286 | 14286 | 2020-12-30 | Lassen | 35 | 4615 | 9 | 0 | 0 |
14344 | 14344 | 2020-12-29 | Lassen | 35 | 4615 | 9 | 42 | 1 |
14431 | 14431 | 2020-12-28 | Siskiyou | 93 | 1111 | 9 | 35 | 1 |
15556 | 15556 | 2020-12-08 | Humboldt | 23 | 1137 | 9 | 35 | 0 |
15614 | 15614 | 2020-12-07 | Humboldt | 23 | 1102 | 9 | 88 | 0 |
15672 | 15672 | 2020-12-06 | Humboldt | 23 | 1014 | 9 | 0 | 0 |
15730 | 15730 | 2020-12-05 | Humboldt | 23 | 1014 | 9 | 0 | 0 |
15788 | 15788 | 2020-12-04 | Humboldt | 23 | 1014 | 9 | 21 | 0 |
15846 | 15846 | 2020-12-03 | Humboldt | 23 | 993 | 9 | 44 | 0 |
15904 | 15904 | 2020-12-02 | Humboldt | 23 | 949 | 9 | 30 | 0 |
15962 | 15962 | 2020-12-01 | Humboldt | 23 | 919 | 9 | 21 | 0 |
16005 | 16005 | 2020-12-01 | Tuolumne | 109 | 1104 | 9 | 49 | 1 |
16020 | 16020 | 2020-11-30 | Humboldt | 23 | 898 | 9 | 48 | 0 |
16037 | 16037 | 2020-11-30 | Nevada | 57 | 1348 | 9 | 165 | 0 |
16078 | 16078 | 2020-11-29 | Humboldt | 23 | 850 | 9 | 0 | 0 |
16095 | 16095 | 2020-11-29 | Nevada | 57 | 1183 | 9 | 0 | 0 |
16136 | 16136 | 2020-11-28 | Humboldt | 23 | 850 | 9 | 0 | 0 |
16153 | 16153 | 2020-11-28 | Nevada | 57 | 1183 | 9 | 0 | 0 |
16194 | 16194 | 2020-11-27 | Humboldt | 23 | 850 | 9 | 31 | 0 |
16211 | 16211 | 2020-11-27 | Nevada | 57 | 1183 | 9 | 0 | 0 |
16252 | 16252 | 2020-11-26 | Humboldt | 23 | 819 | 9 | 0 | 0 |
16269 | 16269 | 2020-11-26 | Nevada | 57 | 1183 | 9 | 0 | 0 |
16310 | 16310 | 2020-11-25 | Humboldt | 23 | 819 | 9 | 18 | 0 |
16327 | 16327 | 2020-11-25 | Nevada | 57 | 1183 | 9 | 20 | 0 |
16368 | 16368 | 2020-11-24 | Humboldt | 23 | 801 | 9 | 17 | 0 |
16385 | 16385 | 2020-11-24 | Nevada | 57 | 1163 | 9 | 32 | 0 |
16426 | 16426 | 2020-11-23 | Humboldt | 23 | 784 | 9 | 54 | 0 |
16443 | 16443 | 2020-11-23 | Nevada | 57 | 1131 | 9 | 116 | 0 |
16484 | 16484 | 2020-11-22 | Humboldt | 23 | 730 | 9 | 0 | 0 |
16501 | 16501 | 2020-11-22 | Nevada | 57 | 1015 | 9 | 0 | 0 |
16542 | 16542 | 2020-11-21 | Humboldt | 23 | 730 | 9 | 0 | 0 |
16559 | 16559 | 2020-11-21 | Nevada | 57 | 1015 | 9 | 0 | 0 |
16600 | 16600 | 2020-11-20 | Humboldt | 23 | 730 | 9 | 19 | 0 |
16617 | 16617 | 2020-11-20 | Nevada | 57 | 1015 | 9 | 67 | 0 |
16658 | 16658 | 2020-11-19 | Humboldt | 23 | 711 | 9 | 12 | 0 |
16675 | 16675 | 2020-11-19 | Nevada | 57 | 948 | 9 | 14 | 0 |
16716 | 16716 | 2020-11-18 | Humboldt | 23 | 699 | 9 | 4 | 0 |
16733 | 16733 | 2020-11-18 | Nevada | 57 | 934 | 9 | 5 | 0 |
16774 | 16774 | 2020-11-17 | Humboldt | 23 | 695 | 9 | 8 | 0 |
16791 | 16791 | 2020-11-17 | Nevada | 57 | 929 | 9 | 28 | 0 |
16832 | 16832 | 2020-11-16 | Humboldt | 23 | 687 | 9 | 29 | 0 |
16849 | 16849 | 2020-11-16 | Nevada | 57 | 901 | 9 | 79 | 0 |
16890 | 16890 | 2020-11-15 | Humboldt | 23 | 658 | 9 | 0 | 0 |
16907 | 16907 | 2020-11-15 | Nevada | 57 | 822 | 9 | 0 | 0 |
16948 | 16948 | 2020-11-14 | Humboldt | 23 | 658 | 9 | 0 | 0 |
16965 | 16965 | 2020-11-14 | Nevada | 57 | 822 | 9 | 0 | 0 |
17006 | 17006 | 2020-11-13 | Humboldt | 23 | 658 | 9 | 5 | 0 |
17023 | 17023 | 2020-11-13 | Nevada | 57 | 822 | 9 | 43 | 0 |
17064 | 17064 | 2020-11-12 | Humboldt | 23 | 653 | 9 | 29 | 0 |
17081 | 17081 | 2020-11-12 | Nevada | 57 | 779 | 9 | 46 | 0 |
17122 | 17122 | 2020-11-11 | Humboldt | 23 | 624 | 9 | 0 | 0 |
17139 | 17139 | 2020-11-11 | Nevada | 57 | 733 | 9 | 0 | 0 |
17180 | 17180 | 2020-11-10 | Humboldt | 23 | 624 | 9 | 3 | 0 |
17197 | 17197 | 2020-11-10 | Nevada | 57 | 733 | 9 | 7 | 0 |
17238 | 17238 | 2020-11-09 | Humboldt | 23 | 621 | 9 | 16 | 0 |
17255 | 17255 | 2020-11-09 | Nevada | 57 | 726 | 9 | 27 | 0 |
17296 | 17296 | 2020-11-08 | Humboldt | 23 | 605 | 9 | 0 | 0 |
17313 | 17313 | 2020-11-08 | Nevada | 57 | 699 | 9 | 0 | 0 |
17354 | 17354 | 2020-11-07 | Humboldt | 23 | 605 | 9 | 0 | 0 |
17371 | 17371 | 2020-11-07 | Nevada | 57 | 699 | 9 | 0 | 0 |
17412 | 17412 | 2020-11-06 | Humboldt | 23 | 605 | 9 | 6 | 0 |
17429 | 17429 | 2020-11-06 | Nevada | 57 | 699 | 9 | 11 | 0 |
17470 | 17470 | 2020-11-05 | Humboldt | 23 | 599 | 9 | 7 | 0 |
17487 | 17487 | 2020-11-05 | Nevada | 57 | 688 | 9 | 7 | 0 |
17528 | 17528 | 2020-11-04 | Humboldt | 23 | 592 | 9 | 6 | 0 |
17545 | 17545 | 2020-11-04 | Nevada | 57 | 681 | 9 | 9 | 0 |
17586 | 17586 | 2020-11-03 | Humboldt | 23 | 586 | 9 | 7 | 0 |
17603 | 17603 | 2020-11-03 | Nevada | 57 | 672 | 9 | 8 | 0 |
17644 | 17644 | 2020-11-02 | Humboldt | 23 | 579 | 9 | 8 | 0 |
17661 | 17661 | 2020-11-02 | Nevada | 57 | 664 | 9 | 22 | 0 |
17702 | 17702 | 2020-11-01 | Humboldt | 23 | 571 | 9 | 0 | 0 |
17719 | 17719 | 2020-11-01 | Nevada | 57 | 642 | 9 | 0 | 0 |
17760 | 17760 | 2020-10-31 | Humboldt | 23 | 571 | 9 | 0 | 0 |
17777 | 17777 | 2020-10-31 | Nevada | 57 | 642 | 9 | 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 );