ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
299 rows where deaths = 22 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 |
---|---|---|---|---|---|---|---|
2502082 | 2502082 | 2022-05-13 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2498824 | 2498824 | 2022-05-12 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2495566 | 2495566 | 2022-05-11 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2270979 | 2270979 | 2022-03-03 | Custer | South Dakota | 46033 | 2015 | 22 |
2267727 | 2267727 | 2022-03-02 | Custer | South Dakota | 46033 | 2013 | 22 |
2264474 | 2264474 | 2022-03-01 | Custer | South Dakota | 46033 | 2012 | 22 |
2261224 | 2261224 | 2022-02-28 | Custer | South Dakota | 46033 | 2011 | 22 |
2257973 | 2257973 | 2022-02-27 | Custer | South Dakota | 46033 | 2010 | 22 |
2254722 | 2254722 | 2022-02-26 | Custer | South Dakota | 46033 | 2010 | 22 |
2251471 | 2251471 | 2022-02-25 | Custer | South Dakota | 46033 | 2010 | 22 |
2248220 | 2248220 | 2022-02-24 | Custer | South Dakota | 46033 | 2007 | 22 |
2244969 | 2244969 | 2022-02-23 | Custer | South Dakota | 46033 | 2005 | 22 |
2241718 | 2241718 | 2022-02-22 | Custer | South Dakota | 46033 | 1994 | 22 |
2238467 | 2238467 | 2022-02-21 | Custer | South Dakota | 46033 | 1993 | 22 |
2235216 | 2235216 | 2022-02-20 | Custer | South Dakota | 46033 | 1993 | 22 |
2231965 | 2231965 | 2022-02-19 | Custer | South Dakota | 46033 | 1993 | 22 |
2228714 | 2228714 | 2022-02-18 | Custer | South Dakota | 46033 | 1993 | 22 |
2225463 | 2225463 | 2022-02-17 | Custer | South Dakota | 46033 | 1988 | 22 |
2222212 | 2222212 | 2022-02-16 | Custer | South Dakota | 46033 | 1985 | 22 |
2218961 | 2218961 | 2022-02-15 | Custer | South Dakota | 46033 | 1983 | 22 |
2215710 | 2215710 | 2022-02-14 | Custer | South Dakota | 46033 | 1975 | 22 |
2212459 | 2212459 | 2022-02-13 | Custer | South Dakota | 46033 | 1973 | 22 |
2212504 | 2212504 | 2022-02-13 | Tripp | South Dakota | 46123 | 1356 | 22 |
2209206 | 2209206 | 2022-02-12 | Custer | South Dakota | 46033 | 1973 | 22 |
2209251 | 2209251 | 2022-02-12 | Tripp | South Dakota | 46123 | 1356 | 22 |
2205953 | 2205953 | 2022-02-11 | Custer | South Dakota | 46033 | 1973 | 22 |
2205998 | 2205998 | 2022-02-11 | Tripp | South Dakota | 46123 | 1356 | 22 |
2202700 | 2202700 | 2022-02-10 | Custer | South Dakota | 46033 | 1967 | 22 |
2202745 | 2202745 | 2022-02-10 | Tripp | South Dakota | 46123 | 1353 | 22 |
2199491 | 2199491 | 2022-02-09 | Tripp | South Dakota | 46123 | 1351 | 22 |
2196237 | 2196237 | 2022-02-08 | Tripp | South Dakota | 46123 | 1342 | 22 |
2192983 | 2192983 | 2022-02-07 | Tripp | South Dakota | 46123 | 1338 | 22 |
2189729 | 2189729 | 2022-02-06 | Tripp | South Dakota | 46123 | 1335 | 22 |
2186476 | 2186476 | 2022-02-05 | Tripp | South Dakota | 46123 | 1335 | 22 |
2183224 | 2183224 | 2022-02-04 | Tripp | South Dakota | 46123 | 1335 | 22 |
2179972 | 2179972 | 2022-02-03 | Tripp | South Dakota | 46123 | 1329 | 22 |
2176721 | 2176721 | 2022-02-02 | Tripp | South Dakota | 46123 | 1326 | 22 |
2176724 | 2176724 | 2022-02-02 | Walworth | South Dakota | 46129 | 1260 | 22 |
2173467 | 2173467 | 2022-02-01 | Tripp | South Dakota | 46123 | 1320 | 22 |
2173470 | 2173470 | 2022-02-01 | Walworth | South Dakota | 46129 | 1253 | 22 |
2085620 | 2085620 | 2022-01-05 | Lake | South Dakota | 46079 | 1896 | 22 |
2082368 | 2082368 | 2022-01-04 | Lake | South Dakota | 46079 | 1885 | 22 |
2079116 | 2079116 | 2022-01-03 | Lake | South Dakota | 46079 | 1856 | 22 |
2075865 | 2075865 | 2022-01-02 | Lake | South Dakota | 46079 | 1853 | 22 |
2072614 | 2072614 | 2022-01-01 | Lake | South Dakota | 46079 | 1853 | 22 |
2069363 | 2069363 | 2021-12-31 | Lake | South Dakota | 46079 | 1853 | 22 |
2066112 | 2066112 | 2021-12-30 | Lake | South Dakota | 46079 | 1853 | 22 |
2062862 | 2062862 | 2021-12-29 | Lake | South Dakota | 46079 | 1841 | 22 |
2059612 | 2059612 | 2021-12-28 | Lake | South Dakota | 46079 | 1832 | 22 |
2056363 | 2056363 | 2021-12-27 | Lake | South Dakota | 46079 | 1820 | 22 |
2053114 | 2053114 | 2021-12-26 | Lake | South Dakota | 46079 | 1813 | 22 |
2049864 | 2049864 | 2021-12-25 | Lake | South Dakota | 46079 | 1813 | 22 |
2046614 | 2046614 | 2021-12-24 | Lake | South Dakota | 46079 | 1813 | 22 |
2043364 | 2043364 | 2021-12-23 | Lake | South Dakota | 46079 | 1813 | 22 |
2040115 | 2040115 | 2021-12-22 | Lake | South Dakota | 46079 | 1804 | 22 |
2036865 | 2036865 | 2021-12-21 | Lake | South Dakota | 46079 | 1784 | 22 |
2033615 | 2033615 | 2021-12-20 | Lake | South Dakota | 46079 | 1782 | 22 |
1962113 | 1962113 | 2021-11-28 | Moody | South Dakota | 46101 | 849 | 22 |
1958862 | 1958862 | 2021-11-27 | Moody | South Dakota | 46101 | 849 | 22 |
1955611 | 1955611 | 2021-11-26 | Moody | South Dakota | 46101 | 849 | 22 |
1952360 | 1952360 | 2021-11-25 | Moody | South Dakota | 46101 | 849 | 22 |
1949109 | 1949109 | 2021-11-24 | Moody | South Dakota | 46101 | 849 | 22 |
1945858 | 1945858 | 2021-11-23 | Moody | South Dakota | 46101 | 845 | 22 |
1851592 | 1851592 | 2021-10-25 | Fall River | South Dakota | 46047 | 965 | 22 |
1848342 | 1848342 | 2021-10-24 | Fall River | South Dakota | 46047 | 963 | 22 |
1845092 | 1845092 | 2021-10-23 | Fall River | South Dakota | 46047 | 963 | 22 |
1841842 | 1841842 | 2021-10-22 | Fall River | South Dakota | 46047 | 963 | 22 |
1838593 | 1838593 | 2021-10-21 | Fall River | South Dakota | 46047 | 960 | 22 |
1835344 | 1835344 | 2021-10-20 | Fall River | South Dakota | 46047 | 952 | 22 |
1832095 | 1832095 | 2021-10-19 | Fall River | South Dakota | 46047 | 947 | 22 |
1828846 | 1828846 | 2021-10-18 | Fall River | South Dakota | 46047 | 943 | 22 |
1825597 | 1825597 | 2021-10-17 | Fall River | South Dakota | 46047 | 940 | 22 |
1822348 | 1822348 | 2021-10-16 | Fall River | South Dakota | 46047 | 940 | 22 |
1819099 | 1819099 | 2021-10-15 | Fall River | South Dakota | 46047 | 940 | 22 |
1815850 | 1815850 | 2021-10-14 | Fall River | South Dakota | 46047 | 937 | 22 |
1812602 | 1812602 | 2021-10-13 | Fall River | South Dakota | 46047 | 934 | 22 |
1809353 | 1809353 | 2021-10-12 | Fall River | South Dakota | 46047 | 918 | 22 |
1806103 | 1806103 | 2021-10-11 | Fall River | South Dakota | 46047 | 915 | 22 |
1802853 | 1802853 | 2021-10-10 | Fall River | South Dakota | 46047 | 915 | 22 |
1799604 | 1799604 | 2021-10-09 | Fall River | South Dakota | 46047 | 915 | 22 |
1796355 | 1796355 | 2021-10-08 | Fall River | South Dakota | 46047 | 915 | 22 |
1793106 | 1793106 | 2021-10-07 | Fall River | South Dakota | 46047 | 909 | 22 |
1789857 | 1789857 | 2021-10-06 | Fall River | South Dakota | 46047 | 893 | 22 |
1786609 | 1786609 | 2021-10-05 | Fall River | South Dakota | 46047 | 889 | 22 |
1783360 | 1783360 | 2021-10-04 | Fall River | South Dakota | 46047 | 875 | 22 |
1666390 | 1666390 | 2021-08-29 | Butte | South Dakota | 46019 | 1242 | 22 |
1663142 | 1663142 | 2021-08-28 | Butte | South Dakota | 46019 | 1242 | 22 |
1659894 | 1659894 | 2021-08-27 | Butte | South Dakota | 46019 | 1242 | 22 |
1656645 | 1656645 | 2021-08-26 | Butte | South Dakota | 46019 | 1232 | 22 |
1653398 | 1653398 | 2021-08-25 | Butte | South Dakota | 46019 | 1221 | 22 |
1650151 | 1650151 | 2021-08-24 | Butte | South Dakota | 46019 | 1206 | 22 |
1646902 | 1646902 | 2021-08-23 | Butte | South Dakota | 46019 | 1185 | 22 |
1643653 | 1643653 | 2021-08-22 | Butte | South Dakota | 46019 | 1173 | 22 |
1640403 | 1640403 | 2021-08-21 | Butte | South Dakota | 46019 | 1173 | 22 |
1637153 | 1637153 | 2021-08-20 | Butte | South Dakota | 46019 | 1173 | 22 |
1633903 | 1633903 | 2021-08-19 | Butte | South Dakota | 46019 | 1159 | 22 |
1630656 | 1630656 | 2021-08-18 | Butte | South Dakota | 46019 | 1154 | 22 |
1627409 | 1627409 | 2021-08-17 | Butte | South Dakota | 46019 | 1137 | 22 |
1624162 | 1624162 | 2021-08-16 | Butte | South Dakota | 46019 | 1132 | 22 |
1620915 | 1620915 | 2021-08-15 | Butte | South Dakota | 46019 | 1130 | 22 |
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);