ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 46102 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 |
---|---|---|---|---|---|---|---|
1949110 | 1949110 | 2021-11-24 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1945859 | 1945859 | 2021-11-23 | Oglala Lakota | South Dakota | 46102 | 2500 | 54 |
1942608 | 1942608 | 2021-11-22 | Oglala Lakota | South Dakota | 46102 | 2500 | 54 |
1939358 | 1939358 | 2021-11-21 | Oglala Lakota | South Dakota | 46102 | 2493 | 54 |
1936108 | 1936108 | 2021-11-20 | Oglala Lakota | South Dakota | 46102 | 2493 | 54 |
1932858 | 1932858 | 2021-11-19 | Oglala Lakota | South Dakota | 46102 | 2493 | 54 |
1929607 | 1929607 | 2021-11-18 | Oglala Lakota | South Dakota | 46102 | 2494 | 54 |
1926357 | 1926357 | 2021-11-17 | Oglala Lakota | South Dakota | 46102 | 2492 | 54 |
1923107 | 1923107 | 2021-11-16 | Oglala Lakota | South Dakota | 46102 | 2492 | 53 |
1919858 | 1919858 | 2021-11-15 | Oglala Lakota | South Dakota | 46102 | 2486 | 53 |
1916608 | 1916608 | 2021-11-14 | Oglala Lakota | South Dakota | 46102 | 2482 | 53 |
1913358 | 1913358 | 2021-11-13 | Oglala Lakota | South Dakota | 46102 | 2482 | 53 |
1910108 | 1910108 | 2021-11-12 | Oglala Lakota | South Dakota | 46102 | 2482 | 53 |
1906859 | 1906859 | 2021-11-11 | Oglala Lakota | South Dakota | 46102 | 2476 | 53 |
1903610 | 1903610 | 2021-11-10 | Oglala Lakota | South Dakota | 46102 | 2476 | 53 |
1900360 | 1900360 | 2021-11-09 | Oglala Lakota | South Dakota | 46102 | 2472 | 53 |
1897110 | 1897110 | 2021-11-08 | Oglala Lakota | South Dakota | 46102 | 2461 | 53 |
1893860 | 1893860 | 2021-11-07 | Oglala Lakota | South Dakota | 46102 | 2458 | 53 |
1890610 | 1890610 | 2021-11-06 | Oglala Lakota | South Dakota | 46102 | 2458 | 53 |
1887360 | 1887360 | 2021-11-05 | Oglala Lakota | South Dakota | 46102 | 2458 | 53 |
1884110 | 1884110 | 2021-11-04 | Oglala Lakota | South Dakota | 46102 | 2455 | 53 |
1880861 | 1880861 | 2021-11-03 | Oglala Lakota | South Dakota | 46102 | 2448 | 53 |
1877612 | 1877612 | 2021-11-02 | Oglala Lakota | South Dakota | 46102 | 2436 | 53 |
1874363 | 1874363 | 2021-11-01 | Oglala Lakota | South Dakota | 46102 | 2426 | 53 |
1871114 | 1871114 | 2021-10-31 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1867865 | 1867865 | 2021-10-30 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1864616 | 1864616 | 2021-10-29 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1861367 | 1861367 | 2021-10-28 | Oglala Lakota | South Dakota | 46102 | 2420 | 53 |
1858118 | 1858118 | 2021-10-27 | Oglala Lakota | South Dakota | 46102 | 2418 | 53 |
1854869 | 1854869 | 2021-10-26 | Oglala Lakota | South Dakota | 46102 | 2413 | 53 |
1851620 | 1851620 | 2021-10-25 | Oglala Lakota | South Dakota | 46102 | 2404 | 53 |
1848370 | 1848370 | 2021-10-24 | Oglala Lakota | South Dakota | 46102 | 2400 | 53 |
1845120 | 1845120 | 2021-10-23 | Oglala Lakota | South Dakota | 46102 | 2400 | 53 |
1841870 | 1841870 | 2021-10-22 | Oglala Lakota | South Dakota | 46102 | 2400 | 53 |
1838621 | 1838621 | 2021-10-21 | Oglala Lakota | South Dakota | 46102 | 2399 | 53 |
1835372 | 1835372 | 2021-10-20 | Oglala Lakota | South Dakota | 46102 | 2395 | 53 |
1832123 | 1832123 | 2021-10-19 | Oglala Lakota | South Dakota | 46102 | 2390 | 53 |
1828874 | 1828874 | 2021-10-18 | Oglala Lakota | South Dakota | 46102 | 2378 | 53 |
1825625 | 1825625 | 2021-10-17 | Oglala Lakota | South Dakota | 46102 | 2368 | 52 |
1822376 | 1822376 | 2021-10-16 | Oglala Lakota | South Dakota | 46102 | 2368 | 52 |
1819127 | 1819127 | 2021-10-15 | Oglala Lakota | South Dakota | 46102 | 2368 | 52 |
1815878 | 1815878 | 2021-10-14 | Oglala Lakota | South Dakota | 46102 | 2365 | 52 |
1812630 | 1812630 | 2021-10-13 | Oglala Lakota | South Dakota | 46102 | 2354 | 52 |
1809381 | 1809381 | 2021-10-12 | Oglala Lakota | South Dakota | 46102 | 2336 | 52 |
1806131 | 1806131 | 2021-10-11 | Oglala Lakota | South Dakota | 46102 | 2333 | 52 |
1802881 | 1802881 | 2021-10-10 | Oglala Lakota | South Dakota | 46102 | 2333 | 52 |
1799632 | 1799632 | 2021-10-09 | Oglala Lakota | South Dakota | 46102 | 2333 | 52 |
1796383 | 1796383 | 2021-10-08 | Oglala Lakota | South Dakota | 46102 | 2333 | 52 |
1793134 | 1793134 | 2021-10-07 | Oglala Lakota | South Dakota | 46102 | 2329 | 52 |
1789885 | 1789885 | 2021-10-06 | Oglala Lakota | South Dakota | 46102 | 2328 | 52 |
1786637 | 1786637 | 2021-10-05 | Oglala Lakota | South Dakota | 46102 | 2329 | 52 |
1783388 | 1783388 | 2021-10-04 | Oglala Lakota | South Dakota | 46102 | 2317 | 52 |
1780139 | 1780139 | 2021-10-03 | Oglala Lakota | South Dakota | 46102 | 2311 | 52 |
1776889 | 1776889 | 2021-10-02 | Oglala Lakota | South Dakota | 46102 | 2311 | 52 |
1773639 | 1773639 | 2021-10-01 | Oglala Lakota | South Dakota | 46102 | 2311 | 52 |
1770389 | 1770389 | 2021-09-30 | Oglala Lakota | South Dakota | 46102 | 2295 | 52 |
1767140 | 1767140 | 2021-09-29 | Oglala Lakota | South Dakota | 46102 | 2290 | 52 |
1763891 | 1763891 | 2021-09-28 | Oglala Lakota | South Dakota | 46102 | 2260 | 52 |
1760642 | 1760642 | 2021-09-27 | Oglala Lakota | South Dakota | 46102 | 2259 | 52 |
1757394 | 1757394 | 2021-09-26 | Oglala Lakota | South Dakota | 46102 | 2256 | 51 |
1754146 | 1754146 | 2021-09-25 | Oglala Lakota | South Dakota | 46102 | 2256 | 51 |
1750898 | 1750898 | 2021-09-24 | Oglala Lakota | South Dakota | 46102 | 2256 | 51 |
1747649 | 1747649 | 2021-09-23 | Oglala Lakota | South Dakota | 46102 | 2255 | 51 |
1744399 | 1744399 | 2021-09-22 | Oglala Lakota | South Dakota | 46102 | 2253 | 51 |
1741150 | 1741150 | 2021-09-21 | Oglala Lakota | South Dakota | 46102 | 2240 | 51 |
1737901 | 1737901 | 2021-09-20 | Oglala Lakota | South Dakota | 46102 | 2233 | 51 |
1734651 | 1734651 | 2021-09-19 | Oglala Lakota | South Dakota | 46102 | 2227 | 51 |
1731401 | 1731401 | 2021-09-18 | Oglala Lakota | South Dakota | 46102 | 2227 | 51 |
1728151 | 1728151 | 2021-09-17 | Oglala Lakota | South Dakota | 46102 | 2227 | 51 |
1724902 | 1724902 | 2021-09-16 | Oglala Lakota | South Dakota | 46102 | 2225 | 51 |
1721653 | 1721653 | 2021-09-15 | Oglala Lakota | South Dakota | 46102 | 2220 | 51 |
1718405 | 1718405 | 2021-09-14 | Oglala Lakota | South Dakota | 46102 | 2211 | 51 |
1715157 | 1715157 | 2021-09-13 | Oglala Lakota | South Dakota | 46102 | 2199 | 51 |
1711911 | 1711911 | 2021-09-12 | Oglala Lakota | South Dakota | 46102 | 2195 | 51 |
1708664 | 1708664 | 2021-09-11 | Oglala Lakota | South Dakota | 46102 | 2195 | 51 |
1705417 | 1705417 | 2021-09-10 | Oglala Lakota | South Dakota | 46102 | 2195 | 51 |
1702167 | 1702167 | 2021-09-09 | Oglala Lakota | South Dakota | 46102 | 2195 | 51 |
1698918 | 1698918 | 2021-09-08 | Oglala Lakota | South Dakota | 46102 | 2192 | 51 |
1695670 | 1695670 | 2021-09-07 | Oglala Lakota | South Dakota | 46102 | 2181 | 51 |
1692422 | 1692422 | 2021-09-06 | Oglala Lakota | South Dakota | 46102 | 2182 | 51 |
1689173 | 1689173 | 2021-09-05 | Oglala Lakota | South Dakota | 46102 | 2182 | 51 |
1685923 | 1685923 | 2021-09-04 | Oglala Lakota | South Dakota | 46102 | 2182 | 51 |
1682672 | 1682672 | 2021-09-03 | Oglala Lakota | South Dakota | 46102 | 2182 | 51 |
1679422 | 1679422 | 2021-09-02 | Oglala Lakota | South Dakota | 46102 | 2181 | 51 |
1676174 | 1676174 | 2021-09-01 | Oglala Lakota | South Dakota | 46102 | 2176 | 51 |
1672927 | 1672927 | 2021-08-31 | Oglala Lakota | South Dakota | 46102 | 2172 | 51 |
1669679 | 1669679 | 2021-08-30 | Oglala Lakota | South Dakota | 46102 | 2167 | 51 |
1666432 | 1666432 | 2021-08-29 | Oglala Lakota | South Dakota | 46102 | 2165 | 51 |
1663184 | 1663184 | 2021-08-28 | Oglala Lakota | South Dakota | 46102 | 2165 | 51 |
1659936 | 1659936 | 2021-08-27 | Oglala Lakota | South Dakota | 46102 | 2165 | 51 |
1656687 | 1656687 | 2021-08-26 | Oglala Lakota | South Dakota | 46102 | 2164 | 51 |
1653440 | 1653440 | 2021-08-25 | Oglala Lakota | South Dakota | 46102 | 2160 | 51 |
1650193 | 1650193 | 2021-08-24 | Oglala Lakota | South Dakota | 46102 | 2157 | 50 |
1646944 | 1646944 | 2021-08-23 | Oglala Lakota | South Dakota | 46102 | 2153 | 50 |
1643695 | 1643695 | 2021-08-22 | Oglala Lakota | South Dakota | 46102 | 2154 | 50 |
1640445 | 1640445 | 2021-08-21 | Oglala Lakota | South Dakota | 46102 | 2154 | 50 |
1637195 | 1637195 | 2021-08-20 | Oglala Lakota | South Dakota | 46102 | 2154 | 50 |
1633945 | 1633945 | 2021-08-19 | Oglala Lakota | South Dakota | 46102 | 2153 | 50 |
1630698 | 1630698 | 2021-08-18 | Oglala Lakota | South Dakota | 46102 | 2149 | 49 |
1627451 | 1627451 | 2021-08-17 | Oglala Lakota | South Dakota | 46102 | 2150 | 49 |
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);