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

5,417 rows where country_or_region = "Italy" sorted by day descending

View and edit SQL

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

province_or_state

country_or_region

  • Italy · 5,417
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298585 2021-01-21 Italy Abruzzo     40025 1358 28007 10660 42.35122196 13.39843823 2021-01-22 05:22:10 Abruzzo, Italy
298586 2021-01-21 Italy Basilicata     12684 306 5437 6941 40.63947052 15.80514834 2021-01-22 05:22:10 Basilicata, Italy
298587 2021-01-21 Italy Calabria     30091 552 19571 9968 38.90597598 16.59440194 2021-01-22 05:22:10 Calabria, Italy
298588 2021-01-21 Italy Campania     210697 3511 136008 71178 40.83956555 14.25084984 2021-01-22 05:22:10 Campania, Italy
298589 2021-01-21 Italy Emilia-Romagna     206578 9008 145533 52037 44.49436681 11.3417208 2021-01-22 05:22:10 Emilia-Romagna, Italy
298590 2021-01-21 Italy Friuli Venezia Giulia     62702 2183 48339 12180 45.6494354 13.76813649 2021-01-22 05:22:10 Friuli Venezia Giulia, Italy
298591 2021-01-21 Italy Lazio     194199 4571 116943 72685 41.89277044 12.48366722 2021-01-22 05:22:10 Lazio, Italy
298592 2021-01-21 Italy Liguria     66789 3183 59003 4603 44.41149315 8.9326992 2021-01-22 05:22:10 Liguria, Italy
298593 2021-01-21 Italy Lombardia     520395 26460 440880 53055 45.46679409 9.190347404 2021-01-22 05:22:10 Lombardia, Italy
298594 2021-01-21 Italy Marche     51544 1841 41629 8074 43.61675973 13.5188753 2021-01-22 05:22:10 Marche, Italy
298595 2021-01-21 Italy Molise     7692 243 6404 1045 41.55774754 14.65916051 2021-01-22 05:22:10 Molise, Italy
298596 2021-01-21 Italy P.A. Bolzano     35127 831 21473 12823 46.49933453 11.35662422 2021-01-22 05:22:10 P.A. Bolzano, Italy
298597 2021-01-21 Italy P.A. Trento     25714 1092 22616 2006 46.06893511 11.12123097 2021-01-22 05:22:10 P.A. Trento, Italy
298598 2021-01-21 Italy Piemonte     215278 8525 193160 13593 45.0732745 7.680687483 2021-01-22 05:22:10 Piemonte, Italy
298599 2021-01-21 Italy Puglia     113115 2943 55388 54784 41.12559576 16.86736689 2021-01-22 05:22:10 Puglia, Italy
298600 2021-01-21 Italy Sardegna     36473 927 18430 17116 39.21531192 9.110616306 2021-01-22 05:22:10 Sardegna, Italy
298601 2021-01-21 Italy Sicilia     126364 3129 76337 46898 38.11569725 13.362356699999998 2021-01-22 05:22:10 Sicilia, Italy
298602 2021-01-21 Italy Toscana     129384 4052 117029 8303 43.76923077 11.25588885 2021-01-22 05:22:10 Toscana, Italy
298603 2021-01-21 Italy Umbria     33185 723 27741 4721 43.10675841 12.38824698 2021-01-22 05:22:10 Umbria, Italy
298604 2021-01-21 Italy Valle d'Aosta     7696 400 6955 341 45.73750286 7.320149366 2021-01-22 05:22:10 Valle d'Aosta, Italy
298605 2021-01-21 Italy Veneto     302489 8364 240568 53557 45.43490485 12.33845213 2021-01-22 05:22:10 Veneto, Italy
889637 2021-01-20 Italy Abruzzo     39814 1349 27478 10987 42.35122196 13.39843823 2021-01-21 05:22:01 Abruzzo, Italy
889638 2021-01-20 Italy Basilicata     12625 302 5374 6949 40.63947052 15.80514834 2021-01-21 05:22:01 Basilicata, Italy
889639 2021-01-20 Italy Calabria     29833 543 19185 10105 38.90597598 16.59440194 2021-01-21 05:22:01 Calabria, Italy
889640 2021-01-20 Italy Campania     209482 3471 135145 70866 40.83956555 14.25084984 2021-01-21 05:22:01 Campania, Italy
889641 2021-01-20 Italy Emilia-Romagna     205261 8935 143747 52579 44.49436681 11.3417208 2021-01-21 05:22:01 Emilia-Romagna, Italy
889642 2021-01-20 Italy Friuli Venezia Giulia     62045 2157 47557 12331 45.6494354 13.76813649 2021-01-21 05:22:01 Friuli Venezia Giulia, Italy
889643 2021-01-20 Italy Lazio     192896 4535 115172 73189 41.89277044 12.48366722 2021-01-21 05:22:01 Lazio, Italy
889644 2021-01-20 Italy Liguria     66546 3169 58619 4758 44.41149315 8.9326992 2021-01-21 05:22:01 Liguria, Italy
889645 2021-01-20 Italy Lombardia     518161 26405 438058 53698 45.46679409 9.190347404 2021-01-21 05:22:01 Lombardia, Italy
889646 2021-01-20 Italy Marche     51044 1825 40604 8615 43.61675973 13.5188753 2021-01-21 05:22:01 Marche, Italy
889647 2021-01-20 Italy Molise     7658 240 6283 1135 41.55774754 14.65916051 2021-01-21 05:22:01 Molise, Italy
889648 2021-01-20 Italy P.A. Bolzano     34561 824 21205 12532 46.49933453 11.35662422 2021-01-21 05:22:01 P.A. Bolzano, Italy
889649 2021-01-20 Italy P.A. Trento     25550 1085 22379 2086 46.06893511 11.12123097 2021-01-21 05:22:01 P.A. Trento, Italy
889650 2021-01-20 Italy Piemonte     214517 8496 192116 13905 45.0732745 7.680687483 2021-01-21 05:22:01 Piemonte, Italy
889651 2021-01-20 Italy Puglia     111840 2917 53822 55101 41.12559576 16.86736689 2021-01-21 05:22:01 Puglia, Italy
889652 2021-01-20 Italy Sardegna     36235 920 18039 17276 39.21531192 9.110616306 2021-01-21 05:22:01 Sardegna, Italy
889653 2021-01-20 Italy Sicilia     125134 3101 75326 46707 38.11569725 13.362356699999998 2021-01-21 05:22:01 Sicilia, Italy
889654 2021-01-20 Italy Toscana     128881 4038 116561 8282 43.76923077 11.25588885 2021-01-21 05:22:01 Toscana, Italy
889655 2021-01-20 Italy Umbria     32899 714 27580 4605 43.10675841 12.38824698 2021-01-21 05:22:01 Umbria, Italy
889656 2021-01-20 Italy Valle d'Aosta     7698 399 6921 378 45.73750286 7.320149366 2021-01-21 05:22:01 Valle d'Aosta, Italy
889657 2021-01-20 Italy Veneto     301486 8256 235761 57469 45.43490485 12.33845213 2021-01-21 05:22:01 Veneto, Italy
318204 2021-01-19 Italy Abruzzo     39535 1342 27147 11046 42.35122196 13.39843823 2021-01-20 05:21:54 Abruzzo, Italy
318205 2021-01-19 Italy Basilicata     12568 302 5325 6941 40.63947052 15.80514834 2021-01-20 05:21:54 Basilicata, Italy
318206 2021-01-19 Italy Calabria     29520 539 18886 10095 38.90597598 16.59440194 2021-01-20 05:21:54 Calabria, Italy
318207 2021-01-19 Italy Campania     208514 3429 133205 71880 40.83956555 14.25084984 2021-01-20 05:21:54 Campania, Italy
318208 2021-01-19 Italy Emilia-Romagna     204174 8872 142061 53241 44.49436681 11.3417208 2021-01-20 05:21:54 Emilia-Romagna, Italy
318209 2021-01-19 Italy Friuli Venezia Giulia     61373 2131 46657 12585 45.6494354 13.76813649 2021-01-20 05:21:54 Friuli Venezia Giulia, Italy
318210 2021-01-19 Italy Lazio     191615 4474 111905 75236 41.89277044 12.48366722 2021-01-20 05:21:54 Lazio, Italy
318211 2021-01-19 Italy Liguria     66261 3145 58305 4811 44.41149315 8.9326992 2021-01-20 05:21:54 Liguria, Italy
318212 2021-01-19 Italy Lombardia     516285 26339 436485 53461 45.46679409 9.190347404 2021-01-20 05:21:54 Lombardia, Italy
318213 2021-01-19 Italy Marche     50627 1810 39277 9540 43.61675973 13.5188753 2021-01-20 05:21:54 Marche, Italy
318214 2021-01-19 Italy Molise     7604 238 6270 1096 41.55774754 14.65916051 2021-01-20 05:21:54 Molise, Italy
318215 2021-01-19 Italy P.A. Bolzano     34120 820 20834 12466 46.49933453 11.35662422 2021-01-20 05:21:54 P.A. Bolzano, Italy
318216 2021-01-19 Italy P.A. Trento     25272 1081 22103 2088 46.06893511 11.12123097 2021-01-20 05:21:54 P.A. Trento, Italy
318217 2021-01-19 Italy Piemonte     213911 8453 191020 14438 45.0732745 7.680687483 2021-01-20 05:21:54 Piemonte, Italy
318218 2021-01-19 Italy Puglia     110681 2892 52598 55191 41.12559576 16.86736689 2021-01-20 05:21:54 Puglia, Italy
318219 2021-01-19 Italy Sardegna     36019 915 17682 17422 39.21531192 9.110616306 2021-01-20 05:21:54 Sardegna, Italy
318220 2021-01-19 Italy Sicilia     123648 3064 73057 47527 38.11569725 13.362356699999998 2021-01-20 05:21:54 Sicilia, Italy
318221 2021-01-19 Italy Toscana     128438 4020 116163 8255 43.76923077 11.25588885 2021-01-20 05:21:54 Toscana, Italy
318222 2021-01-19 Italy Umbria     32622 706 27280 4636 43.10675841 12.38824698 2021-01-20 05:21:54 Umbria, Italy
318223 2021-01-19 Italy Valle d'Aosta     7684 398 6888 398 45.73750286 7.320149366 2021-01-20 05:21:54 Valle d'Aosta, Italy
318224 2021-01-19 Italy Veneto     300127 8187 228769 63171 45.43490485 12.33845213 2021-01-20 05:21:54 Veneto, Italy
570190 2021-01-18 Italy Abruzzo     39422 1333 26707 11382 42.35122196 13.39843823 2021-01-19 05:22:15 Abruzzo, Italy
570191 2021-01-18 Italy Basilicata     12508 294 5311 6903 40.63947052 15.80514834 2021-01-19 05:22:15 Basilicata, Italy
570192 2021-01-18 Italy Calabria     29329 539 18576 10214 38.90597598 16.59440194 2021-01-19 05:22:15 Calabria, Italy
570193 2021-01-18 Italy Campania     207863 3395 131806 72662 40.83956555 14.25084984 2021-01-19 05:22:15 Campania, Italy
570194 2021-01-18 Italy Emilia-Romagna     203141 8797 140114 54230 44.49436681 11.3417208 2021-01-19 05:22:15 Emilia-Romagna, Italy
570195 2021-01-18 Italy Friuli Venezia Giulia     60919 2113 46121 12685 45.6494354 13.76813649 2021-01-19 05:22:15 Friuli Venezia Giulia, Italy
570196 2021-01-18 Italy Lazio     190515 4415 108755 77345 41.89277044 12.48366722 2021-01-19 05:22:15 Lazio, Italy
570197 2021-01-18 Italy Liguria     66026 3128 57849 5049 44.41149315 8.9326992 2021-01-19 05:22:15 Liguria, Italy
570198 2021-01-18 Italy Lombardia     515355 26282 435509 53564 45.46679409 9.190347404 2021-01-19 05:22:15 Lombardia, Italy
570199 2021-01-18 Italy Marche     50268 1794 38223 10251 43.61675973 13.5188753 2021-01-19 05:22:15 Marche, Italy
570200 2021-01-18 Italy Molise     7586 233 6268 1085 41.55774754 14.65916051 2021-01-19 05:22:15 Molise, Italy
570201 2021-01-18 Italy P.A. Bolzano     33684 811 20760 12113 46.49933453 11.35662422 2021-01-19 05:22:15 P.A. Bolzano, Italy
570202 2021-01-18 Italy P.A. Trento     25129 1076 21690 2363 46.06893511 11.12123097 2021-01-19 05:22:15 P.A. Trento, Italy
570203 2021-01-18 Italy Piemonte     213195 8419 189987 14789 45.0732745 7.680687483 2021-01-19 05:22:15 Piemonte, Italy
570204 2021-01-18 Italy Puglia     109831 2876 51443 55512 41.12559576 16.86736689 2021-01-19 05:22:15 Puglia, Italy
570205 2021-01-18 Italy Sardegna     35910 907 17387 17616 39.21531192 9.110616306 2021-01-19 05:22:15 Sardegna, Italy
570206 2021-01-18 Italy Sicilia     122007 3027 72095 46885 38.11569725 13.362356699999998 2021-01-19 05:22:15 Sicilia, Italy
570207 2021-01-18 Italy Toscana     128197 3994 115870 8333 43.76923077 11.25588885 2021-01-19 05:22:15 Toscana, Italy
570208 2021-01-18 Italy Umbria     32397 701 27116 4580 43.10675841 12.38824698 2021-01-19 05:22:15 Umbria, Italy
570209 2021-01-18 Italy Valle d'Aosta     7650 395 6840 415 45.73750286 7.320149366 2021-01-19 05:22:15 Valle d'Aosta, Italy
570210 2021-01-18 Italy Veneto     299170 8025 222062 69083 45.43490485 12.33845213 2021-01-19 05:22:15 Veneto, Italy
534753 2021-01-17 Italy Abruzzo     39315 1325 26438 11552 42.35122196 13.39843823 2021-01-18 05:22:34 Abruzzo, Italy
534754 2021-01-17 Italy Basilicata     12501 293 5290 6918 40.63947052 15.80514834 2021-01-18 05:22:34 Basilicata, Italy
534755 2021-01-17 Italy Calabria     29073 535 18305 10233 38.90597598 16.59440194 2021-01-18 05:22:34 Calabria, Italy
534756 2021-01-17 Italy Campania     207149 3370 130668 73111 40.83956555 14.25084984 2021-01-18 05:22:34 Campania, Italy
534757 2021-01-17 Italy Emilia-Romagna     201988 8746 138411 54831 44.49436681 11.3417208 2021-01-18 05:22:34 Emilia-Romagna, Italy
534758 2021-01-17 Italy Friuli Venezia Giulia     60766 2092 45936 12738 45.6494354 13.76813649 2021-01-18 05:22:34 Friuli Venezia Giulia, Italy
534759 2021-01-17 Italy Lazio     189643 4399 107734 77510 41.89277044 12.48366722 2021-01-18 05:22:34 Lazio, Italy
534760 2021-01-17 Italy Liguria     65763 3116 57681 4966 44.41149315 8.9326992 2021-01-18 05:22:34 Liguria, Italy
534761 2021-01-17 Italy Lombardia     514166 26237 431787 56142 45.46679409 9.190347404 2021-01-18 05:22:34 Lombardia, Italy
534762 2021-01-17 Italy Marche     50111 1783 37786 10542 43.61675973 13.5188753 2021-01-18 05:22:34 Marche, Italy
534763 2021-01-17 Italy Molise     7553 231 6178 1144 41.55774754 14.65916051 2021-01-18 05:22:34 Molise, Italy
534764 2021-01-17 Italy P.A. Bolzano     33519 809 20611 12099 46.49933453 11.35662422 2021-01-18 05:22:34 P.A. Bolzano, Italy
534765 2021-01-17 Italy P.A. Trento     25073 1062 21581 2430 46.06893511 11.12123097 2021-01-18 05:22:34 P.A. Trento, Italy
534766 2021-01-17 Italy Piemonte     212760 8400 189360 15000 45.0732745 7.680687483 2021-01-18 05:22:34 Piemonte, Italy
534767 2021-01-17 Italy Puglia     109428 2850 50458 56120 41.12559576 16.86736689 2021-01-18 05:22:34 Puglia, Italy
534768 2021-01-17 Italy Sardegna     35774 903 17123 17748 39.21531192 9.110616306 2021-01-18 05:22:34 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]);