ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46029 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 |
---|---|---|---|---|---|---|---|
1949073 | 1949073 | 2021-11-24 | Codington | South Dakota | 46029 | 5940 | 86 |
1945822 | 1945822 | 2021-11-23 | Codington | South Dakota | 46029 | 5917 | 87 |
1942571 | 1942571 | 2021-11-22 | Codington | South Dakota | 46029 | 5885 | 87 |
1939321 | 1939321 | 2021-11-21 | Codington | South Dakota | 46029 | 5876 | 86 |
1936071 | 1936071 | 2021-11-20 | Codington | South Dakota | 46029 | 5876 | 86 |
1932821 | 1932821 | 2021-11-19 | Codington | South Dakota | 46029 | 5876 | 86 |
1929570 | 1929570 | 2021-11-18 | Codington | South Dakota | 46029 | 5862 | 85 |
1926320 | 1926320 | 2021-11-17 | Codington | South Dakota | 46029 | 5846 | 85 |
1923070 | 1923070 | 2021-11-16 | Codington | South Dakota | 46029 | 5824 | 85 |
1919821 | 1919821 | 2021-11-15 | Codington | South Dakota | 46029 | 5785 | 84 |
1916571 | 1916571 | 2021-11-14 | Codington | South Dakota | 46029 | 5752 | 84 |
1913321 | 1913321 | 2021-11-13 | Codington | South Dakota | 46029 | 5752 | 84 |
1910071 | 1910071 | 2021-11-12 | Codington | South Dakota | 46029 | 5752 | 84 |
1906822 | 1906822 | 2021-11-11 | Codington | South Dakota | 46029 | 5729 | 84 |
1903573 | 1903573 | 2021-11-10 | Codington | South Dakota | 46029 | 5729 | 84 |
1900323 | 1900323 | 2021-11-09 | Codington | South Dakota | 46029 | 5711 | 84 |
1897073 | 1897073 | 2021-11-08 | Codington | South Dakota | 46029 | 5680 | 84 |
1893823 | 1893823 | 2021-11-07 | Codington | South Dakota | 46029 | 5671 | 84 |
1890573 | 1890573 | 2021-11-06 | Codington | South Dakota | 46029 | 5671 | 84 |
1887323 | 1887323 | 2021-11-05 | Codington | South Dakota | 46029 | 5671 | 84 |
1884073 | 1884073 | 2021-11-04 | Codington | South Dakota | 46029 | 5662 | 84 |
1880824 | 1880824 | 2021-11-03 | Codington | South Dakota | 46029 | 5645 | 84 |
1877575 | 1877575 | 2021-11-02 | Codington | South Dakota | 46029 | 5622 | 84 |
1874326 | 1874326 | 2021-11-01 | Codington | South Dakota | 46029 | 5598 | 84 |
1871077 | 1871077 | 2021-10-31 | Codington | South Dakota | 46029 | 5598 | 84 |
1867828 | 1867828 | 2021-10-30 | Codington | South Dakota | 46029 | 5598 | 84 |
1864579 | 1864579 | 2021-10-29 | Codington | South Dakota | 46029 | 5598 | 84 |
1861330 | 1861330 | 2021-10-28 | Codington | South Dakota | 46029 | 5587 | 84 |
1858081 | 1858081 | 2021-10-27 | Codington | South Dakota | 46029 | 5574 | 84 |
1854832 | 1854832 | 2021-10-26 | Codington | South Dakota | 46029 | 5549 | 84 |
1851583 | 1851583 | 2021-10-25 | Codington | South Dakota | 46029 | 5520 | 84 |
1848333 | 1848333 | 2021-10-24 | Codington | South Dakota | 46029 | 5512 | 84 |
1845083 | 1845083 | 2021-10-23 | Codington | South Dakota | 46029 | 5512 | 84 |
1841833 | 1841833 | 2021-10-22 | Codington | South Dakota | 46029 | 5512 | 84 |
1838584 | 1838584 | 2021-10-21 | Codington | South Dakota | 46029 | 5503 | 84 |
1835335 | 1835335 | 2021-10-20 | Codington | South Dakota | 46029 | 5479 | 84 |
1832086 | 1832086 | 2021-10-19 | Codington | South Dakota | 46029 | 5459 | 84 |
1828837 | 1828837 | 2021-10-18 | Codington | South Dakota | 46029 | 5403 | 84 |
1825588 | 1825588 | 2021-10-17 | Codington | South Dakota | 46029 | 5386 | 83 |
1822339 | 1822339 | 2021-10-16 | Codington | South Dakota | 46029 | 5386 | 83 |
1819090 | 1819090 | 2021-10-15 | Codington | South Dakota | 46029 | 5386 | 83 |
1815841 | 1815841 | 2021-10-14 | Codington | South Dakota | 46029 | 5374 | 83 |
1812593 | 1812593 | 2021-10-13 | Codington | South Dakota | 46029 | 5358 | 83 |
1809344 | 1809344 | 2021-10-12 | Codington | South Dakota | 46029 | 5300 | 83 |
1806094 | 1806094 | 2021-10-11 | Codington | South Dakota | 46029 | 5290 | 83 |
1802844 | 1802844 | 2021-10-10 | Codington | South Dakota | 46029 | 5290 | 83 |
1799595 | 1799595 | 2021-10-09 | Codington | South Dakota | 46029 | 5290 | 83 |
1796346 | 1796346 | 2021-10-08 | Codington | South Dakota | 46029 | 5290 | 83 |
1793097 | 1793097 | 2021-10-07 | Codington | South Dakota | 46029 | 5284 | 83 |
1789848 | 1789848 | 2021-10-06 | Codington | South Dakota | 46029 | 5279 | 83 |
1786600 | 1786600 | 2021-10-05 | Codington | South Dakota | 46029 | 5268 | 83 |
1783351 | 1783351 | 2021-10-04 | Codington | South Dakota | 46029 | 5240 | 83 |
1780102 | 1780102 | 2021-10-03 | Codington | South Dakota | 46029 | 5219 | 83 |
1776852 | 1776852 | 2021-10-02 | Codington | South Dakota | 46029 | 5219 | 83 |
1773602 | 1773602 | 2021-10-01 | Codington | South Dakota | 46029 | 5219 | 83 |
1770352 | 1770352 | 2021-09-30 | Codington | South Dakota | 46029 | 5208 | 82 |
1767103 | 1767103 | 2021-09-29 | Codington | South Dakota | 46029 | 5192 | 82 |
1763854 | 1763854 | 2021-09-28 | Codington | South Dakota | 46029 | 5178 | 82 |
1760605 | 1760605 | 2021-09-27 | Codington | South Dakota | 46029 | 5157 | 82 |
1757357 | 1757357 | 2021-09-26 | Codington | South Dakota | 46029 | 5136 | 82 |
1754109 | 1754109 | 2021-09-25 | Codington | South Dakota | 46029 | 5136 | 82 |
1750861 | 1750861 | 2021-09-24 | Codington | South Dakota | 46029 | 5136 | 82 |
1747612 | 1747612 | 2021-09-23 | Codington | South Dakota | 46029 | 5100 | 82 |
1744362 | 1744362 | 2021-09-22 | Codington | South Dakota | 46029 | 5073 | 82 |
1741113 | 1741113 | 2021-09-21 | Codington | South Dakota | 46029 | 5054 | 82 |
1737864 | 1737864 | 2021-09-20 | Codington | South Dakota | 46029 | 5024 | 82 |
1734614 | 1734614 | 2021-09-19 | Codington | South Dakota | 46029 | 5008 | 82 |
1731364 | 1731364 | 2021-09-18 | Codington | South Dakota | 46029 | 5008 | 82 |
1728114 | 1728114 | 2021-09-17 | Codington | South Dakota | 46029 | 5008 | 82 |
1724865 | 1724865 | 2021-09-16 | Codington | South Dakota | 46029 | 4998 | 82 |
1721616 | 1721616 | 2021-09-15 | Codington | South Dakota | 46029 | 4986 | 82 |
1718368 | 1718368 | 2021-09-14 | Codington | South Dakota | 46029 | 4970 | 82 |
1715120 | 1715120 | 2021-09-13 | Codington | South Dakota | 46029 | 4934 | 82 |
1711874 | 1711874 | 2021-09-12 | Codington | South Dakota | 46029 | 4924 | 82 |
1708627 | 1708627 | 2021-09-11 | Codington | South Dakota | 46029 | 4924 | 82 |
1705380 | 1705380 | 2021-09-10 | Codington | South Dakota | 46029 | 4924 | 82 |
1702130 | 1702130 | 2021-09-09 | Codington | South Dakota | 46029 | 4902 | 82 |
1698881 | 1698881 | 2021-09-08 | Codington | South Dakota | 46029 | 4886 | 82 |
1695633 | 1695633 | 2021-09-07 | Codington | South Dakota | 46029 | 4843 | 82 |
1692385 | 1692385 | 2021-09-06 | Codington | South Dakota | 46029 | 4834 | 82 |
1689136 | 1689136 | 2021-09-05 | Codington | South Dakota | 46029 | 4834 | 82 |
1685886 | 1685886 | 2021-09-04 | Codington | South Dakota | 46029 | 4834 | 82 |
1682635 | 1682635 | 2021-09-03 | Codington | South Dakota | 46029 | 4834 | 82 |
1679385 | 1679385 | 2021-09-02 | Codington | South Dakota | 46029 | 4827 | 82 |
1676137 | 1676137 | 2021-09-01 | Codington | South Dakota | 46029 | 4818 | 82 |
1672890 | 1672890 | 2021-08-31 | Codington | South Dakota | 46029 | 4807 | 82 |
1669642 | 1669642 | 2021-08-30 | Codington | South Dakota | 46029 | 4790 | 82 |
1666395 | 1666395 | 2021-08-29 | Codington | South Dakota | 46029 | 4783 | 82 |
1663147 | 1663147 | 2021-08-28 | Codington | South Dakota | 46029 | 4783 | 82 |
1659899 | 1659899 | 2021-08-27 | Codington | South Dakota | 46029 | 4783 | 82 |
1656650 | 1656650 | 2021-08-26 | Codington | South Dakota | 46029 | 4777 | 82 |
1653403 | 1653403 | 2021-08-25 | Codington | South Dakota | 46029 | 4771 | 82 |
1650156 | 1650156 | 2021-08-24 | Codington | South Dakota | 46029 | 4763 | 82 |
1646907 | 1646907 | 2021-08-23 | Codington | South Dakota | 46029 | 4749 | 82 |
1643658 | 1643658 | 2021-08-22 | Codington | South Dakota | 46029 | 4743 | 82 |
1640408 | 1640408 | 2021-08-21 | Codington | South Dakota | 46029 | 4743 | 82 |
1637158 | 1637158 | 2021-08-20 | Codington | South Dakota | 46029 | 4743 | 82 |
1633908 | 1633908 | 2021-08-19 | Codington | South Dakota | 46029 | 4738 | 82 |
1630661 | 1630661 | 2021-08-18 | Codington | South Dakota | 46029 | 4734 | 82 |
1627414 | 1627414 | 2021-08-17 | Codington | South Dakota | 46029 | 4724 | 82 |
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);