johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
longitude 23 ✖
- 11.12123097 956
- 11.25588885 956
- 12.33845213 956
- 12.38824698 956
- 16.86736689 956
- 7.320149366 956
- 7.680687483 956
- 9.110616306 956
- 11.35662422 955
- 12.48366722 955
- 13.39843823 955
- 13.5188753 955
- 13.76813649 955
- 14.25084984 955
- 14.65916051 955
- 15.80514834 955
- 16.59440194 955
- 8.9326992 955
- 9.190347404 955
- 13.362356699999998 696
- 11.3417208 647
- 11.341720800000001 308
- 13.3623567 260
province_or_state 21
- P.A. Trento 956
- Piemonte 956
- Puglia 956
- Sardegna 956
- Sicilia 956
- Toscana 956
- Umbria 956
- Valle d'Aosta 956
- Veneto 956
- Abruzzo 955
- Basilicata 955
- Calabria 955
- Campania 955
- Emilia-Romagna 955
- Friuli Venezia Giulia 955
- Lazio 955
- Liguria 955
- Lombardia 955
- Marche 955
- Molise 955
- P.A. Bolzano 955
country_or_region 1
- Italy · 20,064 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3260930 | 3260930 | 2020-05-18 | Italy | P.A. Trento | 4351 | 453 | 3650 | 248 | 46.06893511 | 11.12123097 | 2020-05-19 02:32:18 | P.A. Trento, Italy | ||
3260932 | 3260932 | 2020-05-18 | Italy | Piemonte | 29619 | 3632 | 16113 | 9874 | 45.0732745 | 7.680687483 | 2020-05-19 02:32:18 | Piemonte, Italy | ||
3260935 | 3260935 | 2020-05-18 | Italy | Puglia | 4386 | 471 | 1920 | 1995 | 41.12559576 | 16.86736689 | 2020-05-19 02:32:18 | Puglia, Italy | ||
3260948 | 3260948 | 2020-05-18 | Italy | Sardegna | 1353 | 126 | 847 | 380 | 39.21531192 | 9.110616306 | 2020-05-19 02:32:18 | Sardegna, Italy | ||
3260956 | 3260956 | 2020-05-18 | Italy | Sicilia | 3395 | 267 | 1589 | 1539 | 38.11569725 | 13.362356699999998 | 2020-05-19 02:32:18 | Sicilia, Italy | ||
3260964 | 3260964 | 2020-05-18 | Italy | Toscana | 9961 | 989 | 6399 | 2573 | 43.76923077 | 11.25588885 | 2020-05-19 02:32:18 | Toscana, Italy | ||
3260966 | 3260966 | 2020-05-18 | Italy | Umbria | 1424 | 73 | 1274 | 77 | 43.10675841 | 12.38824698 | 2020-05-19 02:32:18 | Umbria, 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 | ||
3260969 | 3260969 | 2020-05-18 | Italy | Veneto | 18950 | 1803 | 13143 | 4004 | 45.43490485 | 12.33845213 | 2020-05-19 02:32:18 | Veneto, Italy | ||
2390091 | 2390091 | 2020-05-19 | Italy | Abruzzo | 3197 | 389 | 1419 | 1389 | 42.35122196 | 13.39843823 | 2020-05-20 02:32:19 | Abruzzo, Italy | ||
2390102 | 2390102 | 2020-05-19 | Italy | Basilicata | 393 | 27 | 282 | 84 | 40.63947052 | 15.80514834 | 2020-05-20 02:32:19 | Basilicata, Italy | ||
2390113 | 2390113 | 2020-05-19 | Italy | Calabria | 1153 | 95 | 676 | 382 | 38.90597598 | 16.59440194 | 2020-05-20 02:32:19 | Calabria, Italy | ||
2390114 | 2390114 | 2020-05-19 | Italy | Campania | 4707 | 399 | 2790 | 1518 | 40.83956555 | 14.25084984 | 2020-05-20 02:32:19 | Campania, Italy | ||
2390128 | 2390128 | 2020-05-19 | Italy | Emilia-Romagna | 27314 | 3997 | 17987 | 5330 | 44.49436681 | 11.341720800000001 | 2020-05-20 02:32:19 | Emilia-Romagna, Italy | ||
2390134 | 2390134 | 2020-05-19 | Italy | Friuli Venezia Giulia | 3203 | 320 | 2283 | 600 | 45.6494354 | 13.76813649 | 2020-05-20 02:32:19 | Friuli Venezia Giulia, Italy | ||
2390162 | 2390162 | 2020-05-19 | Italy | Lazio | 7505 | 640 | 3079 | 3786 | 41.89277044 | 12.48366722 | 2020-05-20 02:32:19 | Lazio, Italy | ||
2390164 | 2390164 | 2020-05-19 | Italy | Liguria | 9257 | 1376 | 5617 | 2264 | 44.41149315 | 8.9326992 | 2020-05-20 02:32:19 | Liguria, Italy | ||
2390165 | 2390165 | 2020-05-19 | Italy | Lombardia | 85481 | 15597 | 42593 | 27291 | 45.46679409 | 9.190347404 | 2020-05-20 02:32:19 | Lombardia, Italy | ||
2390169 | 2390169 | 2020-05-19 | Italy | Marche | 6675 | 986 | 3561 | 2128 | 43.61675973 | 13.5188753 | 2020-05-20 02:32:19 | Marche, Italy | ||
2390174 | 2390174 | 2020-05-19 | Italy | Molise | 422 | 22 | 188 | 212 | 41.55774754 | 14.65916051 | 2020-05-20 02:32:19 | Molise, Italy | ||
2390191 | 2390191 | 2020-05-19 | Italy | P.A. Bolzano | 2587 | 291 | 1988 | 308 | 46.49933453 | 11.35662422 | 2020-05-20 02:32:19 | P.A. Bolzano, Italy | ||
2390192 | 2390192 | 2020-05-19 | Italy | P.A. Trento | 4358 | 455 | 3699 | 204 | 46.06893511 | 11.12123097 | 2020-05-20 02:32:19 | P.A. Trento, Italy | ||
2390194 | 2390194 | 2020-05-19 | Italy | Piemonte | 29727 | 3679 | 16413 | 9635 | 45.0732745 | 7.680687483 | 2020-05-20 02:32:19 | Piemonte, Italy | ||
2390197 | 2390197 | 2020-05-19 | Italy | Puglia | 4396 | 473 | 1982 | 1941 | 41.12559576 | 16.86736689 | 2020-05-20 02:32:19 | Puglia, Italy | ||
2390210 | 2390210 | 2020-05-19 | Italy | Sardegna | 1354 | 126 | 887 | 341 | 39.21531192 | 9.110616306 | 2020-05-20 02:32:19 | Sardegna, Italy | ||
2390218 | 2390218 | 2020-05-19 | Italy | Sicilia | 3403 | 268 | 1611 | 1524 | 38.11569725 | 13.362356699999998 | 2020-05-20 02:32:19 | Sicilia, Italy | ||
2390226 | 2390226 | 2020-05-19 | Italy | Toscana | 9968 | 992 | 6653 | 2323 | 43.76923077 | 11.25588885 | 2020-05-20 02:32:19 | Toscana, Italy | ||
2390228 | 2390228 | 2020-05-19 | Italy | Umbria | 1427 | 74 | 1287 | 66 | 43.10675841 | 12.38824698 | 2020-05-20 02:32:19 | Umbria, Italy | ||
2390230 | 2390230 | 2020-05-19 | Italy | Valle d'Aosta | 1175 | 143 | 983 | 49 | 45.73750286 | 7.320149366 | 2020-05-20 02:32:19 | Valle d'Aosta, Italy | ||
2390231 | 2390231 | 2020-05-19 | Italy | Veneto | 18997 | 1820 | 13423 | 3754 | 45.43490485 | 12.33845213 | 2020-05-20 02:32:19 | Veneto, Italy | ||
1431797 | 1431797 | 2020-05-20 | Italy | Abruzzo | 3205 | 389 | 1499 | 1317 | 42.35122196 | 13.39843823 | 2020-05-21 02:32:48 | Abruzzo, Italy | ||
1431821 | 1431821 | 2020-05-20 | Italy | Basilicata | 393 | 27 | 293 | 73 | 40.63947052 | 15.80514834 | 2020-05-21 02:32:48 | Basilicata, Italy | ||
1431833 | 1431833 | 2020-05-20 | Italy | Calabria | 1156 | 96 | 707 | 353 | 38.90597598 | 16.59440194 | 2020-05-21 02:32:48 | Calabria, Italy | ||
1431834 | 1431834 | 2020-05-20 | Italy | Campania | 4714 | 401 | 2871 | 1442 | 40.83956555 | 14.25084984 | 2020-05-21 02:32:48 | Campania, Italy | ||
1431857 | 1431857 | 2020-05-20 | Italy | Emilia-Romagna | 27364 | 4008 | 18258 | 5098 | 44.49436681 | 11.3417208 | 2020-05-21 02:32:48 | Emilia-Romagna, Italy | ||
1431864 | 1431864 | 2020-05-20 | Italy | Friuli Venezia Giulia | 3209 | 322 | 2291 | 596 | 45.6494354 | 13.76813649 | 2020-05-21 02:32:48 | Friuli Venezia Giulia, Italy | ||
1431897 | 1431897 | 2020-05-20 | Italy | Lazio | 7533 | 647 | 3100 | 3786 | 41.89277044 | 12.48366722 | 2020-05-21 02:32:48 | Lazio, Italy | ||
1431899 | 1431899 | 2020-05-20 | Italy | Liguria | 9289 | 1386 | 5725 | 2178 | 44.41149315 | 8.9326992 | 2020-05-21 02:32:48 | Liguria, Italy | ||
1431900 | 1431900 | 2020-05-20 | Italy | Lombardia | 85775 | 15662 | 43442 | 26671 | 45.46679409 | 9.190347404 | 2020-05-21 02:32:48 | Lombardia, Italy | ||
1431908 | 1431908 | 2020-05-20 | Italy | Marche | 6677 | 987 | 3716 | 1974 | 43.61675973 | 13.5188753 | 2020-05-21 02:32:48 | Marche, Italy | ||
1431920 | 1431920 | 2020-05-20 | Italy | Molise | 422 | 22 | 202 | 198 | 41.55774754 | 14.65916051 | 2020-05-21 02:32:48 | Molise, Italy | ||
1431943 | 1431943 | 2020-05-20 | Italy | P.A. Bolzano | 2587 | 291 | 2024 | 272 | 46.49933453 | 11.35662422 | 2020-05-21 02:32:48 | P.A. Bolzano, Italy | ||
1431944 | 1431944 | 2020-05-20 | Italy | P.A. Trento | 4368 | 455 | 3787 | 126 | 46.06893511 | 11.12123097 | 2020-05-21 02:32:48 | P.A. Trento, Italy | ||
1431951 | 1431951 | 2020-05-20 | Italy | Piemonte | 29885 | 3718 | 17016 | 9151 | 45.0732745 | 7.680687483 | 2020-05-21 02:32:48 | Piemonte, Italy | ||
1431955 | 1431955 | 2020-05-20 | Italy | Puglia | 4407 | 478 | 2027 | 1902 | 41.12559576 | 16.86736689 | 2020-05-21 02:32:48 | Puglia, Italy | ||
1431978 | 1431978 | 2020-05-20 | Italy | Sardegna | 1355 | 126 | 898 | 331 | 39.21531192 | 9.110616306 | 2020-05-21 02:32:48 | Sardegna, Italy | ||
1431987 | 1431987 | 2020-05-20 | Italy | Sicilia | 3411 | 268 | 1620 | 1523 | 38.11569725 | 13.362356699999998 | 2020-05-21 02:32:48 | Sicilia, Italy | ||
1432002 | 1432002 | 2020-05-20 | Italy | Toscana | 9982 | 998 | 6867 | 2117 | 43.76923077 | 11.25588885 | 2020-05-21 02:32:48 | Toscana, Italy | ||
1432004 | 1432004 | 2020-05-20 | Italy | Umbria | 1427 | 74 | 1287 | 66 | 43.10675841 | 12.38824698 | 2020-05-21 02:32:48 | Umbria, Italy | ||
1432009 | 1432009 | 2020-05-20 | Italy | Valle d'Aosta | 1175 | 143 | 986 | 46 | 45.73750286 | 7.320149366 | 2020-05-21 02:32:48 | Valle d'Aosta, Italy | ||
1432011 | 1432011 | 2020-05-20 | Italy | Veneto | 19030 | 1832 | 13666 | 3532 | 45.43490485 | 12.33845213 | 2020-05-21 02:32:48 | Veneto, Italy | ||
268214 | 268214 | 2020-05-21 | Italy | Abruzzo | 3212 | 391 | 1549 | 1272 | 42.35122196 | 13.39843823 | 2020-05-22 02:36:51 | Abruzzo, Italy | ||
268238 | 268238 | 2020-05-21 | Italy | Basilicata | 394 | 27 | 307 | 60 | 40.63947052 | 15.80514834 | 2020-05-22 02:36:51 | Basilicata, Italy | ||
268250 | 268250 | 2020-05-21 | Italy | Calabria | 1156 | 96 | 734 | 326 | 38.90597598 | 16.59440194 | 2020-05-22 02:36:51 | Calabria, Italy | ||
268251 | 268251 | 2020-05-21 | Italy | Campania | 4723 | 403 | 2947 | 1373 | 40.83956555 | 14.25084984 | 2020-05-22 02:36:51 | Campania, Italy | ||
268274 | 268274 | 2020-05-21 | Italy | Emilia-Romagna | 27417 | 4025 | 18466 | 4926 | 44.49436681 | 11.3417208 | 2020-05-22 02:36:51 | Emilia-Romagna, Italy | ||
268281 | 268281 | 2020-05-21 | Italy | Friuli Venezia Giulia | 3215 | 323 | 2314 | 578 | 45.6494354 | 13.76813649 | 2020-05-22 02:36:51 | Friuli Venezia Giulia, Italy | ||
268314 | 268314 | 2020-05-21 | Italy | Lazio | 7558 | 662 | 3259 | 3637 | 41.89277044 | 12.48366722 | 2020-05-22 02:36:51 | Lazio, Italy | ||
268316 | 268316 | 2020-05-21 | Italy | Liguria | 9344 | 1397 | 5872 | 2075 | 44.41149315 | 8.9326992 | 2020-05-22 02:36:51 | Liguria, Italy | ||
268317 | 268317 | 2020-05-21 | Italy | Lombardia | 86091 | 15727 | 43649 | 26715 | 45.46679409 | 9.190347404 | 2020-05-22 02:36:51 | Lombardia, Italy | ||
268325 | 268325 | 2020-05-21 | Italy | Marche | 6689 | 990 | 3867 | 1832 | 43.61675973 | 13.5188753 | 2020-05-22 02:36:51 | Marche, Italy | ||
268337 | 268337 | 2020-05-21 | Italy | Molise | 423 | 22 | 207 | 194 | 41.55774754 | 14.65916051 | 2020-05-22 02:36:51 | Molise, Italy | ||
268360 | 268360 | 2020-05-21 | Italy | P.A. Bolzano | 2587 | 291 | 2046 | 250 | 46.49933453 | 11.35662422 | 2020-05-22 02:36:51 | P.A. Bolzano, Italy | ||
268361 | 268361 | 2020-05-21 | Italy | P.A. Trento | 4378 | 455 | 3857 | 66 | 46.06893511 | 11.12123097 | 2020-05-22 02:36:51 | P.A. Trento, Italy | ||
268368 | 268368 | 2020-05-21 | Italy | Piemonte | 29990 | 3742 | 17538 | 8710 | 45.0732745 | 7.680687483 | 2020-05-22 02:36:51 | Piemonte, Italy | ||
268372 | 268372 | 2020-05-21 | Italy | Puglia | 4413 | 478 | 2096 | 1839 | 41.12559576 | 16.86736689 | 2020-05-22 02:36:51 | Puglia, Italy | ||
268395 | 268395 | 2020-05-21 | Italy | Sardegna | 1356 | 127 | 911 | 318 | 39.21531192 | 9.110616306 | 2020-05-22 02:36:51 | Sardegna, Italy | ||
268404 | 268404 | 2020-05-21 | Italy | Sicilia | 3417 | 268 | 1627 | 1522 | 38.11569725 | 13.362356699999998 | 2020-05-22 02:36:51 | Sicilia, Italy | ||
268419 | 268419 | 2020-05-21 | Italy | Toscana | 10000 | 1004 | 7119 | 1877 | 43.76923077 | 11.25588885 | 2020-05-22 02:36:51 | Toscana, Italy | ||
268421 | 268421 | 2020-05-21 | Italy | Umbria | 1429 | 74 | 1294 | 61 | 43.10675841 | 12.38824698 | 2020-05-22 02:36:51 | Umbria, Italy | ||
268426 | 268426 | 2020-05-21 | Italy | Valle d'Aosta | 1176 | 143 | 990 | 43 | 45.73750286 | 7.320149366 | 2020-05-22 02:36:51 | Valle d'Aosta, Italy | ||
268428 | 268428 | 2020-05-21 | Italy | Veneto | 19038 | 1841 | 13911 | 3286 | 45.43490485 | 12.33845213 | 2020-05-22 02:36:51 | Veneto, Italy | ||
1864708 | 1864708 | 2020-05-22 | Italy | Abruzzo | 3220 | 394 | 1647 | 1179 | 42.35122196 | 13.39843823 | 2020-05-23 02:32:42 | Abruzzo, Italy | ||
1864732 | 1864732 | 2020-05-22 | Italy | Basilicata | 394 | 27 | 318 | 49 | 40.63947052 | 15.80514834 | 2020-05-23 02:32:42 | Basilicata, Italy | ||
1864744 | 1864744 | 2020-05-22 | Italy | Calabria | 1157 | 96 | 759 | 302 | 38.90597598 | 16.59440194 | 2020-05-23 02:32:42 | Calabria, Italy | ||
1864745 | 1864745 | 2020-05-22 | Italy | Campania | 4733 | 404 | 3037 | 1292 | 40.83956555 | 14.25084984 | 2020-05-23 02:32:42 | Campania, Italy | ||
1864768 | 1864768 | 2020-05-22 | Italy | Emilia-Romagna | 27470 | 4037 | 18703 | 4730 | 44.49436681 | 11.3417208 | 2020-05-23 02:32:42 | Emilia-Romagna, Italy | ||
1864775 | 1864775 | 2020-05-22 | Italy | Friuli Venezia Giulia | 3227 | 325 | 2417 | 485 | 45.6494354 | 13.76813649 | 2020-05-23 02:32:42 | Friuli Venezia Giulia, Italy | ||
1864808 | 1864808 | 2020-05-22 | Italy | Lazio | 7589 | 669 | 3285 | 3635 | 41.89277044 | 12.48366722 | 2020-05-23 02:32:42 | Lazio, Italy | ||
1864810 | 1864810 | 2020-05-22 | Italy | Liguria | 9389 | 1407 | 6074 | 1908 | 44.41149315 | 8.9326992 | 2020-05-23 02:32:42 | Liguria, Italy | ||
1864811 | 1864811 | 2020-05-22 | Italy | Lombardia | 86384 | 15784 | 44667 | 25933 | 45.46679409 | 9.190347404 | 2020-05-23 02:32:42 | Lombardia, Italy | ||
1864819 | 1864819 | 2020-05-22 | Italy | Marche | 6697 | 990 | 3939 | 1768 | 43.61675973 | 13.5188753 | 2020-05-23 02:32:42 | Marche, Italy | ||
1864831 | 1864831 | 2020-05-22 | Italy | Molise | 426 | 22 | 220 | 184 | 41.55774754 | 14.65916051 | 2020-05-23 02:32:42 | Molise, Italy | ||
1864854 | 1864854 | 2020-05-22 | Italy | P.A. Bolzano | 2590 | 291 | 2075 | 224 | 46.49933453 | 11.35662422 | 2020-05-23 02:32:42 | P.A. Bolzano, Italy | ||
1864855 | 1864855 | 2020-05-22 | Italy | P.A. Trento | 4388 | 455 | 3326 | 607 | 46.06893511 | 11.12123097 | 2020-05-23 02:32:42 | P.A. Trento, Italy | ||
1864862 | 1864862 | 2020-05-22 | Italy | Piemonte | 30077 | 3757 | 17868 | 8452 | 45.0732745 | 7.680687483 | 2020-05-23 02:32:42 | Piemonte, Italy | ||
1864866 | 1864866 | 2020-05-22 | Italy | Puglia | 4440 | 482 | 2120 | 1838 | 41.12559576 | 16.86736689 | 2020-05-23 02:32:42 | Puglia, Italy | ||
1864889 | 1864889 | 2020-05-22 | Italy | Sardegna | 1356 | 128 | 922 | 306 | 39.21531192 | 9.110616306 | 2020-05-23 02:32:42 | Sardegna, Italy | ||
1864898 | 1864898 | 2020-05-22 | Italy | Sicilia | 3421 | 268 | 1634 | 1519 | 38.11569725 | 13.362356699999998 | 2020-05-23 02:32:42 | Sicilia, Italy | ||
1864913 | 1864913 | 2020-05-22 | Italy | Toscana | 10035 | 1009 | 7240 | 1786 | 43.76923077 | 11.25588885 | 2020-05-23 02:32:42 | Toscana, Italy | ||
1864915 | 1864915 | 2020-05-22 | Italy | Umbria | 1429 | 74 | 1296 | 59 | 43.10675841 | 12.38824698 | 2020-05-23 02:32:42 | Umbria, Italy | ||
1864920 | 1864920 | 2020-05-22 | Italy | Valle d'Aosta | 1177 | 143 | 991 | 43 | 45.73750286 | 7.320149366 | 2020-05-23 02:32:42 | Valle d'Aosta, Italy | ||
1864922 | 1864922 | 2020-05-22 | Italy | Veneto | 19059 | 1854 | 14182 | 3023 | 45.43490485 | 12.33845213 | 2020-05-23 02:32:42 | Veneto, Italy | ||
997685 | 997685 | 2020-05-23 | Italy | Abruzzo | 3221 | 394 | 1659 | 1168 | 42.35122196 | 13.39843823 | 2020-05-24 02:32:43 | Abruzzo, Italy | ||
997709 | 997709 | 2020-05-23 | Italy | Basilicata | 398 | 27 | 330 | 41 | 40.63947052 | 15.80514834 | 2020-05-24 02:32:43 | Basilicata, Italy | ||
997721 | 997721 | 2020-05-23 | Italy | Calabria | 1157 | 96 | 773 | 288 | 38.90597598 | 16.59440194 | 2020-05-24 02:32:43 | Calabria, Italy | ||
997722 | 997722 | 2020-05-23 | Italy | Campania | 4744 | 404 | 3067 | 1273 | 40.83956555 | 14.25084984 | 2020-05-24 02:32:43 | Campania, 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 | ||
997752 | 997752 | 2020-05-23 | Italy | Friuli Venezia Giulia | 3233 | 327 | 2447 | 459 | 45.6494354 | 13.76813649 | 2020-05-24 02:32:43 | Friuli Venezia Giulia, Italy | ||
997785 | 997785 | 2020-05-23 | Italy | Lazio | 7607 | 676 | 3350 | 3581 | 41.89277044 | 12.48366722 | 2020-05-24 02:32:43 | Lazio, 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]);