johns_hopkins_csse_daily_reports

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

7,875 rows where province_or_state = "South Dakota" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • South Dakota · 7,875

country_or_region

  • US 7,875
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391198 2020-08-08 US South Dakota Aurora 46003 38 0 0 38 43.71757685 -98.56050467 2020-08-09 04:34:54 Aurora, South Dakota, US
391247 2020-08-08 US South Dakota Beadle 46005 591 9 0 582 44.41464384 -98.27858469 2020-08-09 04:34:54 Beadle, South Dakota, US
391269 2020-08-08 US South Dakota Bennett 46007 6 0 0 6 43.19486375 -101.6665572 2020-08-09 04:34:54 Bennett, South Dakota, US
391320 2020-08-08 US South Dakota Bon Homme 46009 13 0 0 13 42.98914167 -97.88592746 2020-08-09 04:34:54 Bon Homme, South Dakota, US
391369 2020-08-08 US South Dakota Brookings 46011 133 1 0 132 44.36974375 -96.79079945 2020-08-09 04:34:54 Brookings, South Dakota, US
391381 2020-08-08 US South Dakota Brown 46013 436 3 0 433 45.58994323 -98.35165355 2020-08-09 04:34:54 Brown, South Dakota, US
391384 2020-08-08 US South Dakota Brule 46015 45 0 0 45 43.71756379 -99.08118954 2020-08-09 04:34:54 Brule, South Dakota, US
391397 2020-08-08 US South Dakota Buffalo 46017 109 3 0 106 44.07657829 -99.20814467 2020-08-09 04:34:54 Buffalo, South Dakota, US
391422 2020-08-08 US South Dakota Butte 46019 14 1 0 13 44.90608745 -103.5079318 2020-08-09 04:34:54 Butte, South Dakota, US
391465 2020-08-08 US South Dakota Campbell 46021 3 0 0 3 45.77074915 -100.0510181 2020-08-09 04:34:54 Campbell, South Dakota, US
391546 2020-08-08 US South Dakota Charles Mix 46023 101 0 0 101 43.20660134 -98.58856175 2020-08-09 04:34:54 Charles Mix, South Dakota, US
391627 2020-08-08 US South Dakota Clark 46025 16 0 0 16 44.85834507 -97.72925109 2020-08-09 04:34:54 Clark, South Dakota, US
391650 2020-08-08 US South Dakota Clay 46027 124 0 0 124 42.91296147 -96.97656917 2020-08-09 04:34:54 Clay, South Dakota, US
391685 2020-08-08 US South Dakota Codington 46029 129 1 0 128 44.97788119 -97.18827677 2020-08-09 04:34:54 Codington, South Dakota, US
391737 2020-08-08 US South Dakota Corson 46031 32 0 0 32 45.70889983 -101.1970473 2020-08-09 04:34:54 Corson, South Dakota, US
391801 2020-08-08 US South Dakota Custer 46033 32 0 0 32 43.67741105 -103.4534521 2020-08-09 04:34:54 Custer, South Dakota, US
391829 2020-08-08 US South Dakota Davison 46035 94 1 0 93 43.67490933 -98.14458906 2020-08-09 04:34:54 Davison, South Dakota, US
391835 2020-08-08 US South Dakota Day 46037 23 0 0 23 45.367281 -97.60737498 2020-08-09 04:34:54 Day, South Dakota, US
391875 2020-08-08 US South Dakota Deuel 46039 10 0 0 10 44.75994309 -96.66943645 2020-08-09 04:34:54 Deuel, South Dakota, US
391877 2020-08-08 US South Dakota Dewey 46041 49 0 0 49 45.15639647 -100.8709139 2020-08-09 04:34:54 Dewey, South Dakota, US
391917 2020-08-08 US South Dakota Douglas 46043 17 0 0 17 43.38520741 -98.36978007 2020-08-09 04:34:54 Douglas, South Dakota, US
391951 2020-08-08 US South Dakota Edmunds 46045 14 0 0 14 45.41846445 -99.21545423 2020-08-09 04:34:54 Edmunds, South Dakota, US
392002 2020-08-08 US South Dakota Fall River 46047 22 0 0 22 43.23929297 -103.5275691 2020-08-09 04:34:54 Fall River, South Dakota, US
392009 2020-08-08 US South Dakota Faulk 46049 26 1 0 25 45.07082625 -99.14535601 2020-08-09 04:34:54 Faulk, South Dakota, US
392190 2020-08-08 US South Dakota Grant 46051 26 0 0 26 45.1723937 -96.77002276 2020-08-09 04:34:54 Grant, South Dakota, US
392231 2020-08-08 US South Dakota Gregory 46053 7 0 0 7 43.19419064 -99.18883902 2020-08-09 04:34:54 Gregory, South Dakota, US
392252 2020-08-08 US South Dakota Haakon 46055 2 0 0 2 44.29299053 -101.539099 2020-08-09 04:34:54 Haakon, South Dakota, US
392273 2020-08-08 US South Dakota Hamlin 46057 18 0 0 18 44.67385954 -97.18829593 2020-08-09 04:34:54 Hamlin, South Dakota, US
392289 2020-08-08 US South Dakota Hand 46059 7 0 0 7 44.54708407 -99.00386459 2020-08-09 04:34:54 Hand, South Dakota, US
392292 2020-08-08 US South Dakota Hanson 46061 21 0 0 21 43.6746384 -97.78715148 2020-08-09 04:34:54 Hanson, South Dakota, US
392420 2020-08-08 US South Dakota Hughes 46065 92 2 0 90 44.39091534 -99.99661148 2020-08-09 04:34:54 Hughes, South Dakota, US
392433 2020-08-08 US South Dakota Hutchinson 46067 28 0 0 28 43.33449012 -97.75536441 2020-08-09 04:34:54 Hutchinson, South Dakota, US
392436 2020-08-08 US South Dakota Hyde 46069 3 0 0 3 44.54747703 -99.48572582 2020-08-09 04:34:54 Hyde, South Dakota, US
392487 2020-08-08 US South Dakota Jackson 46071 11 1 0 10 43.69318385 -101.6255063 2020-08-09 04:34:54 Jackson, South Dakota, US
392535 2020-08-08 US South Dakota Jerauld 46073 39 1 0 38 44.06637798 -98.62965972 2020-08-09 04:34:54 Jerauld, South Dakota, US
392561 2020-08-08 US South Dakota Jones 46075 2 0 0 2 43.96278565 -100.6940008 2020-08-09 04:34:54 Jones, South Dakota, US
392617 2020-08-08 US South Dakota Kingsbury 46077 14 0 0 14 44.36956169 -97.4913945 2020-08-09 04:34:54 Kingsbury, South Dakota, US
392675 2020-08-08 US South Dakota Lake 46079 91 2 0 89 44.02193107 -97.12926365 2020-08-09 04:34:54 Lake, South Dakota, US
392721 2020-08-08 US South Dakota Lawrence 46081 52 0 0 52 44.35919441 -103.7929428 2020-08-09 04:34:54 Lawrence, South Dakota, US
392786 2020-08-08 US South Dakota Lincoln 46083 621 2 0 619 43.27841182 -96.7203905 2020-08-09 04:34:54 Lincoln, South Dakota, US
392843 2020-08-08 US South Dakota Lyman 46085 89 2 0 87 43.89522709 -99.85201878 2020-08-09 04:34:54 Lyman, South Dakota, US
392930 2020-08-08 US South Dakota Marshall 46091 9 0 0 9 45.75870838 -97.59855639 2020-08-09 04:34:54 Marshall, South Dakota, US
392958 2020-08-08 US South Dakota McCook 46087 27 1 0 26 43.6742571 -97.36863144 2020-08-09 04:34:54 McCook, South Dakota, US
392987 2020-08-08 US South Dakota McPherson 46089 8 0 0 8 45.76626028 -99.22118798 2020-08-09 04:34:54 McPherson, South Dakota, US
392990 2020-08-08 US South Dakota Meade 46093 91 1 0 90 44.56676791 -102.7162741 2020-08-09 04:34:54 Meade, South Dakota, US
393000 2020-08-08 US South Dakota Mellette 46095 24 0 0 24 43.58078848 -100.7563186 2020-08-09 04:34:54 Mellette, South Dakota, US
393041 2020-08-08 US South Dakota Miner 46097 15 0 0 15 44.02197882 -97.60992207 2020-08-09 04:34:54 Miner, South Dakota, US
393047 2020-08-08 US South Dakota Minnehaha 46099 4376 68 0 4308 43.67441641 -96.7910885 2020-08-09 04:34:54 Minnehaha, South Dakota, US
393109 2020-08-08 US South Dakota Moody 46101 32 0 0 32 44.02266214 -96.67081159 2020-08-09 04:34:54 Moody, South Dakota, US
393230 2020-08-08 US South Dakota Oglala Lakota 46102 154 2 0 152 43.33749164 -102.5555498 2020-08-09 04:34:54 Oglala Lakota, South Dakota, US
393345 2020-08-08 US South Dakota Pennington 46103 881 32 0 849 44.0025835 -102.8240777 2020-08-09 04:34:54 Pennington, South Dakota, US
393351 2020-08-08 US South Dakota Perkins 46105 6 0 0 6 45.49049506 -102.4755586 2020-08-09 04:34:54 Perkins, South Dakota, US
393448 2020-08-08 US South Dakota Potter 46107 1 0 0 1 45.06583079 -99.95498503 2020-08-09 04:34:54 Potter, South Dakota, US
393563 2020-08-08 US South Dakota Roberts 46109 81 1 0 80 45.62975048 -96.94672673 2020-08-09 04:34:54 Roberts, South Dakota, US
393646 2020-08-08 US South Dakota Sanborn 46111 13 0 0 13 44.02351092 -98.0909816 2020-08-09 04:34:54 Sanborn, South Dakota, US
393774 2020-08-08 US South Dakota Spink 46115 24 0 0 24 44.93837606 -98.34626602 2020-08-09 04:34:54 Spink, South Dakota, US
393806 2020-08-08 US South Dakota Stanley 46117 14 0 0 14 44.41381872 -100.7349153 2020-08-09 04:34:54 Stanley, South Dakota, US
393853 2020-08-08 US South Dakota Sully 46119 3 0 0 3 44.71571812 -100.1278092 2020-08-09 04:34:54 Sully, South Dakota, US
393937 2020-08-08 US South Dakota Todd 46121 69 5 0 64 43.19338568 -100.7195503 2020-08-09 04:34:54 Todd, South Dakota, US
393960 2020-08-08 US South Dakota Tripp 46123 20 0 0 20 43.34459388 -99.8854891 2020-08-09 04:34:54 Tripp, South Dakota, US
393971 2020-08-08 US South Dakota Turner 46125 51 0 0 51 43.3109081 -97.14865776 2020-08-09 04:34:54 Turner, South Dakota, US
394022 2020-08-08 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-08-09 04:34:54 Unassigned, South Dakota, US
394048 2020-08-08 US South Dakota Union 46127 213 4 0 209 42.83112163 -96.6557828 2020-08-09 04:34:54 Union, South Dakota, US
394109 2020-08-08 US South Dakota Walworth 46129 18 0 0 18 45.43019636 -100.0307514 2020-08-09 04:34:54 Walworth, South Dakota, US
394304 2020-08-08 US South Dakota Yankton 46135 113 2 0 111 43.00924485 -97.39467635 2020-08-09 04:34:54 Yankton, South Dakota, US
394326 2020-08-08 US South Dakota Ziebach 46137 34 0 0 34 44.97881876 -101.6654622 2020-08-09 04:34:54 Ziebach, South Dakota, US
281762 2020-08-07 US South Dakota Aurora 46003 38 0 0 38 43.71757685 -98.56050467 2020-08-08 04:34:53 Aurora, South Dakota, US
281811 2020-08-07 US South Dakota Beadle 46005 587 9 0 578 44.41464384 -98.27858469 2020-08-08 04:34:53 Beadle, South Dakota, US
281833 2020-08-07 US South Dakota Bennett 46007 6 0 0 6 43.19486375 -101.6665572 2020-08-08 04:34:53 Bennett, South Dakota, US
281884 2020-08-07 US South Dakota Bon Homme 46009 13 0 0 13 42.98914167 -97.88592746 2020-08-08 04:34:53 Bon Homme, South Dakota, US
281933 2020-08-07 US South Dakota Brookings 46011 128 1 0 127 44.36974375 -96.79079945 2020-08-08 04:34:53 Brookings, South Dakota, US
281945 2020-08-07 US South Dakota Brown 46013 428 3 0 425 45.58994323 -98.35165355 2020-08-08 04:34:53 Brown, South Dakota, US
281948 2020-08-07 US South Dakota Brule 46015 45 0 0 45 43.71756379 -99.08118954 2020-08-08 04:34:53 Brule, South Dakota, US
281961 2020-08-07 US South Dakota Buffalo 46017 109 3 0 106 44.07657829 -99.20814467 2020-08-08 04:34:53 Buffalo, South Dakota, US
281986 2020-08-07 US South Dakota Butte 46019 14 1 0 13 44.90608745 -103.5079318 2020-08-08 04:34:53 Butte, South Dakota, US
282029 2020-08-07 US South Dakota Campbell 46021 3 0 0 3 45.77074915 -100.0510181 2020-08-08 04:34:53 Campbell, South Dakota, US
282110 2020-08-07 US South Dakota Charles Mix 46023 101 0 0 101 43.20660134 -98.58856175 2020-08-08 04:34:53 Charles Mix, South Dakota, US
282191 2020-08-07 US South Dakota Clark 46025 16 0 0 16 44.85834507 -97.72925109 2020-08-08 04:34:53 Clark, South Dakota, US
282214 2020-08-07 US South Dakota Clay 46027 124 0 0 124 42.91296147 -96.97656917 2020-08-08 04:34:53 Clay, South Dakota, US
282249 2020-08-07 US South Dakota Codington 46029 129 1 0 128 44.97788119 -97.18827677 2020-08-08 04:34:53 Codington, South Dakota, US
282301 2020-08-07 US South Dakota Corson 46031 32 0 0 32 45.70889983 -101.1970473 2020-08-08 04:34:53 Corson, South Dakota, US
282365 2020-08-07 US South Dakota Custer 46033 29 0 0 29 43.67741105 -103.4534521 2020-08-08 04:34:53 Custer, South Dakota, US
282393 2020-08-07 US South Dakota Davison 46035 94 1 0 93 43.67490933 -98.14458906 2020-08-08 04:34:53 Davison, South Dakota, US
282399 2020-08-07 US South Dakota Day 46037 21 0 0 21 45.367281 -97.60737498 2020-08-08 04:34:53 Day, South Dakota, US
282439 2020-08-07 US South Dakota Deuel 46039 10 0 0 10 44.75994309 -96.66943645 2020-08-08 04:34:53 Deuel, South Dakota, US
282441 2020-08-07 US South Dakota Dewey 46041 50 0 0 50 45.15639647 -100.8709139 2020-08-08 04:34:53 Dewey, South Dakota, US
282481 2020-08-07 US South Dakota Douglas 46043 17 0 0 17 43.38520741 -98.36978007 2020-08-08 04:34:53 Douglas, South Dakota, US
282515 2020-08-07 US South Dakota Edmunds 46045 14 0 0 14 45.41846445 -99.21545423 2020-08-08 04:34:53 Edmunds, South Dakota, US
282566 2020-08-07 US South Dakota Fall River 46047 22 0 0 22 43.23929297 -103.5275691 2020-08-08 04:34:53 Fall River, South Dakota, US
282573 2020-08-07 US South Dakota Faulk 46049 26 1 0 25 45.07082625 -99.14535601 2020-08-08 04:34:53 Faulk, South Dakota, US
282754 2020-08-07 US South Dakota Grant 46051 24 0 0 24 45.1723937 -96.77002276 2020-08-08 04:34:53 Grant, South Dakota, US
282795 2020-08-07 US South Dakota Gregory 46053 7 0 0 7 43.19419064 -99.18883902 2020-08-08 04:34:53 Gregory, South Dakota, US
282816 2020-08-07 US South Dakota Haakon 46055 2 0 0 2 44.29299053 -101.539099 2020-08-08 04:34:53 Haakon, South Dakota, US
282837 2020-08-07 US South Dakota Hamlin 46057 17 0 0 17 44.67385954 -97.18829593 2020-08-08 04:34:53 Hamlin, South Dakota, US
282853 2020-08-07 US South Dakota Hand 46059 7 0 0 7 44.54708407 -99.00386459 2020-08-08 04:34:53 Hand, South Dakota, US
282856 2020-08-07 US South Dakota Hanson 46061 21 0 0 21 43.6746384 -97.78715148 2020-08-08 04:34:53 Hanson, South Dakota, US
282984 2020-08-07 US South Dakota Hughes 46065 88 2 0 86 44.39091534 -99.99661148 2020-08-08 04:34:53 Hughes, South Dakota, US
282997 2020-08-07 US South Dakota Hutchinson 46067 27 0 0 27 43.33449012 -97.75536441 2020-08-08 04:34:53 Hutchinson, South Dakota, US
283000 2020-08-07 US South Dakota Hyde 46069 3 0 0 3 44.54747703 -99.48572582 2020-08-08 04:34:53 Hyde, South Dakota, US
283051 2020-08-07 US South Dakota Jackson 46071 11 1 0 10 43.69318385 -101.6255063 2020-08-08 04:34:53 Jackson, 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] INTEGER,
   [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]);
Powered by Datasette · Query took 1750.359ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette