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

795 rows where fips = 46035 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 · 795 ✖

fips 1

  • 46035 · 795 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502061 2502061 2022-05-13 Davison South Dakota 46035 5907 80
2498803 2498803 2022-05-12 Davison South Dakota 46035 5907 80
2495545 2495545 2022-05-11 Davison South Dakota 46035 5907 80
2492287 2492287 2022-05-10 Davison South Dakota 46035 5897 79
2489029 2489029 2022-05-09 Davison South Dakota 46035 5897 79
2485772 2485772 2022-05-08 Davison South Dakota 46035 5897 79
2482514 2482514 2022-05-07 Davison South Dakota 46035 5897 79
2479256 2479256 2022-05-06 Davison South Dakota 46035 5897 79
2475998 2475998 2022-05-05 Davison South Dakota 46035 5897 79
2472741 2472741 2022-05-04 Davison South Dakota 46035 5897 79
2469485 2469485 2022-05-03 Davison South Dakota 46035 5893 79
2466229 2466229 2022-05-02 Davison South Dakota 46035 5893 79
2462974 2462974 2022-05-01 Davison South Dakota 46035 5893 79
2459718 2459718 2022-04-30 Davison South Dakota 46035 5893 79
2456462 2456462 2022-04-29 Davison South Dakota 46035 5893 79
2453206 2453206 2022-04-28 Davison South Dakota 46035 5893 79
2449950 2449950 2022-04-27 Davison South Dakota 46035 5893 79
2446693 2446693 2022-04-26 Davison South Dakota 46035 5890 79
2443438 2443438 2022-04-25 Davison South Dakota 46035 5890 79
2440182 2440182 2022-04-24 Davison South Dakota 46035 5890 79
2436926 2436926 2022-04-23 Davison South Dakota 46035 5890 79
2433670 2433670 2022-04-22 Davison South Dakota 46035 5890 79
2430414 2430414 2022-04-21 Davison South Dakota 46035 5890 79
2427158 2427158 2022-04-20 Davison South Dakota 46035 5890 79
2423902 2423902 2022-04-19 Davison South Dakota 46035 5887 79
2420646 2420646 2022-04-18 Davison South Dakota 46035 5887 79
2417390 2417390 2022-04-17 Davison South Dakota 46035 5887 79
2414134 2414134 2022-04-16 Davison South Dakota 46035 5887 79
2410878 2410878 2022-04-15 Davison South Dakota 46035 5887 79
2407622 2407622 2022-04-14 Davison South Dakota 46035 5887 79
2404366 2404366 2022-04-13 Davison South Dakota 46035 5887 79
2401111 2401111 2022-04-12 Davison South Dakota 46035 5880 78
2397856 2397856 2022-04-11 Davison South Dakota 46035 5880 78
2394601 2394601 2022-04-10 Davison South Dakota 46035 5880 78
2391345 2391345 2022-04-09 Davison South Dakota 46035 5880 78
2388089 2388089 2022-04-08 Davison South Dakota 46035 5880 78
2384834 2384834 2022-04-07 Davison South Dakota 46035 5880 78
2381579 2381579 2022-04-06 Davison South Dakota 46035 5880 78
2378324 2378324 2022-04-05 Davison South Dakota 46035 5874 78
2375070 2375070 2022-04-04 Davison South Dakota 46035 5874 78
2371818 2371818 2022-04-03 Davison South Dakota 46035 5874 78
2368565 2368565 2022-04-02 Davison South Dakota 46035 5874 78
2365312 2365312 2022-04-01 Davison South Dakota 46035 5874 78
2362059 2362059 2022-03-31 Davison South Dakota 46035 5874 78
2358805 2358805 2022-03-30 Davison South Dakota 46035 5874 78
2355551 2355551 2022-03-29 Davison South Dakota 46035 5867 78
2352298 2352298 2022-03-28 Davison South Dakota 46035 5867 78
2349046 2349046 2022-03-27 Davison South Dakota 46035 5867 78
2345793 2345793 2022-03-26 Davison South Dakota 46035 5867 78
2342540 2342540 2022-03-25 Davison South Dakota 46035 5867 78
2339287 2339287 2022-03-24 Davison South Dakota 46035 5867 78
2336033 2336033 2022-03-23 Davison South Dakota 46035 5867 78
2332779 2332779 2022-03-22 Davison South Dakota 46035 5861 78
2329526 2329526 2022-03-21 Davison South Dakota 46035 5861 78
2326274 2326274 2022-03-20 Davison South Dakota 46035 5861 78
2323021 2323021 2022-03-19 Davison South Dakota 46035 5861 78
2319767 2319767 2022-03-18 Davison South Dakota 46035 5861 78
2316513 2316513 2022-03-17 Davison South Dakota 46035 5858 78
2313260 2313260 2022-03-16 Davison South Dakota 46035 5859 78
2310007 2310007 2022-03-15 Davison South Dakota 46035 5858 78
2306754 2306754 2022-03-14 Davison South Dakota 46035 5852 78
2303503 2303503 2022-03-13 Davison South Dakota 46035 5849 78
2300251 2300251 2022-03-12 Davison South Dakota 46035 5849 78
2296999 2296999 2022-03-11 Davison South Dakota 46035 5849 78
2293747 2293747 2022-03-10 Davison South Dakota 46035 5848 78
2290495 2290495 2022-03-09 Davison South Dakota 46035 5846 78
2287243 2287243 2022-03-08 Davison South Dakota 46035 5846 78
2283991 2283991 2022-03-07 Davison South Dakota 46035 5845 78
2280739 2280739 2022-03-06 Davison South Dakota 46035 5845 78
2277486 2277486 2022-03-05 Davison South Dakota 46035 5845 78
2274233 2274233 2022-03-04 Davison South Dakota 46035 5845 78
2270980 2270980 2022-03-03 Davison South Dakota 46035 5846 78
2267728 2267728 2022-03-02 Davison South Dakota 46035 5844 78
2264475 2264475 2022-03-01 Davison South Dakota 46035 5840 78
2261225 2261225 2022-02-28 Davison South Dakota 46035 5837 78
2257974 2257974 2022-02-27 Davison South Dakota 46035 5834 78
2254723 2254723 2022-02-26 Davison South Dakota 46035 5834 78
2251472 2251472 2022-02-25 Davison South Dakota 46035 5834 78
2248221 2248221 2022-02-24 Davison South Dakota 46035 5827 78
2244970 2244970 2022-02-23 Davison South Dakota 46035 5822 78
2241719 2241719 2022-02-22 Davison South Dakota 46035 5816 78
2238468 2238468 2022-02-21 Davison South Dakota 46035 5813 78
2235217 2235217 2022-02-20 Davison South Dakota 46035 5813 78
2231966 2231966 2022-02-19 Davison South Dakota 46035 5813 78
2228715 2228715 2022-02-18 Davison South Dakota 46035 5813 78
2225464 2225464 2022-02-17 Davison South Dakota 46035 5813 78
2222213 2222213 2022-02-16 Davison South Dakota 46035 5808 78
2218962 2218962 2022-02-15 Davison South Dakota 46035 5806 78
2215711 2215711 2022-02-14 Davison South Dakota 46035 5797 78
2212460 2212460 2022-02-13 Davison South Dakota 46035 5796 79
2209207 2209207 2022-02-12 Davison South Dakota 46035 5796 79
2205954 2205954 2022-02-11 Davison South Dakota 46035 5796 79
2202701 2202701 2022-02-10 Davison South Dakota 46035 5787 79
2199447 2199447 2022-02-09 Davison South Dakota 46035 5770 79
2196193 2196193 2022-02-08 Davison South Dakota 46035 5758 79
2192939 2192939 2022-02-07 Davison South Dakota 46035 5739 79
2189685 2189685 2022-02-06 Davison South Dakota 46035 5732 79
2186432 2186432 2022-02-05 Davison South Dakota 46035 5732 79
2183180 2183180 2022-02-04 Davison South Dakota 46035 5732 79
2179928 2179928 2022-02-03 Davison South Dakota 46035 5713 79

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