ny_times_us_counties

⚠️ 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

4,814 rows where state = "South Dakota" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • South Dakota · 4,814 ✖
Link rowid date ▲ county state fips cases deaths
294078 294078 2020-07-03 Aurora South Dakota 46003 34 0
294079 294079 2020-07-03 Beadle South Dakota 46005 539 7
294080 294080 2020-07-03 Bennett South Dakota 46007 4 0
294081 294081 2020-07-03 Bon Homme South Dakota 46009 11 0
294082 294082 2020-07-03 Brookings South Dakota 46011 70 0
294083 294083 2020-07-03 Brown South Dakota 46013 344 2
294084 294084 2020-07-03 Brule South Dakota 46015 29 0
294085 294085 2020-07-03 Buffalo South Dakota 46017 76 3
294086 294086 2020-07-03 Campbell South Dakota 46021 1 0
294087 294087 2020-07-03 Charles Mix South Dakota 46023 90 0
294088 294088 2020-07-03 Clark South Dakota 46025 15 0
294089 294089 2020-07-03 Clay South Dakota 46027 87 0
294090 294090 2020-07-03 Codington South Dakota 46029 75 0
294091 294091 2020-07-03 Corson South Dakota 46031 18 0
294092 294092 2020-07-03 Custer South Dakota 46033 10 0
294093 294093 2020-07-03 Davison South Dakota 46035 44 1
294094 294094 2020-07-03 Day South Dakota 46037 17 0
294095 294095 2020-07-03 Deuel South Dakota 46039 3 0
294096 294096 2020-07-03 Dewey South Dakota 46041 8 0
294097 294097 2020-07-03 Douglas South Dakota 46043 7 0
294098 294098 2020-07-03 Edmunds South Dakota 46045 7 0
294099 294099 2020-07-03 Fall River South Dakota 46047 12 0
294100 294100 2020-07-03 Faulk South Dakota 46049 23 1
294101 294101 2020-07-03 Grant South Dakota 46051 13 0
294102 294102 2020-07-03 Gregory South Dakota 46053 4 0
294103 294103 2020-07-03 Hamlin South Dakota 46057 13 0
294104 294104 2020-07-03 Hand South Dakota 46059 7 0
294105 294105 2020-07-03 Hanson South Dakota 46061 8 0
294106 294106 2020-07-03 Hughes South Dakota 46065 64 0
294107 294107 2020-07-03 Hutchinson South Dakota 46067 13 0
294108 294108 2020-07-03 Hyde South Dakota 46069 3 0
294109 294109 2020-07-03 Jackson South Dakota 46071 6 1
294110 294110 2020-07-03 Jerauld South Dakota 46073 39 1
294111 294111 2020-07-03 Kingsbury South Dakota 46077 6 0
294112 294112 2020-07-03 Lake South Dakota 46079 22 1
294113 294113 2020-07-03 Lawrence South Dakota 46081 19 0
294114 294114 2020-07-03 Lincoln South Dakota 46083 357 1
294115 294115 2020-07-03 Lyman South Dakota 46085 69 1
294116 294116 2020-07-03 Marshall South Dakota 46091 5 0
294117 294117 2020-07-03 McCook South Dakota 46087 12 1
294118 294118 2020-07-03 McPherson South Dakota 46089 4 0
294119 294119 2020-07-03 Meade South Dakota 46093 50 1
294120 294120 2020-07-03 Mellette South Dakota 46095 5 0
294121 294121 2020-07-03 Miner South Dakota 46097 9 0
294122 294122 2020-07-03 Minnehaha South Dakota 46099 3655 58
294123 294123 2020-07-03 Moody South Dakota 46101 23 0
294124 294124 2020-07-03 Oglala Lakota South Dakota 46102 89 0
294125 294125 2020-07-03 Pennington South Dakota 46103 546 16
294126 294126 2020-07-03 Roberts South Dakota 46109 49 0
294127 294127 2020-07-03 Sanborn South Dakota 46111 12 0
294128 294128 2020-07-03 Spink South Dakota 46115 12 0
294129 294129 2020-07-03 Stanley South Dakota 46117 13 0
294130 294130 2020-07-03 Sully South Dakota 46119 1 0
294131 294131 2020-07-03 Todd South Dakota 46121 57 1
294132 294132 2020-07-03 Tripp South Dakota 46123 18 0
294133 294133 2020-07-03 Turner South Dakota 46125 25 0
294134 294134 2020-07-03 Union South Dakota 46127 132 1
294135 294135 2020-07-03 Walworth South Dakota 46129 14 0
294136 294136 2020-07-03 Yankton South Dakota 46135 79 0
294137 294137 2020-07-03 Ziebach South Dakota 46137 1 0
290998 290998 2020-07-02 Aurora South Dakota 46003 34 0
290999 290999 2020-07-02 Beadle South Dakota 46005 532 7
291000 291000 2020-07-02 Bennett South Dakota 46007 4 0
291001 291001 2020-07-02 Bon Homme South Dakota 46009 11 0
291002 291002 2020-07-02 Brookings South Dakota 46011 68 0
291003 291003 2020-07-02 Brown South Dakota 46013 344 2
291004 291004 2020-07-02 Brule South Dakota 46015 26 0
291005 291005 2020-07-02 Buffalo South Dakota 46017 72 3
291006 291006 2020-07-02 Charles Mix South Dakota 46023 86 0
291007 291007 2020-07-02 Clark South Dakota 46025 15 0
291008 291008 2020-07-02 Clay South Dakota 46027 85 0
291009 291009 2020-07-02 Codington South Dakota 46029 72 0
291010 291010 2020-07-02 Corson South Dakota 46031 18 0
291011 291011 2020-07-02 Custer South Dakota 46033 10 0
291012 291012 2020-07-02 Davison South Dakota 46035 43 1
291013 291013 2020-07-02 Day South Dakota 46037 17 0
291014 291014 2020-07-02 Deuel South Dakota 46039 3 0
291015 291015 2020-07-02 Dewey South Dakota 46041 6 0
291016 291016 2020-07-02 Douglas South Dakota 46043 5 0
291017 291017 2020-07-02 Edmunds South Dakota 46045 7 0
291018 291018 2020-07-02 Fall River South Dakota 46047 12 0
291019 291019 2020-07-02 Faulk South Dakota 46049 23 1
291020 291020 2020-07-02 Grant South Dakota 46051 13 0
291021 291021 2020-07-02 Gregory South Dakota 46053 4 0
291022 291022 2020-07-02 Hamlin South Dakota 46057 12 0
291023 291023 2020-07-02 Hand South Dakota 46059 7 0
291024 291024 2020-07-02 Hanson South Dakota 46061 8 0
291025 291025 2020-07-02 Hughes South Dakota 46065 60 0
291026 291026 2020-07-02 Hutchinson South Dakota 46067 13 0
291027 291027 2020-07-02 Hyde South Dakota 46069 3 0
291028 291028 2020-07-02 Jackson South Dakota 46071 6 1
291029 291029 2020-07-02 Jerauld South Dakota 46073 39 1
291030 291030 2020-07-02 Kingsbury South Dakota 46077 6 0
291031 291031 2020-07-02 Lake South Dakota 46079 22 1
291032 291032 2020-07-02 Lawrence South Dakota 46081 19 0
291033 291033 2020-07-02 Lincoln South Dakota 46083 352 1
291034 291034 2020-07-02 Lyman South Dakota 46085 68 1
291035 291035 2020-07-02 Marshall South Dakota 46091 5 0
291036 291036 2020-07-02 McCook South Dakota 46087 10 1
291037 291037 2020-07-02 McPherson South Dakota 46089 4 0

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
);
Powered by Datasette · Query took 936.381ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette