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

777 rows where fips = 46067 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 · 777 ✖

fips 1

  • 46067 · 777 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502077 2502077 2022-05-13 Hutchinson South Dakota 46067 1733 36
2498819 2498819 2022-05-12 Hutchinson South Dakota 46067 1733 36
2495561 2495561 2022-05-11 Hutchinson South Dakota 46067 1733 36
2492303 2492303 2022-05-10 Hutchinson South Dakota 46067 1733 36
2489045 2489045 2022-05-09 Hutchinson South Dakota 46067 1733 36
2485788 2485788 2022-05-08 Hutchinson South Dakota 46067 1733 36
2482530 2482530 2022-05-07 Hutchinson South Dakota 46067 1733 36
2479272 2479272 2022-05-06 Hutchinson South Dakota 46067 1733 36
2476014 2476014 2022-05-05 Hutchinson South Dakota 46067 1733 36
2472757 2472757 2022-05-04 Hutchinson South Dakota 46067 1733 36
2469501 2469501 2022-05-03 Hutchinson South Dakota 46067 1733 36
2466245 2466245 2022-05-02 Hutchinson South Dakota 46067 1733 36
2462990 2462990 2022-05-01 Hutchinson South Dakota 46067 1733 36
2459734 2459734 2022-04-30 Hutchinson South Dakota 46067 1733 36
2456478 2456478 2022-04-29 Hutchinson South Dakota 46067 1733 36
2453222 2453222 2022-04-28 Hutchinson South Dakota 46067 1733 36
2449966 2449966 2022-04-27 Hutchinson South Dakota 46067 1733 36
2446709 2446709 2022-04-26 Hutchinson South Dakota 46067 1733 36
2443454 2443454 2022-04-25 Hutchinson South Dakota 46067 1733 36
2440198 2440198 2022-04-24 Hutchinson South Dakota 46067 1733 36
2436942 2436942 2022-04-23 Hutchinson South Dakota 46067 1733 36
2433686 2433686 2022-04-22 Hutchinson South Dakota 46067 1733 36
2430430 2430430 2022-04-21 Hutchinson South Dakota 46067 1733 36
2427174 2427174 2022-04-20 Hutchinson South Dakota 46067 1733 36
2423918 2423918 2022-04-19 Hutchinson South Dakota 46067 1733 36
2420662 2420662 2022-04-18 Hutchinson South Dakota 46067 1733 36
2417406 2417406 2022-04-17 Hutchinson South Dakota 46067 1733 36
2414150 2414150 2022-04-16 Hutchinson South Dakota 46067 1733 36
2410894 2410894 2022-04-15 Hutchinson South Dakota 46067 1733 36
2407638 2407638 2022-04-14 Hutchinson South Dakota 46067 1733 36
2404382 2404382 2022-04-13 Hutchinson South Dakota 46067 1733 36
2401127 2401127 2022-04-12 Hutchinson South Dakota 46067 1730 36
2397872 2397872 2022-04-11 Hutchinson South Dakota 46067 1730 36
2394617 2394617 2022-04-10 Hutchinson South Dakota 46067 1730 36
2391361 2391361 2022-04-09 Hutchinson South Dakota 46067 1730 36
2388105 2388105 2022-04-08 Hutchinson South Dakota 46067 1730 36
2384850 2384850 2022-04-07 Hutchinson South Dakota 46067 1730 36
2381595 2381595 2022-04-06 Hutchinson South Dakota 46067 1730 36
2378340 2378340 2022-04-05 Hutchinson South Dakota 46067 1730 36
2375086 2375086 2022-04-04 Hutchinson South Dakota 46067 1730 36
2371834 2371834 2022-04-03 Hutchinson South Dakota 46067 1730 36
2368581 2368581 2022-04-02 Hutchinson South Dakota 46067 1730 36
2365328 2365328 2022-04-01 Hutchinson South Dakota 46067 1730 36
2362075 2362075 2022-03-31 Hutchinson South Dakota 46067 1730 36
2358821 2358821 2022-03-30 Hutchinson South Dakota 46067 1730 36
2355567 2355567 2022-03-29 Hutchinson South Dakota 46067 1728 36
2352314 2352314 2022-03-28 Hutchinson South Dakota 46067 1728 36
2349062 2349062 2022-03-27 Hutchinson South Dakota 46067 1728 36
2345809 2345809 2022-03-26 Hutchinson South Dakota 46067 1728 36
2342556 2342556 2022-03-25 Hutchinson South Dakota 46067 1728 36
2339303 2339303 2022-03-24 Hutchinson South Dakota 46067 1728 36
2336049 2336049 2022-03-23 Hutchinson South Dakota 46067 1728 36
2332795 2332795 2022-03-22 Hutchinson South Dakota 46067 1727 36
2329542 2329542 2022-03-21 Hutchinson South Dakota 46067 1727 36
2326290 2326290 2022-03-20 Hutchinson South Dakota 46067 1727 36
2323037 2323037 2022-03-19 Hutchinson South Dakota 46067 1727 36
2319783 2319783 2022-03-18 Hutchinson South Dakota 46067 1727 36
2316529 2316529 2022-03-17 Hutchinson South Dakota 46067 1727 36
2313276 2313276 2022-03-16 Hutchinson South Dakota 46067 1728 36
2310023 2310023 2022-03-15 Hutchinson South Dakota 46067 1728 36
2306770 2306770 2022-03-14 Hutchinson South Dakota 46067 1727 36
2303519 2303519 2022-03-13 Hutchinson South Dakota 46067 1727 36
2300267 2300267 2022-03-12 Hutchinson South Dakota 46067 1727 36
2297015 2297015 2022-03-11 Hutchinson South Dakota 46067 1727 36
2293763 2293763 2022-03-10 Hutchinson South Dakota 46067 1727 36
2290511 2290511 2022-03-09 Hutchinson South Dakota 46067 1726 36
2287259 2287259 2022-03-08 Hutchinson South Dakota 46067 1726 36
2284007 2284007 2022-03-07 Hutchinson South Dakota 46067 1725 36
2280755 2280755 2022-03-06 Hutchinson South Dakota 46067 1724 36
2277502 2277502 2022-03-05 Hutchinson South Dakota 46067 1724 36
2274249 2274249 2022-03-04 Hutchinson South Dakota 46067 1724 36
2270996 2270996 2022-03-03 Hutchinson South Dakota 46067 1725 35
2267744 2267744 2022-03-02 Hutchinson South Dakota 46067 1725 35
2264491 2264491 2022-03-01 Hutchinson South Dakota 46067 1725 35
2261241 2261241 2022-02-28 Hutchinson South Dakota 46067 1725 35
2257990 2257990 2022-02-27 Hutchinson South Dakota 46067 1725 35
2254739 2254739 2022-02-26 Hutchinson South Dakota 46067 1725 35
2251488 2251488 2022-02-25 Hutchinson South Dakota 46067 1725 35
2248237 2248237 2022-02-24 Hutchinson South Dakota 46067 1725 34
2244986 2244986 2022-02-23 Hutchinson South Dakota 46067 1725 34
2241735 2241735 2022-02-22 Hutchinson South Dakota 46067 1723 34
2238484 2238484 2022-02-21 Hutchinson South Dakota 46067 1723 34
2235233 2235233 2022-02-20 Hutchinson South Dakota 46067 1723 34
2231982 2231982 2022-02-19 Hutchinson South Dakota 46067 1723 34
2228731 2228731 2022-02-18 Hutchinson South Dakota 46067 1723 34
2225480 2225480 2022-02-17 Hutchinson South Dakota 46067 1723 34
2222229 2222229 2022-02-16 Hutchinson South Dakota 46067 1722 34
2218978 2218978 2022-02-15 Hutchinson South Dakota 46067 1721 33
2215727 2215727 2022-02-14 Hutchinson South Dakota 46067 1718 33
2212476 2212476 2022-02-13 Hutchinson South Dakota 46067 1716 33
2209223 2209223 2022-02-12 Hutchinson South Dakota 46067 1716 33
2205970 2205970 2022-02-11 Hutchinson South Dakota 46067 1716 33
2202717 2202717 2022-02-10 Hutchinson South Dakota 46067 1713 33
2199463 2199463 2022-02-09 Hutchinson South Dakota 46067 1713 33
2196209 2196209 2022-02-08 Hutchinson South Dakota 46067 1714 33
2192955 2192955 2022-02-07 Hutchinson South Dakota 46067 1713 33
2189701 2189701 2022-02-06 Hutchinson South Dakota 46067 1711 33
2186448 2186448 2022-02-05 Hutchinson South Dakota 46067 1711 33
2183196 2183196 2022-02-04 Hutchinson South Dakota 46067 1711 33
2179944 2179944 2022-02-03 Hutchinson South Dakota 46067 1704 33

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