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 2020-12-24 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
3694314 3694314 2020-12-24 US South Dakota Aurora 46003 406 8 0 398 43.71757685 -98.56050467 2020-12-25 05:22:48 Aurora, South Dakota, US
3694315 3694315 2020-12-24 US South Dakota Beadle 46005 2476 34 0 2442 44.41464384 -98.27858469 2020-12-25 05:22:48 Beadle, South Dakota, US
3694316 3694316 2020-12-24 US South Dakota Bennett 46007 351 8 0 343 43.19486375 -101.6665572 2020-12-25 05:22:48 Bennett, South Dakota, US
3694317 3694317 2020-12-24 US South Dakota Bon Homme 46009 1462 23 0 1439 42.98914167 -97.88592746 2020-12-25 05:22:48 Bon Homme, South Dakota, US
3694318 3694318 2020-12-24 US South Dakota Brookings 46011 2875 29 0 2846 44.36974375 -96.79079945 2020-12-25 05:22:48 Brookings, South Dakota, US
3694319 3694319 2020-12-24 US South Dakota Brown 46013 4287 54 0 4233 45.58994323 -98.35165355 2020-12-25 05:22:48 Brown, South Dakota, US
3694320 3694320 2020-12-24 US South Dakota Brule 46015 625 6 0 619 43.71756379 -99.08118954 2020-12-25 05:22:48 Brule, South Dakota, US
3694321 3694321 2020-12-24 US South Dakota Buffalo 46017 410 10 0 400 44.07657829 -99.20814467 2020-12-25 05:22:48 Buffalo, South Dakota, US
3694322 3694322 2020-12-24 US South Dakota Butte 46019 848 17 0 831 44.90608745 -103.5079318 2020-12-25 05:22:48 Butte, South Dakota, US
3694323 3694323 2020-12-24 US South Dakota Campbell 46021 111 4 0 107 45.77074915 -100.0510181 2020-12-25 05:22:48 Campbell, South Dakota, US
3694324 3694324 2020-12-24 US South Dakota Charles Mix 46023 1085 11 0 1074 43.20660134 -98.58856175 2020-12-25 05:22:48 Charles Mix, South Dakota, US
3694325 3694325 2020-12-24 US South Dakota Clark 46025 302 2 0 300 44.85834507 -97.72925109 2020-12-25 05:22:48 Clark, South Dakota, US
3694326 3694326 2020-12-24 US South Dakota Clay 46027 1592 11 0 1581 42.91296147 -96.97656917 2020-12-25 05:22:48 Clay, South Dakota, US
3694327 3694327 2020-12-24 US South Dakota Codington 46029 3345 68 0 3277 44.97788119 -97.18827677 2020-12-25 05:22:48 Codington, South Dakota, US
3694328 3694328 2020-12-24 US South Dakota Corson 46031 447 10 0 437 45.70889983 -101.1970473 2020-12-25 05:22:48 Corson, South Dakota, US
3694329 3694329 2020-12-24 US South Dakota Custer 46033 666 9 0 657 43.67741105 -103.4534521 2020-12-25 05:22:48 Custer, South Dakota, US
3694330 3694330 2020-12-24 US South Dakota Davison 46035 2671 52 0 2619 43.67490933 -98.14458906 2020-12-25 05:22:48 Davison, South Dakota, US
3694331 3694331 2020-12-24 US South Dakota Day 46037 516 20 0 496 45.367281 -97.60737498 2020-12-25 05:22:48 Day, South Dakota, US
3694332 3694332 2020-12-24 US South Dakota Deuel 46039 399 6 0 393 44.75994309 -96.66943645 2020-12-25 05:22:48 Deuel, South Dakota, US
3694333 3694333 2020-12-24 US South Dakota Dewey 46041 1240 12 0 1228 45.15639647 -100.8709139 2020-12-25 05:22:48 Dewey, South Dakota, US
3694334 3694334 2020-12-24 US South Dakota Douglas 46043 372 7 0 365 43.38520741 -98.36978007 2020-12-25 05:22:48 Douglas, South Dakota, US
3694335 3694335 2020-12-24 US South Dakota Edmunds 46045 341 4 0 337 45.41846445 -99.21545423 2020-12-25 05:22:48 Edmunds, South Dakota, US
3694336 3694336 2020-12-24 US South Dakota Fall River 46047 434 11 0 423 43.23929297 -103.5275691 2020-12-25 05:22:48 Fall River, South Dakota, US
3694337 3694337 2020-12-24 US South Dakota Faulk 46049 310 11 0 299 45.07082625 -99.14535601 2020-12-25 05:22:48 Faulk, South Dakota, US
3694338 3694338 2020-12-24 US South Dakota Grant 46051 809 25 0 784 45.1723937 -96.77002276 2020-12-25 05:22:48 Grant, South Dakota, US
3694339 3694339 2020-12-24 US South Dakota Gregory 46053 481 26 0 455 43.19419064 -99.18883902 2020-12-25 05:22:48 Gregory, South Dakota, US
3694340 3694340 2020-12-24 US South Dakota Haakon 46055 225 7 0 218 44.29299053 -101.539099 2020-12-25 05:22:48 Haakon, South Dakota, US
3694341 3694341 2020-12-24 US South Dakota Hamlin 46057 589 32 0 557 44.67385954 -97.18829593 2020-12-25 05:22:48 Hamlin, South Dakota, US
3694342 3694342 2020-12-24 US South Dakota Hand 46059 311 2 0 309 44.54708407 -99.00386459 2020-12-25 05:22:48 Hand, South Dakota, US
3694343 3694343 2020-12-24 US South Dakota Hanson 46061 306 3 0 303 43.6746384 -97.78715148 2020-12-25 05:22:48 Hanson, South Dakota, US
3694344 3694344 2020-12-24 US South Dakota Harding 46063 88 1 0 87 45.58015551 -103.4958629 2020-12-25 05:22:48 Harding, South Dakota, US
3694345 3694345 2020-12-24 US South Dakota Hughes 46065 1952 25 0 1927 44.39091534 -99.99661148 2020-12-25 05:22:48 Hughes, South Dakota, US
3694346 3694346 2020-12-24 US South Dakota Hutchinson 46067 688 14 0 674 43.33449012 -97.75536441 2020-12-25 05:22:48 Hutchinson, South Dakota, US
3694347 3694347 2020-12-24 US South Dakota Hyde 46069 131 0 0 131 44.54747703 -99.48572582 2020-12-25 05:22:48 Hyde, South Dakota, US
3694348 3694348 2020-12-24 US South Dakota Jackson 46071 260 8 0 252 43.69318385 -101.6255063 2020-12-25 05:22:48 Jackson, South Dakota, US
3694349 3694349 2020-12-24 US South Dakota Jerauld 46073 258 15 0 243 44.06637798 -98.62965972 2020-12-25 05:22:48 Jerauld, South Dakota, US
3694350 3694350 2020-12-24 US South Dakota Jones 46075 65 0 0 65 43.96278565 -100.6940008 2020-12-25 05:22:48 Jones, South Dakota, US
3694351 3694351 2020-12-24 US South Dakota Kingsbury 46077 527 13 0 514 44.36956169 -97.4913945 2020-12-25 05:22:48 Kingsbury, South Dakota, US
3694352 3694352 2020-12-24 US South Dakota Lake 46079 1004 14 0 990 44.02193107 -97.12926365 2020-12-25 05:22:48 Lake, South Dakota, US
3694353 3694353 2020-12-24 US South Dakota Lawrence 46081 2465 28 0 2437 44.35919441 -103.7929428 2020-12-25 05:22:48 Lawrence, South Dakota, US
3694354 3694354 2020-12-24 US South Dakota Lincoln 46083 6588 63 0 6525 43.27841182 -96.7203905 2020-12-25 05:22:48 Lincoln, South Dakota, US
3694355 3694355 2020-12-24 US South Dakota Lyman 46085 511 9 0 502 43.89522709 -99.85201878 2020-12-25 05:22:48 Lyman, South Dakota, US
3694356 3694356 2020-12-24 US South Dakota Marshall 46091 256 4 0 252 45.75870838 -97.59855639 2020-12-25 05:22:48 Marshall, South Dakota, US
3694357 3694357 2020-12-24 US South Dakota McCook 46087 665 21 0 644 43.6742571 -97.36863144 2020-12-25 05:22:48 McCook, South Dakota, US
3694358 3694358 2020-12-24 US South Dakota McPherson 46089 178 1 0 177 45.76626028 -99.22118798 2020-12-25 05:22:48 McPherson, South Dakota, US
3694359 3694359 2020-12-24 US South Dakota Meade 46093 2160 24 0 2136 44.56676791 -102.7162741 2020-12-25 05:22:48 Meade, South Dakota, US
3694360 3694360 2020-12-24 US South Dakota Mellette 46095 214 2 0 212 43.58078848 -100.7563186 2020-12-25 05:22:48 Mellette, South Dakota, US
3694361 3694361 2020-12-24 US South Dakota Miner 46097 222 6 0 216 44.02197882 -97.60992207 2020-12-25 05:22:48 Miner, South Dakota, US
3694362 3694362 2020-12-24 US South Dakota Minnehaha 46099 24377 257 0 24120 43.67441641 -96.7910885 2020-12-25 05:22:48 Minnehaha, South Dakota, US
3694363 3694363 2020-12-24 US South Dakota Moody 46101 524 14 0 510 44.02266214 -96.67081159 2020-12-25 05:22:48 Moody, South Dakota, US
3694364 3694364 2020-12-24 US South Dakota Oglala Lakota 46102 1893 34 0 1859 43.33749164 -102.5555498 2020-12-25 05:22:48 Oglala Lakota, South Dakota, US
3694365 3694365 2020-12-24 US South Dakota Pennington 46103 10802 127 0 10675 44.0025835 -102.8240777 2020-12-25 05:22:48 Pennington, South Dakota, US
3694366 3694366 2020-12-24 US South Dakota Perkins 46105 274 11 0 263 45.49049506 -102.4755586 2020-12-25 05:22:48 Perkins, South Dakota, US
3694367 3694367 2020-12-24 US South Dakota Potter 46107 298 2 0 296 45.06583079 -99.95498503 2020-12-25 05:22:48 Potter, South Dakota, US
3694368 3694368 2020-12-24 US South Dakota Roberts 46109 940 31 0 909 45.62975048 -96.94672673 2020-12-25 05:22:48 Roberts, South Dakota, US
3694369 3694369 2020-12-24 US South Dakota Sanborn 46111 303 3 0 300 44.02351092 -98.0909816 2020-12-25 05:22:48 Sanborn, South Dakota, US
3694370 3694370 2020-12-24 US South Dakota Spink 46115 689 24 0 665 44.93837606 -98.34626602 2020-12-25 05:22:48 Spink, South Dakota, US
3694371 3694371 2020-12-24 US South Dakota Stanley 46117 264 2 0 262 44.41381872 -100.7349153 2020-12-25 05:22:48 Stanley, South Dakota, US
3694372 3694372 2020-12-24 US South Dakota Sully 46119 105 3 0 102 44.71571812 -100.1278092 2020-12-25 05:22:48 Sully, South Dakota, US
3694373 3694373 2020-12-24 US South Dakota Todd 46121 1136 18 0 1118 43.19338568 -100.7195503 2020-12-25 05:22:48 Todd, South Dakota, US
3694374 3694374 2020-12-24 US South Dakota Tripp 46123 617 11 0 606 43.34459388 -99.8854891 2020-12-25 05:22:48 Tripp, South Dakota, US
3694375 3694375 2020-12-24 US South Dakota Turner 46125 942 47 0 895 43.3109081 -97.14865776 2020-12-25 05:22:48 Turner, South Dakota, US
3694376 3694376 2020-12-24 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2020-12-25 05:22:48 Unassigned, South Dakota, US
3694377 3694377 2020-12-24 US South Dakota Union 46127 1556 30 0 1526 42.83112163 -96.6557828 2020-12-25 05:22:48 Union, South Dakota, US
3694378 3694378 2020-12-24 US South Dakota Walworth 46129 607 14 0 593 45.43019636 -100.0307514 2020-12-25 05:22:48 Walworth, South Dakota, US
3694379 3694379 2020-12-24 US South Dakota Yankton 46135 2408 25 0 2383 43.00924485 -97.39467635 2020-12-25 05:22:48 Yankton, South Dakota, US
3694380 3694380 2020-12-24 US South Dakota Ziebach 46137 287 7 0 280 44.97881876 -101.6654622 2020-12-25 05:22:48 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]);