ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

35,692 rows where state = "South Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • South Dakota · 35,692 ✖
Link rowid date ▲ county state fips cases deaths
1819077 1819077 2021-10-15 Aurora South Dakota 46003 537 16
1819078 1819078 2021-10-15 Beadle South Dakota 46005 3216 43
1819079 1819079 2021-10-15 Bennett South Dakota 46007 455 9
1819080 1819080 2021-10-15 Bon Homme South Dakota 46009 1616 29
1819081 1819081 2021-10-15 Brookings South Dakota 46011 5045 38
1819082 1819082 2021-10-15 Brown South Dakota 46013 6483 99
1819083 1819083 2021-10-15 Brule South Dakota 46015 798 11
1819084 1819084 2021-10-15 Buffalo South Dakota 46017 448 14
1819085 1819085 2021-10-15 Butte South Dakota 46019 1773 27
1819086 1819086 2021-10-15 Campbell South Dakota 46021 159 4
1819087 1819087 2021-10-15 Charles Mix South Dakota 46023 1706 26
1819088 1819088 2021-10-15 Clark South Dakota 46025 502 5
1819089 1819089 2021-10-15 Clay South Dakota 46027 2150 18
1819090 1819090 2021-10-15 Codington South Dakota 46029 5386 83
1819091 1819091 2021-10-15 Corson South Dakota 46031 659 13
1819092 1819092 2021-10-15 Custer South Dakota 46033 1298 15
1819093 1819093 2021-10-15 Davison South Dakota 46035 3673 70
1819094 1819094 2021-10-15 Day South Dakota 46037 800 30
1819095 1819095 2021-10-15 Deuel South Dakota 46039 642 11
1819096 1819096 2021-10-15 Dewey South Dakota 46041 1744 31
1819097 1819097 2021-10-15 Douglas South Dakota 46043 508 9
1819098 1819098 2021-10-15 Edmunds South Dakota 46045 582 14
1819099 1819099 2021-10-15 Fall River South Dakota 46047 940 22
1819100 1819100 2021-10-15 Faulk South Dakota 46049 395 14
1819101 1819101 2021-10-15 Grant South Dakota 46051 1310 43
1819102 1819102 2021-10-15 Gregory South Dakota 46053 691 30
1819103 1819103 2021-10-15 Haakon South Dakota 46055 318 11
1819104 1819104 2021-10-15 Hamlin South Dakota 46057 1004 40
1819105 1819105 2021-10-15 Hand South Dakota 46059 391 6
1819106 1819106 2021-10-15 Hanson South Dakota 46061 433 4
1819107 1819107 2021-10-15 Harding South Dakota 46063 157 1
1819108 1819108 2021-10-15 Hughes South Dakota 46065 2843 44
1819109 1819109 2021-10-15 Hutchinson South Dakota 46067 1031 28
1819110 1819110 2021-10-15 Hyde South Dakota 46069 157 1
1819111 1819111 2021-10-15 Jackson South Dakota 46071 377 16
1819112 1819112 2021-10-15 Jerauld South Dakota 46073 299 17
1819113 1819113 2021-10-15 Jones South Dakota 46075 137 1
1819114 1819114 2021-10-15 Kingsbury South Dakota 46077 907 18
1819115 1819115 2021-10-15 Lake South Dakota 46079 1545 20
1819116 1819116 2021-10-15 Lawrence South Dakota 46081 4223 56
1819117 1819117 2021-10-15 Lincoln South Dakota 46083 10091 78
1819118 1819118 2021-10-15 Lyman South Dakota 46085 716 11
1819119 1819119 2021-10-15 Marshall South Dakota 46091 427 6
1819120 1819120 2021-10-15 McCook South Dakota 46087 895 25
1819121 1819121 2021-10-15 McPherson South Dakota 46089 312 7
1819122 1819122 2021-10-15 Meade South Dakota 46093 4374 44
1819123 1819123 2021-10-15 Mellette South Dakota 46095 317 2
1819124 1819124 2021-10-15 Miner South Dakota 46097 349 11
1819125 1819125 2021-10-15 Minnehaha South Dakota 46099 36752 385
1819126 1819126 2021-10-15 Moody South Dakota 46101 763 20
1819127 1819127 2021-10-15 Oglala Lakota South Dakota 46102 2368 52
1819128 1819128 2021-10-15 Pennington South Dakota 46103 19958 242
1819129 1819129 2021-10-15 Perkins South Dakota 46105 408 14
1819130 1819130 2021-10-15 Potter South Dakota 46107 408 4
1819131 1819131 2021-10-15 Roberts South Dakota 46109 1509 43
1819132 1819132 2021-10-15 Sanborn South Dakota 46111 376 3
1819133 1819133 2021-10-15 Spink South Dakota 46115 1010 27
1819134 1819134 2021-10-15 Stanley South Dakota 46117 413 3
1819135 1819135 2021-10-15 Sully South Dakota 46119 153 3
1819136 1819136 2021-10-15 Todd South Dakota 46121 1525 36
1819137 1819137 2021-10-15 Tripp South Dakota 46123 836 18
1819138 1819138 2021-10-15 Turner South Dakota 46125 1308 60
1819139 1819139 2021-10-15 Union South Dakota 46127 2578 44
1819140 1819140 2021-10-15 Walworth South Dakota 46129 885 18
1819141 1819141 2021-10-15 Yankton South Dakota 46135 3545 37
1819142 1819142 2021-10-15 Ziebach South Dakota 46137 382 9
1815828 1815828 2021-10-14 Aurora South Dakota 46003 537 16
1815829 1815829 2021-10-14 Beadle South Dakota 46005 3210 43
1815830 1815830 2021-10-14 Bennett South Dakota 46007 454 9
1815831 1815831 2021-10-14 Bon Homme South Dakota 46009 1614 29
1815832 1815832 2021-10-14 Brookings South Dakota 46011 5036 38
1815833 1815833 2021-10-14 Brown South Dakota 46013 6463 99
1815834 1815834 2021-10-14 Brule South Dakota 46015 798 11
1815835 1815835 2021-10-14 Buffalo South Dakota 46017 447 14
1815836 1815836 2021-10-14 Butte South Dakota 46019 1770 27
1815837 1815837 2021-10-14 Campbell South Dakota 46021 159 4
1815838 1815838 2021-10-14 Charles Mix South Dakota 46023 1702 26
1815839 1815839 2021-10-14 Clark South Dakota 46025 501 5
1815840 1815840 2021-10-14 Clay South Dakota 46027 2147 18
1815841 1815841 2021-10-14 Codington South Dakota 46029 5374 83
1815842 1815842 2021-10-14 Corson South Dakota 46031 656 13
1815843 1815843 2021-10-14 Custer South Dakota 46033 1291 15
1815844 1815844 2021-10-14 Davison South Dakota 46035 3667 70
1815845 1815845 2021-10-14 Day South Dakota 46037 799 30
1815846 1815846 2021-10-14 Deuel South Dakota 46039 639 11
1815847 1815847 2021-10-14 Dewey South Dakota 46041 1740 31
1815848 1815848 2021-10-14 Douglas South Dakota 46043 508 9
1815849 1815849 2021-10-14 Edmunds South Dakota 46045 578 14
1815850 1815850 2021-10-14 Fall River South Dakota 46047 937 22
1815851 1815851 2021-10-14 Faulk South Dakota 46049 397 14
1815852 1815852 2021-10-14 Grant South Dakota 46051 1304 43
1815853 1815853 2021-10-14 Gregory South Dakota 46053 691 30
1815854 1815854 2021-10-14 Haakon South Dakota 46055 317 11
1815855 1815855 2021-10-14 Hamlin South Dakota 46057 1003 40
1815856 1815856 2021-10-14 Hand South Dakota 46059 391 6
1815857 1815857 2021-10-14 Hanson South Dakota 46061 432 4
1815858 1815858 2021-10-14 Harding South Dakota 46063 157 1
1815859 1815859 2021-10-14 Hughes South Dakota 46065 2834 44
1815860 1815860 2021-10-14 Hutchinson South Dakota 46067 1030 28
1815861 1815861 2021-10-14 Hyde South Dakota 46069 157 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);