ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 466 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2085637 | 2085637 | 2022-01-05 | Sanborn | South Dakota | 46111 | 466 | 4 |
2033584 | 2033584 | 2021-12-20 | Buffalo | South Dakota | 46017 | 466 | 16 |
2030334 | 2030334 | 2021-12-19 | Buffalo | South Dakota | 46017 | 466 | 16 |
2027083 | 2027083 | 2021-12-18 | Buffalo | South Dakota | 46017 | 466 | 16 |
2023832 | 2023832 | 2021-12-17 | Buffalo | South Dakota | 46017 | 466 | 16 |
2020581 | 2020581 | 2021-12-16 | Buffalo | South Dakota | 46017 | 466 | 16 |
1965345 | 1965345 | 2021-11-29 | Hanson | South Dakota | 46061 | 466 | 5 |
1604676 | 1604676 | 2021-08-10 | Clark | South Dakota | 46025 | 466 | 5 |
1601427 | 1601427 | 2021-08-09 | Clark | South Dakota | 46025 | 466 | 5 |
1598179 | 1598179 | 2021-08-08 | Clark | South Dakota | 46025 | 466 | 5 |
1594930 | 1594930 | 2021-08-07 | Clark | South Dakota | 46025 | 466 | 5 |
1591681 | 1591681 | 2021-08-06 | Clark | South Dakota | 46025 | 466 | 5 |
1588432 | 1588432 | 2021-08-05 | Clark | South Dakota | 46025 | 466 | 5 |
1585182 | 1585182 | 2021-08-04 | Clark | South Dakota | 46025 | 466 | 5 |
1581932 | 1581932 | 2021-08-03 | Clark | South Dakota | 46025 | 466 | 5 |
1578683 | 1578683 | 2021-08-02 | Clark | South Dakota | 46025 | 466 | 5 |
1575435 | 1575435 | 2021-08-01 | Clark | South Dakota | 46025 | 466 | 5 |
1572187 | 1572187 | 2021-07-31 | Clark | South Dakota | 46025 | 466 | 5 |
1568939 | 1568939 | 2021-07-30 | Clark | South Dakota | 46025 | 466 | 5 |
1565691 | 1565691 | 2021-07-29 | Clark | South Dakota | 46025 | 466 | 5 |
1562443 | 1562443 | 2021-07-28 | Clark | South Dakota | 46025 | 466 | 5 |
1559195 | 1559195 | 2021-07-27 | Clark | South Dakota | 46025 | 466 | 5 |
1555948 | 1555948 | 2021-07-26 | Clark | South Dakota | 46025 | 466 | 5 |
1552701 | 1552701 | 2021-07-25 | Clark | South Dakota | 46025 | 466 | 5 |
1549454 | 1549454 | 2021-07-24 | Clark | South Dakota | 46025 | 466 | 5 |
1546207 | 1546207 | 2021-07-23 | Clark | South Dakota | 46025 | 466 | 5 |
1542960 | 1542960 | 2021-07-22 | Clark | South Dakota | 46025 | 466 | 5 |
1539712 | 1539712 | 2021-07-21 | Clark | South Dakota | 46025 | 466 | 5 |
1234547 | 1234547 | 2021-04-18 | Aurora | South Dakota | 46003 | 466 | 15 |
1231299 | 1231299 | 2021-04-17 | Aurora | South Dakota | 46003 | 466 | 15 |
1228051 | 1228051 | 2021-04-16 | Aurora | South Dakota | 46003 | 466 | 15 |
1224803 | 1224803 | 2021-04-15 | Aurora | South Dakota | 46003 | 466 | 15 |
1052734 | 1052734 | 2021-02-21 | Corson | South Dakota | 46031 | 466 | 12 |
1049487 | 1049487 | 2021-02-20 | Corson | South Dakota | 46031 | 466 | 12 |
1033264 | 1033264 | 2021-02-15 | Deuel | South Dakota | 46039 | 466 | 8 |
1030018 | 1030018 | 2021-02-14 | Deuel | South Dakota | 46039 | 466 | 8 |
909939 | 909939 | 2021-01-08 | Fall River | South Dakota | 46047 | 466 | 13 |
773675 | 773675 | 2020-11-27 | Walworth | South Dakota | 46129 | 466 | 11 |
598467 | 598467 | 2020-10-04 | Lawrence | South Dakota | 46081 | 466 | 5 |
436687 | 436687 | 2020-08-15 | Brown | South Dakota | 46013 | 466 | 3 |
267502 | 267502 | 2020-06-23 | Pennington | South Dakota | 46103 | 466 | 11 |
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);