ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,020 rows where deaths = 20 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Lake 229
- Butte 199
- Moody 157
- Jerauld 89
- Kingsbury 71
- Brule 64
- Jackson 27
- Clay 24
- Walworth 24
- Custer 20
- Day 15
- Tripp 15
- Fall River 11
- Spink 8
- Grant 7
- Bon Homme 6
- Meade 6
- Charles Mix 5
- Dewey 5
- Gregory 5
- Hutchinson 5
- Oglala Lakota 5
- Pennington 5
- Todd 4
- Brookings 3
- Lincoln 3
- Roberts 3
- McCook 2
- Brown 1
- Davison 1
- …
state 1
- South Dakota · 1,020 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502051 | 2502051 | 2022-05-13 | Brule | South Dakota | 46015 | 1415 | 20 |
2502080 | 2502080 | 2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2498793 | 2498793 | 2022-05-12 | Brule | South Dakota | 46015 | 1415 | 20 |
2498822 | 2498822 | 2022-05-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2495535 | 2495535 | 2022-05-11 | Brule | South Dakota | 46015 | 1415 | 20 |
2495564 | 2495564 | 2022-05-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2492277 | 2492277 | 2022-05-10 | Brule | South Dakota | 46015 | 1413 | 20 |
2492306 | 2492306 | 2022-05-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2489019 | 2489019 | 2022-05-09 | Brule | South Dakota | 46015 | 1413 | 20 |
2489048 | 2489048 | 2022-05-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2485762 | 2485762 | 2022-05-08 | Brule | South Dakota | 46015 | 1413 | 20 |
2485791 | 2485791 | 2022-05-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2482504 | 2482504 | 2022-05-07 | Brule | South Dakota | 46015 | 1413 | 20 |
2482533 | 2482533 | 2022-05-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2479246 | 2479246 | 2022-05-06 | Brule | South Dakota | 46015 | 1413 | 20 |
2479275 | 2479275 | 2022-05-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
2475988 | 2475988 | 2022-05-05 | Brule | South Dakota | 46015 | 1413 | 20 |
2476017 | 2476017 | 2022-05-05 | Jerauld | South Dakota | 46073 | 415 | 20 |
2472731 | 2472731 | 2022-05-04 | Brule | South Dakota | 46015 | 1413 | 20 |
2472760 | 2472760 | 2022-05-04 | Jerauld | South Dakota | 46073 | 415 | 20 |
2469475 | 2469475 | 2022-05-03 | Brule | South Dakota | 46015 | 1413 | 20 |
2469504 | 2469504 | 2022-05-03 | Jerauld | South Dakota | 46073 | 415 | 20 |
2466219 | 2466219 | 2022-05-02 | Brule | South Dakota | 46015 | 1413 | 20 |
2466248 | 2466248 | 2022-05-02 | Jerauld | South Dakota | 46073 | 415 | 20 |
2462964 | 2462964 | 2022-05-01 | Brule | South Dakota | 46015 | 1413 | 20 |
2462993 | 2462993 | 2022-05-01 | Jerauld | South Dakota | 46073 | 415 | 20 |
2459708 | 2459708 | 2022-04-30 | Brule | South Dakota | 46015 | 1413 | 20 |
2459737 | 2459737 | 2022-04-30 | Jerauld | South Dakota | 46073 | 415 | 20 |
2456452 | 2456452 | 2022-04-29 | Brule | South Dakota | 46015 | 1413 | 20 |
2456481 | 2456481 | 2022-04-29 | Jerauld | South Dakota | 46073 | 415 | 20 |
2453196 | 2453196 | 2022-04-28 | Brule | South Dakota | 46015 | 1413 | 20 |
2453225 | 2453225 | 2022-04-28 | Jerauld | South Dakota | 46073 | 415 | 20 |
2449940 | 2449940 | 2022-04-27 | Brule | South Dakota | 46015 | 1413 | 20 |
2449969 | 2449969 | 2022-04-27 | Jerauld | South Dakota | 46073 | 415 | 20 |
2446683 | 2446683 | 2022-04-26 | Brule | South Dakota | 46015 | 1413 | 20 |
2446712 | 2446712 | 2022-04-26 | Jerauld | South Dakota | 46073 | 415 | 20 |
2443428 | 2443428 | 2022-04-25 | Brule | South Dakota | 46015 | 1413 | 20 |
2443457 | 2443457 | 2022-04-25 | Jerauld | South Dakota | 46073 | 415 | 20 |
2440172 | 2440172 | 2022-04-24 | Brule | South Dakota | 46015 | 1413 | 20 |
2440201 | 2440201 | 2022-04-24 | Jerauld | South Dakota | 46073 | 415 | 20 |
2436916 | 2436916 | 2022-04-23 | Brule | South Dakota | 46015 | 1413 | 20 |
2436945 | 2436945 | 2022-04-23 | Jerauld | South Dakota | 46073 | 415 | 20 |
2433660 | 2433660 | 2022-04-22 | Brule | South Dakota | 46015 | 1413 | 20 |
2433689 | 2433689 | 2022-04-22 | Jerauld | South Dakota | 46073 | 415 | 20 |
2430404 | 2430404 | 2022-04-21 | Brule | South Dakota | 46015 | 1413 | 20 |
2430433 | 2430433 | 2022-04-21 | Jerauld | South Dakota | 46073 | 415 | 20 |
2427148 | 2427148 | 2022-04-20 | Brule | South Dakota | 46015 | 1413 | 20 |
2427177 | 2427177 | 2022-04-20 | Jerauld | South Dakota | 46073 | 415 | 20 |
2423892 | 2423892 | 2022-04-19 | Brule | South Dakota | 46015 | 1412 | 20 |
2423921 | 2423921 | 2022-04-19 | Jerauld | South Dakota | 46073 | 415 | 20 |
2420636 | 2420636 | 2022-04-18 | Brule | South Dakota | 46015 | 1412 | 20 |
2420665 | 2420665 | 2022-04-18 | Jerauld | South Dakota | 46073 | 415 | 20 |
2417380 | 2417380 | 2022-04-17 | Brule | South Dakota | 46015 | 1412 | 20 |
2417409 | 2417409 | 2022-04-17 | Jerauld | South Dakota | 46073 | 415 | 20 |
2414124 | 2414124 | 2022-04-16 | Brule | South Dakota | 46015 | 1412 | 20 |
2414153 | 2414153 | 2022-04-16 | Jerauld | South Dakota | 46073 | 415 | 20 |
2410868 | 2410868 | 2022-04-15 | Brule | South Dakota | 46015 | 1412 | 20 |
2410897 | 2410897 | 2022-04-15 | Jerauld | South Dakota | 46073 | 415 | 20 |
2407612 | 2407612 | 2022-04-14 | Brule | South Dakota | 46015 | 1412 | 20 |
2407641 | 2407641 | 2022-04-14 | Jerauld | South Dakota | 46073 | 415 | 20 |
2404356 | 2404356 | 2022-04-13 | Brule | South Dakota | 46015 | 1412 | 20 |
2404385 | 2404385 | 2022-04-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2401101 | 2401101 | 2022-04-12 | Brule | South Dakota | 46015 | 1411 | 20 |
2401130 | 2401130 | 2022-04-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2397846 | 2397846 | 2022-04-11 | Brule | South Dakota | 46015 | 1411 | 20 |
2397875 | 2397875 | 2022-04-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2394591 | 2394591 | 2022-04-10 | Brule | South Dakota | 46015 | 1411 | 20 |
2394620 | 2394620 | 2022-04-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2391335 | 2391335 | 2022-04-09 | Brule | South Dakota | 46015 | 1411 | 20 |
2391364 | 2391364 | 2022-04-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2388079 | 2388079 | 2022-04-08 | Brule | South Dakota | 46015 | 1411 | 20 |
2388108 | 2388108 | 2022-04-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2384824 | 2384824 | 2022-04-07 | Brule | South Dakota | 46015 | 1411 | 20 |
2384853 | 2384853 | 2022-04-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2381569 | 2381569 | 2022-04-06 | Brule | South Dakota | 46015 | 1411 | 20 |
2381598 | 2381598 | 2022-04-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
2378314 | 2378314 | 2022-04-05 | Brule | South Dakota | 46015 | 1410 | 20 |
2378343 | 2378343 | 2022-04-05 | Jerauld | South Dakota | 46073 | 415 | 20 |
2375060 | 2375060 | 2022-04-04 | Brule | South Dakota | 46015 | 1410 | 20 |
2375089 | 2375089 | 2022-04-04 | Jerauld | South Dakota | 46073 | 415 | 20 |
2371808 | 2371808 | 2022-04-03 | Brule | South Dakota | 46015 | 1410 | 20 |
2371837 | 2371837 | 2022-04-03 | Jerauld | South Dakota | 46073 | 415 | 20 |
2368555 | 2368555 | 2022-04-02 | Brule | South Dakota | 46015 | 1410 | 20 |
2368584 | 2368584 | 2022-04-02 | Jerauld | South Dakota | 46073 | 415 | 20 |
2365302 | 2365302 | 2022-04-01 | Brule | South Dakota | 46015 | 1410 | 20 |
2365331 | 2365331 | 2022-04-01 | Jerauld | South Dakota | 46073 | 415 | 20 |
2362049 | 2362049 | 2022-03-31 | Brule | South Dakota | 46015 | 1410 | 20 |
2362078 | 2362078 | 2022-03-31 | Jerauld | South Dakota | 46073 | 415 | 20 |
2358795 | 2358795 | 2022-03-30 | Brule | South Dakota | 46015 | 1410 | 20 |
2358824 | 2358824 | 2022-03-30 | Jerauld | South Dakota | 46073 | 415 | 20 |
2355541 | 2355541 | 2022-03-29 | Brule | South Dakota | 46015 | 1409 | 20 |
2355570 | 2355570 | 2022-03-29 | Jerauld | South Dakota | 46073 | 415 | 20 |
2352288 | 2352288 | 2022-03-28 | Brule | South Dakota | 46015 | 1409 | 20 |
2352317 | 2352317 | 2022-03-28 | Jerauld | South Dakota | 46073 | 415 | 20 |
2349036 | 2349036 | 2022-03-27 | Brule | South Dakota | 46015 | 1409 | 20 |
2349065 | 2349065 | 2022-03-27 | Jerauld | South Dakota | 46073 | 415 | 20 |
2345783 | 2345783 | 2022-03-26 | Brule | South Dakota | 46015 | 1409 | 20 |
2345812 | 2345812 | 2022-03-26 | Jerauld | South Dakota | 46073 | 415 | 20 |
2342530 | 2342530 | 2022-03-25 | Brule | South Dakota | 46015 | 1409 | 20 |
2342559 | 2342559 | 2022-03-25 | Jerauld | South Dakota | 46073 | 415 | 20 |
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);