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

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
120830 2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
132845 2020-03-04 Italy       3089 107 276   43.0 12.0 2020-03-04T19:23:03  
137047 2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
153293 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
199271 2020-03-07 Italy       5883 233 589   43.0 12.0 2020-03-07T17:33:03  
226600 2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
242402 2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
353988 2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
379575 2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
386769 2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
391045 2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
425829 2020-03-09 Italy       9172 463 724   43.0 12.0 2020-03-09T18:13:11  
491486 2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
598605 2020-03-02 Italy       2036 52 149   43.0 12.0 2020-03-02T20:23:16  
642529 2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
673549 2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
677611 2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
685356 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
708809 2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
754559 2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
754640 2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
778112 2020-03-13 Italy       17660 1266 1439   41.8719 12.5674 2020-03-11T20:00:00  
874521 2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
885794 2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
965208 2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
965376 2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
984330 2020-03-12 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
1012396 2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
1023602 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
1082771 2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
1086486 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
1107954 2020-03-05 Italy       3858 148 414   43.0 12.0 2020-03-05T17:43:03  
1120018 2020-03-03 Italy       2502 79 160   43.0 12.0 2020-03-03T20:03:06  
1143330 2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
1180248 2020-03-11 Italy       12462 827 1045   43.0 12.0 2020-03-11T21:33:02  
1188139 2020-03-06 Italy       4636 197 523   43.0 12.0 2020-03-06T17:33:03  
1215236 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
1230388 2020-03-15 Italy       24747 1809 2335   41.8719 12.5674 2020-03-14T20:13:16  
1295443 2020-03-10 Italy       10149 631 724   43.0 12.0 2020-03-10T17:53:02  
1311397 2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
1369524 2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
1403250 2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
1507936 2020-03-01 Italy       1694 34 83   43.0 12.0 2020-03-01T23:23:02  
1523220 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
1540495 2020-03-08 Italy       7375 366 622   43.0 12.0 2020-03-08T18:03:04  
1560730 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
1586169 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1637200 2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
1637554 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
1684499 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
1748181 2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
376016 2020-07-20 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-21 04:38:46 Valle d'Aosta, Italy
483238 2020-07-27 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-28 04:58:43 Valle d'Aosta, Italy
537623 2020-07-24 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-25 04:47:39 Valle d'Aosta, Italy
929135 2020-07-23 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-24 05:30:40 Valle d'Aosta, Italy
1035099 2020-07-21 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-22 04:34:42 Valle d'Aosta, Italy
1169566 2020-07-25 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-26 04:35:00 Valle d'Aosta, Italy
1392249 2020-07-22 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-23 05:15:04 Valle d'Aosta, Italy
1511781 2020-07-26 Italy Valle d'Aosta     1196 146 1049 1 45.73750286 7.320149366 2020-07-27 04:35:02 Valle d'Aosta, Italy
279664 2020-06-28 Italy Basilicata     401 27 372 2 40.63947052 15.80514834 2020-06-29 04:33:44 Basilicata, Italy
866466 2020-07-17 Italy Valle d'Aosta     1196 146 1048 2 45.73750286 7.320149366 2020-07-18 04:34:45 Valle d'Aosta, Italy
873835 2020-07-01 Italy Basilicata     402 27 373 2 40.63947052 15.80514834 2020-07-02 04:33:46 Basilicata, Italy
1026784 2020-07-02 Italy Basilicata     402 27 373 2 40.63947052 15.80514834 2020-07-03 04:33:54 Basilicata, Italy
1230165 2020-07-18 Italy Valle d'Aosta     1196 146 1048 2 45.73750286 7.320149366 2020-07-19 04:34:58 Valle d'Aosta, Italy
1414589 2020-07-16 Italy Valle d'Aosta     1196 146 1048 2 45.73750286 7.320149366 2020-07-17 04:34:50 Valle d'Aosta, Italy
1636981 2020-07-15 Italy Valle d'Aosta     1196 146 1048 2 45.73750286 7.320149366 2020-07-16 04:44:59 Valle d'Aosta, Italy
506610 2020-06-29 Italy Basilicata     402 27 372 3 40.63947052 15.80514834 2020-06-30 04:33:48 Basilicata, Italy
507033 2020-06-29 Italy Valle d'Aosta     1194 146 1045 3 45.73750286 7.320149366 2020-06-30 04:33:48 Valle d'Aosta, Italy
587847 2020-06-30 Italy Basilicata     402 27 372 3 40.63947052 15.80514834 2020-07-01 04:33:52 Basilicata, Italy
874258 2020-07-01 Italy Valle d'Aosta     1195 146 1046 3 45.73750286 7.320149366 2020-07-02 04:33:46 Valle d'Aosta, Italy
893417 2020-07-13 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-14 04:34:46 Valle d'Aosta, Italy
1027207 2020-07-02 Italy Valle d'Aosta     1195 146 1046 3 45.73750286 7.320149366 2020-07-03 04:33:54 Valle d'Aosta, Italy
1119793 2020-07-19 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-20 05:34:40 Valle d'Aosta, Italy
1345367 2020-07-12 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-13 04:43:04 Valle d'Aosta, Italy
1388320 2020-07-11 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-12 04:34:30 Valle d'Aosta, Italy
120155 2020-07-05 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-06 04:33:57 Basilicata, Italy
280087 2020-06-28 Italy Valle d'Aosta     1194 146 1044 4 45.73750286 7.320149366 2020-06-29 04:33:44 Valle d'Aosta, Italy
588270 2020-06-30 Italy Valle d'Aosta     1195 146 1045 4 45.73750286 7.320149366 2020-07-01 04:33:52 Valle d'Aosta, Italy
727954 2020-07-04 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-05 04:33:46 Basilicata, Italy
728376 2020-07-04 Italy Valle d'Aosta     1196 146 1046 4 45.73750286 7.320149366 2020-07-05 04:33:46 Valle d'Aosta, Italy
753871 2020-07-06 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-07 04:34:00 Basilicata, Italy
769904 2020-06-26 Italy Valle d'Aosta     1194 146 1044 4 45.73750286 7.320149366 2020-06-27 04:33:35 Valle d'Aosta, Italy
1093262 2020-06-27 Italy Valle d'Aosta     1194 146 1044 4 45.73750286 7.320149366 2020-06-28 04:34:04 Valle d'Aosta, Italy
1241095 2020-06-19 Italy Valle d'Aosta     1191 146 1041 4 45.73750286 7.320149366 2020-06-20 04:33:19 Valle d'Aosta, Italy
1256643 2020-07-14 Italy Valle d'Aosta     1196 146 1046 4 45.73750286 7.320149366 2020-07-15 04:34:39 Valle d'Aosta, Italy
1337891 2020-07-03 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-04 04:33:51 Basilicata, Italy
1338313 2020-07-03 Italy Valle d'Aosta     1196 146 1046 4 45.73750286 7.320149366 2020-07-04 04:33:51 Valle d'Aosta, Italy
1486071 2020-07-07 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-08 05:33:48 Basilicata, Italy
64872 2020-06-22 Italy Valle d'Aosta     1193 146 1042 5 45.73750286 7.320149366 2020-06-23 04:33:22 Valle d'Aosta, Italy
120577 2020-07-05 Italy Valle d'Aosta     1196 146 1045 5 45.73750286 7.320149366 2020-07-06 04:33:57 Valle d'Aosta, Italy
456284 2020-07-08 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-09 04:34:23 Basilicata, Italy
456706 2020-07-08 Italy Valle d'Aosta     1196 146 1045 5 45.73750286 7.320149366 2020-07-09 04:34:23 Valle d'Aosta, Italy
661327 2020-06-21 Italy Valle d'Aosta     1193 146 1042 5 45.73750286 7.320149366 2020-06-22 04:33:20 Valle d'Aosta, Italy
754293 2020-07-06 Italy Valle d'Aosta     1196 146 1045 5 45.73750286 7.320149366 2020-07-07 04:34:00 Valle d'Aosta, Italy
866034 2020-07-17 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-18 04:34:45 Basilicata, Italy
892995 2020-07-13 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-14 04:34:46 Basilicata, Italy
1229734 2020-07-18 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-19 04:34:58 Basilicata, Italy
1256221 2020-07-14 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-15 04:34:39 Basilicata, Italy
1303177 2020-06-23 Italy Valle d'Aosta     1193 146 1042 5 45.73750286 7.320149366 2020-06-24 04:33:28 Valle d'Aosta, Italy
1344944 2020-07-12 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-13 04:43:04 Basilicata, 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]);