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 = "P.A. Trento" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3675642 | 3675642 | 2021-05-04 | Italy | P.A. Trento | 44219 | 1346 | 41861 | 1012 | 46.06893511 | 11.12123097 | 2021-05-05 04:20:43 | P.A. Trento, Italy | ||
2760909 | 2760909 | 2021-05-03 | Italy | P.A. Trento | 44132 | 1346 | 41735 | 1051 | 46.06893511 | 11.12123097 | 2021-05-04 04:20:34 | P.A. Trento, Italy | ||
2450762 | 2450762 | 2021-05-02 | Italy | P.A. Trento | 44115 | 1345 | 41720 | 1050 | 46.06893511 | 11.12123097 | 2021-05-03 04:20:39 | P.A. Trento, Italy | ||
2824775 | 2824775 | 2021-05-01 | Italy | P.A. Trento | 44077 | 1345 | 41600 | 1132 | 46.06893511 | 11.12123097 | 2021-05-02 04:20:48 | P.A. Trento, Italy | ||
380183 | 380183 | 2021-04-30 | Italy | P.A. Trento | 43999 | 1344 | 41579 | 1076 | 46.06893511 | 11.12123097 | 2021-05-01 04:20:47 | P.A. Trento, Italy | ||
1636306 | 1636306 | 2021-04-29 | Italy | P.A. Trento | 43902 | 1343 | 41497 | 1062 | 46.06893511 | 11.12123097 | 2021-04-30 04:21:03 | P.A. Trento, Italy | ||
3393385 | 3393385 | 2021-04-28 | Italy | P.A. Trento | 43832 | 1340 | 41382 | 1110 | 46.06893511 | 11.12123097 | 2021-04-29 04:20:55 | P.A. Trento, Italy | ||
3702101 | 3702101 | 2021-04-27 | Italy | P.A. Trento | 43739 | 1338 | 41341 | 1060 | 46.06893511 | 11.12123097 | 2021-04-28 04:20:32 | P.A. Trento, Italy | ||
888110 | 888110 | 2021-04-26 | Italy | P.A. Trento | 43650 | 1335 | 41155 | 1160 | 46.06893511 | 11.12123097 | 2021-04-27 04:20:52 | P.A. Trento, Italy | ||
954855 | 954855 | 2021-04-25 | Italy | P.A. Trento | 43634 | 1334 | 41097 | 1203 | 46.06893511 | 11.12123097 | 2021-04-26 04:21:04 | P.A. Trento, Italy | ||
3924002 | 3924002 | 2021-04-24 | Italy | P.A. Trento | 43543 | 1334 | 40987 | 1222 | 46.06893511 | 11.12123097 | 2021-04-25 04:20:32 | P.A. Trento, Italy | ||
1409033 | 1409033 | 2021-04-23 | Italy | P.A. Trento | 43468 | 1333 | 40896 | 1239 | 46.06893511 | 11.12123097 | 2021-04-24 04:20:38 | P.A. Trento, Italy | ||
1568096 | 1568096 | 2021-04-22 | Italy | P.A. Trento | 43372 | 1333 | 40811 | 1228 | 46.06893511 | 11.12123097 | 2021-04-23 04:20:52 | P.A. Trento, Italy | ||
3242317 | 3242317 | 2021-04-21 | Italy | P.A. Trento | 43268 | 1329 | 40705 | 1234 | 46.06893511 | 11.12123097 | 2021-04-22 04:20:53 | P.A. Trento, Italy | ||
2020713 | 2020713 | 2021-04-20 | Italy | P.A. Trento | 43148 | 1328 | 40567 | 1253 | 46.06893511 | 11.12123097 | 2021-04-21 04:21:14 | P.A. Trento, Italy | ||
2410834 | 2410834 | 2021-04-19 | Italy | P.A. Trento | 43063 | 1324 | 40424 | 1315 | 46.06893511 | 11.12123097 | 2021-04-20 04:20:41 | P.A. Trento, Italy | ||
3129511 | 3129511 | 2021-04-18 | Italy | P.A. Trento | 43050 | 1324 | 40390 | 1336 | 46.06893511 | 11.12123097 | 2021-04-19 04:20:57 | P.A. Trento, Italy | ||
982939 | 982939 | 2021-04-17 | Italy | P.A. Trento | 42965 | 1323 | 40265 | 1377 | 46.06893511 | 11.12123097 | 2021-04-18 04:20:41 | P.A. Trento, Italy | ||
170034 | 170034 | 2021-04-16 | Italy | P.A. Trento | 42877 | 1322 | 40108 | 1447 | 46.06893511 | 11.12123097 | 2021-04-17 04:20:40 | P.A. Trento, Italy | ||
2548865 | 2548865 | 2021-04-15 | Italy | P.A. Trento | 42814 | 1318 | 40045 | 1451 | 46.06893511 | 11.12123097 | 2021-04-16 04:20:46 | P.A. Trento, Italy | ||
1841935 | 1841935 | 2021-04-14 | Italy | P.A. Trento | 42697 | 1315 | 39901 | 1481 | 46.06893511 | 11.12123097 | 2021-04-15 04:20:54 | P.A. Trento, Italy | ||
2571669 | 2571669 | 2021-04-13 | Italy | P.A. Trento | 42564 | 1314 | 39737 | 1513 | 46.06893511 | 11.12123097 | 2021-04-14 04:20:41 | P.A. Trento, Italy | ||
36420 | 36420 | 2021-04-12 | Italy | P.A. Trento | 42445 | 1311 | 39571 | 1563 | 46.06893511 | 11.12123097 | 2021-04-13 04:20:37 | P.A. Trento, Italy | ||
3883579 | 3883579 | 2021-04-11 | Italy | P.A. Trento | 42421 | 1311 | 39457 | 1653 | 46.06893511 | 11.12123097 | 2021-04-12 04:21:00 | P.A. Trento, Italy | ||
2983247 | 2983247 | 2021-04-10 | Italy | P.A. Trento | 42328 | 1311 | 39277 | 1740 | 46.06893511 | 11.12123097 | 2021-04-11 04:20:56 | P.A. Trento, Italy | ||
605679 | 605679 | 2021-04-09 | Italy | P.A. Trento | 42221 | 1309 | 39006 | 1906 | 46.06893511 | 11.12123097 | 2021-04-10 04:20:59 | P.A. Trento, Italy | ||
2645743 | 2645743 | 2021-04-08 | Italy | P.A. Trento | 42114 | 1307 | 38758 | 2049 | 46.06893511 | 11.12123097 | 2021-04-09 04:21:13 | P.A. Trento, Italy | ||
2247385 | 2247385 | 2021-04-07 | Italy | P.A. Trento | 41950 | 1306 | 38367 | 2277 | 46.06893511 | 11.12123097 | 2021-04-08 04:21:13 | P.A. Trento, Italy | ||
3003295 | 3003295 | 2021-04-06 | Italy | P.A. Trento | 41847 | 1301 | 38135 | 2411 | 46.06893511 | 11.12123097 | 2021-04-07 04:20:53 | P.A. Trento, Italy | ||
3085290 | 3085290 | 2021-04-05 | Italy | P.A. Trento | 41821 | 1297 | 37925 | 2599 | 46.06893511 | 11.12123097 | 2021-04-06 04:20:32 | P.A. Trento, Italy | ||
388213 | 388213 | 2021-04-04 | Italy | P.A. Trento | 41781 | 1297 | 37761 | 2723 | 46.06893511 | 11.12123097 | 2021-04-05 04:20:35 | P.A. Trento, Italy | ||
3710129 | 3710129 | 2021-04-03 | Italy | P.A. Trento | 41612 | 1295 | 37677 | 2640 | 46.06893511 | 11.12123097 | 2021-04-04 04:20:49 | P.A. Trento, Italy | ||
241245 | 241245 | 2021-04-02 | Italy | P.A. Trento | 41485 | 1289 | 37462 | 2734 | 46.06893511 | 11.12123097 | 2021-04-03 04:20:44 | P.A. Trento, Italy | ||
1302042 | 1302042 | 2021-04-01 | Italy | P.A. Trento | 41371 | 1286 | 37221 | 2864 | 46.06893511 | 11.12123097 | 2021-04-02 04:20:36 | P.A. Trento, Italy | ||
637914 | 637914 | 2021-03-31 | Italy | P.A. Trento | 41231 | 1282 | 37086 | 2863 | 46.06893511 | 11.12123097 | 2021-04-01 04:27:05 | P.A. Trento, Italy | ||
3643543 | 3643543 | 2021-03-30 | Italy | P.A. Trento | 41044 | 1282 | 36756 | 3006 | 46.06893511 | 11.12123097 | 2021-03-31 04:26:25 | P.A. Trento, Italy | ||
1289996 | 1289996 | 2021-03-29 | Italy | P.A. Trento | 40848 | 1278 | 36477 | 3093 | 46.06893511 | 11.12123097 | 2021-03-30 04:26:23 | P.A. Trento, Italy | ||
1535918 | 1535918 | 2021-03-28 | Italy | P.A. Trento | 40764 | 1277 | 36302 | 3185 | 46.06893511 | 11.12123097 | 2021-03-29 04:28:35 | P.A. Trento, Italy | ||
1219558 | 1219558 | 2021-03-27 | Italy | P.A. Trento | 40602 | 1276 | 36018 | 3308 | 46.06893511 | 11.12123097 | 2021-03-28 05:28:10 | P.A. Trento, Italy | ||
1880976 | 1880976 | 2021-03-26 | Italy | P.A. Trento | 40387 | 1273 | 35834 | 3280 | 46.06893511 | 11.12123097 | 2021-03-27 05:25:04 | P.A. Trento, Italy | ||
1980606 | 1980606 | 2021-03-25 | Italy | P.A. Trento | 40149 | 1268 | 35539 | 3342 | 46.06893511 | 11.12123097 | 2021-03-26 05:26:55 | P.A. Trento, Italy | ||
2780984 | 2780984 | 2021-03-24 | Italy | P.A. Trento | 39972 | 1268 | 35328 | 3376 | 46.06893511 | 11.12123097 | 2021-03-25 05:27:00 | P.A. Trento, Italy | ||
1798629 | 1798629 | 2021-03-23 | Italy | P.A. Trento | 39664 | 1265 | 34949 | 3450 | 46.06893511 | 11.12123097 | 2021-03-24 05:25:40 | P.A. Trento, Italy | ||
1203797 | 1203797 | 2021-03-22 | Italy | P.A. Trento | 39473 | 1261 | 34704 | 3508 | 46.06893511 | 11.12123097 | 2021-03-23 05:26:18 | P.A. Trento, Italy | ||
3369319 | 3369319 | 2021-03-21 | Italy | P.A. Trento | 39393 | 1255 | 34432 | 3706 | 46.06893511 | 11.12123097 | 2021-03-22 05:25:43 | P.A. Trento, Italy | ||
1744529 | 1744529 | 2021-03-20 | Italy | P.A. Trento | 39238 | 1254 | 34289 | 3695 | 46.06893511 | 11.12123097 | 2021-03-21 05:25:44 | P.A. Trento, Italy | ||
3420909 | 3420909 | 2021-03-19 | Italy | P.A. Trento | 38931 | 1252 | 33862 | 3817 | 46.06893511 | 11.12123097 | 2021-03-20 05:25:46 | P.A. Trento, Italy | ||
3452847 | 3452847 | 2021-03-18 | Italy | P.A. Trento | 38625 | 1249 | 33429 | 3947 | 46.06893511 | 11.12123097 | 2021-03-19 05:26:09 | P.A. Trento, Italy | ||
3621071 | 3621071 | 2021-03-17 | Italy | P.A. Trento | 38369 | 1246 | 33152 | 3971 | 46.06893511 | 11.12123097 | 2021-03-18 05:26:22 | P.A. Trento, Italy | ||
702395 | 702395 | 2021-03-16 | Italy | P.A. Trento | 38084 | 1243 | 32889 | 3952 | 46.06893511 | 11.12123097 | 2021-03-17 05:25:07 | P.A. Trento, Italy | ||
2055873 | 2055873 | 2021-03-15 | Italy | P.A. Trento | 37894 | 1241 | 32597 | 4056 | 46.06893511 | 11.12123097 | 2021-03-16 05:25:13 | P.A. Trento, Italy | ||
1732485 | 1732485 | 2021-03-14 | Italy | P.A. Trento | 37790 | 1237 | 32241 | 4312 | 46.06893511 | 11.12123097 | 2021-03-15 05:25:51 | P.A. Trento, Italy | ||
1580142 | 1580142 | 2021-03-13 | Italy | P.A. Trento | 37517 | 1236 | 32096 | 4185 | 46.06893511 | 11.12123097 | 2021-03-14 05:25:37 | P.A. Trento, Italy | ||
1837921 | 1837921 | 2021-03-12 | Italy | P.A. Trento | 37278 | 1234 | 31905 | 4139 | 46.06893511 | 11.12123097 | 2021-03-13 05:25:15 | P.A. Trento, Italy | ||
352286 | 352286 | 2021-03-11 | Italy | P.A. Trento | 36997 | 1233 | 31637 | 4127 | 46.06893511 | 11.12123097 | 2021-03-12 05:26:50 | P.A. Trento, Italy | ||
3962510 | 3962510 | 2021-03-10 | Italy | P.A. Trento | 36627 | 1232 | 31385 | 4010 | 46.06893511 | 11.12123097 | 2021-03-11 05:25:48 | P.A. Trento, Italy | ||
3663598 | 3663598 | 2021-03-09 | Italy | P.A. Trento | 36222 | 1227 | 31050 | 3945 | 46.06893511 | 11.12123097 | 2021-03-10 05:24:35 | P.A. Trento, Italy | ||
2359457 | 2359457 | 2021-03-08 | Italy | P.A. Trento | 36009 | 1226 | 30639 | 4144 | 46.06893511 | 11.12123097 | 2021-03-09 05:28:19 | P.A. Trento, Italy | ||
54795 | 54795 | 2021-03-07 | Italy | P.A. Trento | 35926 | 1222 | 30536 | 4168 | 46.06893511 | 11.12123097 | 2021-03-08 05:24:48 | P.A. Trento, Italy | ||
3667612 | 3667612 | 2021-03-06 | Italy | P.A. Trento | 35651 | 1220 | 30372 | 4059 | 46.06893511 | 11.12123097 | 2021-03-07 05:21:54 | P.A. Trento, Italy | ||
1616233 | 1616233 | 2021-03-05 | Italy | P.A. Trento | 35327 | 1216 | 30198 | 3913 | 46.06893511 | 11.12123097 | 2021-03-06 04:23:41 | P.A. Trento, Italy | ||
2207644 | 2207644 | 2021-03-04 | Italy | P.A. Trento | 34921 | 1213 | 30007 | 3701 | 46.06893511 | 11.12123097 | 2021-03-05 05:26:29 | P.A. Trento, Italy | ||
1090065 | 1090065 | 2021-03-03 | Italy | P.A. Trento | 34692 | 1211 | 29728 | 3753 | 46.06893511 | 11.12123097 | 2021-03-04 05:24:24 | P.A. Trento, Italy | ||
3254137 | 3254137 | 2021-03-02 | Italy | P.A. Trento | 34335 | 1209 | 29458 | 3668 | 46.06893511 | 11.12123097 | 2021-03-03 05:23:28 | P.A. Trento, Italy | ||
998429 | 998429 | 2021-03-01 | Italy | P.A. Trento | 34115 | 1208 | 29210 | 3697 | 46.06893511 | 11.12123097 | 2021-03-02 05:23:30 | P.A. Trento, Italy | ||
2367487 | 2367487 | 2021-02-28 | Italy | P.A. Trento | 34058 | 1206 | 28919 | 3933 | 46.06893511 | 11.12123097 | 2021-03-01 05:23:01 | P.A. Trento, Italy | ||
3065989 | 3065989 | 2021-02-27 | Italy | P.A. Trento | 33729 | 1206 | 28868 | 3655 | 46.06893511 | 11.12123097 | 2021-02-28 05:22:20 | P.A. Trento, Italy | ||
2183573 | 2183573 | 2021-02-26 | Italy | P.A. Trento | 33388 | 1204 | 28663 | 3521 | 46.06893511 | 11.12123097 | 2021-02-27 05:22:28 | P.A. Trento, Italy | ||
1857995 | 1857995 | 2021-02-25 | Italy | P.A. Trento | 33037 | 1203 | 28519 | 3315 | 46.06893511 | 11.12123097 | 2021-02-26 05:22:40 | P.A. Trento, Italy | ||
280173 | 280173 | 2021-02-24 | Italy | P.A. Trento | 32631 | 1200 | 28361 | 3070 | 46.06893511 | 11.12123097 | 2021-02-25 05:24:57 | P.A. Trento, Italy | ||
1936441 | 1936441 | 2021-02-23 | Italy | P.A. Trento | 32274 | 1197 | 28085 | 2992 | 46.06893511 | 11.12123097 | 2021-02-24 05:29:16 | P.A. Trento, Italy | ||
530696 | 530696 | 2021-02-22 | Italy | P.A. Trento | 32042 | 1196 | 27853 | 2993 | 46.06893511 | 11.12123097 | 2021-02-23 05:23:41 | P.A. Trento, Italy | ||
182030 | 182030 | 2021-02-21 | Italy | P.A. Trento | 31982 | 1194 | 27679 | 3109 | 46.06893511 | 11.12123097 | 2021-02-22 05:24:21 | P.A. Trento, Italy | ||
742304 | 742304 | 2021-02-20 | Italy | P.A. Trento | 31723 | 1194 | 27505 | 3024 | 46.06893511 | 11.12123097 | 2021-02-21 05:24:33 | P.A. Trento, Italy | ||
471402 | 471402 | 2021-02-19 | Italy | P.A. Trento | 31411 | 1193 | 27334 | 2884 | 46.06893511 | 11.12123097 | 2021-02-20 05:22:51 | P.A. Trento, Italy | ||
1153111 | 1153111 | 2021-02-18 | Italy | P.A. Trento | 31155 | 1189 | 27067 | 2899 | 46.06893511 | 11.12123097 | 2021-02-19 05:24:16 | P.A. Trento, Italy | ||
3601031 | 3601031 | 2021-02-17 | Italy | P.A. Trento | 30863 | 1187 | 26889 | 2787 | 46.06893511 | 11.12123097 | 2021-02-18 05:22:58 | P.A. Trento, Italy | ||
3050166 | 3050166 | 2021-02-16 | Italy | P.A. Trento | 30552 | 1183 | 26652 | 2717 | 46.06893511 | 11.12123097 | 2021-02-17 05:23:10 | P.A. Trento, Italy | ||
1338265 | 1338265 | 2021-02-15 | Italy | P.A. Trento | 30357 | 1179 | 26495 | 2683 | 46.06893511 | 11.12123097 | 2021-02-16 05:24:38 | P.A. Trento, Italy | ||
2283416 | 2283416 | 2021-02-14 | Italy | P.A. Trento | 30331 | 1177 | 26365 | 2789 | 46.06893511 | 11.12123097 | 2021-02-15 05:24:49 | P.A. Trento, Italy | ||
2677816 | 2677816 | 2021-02-13 | Italy | P.A. Trento | 30164 | 1176 | 26275 | 2713 | 46.06893511 | 11.12123097 | 2021-02-14 05:23:43 | P.A. Trento, Italy | ||
3539449 | 3539449 | 2021-02-12 | Italy | P.A. Trento | 29915 | 1176 | 26069 | 2670 | 46.06893511 | 11.12123097 | 2021-02-13 05:22:12 | P.A. Trento, Italy | ||
2637712 | 2637712 | 2021-02-11 | Italy | P.A. Trento | 29696 | 1175 | 25837 | 2684 | 46.06893511 | 11.12123097 | 2021-02-12 05:23:29 | P.A. Trento, Italy | ||
3978567 | 3978567 | 2021-02-10 | Italy | P.A. Trento | 29443 | 1174 | 25603 | 2666 | 46.06893511 | 11.12123097 | 2021-02-11 05:23:55 | P.A. Trento, Italy | ||
1527887 | 1527887 | 2021-02-09 | Italy | P.A. Trento | 29138 | 1173 | 25393 | 2572 | 46.06893511 | 11.12123097 | 2021-02-10 05:22:41 | P.A. Trento, Italy | ||
613678 | 613678 | 2021-02-08 | Italy | P.A. Trento | 28974 | 1170 | 25207 | 2597 | 46.06893511 | 11.12123097 | 2021-02-09 05:23:30 | P.A. Trento, Italy | ||
1672447 | 1672447 | 2021-02-07 | Italy | P.A. Trento | 28908 | 1165 | 25067 | 2676 | 46.06893511 | 11.12123097 | 2021-02-08 05:22:39 | P.A. Trento, Italy | ||
974908 | 974908 | 2021-02-06 | Italy | P.A. Trento | 28733 | 1160 | 24949 | 2624 | 46.06893511 | 11.12123097 | 2021-02-07 05:23:00 | P.A. Trento, Italy | ||
1588166 | 1588166 | 2021-02-05 | Italy | P.A. Trento | 28455 | 1158 | 24782 | 2515 | 46.06893511 | 11.12123097 | 2021-02-06 05:23:55 | P.A. Trento, Italy | ||
790373 | 790373 | 2021-02-04 | Italy | P.A. Trento | 28253 | 1158 | 24653 | 2442 | 46.06893511 | 11.12123097 | 2021-02-05 05:22:38 | P.A. Trento, Italy | ||
340265 | 340265 | 2021-02-03 | Italy | P.A. Trento | 28013 | 1153 | 24365 | 2495 | 46.06893511 | 11.12123097 | 2021-02-04 05:22:26 | P.A. Trento, Italy | ||
1684491 | 1684491 | 2021-02-02 | Italy | P.A. Trento | 27752 | 1150 | 24206 | 2396 | 46.06893511 | 11.12123097 | 2021-02-03 05:22:52 | P.A. Trento, Italy | ||
1676461 | 1676461 | 2021-02-01 | Italy | P.A. Trento | 27580 | 1147 | 23930 | 2503 | 46.06893511 | 11.12123097 | 2021-02-02 05:22:49 | P.A. Trento, Italy | ||
1459749 | 1459749 | 2021-01-31 | Italy | P.A. Trento | 27527 | 1147 | 23911 | 2469 | 46.06893511 | 11.12123097 | 2021-02-01 05:22:53 | P.A. Trento, Italy | ||
2211657 | 2211657 | 2021-01-30 | Italy | P.A. Trento | 27392 | 1146 | 23781 | 2465 | 46.06893511 | 11.12123097 | 2021-01-31 05:22:42 | P.A. Trento, Italy | ||
1897144 | 1897144 | 2021-01-29 | Italy | P.A. Trento | 27162 | 1144 | 23647 | 2371 | 46.06893511 | 11.12123097 | 2021-01-30 05:22:49 | P.A. Trento, Italy | ||
2481960 | 2481960 | 2021-01-28 | Italy | P.A. Trento | 26855 | 1143 | 23549 | 2163 | 46.06893511 | 11.12123097 | 2021-01-29 05:22:23 | P.A. Trento, Italy | ||
3153595 | 3153595 | 2021-01-27 | Italy | P.A. Trento | 26648 | 1143 | 23437 | 2068 | 46.06893511 | 11.12123097 | 2021-01-28 05:22:24 | P.A. Trento, Italy | ||
12330 | 12330 | 2021-01-26 | Italy | P.A. Trento | 26406 | 1141 | 23246 | 2019 | 46.06893511 | 11.12123097 | 2021-01-27 05:23:41 | P.A. Trento, Italy | ||
2567654 | 2567654 | 2021-01-25 | Italy | P.A. Trento | 26249 | 1134 | 23047 | 2068 | 46.06893511 | 11.12123097 | 2021-01-26 05:22:02 | P.A. Trento, 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]);