ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 574 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 |
---|---|---|---|---|---|---|---|
2131114 | 2131114 | 2022-01-19 | Buffalo | South Dakota | 46017 | 574 | 17 |
2127910 | 2127910 | 2022-01-18 | Stanley | South Dakota | 46117 | 574 | 5 |
2108371 | 2108371 | 2022-01-12 | Hanson | South Dakota | 46061 | 574 | 5 |
1812601 | 1812601 | 2021-10-13 | Edmunds | South Dakota | 46045 | 574 | 14 |
1215082 | 1215082 | 2021-04-12 | Fall River | South Dakota | 46047 | 574 | 15 |
1215085 | 1215085 | 2021-04-12 | Gregory | South Dakota | 46053 | 574 | 30 |
1211838 | 1211838 | 2021-04-11 | Gregory | South Dakota | 46053 | 574 | 30 |
1208589 | 1208589 | 2021-04-10 | Gregory | South Dakota | 46053 | 574 | 30 |
1205341 | 1205341 | 2021-04-09 | Gregory | South Dakota | 46053 | 574 | 30 |
945656 | 945656 | 2021-01-19 | Lyman | South Dakota | 46085 | 574 | 10 |
942409 | 942409 | 2021-01-18 | Lyman | South Dakota | 46085 | 574 | 10 |
929405 | 929405 | 2021-01-14 | Day | South Dakota | 46037 | 574 | 23 |
922934 | 922934 | 2021-01-12 | Kingsbury | South Dakota | 46077 | 574 | 13 |
845039 | 845039 | 2020-12-19 | Hamlin | South Dakota | 46057 | 574 | 32 |
789893 | 789893 | 2020-12-02 | Spink | South Dakota | 46115 | 574 | 14 |
770410 | 770410 | 2020-11-26 | McCook | South Dakota | 46087 | 574 | 11 |
767164 | 767164 | 2020-11-25 | McCook | South Dakota | 46087 | 574 | 11 |
702288 | 702288 | 2020-11-05 | Turner | South Dakota | 46125 | 574 | 22 |
359462 | 359462 | 2020-07-22 | Beadle | South Dakota | 46005 | 574 | 9 |
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);