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

58 rows where "day" is on date 2020-06-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 · 58 ✖

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
3863635 3863635 2020-06-03 US South Dakota Aurora 46003 27 0 0 27 43.71757685 -98.56050467 2020-06-04 02:33:14 Aurora, South Dakota, US
3863678 3863678 2020-06-03 US South Dakota Beadle 46005 308 5 0 303 44.41464384 -98.27858469 2020-06-04 02:33:14 Beadle, South Dakota, US
3863745 3863745 2020-06-03 US South Dakota Bon Homme 46009 8 0 0 8 42.98914167 -97.88592746 2020-06-04 02:33:14 Bon Homme, South Dakota, US
3863792 3863792 2020-06-03 US South Dakota Brookings 46011 20 0 0 20 44.36974375 -96.79079945 2020-06-04 02:33:14 Brookings, South Dakota, US
3863803 3863803 2020-06-03 US South Dakota Brown 46013 286 1 0 285 45.58994323 -98.35165355 2020-06-04 02:33:14 Brown, South Dakota, US
3863806 3863806 2020-06-03 US South Dakota Brule 46015 2 0 0 2 43.71756379 -99.08118954 2020-06-04 02:33:14 Brule, South Dakota, US
3863819 3863819 2020-06-03 US South Dakota Buffalo 46017 22 0 0 22 44.07657829 -99.20814467 2020-06-04 02:33:14 Buffalo, South Dakota, US
3863844 3863844 2020-06-03 US South Dakota Butte 46019 0 0 0 0 44.90608745 -103.5079318 2020-06-04 02:33:14 Butte, South Dakota, US
3863957 3863957 2020-06-03 US South Dakota Charles Mix 46023 18 0 0 18 43.20660134 -98.58856175 2020-06-04 02:33:14 Charles Mix, South Dakota, US
3864034 3864034 2020-06-03 US South Dakota Clark 46025 4 0 0 4 44.85834507 -97.72925109 2020-06-04 02:33:14 Clark, South Dakota, US
3864057 3864057 2020-06-03 US South Dakota Clay 46027 15 0 0 15 42.91296147 -96.97656917 2020-06-04 02:33:14 Clay, South Dakota, US
3864090 3864090 2020-06-03 US South Dakota Codington 46029 38 0 0 38 44.97788119 -97.18827677 2020-06-04 02:33:14 Codington, South Dakota, US
3864139 3864139 2020-06-03 US South Dakota Corson 46031 4 0 0 4 45.70889983 -101.1970473 2020-06-04 02:33:14 Corson, South Dakota, US
3864224 3864224 2020-06-03 US South Dakota Davison 46035 20 0 0 20 43.67490933 -98.14458906 2020-06-04 02:33:14 Davison, South Dakota, US
3864229 3864229 2020-06-03 US South Dakota Day 46037 13 0 0 13 45.367281 -97.60737498 2020-06-04 02:33:14 Day, South Dakota, US
3864265 3864265 2020-06-03 US South Dakota Deuel 46039 1 0 0 1 44.75994309 -96.66943645 2020-06-04 02:33:14 Deuel, South Dakota, US
3864267 3864267 2020-06-03 US South Dakota Dewey 46041 1 0 0 1 45.15639647 -100.8709139 2020-06-04 02:33:14 Dewey, South Dakota, US
3864302 3864302 2020-06-03 US South Dakota Douglas 46043 3 0 0 3 43.38520741 -98.36978007 2020-06-04 02:33:14 Douglas, South Dakota, US
3864335 3864335 2020-06-03 US South Dakota Edmunds 46045 3 0 0 3 45.41846445 -99.21545423 2020-06-04 02:33:14 Edmunds, South Dakota, US
3864382 3864382 2020-06-03 US South Dakota Fall River 46047 6 0 0 6 43.23929297 -103.5275691 2020-06-04 02:33:14 Fall River, South Dakota, US
3864388 3864388 2020-06-03 US South Dakota Faulk 46049 1 0 0 1 45.07082625 -99.14535601 2020-06-04 02:33:14 Faulk, South Dakota, US
3864561 3864561 2020-06-03 US South Dakota Grant 46051 13 0 0 13 45.1723937 -96.77002276 2020-06-04 02:33:14 Grant, South Dakota, US
3864601 3864601 2020-06-03 US South Dakota Gregory 46053 1 0 0 1 43.19419064 -99.18883902 2020-06-04 02:33:14 Gregory, South Dakota, US
3864635 3864635 2020-06-03 US South Dakota Hamlin 46057 4 0 0 4 44.67385954 -97.18829593 2020-06-04 02:33:14 Hamlin, South Dakota, US
3864651 3864651 2020-06-03 US South Dakota Hand 46059 3 0 0 3 44.54708407 -99.00386459 2020-06-04 02:33:14 Hand, South Dakota, US
3864654 3864654 2020-06-03 US South Dakota Hanson 46061 1 0 0 1 43.6746384 -97.78715148 2020-06-04 02:33:14 Hanson, South Dakota, US
3864776 3864776 2020-06-03 US South Dakota Hughes 46065 19 0 0 19 44.39091534 -99.99661148 2020-06-04 02:33:14 Hughes, South Dakota, US
3864788 3864788 2020-06-03 US South Dakota Hutchinson 46067 6 0 0 6 43.33449012 -97.75536441 2020-06-04 02:33:14 Hutchinson, South Dakota, US
3864791 3864791 2020-06-03 US South Dakota Hyde 46069 1 0 0 1 44.54747703 -99.48572582 2020-06-04 02:33:14 Hyde, South Dakota, US
3864839 3864839 2020-06-03 US South Dakota Jackson 46071 4 0 0 4 43.69318385 -101.6255063 2020-06-04 02:33:14 Jackson, South Dakota, US
3864885 3864885 2020-06-03 US South Dakota Jerauld 46073 38 1 0 37 44.06637798 -98.62965972 2020-06-04 02:33:14 Jerauld, South Dakota, US
3864957 3864957 2020-06-03 US South Dakota Kingsbury 46077 3 0 0 3 44.36956169 -97.4913945 2020-06-04 02:33:14 Kingsbury, South Dakota, US
3865011 3865011 2020-06-03 US South Dakota Lake 46079 10 0 0 10 44.02193107 -97.12926365 2020-06-04 02:33:14 Lake, South Dakota, US
3865053 3865053 2020-06-03 US South Dakota Lawrence 46081 11 0 0 11 44.35919441 -103.7929428 2020-06-04 02:33:14 Lawrence, South Dakota, US
3865118 3865118 2020-06-03 US South Dakota Lincoln 46083 240 0 0 240 43.27841182 -96.7203905 2020-06-04 02:33:14 Lincoln, South Dakota, US
3865169 3865169 2020-06-03 US South Dakota Lyman 46085 15 0 0 15 43.89522709 -99.85201878 2020-06-04 02:33:14 Lyman, South Dakota, US
3865253 3865253 2020-06-03 US South Dakota Marshall 46091 4 0 0 4 45.75870838 -97.59855639 2020-06-04 02:33:14 Marshall, South Dakota, US
3865278 3865278 2020-06-03 US South Dakota McCook 46087 6 1 0 5 43.6742571 -97.36863144 2020-06-04 02:33:14 McCook, South Dakota, US
3865306 3865306 2020-06-03 US South Dakota McPherson 46089 1 0 0 1 45.76626028 -99.22118798 2020-06-04 02:33:14 McPherson, South Dakota, US
3865309 3865309 2020-06-03 US South Dakota Meade 46093 22 0 0 22 44.56676791 -102.7162741 2020-06-04 02:33:14 Meade, South Dakota, US
3865357 3865357 2020-06-03 US South Dakota Miner 46097 2 0 0 2 44.02197882 -97.60992207 2020-06-04 02:33:14 Miner, South Dakota, US
3865363 3865363 2020-06-03 US South Dakota Minnehaha 46099 3377 49 0 3328 43.67441641 -96.7910885 2020-06-04 02:33:14 Minnehaha, South Dakota, US
3865422 3865422 2020-06-03 US South Dakota Moody 46101 19 0 0 19 44.02266214 -96.67081159 2020-06-04 02:33:14 Moody, South Dakota, US
3865539 3865539 2020-06-03 US South Dakota Oglala Lakota 46102 32 0 0 32 43.33749164 -102.5555498 2020-06-04 02:33:14 Oglala Lakota, South Dakota, US
3865646 3865646 2020-06-03 US South Dakota Pennington 46103 257 4 0 253 44.0025835 -102.8240777 2020-06-04 02:33:14 Pennington, South Dakota, US
3865850 3865850 2020-06-03 US South Dakota Roberts 46109 36 0 0 36 45.62975048 -96.94672673 2020-06-04 02:33:14 Roberts, South Dakota, US
3865922 3865922 2020-06-03 US South Dakota Sanborn 46111 13 0 0 13 44.02351092 -98.0909816 2020-06-04 02:33:14 Sanborn, South Dakota, US
3866038 3866038 2020-06-03 US South Dakota Spink 46115 5 0 0 5 44.93837606 -98.34626602 2020-06-04 02:33:14 Spink, South Dakota, US
3866070 3866070 2020-06-03 US South Dakota Stanley 46117 10 0 0 10 44.41381872 -100.7349153 2020-06-04 02:33:14 Stanley, South Dakota, US
3866115 3866115 2020-06-03 US South Dakota Sully 46119 1 0 0 1 44.71571812 -100.1278092 2020-06-04 02:33:14 Sully, South Dakota, US
3866191 3866191 2020-06-03 US South Dakota Todd 46121 28 1 0 27 43.19338568 -100.7195503 2020-06-04 02:33:14 Todd, South Dakota, US
3866212 3866212 2020-06-03 US South Dakota Tripp 46123 6 0 0 6 43.34459388 -99.8854891 2020-06-04 02:33:14 Tripp, South Dakota, US
3866222 3866222 2020-06-03 US South Dakota Turner 46125 25 0 0 25 43.3109081 -97.14865776 2020-06-04 02:33:14 Turner, South Dakota, US
3866274 3866274 2020-06-03 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-06-04 02:33:14 Unassigned, South Dakota, US
3866301 3866301 2020-06-03 US South Dakota Union 46127 92 0 0 92 42.83112163 -96.6557828 2020-06-04 02:33:14 Union, South Dakota, US
3866354 3866354 2020-06-03 US South Dakota Walworth 46129 5 0 0 5 45.43019636 -100.0307514 2020-06-04 02:33:14 Walworth, South Dakota, US
3866541 3866541 2020-06-03 US South Dakota Yankton 46135 51 0 0 51 43.00924485 -97.39467635 2020-06-04 02:33:14 Yankton, South Dakota, US
3866562 3866562 2020-06-03 US South Dakota Ziebach 46137 1 0 0 1 44.97881876 -101.6654622 2020-06-04 02:33:14 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]);