⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

8,651 rows where country_or_region = "Italy" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date)

province_or_state

country_or_region

  • Italy · 8,651
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234894 2021-06-24 Italy Abruzzo     74694 2512 71145 1037 42.35122196 13.39843823 2021-06-25 04:21:33 Abruzzo, Italy
234895 2021-06-24 Italy Basilicata     26884 589 25398 897 40.63947052 15.80514834 2021-06-25 04:21:33 Basilicata, Italy
234896 2021-06-24 Italy Calabria     68793 1223 61551 6019 38.90597598 16.59440194 2021-06-25 04:21:33 Calabria, Italy
234897 2021-06-24 Italy Campania     423728 7400 406752 9576 40.83956555 14.25084984 2021-06-25 04:21:33 Campania, Italy
234898 2021-06-24 Italy Emilia-Romagna     386512 13251 369062 4199 44.49436681 11.3417208 2021-06-25 04:21:33 Emilia-Romagna, Italy
234899 2021-06-24 Italy Friuli Venezia Giulia     106867 3787 102843 237 45.6494354 13.76813649 2021-06-25 04:21:33 Friuli Venezia Giulia, Italy
234900 2021-06-24 Italy Lazio     345553 8313 333589 3651 41.89277044 12.48366722 2021-06-25 04:21:33 Lazio, Italy
234901 2021-06-24 Italy Liguria     103382 4349 98824 209 44.41149315 8.9326992 2021-06-25 04:21:33 Liguria, Italy
234902 2021-06-24 Italy Lombardia     841184 33765 794917 12502 45.46679409 9.190347404 2021-06-25 04:21:33 Lombardia, Italy
234903 2021-06-24 Italy Marche     103583 3034 98929 1620 43.61675973 13.5188753 2021-06-25 04:21:33 Marche, Italy
234904 2021-06-24 Italy Molise     13691 491 13112 88 41.55774754 14.65916051 2021-06-25 04:21:33 Molise, Italy
234905 2021-06-24 Italy P.A. Bolzano     73274 1180 71888 206 46.49933453 11.35662422 2021-06-25 04:21:33 P.A. Bolzano, Italy
234906 2021-06-24 Italy P.A. Trento     45748 1361 44281 106 46.06893511 11.12123097 2021-06-25 04:21:33 P.A. Trento, Italy
234907 2021-06-24 Italy Piemonte     362746 11694 349785 1267 45.0732745 7.680687483 2021-06-25 04:21:33 Piemonte, Italy
234908 2021-06-24 Italy Puglia     253079 6613 241154 5312 41.12559576 16.86736689 2021-06-25 04:21:33 Puglia, Italy
234909 2021-06-24 Italy Sardegna     57162 1489 53296 2377 39.21531192 9.110616306 2021-06-25 04:21:33 Sardegna, Italy
234910 2021-06-24 Italy Sicilia     231082 5957 220372 4753 38.11569725 13.362356699999998 2021-06-25 04:21:33 Sicilia, Italy
234911 2021-06-24 Italy Toscana     244057 6854 234648 2555 43.76923077 11.25588885 2021-06-25 04:21:33 Toscana, Italy
234912 2021-06-24 Italy Umbria     56806 1419 54551 836 43.10675841 12.38824698 2021-06-25 04:21:33 Umbria, Italy
234913 2021-06-24 Italy Valle d'Aosta     11678 473 11170 35 45.73750286 7.320149366 2021-06-25 04:21:33 Valle d'Aosta, Italy
234914 2021-06-24 Italy Veneto     425197 11608 408762 4827 45.43490485 12.33845213 2021-06-25 04:21:33 Veneto, Italy
471842 2021-06-23 Italy Abruzzo     74655 2511 71060 1084 42.35122196 13.39843823 2021-06-24 04:21:55 Abruzzo, Italy
471843 2021-06-23 Italy Basilicata     26856 589 25359 908 40.63947052 15.80514834 2021-06-24 04:21:55 Basilicata, Italy
471844 2021-06-23 Italy Calabria     68763 1221 61365 6177 38.90597598 16.59440194 2021-06-24 04:21:55 Calabria, Italy
471845 2021-06-23 Italy Campania     423616 7393 406473 9750 40.83956555 14.25084984 2021-06-24 04:21:55 Campania, Italy
471846 2021-06-23 Italy Emilia-Romagna     386440 13250 368752 4438 44.49436681 11.3417208 2021-06-24 04:21:55 Emilia-Romagna, Italy
471847 2021-06-23 Italy Friuli Venezia Giulia     107502 3800 99348 4354 45.6494354 13.76813649 2021-06-24 04:21:55 Friuli Venezia Giulia, Italy
471848 2021-06-23 Italy Lazio     345456 8310 333254 3892 41.89277044 12.48366722 2021-06-24 04:21:55 Lazio, Italy
471849 2021-06-23 Italy Liguria     103372 4349 98809 214 44.41149315 8.9326992 2021-06-24 04:21:55 Liguria, Italy
471850 2021-06-23 Italy Lombardia     841029 33761 794617 12651 45.46679409 9.190347404 2021-06-24 04:21:55 Lombardia, Italy
471851 2021-06-23 Italy Marche     103571 3034 98866 1671 43.61675973 13.5188753 2021-06-24 04:21:55 Marche, Italy
471852 2021-06-23 Italy Molise     13685 491 13112 82 41.55774754 14.65916051 2021-06-24 04:21:55 Molise, Italy
471853 2021-06-23 Italy P.A. Bolzano     73270 1180 71873 217 46.49933453 11.35662422 2021-06-24 04:21:55 P.A. Bolzano, Italy
471854 2021-06-23 Italy P.A. Trento     45744 1361 44254 129 46.06893511 11.12123097 2021-06-24 04:21:55 P.A. Trento, Italy
471855 2021-06-23 Italy Piemonte     362710 11693 349684 1333 45.0732745 7.680687483 2021-06-24 04:21:55 Piemonte, Italy
471856 2021-06-23 Italy Puglia     253037 6613 240487 5937 41.12559576 16.86736689 2021-06-24 04:21:55 Puglia, Italy
471857 2021-06-23 Italy Sardegna     57146 1489 53251 2406 39.21531192 9.110616306 2021-06-24 04:21:55 Sardegna, Italy
471858 2021-06-23 Italy Sicilia     230963 5951 220104 4908 38.11569725 13.362356699999998 2021-06-24 04:21:55 Sicilia, Italy
471859 2021-06-23 Italy Toscana     243984 6853 234478 2653 43.76923077 11.25588885 2021-06-24 04:21:55 Toscana, Italy
471860 2021-06-23 Italy Umbria     56797 1419 54497 881 43.10675841 12.38824698 2021-06-24 04:21:55 Umbria, Italy
471861 2021-06-23 Italy Valle d'Aosta     11676 473 11165 38 45.73750286 7.320149366 2021-06-24 04:21:55 Valle d'Aosta, Italy
471862 2021-06-23 Italy Veneto     425162 11611 408655 4896 45.43490485 12.33845213 2021-06-24 04:21:55 Veneto, Italy
626900 2021-06-22 Italy Abruzzo     74635 2509 70990 1136 42.35122196 13.39843823 2021-06-23 04:21:46 Abruzzo, Italy
626901 2021-06-22 Italy Basilicata     26844 589 25019 1236 40.63947052 15.80514834 2021-06-23 04:21:46 Basilicata, Italy
626902 2021-06-22 Italy Calabria     68696 1220 61063 6413 38.90597598 16.59440194 2021-06-23 04:21:46 Calabria, Italy
626903 2021-06-22 Italy Campania     423506 7391 406141 9974 40.83956555 14.25084984 2021-06-23 04:21:46 Campania, Italy
626904 2021-06-22 Italy Emilia-Romagna     386389 13250 368236 4903 44.49436681 11.3417208 2021-06-23 04:21:46 Emilia-Romagna, Italy
626905 2021-06-22 Italy Friuli Venezia Giulia     107493 3799 99315 4379 45.6494354 13.76813649 2021-06-23 04:21:46 Friuli Venezia Giulia, Italy
626906 2021-06-22 Italy Lazio     345359 8308 333050 4001 41.89277044 12.48366722 2021-06-23 04:21:46 Lazio, Italy
626907 2021-06-22 Italy Liguria     103169 4348 98596 225 44.41149315 8.9326992 2021-06-23 04:21:46 Liguria, Italy
626908 2021-06-22 Italy Lombardia     840898 33758 793685 13455 45.46679409 9.190347404 2021-06-23 04:21:46 Lombardia, Italy
626909 2021-06-22 Italy Marche     103556 3033 98724 1799 43.61675973 13.5188753 2021-06-23 04:21:46 Marche, Italy
626910 2021-06-22 Italy Molise     13683 491 13107 85 41.55774754 14.65916051 2021-06-23 04:21:46 Molise, Italy
626911 2021-06-22 Italy P.A. Bolzano     73260 1180 71845 235 46.49933453 11.35662422 2021-06-23 04:21:46 P.A. Bolzano, Italy
626912 2021-06-22 Italy P.A. Trento     45736 1361 44251 124 46.06893511 11.12123097 2021-06-23 04:21:46 P.A. Trento, Italy
626913 2021-06-22 Italy Piemonte     362659 11693 349505 1461 45.0732745 7.680687483 2021-06-23 04:21:46 Piemonte, Italy
626914 2021-06-22 Italy Puglia     252974 6610 239301 7063 41.12559576 16.86736689 2021-06-23 04:21:46 Puglia, Italy
626915 2021-06-22 Italy Sardegna     57128 1488 53199 2441 39.21531192 9.110616306 2021-06-23 04:21:46 Sardegna, Italy
626916 2021-06-22 Italy Sicilia     230805 5945 219651 5209 38.11569725 13.362356699999998 2021-06-23 04:21:46 Sicilia, Italy
626917 2021-06-22 Italy Toscana     243934 6849 234234 2851 43.76923077 11.25588885 2021-06-23 04:21:46 Toscana, Italy
626918 2021-06-22 Italy Umbria     56782 1418 54487 877 43.10675841 12.38824698 2021-06-23 04:21:46 Umbria, Italy
626919 2021-06-22 Italy Valle d'Aosta     11675 473 11157 45 45.73750286 7.320149366 2021-06-23 04:21:46 Valle d'Aosta, Italy
626920 2021-06-22 Italy Veneto     425113 11609 408452 5052 45.43490485 12.33845213 2021-06-23 04:21:46 Veneto, Italy
226920 2021-06-21 Italy Abruzzo     74622 2509 70896 1217 42.35122196 13.39843823 2021-06-22 04:21:34 Abruzzo, Italy
226921 2021-06-21 Italy Basilicata     26831 589 24978 1264 40.63947052 15.80514834 2021-06-22 04:21:34 Basilicata, Italy
226922 2021-06-21 Italy Calabria     68679 1219 60664 6796 38.90597598 16.59440194 2021-06-22 04:21:34 Calabria, Italy
226923 2021-06-21 Italy Campania     423412 7390 405824 10198 40.83956555 14.25084984 2021-06-22 04:21:34 Campania, Italy
226924 2021-06-21 Italy Emilia-Romagna     386346 13248 367852 5246 44.49436681 11.3417208 2021-06-22 04:21:34 Emilia-Romagna, Italy
226925 2021-06-21 Italy Friuli Venezia Giulia     107478 3799 99198 4481 45.6494354 13.76813649 2021-06-22 04:21:34 Friuli Venezia Giulia, Italy
226926 2021-06-21 Italy Lazio     345285 8307 332833 4145 41.89277044 12.48366722 2021-06-22 04:21:34 Lazio, Italy
226927 2021-06-21 Italy Liguria     103159 4347 98569 243 44.41149315 8.9326992 2021-06-22 04:21:34 Liguria, Italy
226928 2021-06-21 Italy Lombardia     840772 33757 793368 13647 45.46679409 9.190347404 2021-06-22 04:21:34 Lombardia, Italy
226929 2021-06-21 Italy Marche     103539 3031 98569 1939 43.61675973 13.5188753 2021-06-22 04:21:34 Marche, Italy
226930 2021-06-21 Italy Molise     13682 491 13108 83 41.55774754 14.65916051 2021-06-22 04:21:34 Molise, Italy
226931 2021-06-21 Italy P.A. Bolzano     73257 1180 71828 249 46.49933453 11.35662422 2021-06-22 04:21:34 P.A. Bolzano, Italy
226932 2021-06-21 Italy P.A. Trento     45733 1361 44228 144 46.06893511 11.12123097 2021-06-22 04:21:34 P.A. Trento, Italy
226933 2021-06-21 Italy Piemonte     362614 11691 349305 1618 45.0732745 7.680687483 2021-06-22 04:21:34 Piemonte, Italy
226934 2021-06-21 Italy Puglia     252882 6609 237853 8420 41.12559576 16.86736689 2021-06-22 04:21:34 Puglia, Italy
226935 2021-06-21 Italy Sardegna     57122 1485 53145 2492 39.21531192 9.110616306 2021-06-22 04:21:34 Sardegna, Italy
226936 2021-06-21 Italy Sicilia     230672 5938 219225 5509 38.11569725 13.362356699999998 2021-06-22 04:21:34 Sicilia, Italy
226937 2021-06-21 Italy Toscana     243909 6847 234035 3027 43.76923077 11.25588885 2021-06-22 04:21:34 Toscana, Italy
226938 2021-06-21 Italy Umbria     56775 1418 54474 883 43.10675841 12.38824698 2021-06-22 04:21:34 Umbria, Italy
226939 2021-06-21 Italy Valle d'Aosta     11674 472 11150 52 45.73750286 7.320149366 2021-06-22 04:21:34 Valle d'Aosta, Italy
226940 2021-06-21 Italy Veneto     425017 11603 408214 5200 45.43490485 12.33845213 2021-06-22 04:21:34 Veneto, Italy
1472442 2021-06-20 Italy Abruzzo     74628 2509 70844 1275 42.35122196 13.39843823 2021-06-21 04:21:41 Abruzzo, Italy
1472443 2021-06-20 Italy Basilicata     26827 589 24938 1300 40.63947052 15.80514834 2021-06-21 04:21:41 Basilicata, Italy
1472444 2021-06-20 Italy Calabria     68659 1219 60571 6869 38.90597598 16.59440194 2021-06-21 04:21:41 Calabria, Italy
1472445 2021-06-20 Italy Campania     423381 7386 405623 10372 40.83956555 14.25084984 2021-06-21 04:21:41 Campania, Italy
1472446 2021-06-20 Italy Emilia-Romagna     386265 13246 367429 5590 44.49436681 11.3417208 2021-06-21 04:21:41 Emilia-Romagna, Italy
1472447 2021-06-20 Italy Friuli Venezia Giulia     107476 3799 99198 4479 45.6494354 13.76813649 2021-06-21 04:21:41 Friuli Venezia Giulia, Italy
1472448 2021-06-20 Italy Lazio     345214 8304 332671 4239 41.89277044 12.48366722 2021-06-21 04:21:41 Lazio, Italy
1472449 2021-06-20 Italy Liguria     103151 4346 98527 278 44.41149315 8.9326992 2021-06-21 04:21:41 Liguria, Italy
1472450 2021-06-20 Italy Lombardia     840689 33753 793279 13657 45.46679409 9.190347404 2021-06-21 04:21:41 Lombardia, Italy
1472451 2021-06-20 Italy Marche     103539 3031 98496 2012 43.61675973 13.5188753 2021-06-21 04:21:41 Marche, Italy
1472452 2021-06-20 Italy Molise     13682 491 13101 90 41.55774754 14.65916051 2021-06-21 04:21:41 Molise, Italy
1472453 2021-06-20 Italy P.A. Bolzano     73254 1180 71798 276 46.49933453 11.35662422 2021-06-21 04:21:41 P.A. Bolzano, Italy
1472454 2021-06-20 Italy P.A. Trento     45731 1361 44221 149 46.06893511 11.12123097 2021-06-21 04:21:41 P.A. Trento, Italy
1472455 2021-06-20 Italy Piemonte     362594 11690 349206 1698 45.0732745 7.680687483 2021-06-21 04:21:41 Piemonte, Italy
1472456 2021-06-20 Italy Puglia     252863 6605 237399 8859 41.12559576 16.86736689 2021-06-21 04:21:41 Puglia, Italy
1472457 2021-06-20 Italy Sardegna     57118 1485 44055 11578 39.21531192 9.110616306 2021-06-21 04:21:41 Sardegna, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);