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 latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
833594 | 833594 | 2022-12-02 | Italy | Emilia-Romagna | 2045976 | 18531 | 0 | 44.49436681 | 11.3417208 | 2022-12-03 04:21:02 | Emilia-Romagna, Italy | |||
837594 | 837594 | 2020-08-17 | Italy | Emilia-Romagna | 30477 | 4453 | 24210 | 1814 | 44.49436681 | 11.3417208 | 2020-08-18 04:27:56 | Emilia-Romagna, Italy | ||
844652 | 844652 | 2020-07-22 | Italy | Emilia-Romagna | 29295 | 4281 | 23689 | 1325 | 44.49436681 | 11.3417208 | 2020-07-23 05:15:04 | Emilia-Romagna, Italy | ||
845552 | 845552 | 2020-12-12 | Italy | Emilia-Romagna | 142816 | 6529 | 72315 | 63972 | 44.49436681 | 11.3417208 | 2020-12-13 05:27:20 | Emilia-Romagna, Italy | ||
849566 | 849566 | 2022-11-02 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-11-03 04:22:05 | Emilia-Romagna, Italy | |||
853582 | 853582 | 2022-09-30 | Italy | Emilia-Romagna | 1865577 | 18032 | 0 | 44.49436681 | 11.3417208 | 2022-10-01 04:23:01 | Emilia-Romagna, Italy | |||
860659 | 860659 | 2020-12-11 | Italy | Emilia-Romagna | 141010 | 6447 | 70508 | 64055 | 44.49436681 | 11.3417208 | 2020-12-12 05:26:19 | Emilia-Romagna, Italy | ||
864752 | 864752 | 2020-11-12 | Italy | Emilia-Romagna | 80684 | 4925 | 29735 | 46024 | 44.49436681 | 11.3417208 | 2020-11-13 05:25:30 | Emilia-Romagna, Italy | ||
868766 | 868766 | 2022-12-11 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-12 04:21:01 | Emilia-Romagna, Italy | |||
875554 | 875554 | 2020-05-24 | Italy | Emilia-Romagna | 27558 | 4055 | 19046 | 4457 | 44.49436681 | 11.3417208 | 2020-05-25 02:32:44 | Emilia-Romagna, Italy | ||
876231 | 876231 | 2022-03-27 | Italy | Emilia-Romagna | 1265354 | 16223 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-28 04:20:33 | Emilia-Romagna, Italy | |||
880247 | 880247 | 2022-08-05 | Italy | Emilia-Romagna | 1775610 | 17586 | 0 | 44.49436681 | 11.3417208 | 2022-08-06 04:20:56 | Emilia-Romagna, Italy | |||
887214 | 887214 | 2020-07-07 | Italy | Emilia-Romagna | 28706 | 4269 | 23377 | 1060 | 44.49436681 | 11.341720800000001 | 2020-07-08 05:33:48 | Emilia-Romagna, Italy | ||
888102 | 888102 | 2021-04-26 | Italy | Emilia-Romagna | 365715 | 12801 | 304391 | 48523 | 44.49436681 | 11.3417208 | 2021-04-27 04:20:52 | Emilia-Romagna, Italy | ||
892102 | 892102 | 2020-11-05 | Italy | Emilia-Romagna | 65091 | 4712 | 28403 | 31976 | 44.49436681 | 11.3417208 | 2020-11-06 05:24:55 | Emilia-Romagna, Italy | ||
896114 | 896114 | 2022-07-24 | Italy | Emilia-Romagna | 1728701 | 17360 | 0 | 44.49436681 | 11.3417208 | 2022-07-25 04:20:51 | Emilia-Romagna, Italy | |||
900130 | 900130 | 2022-07-22 | Italy | Emilia-Romagna | 1719104 | 17348 | 0 | 44.49436681 | 11.3417208 | 2022-07-23 04:20:53 | Emilia-Romagna, Italy | |||
904145 | 904145 | 2021-11-24 | Italy | Emilia-Romagna | 448368 | 13733 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-25 04:22:33 | Emilia-Romagna, Italy | |||
908160 | 908160 | 2021-01-19 | Italy | Emilia-Romagna | 204174 | 8872 | 142061 | 53241 | 44.49436681 | 11.3417208 | 2021-01-20 05:21:54 | Emilia-Romagna, Italy | ||
912175 | 912175 | 2022-10-29 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-10-30 04:22:14 | Emilia-Romagna, Italy | |||
919651 | 919651 | 2022-03-08 | Italy | Emilia-Romagna | 1202206 | 16021 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-09 04:20:59 | Emilia-Romagna, Italy | |||
923664 | 923664 | 2020-11-26 | Italy | Emilia-Romagna | 114855 | 5548 | 37835 | 71472 | 44.49436681 | 11.3417208 | 2020-11-27 05:26:53 | Emilia-Romagna, Italy | ||
927675 | 927675 | 2020-12-21 | Italy | Emilia-Romagna | 157185 | 7120 | 88011 | 62054 | 44.49436681 | 11.3417208 | 2020-12-22 05:22:33 | Emilia-Romagna, Italy | ||
934767 | 934767 | 2021-10-16 | Italy | Emilia-Romagna | 427626 | 13530 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-17 04:21:29 | Emilia-Romagna, Italy | |||
938784 | 938784 | 2022-06-25 | Italy | Emilia-Romagna | 1546702 | 17066 | 0 | 44.49436681 | 11.3417208 | 2022-06-26 04:21:02 | Emilia-Romagna, Italy | |||
942800 | 942800 | 2022-02-28 | Italy | Emilia-Romagna | 1186174 | 15905 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-01 04:21:09 | Emilia-Romagna, Italy | |||
946816 | 946816 | 2022-06-14 | Italy | Emilia-Romagna | 1508347 | 17017 | 0 | 44.49436681 | 11.3417208 | 2022-06-15 04:20:54 | Emilia-Romagna, Italy | |||
950832 | 950832 | 2022-03-12 | Italy | Emilia-Romagna | 1212925 | 16063 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-13 04:20:49 | Emilia-Romagna, Italy | |||
954847 | 954847 | 2021-04-25 | Italy | Emilia-Romagna | 364782 | 12784 | 301517 | 50481 | 44.49436681 | 11.3417208 | 2021-04-26 04:21:04 | Emilia-Romagna, Italy | ||
958862 | 958862 | 2022-07-19 | Italy | Emilia-Romagna | 1699123 | 17293 | 0 | 44.49436681 | 11.3417208 | 2022-07-20 04:20:59 | Emilia-Romagna, Italy | |||
962878 | 962878 | 2022-09-09 | Italy | Emilia-Romagna | 1833543 | 17946 | 0 | 44.49436681 | 11.3417208 | 2022-09-10 04:21:10 | Emilia-Romagna, Italy | |||
966879 | 966879 | 2020-09-29 | Italy | Emilia-Romagna | 35210 | 4484 | 26016 | 4710 | 44.49436681 | 11.3417208 | 2020-09-30 04:23:33 | Emilia-Romagna, Italy | ||
970886 | 970886 | 2022-06-01 | Italy | Emilia-Romagna | 1488279 | 16948 | 0 | 44.49436681 | 11.3417208 | 2022-06-02 05:20:39 | Emilia-Romagna, Italy | |||
974900 | 974900 | 2021-02-06 | Italy | Emilia-Romagna | 225545 | 9812 | 173085 | 42648 | 44.49436681 | 11.3417208 | 2021-02-07 05:23:00 | Emilia-Romagna, Italy | ||
978915 | 978915 | 2022-02-01 | Italy | Emilia-Romagna | 1057580 | 15128 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-02 04:21:09 | Emilia-Romagna, Italy | |||
982931 | 982931 | 2021-04-17 | Italy | Emilia-Romagna | 357231 | 12587 | 280953 | 63691 | 44.49436681 | 11.3417208 | 2021-04-18 04:20:41 | Emilia-Romagna, Italy | ||
986945 | 986945 | 2021-10-04 | Italy | Emilia-Romagna | 424922 | 13485 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-05 04:21:27 | Emilia-Romagna, Italy | |||
990961 | 990961 | 2022-08-16 | Italy | Emilia-Romagna | 1796606 | 17742 | 0 | 44.49436681 | 11.3417208 | 2022-08-17 04:20:59 | Emilia-Romagna, Italy | |||
997745 | 997745 | 2020-05-23 | Italy | Emilia-Romagna | 27513 | 4047 | 18896 | 4570 | 44.49436681 | 11.3417208 | 2020-05-24 02:32:43 | Emilia-Romagna, Italy | ||
998421 | 998421 | 2021-03-01 | Italy | Emilia-Romagna | 263194 | 10566 | 208350 | 44278 | 44.49436681 | 11.3417208 | 2021-03-02 05:23:30 | Emilia-Romagna, Italy | ||
1005389 | 1005389 | 2020-07-09 | Italy | Emilia-Romagna | 28769 | 4269 | 23434 | 1066 | 44.49436681 | 11.341720800000001 | 2020-07-10 04:34:24 | Emilia-Romagna, Italy | ||
1006276 | 1006276 | 2020-12-06 | Italy | Emilia-Romagna | 133761 | 6162 | 59432 | 68167 | 44.49436681 | 11.3417208 | 2020-12-07 05:26:14 | Emilia-Romagna, Italy | ||
1010287 | 1010287 | 2020-12-30 | Italy | Emilia-Romagna | 169396 | 7683 | 105656 | 56057 | 44.49436681 | 11.3417208 | 2020-12-31 05:22:49 | Emilia-Romagna, Italy | ||
1014300 | 1014300 | 2021-11-21 | Italy | Emilia-Romagna | 445473 | 13705 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-22 04:22:20 | Emilia-Romagna, Italy | |||
1018317 | 1018317 | 2022-12-24 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-25 04:21:04 | Emilia-Romagna, Italy | |||
1022333 | 1022333 | 2022-11-04 | Italy | Emilia-Romagna | 1966155 | 18280 | 0 | 44.49436681 | 11.3417208 | 2022-11-05 04:21:52 | Emilia-Romagna, Italy | |||
1026334 | 1026334 | 2020-10-17 | Italy | Emilia-Romagna | 40333 | 4509 | 27175 | 8649 | 44.49436681 | 11.3417208 | 2020-10-18 04:24:25 | Emilia-Romagna, Italy | ||
1030342 | 1030342 | 2021-12-06 | Italy | Emilia-Romagna | 464838 | 13841 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-07 04:22:34 | Emilia-Romagna, Italy | |||
1034356 | 1034356 | 2020-12-15 | Italy | Emilia-Romagna | 147558 | 6719 | 76205 | 64634 | 44.49436681 | 11.3417208 | 2020-12-16 05:28:04 | Emilia-Romagna, Italy | ||
1041144 | 1041144 | 2020-05-26 | Italy | Emilia-Romagna | 27611 | 4076 | 19389 | 4146 | 44.49436681 | 11.3417208 | 2020-05-27 02:32:31 | Emilia-Romagna, Italy | ||
1041806 | 1041806 | 2020-10-07 | Italy | Emilia-Romagna | 36454 | 4491 | 26668 | 5295 | 44.49436681 | 11.3417208 | 2020-10-08 04:23:56 | Emilia-Romagna, Italy | ||
1045798 | 1045798 | 2020-09-30 | Italy | Emilia-Romagna | 35311 | 4484 | 26174 | 4653 | 44.49436681 | 11.3417208 | 2020-10-01 04:23:42 | Emilia-Romagna, Italy | ||
1049805 | 1049805 | 2022-11-06 | Italy | Emilia-Romagna | 1966155 | 18280 | 0 | 44.49436681 | 11.3417208 | 2022-11-07 04:21:26 | Emilia-Romagna, Italy | |||
1053806 | 1053806 | 2020-10-23 | Italy | Emilia-Romagna | 44365 | 4547 | 27304 | 12514 | 44.49436681 | 11.3417208 | 2020-10-24 04:24:46 | Emilia-Romagna, Italy | ||
1057816 | 1057816 | 2022-02-23 | Italy | Emilia-Romagna | 1174641 | 15812 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-24 04:21:14 | Emilia-Romagna, Italy | |||
1061830 | 1061830 | 2021-01-04 | Italy | Emilia-Romagna | 179586 | 7941 | 115260 | 56385 | 44.49436681 | 11.3417208 | 2021-01-05 05:21:49 | Emilia-Romagna, Italy | ||
1065844 | 1065844 | 2022-07-28 | Italy | Emilia-Romagna | 1745986 | 17463 | 0 | 44.49436681 | 11.3417208 | 2022-07-29 04:20:45 | Emilia-Romagna, Italy | |||
1069860 | 1069860 | 2022-08-07 | Italy | Emilia-Romagna | 1780790 | 17623 | 0 | 44.49436681 | 11.3417208 | 2022-08-08 04:21:08 | Emilia-Romagna, Italy | |||
1073876 | 1073876 | 2022-12-28 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-29 04:21:01 | Emilia-Romagna, Italy | |||
1077891 | 1077891 | 2021-12-09 | Italy | Emilia-Romagna | 469222 | 13872 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-10 04:22:28 | Emilia-Romagna, Italy | |||
1081907 | 1081907 | 2021-05-14 | Italy | Emilia-Romagna | 378607 | 13067 | 338648 | 26892 | 44.49436681 | 11.3417208 | 2021-05-15 04:20:58 | Emilia-Romagna, Italy | ||
1086042 | 1086042 | 2022-08-09 | Italy | Emilia-Romagna | 1783556 | 17661 | 0 | 44.49436681 | 11.3417208 | 2022-08-10 04:20:57 | Emilia-Romagna, Italy | |||
1090057 | 1090057 | 2021-03-03 | Italy | Emilia-Romagna | 267630 | 10650 | 210282 | 46698 | 44.49436681 | 11.3417208 | 2021-03-04 05:24:24 | Emilia-Romagna, Italy | ||
1094070 | 1094070 | 2021-01-20 | Italy | Emilia-Romagna | 205261 | 8935 | 143747 | 52579 | 44.49436681 | 11.3417208 | 2021-01-21 05:22:01 | Emilia-Romagna, Italy | ||
1098085 | 1098085 | 2022-08-03 | Italy | Emilia-Romagna | 1768873 | 17561 | 0 | 44.49436681 | 11.3417208 | 2022-08-04 04:20:58 | Emilia-Romagna, Italy | |||
1104874 | 1104874 | 2020-05-25 | Italy | Emilia-Romagna | 27587 | 4068 | 19160 | 4359 | 44.49436681 | 11.3417208 | 2020-05-26 02:32:35 | Emilia-Romagna, Italy | ||
1105535 | 1105535 | 2020-09-02 | Italy | Emilia-Romagna | 32128 | 4463 | 24562 | 3103 | 44.49436681 | 11.3417208 | 2020-09-03 04:28:22 | Emilia-Romagna, Italy | ||
1109541 | 1109541 | 2022-05-21 | Italy | Emilia-Romagna | 1472836 | 16855 | 0 | 44.49436681 | 11.3417208 | 2022-05-22 04:20:52 | Emilia-Romagna, Italy | |||
1113556 | 1113556 | 2022-01-11 | Italy | Emilia-Romagna | 711706 | 14429 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-12 04:21:44 | Emilia-Romagna, Italy | |||
1117572 | 1117572 | 2021-08-06 | Italy | Emilia-Romagna | 397722 | 13287 | 0 | 44.49436681 | 11.3417208 | 2021-08-07 04:21:30 | Emilia-Romagna, Italy | |||
1121571 | 1121571 | 2020-09-17 | Italy | Emilia-Romagna | 33972 | 4471 | 25224 | 4277 | 44.49436681 | 11.3417208 | 2020-09-18 05:05:00 | Emilia-Romagna, Italy | ||
1125576 | 1125576 | 2021-06-18 | Italy | Emilia-Romagna | 386099 | 13245 | 366860 | 5994 | 44.49436681 | 11.3417208 | 2021-06-19 04:22:33 | Emilia-Romagna, Italy | ||
1135981 | 1135981 | 2020-06-26 | Italy | Emilia-Romagna | 28393 | 4252 | 23097 | 1044 | 44.49436681 | 11.341720800000001 | 2020-06-27 04:33:35 | Emilia-Romagna, Italy | ||
1136866 | 1136866 | 2021-01-01 | Italy | Emilia-Romagna | 174141 | 7808 | 109546 | 56787 | 44.49436681 | 11.3417208 | 2021-01-02 05:22:33 | Emilia-Romagna, Italy | ||
1140879 | 1140879 | 2022-01-23 | Italy | Emilia-Romagna | 933422 | 14771 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-24 04:21:12 | Emilia-Romagna, Italy | |||
1144895 | 1144895 | 2021-12-01 | Italy | Emilia-Romagna | 457044 | 13797 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-02 04:22:37 | Emilia-Romagna, Italy | |||
1148912 | 1148912 | 2022-12-12 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-13 04:21:01 | Emilia-Romagna, Italy | |||
1153103 | 1153103 | 2021-02-18 | Italy | Emilia-Romagna | 240650 | 10240 | 195481 | 34929 | 44.49436681 | 11.3417208 | 2021-02-19 05:24:16 | Emilia-Romagna, Italy | ||
1157119 | 1157119 | 2022-04-29 | Italy | Emilia-Romagna | 1406675 | 16614 | 0 | 44.49436681 | 11.3417208 | 2022-04-30 04:21:05 | Emilia-Romagna, Italy | |||
1161135 | 1161135 | 2022-08-18 | Italy | Emilia-Romagna | 1800315 | 17773 | 0 | 44.49436681 | 11.3417208 | 2022-08-19 04:20:54 | Emilia-Romagna, Italy | |||
1165150 | 1165150 | 2021-07-04 | Italy | Emilia-Romagna | 387048 | 13264 | 371191 | 2593 | 44.49436681 | 11.3417208 | 2021-07-05 04:21:28 | Emilia-Romagna, Italy | ||
1169165 | 1169165 | 2022-05-20 | Italy | Emilia-Romagna | 1470895 | 16851 | 0 | 44.49436681 | 11.3417208 | 2022-05-21 04:20:58 | Emilia-Romagna, Italy | |||
1173165 | 1173165 | 2020-09-10 | Italy | Emilia-Romagna | 33073 | 4468 | 24994 | 3611 | 44.49436681 | 11.3417208 | 2020-09-11 04:46:23 | Emilia-Romagna, Italy | ||
1177476 | 1177476 | 2020-10-22 | Italy | Emilia-Romagna | 43477 | 4537 | 27277 | 11663 | 44.49436681 | 11.3417208 | 2020-10-23 04:24:46 | Emilia-Romagna, Italy | ||
1184712 | 1184712 | 2022-05-18 | Italy | Emilia-Romagna | 1465883 | 16833 | 0 | 44.49436681 | 11.3417208 | 2022-05-19 04:20:54 | Emilia-Romagna, Italy | |||
1188727 | 1188727 | 2021-05-31 | Italy | Emilia-Romagna | 383879 | 13186 | 355420 | 15273 | 44.49436681 | 11.3417208 | 2021-06-01 04:23:09 | Emilia-Romagna, Italy | ||
1195749 | 1195749 | 2020-06-17 | Italy | Emilia-Romagna | 28111 | 4215 | 22551 | 1345 | 44.49436681 | 11.341720800000001 | 2020-06-18 04:33:18 | Emilia-Romagna, Italy | ||
1199774 | 1199774 | 2022-07-06 | Italy | Emilia-Romagna | 1609323 | 17152 | 0 | 44.49436681 | 11.3417208 | 2022-07-07 04:20:55 | Emilia-Romagna, Italy | |||
1203789 | 1203789 | 2021-03-22 | Italy | Emilia-Romagna | 319080 | 11468 | 232841 | 74771 | 44.49436681 | 11.3417208 | 2021-03-23 05:26:18 | Emilia-Romagna, Italy | ||
1210661 | 1210661 | 2020-06-09 | Italy | Emilia-Romagna | 27946 | 4185 | 21605 | 2156 | 44.49436681 | 11.3417208 | 2020-06-10 04:07:00 | Emilia-Romagna, Italy | ||
1211519 | 1211519 | 2022-07-11 | Italy | Emilia-Romagna | 1643771 | 17193 | 0 | 44.49436681 | 11.3417208 | 2022-07-12 04:20:51 | Emilia-Romagna, Italy | |||
1215534 | 1215534 | 2022-01-08 | Italy | Emilia-Romagna | 659235 | 14362 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-09 04:21:46 | Emilia-Romagna, Italy | |||
1219550 | 1219550 | 2021-03-27 | Italy | Emilia-Romagna | 329041 | 11706 | 245274 | 72061 | 44.49436681 | 11.3417208 | 2021-03-28 05:28:10 | Emilia-Romagna, Italy | ||
1223565 | 1223565 | 2022-04-14 | Italy | Emilia-Romagna | 1343088 | 16433 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-15 04:20:57 | Emilia-Romagna, Italy | |||
1227580 | 1227580 | 2022-01-24 | Italy | Emilia-Romagna | 948126 | 14811 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-25 04:21:05 | Emilia-Romagna, Italy | |||
1231596 | 1231596 | 2021-11-28 | Italy | Emilia-Romagna | 453630 | 13774 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-29 04:22:30 | Emilia-Romagna, Italy | |||
1235612 | 1235612 | 2021-09-27 | Italy | Emilia-Romagna | 422939 | 13462 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-28 04:21:28 | Emilia-Romagna, Italy | |||
1239628 | 1239628 | 2022-11-28 | Italy | Emilia-Romagna | 2023014 | 18457 | 0 | 44.49436681 | 11.3417208 | 2022-11-29 04:21:05 | Emilia-Romagna, Italy | |||
1243739 | 1243739 | 2020-09-08 | Italy | Emilia-Romagna | 32854 | 4465 | 24857 | 3532 | 44.49436681 | 11.3417208 | 2020-09-09 04:28:48 | Emilia-Romagna, Italy | ||
1250724 | 1250724 | 2022-08-23 | Italy | Emilia-Romagna | 1808469 | 17829 | 0 | 44.49436681 | 11.3417208 | 2022-08-24 04:20:46 | 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]);