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 2021-01-20 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
1096924 1096924 2021-01-20 US South Dakota Aurora 46003 439 11 0 428 43.71757685 -98.56050467 2021-01-21 05:22:01 Aurora, South Dakota, US
1096925 1096925 2021-01-20 US South Dakota Beadle 46005 2586 38 0 2548 44.41464384 -98.27858469 2021-01-21 05:22:01 Beadle, South Dakota, US
1096926 1096926 2021-01-20 US South Dakota Bennett 46007 374 8 0 366 43.19486375 -101.6665572 2021-01-21 05:22:01 Bennett, South Dakota, US
1096927 1096927 2021-01-20 US South Dakota Bon Homme 46009 1502 23 0 1479 42.98914167 -97.88592746 2021-01-21 05:22:01 Bon Homme, South Dakota, US
1096928 1096928 2021-01-20 US South Dakota Brookings 46011 3329 32 0 3297 44.36974375 -96.79079945 2021-01-21 05:22:01 Brookings, South Dakota, US
1096929 1096929 2021-01-20 US South Dakota Brown 46013 4797 75 0 4722 45.58994323 -98.35165355 2021-01-21 05:22:01 Brown, South Dakota, US
1096930 1096930 2021-01-20 US South Dakota Brule 46015 671 7 0 664 43.71756379 -99.08118954 2021-01-21 05:22:01 Brule, South Dakota, US
1096931 1096931 2021-01-20 US South Dakota Buffalo 46017 415 12 0 403 44.07657829 -99.20814467 2021-01-21 05:22:01 Buffalo, South Dakota, US
1096932 1096932 2021-01-20 US South Dakota Butte 46019 941 20 0 921 44.90608745 -103.5079318 2021-01-21 05:22:01 Butte, South Dakota, US
1096933 1096933 2021-01-20 US South Dakota Campbell 46021 116 4 0 112 45.77074915 -100.0510181 2021-01-21 05:22:01 Campbell, South Dakota, US
1096934 1096934 2021-01-20 US South Dakota Charles Mix 46023 1187 14 0 1173 43.20660134 -98.58856175 2021-01-21 05:22:01 Charles Mix, South Dakota, US
1096935 1096935 2021-01-20 US South Dakota Clark 46025 329 4 0 325 44.85834507 -97.72925109 2021-01-21 05:22:01 Clark, South Dakota, US
1096936 1096936 2021-01-20 US South Dakota Clay 46027 1723 13 0 1710 42.91296147 -96.97656917 2021-01-21 05:22:01 Clay, South Dakota, US
1096937 1096937 2021-01-20 US South Dakota Codington 46029 3686 73 0 3613 44.97788119 -97.18827677 2021-01-21 05:22:01 Codington, South Dakota, US
1096938 1096938 2021-01-20 US South Dakota Corson 46031 457 11 0 446 45.70889983 -101.1970473 2021-01-21 05:22:01 Corson, South Dakota, US
1096939 1096939 2021-01-20 US South Dakota Custer 46033 715 10 0 705 43.67741105 -103.4534521 2021-01-21 05:22:01 Custer, South Dakota, US
1096940 1096940 2021-01-20 US South Dakota Davison 46035 2858 55 0 2803 43.67490933 -98.14458906 2021-01-21 05:22:01 Davison, South Dakota, US
1096941 1096941 2021-01-20 US South Dakota Day 46037 582 23 0 559 45.367281 -97.60737498 2021-01-21 05:22:01 Day, South Dakota, US
1096942 1096942 2021-01-20 US South Dakota Deuel 46039 450 7 0 443 44.75994309 -96.66943645 2021-01-21 05:22:01 Deuel, South Dakota, US
1096943 1096943 2021-01-20 US South Dakota Dewey 46041 1371 18 0 1353 45.15639647 -100.8709139 2021-01-21 05:22:01 Dewey, South Dakota, US
1096944 1096944 2021-01-20 US South Dakota Douglas 46043 409 9 0 400 43.38520741 -98.36978007 2021-01-21 05:22:01 Douglas, South Dakota, US
1096945 1096945 2021-01-20 US South Dakota Edmunds 46045 440 5 0 435 45.41846445 -99.21545423 2021-01-21 05:22:01 Edmunds, South Dakota, US
1096946 1096946 2021-01-20 US South Dakota Fall River 46047 487 13 0 474 43.23929297 -103.5275691 2021-01-21 05:22:01 Fall River, South Dakota, US
1096947 1096947 2021-01-20 US South Dakota Faulk 46049 326 13 0 313 45.07082625 -99.14535601 2021-01-21 05:22:01 Faulk, South Dakota, US
1096948 1096948 2021-01-20 US South Dakota Grant 46051 869 35 0 834 45.1723937 -96.77002276 2021-01-21 05:22:01 Grant, South Dakota, US
1096949 1096949 2021-01-20 US South Dakota Gregory 46053 495 26 0 469 43.19419064 -99.18883902 2021-01-21 05:22:01 Gregory, South Dakota, US
1096950 1096950 2021-01-20 US South Dakota Haakon 46055 240 9 0 231 44.29299053 -101.539099 2021-01-21 05:22:01 Haakon, South Dakota, US
1096951 1096951 2021-01-20 US South Dakota Hamlin 46057 656 38 0 618 44.67385954 -97.18829593 2021-01-21 05:22:01 Hamlin, South Dakota, US
1096952 1096952 2021-01-20 US South Dakota Hand 46059 321 4 0 317 44.54708407 -99.00386459 2021-01-21 05:22:01 Hand, South Dakota, US
1096953 1096953 2021-01-20 US South Dakota Hanson 46061 328 4 0 324 43.6746384 -97.78715148 2021-01-21 05:22:01 Hanson, South Dakota, US
1096954 1096954 2021-01-20 US South Dakota Harding 46063 89 1 0 88 45.58015551 -103.4958629 2021-01-21 05:22:01 Harding, South Dakota, US
1096955 1096955 2021-01-20 US South Dakota Hughes 46065 2140 30 0 2110 44.39091534 -99.99661148 2021-01-21 05:22:01 Hughes, South Dakota, US
1096956 1096956 2021-01-20 US South Dakota Hutchinson 46067 738 22 0 716 43.33449012 -97.75536441 2021-01-21 05:22:01 Hutchinson, South Dakota, US
1096957 1096957 2021-01-20 US South Dakota Hyde 46069 134 1 0 133 44.54747703 -99.48572582 2021-01-21 05:22:01 Hyde, South Dakota, US
1096958 1096958 2021-01-20 US South Dakota Jackson 46071 269 13 0 256 43.69318385 -101.6255063 2021-01-21 05:22:01 Jackson, South Dakota, US
1096959 1096959 2021-01-20 US South Dakota Jerauld 46073 265 16 0 249 44.06637798 -98.62965972 2021-01-21 05:22:01 Jerauld, South Dakota, US
1096960 1096960 2021-01-20 US South Dakota Jones 46075 77 0 0 77 43.96278565 -100.6940008 2021-01-21 05:22:01 Jones, South Dakota, US
1096961 1096961 2021-01-20 US South Dakota Kingsbury 46077 591 13 0 578 44.36956169 -97.4913945 2021-01-21 05:22:01 Kingsbury, South Dakota, US
1096962 1096962 2021-01-20 US South Dakota Lake 46079 1106 16 0 1090 44.02193107 -97.12926365 2021-01-21 05:22:01 Lake, South Dakota, US
1096963 1096963 2021-01-20 US South Dakota Lawrence 46081 2719 35 0 2684 44.35919441 -103.7929428 2021-01-21 05:22:01 Lawrence, South Dakota, US
1096964 1096964 2021-01-20 US South Dakota Lincoln 46083 7281 70 0 7211 43.27841182 -96.7203905 2021-01-21 05:22:01 Lincoln, South Dakota, US
1096965 1096965 2021-01-20 US South Dakota Lyman 46085 575 10 0 565 43.89522709 -99.85201878 2021-01-21 05:22:01 Lyman, South Dakota, US
1096966 1096966 2021-01-20 US South Dakota Marshall 46091 280 5 0 275 45.75870838 -97.59855639 2021-01-21 05:22:01 Marshall, South Dakota, US
1096967 1096967 2021-01-20 US South Dakota McCook 46087 711 22 0 689 43.6742571 -97.36863144 2021-01-21 05:22:01 McCook, South Dakota, US
1096968 1096968 2021-01-20 US South Dakota McPherson 46089 225 4 0 221 45.76626028 -99.22118798 2021-01-21 05:22:01 McPherson, South Dakota, US
1096969 1096969 2021-01-20 US South Dakota Meade 46093 2416 26 0 2390 44.56676791 -102.7162741 2021-01-21 05:22:01 Meade, South Dakota, US
1096970 1096970 2021-01-20 US South Dakota Mellette 46095 233 2 0 231 43.58078848 -100.7563186 2021-01-21 05:22:01 Mellette, South Dakota, US
1096971 1096971 2021-01-20 US South Dakota Miner 46097 256 7 0 249 44.02197882 -97.60992207 2021-01-21 05:22:01 Miner, South Dakota, US
1096972 1096972 2021-01-20 US South Dakota Minnehaha 46099 26509 296 0 26213 43.67441641 -96.7910885 2021-01-21 05:22:01 Minnehaha, South Dakota, US
1096973 1096973 2021-01-20 US South Dakota Moody 46101 586 15 0 571 44.02266214 -96.67081159 2021-01-21 05:22:01 Moody, South Dakota, US
1096974 1096974 2021-01-20 US South Dakota Oglala Lakota 46102 2008 40 0 1968 43.33749164 -102.5555498 2021-01-21 05:22:01 Oglala Lakota, South Dakota, US
1096975 1096975 2021-01-20 US South Dakota Pennington 46103 12115 161 0 11954 44.0025835 -102.8240777 2021-01-21 05:22:01 Pennington, South Dakota, US
1096976 1096976 2021-01-20 US South Dakota Perkins 46105 320 11 0 309 45.49049506 -102.4755586 2021-01-21 05:22:01 Perkins, South Dakota, US
1096977 1096977 2021-01-20 US South Dakota Potter 46107 339 3 0 336 45.06583079 -99.95498503 2021-01-21 05:22:01 Potter, South Dakota, US
1096978 1096978 2021-01-20 US South Dakota Roberts 46109 1082 34 0 1048 45.62975048 -96.94672673 2021-01-21 05:22:01 Roberts, South Dakota, US
1096979 1096979 2021-01-20 US South Dakota Sanborn 46111 323 3 0 320 44.02351092 -98.0909816 2021-01-21 05:22:01 Sanborn, South Dakota, US
1096980 1096980 2021-01-20 US South Dakota Spink 46115 747 24 0 723 44.93837606 -98.34626602 2021-01-21 05:22:01 Spink, South Dakota, US
1096981 1096981 2021-01-20 US South Dakota Stanley 46117 304 2 0 302 44.41381872 -100.7349153 2021-01-21 05:22:01 Stanley, South Dakota, US
1096982 1096982 2021-01-20 US South Dakota Sully 46119 129 3 0 126 44.71571812 -100.1278092 2021-01-21 05:22:01 Sully, South Dakota, US
1096983 1096983 2021-01-20 US South Dakota Todd 46121 1192 20 0 1172 43.19338568 -100.7195503 2021-01-21 05:22:01 Todd, South Dakota, US
1096984 1096984 2021-01-20 US South Dakota Tripp 46123 648 14 0 634 43.34459388 -99.8854891 2021-01-21 05:22:01 Tripp, South Dakota, US
1096985 1096985 2021-01-20 US South Dakota Turner 46125 1024 49 0 975 43.3109081 -97.14865776 2021-01-21 05:22:01 Turner, South Dakota, US
1096986 1096986 2021-01-20 US South Dakota Unassigned 90046 0 0 0 0 45.77074915 -99.99661148 2021-01-21 05:22:01 Unassigned, South Dakota, US
1096987 1096987 2021-01-20 US South Dakota Union 46127 1815 36 0 1779 42.83112163 -96.6557828 2021-01-21 05:22:01 Union, South Dakota, US
1096988 1096988 2021-01-20 US South Dakota Walworth 46129 689 14 0 675 45.43019636 -100.0307514 2021-01-21 05:22:01 Walworth, South Dakota, US
1096989 1096989 2021-01-20 US South Dakota Yankton 46135 2696 27 0 2669 43.00924485 -97.39467635 2021-01-21 05:22:01 Yankton, South Dakota, US
1096990 1096990 2021-01-20 US South Dakota Ziebach 46137 333 8 0 325 44.97881876 -101.6654622 2021-01-21 05:22:01 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]);