ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Spink" 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 |
---|---|---|---|---|---|---|---|
1949116 | 1949116 | 2021-11-24 | Spink | South Dakota | 46115 | 1068 | 28 |
1945865 | 1945865 | 2021-11-23 | Spink | South Dakota | 46115 | 1066 | 28 |
1942614 | 1942614 | 2021-11-22 | Spink | South Dakota | 46115 | 1065 | 27 |
1939364 | 1939364 | 2021-11-21 | Spink | South Dakota | 46115 | 1064 | 27 |
1936114 | 1936114 | 2021-11-20 | Spink | South Dakota | 46115 | 1064 | 27 |
1932864 | 1932864 | 2021-11-19 | Spink | South Dakota | 46115 | 1064 | 27 |
1929613 | 1929613 | 2021-11-18 | Spink | South Dakota | 46115 | 1062 | 27 |
1926363 | 1926363 | 2021-11-17 | Spink | South Dakota | 46115 | 1062 | 27 |
1923113 | 1923113 | 2021-11-16 | Spink | South Dakota | 46115 | 1062 | 27 |
1919864 | 1919864 | 2021-11-15 | Spink | South Dakota | 46115 | 1060 | 27 |
1916614 | 1916614 | 2021-11-14 | Spink | South Dakota | 46115 | 1058 | 27 |
1913364 | 1913364 | 2021-11-13 | Spink | South Dakota | 46115 | 1058 | 27 |
1910114 | 1910114 | 2021-11-12 | Spink | South Dakota | 46115 | 1058 | 27 |
1906865 | 1906865 | 2021-11-11 | Spink | South Dakota | 46115 | 1057 | 27 |
1903616 | 1903616 | 2021-11-10 | Spink | South Dakota | 46115 | 1057 | 27 |
1900366 | 1900366 | 2021-11-09 | Spink | South Dakota | 46115 | 1053 | 27 |
1897116 | 1897116 | 2021-11-08 | Spink | South Dakota | 46115 | 1052 | 27 |
1893866 | 1893866 | 2021-11-07 | Spink | South Dakota | 46115 | 1050 | 27 |
1890616 | 1890616 | 2021-11-06 | Spink | South Dakota | 46115 | 1050 | 27 |
1887366 | 1887366 | 2021-11-05 | Spink | South Dakota | 46115 | 1050 | 27 |
1884116 | 1884116 | 2021-11-04 | Spink | South Dakota | 46115 | 1045 | 27 |
1880867 | 1880867 | 2021-11-03 | Spink | South Dakota | 46115 | 1045 | 27 |
1877618 | 1877618 | 2021-11-02 | Spink | South Dakota | 46115 | 1040 | 27 |
1874369 | 1874369 | 2021-11-01 | Spink | South Dakota | 46115 | 1034 | 27 |
1871120 | 1871120 | 2021-10-31 | Spink | South Dakota | 46115 | 1031 | 27 |
1867871 | 1867871 | 2021-10-30 | Spink | South Dakota | 46115 | 1031 | 27 |
1864622 | 1864622 | 2021-10-29 | Spink | South Dakota | 46115 | 1031 | 27 |
1861373 | 1861373 | 2021-10-28 | Spink | South Dakota | 46115 | 1024 | 27 |
1858124 | 1858124 | 2021-10-27 | Spink | South Dakota | 46115 | 1024 | 27 |
1854875 | 1854875 | 2021-10-26 | Spink | South Dakota | 46115 | 1020 | 27 |
1851626 | 1851626 | 2021-10-25 | Spink | South Dakota | 46115 | 1020 | 27 |
1848376 | 1848376 | 2021-10-24 | Spink | South Dakota | 46115 | 1019 | 27 |
1845126 | 1845126 | 2021-10-23 | Spink | South Dakota | 46115 | 1019 | 27 |
1841876 | 1841876 | 2021-10-22 | Spink | South Dakota | 46115 | 1019 | 27 |
1838627 | 1838627 | 2021-10-21 | Spink | South Dakota | 46115 | 1019 | 27 |
1835378 | 1835378 | 2021-10-20 | Spink | South Dakota | 46115 | 1018 | 27 |
1832129 | 1832129 | 2021-10-19 | Spink | South Dakota | 46115 | 1017 | 27 |
1828880 | 1828880 | 2021-10-18 | Spink | South Dakota | 46115 | 1013 | 27 |
1825631 | 1825631 | 2021-10-17 | Spink | South Dakota | 46115 | 1010 | 27 |
1822382 | 1822382 | 2021-10-16 | Spink | South Dakota | 46115 | 1010 | 27 |
1819133 | 1819133 | 2021-10-15 | Spink | South Dakota | 46115 | 1010 | 27 |
1815884 | 1815884 | 2021-10-14 | Spink | South Dakota | 46115 | 1009 | 27 |
1812636 | 1812636 | 2021-10-13 | Spink | South Dakota | 46115 | 999 | 27 |
1809387 | 1809387 | 2021-10-12 | Spink | South Dakota | 46115 | 986 | 27 |
1806137 | 1806137 | 2021-10-11 | Spink | South Dakota | 46115 | 981 | 27 |
1802887 | 1802887 | 2021-10-10 | Spink | South Dakota | 46115 | 981 | 27 |
1799638 | 1799638 | 2021-10-09 | Spink | South Dakota | 46115 | 981 | 27 |
1796389 | 1796389 | 2021-10-08 | Spink | South Dakota | 46115 | 981 | 27 |
1793140 | 1793140 | 2021-10-07 | Spink | South Dakota | 46115 | 979 | 27 |
1789891 | 1789891 | 2021-10-06 | Spink | South Dakota | 46115 | 979 | 27 |
1786643 | 1786643 | 2021-10-05 | Spink | South Dakota | 46115 | 974 | 27 |
1783394 | 1783394 | 2021-10-04 | Spink | South Dakota | 46115 | 971 | 27 |
1780145 | 1780145 | 2021-10-03 | Spink | South Dakota | 46115 | 971 | 27 |
1776895 | 1776895 | 2021-10-02 | Spink | South Dakota | 46115 | 971 | 27 |
1773645 | 1773645 | 2021-10-01 | Spink | South Dakota | 46115 | 971 | 27 |
1770395 | 1770395 | 2021-09-30 | Spink | South Dakota | 46115 | 966 | 27 |
1767146 | 1767146 | 2021-09-29 | Spink | South Dakota | 46115 | 967 | 26 |
1763897 | 1763897 | 2021-09-28 | Spink | South Dakota | 46115 | 967 | 26 |
1760648 | 1760648 | 2021-09-27 | Spink | South Dakota | 46115 | 960 | 26 |
1757400 | 1757400 | 2021-09-26 | Spink | South Dakota | 46115 | 958 | 26 |
1754152 | 1754152 | 2021-09-25 | Spink | South Dakota | 46115 | 958 | 26 |
1750904 | 1750904 | 2021-09-24 | Spink | South Dakota | 46115 | 958 | 26 |
1747655 | 1747655 | 2021-09-23 | Spink | South Dakota | 46115 | 954 | 26 |
1744405 | 1744405 | 2021-09-22 | Spink | South Dakota | 46115 | 954 | 26 |
1741156 | 1741156 | 2021-09-21 | Spink | South Dakota | 46115 | 949 | 26 |
1737907 | 1737907 | 2021-09-20 | Spink | South Dakota | 46115 | 945 | 26 |
1734657 | 1734657 | 2021-09-19 | Spink | South Dakota | 46115 | 946 | 26 |
1731407 | 1731407 | 2021-09-18 | Spink | South Dakota | 46115 | 946 | 26 |
1728157 | 1728157 | 2021-09-17 | Spink | South Dakota | 46115 | 946 | 26 |
1724908 | 1724908 | 2021-09-16 | Spink | South Dakota | 46115 | 942 | 26 |
1721659 | 1721659 | 2021-09-15 | Spink | South Dakota | 46115 | 939 | 26 |
1718411 | 1718411 | 2021-09-14 | Spink | South Dakota | 46115 | 927 | 26 |
1715163 | 1715163 | 2021-09-13 | Spink | South Dakota | 46115 | 922 | 26 |
1711917 | 1711917 | 2021-09-12 | Spink | South Dakota | 46115 | 918 | 26 |
1708670 | 1708670 | 2021-09-11 | Spink | South Dakota | 46115 | 918 | 26 |
1705423 | 1705423 | 2021-09-10 | Spink | South Dakota | 46115 | 918 | 26 |
1702173 | 1702173 | 2021-09-09 | Spink | South Dakota | 46115 | 915 | 26 |
1698924 | 1698924 | 2021-09-08 | Spink | South Dakota | 46115 | 910 | 26 |
1695676 | 1695676 | 2021-09-07 | Spink | South Dakota | 46115 | 901 | 26 |
1692428 | 1692428 | 2021-09-06 | Spink | South Dakota | 46115 | 899 | 26 |
1689179 | 1689179 | 2021-09-05 | Spink | South Dakota | 46115 | 899 | 26 |
1685929 | 1685929 | 2021-09-04 | Spink | South Dakota | 46115 | 899 | 26 |
1682678 | 1682678 | 2021-09-03 | Spink | South Dakota | 46115 | 899 | 26 |
1679428 | 1679428 | 2021-09-02 | Spink | South Dakota | 46115 | 896 | 26 |
1676180 | 1676180 | 2021-09-01 | Spink | South Dakota | 46115 | 889 | 26 |
1672933 | 1672933 | 2021-08-31 | Spink | South Dakota | 46115 | 886 | 26 |
1669685 | 1669685 | 2021-08-30 | Spink | South Dakota | 46115 | 883 | 26 |
1666438 | 1666438 | 2021-08-29 | Spink | South Dakota | 46115 | 879 | 26 |
1663190 | 1663190 | 2021-08-28 | Spink | South Dakota | 46115 | 879 | 26 |
1659942 | 1659942 | 2021-08-27 | Spink | South Dakota | 46115 | 879 | 26 |
1656693 | 1656693 | 2021-08-26 | Spink | South Dakota | 46115 | 879 | 26 |
1653446 | 1653446 | 2021-08-25 | Spink | South Dakota | 46115 | 878 | 26 |
1650199 | 1650199 | 2021-08-24 | Spink | South Dakota | 46115 | 876 | 26 |
1646950 | 1646950 | 2021-08-23 | Spink | South Dakota | 46115 | 870 | 26 |
1643701 | 1643701 | 2021-08-22 | Spink | South Dakota | 46115 | 866 | 26 |
1640451 | 1640451 | 2021-08-21 | Spink | South Dakota | 46115 | 866 | 26 |
1637201 | 1637201 | 2021-08-20 | Spink | South Dakota | 46115 | 866 | 26 |
1633951 | 1633951 | 2021-08-19 | Spink | South Dakota | 46115 | 865 | 26 |
1630704 | 1630704 | 2021-08-18 | Spink | South Dakota | 46115 | 864 | 26 |
1627457 | 1627457 | 2021-08-17 | Spink | South Dakota | 46115 | 862 | 26 |
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);