johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where deaths = 146 and province_or_state = "Valle d'Aosta" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62192 | 62192 | 2020-07-23 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-24 05:30:40 | Valle d'Aosta, Italy | ||
79085 | 79085 | 2020-10-14 | Italy | Valle d'Aosta | 1566 | 146 | 1125 | 295 | 45.73750286 | 7.320149366 | 2020-10-15 04:24:28 | Valle d'Aosta, Italy | ||
98553 | 98553 | 2020-08-04 | Italy | Valle d'Aosta | 1209 | 146 | 1050 | 13 | 45.73750286 | 7.320149366 | 2020-08-05 04:34:43 | Valle d'Aosta, Italy | ||
122144 | 122144 | 2020-07-19 | Italy | Valle d'Aosta | 1196 | 146 | 1047 | 3 | 45.73750286 | 7.320149366 | 2020-07-20 05:34:40 | Valle d'Aosta, Italy | ||
145969 | 145969 | 2020-08-15 | Italy | Valle d'Aosta | 1217 | 146 | 1060 | 11 | 45.73750286 | 7.320149366 | 2020-08-16 04:27:42 | Valle d'Aosta, Italy | ||
177462 | 177462 | 2020-07-27 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-28 04:58:43 | Valle d'Aosta, Italy | ||
194064 | 194064 | 2020-08-31 | Italy | Valle d'Aosta | 1241 | 146 | 1064 | 31 | 45.73750286 | 7.320149366 | 2020-09-01 04:28:31 | Valle d'Aosta, Italy | ||
206251 | 206251 | 2020-08-19 | Italy | Valle d'Aosta | 1220 | 146 | 1064 | 10 | 45.73750286 | 7.320149366 | 2020-08-20 04:27:43 | Valle d'Aosta, Italy | ||
303297 | 303297 | 2020-07-01 | Italy | Valle d'Aosta | 1195 | 146 | 1046 | 3 | 45.73750286 | 7.320149366 | 2020-07-02 04:33:46 | Valle d'Aosta, Italy | ||
327239 | 327239 | 2020-07-20 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-21 04:38:46 | Valle d'Aosta, Italy | ||
344272 | 344272 | 2020-09-14 | Italy | Valle d'Aosta | 1263 | 146 | 1078 | 39 | 45.73750286 | 7.320149366 | 2020-09-15 03:22:50 | Valle d'Aosta, Italy | ||
367645 | 367645 | 2020-07-16 | Italy | Valle d'Aosta | 1196 | 146 | 1048 | 2 | 45.73750286 | 7.320149366 | 2020-07-17 04:34:50 | Valle d'Aosta, Italy | ||
371618 | 371618 | 2020-08-08 | Italy | Valle d'Aosta | 1216 | 146 | 1051 | 19 | 45.73750286 | 7.320149366 | 2020-08-09 04:34:54 | Valle d'Aosta, Italy | ||
415588 | 415588 | 2020-07-05 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-06 04:33:57 | Valle d'Aosta, Italy | ||
427333 | 427333 | 2020-09-07 | Italy | Valle d'Aosta | 1249 | 146 | 1069 | 34 | 45.73750286 | 7.320149366 | 2020-09-08 04:28:25 | Valle d'Aosta, Italy | ||
442775 | 442775 | 2020-07-26 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-27 04:35:02 | Valle d'Aosta, Italy | ||
458802 | 458802 | 2020-08-07 | Italy | Valle d'Aosta | 1214 | 146 | 1051 | 17 | 45.73750286 | 7.320149366 | 2020-08-08 04:34:53 | Valle d'Aosta, Italy | ||
530150 | 530150 | 2020-07-04 | Italy | Valle d'Aosta | 1196 | 146 | 1046 | 4 | 45.73750286 | 7.320149366 | 2020-07-05 04:33:46 | Valle d'Aosta, Italy | ||
546750 | 546750 | 2020-09-12 | Italy | Valle d'Aosta | 1258 | 146 | 1078 | 34 | 45.73750286 | 7.320149366 | 2020-09-13 04:30:52 | Valle d'Aosta, Italy | ||
582828 | 582828 | 2020-08-13 | Italy | Valle d'Aosta | 1217 | 146 | 1057 | 14 | 45.73750286 | 7.320149366 | 2020-08-14 04:51:19 | Valle d'Aosta, Italy | ||
609685 | 609685 | 2020-08-29 | Italy | Valle d'Aosta | 1230 | 146 | 1065 | 19 | 45.73750286 | 7.320149366 | 2020-08-30 04:28:22 | Valle d'Aosta, Italy | ||
662296 | 662296 | 2020-08-11 | Italy | Valle d'Aosta | 1217 | 146 | 1056 | 15 | 45.73750286 | 7.320149366 | 2020-08-12 04:27:29 | Valle d'Aosta, Italy | ||
666275 | 666275 | 2020-09-16 | Italy | Valle d'Aosta | 1267 | 146 | 1079 | 42 | 45.73750286 | 7.320149366 | 2020-09-17 04:22:00 | Valle d'Aosta, Italy | ||
753756 | 753756 | 2020-08-01 | Italy | Valle d'Aosta | 1208 | 146 | 1050 | 12 | 45.73750286 | 7.320149366 | 2020-08-02 04:34:47 | 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 | ||
786374 | 786374 | 2020-10-15 | Italy | Valle d'Aosta | 1633 | 146 | 1127 | 360 | 45.73750286 | 7.320149366 | 2020-10-16 04:24:01 | Valle d'Aosta, Italy | ||
813573 | 813573 | 2020-09-05 | Italy | Valle d'Aosta | 1249 | 146 | 1069 | 34 | 45.73750286 | 7.320149366 | 2020-09-06 04:28:33 | Valle d'Aosta, Italy | ||
817564 | 817564 | 2020-10-09 | Italy | Valle d'Aosta | 1402 | 146 | 1117 | 139 | 45.73750286 | 7.320149366 | 2020-10-10 04:23:57 | 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 | ||
845009 | 845009 | 2020-07-22 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-23 05:15:04 | Valle d'Aosta, Italy | ||
887563 | 887563 | 2020-07-07 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-08 05:33:48 | 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 | ||
1005739 | 1005739 | 2020-07-09 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-10 04:34:24 | Valle d'Aosta, Italy | ||
1026349 | 1026349 | 2020-10-17 | Italy | Valle d'Aosta | 1738 | 146 | 1134 | 458 | 45.73750286 | 7.320149366 | 2020-10-18 04:24:25 | Valle d'Aosta, Italy | ||
1041821 | 1041821 | 2020-10-07 | Italy | Valle d'Aosta | 1366 | 146 | 1113 | 107 | 45.73750286 | 7.320149366 | 2020-10-08 04:23:56 | 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 | ||
1105550 | 1105550 | 2020-09-02 | Italy | Valle d'Aosta | 1243 | 146 | 1065 | 32 | 45.73750286 | 7.320149366 | 2020-09-03 04:28:22 | Valle d'Aosta, Italy | ||
1121586 | 1121586 | 2020-09-17 | Italy | Valle d'Aosta | 1268 | 146 | 1081 | 41 | 45.73750286 | 7.320149366 | 2020-09-18 05:05:00 | Valle d'Aosta, Italy | ||
1136331 | 1136331 | 2020-06-26 | Italy | Valle d'Aosta | 1194 | 146 | 1044 | 4 | 45.73750286 | 7.320149366 | 2020-06-27 04:33:35 | Valle d'Aosta, Italy | ||
1173180 | 1173180 | 2020-09-10 | Italy | Valle d'Aosta | 1254 | 146 | 1077 | 31 | 45.73750286 | 7.320149366 | 2020-09-11 04:46:23 | Valle d'Aosta, Italy | ||
1243754 | 1243754 | 2020-09-08 | Italy | Valle d'Aosta | 1254 | 146 | 1069 | 39 | 45.73750286 | 7.320149366 | 2020-09-09 04:28:48 | Valle d'Aosta, Italy | ||
1354313 | 1354313 | 2020-09-03 | Italy | Valle d'Aosta | 1247 | 146 | 1065 | 36 | 45.73750286 | 7.320149366 | 2020-09-04 04:28:26 | Valle d'Aosta, Italy | ||
1444579 | 1444579 | 2020-09-11 | Italy | Valle d'Aosta | 1257 | 146 | 1078 | 33 | 45.73750286 | 7.320149366 | 2020-09-12 04:25:05 | Valle d'Aosta, Italy | ||
1479553 | 1479553 | 2020-08-21 | Italy | Valle d'Aosta | 1221 | 146 | 1064 | 11 | 45.73750286 | 7.320149366 | 2020-08-22 04:27:49 | Valle d'Aosta, Italy | ||
1503018 | 1503018 | 2020-07-25 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-26 04:35:00 | Valle d'Aosta, Italy | ||
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 | ||
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 | ||
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 | ||
1523180 | 1523180 | 2020-08-28 | Italy | Valle d'Aosta | 1226 | 146 | 1065 | 15 | 45.73750286 | 7.320149366 | 2020-08-29 04:28:19 | Valle d'Aosta, Italy | ||
1555967 | 1555967 | 2020-08-16 | Italy | Valle d'Aosta | 1217 | 146 | 1062 | 9 | 45.73750286 | 7.320149366 | 2020-08-17 04:27:20 | Valle d'Aosta, Italy | ||
1612244 | 1612244 | 2020-08-14 | Italy | Valle d'Aosta | 1217 | 146 | 1058 | 13 | 45.73750286 | 7.320149366 | 2020-08-15 04:27:31 | Valle d'Aosta, Italy | ||
1691747 | 1691747 | 2020-06-19 | Italy | Valle d'Aosta | 1191 | 146 | 1041 | 4 | 45.73750286 | 7.320149366 | 2020-06-20 04:33:19 | Valle d'Aosta, Italy | ||
1707748 | 1707748 | 2020-07-21 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-22 04:34: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 | ||
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 | ||
1920641 | 1920641 | 2020-08-10 | Italy | Valle d'Aosta | 1217 | 146 | 1056 | 15 | 45.73750286 | 7.320149366 | 2020-08-11 04:35:08 | Valle d'Aosta, Italy | ||
1928627 | 1928627 | 2020-07-30 | Italy | Valle d'Aosta | 1208 | 146 | 1050 | 12 | 45.73750286 | 7.320149366 | 2020-07-31 04:35:18 | Valle d'Aosta, Italy | ||
1996641 | 1996641 | 2020-08-26 | Italy | Valle d'Aosta | 1223 | 146 | 1065 | 12 | 45.73750286 | 7.320149366 | 2020-08-27 04:28:15 | Valle d'Aosta, Italy | ||
2040050 | 2040050 | 2020-06-27 | Italy | Valle d'Aosta | 1194 | 146 | 1044 | 4 | 45.73750286 | 7.320149366 | 2020-06-28 04:34:04 | Valle d'Aosta, Italy | ||
2059879 | 2059879 | 2020-09-01 | Italy | Valle d'Aosta | 1241 | 146 | 1065 | 30 | 45.73750286 | 7.320149366 | 2020-09-02 04:28:25 | Valle d'Aosta, Italy | ||
2158957 | 2158957 | 2020-07-14 | Italy | Valle d'Aosta | 1196 | 146 | 1046 | 4 | 45.73750286 | 7.320149366 | 2020-07-15 04:34:39 | Valle d'Aosta, Italy | ||
2171545 | 2171545 | 2020-09-09 | Italy | Valle d'Aosta | 1254 | 146 | 1074 | 34 | 45.73750286 | 7.320149366 | 2020-09-10 04:29:01 | 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 | ||
2215664 | 2215664 | 2020-08-23 | Italy | Valle d'Aosta | 1221 | 146 | 1064 | 11 | 45.73750286 | 7.320149366 | 2020-08-24 04:27:56 | 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 | ||
2234811 | 2234811 | 2020-07-03 | Italy | Valle d'Aosta | 1196 | 146 | 1046 | 4 | 45.73750286 | 7.320149366 | 2020-07-04 04:33:51 | Valle d'Aosta, Italy | ||
2291440 | 2291440 | 2020-10-12 | Italy | Valle d'Aosta | 1496 | 146 | 1125 | 225 | 45.73750286 | 7.320149366 | 2020-10-13 04:24:02 | Valle d'Aosta, Italy | ||
2299446 | 2299446 | 2020-08-22 | Italy | Valle d'Aosta | 1221 | 146 | 1064 | 11 | 45.73750286 | 7.320149366 | 2020-08-23 04:27:48 | Valle d'Aosta, Italy | ||
2306715 | 2306715 | 2020-06-28 | Italy | Valle d'Aosta | 1194 | 146 | 1044 | 4 | 45.73750286 | 7.320149366 | 2020-06-29 04:33:44 | 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 | ||
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 | ||
2454768 | 2454768 | 2020-09-19 | Italy | Valle d'Aosta | 1276 | 146 | 1082 | 48 | 45.73750286 | 7.320149366 | 2020-09-20 04:22:00 | Valle d'Aosta, Italy | ||
2510181 | 2510181 | 2020-08-27 | Italy | Valle d'Aosta | 1224 | 146 | 1065 | 13 | 45.73750286 | 7.320149366 | 2020-08-28 04:28:11 | 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 | ||
2563989 | 2563989 | 2020-07-24 | Italy | Valle d'Aosta | 1196 | 146 | 1049 | 1 | 45.73750286 | 7.320149366 | 2020-07-25 04:47:39 | 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 | ||
2602031 | 2602031 | 2020-10-10 | Italy | Valle d'Aosta | 1446 | 146 | 1120 | 180 | 45.73750286 | 7.320149366 | 2020-10-11 04:23:46 | 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 | ||
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 | ||
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 | ||
2633152 | 2633152 | 2020-06-29 | Italy | Valle d'Aosta | 1194 | 146 | 1045 | 3 | 45.73750286 | 7.320149366 | 2020-06-30 04:33:48 | 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 | ||
2661773 | 2661773 | 2020-09-04 | Italy | Valle d'Aosta | 1249 | 146 | 1068 | 35 | 45.73750286 | 7.320149366 | 2020-09-05 04:28:19 | 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 | ||
2689679 | 2689679 | 2020-10-08 | Italy | Valle d'Aosta | 1384 | 146 | 1116 | 122 | 45.73750286 | 7.320149366 | 2020-10-09 04:23:59 | 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 | ||
2708836 | 2708836 | 2020-07-17 | Italy | Valle d'Aosta | 1196 | 146 | 1048 | 2 | 45.73750286 | 7.320149366 | 2020-07-18 04:34:45 | Valle d'Aosta, Italy | ||
2729000 | 2729000 | 2020-09-15 | Italy | Valle d'Aosta | 1266 | 146 | 1078 | 42 | 45.73750286 | 7.320149366 | 2020-09-16 04:22:53 | Valle d'Aosta, Italy | ||
2740436 | 2740436 | 2020-08-03 | Italy | Valle d'Aosta | 1209 | 146 | 1050 | 13 | 45.73750286 | 7.320149366 | 2020-08-04 04:41:59 | Valle d'Aosta, Italy | ||
2748313 | 2748313 | 2020-07-15 | Italy | Valle d'Aosta | 1196 | 146 | 1048 | 2 | 45.73750286 | 7.320149366 | 2020-07-16 04:44:59 | Valle d'Aosta, Italy | ||
2808188 | 2808188 | 2020-08-02 | Italy | Valle d'Aosta | 1209 | 146 | 1050 | 13 | 45.73750286 | 7.320149366 | 2020-08-03 04:34:35 | 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 | ||
2836814 | 2836814 | 2020-09-21 | Italy | Valle d'Aosta | 1281 | 146 | 1087 | 48 | 45.73750286 | 7.320149366 | 2020-09-22 04:23:00 | Valle d'Aosta, Italy | ||
2848837 | 2848837 | 2020-09-18 | Italy | Valle d'Aosta | 1276 | 146 | 1081 | 49 | 45.73750286 | 7.320149366 | 2020-09-19 04:22:00 | Valle d'Aosta, Italy | ||
2856844 | 2856844 | 2020-10-16 | Italy | Valle d'Aosta | 1660 | 146 | 1132 | 382 | 45.73750286 | 7.320149366 | 2020-10-17 04:24:12 | Valle d'Aosta, Italy | ||
2868711 | 2868711 | 2020-09-13 | Italy | Valle d'Aosta | 1260 | 146 | 1078 | 36 | 45.73750286 | 7.320149366 | 2020-09-14 04:26:00 | Valle d'Aosta, Italy | ||
2958795 | 2958795 | 2020-07-29 | Italy | Valle d'Aosta | 1208 | 146 | 1049 | 13 | 45.73750286 | 7.320149366 | 2020-07-30 04:35:05 | Valle d'Aosta, Italy | ||
2974675 | 2974675 | 2020-06-30 | Italy | Valle d'Aosta | 1195 | 146 | 1045 | 4 | 45.73750286 | 7.320149366 | 2020-07-01 04:33:52 | Valle d'Aosta, Italy | ||
2991269 | 2991269 | 2020-08-24 | Italy | Valle d'Aosta | 1221 | 146 | 1064 | 11 | 45.73750286 | 7.320149366 | 2020-08-25 04:28:02 | Valle d'Aosta, Italy | ||
3045606 | 3045606 | 2020-07-02 | Italy | Valle d'Aosta | 1195 | 146 | 1046 | 3 | 45.73750286 | 7.320149366 | 2020-07-03 04:33:54 | 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]);