ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

776 rows where fips = 46047 and state = "South Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • South Dakota · 776 ✖

fips 1

  • 46047 · 776 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502067 2502067 2022-05-13 Fall River South Dakota 46047 1807 39
2498809 2498809 2022-05-12 Fall River South Dakota 46047 1807 39
2495551 2495551 2022-05-11 Fall River South Dakota 46047 1807 39
2492293 2492293 2022-05-10 Fall River South Dakota 46047 1806 39
2489035 2489035 2022-05-09 Fall River South Dakota 46047 1806 39
2485778 2485778 2022-05-08 Fall River South Dakota 46047 1806 39
2482520 2482520 2022-05-07 Fall River South Dakota 46047 1806 39
2479262 2479262 2022-05-06 Fall River South Dakota 46047 1806 39
2476004 2476004 2022-05-05 Fall River South Dakota 46047 1806 39
2472747 2472747 2022-05-04 Fall River South Dakota 46047 1806 39
2469491 2469491 2022-05-03 Fall River South Dakota 46047 1806 39
2466235 2466235 2022-05-02 Fall River South Dakota 46047 1806 39
2462980 2462980 2022-05-01 Fall River South Dakota 46047 1806 39
2459724 2459724 2022-04-30 Fall River South Dakota 46047 1806 39
2456468 2456468 2022-04-29 Fall River South Dakota 46047 1806 39
2453212 2453212 2022-04-28 Fall River South Dakota 46047 1806 39
2449956 2449956 2022-04-27 Fall River South Dakota 46047 1806 39
2446699 2446699 2022-04-26 Fall River South Dakota 46047 1804 39
2443444 2443444 2022-04-25 Fall River South Dakota 46047 1804 39
2440188 2440188 2022-04-24 Fall River South Dakota 46047 1804 39
2436932 2436932 2022-04-23 Fall River South Dakota 46047 1804 39
2433676 2433676 2022-04-22 Fall River South Dakota 46047 1804 39
2430420 2430420 2022-04-21 Fall River South Dakota 46047 1804 39
2427164 2427164 2022-04-20 Fall River South Dakota 46047 1804 39
2423908 2423908 2022-04-19 Fall River South Dakota 46047 1804 39
2420652 2420652 2022-04-18 Fall River South Dakota 46047 1804 39
2417396 2417396 2022-04-17 Fall River South Dakota 46047 1804 39
2414140 2414140 2022-04-16 Fall River South Dakota 46047 1804 39
2410884 2410884 2022-04-15 Fall River South Dakota 46047 1804 39
2407628 2407628 2022-04-14 Fall River South Dakota 46047 1804 39
2404372 2404372 2022-04-13 Fall River South Dakota 46047 1804 39
2401117 2401117 2022-04-12 Fall River South Dakota 46047 1804 39
2397862 2397862 2022-04-11 Fall River South Dakota 46047 1804 39
2394607 2394607 2022-04-10 Fall River South Dakota 46047 1804 39
2391351 2391351 2022-04-09 Fall River South Dakota 46047 1804 39
2388095 2388095 2022-04-08 Fall River South Dakota 46047 1804 39
2384840 2384840 2022-04-07 Fall River South Dakota 46047 1804 39
2381585 2381585 2022-04-06 Fall River South Dakota 46047 1804 39
2378330 2378330 2022-04-05 Fall River South Dakota 46047 1802 39
2375076 2375076 2022-04-04 Fall River South Dakota 46047 1802 39
2371824 2371824 2022-04-03 Fall River South Dakota 46047 1802 39
2368571 2368571 2022-04-02 Fall River South Dakota 46047 1802 39
2365318 2365318 2022-04-01 Fall River South Dakota 46047 1802 39
2362065 2362065 2022-03-31 Fall River South Dakota 46047 1802 39
2358811 2358811 2022-03-30 Fall River South Dakota 46047 1802 39
2355557 2355557 2022-03-29 Fall River South Dakota 46047 1800 39
2352304 2352304 2022-03-28 Fall River South Dakota 46047 1800 39
2349052 2349052 2022-03-27 Fall River South Dakota 46047 1800 39
2345799 2345799 2022-03-26 Fall River South Dakota 46047 1800 39
2342546 2342546 2022-03-25 Fall River South Dakota 46047 1800 39
2339293 2339293 2022-03-24 Fall River South Dakota 46047 1800 39
2336039 2336039 2022-03-23 Fall River South Dakota 46047 1800 39
2332785 2332785 2022-03-22 Fall River South Dakota 46047 1800 39
2329532 2329532 2022-03-21 Fall River South Dakota 46047 1800 39
2326280 2326280 2022-03-20 Fall River South Dakota 46047 1800 39
2323027 2323027 2022-03-19 Fall River South Dakota 46047 1800 39
2319773 2319773 2022-03-18 Fall River South Dakota 46047 1800 39
2316519 2316519 2022-03-17 Fall River South Dakota 46047 1800 39
2313266 2313266 2022-03-16 Fall River South Dakota 46047 1800 39
2310013 2310013 2022-03-15 Fall River South Dakota 46047 1799 39
2306760 2306760 2022-03-14 Fall River South Dakota 46047 1799 39
2303509 2303509 2022-03-13 Fall River South Dakota 46047 1799 39
2300257 2300257 2022-03-12 Fall River South Dakota 46047 1799 39
2297005 2297005 2022-03-11 Fall River South Dakota 46047 1799 39
2293753 2293753 2022-03-10 Fall River South Dakota 46047 1799 39
2290501 2290501 2022-03-09 Fall River South Dakota 46047 1799 39
2287249 2287249 2022-03-08 Fall River South Dakota 46047 1798 39
2283997 2283997 2022-03-07 Fall River South Dakota 46047 1799 39
2280745 2280745 2022-03-06 Fall River South Dakota 46047 1799 39
2277492 2277492 2022-03-05 Fall River South Dakota 46047 1799 39
2274239 2274239 2022-03-04 Fall River South Dakota 46047 1799 39
2270986 2270986 2022-03-03 Fall River South Dakota 46047 1797 39
2267734 2267734 2022-03-02 Fall River South Dakota 46047 1796 39
2264481 2264481 2022-03-01 Fall River South Dakota 46047 1796 39
2261231 2261231 2022-02-28 Fall River South Dakota 46047 1796 39
2257980 2257980 2022-02-27 Fall River South Dakota 46047 1796 39
2254729 2254729 2022-02-26 Fall River South Dakota 46047 1796 39
2251478 2251478 2022-02-25 Fall River South Dakota 46047 1796 39
2248227 2248227 2022-02-24 Fall River South Dakota 46047 1793 39
2244976 2244976 2022-02-23 Fall River South Dakota 46047 1791 39
2241725 2241725 2022-02-22 Fall River South Dakota 46047 1790 39
2238474 2238474 2022-02-21 Fall River South Dakota 46047 1789 39
2235223 2235223 2022-02-20 Fall River South Dakota 46047 1789 39
2231972 2231972 2022-02-19 Fall River South Dakota 46047 1789 39
2228721 2228721 2022-02-18 Fall River South Dakota 46047 1789 39
2225470 2225470 2022-02-17 Fall River South Dakota 46047 1785 39
2222219 2222219 2022-02-16 Fall River South Dakota 46047 1783 39
2218968 2218968 2022-02-15 Fall River South Dakota 46047 1779 39
2215717 2215717 2022-02-14 Fall River South Dakota 46047 1775 39
2212466 2212466 2022-02-13 Fall River South Dakota 46047 1770 38
2209213 2209213 2022-02-12 Fall River South Dakota 46047 1770 38
2205960 2205960 2022-02-11 Fall River South Dakota 46047 1770 38
2202707 2202707 2022-02-10 Fall River South Dakota 46047 1767 38
2199453 2199453 2022-02-09 Fall River South Dakota 46047 1762 38
2196199 2196199 2022-02-08 Fall River South Dakota 46047 1755 37
2192945 2192945 2022-02-07 Fall River South Dakota 46047 1749 37
2189691 2189691 2022-02-06 Fall River South Dakota 46047 1736 37
2186438 2186438 2022-02-05 Fall River South Dakota 46047 1736 37
2183186 2183186 2022-02-04 Fall River South Dakota 46047 1736 37
2179934 2179934 2022-02-03 Fall River South Dakota 46047 1726 37

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);