ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,552 rows where state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 46005 123
- 46023 123
- 46035 123
- 46099 123
- 46009 122
- 46087 120
- 46013 111
- 46029 110
- 46065 110
- 46085 110
- 46103 110
- 46011 109
- 46083 108
- 46093 108
- 46003 106
- 46049 106
- 46081 106
- 46121 106
- 46127 106
- 46039 105
- 46057 105
- 46067 105
- 46135 105
- 46025 104
- 46027 104
- 46047 104
- 46109 104
- 46125 104
- 46091 103
- 46079 100
- …
county >30
- Beadle 123
- Charles Mix 123
- Davison 123
- Minnehaha 123
- Bon Homme 122
- McCook 120
- Brown 111
- Codington 110
- Hughes 110
- Lyman 110
- Pennington 110
- Brookings 109
- Lincoln 108
- Meade 108
- Aurora 106
- Faulk 106
- Lawrence 106
- Todd 106
- Union 106
- Deuel 105
- Hamlin 105
- Hutchinson 105
- Yankton 105
- Clark 104
- Clay 104
- Fall River 104
- Roberts 104
- Turner 104
- Marshall 103
- Lake 100
- …
state 1
- South Dakota · 5,243 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
321119 | 321119 | 2020-07-10 | Aurora | South Dakota | 46003 | 34 | 0 |
321120 | 321120 | 2020-07-10 | Beadle | South Dakota | 46005 | 551 | 7 |
321121 | 321121 | 2020-07-10 | Bennett | South Dakota | 46007 | 4 | 0 |
321122 | 321122 | 2020-07-10 | Bon Homme | South Dakota | 46009 | 13 | 0 |
321123 | 321123 | 2020-07-10 | Brookings | South Dakota | 46011 | 90 | 0 |
321124 | 321124 | 2020-07-10 | Brown | South Dakota | 46013 | 354 | 2 |
321125 | 321125 | 2020-07-10 | Brule | South Dakota | 46015 | 33 | 0 |
321126 | 321126 | 2020-07-10 | Buffalo | South Dakota | 46017 | 83 | 3 |
321127 | 321127 | 2020-07-10 | Butte | South Dakota | 46019 | 2 | 0 |
321128 | 321128 | 2020-07-10 | Campbell | South Dakota | 46021 | 1 | 0 |
321129 | 321129 | 2020-07-10 | Charles Mix | South Dakota | 46023 | 96 | 0 |
321130 | 321130 | 2020-07-10 | Clark | South Dakota | 46025 | 15 | 0 |
321131 | 321131 | 2020-07-10 | Clay | South Dakota | 46027 | 93 | 0 |
321132 | 321132 | 2020-07-10 | Codington | South Dakota | 46029 | 92 | 0 |
321133 | 321133 | 2020-07-10 | Corson | South Dakota | 46031 | 19 | 0 |
321134 | 321134 | 2020-07-10 | Custer | South Dakota | 46033 | 10 | 0 |
321135 | 321135 | 2020-07-10 | Davison | South Dakota | 46035 | 52 | 1 |
321136 | 321136 | 2020-07-10 | Day | South Dakota | 46037 | 19 | 0 |
321137 | 321137 | 2020-07-10 | Deuel | South Dakota | 46039 | 4 | 0 |
321138 | 321138 | 2020-07-10 | Dewey | South Dakota | 46041 | 33 | 0 |
321139 | 321139 | 2020-07-10 | Douglas | South Dakota | 46043 | 10 | 0 |
321140 | 321140 | 2020-07-10 | Edmunds | South Dakota | 46045 | 8 | 0 |
321141 | 321141 | 2020-07-10 | Fall River | South Dakota | 46047 | 13 | 0 |
321142 | 321142 | 2020-07-10 | Faulk | South Dakota | 46049 | 24 | 1 |
321143 | 321143 | 2020-07-10 | Grant | South Dakota | 46051 | 16 | 0 |
321144 | 321144 | 2020-07-10 | Gregory | South Dakota | 46053 | 5 | 0 |
321145 | 321145 | 2020-07-10 | Haakon | South Dakota | 46055 | 1 | 0 |
321146 | 321146 | 2020-07-10 | Hamlin | South Dakota | 46057 | 13 | 0 |
321147 | 321147 | 2020-07-10 | Hand | South Dakota | 46059 | 7 | 0 |
321148 | 321148 | 2020-07-10 | Hanson | South Dakota | 46061 | 13 | 0 |
321149 | 321149 | 2020-07-10 | Hughes | South Dakota | 46065 | 68 | 2 |
321150 | 321150 | 2020-07-10 | Hutchinson | South Dakota | 46067 | 15 | 0 |
321151 | 321151 | 2020-07-10 | Hyde | South Dakota | 46069 | 3 | 0 |
321152 | 321152 | 2020-07-10 | Jackson | South Dakota | 46071 | 6 | 1 |
321153 | 321153 | 2020-07-10 | Jerauld | South Dakota | 46073 | 39 | 1 |
321154 | 321154 | 2020-07-10 | Jones | South Dakota | 46075 | 1 | 0 |
321155 | 321155 | 2020-07-10 | Kingsbury | South Dakota | 46077 | 6 | 0 |
321156 | 321156 | 2020-07-10 | Lake | South Dakota | 46079 | 26 | 1 |
321157 | 321157 | 2020-07-10 | Lawrence | South Dakota | 46081 | 19 | 0 |
321158 | 321158 | 2020-07-10 | Lincoln | South Dakota | 46083 | 384 | 1 |
321159 | 321159 | 2020-07-10 | Lyman | South Dakota | 46085 | 84 | 1 |
321160 | 321160 | 2020-07-10 | Marshall | South Dakota | 46091 | 5 | 0 |
321161 | 321161 | 2020-07-10 | McCook | South Dakota | 46087 | 15 | 1 |
321162 | 321162 | 2020-07-10 | McPherson | South Dakota | 46089 | 5 | 0 |
321163 | 321163 | 2020-07-10 | Meade | South Dakota | 46093 | 53 | 1 |
321164 | 321164 | 2020-07-10 | Mellette | South Dakota | 46095 | 6 | 0 |
321165 | 321165 | 2020-07-10 | Miner | South Dakota | 46097 | 10 | 0 |
321166 | 321166 | 2020-07-10 | Minnehaha | South Dakota | 46099 | 3738 | 60 |
321167 | 321167 | 2020-07-10 | Moody | South Dakota | 46101 | 23 | 0 |
321168 | 321168 | 2020-07-10 | Oglala Lakota | South Dakota | 46102 | 108 | 0 |
321169 | 321169 | 2020-07-10 | Pennington | South Dakota | 46103 | 624 | 20 |
321170 | 321170 | 2020-07-10 | Roberts | South Dakota | 46109 | 53 | 0 |
321171 | 321171 | 2020-07-10 | Sanborn | South Dakota | 46111 | 12 | 0 |
321172 | 321172 | 2020-07-10 | Spink | South Dakota | 46115 | 12 | 0 |
321173 | 321173 | 2020-07-10 | Stanley | South Dakota | 46117 | 14 | 0 |
321174 | 321174 | 2020-07-10 | Sully | South Dakota | 46119 | 1 | 0 |
321175 | 321175 | 2020-07-10 | Todd | South Dakota | 46121 | 65 | 2 |
321176 | 321176 | 2020-07-10 | Tripp | South Dakota | 46123 | 19 | 0 |
321177 | 321177 | 2020-07-10 | Turner | South Dakota | 46125 | 28 | 0 |
321178 | 321178 | 2020-07-10 | Union | South Dakota | 46127 | 148 | 1 |
321179 | 321179 | 2020-07-10 | Walworth | South Dakota | 46129 | 16 | 0 |
321180 | 321180 | 2020-07-10 | Yankton | South Dakota | 46135 | 84 | 1 |
321181 | 321181 | 2020-07-10 | Ziebach | South Dakota | 46137 | 3 | 0 |
317941 | 317941 | 2020-07-09 | Aurora | South Dakota | 46003 | 34 | 0 |
317942 | 317942 | 2020-07-09 | Beadle | South Dakota | 46005 | 551 | 7 |
317943 | 317943 | 2020-07-09 | Bennett | South Dakota | 46007 | 4 | 0 |
317944 | 317944 | 2020-07-09 | Bon Homme | South Dakota | 46009 | 13 | 0 |
317945 | 317945 | 2020-07-09 | Brookings | South Dakota | 46011 | 86 | 0 |
317946 | 317946 | 2020-07-09 | Brown | South Dakota | 46013 | 352 | 2 |
317947 | 317947 | 2020-07-09 | Brule | South Dakota | 46015 | 33 | 0 |
317948 | 317948 | 2020-07-09 | Buffalo | South Dakota | 46017 | 84 | 3 |
317949 | 317949 | 2020-07-09 | Butte | South Dakota | 46019 | 1 | 0 |
317950 | 317950 | 2020-07-09 | Campbell | South Dakota | 46021 | 1 | 0 |
317951 | 317951 | 2020-07-09 | Charles Mix | South Dakota | 46023 | 96 | 0 |
317952 | 317952 | 2020-07-09 | Clark | South Dakota | 46025 | 15 | 0 |
317953 | 317953 | 2020-07-09 | Clay | South Dakota | 46027 | 92 | 0 |
317954 | 317954 | 2020-07-09 | Codington | South Dakota | 46029 | 90 | 0 |
317955 | 317955 | 2020-07-09 | Corson | South Dakota | 46031 | 19 | 0 |
317956 | 317956 | 2020-07-09 | Custer | South Dakota | 46033 | 10 | 0 |
317957 | 317957 | 2020-07-09 | Davison | South Dakota | 46035 | 51 | 1 |
317958 | 317958 | 2020-07-09 | Day | South Dakota | 46037 | 19 | 0 |
317959 | 317959 | 2020-07-09 | Deuel | South Dakota | 46039 | 4 | 0 |
317960 | 317960 | 2020-07-09 | Dewey | South Dakota | 46041 | 27 | 0 |
317961 | 317961 | 2020-07-09 | Douglas | South Dakota | 46043 | 10 | 0 |
317962 | 317962 | 2020-07-09 | Edmunds | South Dakota | 46045 | 8 | 0 |
317963 | 317963 | 2020-07-09 | Fall River | South Dakota | 46047 | 13 | 0 |
317964 | 317964 | 2020-07-09 | Faulk | South Dakota | 46049 | 23 | 1 |
317965 | 317965 | 2020-07-09 | Grant | South Dakota | 46051 | 16 | 0 |
317966 | 317966 | 2020-07-09 | Gregory | South Dakota | 46053 | 5 | 0 |
317967 | 317967 | 2020-07-09 | Haakon | South Dakota | 46055 | 1 | 0 |
317968 | 317968 | 2020-07-09 | Hamlin | South Dakota | 46057 | 13 | 0 |
317969 | 317969 | 2020-07-09 | Hand | South Dakota | 46059 | 7 | 0 |
317970 | 317970 | 2020-07-09 | Hanson | South Dakota | 46061 | 13 | 0 |
317971 | 317971 | 2020-07-09 | Hughes | South Dakota | 46065 | 68 | 0 |
317972 | 317972 | 2020-07-09 | Hutchinson | South Dakota | 46067 | 15 | 0 |
317973 | 317973 | 2020-07-09 | Hyde | South Dakota | 46069 | 3 | 0 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 1 |
317975 | 317975 | 2020-07-09 | Jerauld | South Dakota | 46073 | 39 | 1 |
317976 | 317976 | 2020-07-09 | Jones | South Dakota | 46075 | 1 | 0 |
317977 | 317977 | 2020-07-09 | Kingsbury | South Dakota | 46077 | 6 | 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);