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-12-18 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
1904002 1904002 2020-12-18 US South Dakota Aurora 46003 393 8 0 385 43.71757685 -98.56050467 2020-12-19 05:27:52 Aurora, South Dakota, US
1904003 1904003 2020-12-18 US South Dakota Beadle 46005 2447 33 0 2414 44.41464384 -98.27858469 2020-12-19 05:27:52 Beadle, South Dakota, US
1904004 1904004 2020-12-18 US South Dakota Bennett 46007 346 8 0 338 43.19486375 -101.6665572 2020-12-19 05:27:52 Bennett, South Dakota, US
1904005 1904005 2020-12-18 US South Dakota Bon Homme 46009 1439 22 0 1417 42.98914167 -97.88592746 2020-12-19 05:27:52 Bon Homme, South Dakota, US
1904006 1904006 2020-12-18 US South Dakota Brookings 46011 2793 24 0 2769 44.36974375 -96.79079945 2020-12-19 05:27:52 Brookings, South Dakota, US
1904007 1904007 2020-12-18 US South Dakota Brown 46013 4178 49 0 4129 45.58994323 -98.35165355 2020-12-19 05:27:52 Brown, South Dakota, US
1904008 1904008 2020-12-18 US South Dakota Brule 46015 622 6 0 616 43.71756379 -99.08118954 2020-12-19 05:27:52 Brule, South Dakota, US
1904009 1904009 2020-12-18 US South Dakota Buffalo 46017 405 10 0 395 44.07657829 -99.20814467 2020-12-19 05:27:52 Buffalo, South Dakota, US
1904010 1904010 2020-12-18 US South Dakota Butte 46019 828 16 0 812 44.90608745 -103.5079318 2020-12-19 05:27:52 Butte, South Dakota, US
1904011 1904011 2020-12-18 US South Dakota Campbell 46021 109 1 0 108 45.77074915 -100.0510181 2020-12-19 05:27:52 Campbell, South Dakota, US
1904012 1904012 2020-12-18 US South Dakota Charles Mix 46023 1056 10 0 1046 43.20660134 -98.58856175 2020-12-19 05:27:52 Charles Mix, South Dakota, US
1904013 1904013 2020-12-18 US South Dakota Clark 46025 297 2 0 295 44.85834507 -97.72925109 2020-12-19 05:27:52 Clark, South Dakota, US
1904014 1904014 2020-12-18 US South Dakota Clay 46027 1546 11 0 1535 42.91296147 -96.97656917 2020-12-19 05:27:52 Clay, South Dakota, US
1904015 1904015 2020-12-18 US South Dakota Codington 46029 3237 64 0 3173 44.97788119 -97.18827677 2020-12-19 05:27:52 Codington, South Dakota, US
1904016 1904016 2020-12-18 US South Dakota Corson 46031 437 6 0 431 45.70889983 -101.1970473 2020-12-19 05:27:52 Corson, South Dakota, US
1904017 1904017 2020-12-18 US South Dakota Custer 46033 644 8 0 636 43.67741105 -103.4534521 2020-12-19 05:27:52 Custer, South Dakota, US
1904018 1904018 2020-12-18 US South Dakota Davison 46035 2623 52 0 2571 43.67490933 -98.14458906 2020-12-19 05:27:52 Davison, South Dakota, US
1904019 1904019 2020-12-18 US South Dakota Day 46037 497 17 0 480 45.367281 -97.60737498 2020-12-19 05:27:52 Day, South Dakota, US
1904020 1904020 2020-12-18 US South Dakota Deuel 46039 385 6 0 379 44.75994309 -96.66943645 2020-12-19 05:27:52 Deuel, South Dakota, US
1904021 1904021 2020-12-18 US South Dakota Dewey 46041 1214 8 0 1206 45.15639647 -100.8709139 2020-12-19 05:27:52 Dewey, South Dakota, US
1904022 1904022 2020-12-18 US South Dakota Douglas 46043 353 6 0 347 43.38520741 -98.36978007 2020-12-19 05:27:52 Douglas, South Dakota, US
1904023 1904023 2020-12-18 US South Dakota Edmunds 46045 315 3 0 312 45.41846445 -99.21545423 2020-12-19 05:27:52 Edmunds, South Dakota, US
1904024 1904024 2020-12-18 US South Dakota Fall River 46047 418 10 0 408 43.23929297 -103.5275691 2020-12-19 05:27:52 Fall River, South Dakota, US
1904025 1904025 2020-12-18 US South Dakota Faulk 46049 307 10 0 297 45.07082625 -99.14535601 2020-12-19 05:27:52 Faulk, South Dakota, US
1904026 1904026 2020-12-18 US South Dakota Grant 46051 799 21 0 778 45.1723937 -96.77002276 2020-12-19 05:27:52 Grant, South Dakota, US
1904027 1904027 2020-12-18 US South Dakota Gregory 46053 471 24 0 447 43.19419064 -99.18883902 2020-12-19 05:27:52 Gregory, South Dakota, US
1904028 1904028 2020-12-18 US South Dakota Haakon 46055 216 5 0 211 44.29299053 -101.539099 2020-12-19 05:27:52 Haakon, South Dakota, US
1904029 1904029 2020-12-18 US South Dakota Hamlin 46057 570 32 0 538 44.67385954 -97.18829593 2020-12-19 05:27:52 Hamlin, South Dakota, US
1904030 1904030 2020-12-18 US South Dakota Hand 46059 309 2 0 307 44.54708407 -99.00386459 2020-12-19 05:27:52 Hand, South Dakota, US
1904031 1904031 2020-12-18 US South Dakota Hanson 46061 300 3 0 297 43.6746384 -97.78715148 2020-12-19 05:27:52 Hanson, South Dakota, US
1904032 1904032 2020-12-18 US South Dakota Harding 46063 87 0 0 87 45.58015551 -103.4958629 2020-12-19 05:27:52 Harding, South Dakota, US
1904033 1904033 2020-12-18 US South Dakota Hughes 46065 1911 25 0 1886 44.39091534 -99.99661148 2020-12-19 05:27:52 Hughes, South Dakota, US
1904034 1904034 2020-12-18 US South Dakota Hutchinson 46067 673 14 0 659 43.33449012 -97.75536441 2020-12-19 05:27:52 Hutchinson, South Dakota, US
1904035 1904035 2020-12-18 US South Dakota Hyde 46069 130 0 0 130 44.54747703 -99.48572582 2020-12-19 05:27:52 Hyde, South Dakota, US
1904036 1904036 2020-12-18 US South Dakota Jackson 46071 255 8 0 247 43.69318385 -101.6255063 2020-12-19 05:27:52 Jackson, South Dakota, US
1904037 1904037 2020-12-18 US South Dakota Jerauld 46073 256 15 0 241 44.06637798 -98.62965972 2020-12-19 05:27:52 Jerauld, South Dakota, US
1904038 1904038 2020-12-18 US South Dakota Jones 46075 63 0 0 63 43.96278565 -100.6940008 2020-12-19 05:27:52 Jones, South Dakota, US
1904039 1904039 2020-12-18 US South Dakota Kingsbury 46077 497 13 0 484 44.36956169 -97.4913945 2020-12-19 05:27:52 Kingsbury, South Dakota, US
1904040 1904040 2020-12-18 US South Dakota Lake 46079 965 13 0 952 44.02193107 -97.12926365 2020-12-19 05:27:52 Lake, South Dakota, US
1904041 1904041 2020-12-18 US South Dakota Lawrence 46081 2397 27 0 2370 44.35919441 -103.7929428 2020-12-19 05:27:52 Lawrence, South Dakota, US
1904042 1904042 2020-12-18 US South Dakota Lincoln 46083 6332 58 0 6274 43.27841182 -96.7203905 2020-12-19 05:27:52 Lincoln, South Dakota, US
1904043 1904043 2020-12-18 US South Dakota Lyman 46085 507 9 0 498 43.89522709 -99.85201878 2020-12-19 05:27:52 Lyman, South Dakota, US
1904044 1904044 2020-12-18 US South Dakota Marshall 46091 240 4 0 236 45.75870838 -97.59855639 2020-12-19 05:27:52 Marshall, South Dakota, US
1904045 1904045 2020-12-18 US South Dakota McCook 46087 646 21 0 625 43.6742571 -97.36863144 2020-12-19 05:27:52 McCook, South Dakota, US
1904046 1904046 2020-12-18 US South Dakota McPherson 46089 170 1 0 169 45.76626028 -99.22118798 2020-12-19 05:27:52 McPherson, South Dakota, US
1904047 1904047 2020-12-18 US South Dakota Meade 46093 2097 20 0 2077 44.56676791 -102.7162741 2020-12-19 05:27:52 Meade, South Dakota, US
1904048 1904048 2020-12-18 US South Dakota Mellette 46095 212 2 0 210 43.58078848 -100.7563186 2020-12-19 05:27:52 Mellette, South Dakota, US
1904049 1904049 2020-12-18 US South Dakota Miner 46097 216 6 0 210 44.02197882 -97.60992207 2020-12-19 05:27:52 Miner, South Dakota, US
1904050 1904050 2020-12-18 US South Dakota Minnehaha 46099 23759 239 0 23520 43.67441641 -96.7910885 2020-12-19 05:27:52 Minnehaha, South Dakota, US
1904051 1904051 2020-12-18 US South Dakota Moody 46101 507 14 0 493 44.02266214 -96.67081159 2020-12-19 05:27:52 Moody, South Dakota, US
1904052 1904052 2020-12-18 US South Dakota Oglala Lakota 46102 1849 33 0 1816 43.33749164 -102.5555498 2020-12-19 05:27:52 Oglala Lakota, South Dakota, US
1904053 1904053 2020-12-18 US South Dakota Pennington 46103 10379 123 0 10256 44.0025835 -102.8240777 2020-12-19 05:27:52 Pennington, South Dakota, US
1904054 1904054 2020-12-18 US South Dakota Perkins 46105 251 6 0 245 45.49049506 -102.4755586 2020-12-19 05:27:52 Perkins, South Dakota, US
1904055 1904055 2020-12-18 US South Dakota Potter 46107 291 2 0 289 45.06583079 -99.95498503 2020-12-19 05:27:52 Potter, South Dakota, US
1904056 1904056 2020-12-18 US South Dakota Roberts 46109 897 26 0 871 45.62975048 -96.94672673 2020-12-19 05:27:52 Roberts, South Dakota, US
1904057 1904057 2020-12-18 US South Dakota Sanborn 46111 300 3 0 297 44.02351092 -98.0909816 2020-12-19 05:27:52 Sanborn, South Dakota, US
1904058 1904058 2020-12-18 US South Dakota Spink 46115 674 21 0 653 44.93837606 -98.34626602 2020-12-19 05:27:52 Spink, South Dakota, US
1904059 1904059 2020-12-18 US South Dakota Stanley 46117 259 2 0 257 44.41381872 -100.7349153 2020-12-19 05:27:52 Stanley, South Dakota, US
1904060 1904060 2020-12-18 US South Dakota Sully 46119 102 3 0 99 44.71571812 -100.1278092 2020-12-19 05:27:52 Sully, South Dakota, US
1904061 1904061 2020-12-18 US South Dakota Todd 46121 1119 17 0 1102 43.19338568 -100.7195503 2020-12-19 05:27:52 Todd, South Dakota, US
1904062 1904062 2020-12-18 US South Dakota Tripp 46123 599 10 0 589 43.34459388 -99.8854891 2020-12-19 05:27:52 Tripp, South Dakota, US
1904063 1904063 2020-12-18 US South Dakota Turner 46125 917 47 0 870 43.3109081 -97.14865776 2020-12-19 05:27:52 Turner, South Dakota, US
1904064 1904064 2020-12-18 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-12-19 05:27:52 Unassigned, South Dakota, US
1904065 1904065 2020-12-18 US South Dakota Union 46127 1481 28 0 1453 42.83112163 -96.6557828 2020-12-19 05:27:52 Union, South Dakota, US
1904066 1904066 2020-12-18 US South Dakota Walworth 46129 587 14 0 573 45.43019636 -100.0307514 2020-12-19 05:27:52 Walworth, South Dakota, US
1904067 1904067 2020-12-18 US South Dakota Yankton 46135 2313 21 0 2292 43.00924485 -97.39467635 2020-12-19 05:27:52 Yankton, South Dakota, US
1904068 1904068 2020-12-18 US South Dakota Ziebach 46137 280 7 0 273 44.97881876 -101.6654622 2020-12-19 05:27:52 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]);