ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 169 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2030357 | 2030357 | 2021-12-19 | Harding | South Dakota | 46063 | 169 | 3 |
2027106 | 2027106 | 2021-12-18 | Harding | South Dakota | 46063 | 169 | 3 |
2023855 | 2023855 | 2021-12-17 | Harding | South Dakota | 46063 | 169 | 3 |
2020604 | 2020604 | 2021-12-16 | Harding | South Dakota | 46063 | 169 | 3 |
2014103 | 2014103 | 2021-12-14 | Harding | South Dakota | 46063 | 169 | 2 |
2010852 | 2010852 | 2021-12-13 | Harding | South Dakota | 46063 | 169 | 2 |
1919866 | 1919866 | 2021-11-15 | Sully | South Dakota | 46119 | 169 | 3 |
1897069 | 1897069 | 2021-11-08 | Campbell | South Dakota | 46021 | 169 | 4 |
1893819 | 1893819 | 2021-11-07 | Campbell | South Dakota | 46021 | 169 | 4 |
1890569 | 1890569 | 2021-11-06 | Campbell | South Dakota | 46021 | 169 | 4 |
1887319 | 1887319 | 2021-11-05 | Campbell | South Dakota | 46021 | 169 | 4 |
838565 | 838565 | 2020-12-17 | McPherson | South Dakota | 46089 | 169 | 1 |
728221 | 728221 | 2020-11-13 | Miner | South Dakota | 46097 | 169 | 3 |
715212 | 715212 | 2020-11-09 | Clark | South Dakota | 46025 | 169 | 1 |
692533 | 692533 | 2020-11-02 | Jerauld | South Dakota | 46073 | 169 | 13 |
682786 | 682786 | 2020-10-30 | Douglas | South Dakota | 46043 | 169 | 4 |
669832 | 669832 | 2020-10-26 | Kingsbury | South Dakota | 46077 | 169 | 2 |
666588 | 666588 | 2020-10-25 | Kingsbury | South Dakota | 46077 | 169 | 2 |
650350 | 650350 | 2020-10-20 | Fall River | South Dakota | 46047 | 169 | 6 |
549839 | 549839 | 2020-09-19 | Custer | South Dakota | 46033 | 169 | 2 |
549862 | 549862 | 2020-09-19 | Lake | South Dakota | 46079 | 169 | 7 |
536906 | 536906 | 2020-09-15 | Hughes | South Dakota | 46065 | 169 | 4 |
527183 | 527183 | 2020-09-12 | Davison | South Dakota | 46035 | 169 | 2 |
475473 | 475473 | 2020-08-27 | Oglala Lakota | South Dakota | 46102 | 169 | 2 |
456048 | 456048 | 2020-08-21 | Brookings | South Dakota | 46011 | 169 | 1 |
443147 | 443147 | 2020-08-17 | Codington | South Dakota | 46029 | 169 | 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);