ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Hamlin" 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 |
---|---|---|---|---|---|---|---|
2176688 | 2176688 | 2022-02-02 | Hamlin | South Dakota | 46057 | 1454 | 40 |
2173434 | 2173434 | 2022-02-01 | Hamlin | South Dakota | 46057 | 1451 | 40 |
2170182 | 2170182 | 2022-01-31 | Hamlin | South Dakota | 46057 | 1438 | 40 |
2166928 | 2166928 | 2022-01-30 | Hamlin | South Dakota | 46057 | 1431 | 40 |
2163673 | 2163673 | 2022-01-29 | Hamlin | South Dakota | 46057 | 1431 | 40 |
2160418 | 2160418 | 2022-01-28 | Hamlin | South Dakota | 46057 | 1431 | 40 |
2157162 | 2157162 | 2022-01-27 | Hamlin | South Dakota | 46057 | 1424 | 40 |
2153909 | 2153909 | 2022-01-26 | Hamlin | South Dakota | 46057 | 1416 | 40 |
2150657 | 2150657 | 2022-01-25 | Hamlin | South Dakota | 46057 | 1404 | 40 |
2147405 | 2147405 | 2022-01-24 | Hamlin | South Dakota | 46057 | 1391 | 40 |
2144151 | 2144151 | 2022-01-23 | Hamlin | South Dakota | 46057 | 1380 | 40 |
2140896 | 2140896 | 2022-01-22 | Hamlin | South Dakota | 46057 | 1380 | 40 |
2137640 | 2137640 | 2022-01-21 | Hamlin | South Dakota | 46057 | 1380 | 40 |
2134386 | 2134386 | 2022-01-20 | Hamlin | South Dakota | 46057 | 1372 | 40 |
2131134 | 2131134 | 2022-01-19 | Hamlin | South Dakota | 46057 | 1356 | 40 |
2127880 | 2127880 | 2022-01-18 | Hamlin | South Dakota | 46057 | 1311 | 40 |
2124628 | 2124628 | 2022-01-17 | Hamlin | South Dakota | 46057 | 1303 | 40 |
2121376 | 2121376 | 2022-01-16 | Hamlin | South Dakota | 46057 | 1303 | 40 |
2118124 | 2118124 | 2022-01-15 | Hamlin | South Dakota | 46057 | 1303 | 40 |
2114873 | 2114873 | 2022-01-14 | Hamlin | South Dakota | 46057 | 1303 | 40 |
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 |
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);