ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
245 rows where deaths = 47 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 |
---|---|---|---|---|---|---|---|
2248264 | 2248264 | 2022-02-24 | Todd | South Dakota | 46121 | 2940 | 47 |
2245013 | 2245013 | 2022-02-23 | Todd | South Dakota | 46121 | 2939 | 47 |
2241762 | 2241762 | 2022-02-22 | Todd | South Dakota | 46121 | 2883 | 47 |
2238511 | 2238511 | 2022-02-21 | Todd | South Dakota | 46121 | 2872 | 47 |
2235260 | 2235260 | 2022-02-20 | Todd | South Dakota | 46121 | 2872 | 47 |
2232009 | 2232009 | 2022-02-19 | Todd | South Dakota | 46121 | 2872 | 47 |
2228758 | 2228758 | 2022-02-18 | Todd | South Dakota | 46121 | 2872 | 47 |
2225507 | 2225507 | 2022-02-17 | Todd | South Dakota | 46121 | 2867 | 47 |
2222256 | 2222256 | 2022-02-16 | Todd | South Dakota | 46121 | 2859 | 47 |
2219000 | 2219000 | 2022-02-15 | Roberts | South Dakota | 46109 | 2371 | 47 |
2215749 | 2215749 | 2022-02-14 | Roberts | South Dakota | 46109 | 2363 | 47 |
2212498 | 2212498 | 2022-02-13 | Roberts | South Dakota | 46109 | 2352 | 47 |
2209245 | 2209245 | 2022-02-12 | Roberts | South Dakota | 46109 | 2352 | 47 |
2205992 | 2205992 | 2022-02-11 | Roberts | South Dakota | 46109 | 2352 | 47 |
2202739 | 2202739 | 2022-02-10 | Roberts | South Dakota | 46109 | 2347 | 47 |
2199485 | 2199485 | 2022-02-09 | Roberts | South Dakota | 46109 | 2338 | 47 |
2196231 | 2196231 | 2022-02-08 | Roberts | South Dakota | 46109 | 2324 | 47 |
2192977 | 2192977 | 2022-02-07 | Roberts | South Dakota | 46109 | 2312 | 47 |
2189723 | 2189723 | 2022-02-06 | Roberts | South Dakota | 46109 | 2300 | 47 |
2186470 | 2186470 | 2022-02-05 | Roberts | South Dakota | 46109 | 2300 | 47 |
2183218 | 2183218 | 2022-02-04 | Roberts | South Dakota | 46109 | 2300 | 47 |
2179966 | 2179966 | 2022-02-03 | Roberts | South Dakota | 46109 | 2296 | 47 |
2176715 | 2176715 | 2022-02-02 | Roberts | South Dakota | 46109 | 2282 | 47 |
2170179 | 2170179 | 2022-01-31 | Grant | South Dakota | 46051 | 1965 | 47 |
2166925 | 2166925 | 2022-01-30 | Grant | South Dakota | 46051 | 1955 | 47 |
2166963 | 2166963 | 2022-01-30 | Union | South Dakota | 46127 | 3848 | 47 |
2163670 | 2163670 | 2022-01-29 | Grant | South Dakota | 46051 | 1955 | 47 |
2163708 | 2163708 | 2022-01-29 | Union | South Dakota | 46127 | 3848 | 47 |
2160415 | 2160415 | 2022-01-28 | Grant | South Dakota | 46051 | 1955 | 47 |
2160453 | 2160453 | 2022-01-28 | Union | South Dakota | 46127 | 3848 | 47 |
2157159 | 2157159 | 2022-01-27 | Grant | South Dakota | 46051 | 1947 | 47 |
2157197 | 2157197 | 2022-01-27 | Union | South Dakota | 46127 | 3830 | 47 |
2153906 | 2153906 | 2022-01-26 | Grant | South Dakota | 46051 | 1935 | 47 |
2153944 | 2153944 | 2022-01-26 | Union | South Dakota | 46127 | 3803 | 47 |
2150654 | 2150654 | 2022-01-25 | Grant | South Dakota | 46051 | 1929 | 47 |
2150692 | 2150692 | 2022-01-25 | Union | South Dakota | 46127 | 3777 | 47 |
2147402 | 2147402 | 2022-01-24 | Grant | South Dakota | 46051 | 1910 | 47 |
2147440 | 2147440 | 2022-01-24 | Union | South Dakota | 46127 | 3717 | 47 |
2144148 | 2144148 | 2022-01-23 | Grant | South Dakota | 46051 | 1899 | 47 |
2144186 | 2144186 | 2022-01-23 | Union | South Dakota | 46127 | 3672 | 47 |
2140893 | 2140893 | 2022-01-22 | Grant | South Dakota | 46051 | 1899 | 47 |
2140931 | 2140931 | 2022-01-22 | Union | South Dakota | 46127 | 3672 | 47 |
2137637 | 2137637 | 2022-01-21 | Grant | South Dakota | 46051 | 1899 | 47 |
2137675 | 2137675 | 2022-01-21 | Union | South Dakota | 46127 | 3672 | 47 |
2134383 | 2134383 | 2022-01-20 | Grant | South Dakota | 46051 | 1882 | 47 |
2134421 | 2134421 | 2022-01-20 | Union | South Dakota | 46127 | 3647 | 47 |
2134423 | 2134423 | 2022-01-20 | Yankton | South Dakota | 46135 | 5276 | 47 |
2131131 | 2131131 | 2022-01-19 | Grant | South Dakota | 46051 | 1859 | 47 |
2131169 | 2131169 | 2022-01-19 | Union | South Dakota | 46127 | 3626 | 47 |
2131171 | 2131171 | 2022-01-19 | Yankton | South Dakota | 46135 | 5206 | 47 |
2127877 | 2127877 | 2022-01-18 | Grant | South Dakota | 46051 | 1813 | 47 |
2127915 | 2127915 | 2022-01-18 | Union | South Dakota | 46127 | 3526 | 47 |
2127917 | 2127917 | 2022-01-18 | Yankton | South Dakota | 46135 | 5042 | 47 |
2124625 | 2124625 | 2022-01-17 | Grant | South Dakota | 46051 | 1797 | 47 |
2124663 | 2124663 | 2022-01-17 | Union | South Dakota | 46127 | 3474 | 47 |
2124665 | 2124665 | 2022-01-17 | Yankton | South Dakota | 46135 | 4988 | 47 |
2121373 | 2121373 | 2022-01-16 | Grant | South Dakota | 46051 | 1797 | 47 |
2121411 | 2121411 | 2022-01-16 | Union | South Dakota | 46127 | 3474 | 47 |
2121413 | 2121413 | 2022-01-16 | Yankton | South Dakota | 46135 | 4988 | 47 |
2118121 | 2118121 | 2022-01-15 | Grant | South Dakota | 46051 | 1797 | 47 |
2118159 | 2118159 | 2022-01-15 | Union | South Dakota | 46127 | 3474 | 47 |
2118161 | 2118161 | 2022-01-15 | Yankton | South Dakota | 46135 | 4988 | 47 |
2114870 | 2114870 | 2022-01-14 | Grant | South Dakota | 46051 | 1797 | 47 |
2114908 | 2114908 | 2022-01-14 | Union | South Dakota | 46127 | 3474 | 47 |
2114910 | 2114910 | 2022-01-14 | Yankton | South Dakota | 46135 | 4988 | 47 |
2111618 | 2111618 | 2022-01-13 | Grant | South Dakota | 46051 | 1769 | 47 |
2111656 | 2111656 | 2022-01-13 | Union | South Dakota | 46127 | 3410 | 47 |
2108366 | 2108366 | 2022-01-12 | Grant | South Dakota | 46051 | 1743 | 47 |
2108404 | 2108404 | 2022-01-12 | Union | South Dakota | 46127 | 3375 | 47 |
2105115 | 2105115 | 2022-01-11 | Grant | South Dakota | 46051 | 1728 | 47 |
2105153 | 2105153 | 2022-01-11 | Union | South Dakota | 46127 | 3317 | 47 |
2101864 | 2101864 | 2022-01-10 | Grant | South Dakota | 46051 | 1683 | 47 |
2101902 | 2101902 | 2022-01-10 | Union | South Dakota | 46127 | 3268 | 47 |
2098613 | 2098613 | 2022-01-09 | Grant | South Dakota | 46051 | 1666 | 47 |
2098651 | 2098651 | 2022-01-09 | Union | South Dakota | 46127 | 3221 | 47 |
2095361 | 2095361 | 2022-01-08 | Grant | South Dakota | 46051 | 1666 | 47 |
2095399 | 2095399 | 2022-01-08 | Union | South Dakota | 46127 | 3221 | 47 |
2092109 | 2092109 | 2022-01-07 | Grant | South Dakota | 46051 | 1666 | 47 |
2092147 | 2092147 | 2022-01-07 | Union | South Dakota | 46127 | 3221 | 47 |
2088857 | 2088857 | 2022-01-06 | Grant | South Dakota | 46051 | 1641 | 47 |
2088895 | 2088895 | 2022-01-06 | Union | South Dakota | 46127 | 3201 | 47 |
2085606 | 2085606 | 2022-01-05 | Grant | South Dakota | 46051 | 1613 | 47 |
2085644 | 2085644 | 2022-01-05 | Union | South Dakota | 46127 | 3163 | 47 |
2082354 | 2082354 | 2022-01-04 | Grant | South Dakota | 46051 | 1591 | 47 |
2082392 | 2082392 | 2022-01-04 | Union | South Dakota | 46127 | 3095 | 47 |
2079102 | 2079102 | 2022-01-03 | Grant | South Dakota | 46051 | 1564 | 47 |
2079140 | 2079140 | 2022-01-03 | Union | South Dakota | 46127 | 3060 | 47 |
2075851 | 2075851 | 2022-01-02 | Grant | South Dakota | 46051 | 1554 | 47 |
2075889 | 2075889 | 2022-01-02 | Union | South Dakota | 46127 | 3049 | 47 |
2072600 | 2072600 | 2022-01-01 | Grant | South Dakota | 46051 | 1554 | 47 |
2072638 | 2072638 | 2022-01-01 | Union | South Dakota | 46127 | 3049 | 47 |
2069349 | 2069349 | 2021-12-31 | Grant | South Dakota | 46051 | 1554 | 47 |
2069387 | 2069387 | 2021-12-31 | Union | South Dakota | 46127 | 3049 | 47 |
2066098 | 2066098 | 2021-12-30 | Grant | South Dakota | 46051 | 1554 | 47 |
2066136 | 2066136 | 2021-12-30 | Union | South Dakota | 46127 | 3049 | 47 |
2062848 | 2062848 | 2021-12-29 | Grant | South Dakota | 46051 | 1540 | 47 |
2062886 | 2062886 | 2021-12-29 | Union | South Dakota | 46127 | 3042 | 47 |
2059598 | 2059598 | 2021-12-28 | Grant | South Dakota | 46051 | 1537 | 47 |
2059636 | 2059636 | 2021-12-28 | Union | South Dakota | 46127 | 3037 | 47 |
2056349 | 2056349 | 2021-12-27 | Grant | South Dakota | 46051 | 1524 | 47 |
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);