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 longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
662281 | 662281 | 2020-08-11 | Italy | Emilia-Romagna | 30179 | 4298 | 24091 | 1790 | 44.49436681 | 11.3417208 | 2020-08-12 04:27:29 | Emilia-Romagna, Italy | ||
666260 | 666260 | 2020-09-16 | Italy | Emilia-Romagna | 33862 | 4470 | 25213 | 4179 | 44.49436681 | 11.3417208 | 2020-09-17 04:22:00 | Emilia-Romagna, Italy | ||
670266 | 670266 | 2022-07-21 | Italy | Emilia-Romagna | 1713109 | 17335 | 0 | 44.49436681 | 11.3417208 | 2022-07-22 04:21:15 | Emilia-Romagna, Italy | |||
674282 | 674282 | 2022-07-30 | Italy | Emilia-Romagna | 1755934 | 17493 | 0 | 44.49436681 | 11.3417208 | 2022-07-31 04:21:02 | Emilia-Romagna, Italy | |||
678294 | 678294 | 2020-11-23 | Italy | Emilia-Romagna | 108073 | 5384 | 33309 | 69380 | 44.49436681 | 11.3417208 | 2020-11-24 05:27:31 | Emilia-Romagna, Italy | ||
690340 | 690340 | 2022-12-23 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-24 04:21:02 | Emilia-Romagna, Italy | |||
702387 | 702387 | 2021-03-16 | Italy | Emilia-Romagna | 304314 | 11184 | 224138 | 68992 | 44.49436681 | 11.3417208 | 2021-03-17 05:25:07 | Emilia-Romagna, Italy | ||
710417 | 710417 | 2022-11-01 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-11-02 04:22:09 | Emilia-Romagna, Italy | |||
718449 | 718449 | 2022-12-04 | Italy | Emilia-Romagna | 2045976 | 18531 | 0 | 44.49436681 | 11.3417208 | 2022-12-05 04:20:58 | Emilia-Romagna, Italy | |||
726480 | 726480 | 2021-05-22 | Italy | Emilia-Romagna | 381776 | 13140 | 349298 | 19338 | 44.49436681 | 11.3417208 | 2021-05-23 04:20:51 | Emilia-Romagna, Italy | ||
738283 | 738283 | 2020-12-02 | Italy | Emilia-Romagna | 126110 | 5874 | 48931 | 71305 | 44.49436681 | 11.3417208 | 2020-12-03 05:28:22 | Emilia-Romagna, Italy | ||
742296 | 742296 | 2021-02-20 | Italy | Emilia-Romagna | 244170 | 10304 | 198733 | 35133 | 44.49436681 | 11.3417208 | 2021-02-21 05:24:33 | Emilia-Romagna, Italy | ||
753397 | 753397 | 2020-08-01 | Italy | Emilia-Romagna | 29726 | 4291 | 23925 | 1510 | 44.49436681 | 11.3417208 | 2020-08-02 04:34:47 | Emilia-Romagna, Italy | ||
754284 | 754284 | 2020-10-28 | Italy | Emilia-Romagna | 50494 | 4593 | 27671 | 18230 | 44.49436681 | 11.3417208 | 2020-10-29 04:24:49 | Emilia-Romagna, Italy | ||
762296 | 762296 | 2020-10-18 | Italy | Emilia-Romagna | 40859 | 4515 | 27181 | 9163 | 44.49436681 | 11.3417208 | 2020-10-19 04:24:16 | Emilia-Romagna, Italy | ||
766302 | 766302 | 2020-12-29 | Italy | Emilia-Romagna | 167969 | 7614 | 103543 | 56812 | 44.49436681 | 11.3417208 | 2020-12-30 05:22:34 | Emilia-Romagna, Italy | ||
774330 | 774330 | 2021-01-12 | Italy | Emilia-Romagna | 194395 | 8454 | 125749 | 60192 | 44.49436681 | 11.3417208 | 2021-01-13 05:22:15 | Emilia-Romagna, Italy | ||
778343 | 778343 | 2021-07-08 | Italy | Emilia-Romagna | 387311 | 13266 | 371857 | 2188 | 44.49436681 | 11.3417208 | 2021-07-09 04:21:21 | Emilia-Romagna, Italy | ||
786359 | 786359 | 2020-10-15 | Italy | Emilia-Romagna | 39148 | 4503 | 27124 | 7521 | 44.49436681 | 11.3417208 | 2020-10-16 04:24:01 | Emilia-Romagna, Italy | ||
790365 | 790365 | 2021-02-04 | Italy | Emilia-Romagna | 222804 | 9714 | 169281 | 43809 | 44.49436681 | 11.3417208 | 2021-02-05 05:22:38 | Emilia-Romagna, Italy | ||
794381 | 794381 | 2022-10-24 | Italy | Emilia-Romagna | 1943921 | 18169 | 0 | 44.49436681 | 11.3417208 | 2022-10-25 04:21:53 | Emilia-Romagna, Italy | |||
813558 | 813558 | 2020-09-05 | Italy | Emilia-Romagna | 32505 | 4464 | 24790 | 3251 | 44.49436681 | 11.3417208 | 2020-09-06 04:28:33 | Emilia-Romagna, Italy | ||
817549 | 817549 | 2020-10-09 | Italy | Emilia-Romagna | 36914 | 4493 | 26812 | 5609 | 44.49436681 | 11.3417208 | 2020-10-10 04:23:57 | Emilia-Romagna, Italy | ||
821552 | 821552 | 2020-11-19 | Italy | Emilia-Romagna | 97814 | 5218 | 31587 | 61009 | 44.49436681 | 11.3417208 | 2020-11-20 05:26:28 | Emilia-Romagna, Italy | ||
825565 | 825565 | 2021-06-06 | Italy | Emilia-Romagna | 384820 | 13209 | 360157 | 11454 | 44.49436681 | 11.3417208 | 2021-06-07 04:22:51 | Emilia-Romagna, Italy | ||
829579 | 829579 | 2021-07-09 | Italy | Emilia-Romagna | 387410 | 13266 | 371950 | 2194 | 44.49436681 | 11.3417208 | 2021-07-10 04:21:25 | Emilia-Romagna, Italy | ||
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 | ||
880247 | 880247 | 2022-08-05 | Italy | Emilia-Romagna | 1775610 | 17586 | 0 | 44.49436681 | 11.3417208 | 2022-08-06 04:20:56 | 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 | |||
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 | |||
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 | ||
938784 | 938784 | 2022-06-25 | Italy | Emilia-Romagna | 1546702 | 17066 | 0 | 44.49436681 | 11.3417208 | 2022-06-26 04:21:02 | 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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
1239628 | 1239628 | 2022-11-28 | Italy | Emilia-Romagna | 2023014 | 18457 | 0 | 44.49436681 | 11.3417208 | 2022-11-29 04:21:05 | 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]);