ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Minnehaha" 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 |
---|---|---|---|---|---|---|---|
1949108 | 1949108 | 2021-11-24 | Minnehaha | South Dakota | 46099 | 39537 | 404 |
1945857 | 1945857 | 2021-11-23 | Minnehaha | South Dakota | 46099 | 39429 | 403 |
1942606 | 1942606 | 2021-11-22 | Minnehaha | South Dakota | 46099 | 39233 | 400 |
1939356 | 1939356 | 2021-11-21 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1936106 | 1936106 | 2021-11-20 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1932856 | 1932856 | 2021-11-19 | Minnehaha | South Dakota | 46099 | 39147 | 399 |
1929605 | 1929605 | 2021-11-18 | Minnehaha | South Dakota | 46099 | 39076 | 398 |
1926355 | 1926355 | 2021-11-17 | Minnehaha | South Dakota | 46099 | 38986 | 398 |
1923105 | 1923105 | 2021-11-16 | Minnehaha | South Dakota | 46099 | 38871 | 398 |
1919856 | 1919856 | 2021-11-15 | Minnehaha | South Dakota | 46099 | 38647 | 397 |
1916606 | 1916606 | 2021-11-14 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1913356 | 1913356 | 2021-11-13 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1910106 | 1910106 | 2021-11-12 | Minnehaha | South Dakota | 46099 | 38485 | 397 |
1906857 | 1906857 | 2021-11-11 | Minnehaha | South Dakota | 46099 | 38370 | 396 |
1903608 | 1903608 | 2021-11-10 | Minnehaha | South Dakota | 46099 | 38370 | 396 |
1900358 | 1900358 | 2021-11-09 | Minnehaha | South Dakota | 46099 | 38257 | 396 |
1897108 | 1897108 | 2021-11-08 | Minnehaha | South Dakota | 46099 | 38060 | 395 |
1893858 | 1893858 | 2021-11-07 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1890608 | 1890608 | 2021-11-06 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1887358 | 1887358 | 2021-11-05 | Minnehaha | South Dakota | 46099 | 37984 | 395 |
1884108 | 1884108 | 2021-11-04 | Minnehaha | South Dakota | 46099 | 37887 | 394 |
1880859 | 1880859 | 2021-11-03 | Minnehaha | South Dakota | 46099 | 37818 | 394 |
1877610 | 1877610 | 2021-11-02 | Minnehaha | South Dakota | 46099 | 37722 | 394 |
1874361 | 1874361 | 2021-11-01 | Minnehaha | South Dakota | 46099 | 37591 | 393 |
1871112 | 1871112 | 2021-10-31 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1867863 | 1867863 | 2021-10-30 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1864614 | 1864614 | 2021-10-29 | Minnehaha | South Dakota | 46099 | 37519 | 393 |
1861365 | 1861365 | 2021-10-28 | Minnehaha | South Dakota | 46099 | 37444 | 393 |
1858116 | 1858116 | 2021-10-27 | Minnehaha | South Dakota | 46099 | 37396 | 393 |
1854867 | 1854867 | 2021-10-26 | Minnehaha | South Dakota | 46099 | 37321 | 393 |
1851618 | 1851618 | 2021-10-25 | Minnehaha | South Dakota | 46099 | 37184 | 391 |
1848368 | 1848368 | 2021-10-24 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1845118 | 1845118 | 2021-10-23 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1841868 | 1841868 | 2021-10-22 | Minnehaha | South Dakota | 46099 | 37133 | 391 |
1838619 | 1838619 | 2021-10-21 | Minnehaha | South Dakota | 46099 | 37078 | 390 |
1835370 | 1835370 | 2021-10-20 | Minnehaha | South Dakota | 46099 | 37008 | 389 |
1832121 | 1832121 | 2021-10-19 | Minnehaha | South Dakota | 46099 | 36932 | 389 |
1828872 | 1828872 | 2021-10-18 | Minnehaha | South Dakota | 46099 | 36808 | 389 |
1825623 | 1825623 | 2021-10-17 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1822374 | 1822374 | 2021-10-16 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1819125 | 1819125 | 2021-10-15 | Minnehaha | South Dakota | 46099 | 36752 | 385 |
1815876 | 1815876 | 2021-10-14 | Minnehaha | South Dakota | 46099 | 36679 | 383 |
1812628 | 1812628 | 2021-10-13 | Minnehaha | South Dakota | 46099 | 36617 | 383 |
1809379 | 1809379 | 2021-10-12 | Minnehaha | South Dakota | 46099 | 36393 | 383 |
1806129 | 1806129 | 2021-10-11 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1802879 | 1802879 | 2021-10-10 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1799630 | 1799630 | 2021-10-09 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1796381 | 1796381 | 2021-10-08 | Minnehaha | South Dakota | 46099 | 36313 | 383 |
1793132 | 1793132 | 2021-10-07 | Minnehaha | South Dakota | 46099 | 36215 | 383 |
1789883 | 1789883 | 2021-10-06 | Minnehaha | South Dakota | 46099 | 36128 | 382 |
1786635 | 1786635 | 2021-10-05 | Minnehaha | South Dakota | 46099 | 36040 | 380 |
1783386 | 1783386 | 2021-10-04 | Minnehaha | South Dakota | 46099 | 35860 | 379 |
1780137 | 1780137 | 2021-10-03 | Minnehaha | South Dakota | 46099 | 35778 | 377 |
1776887 | 1776887 | 2021-10-02 | Minnehaha | South Dakota | 46099 | 35778 | 377 |
1773637 | 1773637 | 2021-10-01 | Minnehaha | South Dakota | 46099 | 35778 | 377 |
1770387 | 1770387 | 2021-09-30 | Minnehaha | South Dakota | 46099 | 35675 | 377 |
1767138 | 1767138 | 2021-09-29 | Minnehaha | South Dakota | 46099 | 35584 | 377 |
1763889 | 1763889 | 2021-09-28 | Minnehaha | South Dakota | 46099 | 35478 | 377 |
1760640 | 1760640 | 2021-09-27 | Minnehaha | South Dakota | 46099 | 35292 | 377 |
1757392 | 1757392 | 2021-09-26 | Minnehaha | South Dakota | 46099 | 35202 | 377 |
1754144 | 1754144 | 2021-09-25 | Minnehaha | South Dakota | 46099 | 35202 | 377 |
1750896 | 1750896 | 2021-09-24 | Minnehaha | South Dakota | 46099 | 35202 | 377 |
1747647 | 1747647 | 2021-09-23 | Minnehaha | South Dakota | 46099 | 35087 | 376 |
1744397 | 1744397 | 2021-09-22 | Minnehaha | South Dakota | 46099 | 34955 | 373 |
1741148 | 1741148 | 2021-09-21 | Minnehaha | South Dakota | 46099 | 34840 | 373 |
1737899 | 1737899 | 2021-09-20 | Minnehaha | South Dakota | 46099 | 34692 | 372 |
1734649 | 1734649 | 2021-09-19 | Minnehaha | South Dakota | 46099 | 34592 | 372 |
1731399 | 1731399 | 2021-09-18 | Minnehaha | South Dakota | 46099 | 34592 | 372 |
1728149 | 1728149 | 2021-09-17 | Minnehaha | South Dakota | 46099 | 34592 | 372 |
1724900 | 1724900 | 2021-09-16 | Minnehaha | South Dakota | 46099 | 34479 | 371 |
1721651 | 1721651 | 2021-09-15 | Minnehaha | South Dakota | 46099 | 34380 | 371 |
1718403 | 1718403 | 2021-09-14 | Minnehaha | South Dakota | 46099 | 34282 | 371 |
1715155 | 1715155 | 2021-09-13 | Minnehaha | South Dakota | 46099 | 34081 | 371 |
1711909 | 1711909 | 2021-09-12 | Minnehaha | South Dakota | 46099 | 33975 | 371 |
1708662 | 1708662 | 2021-09-11 | Minnehaha | South Dakota | 46099 | 33975 | 371 |
1705415 | 1705415 | 2021-09-10 | Minnehaha | South Dakota | 46099 | 33975 | 371 |
1702165 | 1702165 | 2021-09-09 | Minnehaha | South Dakota | 46099 | 33871 | 370 |
1698916 | 1698916 | 2021-09-08 | Minnehaha | South Dakota | 46099 | 33771 | 370 |
1695668 | 1695668 | 2021-09-07 | Minnehaha | South Dakota | 46099 | 33566 | 369 |
1692420 | 1692420 | 2021-09-06 | Minnehaha | South Dakota | 46099 | 33486 | 368 |
1689171 | 1689171 | 2021-09-05 | Minnehaha | South Dakota | 46099 | 33486 | 368 |
1685921 | 1685921 | 2021-09-04 | Minnehaha | South Dakota | 46099 | 33486 | 368 |
1682670 | 1682670 | 2021-09-03 | Minnehaha | South Dakota | 46099 | 33486 | 368 |
1679420 | 1679420 | 2021-09-02 | Minnehaha | South Dakota | 46099 | 33411 | 368 |
1676172 | 1676172 | 2021-09-01 | Minnehaha | South Dakota | 46099 | 33334 | 368 |
1672925 | 1672925 | 2021-08-31 | Minnehaha | South Dakota | 46099 | 33270 | 368 |
1669677 | 1669677 | 2021-08-30 | Minnehaha | South Dakota | 46099 | 33122 | 367 |
1666430 | 1666430 | 2021-08-29 | Minnehaha | South Dakota | 46099 | 33048 | 366 |
1663182 | 1663182 | 2021-08-28 | Minnehaha | South Dakota | 46099 | 33048 | 366 |
1659934 | 1659934 | 2021-08-27 | Minnehaha | South Dakota | 46099 | 33048 | 366 |
1656685 | 1656685 | 2021-08-26 | Minnehaha | South Dakota | 46099 | 32977 | 365 |
1653438 | 1653438 | 2021-08-25 | Minnehaha | South Dakota | 46099 | 32895 | 365 |
1650191 | 1650191 | 2021-08-24 | Minnehaha | South Dakota | 46099 | 32823 | 365 |
1646942 | 1646942 | 2021-08-23 | Minnehaha | South Dakota | 46099 | 32701 | 365 |
1643693 | 1643693 | 2021-08-22 | Minnehaha | South Dakota | 46099 | 32653 | 365 |
1640443 | 1640443 | 2021-08-21 | Minnehaha | South Dakota | 46099 | 32653 | 365 |
1637193 | 1637193 | 2021-08-20 | Minnehaha | South Dakota | 46099 | 32653 | 365 |
1633943 | 1633943 | 2021-08-19 | Minnehaha | South Dakota | 46099 | 32597 | 365 |
1630696 | 1630696 | 2021-08-18 | Minnehaha | South Dakota | 46099 | 32553 | 365 |
1627449 | 1627449 | 2021-08-17 | Minnehaha | South Dakota | 46099 | 32491 | 365 |
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);