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-09-21 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
1373345 1373345 2022-09-21 US South Dakota Aurora 46003 856 17 0   43.71757685 -98.56050467 2022-09-22 04:22:56 Aurora, South Dakota, US
1373346 1373346 2022-09-21 US South Dakota Beadle 46005 5148 63 0   44.41464384 -98.27858469 2022-09-22 04:22:56 Beadle, South Dakota, US
1373347 1373347 2022-09-21 US South Dakota Bennett 46007 855 15 0   43.19486375 -101.6665572 2022-09-22 04:22:56 Bennett, South Dakota, US
1373348 1373348 2022-09-21 US South Dakota Bon Homme 46009 2401 41 0   42.98914167 -97.88592746 2022-09-22 04:22:56 Bon Homme, South Dakota, US
1373349 1373349 2022-09-21 US South Dakota Brookings 46011 8889 59 0   44.36974375 -96.79079945 2022-09-22 04:22:56 Brookings, South Dakota, US
1373350 1373350 2022-09-21 US South Dakota Brown 46013 11177 124 0   45.58994323 -98.35165355 2022-09-22 04:22:56 Brown, South Dakota, US
1373351 1373351 2022-09-21 US South Dakota Brule 46015 1582 23 0   43.71756379 -99.08118954 2022-09-22 04:22:56 Brule, South Dakota, US
1373352 1373352 2022-09-21 US South Dakota Buffalo 46017 655 18 0   44.07657829 -99.20814467 2022-09-22 04:22:56 Buffalo, South Dakota, US
1373353 1373353 2022-09-21 US South Dakota Butte 46019 3054 47 0   44.90608745 -103.5079318 2022-09-22 04:22:56 Butte, South Dakota, US
1373354 1373354 2022-09-21 US South Dakota Campbell 46021 295 7 0   45.77074915 -100.0510181 2022-09-22 04:22:56 Campbell, South Dakota, US
1373355 1373355 2022-09-21 US South Dakota Charles Mix 46023 3260 36 0   43.20660134 -98.58856175 2022-09-22 04:22:56 Charles Mix, South Dakota, US
1373356 1373356 2022-09-21 US South Dakota Clark 46025 879 11 0   44.85834507 -97.72925109 2022-09-22 04:22:56 Clark, South Dakota, US
1373357 1373357 2022-09-21 US South Dakota Clay 46027 3730 24 0   42.91296147 -96.97656917 2022-09-22 04:22:56 Clay, South Dakota, US
1373358 1373358 2022-09-21 US South Dakota Codington 46029 9589 103 0   44.97788119 -97.18827677 2022-09-22 04:22:56 Codington, South Dakota, US
1373359 1373359 2022-09-21 US South Dakota Corson 46031 1132 18 0   45.70889983 -101.1970473 2022-09-22 04:22:56 Corson, South Dakota, US
1373360 1373360 2022-09-21 US South Dakota Custer 46033 2351 28 0   43.67741105 -103.4534521 2022-09-22 04:22:56 Custer, South Dakota, US
1373361 1373361 2022-09-21 US South Dakota Davison 46035 6466 82 0   43.67490933 -98.14458906 2022-09-22 04:22:56 Davison, South Dakota, US
1373362 1373362 2022-09-21 US South Dakota Day 46037 1391 36 0   45.367281 -97.60737498 2022-09-22 04:22:56 Day, South Dakota, US
1373363 1373363 2022-09-21 US South Dakota Deuel 46039 1117 12 0   44.75994309 -96.66943645 2022-09-22 04:22:56 Deuel, South Dakota, US
1373364 1373364 2022-09-21 US South Dakota Dewey 46041 3256 44 0   45.15639647 -100.8709139 2022-09-22 04:22:56 Dewey, South Dakota, US
1373365 1373365 2022-09-21 US South Dakota Douglas 46043 758 16 0   43.38520741 -98.36978007 2022-09-22 04:22:56 Douglas, South Dakota, US
1373366 1373366 2022-09-21 US South Dakota Edmunds 46045 1003 16 0   45.41846445 -99.21545423 2022-09-22 04:22:56 Edmunds, South Dakota, US
1373367 1373367 2022-09-21 US South Dakota Fall River 46047 2191 40 0   43.23929297 -103.5275691 2022-09-22 04:22:56 Fall River, South Dakota, US
1373368 1373368 2022-09-21 US South Dakota Faulk 46049 620 17 0   45.07082625 -99.14535601 2022-09-22 04:22:56 Faulk, South Dakota, US
1373369 1373369 2022-09-21 US South Dakota Grant 46051 2235 51 0   45.1723937 -96.77002276 2022-09-22 04:22:56 Grant, South Dakota, US
1373370 1373370 2022-09-21 US South Dakota Gregory 46053 1145 34 0   43.19419064 -99.18883902 2022-09-22 04:22:56 Gregory, South Dakota, US
1373371 1373371 2022-09-21 US South Dakota Haakon 46055 498 12 0   44.29299053 -101.539099 2022-09-22 04:22:56 Haakon, South Dakota, US
1373372 1373372 2022-09-21 US South Dakota Hamlin 46057 1684 41 0   44.67385954 -97.18829593 2022-09-22 04:22:56 Hamlin, South Dakota, US
1373373 1373373 2022-09-21 US South Dakota Hand 46059 622 13 0   44.54708407 -99.00386459 2022-09-22 04:22:56 Hand, South Dakota, US
1373374 1373374 2022-09-21 US South Dakota Hanson 46061 696 6 0   43.6746384 -97.78715148 2022-09-22 04:22:56 Hanson, South Dakota, US
1373375 1373375 2022-09-21 US South Dakota Harding 46063 212 3 0   45.58015551 -103.4958629 2022-09-22 04:22:56 Harding, South Dakota, US
1373376 1373376 2022-09-21 US South Dakota Hughes 46065 4736 62 0   44.39091534 -99.99661148 2022-09-22 04:22:56 Hughes, South Dakota, US
1373377 1373377 2022-09-21 US South Dakota Hutchinson 46067 1893 39 0   43.33449012 -97.75536441 2022-09-22 04:22:56 Hutchinson, South Dakota, US
1373378 1373378 2022-09-21 US South Dakota Hyde 46069 328 8 0   44.54747703 -99.48572582 2022-09-22 04:22:56 Hyde, South Dakota, US
1373379 1373379 2022-09-21 US South Dakota Jackson 46071 694 21 0   43.69318385 -101.6255063 2022-09-22 04:22:56 Jackson, South Dakota, US
1373380 1373380 2022-09-21 US South Dakota Jerauld 46073 446 20 0   44.06637798 -98.62965972 2022-09-22 04:22:56 Jerauld, South Dakota, US
1373381 1373381 2022-09-21 US South Dakota Jones 46075 187 2 0   43.96278565 -100.6940008 2022-09-22 04:22:56 Jones, South Dakota, US
1373382 1373382 2022-09-21 US South Dakota Kingsbury 46077 1433 23 0   44.36956169 -97.4913945 2022-09-22 04:22:56 Kingsbury, South Dakota, US
1373383 1373383 2022-09-21 US South Dakota Lake 46079 2496 28 0   44.02193107 -97.12926365 2022-09-22 04:22:56 Lake, South Dakota, US
1373384 1373384 2022-09-21 US South Dakota Lawrence 46081 7372 88 0   44.35919441 -103.7929428 2022-09-22 04:22:56 Lawrence, South Dakota, US
1373385 1373385 2022-09-21 US South Dakota Lincoln 46083 16570 105 0   43.27841182 -96.7203905 2022-09-22 04:22:56 Lincoln, South Dakota, US
1373386 1373386 2022-09-21 US South Dakota Lyman 46085 1317 13 0   43.89522709 -99.85201878 2022-09-22 04:22:56 Lyman, South Dakota, US
1373387 1373387 2022-09-21 US South Dakota Marshall 46091 868 14 0   45.75870838 -97.59855639 2022-09-22 04:22:56 Marshall, South Dakota, US
1373388 1373388 2022-09-21 US South Dakota McCook 46087 1444 32 0   43.6742571 -97.36863144 2022-09-22 04:22:56 McCook, South Dakota, US
1373389 1373389 2022-09-21 US South Dakota McPherson 46089 460 10 0   45.76626028 -99.22118798 2022-09-22 04:22:56 McPherson, South Dakota, US
1373390 1373390 2022-09-21 US South Dakota Meade 46093 7919 68 0   44.56676791 -102.7162741 2022-09-22 04:22:56 Meade, South Dakota, US
1373391 1373391 2022-09-21 US South Dakota Mellette 46095 601 8 0   43.58078848 -100.7563186 2022-09-22 04:22:56 Mellette, South Dakota, US
1373392 1373392 2022-09-21 US South Dakota Miner 46097 499 15 0   44.02197882 -97.60992207 2022-09-22 04:22:56 Miner, South Dakota, US
1373393 1373393 2022-09-21 US South Dakota Minnehaha 46099 61485 534 0   43.67441641 -96.7910885 2022-09-22 04:22:56 Minnehaha, South Dakota, US
1373394 1373394 2022-09-21 US South Dakota Moody 46101 1624 28 0   44.02266214 -96.67081159 2022-09-22 04:22:56 Moody, South Dakota, US
1373395 1373395 2022-09-21 US South Dakota Oglala Lakota 46102 4561 61 0   43.33749164 -102.5555498 2022-09-22 04:22:56 Oglala Lakota, South Dakota, US
1373396 1373396 2022-09-21 US South Dakota Pennington 46103 36782 357 0   44.0025835 -102.8240777 2022-09-22 04:22:56 Pennington, South Dakota, US
1373397 1373397 2022-09-21 US South Dakota Perkins 46105 757 19 0   45.49049506 -102.4755586 2022-09-22 04:22:56 Perkins, South Dakota, US
1373398 1373398 2022-09-21 US South Dakota Potter 46107 746 7 0   45.06583079 -99.95498503 2022-09-22 04:22:56 Potter, South Dakota, US
1373399 1373399 2022-09-21 US South Dakota Roberts 46109 2653 53 0   45.62975048 -96.94672673 2022-09-22 04:22:56 Roberts, South Dakota, US
1373400 1373400 2022-09-21 US South Dakota Sanborn 46111 633 8 0   44.02351092 -98.0909816 2022-09-22 04:22:56 Sanborn, South Dakota, US
1373401 1373401 2022-09-21 US South Dakota Spink 46115 1562 36 0   44.93837606 -98.34626602 2022-09-22 04:22:56 Spink, South Dakota, US
1373402 1373402 2022-09-21 US South Dakota Stanley 46117 694 8 0   44.41381872 -100.7349153 2022-09-22 04:22:56 Stanley, South Dakota, US
1373403 1373403 2022-09-21 US South Dakota Sully 46119 257 3 0   44.71571812 -100.1278092 2022-09-22 04:22:56 Sully, South Dakota, US
1373404 1373404 2022-09-21 US South Dakota Todd 46121 3391 52 0   43.19338568 -100.7195503 2022-09-22 04:22:56 Todd, South Dakota, US
1373405 1373405 2022-09-21 US South Dakota Tripp 46123 1553 26 0   43.34459388 -99.8854891 2022-09-22 04:22:56 Tripp, South Dakota, US
1373406 1373406 2022-09-21 US South Dakota Turner 46125 2111 63 0   43.3109081 -97.14865776 2022-09-22 04:22:56 Turner, South Dakota, US
1373407 1373407 2022-09-21 US South Dakota Unassigned 90046 0 0 0   45.77074915 -99.99661148 2022-09-22 04:22:56 Unassigned, South Dakota, US
1373408 1373408 2022-09-21 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-22 04:22:56 Union, South Dakota, US
1373409 1373409 2022-09-21 US South Dakota Walworth 46129 1434 26 0   45.43019636 -100.0307514 2022-09-22 04:22:56 Walworth, South Dakota, US
1373410 1373410 2022-09-21 US South Dakota Yankton 46135 6492 60 0   43.00924485 -97.39467635 2022-09-22 04:22:56 Yankton, South Dakota, US
1373411 1373411 2022-09-21 US South Dakota Ziebach 46137 692 11 0   44.97881876 -101.6654622 2022-09-22 04:22:56 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]);