daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, day (date), last_update (date)
province_or_state 21
- Abruzzo 960
- Basilicata 960
- Calabria 960
- Campania 960
- Emilia-Romagna 960
- Friuli Venezia Giulia 960
- Lazio 960
- Liguria 960
- Lombardia 960
- Marche 960
- Molise 960
- P.A. Bolzano 960
- P.A. Trento 960
- Piemonte 960
- Puglia 960
- Sardegna 960
- Sicilia 960
- Toscana 960
- Umbria 960
- Valle d'Aosta 960
- Veneto 960
country_or_region 1
- Italy · 20,264 ✖
day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | Italy | 3858 | 148 | 414 | 43.0 | 12.0 | 2020-03-05T17:43:03 | |||||
2020-04-13 | Italy | 159516 | 20465 | 35435 | 103616 | 41.87194 | 12.56738 | 2020-04-13 23:07:34 | Italy | |||
2020-04-17 | Italy | 172434 | 22745 | 42727 | 106962 | 41.87194 | 12.56738 | 2020-04-17 23:30:32 | Italy | |||
2020-03-07 | Italy | 5883 | 233 | 589 | 43.0 | 12.0 | 2020-03-07T17:33:03 | |||||
2020-03-04 | Italy | 3089 | 107 | 276 | 43.0 | 12.0 | 2020-03-04T19:23:03 | |||||
2020-02-15 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-05-08 | Italy | 217185 | 30201 | 99023 | 87961 | 41.87194 | 12.56738 | 2020-05-09 02:32:35 | Italy | |||
2020-04-29 | Italy | 203591 | 27682 | 71252 | 104657 | 41.87194 | 12.56738 | 2020-04-30 02:32:27 | Italy | |||
2020-04-30 | Italy | 205463 | 27967 | 75945 | 101551 | 41.87194 | 12.56738 | 2020-05-01 02:32:28 | Italy | |||
2020-03-03 | Italy | 2502 | 79 | 160 | 43.0 | 12.0 | 2020-03-03T20:03:06 | |||||
2020-04-28 | Italy | 201505 | 27359 | 68941 | 105205 | 41.87194 | 12.56738 | 2020-04-29 02:32:29 | Italy | |||
2020-03-21 | Italy | 53578 | 4825 | 6072 | 41.8719 | 12.5674 | 2020-03-21T17:43:03 | |||||
2020-04-18 | Italy | 175925 | 23227 | 44927 | 107771 | 41.87194 | 12.56738 | 2020-04-18 22:32:28 | 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-01 | Italy | 1694 | 34 | 83 | 43.0 | 12.0 | 2020-03-01T23:23:02 | |||||
2020-02-06 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-04-05 | Italy | 128948 | 15887 | 21815 | 91246 | 41.87194 | 12.56738 | 2020-04-05 23:06:26 | Italy | |||
2020-02-27 | Italy | 655 | 17 | 45 | 2020-02-27T23:23:02 | |||||||
2020-03-09 | Italy | 9172 | 463 | 724 | 43.0 | 12.0 | 2020-03-09T18:13:11 | |||||
2020-03-27 | Italy | 86498 | 9134 | 10950 | 66414 | 41.87194 | 12.56738 | 2020-03-27 23:23:03 | Italy | |||
2020-04-15 | Italy | 165155 | 21645 | 38092 | 105418 | 41.87194 | 12.56738 | 2020-04-15 22:56:32 | Italy | |||
2020-03-26 | Italy | 80589 | 8215 | 10361 | 62013 | 41.87194 | 12.56738 | 2020-03-26 23:48:18 | Italy | |||
2020-04-16 | Italy | 168941 | 22170 | 40164 | 106607 | 41.87194 | 12.56738 | 2020-04-16 23:30:31 | Italy | |||
2020-02-22 | Italy | 62 | 2 | 1 | 2020-02-22T23:43:02 | |||||||
2020-03-25 | Italy | 74386 | 7503 | 9362 | 57521 | 41.87194 | 12.56738 | 2020-03-25 23:33:04 | Italy | |||
2020-03-02 | Italy | 2036 | 52 | 149 | 43.0 | 12.0 | 2020-03-02T20:23:16 | |||||
2020-03-18 | Italy | 35713 | 2978 | 4025 | 41.8719 | 12.5674 | 2020-03-18T17:33:05 | |||||
2020-05-01 | Italy | 207428 | 28236 | 78249 | 100943 | 41.87194 | 12.56738 | 2020-05-02 02:32:27 | Italy | |||
2020-02-14 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-22 | Italy | 187327 | 25085 | 54543 | 107699 | 41.87194 | 12.56738 | 2020-04-22 23:30:32 | Italy | |||
2020-02-17 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-10 | Italy | 147577 | 18849 | 30455 | 98273 | 41.87194 | 12.56738 | 2020-04-10 22:53:48 | Italy | |||
2020-02-08 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-19 | Italy | 178972 | 23660 | 47055 | 108257 | 41.87194 | 12.56738 | 2020-04-19 23:40:41 | Italy | |||
2020-04-24 | Italy | 192994 | 25969 | 60498 | 106527 | 41.87194 | 12.56738 | 2020-04-25 06:30:33 | Italy | |||
2020-03-15 | Italy | 24747 | 1809 | 2335 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
2020-03-24 | Italy | 69176 | 6820 | 8326 | 54030 | 41.87194 | 12.56738 | 2020-03-24 23:37:15 | Italy | |||
2020-03-19 | Italy | 41035 | 3405 | 4440 | 41.8719 | 12.5674 | 2020-03-19T17:43:03 | |||||
2020-03-08 | Italy | 7375 | 366 | 622 | 43.0 | 12.0 | 2020-03-08T18:03:04 | |||||
2020-02-13 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-19 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-04 | Italy | 124632 | 15362 | 20996 | 88274 | 41.87194 | 12.56738 | 4/4/20 23:34 | Italy | |||
2020-02-18 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-03-30 | Italy | 101739 | 11591 | 14620 | 75528 | 41.87194 | 12.56738 | 3/30/20 22:52 | Italy | |||
2020-02-16 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-05-05 | Italy | 213013 | 29315 | 85231 | 98467 | 41.87194 | 12.56738 | 2020-05-06 02:32:31 | Italy | |||
2020-05-02 | Italy | 209328 | 28710 | 79914 | 100704 | 41.87194 | 12.56738 | 2020-05-03 02:32:28 | Italy | |||
2020-02-05 | 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-03-14 | Italy | 21157 | 1441 | 1966 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
2020-03-11 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2020-02-21 | Italy | 20 | 1 | 0 | 2020-02-21T23:33:06 | |||||||
2020-03-23 | Italy | 63927 | 6077 | 7432 | 50418 | 41.87194 | 12.56738 | 2020-03-23 23:19:21 | Italy | |||
2020-03-16 | Italy | 27980 | 2158 | 2749 | 41.8719 | 12.5674 | 2020-03-16T17:33:03 | |||||
2020-02-20 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-05-03 | Italy | 210717 | 28884 | 81654 | 100179 | 41.87194 | 12.56738 | 2020-05-04 02:32:28 | Italy | |||
2020-03-12 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2020-02-02 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-04-20 | Italy | 181228 | 24114 | 48877 | 108237 | 41.87194 | 12.56738 | 2020-04-20 23:36:27 | Italy | |||
2020-02-26 | Italy | 453 | 12 | 3 | 2020-02-26T23:43:03 | |||||||
2020-04-23 | Italy | 189973 | 25549 | 57576 | 106848 | 41.87194 | 12.56738 | 2020-04-24 03:30:31 | Italy | |||
2020-04-11 | Italy | 152271 | 19468 | 32534 | 100269 | 41.87194 | 12.56738 | 2020-04-11 22:45:13 | Italy | |||
2020-02-12 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-12 | Italy | 156363 | 19899 | 34211 | 102253 | 41.87194 | 12.56738 | 2020-04-12 23:17:00 | Italy | |||
2020-05-12 | Italy | 221216 | 30911 | 109039 | 81266 | 41.87194 | 12.56738 | 2020-05-13 03:32:26 | Italy | |||
2020-02-03 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-03-29 | Italy | 97689 | 10779 | 13030 | 73880 | 41.87194 | 12.56738 | 3/29/20 23:08 | Italy | |||
2020-02-28 | Italy | 888 | 21 | 46 | 2020-02-28T20:13:09 | |||||||
2020-05-09 | Italy | 218268 | 30395 | 103031 | 84842 | 41.87194 | 12.56738 | 2020-05-10 02:32:30 | Italy | |||
2020-03-22 | Italy | 59138 | 5476 | 7024 | 46638 | 41.87194 | 12.56738 | 3/22/20 23:45 | Italy | |||
2020-04-07 | Italy | 135586 | 17127 | 24392 | 94067 | 41.87194 | 12.56738 | 2020-04-07 23:04:29 | Italy | |||
2020-05-04 | Italy | 211938 | 29079 | 82879 | 99980 | 41.87194 | 12.56738 | 2020-05-05 02:32:34 | Italy | |||
2020-02-10 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-23 | Italy | 155 | 3 | 2 | 2020-02-23T23:43:02 | |||||||
2020-03-06 | Italy | 4636 | 197 | 523 | 43.0 | 12.0 | 2020-03-06T17:33:03 | |||||
2020-02-11 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-02-29 | Italy | 1128 | 29 | 46 | 2020-02-29T18:03:05 | |||||||
2020-02-07 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-05-07 | Italy | 215858 | 29958 | 96276 | 89624 | 41.87194 | 12.56738 | 2020-05-08 02:32:32 | Italy | |||
2020-05-11 | Italy | 219814 | 30739 | 106587 | 82488 | 41.87194 | 12.56738 | 2020-05-12 03:32:27 | Italy | |||
2020-04-14 | Italy | 162488 | 21067 | 37130 | 104291 | 41.87194 | 12.56738 | 2020-04-14 23:33:12 | Italy | |||
2020-02-09 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2020-04-01 | Italy | 110574 | 13155 | 16847 | 80572 | 41.87194 | 12.56738 | 2020-04-01 21:58:34 | Italy | |||
2020-02-01 | Italy | 2 | 0 | 0 | 1/31/2020 8:15 | |||||||
2020-05-10 | Italy | 219070 | 30560 | 105186 | 83324 | 41.87194 | 12.56738 | 2020-05-11 02:32:30 | Italy | |||
2020-02-04 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2020-04-25 | Italy | 195351 | 26384 | 63120 | 105847 | 41.87194 | 12.56738 | 2020-04-26 02:30:31 | Italy | |||
2020-02-24 | Italy | 229 | 7 | 1 | 2020-02-24T23:43:01 | |||||||
2020-04-08 | Italy | 139422 | 17669 | 26491 | 95262 | 41.87194 | 12.56738 | 2020-04-08 22:51:39 | Italy | |||
2020-04-27 | Italy | 199414 | 26977 | 66624 | 105813 | 41.87194 | 12.56738 | 2020-04-28 02:30:32 | Italy | |||
2020-04-26 | Italy | 197675 | 26644 | 64928 | 106103 | 41.87194 | 12.56738 | 2020-04-27 02:30:33 | Italy | |||
2020-04-06 | Italy | 132547 | 16523 | 22837 | 93187 | 41.87194 | 12.56738 | 4/6/20 23:21 | Italy | |||
2020-04-02 | Italy | 115242 | 13915 | 18278 | 83049 | 41.87194 | 12.56738 | 4/2/20 23:25 | Italy | |||
2020-03-20 | Italy | 47021 | 4032 | 4440 | 41.8719 | 12.5674 | 2020-03-20T17:43:03 | |||||
2020-04-03 | Italy | 119827 | 14681 | 19758 | 85388 | 41.87194 | 12.56738 | 2020-04-03 22:46:20 | Italy | |||
2020-03-10 | Italy | 10149 | 631 | 724 | 43.0 | 12.0 | 2020-03-10T17:53:02 | |||||
2020-01-31 | Italy | 2 | 0 | 0 | 1/31/2020 23:59 | |||||||
2020-03-13 | Italy | 17660 | 1266 | 1439 | 41.8719 | 12.5674 | 2020-03-11T20:00:00 | |||||
2020-03-31 | Italy | 105792 | 12428 | 15729 | 77635 | 41.87194 | 12.56738 | 2020-03-31 23:43:43 | Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;