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-10-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
2723848 2723848 2021-10-30 US South Dakota Aurora 46003 545 17 0   43.71757685 -98.56050467 2021-10-31 04:22:08 Aurora, South Dakota, US
2723849 2723849 2021-10-30 US South Dakota Beadle 46005 3298 47 0   44.41464384 -98.27858469 2021-10-31 04:22:08 Beadle, South Dakota, US
2723850 2723850 2021-10-30 US South Dakota Bennett 46007 473 9 0   43.19486375 -101.6665572 2021-10-31 04:22:08 Bennett, South Dakota, US
2723851 2723851 2021-10-30 US South Dakota Bon Homme 46009 1637 29 0   42.98914167 -97.88592746 2021-10-31 04:22:08 Bon Homme, South Dakota, US
2723852 2723852 2021-10-30 US South Dakota Brookings 46011 5132 39 0   44.36974375 -96.79079945 2021-10-31 04:22:08 Brookings, South Dakota, US
2723853 2723853 2021-10-30 US South Dakota Brown 46013 6685 100 0   45.58994323 -98.35165355 2021-10-31 04:22:08 Brown, South Dakota, US
2723854 2723854 2021-10-30 US South Dakota Brule 46015 813 11 0   43.71756379 -99.08118954 2021-10-31 04:22:08 Brule, South Dakota, US
2723855 2723855 2021-10-30 US South Dakota Buffalo 46017 452 14 0   44.07657829 -99.20814467 2021-10-31 04:22:08 Buffalo, South Dakota, US
2723856 2723856 2021-10-30 US South Dakota Butte 46019 1876 31 0   44.90608745 -103.5079318 2021-10-31 04:22:08 Butte, South Dakota, US
2723857 2723857 2021-10-30 US South Dakota Campbell 46021 166 4 0   45.77074915 -100.0510181 2021-10-31 04:22:08 Campbell, South Dakota, US
2723858 2723858 2021-10-30 US South Dakota Charles Mix 46023 1724 26 0   43.20660134 -98.58856175 2021-10-31 04:22:08 Charles Mix, South Dakota, US
2723859 2723859 2021-10-30 US South Dakota Clark 46025 511 5 0   44.85834507 -97.72925109 2021-10-31 04:22:08 Clark, South Dakota, US
2723860 2723860 2021-10-30 US South Dakota Clay 46027 2218 18 0   42.91296147 -96.97656917 2021-10-31 04:22:08 Clay, South Dakota, US
2723861 2723861 2021-10-30 US South Dakota Codington 46029 5598 84 0   44.97788119 -97.18827677 2021-10-31 04:22:08 Codington, South Dakota, US
2723862 2723862 2021-10-30 US South Dakota Corson 46031 672 13 0   45.70889983 -101.1970473 2021-10-31 04:22:08 Corson, South Dakota, US
2723863 2723863 2021-10-30 US South Dakota Custer 46033 1358 15 0   43.67741105 -103.45345209999999 2021-10-31 04:22:08 Custer, South Dakota, US
2723864 2723864 2021-10-30 US South Dakota Davison 46035 3742 69 0   43.67490933 -98.14458906 2021-10-31 04:22:08 Davison, South Dakota, US
2723865 2723865 2021-10-30 US South Dakota Day 46037 818 30 0   45.367281 -97.60737498 2021-10-31 04:22:08 Day, South Dakota, US
2723866 2723866 2021-10-30 US South Dakota Deuel 46039 666 11 0   44.75994309 -96.66943645 2021-10-31 04:22:08 Deuel, South Dakota, US
2723867 2723867 2021-10-30 US South Dakota Dewey 46041 1843 31 0   45.15639647 -100.8709139 2021-10-31 04:22:08 Dewey, South Dakota, US
2723868 2723868 2021-10-30 US South Dakota Douglas 46043 514 9 0   43.38520741 -98.36978007 2021-10-31 04:22:08 Douglas, South Dakota, US
2723869 2723869 2021-10-30 US South Dakota Edmunds 46045 622 14 0   45.41846445 -99.21545423 2021-10-31 04:22:08 Edmunds, South Dakota, US
2723870 2723870 2021-10-30 US South Dakota Fall River 46047 990 23 0   43.23929297 -103.5275691 2021-10-31 04:22:08 Fall River, South Dakota, US
2723871 2723871 2021-10-30 US South Dakota Faulk 46049 405 15 0   45.07082625 -99.14535601 2021-10-31 04:22:08 Faulk, South Dakota, US
2723872 2723872 2021-10-30 US South Dakota Grant 46051 1339 44 0   45.1723937 -96.77002276 2021-10-31 04:22:08 Grant, South Dakota, US
2723873 2723873 2021-10-30 US South Dakota Gregory 46053 713 30 0   43.19419064 -99.18883902 2021-10-31 04:22:08 Gregory, South Dakota, US
2723874 2723874 2021-10-30 US South Dakota Haakon 46055 328 11 0   44.29299053 -101.539099 2021-10-31 04:22:08 Haakon, South Dakota, US
2723875 2723875 2021-10-30 US South Dakota Hamlin 46057 1030 40 0   44.67385954 -97.18829593 2021-10-31 04:22:08 Hamlin, South Dakota, US
2723876 2723876 2021-10-30 US South Dakota Hand 46059 395 6 0   44.54708407 -99.00386459 2021-10-31 04:22:08 Hand, South Dakota, US
2723877 2723877 2021-10-30 US South Dakota Hanson 46061 441 4 0   43.6746384 -97.78715148 2021-10-31 04:22:08 Hanson, South Dakota, US
2723878 2723878 2021-10-30 US South Dakota Harding 46063 161 2 0   45.58015551 -103.4958629 2021-10-31 04:22:08 Harding, South Dakota, US
2723879 2723879 2021-10-30 US South Dakota Hughes 46065 2988 45 0   44.39091534 -99.99661148 2021-10-31 04:22:08 Hughes, South Dakota, US
2723880 2723880 2021-10-30 US South Dakota Hutchinson 46067 1053 28 0   43.33449012 -97.75536441 2021-10-31 04:22:08 Hutchinson, South Dakota, US
2723881 2723881 2021-10-30 US South Dakota Hyde 46069 191 2 0   44.54747703 -99.48572582 2021-10-31 04:22:08 Hyde, South Dakota, US
2723882 2723882 2021-10-30 US South Dakota Jackson 46071 394 16 0   43.69318385 -101.6255063 2021-10-31 04:22:08 Jackson, South Dakota, US
2723883 2723883 2021-10-30 US South Dakota Jerauld 46073 300 17 0   44.06637798 -98.62965972 2021-10-31 04:22:08 Jerauld, South Dakota, US
2723884 2723884 2021-10-30 US South Dakota Jones 46075 140 1 0   43.96278565 -100.6940008 2021-10-31 04:22:08 Jones, South Dakota, US
2723885 2723885 2021-10-30 US South Dakota Kingsbury 46077 919 18 0   44.36956169 -97.4913945 2021-10-31 04:22:08 Kingsbury, South Dakota, US
2723886 2723886 2021-10-30 US South Dakota Lake 46079 1572 20 0   44.02193107 -97.12926365 2021-10-31 04:22:08 Lake, South Dakota, US
2723887 2723887 2021-10-30 US South Dakota Lawrence 46081 4358 59 0   44.35919441 -103.79294279999999 2021-10-31 04:22:08 Lawrence, South Dakota, US
2723888 2723888 2021-10-30 US South Dakota Lincoln 46083 10267 78 0   43.27841182 -96.72039050000001 2021-10-31 04:22:08 Lincoln, South Dakota, US
2723889 2723889 2021-10-30 US South Dakota Lyman 46085 734 11 0   43.89522709 -99.85201878 2021-10-31 04:22:08 Lyman, South Dakota, US
2723890 2723890 2021-10-30 US South Dakota Marshall 46091 449 8 0   45.75870838 -97.59855639 2021-10-31 04:22:08 Marshall, South Dakota, US
2723891 2723891 2021-10-30 US South Dakota McCook 46087 911 25 0   43.6742571 -97.36863144 2021-10-31 04:22:08 McCook, South Dakota, US
2723892 2723892 2021-10-30 US South Dakota McPherson 46089 324 7 0   45.76626028 -99.22118798 2021-10-31 04:22:08 McPherson, South Dakota, US
2723893 2723893 2021-10-30 US South Dakota Meade 46093 4547 46 0   44.56676791 -102.71627409999999 2021-10-31 04:22:08 Meade, South Dakota, US
2723894 2723894 2021-10-30 US South Dakota Mellette 46095 321 3 0   43.58078848 -100.7563186 2021-10-31 04:22:08 Mellette, South Dakota, US
2723895 2723895 2021-10-30 US South Dakota Miner 46097 354 11 0   44.02197882 -97.60992207 2021-10-31 04:22:08 Miner, South Dakota, US
2723896 2723896 2021-10-30 US South Dakota Minnehaha 46099 37519 393 0   43.67441641 -96.7910885 2021-10-31 04:22:08 Minnehaha, South Dakota, US
2723897 2723897 2021-10-30 US South Dakota Moody 46101 783 20 0   44.02266214 -96.67081159 2021-10-31 04:22:08 Moody, South Dakota, US
2723898 2723898 2021-10-30 US South Dakota Oglala Lakota 46102 2423 53 0   43.33749164 -102.55554980000001 2021-10-31 04:22:08 Oglala Lakota, South Dakota, US
2723899 2723899 2021-10-30 US South Dakota Pennington 46103 20863 249 0   44.0025835 -102.8240777 2021-10-31 04:22:08 Pennington, South Dakota, US
2723900 2723900 2021-10-30 US South Dakota Perkins 46105 418 15 0   45.49049506 -102.47555859999999 2021-10-31 04:22:08 Perkins, South Dakota, US
2723901 2723901 2021-10-30 US South Dakota Potter 46107 425 4 0   45.06583079 -99.95498503 2021-10-31 04:22:08 Potter, South Dakota, US
2723902 2723902 2021-10-30 US South Dakota Roberts 46109 1560 43 0   45.62975048 -96.94672673 2021-10-31 04:22:08 Roberts, South Dakota, US
2723903 2723903 2021-10-30 US South Dakota Sanborn 46111 385 3 0   44.02351092 -98.09098159999999 2021-10-31 04:22:08 Sanborn, South Dakota, US
2723904 2723904 2021-10-30 US South Dakota Spink 46115 1031 27 0   44.93837606 -98.34626602 2021-10-31 04:22:08 Spink, South Dakota, US
2723905 2723905 2021-10-30 US South Dakota Stanley 46117 436 3 0   44.41381872 -100.7349153 2021-10-31 04:22:08 Stanley, South Dakota, US
2723906 2723906 2021-10-30 US South Dakota Sully 46119 159 3 0   44.71571812 -100.1278092 2021-10-31 04:22:08 Sully, South Dakota, US
2723907 2723907 2021-10-30 US South Dakota Todd 46121 1618 36 0   43.19338568 -100.71955030000001 2021-10-31 04:22:08 Todd, South Dakota, US
2723908 2723908 2021-10-30 US South Dakota Tripp 46123 853 18 0   43.34459388 -99.8854891 2021-10-31 04:22:08 Tripp, South Dakota, US
2723909 2723909 2021-10-30 US South Dakota Turner 46125 1335 61 0   43.3109081 -97.14865776 2021-10-31 04:22:08 Turner, South Dakota, US
2723910 2723910 2021-10-30 US South Dakota Unassigned 90046 0 0 0   45.77074915 -99.99661148 2021-10-31 04:22:08 Unassigned, South Dakota, US
2723911 2723911 2021-10-30 US South Dakota Union 46127 2673 45 0   42.83112163 -96.6557828 2021-10-31 04:22:08 Union, South Dakota, US
2723912 2723912 2021-10-30 US South Dakota Walworth 46129 910 18 0   45.43019636 -100.03075140000001 2021-10-31 04:22:08 Walworth, South Dakota, US
2723913 2723913 2021-10-30 US South Dakota Yankton 46135 3678 38 0   43.00924485 -97.39467635 2021-10-31 04:22:08 Yankton, South Dakota, US
2723914 2723914 2021-10-30 US South Dakota Ziebach 46137 426 10 0   44.97881876 -101.6654622 2021-10-31 04:22:08 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]);