ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46065 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 |
---|---|---|---|---|---|---|---|
1949091 | 1949091 | 2021-11-24 | Hughes | South Dakota | 46065 | 3301 | 49 |
1945840 | 1945840 | 2021-11-23 | Hughes | South Dakota | 46065 | 3277 | 49 |
1942589 | 1942589 | 2021-11-22 | Hughes | South Dakota | 46065 | 3249 | 49 |
1939339 | 1939339 | 2021-11-21 | Hughes | South Dakota | 46065 | 3241 | 48 |
1936089 | 1936089 | 2021-11-20 | Hughes | South Dakota | 46065 | 3241 | 48 |
1932839 | 1932839 | 2021-11-19 | Hughes | South Dakota | 46065 | 3241 | 48 |
1929588 | 1929588 | 2021-11-18 | Hughes | South Dakota | 46065 | 3232 | 48 |
1926338 | 1926338 | 2021-11-17 | Hughes | South Dakota | 46065 | 3217 | 48 |
1923088 | 1923088 | 2021-11-16 | Hughes | South Dakota | 46065 | 3205 | 48 |
1919839 | 1919839 | 2021-11-15 | Hughes | South Dakota | 46065 | 3181 | 48 |
1916589 | 1916589 | 2021-11-14 | Hughes | South Dakota | 46065 | 3160 | 48 |
1913339 | 1913339 | 2021-11-13 | Hughes | South Dakota | 46065 | 3160 | 48 |
1910089 | 1910089 | 2021-11-12 | Hughes | South Dakota | 46065 | 3160 | 48 |
1906840 | 1906840 | 2021-11-11 | Hughes | South Dakota | 46065 | 3134 | 48 |
1903591 | 1903591 | 2021-11-10 | Hughes | South Dakota | 46065 | 3134 | 48 |
1900341 | 1900341 | 2021-11-09 | Hughes | South Dakota | 46065 | 3112 | 47 |
1897091 | 1897091 | 2021-11-08 | Hughes | South Dakota | 46065 | 3090 | 46 |
1893841 | 1893841 | 2021-11-07 | Hughes | South Dakota | 46065 | 3078 | 46 |
1890591 | 1890591 | 2021-11-06 | Hughes | South Dakota | 46065 | 3078 | 46 |
1887341 | 1887341 | 2021-11-05 | Hughes | South Dakota | 46065 | 3078 | 46 |
1884091 | 1884091 | 2021-11-04 | Hughes | South Dakota | 46065 | 3062 | 46 |
1880842 | 1880842 | 2021-11-03 | Hughes | South Dakota | 46065 | 3049 | 45 |
1877593 | 1877593 | 2021-11-02 | Hughes | South Dakota | 46065 | 3027 | 45 |
1874344 | 1874344 | 2021-11-01 | Hughes | South Dakota | 46065 | 3007 | 45 |
1871095 | 1871095 | 2021-10-31 | Hughes | South Dakota | 46065 | 2988 | 45 |
1867846 | 1867846 | 2021-10-30 | Hughes | South Dakota | 46065 | 2988 | 45 |
1864597 | 1864597 | 2021-10-29 | Hughes | South Dakota | 46065 | 2988 | 45 |
1861348 | 1861348 | 2021-10-28 | Hughes | South Dakota | 46065 | 2971 | 45 |
1858099 | 1858099 | 2021-10-27 | Hughes | South Dakota | 46065 | 2959 | 45 |
1854850 | 1854850 | 2021-10-26 | Hughes | South Dakota | 46065 | 2941 | 45 |
1851601 | 1851601 | 2021-10-25 | Hughes | South Dakota | 46065 | 2922 | 45 |
1848351 | 1848351 | 2021-10-24 | Hughes | South Dakota | 46065 | 2914 | 44 |
1845101 | 1845101 | 2021-10-23 | Hughes | South Dakota | 46065 | 2914 | 44 |
1841851 | 1841851 | 2021-10-22 | Hughes | South Dakota | 46065 | 2914 | 44 |
1838602 | 1838602 | 2021-10-21 | Hughes | South Dakota | 46065 | 2905 | 44 |
1835353 | 1835353 | 2021-10-20 | Hughes | South Dakota | 46065 | 2887 | 44 |
1832104 | 1832104 | 2021-10-19 | Hughes | South Dakota | 46065 | 2866 | 44 |
1828855 | 1828855 | 2021-10-18 | Hughes | South Dakota | 46065 | 2853 | 44 |
1825606 | 1825606 | 2021-10-17 | Hughes | South Dakota | 46065 | 2843 | 44 |
1822357 | 1822357 | 2021-10-16 | Hughes | South Dakota | 46065 | 2843 | 44 |
1819108 | 1819108 | 2021-10-15 | Hughes | South Dakota | 46065 | 2843 | 44 |
1815859 | 1815859 | 2021-10-14 | Hughes | South Dakota | 46065 | 2834 | 44 |
1812611 | 1812611 | 2021-10-13 | Hughes | South Dakota | 46065 | 2829 | 44 |
1809362 | 1809362 | 2021-10-12 | Hughes | South Dakota | 46065 | 2797 | 44 |
1806112 | 1806112 | 2021-10-11 | Hughes | South Dakota | 46065 | 2787 | 43 |
1802862 | 1802862 | 2021-10-10 | Hughes | South Dakota | 46065 | 2787 | 43 |
1799613 | 1799613 | 2021-10-09 | Hughes | South Dakota | 46065 | 2787 | 43 |
1796364 | 1796364 | 2021-10-08 | Hughes | South Dakota | 46065 | 2787 | 43 |
1793115 | 1793115 | 2021-10-07 | Hughes | South Dakota | 46065 | 2782 | 43 |
1789866 | 1789866 | 2021-10-06 | Hughes | South Dakota | 46065 | 2773 | 43 |
1786618 | 1786618 | 2021-10-05 | Hughes | South Dakota | 46065 | 2766 | 43 |
1783369 | 1783369 | 2021-10-04 | Hughes | South Dakota | 46065 | 2755 | 43 |
1780120 | 1780120 | 2021-10-03 | Hughes | South Dakota | 46065 | 2753 | 43 |
1776870 | 1776870 | 2021-10-02 | Hughes | South Dakota | 46065 | 2753 | 43 |
1773620 | 1773620 | 2021-10-01 | Hughes | South Dakota | 46065 | 2753 | 43 |
1770370 | 1770370 | 2021-09-30 | Hughes | South Dakota | 46065 | 2744 | 43 |
1767121 | 1767121 | 2021-09-29 | Hughes | South Dakota | 46065 | 2731 | 43 |
1763872 | 1763872 | 2021-09-28 | Hughes | South Dakota | 46065 | 2727 | 43 |
1760623 | 1760623 | 2021-09-27 | Hughes | South Dakota | 46065 | 2718 | 43 |
1757375 | 1757375 | 2021-09-26 | Hughes | South Dakota | 46065 | 2712 | 43 |
1754127 | 1754127 | 2021-09-25 | Hughes | South Dakota | 46065 | 2712 | 43 |
1750879 | 1750879 | 2021-09-24 | Hughes | South Dakota | 46065 | 2712 | 43 |
1747630 | 1747630 | 2021-09-23 | Hughes | South Dakota | 46065 | 2709 | 43 |
1744380 | 1744380 | 2021-09-22 | Hughes | South Dakota | 46065 | 2706 | 43 |
1741131 | 1741131 | 2021-09-21 | Hughes | South Dakota | 46065 | 2697 | 43 |
1737882 | 1737882 | 2021-09-20 | Hughes | South Dakota | 46065 | 2695 | 43 |
1734632 | 1734632 | 2021-09-19 | Hughes | South Dakota | 46065 | 2692 | 43 |
1731382 | 1731382 | 2021-09-18 | Hughes | South Dakota | 46065 | 2692 | 43 |
1728132 | 1728132 | 2021-09-17 | Hughes | South Dakota | 46065 | 2692 | 43 |
1724883 | 1724883 | 2021-09-16 | Hughes | South Dakota | 46065 | 2689 | 43 |
1721634 | 1721634 | 2021-09-15 | Hughes | South Dakota | 46065 | 2686 | 43 |
1718386 | 1718386 | 2021-09-14 | Hughes | South Dakota | 46065 | 2680 | 43 |
1715138 | 1715138 | 2021-09-13 | Hughes | South Dakota | 46065 | 2675 | 43 |
1711892 | 1711892 | 2021-09-12 | Hughes | South Dakota | 46065 | 2669 | 43 |
1708645 | 1708645 | 2021-09-11 | Hughes | South Dakota | 46065 | 2669 | 43 |
1705398 | 1705398 | 2021-09-10 | Hughes | South Dakota | 46065 | 2669 | 43 |
1702148 | 1702148 | 2021-09-09 | Hughes | South Dakota | 46065 | 2662 | 43 |
1698899 | 1698899 | 2021-09-08 | Hughes | South Dakota | 46065 | 2654 | 43 |
1695651 | 1695651 | 2021-09-07 | Hughes | South Dakota | 46065 | 2647 | 43 |
1692403 | 1692403 | 2021-09-06 | Hughes | South Dakota | 46065 | 2643 | 43 |
1689154 | 1689154 | 2021-09-05 | Hughes | South Dakota | 46065 | 2643 | 43 |
1685904 | 1685904 | 2021-09-04 | Hughes | South Dakota | 46065 | 2643 | 43 |
1682653 | 1682653 | 2021-09-03 | Hughes | South Dakota | 46065 | 2643 | 43 |
1679403 | 1679403 | 2021-09-02 | Hughes | South Dakota | 46065 | 2639 | 43 |
1676155 | 1676155 | 2021-09-01 | Hughes | South Dakota | 46065 | 2632 | 43 |
1672908 | 1672908 | 2021-08-31 | Hughes | South Dakota | 46065 | 2626 | 43 |
1669660 | 1669660 | 2021-08-30 | Hughes | South Dakota | 46065 | 2622 | 43 |
1666413 | 1666413 | 2021-08-29 | Hughes | South Dakota | 46065 | 2619 | 43 |
1663165 | 1663165 | 2021-08-28 | Hughes | South Dakota | 46065 | 2619 | 43 |
1659917 | 1659917 | 2021-08-27 | Hughes | South Dakota | 46065 | 2619 | 43 |
1656668 | 1656668 | 2021-08-26 | Hughes | South Dakota | 46065 | 2610 | 43 |
1653421 | 1653421 | 2021-08-25 | Hughes | South Dakota | 46065 | 2605 | 43 |
1650174 | 1650174 | 2021-08-24 | Hughes | South Dakota | 46065 | 2601 | 43 |
1646925 | 1646925 | 2021-08-23 | Hughes | South Dakota | 46065 | 2590 | 43 |
1643676 | 1643676 | 2021-08-22 | Hughes | South Dakota | 46065 | 2587 | 43 |
1640426 | 1640426 | 2021-08-21 | Hughes | South Dakota | 46065 | 2587 | 43 |
1637176 | 1637176 | 2021-08-20 | Hughes | South Dakota | 46065 | 2587 | 43 |
1633926 | 1633926 | 2021-08-19 | Hughes | South Dakota | 46065 | 2584 | 43 |
1630679 | 1630679 | 2021-08-18 | Hughes | South Dakota | 46065 | 2582 | 43 |
1627432 | 1627432 | 2021-08-17 | Hughes | South Dakota | 46065 | 2579 | 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);