daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

69 rows where country_or_region = "Italy" sorted by confirmed descending

View and edit SQL

Suggested facets: latitude, longitude, day (date), last_update (date)

country_or_region

  • Italy · 69

province_or_state

day country_or_region province_or_state admin2 fips confirmed ▲ deaths recovered active latitude longitude last_update combined_key
2020-04-08 Italy       139422 17669 26491 95262 41.87194 12.56738 2020-04-08 22:51:39 Italy
2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
2020-04-06 Italy       132547 16523 22837 93187 41.87194 12.56738 4/6/20 23:21 Italy
2020-04-05 Italy       128948 15887 21815 91246 41.87194 12.56738 2020-04-05 23:06:26 Italy
2020-04-04 Italy       124632 15362 20996 88274 41.87194 12.56738 2020-04-04 23:34:04 Italy
2020-04-03 Italy       119827 14681 19758 85388 41.87194 12.56738 2020-04-03 22:46:20 Italy
2020-04-02 Italy       115242 13915 18278 83049 41.87194 12.56738 2020-04-02 23:25:14 Italy
2020-04-01 Italy       110574 13155 16847 80572 41.87194 12.56738 2020-04-01 21:58:34 Italy
2020-03-31 Italy       105792 12428 15729 77635 41.87194 12.56738 2020-03-31 23:43:43 Italy
2020-03-30 Italy       101739 11591 14620 75528 41.87194 12.56738 3/30/20 22:52 Italy
2020-03-29 Italy       97689 10779 13030 73880 41.87194 12.56738 3/29/20 23:08 Italy
2020-03-28 Italy       92472 10023 12384 70065 41.87194 12.56738 2020-03-28 23:05:25 Italy
2020-03-27 Italy       86498 9134 10950 66414 41.87194 12.56738 2020-03-27 23:23:03 Italy
2020-03-26 Italy       80589 8215 10361 62013 41.87194 12.56738 2020-03-26 23:48:18 Italy
2020-03-25 Italy       74386 7503 9362 57521 41.87194 12.56738 2020-03-25 23:33:04 Italy
2020-03-24 Italy       69176 6820 8326 54030 41.87194 12.56738 2020-03-24 23:37:15 Italy
2020-03-23 Italy       63927 6077 7432 50418 41.87194 12.56738 2020-03-23 23:19:21 Italy
2020-03-22 Italy       59138 5476 7024 46638 41.87194 12.56738 3/22/20 23:45 Italy
2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
2020-03-15 Italy       24747 1809 2335   41.8719 12.5674 2020-03-14T20:13:16  
2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
2020-03-13 Italy       17660 1266 1439   41.8719 12.5674 2020-03-11T20:00:00  
2020-03-12 Italy       12462 827 1045   43.0000 12.0000 2020-03-11T21:33:02  
2020-03-11 Italy       12462 827 1045   43.0000 12.0000 2020-03-11T21:33:02  
2020-03-10 Italy       10149 631 724   43.0000 12.0000 2020-03-10T17:53:02  
2020-03-09 Italy       9172 463 724   43.0000 12.0000 2020-03-09T18:13:11  
2020-03-08 Italy       7375 366 622   43.0000 12.0000 2020-03-08T18:03:04  
2020-03-07 Italy       5883 233 589   43.0000 12.0000 2020-03-07T17:33:03  
2020-03-06 Italy       4636 197 523   43.0000 12.0000 2020-03-06T17:33:03  
2020-03-05 Italy       3858 148 414   43.0000 12.0000 2020-03-05T17:43:03  
2020-03-04 Italy       3089 107 276   43.0000 12.0000 2020-03-04T19:23:03  
2020-03-03 Italy       2502 79 160   43.0000 12.0000 2020-03-03T20:03:06  
2020-03-02 Italy       2036 52 149   43.0000 12.0000 2020-03-02T20:23:16  
2020-03-01 Italy       1694 34 83   43.0000 12.0000 2020-03-01T23:23:02  
2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-07 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-08 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
2020-01-31 Italy       2 0 0       1/31/2020 23:59  
2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-01 Italy       2 0 0       1/31/2020 8:15  
2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 534.806ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette