johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Emilia-Romagna" sorted by combined_key descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, 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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
296 | 296 | 2021-12-02 | Italy | Emilia-Romagna | 458504 | 13803 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-03 04:23:05 | Emilia-Romagna, Italy | |||
4312 | 4312 | 2021-10-28 | Italy | Emilia-Romagna | 431067 | 13583 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-29 04:22:03 | Emilia-Romagna, Italy | |||
8314 | 8314 | 2020-10-25 | Italy | Emilia-Romagna | 46734 | 4561 | 27345 | 14828 | 44.49436681 | 11.3417208 | 2020-10-26 04:25:02 | Emilia-Romagna, Italy | ||
12322 | 12322 | 2021-01-26 | Italy | Emilia-Romagna | 212590 | 9270 | 154178 | 49142 | 44.49436681 | 11.3417208 | 2021-01-27 05:23:41 | Emilia-Romagna, Italy | ||
16337 | 16337 | 2021-09-18 | Italy | Emilia-Romagna | 420118 | 13432 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-19 04:21:34 | Emilia-Romagna, Italy | |||
20352 | 20352 | 2021-05-28 | Italy | Emilia-Romagna | 383282 | 13174 | 353718 | 16390 | 44.49436681 | 11.3417208 | 2021-05-29 04:20:41 | Emilia-Romagna, Italy | ||
24367 | 24367 | 2022-03-20 | Italy | Emilia-Romagna | 1239281 | 16150 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-21 04:20:50 | Emilia-Romagna, Italy | |||
28382 | 28382 | 2021-11-11 | Italy | Emilia-Romagna | 437457 | 13644 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-12 04:22:01 | Emilia-Romagna, Italy | |||
32398 | 32398 | 2021-08-25 | Italy | Emilia-Romagna | 408320 | 13334 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-26 04:21:28 | Emilia-Romagna, Italy | |||
36412 | 36412 | 2021-04-12 | Italy | Emilia-Romagna | 352131 | 12411 | 273287 | 66433 | 44.49436681 | 11.3417208 | 2021-04-13 04:20:37 | Emilia-Romagna, Italy | ||
43674 | 43674 | 2021-11-02 | Italy | Emilia-Romagna | 433011 | 13603 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-03 06:22:09 | Emilia-Romagna, Italy | |||
50773 | 50773 | 2021-05-29 | Italy | Emilia-Romagna | 383503 | 13180 | 354260 | 16063 | 44.49436681 | 11.3417208 | 2021-05-30 04:20:55 | Emilia-Romagna, Italy | ||
54787 | 54787 | 2021-03-07 | Italy | Emilia-Romagna | 279646 | 10777 | 213934 | 54935 | 44.49436681 | 11.3417208 | 2021-03-08 05:24:48 | Emilia-Romagna, Italy | ||
61854 | 61854 | 2020-07-23 | Italy | Emilia-Romagna | 29350 | 4281 | 23719 | 1350 | 44.49436681 | 11.341720800000001 | 2020-07-24 05:30:40 | Emilia-Romagna, Italy | ||
63028 | 63028 | 2022-11-12 | Italy | Emilia-Romagna | 1981780 | 18333 | 0 | 44.49436681 | 11.3417208 | 2022-11-13 04:21:14 | Emilia-Romagna, Italy | |||
67043 | 67043 | 2021-09-01 | Italy | Emilia-Romagna | 412269 | 13372 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-02 04:21:15 | Emilia-Romagna, Italy | |||
71057 | 71057 | 2022-02-07 | Italy | Emilia-Romagna | 1112384 | 15358 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-08 04:21:15 | Emilia-Romagna, Italy | |||
75071 | 75071 | 2020-12-03 | Italy | Emilia-Romagna | 127870 | 5959 | 51674 | 70237 | 44.49436681 | 11.3417208 | 2020-12-04 05:27:27 | Emilia-Romagna, Italy | ||
79070 | 79070 | 2020-10-14 | Italy | Emilia-Romagna | 38695 | 4502 | 27045 | 7148 | 44.49436681 | 11.3417208 | 2020-10-15 04:24:28 | Emilia-Romagna, Italy | ||
83077 | 83077 | 2021-05-25 | Italy | Emilia-Romagna | 382544 | 13163 | 351559 | 17822 | 44.49436681 | 11.3417208 | 2021-05-26 04:20:35 | Emilia-Romagna, Italy | ||
87091 | 87091 | 2021-11-09 | Italy | Emilia-Romagna | 436293 | 13629 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-10 04:21:38 | Emilia-Romagna, Italy | |||
91108 | 91108 | 2022-07-23 | Italy | Emilia-Romagna | 1724270 | 17359 | 0 | 44.49436681 | 11.3417208 | 2022-07-24 04:20:47 | Emilia-Romagna, Italy | |||
98194 | 98194 | 2020-08-04 | Italy | Emilia-Romagna | 29850 | 4291 | 23978 | 1581 | 44.49436681 | 11.3417208 | 2020-08-05 04:34:43 | Emilia-Romagna, Italy | ||
99292 | 99292 | 2022-01-14 | Italy | Emilia-Romagna | 771295 | 14510 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-15 04:21:07 | Emilia-Romagna, Italy | |||
103308 | 103308 | 2021-08-15 | Italy | Emilia-Romagna | 403150 | 13300 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-16 04:21:31 | Emilia-Romagna, Italy | |||
107433 | 107433 | 2021-06-19 | Italy | Emilia-Romagna | 386192 | 13245 | 367185 | 5762 | 44.49436681 | 11.3417208 | 2021-06-20 04:21:48 | Emilia-Romagna, Italy | ||
114718 | 114718 | 2022-09-06 | Italy | Emilia-Romagna | 1829133 | 17925 | 0 | 44.49436681 | 11.3417208 | 2022-09-07 04:20:59 | Emilia-Romagna, Italy | |||
121787 | 121787 | 2020-07-19 | Italy | Emilia-Romagna | 29178 | 4274 | 23638 | 1266 | 44.49436681 | 11.341720800000001 | 2020-07-20 05:34:40 | Emilia-Romagna, Italy | ||
122686 | 122686 | 2020-11-18 | Italy | Emilia-Romagna | 95654 | 5168 | 31167 | 59319 | 44.49436681 | 11.3417208 | 2020-11-19 05:25:23 | Emilia-Romagna, Italy | ||
126699 | 126699 | 2022-01-09 | Italy | Emilia-Romagna | 676931 | 14378 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-10 04:22:07 | Emilia-Romagna, Italy | |||
130716 | 130716 | 2022-10-04 | Italy | Emilia-Romagna | 1875894 | 18044 | 0 | 44.49436681 | 11.3417208 | 2022-10-05 04:23:06 | Emilia-Romagna, Italy | |||
137937 | 137937 | 2021-12-04 | Italy | Emilia-Romagna | 461740 | 13822 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-05 04:22:25 | Emilia-Romagna, Italy | |||
141954 | 141954 | 2022-07-09 | Italy | Emilia-Romagna | 1632663 | 17177 | 0 | 44.49436681 | 11.3417208 | 2022-07-10 04:20:54 | Emilia-Romagna, Italy | |||
145954 | 145954 | 2020-08-15 | Italy | Emilia-Romagna | 30385 | 4453 | 24178 | 1754 | 44.49436681 | 11.3417208 | 2020-08-16 04:27:42 | Emilia-Romagna, Italy | ||
149950 | 149950 | 2021-11-29 | Italy | Emilia-Romagna | 454850 | 13781 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-30 04:22:53 | Emilia-Romagna, Italy | |||
153965 | 153965 | 2021-01-08 | Italy | Emilia-Romagna | 186913 | 8210 | 121855 | 56848 | 44.49436681 | 11.3417208 | 2021-01-09 05:22:18 | Emilia-Romagna, Italy | ||
157979 | 157979 | 2022-03-29 | Italy | Emilia-Romagna | 1271569 | 16239 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-30 04:20:45 | Emilia-Romagna, Italy | |||
161994 | 161994 | 2021-11-19 | Italy | Emilia-Romagna | 443434 | 13696 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-20 04:22:17 | Emilia-Romagna, Italy | |||
166011 | 166011 | 2022-06-21 | Italy | Emilia-Romagna | 1528629 | 17045 | 0 | 44.49436681 | 11.3417208 | 2022-06-22 04:20:54 | Emilia-Romagna, Italy | |||
170026 | 170026 | 2021-04-16 | Italy | Emilia-Romagna | 356159 | 12557 | 279482 | 64120 | 44.49436681 | 11.3417208 | 2021-04-17 04:20:40 | Emilia-Romagna, Italy | ||
177105 | 177105 | 2020-07-27 | Italy | Emilia-Romagna | 29555 | 4285 | 23814 | 1456 | 44.49436681 | 11.3417208 | 2020-07-28 04:58:43 | Emilia-Romagna, Italy | ||
178008 | 178008 | 2021-09-02 | Italy | Emilia-Romagna | 412791 | 13372 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-03 04:21:20 | Emilia-Romagna, Italy | |||
182022 | 182022 | 2021-02-21 | Italy | Emilia-Romagna | 246020 | 10345 | 199647 | 36028 | 44.49436681 | 11.3417208 | 2021-02-22 05:24:21 | Emilia-Romagna, Italy | ||
186037 | 186037 | 2022-02-13 | Italy | Emilia-Romagna | 1144576 | 15560 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-14 04:20:51 | Emilia-Romagna, Italy | |||
190051 | 190051 | 2021-01-11 | Italy | Emilia-Romagna | 192832 | 8403 | 122963 | 61466 | 44.49436681 | 11.3417208 | 2021-01-12 05:22:15 | Emilia-Romagna, Italy | ||
194049 | 194049 | 2020-08-31 | Italy | Emilia-Romagna | 31922 | 4463 | 24482 | 2977 | 44.49436681 | 11.3417208 | 2020-09-01 04:28:31 | Emilia-Romagna, Italy | ||
198225 | 198225 | 2022-10-19 | Italy | Emilia-Romagna | 1929820 | 18146 | 0 | 44.49436681 | 11.3417208 | 2022-10-20 04:22:59 | Emilia-Romagna, Italy | |||
202238 | 202238 | 2020-12-25 | Italy | Emilia-Romagna | 163290 | 7400 | 96910 | 58980 | 44.49436681 | 11.3417208 | 2020-12-26 05:22:28 | Emilia-Romagna, Italy | ||
206236 | 206236 | 2020-08-19 | Italy | Emilia-Romagna | 30574 | 4455 | 24324 | 1795 | 44.49436681 | 11.3417208 | 2020-08-20 04:27:43 | Emilia-Romagna, Italy | ||
210222 | 210222 | 2020-10-29 | Italy | Emilia-Romagna | 52038 | 4601 | 27724 | 19713 | 44.49436681 | 11.3417208 | 2020-10-30 04:24:49 | Emilia-Romagna, Italy | ||
217088 | 217088 | 2020-06-08 | Italy | Emilia-Romagna | 27928 | 4179 | 21467 | 2282 | 44.49436681 | 11.3417208 | 2020-06-09 03:33:03 | Emilia-Romagna, Italy | ||
217946 | 217946 | 2022-12-26 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-27 04:21:07 | Emilia-Romagna, Italy | |||
221962 | 221962 | 2022-05-09 | Italy | Emilia-Romagna | 1440297 | 16722 | 0 | 44.49436681 | 11.3417208 | 2022-05-10 04:20:50 | Emilia-Romagna, Italy | |||
229193 | 229193 | 2022-05-31 | Italy | Emilia-Romagna | 1486838 | 16940 | 0 | 44.49436681 | 11.3417208 | 2022-06-01 04:20:55 | Emilia-Romagna, Italy | |||
233209 | 233209 | 2022-02-11 | Italy | Emilia-Romagna | 1135689 | 15505 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-12 04:21:06 | Emilia-Romagna, Italy | |||
237223 | 237223 | 2021-01-18 | Italy | Emilia-Romagna | 203141 | 8797 | 140114 | 54230 | 44.49436681 | 11.3417208 | 2021-01-19 05:22:15 | Emilia-Romagna, Italy | ||
241237 | 241237 | 2021-04-02 | Italy | Emilia-Romagna | 339440 | 12040 | 254151 | 73249 | 44.49436681 | 11.3417208 | 2021-04-03 04:20:44 | Emilia-Romagna, Italy | ||
245251 | 245251 | 2021-08-17 | Italy | Emilia-Romagna | 404078 | 13309 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-18 04:21:35 | Emilia-Romagna, Italy | |||
249265 | 249265 | 2021-09-04 | Italy | Emilia-Romagna | 414052 | 13376 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-05 04:21:33 | Emilia-Romagna, Italy | |||
253280 | 253280 | 2022-09-08 | Italy | Emilia-Romagna | 1832191 | 17939 | 0 | 44.49436681 | 11.3417208 | 2022-09-09 04:21:11 | Emilia-Romagna, Italy | |||
257296 | 257296 | 2022-12-10 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-11 04:20:50 | Emilia-Romagna, Italy | |||
261499 | 261499 | 2022-03-15 | Italy | Emilia-Romagna | 1219922 | 16101 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-16 04:20:50 | Emilia-Romagna, Italy | |||
268274 | 268274 | 2020-05-21 | Italy | Emilia-Romagna | 27417 | 4025 | 18466 | 4926 | 44.49436681 | 11.3417208 | 2020-05-22 02:36:51 | Emilia-Romagna, Italy | ||
272137 | 272137 | 2020-11-10 | Italy | Emilia-Romagna | 75855 | 4845 | 29230 | 41780 | 44.49436681 | 11.3417208 | 2020-11-11 05:25:30 | Emilia-Romagna, Italy | ||
276149 | 276149 | 2021-11-03 | Italy | Emilia-Romagna | 433233 | 13608 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-04 04:22:20 | Emilia-Romagna, Italy | |||
280165 | 280165 | 2021-02-24 | Italy | Emilia-Romagna | 250839 | 10426 | 203642 | 36771 | 44.49436681 | 11.3417208 | 2021-02-25 05:24:57 | Emilia-Romagna, Italy | ||
287075 | 287075 | 2020-06-15 | Italy | Emilia-Romagna | 28084 | 4207 | 22377 | 1500 | 44.49436681 | 11.341720800000001 | 2020-06-16 04:33:09 | Emilia-Romagna, Italy | ||
287962 | 287962 | 2021-10-31 | Italy | Emilia-Romagna | 432274 | 13595 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-01 04:22:01 | Emilia-Romagna, Italy | |||
291979 | 291979 | 2022-11-15 | Italy | Emilia-Romagna | 1981780 | 18333 | 0 | 44.49436681 | 11.3417208 | 2022-11-16 04:21:09 | Emilia-Romagna, Italy | |||
295994 | 295994 | 2021-07-15 | Italy | Emilia-Romagna | 388073 | 13268 | 372548 | 2257 | 44.49436681 | 11.3417208 | 2021-07-16 04:21:22 | Emilia-Romagna, Italy | ||
302947 | 302947 | 2020-07-01 | Italy | Emilia-Romagna | 28508 | 4264 | 23242 | 1002 | 44.49436681 | 11.341720800000001 | 2020-07-02 04:33:46 | Emilia-Romagna, Italy | ||
303835 | 303835 | 2022-04-16 | Italy | Emilia-Romagna | 1352490 | 16451 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-17 04:20:59 | Emilia-Romagna, Italy | |||
307851 | 307851 | 2022-12-13 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-14 04:21:04 | Emilia-Romagna, Italy | |||
311867 | 311867 | 2022-11-13 | Italy | Emilia-Romagna | 1981780 | 18333 | 0 | 44.49436681 | 11.3417208 | 2022-11-14 04:21:09 | Emilia-Romagna, Italy | |||
315883 | 315883 | 2022-02-12 | Italy | Emilia-Romagna | 1140182 | 15531 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-13 04:21:00 | Emilia-Romagna, Italy | |||
319899 | 319899 | 2022-10-30 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-10-31 04:21:36 | Emilia-Romagna, Italy | |||
326882 | 326882 | 2020-07-20 | Italy | Emilia-Romagna | 29220 | 4277 | 23645 | 1298 | 44.49436681 | 11.341720800000001 | 2020-07-21 04:38:46 | Emilia-Romagna, Italy | ||
327873 | 327873 | 2022-12-27 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-28 04:21:04 | Emilia-Romagna, Italy | |||
331888 | 331888 | 2021-08-04 | Italy | Emilia-Romagna | 396341 | 13286 | 374451 | 8604 | 44.49436681 | 11.3417208 | 2021-08-05 04:21:51 | Emilia-Romagna, Italy | ||
335903 | 335903 | 2022-03-18 | Italy | Emilia-Romagna | 1231488 | 16138 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-19 04:20:47 | Emilia-Romagna, Italy | |||
340257 | 340257 | 2021-02-03 | Italy | Emilia-Romagna | 221615 | 9657 | 167556 | 44402 | 44.49436681 | 11.3417208 | 2021-02-04 05:22:26 | Emilia-Romagna, Italy | ||
344257 | 344257 | 2020-09-14 | Italy | Emilia-Romagna | 33631 | 4469 | 25098 | 4064 | 44.49436681 | 11.3417208 | 2020-09-15 03:22:50 | Emilia-Romagna, Italy | ||
348263 | 348263 | 2022-12-14 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-15 04:20:58 | Emilia-Romagna, Italy | |||
352278 | 352278 | 2021-03-11 | Italy | Emilia-Romagna | 289957 | 10959 | 218332 | 60666 | 44.49436681 | 11.3417208 | 2021-03-12 05:26:50 | Emilia-Romagna, Italy | ||
356293 | 356293 | 2022-03-11 | Italy | Emilia-Romagna | 1210197 | 16058 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-12 04:20:50 | Emilia-Romagna, Italy | |||
360309 | 360309 | 2022-05-07 | Italy | Emilia-Romagna | 1435126 | 16712 | 0 | 44.49436681 | 11.3417208 | 2022-05-08 04:20:49 | Emilia-Romagna, Italy | |||
367296 | 367296 | 2020-07-16 | Italy | Emilia-Romagna | 29035 | 4271 | 23566 | 1198 | 44.49436681 | 11.3417208 | 2020-07-17 04:34:50 | Emilia-Romagna, Italy | ||
371259 | 371259 | 2020-08-08 | Italy | Emilia-Romagna | 30052 | 4294 | 24046 | 1712 | 44.49436681 | 11.3417208 | 2020-08-09 04:34:54 | Emilia-Romagna, Italy | ||
372163 | 372163 | 2022-09-13 | Italy | Emilia-Romagna | 1836555 | 17957 | 0 | 44.49436681 | 11.3417208 | 2022-09-14 04:20:44 | Emilia-Romagna, Italy | |||
376164 | 376164 | 2020-11-06 | Italy | Emilia-Romagna | 67041 | 4752 | 28559 | 33730 | 44.49436681 | 11.3417208 | 2020-11-07 05:24:52 | Emilia-Romagna, Italy | ||
380175 | 380175 | 2021-04-30 | Italy | Emilia-Romagna | 369250 | 12876 | 312018 | 44356 | 44.49436681 | 11.3417208 | 2021-05-01 04:20:47 | Emilia-Romagna, Italy | ||
384190 | 384190 | 2022-09-23 | Italy | Emilia-Romagna | 1850155 | 18006 | 0 | 44.49436681 | 11.3417208 | 2022-09-24 04:21:40 | Emilia-Romagna, Italy | |||
388205 | 388205 | 2021-04-04 | Italy | Emilia-Romagna | 342915 | 12113 | 258614 | 72188 | 44.49436681 | 11.3417208 | 2021-04-05 04:20:35 | Emilia-Romagna, Italy | ||
392217 | 392217 | 2020-11-27 | Italy | Emilia-Romagna | 117019 | 5614 | 41116 | 70289 | 44.49436681 | 11.3417208 | 2020-11-28 05:25:50 | Emilia-Romagna, Italy | ||
396231 | 396231 | 2022-10-07 | Italy | Emilia-Romagna | 1888389 | 18062 | 0 | 44.49436681 | 11.3417208 | 2022-10-08 04:22:56 | Emilia-Romagna, Italy | |||
400246 | 400246 | 2021-06-29 | Italy | Emilia-Romagna | 386791 | 13261 | 370254 | 3276 | 44.49436681 | 11.3417208 | 2021-06-30 04:21:41 | Emilia-Romagna, Italy | ||
404260 | 404260 | 2021-12-07 | Italy | Emilia-Romagna | 466182 | 13851 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-08 04:22:46 | Emilia-Romagna, Italy | |||
408276 | 408276 | 2021-07-28 | Italy | Emilia-Romagna | 392602 | 13281 | 373699 | 5622 | 44.49436681 | 11.3417208 | 2021-07-29 04:21:33 | Emilia-Romagna, Italy | ||
415239 | 415239 | 2020-07-05 | Italy | Emilia-Romagna | 28637 | 4268 | 23340 | 1029 | 44.49436681 | 11.341720800000001 | 2020-07-06 04:33:57 | Emilia-Romagna, Italy | ||
419302 | 419302 | 2022-09-18 | Italy | Emilia-Romagna | 1843830 | 17981 | 0 | 44.49436681 | 11.3417208 | 2022-09-19 04:21:49 | Emilia-Romagna, Italy |
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]);