johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
71 rows where active = 39, country_or_region = "US" and province_or_state = "South Dakota" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
894990 | 894990 | 2020-11-05 | US | South Dakota | Jones | 46075 | 39 | 0 | 0 | 39 | 43.96278565 | -100.6940008 | 2020-11-06 05:24:55 | Jones, South Dakota, US |
1455452 | 1455452 | 2020-10-27 | US | South Dakota | Hyde | 46069 | 39 | 0 | 0 | 39 | 44.54747703 | -99.48572582 | 2020-10-28 04:24:39 | Hyde, South Dakota, US |
3483176 | 3483176 | 2020-10-26 | US | South Dakota | Hyde | 46069 | 39 | 0 | 0 | 39 | 44.54747703 | -99.48572582 | 2020-10-27 04:24:45 | Hyde, South Dakota, US |
1056714 | 1056714 | 2020-10-23 | US | South Dakota | Sully | 46119 | 39 | 0 | 0 | 39 | 44.71571812 | -100.1278092 | 2020-10-24 04:24:46 | Sully, South Dakota, US |
1180356 | 1180356 | 2020-10-22 | US | South Dakota | Harding | 46063 | 39 | 0 | 0 | 39 | 45.58015551 | -103.4958629 | 2020-10-23 04:24:46 | Harding, South Dakota, US |
1180384 | 1180384 | 2020-10-22 | US | South Dakota | Sully | 46119 | 39 | 0 | 0 | 39 | 44.71571812 | -100.1278092 | 2020-10-23 04:24:46 | Sully, South Dakota, US |
2194489 | 2194489 | 2020-10-21 | US | South Dakota | Sully | 46119 | 39 | 0 | 0 | 39 | 44.71571812 | -100.1278092 | 2020-10-22 04:24:27 | Sully, South Dakota, US |
1825625 | 1825625 | 2020-10-04 | US | South Dakota | Campbell | 46021 | 39 | 0 | 0 | 39 | 45.77074915 | -100.0510181 | 2020-10-05 04:23:33 | Campbell, South Dakota, US |
2517055 | 2517055 | 2020-10-03 | US | South Dakota | Sanborn | 46111 | 39 | 0 | 0 | 39 | 44.02351092 | -98.0909816 | 2020-10-04 04:23:44 | Sanborn, South Dakota, US |
3319100 | 3319100 | 2020-09-22 | US | South Dakota | Potter | 46107 | 39 | 0 | 0 | 39 | 45.06583079 | -99.95498503 | 2020-09-23 04:23:00 | Potter, South Dakota, US |
2839699 | 2839699 | 2020-09-21 | US | South Dakota | Potter | 46107 | 39 | 0 | 0 | 39 | 45.06583079 | -99.95498503 | 2020-09-22 04:23:00 | Potter, South Dakota, US |
2851705 | 2851705 | 2020-09-18 | US | South Dakota | Kingsbury | 46077 | 39 | 0 | 0 | 39 | 44.36956169 | -97.4913945 | 2020-09-19 04:22:00 | Kingsbury, South Dakota, US |
2871602 | 2871602 | 2020-09-13 | US | South Dakota | Tripp | 46123 | 39 | 0 | 0 | 39 | 43.34459388 | -99.8854891 | 2020-09-14 04:26:00 | Tripp, South Dakota, US |
1246610 | 1246610 | 2020-09-08 | US | South Dakota | Gregory | 46053 | 40 | 1 | 0 | 39 | 43.19419064 | -99.18883902 | 2020-09-09 04:28:48 | Gregory, South Dakota, US |
430185 | 430185 | 2020-09-07 | US | South Dakota | Edmunds | 46045 | 39 | 0 | 0 | 39 | 45.41846445 | -99.21545423 | 2020-09-08 04:28:25 | Edmunds, South Dakota, US |
1357161 | 1357161 | 2020-09-03 | US | South Dakota | Day | 46037 | 39 | 0 | 0 | 39 | 45.367281 | -97.60737498 | 2020-09-04 04:28:26 | Day, South Dakota, US |
196930 | 196930 | 2020-08-31 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-09-01 04:28:31 | Jerauld, South Dakota, US |
3934885 | 3934885 | 2020-08-30 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-31 04:28:27 | Jerauld, South Dakota, US |
612547 | 612547 | 2020-08-29 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-30 04:28:22 | Jerauld, South Dakota, US |
1526042 | 1526042 | 2020-08-28 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-29 04:28:19 | Jerauld, South Dakota, US |
2513043 | 2513043 | 2020-08-27 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-28 04:28:11 | Jerauld, South Dakota, US |
2513057 | 2513057 | 2020-08-27 | US | South Dakota | Moody | 46101 | 39 | 0 | 0 | 39 | 44.02266214 | -96.67081159 | 2020-08-28 04:28:11 | Moody, South Dakota, US |
1999492 | 1999492 | 2020-08-26 | US | South Dakota | Grant | 46051 | 39 | 0 | 0 | 39 | 45.1723937 | -96.77002276 | 2020-08-27 04:28:15 | Grant, South Dakota, US |
1999503 | 1999503 | 2020-08-26 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-27 04:28:15 | Jerauld, South Dakota, US |
3565416 | 3565416 | 2020-08-25 | US | South Dakota | Grant | 46051 | 39 | 0 | 0 | 39 | 45.1723937 | -96.77002276 | 2020-08-26 04:28:11 | Grant, South Dakota, US |
3565427 | 3565427 | 2020-08-25 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-26 04:28:11 | Jerauld, South Dakota, US |
2994120 | 2994120 | 2020-08-24 | US | South Dakota | Grant | 46051 | 39 | 0 | 0 | 39 | 45.1723937 | -96.77002276 | 2020-08-25 04:28:02 | Grant, South Dakota, US |
2994131 | 2994131 | 2020-08-24 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-25 04:28:02 | Jerauld, South Dakota, US |
2218515 | 2218515 | 2020-08-23 | US | South Dakota | Grant | 46051 | 39 | 0 | 0 | 39 | 45.1723937 | -96.77002276 | 2020-08-24 04:27:56 | Grant, South Dakota, US |
2218526 | 2218526 | 2020-08-23 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-24 04:27:56 | Jerauld, South Dakota, US |
2302297 | 2302297 | 2020-08-22 | US | South Dakota | Grant | 46051 | 39 | 0 | 0 | 39 | 45.1723937 | -96.77002276 | 2020-08-23 04:27:48 | Grant, South Dakota, US |
2302308 | 2302308 | 2020-08-22 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-23 04:27:48 | Jerauld, South Dakota, US |
148806 | 148806 | 2020-08-15 | US | South Dakota | Custer | 46033 | 39 | 0 | 0 | 39 | 43.67741105 | -103.4534521 | 2020-08-16 04:27:42 | Custer, South Dakota, US |
1615066 | 1615066 | 2020-08-14 | US | South Dakota | Aurora | 46003 | 39 | 0 | 0 | 39 | 43.71757685 | -98.56050467 | 2020-08-15 04:27:31 | Aurora, South Dakota, US |
3610212 | 3610212 | 2020-08-06 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-07 04:35:11 | Jerauld, South Dakota, US |
3791042 | 3791042 | 2020-08-05 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-06 04:35:02 | Jerauld, South Dakota, US |
96280 | 96280 | 2020-08-04 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-05 04:34:43 | Jerauld, South Dakota, US |
2738163 | 2738163 | 2020-08-03 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-04 04:41:59 | Jerauld, South Dakota, US |
2805915 | 2805915 | 2020-08-02 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-08-03 04:34:35 | Jerauld, South Dakota, US |
1925206 | 1925206 | 2020-07-30 | US | South Dakota | Brule | 46015 | 39 | 0 | 0 | 39 | 43.71756379 | -99.08118954 | 2020-07-31 04:35:18 | Brule, South Dakota, US |
2563150 | 2563150 | 2020-07-24 | US | South Dakota | Turner | 46125 | 39 | 0 | 0 | 39 | 43.3109081 | -97.14865776 | 2020-07-25 04:47:39 | Turner, South Dakota, US |
2303847 | 2303847 | 2020-06-28 | US | South Dakota | Davison | 46035 | 39 | 0 | 0 | 39 | 43.67490933 | -98.14458906 | 2020-06-29 04:33:44 | Davison, South Dakota, US |
3680724 | 3680724 | 2020-06-18 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-19 04:33:17 | Jerauld, South Dakota, US |
3681152 | 3681152 | 2020-06-18 | US | South Dakota | Meade | 46093 | 40 | 1 | 0 | 39 | 44.56676791 | -102.7162741 | 2020-06-19 04:33:17 | Meade, South Dakota, US |
1192823 | 1192823 | 2020-06-17 | US | South Dakota | Brookings | 46011 | 39 | 0 | 0 | 39 | 44.36974375 | -96.79079945 | 2020-06-18 04:33:18 | Brookings, South Dakota, US |
1193928 | 1193928 | 2020-06-17 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-18 04:33:18 | Jerauld, South Dakota, US |
1194216 | 1194216 | 2020-06-17 | US | South Dakota | Lyman | 46085 | 39 | 0 | 0 | 39 | 43.89522709 | -99.85201878 | 2020-06-18 04:33:18 | Lyman, South Dakota, US |
2384692 | 2384692 | 2020-06-16 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-17 04:33:21 | Jerauld, South Dakota, US |
285254 | 285254 | 2020-06-15 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-16 04:33:09 | Jerauld, South Dakota, US |
1835208 | 1835208 | 2020-06-14 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-15 03:33:14 | Jerauld, South Dakota, US |
3059260 | 3059260 | 2020-06-13 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-14 03:33:15 | Jerauld, South Dakota, US |
734507 | 734507 | 2020-06-12 | US | South Dakota | Buffalo | 46017 | 39 | 0 | 0 | 39 | 44.07657829 | -99.20814467 | 2020-06-13 03:33:14 | Buffalo, South Dakota, US |
735582 | 735582 | 2020-06-12 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-13 03:33:14 | Jerauld, South Dakota, US |
1271560 | 1271560 | 2020-06-11 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-12 05:09:52 | Jerauld, South Dakota, US |
1272528 | 1272528 | 2020-06-11 | US | South Dakota | Roberts | 46109 | 39 | 0 | 0 | 39 | 45.62975048 | -96.94672673 | 2020-06-12 05:09:52 | Roberts, South Dakota, US |
2862005 | 2862005 | 2020-06-10 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-11 03:33:41 | Jerauld, South Dakota, US |
2862973 | 2862973 | 2020-06-10 | US | South Dakota | Roberts | 46109 | 39 | 0 | 0 | 39 | 45.62975048 | -96.94672673 | 2020-06-11 03:33:41 | Roberts, South Dakota, US |
1208035 | 1208035 | 2020-06-09 | US | South Dakota | Clay | 46027 | 39 | 0 | 0 | 39 | 42.91296147 | -96.97656917 | 2020-06-10 04:07:00 | Clay, South Dakota, US |
1208866 | 1208866 | 2020-06-09 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-10 04:07:00 | Jerauld, South Dakota, US |
1209833 | 1209833 | 2020-06-09 | US | South Dakota | Roberts | 46109 | 39 | 0 | 0 | 39 | 45.62975048 | -96.94672673 | 2020-06-10 04:07:00 | Roberts, South Dakota, US |
215294 | 215294 | 2020-06-08 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-09 03:33:03 | Jerauld, South Dakota, US |
215949 | 215949 | 2020-06-08 | US | South Dakota | Oglala Lakota | 46102 | 39 | 0 | 0 | 39 | 43.33749164 | -102.5555498 | 2020-06-09 03:33:03 | Oglala Lakota, South Dakota, US |
2798092 | 2798092 | 2020-06-07 | US | South Dakota | Jerauld | 46073 | 40 | 1 | 0 | 39 | 44.06637798 | -98.62965972 | 2020-06-08 03:33:22 | Jerauld, South Dakota, US |
2798747 | 2798747 | 2020-06-07 | US | South Dakota | Oglala Lakota | 46102 | 39 | 0 | 0 | 39 | 43.33749164 | -102.5555498 | 2020-06-08 03:33:22 | Oglala Lakota, South Dakota, US |
1267050 | 1267050 | 2020-06-05 | US | South Dakota | Codington | 46029 | 39 | 0 | 0 | 39 | 44.97788119 | -97.18827677 | 2020-06-06 02:33:00 | Codington, South Dakota, US |
1278534 | 1278534 | 2020-06-04 | US | South Dakota | Codington | 46029 | 39 | 0 | 0 | 39 | 44.97788119 | -97.18827677 | 2020-06-05 02:33:06 | Codington, South Dakota, US |
2711389 | 2711389 | 2020-05-28 | US | South Dakota | Roberts | 46109 | 39 | 0 | 0 | 39 | 45.62975048 | -96.94672673 | 2020-05-29 02:32:50 | Roberts, South Dakota, US |
2547410 | 2547410 | 2020-05-27 | US | South Dakota | Roberts | 46109 | 39 | 0 | 0 | 39 | 45.62975048 | -96.94672673 | 2020-05-28 02:32:31 | Roberts, South Dakota, US |
1403446 | 1403446 | 2020-05-14 | US | South Dakota | Pennington | 46103 | 40 | 1 | 0 | 39 | 44.0025835 | -102.8240777 | 2020-05-15 02:33:02 | Pennington, South Dakota, US |
225936 | 225936 | 2020-04-30 | US | South Dakota | Brown | 46013 | 39 | 0 | 0 | 39 | 45.58994323 | -98.35165355 | 2020-05-01 02:32:28 | Brown, South Dakota, US |
2565642 | 2565642 | 2020-04-11 | US | South Dakota | Lincoln | 46083 | 39 | 0 | 0 | 39 | 43.27841182 | -96.72039050000001 | 2020-04-11 22:45:33 | Lincoln, South Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);