ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 140 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Humboldt 22
- Tehama 9
- Solano 7
- Santa Clara 6
- Alameda 5
- San Francisco 5
- Santa Barbara 5
- Merced 3
- El Dorado 2
- Napa 2
- Imperial 1
- Kern 1
- Marin 1
- San Diego 1
- San Luis Obispo 1
- Tuolumne 1
state 1
- California · 72 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2379292 | 2379292 | 2022-04-06 | Humboldt | California | 6023 | 20002 | 140 |
2376038 | 2376038 | 2022-04-05 | Humboldt | California | 6023 | 20002 | 140 |
2372786 | 2372786 | 2022-04-04 | Humboldt | California | 6023 | 20002 | 140 |
2369533 | 2369533 | 2022-04-03 | Humboldt | California | 6023 | 20002 | 140 |
2366280 | 2366280 | 2022-04-02 | Humboldt | California | 6023 | 20002 | 140 |
2363027 | 2363027 | 2022-04-01 | Humboldt | California | 6023 | 20002 | 140 |
2359773 | 2359773 | 2022-03-31 | Humboldt | California | 6023 | 20002 | 140 |
2356519 | 2356519 | 2022-03-30 | Humboldt | California | 6023 | 20002 | 140 |
2353266 | 2353266 | 2022-03-29 | Humboldt | California | 6023 | 20002 | 140 |
2353282 | 2353282 | 2022-03-29 | Napa | California | 6055 | 26687 | 140 |
2350014 | 2350014 | 2022-03-28 | Humboldt | California | 6023 | 20002 | 140 |
2350030 | 2350030 | 2022-03-28 | Napa | California | 6055 | 26687 | 140 |
2307722 | 2307722 | 2022-03-15 | Humboldt | California | 6023 | 19849 | 140 |
2304471 | 2304471 | 2022-03-14 | Humboldt | California | 6023 | 19849 | 140 |
2301219 | 2301219 | 2022-03-13 | Humboldt | California | 6023 | 19849 | 140 |
2297967 | 2297967 | 2022-03-12 | Humboldt | California | 6023 | 19849 | 140 |
2294715 | 2294715 | 2022-03-11 | Humboldt | California | 6023 | 19849 | 140 |
2291463 | 2291463 | 2022-03-10 | Humboldt | California | 6023 | 19813 | 140 |
2288211 | 2288211 | 2022-03-09 | Humboldt | California | 6023 | 19813 | 140 |
2284960 | 2284960 | 2022-03-08 | Humboldt | California | 6023 | 19763 | 140 |
2281708 | 2281708 | 2022-03-07 | Humboldt | California | 6023 | 19763 | 140 |
2278455 | 2278455 | 2022-03-06 | Humboldt | California | 6023 | 19698 | 140 |
2275202 | 2275202 | 2022-03-05 | Humboldt | California | 6023 | 19698 | 140 |
2271949 | 2271949 | 2022-03-04 | Humboldt | California | 6023 | 19698 | 140 |
2106116 | 2106116 | 2022-01-12 | Tehama | California | 6103 | 11071 | 140 |
2102865 | 2102865 | 2022-01-11 | Tehama | California | 6103 | 11025 | 140 |
2099614 | 2099614 | 2022-01-10 | Tehama | California | 6103 | 10971 | 140 |
2096363 | 2096363 | 2022-01-09 | Tehama | California | 6103 | 10774 | 140 |
2093111 | 2093111 | 2022-01-08 | Tehama | California | 6103 | 10774 | 140 |
2089859 | 2089859 | 2022-01-07 | Tehama | California | 6103 | 10774 | 140 |
2086608 | 2086608 | 2022-01-06 | Tehama | California | 6103 | 10676 | 140 |
2083356 | 2083356 | 2022-01-05 | Tehama | California | 6103 | 10626 | 140 |
2080104 | 2080104 | 2022-01-04 | Tehama | California | 6103 | 10611 | 140 |
1940336 | 1940336 | 2021-11-22 | Tuolumne | California | 6109 | 7780 | 140 |
1790817 | 1790817 | 2021-10-07 | El Dorado | California | 6017 | 16693 | 140 |
1787568 | 1787568 | 2021-10-06 | El Dorado | California | 6017 | 16635 | 140 |
1031019 | 1031019 | 2021-02-15 | Solano | California | 6095 | 29256 | 140 |
1027772 | 1027772 | 2021-02-14 | Solano | California | 6095 | 29256 | 140 |
1024527 | 1024527 | 2021-02-13 | Solano | California | 6095 | 29256 | 140 |
1021282 | 1021282 | 2021-02-12 | Solano | California | 6095 | 29256 | 140 |
1018037 | 1018037 | 2021-02-11 | Solano | California | 6095 | 29256 | 140 |
1014792 | 1014792 | 2021-02-10 | Solano | California | 6095 | 29177 | 140 |
1011547 | 1011547 | 2021-02-09 | Solano | California | 6095 | 29045 | 140 |
946626 | 946626 | 2021-01-20 | San Luis Obispo | California | 6079 | 16056 | 140 |
897928 | 897928 | 2021-01-05 | Marin | California | 6041 | 10286 | 140 |
826550 | 826550 | 2020-12-14 | Santa Barbara | California | 6083 | 13557 | 140 |
823303 | 823303 | 2020-12-13 | Santa Barbara | California | 6083 | 13198 | 140 |
820057 | 820057 | 2020-12-12 | Santa Barbara | California | 6083 | 13056 | 140 |
816811 | 816811 | 2020-12-11 | Santa Barbara | California | 6083 | 12866 | 140 |
813565 | 813565 | 2020-12-10 | Santa Barbara | California | 6083 | 12808 | 140 |
670803 | 670803 | 2020-10-27 | San Francisco | California | 6075 | 12192 | 140 |
667560 | 667560 | 2020-10-26 | San Francisco | California | 6075 | 12155 | 140 |
664315 | 664315 | 2020-10-25 | San Francisco | California | 6075 | 12106 | 140 |
661071 | 661071 | 2020-10-24 | San Francisco | California | 6075 | 12072 | 140 |
657827 | 657827 | 2020-10-23 | San Francisco | California | 6075 | 12035 | 140 |
563769 | 563769 | 2020-09-24 | Merced | California | 6047 | 8846 | 140 |
560530 | 560530 | 2020-09-23 | Merced | California | 6047 | 8828 | 140 |
557294 | 557294 | 2020-09-22 | Merced | California | 6047 | 8803 | 140 |
386139 | 386139 | 2020-07-31 | Kern | California | 6029 | 19552 | 140 |
331642 | 331642 | 2020-07-14 | Imperial | California | 6025 | 8119 | 140 |
309380 | 309380 | 2020-07-07 | Alameda | California | 6001 | 6991 | 140 |
306212 | 306212 | 2020-07-06 | Alameda | California | 6001 | 6908 | 140 |
303048 | 303048 | 2020-07-05 | Alameda | California | 6001 | 6876 | 140 |
299884 | 299884 | 2020-07-04 | Alameda | California | 6001 | 6577 | 140 |
296722 | 296722 | 2020-07-03 | Alameda | California | 6001 | 6493 | 140 |
175669 | 175669 | 2020-05-25 | Santa Clara | California | 6085 | 2652 | 140 |
172625 | 172625 | 2020-05-24 | Santa Clara | California | 6085 | 2617 | 140 |
169584 | 169584 | 2020-05-23 | Santa Clara | California | 6085 | 2571 | 140 |
166547 | 166547 | 2020-05-22 | Santa Clara | California | 6085 | 2546 | 140 |
163515 | 163515 | 2020-05-21 | Santa Clara | California | 6085 | 2508 | 140 |
160487 | 160487 | 2020-05-20 | Santa Clara | California | 6085 | 2492 | 140 |
101220 | 101220 | 2020-04-30 | San Diego | California | 6073 | 3627 | 140 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);