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-11-21 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
754139 | 754139 | 2020-11-21 | Aurora | South Dakota | 46003 | 325 | 3 |
754140 | 754140 | 2020-11-21 | Beadle | South Dakota | 46005 | 2129 | 25 |
754141 | 754141 | 2020-11-21 | Bennett | South Dakota | 46007 | 299 | 5 |
754142 | 754142 | 2020-11-21 | Bon Homme | South Dakota | 46009 | 1301 | 13 |
754143 | 754143 | 2020-11-21 | Brookings | South Dakota | 46011 | 2222 | 16 |
754144 | 754144 | 2020-11-21 | Brown | South Dakota | 46013 | 3213 | 14 |
754145 | 754145 | 2020-11-21 | Brule | South Dakota | 46015 | 517 | 5 |
754146 | 754146 | 2020-11-21 | Buffalo | South Dakota | 46017 | 359 | 6 |
754147 | 754147 | 2020-11-21 | Butte | South Dakota | 46019 | 646 | 12 |
754148 | 754148 | 2020-11-21 | Campbell | South Dakota | 46021 | 97 | 1 |
754149 | 754149 | 2020-11-21 | Charles Mix | South Dakota | 46023 | 744 | 4 |
754150 | 754150 | 2020-11-21 | Clark | South Dakota | 46025 | 224 | 1 |
754151 | 754151 | 2020-11-21 | Clay | South Dakota | 46027 | 1214 | 9 |
754152 | 754152 | 2020-11-21 | Codington | South Dakota | 46029 | 2450 | 37 |
754153 | 754153 | 2020-11-21 | Corson | South Dakota | 46031 | 343 | 3 |
754154 | 754154 | 2020-11-21 | Custer | South Dakota | 46033 | 484 | 7 |
754155 | 754155 | 2020-11-21 | Davison | South Dakota | 46035 | 2197 | 25 |
754156 | 754156 | 2020-11-21 | Day | South Dakota | 46037 | 310 | 5 |
754157 | 754157 | 2020-11-21 | Deuel | South Dakota | 46039 | 277 | 2 |
754158 | 754158 | 2020-11-21 | Dewey | South Dakota | 46041 | 730 | 2 |
754159 | 754159 | 2020-11-21 | Douglas | South Dakota | 46043 | 272 | 5 |
754160 | 754160 | 2020-11-21 | Edmunds | South Dakota | 46045 | 226 | 1 |
754161 | 754161 | 2020-11-21 | Fall River | South Dakota | 46047 | 343 | 8 |
754162 | 754162 | 2020-11-21 | Faulk | South Dakota | 46049 | 271 | 8 |
754163 | 754163 | 2020-11-21 | Grant | South Dakota | 46051 | 539 | 5 |
754164 | 754164 | 2020-11-21 | Gregory | South Dakota | 46053 | 402 | 17 |
754165 | 754165 | 2020-11-21 | Haakon | South Dakota | 46055 | 131 | 3 |
754166 | 754166 | 2020-11-21 | Hamlin | South Dakota | 46057 | 427 | 1 |
754167 | 754167 | 2020-11-21 | Hand | South Dakota | 46059 | 264 | 1 |
754168 | 754168 | 2020-11-21 | Hanson | South Dakota | 46061 | 211 | 1 |
754169 | 754169 | 2020-11-21 | Harding | South Dakota | 46063 | 64 | 0 |
754170 | 754170 | 2020-11-21 | Hughes | South Dakota | 46065 | 1513 | 17 |
754171 | 754171 | 2020-11-21 | Hutchinson | South Dakota | 46067 | 499 | 3 |
754172 | 754172 | 2020-11-21 | Hyde | South Dakota | 46069 | 112 | 0 |
754173 | 754173 | 2020-11-21 | Jackson | South Dakota | 46071 | 185 | 6 |
754174 | 754174 | 2020-11-21 | Jerauld | South Dakota | 46073 | 229 | 13 |
754175 | 754175 | 2020-11-21 | Jones | South Dakota | 46075 | 55 | 0 |
754176 | 754176 | 2020-11-21 | Kingsbury | South Dakota | 46077 | 397 | 8 |
754177 | 754177 | 2020-11-21 | Lake | South Dakota | 46079 | 760 | 9 |
754178 | 754178 | 2020-11-21 | Lawrence | South Dakota | 46081 | 1790 | 18 |
754179 | 754179 | 2020-11-21 | Lincoln | South Dakota | 46083 | 4921 | 44 |
754180 | 754180 | 2020-11-21 | Lyman | South Dakota | 46085 | 422 | 8 |
754181 | 754181 | 2020-11-21 | Marshall | South Dakota | 46091 | 143 | 3 |
754182 | 754182 | 2020-11-21 | McCook | South Dakota | 46087 | 551 | 11 |
754183 | 754183 | 2020-11-21 | McPherson | South Dakota | 46089 | 129 | 1 |
754184 | 754184 | 2020-11-21 | Meade | South Dakota | 46093 | 1553 | 12 |
754185 | 754185 | 2020-11-21 | Mellette | South Dakota | 46095 | 152 | 1 |
754186 | 754186 | 2020-11-21 | Miner | South Dakota | 46097 | 181 | 4 |
754187 | 754187 | 2020-11-21 | Minnehaha | South Dakota | 46099 | 18533 | 155 |
754188 | 754188 | 2020-11-21 | Moody | South Dakota | 46101 | 378 | 10 |
754189 | 754189 | 2020-11-21 | Oglala Lakota | South Dakota | 46102 | 1518 | 17 |
754190 | 754190 | 2020-11-21 | Pennington | South Dakota | 46103 | 7679 | 65 |
754191 | 754191 | 2020-11-21 | Perkins | South Dakota | 46105 | 153 | 2 |
754192 | 754192 | 2020-11-21 | Potter | South Dakota | 46107 | 236 | 1 |
754193 | 754193 | 2020-11-21 | Roberts | South Dakota | 46109 | 634 | 17 |
754194 | 754194 | 2020-11-21 | Sanborn | South Dakota | 46111 | 238 | 1 |
754195 | 754195 | 2020-11-21 | Spink | South Dakota | 46115 | 506 | 11 |
754196 | 754196 | 2020-11-21 | Stanley | South Dakota | 46117 | 212 | 0 |
754197 | 754197 | 2020-11-21 | Sully | South Dakota | 46119 | 84 | 2 |
754198 | 754198 | 2020-11-21 | Todd | South Dakota | 46121 | 816 | 10 |
754199 | 754199 | 2020-11-21 | Tripp | South Dakota | 46123 | 441 | 2 |
754200 | 754200 | 2020-11-21 | Turner | South Dakota | 46125 | 751 | 35 |
754201 | 754201 | 2020-11-21 | Union | South Dakota | 46127 | 1148 | 23 |
754202 | 754202 | 2020-11-21 | Walworth | South Dakota | 46129 | 431 | 10 |
754203 | 754203 | 2020-11-21 | Yankton | South Dakota | 46135 | 1474 | 8 |
754204 | 754204 | 2020-11-21 | Ziebach | South Dakota | 46137 | 159 | 5 |
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);