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 = 46135 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

  • 46135 · 777 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502109 2502109 2022-05-13 Yankton South Dakota 46135 5929 59
2498851 2498851 2022-05-12 Yankton South Dakota 46135 5929 59
2495593 2495593 2022-05-11 Yankton South Dakota 46135 5929 59
2492335 2492335 2022-05-10 Yankton South Dakota 46135 5916 59
2489077 2489077 2022-05-09 Yankton South Dakota 46135 5916 59
2485820 2485820 2022-05-08 Yankton South Dakota 46135 5916 59
2482562 2482562 2022-05-07 Yankton South Dakota 46135 5916 59
2479304 2479304 2022-05-06 Yankton South Dakota 46135 5916 59
2476046 2476046 2022-05-05 Yankton South Dakota 46135 5916 59
2472789 2472789 2022-05-04 Yankton South Dakota 46135 5916 59
2469533 2469533 2022-05-03 Yankton South Dakota 46135 5910 59
2466277 2466277 2022-05-02 Yankton South Dakota 46135 5910 59
2463022 2463022 2022-05-01 Yankton South Dakota 46135 5910 59
2459766 2459766 2022-04-30 Yankton South Dakota 46135 5910 59
2456510 2456510 2022-04-29 Yankton South Dakota 46135 5910 59
2453254 2453254 2022-04-28 Yankton South Dakota 46135 5910 59
2449998 2449998 2022-04-27 Yankton South Dakota 46135 5910 59
2446741 2446741 2022-04-26 Yankton South Dakota 46135 5905 59
2443486 2443486 2022-04-25 Yankton South Dakota 46135 5905 59
2440230 2440230 2022-04-24 Yankton South Dakota 46135 5905 59
2436974 2436974 2022-04-23 Yankton South Dakota 46135 5905 59
2433718 2433718 2022-04-22 Yankton South Dakota 46135 5905 59
2430462 2430462 2022-04-21 Yankton South Dakota 46135 5905 59
2427206 2427206 2022-04-20 Yankton South Dakota 46135 5905 59
2423950 2423950 2022-04-19 Yankton South Dakota 46135 5903 59
2420694 2420694 2022-04-18 Yankton South Dakota 46135 5903 59
2417438 2417438 2022-04-17 Yankton South Dakota 46135 5903 59
2414182 2414182 2022-04-16 Yankton South Dakota 46135 5903 59
2410926 2410926 2022-04-15 Yankton South Dakota 46135 5903 59
2407670 2407670 2022-04-14 Yankton South Dakota 46135 5903 59
2404414 2404414 2022-04-13 Yankton South Dakota 46135 5903 59
2401159 2401159 2022-04-12 Yankton South Dakota 46135 5902 59
2397904 2397904 2022-04-11 Yankton South Dakota 46135 5902 59
2394649 2394649 2022-04-10 Yankton South Dakota 46135 5902 59
2391393 2391393 2022-04-09 Yankton South Dakota 46135 5902 59
2388137 2388137 2022-04-08 Yankton South Dakota 46135 5902 59
2384882 2384882 2022-04-07 Yankton South Dakota 46135 5902 59
2381627 2381627 2022-04-06 Yankton South Dakota 46135 5902 59
2378372 2378372 2022-04-05 Yankton South Dakota 46135 5900 58
2375118 2375118 2022-04-04 Yankton South Dakota 46135 5900 58
2371866 2371866 2022-04-03 Yankton South Dakota 46135 5900 58
2368613 2368613 2022-04-02 Yankton South Dakota 46135 5900 58
2365360 2365360 2022-04-01 Yankton South Dakota 46135 5900 58
2362107 2362107 2022-03-31 Yankton South Dakota 46135 5900 58
2358853 2358853 2022-03-30 Yankton South Dakota 46135 5900 58
2355599 2355599 2022-03-29 Yankton South Dakota 46135 5901 58
2352346 2352346 2022-03-28 Yankton South Dakota 46135 5901 58
2349094 2349094 2022-03-27 Yankton South Dakota 46135 5901 58
2345841 2345841 2022-03-26 Yankton South Dakota 46135 5901 58
2342588 2342588 2022-03-25 Yankton South Dakota 46135 5901 58
2339335 2339335 2022-03-24 Yankton South Dakota 46135 5901 58
2336081 2336081 2022-03-23 Yankton South Dakota 46135 5901 58
2332827 2332827 2022-03-22 Yankton South Dakota 46135 5901 58
2329574 2329574 2022-03-21 Yankton South Dakota 46135 5901 58
2326322 2326322 2022-03-20 Yankton South Dakota 46135 5901 58
2323069 2323069 2022-03-19 Yankton South Dakota 46135 5901 58
2319815 2319815 2022-03-18 Yankton South Dakota 46135 5901 58
2316561 2316561 2022-03-17 Yankton South Dakota 46135 5901 57
2313308 2313308 2022-03-16 Yankton South Dakota 46135 5900 57
2310055 2310055 2022-03-15 Yankton South Dakota 46135 5899 57
2306802 2306802 2022-03-14 Yankton South Dakota 46135 5900 57
2303551 2303551 2022-03-13 Yankton South Dakota 46135 5902 57
2300299 2300299 2022-03-12 Yankton South Dakota 46135 5902 57
2297047 2297047 2022-03-11 Yankton South Dakota 46135 5902 57
2293795 2293795 2022-03-10 Yankton South Dakota 46135 5901 56
2290543 2290543 2022-03-09 Yankton South Dakota 46135 5897 56
2287291 2287291 2022-03-08 Yankton South Dakota 46135 5896 56
2284039 2284039 2022-03-07 Yankton South Dakota 46135 5894 56
2280787 2280787 2022-03-06 Yankton South Dakota 46135 5891 56
2277534 2277534 2022-03-05 Yankton South Dakota 46135 5891 56
2274281 2274281 2022-03-04 Yankton South Dakota 46135 5891 56
2271028 2271028 2022-03-03 Yankton South Dakota 46135 5887 56
2267776 2267776 2022-03-02 Yankton South Dakota 46135 5883 56
2264523 2264523 2022-03-01 Yankton South Dakota 46135 5882 56
2261273 2261273 2022-02-28 Yankton South Dakota 46135 5878 56
2258022 2258022 2022-02-27 Yankton South Dakota 46135 5875 56
2254771 2254771 2022-02-26 Yankton South Dakota 46135 5875 56
2251520 2251520 2022-02-25 Yankton South Dakota 46135 5875 56
2248269 2248269 2022-02-24 Yankton South Dakota 46135 5873 54
2245018 2245018 2022-02-23 Yankton South Dakota 46135 5875 54
2241767 2241767 2022-02-22 Yankton South Dakota 46135 5865 54
2238516 2238516 2022-02-21 Yankton South Dakota 46135 5866 54
2235265 2235265 2022-02-20 Yankton South Dakota 46135 5866 54
2232014 2232014 2022-02-19 Yankton South Dakota 46135 5866 54
2228763 2228763 2022-02-18 Yankton South Dakota 46135 5866 54
2225512 2225512 2022-02-17 Yankton South Dakota 46135 5863 53
2222261 2222261 2022-02-16 Yankton South Dakota 46135 5860 52
2219010 2219010 2022-02-15 Yankton South Dakota 46135 5854 51
2215759 2215759 2022-02-14 Yankton South Dakota 46135 5847 51
2212508 2212508 2022-02-13 Yankton South Dakota 46135 5840 51
2209255 2209255 2022-02-12 Yankton South Dakota 46135 5840 51
2206002 2206002 2022-02-11 Yankton South Dakota 46135 5840 51
2202749 2202749 2022-02-10 Yankton South Dakota 46135 5840 51
2199495 2199495 2022-02-09 Yankton South Dakota 46135 5835 51
2196241 2196241 2022-02-08 Yankton South Dakota 46135 5818 51
2192987 2192987 2022-02-07 Yankton South Dakota 46135 5798 51
2189733 2189733 2022-02-06 Yankton South Dakota 46135 5698 51
2186480 2186480 2022-02-05 Yankton South Dakota 46135 5698 51
2183228 2183228 2022-02-04 Yankton South Dakota 46135 5698 51
2179976 2179976 2022-02-03 Yankton South Dakota 46135 5677 51

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