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 confirmed descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- Valle d'Aosta 628
- Molise 625
- Basilicata 481
- P.A. Trento 272
- Calabria 249
- Umbria 233
- P.A. Bolzano 230
- Sardegna 224
- Abruzzo 204
- Marche 199
- Friuli Venezia Giulia 198
- Puglia 182
- Sicilia 177
- Liguria 171
- Toscana 163
- Lazio 161
- Campania 160
- Veneto 146
- Emilia-Romagna 67
- Piemonte 1
country_or_region 1
- Italy · 4,817 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▲ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1404450 | 1404450 | 2020-05-14 | Italy | Piemonte | 29209 | 3493 | 13825 | 11891 | 45.0732745 | 7.680687483 | 2020-05-15 02:33:02 | Piemonte, Italy | ||
3193980 | 3193980 | 2021-09-06 | Italy | Basilicata | 29204 | 600 | 0 | 40.63947052 | 15.80514834 | 2021-09-07 04:21:35 | Basilicata, Italy | |||
3280848 | 3280848 | 2021-09-05 | Italy | Basilicata | 29200 | 600 | 0 | 40.63947052 | 15.80514834 | 2021-09-06 04:21:22 | Basilicata, Italy | |||
75067 | 75067 | 2020-12-03 | Italy | Abruzzo | 29196 | 940 | 10428 | 17828 | 42.35122196 | 13.39843823 | 2020-12-04 05:27:27 | Abruzzo, Italy | ||
1136880 | 1136880 | 2021-01-01 | Italy | Umbria | 29188 | 625 | 24759 | 3804 | 43.10675841 | 12.38824698 | 2021-01-02 05:22:33 | Umbria, Italy | ||
121787 | 121787 | 2020-07-19 | Italy | Emilia-Romagna | 29178 | 4274 | 23638 | 1266 | 44.49436681 | 11.341720800000001 | 2020-07-20 05:34:40 | Emilia-Romagna, Italy | ||
249262 | 249262 | 2021-09-04 | Italy | Basilicata | 29166 | 600 | 0 | 40.63947052 | 15.80514834 | 2021-09-05 04:21:33 | Basilicata, 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 | ||
2406824 | 2406824 | 2020-12-23 | Italy | Sardegna | 29136 | 689 | 12478 | 15969 | 39.21531192 | 9.110616306 | 2020-12-24 05:23:04 | Sardegna, Italy | ||
3205176 | 3205176 | 2020-07-18 | Italy | Emilia-Romagna | 29127 | 4274 | 23619 | 1234 | 44.49436681 | 11.341720800000001 | 2020-07-19 04:34:58 | Emilia-Romagna, Italy | ||
3974543 | 3974543 | 2021-09-03 | Italy | Basilicata | 29118 | 600 | 0 | 40.63947052 | 15.80514834 | 2021-09-04 04:21:28 | Basilicata, Italy | |||
2657772 | 2657772 | 2022-01-31 | Italy | Valle d'Aosta | 29117 | 507 | 0 | 45.73750286 | 7.320149366 | 2022-02-01 04:21:11 | Valle d'Aosta, Italy | |||
2708478 | 2708478 | 2020-07-17 | Italy | Emilia-Romagna | 29087 | 4273 | 23586 | 1228 | 44.49436681 | 11.341720800000001 | 2020-07-18 04:34:45 | Emilia-Romagna, Italy | ||
3503338 | 3503338 | 2021-01-17 | Italy | Calabria | 29073 | 535 | 18305 | 10233 | 38.90597598 | 16.59440194 | 2021-01-18 05:22:34 | Calabria, Italy | ||
3300189 | 3300189 | 2022-01-30 | Italy | Valle d'Aosta | 29061 | 506 | 0 | 45.73750286 | 7.320149366 | 2022-01-31 04:21:09 | Valle d'Aosta, Italy | |||
178005 | 178005 | 2021-09-02 | Italy | Basilicata | 29057 | 599 | 0 | 40.63947052 | 15.80514834 | 2021-09-03 04:21:20 | Basilicata, Italy | |||
3117483 | 3117483 | 2020-10-06 | Italy | Veneto | 29043 | 2198 | 22319 | 4526 | 45.43490485 | 12.33845213 | 2020-10-07 04:23:40 | Veneto, Italy | ||
2935219 | 2935219 | 2020-11-28 | Italy | Marche | 29036 | 1242 | 10551 | 17243 | 43.61675973 | 13.5188753 | 2020-11-29 05:25:55 | Marche, Italy | ||
367296 | 367296 | 2020-07-16 | Italy | Emilia-Romagna | 29035 | 4271 | 23566 | 1198 | 44.49436681 | 11.3417208 | 2020-07-17 04:34:50 | Emilia-Romagna, Italy | ||
67040 | 67040 | 2021-09-01 | Italy | Basilicata | 29018 | 599 | 0 | 40.63947052 | 15.80514834 | 2021-09-02 04:21:15 | Basilicata, Italy | |||
766309 | 766309 | 2020-12-29 | Italy | P.A. Bolzano | 29014 | 729 | 17607 | 10678 | 46.49933453 | 11.35662422 | 2020-12-30 05:22:34 | P.A. Bolzano, Italy | ||
3440807 | 3440807 | 2020-11-11 | Italy | Puglia | 29008 | 896 | 8013 | 20099 | 41.12559576 | 16.86736689 | 2020-11-12 05:25:55 | Puglia, Italy | ||
2747964 | 2747964 | 2020-07-15 | Italy | Emilia-Romagna | 28989 | 4271 | 23548 | 1170 | 44.49436681 | 11.3417208 | 2020-07-16 04:44:59 | Emilia-Romagna, Italy | ||
3809905 | 3809905 | 2022-01-28 | Italy | Molise | 28989 | 526 | 0 | 41.55774754 | 14.65916051 | 2022-01-29 04:21:10 | Molise, 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 | ||
2158608 | 2158608 | 2020-07-14 | Italy | Emilia-Romagna | 28971 | 4271 | 23511 | 1189 | 44.49436681 | 11.341720800000001 | 2020-07-15 04:34:39 | Emilia-Romagna, Italy | ||
3695486 | 3695486 | 2020-12-31 | Italy | Umbria | 28960 | 624 | 24559 | 3777 | 43.10675841 | 12.38824698 | 2021-01-01 05:23:07 | Umbria, Italy | ||
3491249 | 3491249 | 2020-07-13 | Italy | Emilia-Romagna | 28958 | 4269 | 23496 | 1193 | 44.49436681 | 11.341720800000001 | 2020-07-14 04:34:46 | Emilia-Romagna, Italy | ||
3737511 | 3737511 | 2020-07-12 | Italy | Emilia-Romagna | 28940 | 4269 | 23491 | 1180 | 44.49436681 | 11.341720800000001 | 2020-07-13 04:43:04 | Emilia-Romagna, Italy | ||
2067882 | 2067882 | 2021-08-31 | Italy | Basilicata | 28939 | 599 | 0 | 40.63947052 | 15.80514834 | 2021-09-01 04:21:38 | Basilicata, Italy | |||
3761573 | 3761573 | 2020-12-28 | Italy | P.A. Bolzano | 28923 | 722 | 17594 | 10607 | 46.49933453 | 11.35662422 | 2020-12-29 05:22:37 | P.A. Bolzano, 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 | ||
3435906 | 3435906 | 2020-07-11 | Italy | Emilia-Romagna | 28869 | 4269 | 23481 | 1119 | 44.49436681 | 11.341720800000001 | 2020-07-12 04:34:30 | Emilia-Romagna, Italy | ||
3769870 | 3769870 | 2020-12-22 | Italy | Sardegna | 28867 | 681 | 12307 | 15879 | 39.21531192 | 9.110616306 | 2020-12-23 05:22:03 | Sardegna, Italy | ||
3801895 | 3801895 | 2020-10-05 | Italy | Veneto | 28854 | 2194 | 22259 | 4401 | 45.43490485 | 12.33845213 | 2020-10-06 04:23:33 | Veneto, Italy | ||
3061980 | 3061980 | 2022-01-29 | Italy | Valle d'Aosta | 28853 | 505 | 0 | 45.73750286 | 7.320149366 | 2022-01-30 04:21:26 | Valle d'Aosta, Italy | |||
1775336 | 1775336 | 2021-08-30 | Italy | Basilicata | 28841 | 599 | 0 | 40.63947052 | 15.80514834 | 2021-08-31 04:21:46 | Basilicata, Italy | |||
3891910 | 3891910 | 2021-08-29 | Italy | Basilicata | 28839 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-30 04:21:23 | Basilicata, Italy | |||
376176 | 376176 | 2020-11-06 | Italy | Sicilia | 28825 | 628 | 8684 | 19513 | 38.11569725 | 13.362356699999998 | 2020-11-07 05:24:52 | Sicilia, Italy | ||
3237404 | 3237404 | 2020-07-10 | Italy | Emilia-Romagna | 28822 | 4269 | 23440 | 1113 | 44.49436681 | 11.341720800000001 | 2020-07-11 04:34:26 | Emilia-Romagna, Italy | ||
3777893 | 3777893 | 2020-12-27 | Italy | P.A. Bolzano | 28803 | 720 | 17503 | 10580 | 46.49933453 | 11.35662422 | 2020-12-28 05:22:06 | P.A. Bolzano, Italy | ||
738279 | 738279 | 2020-12-02 | Italy | Abruzzo | 28801 | 927 | 9890 | 17984 | 42.35122196 | 13.39843823 | 2020-12-03 05:28:22 | Abruzzo, Italy | ||
1005389 | 1005389 | 2020-07-09 | Italy | Emilia-Romagna | 28769 | 4269 | 23434 | 1066 | 44.49436681 | 11.341720800000001 | 2020-07-10 04:34:24 | Emilia-Romagna, Italy | ||
2793013 | 2793013 | 2021-08-28 | Italy | Basilicata | 28767 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-29 04:21:14 | Basilicata, Italy | |||
2222605 | 2222605 | 2020-07-08 | Italy | Emilia-Romagna | 28755 | 4269 | 23415 | 1071 | 44.49436681 | 11.341720800000001 | 2020-07-09 04:34:23 | Emilia-Romagna, 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 | ||
3990591 | 3990591 | 2020-10-20 | Italy | Campania | 28724 | 534 | 8732 | 19458 | 40.83956555 | 14.25084984 | 2020-10-21 04:24:14 | Campania, Italy | ||
202245 | 202245 | 2020-12-25 | Italy | P.A. Bolzano | 28722 | 711 | 17447 | 10564 | 46.49933453 | 11.35662422 | 2020-12-26 05:22:28 | P.A. Bolzano, Italy | ||
2223498 | 2223498 | 2020-12-26 | Italy | P.A. Bolzano | 28722 | 711 | 17447 | 10564 | 46.49933453 | 11.35662422 | 2020-12-27 05:22:55 | P.A. Bolzano, Italy | ||
3101421 | 3101421 | 2021-01-16 | Italy | Calabria | 28722 | 532 | 18200 | 9990 | 38.90597598 | 16.59440194 | 2021-01-17 05:22:17 | Calabria, Italy | ||
2923172 | 2923172 | 2021-08-27 | Italy | Basilicata | 28712 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-28 04:21:28 | Basilicata, Italy | |||
887214 | 887214 | 2020-07-07 | Italy | Emilia-Romagna | 28706 | 4269 | 23377 | 1060 | 44.49436681 | 11.341720800000001 | 2020-07-08 05:33:48 | Emilia-Romagna, Italy | ||
927686 | 927686 | 2020-12-21 | Italy | Sardegna | 28683 | 669 | 12055 | 15959 | 39.21531192 | 9.110616306 | 2020-12-22 05:22:33 | Sardegna, Italy | ||
2684774 | 2684774 | 2020-07-06 | Italy | Emilia-Romagna | 28675 | 4268 | 23343 | 1064 | 44.49436681 | 11.341720800000001 | 2020-07-07 04:34:00 | Emilia-Romagna, Italy | ||
1010301 | 1010301 | 2020-12-30 | Italy | Umbria | 28660 | 618 | 24336 | 3706 | 43.10675841 | 12.38824698 | 2020-12-31 05:22:49 | Umbria, Italy | ||
1596186 | 1596186 | 2021-08-26 | Italy | Basilicata | 28647 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-27 04:21:37 | Basilicata, Italy | |||
415239 | 415239 | 2020-07-05 | Italy | Emilia-Romagna | 28637 | 4268 | 23340 | 1029 | 44.49436681 | 11.341720800000001 | 2020-07-06 04:33:57 | Emilia-Romagna, Italy | ||
1822785 | 1822785 | 2020-10-04 | Italy | Veneto | 28624 | 2194 | 22195 | 4235 | 45.43490485 | 12.33845213 | 2020-10-05 04:23:33 | Veneto, Italy | ||
529801 | 529801 | 2020-07-04 | Italy | Emilia-Romagna | 28613 | 4267 | 23309 | 1037 | 44.49436681 | 11.341720800000001 | 2020-07-05 04:33:46 | Emilia-Romagna, Italy | ||
2079917 | 2079917 | 2020-10-31 | Italy | Liguria | 28608 | 1774 | 18403 | 8431 | 44.41149315 | 8.9326992 | 2020-11-01 04:36:19 | Liguria, Italy | ||
32395 | 32395 | 2021-08-25 | Italy | Basilicata | 28599 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-26 04:21:28 | Basilicata, Italy | |||
1779359 | 1779359 | 2022-01-27 | Italy | Molise | 28597 | 524 | 0 | 41.55774754 | 14.65916051 | 2022-01-28 04:21:09 | Molise, Italy | |||
392222 | 392222 | 2020-11-27 | Italy | Marche | 28563 | 1230 | 10490 | 16843 | 43.61675973 | 13.5188753 | 2020-11-28 05:25:50 | Marche, Italy | ||
3809914 | 3809914 | 2022-01-28 | Italy | Valle d'Aosta | 28563 | 505 | 0 | 45.73750286 | 7.320149366 | 2022-01-29 04:21:10 | Valle d'Aosta, Italy | |||
2234462 | 2234462 | 2020-07-03 | Italy | Emilia-Romagna | 28562 | 4267 | 23284 | 1011 | 44.49436681 | 11.341720800000001 | 2020-07-04 04:33:51 | Emilia-Romagna, Italy | ||
3691468 | 3691468 | 2020-12-24 | Italy | P.A. Bolzano | 28540 | 704 | 18729 | 9107 | 46.49933453 | 11.35662422 | 2020-12-25 05:22:48 | P.A. Bolzano, Italy | ||
3045256 | 3045256 | 2020-07-02 | Italy | Emilia-Romagna | 28535 | 4265 | 23267 | 1003 | 44.49436681 | 11.3417208 | 2020-07-03 04:33:54 | Emilia-Romagna, Italy | ||
3105434 | 3105434 | 2021-08-24 | Italy | Basilicata | 28515 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-25 04:21:41 | Basilicata, Italy | |||
302947 | 302947 | 2020-07-01 | Italy | Emilia-Romagna | 28508 | 4264 | 23242 | 1002 | 44.49436681 | 11.341720800000001 | 2020-07-02 04:33:46 | Emilia-Romagna, Italy | ||
2974325 | 2974325 | 2020-06-30 | Italy | Emilia-Romagna | 28492 | 4260 | 23222 | 1010 | 44.49436681 | 11.341720800000001 | 2020-07-01 04:33:52 | Emilia-Romagna, Italy | ||
2632802 | 2632802 | 2020-06-29 | Italy | Emilia-Romagna | 28472 | 4255 | 23185 | 1032 | 44.49436681 | 11.3417208 | 2020-06-30 04:33:48 | Emilia-Romagna, Italy | ||
2306365 | 2306365 | 2020-06-28 | Italy | Emilia-Romagna | 28456 | 4253 | 23161 | 1042 | 44.49436681 | 11.341720800000001 | 2020-06-29 04:33:44 | Emilia-Romagna, 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 | ||
3165605 | 3165605 | 2021-08-23 | Italy | Basilicata | 28444 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-24 04:21:19 | Basilicata, Italy | |||
2175532 | 2175532 | 2021-08-22 | Italy | Basilicata | 28436 | 597 | 0 | 40.63947052 | 15.80514834 | 2021-08-23 04:21:27 | Basilicata, Italy | |||
2039700 | 2039700 | 2020-06-27 | Italy | Emilia-Romagna | 28435 | 4252 | 23142 | 1041 | 44.49436681 | 11.341720800000001 | 2020-06-28 04:34:04 | Emilia-Romagna, Italy | ||
3515383 | 3515383 | 2021-01-15 | Italy | Calabria | 28427 | 530 | 18087 | 9810 | 38.90597598 | 16.59440194 | 2021-01-16 05:22:40 | Calabria, Italy | ||
2537373 | 2537373 | 2020-12-01 | Italy | Abruzzo | 28420 | 906 | 9326 | 18188 | 42.35122196 | 13.39843823 | 2020-12-02 05:27:41 | Abruzzo, Italy | ||
2406820 | 2406820 | 2020-12-23 | Italy | P.A. Bolzano | 28398 | 699 | 18485 | 9214 | 46.49933453 | 11.35662422 | 2020-12-24 05:23:04 | P.A. Bolzano, Italy | ||
1135981 | 1135981 | 2020-06-26 | Italy | Emilia-Romagna | 28393 | 4252 | 23097 | 1044 | 44.49436681 | 11.341720800000001 | 2020-06-27 04:33:35 | Emilia-Romagna, Italy | ||
2119707 | 2119707 | 2020-12-20 | Italy | Sardegna | 28386 | 660 | 11890 | 15836 | 39.21531192 | 9.110616306 | 2020-12-21 05:27:58 | Sardegna, Italy | ||
3555628 | 3555628 | 2021-08-21 | Italy | Basilicata | 28384 | 596 | 0 | 40.63947052 | 15.80514834 | 2021-08-22 04:21:29 | Basilicata, Italy | |||
2191583 | 2191583 | 2020-10-21 | Italy | Lazio | 28370 | 1054 | 9913 | 17403 | 41.89277044 | 12.48366722 | 2020-10-22 04:24:27 | Lazio, Italy | ||
2514169 | 2514169 | 2020-10-03 | Italy | Veneto | 28363 | 2193 | 22058 | 4112 | 45.43490485 | 12.33845213 | 2020-10-04 04:23:44 | Veneto, Italy | ||
2624968 | 2624968 | 2020-06-25 | Italy | Emilia-Romagna | 28351 | 4249 | 23034 | 1068 | 44.49436681 | 11.341720800000001 | 2020-06-26 04:33:43 | Emilia-Romagna, Italy | ||
1853970 | 1853970 | 2021-08-20 | Italy | Basilicata | 28335 | 596 | 0 | 40.63947052 | 15.80514834 | 2021-08-21 04:21:38 | Basilicata, Italy | |||
766316 | 766316 | 2020-12-29 | Italy | Umbria | 28313 | 613 | 24132 | 3568 | 43.10675841 | 12.38824698 | 2020-12-30 05:22:34 | Umbria, Italy | ||
2700608 | 2700608 | 2020-06-24 | Italy | Emilia-Romagna | 28304 | 4245 | 22985 | 1074 | 44.49436681 | 11.341720800000001 | 2020-06-25 05:26:54 | Emilia-Romagna, Italy | ||
511677 | 511677 | 2021-08-19 | Italy | Basilicata | 28290 | 596 | 0 | 40.63947052 | 15.80514834 | 2021-08-20 04:21:33 | Basilicata, Italy | |||
3769866 | 3769866 | 2020-12-22 | Italy | P.A. Bolzano | 28267 | 698 | 18214 | 9355 | 46.49933453 | 11.35662422 | 2020-12-23 05:22:03 | P.A. Bolzano, Italy | ||
1522293 | 1522293 | 2020-06-23 | Italy | Emilia-Romagna | 28260 | 4236 | 22935 | 1089 | 44.49436681 | 11.341720800000001 | 2020-06-24 04:33:28 | Emilia-Romagna, 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 | ||
1510487 | 1510487 | 2020-06-22 | Italy | Emilia-Romagna | 28243 | 4235 | 22854 | 1154 | 44.49436681 | 11.341720800000001 | 2020-06-23 04:33:22 | Emilia-Romagna, Italy | ||
2518156 | 2518156 | 2021-08-18 | Italy | Basilicata | 28222 | 596 | 0 | 40.63947052 | 15.80514834 | 2021-08-19 04:21:15 | Basilicata, Italy | |||
3249226 | 3249226 | 2020-06-21 | Italy | Emilia-Romagna | 28221 | 4231 | 22818 | 1172 | 44.49436681 | 11.341720800000001 | 2020-06-22 04:33:20 | Emilia-Romagna, Italy | ||
1779368 | 1779368 | 2022-01-27 | Italy | Valle d'Aosta | 28219 | 504 | 0 | 45.73750286 | 7.320149366 | 2022-01-28 04:21:09 | Valle d'Aosta, Italy | |||
2437819 | 2437819 | 2020-06-20 | Italy | Emilia-Romagna | 28198 | 4230 | 22761 | 1207 | 44.49436681 | 11.341720800000001 | 2020-06-21 04:33:19 | Emilia-Romagna, Italy | ||
1691397 | 1691397 | 2020-06-19 | Italy | Emilia-Romagna | 28170 | 4224 | 22727 | 1219 | 44.49436681 | 11.341720800000001 | 2020-06-20 04:33:19 | Emilia-Romagna, Italy | ||
927682 | 927682 | 2020-12-21 | Italy | P.A. Bolzano | 28165 | 692 | 18126 | 9347 | 46.49933453 | 11.35662422 | 2020-12-22 05:22:33 | P.A. Bolzano, Italy | ||
245248 | 245248 | 2021-08-17 | Italy | Basilicata | 28154 | 595 | 0 | 40.63947052 | 15.80514834 | 2021-08-18 04:21:35 | Basilicata, 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]);