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

782 rows where fips = 46085 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 · 782 ✖

fips 1

  • 46085 · 782 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502086 2502086 2022-05-13 Lyman South Dakota 46085 1205 12
2498828 2498828 2022-05-12 Lyman South Dakota 46085 1205 12
2495570 2495570 2022-05-11 Lyman South Dakota 46085 1205 12
2492312 2492312 2022-05-10 Lyman South Dakota 46085 1203 12
2489054 2489054 2022-05-09 Lyman South Dakota 46085 1203 12
2485797 2485797 2022-05-08 Lyman South Dakota 46085 1203 12
2482539 2482539 2022-05-07 Lyman South Dakota 46085 1203 12
2479281 2479281 2022-05-06 Lyman South Dakota 46085 1203 12
2476023 2476023 2022-05-05 Lyman South Dakota 46085 1203 12
2472766 2472766 2022-05-04 Lyman South Dakota 46085 1203 12
2469510 2469510 2022-05-03 Lyman South Dakota 46085 1203 12
2466254 2466254 2022-05-02 Lyman South Dakota 46085 1203 12
2462999 2462999 2022-05-01 Lyman South Dakota 46085 1203 12
2459743 2459743 2022-04-30 Lyman South Dakota 46085 1203 12
2456487 2456487 2022-04-29 Lyman South Dakota 46085 1203 12
2453231 2453231 2022-04-28 Lyman South Dakota 46085 1203 12
2449975 2449975 2022-04-27 Lyman South Dakota 46085 1203 12
2446718 2446718 2022-04-26 Lyman South Dakota 46085 1203 12
2443463 2443463 2022-04-25 Lyman South Dakota 46085 1203 12
2440207 2440207 2022-04-24 Lyman South Dakota 46085 1203 12
2436951 2436951 2022-04-23 Lyman South Dakota 46085 1203 12
2433695 2433695 2022-04-22 Lyman South Dakota 46085 1203 12
2430439 2430439 2022-04-21 Lyman South Dakota 46085 1203 12
2427183 2427183 2022-04-20 Lyman South Dakota 46085 1203 12
2423927 2423927 2022-04-19 Lyman South Dakota 46085 1203 12
2420671 2420671 2022-04-18 Lyman South Dakota 46085 1203 12
2417415 2417415 2022-04-17 Lyman South Dakota 46085 1203 12
2414159 2414159 2022-04-16 Lyman South Dakota 46085 1203 12
2410903 2410903 2022-04-15 Lyman South Dakota 46085 1203 12
2407647 2407647 2022-04-14 Lyman South Dakota 46085 1203 12
2404391 2404391 2022-04-13 Lyman South Dakota 46085 1203 12
2401136 2401136 2022-04-12 Lyman South Dakota 46085 1203 12
2397881 2397881 2022-04-11 Lyman South Dakota 46085 1203 12
2394626 2394626 2022-04-10 Lyman South Dakota 46085 1203 12
2391370 2391370 2022-04-09 Lyman South Dakota 46085 1203 12
2388114 2388114 2022-04-08 Lyman South Dakota 46085 1203 12
2384859 2384859 2022-04-07 Lyman South Dakota 46085 1203 12
2381604 2381604 2022-04-06 Lyman South Dakota 46085 1203 12
2378349 2378349 2022-04-05 Lyman South Dakota 46085 1203 12
2375095 2375095 2022-04-04 Lyman South Dakota 46085 1203 12
2371843 2371843 2022-04-03 Lyman South Dakota 46085 1203 12
2368590 2368590 2022-04-02 Lyman South Dakota 46085 1203 12
2365337 2365337 2022-04-01 Lyman South Dakota 46085 1203 12
2362084 2362084 2022-03-31 Lyman South Dakota 46085 1203 12
2358830 2358830 2022-03-30 Lyman South Dakota 46085 1203 12
2355576 2355576 2022-03-29 Lyman South Dakota 46085 1203 12
2352323 2352323 2022-03-28 Lyman South Dakota 46085 1203 12
2349071 2349071 2022-03-27 Lyman South Dakota 46085 1203 12
2345818 2345818 2022-03-26 Lyman South Dakota 46085 1203 12
2342565 2342565 2022-03-25 Lyman South Dakota 46085 1203 12
2339312 2339312 2022-03-24 Lyman South Dakota 46085 1203 12
2336058 2336058 2022-03-23 Lyman South Dakota 46085 1203 12
2332804 2332804 2022-03-22 Lyman South Dakota 46085 1203 12
2329551 2329551 2022-03-21 Lyman South Dakota 46085 1203 12
2326299 2326299 2022-03-20 Lyman South Dakota 46085 1203 12
2323046 2323046 2022-03-19 Lyman South Dakota 46085 1203 12
2319792 2319792 2022-03-18 Lyman South Dakota 46085 1203 12
2316538 2316538 2022-03-17 Lyman South Dakota 46085 1203 12
2313285 2313285 2022-03-16 Lyman South Dakota 46085 1203 12
2310032 2310032 2022-03-15 Lyman South Dakota 46085 1203 12
2306779 2306779 2022-03-14 Lyman South Dakota 46085 1203 12
2303528 2303528 2022-03-13 Lyman South Dakota 46085 1203 12
2300276 2300276 2022-03-12 Lyman South Dakota 46085 1203 12
2297024 2297024 2022-03-11 Lyman South Dakota 46085 1203 12
2293772 2293772 2022-03-10 Lyman South Dakota 46085 1203 12
2290520 2290520 2022-03-09 Lyman South Dakota 46085 1203 12
2287268 2287268 2022-03-08 Lyman South Dakota 46085 1203 12
2284016 2284016 2022-03-07 Lyman South Dakota 46085 1203 12
2280764 2280764 2022-03-06 Lyman South Dakota 46085 1203 12
2277511 2277511 2022-03-05 Lyman South Dakota 46085 1203 12
2274258 2274258 2022-03-04 Lyman South Dakota 46085 1203 12
2271005 2271005 2022-03-03 Lyman South Dakota 46085 1203 12
2267753 2267753 2022-03-02 Lyman South Dakota 46085 1203 12
2264500 2264500 2022-03-01 Lyman South Dakota 46085 1203 12
2261250 2261250 2022-02-28 Lyman South Dakota 46085 1204 12
2257999 2257999 2022-02-27 Lyman South Dakota 46085 1204 12
2254748 2254748 2022-02-26 Lyman South Dakota 46085 1204 12
2251497 2251497 2022-02-25 Lyman South Dakota 46085 1204 12
2248246 2248246 2022-02-24 Lyman South Dakota 46085 1203 12
2244995 2244995 2022-02-23 Lyman South Dakota 46085 1203 12
2241744 2241744 2022-02-22 Lyman South Dakota 46085 1199 12
2238493 2238493 2022-02-21 Lyman South Dakota 46085 1199 12
2235242 2235242 2022-02-20 Lyman South Dakota 46085 1199 12
2231991 2231991 2022-02-19 Lyman South Dakota 46085 1199 12
2228740 2228740 2022-02-18 Lyman South Dakota 46085 1199 12
2225489 2225489 2022-02-17 Lyman South Dakota 46085 1197 12
2222238 2222238 2022-02-16 Lyman South Dakota 46085 1195 12
2218987 2218987 2022-02-15 Lyman South Dakota 46085 1193 12
2215736 2215736 2022-02-14 Lyman South Dakota 46085 1192 12
2212485 2212485 2022-02-13 Lyman South Dakota 46085 1191 12
2209232 2209232 2022-02-12 Lyman South Dakota 46085 1191 12
2205979 2205979 2022-02-11 Lyman South Dakota 46085 1191 12
2202726 2202726 2022-02-10 Lyman South Dakota 46085 1188 12
2199472 2199472 2022-02-09 Lyman South Dakota 46085 1187 12
2196218 2196218 2022-02-08 Lyman South Dakota 46085 1184 12
2192964 2192964 2022-02-07 Lyman South Dakota 46085 1182 12
2189710 2189710 2022-02-06 Lyman South Dakota 46085 1181 12
2186457 2186457 2022-02-05 Lyman South Dakota 46085 1181 12
2183205 2183205 2022-02-04 Lyman South Dakota 46085 1181 12
2179953 2179953 2022-02-03 Lyman South Dakota 46085 1176 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);