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 county = "Deuel" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • South Dakota · 777 ✖

fips 1

county 1

  • Deuel · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502063 2502063 2022-05-13 Deuel South Dakota 46039 1043 12
2498805 2498805 2022-05-12 Deuel South Dakota 46039 1043 12
2495547 2495547 2022-05-11 Deuel South Dakota 46039 1043 12
2492289 2492289 2022-05-10 Deuel South Dakota 46039 1042 12
2489031 2489031 2022-05-09 Deuel South Dakota 46039 1042 12
2485774 2485774 2022-05-08 Deuel South Dakota 46039 1042 12
2482516 2482516 2022-05-07 Deuel South Dakota 46039 1042 12
2479258 2479258 2022-05-06 Deuel South Dakota 46039 1042 12
2476000 2476000 2022-05-05 Deuel South Dakota 46039 1042 12
2472743 2472743 2022-05-04 Deuel South Dakota 46039 1042 12
2469487 2469487 2022-05-03 Deuel South Dakota 46039 1038 12
2466231 2466231 2022-05-02 Deuel South Dakota 46039 1038 12
2462976 2462976 2022-05-01 Deuel South Dakota 46039 1038 12
2459720 2459720 2022-04-30 Deuel South Dakota 46039 1038 12
2456464 2456464 2022-04-29 Deuel South Dakota 46039 1038 12
2453208 2453208 2022-04-28 Deuel South Dakota 46039 1038 12
2449952 2449952 2022-04-27 Deuel South Dakota 46039 1038 12
2446695 2446695 2022-04-26 Deuel South Dakota 46039 1037 12
2443440 2443440 2022-04-25 Deuel South Dakota 46039 1037 12
2440184 2440184 2022-04-24 Deuel South Dakota 46039 1037 12
2436928 2436928 2022-04-23 Deuel South Dakota 46039 1037 12
2433672 2433672 2022-04-22 Deuel South Dakota 46039 1037 12
2430416 2430416 2022-04-21 Deuel South Dakota 46039 1037 12
2427160 2427160 2022-04-20 Deuel South Dakota 46039 1037 12
2423904 2423904 2022-04-19 Deuel South Dakota 46039 1036 12
2420648 2420648 2022-04-18 Deuel South Dakota 46039 1036 12
2417392 2417392 2022-04-17 Deuel South Dakota 46039 1036 12
2414136 2414136 2022-04-16 Deuel South Dakota 46039 1036 12
2410880 2410880 2022-04-15 Deuel South Dakota 46039 1036 12
2407624 2407624 2022-04-14 Deuel South Dakota 46039 1036 12
2404368 2404368 2022-04-13 Deuel South Dakota 46039 1036 12
2401113 2401113 2022-04-12 Deuel South Dakota 46039 1035 12
2397858 2397858 2022-04-11 Deuel South Dakota 46039 1035 12
2394603 2394603 2022-04-10 Deuel South Dakota 46039 1035 12
2391347 2391347 2022-04-09 Deuel South Dakota 46039 1035 12
2388091 2388091 2022-04-08 Deuel South Dakota 46039 1035 12
2384836 2384836 2022-04-07 Deuel South Dakota 46039 1035 12
2381581 2381581 2022-04-06 Deuel South Dakota 46039 1035 12
2378326 2378326 2022-04-05 Deuel South Dakota 46039 1035 12
2375072 2375072 2022-04-04 Deuel South Dakota 46039 1035 12
2371820 2371820 2022-04-03 Deuel South Dakota 46039 1035 12
2368567 2368567 2022-04-02 Deuel South Dakota 46039 1035 12
2365314 2365314 2022-04-01 Deuel South Dakota 46039 1035 12
2362061 2362061 2022-03-31 Deuel South Dakota 46039 1035 12
2358807 2358807 2022-03-30 Deuel South Dakota 46039 1035 12
2355553 2355553 2022-03-29 Deuel South Dakota 46039 1035 12
2352300 2352300 2022-03-28 Deuel South Dakota 46039 1035 12
2349048 2349048 2022-03-27 Deuel South Dakota 46039 1035 12
2345795 2345795 2022-03-26 Deuel South Dakota 46039 1035 12
2342542 2342542 2022-03-25 Deuel South Dakota 46039 1035 12
2339289 2339289 2022-03-24 Deuel South Dakota 46039 1035 12
2336035 2336035 2022-03-23 Deuel South Dakota 46039 1035 12
2332781 2332781 2022-03-22 Deuel South Dakota 46039 1035 12
2329528 2329528 2022-03-21 Deuel South Dakota 46039 1035 12
2326276 2326276 2022-03-20 Deuel South Dakota 46039 1035 12
2323023 2323023 2022-03-19 Deuel South Dakota 46039 1035 12
2319769 2319769 2022-03-18 Deuel South Dakota 46039 1035 12
2316515 2316515 2022-03-17 Deuel South Dakota 46039 1035 12
2313262 2313262 2022-03-16 Deuel South Dakota 46039 1035 12
2310009 2310009 2022-03-15 Deuel South Dakota 46039 1035 12
2306756 2306756 2022-03-14 Deuel South Dakota 46039 1035 12
2303505 2303505 2022-03-13 Deuel South Dakota 46039 1034 12
2300253 2300253 2022-03-12 Deuel South Dakota 46039 1034 12
2297001 2297001 2022-03-11 Deuel South Dakota 46039 1034 12
2293749 2293749 2022-03-10 Deuel South Dakota 46039 1034 12
2290497 2290497 2022-03-09 Deuel South Dakota 46039 1034 12
2287245 2287245 2022-03-08 Deuel South Dakota 46039 1034 12
2283993 2283993 2022-03-07 Deuel South Dakota 46039 1034 12
2280741 2280741 2022-03-06 Deuel South Dakota 46039 1034 12
2277488 2277488 2022-03-05 Deuel South Dakota 46039 1034 12
2274235 2274235 2022-03-04 Deuel South Dakota 46039 1034 12
2270982 2270982 2022-03-03 Deuel South Dakota 46039 1035 12
2267730 2267730 2022-03-02 Deuel South Dakota 46039 1035 12
2264477 2264477 2022-03-01 Deuel South Dakota 46039 1033 12
2261227 2261227 2022-02-28 Deuel South Dakota 46039 1033 12
2257976 2257976 2022-02-27 Deuel South Dakota 46039 1033 12
2254725 2254725 2022-02-26 Deuel South Dakota 46039 1033 12
2251474 2251474 2022-02-25 Deuel South Dakota 46039 1033 12
2248223 2248223 2022-02-24 Deuel South Dakota 46039 1032 12
2244972 2244972 2022-02-23 Deuel South Dakota 46039 1032 12
2241721 2241721 2022-02-22 Deuel South Dakota 46039 1030 12
2238470 2238470 2022-02-21 Deuel South Dakota 46039 1029 12
2235219 2235219 2022-02-20 Deuel South Dakota 46039 1029 12
2231968 2231968 2022-02-19 Deuel South Dakota 46039 1029 12
2228717 2228717 2022-02-18 Deuel South Dakota 46039 1029 12
2225466 2225466 2022-02-17 Deuel South Dakota 46039 1028 12
2222215 2222215 2022-02-16 Deuel South Dakota 46039 1027 12
2218964 2218964 2022-02-15 Deuel South Dakota 46039 1026 12
2215713 2215713 2022-02-14 Deuel South Dakota 46039 1022 12
2212462 2212462 2022-02-13 Deuel South Dakota 46039 1020 12
2209209 2209209 2022-02-12 Deuel South Dakota 46039 1020 12
2205956 2205956 2022-02-11 Deuel South Dakota 46039 1020 12
2202703 2202703 2022-02-10 Deuel South Dakota 46039 1018 12
2199449 2199449 2022-02-09 Deuel South Dakota 46039 1016 12
2196195 2196195 2022-02-08 Deuel South Dakota 46039 1017 12
2192941 2192941 2022-02-07 Deuel South Dakota 46039 1015 12
2189687 2189687 2022-02-06 Deuel South Dakota 46039 1013 12
2186434 2186434 2022-02-05 Deuel South Dakota 46039 1013 12
2183182 2183182 2022-02-04 Deuel South Dakota 46039 1013 12
2179930 2179930 2022-02-03 Deuel South Dakota 46039 1011 12

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