⚠️ 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,546 rows where country_or_region = "Italy" sorted by day descending

View and edit SQL

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

province_or_state

country_or_region

  • Italy · 8,546
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168438 2021-06-19 Italy Abruzzo     74601 2509 70837 1255 42.35122196 13.39843823 2021-06-20 04:21:48 Abruzzo, Italy
168439 2021-06-19 Italy Basilicata     26791 588 24371 1832 40.63947052 15.80514834 2021-06-20 04:21:48 Basilicata, Italy
168440 2021-06-19 Italy Calabria     68605 1219 60481 6905 38.90597598 16.59440194 2021-06-20 04:21:48 Calabria, Italy
168441 2021-06-19 Italy Campania     423299 7383 405295 10621 40.83956555 14.25084984 2021-06-20 04:21:48 Campania, Italy
168442 2021-06-19 Italy Emilia-Romagna     386192 13245 367185 5762 44.49436681 11.3417208 2021-06-20 04:21:48 Emilia-Romagna, Italy
168443 2021-06-19 Italy Friuli Venezia Giulia     107469 3799 99192 4478 45.6494354 13.76813649 2021-06-20 04:21:48 Friuli Venezia Giulia, Italy
168444 2021-06-19 Italy Lazio     345146 8304 332483 4359 41.89277044 12.48366722 2021-06-20 04:21:48 Lazio, Italy
168445 2021-06-19 Italy Liguria     103133 4345 98497 291 44.41149315 8.9326992 2021-06-20 04:21:48 Liguria, Italy
168446 2021-06-19 Italy Lombardia     840544 33751 793206 13587 45.46679409 9.190347404 2021-06-20 04:21:48 Lombardia, Italy
168447 2021-06-19 Italy Marche     103524 3031 98424 2069 43.61675973 13.5188753 2021-06-20 04:21:48 Marche, Italy
168448 2021-06-19 Italy Molise     13670 491 13098 81 41.55774754 14.65916051 2021-06-20 04:21:48 Molise, Italy
168449 2021-06-19 Italy P.A. Bolzano     73246 1180 71769 297 46.49933453 11.35662422 2021-06-20 04:21:48 P.A. Bolzano, Italy
168450 2021-06-19 Italy P.A. Trento     45727 1361 44200 166 46.06893511 11.12123097 2021-06-20 04:21:48 P.A. Trento, Italy
168451 2021-06-19 Italy Piemonte     362563 11688 349077 1798 45.0732745 7.680687483 2021-06-20 04:21:48 Piemonte, Italy
168452 2021-06-19 Italy Puglia     252818 6604 237305 8909 41.12559576 16.86736689 2021-06-20 04:21:48 Puglia, Italy
168453 2021-06-19 Italy Sardegna     57109 1485 44027 11597 39.21531192 9.110616306 2021-06-20 04:21:48 Sardegna, Italy
168454 2021-06-19 Italy Sicilia     230452 5936 218901 5615 38.11569725 13.362356699999998 2021-06-20 04:21:48 Sicilia, Italy
168455 2021-06-19 Italy Toscana     243809 6842 233679 3288 43.76923077 11.25588885 2021-06-20 04:21:48 Toscana, Italy
168456 2021-06-19 Italy Umbria     56744 1418 54432 894 43.10675841 12.38824698 2021-06-20 04:21:48 Umbria, Italy
168457 2021-06-19 Italy Valle d'Aosta     11670 472 11137 61 45.73750286 7.320149366 2021-06-20 04:21:48 Valle d'Aosta, Italy
168458 2021-06-19 Italy Veneto     424983 11602 408096 5285 45.43490485 12.33845213 2021-06-20 04:21:48 Veneto, Italy
685963 2021-06-18 Italy Abruzzo     74570 2507 70786 1277 42.35122196 13.39843823 2021-06-19 04:22:33 Abruzzo, Italy
685964 2021-06-18 Italy Basilicata     26778 587 23456 2735 40.63947052 15.80514834 2021-06-19 04:22:33 Basilicata, Italy
685965 2021-06-18 Italy Calabria     68494 1217 60256 7021 38.90597598 16.59440194 2021-06-19 04:22:33 Calabria, Italy
685966 2021-06-18 Italy Campania     423160 7379 405009 10772 40.83956555 14.25084984 2021-06-19 04:22:33 Campania, Italy
685967 2021-06-18 Italy Emilia-Romagna     386099 13245 366860 5994 44.49436681 11.3417208 2021-06-19 04:22:33 Emilia-Romagna, Italy
685968 2021-06-18 Italy Friuli Venezia Giulia     107454 3798 99142 4514 45.6494354 13.76813649 2021-06-19 04:22:33 Friuli Venezia Giulia, Italy
685969 2021-06-18 Italy Lazio     345045 8303 332268 4474 41.89277044 12.48366722 2021-06-19 04:22:33 Lazio, Italy
685970 2021-06-18 Italy Liguria     103119 4344 98489 286 44.41149315 8.9326992 2021-06-19 04:22:33 Liguria, Italy
685971 2021-06-18 Italy Lombardia     840361 33748 792781 13832 45.46679409 9.190347404 2021-06-19 04:22:33 Lombardia, Italy
685972 2021-06-18 Italy Marche     103508 3030 98277 2201 43.61675973 13.5188753 2021-06-19 04:22:33 Marche, Italy
685973 2021-06-18 Italy Molise     13663 491 13090 82 41.55774754 14.65916051 2021-06-19 04:22:33 Molise, Italy
685974 2021-06-18 Italy P.A. Bolzano     73238 1180 71753 305 46.49933453 11.35662422 2021-06-19 04:22:33 P.A. Bolzano, Italy
685975 2021-06-18 Italy P.A. Trento     45719 1361 44180 178 46.06893511 11.12123097 2021-06-19 04:22:33 P.A. Trento, Italy
685976 2021-06-18 Italy Piemonte     362497 11686 348906 1905 45.0732745 7.680687483 2021-06-19 04:22:33 Piemonte, Italy
685977 2021-06-18 Italy Puglia     252757 6601 236813 9343 41.12559576 16.86736689 2021-06-19 04:22:33 Puglia, Italy
685978 2021-06-18 Italy Sardegna     57096 1485 44005 11606 39.21531192 9.110616306 2021-06-19 04:22:33 Sardegna, Italy
685979 2021-06-18 Italy Sicilia     230269 5931 218636 5702 38.11569725 13.362356699999998 2021-06-19 04:22:33 Sicilia, Italy
685980 2021-06-18 Italy Toscana     243747 6841 233436 3470 43.76923077 11.25588885 2021-06-19 04:22:33 Toscana, Italy
685981 2021-06-18 Italy Umbria     56736 1418 54392 926 43.10675841 12.38824698 2021-06-19 04:22:33 Umbria, Italy
685982 2021-06-18 Italy Valle d'Aosta     11667 472 11131 64 45.73750286 7.320149366 2021-06-19 04:22:33 Valle d'Aosta, Italy
685983 2021-06-18 Italy Veneto     424925 11601 407939 5385 45.43490485 12.33845213 2021-06-19 04:22:33 Veneto, Italy
958020 2021-06-17 Italy Abruzzo     74545 2507 70736 1302 42.35122196 13.39843823 2021-06-18 04:22:16 Abruzzo, Italy
958021 2021-06-17 Italy Basilicata     26764 587 23401 2776 40.63947052 15.80514834 2021-06-18 04:22:16 Basilicata, Italy
958022 2021-06-17 Italy Calabria     68417 1217 59864 7336 38.90597598 16.59440194 2021-06-18 04:22:16 Calabria, Italy
958023 2021-06-17 Italy Campania     423053 7371 404602 11080 40.83956555 14.25084984 2021-06-18 04:22:16 Campania, Italy
958024 2021-06-17 Italy Emilia-Romagna     386028 13239 366551 6238 44.49436681 11.3417208 2021-06-18 04:22:16 Emilia-Romagna, Italy
958025 2021-06-17 Italy Friuli Venezia Giulia     107431 3797 99100 4534 45.6494354 13.76813649 2021-06-18 04:22:16 Friuli Venezia Giulia, Italy
958026 2021-06-17 Italy Lazio     344898 8300 331704 4894 41.89277044 12.48366722 2021-06-18 04:22:16 Lazio, Italy
958027 2021-06-17 Italy Liguria     103103 4343 98472 288 44.41149315 8.9326992 2021-06-18 04:22:16 Liguria, Italy
958028 2021-06-17 Italy Lombardia     840247 33746 789375 17126 45.46679409 9.190347404 2021-06-18 04:22:16 Lombardia, Italy
958029 2021-06-17 Italy Marche     103480 3028 98019 2433 43.61675973 13.5188753 2021-06-18 04:22:16 Marche, Italy
958030 2021-06-17 Italy Molise     13651 491 13087 73 41.55774754 14.65916051 2021-06-18 04:22:16 Molise, Italy
958031 2021-06-17 Italy P.A. Bolzano     73229 1180 71721 328 46.49933453 11.35662422 2021-06-18 04:22:16 P.A. Bolzano, Italy
958032 2021-06-17 Italy P.A. Trento     45711 1361 44159 191 46.06893511 11.12123097 2021-06-18 04:22:16 P.A. Trento, Italy
958033 2021-06-17 Italy Piemonte     362439 11684 348696 2059 45.0732745 7.680687483 2021-06-18 04:22:16 Piemonte, Italy
958034 2021-06-17 Italy Puglia     252651 6597 235823 10231 41.12559576 16.86736689 2021-06-18 04:22:16 Puglia, Italy
958035 2021-06-17 Italy Sardegna     57088 1485 43960 11643 39.21531192 9.110616306 2021-06-18 04:22:16 Sardegna, Italy
958036 2021-06-17 Italy Sicilia     230099 5928 218270 5901 38.11569725 13.362356699999998 2021-06-18 04:22:16 Sicilia, Italy
958037 2021-06-17 Italy Toscana     243680 6838 233201 3641 43.76923077 11.25588885 2021-06-18 04:22:16 Toscana, Italy
958038 2021-06-17 Italy Umbria     56723 1418 54352 953 43.10675841 12.38824698 2021-06-18 04:22:16 Umbria, Italy
958039 2021-06-17 Italy Valle d'Aosta     11665 472 11119 74 45.73750286 7.320149366 2021-06-18 04:22:16 Valle d'Aosta, Italy
958040 2021-06-17 Italy Veneto     424853 11601 407745 5507 45.43490485 12.33845213 2021-06-18 04:22:16 Veneto, Italy
1281387 2021-06-16 Italy Abruzzo     74523 2506 70658 1359 42.35122196 13.39843823 2021-06-17 04:22:36 Abruzzo, Italy
1281388 2021-06-16 Italy Basilicata     26733 587 23305 2841 40.63947052 15.80514834 2021-06-17 04:22:36 Basilicata, Italy
1281389 2021-06-16 Italy Calabria     68348 1214 59717 7417 38.90597598 16.59440194 2021-06-17 04:22:36 Calabria, Italy
1281390 2021-06-16 Italy Campania     422922 7363 404125 11434 40.83956555 14.25084984 2021-06-17 04:22:36 Campania, Italy
1281391 2021-06-16 Italy Emilia-Romagna     385941 13239 366031 6671 44.49436681 11.3417208 2021-06-17 04:22:36 Emilia-Romagna, Italy
1281392 2021-06-16 Italy Friuli Venezia Giulia     107408 3795 99073 4540 45.6494354 13.76813649 2021-06-17 04:22:36 Friuli Venezia Giulia, Italy
1281393 2021-06-16 Italy Lazio     344779 8292 331243 5244 41.89277044 12.48366722 2021-06-17 04:22:36 Lazio, Italy
1281394 2021-06-16 Italy Liguria     103085 4343 98425 317 44.41149315 8.9326992 2021-06-17 04:22:36 Liguria, Italy
1281395 2021-06-16 Italy Lombardia     840015 33742 789029 17244 45.46679409 9.190347404 2021-06-17 04:22:36 Lombardia, Italy
1281396 2021-06-16 Italy Marche     103459 3026 97783 2650 43.61675973 13.5188753 2021-06-17 04:22:36 Marche, Italy
1281397 2021-06-16 Italy Molise     13647 491 13078 78 41.55774754 14.65916051 2021-06-17 04:22:36 Molise, Italy
1281398 2021-06-16 Italy P.A. Bolzano     73210 1180 71672 358 46.49933453 11.35662422 2021-06-17 04:22:36 P.A. Bolzano, Italy
1281399 2021-06-16 Italy P.A. Trento     45700 1360 44147 193 46.06893511 11.12123097 2021-06-17 04:22:36 P.A. Trento, Italy
1281400 2021-06-16 Italy Piemonte     362367 11684 348484 2199 45.0732745 7.680687483 2021-06-17 04:22:36 Piemonte, Italy
1281401 2021-06-16 Italy Puglia     252561 6595 234937 11029 41.12559576 16.86736689 2021-06-17 04:22:36 Puglia, Italy
1281402 2021-06-16 Italy Sardegna     57085 1485 43836 11764 39.21531192 9.110616306 2021-06-17 04:22:36 Sardegna, Italy
1281403 2021-06-16 Italy Sicilia     229871 5928 217940 6003 38.11569725 13.362356699999998 2021-06-17 04:22:36 Sicilia, Italy
1281404 2021-06-16 Italy Toscana     243620 6832 232927 3861 43.76923077 11.25588885 2021-06-17 04:22:36 Toscana, Italy
1281405 2021-06-16 Italy Umbria     56704 1418 54323 963 43.10675841 12.38824698 2021-06-17 04:22:36 Umbria, Italy
1281406 2021-06-16 Italy Valle d'Aosta     11662 472 11109 81 45.73750286 7.320149366 2021-06-17 04:22:36 Valle d'Aosta, Italy
1281407 2021-06-16 Italy Veneto     424792 11601 407582 5609 45.43490485 12.33845213 2021-06-17 04:22:36 Veneto, Italy
681977 2021-06-15 Italy Abruzzo     74496 2503 70616 1377 42.35122196 13.39843823 2021-06-16 04:22:32 Abruzzo, Italy
681978 2021-06-15 Italy Basilicata     26717 587 23234 2896 40.63947052 15.80514834 2021-06-16 04:22:32 Basilicata, Italy
681979 2021-06-15 Italy Calabria     68282 1213 59306 7763 38.90597598 16.59440194 2021-06-16 04:22:32 Calabria, Italy
681980 2021-06-15 Italy Campania     422755 7357 403661 11737 40.83956555 14.25084984 2021-06-16 04:22:32 Campania, Italy
681981 2021-06-15 Italy Emilia-Romagna     385868 13236 365384 7248 44.49436681 11.3417208 2021-06-16 04:22:32 Emilia-Romagna, Italy
681982 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
681983 2021-06-15 Italy Lazio     344636 8281 330853 5502 41.89277044 12.48366722 2021-06-16 04:22:32 Lazio, Italy
681984 2021-06-15 Italy Liguria     103064 4343 98337 384 44.41149315 8.9326992 2021-06-16 04:22:32 Liguria, Italy
681985 2021-06-15 Italy Lombardia     839759 33737 787696 18326 45.46679409 9.190347404 2021-06-16 04:22:32 Lombardia, Italy
681986 2021-06-15 Italy Marche     103430 3026 97733 2671 43.61675973 13.5188753 2021-06-16 04:22:32 Marche, Italy
681987 2021-06-15 Italy Molise     13646 491 13072 83 41.55774754 14.65916051 2021-06-16 04:22:32 Molise, Italy
681988 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
681989 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
681990 2021-06-15 Italy Piemonte     362308 11681 348249 2378 45.0732745 7.680687483 2021-06-16 04:22:32 Piemonte, Italy
681991 2021-06-15 Italy Puglia     252449 6592 234546 11311 41.12559576 16.86736689 2021-06-16 04:22:32 Puglia, Italy
681992 2021-06-15 Italy Sardegna     57061 1484 43710 11867 39.21531192 9.110616306 2021-06-16 04:22:32 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]);