ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where "date" is on date 2020-09-27 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
575742 | 575742 | 2020-09-27 | Aurora | South Dakota | 46003 | 54 | 0 |
575743 | 575743 | 2020-09-27 | Beadle | South Dakota | 46005 | 791 | 9 |
575744 | 575744 | 2020-09-27 | Bennett | South Dakota | 46007 | 67 | 1 |
575745 | 575745 | 2020-09-27 | Bon Homme | South Dakota | 46009 | 84 | 1 |
575746 | 575746 | 2020-09-27 | Brookings | South Dakota | 46011 | 763 | 2 |
575747 | 575747 | 2020-09-27 | Brown | South Dakota | 46013 | 1189 | 4 |
575748 | 575748 | 2020-09-27 | Brule | South Dakota | 46015 | 120 | 0 |
575749 | 575749 | 2020-09-27 | Buffalo | South Dakota | 46017 | 138 | 3 |
575750 | 575750 | 2020-09-27 | Butte | South Dakota | 46019 | 102 | 3 |
575751 | 575751 | 2020-09-27 | Campbell | South Dakota | 46021 | 29 | 0 |
575752 | 575752 | 2020-09-27 | Charles Mix | South Dakota | 46023 | 173 | 0 |
575753 | 575753 | 2020-09-27 | Clark | South Dakota | 46025 | 40 | 0 |
575754 | 575754 | 2020-09-27 | Clay | South Dakota | 46027 | 563 | 5 |
575755 | 575755 | 2020-09-27 | Codington | South Dakota | 46029 | 872 | 4 |
575756 | 575756 | 2020-09-27 | Corson | South Dakota | 46031 | 91 | 1 |
575757 | 575757 | 2020-09-27 | Custer | South Dakota | 46033 | 185 | 2 |
575758 | 575758 | 2020-09-27 | Davison | South Dakota | 46035 | 295 | 2 |
575759 | 575759 | 2020-09-27 | Day | South Dakota | 46037 | 76 | 0 |
575760 | 575760 | 2020-09-27 | Deuel | South Dakota | 46039 | 84 | 0 |
575761 | 575761 | 2020-09-27 | Dewey | South Dakota | 46041 | 144 | 0 |
575762 | 575762 | 2020-09-27 | Douglas | South Dakota | 46043 | 80 | 1 |
575763 | 575763 | 2020-09-27 | Edmunds | South Dakota | 46045 | 93 | 0 |
575764 | 575764 | 2020-09-27 | Fall River | South Dakota | 46047 | 94 | 3 |
575765 | 575765 | 2020-09-27 | Faulk | South Dakota | 46049 | 73 | 1 |
575766 | 575766 | 2020-09-27 | Grant | South Dakota | 46051 | 128 | 1 |
575767 | 575767 | 2020-09-27 | Gregory | South Dakota | 46053 | 127 | 3 |
575768 | 575768 | 2020-09-27 | Haakon | South Dakota | 46055 | 24 | 0 |
575769 | 575769 | 2020-09-27 | Hamlin | South Dakota | 46057 | 99 | 0 |
575770 | 575770 | 2020-09-27 | Hand | South Dakota | 46059 | 38 | 0 |
575771 | 575771 | 2020-09-27 | Hanson | South Dakota | 46061 | 38 | 0 |
575772 | 575772 | 2020-09-27 | Harding | South Dakota | 46063 | 4 | 0 |
575773 | 575773 | 2020-09-27 | Hughes | South Dakota | 46065 | 437 | 5 |
575774 | 575774 | 2020-09-27 | Hutchinson | South Dakota | 46067 | 99 | 2 |
575775 | 575775 | 2020-09-27 | Hyde | South Dakota | 46069 | 19 | 0 |
575776 | 575776 | 2020-09-27 | Jackson | South Dakota | 46071 | 34 | 1 |
575777 | 575777 | 2020-09-27 | Jerauld | South Dakota | 46073 | 84 | 1 |
575778 | 575778 | 2020-09-27 | Jones | South Dakota | 46075 | 13 | 0 |
575779 | 575779 | 2020-09-27 | Kingsbury | South Dakota | 46077 | 55 | 0 |
575780 | 575780 | 2020-09-27 | Lake | South Dakota | 46079 | 195 | 7 |
575781 | 575781 | 2020-09-27 | Lawrence | South Dakota | 46081 | 402 | 4 |
575782 | 575782 | 2020-09-27 | Lincoln | South Dakota | 46083 | 1355 | 2 |
575783 | 575783 | 2020-09-27 | Lyman | South Dakota | 46085 | 160 | 3 |
575784 | 575784 | 2020-09-27 | Marshall | South Dakota | 46091 | 38 | 0 |
575785 | 575785 | 2020-09-27 | McCook | South Dakota | 46087 | 96 | 1 |
575786 | 575786 | 2020-09-27 | McPherson | South Dakota | 46089 | 33 | 0 |
575787 | 575787 | 2020-09-27 | Meade | South Dakota | 46093 | 537 | 5 |
575788 | 575788 | 2020-09-27 | Mellette | South Dakota | 46095 | 30 | 0 |
575789 | 575789 | 2020-09-27 | Miner | South Dakota | 46097 | 23 | 0 |
575790 | 575790 | 2020-09-27 | Minnehaha | South Dakota | 46099 | 6650 | 81 |
575791 | 575791 | 2020-09-27 | Moody | South Dakota | 46101 | 90 | 0 |
575792 | 575792 | 2020-09-27 | Oglala Lakota | South Dakota | 46102 | 281 | 3 |
575793 | 575793 | 2020-09-27 | Pennington | South Dakota | 46103 | 2311 | 37 |
575794 | 575794 | 2020-09-27 | Perkins | South Dakota | 46105 | 38 | 0 |
575795 | 575795 | 2020-09-27 | Potter | South Dakota | 46107 | 43 | 0 |
575796 | 575796 | 2020-09-27 | Roberts | South Dakota | 46109 | 209 | 1 |
575797 | 575797 | 2020-09-27 | Sanborn | South Dakota | 46111 | 29 | 0 |
575798 | 575798 | 2020-09-27 | Spink | South Dakota | 46115 | 134 | 0 |
575799 | 575799 | 2020-09-27 | Stanley | South Dakota | 46117 | 41 | 0 |
575800 | 575800 | 2020-09-27 | Sully | South Dakota | 46119 | 11 | 0 |
575801 | 575801 | 2020-09-27 | Todd | South Dakota | 46121 | 120 | 5 |
575802 | 575802 | 2020-09-27 | Tripp | South Dakota | 46123 | 155 | 0 |
575803 | 575803 | 2020-09-27 | Turner | South Dakota | 46125 | 162 | 2 |
575804 | 575804 | 2020-09-27 | Union | South Dakota | 46127 | 402 | 7 |
575805 | 575805 | 2020-09-27 | Walworth | South Dakota | 46129 | 123 | 1 |
575806 | 575806 | 2020-09-27 | Yankton | South Dakota | 46135 | 413 | 4 |
575807 | 575807 | 2020-09-27 | Ziebach | South Dakota | 46137 | 61 | 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);