ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Meade" 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 |
---|---|---|---|---|---|---|---|
1949105 | 1949105 | 2021-11-24 | Meade | South Dakota | 46093 | 4864 | 51 |
1945854 | 1945854 | 2021-11-23 | Meade | South Dakota | 46093 | 4845 | 51 |
1942603 | 1942603 | 2021-11-22 | Meade | South Dakota | 46093 | 4829 | 51 |
1939353 | 1939353 | 2021-11-21 | Meade | South Dakota | 46093 | 4815 | 51 |
1936103 | 1936103 | 2021-11-20 | Meade | South Dakota | 46093 | 4815 | 51 |
1932853 | 1932853 | 2021-11-19 | Meade | South Dakota | 46093 | 4815 | 51 |
1929602 | 1929602 | 2021-11-18 | Meade | South Dakota | 46093 | 4806 | 51 |
1926352 | 1926352 | 2021-11-17 | Meade | South Dakota | 46093 | 4797 | 50 |
1923102 | 1923102 | 2021-11-16 | Meade | South Dakota | 46093 | 4778 | 50 |
1919853 | 1919853 | 2021-11-15 | Meade | South Dakota | 46093 | 4751 | 50 |
1916603 | 1916603 | 2021-11-14 | Meade | South Dakota | 46093 | 4731 | 49 |
1913353 | 1913353 | 2021-11-13 | Meade | South Dakota | 46093 | 4731 | 49 |
1910103 | 1910103 | 2021-11-12 | Meade | South Dakota | 46093 | 4731 | 49 |
1906854 | 1906854 | 2021-11-11 | Meade | South Dakota | 46093 | 4711 | 49 |
1903605 | 1903605 | 2021-11-10 | Meade | South Dakota | 46093 | 4711 | 49 |
1900355 | 1900355 | 2021-11-09 | Meade | South Dakota | 46093 | 4692 | 49 |
1897105 | 1897105 | 2021-11-08 | Meade | South Dakota | 46093 | 4666 | 49 |
1893855 | 1893855 | 2021-11-07 | Meade | South Dakota | 46093 | 4655 | 49 |
1890605 | 1890605 | 2021-11-06 | Meade | South Dakota | 46093 | 4655 | 49 |
1887355 | 1887355 | 2021-11-05 | Meade | South Dakota | 46093 | 4655 | 49 |
1884105 | 1884105 | 2021-11-04 | Meade | South Dakota | 46093 | 4645 | 49 |
1880856 | 1880856 | 2021-11-03 | Meade | South Dakota | 46093 | 4630 | 48 |
1877607 | 1877607 | 2021-11-02 | Meade | South Dakota | 46093 | 4603 | 48 |
1874358 | 1874358 | 2021-11-01 | Meade | South Dakota | 46093 | 4563 | 46 |
1871109 | 1871109 | 2021-10-31 | Meade | South Dakota | 46093 | 4547 | 46 |
1867860 | 1867860 | 2021-10-30 | Meade | South Dakota | 46093 | 4547 | 46 |
1864611 | 1864611 | 2021-10-29 | Meade | South Dakota | 46093 | 4547 | 46 |
1861362 | 1861362 | 2021-10-28 | Meade | South Dakota | 46093 | 4532 | 46 |
1858113 | 1858113 | 2021-10-27 | Meade | South Dakota | 46093 | 4521 | 46 |
1854864 | 1854864 | 2021-10-26 | Meade | South Dakota | 46093 | 4506 | 46 |
1851615 | 1851615 | 2021-10-25 | Meade | South Dakota | 46093 | 4478 | 46 |
1848365 | 1848365 | 2021-10-24 | Meade | South Dakota | 46093 | 4456 | 46 |
1845115 | 1845115 | 2021-10-23 | Meade | South Dakota | 46093 | 4456 | 46 |
1841865 | 1841865 | 2021-10-22 | Meade | South Dakota | 46093 | 4456 | 46 |
1838616 | 1838616 | 2021-10-21 | Meade | South Dakota | 46093 | 4448 | 46 |
1835367 | 1835367 | 2021-10-20 | Meade | South Dakota | 46093 | 4437 | 46 |
1832118 | 1832118 | 2021-10-19 | Meade | South Dakota | 46093 | 4414 | 45 |
1828869 | 1828869 | 2021-10-18 | Meade | South Dakota | 46093 | 4389 | 45 |
1825620 | 1825620 | 2021-10-17 | Meade | South Dakota | 46093 | 4374 | 44 |
1822371 | 1822371 | 2021-10-16 | Meade | South Dakota | 46093 | 4374 | 44 |
1819122 | 1819122 | 2021-10-15 | Meade | South Dakota | 46093 | 4374 | 44 |
1815873 | 1815873 | 2021-10-14 | Meade | South Dakota | 46093 | 4368 | 44 |
1812625 | 1812625 | 2021-10-13 | Meade | South Dakota | 46093 | 4358 | 43 |
1809376 | 1809376 | 2021-10-12 | Meade | South Dakota | 46093 | 4316 | 43 |
1806126 | 1806126 | 2021-10-11 | Meade | South Dakota | 46093 | 4286 | 42 |
1802876 | 1802876 | 2021-10-10 | Meade | South Dakota | 46093 | 4286 | 42 |
1799627 | 1799627 | 2021-10-09 | Meade | South Dakota | 46093 | 4286 | 42 |
1796378 | 1796378 | 2021-10-08 | Meade | South Dakota | 46093 | 4286 | 42 |
1793129 | 1793129 | 2021-10-07 | Meade | South Dakota | 46093 | 4266 | 42 |
1789880 | 1789880 | 2021-10-06 | Meade | South Dakota | 46093 | 4240 | 42 |
1786632 | 1786632 | 2021-10-05 | Meade | South Dakota | 46093 | 4208 | 40 |
1783383 | 1783383 | 2021-10-04 | Meade | South Dakota | 46093 | 4175 | 40 |
1780134 | 1780134 | 2021-10-03 | Meade | South Dakota | 46093 | 4164 | 40 |
1776884 | 1776884 | 2021-10-02 | Meade | South Dakota | 46093 | 4164 | 40 |
1773634 | 1773634 | 2021-10-01 | Meade | South Dakota | 46093 | 4164 | 40 |
1770384 | 1770384 | 2021-09-30 | Meade | South Dakota | 46093 | 4146 | 40 |
1767135 | 1767135 | 2021-09-29 | Meade | South Dakota | 46093 | 4115 | 40 |
1763886 | 1763886 | 2021-09-28 | Meade | South Dakota | 46093 | 4093 | 40 |
1760637 | 1760637 | 2021-09-27 | Meade | South Dakota | 46093 | 4053 | 39 |
1757389 | 1757389 | 2021-09-26 | Meade | South Dakota | 46093 | 4041 | 39 |
1754141 | 1754141 | 2021-09-25 | Meade | South Dakota | 46093 | 4041 | 39 |
1750893 | 1750893 | 2021-09-24 | Meade | South Dakota | 46093 | 4041 | 39 |
1747644 | 1747644 | 2021-09-23 | Meade | South Dakota | 46093 | 4026 | 38 |
1744394 | 1744394 | 2021-09-22 | Meade | South Dakota | 46093 | 3994 | 38 |
1741145 | 1741145 | 2021-09-21 | Meade | South Dakota | 46093 | 3969 | 38 |
1737896 | 1737896 | 2021-09-20 | Meade | South Dakota | 46093 | 3937 | 38 |
1734646 | 1734646 | 2021-09-19 | Meade | South Dakota | 46093 | 3920 | 36 |
1731396 | 1731396 | 2021-09-18 | Meade | South Dakota | 46093 | 3920 | 36 |
1728146 | 1728146 | 2021-09-17 | Meade | South Dakota | 46093 | 3920 | 36 |
1724897 | 1724897 | 2021-09-16 | Meade | South Dakota | 46093 | 3891 | 36 |
1721648 | 1721648 | 2021-09-15 | Meade | South Dakota | 46093 | 3860 | 36 |
1718400 | 1718400 | 2021-09-14 | Meade | South Dakota | 46093 | 3831 | 36 |
1715152 | 1715152 | 2021-09-13 | Meade | South Dakota | 46093 | 3766 | 35 |
1711906 | 1711906 | 2021-09-12 | Meade | South Dakota | 46093 | 3728 | 34 |
1708659 | 1708659 | 2021-09-11 | Meade | South Dakota | 46093 | 3728 | 34 |
1705412 | 1705412 | 2021-09-10 | Meade | South Dakota | 46093 | 3728 | 34 |
1702162 | 1702162 | 2021-09-09 | Meade | South Dakota | 46093 | 3692 | 33 |
1698913 | 1698913 | 2021-09-08 | Meade | South Dakota | 46093 | 3666 | 33 |
1695665 | 1695665 | 2021-09-07 | Meade | South Dakota | 46093 | 3591 | 33 |
1692417 | 1692417 | 2021-09-06 | Meade | South Dakota | 46093 | 3559 | 33 |
1689168 | 1689168 | 2021-09-05 | Meade | South Dakota | 46093 | 3559 | 33 |
1685918 | 1685918 | 2021-09-04 | Meade | South Dakota | 46093 | 3559 | 33 |
1682667 | 1682667 | 2021-09-03 | Meade | South Dakota | 46093 | 3559 | 33 |
1679417 | 1679417 | 2021-09-02 | Meade | South Dakota | 46093 | 3515 | 33 |
1676169 | 1676169 | 2021-09-01 | Meade | South Dakota | 46093 | 3472 | 32 |
1672922 | 1672922 | 2021-08-31 | Meade | South Dakota | 46093 | 3432 | 32 |
1669674 | 1669674 | 2021-08-30 | Meade | South Dakota | 46093 | 3335 | 32 |
1666427 | 1666427 | 2021-08-29 | Meade | South Dakota | 46093 | 3301 | 31 |
1663179 | 1663179 | 2021-08-28 | Meade | South Dakota | 46093 | 3301 | 31 |
1659931 | 1659931 | 2021-08-27 | Meade | South Dakota | 46093 | 3301 | 31 |
1656682 | 1656682 | 2021-08-26 | Meade | South Dakota | 46093 | 3249 | 31 |
1653435 | 1653435 | 2021-08-25 | Meade | South Dakota | 46093 | 3206 | 31 |
1650188 | 1650188 | 2021-08-24 | Meade | South Dakota | 46093 | 3168 | 31 |
1646939 | 1646939 | 2021-08-23 | Meade | South Dakota | 46093 | 3086 | 31 |
1643690 | 1643690 | 2021-08-22 | Meade | South Dakota | 46093 | 3028 | 31 |
1640440 | 1640440 | 2021-08-21 | Meade | South Dakota | 46093 | 3028 | 31 |
1637190 | 1637190 | 2021-08-20 | Meade | South Dakota | 46093 | 3028 | 31 |
1633940 | 1633940 | 2021-08-19 | Meade | South Dakota | 46093 | 3000 | 31 |
1630693 | 1630693 | 2021-08-18 | Meade | South Dakota | 46093 | 2974 | 31 |
1627446 | 1627446 | 2021-08-17 | Meade | South Dakota | 46093 | 2922 | 31 |
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);