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

780 rows where fips = 46093 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 · 780 ✖

fips 1

  • 46093 · 780 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502090 2502090 2022-05-13 Meade South Dakota 46093 7042 64
2498832 2498832 2022-05-12 Meade South Dakota 46093 7042 64
2495574 2495574 2022-05-11 Meade South Dakota 46093 7042 64
2492316 2492316 2022-05-10 Meade South Dakota 46093 7027 64
2489058 2489058 2022-05-09 Meade South Dakota 46093 7027 64
2485801 2485801 2022-05-08 Meade South Dakota 46093 7027 64
2482543 2482543 2022-05-07 Meade South Dakota 46093 7027 64
2479285 2479285 2022-05-06 Meade South Dakota 46093 7027 64
2476027 2476027 2022-05-05 Meade South Dakota 46093 7027 64
2472770 2472770 2022-05-04 Meade South Dakota 46093 7027 64
2469514 2469514 2022-05-03 Meade South Dakota 46093 7020 64
2466258 2466258 2022-05-02 Meade South Dakota 46093 7020 64
2463003 2463003 2022-05-01 Meade South Dakota 46093 7020 64
2459747 2459747 2022-04-30 Meade South Dakota 46093 7020 64
2456491 2456491 2022-04-29 Meade South Dakota 46093 7020 64
2453235 2453235 2022-04-28 Meade South Dakota 46093 7020 64
2449979 2449979 2022-04-27 Meade South Dakota 46093 7020 64
2446722 2446722 2022-04-26 Meade South Dakota 46093 7010 64
2443467 2443467 2022-04-25 Meade South Dakota 46093 7010 64
2440211 2440211 2022-04-24 Meade South Dakota 46093 7010 64
2436955 2436955 2022-04-23 Meade South Dakota 46093 7010 64
2433699 2433699 2022-04-22 Meade South Dakota 46093 7010 64
2430443 2430443 2022-04-21 Meade South Dakota 46093 7010 64
2427187 2427187 2022-04-20 Meade South Dakota 46093 7010 64
2423931 2423931 2022-04-19 Meade South Dakota 46093 7007 63
2420675 2420675 2022-04-18 Meade South Dakota 46093 7007 63
2417419 2417419 2022-04-17 Meade South Dakota 46093 7007 63
2414163 2414163 2022-04-16 Meade South Dakota 46093 7007 63
2410907 2410907 2022-04-15 Meade South Dakota 46093 7007 63
2407651 2407651 2022-04-14 Meade South Dakota 46093 7007 63
2404395 2404395 2022-04-13 Meade South Dakota 46093 7007 63
2401140 2401140 2022-04-12 Meade South Dakota 46093 7004 62
2397885 2397885 2022-04-11 Meade South Dakota 46093 7004 62
2394630 2394630 2022-04-10 Meade South Dakota 46093 7004 62
2391374 2391374 2022-04-09 Meade South Dakota 46093 7004 62
2388118 2388118 2022-04-08 Meade South Dakota 46093 7004 62
2384863 2384863 2022-04-07 Meade South Dakota 46093 7004 62
2381608 2381608 2022-04-06 Meade South Dakota 46093 7004 62
2378353 2378353 2022-04-05 Meade South Dakota 46093 6999 62
2375099 2375099 2022-04-04 Meade South Dakota 46093 6999 62
2371847 2371847 2022-04-03 Meade South Dakota 46093 6999 62
2368594 2368594 2022-04-02 Meade South Dakota 46093 6999 62
2365341 2365341 2022-04-01 Meade South Dakota 46093 6999 62
2362088 2362088 2022-03-31 Meade South Dakota 46093 6999 62
2358834 2358834 2022-03-30 Meade South Dakota 46093 6999 62
2355580 2355580 2022-03-29 Meade South Dakota 46093 6994 62
2352327 2352327 2022-03-28 Meade South Dakota 46093 6994 62
2349075 2349075 2022-03-27 Meade South Dakota 46093 6994 62
2345822 2345822 2022-03-26 Meade South Dakota 46093 6994 62
2342569 2342569 2022-03-25 Meade South Dakota 46093 6994 62
2339316 2339316 2022-03-24 Meade South Dakota 46093 6994 62
2336062 2336062 2022-03-23 Meade South Dakota 46093 6994 62
2332808 2332808 2022-03-22 Meade South Dakota 46093 6993 62
2329555 2329555 2022-03-21 Meade South Dakota 46093 6993 62
2326303 2326303 2022-03-20 Meade South Dakota 46093 6993 62
2323050 2323050 2022-03-19 Meade South Dakota 46093 6993 62
2319796 2319796 2022-03-18 Meade South Dakota 46093 6993 62
2316542 2316542 2022-03-17 Meade South Dakota 46093 6991 62
2313289 2313289 2022-03-16 Meade South Dakota 46093 6991 62
2310036 2310036 2022-03-15 Meade South Dakota 46093 6991 62
2306783 2306783 2022-03-14 Meade South Dakota 46093 6988 62
2303532 2303532 2022-03-13 Meade South Dakota 46093 6986 62
2300280 2300280 2022-03-12 Meade South Dakota 46093 6986 62
2297028 2297028 2022-03-11 Meade South Dakota 46093 6986 62
2293776 2293776 2022-03-10 Meade South Dakota 46093 6982 62
2290524 2290524 2022-03-09 Meade South Dakota 46093 6978 62
2287272 2287272 2022-03-08 Meade South Dakota 46093 6974 62
2284020 2284020 2022-03-07 Meade South Dakota 46093 6972 62
2280768 2280768 2022-03-06 Meade South Dakota 46093 6970 59
2277515 2277515 2022-03-05 Meade South Dakota 46093 6970 59
2274262 2274262 2022-03-04 Meade South Dakota 46093 6970 59
2271009 2271009 2022-03-03 Meade South Dakota 46093 6969 59
2267757 2267757 2022-03-02 Meade South Dakota 46093 6966 59
2264504 2264504 2022-03-01 Meade South Dakota 46093 6958 59
2261254 2261254 2022-02-28 Meade South Dakota 46093 6952 59
2258003 2258003 2022-02-27 Meade South Dakota 46093 6951 59
2254752 2254752 2022-02-26 Meade South Dakota 46093 6951 59
2251501 2251501 2022-02-25 Meade South Dakota 46093 6951 59
2248250 2248250 2022-02-24 Meade South Dakota 46093 6942 59
2244999 2244999 2022-02-23 Meade South Dakota 46093 6938 59
2241748 2241748 2022-02-22 Meade South Dakota 46093 6918 59
2238497 2238497 2022-02-21 Meade South Dakota 46093 6902 59
2235246 2235246 2022-02-20 Meade South Dakota 46093 6902 59
2231995 2231995 2022-02-19 Meade South Dakota 46093 6902 59
2228744 2228744 2022-02-18 Meade South Dakota 46093 6902 59
2225493 2225493 2022-02-17 Meade South Dakota 46093 6878 59
2222242 2222242 2022-02-16 Meade South Dakota 46093 6869 59
2218991 2218991 2022-02-15 Meade South Dakota 46093 6861 59
2215740 2215740 2022-02-14 Meade South Dakota 46093 6845 59
2212489 2212489 2022-02-13 Meade South Dakota 46093 6831 59
2209236 2209236 2022-02-12 Meade South Dakota 46093 6831 59
2205983 2205983 2022-02-11 Meade South Dakota 46093 6831 59
2202730 2202730 2022-02-10 Meade South Dakota 46093 6822 59
2199476 2199476 2022-02-09 Meade South Dakota 46093 6814 58
2196222 2196222 2022-02-08 Meade South Dakota 46093 6794 58
2192968 2192968 2022-02-07 Meade South Dakota 46093 6777 58
2189714 2189714 2022-02-06 Meade South Dakota 46093 6752 58
2186461 2186461 2022-02-05 Meade South Dakota 46093 6752 58
2183209 2183209 2022-02-04 Meade South Dakota 46093 6752 58
2179957 2179957 2022-02-03 Meade South Dakota 46093 6732 57

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