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

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  
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  
491486 2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
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  
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  
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  
965376 2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
1023602 2020-01-31 Italy       2 0 0       1/31/2020 23:59  
1143330 2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
1215236 2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
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  
1523220 2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
1586169 2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
1637554 2020-02-01 Italy       2 0 0       1/31/2020 8:15  
153293 2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
1403250 2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
1684499 2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
1012396 2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
1086486 2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
685356 2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
965208 2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
1560730 2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
1507936 2020-03-01 Italy       1694 34 83   43.0 12.0 2020-03-01T23:23:02  
598605 2020-03-02 Italy       2036 52 149   43.0 12.0 2020-03-02T20:23:16  
518272 2020-05-14 Italy Molise     403 22 152 229 41.55774754 14.65916051 2020-05-15 02:33:02 Molise, Italy
750445 2020-05-15 Italy Molise     407 22 158 227 41.55774754 14.65916051 2020-05-16 02:32:19 Molise, Italy
1120018 2020-03-03 Italy       2502 79 160   43.0 12.0 2020-03-03T20:03:06  
175551 2020-05-16 Italy Molise     410 22 173 215 41.55774754 14.65916051 2020-05-17 02:32:32 Molise, Italy
287352 2020-05-17 Italy Molise     411 22 173 216 41.55774754 14.65916051 2020-05-18 02:32:21 Molise, Italy
1482644 2020-05-18 Italy Molise     422 22 183 217 41.55774754 14.65916051 2020-05-19 02:32:18 Molise, Italy
1536829 2020-05-19 Italy Molise     422 22 188 212 41.55774754 14.65916051 2020-05-20 02:32:19 Molise, Italy
846660 2020-05-20 Italy Molise     422 22 202 198 41.55774754 14.65916051 2020-05-21 02:32:48 Molise, Italy
1767367 2020-05-21 Italy Molise     423 22 207 194 41.55774754 14.65916051 2020-05-22 02:36:51 Molise, Italy
1540207 2020-05-22 Italy Molise     426 22 220 184 41.55774754 14.65916051 2020-05-23 02:32:42 Molise, Italy
1770781 2020-05-23 Italy Molise     431 22 220 189 41.55774754 14.65916051 2020-05-24 02:32:43 Molise, Italy
398420 2020-05-24 Italy Molise     432 22 227 183 41.55774754 14.65916051 2020-05-25 02:32:44 Molise, Italy
1574800 2020-05-25 Italy Molise     432 22 233 177 41.55774754 14.65916051 2020-05-26 02:32:35 Molise, Italy
518201 2020-05-14 Italy Basilicata     389 27 235 127 40.63947052 15.80514834 2020-05-15 02:33:02 Basilicata, Italy
1318523 2020-05-26 Italy Molise     432 22 236 174 41.55774754 14.65916051 2020-05-27 02:32:31 Molise, Italy
750374 2020-05-15 Italy Basilicata     389 27 242 120 40.63947052 15.80514834 2020-05-16 02:32:19 Basilicata, Italy
708473 2020-05-27 Italy Molise     434 22 246 166 41.55774754 14.65916051 2020-05-28 02:32:31 Molise, Italy
175480 2020-05-16 Italy Basilicata     390 27 250 113 40.63947052 15.80514834 2020-05-17 02:32:32 Basilicata, Italy
1625234 2020-05-28 Italy Molise     435 22 250 163 41.55774754 14.65916051 2020-05-29 02:32:50 Molise, Italy
1504390 2020-05-29 Italy Molise     436 22 252 162 41.55774754 14.65916051 2020-05-30 02:32:48 Molise, Italy
1158502 2020-05-30 Italy Molise     436 22 258 156 41.55774754 14.65916051 2020-05-31 02:32:45 Molise, Italy
287281 2020-05-17 Italy Basilicata     392 27 261 104 40.63947052 15.80514834 2020-05-18 02:32:21 Basilicata, Italy
349623 2020-05-31 Italy Molise     436 22 269 145 41.55774754 14.65916051 2020-06-01 02:32:46 Molise, Italy
1482573 2020-05-18 Italy Basilicata     392 27 272 93 40.63947052 15.80514834 2020-05-19 02:32:18 Basilicata, Italy
132845 2020-03-04 Italy       3089 107 276   43.0 12.0 2020-03-04T19:23:03  
194922 2020-06-01 Italy Molise     436 22 279 135 41.55774754 14.65916051 2020-06-02 02:33:08 Molise, Italy
372014 2020-06-02 Italy Molise     436 22 281 133 41.55774754 14.65916051 2020-06-03 02:33:13 Molise, Italy
1536757 2020-05-19 Italy Basilicata     393 27 282 84 40.63947052 15.80514834 2020-05-20 02:32:19 Basilicata, Italy
1271183 2020-06-03 Italy Molise     436 22 287 127 41.55774754 14.65916051 2020-06-04 02:33:14 Molise, Italy
7261 2020-06-04 Italy Molise     436 23 288 125 41.55774754 14.65916051 2020-06-05 02:33:06 Molise, Italy
56941 2020-06-05 Italy Molise     436 23 291 122 41.55774754 14.65916051 2020-06-06 02:33:00 Molise, Italy
1410580 2020-06-06 Italy Molise     436 23 292 121 41.55774754 14.65916051 2020-06-07 03:53:30 Molise, Italy
846561 2020-05-20 Italy Basilicata     393 27 293 73 40.63947052 15.80514834 2020-05-21 02:32:48 Basilicata, Italy
1187743 2020-06-07 Italy Molise     436 23 293 120 41.55774754 14.65916051 2020-06-08 03:33:22 Molise, Italy
1078391 2020-06-08 Italy Molise     436 23 294 119 41.55774754 14.65916051 2020-06-09 03:33:03 Molise, Italy
330156 2020-06-09 Italy Molise     438 23 295 120 41.55774754 14.65916051 2020-06-10 04:07:00 Molise, Italy
765922 2020-06-10 Italy Molise     439 23 296 120 41.55774754 14.65916051 2020-06-11 03:33:41 Molise, Italy
1644892 2020-06-11 Italy Molise     439 23 300 116 41.55774754 14.65916051 2020-06-12 05:09:52 Molise, Italy
1248635 2020-06-12 Italy Molise     439 23 302 114 41.55774754 14.65916051 2020-06-13 03:33:14 Molise, Italy
1767268 2020-05-21 Italy Basilicata     394 27 307 60 40.63947052 15.80514834 2020-05-22 02:36:51 Basilicata, Italy
1540108 2020-05-22 Italy Basilicata     394 27 318 49 40.63947052 15.80514834 2020-05-23 02:32:42 Basilicata, Italy
106641 2020-06-13 Italy Molise     439 23 319 97 41.55774754 14.65916051 2020-06-14 03:33:15 Molise, Italy
1770682 2020-05-23 Italy Basilicata     398 27 330 41 40.63947052 15.80514834 2020-05-24 02:32:43 Basilicata, Italy
398321 2020-05-24 Italy Basilicata     399 27 333 39 40.63947052 15.80514834 2020-05-25 02:32:44 Basilicata, Italy
708374 2020-05-27 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-28 02:32:31 Basilicata, Italy
1318424 2020-05-26 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-27 02:32:31 Basilicata, Italy
1574701 2020-05-25 Italy Basilicata     399 27 336 36 40.63947052 15.80514834 2020-05-26 02:32:35 Basilicata, Italy
1625087 2020-05-28 Italy Basilicata     399 27 338 34 40.63947052 15.80514834 2020-05-29 02:32:50 Basilicata, Italy
1504242 2020-05-29 Italy Basilicata     399 27 339 33 40.63947052 15.80514834 2020-05-30 02:32:48 Basilicata, Italy
1158354 2020-05-30 Italy Basilicata     399 27 341 31 40.63947052 15.80514834 2020-05-31 02:32:45 Basilicata, Italy
1652630 2020-06-14 Italy Molise     439 23 342 74 41.55774754 14.65916051 2020-06-15 03:33:14 Molise, Italy
349475 2020-05-31 Italy Basilicata     399 27 343 29 40.63947052 15.80514834 2020-06-01 02:32:46 Basilicata, Italy
194725 2020-06-01 Italy Basilicata     399 27 344 28 40.63947052 15.80514834 2020-06-02 02:33:08 Basilicata, Italy
1515353 2020-06-15 Italy Molise     439 23 346 70 41.55774754 14.65916051 2020-06-16 04:33:09 Molise, Italy
371818 2020-06-02 Italy Basilicata     399 27 348 24 40.63947052 15.80514834 2020-06-03 02:33:13 Basilicata, Italy
1270986 2020-06-03 Italy Basilicata     399 27 349 23 40.63947052 15.80514834 2020-06-04 02:33:14 Basilicata, Italy
1731824 2020-06-16 Italy Molise     439 23 351 65 41.55774754 14.65916051 2020-06-17 04:33:21 Molise, Italy
7064 2020-06-04 Italy Basilicata     399 27 352 20 40.63947052 15.80514834 2020-06-05 02:33:06 Basilicata, Italy
56735 2020-06-05 Italy Basilicata     399 27 354 18 40.63947052 15.80514834 2020-06-06 02:33:00 Basilicata, Italy
980673 2020-06-17 Italy Molise     440 23 355 62 41.55774754 14.65916051 2020-06-18 04:33:18 Molise, Italy
1410374 2020-06-06 Italy Basilicata     399 27 355 17 40.63947052 15.80514834 2020-06-07 03:53:30 Basilicata, Italy
680988 2020-06-18 Italy Molise     440 23 357 60 41.55774754 14.65916051 2020-06-19 04:33:17 Molise, Italy
1187537 2020-06-07 Italy Basilicata     399 27 358 14 40.63947052 15.80514834 2020-06-08 03:33:22 Basilicata, Italy
329949 2020-06-09 Italy Basilicata     400 27 359 14 40.63947052 15.80514834 2020-06-10 04:07:00 Basilicata, Italy
1078184 2020-06-08 Italy Basilicata     399 27 359 13 40.63947052 15.80514834 2020-06-09 03:33:03 Basilicata, Italy
765693 2020-06-10 Italy Basilicata     400 27 362 11 40.63947052 15.80514834 2020-06-11 03:33:41 Basilicata, Italy
1248405 2020-06-12 Italy Basilicata     401 27 362 12 40.63947052 15.80514834 2020-06-13 03:33:14 Basilicata, Italy
1644662 2020-06-11 Italy Basilicata     401 27 362 12 40.63947052 15.80514834 2020-06-12 05:09:52 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]);