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

67 rows where "day" is on date 2020-10-03 and 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 1

  • South Dakota · 67 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2517000 2517000 2020-10-03 US South Dakota Aurora 46003 68 0 0 68 43.71757685 -98.56050467 2020-10-04 04:23:44 Aurora, South Dakota, US
2517001 2517001 2020-10-03 US South Dakota Beadle 46005 841 10 0 831 44.41464384 -98.27858469 2020-10-04 04:23:44 Beadle, South Dakota, US
2517002 2517002 2020-10-03 US South Dakota Bennett 46007 74 3 0 71 43.19486375 -101.6665572 2020-10-04 04:23:44 Bennett, South Dakota, US
2517003 2517003 2020-10-03 US South Dakota Bon Homme 46009 108 1 0 107 42.98914167 -97.88592746 2020-10-04 04:23:44 Bon Homme, South Dakota, US
2517004 2517004 2020-10-03 US South Dakota Brookings 46011 833 2 0 831 44.36974375 -96.79079945 2020-10-04 04:23:44 Brookings, South Dakota, US
2517005 2517005 2020-10-03 US South Dakota Brown 46013 1326 4 0 1322 45.58994323 -98.35165355 2020-10-04 04:23:44 Brown, South Dakota, US
2517006 2517006 2020-10-03 US South Dakota Brule 46015 146 1 0 145 43.71756379 -99.08118954 2020-10-04 04:23:44 Brule, South Dakota, US
2517007 2517007 2020-10-03 US South Dakota Buffalo 46017 151 3 0 148 44.07657829 -99.20814467 2020-10-04 04:23:44 Buffalo, South Dakota, US
2517008 2517008 2020-10-03 US South Dakota Butte 46019 122 3 0 119 44.90608745 -103.5079318 2020-10-04 04:23:44 Butte, South Dakota, US
2517009 2517009 2020-10-03 US South Dakota Campbell 46021 37 0 0 37 45.77074915 -100.0510181 2020-10-04 04:23:44 Campbell, South Dakota, US
2517010 2517010 2020-10-03 US South Dakota Charles Mix 46023 206 0 0 206 43.20660134 -98.58856175 2020-10-04 04:23:44 Charles Mix, South Dakota, US
2517011 2517011 2020-10-03 US South Dakota Clark 46025 46 0 0 46 44.85834507 -97.72925109 2020-10-04 04:23:44 Clark, South Dakota, US
2517012 2517012 2020-10-03 US South Dakota Clay 46027 581 7 0 574 42.91296147 -96.97656917 2020-10-04 04:23:44 Clay, South Dakota, US
2517013 2517013 2020-10-03 US South Dakota Codington 46029 970 7 0 963 44.97788119 -97.18827677 2020-10-04 04:23:44 Codington, South Dakota, US
2517014 2517014 2020-10-03 US South Dakota Corson 46031 94 1 0 93 45.70889983 -101.1970473 2020-10-04 04:23:44 Corson, South Dakota, US
2517015 2517015 2020-10-03 US South Dakota Custer 46033 196 3 0 193 43.67741105 -103.4534521 2020-10-04 04:23:44 Custer, South Dakota, US
2517016 2517016 2020-10-03 US South Dakota Davison 46035 396 2 0 394 43.67490933 -98.14458906 2020-10-04 04:23:44 Davison, South Dakota, US
2517017 2517017 2020-10-03 US South Dakota Day 46037 95 0 0 95 45.367281 -97.60737498 2020-10-04 04:23:44 Day, South Dakota, US
2517018 2517018 2020-10-03 US South Dakota Deuel 46039 93 0 0 93 44.75994309 -96.66943645 2020-10-04 04:23:44 Deuel, South Dakota, US
2517019 2517019 2020-10-03 US South Dakota Dewey 46041 174 0 0 174 45.15639647 -100.8709139 2020-10-04 04:23:44 Dewey, South Dakota, US
2517020 2517020 2020-10-03 US South Dakota Douglas 46043 99 1 0 98 43.38520741 -98.36978007 2020-10-04 04:23:44 Douglas, South Dakota, US
2517021 2517021 2020-10-03 US South Dakota Edmunds 46045 102 0 0 102 45.41846445 -99.21545423 2020-10-04 04:23:44 Edmunds, South Dakota, US
2517022 2517022 2020-10-03 US South Dakota Fall River 46047 103 5 0 98 43.23929297 -103.5275691 2020-10-04 04:23:44 Fall River, South Dakota, US
2517023 2517023 2020-10-03 US South Dakota Faulk 46049 76 1 0 75 45.07082625 -99.14535601 2020-10-04 04:23:44 Faulk, South Dakota, US
2517024 2517024 2020-10-03 US South Dakota Grant 46051 172 1 0 171 45.1723937 -96.77002276 2020-10-04 04:23:44 Grant, South Dakota, US
2517025 2517025 2020-10-03 US South Dakota Gregory 46053 145 4 0 141 43.19419064 -99.18883902 2020-10-04 04:23:44 Gregory, South Dakota, US
2517026 2517026 2020-10-03 US South Dakota Haakon 46055 32 1 0 31 44.29299053 -101.539099 2020-10-04 04:23:44 Haakon, South Dakota, US
2517027 2517027 2020-10-03 US South Dakota Hamlin 46057 108 0 0 108 44.67385954 -97.18829593 2020-10-04 04:23:44 Hamlin, South Dakota, US
2517028 2517028 2020-10-03 US South Dakota Hand 46059 56 1 0 55 44.54708407 -99.00386459 2020-10-04 04:23:44 Hand, South Dakota, US
2517029 2517029 2020-10-03 US South Dakota Hanson 46061 47 1 0 46 43.6746384 -97.78715148 2020-10-04 04:23:44 Hanson, South Dakota, US
2517030 2517030 2020-10-03 US South Dakota Harding 46063 4 0 0 4 45.58015551 -103.4958629 2020-10-04 04:23:44 Harding, South Dakota, US
2517031 2517031 2020-10-03 US South Dakota Hughes 46065 530 5 0 525 44.39091534 -99.99661148 2020-10-04 04:23:44 Hughes, South Dakota, US
2517032 2517032 2020-10-03 US South Dakota Hutchinson 46067 119 2 0 117 43.33449012 -97.75536441 2020-10-04 04:23:44 Hutchinson, South Dakota, US
2517033 2517033 2020-10-03 US South Dakota Hyde 46069 20 0 0 20 44.54747703 -99.48572582 2020-10-04 04:23:44 Hyde, South Dakota, US
2517034 2517034 2020-10-03 US South Dakota Jackson 46071 37 1 0 36 43.69318385 -101.6255063 2020-10-04 04:23:44 Jackson, South Dakota, US
2517035 2517035 2020-10-03 US South Dakota Jerauld 46073 99 3 0 96 44.06637798 -98.62965972 2020-10-04 04:23:44 Jerauld, South Dakota, US
2517036 2517036 2020-10-03 US South Dakota Jones 46075 18 0 0 18 43.96278565 -100.6940008 2020-10-04 04:23:44 Jones, South Dakota, US
2517037 2517037 2020-10-03 US South Dakota Kingsbury 46077 63 0 0 63 44.36956169 -97.4913945 2020-10-04 04:23:44 Kingsbury, South Dakota, US
2517038 2517038 2020-10-03 US South Dakota Lake 46079 212 7 0 205 44.02193107 -97.12926365 2020-10-04 04:23:44 Lake, South Dakota, US
2517039 2517039 2020-10-03 US South Dakota Lawrence 46081 457 5 0 452 44.35919441 -103.7929428 2020-10-04 04:23:44 Lawrence, South Dakota, US
2517040 2517040 2020-10-03 US South Dakota Lincoln 46083 1531 3 0 1528 43.27841182 -96.7203905 2020-10-04 04:23:44 Lincoln, South Dakota, US
2517041 2517041 2020-10-03 US South Dakota Lyman 46085 179 3 0 176 43.89522709 -99.85201878 2020-10-04 04:23:44 Lyman, South Dakota, US
2517042 2517042 2020-10-03 US South Dakota Marshall 46091 46 0 0 46 45.75870838 -97.59855639 2020-10-04 04:23:44 Marshall, South Dakota, US
2517043 2517043 2020-10-03 US South Dakota McCook 46087 120 1 0 119 43.6742571 -97.36863144 2020-10-04 04:23:44 McCook, South Dakota, US
2517044 2517044 2020-10-03 US South Dakota McPherson 46089 40 0 0 40 45.76626028 -99.22118798 2020-10-04 04:23:44 McPherson, South Dakota, US
2517045 2517045 2020-10-03 US South Dakota Meade 46093 608 5 0 603 44.56676791 -102.7162741 2020-10-04 04:23:44 Meade, South Dakota, US
2517046 2517046 2020-10-03 US South Dakota Mellette 46095 36 0 0 36 43.58078848 -100.7563186 2020-10-04 04:23:44 Mellette, South Dakota, US
2517047 2517047 2020-10-03 US South Dakota Miner 46097 28 0 0 28 44.02197882 -97.60992207 2020-10-04 04:23:44 Miner, South Dakota, US
2517048 2517048 2020-10-03 US South Dakota Minnehaha 46099 7109 84 0 7025 43.67441641 -96.7910885 2020-10-04 04:23:44 Minnehaha, South Dakota, US
2517049 2517049 2020-10-03 US South Dakota Moody 46101 111 0 0 111 44.02266214 -96.67081159 2020-10-04 04:23:44 Moody, South Dakota, US
2517050 2517050 2020-10-03 US South Dakota Oglala Lakota 46102 333 4 0 329 43.33749164 -102.5555498 2020-10-04 04:23:44 Oglala Lakota, South Dakota, US
2517051 2517051 2020-10-03 US South Dakota Pennington 46103 2568 37 0 2531 44.0025835 -102.8240777 2020-10-04 04:23:44 Pennington, South Dakota, US
2517052 2517052 2020-10-03 US South Dakota Perkins 46105 42 0 0 42 45.49049506 -102.4755586 2020-10-04 04:23:44 Perkins, South Dakota, US
2517053 2517053 2020-10-03 US South Dakota Potter 46107 51 0 0 51 45.06583079 -99.95498503 2020-10-04 04:23:44 Potter, South Dakota, US
2517054 2517054 2020-10-03 US South Dakota Roberts 46109 237 1 0 236 45.62975048 -96.94672673 2020-10-04 04:23:44 Roberts, South Dakota, US
2517055 2517055 2020-10-03 US South Dakota Sanborn 46111 39 0 0 39 44.02351092 -98.0909816 2020-10-04 04:23:44 Sanborn, South Dakota, US
2517056 2517056 2020-10-03 US South Dakota Spink 46115 150 0 0 150 44.93837606 -98.34626602 2020-10-04 04:23:44 Spink, South Dakota, US
2517057 2517057 2020-10-03 US South Dakota Stanley 46117 48 0 0 48 44.41381872 -100.7349153 2020-10-04 04:23:44 Stanley, South Dakota, US
2517058 2517058 2020-10-03 US South Dakota Sully 46119 14 0 0 14 44.71571812 -100.1278092 2020-10-04 04:23:44 Sully, South Dakota, US
2517059 2517059 2020-10-03 US South Dakota Todd 46121 151 5 0 146 43.19338568 -100.7195503 2020-10-04 04:23:44 Todd, South Dakota, US
2517060 2517060 2020-10-03 US South Dakota Tripp 46123 185 1 0 184 43.34459388 -99.8854891 2020-10-04 04:23:44 Tripp, South Dakota, US
2517061 2517061 2020-10-03 US South Dakota Turner 46125 181 4 0 177 43.3109081 -97.14865776 2020-10-04 04:23:44 Turner, South Dakota, US
2517062 2517062 2020-10-03 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-10-04 04:23:44 Unassigned, South Dakota, US
2517063 2517063 2020-10-03 US South Dakota Union 46127 454 9 0 445 42.83112163 -96.6557828 2020-10-04 04:23:44 Union, South Dakota, US
2517064 2517064 2020-10-03 US South Dakota Walworth 46129 140 1 0 139 45.43019636 -100.0307514 2020-10-04 04:23:44 Walworth, South Dakota, US
2517065 2517065 2020-10-03 US South Dakota Yankton 46135 464 4 0 460 43.00924485 -97.39467635 2020-10-04 04:23:44 Yankton, South Dakota, US
2517066 2517066 2020-10-03 US South Dakota Ziebach 46137 65 1 0 64 44.97881876 -101.6654622 2020-10-04 04:23:44 Ziebach, South Dakota, US

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