⚠️ 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

province_or_state

country_or_region

  • Italy · 7,580
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1331026 2021-05-04 Italy Abruzzo     71724 2420 60938 8366 42.35122196 13.39843823 2021-05-05 04:20:43 Abruzzo, Italy
1331027 2021-05-04 Italy Basilicata     24330 542 17565 6223 40.63947052 15.80514834 2021-05-05 04:20:43 Basilicata, Italy
1331028 2021-05-04 Italy Calabria     61227 1040 46040 14147 38.90597598 16.59440194 2021-05-05 04:20:43 Calabria, Italy
1331029 2021-05-04 Italy Campania     397384 6484 301880 89020 40.83956555 14.25084984 2021-05-05 04:20:43 Campania, Italy
1331030 2021-05-04 Italy Emilia-Romagna     372262 12940 320194 39128 44.49436681 11.3417208 2021-05-05 04:20:43 Emilia-Romagna, Italy
1331031 2021-05-04 Italy Friuli Venezia Giulia     105587 3720 94813 7054 45.6494354 13.76813649 2021-05-05 04:20:43 Friuli Venezia Giulia, Italy
1331032 2021-05-04 Italy Lazio     327273 7757 278237 41279 41.89277044 12.48366722 2021-05-05 04:20:43 Lazio, Italy
1331033 2021-05-04 Italy Liguria     100133 4210 90886 5037 44.41149315 8.9326992 2021-05-05 04:20:43 Liguria, Italy
1331034 2021-05-04 Italy Lombardia     810037 33014 728840 48183 45.46679409 9.190347404 2021-05-05 04:20:43 Lombardia, Italy
1331035 2021-05-04 Italy Marche     98359 2951 89398 6010 43.61675973 13.5188753 2021-05-05 04:20:43 Marche, Italy
1331036 2021-05-04 Italy Molise     13314 478 12269 567 41.55774754 14.65916051 2021-05-05 04:20:43 Molise, Italy
1331037 2021-05-04 Italy P.A. Bolzano     71427 1164 69094 1169 46.49933453 11.35662422 2021-05-05 04:20:43 P.A. Bolzano, Italy
1331038 2021-05-04 Italy P.A. Trento     44219 1346 41861 1012 46.06893511 11.12123097 2021-05-05 04:20:43 P.A. Trento, Italy
1331039 2021-05-04 Italy Piemonte     347957 11330 321868 14759 45.0732745 7.680687483 2021-05-05 04:20:43 Piemonte, Italy
1331040 2021-05-04 Italy Puglia     238144 5998 185526 46620 41.12559576 16.86736689 2021-05-05 04:20:43 Puglia, Italy
1331041 2021-05-04 Italy Sardegna     54980 1398 37139 16443 39.21531192 9.110616306 2021-05-05 04:20:43 Sardegna, Italy
1331042 2021-05-04 Italy Sicilia     211895 5468 181604 24823 38.11569725 13.362356699999998 2021-05-05 04:20:43 Sicilia, Italy
1331043 2021-05-04 Italy Toscana     229540 6273 203731 19536 43.76923077 11.25588885 2021-05-05 04:20:43 Toscana, Italy
1331044 2021-05-04 Italy Umbria     54736 1361 50561 2814 43.10675841 12.38824698 2021-05-05 04:20:43 Umbria, Italy
1331045 2021-05-04 Italy Valle d'Aosta     11066 459 9922 685 45.73750286 7.320149366 2021-05-05 04:20:43 Valle d'Aosta, Italy
1331046 2021-05-04 Italy Veneto     414227 11385 381828 21014 45.43490485 12.33845213 2021-05-05 04:20:43 Veneto, Italy
1035613 2021-05-03 Italy Abruzzo     71640 2415 60613 8612 42.35122196 13.39843823 2021-05-04 04:20:34 Abruzzo, Italy
1035614 2021-05-03 Italy Basilicata     24258 540 17487 6231 40.63947052 15.80514834 2021-05-04 04:20:34 Basilicata, Italy
1035615 2021-05-03 Italy Calabria     60925 1035 45505 14385 38.90597598 16.59440194 2021-05-04 04:20:34 Calabria, Italy
1035616 2021-05-03 Italy Campania     396053 6446 299192 90415 40.83956555 14.25084984 2021-05-04 04:20:34 Campania, Italy
1035617 2021-05-03 Italy Emilia-Romagna     371776 12916 316859 42001 44.49436681 11.3417208 2021-05-04 04:20:34 Emilia-Romagna, Italy
1035618 2021-05-03 Italy Friuli Venezia Giulia     105454 3717 94450 7287 45.6494354 13.76813649 2021-05-04 04:20:34 Friuli Venezia Giulia, Italy
1035619 2021-05-03 Italy Lazio     326470 7721 275992 42757 41.89277044 12.48366722 2021-05-04 04:20:34 Lazio, Italy
1035620 2021-05-03 Italy Liguria     99972 4200 90405 5367 44.41149315 8.9326992 2021-05-04 04:20:34 Liguria, Italy
1035621 2021-05-03 Italy Lombardia     808683 32973 727433 48277 45.46679409 9.190347404 2021-05-04 04:20:34 Lombardia, Italy
1035622 2021-05-03 Italy Marche     98155 2945 89134 6076 43.61675973 13.5188753 2021-05-04 04:20:34 Marche, Italy
1035623 2021-05-03 Italy Molise     13309 478 12238 593 41.55774754 14.65916051 2021-05-04 04:20:34 Molise, Italy
1035624 2021-05-03 Italy P.A. Bolzano     71354 1162 69015 1177 46.49933453 11.35662422 2021-05-04 04:20:34 P.A. Bolzano, Italy
1035625 2021-05-03 Italy P.A. Trento     44132 1346 41735 1051 46.06893511 11.12123097 2021-05-04 04:20:34 P.A. Trento, Italy
1035626 2021-05-03 Italy Piemonte     347320 11302 320847 15171 45.0732745 7.680687483 2021-05-04 04:20:34 Piemonte, Italy
1035627 2021-05-03 Italy Puglia     237116 5964 184129 47023 41.12559576 16.86736689 2021-05-04 04:20:34 Puglia, Italy
1035628 2021-05-03 Italy Sardegna     54876 1393 36718 16765 39.21531192 9.110616306 2021-05-04 04:20:34 Sardegna, Italy
1035629 2021-05-03 Italy Sicilia     210993 5443 180595 24955 38.11569725 13.362356699999998 2021-05-04 04:20:34 Sicilia, Italy
1035630 2021-05-03 Italy Toscana     229037 6248 202799 19990 43.76923077 11.25588885 2021-05-04 04:20:34 Toscana, Italy
1035631 2021-05-03 Italy Umbria     54638 1361 50490 2787 43.10675841 12.38824698 2021-05-04 04:20:34 Umbria, Italy
1035632 2021-05-03 Italy Valle d'Aosta     11041 459 9867 715 45.73750286 7.320149366 2021-05-04 04:20:34 Valle d'Aosta, Italy
1035633 2021-05-03 Italy Veneto     413506 11369 380214 21923 45.43490485 12.33845213 2021-05-04 04:20:34 Veneto, Italy
913803 2021-05-02 Italy Abruzzo     71603 2412 60458 8733 42.35122196 13.39843823 2021-05-03 04:20:39 Abruzzo, Italy
913804 2021-05-02 Italy Basilicata     24232 536 17412 6284 40.63947052 15.80514834 2021-05-03 04:20:39 Basilicata, Italy
913805 2021-05-02 Italy Calabria     60697 1019 44453 15225 38.90597598 16.59440194 2021-05-03 04:20:39 Calabria, Italy
913806 2021-05-02 Italy Campania     395094 6416 297441 91237 40.83956555 14.25084984 2021-05-03 04:20:39 Campania, Italy
913807 2021-05-02 Italy Emilia-Romagna     371137 12906 316468 41763 44.49436681 11.3417208 2021-05-03 04:20:39 Emilia-Romagna, Italy
913808 2021-05-02 Italy Friuli Venezia Giulia     105403 3714 94416 7273 45.6494354 13.76813649 2021-05-03 04:20:39 Friuli Venezia Giulia, Italy
913809 2021-05-02 Italy Lazio     325809 7699 274897 43213 41.89277044 12.48366722 2021-05-03 04:20:39 Lazio, Italy
913810 2021-05-02 Italy Liguria     99837 4194 90046 5597 44.41149315 8.9326992 2021-05-03 04:20:39 Liguria, Italy
913811 2021-05-02 Italy Lombardia     808046 32945 722815 52286 45.46679409 9.190347404 2021-05-03 04:20:39 Lombardia, Italy
913812 2021-05-02 Italy Marche     98096 2944 89051 6101 43.61675973 13.5188753 2021-05-03 04:20:39 Marche, Italy
913813 2021-05-02 Italy Molise     13287 478 12205 604 41.55774754 14.65916051 2021-05-03 04:20:39 Molise, Italy
913814 2021-05-02 Italy P.A. Bolzano     71349 1162 69009 1178 46.49933453 11.35662422 2021-05-03 04:20:39 P.A. Bolzano, Italy
913815 2021-05-02 Italy P.A. Trento     44115 1345 41720 1050 46.06893511 11.12123097 2021-05-03 04:20:39 P.A. Trento, Italy
913816 2021-05-02 Italy Piemonte     346977 11283 320221 15473 45.0732745 7.680687483 2021-05-03 04:20:39 Piemonte, Italy
913817 2021-05-02 Italy Puglia     236781 5912 183232 47637 41.12559576 16.86736689 2021-05-03 04:20:39 Puglia, Italy
913818 2021-05-02 Italy Sardegna     54815 1389 36534 16892 39.21531192 9.110616306 2021-05-03 04:20:39 Sardegna, Italy
913819 2021-05-02 Italy Sicilia     210259 5423 180055 24781 38.11569725 13.362356699999998 2021-05-03 04:20:39 Sicilia, Italy
913820 2021-05-02 Italy Toscana     228467 6219 201958 20290 43.76923077 11.25588885 2021-05-03 04:20:39 Toscana, Italy
913821 2021-05-02 Italy Umbria     54603 1357 50395 2851 43.10675841 12.38824698 2021-05-03 04:20:39 Umbria, Italy
913822 2021-05-02 Italy Valle d'Aosta     11013 459 9856 698 45.73750286 7.320149366 2021-05-03 04:20:39 Valle d'Aosta, Italy
913823 2021-05-02 Italy Veneto     413142 11365 380037 21740 45.43490485 12.33845213 2021-05-03 04:20:39 Veneto, Italy
1756769 2021-05-01 Italy Abruzzo     71444 2408 60457 8579 42.35122196 13.39843823 2021-05-02 04:20:48 Abruzzo, Italy
1756770 2021-05-01 Italy Basilicata     24155 534 17329 6292 40.63947052 15.80514834 2021-05-02 04:20:48 Basilicata, Italy
1756771 2021-05-01 Italy Calabria     60411 1015 44339 15057 38.90597598 16.59440194 2021-05-02 04:20:48 Calabria, Italy
1756772 2021-05-01 Italy Campania     393742 6405 295740 91597 40.83956555 14.25084984 2021-05-02 04:20:48 Campania, Italy
1756773 2021-05-01 Italy Emilia-Romagna     370190 12893 315967 41330 44.49436681 11.3417208 2021-05-02 04:20:48 Emilia-Romagna, Italy
1756774 2021-05-01 Italy Friuli Venezia Giulia     105379 3711 94304 7364 45.6494354 13.76813649 2021-05-02 04:20:48 Friuli Venezia Giulia, Italy
1756775 2021-05-01 Italy Lazio     324823 7686 273842 43295 41.89277044 12.48366722 2021-05-02 04:20:48 Lazio, Italy
1756776 2021-05-01 Italy Liguria     99635 4189 89913 5533 44.41149315 8.9326992 2021-05-02 04:20:48 Liguria, Italy
1756777 2021-05-01 Italy Lombardia     806759 32922 722214 51623 45.46679409 9.190347404 2021-05-02 04:20:48 Lombardia, Italy
1756778 2021-05-01 Italy Marche     97964 2943 88843 6178 43.61675973 13.5188753 2021-05-02 04:20:48 Marche, Italy
1756779 2021-05-01 Italy Molise     13259 478 12149 632 41.55774754 14.65916051 2021-05-02 04:20:48 Molise, Italy
1756780 2021-05-01 Italy P.A. Bolzano     71277 1162 68955 1160 46.49933453 11.35662422 2021-05-02 04:20:48 P.A. Bolzano, Italy
1756781 2021-05-01 Italy P.A. Trento     44077 1345 41600 1132 46.06893511 11.12123097 2021-05-02 04:20:48 P.A. Trento, Italy
1756782 2021-05-01 Italy Piemonte     346275 11273 319531 15471 45.0732745 7.680687483 2021-05-02 04:20:48 Piemonte, Italy
1756783 2021-05-01 Italy Puglia     235971 5894 182310 47767 41.12559576 16.86736689 2021-05-02 04:20:48 Puglia, Italy
1756784 2021-05-01 Italy Sardegna     54691 1387 36328 16976 39.21531192 9.110616306 2021-05-02 04:20:48 Sardegna, Italy
1756785 2021-05-01 Italy Sicilia     209487 5420 179294 24773 38.11569725 13.362356699999998 2021-05-02 04:20:48 Sicilia, Italy
1756786 2021-05-01 Italy Toscana     227737 6202 201136 20399 43.76923077 11.25588885 2021-05-02 04:20:48 Toscana, Italy
1756787 2021-05-01 Italy Umbria     54538 1357 50300 2881 43.10675841 12.38824698 2021-05-02 04:20:48 Umbria, Italy
1756788 2021-05-01 Italy Valle d'Aosta     10990 459 9804 727 45.73750286 7.320149366 2021-05-02 04:20:48 Valle d'Aosta, Italy
1756789 2021-05-01 Italy Veneto     412813 11350 379687 21776 45.43490485 12.33845213 2021-05-02 04:20:48 Veneto, Italy
1456540 2021-04-30 Italy Abruzzo     71218 2403 60432 8383 42.35122196 13.39843823 2021-05-01 04:20:47 Abruzzo, Italy
1456541 2021-04-30 Italy Basilicata     23956 534 17192 6230 40.63947052 15.80514834 2021-05-01 04:20:47 Basilicata, Italy
1456542 2021-04-30 Italy Calabria     60074 1011 43849 15214 38.90597598 16.59440194 2021-05-01 04:20:47 Calabria, Italy
1456543 2021-04-30 Italy Campania     391792 6393 294011 91388 40.83956555 14.25084984 2021-05-01 04:20:47 Campania, Italy
1456544 2021-04-30 Italy Emilia-Romagna     369250 12876 312018 44356 44.49436681 11.3417208 2021-05-01 04:20:47 Emilia-Romagna, Italy
1456545 2021-04-30 Italy Friuli Venezia Giulia     105156 3700 93878 7578 45.6494354 13.76813649 2021-05-01 04:20:47 Friuli Venezia Giulia, Italy
1456546 2021-04-30 Italy Lazio     323754 7673 271385 44696 41.89277044 12.48366722 2021-05-01 04:20:47 Lazio, Italy
1456547 2021-04-30 Italy Liguria     99416 4183 89762 5471 44.41149315 8.9326992 2021-05-01 04:20:47 Liguria, Italy
1456548 2021-04-30 Italy Lombardia     804620 32870 719265 52485 45.46679409 9.190347404 2021-05-01 04:20:47 Lombardia, Italy
1456549 2021-04-30 Italy Marche     97705 2938 88565 6202 43.61675973 13.5188753 2021-05-01 04:20:47 Marche, Italy
1456550 2021-04-30 Italy Molise     13228 475 12124 629 41.55774754 14.65916051 2021-05-01 04:20:47 Molise, Italy
1456551 2021-04-30 Italy P.A. Bolzano     71142 1161 68942 1039 46.49933453 11.35662422 2021-05-01 04:20:47 P.A. Bolzano, Italy
1456552 2021-04-30 Italy P.A. Trento     43999 1344 41579 1076 46.06893511 11.12123097 2021-05-01 04:20:47 P.A. Trento, Italy
1456553 2021-04-30 Italy Piemonte     345393 11255 318439 15699 45.0732745 7.680687483 2021-05-01 04:20:47 Piemonte, Italy
1456554 2021-04-30 Italy Puglia     234841 5873 181376 47592 41.12559576 16.86736689 2021-05-01 04:20:47 Puglia, Italy
1456555 2021-04-30 Italy Sardegna     54507 1384 36030 17093 39.21531192 9.110616306 2021-05-01 04:20:47 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]);