ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 69 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
903462 | 903462 | 2021-01-06 | Jones | South Dakota | 46075 | 69 | 0 |
900217 | 900217 | 2021-01-05 | Jones | South Dakota | 46075 | 69 | 0 |
695782 | 695782 | 2020-11-03 | Marshall | South Dakota | 46091 | 69 | 1 |
676324 | 676324 | 2020-10-28 | McPherson | South Dakota | 46089 | 69 | 0 |
656870 | 656870 | 2020-10-22 | Perkins | South Dakota | 46105 | 69 | 0 |
634132 | 634132 | 2020-10-15 | Jackson | South Dakota | 46071 | 69 | 1 |
627656 | 627656 | 2020-10-13 | Miner | South Dakota | 46097 | 69 | 0 |
614692 | 614692 | 2020-10-09 | Potter | South Dakota | 46107 | 69 | 0 |
608221 | 608221 | 2020-10-07 | Ziebach | South Dakota | 46137 | 69 | 1 |
604950 | 604950 | 2020-10-06 | Kingsbury | South Dakota | 46077 | 69 | 0 |
588705 | 588705 | 2020-10-01 | Bennett | South Dakota | 46007 | 69 | 3 |
549873 | 549873 | 2020-09-19 | Moody | South Dakota | 46101 | 69 | 0 |
540115 | 540115 | 2020-09-16 | Bon Homme | South Dakota | 46009 | 69 | 1 |
540120 | 540120 | 2020-09-16 | Butte | South Dakota | 46019 | 69 | 1 |
536896 | 536896 | 2020-09-15 | Edmunds | South Dakota | 46045 | 69 | 0 |
536938 | 536938 | 2020-09-15 | Walworth | South Dakota | 46129 | 69 | 0 |
530467 | 530467 | 2020-09-13 | Walworth | South Dakota | 46129 | 69 | 0 |
511018 | 511018 | 2020-09-07 | Hamlin | South Dakota | 46057 | 69 | 0 |
465790 | 465790 | 2020-08-24 | Turner | South Dakota | 46125 | 69 | 0 |
436721 | 436721 | 2020-08-15 | Lawrence | South Dakota | 46081 | 69 | 1 |
423839 | 423839 | 2020-08-11 | Todd | South Dakota | 46121 | 69 | 5 |
420617 | 420617 | 2020-08-10 | Todd | South Dakota | 46121 | 69 | 5 |
417396 | 417396 | 2020-08-09 | Todd | South Dakota | 46121 | 69 | 5 |
414175 | 414175 | 2020-08-08 | Todd | South Dakota | 46121 | 69 | 5 |
388428 | 388428 | 2020-07-31 | Roberts | South Dakota | 46109 | 69 | 1 |
385202 | 385202 | 2020-07-30 | Meade | South Dakota | 46093 | 69 | 1 |
385211 | 385211 | 2020-07-30 | Roberts | South Dakota | 46109 | 69 | 1 |
378760 | 378760 | 2020-07-28 | Lake | South Dakota | 46079 | 69 | 2 |
353070 | 353070 | 2020-07-20 | Davison | South Dakota | 46035 | 69 | 1 |
324329 | 324329 | 2020-07-11 | Hughes | South Dakota | 46065 | 69 | 2 |
298970 | 298970 | 2020-07-03 | Lyman | South Dakota | 46085 | 69 | 1 |
276883 | 276883 | 2020-06-26 | Buffalo | South Dakota | 46017 | 69 | 1 |
264385 | 264385 | 2020-06-22 | Yankton | South Dakota | 46135 | 69 | 0 |
248727 | 248727 | 2020-06-17 | Clay | South Dakota | 46027 | 69 | 0 |
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);