ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where date = "2022-01-29" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2163646 | 2163646 | 2022-01-29 | Aurora | South Dakota | 46003 | 729 | 17 |
2163647 | 2163647 | 2022-01-29 | Beadle | South Dakota | 46005 | 4384 | 51 |
2163648 | 2163648 | 2022-01-29 | Bennett | South Dakota | 46007 | 710 | 9 |
2163649 | 2163649 | 2022-01-29 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2163650 | 2163650 | 2022-01-29 | Brookings | South Dakota | 46011 | 7805 | 43 |
2163651 | 2163651 | 2022-01-29 | Brown | South Dakota | 46013 | 9641 | 113 |
2163652 | 2163652 | 2022-01-29 | Brule | South Dakota | 46015 | 1348 | 18 |
2163653 | 2163653 | 2022-01-29 | Buffalo | South Dakota | 46017 | 595 | 17 |
2163654 | 2163654 | 2022-01-29 | Butte | South Dakota | 46019 | 2537 | 43 |
2163655 | 2163655 | 2022-01-29 | Campbell | South Dakota | 46021 | 250 | 7 |
2163656 | 2163656 | 2022-01-29 | Charles Mix | South Dakota | 46023 | 2763 | 33 |
2163657 | 2163657 | 2022-01-29 | Clark | South Dakota | 46025 | 749 | 6 |
2163658 | 2163658 | 2022-01-29 | Clay | South Dakota | 46027 | 3342 | 19 |
2163659 | 2163659 | 2022-01-29 | Codington | South Dakota | 46029 | 7865 | 94 |
2163660 | 2163660 | 2022-01-29 | Corson | South Dakota | 46031 | 968 | 15 |
2163661 | 2163661 | 2022-01-29 | Custer | South Dakota | 46033 | 1894 | 21 |
2163662 | 2163662 | 2022-01-29 | Davison | South Dakota | 46035 | 5616 | 78 |
2163663 | 2163663 | 2022-01-29 | Day | South Dakota | 46037 | 1209 | 32 |
2163664 | 2163664 | 2022-01-29 | Deuel | South Dakota | 46039 | 990 | 12 |
2163665 | 2163665 | 2022-01-29 | Dewey | South Dakota | 46041 | 2381 | 37 |
2163666 | 2163666 | 2022-01-29 | Douglas | South Dakota | 46043 | 663 | 15 |
2163667 | 2163667 | 2022-01-29 | Edmunds | South Dakota | 46045 | 884 | 16 |
2163668 | 2163668 | 2022-01-29 | Fall River | South Dakota | 46047 | 1660 | 36 |
2163669 | 2163669 | 2022-01-29 | Faulk | South Dakota | 46049 | 515 | 16 |
2163670 | 2163670 | 2022-01-29 | Grant | South Dakota | 46051 | 1955 | 47 |
2163671 | 2163671 | 2022-01-29 | Gregory | South Dakota | 46053 | 1020 | 33 |
2163672 | 2163672 | 2022-01-29 | Haakon | South Dakota | 46055 | 434 | 11 |
2163673 | 2163673 | 2022-01-29 | Hamlin | South Dakota | 46057 | 1431 | 40 |
2163674 | 2163674 | 2022-01-29 | Hand | South Dakota | 46059 | 529 | 8 |
2163675 | 2163675 | 2022-01-29 | Hanson | South Dakota | 46061 | 632 | 6 |
2163676 | 2163676 | 2022-01-29 | Harding | South Dakota | 46063 | 197 | 3 |
2163677 | 2163677 | 2022-01-29 | Hughes | South Dakota | 46065 | 4105 | 57 |
2163678 | 2163678 | 2022-01-29 | Hutchinson | South Dakota | 46067 | 1672 | 33 |
2163679 | 2163679 | 2022-01-29 | Hyde | South Dakota | 46069 | 280 | 5 |
2163680 | 2163680 | 2022-01-29 | Jackson | South Dakota | 46071 | 587 | 20 |
2163681 | 2163681 | 2022-01-29 | Jerauld | South Dakota | 46073 | 387 | 19 |
2163682 | 2163682 | 2022-01-29 | Jones | South Dakota | 46075 | 170 | 1 |
2163683 | 2163683 | 2022-01-29 | Kingsbury | South Dakota | 46077 | 1252 | 20 |
2163684 | 2163684 | 2022-01-29 | Lake | South Dakota | 46079 | 2258 | 26 |
2163685 | 2163685 | 2022-01-29 | Lawrence | South Dakota | 46081 | 6150 | 79 |
2163686 | 2163686 | 2022-01-29 | Lincoln | South Dakota | 46083 | 15086 | 89 |
2163687 | 2163687 | 2022-01-29 | Lyman | South Dakota | 46085 | 1161 | 12 |
2163688 | 2163688 | 2022-01-29 | Marshall | South Dakota | 46091 | 710 | 9 |
2163689 | 2163689 | 2022-01-29 | McCook | South Dakota | 46087 | 1296 | 30 |
2163690 | 2163690 | 2022-01-29 | McPherson | South Dakota | 46089 | 408 | 9 |
2163691 | 2163691 | 2022-01-29 | Meade | South Dakota | 46093 | 6562 | 57 |
2163692 | 2163692 | 2022-01-29 | Mellette | South Dakota | 46095 | 487 | 5 |
2163693 | 2163693 | 2022-01-29 | Miner | South Dakota | 46097 | 446 | 12 |
2163694 | 2163694 | 2022-01-29 | Minnehaha | South Dakota | 46099 | 55414 | 466 |
2163695 | 2163695 | 2022-01-29 | Moody | South Dakota | 46101 | 1269 | 26 |
2163696 | 2163696 | 2022-01-29 | Oglala Lakota | South Dakota | 46102 | 3538 | 56 |
2163697 | 2163697 | 2022-01-29 | Pennington | South Dakota | 46103 | 30904 | 306 |
2163698 | 2163698 | 2022-01-29 | Perkins | South Dakota | 46105 | 645 | 16 |
2163699 | 2163699 | 2022-01-29 | Potter | South Dakota | 46107 | 657 | 6 |
2163700 | 2163700 | 2022-01-29 | Roberts | South Dakota | 46109 | 2224 | 46 |
2163701 | 2163701 | 2022-01-29 | Sanborn | South Dakota | 46111 | 546 | 5 |
2163702 | 2163702 | 2022-01-29 | Spink | South Dakota | 46115 | 1332 | 32 |
2163703 | 2163703 | 2022-01-29 | Stanley | South Dakota | 46117 | 611 | 6 |
2163704 | 2163704 | 2022-01-29 | Sully | South Dakota | 46119 | 236 | 3 |
2163705 | 2163705 | 2022-01-29 | Todd | South Dakota | 46121 | 2674 | 43 |
2163706 | 2163706 | 2022-01-29 | Tripp | South Dakota | 46123 | 1299 | 21 |
2163707 | 2163707 | 2022-01-29 | Turner | South Dakota | 46125 | 1901 | 62 |
2163708 | 2163708 | 2022-01-29 | Union | South Dakota | 46127 | 3848 | 47 |
2163709 | 2163709 | 2022-01-29 | Walworth | South Dakota | 46129 | 1229 | 20 |
2163710 | 2163710 | 2022-01-29 | Yankton | South Dakota | 46135 | 5587 | 50 |
2163711 | 2163711 | 2022-01-29 | Ziebach | South Dakota | 46137 | 516 | 11 |
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);