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

51 rows where "day" is on date 2020-05-01 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 · 51 ✖

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
1181291 1181291 2020-05-01 US South Dakota Aurora 46003 1 0 0 1 43.71757685 -98.56050467 2020-05-02 02:32:27 Aurora, South Dakota, US
1181331 1181331 2020-05-01 US South Dakota Beadle 46005 21 2 0 19 44.41464384 -98.27858469 2020-05-02 02:32:27 Beadle, South Dakota, US
1181393 1181393 2020-05-01 US South Dakota Bon Homme 46009 4 0 0 4 42.98914167 -97.88592746 2020-05-02 02:32:27 Bon Homme, South Dakota, US
1181436 1181436 2020-05-01 US South Dakota Brookings 46011 13 0 0 13 44.36974375 -96.79079945 2020-05-02 02:32:27 Brookings, South Dakota, US
1181446 1181446 2020-05-01 US South Dakota Brown 46013 42 0 0 42 45.58994323 -98.35165355 2020-05-02 02:32:27 Brown, South Dakota, US
1181449 1181449 2020-05-01 US South Dakota Brule 46015 0 0 0 0 43.71756379 -99.08118954 2020-05-02 02:32:27 Brule, South Dakota, US
1181462 1181462 2020-05-01 US South Dakota Buffalo 46017 1 0 0 1 44.07657829 -99.20814467 2020-05-02 02:32:27 Buffalo, South Dakota, US
1181486 1181486 2020-05-01 US South Dakota Butte 46019 0 0 0 0 44.90608745 -103.5079318 2020-05-02 02:32:27 Butte, South Dakota, US
1181598 1181598 2020-05-01 US South Dakota Charles Mix 46023 5 0 0 5 43.20660134 -98.58856175 2020-05-02 02:32:27 Charles Mix, South Dakota, US
1181673 1181673 2020-05-01 US South Dakota Clark 46025 1 0 0 1 44.85834507 -97.72925109 2020-05-02 02:32:27 Clark, South Dakota, US
1181696 1181696 2020-05-01 US South Dakota Clay 46027 6 0 0 6 42.91296147 -96.97656917 2020-05-02 02:32:27 Clay, South Dakota, US
1181727 1181727 2020-05-01 US South Dakota Codington 46029 14 0 0 14 44.97788119 -97.18827677 2020-05-02 02:32:27 Codington, South Dakota, US
1181772 1181772 2020-05-01 US South Dakota Corson 46031 1 0 0 1 45.70889983 -101.1970473 2020-05-02 02:32:27 Corson, South Dakota, US
1181857 1181857 2020-05-01 US South Dakota Davison 46035 5 0 0 5 43.67490933 -98.14458906 2020-05-02 02:32:27 Davison, South Dakota, US
1181862 1181862 2020-05-01 US South Dakota Day 46037 4 0 0 4 45.367281 -97.60737498 2020-05-02 02:32:27 Day, South Dakota, US
1181897 1181897 2020-05-01 US South Dakota Deuel 46039 1 0 0 1 44.75994309 -96.66943645 2020-05-02 02:32:27 Deuel, South Dakota, US
1181899 1181899 2020-05-01 US South Dakota Dewey 46041 1 0 0 1 45.15639647 -100.8709139 2020-05-02 02:32:27 Dewey, South Dakota, US
1181933 1181933 2020-05-01 US South Dakota Douglas 46043 1 0 0 1 43.38520741 -98.36978007 2020-05-02 02:32:27 Douglas, South Dakota, US
1182007 1182007 2020-05-01 US South Dakota Fall River 46047 1 0 0 1 43.23929297 -103.5275691 2020-05-02 02:32:27 Fall River, South Dakota, US
1182013 1182013 2020-05-01 US South Dakota Faulk 46049 1 0 0 1 45.07082625 -99.14535601 2020-05-02 02:32:27 Faulk, South Dakota, US
1182248 1182248 2020-05-01 US South Dakota Hamlin 46057 2 0 0 2 44.67385954 -97.18829593 2020-05-02 02:32:27 Hamlin, South Dakota, US
1182264 1182264 2020-05-01 US South Dakota Hand 46059 1 0 0 1 44.54708407 -99.00386459 2020-05-02 02:32:27 Hand, South Dakota, US
1182378 1182378 2020-05-01 US South Dakota Hughes 46065 9 0 0 9 44.39091534 -99.99661148 2020-05-02 02:32:27 Hughes, South Dakota, US
1182390 1182390 2020-05-01 US South Dakota Hutchinson 46067 3 0 0 3 43.33449012 -97.75536441 2020-05-02 02:32:27 Hutchinson, South Dakota, US
1182393 1182393 2020-05-01 US South Dakota Hyde 46069 1 0 0 1 44.54747703 -99.48572582 2020-05-02 02:32:27 Hyde, South Dakota, US
1182483 1182483 2020-05-01 US South Dakota Jerauld 46073 6 1 0 5 44.06637798 -98.62965972 2020-05-02 02:32:27 Jerauld, South Dakota, US
1182552 1182552 2020-05-01 US South Dakota Kingsbury 46077 0 0 0 0 44.36956169 -97.4913945 2020-05-02 02:32:27 Kingsbury, South Dakota, US
1182602 1182602 2020-05-01 US South Dakota Lake 46079 4 0 0 4 44.02193107 -97.12926365 2020-05-02 02:32:27 Lake, South Dakota, US
1182640 1182640 2020-05-01 US South Dakota Lawrence 46081 9 0 0 9 44.35919441 -103.79294279999999 2020-05-02 02:32:27 Lawrence, South Dakota, US
1182704 1182704 2020-05-01 US South Dakota Lincoln 46083 153 0 0 153 43.27841182 -96.72039050000001 2020-05-02 02:32:27 Lincoln, South Dakota, US
1182753 1182753 2020-05-01 US South Dakota Lyman 46085 3 0 0 3 43.89522709 -99.85201878 2020-05-02 02:32:27 Lyman, South Dakota, US
1182836 1182836 2020-05-01 US South Dakota Marshall 46091 1 0 0 1 45.75870838 -97.59855639 2020-05-02 02:32:27 Marshall, South Dakota, US
1182861 1182861 2020-05-01 US South Dakota McCook 46087 4 1 0 3 43.6742571 -97.36863144 2020-05-02 02:32:27 McCook, South Dakota, US
1182888 1182888 2020-05-01 US South Dakota McPherson 46089 1 0 0 1 45.76626028 -99.22118798 2020-05-02 02:32:27 McPherson, South Dakota, US
1182891 1182891 2020-05-01 US South Dakota Meade 46093 1 0 0 1 44.56676791 -102.71627409999999 2020-05-02 02:32:27 Meade, South Dakota, US
1182938 1182938 2020-05-01 US South Dakota Miner 46097 1 0 0 1 44.02197882 -97.60992207 2020-05-02 02:32:27 Miner, South Dakota, US
1182944 1182944 2020-05-01 US South Dakota Minnehaha 46099 2089 16 0 2073 43.67441641 -96.7910885 2020-05-02 02:32:27 Minnehaha, South Dakota, US
1183002 1183002 2020-05-01 US South Dakota Moody 46101 5 0 0 5 44.02266214 -96.67081159 2020-05-02 02:32:27 Moody, South Dakota, US
1183115 1183115 2020-05-01 US South Dakota Oglala Lakota 46102 1 0 0 1 43.33749164 -102.55554980000001 2020-05-02 02:32:27 Oglala Lakota, South Dakota, US
1183220 1183220 2020-05-01 US South Dakota Pennington 46103 13 1 0 12 44.0025835 -102.8240777 2020-05-02 02:32:27 Pennington, South Dakota, US
1183414 1183414 2020-05-01 US South Dakota Roberts 46109 8 0 0 8 45.62975048 -96.94672673 2020-05-02 02:32:27 Roberts, South Dakota, US
1183484 1183484 2020-05-01 US South Dakota Sanborn 46111 3 0 0 3 44.02351092 -98.09098159999999 2020-05-02 02:32:27 Sanborn, South Dakota, US
1183598 1183598 2020-05-01 US South Dakota Spink 46115 3 0 0 3 44.93837606 -98.34626602 2020-05-02 02:32:27 Spink, South Dakota, US
1183630 1183630 2020-05-01 US South Dakota Stanley 46117 8 0 0 8 44.41381872 -100.7349153 2020-05-02 02:32:27 Stanley, South Dakota, US
1183672 1183672 2020-05-01 US South Dakota Sully 46119 1 0 0 1 44.71571812 -100.1278092 2020-05-02 02:32:27 Sully, South Dakota, US
1183744 1183744 2020-05-01 US South Dakota Todd 46121 2 0 0 2 43.19338568 -100.71955030000001 2020-05-02 02:32:27 Todd, South Dakota, US
1183771 1183771 2020-05-01 US South Dakota Turner 46125 17 0 0 17 43.3109081 -97.14865776 2020-05-02 02:32:27 Turner, South Dakota, US
1183822 1183822 2020-05-01 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-05-02 02:32:27 Unassigned, South Dakota, US
1183849 1183849 2020-05-01 US South Dakota Union 46127 21 0 0 21 42.83112163 -96.6557828 2020-05-02 02:32:27 Union, South Dakota, US
1183902 1183902 2020-05-01 US South Dakota Walworth 46129 5 0 0 5 45.43019636 -100.03075140000001 2020-05-02 02:32:27 Walworth, South Dakota, US
1184085 1184085 2020-05-01 US South Dakota Yankton 46135 27 0 0 27 43.00924485 -97.39467635 2020-05-02 02:32:27 Yankton, 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]);