ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 400 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2144168 | 2144168 | 2022-01-23 | McPherson | South Dakota | 46089 | 400 | 9 |
2140913 | 2140913 | 2022-01-22 | McPherson | South Dakota | 46089 | 400 | 9 |
2137657 | 2137657 | 2022-01-21 | McPherson | South Dakota | 46089 | 400 | 9 |
2124627 | 2124627 | 2022-01-17 | Haakon | South Dakota | 46055 | 400 | 11 |
2121375 | 2121375 | 2022-01-16 | Haakon | South Dakota | 46055 | 400 | 11 |
2118123 | 2118123 | 2022-01-15 | Haakon | South Dakota | 46055 | 400 | 11 |
2114872 | 2114872 | 2022-01-14 | Haakon | South Dakota | 46055 | 400 | 11 |
2101887 | 2101887 | 2022-01-10 | Miner | South Dakota | 46097 | 400 | 12 |
2098636 | 2098636 | 2022-01-09 | Miner | South Dakota | 46097 | 400 | 12 |
2095384 | 2095384 | 2022-01-08 | Miner | South Dakota | 46097 | 400 | 12 |
2092132 | 2092132 | 2022-01-07 | Miner | South Dakota | 46097 | 400 | 12 |
1884094 | 1884094 | 2021-11-04 | Jackson | South Dakota | 46071 | 400 | 16 |
1880845 | 1880845 | 2021-11-03 | Jackson | South Dakota | 46071 | 400 | 16 |
1783395 | 1783395 | 2021-10-04 | Stanley | South Dakota | 46117 | 400 | 3 |
1780146 | 1780146 | 2021-10-03 | Stanley | South Dakota | 46117 | 400 | 3 |
1776896 | 1776896 | 2021-10-02 | Stanley | South Dakota | 46117 | 400 | 3 |
1773646 | 1773646 | 2021-10-01 | Stanley | South Dakota | 46117 | 400 | 3 |
1757386 | 1757386 | 2021-09-26 | Marshall | South Dakota | 46091 | 400 | 6 |
1754138 | 1754138 | 2021-09-25 | Marshall | South Dakota | 46091 | 400 | 6 |
1750890 | 1750890 | 2021-09-24 | Marshall | South Dakota | 46091 | 400 | 6 |
1747641 | 1747641 | 2021-09-23 | Marshall | South Dakota | 46091 | 400 | 6 |
1744391 | 1744391 | 2021-09-22 | Marshall | South Dakota | 46091 | 400 | 6 |
1650172 | 1650172 | 2021-08-24 | Hanson | South Dakota | 46061 | 400 | 4 |
1607916 | 1607916 | 2021-08-11 | Bennett | South Dakota | 46007 | 400 | 9 |
1153363 | 1153363 | 2021-03-24 | Clark | South Dakota | 46025 | 400 | 5 |
718450 | 718450 | 2020-11-10 | Brule | South Dakota | 46015 | 400 | 3 |
663365 | 663365 | 2020-10-24 | Todd | South Dakota | 46121 | 400 | 6 |
333901 | 333901 | 2020-07-14 | Lincoln | South Dakota | 46083 | 400 | 1 |
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);