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 |
---|---|---|---|---|---|---|---|
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 |
1786614 | 1786614 | 2021-10-05 | Hamlin | South Dakota | 46057 | 987 | 40 |
1783365 | 1783365 | 2021-10-04 | Hamlin | South Dakota | 46057 | 976 | 40 |
1780116 | 1780116 | 2021-10-03 | Hamlin | South Dakota | 46057 | 967 | 40 |
1776866 | 1776866 | 2021-10-02 | Hamlin | South Dakota | 46057 | 967 | 40 |
1773616 | 1773616 | 2021-10-01 | Hamlin | South Dakota | 46057 | 967 | 40 |
1770366 | 1770366 | 2021-09-30 | Hamlin | South Dakota | 46057 | 966 | 40 |
1767117 | 1767117 | 2021-09-29 | Hamlin | South Dakota | 46057 | 963 | 40 |
1763868 | 1763868 | 2021-09-28 | Hamlin | South Dakota | 46057 | 954 | 40 |
1760619 | 1760619 | 2021-09-27 | Hamlin | South Dakota | 46057 | 953 | 40 |
1757371 | 1757371 | 2021-09-26 | Hamlin | South Dakota | 46057 | 952 | 40 |
1754123 | 1754123 | 2021-09-25 | Hamlin | South Dakota | 46057 | 952 | 40 |
1750875 | 1750875 | 2021-09-24 | Hamlin | South Dakota | 46057 | 952 | 40 |
1747626 | 1747626 | 2021-09-23 | Hamlin | South Dakota | 46057 | 944 | 40 |
1744376 | 1744376 | 2021-09-22 | Hamlin | South Dakota | 46057 | 931 | 40 |
1741127 | 1741127 | 2021-09-21 | Hamlin | South Dakota | 46057 | 922 | 40 |
1737878 | 1737878 | 2021-09-20 | Hamlin | South Dakota | 46057 | 909 | 40 |
1734628 | 1734628 | 2021-09-19 | Hamlin | South Dakota | 46057 | 901 | 40 |
1731378 | 1731378 | 2021-09-18 | Hamlin | South Dakota | 46057 | 901 | 40 |
1728128 | 1728128 | 2021-09-17 | Hamlin | South Dakota | 46057 | 901 | 40 |
1724879 | 1724879 | 2021-09-16 | Hamlin | South Dakota | 46057 | 894 | 40 |
1721630 | 1721630 | 2021-09-15 | Hamlin | South Dakota | 46057 | 888 | 40 |
1718382 | 1718382 | 2021-09-14 | Hamlin | South Dakota | 46057 | 881 | 40 |
1715134 | 1715134 | 2021-09-13 | Hamlin | South Dakota | 46057 | 858 | 39 |
1711888 | 1711888 | 2021-09-12 | Hamlin | South Dakota | 46057 | 857 | 39 |
1708641 | 1708641 | 2021-09-11 | Hamlin | South Dakota | 46057 | 857 | 39 |
1705394 | 1705394 | 2021-09-10 | Hamlin | South Dakota | 46057 | 857 | 39 |
1702144 | 1702144 | 2021-09-09 | Hamlin | South Dakota | 46057 | 844 | 39 |
1698895 | 1698895 | 2021-09-08 | Hamlin | South Dakota | 46057 | 842 | 39 |
1695647 | 1695647 | 2021-09-07 | Hamlin | South Dakota | 46057 | 834 | 39 |
1692399 | 1692399 | 2021-09-06 | Hamlin | South Dakota | 46057 | 834 | 39 |
1689150 | 1689150 | 2021-09-05 | Hamlin | South Dakota | 46057 | 834 | 39 |
1685900 | 1685900 | 2021-09-04 | Hamlin | South Dakota | 46057 | 834 | 39 |
1682649 | 1682649 | 2021-09-03 | Hamlin | South Dakota | 46057 | 834 | 39 |
1679399 | 1679399 | 2021-09-02 | Hamlin | South Dakota | 46057 | 832 | 39 |
1676151 | 1676151 | 2021-09-01 | Hamlin | South Dakota | 46057 | 831 | 39 |
1672904 | 1672904 | 2021-08-31 | Hamlin | South Dakota | 46057 | 831 | 39 |
1669656 | 1669656 | 2021-08-30 | Hamlin | South Dakota | 46057 | 830 | 39 |
1666409 | 1666409 | 2021-08-29 | Hamlin | South Dakota | 46057 | 828 | 39 |
1663161 | 1663161 | 2021-08-28 | Hamlin | South Dakota | 46057 | 828 | 39 |
1659913 | 1659913 | 2021-08-27 | Hamlin | South Dakota | 46057 | 828 | 39 |
1656664 | 1656664 | 2021-08-26 | Hamlin | South Dakota | 46057 | 828 | 39 |
1653417 | 1653417 | 2021-08-25 | Hamlin | South Dakota | 46057 | 827 | 39 |
1650170 | 1650170 | 2021-08-24 | Hamlin | South Dakota | 46057 | 826 | 39 |
1646921 | 1646921 | 2021-08-23 | Hamlin | South Dakota | 46057 | 823 | 39 |
1643672 | 1643672 | 2021-08-22 | Hamlin | South Dakota | 46057 | 821 | 39 |
1640422 | 1640422 | 2021-08-21 | Hamlin | South Dakota | 46057 | 821 | 39 |
1637172 | 1637172 | 2021-08-20 | Hamlin | South Dakota | 46057 | 821 | 39 |
1633922 | 1633922 | 2021-08-19 | Hamlin | South Dakota | 46057 | 820 | 39 |
1630675 | 1630675 | 2021-08-18 | Hamlin | South Dakota | 46057 | 819 | 39 |
1627428 | 1627428 | 2021-08-17 | Hamlin | South Dakota | 46057 | 815 | 39 |
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);