ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46057 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 |
---|---|---|---|---|---|---|---|
2111621 | 2111621 | 2022-01-13 | Hamlin | South Dakota | 46057 | 1290 | 40 |
2108369 | 2108369 | 2022-01-12 | Hamlin | South Dakota | 46057 | 1284 | 40 |
2105118 | 2105118 | 2022-01-11 | Hamlin | South Dakota | 46057 | 1267 | 40 |
2101867 | 2101867 | 2022-01-10 | Hamlin | South Dakota | 46057 | 1258 | 40 |
2098616 | 2098616 | 2022-01-09 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2095364 | 2095364 | 2022-01-08 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2092112 | 2092112 | 2022-01-07 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2088860 | 2088860 | 2022-01-06 | Hamlin | South Dakota | 46057 | 1246 | 40 |
2085609 | 2085609 | 2022-01-05 | Hamlin | South Dakota | 46057 | 1240 | 40 |
2082357 | 2082357 | 2022-01-04 | Hamlin | South Dakota | 46057 | 1229 | 40 |
2079105 | 2079105 | 2022-01-03 | Hamlin | South Dakota | 46057 | 1214 | 40 |
2075854 | 2075854 | 2022-01-02 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2072603 | 2072603 | 2022-01-01 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2069352 | 2069352 | 2021-12-31 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2066101 | 2066101 | 2021-12-30 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2062851 | 2062851 | 2021-12-29 | Hamlin | South Dakota | 46057 | 1210 | 40 |
2059601 | 2059601 | 2021-12-28 | Hamlin | South Dakota | 46057 | 1204 | 40 |
2056352 | 2056352 | 2021-12-27 | Hamlin | South Dakota | 46057 | 1195 | 40 |
2053103 | 2053103 | 2021-12-26 | Hamlin | South Dakota | 46057 | 1193 | 40 |
2049853 | 2049853 | 2021-12-25 | Hamlin | South Dakota | 46057 | 1193 | 40 |
2046603 | 2046603 | 2021-12-24 | Hamlin | South Dakota | 46057 | 1193 | 40 |
2043353 | 2043353 | 2021-12-23 | Hamlin | South Dakota | 46057 | 1193 | 40 |
2040104 | 2040104 | 2021-12-22 | Hamlin | South Dakota | 46057 | 1189 | 40 |
2036854 | 2036854 | 2021-12-21 | Hamlin | South Dakota | 46057 | 1187 | 40 |
2033604 | 2033604 | 2021-12-20 | Hamlin | South Dakota | 46057 | 1169 | 40 |
2030354 | 2030354 | 2021-12-19 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2027103 | 2027103 | 2021-12-18 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2023852 | 2023852 | 2021-12-17 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2020601 | 2020601 | 2021-12-16 | Hamlin | South Dakota | 46057 | 1154 | 40 |
2017350 | 2017350 | 2021-12-15 | Hamlin | South Dakota | 46057 | 1151 | 40 |
2014100 | 2014100 | 2021-12-14 | Hamlin | South Dakota | 46057 | 1140 | 40 |
2010849 | 2010849 | 2021-12-13 | Hamlin | South Dakota | 46057 | 1129 | 40 |
2007598 | 2007598 | 2021-12-12 | Hamlin | South Dakota | 46057 | 1129 | 40 |
2004347 | 2004347 | 2021-12-11 | Hamlin | South Dakota | 46057 | 1129 | 40 |
2001096 | 2001096 | 2021-12-10 | Hamlin | South Dakota | 46057 | 1129 | 40 |
1997846 | 1997846 | 2021-12-09 | Hamlin | South Dakota | 46057 | 1124 | 40 |
1994595 | 1994595 | 2021-12-08 | Hamlin | South Dakota | 46057 | 1120 | 40 |
1991344 | 1991344 | 2021-12-07 | Hamlin | South Dakota | 46057 | 1113 | 40 |
1988093 | 1988093 | 2021-12-06 | Hamlin | South Dakota | 46057 | 1104 | 40 |
1984843 | 1984843 | 2021-12-05 | Hamlin | South Dakota | 46057 | 1101 | 40 |
1981593 | 1981593 | 2021-12-04 | Hamlin | South Dakota | 46057 | 1101 | 40 |
1978343 | 1978343 | 2021-12-03 | Hamlin | South Dakota | 46057 | 1101 | 40 |
1975093 | 1975093 | 2021-12-02 | Hamlin | South Dakota | 46057 | 1098 | 40 |
1971844 | 1971844 | 2021-12-01 | Hamlin | South Dakota | 46057 | 1096 | 40 |
1968594 | 1968594 | 2021-11-30 | Hamlin | South Dakota | 46057 | 1080 | 40 |
1965343 | 1965343 | 2021-11-29 | Hamlin | South Dakota | 46057 | 1066 | 40 |
1962091 | 1962091 | 2021-11-28 | Hamlin | South Dakota | 46057 | 1065 | 40 |
1958840 | 1958840 | 2021-11-27 | Hamlin | South Dakota | 46057 | 1065 | 40 |
1955589 | 1955589 | 2021-11-26 | Hamlin | South Dakota | 46057 | 1065 | 40 |
1952338 | 1952338 | 2021-11-25 | Hamlin | South Dakota | 46057 | 1065 | 40 |
1949087 | 1949087 | 2021-11-24 | Hamlin | South Dakota | 46057 | 1065 | 40 |
1945836 | 1945836 | 2021-11-23 | Hamlin | South Dakota | 46057 | 1062 | 40 |
1942585 | 1942585 | 2021-11-22 | Hamlin | South Dakota | 46057 | 1057 | 40 |
1939335 | 1939335 | 2021-11-21 | Hamlin | South Dakota | 46057 | 1055 | 40 |
1936085 | 1936085 | 2021-11-20 | Hamlin | South Dakota | 46057 | 1055 | 40 |
1932835 | 1932835 | 2021-11-19 | Hamlin | South Dakota | 46057 | 1055 | 40 |
1929584 | 1929584 | 2021-11-18 | Hamlin | South Dakota | 46057 | 1053 | 40 |
1926334 | 1926334 | 2021-11-17 | Hamlin | South Dakota | 46057 | 1051 | 40 |
1923084 | 1923084 | 2021-11-16 | Hamlin | South Dakota | 46057 | 1048 | 40 |
1919835 | 1919835 | 2021-11-15 | Hamlin | South Dakota | 46057 | 1047 | 40 |
1916585 | 1916585 | 2021-11-14 | Hamlin | South Dakota | 46057 | 1047 | 40 |
1913335 | 1913335 | 2021-11-13 | Hamlin | South Dakota | 46057 | 1047 | 40 |
1910085 | 1910085 | 2021-11-12 | Hamlin | South Dakota | 46057 | 1047 | 40 |
1906836 | 1906836 | 2021-11-11 | Hamlin | South Dakota | 46057 | 1044 | 40 |
1903587 | 1903587 | 2021-11-10 | Hamlin | South Dakota | 46057 | 1044 | 40 |
1900337 | 1900337 | 2021-11-09 | Hamlin | South Dakota | 46057 | 1042 | 40 |
1897087 | 1897087 | 2021-11-08 | Hamlin | South Dakota | 46057 | 1040 | 40 |
1893837 | 1893837 | 2021-11-07 | Hamlin | South Dakota | 46057 | 1038 | 40 |
1890587 | 1890587 | 2021-11-06 | Hamlin | South Dakota | 46057 | 1038 | 40 |
1887337 | 1887337 | 2021-11-05 | Hamlin | South Dakota | 46057 | 1038 | 40 |
1884087 | 1884087 | 2021-11-04 | Hamlin | South Dakota | 46057 | 1037 | 40 |
1880838 | 1880838 | 2021-11-03 | Hamlin | South Dakota | 46057 | 1037 | 40 |
1877589 | 1877589 | 2021-11-02 | Hamlin | South Dakota | 46057 | 1037 | 40 |
1874340 | 1874340 | 2021-11-01 | Hamlin | South Dakota | 46057 | 1030 | 40 |
1871091 | 1871091 | 2021-10-31 | Hamlin | South Dakota | 46057 | 1030 | 40 |
1867842 | 1867842 | 2021-10-30 | Hamlin | South Dakota | 46057 | 1030 | 40 |
1864593 | 1864593 | 2021-10-29 | Hamlin | South Dakota | 46057 | 1030 | 40 |
1861344 | 1861344 | 2021-10-28 | Hamlin | South Dakota | 46057 | 1030 | 40 |
1858095 | 1858095 | 2021-10-27 | Hamlin | South Dakota | 46057 | 1029 | 40 |
1854846 | 1854846 | 2021-10-26 | Hamlin | South Dakota | 46057 | 1027 | 40 |
1851597 | 1851597 | 2021-10-25 | Hamlin | South Dakota | 46057 | 1021 | 40 |
1848347 | 1848347 | 2021-10-24 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1845097 | 1845097 | 2021-10-23 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1841847 | 1841847 | 2021-10-22 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1838598 | 1838598 | 2021-10-21 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1835349 | 1835349 | 2021-10-20 | Hamlin | South Dakota | 46057 | 1014 | 40 |
1832100 | 1832100 | 2021-10-19 | Hamlin | South Dakota | 46057 | 1011 | 40 |
1828851 | 1828851 | 2021-10-18 | Hamlin | South Dakota | 46057 | 1004 | 40 |
1825602 | 1825602 | 2021-10-17 | Hamlin | South Dakota | 46057 | 1004 | 40 |
1822353 | 1822353 | 2021-10-16 | Hamlin | South Dakota | 46057 | 1004 | 40 |
1819104 | 1819104 | 2021-10-15 | Hamlin | South Dakota | 46057 | 1004 | 40 |
1815855 | 1815855 | 2021-10-14 | Hamlin | South Dakota | 46057 | 1003 | 40 |
1812607 | 1812607 | 2021-10-13 | Hamlin | South Dakota | 46057 | 1004 | 40 |
1809358 | 1809358 | 2021-10-12 | Hamlin | South Dakota | 46057 | 999 | 40 |
1806108 | 1806108 | 2021-10-11 | Hamlin | South Dakota | 46057 | 997 | 40 |
1802858 | 1802858 | 2021-10-10 | Hamlin | South Dakota | 46057 | 997 | 40 |
1799609 | 1799609 | 2021-10-09 | Hamlin | South Dakota | 46057 | 997 | 40 |
1796360 | 1796360 | 2021-10-08 | Hamlin | South Dakota | 46057 | 997 | 40 |
1793111 | 1793111 | 2021-10-07 | Hamlin | South Dakota | 46057 | 995 | 40 |
1789862 | 1789862 | 2021-10-06 | Hamlin | South Dakota | 46057 | 992 | 40 |
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);