ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,245 rows where deaths = 14 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
- Edmunds 258
- Perkins 237
- Jackson 151
- Buffalo 140
- Faulk 76
- Kingsbury 75
- Bennett 66
- Walworth 43
- Custer 37
- Moody 30
- Douglas 23
- Hutchinson 15
- Fall River 12
- Charles Mix 11
- Bon Homme 10
- Tripp 9
- Corson 7
- Butte 6
- Spink 6
- Clay 5
- Day 4
- Davison 3
- Dewey 3
- Lincoln 3
- Aurora 2
- Brookings 2
- Lake 2
- Meade 2
- Todd 2
- Beadle 1
- …
state 1
- South Dakota · 1,245 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502047 | 2502047 | 2022-05-13 | Bennett | South Dakota | 46007 | 789 | 14 |
2498789 | 2498789 | 2022-05-12 | Bennett | South Dakota | 46007 | 789 | 14 |
2495531 | 2495531 | 2022-05-11 | Bennett | South Dakota | 46007 | 789 | 14 |
2492273 | 2492273 | 2022-05-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2489015 | 2489015 | 2022-05-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2485758 | 2485758 | 2022-05-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2482500 | 2482500 | 2022-05-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2479242 | 2479242 | 2022-05-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2475984 | 2475984 | 2022-05-05 | Bennett | South Dakota | 46007 | 788 | 14 |
2472727 | 2472727 | 2022-05-04 | Bennett | South Dakota | 46007 | 788 | 14 |
2469471 | 2469471 | 2022-05-03 | Bennett | South Dakota | 46007 | 788 | 14 |
2466215 | 2466215 | 2022-05-02 | Bennett | South Dakota | 46007 | 788 | 14 |
2462960 | 2462960 | 2022-05-01 | Bennett | South Dakota | 46007 | 788 | 14 |
2459704 | 2459704 | 2022-04-30 | Bennett | South Dakota | 46007 | 788 | 14 |
2456448 | 2456448 | 2022-04-29 | Bennett | South Dakota | 46007 | 788 | 14 |
2453192 | 2453192 | 2022-04-28 | Bennett | South Dakota | 46007 | 788 | 14 |
2449936 | 2449936 | 2022-04-27 | Bennett | South Dakota | 46007 | 788 | 14 |
2446679 | 2446679 | 2022-04-26 | Bennett | South Dakota | 46007 | 788 | 14 |
2443424 | 2443424 | 2022-04-25 | Bennett | South Dakota | 46007 | 788 | 14 |
2440168 | 2440168 | 2022-04-24 | Bennett | South Dakota | 46007 | 788 | 14 |
2436912 | 2436912 | 2022-04-23 | Bennett | South Dakota | 46007 | 788 | 14 |
2433656 | 2433656 | 2022-04-22 | Bennett | South Dakota | 46007 | 788 | 14 |
2430400 | 2430400 | 2022-04-21 | Bennett | South Dakota | 46007 | 788 | 14 |
2427144 | 2427144 | 2022-04-20 | Bennett | South Dakota | 46007 | 788 | 14 |
2423888 | 2423888 | 2022-04-19 | Bennett | South Dakota | 46007 | 788 | 14 |
2420632 | 2420632 | 2022-04-18 | Bennett | South Dakota | 46007 | 788 | 14 |
2417376 | 2417376 | 2022-04-17 | Bennett | South Dakota | 46007 | 788 | 14 |
2414120 | 2414120 | 2022-04-16 | Bennett | South Dakota | 46007 | 788 | 14 |
2410864 | 2410864 | 2022-04-15 | Bennett | South Dakota | 46007 | 788 | 14 |
2407608 | 2407608 | 2022-04-14 | Bennett | South Dakota | 46007 | 788 | 14 |
2404352 | 2404352 | 2022-04-13 | Bennett | South Dakota | 46007 | 788 | 14 |
2401097 | 2401097 | 2022-04-12 | Bennett | South Dakota | 46007 | 788 | 14 |
2397842 | 2397842 | 2022-04-11 | Bennett | South Dakota | 46007 | 788 | 14 |
2394587 | 2394587 | 2022-04-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2391331 | 2391331 | 2022-04-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2388075 | 2388075 | 2022-04-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2384820 | 2384820 | 2022-04-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2381565 | 2381565 | 2022-04-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2378310 | 2378310 | 2022-04-05 | Bennett | South Dakota | 46007 | 787 | 14 |
2375056 | 2375056 | 2022-04-04 | Bennett | South Dakota | 46007 | 787 | 14 |
2371804 | 2371804 | 2022-04-03 | Bennett | South Dakota | 46007 | 787 | 14 |
2368551 | 2368551 | 2022-04-02 | Bennett | South Dakota | 46007 | 787 | 14 |
2365298 | 2365298 | 2022-04-01 | Bennett | South Dakota | 46007 | 787 | 14 |
2362045 | 2362045 | 2022-03-31 | Bennett | South Dakota | 46007 | 787 | 14 |
2358791 | 2358791 | 2022-03-30 | Bennett | South Dakota | 46007 | 787 | 14 |
2355537 | 2355537 | 2022-03-29 | Bennett | South Dakota | 46007 | 786 | 14 |
2352284 | 2352284 | 2022-03-28 | Bennett | South Dakota | 46007 | 786 | 14 |
2349032 | 2349032 | 2022-03-27 | Bennett | South Dakota | 46007 | 786 | 14 |
2345779 | 2345779 | 2022-03-26 | Bennett | South Dakota | 46007 | 786 | 14 |
2342526 | 2342526 | 2022-03-25 | Bennett | South Dakota | 46007 | 786 | 14 |
2339273 | 2339273 | 2022-03-24 | Bennett | South Dakota | 46007 | 786 | 14 |
2336019 | 2336019 | 2022-03-23 | Bennett | South Dakota | 46007 | 786 | 14 |
2332765 | 2332765 | 2022-03-22 | Bennett | South Dakota | 46007 | 786 | 14 |
2329512 | 2329512 | 2022-03-21 | Bennett | South Dakota | 46007 | 786 | 14 |
2326260 | 2326260 | 2022-03-20 | Bennett | South Dakota | 46007 | 786 | 14 |
2323007 | 2323007 | 2022-03-19 | Bennett | South Dakota | 46007 | 786 | 14 |
2319753 | 2319753 | 2022-03-18 | Bennett | South Dakota | 46007 | 786 | 14 |
2316499 | 2316499 | 2022-03-17 | Bennett | South Dakota | 46007 | 786 | 14 |
2313246 | 2313246 | 2022-03-16 | Bennett | South Dakota | 46007 | 786 | 14 |
2309993 | 2309993 | 2022-03-15 | Bennett | South Dakota | 46007 | 786 | 14 |
2306740 | 2306740 | 2022-03-14 | Bennett | South Dakota | 46007 | 786 | 14 |
2303489 | 2303489 | 2022-03-13 | Bennett | South Dakota | 46007 | 785 | 14 |
2300237 | 2300237 | 2022-03-12 | Bennett | South Dakota | 46007 | 785 | 14 |
2296985 | 2296985 | 2022-03-11 | Bennett | South Dakota | 46007 | 785 | 14 |
2293733 | 2293733 | 2022-03-10 | Bennett | South Dakota | 46007 | 785 | 14 |
2290481 | 2290481 | 2022-03-09 | Bennett | South Dakota | 46007 | 785 | 14 |
2144145 | 2144145 | 2022-01-23 | Edmunds | South Dakota | 46045 | 832 | 14 |
2140890 | 2140890 | 2022-01-22 | Edmunds | South Dakota | 46045 | 832 | 14 |
2137634 | 2137634 | 2022-01-21 | Edmunds | South Dakota | 46045 | 832 | 14 |
2134380 | 2134380 | 2022-01-20 | Edmunds | South Dakota | 46045 | 822 | 14 |
2131128 | 2131128 | 2022-01-19 | Edmunds | South Dakota | 46045 | 812 | 14 |
2127874 | 2127874 | 2022-01-18 | Edmunds | South Dakota | 46045 | 780 | 14 |
2124622 | 2124622 | 2022-01-17 | Edmunds | South Dakota | 46045 | 772 | 14 |
2121370 | 2121370 | 2022-01-16 | Edmunds | South Dakota | 46045 | 772 | 14 |
2118118 | 2118118 | 2022-01-15 | Edmunds | South Dakota | 46045 | 772 | 14 |
2114867 | 2114867 | 2022-01-14 | Edmunds | South Dakota | 46045 | 772 | 14 |
2111615 | 2111615 | 2022-01-13 | Edmunds | South Dakota | 46045 | 763 | 14 |
2108363 | 2108363 | 2022-01-12 | Edmunds | South Dakota | 46045 | 758 | 14 |
2105112 | 2105112 | 2022-01-11 | Edmunds | South Dakota | 46045 | 753 | 14 |
2101861 | 2101861 | 2022-01-10 | Edmunds | South Dakota | 46045 | 744 | 14 |
2098610 | 2098610 | 2022-01-09 | Edmunds | South Dakota | 46045 | 740 | 14 |
2095358 | 2095358 | 2022-01-08 | Edmunds | South Dakota | 46045 | 740 | 14 |
2092106 | 2092106 | 2022-01-07 | Edmunds | South Dakota | 46045 | 740 | 14 |
2088854 | 2088854 | 2022-01-06 | Edmunds | South Dakota | 46045 | 737 | 14 |
2085602 | 2085602 | 2022-01-05 | Douglas | South Dakota | 46043 | 597 | 14 |
2085603 | 2085603 | 2022-01-05 | Edmunds | South Dakota | 46045 | 736 | 14 |
2082350 | 2082350 | 2022-01-04 | Douglas | South Dakota | 46043 | 592 | 14 |
2082351 | 2082351 | 2022-01-04 | Edmunds | South Dakota | 46045 | 731 | 14 |
2079098 | 2079098 | 2022-01-03 | Douglas | South Dakota | 46043 | 591 | 14 |
2079099 | 2079099 | 2022-01-03 | Edmunds | South Dakota | 46045 | 719 | 14 |
2075847 | 2075847 | 2022-01-02 | Douglas | South Dakota | 46043 | 590 | 14 |
2075848 | 2075848 | 2022-01-02 | Edmunds | South Dakota | 46045 | 712 | 14 |
2072596 | 2072596 | 2022-01-01 | Douglas | South Dakota | 46043 | 590 | 14 |
2072597 | 2072597 | 2022-01-01 | Edmunds | South Dakota | 46045 | 712 | 14 |
2069345 | 2069345 | 2021-12-31 | Douglas | South Dakota | 46043 | 590 | 14 |
2069346 | 2069346 | 2021-12-31 | Edmunds | South Dakota | 46045 | 712 | 14 |
2066094 | 2066094 | 2021-12-30 | Douglas | South Dakota | 46043 | 590 | 14 |
2066095 | 2066095 | 2021-12-30 | Edmunds | South Dakota | 46045 | 712 | 14 |
2062844 | 2062844 | 2021-12-29 | Douglas | South Dakota | 46043 | 588 | 14 |
2062845 | 2062845 | 2021-12-29 | Edmunds | South Dakota | 46045 | 709 | 14 |
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);