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 221
- 46023 221
- 46035 221
- 46099 221
- 46009 220
- 46087 218
- 46013 209
- 46029 208
- 46065 208
- 46085 208
- 46103 208
- 46011 207
- 46083 206
- 46093 206
- 46003 204
- 46049 204
- 46081 204
- 46121 204
- 46127 204
- 46039 203
- 46057 203
- 46067 203
- 46135 203
- 46025 202
- 46027 202
- 46047 202
- 46109 202
- 46125 202
- 46091 201
- 46079 198
- …
county >30
- Beadle 221
- Charles Mix 221
- Davison 221
- Minnehaha 221
- Bon Homme 220
- McCook 218
- Brown 209
- Codington 208
- Hughes 208
- Lyman 208
- Pennington 208
- Brookings 207
- Lincoln 206
- Meade 206
- Aurora 204
- Faulk 204
- Lawrence 204
- Todd 204
- Union 204
- Deuel 203
- Hamlin 203
- Hutchinson 203
- Yankton 203
- Clark 202
- Clay 202
- Fall River 202
- Roberts 202
- Turner 202
- Marshall 201
- Lake 198
- …
state 1
- South Dakota · 11,668 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637344 | 637344 | 2020-10-16 | Aurora | South Dakota | 46003 | 148 | 0 |
637345 | 637345 | 2020-10-16 | Beadle | South Dakota | 46005 | 1033 | 12 |
637346 | 637346 | 2020-10-16 | Bennett | South Dakota | 46007 | 121 | 4 |
637347 | 637347 | 2020-10-16 | Bon Homme | South Dakota | 46009 | 200 | 1 |
637348 | 637348 | 2020-10-16 | Brookings | South Dakota | 46011 | 1109 | 2 |
637349 | 637349 | 2020-10-16 | Brown | South Dakota | 46013 | 1685 | 4 |
637350 | 637350 | 2020-10-16 | Brule | South Dakota | 46015 | 195 | 2 |
637351 | 637351 | 2020-10-16 | Buffalo | South Dakota | 46017 | 192 | 3 |
637352 | 637352 | 2020-10-16 | Butte | South Dakota | 46019 | 210 | 3 |
637353 | 637353 | 2020-10-16 | Campbell | South Dakota | 46021 | 62 | 0 |
637354 | 637354 | 2020-10-16 | Charles Mix | South Dakota | 46023 | 293 | 0 |
637355 | 637355 | 2020-10-16 | Clark | South Dakota | 46025 | 65 | 0 |
637356 | 637356 | 2020-10-16 | Clay | South Dakota | 46027 | 683 | 8 |
637357 | 637357 | 2020-10-16 | Codington | South Dakota | 46029 | 1206 | 10 |
637358 | 637358 | 2020-10-16 | Corson | South Dakota | 46031 | 128 | 1 |
637359 | 637359 | 2020-10-16 | Custer | South Dakota | 46033 | 252 | 3 |
637360 | 637360 | 2020-10-16 | Davison | South Dakota | 46035 | 654 | 5 |
637361 | 637361 | 2020-10-16 | Day | South Dakota | 46037 | 119 | 0 |
637362 | 637362 | 2020-10-16 | Deuel | South Dakota | 46039 | 142 | 0 |
637363 | 637363 | 2020-10-16 | Dewey | South Dakota | 46041 | 257 | 0 |
637364 | 637364 | 2020-10-16 | Douglas | South Dakota | 46043 | 145 | 3 |
637365 | 637365 | 2020-10-16 | Edmunds | South Dakota | 46045 | 117 | 1 |
637366 | 637366 | 2020-10-16 | Fall River | South Dakota | 46047 | 153 | 6 |
637367 | 637367 | 2020-10-16 | Faulk | South Dakota | 46049 | 145 | 1 |
637368 | 637368 | 2020-10-16 | Grant | South Dakota | 46051 | 244 | 2 |
637369 | 637369 | 2020-10-16 | Gregory | South Dakota | 46053 | 171 | 8 |
637370 | 637370 | 2020-10-16 | Haakon | South Dakota | 46055 | 59 | 1 |
637371 | 637371 | 2020-10-16 | Hamlin | South Dakota | 46057 | 147 | 0 |
637372 | 637372 | 2020-10-16 | Hand | South Dakota | 46059 | 84 | 1 |
637373 | 637373 | 2020-10-16 | Hanson | South Dakota | 46061 | 63 | 1 |
637374 | 637374 | 2020-10-16 | Harding | South Dakota | 46063 | 18 | 0 |
637375 | 637375 | 2020-10-16 | Hughes | South Dakota | 46065 | 702 | 5 |
637376 | 637376 | 2020-10-16 | Hutchinson | South Dakota | 46067 | 176 | 2 |
637377 | 637377 | 2020-10-16 | Hyde | South Dakota | 46069 | 32 | 0 |
637378 | 637378 | 2020-10-16 | Jackson | South Dakota | 46071 | 72 | 1 |
637379 | 637379 | 2020-10-16 | Jerauld | South Dakota | 46073 | 153 | 6 |
637380 | 637380 | 2020-10-16 | Jones | South Dakota | 46075 | 24 | 0 |
637381 | 637381 | 2020-10-16 | Kingsbury | South Dakota | 46077 | 123 | 0 |
637382 | 637382 | 2020-10-16 | Lake | South Dakota | 46079 | 284 | 8 |
637383 | 637383 | 2020-10-16 | Lawrence | South Dakota | 46081 | 630 | 5 |
637384 | 637384 | 2020-10-16 | Lincoln | South Dakota | 46083 | 2094 | 11 |
637385 | 637385 | 2020-10-16 | Lyman | South Dakota | 46085 | 207 | 4 |
637386 | 637386 | 2020-10-16 | Marshall | South Dakota | 46091 | 54 | 0 |
637387 | 637387 | 2020-10-16 | McCook | South Dakota | 46087 | 171 | 1 |
637388 | 637388 | 2020-10-16 | McPherson | South Dakota | 46089 | 53 | 0 |
637389 | 637389 | 2020-10-16 | Meade | South Dakota | 46093 | 773 | 8 |
637390 | 637390 | 2020-10-16 | Mellette | South Dakota | 46095 | 47 | 0 |
637391 | 637391 | 2020-10-16 | Miner | South Dakota | 46097 | 94 | 0 |
637392 | 637392 | 2020-10-16 | Minnehaha | South Dakota | 46099 | 8712 | 92 |
637393 | 637393 | 2020-10-16 | Moody | South Dakota | 46101 | 159 | 1 |
637394 | 637394 | 2020-10-16 | Oglala Lakota | South Dakota | 46102 | 518 | 5 |
637395 | 637395 | 2020-10-16 | Pennington | South Dakota | 46103 | 3468 | 42 |
637396 | 637396 | 2020-10-16 | Perkins | South Dakota | 46105 | 59 | 0 |
637397 | 637397 | 2020-10-16 | Potter | South Dakota | 46107 | 82 | 0 |
637398 | 637398 | 2020-10-16 | Roberts | South Dakota | 46109 | 266 | 2 |
637399 | 637399 | 2020-10-16 | Sanborn | South Dakota | 46111 | 66 | 0 |
637400 | 637400 | 2020-10-16 | Spink | South Dakota | 46115 | 206 | 1 |
637401 | 637401 | 2020-10-16 | Stanley | South Dakota | 46117 | 65 | 0 |
637402 | 637402 | 2020-10-16 | Sully | South Dakota | 46119 | 27 | 0 |
637403 | 637403 | 2020-10-16 | Todd | South Dakota | 46121 | 292 | 5 |
637404 | 637404 | 2020-10-16 | Tripp | South Dakota | 46123 | 223 | 1 |
637405 | 637405 | 2020-10-16 | Turner | South Dakota | 46125 | 341 | 8 |
637406 | 637406 | 2020-10-16 | Union | South Dakota | 46127 | 630 | 10 |
637407 | 637407 | 2020-10-16 | Walworth | South Dakota | 46129 | 234 | 1 |
637408 | 637408 | 2020-10-16 | Yankton | South Dakota | 46135 | 590 | 5 |
637409 | 637409 | 2020-10-16 | Ziebach | South Dakota | 46137 | 78 | 1 |
634098 | 634098 | 2020-10-15 | Aurora | South Dakota | 46003 | 145 | 0 |
634099 | 634099 | 2020-10-15 | Beadle | South Dakota | 46005 | 1016 | 12 |
634100 | 634100 | 2020-10-15 | Bennett | South Dakota | 46007 | 119 | 4 |
634101 | 634101 | 2020-10-15 | Bon Homme | South Dakota | 46009 | 191 | 1 |
634102 | 634102 | 2020-10-15 | Brookings | South Dakota | 46011 | 1085 | 2 |
634103 | 634103 | 2020-10-15 | Brown | South Dakota | 46013 | 1650 | 4 |
634104 | 634104 | 2020-10-15 | Brule | South Dakota | 46015 | 189 | 2 |
634105 | 634105 | 2020-10-15 | Buffalo | South Dakota | 46017 | 187 | 3 |
634106 | 634106 | 2020-10-15 | Butte | South Dakota | 46019 | 184 | 3 |
634107 | 634107 | 2020-10-15 | Campbell | South Dakota | 46021 | 57 | 0 |
634108 | 634108 | 2020-10-15 | Charles Mix | South Dakota | 46023 | 289 | 0 |
634109 | 634109 | 2020-10-15 | Clark | South Dakota | 46025 | 61 | 0 |
634110 | 634110 | 2020-10-15 | Clay | South Dakota | 46027 | 677 | 8 |
634111 | 634111 | 2020-10-15 | Codington | South Dakota | 46029 | 1180 | 10 |
634112 | 634112 | 2020-10-15 | Corson | South Dakota | 46031 | 125 | 1 |
634113 | 634113 | 2020-10-15 | Custer | South Dakota | 46033 | 242 | 3 |
634114 | 634114 | 2020-10-15 | Davison | South Dakota | 46035 | 635 | 5 |
634115 | 634115 | 2020-10-15 | Day | South Dakota | 46037 | 118 | 0 |
634116 | 634116 | 2020-10-15 | Deuel | South Dakota | 46039 | 137 | 0 |
634117 | 634117 | 2020-10-15 | Dewey | South Dakota | 46041 | 252 | 0 |
634118 | 634118 | 2020-10-15 | Douglas | South Dakota | 46043 | 142 | 2 |
634119 | 634119 | 2020-10-15 | Edmunds | South Dakota | 46045 | 113 | 0 |
634120 | 634120 | 2020-10-15 | Fall River | South Dakota | 46047 | 149 | 6 |
634121 | 634121 | 2020-10-15 | Faulk | South Dakota | 46049 | 145 | 1 |
634122 | 634122 | 2020-10-15 | Grant | South Dakota | 46051 | 237 | 2 |
634123 | 634123 | 2020-10-15 | Gregory | South Dakota | 46053 | 170 | 8 |
634124 | 634124 | 2020-10-15 | Haakon | South Dakota | 46055 | 57 | 1 |
634125 | 634125 | 2020-10-15 | Hamlin | South Dakota | 46057 | 144 | 0 |
634126 | 634126 | 2020-10-15 | Hand | South Dakota | 46059 | 81 | 1 |
634127 | 634127 | 2020-10-15 | Hanson | South Dakota | 46061 | 61 | 1 |
634128 | 634128 | 2020-10-15 | Harding | South Dakota | 46063 | 16 | 0 |
634129 | 634129 | 2020-10-15 | Hughes | South Dakota | 46065 | 684 | 5 |
634130 | 634130 | 2020-10-15 | Hutchinson | South Dakota | 46067 | 174 | 2 |
634131 | 634131 | 2020-10-15 | Hyde | South Dakota | 46069 | 30 | 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);