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

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
72813 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
383960 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
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  
1113585 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
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  
1299165 2020-05-15 Italy Basilicata     389 27 242 120 40.63947052 15.80514834 2020-05-16 02:32:19 Basilicata, Italy
1666422 2020-05-14 Italy Basilicata     389 27 235 127 40.63947052 15.80514834 2020-05-15 02:33:02 Basilicata, Italy
504391 2020-05-16 Italy Basilicata     390 27 250 113 40.63947052 15.80514834 2020-05-17 02:32:32 Basilicata, Italy
911214 2020-05-17 Italy Basilicata     392 27 261 104 40.63947052 15.80514834 2020-05-18 02:32:21 Basilicata, Italy
1635375 2020-05-18 Italy Basilicata     392 27 272 93 40.63947052 15.80514834 2020-05-19 02:32:18 Basilicata, Italy
167823 2020-05-19 Italy Basilicata     393 27 282 84 40.63947052 15.80514834 2020-05-20 02:32:19 Basilicata, Italy
317401 2020-05-20 Italy Basilicata     393 27 293 73 40.63947052 15.80514834 2020-05-21 02:32:48 Basilicata, Italy
1144279 2020-05-22 Italy Basilicata     394 27 318 49 40.63947052 15.80514834 2020-05-23 02:32:42 Basilicata, Italy
1452358 2020-05-21 Italy Basilicata     394 27 307 60 40.63947052 15.80514834 2020-05-22 02:36:51 Basilicata, Italy
310037 2020-05-23 Italy Basilicata     398 27 330 41 40.63947052 15.80514834 2020-05-24 02:32:43 Basilicata, Italy
186725 2020-06-07 Italy Basilicata     399 27 358 14 40.63947052 15.80514834 2020-06-08 03:33:22 Basilicata, Italy
252127 2020-05-27 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-28 02:32:31 Basilicata, Italy
448380 2020-06-02 Italy Basilicata     399 27 348 24 40.63947052 15.80514834 2020-06-03 02:33:13 Basilicata, Italy
531056 2020-06-06 Italy Basilicata     399 27 355 17 40.63947052 15.80514834 2020-06-07 03:53:30 Basilicata, Italy
669124 2020-06-04 Italy Basilicata     399 27 352 20 40.63947052 15.80514834 2020-06-05 02:33:06 Basilicata, Italy
777394 2020-05-28 Italy Basilicata     399 27 338 34 40.63947052 15.80514834 2020-05-29 02:32:50 Basilicata, Italy
880053 2020-06-08 Italy Basilicata     399 27 359 13 40.63947052 15.80514834 2020-06-09 03:33:03 Basilicata, Italy
995672 2020-05-31 Italy Basilicata     399 27 343 29 40.63947052 15.80514834 2020-06-01 02:32:46 Basilicata, Italy
1302556 2020-06-01 Italy Basilicata     399 27 344 28 40.63947052 15.80514834 2020-06-02 02:33:08 Basilicata, Italy
1383901 2020-05-24 Italy Basilicata     399 27 333 39 40.63947052 15.80514834 2020-05-25 02:32:44 Basilicata, Italy
1411083 2020-06-05 Italy Basilicata     399 27 354 18 40.63947052 15.80514834 2020-06-06 02:33:00 Basilicata, Italy
1455799 2020-05-29 Italy Basilicata     399 27 339 33 40.63947052 15.80514834 2020-05-30 02:32:48 Basilicata, Italy
1463335 2020-06-03 Italy Basilicata     399 27 349 23 40.63947052 15.80514834 2020-06-04 02:33:14 Basilicata, Italy
1494580 2020-05-30 Italy Basilicata     399 27 341 31 40.63947052 15.80514834 2020-05-31 02:32:45 Basilicata, Italy
1537704 2020-05-26 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-27 02:32:31 Basilicata, Italy
1624049 2020-05-25 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-26 02:32:35 Basilicata, Italy
11031 2020-06-09 Italy Basilicata     400 27 359 14 40.63947052 15.80514834 2020-06-10 04:07:00 Basilicata, Italy
383281 2020-06-10 Italy Basilicata     400 27 362 11 40.63947052 15.80514834 2020-06-11 03:33:41 Basilicata, Italy
21365 2020-06-17 Italy Basilicata     401 27 364 10 40.63947052 15.80514834 2020-06-18 04:33:18 Basilicata, Italy
149284 2020-06-21 Italy Basilicata     401 27 366 8 40.63947052 15.80514834 2020-06-22 04:33:20 Basilicata, Italy
343452 2020-06-22 Italy Basilicata     401 27 366 8 40.63947052 15.80514834 2020-06-23 04:33:22 Basilicata, Italy
461104 2020-06-27 Italy Basilicata     401 27 367 7 40.63947052 15.80514834 2020-06-28 04:34:04 Basilicata, Italy
549893 2020-06-12 Italy Basilicata     401 27 362 12 40.63947052 15.80514834 2020-06-13 03:33:14 Basilicata, Italy
559673 2020-06-28 Italy Basilicata     401 27 372 2 40.63947052 15.80514834 2020-06-29 04:33:44 Basilicata, Italy
636582 2020-06-20 Italy Basilicata     401 27 366 8 40.63947052 15.80514834 2020-06-21 04:33:19 Basilicata, Italy
712683 2020-06-18 Italy Basilicata     401 27 364 10 40.63947052 15.80514834 2020-06-19 04:33:17 Basilicata, Italy
891682 2020-06-14 Italy Basilicata     401 27 363 11 40.63947052 15.80514834 2020-06-15 03:33:14 Basilicata, Italy
949120 2020-06-13 Italy Basilicata     401 27 363 11 40.63947052 15.80514834 2020-06-14 03:33:15 Basilicata, Italy
1019430 2020-06-23 Italy Basilicata     401 27 366 8 40.63947052 15.80514834 2020-06-24 04:33:28 Basilicata, Italy
1108946 2020-06-11 Italy Basilicata     401 27 362 12 40.63947052 15.80514834 2020-06-12 05:09:52 Basilicata, Italy
1198556 2020-06-16 Italy Basilicata     401 27 364 10 40.63947052 15.80514834 2020-06-17 04:33:21 Basilicata, Italy
1238160 2020-06-24 Italy Basilicata     401 27 367 7 40.63947052 15.80514834 2020-06-25 05:26:54 Basilicata, Italy
1376249 2020-06-26 Italy Basilicata     401 27 367 7 40.63947052 15.80514834 2020-06-27 04:33:35 Basilicata, Italy
1530080 2020-06-19 Italy Basilicata     401 27 366 8 40.63947052 15.80514834 2020-06-20 04:33:19 Basilicata, Italy
1580136 2020-06-25 Italy Basilicata     401 27 367 7 40.63947052 15.80514834 2020-06-26 04:33:43 Basilicata, Italy
1745995 2020-06-15 Italy Basilicata     401 27 363 11 40.63947052 15.80514834 2020-06-16 04:33:09 Basilicata, Italy
658509 2020-06-29 Italy Basilicata     402 27 372 3 40.63947052 15.80514834 2020-06-30 04:33:48 Basilicata, Italy
1031200 2020-07-01 Italy Basilicata     402 27 373 2 40.63947052 15.80514834 2020-07-02 04:33:46 Basilicata, Italy
1116766 2020-07-02 Italy Basilicata     402 27 373 2 40.63947052 15.80514834 2020-07-03 04:33:54 Basilicata, Italy
1486957 2020-06-30 Italy Basilicata     402 27 372 3 40.63947052 15.80514834 2020-07-01 04:33:52 Basilicata, Italy
1666493 2020-05-14 Italy Molise     403 22 152 229 41.55774754 14.65916051 2020-05-15 02:33:02 Molise, Italy
87492 2020-07-03 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-04 04:33:51 Basilicata, Italy
225133 2020-07-07 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-08 05:33:48 Basilicata, Italy
267714 2020-07-05 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-06 04:33:57 Basilicata, Italy
492798 2020-07-06 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-07 04:34:00 Basilicata, Italy
1333600 2020-07-04 Italy Basilicata     404 27 373 4 40.63947052 15.80514834 2020-07-05 04:33:46 Basilicata, Italy
415011 2020-07-16 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-17 04:34:50 Basilicata, Italy
825643 2020-07-15 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-16 04:44:59 Basilicata, Italy
860178 2020-07-10 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-11 04:34:26 Basilicata, Italy
941391 2020-07-18 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-19 04:34:58 Basilicata, Italy
1522031 2020-07-09 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-10 04:34:24 Basilicata, Italy
1545343 2020-07-17 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-18 04:34:45 Basilicata, Italy
1650789 2020-07-08 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-09 04:34:23 Basilicata, Italy
145520 2020-07-11 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-12 04:34:30 Basilicata, Italy
761624 2020-07-14 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-15 04:34:39 Basilicata, Italy
1399392 2020-07-12 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-13 04:43:04 Basilicata, Italy
1608421 2020-07-13 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-14 04:34:46 Basilicata, Italy
1299236 2020-05-15 Italy Molise     407 22 158 227 41.55774754 14.65916051 2020-05-16 02:32:19 Molise, Italy
616694 2020-07-20 Italy Basilicata     408 28 373 7 40.63947052 15.80514834 2020-07-21 04:38:46 Basilicata, Italy
650653 2020-07-21 Italy Basilicata     408 28 373 7 40.63947052 15.80514834 2020-07-22 04:34:42 Basilicata, Italy
1490869 2020-07-19 Italy Basilicata     408 28 373 7 40.63947052 15.80514834 2020-07-20 05:34:40 Basilicata, Italy
504462 2020-05-16 Italy Molise     410 22 173 215 41.55774754 14.65916051 2020-05-17 02:32:32 Molise, Italy
911285 2020-05-17 Italy Molise     411 22 173 216 41.55774754 14.65916051 2020-05-18 02:32:21 Molise, Italy
167895 2020-05-19 Italy Molise     422 22 188 212 41.55774754 14.65916051 2020-05-20 02:32:19 Molise, 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]);