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 = 46125 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 · 776 ✖

fips 1

  • 46125 · 776 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502106 2502106 2022-05-13 Turner South Dakota 46125 1969 62
2498848 2498848 2022-05-12 Turner South Dakota 46125 1969 62
2495590 2495590 2022-05-11 Turner South Dakota 46125 1969 62
2492332 2492332 2022-05-10 Turner South Dakota 46125 1967 62
2489074 2489074 2022-05-09 Turner South Dakota 46125 1967 62
2485817 2485817 2022-05-08 Turner South Dakota 46125 1967 62
2482559 2482559 2022-05-07 Turner South Dakota 46125 1967 62
2479301 2479301 2022-05-06 Turner South Dakota 46125 1967 62
2476043 2476043 2022-05-05 Turner South Dakota 46125 1967 62
2472786 2472786 2022-05-04 Turner South Dakota 46125 1967 62
2469530 2469530 2022-05-03 Turner South Dakota 46125 1966 62
2466274 2466274 2022-05-02 Turner South Dakota 46125 1966 62
2463019 2463019 2022-05-01 Turner South Dakota 46125 1966 62
2459763 2459763 2022-04-30 Turner South Dakota 46125 1966 62
2456507 2456507 2022-04-29 Turner South Dakota 46125 1966 62
2453251 2453251 2022-04-28 Turner South Dakota 46125 1966 62
2449995 2449995 2022-04-27 Turner South Dakota 46125 1966 62
2446738 2446738 2022-04-26 Turner South Dakota 46125 1965 62
2443483 2443483 2022-04-25 Turner South Dakota 46125 1965 62
2440227 2440227 2022-04-24 Turner South Dakota 46125 1965 62
2436971 2436971 2022-04-23 Turner South Dakota 46125 1965 62
2433715 2433715 2022-04-22 Turner South Dakota 46125 1965 62
2430459 2430459 2022-04-21 Turner South Dakota 46125 1965 62
2427203 2427203 2022-04-20 Turner South Dakota 46125 1965 62
2423947 2423947 2022-04-19 Turner South Dakota 46125 1964 62
2420691 2420691 2022-04-18 Turner South Dakota 46125 1964 62
2417435 2417435 2022-04-17 Turner South Dakota 46125 1964 62
2414179 2414179 2022-04-16 Turner South Dakota 46125 1964 62
2410923 2410923 2022-04-15 Turner South Dakota 46125 1964 62
2407667 2407667 2022-04-14 Turner South Dakota 46125 1964 62
2404411 2404411 2022-04-13 Turner South Dakota 46125 1964 62
2401156 2401156 2022-04-12 Turner South Dakota 46125 1964 62
2397901 2397901 2022-04-11 Turner South Dakota 46125 1964 62
2394646 2394646 2022-04-10 Turner South Dakota 46125 1964 62
2391390 2391390 2022-04-09 Turner South Dakota 46125 1964 62
2388134 2388134 2022-04-08 Turner South Dakota 46125 1964 62
2384879 2384879 2022-04-07 Turner South Dakota 46125 1964 62
2381624 2381624 2022-04-06 Turner South Dakota 46125 1964 62
2378369 2378369 2022-04-05 Turner South Dakota 46125 1963 62
2375115 2375115 2022-04-04 Turner South Dakota 46125 1963 62
2371863 2371863 2022-04-03 Turner South Dakota 46125 1963 62
2368610 2368610 2022-04-02 Turner South Dakota 46125 1963 62
2365357 2365357 2022-04-01 Turner South Dakota 46125 1963 62
2362104 2362104 2022-03-31 Turner South Dakota 46125 1963 62
2358850 2358850 2022-03-30 Turner South Dakota 46125 1963 62
2355596 2355596 2022-03-29 Turner South Dakota 46125 1962 62
2352343 2352343 2022-03-28 Turner South Dakota 46125 1962 62
2349091 2349091 2022-03-27 Turner South Dakota 46125 1962 62
2345838 2345838 2022-03-26 Turner South Dakota 46125 1962 62
2342585 2342585 2022-03-25 Turner South Dakota 46125 1962 62
2339332 2339332 2022-03-24 Turner South Dakota 46125 1962 62
2336078 2336078 2022-03-23 Turner South Dakota 46125 1962 62
2332824 2332824 2022-03-22 Turner South Dakota 46125 1959 62
2329571 2329571 2022-03-21 Turner South Dakota 46125 1959 62
2326319 2326319 2022-03-20 Turner South Dakota 46125 1959 62
2323066 2323066 2022-03-19 Turner South Dakota 46125 1959 62
2319812 2319812 2022-03-18 Turner South Dakota 46125 1959 62
2316558 2316558 2022-03-17 Turner South Dakota 46125 1958 62
2313305 2313305 2022-03-16 Turner South Dakota 46125 1959 62
2310052 2310052 2022-03-15 Turner South Dakota 46125 1959 62
2306799 2306799 2022-03-14 Turner South Dakota 46125 1958 62
2303548 2303548 2022-03-13 Turner South Dakota 46125 1958 62
2300296 2300296 2022-03-12 Turner South Dakota 46125 1958 62
2297044 2297044 2022-03-11 Turner South Dakota 46125 1958 62
2293792 2293792 2022-03-10 Turner South Dakota 46125 1957 62
2290540 2290540 2022-03-09 Turner South Dakota 46125 1957 62
2287288 2287288 2022-03-08 Turner South Dakota 46125 1957 62
2284036 2284036 2022-03-07 Turner South Dakota 46125 1957 62
2280784 2280784 2022-03-06 Turner South Dakota 46125 1957 62
2277531 2277531 2022-03-05 Turner South Dakota 46125 1957 62
2274278 2274278 2022-03-04 Turner South Dakota 46125 1957 62
2271025 2271025 2022-03-03 Turner South Dakota 46125 1957 62
2267773 2267773 2022-03-02 Turner South Dakota 46125 1957 62
2264520 2264520 2022-03-01 Turner South Dakota 46125 1956 62
2261270 2261270 2022-02-28 Turner South Dakota 46125 1956 62
2258019 2258019 2022-02-27 Turner South Dakota 46125 1954 62
2254768 2254768 2022-02-26 Turner South Dakota 46125 1954 62
2251517 2251517 2022-02-25 Turner South Dakota 46125 1954 62
2248266 2248266 2022-02-24 Turner South Dakota 46125 1953 62
2245015 2245015 2022-02-23 Turner South Dakota 46125 1953 62
2241764 2241764 2022-02-22 Turner South Dakota 46125 1950 62
2238513 2238513 2022-02-21 Turner South Dakota 46125 1948 62
2235262 2235262 2022-02-20 Turner South Dakota 46125 1948 62
2232011 2232011 2022-02-19 Turner South Dakota 46125 1948 62
2228760 2228760 2022-02-18 Turner South Dakota 46125 1948 62
2225509 2225509 2022-02-17 Turner South Dakota 46125 1947 62
2222258 2222258 2022-02-16 Turner South Dakota 46125 1947 62
2219007 2219007 2022-02-15 Turner South Dakota 46125 1944 62
2215756 2215756 2022-02-14 Turner South Dakota 46125 1943 62
2212505 2212505 2022-02-13 Turner South Dakota 46125 1939 62
2209252 2209252 2022-02-12 Turner South Dakota 46125 1939 62
2205999 2205999 2022-02-11 Turner South Dakota 46125 1939 62
2202746 2202746 2022-02-10 Turner South Dakota 46125 1939 62
2199492 2199492 2022-02-09 Turner South Dakota 46125 1935 62
2196238 2196238 2022-02-08 Turner South Dakota 46125 1930 62
2192984 2192984 2022-02-07 Turner South Dakota 46125 1929 62
2189730 2189730 2022-02-06 Turner South Dakota 46125 1930 62
2186477 2186477 2022-02-05 Turner South Dakota 46125 1930 62
2183225 2183225 2022-02-04 Turner South Dakota 46125 1930 62
2179973 2179973 2022-02-03 Turner South Dakota 46125 1926 62

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