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

9,260 rows where country_or_region = "Italy" sorted by admin2

View and edit SQL

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

province_or_state

country_or_region

  • Italy · 9,260
Link rowid day country_or_region province_or_state admin2 ▼ fips confirmed deaths recovered active latitude longitude last_update combined_key
292 2021-04-20 Italy Abruzzo     69650 2345 57800 9505 42.35122196 13.39843823 2021-04-21 04:21:14 Abruzzo, Italy
293 2021-04-20 Italy Basilicata     22400 502 16112 5786 40.63947052 15.80514834 2021-04-21 04:21:14 Basilicata, Italy
294 2021-04-20 Italy Calabria     55595 955 40606 14034 38.90597598 16.59440194 2021-04-21 04:21:14 Calabria, Italy
295 2021-04-20 Italy Campania     373499 6039 275673 91787 40.83956555 14.25084984 2021-04-21 04:21:14 Campania, Italy
296 2021-04-20 Italy Emilia-Romagna     359941 12667 286311 60963 44.49436681 11.3417208 2021-04-21 04:21:14 Emilia-Romagna, Italy
297 2021-04-20 Italy Friuli Venezia Giulia     103452 3618 90876 8958 45.6494354 13.76813649 2021-04-21 04:21:14 Friuli Venezia Giulia, Italy
298 2021-04-20 Italy Lazio     312354 7362 255816 49176 41.89277044 12.48366722 2021-04-21 04:21:14 Lazio, Italy
299 2021-04-20 Italy Liguria     96683 4090 86110 6483 44.41149315 8.9326992 2021-04-21 04:21:14 Liguria, Italy
300 2021-04-20 Italy Lombardia     784229 32386 693524 58319 45.46679409 9.190347404 2021-04-21 04:21:14 Lombardia, Italy
301 2021-04-20 Italy Marche     94848 2868 84719 7261 43.61675973 13.5188753 2021-04-21 04:21:14 Marche, Italy
302 2021-04-20 Italy Molise     12888 466 11837 585 41.55774754 14.65916051 2021-04-21 04:21:14 Molise, Italy
303 2021-04-20 Italy P.A. Bolzano     70455 1157 68885 413 46.49933453 11.35662422 2021-04-21 04:21:14 P.A. Bolzano, Italy
304 2021-04-20 Italy P.A. Trento     43148 1328 40567 1253 46.06893511 11.12123097 2021-04-21 04:21:14 P.A. Trento, Italy
305 2021-04-20 Italy Piemonte     335463 10991 303708 20764 45.0732745 7.680687483 2021-04-21 04:21:14 Piemonte, Italy
306 2021-04-20 Italy Puglia     221995 5508 166688 49799 41.12559576 16.86736689 2021-04-21 04:21:14 Puglia, Italy
307 2021-04-20 Italy Sardegna     52013 1321 32713 17979 39.21531192 9.110616306 2021-04-21 04:21:14 Sardegna, Italy
308 2021-04-20 Italy Sicilia     197790 5208 167683 24899 38.11569725 13.362356699999998 2021-04-21 04:21:14 Sicilia, Italy
309 2021-04-20 Italy Toscana     217993 5911 187011 25071 43.76923077 11.25588885 2021-04-21 04:21:14 Toscana, Italy
310 2021-04-20 Italy Umbria     53322 1331 48687 3304 43.10675841 12.38824698 2021-04-21 04:21:14 Umbria, Italy
311 2021-04-20 Italy Valle d'Aosta     10468 441 9106 921 45.73750286 7.320149366 2021-04-21 04:21:14 Valle d'Aosta, Italy
312 2021-04-20 Italy Veneto     402877 11139 366283 25455 45.43490485 12.33845213 2021-04-21 04:21:14 Veneto, Italy
6931 2020-04-16 Italy       168941 22170 40164 106607 41.87194 12.56738 2020-04-16 23:30:31 Italy
7313 2020-10-08 Italy Abruzzo     4783 486 3145 1152 42.35122196 13.39843823 2020-10-09 04:23:59 Abruzzo, Italy
7314 2020-10-08 Italy Basilicata     975 35 511 429 40.63947052 15.80514834 2020-10-09 04:23:59 Basilicata, Italy
7315 2020-10-08 Italy Calabria     2146 102 1441 603 38.90597598 16.59440194 2020-10-09 04:23:59 Calabria, Italy
7316 2020-10-08 Italy Campania     16464 470 7044 8950 40.83956555 14.25084984 2020-10-09 04:23:59 Campania, Italy
7317 2020-10-08 Italy Emilia-Romagna     36638 4492 26722 5424 44.49436681 11.3417208 2020-10-09 04:23:59 Emilia-Romagna, Italy
7318 2020-10-08 Italy Friuli Venezia Giulia     5144 355 3769 1020 45.6494354 13.76813649 2020-10-09 04:23:59 Friuli Venezia Giulia, Italy
7319 2020-10-08 Italy Lazio     18748 960 8936 8852 41.89277044 12.48366722 2020-10-09 04:23:59 Lazio, Italy
7320 2020-10-08 Italy Liguria     14474 1614 10705 2155 44.41149315 8.9326992 2020-10-09 04:23:59 Liguria, Italy
7321 2020-10-08 Italy Lombardia     109869 16979 82484 10406 45.46679409 9.190347404 2020-10-09 04:23:59 Lombardia, Italy
7322 2020-10-08 Italy Marche     8350 992 6251 1107 43.61675973 13.5188753 2020-10-09 04:23:59 Marche, Italy
7323 2020-10-08 Italy Molise     690 25 523 142 41.55774754 14.65916051 2020-10-09 04:23:59 Molise, Italy
7324 2020-10-08 Italy P.A. Bolzano     3803 292 2785 726 46.49933453 11.35662422 2020-10-09 04:23:59 P.A. Bolzano, Italy
7325 2020-10-08 Italy P.A. Trento     6355 406 5259 690 46.06893511 11.12123097 2020-10-09 04:23:59 P.A. Trento, Italy
7326 2020-10-08 Italy Piemonte     37194 4172 29043 3979 45.0732745 7.680687483 2020-10-09 04:23:59 Piemonte, Italy
7327 2020-10-08 Italy Puglia     8867 604 4929 3334 41.12559576 16.86736689 2020-10-09 04:23:59 Puglia, Italy
7328 2020-10-08 Italy Sardegna     4608 161 1977 2470 39.21531192 9.110616306 2020-10-09 04:23:59 Sardegna, Italy
7329 2020-10-08 Italy Sicilia     8479 329 4454 3696 38.11569725 13.362356699999998 2020-10-09 04:23:59 Sicilia, Italy
7330 2020-10-08 Italy Toscana     16612 1170 10693 4749 43.76923077 11.25588885 2020-10-09 04:23:59 Toscana, Italy
7331 2020-10-08 Italy Umbria     2906 87 1956 863 43.10675841 12.38824698 2020-10-09 04:23:59 Umbria, Italy
7332 2020-10-08 Italy Valle d'Aosta     1384 146 1116 122 45.73750286 7.320149366 2020-10-09 04:23:59 Valle d'Aosta, Italy
7333 2020-10-08 Italy Veneto     29909 2206 22620 5083 45.43490485 12.33845213 2020-10-09 04:23:59 Veneto, Italy
11278 2020-10-23 Italy Abruzzo     7325 503 3293 3529 42.35122196 13.39843823 2020-10-24 04:24:46 Abruzzo, Italy
11279 2020-10-23 Italy Basilicata     1570 42 621 907 40.63947052 15.80514834 2020-10-24 04:24:46 Basilicata, Italy
11280 2020-10-23 Italy Calabria     3445 105 1645 1695 38.90597598 16.59440194 2020-10-24 04:24:46 Calabria, Italy
11281 2020-10-23 Italy Campania     34305 563 9107 24635 40.83956555 14.25084984 2020-10-24 04:24:46 Campania, Italy
11282 2020-10-23 Italy Emilia-Romagna     44365 4547 27304 12514 44.49436681 11.3417208 2020-10-24 04:24:46 Emilia-Romagna, Italy
11283 2020-10-23 Italy Friuli Venezia Giulia     7415 369 4569 2477 45.6494354 13.76813649 2020-10-24 04:24:46 Friuli Venezia Giulia, Italy
11284 2020-10-23 Italy Lazio     31010 1081 10108 19821 41.89277044 12.48366722 2020-10-24 04:24:46 Lazio, Italy
11285 2020-10-23 Italy Liguria     21359 1680 14210 5469 44.41149315 8.9326992 2020-10-24 04:24:46 Liguria, Italy
11286 2020-10-23 Italy Lombardia     143645 17159 88536 37950 45.46679409 9.190347404 2020-10-24 04:24:46 Lombardia, Italy
11287 2020-10-23 Italy Marche     10645 1000 6596 3049 43.61675973 13.5188753 2020-10-24 04:24:46 Marche, Italy
11288 2020-10-23 Italy Molise     1126 26 606 494 41.55774754 14.65916051 2020-10-24 04:24:46 Molise, Italy
11289 2020-10-23 Italy P.A. Bolzano     5818 296 2940 2582 46.49933453 11.35662422 2020-10-24 04:24:46 P.A. Bolzano, Italy
11290 2020-10-23 Italy P.A. Trento     7526 423 5974 1129 46.06893511 11.12123097 2020-10-24 04:24:46 P.A. Trento, Italy
11291 2020-10-23 Italy Piemonte     51700 4236 31002 16462 45.0732745 7.680687483 2020-10-24 04:24:46 Piemonte, Italy
11292 2020-10-23 Italy Puglia     13400 646 5926 6828 41.12559576 16.86736689 2020-10-24 04:24:46 Puglia, Italy
11293 2020-10-23 Italy Sardegna     7235 181 2768 4286 39.21531192 9.110616306 2020-10-24 04:24:46 Sardegna, Italy
11294 2020-10-23 Italy Sicilia     15316 408 5772 9136 38.11569725 13.362356699999998 2020-10-24 04:24:46 Sicilia, Italy
11295 2020-10-23 Italy Toscana     27901 1237 12290 14374 43.76923077 11.25588885 2020-10-24 04:24:46 Toscana, Italy
11296 2020-10-23 Italy Umbria     6307 100 2577 3630 43.10675841 12.38824698 2020-10-24 04:24:46 Umbria, Italy
11297 2020-10-23 Italy Valle d'Aosta     2316 149 1166 1001 45.73750286 7.320149366 2020-10-24 04:24:46 Valle d'Aosta, Italy
11298 2020-10-23 Italy Veneto     41140 2308 24798 14034 45.43490485 12.33845213 2020-10-24 04:24:46 Veneto, Italy
15260 2021-04-07 Italy Abruzzo     66878 2200 54281 10397 42.35122196 13.39843823 2021-04-08 04:21:13 Abruzzo, Italy
15261 2021-04-07 Italy Basilicata     20197 470 14808 4919 40.63947052 15.80514834 2021-04-08 04:21:13 Basilicata, Italy
15262 2021-04-07 Italy Calabria     49596 872 37281 11443 38.90597598 16.59440194 2021-04-08 04:21:13 Calabria, Italy
15263 2021-04-07 Italy Campania     348959 5653 252199 91107 40.83956555 14.25084984 2021-04-08 04:21:13 Campania, Italy
15264 2021-04-07 Italy Emilia-Romagna     345753 12246 264532 68975 44.49436681 11.3417208 2021-04-08 04:21:13 Emilia-Romagna, Italy
15265 2021-04-07 Italy Friuli Venezia Giulia     100016 3424 83630 12962 45.6494354 13.76813649 2021-04-08 04:21:13 Friuli Venezia Giulia, Italy
15266 2021-04-07 Italy Lazio     295977 6895 236271 52811 41.89277044 12.48366722 2021-04-08 04:21:13 Lazio, Italy
15267 2021-04-07 Italy Liguria     92379 3922 80485 7972 44.41149315 8.9326992 2021-04-08 04:21:13 Liguria, Italy
15268 2021-04-07 Italy Lombardia     755811 31373 642145 82293 45.46679409 9.190347404 2021-04-08 04:21:13 Lombardia, Italy
15269 2021-04-07 Italy Marche     90720 2717 79677 8326 43.61675973 13.5188753 2021-04-08 04:21:13 Marche, Italy
15270 2021-04-07 Italy Molise     12456 450 11333 673 41.55774754 14.65916051 2021-04-08 04:21:13 Molise, Italy
15271 2021-04-07 Italy P.A. Bolzano     69645 1148 67923 574 46.49933453 11.35662422 2021-04-08 04:21:13 P.A. Bolzano, Italy
15272 2021-04-07 Italy P.A. Trento     41950 1306 38367 2277 46.06893511 11.12123097 2021-04-08 04:21:13 P.A. Trento, Italy
15273 2021-04-07 Italy Piemonte     320478 10560 278396 31522 45.0732745 7.680687483 2021-04-08 04:21:13 Piemonte, Italy
15274 2021-04-07 Italy Puglia     203602 5044 147829 50729 41.12559576 16.86736689 2021-04-08 04:21:13 Puglia, Italy
15275 2021-04-07 Italy Sardegna     47630 1250 30390 15990 39.21531192 9.110616306 2021-04-08 04:21:13 Sardegna, Italy
15276 2021-04-07 Italy Sicilia     181346 4746 151254 25346 38.11569725 13.362356699999998 2021-04-08 04:21:13 Sicilia, Italy
15277 2021-04-07 Italy Toscana     204347 5551 170444 28352 43.76923077 11.25588885 2021-04-08 04:21:13 Toscana, Italy
15278 2021-04-07 Italy Umbria     51784 1279 46046 4459 43.10675841 12.38824698 2021-04-08 04:21:13 Umbria, Italy
15279 2021-04-07 Italy Valle d'Aosta     9816 431 8212 1173 45.73750286 7.320149366 2021-04-08 04:21:13 Valle d'Aosta, Italy
15280 2021-04-07 Italy Veneto     391053 10837 344679 35537 45.43490485 12.33845213 2021-04-08 04:21:13 Veneto, Italy
19233 2020-09-24 Italy Abruzzo     4266 477 3019 770 42.35122196 13.39843823 2020-09-25 04:23:00 Abruzzo, Italy
19234 2020-09-24 Italy Basilicata     678 28 454 196 40.63947052 15.80514834 2020-09-25 04:23:00 Basilicata, Italy
19235 2020-09-24 Italy Calabria     1896 98 1298 500 38.90597598 16.59440194 2020-09-25 04:23:00 Calabria, Italy
19236 2020-09-24 Italy Campania     11102 457 5488 5157 40.83956555 14.25084984 2020-09-25 04:23:00 Campania, Italy
19237 2020-09-24 Italy Emilia-Romagna     34711 4480 25604 4627 44.49436681 11.3417208 2020-09-25 04:23:00 Emilia-Romagna, Italy
19238 2020-09-24 Italy Friuli Venezia Giulia     4489 350 3432 707 45.6494354 13.76813649 2020-09-25 04:23:00 Friuli Venezia Giulia, Italy
19239 2020-09-24 Italy Lazio     15205 902 7956 6347 41.89277044 12.48366722 2020-09-25 04:23:00 Lazio, Italy
19240 2020-09-24 Italy Liguria     12871 1596 9621 1654 44.41149315 8.9326992 2020-09-25 04:23:00 Liguria, Italy
19241 2020-09-24 Italy Lombardia     105455 16935 79472 9048 45.46679409 9.190347404 2020-09-25 04:23:00 Lombardia, Italy
19242 2020-09-24 Italy Marche     7818 989 6129 700 43.61675973 13.5188753 2020-09-25 04:23:00 Marche, Italy
19243 2020-09-24 Italy Molise     627 23 471 133 41.55774754 14.65916051 2020-09-25 04:23:00 Molise, Italy
19244 2020-09-24 Italy P.A. Bolzano     3386 292 2609 485 46.49933453 11.35662422 2020-09-25 04:23:00 P.A. Bolzano, Italy
19245 2020-09-24 Italy P.A. Trento     5806 405 4852 549 46.06893511 11.12123097 2020-09-25 04:23:00 P.A. Trento, Italy
19246 2020-09-24 Italy Piemonte     34679 4158 28059 2462 45.0732745 7.680687483 2020-09-25 04:23:00 Piemonte, Italy
19247 2020-09-24 Italy Puglia     7304 586 4455 2263 41.12559576 16.86736689 2020-09-25 04:23:00 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]);