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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- Abruzzo 297
- Basilicata 297
- Calabria 297
- Campania 297
- Emilia-Romagna 297
- Friuli Venezia Giulia 297
- Lazio 297
- Liguria 297
- Lombardia 297
- Marche 297
- Molise 297
- P.A. Bolzano 297
- P.A. Trento 297
- Piemonte 297
- Puglia 297
- Sardegna 297
- Sicilia 297
- Toscana 297
- Umbria 297
- Valle d'Aosta 297
- Veneto 297
country_or_region 1
- Italy · 6,341 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3667600 | 3667600 | 2021-03-06 | Italy | Abruzzo | 56944 | 1791 | 42046 | 13107 | 42.35122196 | 13.39843823 | 2021-03-07 05:21:54 | Abruzzo, Italy | ||
3667601 | 3667601 | 2021-03-06 | Italy | Basilicata | 16445 | 378 | 12113 | 3954 | 40.63947052 | 15.80514834 | 2021-03-07 05:21:54 | Basilicata, Italy | ||
3667602 | 3667602 | 2021-03-06 | Italy | Calabria | 39142 | 704 | 31853 | 6585 | 38.90597598 | 16.59440194 | 2021-03-07 05:21:54 | Calabria, Italy | ||
3667603 | 3667603 | 2021-03-06 | Italy | Campania | 282661 | 4451 | 190777 | 87433 | 40.83956555 | 14.25084984 | 2021-03-07 05:21:54 | Campania, Italy | ||
3667604 | 3667604 | 2021-03-06 | Italy | Emilia-Romagna | 276601 | 10746 | 213413 | 52442 | 44.49436681 | 11.3417208 | 2021-03-07 05:21:54 | Emilia-Romagna, Italy | ||
3667605 | 3667605 | 2021-03-06 | Italy | Friuli Venezia Giulia | 80283 | 2899 | 65698 | 11686 | 45.6494354 | 13.76813649 | 2021-03-07 05:21:54 | Friuli Venezia Giulia, Italy | ||
3667606 | 3667606 | 2021-03-06 | Italy | Lazio | 242770 | 6029 | 199572 | 37169 | 41.89277044 | 12.48366722 | 2021-03-07 05:21:54 | Lazio, Italy | ||
3667607 | 3667607 | 2021-03-06 | Italy | Liguria | 80016 | 3681 | 70475 | 5860 | 44.41149315 | 8.9326992 | 2021-03-07 05:21:54 | Liguria, Italy | ||
3667608 | 3667608 | 2021-03-06 | Italy | Lombardia | 629610 | 28705 | 520251 | 80654 | 45.46679409 | 9.190347404 | 2021-03-07 05:21:54 | Lombardia, Italy | ||
3667609 | 3667609 | 2021-03-06 | Italy | Marche | 72259 | 2318 | 59651 | 10290 | 43.61675973 | 13.5188753 | 2021-03-07 05:21:54 | Marche, Italy | ||
3667610 | 3667610 | 2021-03-06 | Italy | Molise | 11108 | 373 | 9042 | 1693 | 41.55774754 | 14.65916051 | 2021-03-07 05:21:54 | Molise, Italy | ||
3667611 | 3667611 | 2021-03-06 | Italy | P.A. Bolzano | 55142 | 1056 | 48475 | 5611 | 46.49933453 | 11.35662422 | 2021-03-07 05:21:54 | P.A. Bolzano, 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 | ||
3667613 | 3667613 | 2021-03-06 | Italy | Piemonte | 257678 | 9486 | 226737 | 21455 | 45.0732745 | 7.680687483 | 2021-03-07 05:21:54 | Piemonte, Italy | ||
3667614 | 3667614 | 2021-03-06 | Italy | Puglia | 154302 | 4087 | 115362 | 34853 | 41.12559576 | 16.86736689 | 2021-03-07 05:21:54 | Puglia, Italy | ||
3667615 | 3667615 | 2021-03-06 | Italy | Sardegna | 41650 | 1183 | 27821 | 12646 | 39.21531192 | 9.110616306 | 2021-03-07 05:21:54 | Sardegna, Italy | ||
3667616 | 3667616 | 2021-03-06 | Italy | Sicilia | 155812 | 4223 | 131862 | 19727 | 38.11569725 | 13.362356699999998 | 2021-03-07 05:21:54 | Sicilia, Italy | ||
3667617 | 3667617 | 2021-03-06 | Italy | Toscana | 163096 | 4784 | 137614 | 20698 | 43.76923077 | 11.25588885 | 2021-03-07 05:21:54 | Toscana, Italy | ||
3667618 | 3667618 | 2021-03-06 | Italy | Umbria | 46197 | 1095 | 37677 | 7425 | 43.10675841 | 12.38824698 | 2021-03-07 05:21:54 | Umbria, Italy | ||
3667619 | 3667619 | 2021-03-06 | Italy | Valle d'Aosta | 8114 | 416 | 7525 | 173 | 45.73750286 | 7.320149366 | 2021-03-07 05:21:54 | Valle d'Aosta, Italy | ||
3667620 | 3667620 | 2021-03-06 | Italy | Veneto | 341281 | 9953 | 303036 | 28292 | 45.43490485 | 12.33845213 | 2021-03-07 05:21:54 | Veneto, Italy | ||
1616221 | 1616221 | 2021-03-05 | Italy | Abruzzo | 56503 | 1766 | 41621 | 13116 | 42.35122196 | 13.39843823 | 2021-03-06 04:23:41 | Abruzzo, Italy | ||
1616222 | 1616222 | 2021-03-05 | Italy | Basilicata | 16267 | 376 | 12015 | 3876 | 40.63947052 | 15.80514834 | 2021-03-06 04:23:41 | Basilicata, Italy | ||
1616223 | 1616223 | 2021-03-05 | Italy | Calabria | 38849 | 700 | 31762 | 6387 | 38.90597598 | 16.59440194 | 2021-03-06 04:23:41 | Calabria, Italy | ||
1616224 | 1616224 | 2021-03-05 | Italy | Campania | 279818 | 4427 | 190181 | 85210 | 40.83956555 | 14.25084984 | 2021-03-06 04:23:41 | Campania, Italy | ||
1616225 | 1616225 | 2021-03-05 | Italy | Emilia-Romagna | 273376 | 10721 | 212341 | 50314 | 44.49436681 | 11.3417208 | 2021-03-06 04:23:41 | Emilia-Romagna, Italy | ||
1616226 | 1616226 | 2021-03-05 | Italy | Friuli Venezia Giulia | 79622 | 2888 | 65341 | 11393 | 45.6494354 | 13.76813649 | 2021-03-06 04:23:41 | Friuli Venezia Giulia, Italy | ||
1616227 | 1616227 | 2021-03-05 | Italy | Lazio | 241207 | 6016 | 198629 | 36562 | 41.89277044 | 12.48366722 | 2021-03-06 04:23:41 | Lazio, Italy | ||
1616228 | 1616228 | 2021-03-05 | Italy | Liguria | 79744 | 3674 | 70277 | 5793 | 44.41149315 | 8.9326992 | 2021-03-06 04:23:41 | Liguria, Italy | ||
1616229 | 1616229 | 2021-03-05 | Italy | Lombardia | 623952 | 28638 | 519186 | 76128 | 45.46679409 | 9.190347404 | 2021-03-06 04:23:41 | Lombardia, Italy | ||
1616230 | 1616230 | 2021-03-05 | Italy | Marche | 71423 | 2307 | 58913 | 10203 | 43.61675973 | 13.5188753 | 2021-03-06 04:23:41 | Marche, Italy | ||
1616231 | 1616231 | 2021-03-05 | Italy | Molise | 11059 | 370 | 8931 | 1758 | 41.55774754 | 14.65916051 | 2021-03-06 04:23:41 | Molise, Italy | ||
1616232 | 1616232 | 2021-03-05 | Italy | P.A. Bolzano | 54924 | 1052 | 47536 | 6336 | 46.49933453 | 11.35662422 | 2021-03-06 04:23:41 | P.A. Bolzano, 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 | ||
1616234 | 1616234 | 2021-03-05 | Italy | Piemonte | 255885 | 9461 | 225923 | 20501 | 45.0732745 | 7.680687483 | 2021-03-06 04:23:41 | Piemonte, Italy | ||
1616235 | 1616235 | 2021-03-05 | Italy | Puglia | 152819 | 4072 | 114497 | 34250 | 41.12559576 | 16.86736689 | 2021-03-06 04:23:41 | Puglia, Italy | ||
1616236 | 1616236 | 2021-03-05 | Italy | Sardegna | 41577 | 1179 | 27712 | 12686 | 39.21531192 | 9.110616306 | 2021-03-06 04:23:41 | Sardegna, Italy | ||
1616237 | 1616237 | 2021-03-05 | Italy | Sicilia | 155220 | 4213 | 128329 | 22678 | 38.11569725 | 13.362356699999998 | 2021-03-06 04:23:41 | Sicilia, Italy | ||
1616238 | 1616238 | 2021-03-05 | Italy | Toscana | 161803 | 4761 | 136890 | 20152 | 43.76923077 | 11.25588885 | 2021-03-06 04:23:41 | Toscana, Italy | ||
1616239 | 1616239 | 2021-03-05 | Italy | Umbria | 45914 | 1082 | 37229 | 7603 | 43.10675841 | 12.38824698 | 2021-03-06 04:23:41 | Umbria, Italy | ||
1616240 | 1616240 | 2021-03-05 | Italy | Valle d'Aosta | 8098 | 416 | 7511 | 171 | 45.73750286 | 7.320149366 | 2021-03-06 04:23:41 | Valle d'Aosta, Italy | ||
1616241 | 1616241 | 2021-03-05 | Italy | Veneto | 339742 | 9936 | 302366 | 27440 | 45.43490485 | 12.33845213 | 2021-03-06 04:23:41 | Veneto, Italy | ||
2207632 | 2207632 | 2021-03-04 | Italy | Abruzzo | 56031 | 1758 | 41194 | 13079 | 42.35122196 | 13.39843823 | 2021-03-05 05:26:29 | Abruzzo, Italy | ||
2207633 | 2207633 | 2021-03-04 | Italy | Basilicata | 16103 | 376 | 11540 | 4187 | 40.63947052 | 15.80514834 | 2021-03-05 05:26:29 | Basilicata, Italy | ||
2207634 | 2207634 | 2021-03-04 | Italy | Calabria | 38589 | 700 | 31535 | 6354 | 38.90597598 | 16.59440194 | 2021-03-05 05:26:29 | Calabria, Italy | ||
2207635 | 2207635 | 2021-03-04 | Italy | Campania | 276976 | 4414 | 189604 | 82958 | 40.83956555 | 14.25084984 | 2021-03-05 05:26:29 | Campania, Italy | ||
2207636 | 2207636 | 2021-03-04 | Italy | Emilia-Romagna | 270155 | 10675 | 211352 | 48128 | 44.49436681 | 11.3417208 | 2021-03-05 05:26:29 | Emilia-Romagna, Italy | ||
2207637 | 2207637 | 2021-03-04 | Italy | Friuli Venezia Giulia | 78799 | 2876 | 64983 | 10940 | 45.6494354 | 13.76813649 | 2021-03-05 05:26:29 | Friuli Venezia Giulia, Italy | ||
2207638 | 2207638 | 2021-03-04 | Italy | Lazio | 239682 | 5997 | 197642 | 36043 | 41.89277044 | 12.48366722 | 2021-03-05 05:26:29 | Lazio, Italy | ||
2207639 | 2207639 | 2021-03-04 | Italy | Liguria | 79406 | 3666 | 70055 | 5685 | 44.41149315 | 8.9326992 | 2021-03-05 05:26:29 | Liguria, Italy | ||
2207640 | 2207640 | 2021-03-04 | Italy | Lombardia | 618742 | 28577 | 517771 | 72394 | 45.46679409 | 9.190347404 | 2021-03-05 05:26:29 | Lombardia, Italy | ||
2207641 | 2207641 | 2021-03-04 | Italy | Marche | 70396 | 2295 | 57931 | 10170 | 43.61675973 | 13.5188753 | 2021-03-05 05:26:29 | Marche, Italy | ||
2207642 | 2207642 | 2021-03-04 | Italy | Molise | 10922 | 359 | 8838 | 1725 | 41.55774754 | 14.65916051 | 2021-03-05 05:26:29 | Molise, Italy | ||
2207643 | 2207643 | 2021-03-04 | Italy | P.A. Bolzano | 54694 | 1048 | 46989 | 6657 | 46.49933453 | 11.35662422 | 2021-03-05 05:26:29 | P.A. Bolzano, 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 | ||
2207645 | 2207645 | 2021-03-04 | Italy | Piemonte | 253602 | 9437 | 225008 | 19157 | 45.0732745 | 7.680687483 | 2021-03-05 05:26:29 | Piemonte, Italy | ||
2207646 | 2207646 | 2021-03-04 | Italy | Puglia | 151401 | 4053 | 113542 | 33806 | 41.12559576 | 16.86736689 | 2021-03-05 05:26:29 | Puglia, Italy | ||
2207647 | 2207647 | 2021-03-04 | Italy | Sardegna | 41488 | 1177 | 27610 | 12701 | 39.21531192 | 9.110616306 | 2021-03-05 05:26:29 | Sardegna, Italy | ||
2207648 | 2207648 | 2021-03-04 | Italy | Sicilia | 154701 | 4201 | 125955 | 24545 | 38.11569725 | 13.362356699999998 | 2021-03-05 05:26:29 | Sicilia, Italy | ||
2207649 | 2207649 | 2021-03-04 | Italy | Toscana | 160572 | 4750 | 136119 | 19703 | 43.76923077 | 11.25588885 | 2021-03-05 05:26:29 | Toscana, Italy | ||
2207650 | 2207650 | 2021-03-04 | Italy | Umbria | 45619 | 1075 | 36807 | 7737 | 43.10675841 | 12.38824698 | 2021-03-05 05:26:29 | Umbria, Italy | ||
2207651 | 2207651 | 2021-03-04 | Italy | Valle d'Aosta | 8083 | 416 | 7499 | 168 | 45.73750286 | 7.320149366 | 2021-03-05 05:26:29 | Valle d'Aosta, Italy | ||
2207652 | 2207652 | 2021-03-04 | Italy | Veneto | 338237 | 9911 | 301725 | 26601 | 45.43490485 | 12.33845213 | 2021-03-05 05:26:29 | Veneto, Italy | ||
1090053 | 1090053 | 2021-03-03 | Italy | Abruzzo | 55479 | 1731 | 40708 | 13040 | 42.35122196 | 13.39843823 | 2021-03-04 05:24:24 | Abruzzo, Italy | ||
1090054 | 1090054 | 2021-03-03 | Italy | Basilicata | 15981 | 375 | 11359 | 4247 | 40.63947052 | 15.80514834 | 2021-03-04 05:24:24 | Basilicata, Italy | ||
1090055 | 1090055 | 2021-03-03 | Italy | Calabria | 38363 | 697 | 31407 | 6259 | 38.90597598 | 16.59440194 | 2021-03-04 05:24:24 | Calabria, Italy | ||
1090056 | 1090056 | 2021-03-03 | Italy | Campania | 274196 | 4374 | 188570 | 81252 | 40.83956555 | 14.25084984 | 2021-03-04 05:24:24 | Campania, 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 | ||
1090058 | 1090058 | 2021-03-03 | Italy | Friuli Venezia Giulia | 78156 | 2866 | 64735 | 10555 | 45.6494354 | 13.76813649 | 2021-03-04 05:24:24 | Friuli Venezia Giulia, Italy | ||
1090059 | 1090059 | 2021-03-03 | Italy | Lazio | 237980 | 5975 | 196216 | 35789 | 41.89277044 | 12.48366722 | 2021-03-04 05:24:24 | Lazio, Italy | ||
1090060 | 1090060 | 2021-03-03 | Italy | Liguria | 78992 | 3659 | 69835 | 5498 | 44.41149315 | 8.9326992 | 2021-03-04 05:24:24 | Liguria, Italy | ||
1090061 | 1090061 | 2021-03-03 | Italy | Lombardia | 613568 | 28518 | 515714 | 69336 | 45.46679409 | 9.190347404 | 2021-03-04 05:24:24 | Lombardia, Italy | ||
1090062 | 1090062 | 2021-03-03 | Italy | Marche | 69477 | 2286 | 57279 | 9912 | 43.61675973 | 13.5188753 | 2021-03-04 05:24:24 | Marche, Italy | ||
1090063 | 1090063 | 2021-03-03 | Italy | Molise | 10866 | 357 | 8751 | 1758 | 41.55774754 | 14.65916051 | 2021-03-04 05:24:24 | Molise, Italy | ||
1090064 | 1090064 | 2021-03-03 | Italy | P.A. Bolzano | 54441 | 1044 | 46634 | 6763 | 46.49933453 | 11.35662422 | 2021-03-04 05:24:24 | P.A. Bolzano, 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 | ||
1090066 | 1090066 | 2021-03-03 | Italy | Piemonte | 251435 | 9411 | 224093 | 17931 | 45.0732745 | 7.680687483 | 2021-03-04 05:24:24 | Piemonte, Italy | ||
1090067 | 1090067 | 2021-03-03 | Italy | Puglia | 149963 | 4021 | 112274 | 33668 | 41.12559576 | 16.86736689 | 2021-03-04 05:24:24 | Puglia, Italy | ||
1090068 | 1090068 | 2021-03-03 | Italy | Sardegna | 41407 | 1173 | 27528 | 12706 | 39.21531192 | 9.110616306 | 2021-03-04 05:24:24 | Sardegna, Italy | ||
1090069 | 1090069 | 2021-03-03 | Italy | Sicilia | 154141 | 4187 | 124825 | 25129 | 38.11569725 | 13.362356699999998 | 2021-03-04 05:24:24 | Sicilia, Italy | ||
1090070 | 1090070 | 2021-03-03 | Italy | Toscana | 159333 | 4727 | 135347 | 19259 | 43.76923077 | 11.25588885 | 2021-03-04 05:24:24 | Toscana, Italy | ||
1090071 | 1090071 | 2021-03-03 | Italy | Umbria | 45352 | 1067 | 36347 | 7938 | 43.10675841 | 12.38824698 | 2021-03-04 05:24:24 | Umbria, Italy | ||
1090072 | 1090072 | 2021-03-03 | Italy | Valle d'Aosta | 8072 | 415 | 7491 | 166 | 45.73750286 | 7.320149366 | 2021-03-04 05:24:24 | Valle d'Aosta, Italy | ||
1090073 | 1090073 | 2021-03-03 | Italy | Veneto | 336750 | 9891 | 301095 | 25764 | 45.43490485 | 12.33845213 | 2021-03-04 05:24:24 | Veneto, Italy | ||
3254125 | 3254125 | 2021-03-02 | Italy | Abruzzo | 54910 | 1720 | 40135 | 13055 | 42.35122196 | 13.39843823 | 2021-03-03 05:23:28 | Abruzzo, Italy | ||
3254126 | 3254126 | 2021-03-02 | Italy | Basilicata | 15857 | 375 | 11298 | 4184 | 40.63947052 | 15.80514834 | 2021-03-03 05:23:28 | Basilicata, Italy | ||
3254127 | 3254127 | 2021-03-02 | Italy | Calabria | 38133 | 693 | 31175 | 6265 | 38.90597598 | 16.59440194 | 2021-03-03 05:23:28 | Calabria, Italy | ||
3254128 | 3254128 | 2021-03-02 | Italy | Campania | 271561 | 4334 | 187942 | 79285 | 40.83956555 | 14.25084984 | 2021-03-03 05:23:28 | Campania, Italy | ||
3254129 | 3254129 | 2021-03-02 | Italy | Emilia-Romagna | 265214 | 10610 | 208757 | 45847 | 44.49436681 | 11.3417208 | 2021-03-03 05:23:28 | Emilia-Romagna, Italy | ||
3254130 | 3254130 | 2021-03-02 | Italy | Friuli Venezia Giulia | 77463 | 2856 | 64401 | 10206 | 45.6494354 | 13.76813649 | 2021-03-03 05:23:28 | Friuli Venezia Giulia, Italy | ||
3254131 | 3254131 | 2021-03-02 | Italy | Lazio | 236460 | 5940 | 194725 | 35795 | 41.89277044 | 12.48366722 | 2021-03-03 05:23:28 | Lazio, Italy | ||
3254132 | 3254132 | 2021-03-02 | Italy | Liguria | 78624 | 3644 | 69553 | 5427 | 44.41149315 | 8.9326992 | 2021-03-03 05:23:28 | Liguria, Italy | ||
3254133 | 3254133 | 2021-03-02 | Italy | Lombardia | 608978 | 28458 | 512830 | 67690 | 45.46679409 | 9.190347404 | 2021-03-03 05:23:28 | Lombardia, Italy | ||
3254134 | 3254134 | 2021-03-02 | Italy | Marche | 68718 | 2275 | 56671 | 9772 | 43.61675973 | 13.5188753 | 2021-03-03 05:23:28 | Marche, Italy | ||
3254135 | 3254135 | 2021-03-02 | Italy | Molise | 10750 | 354 | 8712 | 1684 | 41.55774754 | 14.65916051 | 2021-03-03 05:23:28 | Molise, Italy | ||
3254136 | 3254136 | 2021-03-02 | Italy | P.A. Bolzano | 54161 | 1043 | 46226 | 6892 | 46.49933453 | 11.35662422 | 2021-03-03 05:23:28 | P.A. Bolzano, 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 | ||
3254138 | 3254138 | 2021-03-02 | Italy | Piemonte | 249898 | 9395 | 223170 | 17333 | 45.0732745 | 7.680687483 | 2021-03-03 05:23:28 | Piemonte, Italy | ||
3254139 | 3254139 | 2021-03-02 | Italy | Puglia | 148702 | 3992 | 111599 | 33111 | 41.12559576 | 16.86736689 | 2021-03-03 05:23:28 | Puglia, Italy | ||
3254140 | 3254140 | 2021-03-02 | Italy | Sardegna | 41306 | 1170 | 27397 | 12739 | 39.21531192 | 9.110616306 | 2021-03-03 05:23:28 | Sardegna, 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]);