ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
271 rows where deaths = 36 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 18
county 18
- Hutchinson 71
- Todd 31
- Roberts 30
- Hughes 28
- Bon Homme 17
- Spink 17
- Dewey 13
- Union 9
- Hamlin 8
- Butte 7
- Fall River 7
- Brookings 6
- Grant 6
- Meade 6
- Yankton 6
- Turner 5
- Oglala Lakota 2
- Pennington 2
state 1
- South Dakota · 271 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502077 | 2502077 | 2022-05-13 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2502101 | 2502101 | 2022-05-13 | Spink | South Dakota | 46115 | 1418 | 36 |
2498819 | 2498819 | 2022-05-12 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2498843 | 2498843 | 2022-05-12 | Spink | South Dakota | 46115 | 1418 | 36 |
2495561 | 2495561 | 2022-05-11 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2495585 | 2495585 | 2022-05-11 | Spink | South Dakota | 46115 | 1418 | 36 |
2492303 | 2492303 | 2022-05-10 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2492327 | 2492327 | 2022-05-10 | Spink | South Dakota | 46115 | 1416 | 36 |
2489045 | 2489045 | 2022-05-09 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2489069 | 2489069 | 2022-05-09 | Spink | South Dakota | 46115 | 1416 | 36 |
2485788 | 2485788 | 2022-05-08 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2485812 | 2485812 | 2022-05-08 | Spink | South Dakota | 46115 | 1416 | 36 |
2482530 | 2482530 | 2022-05-07 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2482554 | 2482554 | 2022-05-07 | Spink | South Dakota | 46115 | 1416 | 36 |
2479272 | 2479272 | 2022-05-06 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2479296 | 2479296 | 2022-05-06 | Spink | South Dakota | 46115 | 1416 | 36 |
2476014 | 2476014 | 2022-05-05 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2476038 | 2476038 | 2022-05-05 | Spink | South Dakota | 46115 | 1416 | 36 |
2472757 | 2472757 | 2022-05-04 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2472781 | 2472781 | 2022-05-04 | Spink | South Dakota | 46115 | 1416 | 36 |
2469501 | 2469501 | 2022-05-03 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2469525 | 2469525 | 2022-05-03 | Spink | South Dakota | 46115 | 1415 | 36 |
2466245 | 2466245 | 2022-05-02 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2466269 | 2466269 | 2022-05-02 | Spink | South Dakota | 46115 | 1415 | 36 |
2462990 | 2462990 | 2022-05-01 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2463014 | 2463014 | 2022-05-01 | Spink | South Dakota | 46115 | 1415 | 36 |
2459734 | 2459734 | 2022-04-30 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2459758 | 2459758 | 2022-04-30 | Spink | South Dakota | 46115 | 1415 | 36 |
2456478 | 2456478 | 2022-04-29 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2456502 | 2456502 | 2022-04-29 | Spink | South Dakota | 46115 | 1415 | 36 |
2453222 | 2453222 | 2022-04-28 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2453246 | 2453246 | 2022-04-28 | Spink | South Dakota | 46115 | 1415 | 36 |
2449966 | 2449966 | 2022-04-27 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2449990 | 2449990 | 2022-04-27 | Spink | South Dakota | 46115 | 1415 | 36 |
2446709 | 2446709 | 2022-04-26 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2443454 | 2443454 | 2022-04-25 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2440198 | 2440198 | 2022-04-24 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2436942 | 2436942 | 2022-04-23 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2433686 | 2433686 | 2022-04-22 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2430430 | 2430430 | 2022-04-21 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2427174 | 2427174 | 2022-04-20 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2423918 | 2423918 | 2022-04-19 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2420662 | 2420662 | 2022-04-18 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2417406 | 2417406 | 2022-04-17 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2414150 | 2414150 | 2022-04-16 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2410894 | 2410894 | 2022-04-15 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2407638 | 2407638 | 2022-04-14 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2404382 | 2404382 | 2022-04-13 | Hutchinson | South Dakota | 46067 | 1733 | 36 |
2401127 | 2401127 | 2022-04-12 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2397872 | 2397872 | 2022-04-11 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2394617 | 2394617 | 2022-04-10 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2391361 | 2391361 | 2022-04-09 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2388105 | 2388105 | 2022-04-08 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2384850 | 2384850 | 2022-04-07 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2381595 | 2381595 | 2022-04-06 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2378340 | 2378340 | 2022-04-05 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2375086 | 2375086 | 2022-04-04 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2371834 | 2371834 | 2022-04-03 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2368581 | 2368581 | 2022-04-02 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2365328 | 2365328 | 2022-04-01 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2362075 | 2362075 | 2022-03-31 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2358821 | 2358821 | 2022-03-30 | Hutchinson | South Dakota | 46067 | 1730 | 36 |
2355567 | 2355567 | 2022-03-29 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2352314 | 2352314 | 2022-03-28 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2349062 | 2349062 | 2022-03-27 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2345809 | 2345809 | 2022-03-26 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2342556 | 2342556 | 2022-03-25 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2339303 | 2339303 | 2022-03-24 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2336049 | 2336049 | 2022-03-23 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2332795 | 2332795 | 2022-03-22 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2329542 | 2329542 | 2022-03-21 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2326290 | 2326290 | 2022-03-20 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2323037 | 2323037 | 2022-03-19 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2319783 | 2319783 | 2022-03-18 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2316529 | 2316529 | 2022-03-17 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2313276 | 2313276 | 2022-03-16 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2310023 | 2310023 | 2022-03-15 | Hutchinson | South Dakota | 46067 | 1728 | 36 |
2306770 | 2306770 | 2022-03-14 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2303519 | 2303519 | 2022-03-13 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2300267 | 2300267 | 2022-03-12 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2297015 | 2297015 | 2022-03-11 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2293763 | 2293763 | 2022-03-10 | Hutchinson | South Dakota | 46067 | 1727 | 36 |
2290511 | 2290511 | 2022-03-09 | Hutchinson | South Dakota | 46067 | 1726 | 36 |
2287259 | 2287259 | 2022-03-08 | Hutchinson | South Dakota | 46067 | 1726 | 36 |
2284007 | 2284007 | 2022-03-07 | Hutchinson | South Dakota | 46067 | 1725 | 36 |
2280755 | 2280755 | 2022-03-06 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
2277502 | 2277502 | 2022-03-05 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
2274249 | 2274249 | 2022-03-04 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
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 |
2176664 | 2176664 | 2022-02-02 | Bon Homme | South Dakota | 46009 | 2258 | 36 |
2173410 | 2173410 | 2022-02-01 | Bon Homme | South Dakota | 46009 | 2255 | 36 |
2173429 | 2173429 | 2022-02-01 | Fall River | South Dakota | 46047 | 1703 | 36 |
2170158 | 2170158 | 2022-01-31 | Bon Homme | South Dakota | 46009 | 2247 | 36 |
2170177 | 2170177 | 2022-01-31 | Fall River | South Dakota | 46047 | 1678 | 36 |
Advanced export
JSON shape: default, array, newline-delimited
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);