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

65 rows where "day" is on date 2020-07-12 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 · 65 ✖

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
3734361 3734361 2020-07-12 US South Dakota Aurora 46003 34 0 0 34 43.71757685 -98.56050467 2020-07-13 04:43:04 Aurora, South Dakota, US
3734407 3734407 2020-07-12 US South Dakota Beadle 46005 553 8 0 545 44.41464384 -98.27858469 2020-07-13 04:43:04 Beadle, South Dakota, US
3734429 3734429 2020-07-12 US South Dakota Bennett 46007 4 0 0 4 43.19486375 -101.6665572 2020-07-13 04:43:04 Bennett, South Dakota, US
3734479 3734479 2020-07-12 US South Dakota Bon Homme 46009 14 0 0 14 42.98914167 -97.88592746 2020-07-13 04:43:04 Bon Homme, South Dakota, US
3734527 3734527 2020-07-12 US South Dakota Brookings 46011 95 0 0 95 44.36974375 -96.79079945 2020-07-13 04:43:04 Brookings, South Dakota, US
3734539 3734539 2020-07-12 US South Dakota Brown 46013 358 2 0 356 45.58994323 -98.35165355 2020-07-13 04:43:04 Brown, South Dakota, US
3734542 3734542 2020-07-12 US South Dakota Brule 46015 34 0 0 34 43.71756379 -99.08118954 2020-07-13 04:43:04 Brule, South Dakota, US
3734555 3734555 2020-07-12 US South Dakota Buffalo 46017 86 3 0 83 44.07657829 -99.20814467 2020-07-13 04:43:04 Buffalo, South Dakota, US
3734580 3734580 2020-07-12 US South Dakota Butte 46019 3 0 0 3 44.90608745 -103.5079318 2020-07-13 04:43:04 Butte, South Dakota, US
3734621 3734621 2020-07-12 US South Dakota Campbell 46021 1 0 0 1 45.77074915 -100.0510181 2020-07-13 04:43:04 Campbell, South Dakota, US
3734696 3734696 2020-07-12 US South Dakota Charles Mix 46023 96 0 0 96 43.20660134 -98.58856175 2020-07-13 04:43:04 Charles Mix, South Dakota, US
3734773 3734773 2020-07-12 US South Dakota Clark 46025 15 0 0 15 44.85834507 -97.72925109 2020-07-13 04:43:04 Clark, South Dakota, US
3734796 3734796 2020-07-12 US South Dakota Clay 46027 93 0 0 93 42.91296147 -96.97656917 2020-07-13 04:43:04 Clay, South Dakota, US
3734830 3734830 2020-07-12 US South Dakota Codington 46029 92 0 0 92 44.97788119 -97.18827677 2020-07-13 04:43:04 Codington, South Dakota, US
3734880 3734880 2020-07-12 US South Dakota Corson 46031 20 0 0 20 45.70889983 -101.1970473 2020-07-13 04:43:04 Corson, South Dakota, US
3734943 3734943 2020-07-12 US South Dakota Custer 46033 10 0 0 10 43.67741105 -103.45345209999999 2020-07-13 04:43:04 Custer, South Dakota, US
3734970 3734970 2020-07-12 US South Dakota Davison 46035 55 0 0 55 43.67490933 -98.14458906 2020-07-13 04:43:04 Davison, South Dakota, US
3734976 3734976 2020-07-12 US South Dakota Day 46037 19 0 0 19 45.367281 -97.60737498 2020-07-13 04:43:04 Day, South Dakota, US
3735014 3735014 2020-07-12 US South Dakota Deuel 46039 5 0 0 5 44.75994309 -96.66943645 2020-07-13 04:43:04 Deuel, South Dakota, US
3735016 3735016 2020-07-12 US South Dakota Dewey 46041 35 0 0 35 45.15639647 -100.8709139 2020-07-13 04:43:04 Dewey, South Dakota, US
3735052 3735052 2020-07-12 US South Dakota Douglas 46043 10 0 0 10 43.38520741 -98.36978007 2020-07-13 04:43:04 Douglas, South Dakota, US
3735086 3735086 2020-07-12 US South Dakota Edmunds 46045 8 0 0 8 45.41846445 -99.21545423 2020-07-13 04:43:04 Edmunds, South Dakota, US
3735136 3735136 2020-07-12 US South Dakota Fall River 46047 13 0 0 13 43.23929297 -103.5275691 2020-07-13 04:43:04 Fall River, South Dakota, US
3735143 3735143 2020-07-12 US South Dakota Faulk 46049 24 1 0 23 45.07082625 -99.14535601 2020-07-13 04:43:04 Faulk, South Dakota, US
3735321 3735321 2020-07-12 US South Dakota Grant 46051 17 0 0 17 45.1723937 -96.77002276 2020-07-13 04:43:04 Grant, South Dakota, US
3735362 3735362 2020-07-12 US South Dakota Gregory 46053 5 0 0 5 43.19419064 -99.18883902 2020-07-13 04:43:04 Gregory, South Dakota, US
3735378 3735378 2020-07-12 US South Dakota Haakon 46055 1 0 0 1 44.29299053 -101.539099 2020-07-13 04:43:04 Haakon, South Dakota, US
3735399 3735399 2020-07-12 US South Dakota Hamlin 46057 13 0 0 13 44.67385954 -97.18829593 2020-07-13 04:43:04 Hamlin, South Dakota, US
3735415 3735415 2020-07-12 US South Dakota Hand 46059 7 0 0 7 44.54708407 -99.00386459 2020-07-13 04:43:04 Hand, South Dakota, US
3735418 3735418 2020-07-12 US South Dakota Hanson 46061 13 0 0 13 43.6746384 -97.78715148 2020-07-13 04:43:04 Hanson, South Dakota, US
3735544 3735544 2020-07-12 US South Dakota Hughes 46065 70 2 0 68 44.39091534 -99.99661148 2020-07-13 04:43:04 Hughes, South Dakota, US
3735556 3735556 2020-07-12 US South Dakota Hutchinson 46067 17 0 0 17 43.33449012 -97.75536441 2020-07-13 04:43:04 Hutchinson, South Dakota, US
3735559 3735559 2020-07-12 US South Dakota Hyde 46069 3 0 0 3 44.54747703 -99.48572582 2020-07-13 04:43:04 Hyde, South Dakota, US
3735609 3735609 2020-07-12 US South Dakota Jackson 46071 7 1 0 6 43.69318385 -101.6255063 2020-07-13 04:43:04 Jackson, South Dakota, US
3735656 3735656 2020-07-12 US South Dakota Jerauld 46073 39 1 0 38 44.06637798 -98.62965972 2020-07-13 04:43:04 Jerauld, South Dakota, US
3735682 3735682 2020-07-12 US South Dakota Jones 46075 1 0 0 1 43.96278565 -100.6940008 2020-07-13 04:43:04 Jones, South Dakota, US
3735733 3735733 2020-07-12 US South Dakota Kingsbury 46077 8 0 0 8 44.36956169 -97.4913945 2020-07-13 04:43:04 Kingsbury, South Dakota, US
3735790 3735790 2020-07-12 US South Dakota Lake 46079 29 1 0 28 44.02193107 -97.12926365 2020-07-13 04:43:04 Lake, South Dakota, US
3735833 3735833 2020-07-12 US South Dakota Lawrence 46081 20 0 0 20 44.35919441 -103.79294279999999 2020-07-13 04:43:04 Lawrence, South Dakota, US
3735898 3735898 2020-07-12 US South Dakota Lincoln 46083 396 1 0 395 43.27841182 -96.72039050000001 2020-07-13 04:43:04 Lincoln, South Dakota, US
3735952 3735952 2020-07-12 US South Dakota Lyman 46085 82 1 0 81 43.89522709 -99.85201878 2020-07-13 04:43:04 Lyman, South Dakota, US
3736037 3736037 2020-07-12 US South Dakota Marshall 46091 5 0 0 5 45.75870838 -97.59855639 2020-07-13 04:43:04 Marshall, South Dakota, US
3736062 3736062 2020-07-12 US South Dakota McCook 46087 17 1 0 16 43.6742571 -97.36863144 2020-07-13 04:43:04 McCook, South Dakota, US
3736090 3736090 2020-07-12 US South Dakota McPherson 46089 6 0 0 6 45.76626028 -99.22118798 2020-07-13 04:43:04 McPherson, South Dakota, US
3736093 3736093 2020-07-12 US South Dakota Meade 46093 53 1 0 52 44.56676791 -102.71627409999999 2020-07-13 04:43:04 Meade, South Dakota, US
3736103 3736103 2020-07-12 US South Dakota Mellette 46095 9 0 0 9 43.58078848 -100.7563186 2020-07-13 04:43:04 Mellette, South Dakota, US
3736144 3736144 2020-07-12 US South Dakota Miner 46097 10 0 0 10 44.02197882 -97.60992207 2020-07-13 04:43:04 Miner, South Dakota, US
3736150 3736150 2020-07-12 US South Dakota Minnehaha 46099 3756 60 0 3696 43.67441641 -96.7910885 2020-07-13 04:43:04 Minnehaha, South Dakota, US
3736210 3736210 2020-07-12 US South Dakota Moody 46101 23 0 0 23 44.02266214 -96.67081159 2020-07-13 04:43:04 Moody, South Dakota, US
3736328 3736328 2020-07-12 US South Dakota Oglala Lakota 46102 112 0 0 112 43.33749164 -102.55554980000001 2020-07-13 04:43:04 Oglala Lakota, South Dakota, US
3736439 3736439 2020-07-12 US South Dakota Pennington 46103 635 21 0 614 44.0025835 -102.8240777 2020-07-13 04:43:04 Pennington, South Dakota, US
3736444 3736444 2020-07-12 US South Dakota Perkins 46105 1 0 0 1 45.49049506 -102.47555859999999 2020-07-13 04:43:04 Perkins, South Dakota, US
3736647 3736647 2020-07-12 US South Dakota Roberts 46109 57 0 0 57 45.62975048 -96.94672673 2020-07-13 04:43:04 Roberts, South Dakota, US
3736724 3736724 2020-07-12 US South Dakota Sanborn 46111 12 0 0 12 44.02351092 -98.09098159999999 2020-07-13 04:43:04 Sanborn, South Dakota, US
3736849 3736849 2020-07-12 US South Dakota Spink 46115 14 0 0 14 44.93837606 -98.34626602 2020-07-13 04:43:04 Spink, South Dakota, US
3736881 3736881 2020-07-12 US South Dakota Stanley 46117 14 0 0 14 44.41381872 -100.7349153 2020-07-13 04:43:04 Stanley, South Dakota, US
3736927 3736927 2020-07-12 US South Dakota Sully 46119 1 0 0 1 44.71571812 -100.1278092 2020-07-13 04:43:04 Sully, South Dakota, US
3737008 3737008 2020-07-12 US South Dakota Todd 46121 66 2 0 64 43.19338568 -100.71955030000001 2020-07-13 04:43:04 Todd, South Dakota, US
3737031 3737031 2020-07-12 US South Dakota Tripp 46123 19 0 0 19 43.34459388 -99.8854891 2020-07-13 04:43:04 Tripp, South Dakota, US
3737041 3737041 2020-07-12 US South Dakota Turner 46125 29 0 0 29 43.3109081 -97.14865776 2020-07-13 04:43:04 Turner, South Dakota, US
3737093 3737093 2020-07-12 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-07-13 04:43:04 Unassigned, South Dakota, US
3737120 3737120 2020-07-12 US South Dakota Union 46127 151 1 0 150 42.83112163 -96.6557828 2020-07-13 04:43:04 Union, South Dakota, US
3737176 3737176 2020-07-12 US South Dakota Walworth 46129 16 0 0 16 45.43019636 -100.03075140000001 2020-07-13 04:43:04 Walworth, South Dakota, US
3737367 3737367 2020-07-12 US South Dakota Yankton 46135 85 2 0 83 43.00924485 -97.39467635 2020-07-13 04:43:04 Yankton, South Dakota, US
3737388 3737388 2020-07-12 US South Dakota Ziebach 46137 3 0 0 3 44.97881876 -101.6654622 2020-07-13 04:43:04 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]);