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

794 rows where fips = 46009 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 · 794 ✖

fips 1

  • 46009 · 794 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502048 2502048 2022-05-13 Bon Homme South Dakota 46009 2292 39
2498790 2498790 2022-05-12 Bon Homme South Dakota 46009 2292 39
2495532 2495532 2022-05-11 Bon Homme South Dakota 46009 2292 39
2492274 2492274 2022-05-10 Bon Homme South Dakota 46009 2293 39
2489016 2489016 2022-05-09 Bon Homme South Dakota 46009 2293 39
2485759 2485759 2022-05-08 Bon Homme South Dakota 46009 2293 39
2482501 2482501 2022-05-07 Bon Homme South Dakota 46009 2293 39
2479243 2479243 2022-05-06 Bon Homme South Dakota 46009 2293 39
2475985 2475985 2022-05-05 Bon Homme South Dakota 46009 2293 39
2472728 2472728 2022-05-04 Bon Homme South Dakota 46009 2293 39
2469472 2469472 2022-05-03 Bon Homme South Dakota 46009 2291 39
2466216 2466216 2022-05-02 Bon Homme South Dakota 46009 2291 39
2462961 2462961 2022-05-01 Bon Homme South Dakota 46009 2291 39
2459705 2459705 2022-04-30 Bon Homme South Dakota 46009 2291 39
2456449 2456449 2022-04-29 Bon Homme South Dakota 46009 2291 39
2453193 2453193 2022-04-28 Bon Homme South Dakota 46009 2291 39
2449937 2449937 2022-04-27 Bon Homme South Dakota 46009 2291 39
2446680 2446680 2022-04-26 Bon Homme South Dakota 46009 2291 38
2443425 2443425 2022-04-25 Bon Homme South Dakota 46009 2291 38
2440169 2440169 2022-04-24 Bon Homme South Dakota 46009 2291 38
2436913 2436913 2022-04-23 Bon Homme South Dakota 46009 2291 38
2433657 2433657 2022-04-22 Bon Homme South Dakota 46009 2291 38
2430401 2430401 2022-04-21 Bon Homme South Dakota 46009 2291 38
2427145 2427145 2022-04-20 Bon Homme South Dakota 46009 2291 38
2423889 2423889 2022-04-19 Bon Homme South Dakota 46009 2291 38
2420633 2420633 2022-04-18 Bon Homme South Dakota 46009 2291 38
2417377 2417377 2022-04-17 Bon Homme South Dakota 46009 2291 38
2414121 2414121 2022-04-16 Bon Homme South Dakota 46009 2291 38
2410865 2410865 2022-04-15 Bon Homme South Dakota 46009 2291 38
2407609 2407609 2022-04-14 Bon Homme South Dakota 46009 2291 38
2404353 2404353 2022-04-13 Bon Homme South Dakota 46009 2291 38
2401098 2401098 2022-04-12 Bon Homme South Dakota 46009 2291 38
2397843 2397843 2022-04-11 Bon Homme South Dakota 46009 2291 38
2394588 2394588 2022-04-10 Bon Homme South Dakota 46009 2291 38
2391332 2391332 2022-04-09 Bon Homme South Dakota 46009 2291 38
2388076 2388076 2022-04-08 Bon Homme South Dakota 46009 2291 38
2384821 2384821 2022-04-07 Bon Homme South Dakota 46009 2291 38
2381566 2381566 2022-04-06 Bon Homme South Dakota 46009 2291 38
2378311 2378311 2022-04-05 Bon Homme South Dakota 46009 2291 38
2375057 2375057 2022-04-04 Bon Homme South Dakota 46009 2291 38
2371805 2371805 2022-04-03 Bon Homme South Dakota 46009 2291 38
2368552 2368552 2022-04-02 Bon Homme South Dakota 46009 2291 38
2365299 2365299 2022-04-01 Bon Homme South Dakota 46009 2291 38
2362046 2362046 2022-03-31 Bon Homme South Dakota 46009 2291 38
2358792 2358792 2022-03-30 Bon Homme South Dakota 46009 2291 38
2355538 2355538 2022-03-29 Bon Homme South Dakota 46009 2291 38
2352285 2352285 2022-03-28 Bon Homme South Dakota 46009 2291 38
2349033 2349033 2022-03-27 Bon Homme South Dakota 46009 2291 38
2345780 2345780 2022-03-26 Bon Homme South Dakota 46009 2291 38
2342527 2342527 2022-03-25 Bon Homme South Dakota 46009 2291 38
2339274 2339274 2022-03-24 Bon Homme South Dakota 46009 2291 38
2336020 2336020 2022-03-23 Bon Homme South Dakota 46009 2291 38
2332766 2332766 2022-03-22 Bon Homme South Dakota 46009 2290 38
2329513 2329513 2022-03-21 Bon Homme South Dakota 46009 2290 38
2326261 2326261 2022-03-20 Bon Homme South Dakota 46009 2290 38
2323008 2323008 2022-03-19 Bon Homme South Dakota 46009 2290 38
2319754 2319754 2022-03-18 Bon Homme South Dakota 46009 2290 38
2316500 2316500 2022-03-17 Bon Homme South Dakota 46009 2290 38
2313247 2313247 2022-03-16 Bon Homme South Dakota 46009 2290 38
2309994 2309994 2022-03-15 Bon Homme South Dakota 46009 2290 38
2306741 2306741 2022-03-14 Bon Homme South Dakota 46009 2290 38
2303490 2303490 2022-03-13 Bon Homme South Dakota 46009 2289 38
2300238 2300238 2022-03-12 Bon Homme South Dakota 46009 2289 38
2296986 2296986 2022-03-11 Bon Homme South Dakota 46009 2289 38
2293734 2293734 2022-03-10 Bon Homme South Dakota 46009 2289 38
2290482 2290482 2022-03-09 Bon Homme South Dakota 46009 2289 38
2287230 2287230 2022-03-08 Bon Homme South Dakota 46009 2289 38
2283978 2283978 2022-03-07 Bon Homme South Dakota 46009 2289 38
2280726 2280726 2022-03-06 Bon Homme South Dakota 46009 2289 38
2277473 2277473 2022-03-05 Bon Homme South Dakota 46009 2289 38
2274220 2274220 2022-03-04 Bon Homme South Dakota 46009 2289 38
2270967 2270967 2022-03-03 Bon Homme South Dakota 46009 2290 37
2267715 2267715 2022-03-02 Bon Homme South Dakota 46009 2289 37
2264462 2264462 2022-03-01 Bon Homme South Dakota 46009 2289 37
2261212 2261212 2022-02-28 Bon Homme South Dakota 46009 2289 37
2257961 2257961 2022-02-27 Bon Homme South Dakota 46009 2290 37
2254710 2254710 2022-02-26 Bon Homme South Dakota 46009 2290 37
2251459 2251459 2022-02-25 Bon Homme South Dakota 46009 2290 37
2248208 2248208 2022-02-24 Bon Homme South Dakota 46009 2291 37
2244957 2244957 2022-02-23 Bon Homme South Dakota 46009 2290 37
2241706 2241706 2022-02-22 Bon Homme South Dakota 46009 2288 37
2238455 2238455 2022-02-21 Bon Homme South Dakota 46009 2288 37
2235204 2235204 2022-02-20 Bon Homme South Dakota 46009 2288 37
2231953 2231953 2022-02-19 Bon Homme South Dakota 46009 2288 37
2228702 2228702 2022-02-18 Bon Homme South Dakota 46009 2288 37
2225451 2225451 2022-02-17 Bon Homme South Dakota 46009 2287 37
2222200 2222200 2022-02-16 Bon Homme South Dakota 46009 2284 37
2218949 2218949 2022-02-15 Bon Homme South Dakota 46009 2283 37
2215698 2215698 2022-02-14 Bon Homme South Dakota 46009 2277 37
2212447 2212447 2022-02-13 Bon Homme South Dakota 46009 2275 37
2209194 2209194 2022-02-12 Bon Homme South Dakota 46009 2275 37
2205941 2205941 2022-02-11 Bon Homme South Dakota 46009 2275 37
2202688 2202688 2022-02-10 Bon Homme South Dakota 46009 2273 37
2199434 2199434 2022-02-09 Bon Homme South Dakota 46009 2272 36
2196180 2196180 2022-02-08 Bon Homme South Dakota 46009 2270 36
2192926 2192926 2022-02-07 Bon Homme South Dakota 46009 2267 36
2189672 2189672 2022-02-06 Bon Homme South Dakota 46009 2266 36
2186419 2186419 2022-02-05 Bon Homme South Dakota 46009 2266 36
2183167 2183167 2022-02-04 Bon Homme South Dakota 46009 2266 36
2179915 2179915 2022-02-03 Bon Homme South Dakota 46009 2263 36

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