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

View and edit SQL

Suggested facets: latitude, longitude, 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 ▼
22005 2020-03-06 Italy       4636 197 523   43.0 12.0 2020-03-06T17:33:03  
64387 2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
68654 2020-03-01 Italy       1694 34 83   43.0 12.0 2020-03-01T23:23:02  
72813 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
72838 2020-03-05 Italy       3858 148 414   43.0 12.0 2020-03-05T17:43:03  
80255 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
179365 2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
252560 2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
299494 2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
306702 2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
367993 2020-03-15 Italy       24747 1809 2335   41.8719 12.5674 2020-03-14T20:13:16  
383960 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
399879 2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
477663 2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
523904 2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
527948 2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
629383 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
643103 2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
655322 2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
677705 2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
766229 2020-03-02 Italy       2036 52 149   43.0 12.0 2020-03-02T20:23:16  
803546 2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
826283 2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
826545 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
864862 2020-03-13 Italy       17660 1266 1439   41.8719 12.5674 2020-03-11T20:00:00  
933927 2020-03-07 Italy       5883 233 589   43.0 12.0 2020-03-07T17:33:03  
996150 2020-03-04 Italy       3089 107 276   43.0 12.0 2020-03-04T19:23:03  
996361 2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
1071580 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
1079672 2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
1091703 2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
1113585 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
1156638 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
1183842 2020-03-12 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
1191188 2020-03-09 Italy       9172 463 724   43.0 12.0 2020-03-09T18:13:11  
1274013 2020-03-03 Italy       2502 79 160   43.0 12.0 2020-03-03T20:03:06  
1277080 2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
1285131 2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
1350205 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
1442248 2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
1522671 2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
1542121 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1588718 2020-03-10 Italy       10149 631 724   43.0 12.0 2020-03-10T17:53:02  
1596859 2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
1597183 2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
1597263 2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
1659427 2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
1710525 2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
1714519 2020-03-08 Italy       7375 366 622   43.0 12.0 2020-03-08T18:03:04  
1718722 2020-03-11 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
1738860 2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
277 2020-09-15 Italy Abruzzo     4034 473 2970 591 42.35122196 13.39843823 2020-09-16 04:22:53 Abruzzo, Italy
4252 2020-12-05 Italy Abruzzo     29980 969 11764 17247 42.35122196 13.39843823 2020-12-06 05:26:18 Abruzzo, Italy
10988 2020-06-09 Italy Abruzzo     3266 451 2248 567 42.35122196 13.39843823 2020-06-10 04:07:00 Abruzzo, Italy
11920 2021-04-28 Italy Abruzzo     70873 2391 59926 8556 42.35122196 13.39843823 2021-04-29 04:20:55 Abruzzo, Italy
21316 2020-06-17 Italy Abruzzo     3281 457 2386 438 42.35122196 13.39843823 2020-06-18 04:33:18 Abruzzo, Italy
22496 2021-03-12 Italy Abruzzo     59446 1883 44653 12910 42.35122196 13.39843823 2021-03-13 05:25:15 Abruzzo, Italy
29434 2020-08-02 Italy Abruzzo     3389 472 2801 116 42.35122196 13.39843823 2020-08-03 04:34:35 Abruzzo, Italy
30412 2020-10-09 Italy Abruzzo     4886 487 3150 1249 42.35122196 13.39843823 2020-10-10 04:23:57 Abruzzo, Italy
34375 2020-08-21 Italy Abruzzo     3604 472 2843 289 42.35122196 13.39843823 2020-08-22 04:27:49 Abruzzo, Italy
38347 2021-04-29 Italy Abruzzo     71067 2397 60119 8551 42.35122196 13.39843823 2021-04-30 04:21:03 Abruzzo, Italy
42333 2021-02-26 Italy Abruzzo     53545 1689 39125 12731 42.35122196 13.39843823 2021-02-27 05:22:28 Abruzzo, Italy
46317 2020-12-31 Italy Abruzzo     35314 1213 23028 11073 42.35122196 13.39843823 2021-01-01 05:23:07 Abruzzo, Italy
50288 2020-09-24 Italy Abruzzo     4266 477 3019 770 42.35122196 13.39843823 2020-09-25 04:23:00 Abruzzo, Italy
54266 2021-05-22 Italy Abruzzo     73621 2466 65254 5901 42.35122196 13.39843823 2021-05-23 04:20:51 Abruzzo, Italy
64957 2021-05-18 Italy Abruzzo     73295 2460 64421 6414 42.35122196 13.39843823 2021-05-19 04:20:42 Abruzzo, Italy
69071 2021-01-08 Italy Abruzzo     37038 1269 24672 11097 42.35122196 13.39843823 2021-01-09 05:22:18 Abruzzo, Italy
73304 2021-04-04 Italy Abruzzo     66594 2169 53697 10728 42.35122196 13.39843823 2021-04-05 04:20:35 Abruzzo, Italy
80628 2021-06-12 Italy Abruzzo     74450 2502 70432 1516 42.35122196 13.39843823 2021-06-13 04:22:44 Abruzzo, Italy
87443 2020-07-03 Italy Abruzzo     3298 464 2678 156 42.35122196 13.39843823 2020-07-04 04:33:51 Abruzzo, Italy
88420 2021-04-06 Italy Abruzzo     66660 2187 53902 10571 42.35122196 13.39843823 2021-04-07 04:20:53 Abruzzo, Italy
92405 2021-01-09 Italy Abruzzo     37438 1274 24901 11263 42.35122196 13.39843823 2021-01-10 05:22:12 Abruzzo, Italy
96390 2021-04-22 Italy Abruzzo     70045 2355 58270 9420 42.35122196 13.39843823 2021-04-23 04:20:52 Abruzzo, Italy
100426 2021-02-23 Italy Abruzzo     51764 1652 37289 12823 42.35122196 13.39843823 2021-02-24 05:29:16 Abruzzo, Italy
104398 2020-09-25 Italy Abruzzo     4317 477 3023 817 42.35122196 13.39843823 2020-09-26 04:23:00 Abruzzo, Italy
108374 2020-12-28 Italy Abruzzo     34533 1176 21812 11545 42.35122196 13.39843823 2020-12-29 05:22:37 Abruzzo, Italy
112345 2020-10-26 Italy Abruzzo     8414 524 3537 4353 42.35122196 13.39843823 2020-10-27 04:24:45 Abruzzo, Italy
116326 2021-02-21 Italy Abruzzo     51093 1620 36549 12924 42.35122196 13.39843823 2021-02-22 05:24:21 Abruzzo, Italy
122802 2021-04-05 Italy Abruzzo     66613 2173 53724 10716 42.35122196 13.39843823 2021-04-06 04:20:32 Abruzzo, Italy
126774 2020-09-29 Italy Abruzzo     4397 481 3051 865 42.35122196 13.39843823 2020-09-30 04:23:33 Abruzzo, Italy
133707 2020-08-06 Italy Abruzzo     3435 472 2810 153 42.35122196 13.39843823 2020-08-07 04:35:11 Abruzzo, Italy
134700 2021-01-19 Italy Abruzzo     39535 1342 27147 11046 42.35122196 13.39843823 2021-01-20 05:21:54 Abruzzo, Italy
141636 2020-07-30 Italy Abruzzo     3377 472 2799 106 42.35122196 13.39843823 2020-07-31 04:35:18 Abruzzo, Italy
145471 2020-07-11 Italy Abruzzo     3323 464 2712 147 42.35122196 13.39843823 2020-07-12 04:34:30 Abruzzo, Italy
149235 2020-06-21 Italy Abruzzo     3281 459 2419 403 42.35122196 13.39843823 2020-06-22 04:33:20 Abruzzo, Italy
150209 2020-11-19 Italy Abruzzo     21842 721 6259 14862 42.35122196 13.39843823 2020-11-20 05:26:28 Abruzzo, Italy
154247 2020-12-23 Italy Abruzzo     33875 1151 20705 12019 42.35122196 13.39843823 2020-12-24 05:23:04 Abruzzo, Italy
161134 2020-11-02 Italy Abruzzo     11519 556 3872 7091 42.35122196 13.39843823 2020-11-03 06:00:16 Abruzzo, Italy
167812 2020-05-19 Italy Abruzzo     3197 389 1419 1389 42.35122196 13.39843823 2020-05-20 02:32:19 Abruzzo, Italy
168438 2021-06-19 Italy Abruzzo     74601 2509 70837 1255 42.35122196 13.39843823 2021-06-20 04:21:48 Abruzzo, Italy
172424 2021-03-09 Italy Abruzzo     57954 1825 42804 13325 42.35122196 13.39843823 2021-03-10 05:24:35 Abruzzo, Italy
179949 2020-12-04 Italy Abruzzo     29604 955 10857 17792 42.35122196 13.39843823 2020-12-05 05:27:36 Abruzzo, Italy
186682 2020-06-07 Italy Abruzzo     3265 418 2194 653 42.35122196 13.39843823 2020-06-08 03:33:22 Abruzzo, Italy
187614 2021-02-20 Italy Abruzzo     50590 1610 36497 12483 42.35122196 13.39843823 2021-02-21 05:24:33 Abruzzo, Italy
194552 2020-08-03 Italy Abruzzo     3398 472 2802 124 42.35122196 13.39843823 2020-08-04 04:41:59 Abruzzo, Italy
195529 2020-08-28 Italy Abruzzo     3725 472 2870 383 42.35122196 13.39843823 2020-08-29 04:28:19 Abruzzo, Italy
199487 2020-08-24 Italy Abruzzo     3652 472 2844 336 42.35122196 13.39843823 2020-08-25 04:28:02 Abruzzo, Italy
206884 2021-02-22 Italy Abruzzo     51442 1628 36841 12973 42.35122196 13.39843823 2021-02-23 05:23:41 Abruzzo, Italy
210856 2020-11-08 Italy Abruzzo     14519 596 4592 9331 42.35122196 13.39843823 2020-11-09 05:25:45 Abruzzo, Italy
214838 2021-01-13 Italy Abruzzo     38339 1300 25823 11216 42.35122196 13.39843823 2021-01-14 05:22:32 Abruzzo, 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]);