ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where date = "2020-10-16" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
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);