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 2022-01-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
3303055 3303055 2022-01-30 US South Dakota Aurora 46003 729 17 0   43.71757685 -98.56050467 2022-01-31 04:21:09 Aurora, South Dakota, US
3303056 3303056 2022-01-30 US South Dakota Beadle 46005 4384 51 0   44.41464384 -98.27858469 2022-01-31 04:21:09 Beadle, South Dakota, US
3303057 3303057 2022-01-30 US South Dakota Bennett 46007 710 9 0   43.19486375 -101.6665572 2022-01-31 04:21:09 Bennett, South Dakota, US
3303058 3303058 2022-01-30 US South Dakota Bon Homme 46009 2240 36 0   42.98914167 -97.88592746 2022-01-31 04:21:09 Bon Homme, South Dakota, US
3303059 3303059 2022-01-30 US South Dakota Brookings 46011 7805 43 0   44.36974375 -96.79079945 2022-01-31 04:21:09 Brookings, South Dakota, US
3303060 3303060 2022-01-30 US South Dakota Brown 46013 9641 113 0   45.58994323 -98.35165355 2022-01-31 04:21:09 Brown, South Dakota, US
3303061 3303061 2022-01-30 US South Dakota Brule 46015 1348 18 0   43.71756379 -99.08118954 2022-01-31 04:21:09 Brule, South Dakota, US
3303062 3303062 2022-01-30 US South Dakota Buffalo 46017 595 17 0   44.07657829 -99.20814467 2022-01-31 04:21:09 Buffalo, South Dakota, US
3303063 3303063 2022-01-30 US South Dakota Butte 46019 2537 43 0   44.90608745 -103.5079318 2022-01-31 04:21:09 Butte, South Dakota, US
3303064 3303064 2022-01-30 US South Dakota Campbell 46021 250 7 0   45.77074915 -100.0510181 2022-01-31 04:21:09 Campbell, South Dakota, US
3303065 3303065 2022-01-30 US South Dakota Charles Mix 46023 2763 33 0   43.20660134 -98.58856175 2022-01-31 04:21:09 Charles Mix, South Dakota, US
3303066 3303066 2022-01-30 US South Dakota Clark 46025 749 6 0   44.85834507 -97.72925109 2022-01-31 04:21:09 Clark, South Dakota, US
3303067 3303067 2022-01-30 US South Dakota Clay 46027 3342 19 0   42.91296147 -96.97656917 2022-01-31 04:21:09 Clay, South Dakota, US
3303068 3303068 2022-01-30 US South Dakota Codington 46029 7865 94 0   44.97788119 -97.18827677 2022-01-31 04:21:09 Codington, South Dakota, US
3303069 3303069 2022-01-30 US South Dakota Corson 46031 968 15 0   45.70889983 -101.1970473 2022-01-31 04:21:09 Corson, South Dakota, US
3303070 3303070 2022-01-30 US South Dakota Custer 46033 1894 21 0   43.67741105 -103.45345209999999 2022-01-31 04:21:09 Custer, South Dakota, US
3303071 3303071 2022-01-30 US South Dakota Davison 46035 5616 77 0   43.67490933 -98.14458906 2022-01-31 04:21:09 Davison, South Dakota, US
3303072 3303072 2022-01-30 US South Dakota Day 46037 1209 32 0   45.367281 -97.60737498 2022-01-31 04:21:09 Day, South Dakota, US
3303073 3303073 2022-01-30 US South Dakota Deuel 46039 990 12 0   44.75994309 -96.66943645 2022-01-31 04:21:09 Deuel, South Dakota, US
3303074 3303074 2022-01-30 US South Dakota Dewey 46041 2381 37 0   45.15639647 -100.8709139 2022-01-31 04:21:09 Dewey, South Dakota, US
3303075 3303075 2022-01-30 US South Dakota Douglas 46043 663 15 0   43.38520741 -98.36978007 2022-01-31 04:21:09 Douglas, South Dakota, US
3303076 3303076 2022-01-30 US South Dakota Edmunds 46045 884 16 0   45.41846445 -99.21545423 2022-01-31 04:21:09 Edmunds, South Dakota, US
3303077 3303077 2022-01-30 US South Dakota Fall River 46047 1660 36 0   43.23929297 -103.5275691 2022-01-31 04:21:09 Fall River, South Dakota, US
3303078 3303078 2022-01-30 US South Dakota Faulk 46049 515 16 0   45.07082625 -99.14535601 2022-01-31 04:21:09 Faulk, South Dakota, US
3303079 3303079 2022-01-30 US South Dakota Grant 46051 1955 47 0   45.1723937 -96.77002276 2022-01-31 04:21:09 Grant, South Dakota, US
3303080 3303080 2022-01-30 US South Dakota Gregory 46053 1020 33 0   43.19419064 -99.18883902 2022-01-31 04:21:09 Gregory, South Dakota, US
3303081 3303081 2022-01-30 US South Dakota Haakon 46055 434 11 0   44.29299053 -101.539099 2022-01-31 04:21:09 Haakon, South Dakota, US
3303082 3303082 2022-01-30 US South Dakota Hamlin 46057 1431 40 0   44.67385954 -97.18829593 2022-01-31 04:21:09 Hamlin, South Dakota, US
3303083 3303083 2022-01-30 US South Dakota Hand 46059 529 8 0   44.54708407 -99.00386459 2022-01-31 04:21:09 Hand, South Dakota, US
3303084 3303084 2022-01-30 US South Dakota Hanson 46061 632 6 0   43.6746384 -97.78715148 2022-01-31 04:21:09 Hanson, South Dakota, US
3303085 3303085 2022-01-30 US South Dakota Harding 46063 197 3 0   45.58015551 -103.4958629 2022-01-31 04:21:09 Harding, South Dakota, US
3303086 3303086 2022-01-30 US South Dakota Hughes 46065 4105 57 0   44.39091534 -99.99661148 2022-01-31 04:21:09 Hughes, South Dakota, US
3303087 3303087 2022-01-30 US South Dakota Hutchinson 46067 1672 33 0   43.33449012 -97.75536441 2022-01-31 04:21:09 Hutchinson, South Dakota, US
3303088 3303088 2022-01-30 US South Dakota Hyde 46069 280 5 0   44.54747703 -99.48572582 2022-01-31 04:21:09 Hyde, South Dakota, US
3303089 3303089 2022-01-30 US South Dakota Jackson 46071 587 20 0   43.69318385 -101.6255063 2022-01-31 04:21:09 Jackson, South Dakota, US
3303090 3303090 2022-01-30 US South Dakota Jerauld 46073 387 19 0   44.06637798 -98.62965972 2022-01-31 04:21:09 Jerauld, South Dakota, US
3303091 3303091 2022-01-30 US South Dakota Jones 46075 170 1 0   43.96278565 -100.6940008 2022-01-31 04:21:09 Jones, South Dakota, US
3303092 3303092 2022-01-30 US South Dakota Kingsbury 46077 1252 20 0   44.36956169 -97.4913945 2022-01-31 04:21:09 Kingsbury, South Dakota, US
3303093 3303093 2022-01-30 US South Dakota Lake 46079 2258 26 0   44.02193107 -97.12926365 2022-01-31 04:21:09 Lake, South Dakota, US
3303094 3303094 2022-01-30 US South Dakota Lawrence 46081 6150 79 0   44.35919441 -103.79294279999999 2022-01-31 04:21:09 Lawrence, South Dakota, US
3303095 3303095 2022-01-30 US South Dakota Lincoln 46083 15086 89 0   43.27841182 -96.72039050000001 2022-01-31 04:21:09 Lincoln, South Dakota, US
3303096 3303096 2022-01-30 US South Dakota Lyman 46085 1161 12 0   43.89522709 -99.85201878 2022-01-31 04:21:09 Lyman, South Dakota, US
3303097 3303097 2022-01-30 US South Dakota Marshall 46091 710 9 0   45.75870838 -97.59855639 2022-01-31 04:21:09 Marshall, South Dakota, US
3303098 3303098 2022-01-30 US South Dakota McCook 46087 1296 30 0   43.6742571 -97.36863144 2022-01-31 04:21:09 McCook, South Dakota, US
3303099 3303099 2022-01-30 US South Dakota McPherson 46089 408 9 0   45.76626028 -99.22118798 2022-01-31 04:21:09 McPherson, South Dakota, US
3303100 3303100 2022-01-30 US South Dakota Meade 46093 6562 57 0   44.56676791 -102.71627409999999 2022-01-31 04:21:09 Meade, South Dakota, US
3303101 3303101 2022-01-30 US South Dakota Mellette 46095 487 5 0   43.58078848 -100.7563186 2022-01-31 04:21:09 Mellette, South Dakota, US
3303102 3303102 2022-01-30 US South Dakota Miner 46097 446 12 0   44.02197882 -97.60992207 2022-01-31 04:21:09 Miner, South Dakota, US
3303103 3303103 2022-01-30 US South Dakota Minnehaha 46099 55414 466 0   43.67441641 -96.7910885 2022-01-31 04:21:09 Minnehaha, South Dakota, US
3303104 3303104 2022-01-30 US South Dakota Moody 46101 1269 26 0   44.02266214 -96.67081159 2022-01-31 04:21:09 Moody, South Dakota, US
3303105 3303105 2022-01-30 US South Dakota Oglala Lakota 46102 3538 56 0   43.33749164 -102.55554980000001 2022-01-31 04:21:09 Oglala Lakota, South Dakota, US
3303106 3303106 2022-01-30 US South Dakota Pennington 46103 30904 307 0   44.0025835 -102.8240777 2022-01-31 04:21:09 Pennington, South Dakota, US
3303107 3303107 2022-01-30 US South Dakota Perkins 46105 645 16 0   45.49049506 -102.47555859999999 2022-01-31 04:21:09 Perkins, South Dakota, US
3303108 3303108 2022-01-30 US South Dakota Potter 46107 657 6 0   45.06583079 -99.95498503 2022-01-31 04:21:09 Potter, South Dakota, US
3303109 3303109 2022-01-30 US South Dakota Roberts 46109 2224 46 0   45.62975048 -96.94672673 2022-01-31 04:21:09 Roberts, South Dakota, US
3303110 3303110 2022-01-30 US South Dakota Sanborn 46111 546 5 0   44.02351092 -98.09098159999999 2022-01-31 04:21:09 Sanborn, South Dakota, US
3303111 3303111 2022-01-30 US South Dakota Spink 46115 1332 32 0   44.93837606 -98.34626602 2022-01-31 04:21:09 Spink, South Dakota, US
3303112 3303112 2022-01-30 US South Dakota Stanley 46117 611 6 0   44.41381872 -100.7349153 2022-01-31 04:21:09 Stanley, South Dakota, US
3303113 3303113 2022-01-30 US South Dakota Sully 46119 236 3 0   44.71571812 -100.1278092 2022-01-31 04:21:09 Sully, South Dakota, US
3303114 3303114 2022-01-30 US South Dakota Todd 46121 2674 43 0   43.19338568 -100.71955030000001 2022-01-31 04:21:09 Todd, South Dakota, US
3303115 3303115 2022-01-30 US South Dakota Tripp 46123 1299 21 0   43.34459388 -99.8854891 2022-01-31 04:21:09 Tripp, South Dakota, US
3303116 3303116 2022-01-30 US South Dakota Turner 46125 1901 62 0   43.3109081 -97.14865776 2022-01-31 04:21:09 Turner, South Dakota, US
3303117 3303117 2022-01-30 US South Dakota Unassigned 90046 0 0 0   45.77074915 -99.99661148 2022-01-31 04:21:09 Unassigned, South Dakota, US
3303118 3303118 2022-01-30 US South Dakota Union 46127 3848 47 0   42.83112163 -96.6557828 2022-01-31 04:21:09 Union, South Dakota, US
3303119 3303119 2022-01-30 US South Dakota Walworth 46129 1229 20 0   45.43019636 -100.03075140000001 2022-01-31 04:21:09 Walworth, South Dakota, US
3303120 3303120 2022-01-30 US South Dakota Yankton 46135 5587 50 0   43.00924485 -97.39467635 2022-01-31 04:21:09 Yankton, South Dakota, US
3303121 3303121 2022-01-30 US South Dakota Ziebach 46137 516 11 0   44.97881876 -101.6654622 2022-01-31 04:21:09 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]);