johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,362 rows where province_or_state = "South Dakota" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3239 | 3239 | 2021-12-02 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-12-03 04:23:05 | Unassigned, South Dakota, US | |
7254 | 7254 | 2021-10-28 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-10-29 04:22:03 | Unassigned, South Dakota, US | |
11226 | 11226 | 2020-10-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-10-26 04:25:02 | Unassigned, South Dakota, US |
15239 | 15239 | 2021-01-26 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-01-27 05:23:41 | Unassigned, South Dakota, US |
19261 | 19261 | 2021-09-18 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-09-19 04:21:34 | Unassigned, South Dakota, US | |
23272 | 23272 | 2021-05-28 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-05-29 04:20:41 | Unassigned, South Dakota, US | |
27310 | 27310 | 2022-03-20 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-03-21 04:20:50 | Unassigned, South Dakota, US | |
31325 | 31325 | 2021-11-11 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-12 04:22:01 | Unassigned, South Dakota, US | |
35321 | 35321 | 2021-08-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-08-26 04:21:28 | Unassigned, South Dakota, US | |
39331 | 39331 | 2021-04-12 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-04-13 04:20:37 | Unassigned, South Dakota, US | |
40623 | 40623 | 2020-04-13 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-04-13 23:07:54 | Butte, South Dakota, US |
41619 | 41619 | 2020-04-13 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-04-13 23:07:54 | Kingsbury, South Dakota, US |
42809 | 42809 | 2020-04-13 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-04-13 23:07:54 | Unassigned, South Dakota, US |
46617 | 46617 | 2021-11-02 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-03 06:22:09 | Unassigned, South Dakota, US | |
47649 | 47649 | 2020-04-17 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-04-17 23:30:52 | Brule, South Dakota, US |
47684 | 47684 | 2020-04-17 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-04-17 23:30:52 | Butte, South Dakota, US |
48688 | 48688 | 2020-04-17 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-04-17 23:30:52 | Kingsbury, South Dakota, US |
49902 | 49902 | 2020-04-17 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-04-17 23:30:52 | Unassigned, South Dakota, US |
53693 | 53693 | 2021-05-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-05-30 04:20:55 | Unassigned, South Dakota, US | |
57704 | 57704 | 2021-03-07 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-03-08 05:24:48 | Unassigned, South Dakota, US | |
61436 | 61436 | 2020-07-23 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-07-24 05:30:40 | Unassigned, South Dakota, US |
65975 | 65975 | 2022-11-12 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-11-13 04:21:14 | Unassigned, South Dakota, US | |
69966 | 69966 | 2021-09-01 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-09-02 04:21:15 | Unassigned, South Dakota, US | |
74000 | 74000 | 2022-02-07 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-02-08 04:21:15 | Unassigned, South Dakota, US | |
77986 | 77986 | 2020-12-03 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-12-04 05:27:27 | Unassigned, South Dakota, US |
81980 | 81980 | 2020-10-14 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-10-15 04:24:28 | Unassigned, South Dakota, US |
85996 | 85996 | 2021-05-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-05-26 04:20:35 | Unassigned, South Dakota, US | |
90034 | 90034 | 2021-11-09 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-10 04:21:38 | Unassigned, South Dakota, US | |
94052 | 94052 | 2022-07-23 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-07-24 04:20:47 | Unassigned, South Dakota, US | |
97765 | 97765 | 2020-08-04 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-08-05 04:34:43 | Unassigned, South Dakota, US |
102235 | 102235 | 2022-01-14 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-01-15 04:21:07 | Unassigned, South Dakota, US | |
106231 | 106231 | 2021-08-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-08-16 04:21:31 | Unassigned, South Dakota, US | |
110355 | 110355 | 2021-06-19 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-06-20 04:21:48 | Unassigned, South Dakota, US | |
111418 | 111418 | 2020-05-08 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-05-09 02:32:35 | Brule, South Dakota, US |
111455 | 111455 | 2020-05-08 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-05-09 02:32:35 | Butte, South Dakota, US |
112538 | 112538 | 2020-05-08 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-05-09 02:32:35 | Kingsbury, South Dakota, US |
113824 | 113824 | 2020-05-08 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-05-09 02:32:35 | Unassigned, South Dakota, US |
117662 | 117662 | 2022-09-06 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-09-07 04:20:59 | Unassigned, South Dakota, US | |
121360 | 121360 | 2020-07-19 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-07-20 05:34:40 | Unassigned, South Dakota, US |
125601 | 125601 | 2020-11-18 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-11-19 05:25:23 | Unassigned, South Dakota, US |
129642 | 129642 | 2022-01-09 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-01-10 04:22:07 | Unassigned, South Dakota, US | |
133663 | 133663 | 2022-10-04 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-10-05 04:23:06 | Unassigned, South Dakota, US | |
134693 | 134693 | 2020-04-29 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-04-30 02:32:27 | Brule, South Dakota, US |
134730 | 134730 | 2020-04-29 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-04-30 02:32:27 | Butte, South Dakota, US |
135785 | 135785 | 2020-04-29 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-04-30 02:32:27 | Kingsbury, South Dakota, US |
137052 | 137052 | 2020-04-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-04-30 02:32:27 | Unassigned, South Dakota, US |
140880 | 140880 | 2021-12-04 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-12-05 04:22:25 | Unassigned, South Dakota, US | |
144898 | 144898 | 2022-07-09 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-07-10 04:20:54 | Unassigned, South Dakota, US | |
148853 | 148853 | 2020-08-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-08-16 04:27:42 | Unassigned, South Dakota, US |
152893 | 152893 | 2021-11-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-30 04:22:53 | Unassigned, South Dakota, US | |
156880 | 156880 | 2021-01-08 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-01-09 05:22:18 | Unassigned, South Dakota, US |
160922 | 160922 | 2022-03-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-03-30 04:20:45 | Unassigned, South Dakota, US | |
164937 | 164937 | 2021-11-19 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-20 04:22:17 | Unassigned, South Dakota, US | |
168955 | 168955 | 2022-06-21 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-06-22 04:20:54 | Unassigned, South Dakota, US | |
172945 | 172945 | 2021-04-16 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-04-17 04:20:40 | Unassigned, South Dakota, US | |
176676 | 176676 | 2020-07-27 | US | South Dakota | Unassigned | 90046 | 0 | 1 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-07-28 04:58:43 | Unassigned, South Dakota, US |
180931 | 180931 | 2021-09-02 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-09-03 04:21:20 | Unassigned, South Dakota, US | |
184939 | 184939 | 2021-02-21 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-02-22 05:24:21 | Unassigned, South Dakota, US |
188980 | 188980 | 2022-02-13 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-02-14 04:20:51 | Unassigned, South Dakota, US | |
192966 | 192966 | 2021-01-11 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-01-12 05:22:15 | Unassigned, South Dakota, US |
196957 | 196957 | 2020-08-31 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-09-01 04:28:31 | Unassigned, South Dakota, US |
201172 | 201172 | 2022-10-19 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-10-20 04:22:59 | Unassigned, South Dakota, US | |
205153 | 205153 | 2020-12-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-12-26 05:22:28 | Unassigned, South Dakota, US |
209139 | 209139 | 2020-08-19 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-08-20 04:27:43 | Unassigned, South Dakota, US |
213135 | 213135 | 2020-10-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-10-30 04:24:49 | Unassigned, South Dakota, US |
214251 | 214251 | 2020-06-08 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-06-09 03:33:03 | Butte, South Dakota, US |
216687 | 216687 | 2020-06-08 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-06-09 03:33:03 | Unassigned, South Dakota, US |
220893 | 220893 | 2022-12-26 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-12-27 04:21:07 | Unassigned, South Dakota, US | |
224905 | 224905 | 2022-05-09 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-05-10 04:20:50 | Unassigned, South Dakota, US | |
225939 | 225939 | 2020-04-30 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-05-01 02:32:28 | Brule, South Dakota, US |
225976 | 225976 | 2020-04-30 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-05-01 02:32:28 | Butte, South Dakota, US |
227037 | 227037 | 2020-04-30 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-05-01 02:32:28 | Kingsbury, South Dakota, US |
228304 | 228304 | 2020-04-30 | US | South Dakota | Unassigned | 90046 | 0 | 4 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-05-01 02:32:28 | Unassigned, South Dakota, US |
232137 | 232137 | 2022-05-31 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-06-01 04:20:55 | Unassigned, South Dakota, US | |
236152 | 236152 | 2022-02-11 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-02-12 04:21:06 | Unassigned, South Dakota, US | |
240139 | 240139 | 2021-01-18 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-01-19 05:22:15 | Unassigned, South Dakota, US |
244156 | 244156 | 2021-04-02 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-04-03 04:20:44 | Unassigned, South Dakota, US | |
248174 | 248174 | 2021-08-17 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-08-18 04:21:35 | Unassigned, South Dakota, US | |
252188 | 252188 | 2021-09-04 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-09-05 04:21:33 | Unassigned, South Dakota, US | |
256224 | 256224 | 2022-09-08 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-09-09 04:21:11 | Unassigned, South Dakota, US | |
260243 | 260243 | 2022-12-10 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-12-11 04:20:50 | Unassigned, South Dakota, US | |
264442 | 264442 | 2022-03-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-03-16 04:20:50 | Unassigned, South Dakota, US | |
265491 | 265491 | 2020-05-21 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-05-22 02:36:51 | Brule, South Dakota, US |
265529 | 265529 | 2020-05-21 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-05-22 02:36:51 | Butte, South Dakota, US |
265950 | 265950 | 2020-05-21 | US | South Dakota | Dewey | 46041 | 0 | 0 | 0 | 0 | 45.15639647 | -100.8709139 | 2020-05-22 02:36:51 | Dewey, South Dakota, US |
266622 | 266622 | 2020-05-21 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-05-22 02:36:51 | Kingsbury, South Dakota, US |
267927 | 267927 | 2020-05-21 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-05-22 02:36:51 | Unassigned, South Dakota, US |
268912 | 268912 | 2020-04-28 | US | South Dakota | Brule | 46015 | 0 | 0 | 0 | 0 | 43.71756379 | -99.08118954 | 2020-04-29 02:32:29 | Brule, South Dakota, US |
268949 | 268949 | 2020-04-28 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-04-29 02:32:29 | Butte, South Dakota, US |
269323 | 269323 | 2020-04-28 | US | South Dakota | Day | 46037 | 0 | 0 | 0 | 0 | 45.367281 | -97.60737498 | 2020-04-29 02:32:29 | Day, South Dakota, US |
270002 | 270002 | 2020-04-28 | US | South Dakota | Kingsbury | 46077 | 0 | 0 | 0 | 0 | 44.36956169 | -97.4913945 | 2020-04-29 02:32:29 | Kingsbury, South Dakota, US |
271266 | 271266 | 2020-04-28 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-04-29 02:32:29 | Unassigned, South Dakota, US |
275051 | 275051 | 2020-11-10 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-11-11 05:25:30 | Unassigned, South Dakota, US |
279092 | 279092 | 2021-11-03 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-04 04:22:20 | Unassigned, South Dakota, US | |
283082 | 283082 | 2021-02-24 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-02-25 05:24:57 | Unassigned, South Dakota, US |
284202 | 284202 | 2020-06-15 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-06-16 04:33:09 | Butte, South Dakota, US |
286661 | 286661 | 2020-06-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-06-16 04:33:09 | Unassigned, South Dakota, US |
290904 | 290904 | 2021-10-31 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-11-01 04:22:01 | Unassigned, South Dakota, US | |
294926 | 294926 | 2022-11-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2022-11-16 04:21:09 | Unassigned, South Dakota, US | |
298917 | 298917 | 2021-07-15 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-07-16 04:21:22 | Unassigned, 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]);