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

660 rows where fips = 46107 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 · 660 ✖

fips 1

  • 46107 · 660 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502098 2502098 2022-05-13 Potter South Dakota 46107 703 7
2498840 2498840 2022-05-12 Potter South Dakota 46107 703 7
2495582 2495582 2022-05-11 Potter South Dakota 46107 703 7
2492324 2492324 2022-05-10 Potter South Dakota 46107 704 7
2489066 2489066 2022-05-09 Potter South Dakota 46107 704 7
2485809 2485809 2022-05-08 Potter South Dakota 46107 704 7
2482551 2482551 2022-05-07 Potter South Dakota 46107 704 7
2479293 2479293 2022-05-06 Potter South Dakota 46107 704 7
2476035 2476035 2022-05-05 Potter South Dakota 46107 704 7
2472778 2472778 2022-05-04 Potter South Dakota 46107 704 7
2469522 2469522 2022-05-03 Potter South Dakota 46107 703 7
2466266 2466266 2022-05-02 Potter South Dakota 46107 703 7
2463011 2463011 2022-05-01 Potter South Dakota 46107 703 7
2459755 2459755 2022-04-30 Potter South Dakota 46107 703 7
2456499 2456499 2022-04-29 Potter South Dakota 46107 703 7
2453243 2453243 2022-04-28 Potter South Dakota 46107 703 7
2449987 2449987 2022-04-27 Potter South Dakota 46107 703 7
2446730 2446730 2022-04-26 Potter South Dakota 46107 703 7
2443475 2443475 2022-04-25 Potter South Dakota 46107 703 7
2440219 2440219 2022-04-24 Potter South Dakota 46107 703 7
2436963 2436963 2022-04-23 Potter South Dakota 46107 703 7
2433707 2433707 2022-04-22 Potter South Dakota 46107 703 7
2430451 2430451 2022-04-21 Potter South Dakota 46107 703 7
2427195 2427195 2022-04-20 Potter South Dakota 46107 703 7
2423939 2423939 2022-04-19 Potter South Dakota 46107 704 7
2420683 2420683 2022-04-18 Potter South Dakota 46107 704 7
2417427 2417427 2022-04-17 Potter South Dakota 46107 704 7
2414171 2414171 2022-04-16 Potter South Dakota 46107 704 7
2410915 2410915 2022-04-15 Potter South Dakota 46107 704 7
2407659 2407659 2022-04-14 Potter South Dakota 46107 704 7
2404403 2404403 2022-04-13 Potter South Dakota 46107 704 7
2401148 2401148 2022-04-12 Potter South Dakota 46107 704 7
2397893 2397893 2022-04-11 Potter South Dakota 46107 704 7
2394638 2394638 2022-04-10 Potter South Dakota 46107 704 7
2391382 2391382 2022-04-09 Potter South Dakota 46107 704 7
2388126 2388126 2022-04-08 Potter South Dakota 46107 704 7
2384871 2384871 2022-04-07 Potter South Dakota 46107 704 7
2381616 2381616 2022-04-06 Potter South Dakota 46107 704 7
2378361 2378361 2022-04-05 Potter South Dakota 46107 704 7
2375107 2375107 2022-04-04 Potter South Dakota 46107 704 7
2371855 2371855 2022-04-03 Potter South Dakota 46107 704 7
2368602 2368602 2022-04-02 Potter South Dakota 46107 704 7
2365349 2365349 2022-04-01 Potter South Dakota 46107 704 7
2362096 2362096 2022-03-31 Potter South Dakota 46107 704 7
2358842 2358842 2022-03-30 Potter South Dakota 46107 704 7
2355588 2355588 2022-03-29 Potter South Dakota 46107 704 7
2352335 2352335 2022-03-28 Potter South Dakota 46107 704 7
2349083 2349083 2022-03-27 Potter South Dakota 46107 704 7
2345830 2345830 2022-03-26 Potter South Dakota 46107 704 7
2342577 2342577 2022-03-25 Potter South Dakota 46107 704 7
2339324 2339324 2022-03-24 Potter South Dakota 46107 704 7
2336070 2336070 2022-03-23 Potter South Dakota 46107 704 7
2332816 2332816 2022-03-22 Potter South Dakota 46107 704 7
2329563 2329563 2022-03-21 Potter South Dakota 46107 704 7
2326311 2326311 2022-03-20 Potter South Dakota 46107 704 7
2323058 2323058 2022-03-19 Potter South Dakota 46107 704 7
2319804 2319804 2022-03-18 Potter South Dakota 46107 704 7
2316550 2316550 2022-03-17 Potter South Dakota 46107 704 7
2313297 2313297 2022-03-16 Potter South Dakota 46107 704 7
2310044 2310044 2022-03-15 Potter South Dakota 46107 704 7
2306791 2306791 2022-03-14 Potter South Dakota 46107 700 7
2303540 2303540 2022-03-13 Potter South Dakota 46107 699 7
2300288 2300288 2022-03-12 Potter South Dakota 46107 699 7
2297036 2297036 2022-03-11 Potter South Dakota 46107 699 7
2293784 2293784 2022-03-10 Potter South Dakota 46107 699 7
2290532 2290532 2022-03-09 Potter South Dakota 46107 698 7
2287280 2287280 2022-03-08 Potter South Dakota 46107 697 7
2284028 2284028 2022-03-07 Potter South Dakota 46107 697 7
2280776 2280776 2022-03-06 Potter South Dakota 46107 696 7
2277523 2277523 2022-03-05 Potter South Dakota 46107 696 7
2274270 2274270 2022-03-04 Potter South Dakota 46107 696 7
2271017 2271017 2022-03-03 Potter South Dakota 46107 696 7
2267765 2267765 2022-03-02 Potter South Dakota 46107 694 7
2264512 2264512 2022-03-01 Potter South Dakota 46107 693 7
2261262 2261262 2022-02-28 Potter South Dakota 46107 692 7
2258011 2258011 2022-02-27 Potter South Dakota 46107 692 7
2254760 2254760 2022-02-26 Potter South Dakota 46107 692 7
2251509 2251509 2022-02-25 Potter South Dakota 46107 692 7
2248258 2248258 2022-02-24 Potter South Dakota 46107 692 7
2245007 2245007 2022-02-23 Potter South Dakota 46107 690 7
2241756 2241756 2022-02-22 Potter South Dakota 46107 690 7
2238505 2238505 2022-02-21 Potter South Dakota 46107 690 7
2235254 2235254 2022-02-20 Potter South Dakota 46107 690 7
2232003 2232003 2022-02-19 Potter South Dakota 46107 690 7
2228752 2228752 2022-02-18 Potter South Dakota 46107 690 7
2225501 2225501 2022-02-17 Potter South Dakota 46107 689 7
2222250 2222250 2022-02-16 Potter South Dakota 46107 687 7
2218999 2218999 2022-02-15 Potter South Dakota 46107 687 7
2215748 2215748 2022-02-14 Potter South Dakota 46107 685 7
2212497 2212497 2022-02-13 Potter South Dakota 46107 683 7
2209244 2209244 2022-02-12 Potter South Dakota 46107 683 7
2205991 2205991 2022-02-11 Potter South Dakota 46107 683 7
2202738 2202738 2022-02-10 Potter South Dakota 46107 683 7
2199484 2199484 2022-02-09 Potter South Dakota 46107 679 7
2196230 2196230 2022-02-08 Potter South Dakota 46107 678 7
2192976 2192976 2022-02-07 Potter South Dakota 46107 677 7
2189722 2189722 2022-02-06 Potter South Dakota 46107 675 7
2186469 2186469 2022-02-05 Potter South Dakota 46107 675 7
2183217 2183217 2022-02-04 Potter South Dakota 46107 675 7
2179965 2179965 2022-02-03 Potter South Dakota 46107 672 7

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