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

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (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
292 2021-02-27 Italy Abruzzo     53900 1698 39479 12723 42.35122196 13.39843823 2021-02-28 05:22:20 Abruzzo, Italy
293 2021-02-27 Italy Basilicata     15534 371 11212 3951 40.63947052 15.80514834 2021-02-28 05:22:20 Basilicata, Italy
294 2021-02-27 Italy Calabria     37720 680 30736 6304 38.90597598 16.59440194 2021-02-28 05:22:20 Calabria, Italy
295 2021-02-27 Italy Campania     265058 4273 185794 74991 40.83956555 14.25084984 2021-02-28 05:22:20 Campania, Italy
296 2021-02-27 Italy Emilia-Romagna     258007 10521 206815 40671 44.49436681 11.3417208 2021-02-28 05:22:20 Emilia-Romagna, Italy
297 2021-02-27 Italy Friuli Venezia Giulia     76471 2834 63652 9985 45.6494354 13.76813649 2021-02-28 05:22:20 Friuli Venezia Giulia, Italy
298 2021-02-27 Italy Lazio     232887 5871 191352 35664 41.89277044 12.48366722 2021-02-28 05:22:20 Lazio, Italy
299 2021-02-27 Italy Liguria     77730 3628 68901 5201 44.41149315 8.9326992 2021-02-28 05:22:20 Liguria, Italy
300 2021-02-27 Italy Lombardia     599552 28324 507514 63714 45.46679409 9.190347404 2021-02-28 05:22:20 Lombardia, Italy
301 2021-02-27 Italy Marche     67269 2240 54970 10059 43.61675973 13.5188753 2021-02-28 05:22:20 Marche, Italy
302 2021-02-27 Italy Molise     10547 349 8460 1738 41.55774754 14.65916051 2021-02-28 05:22:20 Molise, Italy
303 2021-02-27 Italy P.A. Bolzano     53578 1026 45768 6784 46.49933453 11.35662422 2021-02-28 05:22:20 P.A. Bolzano, Italy
304 2021-02-27 Italy P.A. Trento     33729 1206 28868 3655 46.06893511 11.12123097 2021-02-28 05:22:20 P.A. Trento, Italy
305 2021-02-27 Italy Piemonte     246232 9365 221224 15643 45.0732745 7.680687483 2021-02-28 05:22:20 Piemonte, Italy
306 2021-02-27 Italy Puglia     145997 3907 109633 32457 41.12559576 16.86736689 2021-02-28 05:22:20 Puglia, Italy
307 2021-02-27 Italy Sardegna     41114 1153 27126 12835 39.21531192 9.110616306 2021-02-28 05:22:20 Sardegna, Italy
308 2021-02-27 Italy Sicilia     152105 4117 122217 25771 38.11569725 13.362356699999998 2021-02-28 05:22:20 Sicilia, Italy
309 2021-02-27 Italy Toscana     155167 4655 133083 17429 43.76923077 11.25588885 2021-02-28 05:22:20 Toscana, Italy
310 2021-02-27 Italy Umbria     44471 1037 35219 8215 43.10675841 12.38824698 2021-02-28 05:22:20 Umbria, Italy
311 2021-02-27 Italy Valle d'Aosta     8021 415 7462 144 45.73750286 7.320149366 2021-02-28 05:22:20 Valle d'Aosta, Italy
312 2021-02-27 Italy Veneto     332736 9837 298867 24032 45.43490485 12.33845213 2021-02-28 05:22:20 Veneto, Italy
7021 2020-06-04 Italy Abruzzo     3255 415 2136 704 42.35122196 13.39843823 2020-06-05 02:33:06 Abruzzo, Italy
7064 2020-06-04 Italy Basilicata     399 27 352 20 40.63947052 15.80514834 2020-06-05 02:33:06 Basilicata, Italy
7082 2020-06-04 Italy Calabria     1158 97 959 102 38.90597598 16.59440194 2020-06-05 02:33:06 Calabria, Italy
7085 2020-06-04 Italy Campania     4822 420 3572 830 40.83956555 14.25084984 2020-06-05 02:33:06 Campania, Italy
7130 2020-06-04 Italy Emilia-Romagna     27860 4154 21018 2688 44.49436681 11.341720800000001 2020-06-05 02:33:06 Emilia-Romagna, Italy
7137 2020-06-04 Italy Friuli Venezia Giulia     3279 336 2730 213 45.6494354 13.76813649 2020-06-05 02:33:06 Friuli Venezia Giulia, Italy
7224 2020-06-04 Italy Lazio     7764 750 4260 2754 41.89277044 12.48366722 2020-06-05 02:33:06 Lazio, Italy
7227 2020-06-04 Italy Liguria     9772 1479 7899 394 44.41149315 8.9326992 2020-06-05 02:33:06 Liguria, Italy
7230 2020-06-04 Italy Lombardia     89526 16201 53101 20224 45.46679409 9.190347404 2020-06-05 02:33:06 Lombardia, Italy
7244 2020-06-04 Italy Marche     6738 988 4447 1303 43.61675973 13.5188753 2020-06-05 02:33:06 Marche, Italy
7261 2020-06-04 Italy Molise     436 23 288 125 41.55774754 14.65916051 2020-06-05 02:33:06 Molise, Italy
7309 2020-06-04 Italy P.A. Bolzano     2598 292 2194 112 46.49933453 11.35662422 2020-06-05 02:33:06 P.A. Bolzano, Italy
7310 2020-06-04 Italy P.A. Trento     4433 464 3762 207 46.06893511 11.12123097 2020-06-05 02:33:06 P.A. Trento, Italy
7320 2020-06-04 Italy Piemonte     30758 3910 22292 4556 45.0732745 7.680687483 2020-06-05 02:33:06 Piemonte, Italy
7329 2020-06-04 Italy Puglia     4503 514 3022 967 41.12559576 16.86736689 2020-06-05 02:33:06 Puglia, Italy
7369 2020-06-04 Italy Sardegna     1357 131 1118 108 39.21531192 9.110616306 2020-06-05 02:33:06 Sardegna, Italy
7382 2020-06-04 Italy Sicilia     3447 276 2292 879 38.11569725 13.362356699999998 2020-06-05 02:33:06 Sicilia, Italy
7411 2020-06-04 Italy Toscana     10122 1059 8180 883 43.76923077 11.25588885 2020-06-05 02:33:06 Toscana, Italy
7423 2020-06-04 Italy Umbria     1431 76 1324 31 43.10675841 12.38824698 2020-06-05 02:33:06 Umbria, Italy
7431 2020-06-04 Italy Valle d'Aosta     1187 143 1034 10 45.73750286 7.320149366 2020-06-05 02:33:06 Valle d'Aosta, Italy
7435 2020-06-04 Italy Veneto     19168 1934 15915 1319 45.43490485 12.33845213 2020-06-05 02:33:06 Veneto, Italy
7919 2020-08-11 Italy Abruzzo     3512 472 2821 219 42.35122196 13.39843823 2020-08-12 04:27:29 Abruzzo, Italy
7920 2020-08-11 Italy Basilicata     477 28 376 73 40.63947052 15.80514834 2020-08-12 04:27:29 Basilicata, Italy
7921 2020-08-11 Italy Calabria     1300 97 1091 112 38.90597598 16.59440194 2020-08-12 04:27:29 Calabria, Italy
7922 2020-08-11 Italy Campania     5114 440 4272 402 40.83956555 14.25084984 2020-08-12 04:27:29 Campania, Italy
7923 2020-08-11 Italy Emilia-Romagna     30179 4298 24091 1790 44.49436681 11.3417208 2020-08-12 04:27:29 Emilia-Romagna, Italy
7924 2020-08-11 Italy Friuli Venezia Giulia     3452 348 2948 156 45.6494354 13.76813649 2020-08-12 04:27:29 Friuli Venezia Giulia, Italy
7925 2020-08-11 Italy Lazio     8883 867 6915 1101 41.89277044 12.48366722 2020-08-12 04:27:29 Lazio, Italy
7926 2020-08-11 Italy Liguria     10304 1569 8512 223 44.41149315 8.9326992 2020-08-12 04:27:29 Liguria, Italy
7927 2020-08-11 Italy Lombardia     96952 16833 74605 5514 45.46679409 9.190347404 2020-08-12 04:27:29 Lombardia, Italy
7928 2020-08-11 Italy Marche     6960 987 5811 162 43.61675973 13.5188753 2020-08-12 04:27:29 Marche, Italy
7929 2020-08-11 Italy Molise     479 23 423 33 41.55774754 14.65916051 2020-08-12 04:27:29 Molise, Italy
7930 2020-08-11 Italy P.A. Bolzano     2775 292 2355 128 46.49933453 11.35662422 2020-08-12 04:27:29 P.A. Bolzano, Italy
7931 2020-08-11 Italy P.A. Trento     4998 405 4518 75 46.06893511 11.12123097 2020-08-12 04:27:29 P.A. Trento, Italy
7932 2020-08-11 Italy Piemonte     31914 4136 26956 822 45.0732745 7.680687483 2020-08-12 04:27:29 Piemonte, Italy
7933 2020-08-11 Italy Puglia     4760 554 3977 229 41.12559576 16.86736689 2020-08-12 04:27:29 Puglia, Italy
7934 2020-08-11 Italy Sardegna     1461 134 1245 82 39.21531192 9.110616306 2020-08-12 04:27:29 Sardegna, Italy
7935 2020-08-11 Italy Sicilia     3574 284 2752 538 38.11569725 13.362356699999998 2020-08-12 04:27:29 Sicilia, Italy
7936 2020-08-11 Italy Toscana     10674 1137 9002 535 43.76923077 11.25588885 2020-08-12 04:27:29 Toscana, Italy
7937 2020-08-11 Italy Umbria     1511 80 1379 52 43.10675841 12.38824698 2020-08-12 04:27:29 Umbria, Italy
7938 2020-08-11 Italy Valle d'Aosta     1217 146 1056 15 45.73750286 7.320149366 2020-08-12 04:27:29 Valle d'Aosta, Italy
7939 2020-08-11 Italy Veneto     20741 2085 17356 1300 45.43490485 12.33845213 2020-08-12 04:27:29 Veneto, Italy
11872 2020-09-27 Italy Abruzzo     4380 478 3040 862 42.35122196 13.39843823 2020-09-28 04:23:00 Abruzzo, Italy
11873 2020-09-27 Italy Basilicata     763 29 468 266 40.63947052 15.80514834 2020-09-28 04:23:00 Basilicata, Italy
11874 2020-09-27 Italy Calabria     1952 100 1308 544 38.90597598 16.59440194 2020-09-28 04:23:00 Calabria, Italy
11875 2020-09-27 Italy Campania     11874 460 5824 5590 40.83956555 14.25084984 2020-09-28 04:23:00 Campania, Italy
11876 2020-09-27 Italy Emilia-Romagna     35028 4482 25864 4682 44.49436681 11.3417208 2020-09-28 04:23:00 Emilia-Romagna, Italy
11877 2020-09-27 Italy Friuli Venezia Giulia     4608 351 3537 720 45.6494354 13.76813649 2020-09-28 04:23:00 Friuli Venezia Giulia, Italy
11878 2020-09-27 Italy Lazio     15835 907 8119 6809 41.89277044 12.48366722 2020-09-28 04:23:00 Lazio, Italy
11879 2020-09-27 Italy Liguria     13086 1599 9749 1738 44.41149315 8.9326992 2020-09-28 04:23:00 Liguria, Italy
11880 2020-09-27 Italy Lombardia     106204 16946 80021 9237 45.46679409 9.190347404 2020-09-28 04:23:00 Lombardia, Italy
11881 2020-09-27 Italy Marche     7901 990 6151 760 43.61675973 13.5188753 2020-09-28 04:23:00 Marche, Italy
11882 2020-09-27 Italy Molise     644 24 479 141 41.55774754 14.65916051 2020-09-28 04:23:00 Molise, Italy
11883 2020-09-27 Italy P.A. Bolzano     3489 292 2650 547 46.49933453 11.35662422 2020-09-28 04:23:00 P.A. Bolzano, Italy
11884 2020-09-27 Italy P.A. Trento     5922 405 4919 598 46.06893511 11.12123097 2020-09-28 04:23:00 P.A. Trento, Italy
11885 2020-09-27 Italy Piemonte     35038 4161 28244 2633 45.0732745 7.680687483 2020-09-28 04:23:00 Piemonte, Italy
11886 2020-09-27 Italy Puglia     7521 590 4527 2404 41.12559576 16.86736689 2020-09-28 04:23:00 Puglia, Italy
11887 2020-09-27 Italy Sardegna     3730 149 1617 1964 39.21531192 9.110616306 2020-09-28 04:23:00 Sardegna, Italy
11888 2020-09-27 Italy Sicilia     6683 308 3716 2659 38.11569725 13.3623567 2020-09-28 04:23:00 Sicilia, Italy
11889 2020-09-27 Italy Toscana     14566 1157 10002 3407 43.76923077 11.25588885 2020-09-28 04:23:00 Toscana, Italy
11890 2020-09-27 Italy Umbria     2374 85 1788 501 43.10675841 12.38824698 2020-09-28 04:23:00 Umbria, Italy
11891 2020-09-27 Italy Valle d'Aosta     1299 146 1087 66 45.73750286 7.320149366 2020-09-28 04:23:00 Valle d'Aosta, Italy
11892 2020-09-27 Italy Veneto     26973 2176 21307 3490 45.43490485 12.33845213 2020-09-28 04:23:00 Veneto, Italy
18698 2020-05-12 Italy       221216 30911 109039 81266 41.87194 12.56738 2020-05-13 03:32:26 Italy
19097 2021-05-31 Italy Abruzzo     74040 2482 66065 5493 42.35122196 13.39843823 2021-06-01 04:23:09 Abruzzo, Italy
19098 2021-05-31 Italy Basilicata     26316 579 21968 3769 40.63947052 15.80514834 2021-06-01 04:23:09 Basilicata, Italy
19099 2021-05-31 Italy Calabria     66932 1167 56027 9738 38.90597598 16.59440194 2021-06-01 04:23:09 Calabria, Italy
19100 2021-05-31 Italy Campania     419269 7206 345384 66679 40.83956555 14.25084984 2021-06-01 04:23:09 Campania, Italy
19101 2021-05-31 Italy Emilia-Romagna     383879 13186 355420 15273 44.49436681 11.3417208 2021-06-01 04:23:09 Emilia-Romagna, Italy
19102 2021-05-31 Italy Friuli Venezia Giulia     107006 3787 98307 4912 45.6494354 13.76813649 2021-06-01 04:23:09 Friuli Venezia Giulia, Italy
19103 2021-05-31 Italy Lazio     342023 8175 315078 18770 41.89277044 12.48366722 2021-06-01 04:23:09 Lazio, Italy
19104 2021-05-31 Italy Liguria     102761 4323 97285 1153 44.41149315 8.9326992 2021-06-01 04:23:09 Liguria, Italy
19105 2021-05-31 Italy Lombardia     835117 33611 770009 31497 45.46679409 9.190347404 2021-06-01 04:23:09 Lombardia, Italy
19106 2021-05-31 Italy Marche     102682 3015 95833 3834 43.61675973 13.5188753 2021-06-01 04:23:09 Marche, Italy
19107 2021-05-31 Italy Molise     13586 491 12964 131 41.55774754 14.65916051 2021-06-01 04:23:09 Molise, Italy
19108 2021-05-31 Italy P.A. Bolzano     72897 1175 71045 677 46.49933453 11.35662422 2021-06-01 04:23:09 P.A. Bolzano, Italy
19109 2021-05-31 Italy P.A. Trento     45427 1355 43599 473 46.06893511 11.12123097 2021-06-01 04:23:09 P.A. Trento, Italy
19110 2021-05-31 Italy Piemonte     360274 11631 343478 5165 45.0732745 7.680687483 2021-06-01 04:23:09 Piemonte, Italy
19111 2021-05-31 Italy Puglia     250419 6502 218993 24924 41.12559576 16.86736689 2021-06-01 04:23:09 Puglia, 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]);