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-09-30 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
1048645 1048645 2020-09-30 US South Dakota Aurora 46003 59 0 0 59 43.71757685 -98.56050467 2020-10-01 04:23:42 Aurora, South Dakota, US
1048646 1048646 2020-09-30 US South Dakota Beadle 46005 815 9 0 806 44.41464384 -98.27858469 2020-10-01 04:23:42 Beadle, South Dakota, US
1048647 1048647 2020-09-30 US South Dakota Bennett 46007 67 1 0 66 43.19486375 -101.6665572 2020-10-01 04:23:42 Bennett, South Dakota, US
1048648 1048648 2020-09-30 US South Dakota Bon Homme 46009 91 1 0 90 42.98914167 -97.88592746 2020-10-01 04:23:42 Bon Homme, South Dakota, US
1048649 1048649 2020-09-30 US South Dakota Brookings 46011 779 2 0 777 44.36974375 -96.79079945 2020-10-01 04:23:42 Brookings, South Dakota, US
1048650 1048650 2020-09-30 US South Dakota Brown 46013 1240 4 0 1236 45.58994323 -98.35165355 2020-10-01 04:23:42 Brown, South Dakota, US
1048651 1048651 2020-09-30 US South Dakota Brule 46015 132 0 0 132 43.71756379 -99.08118954 2020-10-01 04:23:42 Brule, South Dakota, US
1048652 1048652 2020-09-30 US South Dakota Buffalo 46017 140 3 0 137 44.07657829 -99.20814467 2020-10-01 04:23:42 Buffalo, South Dakota, US
1048653 1048653 2020-09-30 US South Dakota Butte 46019 110 3 0 107 44.90608745 -103.5079318 2020-10-01 04:23:42 Butte, South Dakota, US
1048654 1048654 2020-09-30 US South Dakota Campbell 46021 36 0 0 36 45.77074915 -100.0510181 2020-10-01 04:23:42 Campbell, South Dakota, US
1048655 1048655 2020-09-30 US South Dakota Charles Mix 46023 184 0 0 184 43.20660134 -98.58856175 2020-10-01 04:23:42 Charles Mix, South Dakota, US
1048656 1048656 2020-09-30 US South Dakota Clark 46025 43 0 0 43 44.85834507 -97.72925109 2020-10-01 04:23:42 Clark, South Dakota, US
1048657 1048657 2020-09-30 US South Dakota Clay 46027 568 6 0 562 42.91296147 -96.97656917 2020-10-01 04:23:42 Clay, South Dakota, US
1048658 1048658 2020-09-30 US South Dakota Codington 46029 894 6 0 888 44.97788119 -97.18827677 2020-10-01 04:23:42 Codington, South Dakota, US
1048659 1048659 2020-09-30 US South Dakota Corson 46031 92 1 0 91 45.70889983 -101.1970473 2020-10-01 04:23:42 Corson, South Dakota, US
1048660 1048660 2020-09-30 US South Dakota Custer 46033 189 2 0 187 43.67741105 -103.4534521 2020-10-01 04:23:42 Custer, South Dakota, US
1048661 1048661 2020-09-30 US South Dakota Davison 46035 329 2 0 327 43.67490933 -98.14458906 2020-10-01 04:23:42 Davison, South Dakota, US
1048662 1048662 2020-09-30 US South Dakota Day 46037 84 0 0 84 45.367281 -97.60737498 2020-10-01 04:23:42 Day, South Dakota, US
1048663 1048663 2020-09-30 US South Dakota Deuel 46039 87 0 0 87 44.75994309 -96.66943645 2020-10-01 04:23:42 Deuel, South Dakota, US
1048664 1048664 2020-09-30 US South Dakota Dewey 46041 158 0 0 158 45.15639647 -100.8709139 2020-10-01 04:23:42 Dewey, South Dakota, US
1048665 1048665 2020-09-30 US South Dakota Douglas 46043 87 1 0 86 43.38520741 -98.36978007 2020-10-01 04:23:42 Douglas, South Dakota, US
1048666 1048666 2020-09-30 US South Dakota Edmunds 46045 98 0 0 98 45.41846445 -99.21545423 2020-10-01 04:23:42 Edmunds, South Dakota, US
1048667 1048667 2020-09-30 US South Dakota Fall River 46047 96 4 0 92 43.23929297 -103.5275691 2020-10-01 04:23:42 Fall River, South Dakota, US
1048668 1048668 2020-09-30 US South Dakota Faulk 46049 74 1 0 73 45.07082625 -99.14535601 2020-10-01 04:23:42 Faulk, South Dakota, US
1048669 1048669 2020-09-30 US South Dakota Grant 46051 144 1 0 143 45.1723937 -96.77002276 2020-10-01 04:23:42 Grant, South Dakota, US
1048670 1048670 2020-09-30 US South Dakota Gregory 46053 136 3 0 133 43.19419064 -99.18883902 2020-10-01 04:23:42 Gregory, South Dakota, US
1048671 1048671 2020-09-30 US South Dakota Haakon 46055 27 0 0 27 44.29299053 -101.539099 2020-10-01 04:23:42 Haakon, South Dakota, US
1048672 1048672 2020-09-30 US South Dakota Hamlin 46057 101 0 0 101 44.67385954 -97.18829593 2020-10-01 04:23:42 Hamlin, South Dakota, US
1048673 1048673 2020-09-30 US South Dakota Hand 46059 47 0 0 47 44.54708407 -99.00386459 2020-10-01 04:23:42 Hand, South Dakota, US
1048674 1048674 2020-09-30 US South Dakota Hanson 46061 42 0 0 42 43.6746384 -97.78715148 2020-10-01 04:23:42 Hanson, South Dakota, US
1048675 1048675 2020-09-30 US South Dakota Harding 46063 4 0 0 4 45.58015551 -103.4958629 2020-10-01 04:23:42 Harding, South Dakota, US
1048676 1048676 2020-09-30 US South Dakota Hughes 46065 459 5 0 454 44.39091534 -99.99661148 2020-10-01 04:23:42 Hughes, South Dakota, US
1048677 1048677 2020-09-30 US South Dakota Hutchinson 46067 105 2 0 103 43.33449012 -97.75536441 2020-10-01 04:23:42 Hutchinson, South Dakota, US
1048678 1048678 2020-09-30 US South Dakota Hyde 46069 20 0 0 20 44.54747703 -99.48572582 2020-10-01 04:23:42 Hyde, South Dakota, US
1048679 1048679 2020-09-30 US South Dakota Jackson 46071 36 1 0 35 43.69318385 -101.6255063 2020-10-01 04:23:42 Jackson, South Dakota, US
1048680 1048680 2020-09-30 US South Dakota Jerauld 46073 96 1 0 95 44.06637798 -98.62965972 2020-10-01 04:23:42 Jerauld, South Dakota, US
1048681 1048681 2020-09-30 US South Dakota Jones 46075 14 0 0 14 43.96278565 -100.6940008 2020-10-01 04:23:42 Jones, South Dakota, US
1048682 1048682 2020-09-30 US South Dakota Kingsbury 46077 59 0 0 59 44.36956169 -97.4913945 2020-10-01 04:23:42 Kingsbury, South Dakota, US
1048683 1048683 2020-09-30 US South Dakota Lake 46079 201 7 0 194 44.02193107 -97.12926365 2020-10-01 04:23:42 Lake, South Dakota, US
1048684 1048684 2020-09-30 US South Dakota Lawrence 46081 428 5 0 423 44.35919441 -103.7929428 2020-10-01 04:23:42 Lawrence, South Dakota, US
1048685 1048685 2020-09-30 US South Dakota Lincoln 46083 1408 2 0 1406 43.27841182 -96.7203905 2020-10-01 04:23:42 Lincoln, South Dakota, US
1048686 1048686 2020-09-30 US South Dakota Lyman 46085 165 3 0 162 43.89522709 -99.85201878 2020-10-01 04:23:42 Lyman, South Dakota, US
1048687 1048687 2020-09-30 US South Dakota Marshall 46091 43 0 0 43 45.75870838 -97.59855639 2020-10-01 04:23:42 Marshall, South Dakota, US
1048688 1048688 2020-09-30 US South Dakota McCook 46087 106 1 0 105 43.6742571 -97.36863144 2020-10-01 04:23:42 McCook, South Dakota, US
1048689 1048689 2020-09-30 US South Dakota McPherson 46089 36 0 0 36 45.76626028 -99.22118798 2020-10-01 04:23:42 McPherson, South Dakota, US
1048690 1048690 2020-09-30 US South Dakota Meade 46093 560 5 0 555 44.56676791 -102.7162741 2020-10-01 04:23:42 Meade, South Dakota, US
1048691 1048691 2020-09-30 US South Dakota Mellette 46095 32 0 0 32 43.58078848 -100.7563186 2020-10-01 04:23:42 Mellette, South Dakota, US
1048692 1048692 2020-09-30 US South Dakota Miner 46097 25 0 0 25 44.02197882 -97.60992207 2020-10-01 04:23:42 Miner, South Dakota, US
1048693 1048693 2020-09-30 US South Dakota Minnehaha 46099 6816 81 0 6735 43.67441641 -96.7910885 2020-10-01 04:23:42 Minnehaha, South Dakota, US
1048694 1048694 2020-09-30 US South Dakota Moody 46101 98 0 0 98 44.02266214 -96.67081159 2020-10-01 04:23:42 Moody, South Dakota, US
1048695 1048695 2020-09-30 US South Dakota Oglala Lakota 46102 295 3 0 292 43.33749164 -102.5555498 2020-10-01 04:23:42 Oglala Lakota, South Dakota, US
1048696 1048696 2020-09-30 US South Dakota Pennington 46103 2405 37 0 2368 44.0025835 -102.8240777 2020-10-01 04:23:42 Pennington, South Dakota, US
1048697 1048697 2020-09-30 US South Dakota Perkins 46105 41 0 0 41 45.49049506 -102.4755586 2020-10-01 04:23:42 Perkins, South Dakota, US
1048698 1048698 2020-09-30 US South Dakota Potter 46107 46 0 0 46 45.06583079 -99.95498503 2020-10-01 04:23:42 Potter, South Dakota, US
1048699 1048699 2020-09-30 US South Dakota Roberts 46109 217 1 0 216 45.62975048 -96.94672673 2020-10-01 04:23:42 Roberts, South Dakota, US
1048700 1048700 2020-09-30 US South Dakota Sanborn 46111 31 0 0 31 44.02351092 -98.0909816 2020-10-01 04:23:42 Sanborn, South Dakota, US
1048701 1048701 2020-09-30 US South Dakota Spink 46115 140 0 0 140 44.93837606 -98.34626602 2020-10-01 04:23:42 Spink, South Dakota, US
1048702 1048702 2020-09-30 US South Dakota Stanley 46117 42 0 0 42 44.41381872 -100.7349153 2020-10-01 04:23:42 Stanley, South Dakota, US
1048703 1048703 2020-09-30 US South Dakota Sully 46119 13 0 0 13 44.71571812 -100.1278092 2020-10-01 04:23:42 Sully, South Dakota, US
1048704 1048704 2020-09-30 US South Dakota Todd 46121 128 5 0 123 43.19338568 -100.7195503 2020-10-01 04:23:42 Todd, South Dakota, US
1048705 1048705 2020-09-30 US South Dakota Tripp 46123 164 0 0 164 43.34459388 -99.8854891 2020-10-01 04:23:42 Tripp, South Dakota, US
1048706 1048706 2020-09-30 US South Dakota Turner 46125 168 2 0 166 43.3109081 -97.14865776 2020-10-01 04:23:42 Turner, South Dakota, US
1048707 1048707 2020-09-30 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-10-01 04:23:42 Unassigned, South Dakota, US
1048708 1048708 2020-09-30 US South Dakota Union 46127 408 7 0 401 42.83112163 -96.6557828 2020-10-01 04:23:42 Union, South Dakota, US
1048709 1048709 2020-09-30 US South Dakota Walworth 46129 133 1 0 132 45.43019636 -100.0307514 2020-10-01 04:23:42 Walworth, South Dakota, US
1048710 1048710 2020-09-30 US South Dakota Yankton 46135 435 4 0 431 43.00924485 -97.39467635 2020-10-01 04:23:42 Yankton, South Dakota, US
1048711 1048711 2020-09-30 US South Dakota Ziebach 46137 63 0 0 63 44.97881876 -101.6654622 2020-10-01 04:23:42 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]);