ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,209 rows where deaths = 5 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clark 298
- Hyde 83
- Hanson 80
- Todd 78
- Marshall 62
- Potter 59
- Bennett 58
- Douglas 40
- Brule 32
- Hughes 31
- Mellette 31
- Lawrence 23
- Sanborn 21
- Yankton 21
- Corson 19
- Edmunds 16
- Miner 16
- Campbell 15
- Union 15
- Buffalo 14
- Clay 13
- Oglala Lakota 13
- Davison 12
- Day 12
- Meade 12
- Beadle 11
- Grant 11
- Lyman 9
- McPherson 9
- Aurora 8
- …
state 1
- South Dakota · 1,209 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2212490 | 2212490 | 2022-02-13 | Mellette | South Dakota | 46095 | 510 | 5 |
2209237 | 2209237 | 2022-02-12 | Mellette | South Dakota | 46095 | 510 | 5 |
2205984 | 2205984 | 2022-02-11 | Mellette | South Dakota | 46095 | 510 | 5 |
2202731 | 2202731 | 2022-02-10 | Mellette | South Dakota | 46095 | 510 | 5 |
2199477 | 2199477 | 2022-02-09 | Mellette | South Dakota | 46095 | 509 | 5 |
2196223 | 2196223 | 2022-02-08 | Mellette | South Dakota | 46095 | 510 | 5 |
2192969 | 2192969 | 2022-02-07 | Mellette | South Dakota | 46095 | 509 | 5 |
2189715 | 2189715 | 2022-02-06 | Mellette | South Dakota | 46095 | 509 | 5 |
2186462 | 2186462 | 2022-02-05 | Mellette | South Dakota | 46095 | 509 | 5 |
2183210 | 2183210 | 2022-02-04 | Mellette | South Dakota | 46095 | 509 | 5 |
2179958 | 2179958 | 2022-02-03 | Mellette | South Dakota | 46095 | 506 | 5 |
2176694 | 2176694 | 2022-02-02 | Hyde | South Dakota | 46069 | 293 | 5 |
2176707 | 2176707 | 2022-02-02 | Mellette | South Dakota | 46095 | 504 | 5 |
2176716 | 2176716 | 2022-02-02 | Sanborn | South Dakota | 46111 | 552 | 5 |
2173440 | 2173440 | 2022-02-01 | Hyde | South Dakota | 46069 | 287 | 5 |
2173453 | 2173453 | 2022-02-01 | Mellette | South Dakota | 46095 | 500 | 5 |
2173462 | 2173462 | 2022-02-01 | Sanborn | South Dakota | 46111 | 549 | 5 |
2170188 | 2170188 | 2022-01-31 | Hyde | South Dakota | 46069 | 283 | 5 |
2170201 | 2170201 | 2022-01-31 | Mellette | South Dakota | 46095 | 498 | 5 |
2170210 | 2170210 | 2022-01-31 | Sanborn | South Dakota | 46111 | 547 | 5 |
2166934 | 2166934 | 2022-01-30 | Hyde | South Dakota | 46069 | 280 | 5 |
2166947 | 2166947 | 2022-01-30 | Mellette | South Dakota | 46095 | 487 | 5 |
2166956 | 2166956 | 2022-01-30 | Sanborn | South Dakota | 46111 | 546 | 5 |
2163679 | 2163679 | 2022-01-29 | Hyde | South Dakota | 46069 | 280 | 5 |
2163692 | 2163692 | 2022-01-29 | Mellette | South Dakota | 46095 | 487 | 5 |
2163701 | 2163701 | 2022-01-29 | Sanborn | South Dakota | 46111 | 546 | 5 |
2160424 | 2160424 | 2022-01-28 | Hyde | South Dakota | 46069 | 280 | 5 |
2160437 | 2160437 | 2022-01-28 | Mellette | South Dakota | 46095 | 487 | 5 |
2160446 | 2160446 | 2022-01-28 | Sanborn | South Dakota | 46111 | 546 | 5 |
2157168 | 2157168 | 2022-01-27 | Hyde | South Dakota | 46069 | 278 | 5 |
2157181 | 2157181 | 2022-01-27 | Mellette | South Dakota | 46095 | 480 | 5 |
2157190 | 2157190 | 2022-01-27 | Sanborn | South Dakota | 46111 | 544 | 5 |
2153915 | 2153915 | 2022-01-26 | Hyde | South Dakota | 46069 | 276 | 5 |
2153928 | 2153928 | 2022-01-26 | Mellette | South Dakota | 46095 | 467 | 5 |
2153937 | 2153937 | 2022-01-26 | Sanborn | South Dakota | 46111 | 539 | 5 |
2150663 | 2150663 | 2022-01-25 | Hyde | South Dakota | 46069 | 271 | 5 |
2150676 | 2150676 | 2022-01-25 | Mellette | South Dakota | 46095 | 467 | 5 |
2150685 | 2150685 | 2022-01-25 | Sanborn | South Dakota | 46111 | 536 | 5 |
2147411 | 2147411 | 2022-01-24 | Hyde | South Dakota | 46069 | 267 | 5 |
2147424 | 2147424 | 2022-01-24 | Mellette | South Dakota | 46095 | 458 | 5 |
2147433 | 2147433 | 2022-01-24 | Sanborn | South Dakota | 46111 | 527 | 5 |
2144157 | 2144157 | 2022-01-23 | Hyde | South Dakota | 46069 | 262 | 5 |
2144170 | 2144170 | 2022-01-23 | Mellette | South Dakota | 46095 | 452 | 5 |
2144179 | 2144179 | 2022-01-23 | Sanborn | South Dakota | 46111 | 525 | 5 |
2140902 | 2140902 | 2022-01-22 | Hyde | South Dakota | 46069 | 262 | 5 |
2140915 | 2140915 | 2022-01-22 | Mellette | South Dakota | 46095 | 452 | 5 |
2140924 | 2140924 | 2022-01-22 | Sanborn | South Dakota | 46111 | 525 | 5 |
2137646 | 2137646 | 2022-01-21 | Hyde | South Dakota | 46069 | 262 | 5 |
2137659 | 2137659 | 2022-01-21 | Mellette | South Dakota | 46095 | 452 | 5 |
2137668 | 2137668 | 2022-01-21 | Sanborn | South Dakota | 46111 | 525 | 5 |
2134388 | 2134388 | 2022-01-20 | Hanson | South Dakota | 46061 | 607 | 5 |
2134392 | 2134392 | 2022-01-20 | Hyde | South Dakota | 46069 | 257 | 5 |
2134405 | 2134405 | 2022-01-20 | Mellette | South Dakota | 46095 | 447 | 5 |
2134412 | 2134412 | 2022-01-20 | Potter | South Dakota | 46107 | 613 | 5 |
2134414 | 2134414 | 2022-01-20 | Sanborn | South Dakota | 46111 | 521 | 5 |
2134416 | 2134416 | 2022-01-20 | Stanley | South Dakota | 46117 | 588 | 5 |
2131136 | 2131136 | 2022-01-19 | Hanson | South Dakota | 46061 | 600 | 5 |
2131140 | 2131140 | 2022-01-19 | Hyde | South Dakota | 46069 | 257 | 5 |
2131153 | 2131153 | 2022-01-19 | Mellette | South Dakota | 46095 | 435 | 5 |
2131160 | 2131160 | 2022-01-19 | Potter | South Dakota | 46107 | 606 | 5 |
2131162 | 2131162 | 2022-01-19 | Sanborn | South Dakota | 46111 | 515 | 5 |
2131164 | 2131164 | 2022-01-19 | Stanley | South Dakota | 46117 | 584 | 5 |
2127882 | 2127882 | 2022-01-18 | Hanson | South Dakota | 46061 | 589 | 5 |
2127886 | 2127886 | 2022-01-18 | Hyde | South Dakota | 46069 | 256 | 5 |
2127899 | 2127899 | 2022-01-18 | Mellette | South Dakota | 46095 | 418 | 5 |
2127906 | 2127906 | 2022-01-18 | Potter | South Dakota | 46107 | 587 | 5 |
2127908 | 2127908 | 2022-01-18 | Sanborn | South Dakota | 46111 | 503 | 5 |
2127910 | 2127910 | 2022-01-18 | Stanley | South Dakota | 46117 | 574 | 5 |
2124630 | 2124630 | 2022-01-17 | Hanson | South Dakota | 46061 | 585 | 5 |
2124634 | 2124634 | 2022-01-17 | Hyde | South Dakota | 46069 | 254 | 5 |
2124647 | 2124647 | 2022-01-17 | Mellette | South Dakota | 46095 | 416 | 5 |
2124654 | 2124654 | 2022-01-17 | Potter | South Dakota | 46107 | 576 | 5 |
2124656 | 2124656 | 2022-01-17 | Sanborn | South Dakota | 46111 | 499 | 5 |
2124658 | 2124658 | 2022-01-17 | Stanley | South Dakota | 46117 | 571 | 5 |
2121378 | 2121378 | 2022-01-16 | Hanson | South Dakota | 46061 | 585 | 5 |
2121382 | 2121382 | 2022-01-16 | Hyde | South Dakota | 46069 | 254 | 5 |
2121395 | 2121395 | 2022-01-16 | Mellette | South Dakota | 46095 | 416 | 5 |
2121402 | 2121402 | 2022-01-16 | Potter | South Dakota | 46107 | 576 | 5 |
2121404 | 2121404 | 2022-01-16 | Sanborn | South Dakota | 46111 | 499 | 5 |
2121406 | 2121406 | 2022-01-16 | Stanley | South Dakota | 46117 | 571 | 5 |
2118126 | 2118126 | 2022-01-15 | Hanson | South Dakota | 46061 | 585 | 5 |
2118130 | 2118130 | 2022-01-15 | Hyde | South Dakota | 46069 | 254 | 5 |
2118143 | 2118143 | 2022-01-15 | Mellette | South Dakota | 46095 | 416 | 5 |
2118150 | 2118150 | 2022-01-15 | Potter | South Dakota | 46107 | 576 | 5 |
2118152 | 2118152 | 2022-01-15 | Sanborn | South Dakota | 46111 | 499 | 5 |
2118154 | 2118154 | 2022-01-15 | Stanley | South Dakota | 46117 | 571 | 5 |
2114875 | 2114875 | 2022-01-14 | Hanson | South Dakota | 46061 | 585 | 5 |
2114879 | 2114879 | 2022-01-14 | Hyde | South Dakota | 46069 | 254 | 5 |
2114892 | 2114892 | 2022-01-14 | Mellette | South Dakota | 46095 | 416 | 5 |
2114899 | 2114899 | 2022-01-14 | Potter | South Dakota | 46107 | 576 | 5 |
2114901 | 2114901 | 2022-01-14 | Sanborn | South Dakota | 46111 | 499 | 5 |
2114903 | 2114903 | 2022-01-14 | Stanley | South Dakota | 46117 | 571 | 5 |
2111623 | 2111623 | 2022-01-13 | Hanson | South Dakota | 46061 | 581 | 5 |
2111627 | 2111627 | 2022-01-13 | Hyde | South Dakota | 46069 | 253 | 5 |
2111647 | 2111647 | 2022-01-13 | Potter | South Dakota | 46107 | 567 | 5 |
2111649 | 2111649 | 2022-01-13 | Sanborn | South Dakota | 46111 | 496 | 5 |
2108371 | 2108371 | 2022-01-12 | Hanson | South Dakota | 46061 | 574 | 5 |
2108375 | 2108375 | 2022-01-12 | Hyde | South Dakota | 46069 | 252 | 5 |
2108395 | 2108395 | 2022-01-12 | Potter | South Dakota | 46107 | 556 | 5 |
2105120 | 2105120 | 2022-01-11 | Hanson | South Dakota | 46061 | 567 | 5 |
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);