ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
459 rows where deaths = 43 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446696 | 2446696 | 2022-04-26 | Dewey | South Dakota | 46041 | 3136 | 43 |
2443441 | 2443441 | 2022-04-25 | Dewey | South Dakota | 46041 | 3136 | 43 |
2440185 | 2440185 | 2022-04-24 | Dewey | South Dakota | 46041 | 3136 | 43 |
2436929 | 2436929 | 2022-04-23 | Dewey | South Dakota | 46041 | 3136 | 43 |
2433673 | 2433673 | 2022-04-22 | Dewey | South Dakota | 46041 | 3136 | 43 |
2430417 | 2430417 | 2022-04-21 | Dewey | South Dakota | 46041 | 3136 | 43 |
2427161 | 2427161 | 2022-04-20 | Dewey | South Dakota | 46041 | 3136 | 43 |
2179971 | 2179971 | 2022-02-03 | Todd | South Dakota | 46121 | 2757 | 43 |
2176665 | 2176665 | 2022-02-02 | Brookings | South Dakota | 46011 | 7891 | 43 |
2176720 | 2176720 | 2022-02-02 | Todd | South Dakota | 46121 | 2742 | 43 |
2173411 | 2173411 | 2022-02-01 | Brookings | South Dakota | 46011 | 7868 | 43 |
2173466 | 2173466 | 2022-02-01 | Todd | South Dakota | 46121 | 2711 | 43 |
2170159 | 2170159 | 2022-01-31 | Brookings | South Dakota | 46011 | 7828 | 43 |
2170214 | 2170214 | 2022-01-31 | Todd | South Dakota | 46121 | 2696 | 43 |
2166905 | 2166905 | 2022-01-30 | Brookings | South Dakota | 46011 | 7805 | 43 |
2166909 | 2166909 | 2022-01-30 | Butte | South Dakota | 46019 | 2537 | 43 |
2166960 | 2166960 | 2022-01-30 | Todd | South Dakota | 46121 | 2674 | 43 |
2163650 | 2163650 | 2022-01-29 | Brookings | South Dakota | 46011 | 7805 | 43 |
2163654 | 2163654 | 2022-01-29 | Butte | South Dakota | 46019 | 2537 | 43 |
2163705 | 2163705 | 2022-01-29 | Todd | South Dakota | 46121 | 2674 | 43 |
2160395 | 2160395 | 2022-01-28 | Brookings | South Dakota | 46011 | 7805 | 43 |
2160399 | 2160399 | 2022-01-28 | Butte | South Dakota | 46019 | 2537 | 43 |
2160450 | 2160450 | 2022-01-28 | Todd | South Dakota | 46121 | 2674 | 43 |
2157143 | 2157143 | 2022-01-27 | Butte | South Dakota | 46019 | 2515 | 43 |
2157194 | 2157194 | 2022-01-27 | Todd | South Dakota | 46121 | 2652 | 43 |
2153941 | 2153941 | 2022-01-26 | Todd | South Dakota | 46121 | 2602 | 43 |
2150689 | 2150689 | 2022-01-25 | Todd | South Dakota | 46121 | 2586 | 43 |
2147437 | 2147437 | 2022-01-24 | Todd | South Dakota | 46121 | 2548 | 43 |
2144183 | 2144183 | 2022-01-23 | Todd | South Dakota | 46121 | 2513 | 43 |
2140928 | 2140928 | 2022-01-22 | Todd | South Dakota | 46121 | 2513 | 43 |
2137672 | 2137672 | 2022-01-21 | Todd | South Dakota | 46121 | 2513 | 43 |
1997883 | 1997883 | 2021-12-09 | Yankton | South Dakota | 46135 | 4120 | 43 |
1994632 | 1994632 | 2021-12-08 | Yankton | South Dakota | 46135 | 4098 | 43 |
1900364 | 1900364 | 2021-11-09 | Roberts | South Dakota | 46109 | 1590 | 43 |
1897114 | 1897114 | 2021-11-08 | Roberts | South Dakota | 46109 | 1581 | 43 |
1893864 | 1893864 | 2021-11-07 | Roberts | South Dakota | 46109 | 1578 | 43 |
1890614 | 1890614 | 2021-11-06 | Roberts | South Dakota | 46109 | 1578 | 43 |
1887364 | 1887364 | 2021-11-05 | Roberts | South Dakota | 46109 | 1578 | 43 |
1884114 | 1884114 | 2021-11-04 | Roberts | South Dakota | 46109 | 1575 | 43 |
1880865 | 1880865 | 2021-11-03 | Roberts | South Dakota | 46109 | 1571 | 43 |
1877616 | 1877616 | 2021-11-02 | Roberts | South Dakota | 46109 | 1564 | 43 |
1874367 | 1874367 | 2021-11-01 | Roberts | South Dakota | 46109 | 1562 | 43 |
1871118 | 1871118 | 2021-10-31 | Roberts | South Dakota | 46109 | 1560 | 43 |
1867869 | 1867869 | 2021-10-30 | Roberts | South Dakota | 46109 | 1560 | 43 |
1864620 | 1864620 | 2021-10-29 | Roberts | South Dakota | 46109 | 1560 | 43 |
1861371 | 1861371 | 2021-10-28 | Roberts | South Dakota | 46109 | 1553 | 43 |
1858122 | 1858122 | 2021-10-27 | Roberts | South Dakota | 46109 | 1551 | 43 |
1854873 | 1854873 | 2021-10-26 | Roberts | South Dakota | 46109 | 1545 | 43 |
1851624 | 1851624 | 2021-10-25 | Roberts | South Dakota | 46109 | 1539 | 43 |
1848321 | 1848321 | 2021-10-24 | Beadle | South Dakota | 46005 | 3267 | 43 |
1848374 | 1848374 | 2021-10-24 | Roberts | South Dakota | 46109 | 1535 | 43 |
1845071 | 1845071 | 2021-10-23 | Beadle | South Dakota | 46005 | 3267 | 43 |
1845124 | 1845124 | 2021-10-23 | Roberts | South Dakota | 46109 | 1535 | 43 |
1841821 | 1841821 | 2021-10-22 | Beadle | South Dakota | 46005 | 3267 | 43 |
1841874 | 1841874 | 2021-10-22 | Roberts | South Dakota | 46109 | 1535 | 43 |
1838572 | 1838572 | 2021-10-21 | Beadle | South Dakota | 46005 | 3262 | 43 |
1838625 | 1838625 | 2021-10-21 | Roberts | South Dakota | 46109 | 1531 | 43 |
1835323 | 1835323 | 2021-10-20 | Beadle | South Dakota | 46005 | 3258 | 43 |
1835376 | 1835376 | 2021-10-20 | Roberts | South Dakota | 46109 | 1530 | 43 |
1832074 | 1832074 | 2021-10-19 | Beadle | South Dakota | 46005 | 3252 | 43 |
1832127 | 1832127 | 2021-10-19 | Roberts | South Dakota | 46109 | 1525 | 43 |
1828825 | 1828825 | 2021-10-18 | Beadle | South Dakota | 46005 | 3233 | 43 |
1828878 | 1828878 | 2021-10-18 | Roberts | South Dakota | 46109 | 1513 | 43 |
1825576 | 1825576 | 2021-10-17 | Beadle | South Dakota | 46005 | 3216 | 43 |
1825599 | 1825599 | 2021-10-17 | Grant | South Dakota | 46051 | 1310 | 43 |
1825629 | 1825629 | 2021-10-17 | Roberts | South Dakota | 46109 | 1509 | 43 |
1822327 | 1822327 | 2021-10-16 | Beadle | South Dakota | 46005 | 3216 | 43 |
1822350 | 1822350 | 2021-10-16 | Grant | South Dakota | 46051 | 1310 | 43 |
1822380 | 1822380 | 2021-10-16 | Roberts | South Dakota | 46109 | 1509 | 43 |
1819078 | 1819078 | 2021-10-15 | Beadle | South Dakota | 46005 | 3216 | 43 |
1819101 | 1819101 | 2021-10-15 | Grant | South Dakota | 46051 | 1310 | 43 |
1819131 | 1819131 | 2021-10-15 | Roberts | South Dakota | 46109 | 1509 | 43 |
1815829 | 1815829 | 2021-10-14 | Beadle | South Dakota | 46005 | 3210 | 43 |
1815852 | 1815852 | 2021-10-14 | Grant | South Dakota | 46051 | 1304 | 43 |
1815882 | 1815882 | 2021-10-14 | Roberts | South Dakota | 46109 | 1505 | 43 |
1812581 | 1812581 | 2021-10-13 | Beadle | South Dakota | 46005 | 3203 | 43 |
1812604 | 1812604 | 2021-10-13 | Grant | South Dakota | 46051 | 1300 | 43 |
1812625 | 1812625 | 2021-10-13 | Meade | South Dakota | 46093 | 4358 | 43 |
1812634 | 1812634 | 2021-10-13 | Roberts | South Dakota | 46109 | 1503 | 43 |
1809332 | 1809332 | 2021-10-12 | Beadle | South Dakota | 46005 | 3186 | 43 |
1809355 | 1809355 | 2021-10-12 | Grant | South Dakota | 46051 | 1285 | 43 |
1809376 | 1809376 | 2021-10-12 | Meade | South Dakota | 46093 | 4316 | 43 |
1809385 | 1809385 | 2021-10-12 | Roberts | South Dakota | 46109 | 1498 | 43 |
1806082 | 1806082 | 2021-10-11 | Beadle | South Dakota | 46005 | 3181 | 43 |
1806105 | 1806105 | 2021-10-11 | Grant | South Dakota | 46051 | 1276 | 43 |
1806112 | 1806112 | 2021-10-11 | Hughes | South Dakota | 46065 | 2787 | 43 |
1806135 | 1806135 | 2021-10-11 | Roberts | South Dakota | 46109 | 1497 | 43 |
1802832 | 1802832 | 2021-10-10 | Beadle | South Dakota | 46005 | 3181 | 43 |
1802855 | 1802855 | 2021-10-10 | Grant | South Dakota | 46051 | 1276 | 43 |
1802862 | 1802862 | 2021-10-10 | Hughes | South Dakota | 46065 | 2787 | 43 |
1802885 | 1802885 | 2021-10-10 | Roberts | South Dakota | 46109 | 1497 | 43 |
1799583 | 1799583 | 2021-10-09 | Beadle | South Dakota | 46005 | 3181 | 43 |
1799606 | 1799606 | 2021-10-09 | Grant | South Dakota | 46051 | 1276 | 43 |
1799613 | 1799613 | 2021-10-09 | Hughes | South Dakota | 46065 | 2787 | 43 |
1799636 | 1799636 | 2021-10-09 | Roberts | South Dakota | 46109 | 1497 | 43 |
1796334 | 1796334 | 2021-10-08 | Beadle | South Dakota | 46005 | 3181 | 43 |
1796357 | 1796357 | 2021-10-08 | Grant | South Dakota | 46051 | 1276 | 43 |
1796364 | 1796364 | 2021-10-08 | Hughes | South Dakota | 46065 | 2787 | 43 |
1796387 | 1796387 | 2021-10-08 | Roberts | South Dakota | 46109 | 1497 | 43 |
1793085 | 1793085 | 2021-10-07 | Beadle | South Dakota | 46005 | 3180 | 43 |
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);