ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 48 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- South Dakota · 122 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264518 | 2264518 | 2022-03-01 | Todd | South Dakota | 46121 | 2945 | 48 |
2261268 | 2261268 | 2022-02-28 | Todd | South Dakota | 46121 | 2939 | 48 |
2258017 | 2258017 | 2022-02-27 | Todd | South Dakota | 46121 | 2940 | 48 |
2254766 | 2254766 | 2022-02-26 | Todd | South Dakota | 46121 | 2940 | 48 |
2251515 | 2251515 | 2022-02-25 | Todd | South Dakota | 46121 | 2940 | 48 |
2241707 | 2241707 | 2022-02-22 | Brookings | South Dakota | 46011 | 8051 | 48 |
2238456 | 2238456 | 2022-02-21 | Brookings | South Dakota | 46011 | 8050 | 48 |
2235205 | 2235205 | 2022-02-20 | Brookings | South Dakota | 46011 | 8050 | 48 |
2231954 | 2231954 | 2022-02-19 | Brookings | South Dakota | 46011 | 8050 | 48 |
2228703 | 2228703 | 2022-02-18 | Brookings | South Dakota | 46011 | 8050 | 48 |
2225452 | 2225452 | 2022-02-17 | Brookings | South Dakota | 46011 | 8044 | 48 |
2222201 | 2222201 | 2022-02-16 | Brookings | South Dakota | 46011 | 8038 | 48 |
2218950 | 2218950 | 2022-02-15 | Brookings | South Dakota | 46011 | 8032 | 48 |
2215699 | 2215699 | 2022-02-14 | Brookings | South Dakota | 46011 | 8022 | 48 |
2196201 | 2196201 | 2022-02-08 | Grant | South Dakota | 46051 | 2008 | 48 |
2192947 | 2192947 | 2022-02-07 | Grant | South Dakota | 46051 | 2006 | 48 |
2189693 | 2189693 | 2022-02-06 | Grant | South Dakota | 46051 | 1997 | 48 |
2186440 | 2186440 | 2022-02-05 | Grant | South Dakota | 46051 | 1997 | 48 |
2183188 | 2183188 | 2022-02-04 | Grant | South Dakota | 46051 | 1997 | 48 |
2179936 | 2179936 | 2022-02-03 | Grant | South Dakota | 46051 | 1991 | 48 |
2176685 | 2176685 | 2022-02-02 | Grant | South Dakota | 46051 | 1983 | 48 |
2173431 | 2173431 | 2022-02-01 | Grant | South Dakota | 46051 | 1974 | 48 |
2170217 | 2170217 | 2022-01-31 | Union | South Dakota | 46127 | 3872 | 48 |
2150694 | 2150694 | 2022-01-25 | Yankton | South Dakota | 46135 | 5481 | 48 |
2147442 | 2147442 | 2022-01-24 | Yankton | South Dakota | 46135 | 5389 | 48 |
2144188 | 2144188 | 2022-01-23 | Yankton | South Dakota | 46135 | 5339 | 48 |
2140933 | 2140933 | 2022-01-22 | Yankton | South Dakota | 46135 | 5339 | 48 |
2137677 | 2137677 | 2022-01-21 | Yankton | South Dakota | 46135 | 5339 | 48 |
2033578 | 2033578 | 2021-12-20 | Beadle | South Dakota | 46005 | 3650 | 48 |
2030328 | 2030328 | 2021-12-19 | Beadle | South Dakota | 46005 | 3640 | 48 |
2027077 | 2027077 | 2021-12-18 | Beadle | South Dakota | 46005 | 3640 | 48 |
2023826 | 2023826 | 2021-12-17 | Beadle | South Dakota | 46005 | 3640 | 48 |
2020575 | 2020575 | 2021-12-16 | Beadle | South Dakota | 46005 | 3633 | 48 |
2017324 | 2017324 | 2021-12-15 | Beadle | South Dakota | 46005 | 3610 | 48 |
2014074 | 2014074 | 2021-12-14 | Beadle | South Dakota | 46005 | 3603 | 48 |
2010823 | 2010823 | 2021-12-13 | Beadle | South Dakota | 46005 | 3581 | 48 |
2007572 | 2007572 | 2021-12-12 | Beadle | South Dakota | 46005 | 3573 | 48 |
2004321 | 2004321 | 2021-12-11 | Beadle | South Dakota | 46005 | 3573 | 48 |
2001070 | 2001070 | 2021-12-10 | Beadle | South Dakota | 46005 | 3573 | 48 |
1997820 | 1997820 | 2021-12-09 | Beadle | South Dakota | 46005 | 3577 | 48 |
1939339 | 1939339 | 2021-11-21 | Hughes | South Dakota | 46065 | 3241 | 48 |
1936089 | 1936089 | 2021-11-20 | Hughes | South Dakota | 46065 | 3241 | 48 |
1932839 | 1932839 | 2021-11-19 | Hughes | South Dakota | 46065 | 3241 | 48 |
1929588 | 1929588 | 2021-11-18 | Hughes | South Dakota | 46065 | 3232 | 48 |
1926338 | 1926338 | 2021-11-17 | Hughes | South Dakota | 46065 | 3217 | 48 |
1923088 | 1923088 | 2021-11-16 | Hughes | South Dakota | 46065 | 3205 | 48 |
1919839 | 1919839 | 2021-11-15 | Hughes | South Dakota | 46065 | 3181 | 48 |
1916589 | 1916589 | 2021-11-14 | Hughes | South Dakota | 46065 | 3160 | 48 |
1913339 | 1913339 | 2021-11-13 | Hughes | South Dakota | 46065 | 3160 | 48 |
1910089 | 1910089 | 2021-11-12 | Hughes | South Dakota | 46065 | 3160 | 48 |
1906840 | 1906840 | 2021-11-11 | Hughes | South Dakota | 46065 | 3134 | 48 |
1903591 | 1903591 | 2021-11-10 | Hughes | South Dakota | 46065 | 3134 | 48 |
1880856 | 1880856 | 2021-11-03 | Meade | South Dakota | 46093 | 4630 | 48 |
1877607 | 1877607 | 2021-11-02 | Meade | South Dakota | 46093 | 4603 | 48 |
1581960 | 1581960 | 2021-08-03 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1578711 | 1578711 | 2021-08-02 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1575463 | 1575463 | 2021-08-01 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1572215 | 1572215 | 2021-07-31 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1568967 | 1568967 | 2021-07-30 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1565719 | 1565719 | 2021-07-29 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1562471 | 1562471 | 2021-07-28 | Lawrence | South Dakota | 46081 | 3046 | 48 |
1559223 | 1559223 | 2021-07-27 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1555976 | 1555976 | 2021-07-26 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1552729 | 1552729 | 2021-07-25 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1549482 | 1549482 | 2021-07-24 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1546235 | 1546235 | 2021-07-23 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1542988 | 1542988 | 2021-07-22 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1539740 | 1539740 | 2021-07-21 | Lawrence | South Dakota | 46081 | 3035 | 48 |
1536493 | 1536493 | 2021-07-20 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1533245 | 1533245 | 2021-07-19 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1529998 | 1529998 | 2021-07-18 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1526751 | 1526751 | 2021-07-17 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1523504 | 1523504 | 2021-07-16 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1520256 | 1520256 | 2021-07-15 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1517008 | 1517008 | 2021-07-14 | Lawrence | South Dakota | 46081 | 3026 | 48 |
1513761 | 1513761 | 2021-07-13 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1510515 | 1510515 | 2021-07-12 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1507268 | 1507268 | 2021-07-11 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1504022 | 1504022 | 2021-07-10 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1500776 | 1500776 | 2021-07-09 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1497530 | 1497530 | 2021-07-08 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1494283 | 1494283 | 2021-07-07 | Lawrence | South Dakota | 46081 | 3020 | 48 |
1491036 | 1491036 | 2021-07-06 | Lawrence | South Dakota | 46081 | 3018 | 48 |
1487789 | 1487789 | 2021-07-05 | Lawrence | South Dakota | 46081 | 3018 | 48 |
1484542 | 1484542 | 2021-07-04 | Lawrence | South Dakota | 46081 | 3018 | 48 |
1481296 | 1481296 | 2021-07-03 | Lawrence | South Dakota | 46081 | 3018 | 48 |
1478049 | 1478049 | 2021-07-02 | Lawrence | South Dakota | 46081 | 3018 | 48 |
1474803 | 1474803 | 2021-07-01 | Lawrence | South Dakota | 46081 | 3017 | 48 |
1471557 | 1471557 | 2021-06-30 | Lawrence | South Dakota | 46081 | 3014 | 48 |
1468312 | 1468312 | 2021-06-29 | Lawrence | South Dakota | 46081 | 3011 | 48 |
1465067 | 1465067 | 2021-06-28 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1461822 | 1461822 | 2021-06-27 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1458577 | 1458577 | 2021-06-26 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1455332 | 1455332 | 2021-06-25 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1452087 | 1452087 | 2021-06-24 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1448841 | 1448841 | 2021-06-23 | Lawrence | South Dakota | 46081 | 3010 | 48 |
1445596 | 1445596 | 2021-06-22 | Lawrence | South Dakota | 46081 | 3009 | 48 |
1442351 | 1442351 | 2021-06-21 | Lawrence | South Dakota | 46081 | 3007 | 48 |
1439106 | 1439106 | 2021-06-20 | Lawrence | South Dakota | 46081 | 3007 | 48 |
1435859 | 1435859 | 2021-06-19 | Lawrence | South Dakota | 46081 | 3007 | 48 |
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);