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

776 rows where fips = 46025 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 · 776 ✖

fips 1

  • 46025 · 776 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502056 2502056 2022-05-13 Clark South Dakota 46025 804 9
2498798 2498798 2022-05-12 Clark South Dakota 46025 804 9
2495540 2495540 2022-05-11 Clark South Dakota 46025 804 9
2492282 2492282 2022-05-10 Clark South Dakota 46025 804 9
2489024 2489024 2022-05-09 Clark South Dakota 46025 804 9
2485767 2485767 2022-05-08 Clark South Dakota 46025 804 9
2482509 2482509 2022-05-07 Clark South Dakota 46025 804 9
2479251 2479251 2022-05-06 Clark South Dakota 46025 804 9
2475993 2475993 2022-05-05 Clark South Dakota 46025 804 9
2472736 2472736 2022-05-04 Clark South Dakota 46025 804 9
2469480 2469480 2022-05-03 Clark South Dakota 46025 801 9
2466224 2466224 2022-05-02 Clark South Dakota 46025 801 9
2462969 2462969 2022-05-01 Clark South Dakota 46025 801 9
2459713 2459713 2022-04-30 Clark South Dakota 46025 801 9
2456457 2456457 2022-04-29 Clark South Dakota 46025 801 9
2453201 2453201 2022-04-28 Clark South Dakota 46025 801 9
2449945 2449945 2022-04-27 Clark South Dakota 46025 801 9
2446688 2446688 2022-04-26 Clark South Dakota 46025 801 9
2443433 2443433 2022-04-25 Clark South Dakota 46025 801 9
2440177 2440177 2022-04-24 Clark South Dakota 46025 801 9
2436921 2436921 2022-04-23 Clark South Dakota 46025 801 9
2433665 2433665 2022-04-22 Clark South Dakota 46025 801 9
2430409 2430409 2022-04-21 Clark South Dakota 46025 801 9
2427153 2427153 2022-04-20 Clark South Dakota 46025 801 9
2423897 2423897 2022-04-19 Clark South Dakota 46025 800 9
2420641 2420641 2022-04-18 Clark South Dakota 46025 800 9
2417385 2417385 2022-04-17 Clark South Dakota 46025 800 9
2414129 2414129 2022-04-16 Clark South Dakota 46025 800 9
2410873 2410873 2022-04-15 Clark South Dakota 46025 800 9
2407617 2407617 2022-04-14 Clark South Dakota 46025 800 9
2404361 2404361 2022-04-13 Clark South Dakota 46025 800 9
2401106 2401106 2022-04-12 Clark South Dakota 46025 797 9
2397851 2397851 2022-04-11 Clark South Dakota 46025 797 9
2394596 2394596 2022-04-10 Clark South Dakota 46025 797 9
2391340 2391340 2022-04-09 Clark South Dakota 46025 797 9
2388084 2388084 2022-04-08 Clark South Dakota 46025 797 9
2384829 2384829 2022-04-07 Clark South Dakota 46025 797 9
2381574 2381574 2022-04-06 Clark South Dakota 46025 797 9
2378319 2378319 2022-04-05 Clark South Dakota 46025 794 9
2375065 2375065 2022-04-04 Clark South Dakota 46025 794 9
2371813 2371813 2022-04-03 Clark South Dakota 46025 794 9
2368560 2368560 2022-04-02 Clark South Dakota 46025 794 9
2365307 2365307 2022-04-01 Clark South Dakota 46025 794 9
2362054 2362054 2022-03-31 Clark South Dakota 46025 794 9
2358800 2358800 2022-03-30 Clark South Dakota 46025 794 9
2355546 2355546 2022-03-29 Clark South Dakota 46025 789 9
2352293 2352293 2022-03-28 Clark South Dakota 46025 789 9
2349041 2349041 2022-03-27 Clark South Dakota 46025 789 9
2345788 2345788 2022-03-26 Clark South Dakota 46025 789 9
2342535 2342535 2022-03-25 Clark South Dakota 46025 789 9
2339282 2339282 2022-03-24 Clark South Dakota 46025 789 9
2336028 2336028 2022-03-23 Clark South Dakota 46025 789 9
2332774 2332774 2022-03-22 Clark South Dakota 46025 789 9
2329521 2329521 2022-03-21 Clark South Dakota 46025 789 9
2326269 2326269 2022-03-20 Clark South Dakota 46025 789 9
2323016 2323016 2022-03-19 Clark South Dakota 46025 789 9
2319762 2319762 2022-03-18 Clark South Dakota 46025 789 9
2316508 2316508 2022-03-17 Clark South Dakota 46025 789 9
2313255 2313255 2022-03-16 Clark South Dakota 46025 789 9
2310002 2310002 2022-03-15 Clark South Dakota 46025 787 9
2306749 2306749 2022-03-14 Clark South Dakota 46025 786 9
2303498 2303498 2022-03-13 Clark South Dakota 46025 786 9
2300246 2300246 2022-03-12 Clark South Dakota 46025 786 9
2296994 2296994 2022-03-11 Clark South Dakota 46025 786 9
2293742 2293742 2022-03-10 Clark South Dakota 46025 786 8
2290490 2290490 2022-03-09 Clark South Dakota 46025 785 8
2287238 2287238 2022-03-08 Clark South Dakota 46025 784 8
2283986 2283986 2022-03-07 Clark South Dakota 46025 784 8
2280734 2280734 2022-03-06 Clark South Dakota 46025 784 8
2277481 2277481 2022-03-05 Clark South Dakota 46025 784 8
2274228 2274228 2022-03-04 Clark South Dakota 46025 784 8
2270975 2270975 2022-03-03 Clark South Dakota 46025 784 8
2267723 2267723 2022-03-02 Clark South Dakota 46025 784 8
2264470 2264470 2022-03-01 Clark South Dakota 46025 784 8
2261220 2261220 2022-02-28 Clark South Dakota 46025 785 8
2257969 2257969 2022-02-27 Clark South Dakota 46025 784 8
2254718 2254718 2022-02-26 Clark South Dakota 46025 784 8
2251467 2251467 2022-02-25 Clark South Dakota 46025 784 8
2248216 2248216 2022-02-24 Clark South Dakota 46025 782 8
2244965 2244965 2022-02-23 Clark South Dakota 46025 781 8
2241714 2241714 2022-02-22 Clark South Dakota 46025 779 8
2238463 2238463 2022-02-21 Clark South Dakota 46025 778 8
2235212 2235212 2022-02-20 Clark South Dakota 46025 778 8
2231961 2231961 2022-02-19 Clark South Dakota 46025 778 8
2228710 2228710 2022-02-18 Clark South Dakota 46025 778 8
2225459 2225459 2022-02-17 Clark South Dakota 46025 777 8
2222208 2222208 2022-02-16 Clark South Dakota 46025 774 8
2218957 2218957 2022-02-15 Clark South Dakota 46025 773 8
2215706 2215706 2022-02-14 Clark South Dakota 46025 772 8
2212455 2212455 2022-02-13 Clark South Dakota 46025 770 8
2209202 2209202 2022-02-12 Clark South Dakota 46025 770 8
2205949 2205949 2022-02-11 Clark South Dakota 46025 770 8
2202696 2202696 2022-02-10 Clark South Dakota 46025 769 8
2199442 2199442 2022-02-09 Clark South Dakota 46025 768 8
2196188 2196188 2022-02-08 Clark South Dakota 46025 765 8
2192934 2192934 2022-02-07 Clark South Dakota 46025 764 6
2189680 2189680 2022-02-06 Clark South Dakota 46025 762 6
2186427 2186427 2022-02-05 Clark South Dakota 46025 762 6
2183175 2183175 2022-02-04 Clark South Dakota 46025 762 6
2179923 2179923 2022-02-03 Clark South Dakota 46025 761 6

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