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 = "Valle d'Aosta" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1510837 | 1510837 | 2020-06-22 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-23 04:33:22 | Valle d'Aosta, Italy | ||
1522643 | 1522643 | 2020-06-23 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-24 04:33:28 | Valle d'Aosta, Italy | ||
2222954 | 2222954 | 2020-07-08 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-09 04:34:23 | Valle d'Aosta, Italy | ||
2625318 | 2625318 | 2020-06-25 | Italy | Valle d'Aosta | 1194 | 146 | 1043 | 5 | 45.73750286 | 7.320149366 | 2020-06-26 04:33:43 | Valle d'Aosta, Italy | ||
2685123 | 2685123 | 2020-07-06 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-07 04:34:00 | Valle d'Aosta, Italy | ||
3237754 | 3237754 | 2020-07-10 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-11 04:34:26 | Valle d'Aosta, Italy | ||
3249576 | 3249576 | 2020-06-21 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-22 04:33:20 | Valle d'Aosta, Italy | ||
1901164 | 1901164 | 2020-12-18 | Italy | Valle d'Aosta | 6986 | 365 | 6121 | 500 | 45.73750286 | 7.320149366 | 2020-12-19 05:27:52 | Valle d'Aosta, Italy | ||
1744536 | 1744536 | 2021-03-20 | Italy | Valle d'Aosta | 8575 | 419 | 7653 | 503 | 45.73750286 | 7.320149366 | 2021-03-21 05:25:44 | Valle d'Aosta, Italy | ||
3054188 | 3054188 | 2021-05-13 | Italy | Valle d'Aosta | 11311 | 466 | 10342 | 503 | 45.73750286 | 7.320149366 | 2021-05-14 04:20:41 | Valle d'Aosta, Italy | ||
408291 | 408291 | 2021-07-28 | Italy | Valle d'Aosta | 11751 | 473 | 11227 | 51 | 45.73750286 | 7.320149366 | 2021-07-29 04:21:33 | Valle d'Aosta, Italy | ||
1306152 | 1306152 | 2021-07-27 | Italy | Valle d'Aosta | 11748 | 473 | 11224 | 51 | 45.73750286 | 7.320149366 | 2021-07-28 04:21:39 | Valle d'Aosta, Italy | ||
3093418 | 3093418 | 2020-09-20 | Italy | Valle d'Aosta | 1279 | 146 | 1082 | 51 | 45.73750286 | 7.320149366 | 2020-09-21 04:23:00 | Valle d'Aosta, Italy | ||
2004658 | 2004658 | 2021-05-12 | Italy | Valle d'Aosta | 11282 | 466 | 10303 | 513 | 45.73750286 | 7.320149366 | 2021-05-13 04:20:51 | Valle d'Aosta, Italy | ||
1081922 | 1081922 | 2021-05-14 | Italy | Valle d'Aosta | 11354 | 466 | 10372 | 516 | 45.73750286 | 7.320149366 | 2021-05-15 04:20:58 | Valle d'Aosta, Italy | ||
3358666 | 3358666 | 2021-06-21 | Italy | Valle d'Aosta | 11674 | 472 | 11150 | 52 | 45.73750286 | 7.320149366 | 2021-06-22 04:21:34 | Valle d'Aosta, Italy | ||
3149590 | 3149590 | 2020-12-16 | Italy | Valle d'Aosta | 6943 | 360 | 6060 | 523 | 45.73750286 | 7.320149366 | 2020-12-17 05:28:12 | Valle d'Aosta, Italy | ||
1034371 | 1034371 | 2020-12-15 | Italy | Valle d'Aosta | 6905 | 356 | 6022 | 527 | 45.73750286 | 7.320149366 | 2020-12-16 05:28:04 | Valle d'Aosta, Italy | ||
762311 | 762311 | 2020-10-18 | Italy | Valle d'Aosta | 1811 | 146 | 1137 | 528 | 45.73750286 | 7.320149366 | 2020-10-19 04:24:16 | Valle d'Aosta, Italy | ||
3369326 | 3369326 | 2021-03-21 | Italy | Valle d'Aosta | 8603 | 419 | 7654 | 530 | 45.73750286 | 7.320149366 | 2021-03-22 05:25:43 | Valle d'Aosta, Italy | ||
3954489 | 3954489 | 2021-05-11 | Italy | Valle d'Aosta | 11259 | 464 | 10261 | 534 | 45.73750286 | 7.320149366 | 2021-05-12 04:21:29 | Valle d'Aosta, Italy | ||
2812746 | 2812746 | 2020-09-25 | Italy | Valle d'Aosta | 1288 | 146 | 1087 | 55 | 45.73750286 | 7.320149366 | 2020-09-26 04:23:00 | Valle d'Aosta, Italy | ||
3385386 | 3385386 | 2021-07-29 | Italy | Valle d'Aosta | 11755 | 473 | 11227 | 55 | 45.73750286 | 7.320149366 | 2021-07-30 04:21:34 | Valle d'Aosta, Italy | ||
2606023 | 2606023 | 2020-09-24 | Italy | Valle d'Aosta | 1287 | 146 | 1085 | 56 | 45.73750286 | 7.320149366 | 2020-09-25 04:23:00 | Valle d'Aosta, Italy | ||
1203804 | 1203804 | 2021-03-22 | Italy | Valle d'Aosta | 8655 | 419 | 7671 | 565 | 45.73750286 | 7.320149366 | 2021-03-23 05:26:18 | Valle d'Aosta, Italy | ||
2820768 | 2820768 | 2021-05-10 | Italy | Valle d'Aosta | 11236 | 463 | 10205 | 568 | 45.73750286 | 7.320149366 | 2021-05-11 04:20:41 | Valle d'Aosta, Italy | ||
1798636 | 1798636 | 2021-03-23 | Italy | Valle d'Aosta | 8685 | 419 | 7697 | 569 | 45.73750286 | 7.320149366 | 2021-03-24 05:25:40 | Valle d'Aosta, Italy | ||
2884365 | 2884365 | 2021-06-20 | Italy | Valle d'Aosta | 11674 | 472 | 11145 | 57 | 45.73750286 | 7.320149366 | 2021-06-21 04:21:41 | Valle d'Aosta, Italy | ||
3903970 | 3903970 | 2021-07-31 | Italy | Valle d'Aosta | 11765 | 473 | 11235 | 57 | 45.73750286 | 7.320149366 | 2021-08-01 04:21:50 | Valle d'Aosta, Italy | ||
2653766 | 2653766 | 2020-09-23 | Italy | Valle d'Aosta | 1284 | 146 | 1080 | 58 | 45.73750286 | 7.320149366 | 2020-09-24 04:23:00 | Valle d'Aosta, Italy | ||
3015347 | 3015347 | 2021-08-01 | Italy | Valle d'Aosta | 11769 | 473 | 11238 | 58 | 45.73750286 | 7.320149366 | 2021-08-02 04:21:36 | Valle d'Aosta, Italy | ||
1751265 | 1751265 | 2020-12-14 | Italy | Valle d'Aosta | 6885 | 353 | 5944 | 588 | 45.73750286 | 7.320149366 | 2020-12-15 05:26:38 | Valle d'Aosta, Italy | ||
1425100 | 1425100 | 2021-05-09 | Italy | Valle d'Aosta | 11217 | 462 | 10163 | 592 | 45.73750286 | 7.320149366 | 2021-05-10 04:20:38 | Valle d'Aosta, Italy | ||
1273718 | 1273718 | 2020-06-11 | Italy | Valle d'Aosta | 1191 | 144 | 1041 | 6 | 45.73750286 | 7.320149366 | 2020-06-12 05:09:52 | Valle d'Aosta, Italy | ||
2438169 | 2438169 | 2020-06-20 | Italy | Valle d'Aosta | 1193 | 146 | 1041 | 6 | 45.73750286 | 7.320149366 | 2020-06-21 04:33:19 | Valle d'Aosta, Italy | ||
2700958 | 2700958 | 2020-06-24 | Italy | Valle d'Aosta | 1194 | 146 | 1042 | 6 | 45.73750286 | 7.320149366 | 2020-06-25 05:26:54 | Valle d'Aosta, Italy | ||
2864158 | 2864158 | 2020-06-10 | Italy | Valle d'Aosta | 1191 | 144 | 1041 | 6 | 45.73750286 | 7.320149366 | 2020-06-11 03:33:41 | Valle d'Aosta, Italy | ||
3682896 | 3682896 | 2020-06-18 | Italy | Valle d'Aosta | 1191 | 145 | 1040 | 6 | 45.73750286 | 7.320149366 | 2020-06-19 04:33:17 | Valle d'Aosta, Italy | ||
3260968 | 3260968 | 2020-05-18 | Italy | Valle d'Aosta | 1174 | 143 | 971 | 60 | 45.73750286 | 7.320149366 | 2020-05-19 02:32:18 | Valle d'Aosta, Italy | ||
3296175 | 3296175 | 2021-07-30 | Italy | Valle d'Aosta | 11761 | 473 | 11228 | 60 | 45.73750286 | 7.320149366 | 2021-07-31 04:21:35 | Valle d'Aosta, Italy | ||
3683448 | 3683448 | 2021-08-02 | Italy | Valle d'Aosta | 11771 | 473 | 11238 | 60 | 45.73750286 | 7.320149366 | 2021-08-03 04:21:39 | Valle d'Aosta, Italy | ||
1551968 | 1551968 | 2021-05-08 | Italy | Valle d'Aosta | 11209 | 462 | 10142 | 605 | 45.73750286 | 7.320149366 | 2021-05-09 04:20:35 | Valle d'Aosta, Italy | ||
107448 | 107448 | 2021-06-19 | Italy | Valle d'Aosta | 11670 | 472 | 11137 | 61 | 45.73750286 | 7.320149366 | 2021-06-20 04:21:48 | Valle d'Aosta, Italy | ||
3113482 | 3113482 | 2021-05-06 | Italy | Valle d'Aosta | 11118 | 461 | 10047 | 610 | 45.73750286 | 7.320149366 | 2021-05-07 04:20:40 | Valle d'Aosta, Italy | ||
3847785 | 3847785 | 2020-12-13 | Italy | Valle d'Aosta | 6871 | 353 | 5896 | 622 | 45.73750286 | 7.320149366 | 2020-12-14 05:26:27 | Valle d'Aosta, Italy | ||
2780991 | 2780991 | 2021-03-24 | Italy | Valle d'Aosta | 8755 | 419 | 7709 | 627 | 45.73750286 | 7.320149366 | 2021-03-25 05:27:00 | Valle d'Aosta, Italy | ||
645949 | 645949 | 2021-05-05 | Italy | Valle d'Aosta | 11078 | 460 | 9988 | 630 | 45.73750286 | 7.320149366 | 2021-05-06 04:20:38 | Valle d'Aosta, Italy | ||
2502026 | 2502026 | 2021-05-07 | Italy | Valle d'Aosta | 11169 | 461 | 10078 | 630 | 45.73750286 | 7.320149366 | 2021-05-08 04:21:04 | Valle d'Aosta, Italy | ||
1125591 | 1125591 | 2021-06-18 | Italy | Valle d'Aosta | 11667 | 472 | 11131 | 64 | 45.73750286 | 7.320149366 | 2021-06-19 04:22:33 | Valle d'Aosta, Italy | ||
1980613 | 1980613 | 2021-03-25 | Italy | Valle d'Aosta | 8816 | 419 | 7748 | 649 | 45.73750286 | 7.320149366 | 2021-03-26 05:26:55 | Valle d'Aosta, Italy | ||
1515391 | 1515391 | 2020-09-28 | Italy | Valle d'Aosta | 1300 | 146 | 1089 | 65 | 45.73750286 | 7.320149366 | 2020-09-29 04:23:42 | Valle d'Aosta, Italy | ||
1794627 | 1794627 | 2020-10-19 | Italy | Valle d'Aosta | 1946 | 146 | 1142 | 658 | 45.73750286 | 7.320149366 | 2020-10-20 04:24:22 | Valle d'Aosta, Italy | ||
2581979 | 2581979 | 2020-09-27 | Italy | Valle d'Aosta | 1299 | 146 | 1087 | 66 | 45.73750286 | 7.320149366 | 2020-09-28 04:23:00 | Valle d'Aosta, Italy | ||
2614031 | 2614031 | 2020-09-26 | Italy | Valle d'Aosta | 1299 | 146 | 1087 | 66 | 45.73750286 | 7.320149366 | 2020-09-27 04:23:00 | Valle d'Aosta, Italy | ||
845567 | 845567 | 2020-12-12 | Italy | Valle d'Aosta | 6837 | 351 | 5823 | 663 | 45.73750286 | 7.320149366 | 2020-12-13 05:27:20 | Valle d'Aosta, Italy | ||
3416362 | 3416362 | 2020-05-17 | Italy | Valle d'Aosta | 1173 | 143 | 962 | 68 | 45.73750286 | 7.320149366 | 2020-05-18 02:32:21 | Valle d'Aosta, Italy | ||
3675649 | 3675649 | 2021-05-04 | Italy | Valle d'Aosta | 11066 | 459 | 9922 | 685 | 45.73750286 | 7.320149366 | 2021-05-05 04:20:43 | Valle d'Aosta, Italy | ||
966894 | 966894 | 2020-09-29 | Italy | Valle d'Aosta | 1308 | 146 | 1093 | 69 | 45.73750286 | 7.320149366 | 2020-09-30 04:23:33 | Valle d'Aosta, Italy | ||
2379627 | 2379627 | 2020-10-01 | Italy | Valle d'Aosta | 1315 | 146 | 1100 | 69 | 45.73750286 | 7.320149366 | 2020-10-02 04:23:51 | Valle d'Aosta, Italy | ||
1880983 | 1880983 | 2021-03-26 | Italy | Valle d'Aosta | 8873 | 420 | 7763 | 690 | 45.73750286 | 7.320149366 | 2021-03-27 05:25:04 | Valle d'Aosta, Italy | ||
2450769 | 2450769 | 2021-05-02 | Italy | Valle d'Aosta | 11013 | 459 | 9856 | 698 | 45.73750286 | 7.320149366 | 2021-05-03 04:20:39 | Valle d'Aosta, Italy | ||
1837376 | 1837376 | 2020-06-14 | Italy | Valle d'Aosta | 1191 | 144 | 1040 | 7 | 45.73750286 | 7.320149366 | 2020-06-15 03:33:14 | Valle d'Aosta, Italy | ||
3061428 | 3061428 | 2020-06-13 | Italy | Valle d'Aosta | 1191 | 144 | 1040 | 7 | 45.73750286 | 7.320149366 | 2020-06-14 03:33:15 | Valle d'Aosta, Italy | ||
2760916 | 2760916 | 2021-05-03 | Italy | Valle d'Aosta | 11041 | 459 | 9867 | 715 | 45.73750286 | 7.320149366 | 2021-05-04 04:20:34 | Valle d'Aosta, Italy | ||
860674 | 860674 | 2020-12-11 | Italy | Valle d'Aosta | 6812 | 347 | 5749 | 716 | 45.73750286 | 7.320149366 | 2020-12-12 05:26:19 | Valle d'Aosta, Italy | ||
3990607 | 3990607 | 2020-10-20 | Italy | Valle d'Aosta | 2021 | 146 | 1150 | 725 | 45.73750286 | 7.320149366 | 2020-10-21 04:24:14 | Valle d'Aosta, Italy | ||
2824782 | 2824782 | 2021-05-01 | Italy | Valle d'Aosta | 10990 | 459 | 9804 | 727 | 45.73750286 | 7.320149366 | 2021-05-02 04:20:48 | Valle d'Aosta, Italy | ||
2911169 | 2911169 | 2021-06-17 | Italy | Valle d'Aosta | 11665 | 472 | 11119 | 74 | 45.73750286 | 7.320149366 | 2021-06-18 04:22:16 | Valle d'Aosta, Italy | ||
380190 | 380190 | 2021-04-30 | Italy | Valle d'Aosta | 10932 | 458 | 9725 | 749 | 45.73750286 | 7.320149366 | 2021-05-01 04:20:47 | Valle d'Aosta, Italy | ||
1045813 | 1045813 | 2020-09-30 | Italy | Valle d'Aosta | 1314 | 146 | 1093 | 75 | 45.73750286 | 7.320149366 | 2020-10-01 04:23:42 | Valle d'Aosta, Italy | ||
1829596 | 1829596 | 2020-05-16 | Italy | Valle d'Aosta | 1173 | 142 | 956 | 75 | 45.73750286 | 7.320149366 | 2020-05-17 02:32:32 | Valle d'Aosta, Italy | ||
2514168 | 2514168 | 2020-10-03 | Italy | Valle d'Aosta | 1326 | 146 | 1105 | 75 | 45.73750286 | 7.320149366 | 2020-10-04 04:23:44 | Valle d'Aosta, Italy | ||
3393392 | 3393392 | 2021-04-28 | Italy | Valle d'Aosta | 10823 | 455 | 9618 | 750 | 45.73750286 | 7.320149366 | 2021-04-29 04:20:55 | Valle d'Aosta, Italy | ||
1636313 | 1636313 | 2021-04-29 | Italy | Valle d'Aosta | 10884 | 455 | 9665 | 764 | 45.73750286 | 7.320149366 | 2021-04-30 04:21:03 | Valle d'Aosta, Italy | ||
3276312 | 3276312 | 2020-05-15 | Italy | Valle d'Aosta | 1172 | 142 | 953 | 77 | 45.73750286 | 7.320149366 | 2020-05-16 02:32:19 | Valle d'Aosta, Italy | ||
3389386 | 3389386 | 2020-10-02 | Italy | Valle d'Aosta | 1326 | 146 | 1103 | 77 | 45.73750286 | 7.320149366 | 2020-10-03 04:23:40 | Valle d'Aosta, Italy | ||
3924009 | 3924009 | 2021-04-24 | Italy | Valle d'Aosta | 10643 | 450 | 9412 | 781 | 45.73750286 | 7.320149366 | 2021-04-25 04:20:32 | Valle d'Aosta, Italy | ||
1600216 | 1600216 | 2020-12-10 | Italy | Valle d'Aosta | 6801 | 344 | 5674 | 783 | 45.73750286 | 7.320149366 | 2020-12-11 05:26:59 | Valle d'Aosta, Italy | ||
3702108 | 3702108 | 2021-04-27 | Italy | Valle d'Aosta | 10786 | 454 | 9549 | 783 | 45.73750286 | 7.320149366 | 2021-04-28 04:20:32 | Valle d'Aosta, Italy | ||
1219565 | 1219565 | 2021-03-27 | Italy | Valle d'Aosta | 8998 | 420 | 7787 | 791 | 45.73750286 | 7.320149366 | 2021-03-28 05:28:10 | Valle d'Aosta, Italy | ||
954862 | 954862 | 2021-04-25 | Italy | Valle d'Aosta | 10693 | 451 | 9450 | 792 | 45.73750286 | 7.320149366 | 2021-04-26 04:21:04 | Valle d'Aosta, Italy | ||
217403 | 217403 | 2020-06-08 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-09 03:33:03 | Valle d'Aosta, Italy | ||
837609 | 837609 | 2020-08-17 | Italy | Valle d'Aosta | 1218 | 146 | 1064 | 8 | 45.73750286 | 7.320149366 | 2020-08-18 04:27:56 | Valle d'Aosta, Italy | ||
1196099 | 1196099 | 2020-06-17 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-18 04:33:18 | Valle d'Aosta, Italy | ||
1210976 | 1210976 | 2020-06-09 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-10 04:07:00 | Valle d'Aosta, Italy | ||
3178005 | 3178005 | 2020-08-18 | Italy | Valle d'Aosta | 1218 | 146 | 1064 | 8 | 45.73750286 | 7.320149366 | 2020-08-19 04:27:00 | Valle d'Aosta, Italy | ||
1404486 | 1404486 | 2020-05-14 | Italy | Valle d'Aosta | 1166 | 141 | 945 | 80 | 45.73750286 | 7.320149366 | 2020-05-15 02:33:02 | Valle d'Aosta, Italy | ||
1822784 | 1822784 | 2020-10-04 | Italy | Valle d'Aosta | 1333 | 146 | 1106 | 81 | 45.73750286 | 7.320149366 | 2020-10-05 04:23:33 | Valle d'Aosta, Italy | ||
3030287 | 3030287 | 2021-06-16 | Italy | Valle d'Aosta | 11662 | 472 | 11109 | 81 | 45.73750286 | 7.320149366 | 2021-06-17 04:22:36 | Valle d'Aosta, Italy | ||
888117 | 888117 | 2021-04-26 | Italy | Valle d'Aosta | 10746 | 454 | 9478 | 814 | 45.73750286 | 7.320149366 | 2021-04-27 04:20:52 | Valle d'Aosta, Italy | ||
1535925 | 1535925 | 2021-03-28 | Italy | Valle d'Aosta | 9075 | 420 | 7835 | 820 | 45.73750286 | 7.320149366 | 2021-03-29 04:28:35 | Valle d'Aosta, Italy | ||
3468174 | 3468174 | 2021-08-03 | Italy | Valle d'Aosta | 11799 | 473 | 11243 | 83 | 45.73750286 | 7.320149366 | 2021-08-04 04:21:25 | Valle d'Aosta, Italy | ||
2191596 | 2191596 | 2020-10-21 | Italy | Valle d'Aosta | 2132 | 146 | 1155 | 831 | 45.73750286 | 7.320149366 | 2020-10-22 04:24:27 | Valle d'Aosta, Italy | ||
1409040 | 1409040 | 2021-04-23 | Italy | Valle d'Aosta | 10598 | 446 | 9311 | 841 | 45.73750286 | 7.320149366 | 2021-04-24 04:20:38 | Valle d'Aosta, Italy | ||
1290003 | 1290003 | 2021-03-29 | Italy | Valle d'Aosta | 9102 | 421 | 7839 | 842 | 45.73750286 | 7.320149366 | 2021-03-30 04:26:23 | Valle d'Aosta, Italy | ||
2975225 | 2975225 | 2020-12-09 | Italy | Valle d'Aosta | 6783 | 343 | 5584 | 856 | 45.73750286 | 7.320149366 | 2020-12-10 05:26:19 | Valle d'Aosta, Italy | ||
1568103 | 1568103 | 2021-04-22 | Italy | Valle d'Aosta | 10553 | 445 | 9245 | 863 | 45.73750286 | 7.320149366 | 2021-04-23 04:20:52 | Valle d'Aosta, Italy | ||
1818785 | 1818785 | 2020-12-08 | Italy | Valle d'Aosta | 6766 | 339 | 5557 | 870 | 45.73750286 | 7.320149366 | 2020-12-09 05:28:01 | Valle d'Aosta, Italy | ||
3242324 | 3242324 | 2021-04-21 | Italy | Valle d'Aosta | 10514 | 443 | 9180 | 891 | 45.73750286 | 7.320149366 | 2021-04-22 04:20:53 | Valle d'Aosta, Italy | ||
737748 | 737748 | 2020-06-12 | Italy | Valle d'Aosta | 1191 | 144 | 1038 | 9 | 45.73750286 | 7.320149366 | 2020-06-13 03:33:14 | Valle d'Aosta, 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]);