johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

21,606 rows where province_or_state = "South Dakota" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • South Dakota · 21,606 ✖

country_or_region

  • US 21,606
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
804124 804124 2021-03-01 US South Dakota Aurora 46003 453 15 0 438 43.71757685 -98.56050467 2021-03-02 05:23:30 Aurora, South Dakota, US
804125 804125 2021-03-01 US South Dakota Beadle 46005 2733 39 0 2694 44.41464384 -98.27858469 2021-03-02 05:23:30 Beadle, South Dakota, US
804126 804126 2021-03-01 US South Dakota Bennett 46007 382 9 0 373 43.19486375 -101.6665572 2021-03-02 05:23:30 Bennett, South Dakota, US
804127 804127 2021-03-01 US South Dakota Bon Homme 46009 1504 25 0 1479 42.98914167 -97.88592746 2021-03-02 05:23:30 Bon Homme, South Dakota, US
804128 804128 2021-03-01 US South Dakota Brookings 46011 3588 37 0 3551 44.36974375 -96.79079945 2021-03-02 05:23:30 Brookings, South Dakota, US
804129 804129 2021-03-01 US South Dakota Brown 46013 5132 88 0 5044 45.58994323 -98.35165355 2021-03-02 05:23:30 Brown, South Dakota, US
804130 804130 2021-03-01 US South Dakota Brule 46015 691 9 0 682 43.71756379 -99.08118954 2021-03-02 05:23:30 Brule, South Dakota, US
804131 804131 2021-03-01 US South Dakota Buffalo 46017 420 13 0 407 44.07657829 -99.20814467 2021-03-02 05:23:30 Buffalo, South Dakota, US
804132 804132 2021-03-01 US South Dakota Butte 46019 978 20 0 958 44.90608745 -103.5079318 2021-03-02 05:23:30 Butte, South Dakota, US
804133 804133 2021-03-01 US South Dakota Campbell 46021 129 4 0 125 45.77074915 -100.0510181 2021-03-02 05:23:30 Campbell, South Dakota, US
804134 804134 2021-03-01 US South Dakota Charles Mix 46023 1294 21 0 1273 43.20660134 -98.58856175 2021-03-02 05:23:30 Charles Mix, South Dakota, US
804135 804135 2021-03-01 US South Dakota Clark 46025 371 5 0 366 44.85834507 -97.72925109 2021-03-02 05:23:30 Clark, South Dakota, US
804136 804136 2021-03-01 US South Dakota Clay 46027 1793 15 0 1778 42.91296147 -96.97656917 2021-03-02 05:23:30 Clay, South Dakota, US
804137 804137 2021-03-01 US South Dakota Codington 46029 3989 77 0 3912 44.97788119 -97.18827677 2021-03-02 05:23:30 Codington, South Dakota, US
804138 804138 2021-03-01 US South Dakota Corson 46031 468 12 0 456 45.70889983 -101.1970473 2021-03-02 05:23:30 Corson, South Dakota, US
804139 804139 2021-03-01 US South Dakota Custer 46033 751 12 0 739 43.67741105 -103.4534521 2021-03-02 05:23:30 Custer, South Dakota, US
804140 804140 2021-03-01 US South Dakota Davison 46035 2955 61 0 2894 43.67490933 -98.14458906 2021-03-02 05:23:30 Davison, South Dakota, US
804141 804141 2021-03-01 US South Dakota Day 46037 663 28 0 635 45.367281 -97.60737498 2021-03-02 05:23:30 Day, South Dakota, US
804142 804142 2021-03-01 US South Dakota Deuel 46039 473 8 0 465 44.75994309 -96.66943645 2021-03-02 05:23:30 Deuel, South Dakota, US
804143 804143 2021-03-01 US South Dakota Dewey 46041 1412 26 0 1386 45.15639647 -100.8709139 2021-03-02 05:23:30 Dewey, South Dakota, US
804144 804144 2021-03-01 US South Dakota Douglas 46043 434 9 0 425 43.38520741 -98.36978007 2021-03-02 05:23:30 Douglas, South Dakota, US
804145 804145 2021-03-01 US South Dakota Edmunds 46045 482 12 0 470 45.41846445 -99.21545423 2021-03-02 05:23:30 Edmunds, South Dakota, US
804146 804146 2021-03-01 US South Dakota Fall River 46047 527 15 0 512 43.23929297 -103.5275691 2021-03-02 05:23:30 Fall River, South Dakota, US
804147 804147 2021-03-01 US South Dakota Faulk 46049 360 13 0 347 45.07082625 -99.14535601 2021-03-02 05:23:30 Faulk, South Dakota, US
804148 804148 2021-03-01 US South Dakota Grant 46051 974 38 0 936 45.1723937 -96.77002276 2021-03-02 05:23:30 Grant, South Dakota, US
804149 804149 2021-03-01 US South Dakota Gregory 46053 540 29 0 511 43.19419064 -99.18883902 2021-03-02 05:23:30 Gregory, South Dakota, US
804150 804150 2021-03-01 US South Dakota Haakon 46055 251 10 0 241 44.29299053 -101.539099 2021-03-02 05:23:30 Haakon, South Dakota, US
804151 804151 2021-03-01 US South Dakota Hamlin 46057 713 37 0 676 44.67385954 -97.18829593 2021-03-02 05:23:30 Hamlin, South Dakota, US
804152 804152 2021-03-01 US South Dakota Hand 46059 338 6 0 332 44.54708407 -99.00386459 2021-03-02 05:23:30 Hand, South Dakota, US
804153 804153 2021-03-01 US South Dakota Hanson 46061 363 4 0 359 43.6746384 -97.78715148 2021-03-02 05:23:30 Hanson, South Dakota, US
804154 804154 2021-03-01 US South Dakota Harding 46063 91 1 0 90 45.58015551 -103.4958629 2021-03-02 05:23:30 Harding, South Dakota, US
804155 804155 2021-03-01 US South Dakota Hughes 46065 2302 36 0 2266 44.39091534 -99.99661148 2021-03-02 05:23:30 Hughes, South Dakota, US
804156 804156 2021-03-01 US South Dakota Hutchinson 46067 788 24 0 764 43.33449012 -97.75536441 2021-03-02 05:23:30 Hutchinson, South Dakota, US
804157 804157 2021-03-01 US South Dakota Hyde 46069 138 1 0 137 44.54747703 -99.48572582 2021-03-02 05:23:30 Hyde, South Dakota, US
804158 804158 2021-03-01 US South Dakota Jackson 46071 279 14 0 265 43.69318385 -101.6255063 2021-03-02 05:23:30 Jackson, South Dakota, US
804159 804159 2021-03-01 US South Dakota Jerauld 46073 272 16 0 256 44.06637798 -98.62965972 2021-03-02 05:23:30 Jerauld, South Dakota, US
804160 804160 2021-03-01 US South Dakota Jones 46075 85 0 0 85 43.96278565 -100.6940008 2021-03-02 05:23:30 Jones, South Dakota, US
804161 804161 2021-03-01 US South Dakota Kingsbury 46077 639 14 0 625 44.36956169 -97.4913945 2021-03-02 05:23:30 Kingsbury, South Dakota, US
804162 804162 2021-03-01 US South Dakota Lake 46079 1192 17 0 1175 44.02193107 -97.12926365 2021-03-02 05:23:30 Lake, South Dakota, US
804163 804163 2021-03-01 US South Dakota Lawrence 46081 2825 45 0 2780 44.35919441 -103.7929428 2021-03-02 05:23:30 Lawrence, South Dakota, US
804164 804164 2021-03-01 US South Dakota Lincoln 46083 7754 77 0 7677 43.27841182 -96.7203905 2021-03-02 05:23:30 Lincoln, South Dakota, US
804165 804165 2021-03-01 US South Dakota Lyman 46085 598 10 0 588 43.89522709 -99.85201878 2021-03-02 05:23:30 Lyman, South Dakota, US
804166 804166 2021-03-01 US South Dakota Marshall 46091 319 5 0 314 45.75870838 -97.59855639 2021-03-02 05:23:30 Marshall, South Dakota, US
804167 804167 2021-03-01 US South Dakota McCook 46087 741 24 0 717 43.6742571 -97.36863144 2021-03-02 05:23:30 McCook, South Dakota, US
804168 804168 2021-03-01 US South Dakota McPherson 46089 239 4 0 235 45.76626028 -99.22118798 2021-03-02 05:23:30 McPherson, South Dakota, US
804169 804169 2021-03-01 US South Dakota Meade 46093 2592 31 0 2561 44.56676791 -102.7162741 2021-03-02 05:23:30 Meade, South Dakota, US
804170 804170 2021-03-01 US South Dakota Mellette 46095 248 2 0 246 43.58078848 -100.7563186 2021-03-02 05:23:30 Mellette, South Dakota, US
804171 804171 2021-03-01 US South Dakota Miner 46097 271 9 0 262 44.02197882 -97.60992207 2021-03-02 05:23:30 Miner, South Dakota, US
804172 804172 2021-03-01 US South Dakota Minnehaha 46099 28018 332 0 27686 43.67441641 -96.7910885 2021-03-02 05:23:30 Minnehaha, South Dakota, US
804173 804173 2021-03-01 US South Dakota Moody 46101 618 16 0 602 44.02266214 -96.67081159 2021-03-02 05:23:30 Moody, South Dakota, US
804174 804174 2021-03-01 US South Dakota Oglala Lakota 46102 2060 49 0 2011 43.33749164 -102.5555498 2021-03-02 05:23:30 Oglala Lakota, South Dakota, US
804175 804175 2021-03-01 US South Dakota Pennington 46103 12908 189 0 12719 44.0025835 -102.8240777 2021-03-02 05:23:30 Pennington, South Dakota, US
804176 804176 2021-03-01 US South Dakota Perkins 46105 347 14 0 333 45.49049506 -102.4755586 2021-03-02 05:23:30 Perkins, South Dakota, US
804177 804177 2021-03-01 US South Dakota Potter 46107 371 4 0 367 45.06583079 -99.95498503 2021-03-02 05:23:30 Potter, South Dakota, US
804178 804178 2021-03-01 US South Dakota Roberts 46109 1189 36 0 1153 45.62975048 -96.94672673 2021-03-02 05:23:30 Roberts, South Dakota, US
804179 804179 2021-03-01 US South Dakota Sanborn 46111 330 3 0 327 44.02351092 -98.0909816 2021-03-02 05:23:30 Sanborn, South Dakota, US
804180 804180 2021-03-01 US South Dakota Spink 46115 798 25 0 773 44.93837606 -98.34626602 2021-03-02 05:23:30 Spink, South Dakota, US
804181 804181 2021-03-01 US South Dakota Stanley 46117 331 2 0 329 44.41381872 -100.7349153 2021-03-02 05:23:30 Stanley, South Dakota, US
804182 804182 2021-03-01 US South Dakota Sully 46119 137 3 0 134 44.71571812 -100.1278092 2021-03-02 05:23:30 Sully, South Dakota, US
804183 804183 2021-03-01 US South Dakota Todd 46121 1219 28 0 1191 43.19338568 -100.7195503 2021-03-02 05:23:30 Todd, South Dakota, US
804184 804184 2021-03-01 US South Dakota Tripp 46123 699 16 0 683 43.34459388 -99.8854891 2021-03-02 05:23:30 Tripp, South Dakota, US
804185 804185 2021-03-01 US South Dakota Turner 46125 1067 53 0 1014 43.3109081 -97.14865776 2021-03-02 05:23:30 Turner, South Dakota, US
804186 804186 2021-03-01 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2021-03-02 05:23:30 Unassigned, South Dakota, US
804187 804187 2021-03-01 US South Dakota Union 46127 1981 39 0 1942 42.83112163 -96.6557828 2021-03-02 05:23:30 Union, South Dakota, US
804188 804188 2021-03-01 US South Dakota Walworth 46129 725 15 0 710 45.43019636 -100.0307514 2021-03-02 05:23:30 Walworth, South Dakota, US
804189 804189 2021-03-01 US South Dakota Yankton 46135 2802 28 0 2774 43.00924485 -97.39467635 2021-03-02 05:23:30 Yankton, South Dakota, US
804190 804190 2021-03-01 US South Dakota Ziebach 46137 336 9 0 327 44.97881876 -101.6654622 2021-03-02 05:23:30 Ziebach, South Dakota, US
1069266 1069266 2021-02-28 US South Dakota Aurora 46003 453 15 0 438 43.71757685 -98.56050467 2021-03-01 05:23:01 Aurora, South Dakota, US
1069267 1069267 2021-02-28 US South Dakota Beadle 46005 2730 39 0 2691 44.41464384 -98.27858469 2021-03-01 05:23:01 Beadle, South Dakota, US
1069268 1069268 2021-02-28 US South Dakota Bennett 46007 382 9 0 373 43.19486375 -101.6665572 2021-03-01 05:23:01 Bennett, South Dakota, US
1069269 1069269 2021-02-28 US South Dakota Bon Homme 46009 1504 25 0 1479 42.98914167 -97.88592746 2021-03-01 05:23:01 Bon Homme, South Dakota, US
1069270 1069270 2021-02-28 US South Dakota Brookings 46011 3588 37 0 3551 44.36974375 -96.79079945 2021-03-01 05:23:01 Brookings, South Dakota, US
1069271 1069271 2021-02-28 US South Dakota Brown 46013 5129 88 0 5041 45.58994323 -98.35165355 2021-03-01 05:23:01 Brown, South Dakota, US
1069272 1069272 2021-02-28 US South Dakota Brule 46015 691 9 0 682 43.71756379 -99.08118954 2021-03-01 05:23:01 Brule, South Dakota, US
1069273 1069273 2021-02-28 US South Dakota Buffalo 46017 420 13 0 407 44.07657829 -99.20814467 2021-03-01 05:23:01 Buffalo, South Dakota, US
1069274 1069274 2021-02-28 US South Dakota Butte 46019 978 20 0 958 44.90608745 -103.5079318 2021-03-01 05:23:01 Butte, South Dakota, US
1069275 1069275 2021-02-28 US South Dakota Campbell 46021 129 4 0 125 45.77074915 -100.0510181 2021-03-01 05:23:01 Campbell, South Dakota, US
1069276 1069276 2021-02-28 US South Dakota Charles Mix 46023 1294 21 0 1273 43.20660134 -98.58856175 2021-03-01 05:23:01 Charles Mix, South Dakota, US
1069277 1069277 2021-02-28 US South Dakota Clark 46025 371 5 0 366 44.85834507 -97.72925109 2021-03-01 05:23:01 Clark, South Dakota, US
1069278 1069278 2021-02-28 US South Dakota Clay 46027 1793 15 0 1778 42.91296147 -96.97656917 2021-03-01 05:23:01 Clay, South Dakota, US
1069279 1069279 2021-02-28 US South Dakota Codington 46029 3986 77 0 3909 44.97788119 -97.18827677 2021-03-01 05:23:01 Codington, South Dakota, US
1069280 1069280 2021-02-28 US South Dakota Corson 46031 468 12 0 456 45.70889983 -101.1970473 2021-03-01 05:23:01 Corson, South Dakota, US
1069281 1069281 2021-02-28 US South Dakota Custer 46033 749 12 0 737 43.67741105 -103.4534521 2021-03-01 05:23:01 Custer, South Dakota, US
1069282 1069282 2021-02-28 US South Dakota Davison 46035 2952 61 0 2891 43.67490933 -98.14458906 2021-03-01 05:23:01 Davison, South Dakota, US
1069283 1069283 2021-02-28 US South Dakota Day 46037 663 28 0 635 45.367281 -97.60737498 2021-03-01 05:23:01 Day, South Dakota, US
1069284 1069284 2021-02-28 US South Dakota Deuel 46039 473 8 0 465 44.75994309 -96.66943645 2021-03-01 05:23:01 Deuel, South Dakota, US
1069285 1069285 2021-02-28 US South Dakota Dewey 46041 1412 26 0 1386 45.15639647 -100.8709139 2021-03-01 05:23:01 Dewey, South Dakota, US
1069286 1069286 2021-02-28 US South Dakota Douglas 46043 434 9 0 425 43.38520741 -98.36978007 2021-03-01 05:23:01 Douglas, South Dakota, US
1069287 1069287 2021-02-28 US South Dakota Edmunds 46045 482 12 0 470 45.41846445 -99.21545423 2021-03-01 05:23:01 Edmunds, South Dakota, US
1069288 1069288 2021-02-28 US South Dakota Fall River 46047 527 15 0 512 43.23929297 -103.5275691 2021-03-01 05:23:01 Fall River, South Dakota, US
1069289 1069289 2021-02-28 US South Dakota Faulk 46049 360 13 0 347 45.07082625 -99.14535601 2021-03-01 05:23:01 Faulk, South Dakota, US
1069290 1069290 2021-02-28 US South Dakota Grant 46051 974 38 0 936 45.1723937 -96.77002276 2021-03-01 05:23:01 Grant, South Dakota, US
1069291 1069291 2021-02-28 US South Dakota Gregory 46053 539 29 0 510 43.19419064 -99.18883902 2021-03-01 05:23:01 Gregory, South Dakota, US
1069292 1069292 2021-02-28 US South Dakota Haakon 46055 251 10 0 241 44.29299053 -101.539099 2021-03-01 05:23:01 Haakon, South Dakota, US
1069293 1069293 2021-02-28 US South Dakota Hamlin 46057 712 37 0 675 44.67385954 -97.18829593 2021-03-01 05:23:01 Hamlin, South Dakota, US
1069294 1069294 2021-02-28 US South Dakota Hand 46059 338 6 0 332 44.54708407 -99.00386459 2021-03-01 05:23:01 Hand, South Dakota, US
1069295 1069295 2021-02-28 US South Dakota Hanson 46061 363 4 0 359 43.6746384 -97.78715148 2021-03-01 05:23:01 Hanson, South Dakota, US
1069296 1069296 2021-02-28 US South Dakota Harding 46063 91 1 0 90 45.58015551 -103.4958629 2021-03-01 05:23:01 Harding, South Dakota, US
1069297 1069297 2021-02-28 US South Dakota Hughes 46065 2299 36 0 2263 44.39091534 -99.99661148 2021-03-01 05:23:01 Hughes, South Dakota, US
1069298 1069298 2021-02-28 US South Dakota Hutchinson 46067 788 24 0 764 43.33449012 -97.75536441 2021-03-01 05:23:01 Hutchinson, South Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);