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

545 rows where country_or_region = "Italy" sorted by province_or_state

View and edit SQL

country_or_region

  • Italy · 545
day country_or_region province_or_state ▼ admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-04-30 Italy       205463 27967 75945 101551 41.87194 12.56738 2020-05-01 02:32:28 Italy
2020-03-26 Italy       80589 8215 10361 62013 41.87194 12.56738 2020-03-26 23:48:18 Italy
2020-05-11 Italy       219814 30739 106587 82488 41.87194 12.56738 2020-05-12 03:32:27 Italy
2020-02-01 Italy       2 0 0       1/31/2020 8:15  
2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
2020-04-02 Italy       115242 13915 18278 83049 41.87194 12.56738 4/2/20 23:25 Italy
2020-04-20 Italy       181228 24114 48877 108237 41.87194 12.56738 2020-04-20 23:36:27 Italy
2020-04-27 Italy       199414 26977 66624 105813 41.87194 12.56738 2020-04-28 02:30:32 Italy
2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
2020-05-03 Italy       210717 28884 81654 100179 41.87194 12.56738 2020-05-04 02:32:28 Italy
2020-03-22 Italy       59138 5476 7024 46638 41.87194 12.56738 3/22/20 23:45 Italy
2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
2020-04-23 Italy       189973 25549 57576 106848 41.87194 12.56738 2020-04-24 03:30:31 Italy
2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
2020-03-29 Italy       97689 10779 13030 73880 41.87194 12.56738 3/29/20 23:08 Italy
2020-05-08 Italy       217185 30201 99023 87961 41.87194 12.56738 2020-05-09 02:32:35 Italy
2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
2020-05-02 Italy       209328 28710 79914 100704 41.87194 12.56738 2020-05-03 02:32:28 Italy
2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
2020-04-15 Italy       165155 21645 38092 105418 41.87194 12.56738 2020-04-15 22:56:32 Italy
2020-03-30 Italy       101739 11591 14620 75528 41.87194 12.56738 3/30/20 22:52 Italy
2020-03-23 Italy       63927 6077 7432 50418 41.87194 12.56738 2020-03-23 23:19:21 Italy
2020-04-22 Italy       187327 25085 54543 107699 41.87194 12.56738 2020-04-22 23:30:32 Italy
2020-03-10 Italy       10149 631 724   43.0000 12.0000 2020-03-10T17:53:02  
2020-04-12 Italy       156363 19899 34211 102253 41.87194 12.56738 2020-04-12 23:17:00 Italy
2020-03-15 Italy       24747 1809 2335   41.8719 12.5674 2020-03-14T20:13:16  
2020-03-06 Italy       4636 197 523   43.0000 12.0000 2020-03-06T17:33:03  
2020-04-16 Italy       168941 22170 40164 106607 41.87194 12.56738 2020-04-16 23:30:31 Italy
2020-02-04 Italy       2 0 0       2020-01-31T08:15:53  
2020-03-11 Italy       12462 827 1045   43.0000 12.0000 2020-03-11T21:33:02  
2020-03-05 Italy       3858 148 414   43.0000 12.0000 2020-03-05T17:43:03  
2020-02-10 Italy       3 0 0       2020-02-07T17:53:02  
2020-04-18 Italy       175925 23227 44927 107771 41.87194 12.56738 2020-04-18 22:32:28 Italy
2020-03-17 Italy       31506 2503 2941   41.8719 12.5674 2020-03-17T18:33:02  
2020-05-05 Italy       213013 29315 85231 98467 41.87194 12.56738 2020-05-06 02:32:31 Italy
2020-04-03 Italy       119827 14681 19758 85388 41.87194 12.56738 2020-04-03 22:46:20 Italy
2020-03-13 Italy       17660 1266 1439   41.8719 12.5674 2020-03-11T20:00:00  
2020-04-25 Italy       195351 26384 63120 105847 41.87194 12.56738 2020-04-26 02:30:31 Italy
2020-02-05 Italy       2 0 0       2020-01-31T08:15:53  
2020-03-03 Italy       2502 79 160   43.0000 12.0000 2020-03-03T20:03:06  
2020-04-04 Italy       124632 15362 20996 88274 41.87194 12.56738 4/4/20 23:34 Italy
2020-03-12 Italy       12462 827 1045   43.0000 12.0000 2020-03-11T21:33:02  
2020-02-23 Italy       155 3 2       2020-02-23T23:43:02  
2020-04-14 Italy       162488 21067 37130 104291 41.87194 12.56738 2020-04-14 23:33:12 Italy
2020-02-13 Italy       3 0 0       2020-02-07T17:53:02  
2020-03-07 Italy       5883 233 589   43.0000 12.0000 2020-03-07T17:33:03  
2020-03-24 Italy       69176 6820 8326 54030 41.87194 12.56738 2020-03-24 23:37:15 Italy
2020-05-01 Italy       207428 28236 78249 100943 41.87194 12.56738 2020-05-02 02:32:27 Italy
2020-04-13 Italy       159516 20465 35435 103616 41.87194 12.56738 2020-04-13 23:07:34 Italy
2020-02-06 Italy       2 0 0       2020-01-31T08:15:53  
2020-05-06 Italy       214457 29684 93245 91528 41.87194 12.56738 2020-05-07 02:32:28 Italy
2020-02-21 Italy       20 1 0       2020-02-21T23:33:06  
2020-04-28 Italy       201505 27359 68941 105205 41.87194 12.56738 2020-04-29 02:32:29 Italy
2020-02-22 Italy       62 2 1       2020-02-22T23:43:02  
2020-04-01 Italy       110574 13155 16847 80572 41.87194 12.56738 2020-04-01 21:58:34 Italy
2020-02-11 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-18 Italy       3 0 0       2020-02-07T17:53:02  
2020-04-06 Italy       132547 16523 22837 93187 41.87194 12.56738 4/6/20 23:21 Italy
2020-04-17 Italy       172434 22745 42727 106962 41.87194 12.56738 2020-04-17 23:30:32 Italy
2020-03-25 Italy       74386 7503 9362 57521 41.87194 12.56738 2020-03-25 23:33:04 Italy
2020-02-12 Italy       3 0 0       2020-02-07T17:53:02  
2020-01-31 Italy       2 0 0       1/31/2020 23:59  
2020-02-27 Italy       655 17 45       2020-02-27T23:23:02  
2020-03-01 Italy       1694 34 83   43.0000 12.0000 2020-03-01T23:23:02  
2020-04-10 Italy       147577 18849 30455 98273 41.87194 12.56738 2020-04-10 22:53:48 Italy
2020-05-07 Italy       215858 29958 96276 89624 41.87194 12.56738 2020-05-08 02:32:32 Italy
2020-04-08 Italy       139422 17669 26491 95262 41.87194 12.56738 2020-04-08 22:51:39 Italy
2020-03-02 Italy       2036 52 149   43.0000 12.0000 2020-03-02T20:23:16  
2020-05-13 Italy       222104 31106 112541 78457 41.87194 12.56738 2020-05-14 03:32:28 Italy
2020-04-26 Italy       197675 26644 64928 106103 41.87194 12.56738 2020-04-27 02:30:33 Italy
2020-03-08 Italy       7375 366 622   43.0000 12.0000 2020-03-08T18:03:04  
2020-03-28 Italy       92472 10023 12384 70065 41.87194 12.56738 3/28/20 23:05 Italy
2020-02-25 Italy       322 10 1       2020-02-25T18:55:32  
2020-04-21 Italy       183957 24648 51600 107709 41.87194 12.56738 2020-04-21 23:30:30 Italy
2020-03-31 Italy       105792 12428 15729 77635 41.87194 12.56738 2020-03-31 23:43:43 Italy
2020-03-21 Italy       53578 4825 6072   41.8719 12.5674 2020-03-21T17:43:03  
2020-04-05 Italy       128948 15887 21815 91246 41.87194 12.56738 2020-04-05 23:06:26 Italy
2020-02-16 Italy       3 0 0       2020-02-07T17:53:02  
2020-03-04 Italy       3089 107 276   43.0000 12.0000 2020-03-04T19:23:03  
2020-04-11 Italy       152271 19468 32534 100269 41.87194 12.56738 2020-04-11 22:45:13 Italy
2020-02-09 Italy       3 0 0       2020-02-07T17:53:02  
2020-05-04 Italy       211938 29079 82879 99980 41.87194 12.56738 2020-05-05 02:32:34 Italy
2020-02-15 Italy       3 0 0       2020-02-07T17:53:02  
2020-05-10 Italy       219070 30560 105186 83324 41.87194 12.56738 2020-05-11 02:32:30 Italy
2020-04-09 Italy       143626 18279 28470 96877 41.87194 12.56738 2020-04-09 23:02:19 Italy
2020-04-19 Italy       178972 23660 47055 108257 41.87194 12.56738 2020-04-19 23:40:41 Italy
2020-05-12 Italy       221216 30911 109039 81266 41.87194 12.56738 2020-05-13 03:32:26 Italy
2020-05-09 Italy       218268 30395 103031 84842 41.87194 12.56738 2020-05-10 02:32:30 Italy
2020-03-18 Italy       35713 2978 4025   41.8719 12.5674 2020-03-18T17:33:05  
2020-04-29 Italy       203591 27682 71252 104657 41.87194 12.56738 2020-04-30 02:32:27 Italy
2020-04-24 Italy       192994 25969 60498 106527 41.87194 12.56738 2020-04-25 06:30:33 Italy

Next page

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 3179.604ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette