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

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
1113585 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
383960 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
72813 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
477663 2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
527948 2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
1350205 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
1597263 2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
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  
399879 2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
523904 2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
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  
996361 2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
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  
1442248 2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
1542121 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1597183 2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
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  
1738860 2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
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  
1156638 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
80255 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
629383 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
826545 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
1071580 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
803546 2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
68654 2020-03-01 Italy       1694 34 83   43.0 12.0 2020-03-01T23:23:02  
766229 2020-03-02 Italy       2036 52 149   43.0 12.0 2020-03-02T20:23:16  
1274013 2020-03-03 Italy       2502 79 160   43.0 12.0 2020-03-03T20:03:06  
996150 2020-03-04 Italy       3089 107 276   43.0 12.0 2020-03-04T19:23:03  
72838 2020-03-05 Italy       3858 148 414   43.0 12.0 2020-03-05T17:43:03  
22005 2020-03-06 Italy       4636 197 523   43.0 12.0 2020-03-06T17:33:03  
933927 2020-03-07 Italy       5883 233 589   43.0 12.0 2020-03-07T17:33:03  
1714519 2020-03-08 Italy       7375 366 622   43.0 12.0 2020-03-08T18:03:04  
1191188 2020-03-09 Italy       9172 463 724   43.0 12.0 2020-03-09T18:13:11  
1588718 2020-03-10 Italy       10149 631 724   43.0 12.0 2020-03-10T17:53:02  
864862 2020-03-13 Italy       17660 1266 1439   41.8719 12.5674 2020-03-11T20:00:00  
1183842 2020-03-12 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
1718722 2020-03-11 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
367993 2020-03-15 Italy       24747 1809 2335   41.8719 12.5674 2020-03-14T20:13:16  
826283 2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
1596859 2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
64387 2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
643103 2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
179365 2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
1522671 2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
306702 2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
1423034 2020-03-23 Italy       63927 6077 7432 50418 41.87194 12.56738 2020-03-23 23:19:21 Italy
1261983 2020-03-24 Italy       69176 6820 8326 54030 41.87194 12.56738 2020-03-24 23:37:15 Italy
221863 2020-03-25 Italy       74386 7503 9362 57521 41.87194 12.56738 2020-03-25 23:33:04 Italy
336240 2020-03-26 Italy       80589 8215 10361 62013 41.87194 12.56738 2020-03-26 23:48:18 Italy
1314392 2020-03-27 Italy       86498 9134 10950 66414 41.87194 12.56738 2020-03-27 23:23:03 Italy
836954 2020-03-31 Italy       105792 12428 15729 77635 41.87194 12.56738 2020-03-31 23:43:43 Italy
122411 2020-04-01 Italy       110574 13155 16847 80572 41.87194 12.56738 2020-04-01 21:58:34 Italy
18144 2020-04-03 Italy       119827 14681 19758 85388 41.87194 12.56738 2020-04-03 22:46:20 Italy
451623 2020-04-05 Italy       128948 15887 21815 91246 41.87194 12.56738 2020-04-05 23:06:26 Italy
553289 2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
822348 2020-04-08 Italy       139422 17669 26491 95262 41.87194 12.56738 2020-04-08 22:51:39 Italy
160754 2020-04-09 Italy       143626 18279 28470 96877 41.87194 12.56738 2020-04-09 23:02:19 Italy
661988 2020-04-10 Italy       147577 18849 30455 98273 41.87194 12.56738 2020-04-10 22:53:48 Italy
609417 2020-04-11 Italy       152271 19468 32534 100269 41.87194 12.56738 2020-04-11 22:45:13 Italy
1361053 2020-04-12 Italy       156363 19899 34211 102253 41.87194 12.56738 2020-04-12 23:17:00 Italy
758329 2020-04-13 Italy       159516 20465 35435 103616 41.87194 12.56738 2020-04-13 23:07:34 Italy
454641 2020-04-14 Italy       162488 21067 37130 104291 41.87194 12.56738 2020-04-14 23:33:12 Italy
1101777 2020-04-15 Italy       165155 21645 38092 105418 41.87194 12.56738 2020-04-15 22:56:32 Italy
980551 2020-04-16 Italy       168941 22170 40164 106607 41.87194 12.56738 2020-04-16 23:30:31 Italy
1288108 2020-04-17 Italy       172434 22745 42727 106962 41.87194 12.56738 2020-04-17 23:30:32 Italy
929836 2020-04-18 Italy       175925 23227 44927 107771 41.87194 12.56738 2020-04-18 22:32:28 Italy
1449235 2020-04-19 Italy       178972 23660 47055 108257 41.87194 12.56738 2020-04-19 23:40:41 Italy
434013 2020-04-20 Italy       181228 24114 48877 108237 41.87194 12.56738 2020-04-20 23:36:27 Italy
1094763 2020-04-21 Italy       183957 24648 51600 107709 41.87194 12.56738 2020-04-21 23:30:30 Italy
716321 2020-04-22 Italy       187327 25085 54543 107699 41.87194 12.56738 2020-04-22 23:30:32 Italy
556406 2020-04-23 Italy       189973 25549 57576 106848 41.87194 12.56738 2020-04-24 03:30:31 Italy
598467 2020-04-24 Italy       192994 25969 60498 106527 41.87194 12.56738 2020-04-25 06:30:33 Italy
1187089 2020-04-25 Italy       195351 26384 63120 105847 41.87194 12.56738 2020-04-26 02:30:31 Italy
1560963 2020-04-26 Italy       197675 26644 64928 106103 41.87194 12.56738 2020-04-27 02:30:33 Italy
1426172 2020-04-27 Italy       199414 26977 66624 105813 41.87194 12.56738 2020-04-28 02:30:32 Italy
743367 2020-04-28 Italy       201505 27359 68941 105205 41.87194 12.56738 2020-04-29 02:32:29 Italy
542696 2020-04-29 Italy       203591 27682 71252 104657 41.87194 12.56738 2020-04-30 02:32:27 Italy
61039 2020-04-30 Italy       205463 27967 75945 101551 41.87194 12.56738 2020-05-01 02:32:28 Italy
302613 2020-05-01 Italy       207428 28236 78249 100943 41.87194 12.56738 2020-05-02 02:32:27 Italy
642997 2020-05-02 Italy       209328 28710 79914 100704 41.87194 12.56738 2020-05-03 02:32:28 Italy
457844 2020-05-03 Italy       210717 28884 81654 100179 41.87194 12.56738 2020-05-04 02:32:28 Italy
328856 2020-05-04 Italy       211938 29079 82879 99980 41.87194 12.56738 2020-05-05 02:32:34 Italy
1175766 2020-05-05 Italy       213013 29315 85231 98467 41.87194 12.56738 2020-05-06 02:32:31 Italy
575368 2020-05-06 Italy       214457 29684 93245 91528 41.87194 12.56738 2020-05-07 02:32:28 Italy
791522 2020-05-07 Italy       215858 29958 96276 89624 41.87194 12.56738 2020-05-08 02:32:32 Italy
271482 2020-05-08 Italy       217185 30201 99023 87961 41.87194 12.56738 2020-05-09 02:32:35 Italy
80132 2020-05-09 Italy       218268 30395 103031 84842 41.87194 12.56738 2020-05-10 02:32:30 Italy
64279 2020-05-10 Italy       219070 30560 105186 83324 41.87194 12.56738 2020-05-11 02:32:30 Italy
445200 2020-05-11 Italy       219814 30739 106587 82488 41.87194 12.56738 2020-05-12 03:32:27 Italy
179257 2020-05-12 Italy       221216 30911 109039 81266 41.87194 12.56738 2020-05-13 03:32:26 Italy
519790 2020-05-13 Italy       222104 31106 112541 78457 41.87194 12.56738 2020-05-14 03:32:28 Italy
1666411 2020-05-14 Italy Abruzzo     3136 379 1275 1482 42.35122196 13.39843823 2020-05-15 02:33:02 Abruzzo, Italy
1666422 2020-05-14 Italy Basilicata     389 27 235 127 40.63947052 15.80514834 2020-05-15 02:33:02 Basilicata, Italy
1666433 2020-05-14 Italy Calabria     1143 95 524 524 38.90597598 16.59440194 2020-05-15 02:33:02 Calabria, 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]);