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)
latitude 24 ✖
- 38.11569725 398
- 38.90597598 398
- 39.21531192 398
- 40.63947052 398
- 40.83956555 398
- 41.12559576 398
- 41.55774754 398
- 41.89277044 398
- 42.35122196 398
- 43.10675841 398
- 43.61675973 398
- 43.76923077 398
- 44.41149315 398
- 44.49436681 398
- 45.0732745 398
- 45.43490485 398
- 45.46679409 398
- 45.6494354 398
- 45.73750286 398
- 46.06893511 398
- 46.49933453 398
- 41.87194 53
- 43.0 12
- 41.8719 9
province_or_state 21
- Abruzzo 398
- Basilicata 398
- Calabria 398
- Campania 398
- Emilia-Romagna 398
- Friuli Venezia Giulia 398
- Lazio 398
- Liguria 398
- Lombardia 398
- Marche 398
- Molise 398
- P.A. Bolzano 398
- P.A. Trento 398
- Piemonte 398
- Puglia 398
- Sardegna 398
- Sicilia 398
- Toscana 398
- Umbria 398
- Valle d'Aosta 398
- Veneto 398
country_or_region 1
- Italy · 8,462 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2339374 | 2339374 | 2021-06-15 | Italy | Abruzzo | 74496 | 2503 | 70616 | 1377 | 42.35122196 | 13.39843823 | 2021-06-16 04:22:32 | Abruzzo, Italy | ||
2339375 | 2339375 | 2021-06-15 | Italy | Basilicata | 26717 | 587 | 23234 | 2896 | 40.63947052 | 15.80514834 | 2021-06-16 04:22:32 | Basilicata, Italy | ||
2339376 | 2339376 | 2021-06-15 | Italy | Calabria | 68282 | 1213 | 59306 | 7763 | 38.90597598 | 16.59440194 | 2021-06-16 04:22:32 | Calabria, Italy | ||
2339377 | 2339377 | 2021-06-15 | Italy | Campania | 422755 | 7357 | 403661 | 11737 | 40.83956555 | 14.25084984 | 2021-06-16 04:22:32 | Campania, Italy | ||
2339378 | 2339378 | 2021-06-15 | Italy | Emilia-Romagna | 385868 | 13236 | 365384 | 7248 | 44.49436681 | 11.3417208 | 2021-06-16 04:22:32 | Emilia-Romagna, Italy | ||
2339379 | 2339379 | 2021-06-15 | Italy | Friuli Venezia Giulia | 107385 | 3795 | 99043 | 4547 | 45.6494354 | 13.76813649 | 2021-06-16 04:22:32 | Friuli Venezia Giulia, Italy | ||
2339380 | 2339380 | 2021-06-15 | Italy | Lazio | 344636 | 8281 | 330853 | 5502 | 41.89277044 | 12.48366722 | 2021-06-16 04:22:32 | Lazio, Italy | ||
2339381 | 2339381 | 2021-06-15 | Italy | Liguria | 103064 | 4343 | 98337 | 384 | 44.41149315 | 8.9326992 | 2021-06-16 04:22:32 | Liguria, Italy | ||
2339382 | 2339382 | 2021-06-15 | Italy | Lombardia | 839759 | 33737 | 787696 | 18326 | 45.46679409 | 9.190347404 | 2021-06-16 04:22:32 | Lombardia, Italy | ||
2339383 | 2339383 | 2021-06-15 | Italy | Marche | 103430 | 3026 | 97733 | 2671 | 43.61675973 | 13.5188753 | 2021-06-16 04:22:32 | Marche, Italy | ||
2339384 | 2339384 | 2021-06-15 | Italy | Molise | 13646 | 491 | 13072 | 83 | 41.55774754 | 14.65916051 | 2021-06-16 04:22:32 | Molise, Italy | ||
2339385 | 2339385 | 2021-06-15 | Italy | P.A. Bolzano | 73202 | 1180 | 71661 | 361 | 46.49933453 | 11.35662422 | 2021-06-16 04:22:32 | P.A. Bolzano, Italy | ||
2339386 | 2339386 | 2021-06-15 | Italy | P.A. Trento | 45696 | 1360 | 44134 | 202 | 46.06893511 | 11.12123097 | 2021-06-16 04:22:32 | P.A. Trento, Italy | ||
2339387 | 2339387 | 2021-06-15 | Italy | Piemonte | 362308 | 11681 | 348249 | 2378 | 45.0732745 | 7.680687483 | 2021-06-16 04:22:32 | Piemonte, Italy | ||
2339388 | 2339388 | 2021-06-15 | Italy | Puglia | 252449 | 6592 | 234546 | 11311 | 41.12559576 | 16.86736689 | 2021-06-16 04:22:32 | Puglia, Italy | ||
2339389 | 2339389 | 2021-06-15 | Italy | Sardegna | 57061 | 1484 | 43710 | 11867 | 39.21531192 | 9.110616306 | 2021-06-16 04:22:32 | Sardegna, Italy | ||
2339390 | 2339390 | 2021-06-15 | Italy | Sicilia | 229703 | 5920 | 217416 | 6367 | 38.11569725 | 13.362356699999998 | 2021-06-16 04:22:32 | Sicilia, Italy | ||
2339391 | 2339391 | 2021-06-15 | Italy | Toscana | 243514 | 6826 | 232632 | 4056 | 43.76923077 | 11.25588885 | 2021-06-16 04:22:32 | Toscana, Italy | ||
2339392 | 2339392 | 2021-06-15 | Italy | Umbria | 56692 | 1417 | 54251 | 1024 | 43.10675841 | 12.38824698 | 2021-06-16 04:22:32 | Umbria, Italy | ||
2339393 | 2339393 | 2021-06-15 | Italy | Valle d'Aosta | 11661 | 472 | 11099 | 90 | 45.73750286 | 7.320149366 | 2021-06-16 04:22:32 | Valle d'Aosta, Italy | ||
2339394 | 2339394 | 2021-06-15 | Italy | Veneto | 424708 | 11600 | 407392 | 5716 | 45.43490485 | 12.33845213 | 2021-06-16 04:22:32 | Veneto, Italy | ||
1564070 | 1564070 | 2021-06-14 | Italy | Abruzzo | 74469 | 2502 | 70494 | 1473 | 42.35122196 | 13.39843823 | 2021-06-15 04:22:22 | Abruzzo, Italy | ||
1564071 | 1564071 | 2021-06-14 | Italy | Basilicata | 26689 | 586 | 23150 | 2953 | 40.63947052 | 15.80514834 | 2021-06-15 04:22:22 | Basilicata, Italy | ||
1564072 | 1564072 | 2021-06-14 | Italy | Calabria | 68250 | 1212 | 59139 | 7899 | 38.90597598 | 16.59440194 | 2021-06-15 04:22:22 | Calabria, Italy | ||
1564073 | 1564073 | 2021-06-14 | Italy | Campania | 422619 | 7342 | 355448 | 59829 | 40.83956555 | 14.25084984 | 2021-06-15 04:22:22 | Campania, Italy | ||
1564074 | 1564074 | 2021-06-14 | Italy | Emilia-Romagna | 385821 | 13234 | 364569 | 8018 | 44.49436681 | 11.3417208 | 2021-06-15 04:22:22 | Emilia-Romagna, Italy | ||
1564075 | 1564075 | 2021-06-14 | Italy | Friuli Venezia Giulia | 107373 | 3794 | 98997 | 4582 | 45.6494354 | 13.76813649 | 2021-06-15 04:22:22 | Friuli Venezia Giulia, Italy | ||
1564076 | 1564076 | 2021-06-14 | Italy | Lazio | 344518 | 8268 | 330404 | 5846 | 41.89277044 | 12.48366722 | 2021-06-15 04:22:22 | Lazio, Italy | ||
1564077 | 1564077 | 2021-06-14 | Italy | Liguria | 103056 | 4343 | 98295 | 418 | 44.41149315 | 8.9326992 | 2021-06-15 04:22:22 | Liguria, Italy | ||
1564078 | 1564078 | 2021-06-14 | Italy | Lombardia | 839577 | 33729 | 787476 | 18372 | 45.46679409 | 9.190347404 | 2021-06-15 04:22:22 | Lombardia, Italy | ||
1564079 | 1564079 | 2021-06-14 | Italy | Marche | 103414 | 3025 | 97685 | 2704 | 43.61675973 | 13.5188753 | 2021-06-15 04:22:22 | Marche, Italy | ||
1564080 | 1564080 | 2021-06-14 | Italy | Molise | 13636 | 491 | 13066 | 79 | 41.55774754 | 14.65916051 | 2021-06-15 04:22:22 | Molise, Italy | ||
1564081 | 1564081 | 2021-06-14 | Italy | P.A. Bolzano | 73193 | 1180 | 71625 | 388 | 46.49933453 | 11.35662422 | 2021-06-15 04:22:22 | P.A. Bolzano, Italy | ||
1564082 | 1564082 | 2021-06-14 | Italy | P.A. Trento | 45689 | 1360 | 44087 | 242 | 46.06893511 | 11.12123097 | 2021-06-15 04:22:22 | P.A. Trento, Italy | ||
1564083 | 1564083 | 2021-06-14 | Italy | Piemonte | 362233 | 11678 | 347950 | 2605 | 45.0732745 | 7.680687483 | 2021-06-15 04:22:22 | Piemonte, Italy | ||
1564084 | 1564084 | 2021-06-14 | Italy | Puglia | 252280 | 6590 | 233106 | 12584 | 41.12559576 | 16.86736689 | 2021-06-15 04:22:22 | Puglia, Italy | ||
1564085 | 1564085 | 2021-06-14 | Italy | Sardegna | 57039 | 1484 | 43583 | 11972 | 39.21531192 | 9.110616306 | 2021-06-15 04:22:22 | Sardegna, Italy | ||
1564086 | 1564086 | 2021-06-14 | Italy | Sicilia | 229503 | 5912 | 216960 | 6631 | 38.11569725 | 13.362356699999998 | 2021-06-15 04:22:22 | Sicilia, Italy | ||
1564087 | 1564087 | 2021-06-14 | Italy | Toscana | 243457 | 6819 | 232432 | 4206 | 43.76923077 | 11.25588885 | 2021-06-15 04:22:22 | Toscana, Italy | ||
1564088 | 1564088 | 2021-06-14 | Italy | Umbria | 56671 | 1417 | 54241 | 1013 | 43.10675841 | 12.38824698 | 2021-06-15 04:22:22 | Umbria, Italy | ||
1564089 | 1564089 | 2021-06-14 | Italy | Valle d'Aosta | 11658 | 472 | 11090 | 96 | 45.73750286 | 7.320149366 | 2021-06-15 04:22:22 | Valle d'Aosta, Italy | ||
1564090 | 1564090 | 2021-06-14 | Italy | Veneto | 424634 | 11600 | 407154 | 5880 | 45.43490485 | 12.33845213 | 2021-06-15 04:22:22 | Veneto, Italy | ||
3381353 | 3381353 | 2021-06-13 | Italy | Abruzzo | 74464 | 2502 | 70433 | 1529 | 42.35122196 | 13.39843823 | 2021-06-14 04:22:46 | Abruzzo, Italy | ||
3381354 | 3381354 | 2021-06-13 | Italy | Basilicata | 26688 | 585 | 23124 | 2979 | 40.63947052 | 15.80514834 | 2021-06-14 04:22:46 | Basilicata, Italy | ||
3381355 | 3381355 | 2021-06-13 | Italy | Calabria | 68232 | 1208 | 58929 | 8095 | 38.90597598 | 16.59440194 | 2021-06-14 04:22:46 | Calabria, Italy | ||
3381356 | 3381356 | 2021-06-13 | Italy | Campania | 422539 | 7337 | 355124 | 60078 | 40.83956555 | 14.25084984 | 2021-06-14 04:22:46 | Campania, Italy | ||
3381357 | 3381357 | 2021-06-13 | Italy | Emilia-Romagna | 385684 | 13233 | 364106 | 8345 | 44.49436681 | 11.3417208 | 2021-06-14 04:22:46 | Emilia-Romagna, Italy | ||
3381358 | 3381358 | 2021-06-13 | Italy | Friuli Venezia Giulia | 107369 | 3794 | 98986 | 4589 | 45.6494354 | 13.76813649 | 2021-06-14 04:22:46 | Friuli Venezia Giulia, Italy | ||
3381359 | 3381359 | 2021-06-13 | Italy | Lazio | 344407 | 8262 | 329976 | 6169 | 41.89277044 | 12.48366722 | 2021-06-14 04:22:46 | Lazio, Italy | ||
3381360 | 3381360 | 2021-06-13 | Italy | Liguria | 103051 | 4342 | 98270 | 439 | 44.41149315 | 8.9326992 | 2021-06-14 04:22:46 | Liguria, Italy | ||
3381361 | 3381361 | 2021-06-13 | Italy | Lombardia | 839475 | 33726 | 787358 | 18391 | 45.46679409 | 9.190347404 | 2021-06-14 04:22:46 | Lombardia, Italy | ||
3381362 | 3381362 | 2021-06-13 | Italy | Marche | 103411 | 3025 | 97587 | 2799 | 43.61675973 | 13.5188753 | 2021-06-14 04:22:46 | Marche, Italy | ||
3381363 | 3381363 | 2021-06-13 | Italy | Molise | 13632 | 491 | 13059 | 82 | 41.55774754 | 14.65916051 | 2021-06-14 04:22:46 | Molise, Italy | ||
3381364 | 3381364 | 2021-06-13 | Italy | P.A. Bolzano | 73193 | 1180 | 71610 | 403 | 46.49933453 | 11.35662422 | 2021-06-14 04:22:46 | P.A. Bolzano, Italy | ||
3381365 | 3381365 | 2021-06-13 | Italy | P.A. Trento | 45687 | 1360 | 44081 | 246 | 46.06893511 | 11.12123097 | 2021-06-14 04:22:46 | P.A. Trento, Italy | ||
3381366 | 3381366 | 2021-06-13 | Italy | Piemonte | 362146 | 11675 | 347802 | 2669 | 45.0732745 | 7.680687483 | 2021-06-14 04:22:46 | Piemonte, Italy | ||
3381367 | 3381367 | 2021-06-13 | Italy | Puglia | 252233 | 6588 | 232428 | 13217 | 41.12559576 | 16.86736689 | 2021-06-14 04:22:46 | Puglia, Italy | ||
3381368 | 3381368 | 2021-06-13 | Italy | Sardegna | 57008 | 1484 | 43473 | 12051 | 39.21531192 | 9.110616306 | 2021-06-14 04:22:46 | Sardegna, Italy | ||
3381369 | 3381369 | 2021-06-13 | Italy | Sicilia | 229340 | 5905 | 216713 | 6722 | 38.11569725 | 13.362356699999998 | 2021-06-14 04:22:46 | Sicilia, Italy | ||
3381370 | 3381370 | 2021-06-13 | Italy | Toscana | 243375 | 6816 | 232101 | 4458 | 43.76923077 | 11.25588885 | 2021-06-14 04:22:46 | Toscana, Italy | ||
3381371 | 3381371 | 2021-06-13 | Italy | Umbria | 56667 | 1417 | 54213 | 1037 | 43.10675841 | 12.38824698 | 2021-06-14 04:22:46 | Umbria, Italy | ||
3381372 | 3381372 | 2021-06-13 | Italy | Valle d'Aosta | 11656 | 472 | 11089 | 95 | 45.73750286 | 7.320149366 | 2021-06-14 04:22:46 | Valle d'Aosta, Italy | ||
3381373 | 3381373 | 2021-06-13 | Italy | Veneto | 424615 | 11600 | 407095 | 5920 | 45.43490485 | 12.33845213 | 2021-06-14 04:22:46 | Veneto, Italy | ||
1736487 | 1736487 | 2021-06-12 | Italy | Abruzzo | 74450 | 2502 | 70432 | 1516 | 42.35122196 | 13.39843823 | 2021-06-13 04:22:44 | Abruzzo, Italy | ||
1736488 | 1736488 | 2021-06-12 | Italy | Basilicata | 26661 | 585 | 23087 | 2989 | 40.63947052 | 15.80514834 | 2021-06-13 04:22:44 | Basilicata, Italy | ||
1736489 | 1736489 | 2021-06-12 | Italy | Calabria | 68160 | 1207 | 58702 | 8251 | 38.90597598 | 16.59440194 | 2021-06-13 04:22:44 | Calabria, Italy | ||
1736490 | 1736490 | 2021-06-12 | Italy | Campania | 422392 | 7334 | 354673 | 60385 | 40.83956555 | 14.25084984 | 2021-06-13 04:22:44 | Campania, Italy | ||
1736491 | 1736491 | 2021-06-12 | Italy | Emilia-Romagna | 385561 | 13230 | 363818 | 8513 | 44.49436681 | 11.3417208 | 2021-06-13 04:22:44 | Emilia-Romagna, Italy | ||
1736492 | 1736492 | 2021-06-12 | Italy | Friuli Venezia Giulia | 107358 | 3794 | 98956 | 4608 | 45.6494354 | 13.76813649 | 2021-06-13 04:22:44 | Friuli Venezia Giulia, Italy | ||
1736493 | 1736493 | 2021-06-12 | Italy | Lazio | 344280 | 8262 | 329451 | 6567 | 41.89277044 | 12.48366722 | 2021-06-13 04:22:44 | Lazio, Italy | ||
1736494 | 1736494 | 2021-06-12 | Italy | Liguria | 103041 | 4342 | 98225 | 474 | 44.41149315 | 8.9326992 | 2021-06-13 04:22:44 | Liguria, Italy | ||
1736495 | 1736495 | 2021-06-12 | Italy | Lombardia | 839218 | 33720 | 787042 | 18456 | 45.46679409 | 9.190347404 | 2021-06-13 04:22:44 | Lombardia, Italy | ||
1736496 | 1736496 | 2021-06-12 | Italy | Marche | 103378 | 3025 | 97483 | 2870 | 43.61675973 | 13.5188753 | 2021-06-13 04:22:44 | Marche, Italy | ||
1736497 | 1736497 | 2021-06-12 | Italy | Molise | 13630 | 491 | 13057 | 82 | 41.55774754 | 14.65916051 | 2021-06-13 04:22:44 | Molise, Italy | ||
1736498 | 1736498 | 2021-06-12 | Italy | P.A. Bolzano | 73185 | 1180 | 71585 | 420 | 46.49933453 | 11.35662422 | 2021-06-13 04:22:44 | P.A. Bolzano, Italy | ||
1736499 | 1736499 | 2021-06-12 | Italy | P.A. Trento | 45676 | 1360 | 44037 | 279 | 46.06893511 | 11.12123097 | 2021-06-13 04:22:44 | P.A. Trento, Italy | ||
1736500 | 1736500 | 2021-06-12 | Italy | Piemonte | 362087 | 11674 | 347657 | 2756 | 45.0732745 | 7.680687483 | 2021-06-13 04:22:44 | Piemonte, Italy | ||
1736501 | 1736501 | 2021-06-12 | Italy | Puglia | 252160 | 6588 | 231760 | 13812 | 41.12559576 | 16.86736689 | 2021-06-13 04:22:44 | Puglia, Italy | ||
1736502 | 1736502 | 2021-06-12 | Italy | Sardegna | 56997 | 1483 | 43443 | 12071 | 39.21531192 | 9.110616306 | 2021-06-13 04:22:44 | Sardegna, Italy | ||
1736503 | 1736503 | 2021-06-12 | Italy | Sicilia | 229157 | 5900 | 216559 | 6698 | 38.11569725 | 13.362356699999998 | 2021-06-13 04:22:44 | Sicilia, Italy | ||
1736504 | 1736504 | 2021-06-12 | Italy | Toscana | 243252 | 6810 | 231869 | 4573 | 43.76923077 | 11.25588885 | 2021-06-13 04:22:44 | Toscana, Italy | ||
1736505 | 1736505 | 2021-06-12 | Italy | Umbria | 56656 | 1417 | 54181 | 1058 | 43.10675841 | 12.38824698 | 2021-06-13 04:22:44 | Umbria, Italy | ||
1736506 | 1736506 | 2021-06-12 | Italy | Valle d'Aosta | 11655 | 472 | 11082 | 101 | 45.73750286 | 7.320149366 | 2021-06-13 04:22:44 | Valle d'Aosta, Italy | ||
1736507 | 1736507 | 2021-06-12 | Italy | Veneto | 424528 | 11600 | 406998 | 5930 | 45.43490485 | 12.33845213 | 2021-06-13 04:22:44 | Veneto, Italy | ||
3970528 | 3970528 | 2021-06-11 | Italy | Abruzzo | 74421 | 2500 | 70389 | 1532 | 42.35122196 | 13.39843823 | 2021-06-12 04:22:22 | Abruzzo, Italy | ||
3970529 | 3970529 | 2021-06-11 | Italy | Basilicata | 26648 | 585 | 23035 | 3028 | 40.63947052 | 15.80514834 | 2021-06-12 04:22:22 | Basilicata, Italy | ||
3970530 | 3970530 | 2021-06-11 | Italy | Calabria | 68080 | 1205 | 58641 | 8234 | 38.90597598 | 16.59440194 | 2021-06-12 04:22:22 | Calabria, Italy | ||
3970531 | 3970531 | 2021-06-11 | Italy | Campania | 422205 | 7326 | 354088 | 60791 | 40.83956555 | 14.25084984 | 2021-06-12 04:22:22 | Campania, Italy | ||
3970532 | 3970532 | 2021-06-11 | Italy | Emilia-Romagna | 385457 | 13230 | 363523 | 8704 | 44.49436681 | 11.3417208 | 2021-06-12 04:22:22 | Emilia-Romagna, Italy | ||
3970533 | 3970533 | 2021-06-11 | Italy | Friuli Venezia Giulia | 107322 | 3794 | 98887 | 4641 | 45.6494354 | 13.76813649 | 2021-06-12 04:22:22 | Friuli Venezia Giulia, Italy | ||
3970534 | 3970534 | 2021-06-11 | Italy | Lazio | 344116 | 8254 | 328498 | 7364 | 41.89277044 | 12.48366722 | 2021-06-12 04:22:22 | Lazio, Italy | ||
3970535 | 3970535 | 2021-06-11 | Italy | Liguria | 103020 | 4342 | 98184 | 494 | 44.41149315 | 8.9326992 | 2021-06-12 04:22:22 | Liguria, Italy | ||
3970536 | 3970536 | 2021-06-11 | Italy | Lombardia | 838963 | 33707 | 786849 | 18407 | 45.46679409 | 9.190347404 | 2021-06-12 04:22:22 | Lombardia, Italy | ||
3970537 | 3970537 | 2021-06-11 | Italy | Marche | 103344 | 3025 | 97346 | 2973 | 43.61675973 | 13.5188753 | 2021-06-12 04:22:22 | Marche, Italy | ||
3970538 | 3970538 | 2021-06-11 | Italy | Molise | 13626 | 491 | 13050 | 85 | 41.55774754 | 14.65916051 | 2021-06-12 04:22:22 | Molise, Italy | ||
3970539 | 3970539 | 2021-06-11 | Italy | P.A. Bolzano | 73151 | 1180 | 71527 | 444 | 46.49933453 | 11.35662422 | 2021-06-12 04:22:22 | P.A. Bolzano, Italy | ||
3970540 | 3970540 | 2021-06-11 | Italy | P.A. Trento | 45664 | 1359 | 43991 | 314 | 46.06893511 | 11.12123097 | 2021-06-12 04:22:22 | P.A. Trento, Italy | ||
3970541 | 3970541 | 2021-06-11 | Italy | Piemonte | 361997 | 11670 | 347451 | 2876 | 45.0732745 | 7.680687483 | 2021-06-12 04:22:22 | Piemonte, Italy | ||
3970542 | 3970542 | 2021-06-11 | Italy | Puglia | 252020 | 6585 | 231088 | 14347 | 41.12559576 | 16.86736689 | 2021-06-12 04:22:22 | Puglia, Italy | ||
3970543 | 3970543 | 2021-06-11 | Italy | Sardegna | 56977 | 1483 | 43421 | 12073 | 39.21531192 | 9.110616306 | 2021-06-12 04:22:22 | 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]);