johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 42
- 2022-05-26 42
- 2020-05-15 21
- 2020-05-16 21
- 2020-05-17 21
- 2020-05-18 21
- 2020-05-19 21
- 2020-05-20 21
- 2020-05-21 21
- 2020-05-22 21
- 2020-05-23 21
- 2020-05-24 21
- 2020-05-25 21
- 2020-05-26 21
- 2020-05-27 21
- 2020-05-28 21
- 2020-05-29 21
- 2020-05-30 21
- 2020-05-31 21
- 2020-06-01 21
- 2020-06-02 21
- 2020-06-03 21
- 2020-06-04 21
- 2020-06-05 21
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- …
day (date) >30 ✖
- 2020-05-14 21
- 2020-05-15 21
- 2020-05-16 21
- 2020-05-17 21
- 2020-05-18 21
- 2020-05-19 21
- 2020-05-20 21
- 2020-05-21 21
- 2020-05-22 21
- 2020-05-23 21
- 2020-05-24 21
- 2020-05-25 21
- 2020-05-26 21
- 2020-05-27 21
- 2020-05-28 21
- 2020-05-29 21
- 2020-05-30 21
- 2020-05-31 21
- 2020-06-01 21
- 2020-06-02 21
- 2020-06-03 21
- 2020-06-04 21
- 2020-06-05 21
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- 2020-06-12 21
- …
longitude 26 ✖
- 11.12123097 960
- 11.25588885 960
- 11.35662422 960
- 12.33845213 960
- 12.38824698 960
- 12.48366722 960
- 13.39843823 960
- 13.5188753 960
- 13.76813649 960
- 14.25084984 960
- 14.65916051 960
- 15.80514834 960
- 16.59440194 960
- 16.86736689 960
- 7.320149366 960
- 7.680687483 960
- 8.9326992 960
- 9.110616306 960
- 9.190347404 960
- 13.362356699999998 700
- 11.3417208 647
- 11.341720800000001 313
- 13.3623567 260
- 12.56738 53
- 12.0 12
- 12.5674 9
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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3761223 | 3761223 | 2020-01-31 | Italy | 2 | 0 | 0 | 1/31/2020 23:59 | |||||||
3413185 | 3413185 | 2020-02-01 | Italy | 2 | 0 | 0 | 1/31/2020 8:15 | |||||||
566716 | 566716 | 2020-02-06 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2091709 | 2091709 | 2020-02-05 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2379275 | 2379275 | 2020-02-02 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
2860589 | 2860589 | 2020-02-03 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
3471925 | 3471925 | 2020-02-04 | Italy | 2 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
107075 | 107075 | 2020-02-15 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1192494 | 1192494 | 2020-02-14 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1243396 | 1243396 | 2020-02-17 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1366087 | 1366087 | 2020-02-08 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1559701 | 1559701 | 2020-02-13 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1720090 | 1720090 | 2020-02-19 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1783122 | 1783122 | 2020-02-18 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
1888749 | 1888749 | 2020-02-16 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2263499 | 2263499 | 2020-02-20 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2567291 | 2567291 | 2020-02-12 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3089049 | 3089049 | 2020-02-10 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3197750 | 3197750 | 2020-02-11 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3222046 | 3222046 | 2020-02-07 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
3362417 | 3362417 | 2020-02-09 | Italy | 3 | 0 | 0 | 2020-02-07T17:53:02 | |||||||
2135744 | 2135744 | 2020-02-21 | Italy | 20 | 1 | 0 | 2020-02-21T23:33:06 | |||||||
1085660 | 1085660 | 2020-02-22 | Italy | 62 | 2 | 1 | 2020-02-22T23:43:02 | |||||||
3173359 | 3173359 | 2020-02-23 | Italy | 155 | 3 | 2 | 2020-02-23T23:43:02 | |||||||
3551213 | 3551213 | 2020-02-24 | Italy | 229 | 7 | 1 | 2020-02-24T23:43:01 | |||||||
479145 | 479145 | 2020-02-25 | Italy | 322 | 10 | 1 | 2020-02-25T18:55:32 | |||||||
2509760 | 2509760 | 2020-02-26 | Italy | 453 | 12 | 3 | 2020-02-26T23:43:03 | |||||||
617400 | 617400 | 2020-02-27 | Italy | 655 | 17 | 45 | 2020-02-27T23:23:02 | |||||||
2883913 | 2883913 | 2020-02-28 | Italy | 888 | 21 | 46 | 2020-02-28T20:13:09 | |||||||
3205787 | 3205787 | 2020-02-29 | Italy | 1128 | 29 | 46 | 2020-02-29T18:03:05 | |||||||
562495 | 562495 | 2020-03-01 | Italy | 1694 | 34 | 83 | 43.0 | 12.0 | 2020-03-01T23:23:02 | |||||
1152634 | 1152634 | 2020-03-02 | Italy | 2036 | 52 | 149 | 43.0 | 12.0 | 2020-03-02T20:23:16 | |||||
261018 | 261018 | 2020-03-03 | Italy | 2502 | 79 | 160 | 43.0 | 12.0 | 2020-03-03T20:03:06 | |||||
98803 | 98803 | 2020-03-04 | Italy | 3089 | 107 | 276 | 43.0 | 12.0 | 2020-03-04T19:23:03 | |||||
40133 | 40133 | 2020-03-05 | Italy | 3858 | 148 | 414 | 43.0 | 12.0 | 2020-03-05T17:43:03 | |||||
3177478 | 3177478 | 2020-03-06 | Italy | 4636 | 197 | 523 | 43.0 | 12.0 | 2020-03-06T17:33:03 | |||||
62473 | 62473 | 2020-03-07 | Italy | 5883 | 233 | 589 | 43.0 | 12.0 | 2020-03-07T17:33:03 | |||||
1527200 | 1527200 | 2020-03-08 | Italy | 7375 | 366 | 622 | 43.0 | 12.0 | 2020-03-08T18:03:04 | |||||
657684 | 657684 | 2020-03-09 | Italy | 9172 | 463 | 724 | 43.0 | 12.0 | 2020-03-09T18:13:11 | |||||
3752815 | 3752815 | 2020-03-10 | Italy | 10149 | 631 | 724 | 43.0 | 12.0 | 2020-03-10T17:53:02 | |||||
3765346 | 3765346 | 2020-03-13 | Italy | 17660 | 1266 | 1439 | 41.8719 | 12.5674 | 2020-03-11T20:00:00 | |||||
2127431 | 2127431 | 2020-03-11 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2282861 | 2282861 | 2020-03-12 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
1463462 | 1463462 | 2020-03-15 | Italy | 24747 | 1809 | 2335 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
2111087 | 2111087 | 2020-03-14 | Italy | 21157 | 1441 | 1966 | 41.8719 | 12.5674 | 2020-03-14T20:13:16 | |||||
2255113 | 2255113 | 2020-03-16 | Italy | 27980 | 2158 | 2749 | 41.8719 | 12.5674 | 2020-03-16T17:33:03 | |||||
3891307 | 3891307 | 2020-03-17 | Italy | 31506 | 2503 | 2941 | 41.8719 | 12.5674 | 2020-03-17T18:33:02 | |||||
1176876 | 1176876 | 2020-03-18 | Italy | 35713 | 2978 | 4025 | 41.8719 | 12.5674 | 2020-03-18T17:33:05 | |||||
1526872 | 1526872 | 2020-03-19 | Italy | 41035 | 3405 | 4440 | 41.8719 | 12.5674 | 2020-03-19T17:43:03 | |||||
3733921 | 3733921 | 2020-03-20 | Italy | 47021 | 4032 | 4440 | 41.8719 | 12.5674 | 2020-03-20T17:43:03 | |||||
339624 | 339624 | 2020-03-21 | Italy | 53578 | 4825 | 6072 | 41.8719 | 12.5674 | 2020-03-21T17:43:03 | |||||
2147188 | 2147188 | 2020-03-23 | Italy | 63927 | 6077 | 7432 | 50418 | 41.87194 | 12.56738 | 2020-03-23 23:19:21 | Italy | |||
1479132 | 1479132 | 2020-03-24 | Italy | 69176 | 6820 | 8326 | 54030 | 41.87194 | 12.56738 | 2020-03-24 23:37:15 | Italy | |||
1132626 | 1132626 | 2020-03-25 | Italy | 74386 | 7503 | 9362 | 57521 | 41.87194 | 12.56738 | 2020-03-25 23:33:04 | Italy | |||
919225 | 919225 | 2020-03-26 | Italy | 80589 | 8215 | 10361 | 62013 | 41.87194 | 12.56738 | 2020-03-26 23:48:18 | Italy | |||
809133 | 809133 | 2020-03-27 | Italy | 86498 | 9134 | 10950 | 66414 | 41.87194 | 12.56738 | 2020-03-27 23:23:03 | Italy | |||
3815961 | 3815961 | 2020-03-31 | Italy | 105792 | 12428 | 15729 | 77635 | 41.87194 | 12.56738 | 2020-03-31 23:43:43 | Italy | |||
3364868 | 3364868 | 2020-04-01 | Italy | 110574 | 13155 | 16847 | 80572 | 41.87194 | 12.56738 | 2020-04-01 21:58:34 | Italy | |||
3740634 | 3740634 | 2020-04-03 | Italy | 119827 | 14681 | 19758 | 85388 | 41.87194 | 12.56738 | 2020-04-03 22:46:20 | Italy | |||
589180 | 589180 | 2020-04-05 | Italy | 128948 | 15887 | 21815 | 91246 | 41.87194 | 12.56738 | 2020-04-05 23:06:26 | Italy | |||
3021810 | 3021810 | 2020-04-07 | Italy | 135586 | 17127 | 24392 | 94067 | 41.87194 | 12.56738 | 2020-04-07 23:04:29 | Italy | |||
3562135 | 3562135 | 2020-04-08 | Italy | 139422 | 17669 | 26491 | 95262 | 41.87194 | 12.56738 | 2020-04-08 22:51:39 | Italy | |||
3950028 | 3950028 | 2020-04-09 | Italy | 143626 | 18279 | 28470 | 96877 | 41.87194 | 12.56738 | 2020-04-09 23:02:19 | Italy | |||
1250291 | 1250291 | 2020-04-10 | Italy | 147577 | 18849 | 30455 | 98273 | 41.87194 | 12.56738 | 2020-04-10 22:53:48 | Italy | |||
2567106 | 2567106 | 2020-04-11 | Italy | 152271 | 19468 | 32534 | 100269 | 41.87194 | 12.56738 | 2020-04-11 22:45:13 | Italy | |||
2578269 | 2578269 | 2020-04-12 | Italy | 156363 | 19899 | 34211 | 102253 | 41.87194 | 12.56738 | 2020-04-12 23:17:00 | Italy | |||
43243 | 43243 | 2020-04-13 | Italy | 159516 | 20465 | 35435 | 103616 | 41.87194 | 12.56738 | 2020-04-13 23:07:34 | Italy | |||
3338146 | 3338146 | 2020-04-14 | Italy | 162488 | 21067 | 37130 | 104291 | 41.87194 | 12.56738 | 2020-04-14 23:33:12 | Italy | |||
860230 | 860230 | 2020-04-15 | Italy | 165155 | 21645 | 38092 | 105418 | 41.87194 | 12.56738 | 2020-04-15 22:56:32 | Italy | |||
934336 | 934336 | 2020-04-16 | Italy | 168941 | 22170 | 40164 | 106607 | 41.87194 | 12.56738 | 2020-04-16 23:30:31 | Italy | |||
50342 | 50342 | 2020-04-17 | Italy | 172434 | 22745 | 42727 | 106962 | 41.87194 | 12.56738 | 2020-04-17 23:30:32 | Italy | |||
418870 | 418870 | 2020-04-18 | Italy | 175925 | 23227 | 44927 | 107771 | 41.87194 | 12.56738 | 2020-04-18 22:32:28 | Italy | |||
1385182 | 1385182 | 2020-04-19 | Italy | 178972 | 23660 | 47055 | 108257 | 41.87194 | 12.56738 | 2020-04-19 23:40:41 | Italy | |||
2473490 | 2473490 | 2020-04-20 | Italy | 181228 | 24114 | 48877 | 108237 | 41.87194 | 12.56738 | 2020-04-20 23:36:27 | Italy | |||
522408 | 522408 | 2020-04-21 | Italy | 183957 | 24648 | 51600 | 107709 | 41.87194 | 12.56738 | 2020-04-21 23:30:30 | Italy | |||
1199342 | 1199342 | 2020-04-22 | Italy | 187327 | 25085 | 54543 | 107699 | 41.87194 | 12.56738 | 2020-04-22 23:30:32 | Italy | |||
2524892 | 2524892 | 2020-04-23 | Italy | 189973 | 25549 | 57576 | 106848 | 41.87194 | 12.56738 | 2020-04-24 03:30:31 | Italy | |||
1459303 | 1459303 | 2020-04-24 | Italy | 192994 | 25969 | 60498 | 106527 | 41.87194 | 12.56738 | 2020-04-25 06:30:33 | Italy | |||
3502902 | 3502902 | 2020-04-25 | Italy | 195351 | 26384 | 63120 | 105847 | 41.87194 | 12.56738 | 2020-04-26 02:30:31 | Italy | |||
3592553 | 3592553 | 2020-04-26 | Italy | 197675 | 26644 | 64928 | 106103 | 41.87194 | 12.56738 | 2020-04-27 02:30:33 | Italy | |||
3589375 | 3589375 | 2020-04-27 | Italy | 199414 | 26977 | 66624 | 105813 | 41.87194 | 12.56738 | 2020-04-28 02:30:32 | Italy | |||
271720 | 271720 | 2020-04-28 | Italy | 201505 | 27359 | 68941 | 105205 | 41.87194 | 12.56738 | 2020-04-29 02:32:29 | Italy | |||
137506 | 137506 | 2020-04-29 | Italy | 203591 | 27682 | 71252 | 104657 | 41.87194 | 12.56738 | 2020-04-30 02:32:27 | Italy | |||
228760 | 228760 | 2020-04-30 | Italy | 205463 | 27967 | 75945 | 101551 | 41.87194 | 12.56738 | 2020-05-01 02:32:28 | Italy | |||
1184279 | 1184279 | 2020-05-01 | Italy | 207428 | 28236 | 78249 | 100943 | 41.87194 | 12.56738 | 2020-05-02 02:32:27 | Italy | |||
2043385 | 2043385 | 2020-05-02 | Italy | 209328 | 28710 | 79914 | 100704 | 41.87194 | 12.56738 | 2020-05-03 02:32:28 | Italy | |||
2278709 | 2278709 | 2020-05-03 | Italy | 210717 | 28884 | 81654 | 100179 | 41.87194 | 12.56738 | 2020-05-04 02:32:28 | Italy | |||
3084850 | 3084850 | 2020-05-04 | Italy | 211938 | 29079 | 82879 | 99980 | 41.87194 | 12.56738 | 2020-05-05 02:32:34 | Italy | |||
1931987 | 1931987 | 2020-05-05 | Italy | 213013 | 29315 | 85231 | 98467 | 41.87194 | 12.56738 | 2020-05-06 02:32:31 | Italy | |||
2110947 | 2110947 | 2020-05-06 | Italy | 214457 | 29684 | 93245 | 91528 | 41.87194 | 12.56738 | 2020-05-07 02:32:28 | Italy | |||
3295726 | 3295726 | 2020-05-07 | Italy | 215858 | 29958 | 96276 | 89624 | 41.87194 | 12.56738 | 2020-05-08 02:32:32 | Italy | |||
114283 | 114283 | 2020-05-08 | Italy | 217185 | 30201 | 99023 | 87961 | 41.87194 | 12.56738 | 2020-05-09 02:32:35 | Italy | |||
2899234 | 2899234 | 2020-05-09 | Italy | 218268 | 30395 | 103031 | 84842 | 41.87194 | 12.56738 | 2020-05-10 02:32:30 | Italy | |||
3459693 | 3459693 | 2020-05-10 | Italy | 219070 | 30560 | 105186 | 83324 | 41.87194 | 12.56738 | 2020-05-11 02:32:30 | Italy | |||
3331078 | 3331078 | 2020-05-11 | Italy | 219814 | 30739 | 106587 | 82488 | 41.87194 | 12.56738 | 2020-05-12 03:32:27 | Italy | |||
2581544 | 2581544 | 2020-05-12 | Italy | 221216 | 30911 | 109039 | 81266 | 41.87194 | 12.56738 | 2020-05-13 03:32:26 | Italy | |||
3847337 | 3847337 | 2020-05-13 | Italy | 222104 | 31106 | 112541 | 78457 | 41.87194 | 12.56738 | 2020-05-14 03:32:28 | Italy | |||
1404348 | 1404348 | 2020-05-14 | Italy | Abruzzo | 3136 | 379 | 1275 | 1482 | 42.35122196 | 13.39843823 | 2020-05-15 02:33:02 | Abruzzo, Italy | ||
1404359 | 1404359 | 2020-05-14 | Italy | Basilicata | 389 | 27 | 235 | 127 | 40.63947052 | 15.80514834 | 2020-05-15 02:33:02 | Basilicata, Italy | ||
1404370 | 1404370 | 2020-05-14 | Italy | Calabria | 1143 | 95 | 524 | 524 | 38.90597598 | 16.59440194 | 2020-05-15 02:33:02 | Calabria, Italy |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);