ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where date = "2020-10-29" 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 |
---|---|---|---|---|---|---|---|
679523 | 679523 | 2020-10-29 | Aurora | South Dakota | 46003 | 180 | 0 |
679524 | 679524 | 2020-10-29 | Beadle | South Dakota | 46005 | 1290 | 14 |
679525 | 679525 | 2020-10-29 | Bennett | South Dakota | 46007 | 187 | 5 |
679526 | 679526 | 2020-10-29 | Bon Homme | South Dakota | 46009 | 950 | 1 |
679527 | 679527 | 2020-10-29 | Brookings | South Dakota | 46011 | 1466 | 5 |
679528 | 679528 | 2020-10-29 | Brown | South Dakota | 46013 | 2033 | 5 |
679529 | 679529 | 2020-10-29 | Brule | South Dakota | 46015 | 292 | 2 |
679530 | 679530 | 2020-10-29 | Buffalo | South Dakota | 46017 | 254 | 4 |
679531 | 679531 | 2020-10-29 | Butte | South Dakota | 46019 | 368 | 3 |
679532 | 679532 | 2020-10-29 | Campbell | South Dakota | 46021 | 75 | 1 |
679533 | 679533 | 2020-10-29 | Charles Mix | South Dakota | 46023 | 398 | 0 |
679534 | 679534 | 2020-10-29 | Clark | South Dakota | 46025 | 118 | 0 |
679535 | 679535 | 2020-10-29 | Clay | South Dakota | 46027 | 829 | 8 |
679536 | 679536 | 2020-10-29 | Codington | South Dakota | 46029 | 1502 | 13 |
679537 | 679537 | 2020-10-29 | Corson | South Dakota | 46031 | 206 | 1 |
679538 | 679538 | 2020-10-29 | Custer | South Dakota | 46033 | 316 | 3 |
679539 | 679539 | 2020-10-29 | Davison | South Dakota | 46035 | 957 | 10 |
679540 | 679540 | 2020-10-29 | Day | South Dakota | 46037 | 160 | 2 |
679541 | 679541 | 2020-10-29 | Deuel | South Dakota | 46039 | 189 | 1 |
679542 | 679542 | 2020-10-29 | Dewey | South Dakota | 46041 | 330 | 0 |
679543 | 679543 | 2020-10-29 | Douglas | South Dakota | 46043 | 165 | 4 |
679544 | 679544 | 2020-10-29 | Edmunds | South Dakota | 46045 | 144 | 1 |
679545 | 679545 | 2020-10-29 | Fall River | South Dakota | 46047 | 210 | 6 |
679546 | 679546 | 2020-10-29 | Faulk | South Dakota | 46049 | 218 | 1 |
679547 | 679547 | 2020-10-29 | Grant | South Dakota | 46051 | 305 | 2 |
679548 | 679548 | 2020-10-29 | Gregory | South Dakota | 46053 | 233 | 10 |
679549 | 679549 | 2020-10-29 | Haakon | South Dakota | 46055 | 98 | 1 |
679550 | 679550 | 2020-10-29 | Hamlin | South Dakota | 46057 | 199 | 0 |
679551 | 679551 | 2020-10-29 | Hand | South Dakota | 46059 | 131 | 1 |
679552 | 679552 | 2020-10-29 | Hanson | South Dakota | 46061 | 96 | 1 |
679553 | 679553 | 2020-10-29 | Harding | South Dakota | 46063 | 56 | 0 |
679554 | 679554 | 2020-10-29 | Hughes | South Dakota | 46065 | 854 | 7 |
679555 | 679555 | 2020-10-29 | Hutchinson | South Dakota | 46067 | 239 | 2 |
679556 | 679556 | 2020-10-29 | Hyde | South Dakota | 46069 | 44 | 0 |
679557 | 679557 | 2020-10-29 | Jackson | South Dakota | 46071 | 126 | 1 |
679558 | 679558 | 2020-10-29 | Jerauld | South Dakota | 46073 | 162 | 12 |
679559 | 679559 | 2020-10-29 | Jones | South Dakota | 46075 | 32 | 0 |
679560 | 679560 | 2020-10-29 | Kingsbury | South Dakota | 46077 | 191 | 2 |
679561 | 679561 | 2020-10-29 | Lake | South Dakota | 46079 | 389 | 9 |
679562 | 679562 | 2020-10-29 | Lawrence | South Dakota | 46081 | 925 | 6 |
679563 | 679563 | 2020-10-29 | Lincoln | South Dakota | 46083 | 2830 | 20 |
679564 | 679564 | 2020-10-29 | Lyman | South Dakota | 46085 | 277 | 5 |
679565 | 679565 | 2020-10-29 | Marshall | South Dakota | 46091 | 65 | 1 |
679566 | 679566 | 2020-10-29 | McCook | South Dakota | 46087 | 250 | 1 |
679567 | 679567 | 2020-10-29 | McPherson | South Dakota | 46089 | 72 | 0 |
679568 | 679568 | 2020-10-29 | Meade | South Dakota | 46093 | 962 | 10 |
679569 | 679569 | 2020-10-29 | Mellette | South Dakota | 46095 | 83 | 1 |
679570 | 679570 | 2020-10-29 | Miner | South Dakota | 46097 | 142 | 1 |
679571 | 679571 | 2020-10-29 | Minnehaha | South Dakota | 46099 | 11495 | 110 |
679572 | 679572 | 2020-10-29 | Moody | South Dakota | 46101 | 219 | 2 |
679573 | 679573 | 2020-10-29 | Oglala Lakota | South Dakota | 46102 | 953 | 6 |
679574 | 679574 | 2020-10-29 | Pennington | South Dakota | 46103 | 4466 | 48 |
679575 | 679575 | 2020-10-29 | Perkins | South Dakota | 46105 | 80 | 0 |
679576 | 679576 | 2020-10-29 | Potter | South Dakota | 46107 | 107 | 0 |
679577 | 679577 | 2020-10-29 | Roberts | South Dakota | 46109 | 348 | 5 |
679578 | 679578 | 2020-10-29 | Sanborn | South Dakota | 46111 | 102 | 1 |
679579 | 679579 | 2020-10-29 | Spink | South Dakota | 46115 | 278 | 1 |
679580 | 679580 | 2020-10-29 | Stanley | South Dakota | 46117 | 92 | 0 |
679581 | 679581 | 2020-10-29 | Sully | South Dakota | 46119 | 41 | 0 |
679582 | 679582 | 2020-10-29 | Todd | South Dakota | 46121 | 469 | 6 |
679583 | 679583 | 2020-10-29 | Tripp | South Dakota | 46123 | 271 | 2 |
679584 | 679584 | 2020-10-29 | Turner | South Dakota | 46125 | 483 | 16 |
679585 | 679585 | 2020-10-29 | Union | South Dakota | 46127 | 758 | 11 |
679586 | 679586 | 2020-10-29 | Walworth | South Dakota | 46129 | 271 | 5 |
679587 | 679587 | 2020-10-29 | Yankton | South Dakota | 46135 | 876 | 5 |
679588 | 679588 | 2020-10-29 | Ziebach | South Dakota | 46137 | 93 | 2 |
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);