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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- Campania 287
- Lombardia 250
- Basilicata 224
- Lazio 210
- Calabria 205
- Umbria 180
- P.A. Bolzano 170
- Emilia-Romagna 169
- Liguria 159
- Veneto 155
- Friuli Venezia Giulia 153
- Marche 147
- P.A. Trento 139
- Puglia 138
- Abruzzo 135
- Molise 134
- Piemonte 134
- Valle d'Aosta 118
- Toscana 107
- Sicilia 85
- Sardegna 49
country_or_region 1
- Italy · 3,377 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1510837 | 1510837 | 2020-06-22 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-23 04:33:22 | Valle d'Aosta, Italy | ||
1522643 | 1522643 | 2020-06-23 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-24 04:33:28 | Valle d'Aosta, Italy | ||
2158535 | 2158535 | 2020-07-14 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-15 04:34:39 | Basilicata, Italy | ||
2222532 | 2222532 | 2020-07-08 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-09 04:34:23 | Basilicata, Italy | ||
2222954 | 2222954 | 2020-07-08 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-09 04:34:23 | Valle d'Aosta, Italy | ||
2625318 | 2625318 | 2020-06-25 | Italy | Valle d'Aosta | 1194 | 146 | 1043 | 5 | 45.73750286 | 7.320149366 | 2020-06-26 04:33:43 | Valle d'Aosta, Italy | ||
2685123 | 2685123 | 2020-07-06 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-07 04:34:00 | Valle d'Aosta, Italy | ||
2708404 | 2708404 | 2020-07-17 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-18 04:34:45 | Basilicata, Italy | ||
2747891 | 2747891 | 2020-07-15 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-16 04:44:59 | Basilicata, Italy | ||
3205102 | 3205102 | 2020-07-18 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-19 04:34:58 | Basilicata, Italy | ||
3237331 | 3237331 | 2020-07-10 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-11 04:34:26 | Basilicata, Italy | ||
3237754 | 3237754 | 2020-07-10 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-11 04:34:26 | Valle d'Aosta, Italy | ||
3249576 | 3249576 | 2020-06-21 | Italy | Valle d'Aosta | 1193 | 146 | 1042 | 5 | 45.73750286 | 7.320149366 | 2020-06-22 04:33:20 | Valle d'Aosta, Italy | ||
3435833 | 3435833 | 2020-07-11 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-12 04:34:30 | Basilicata, Italy | ||
3491176 | 3491176 | 2020-07-13 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-14 04:34:46 | Basilicata, Italy | ||
3737438 | 3737438 | 2020-07-12 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-13 04:43:04 | Basilicata, Italy | ||
625868 | 625868 | 2021-07-10 | Italy | P.A. Trento | 45810 | 1363 | 44397 | 50 | 46.06893511 | 11.12123097 | 2021-07-11 04:21:43 | P.A. Trento, Italy | ||
753323 | 753323 | 2020-08-01 | Italy | Basilicata | 452 | 28 | 374 | 50 | 40.63947052 | 15.80514834 | 2020-08-02 04:34:47 | Basilicata, Italy | ||
2864085 | 2864085 | 2020-06-10 | Italy | Sardegna | 1361 | 131 | 1180 | 50 | 39.21531192 | 9.110616306 | 2020-06-11 03:33:41 | Sardegna, Italy | ||
2974537 | 2974537 | 2020-06-30 | Italy | P.A. Trento | 4863 | 405 | 4408 | 50 | 46.06893511 | 11.12123097 | 2020-07-01 04:33:52 | P.A. Trento, Italy | ||
3264488 | 3264488 | 2020-07-31 | Italy | Basilicata | 452 | 28 | 374 | 50 | 40.63947052 | 15.80514834 | 2020-08-01 04:36:27 | Basilicata, Italy | ||
1901164 | 1901164 | 2020-12-18 | Italy | Valle d'Aosta | 6986 | 365 | 6121 | 500 | 45.73750286 | 7.320149366 | 2020-12-19 05:27:52 | Valle d'Aosta, Italy | ||
2606006 | 2606006 | 2020-09-24 | Italy | Calabria | 1896 | 98 | 1298 | 500 | 38.90597598 | 16.59440194 | 2020-09-25 04:23:00 | Calabria, Italy | ||
2614030 | 2614030 | 2020-09-26 | Italy | Umbria | 2353 | 85 | 1768 | 500 | 43.10675841 | 12.38824698 | 2020-09-27 04:23:00 | Umbria, Italy | ||
3308188 | 3308188 | 2021-01-13 | Italy | Liguria | 64671 | 3064 | 56605 | 5002 | 44.41149315 | 8.9326992 | 2021-01-14 05:22:32 | Liguria, Italy | ||
2983236 | 2983236 | 2021-04-10 | Italy | Basilicata | 20735 | 482 | 15250 | 5003 | 40.63947052 | 15.80514834 | 2021-04-11 04:20:56 | Basilicata, Italy | ||
1684490 | 1684490 | 2021-02-02 | Italy | P.A. Bolzano | 41122 | 880 | 35234 | 5008 | 46.49933453 | 11.35662422 | 2021-02-03 05:22:52 | P.A. Bolzano, Italy | ||
3659592 | 3659592 | 2021-07-11 | Italy | Veneto | 426413 | 11621 | 409784 | 5008 | 45.43490485 | 12.33845213 | 2021-07-12 04:21:34 | Veneto, Italy | ||
666268 | 666268 | 2020-09-16 | Italy | P.A. Trento | 5573 | 405 | 4667 | 501 | 46.06893511 | 11.12123097 | 2020-09-17 04:22:00 | P.A. Trento, Italy | ||
2581978 | 2581978 | 2020-09-27 | Italy | Umbria | 2374 | 85 | 1788 | 501 | 43.10675841 | 12.38824698 | 2020-09-28 04:23:00 | Umbria, Italy | ||
2785000 | 2785000 | 2020-11-13 | Italy | Toscana | 74330 | 1793 | 22408 | 50129 | 43.76923077 | 11.25588885 | 2020-11-14 05:25:37 | Toscana, Italy | ||
1806728 | 1806728 | 2021-05-27 | Italy | Friuli Venezia Giulia | 106867 | 3784 | 98069 | 5014 | 45.6494354 | 13.76813649 | 2021-05-28 04:20:36 | Friuli Venezia Giulia, Italy | ||
2211653 | 2211653 | 2021-01-30 | Italy | Lombardia | 536616 | 27074 | 459401 | 50141 | 45.46679409 | 9.190347404 | 2021-01-31 05:22:42 | Lombardia, Italy | ||
2283411 | 2283411 | 2021-02-14 | Italy | Liguria | 73815 | 3515 | 65285 | 5015 | 44.41149315 | 8.9326992 | 2021-02-15 05:24:49 | Liguria, Italy | ||
3710131 | 3710131 | 2021-04-03 | Italy | Puglia | 199567 | 4896 | 144505 | 50166 | 41.12559576 | 16.86736689 | 2021-04-04 04:20:49 | Puglia, Italy | ||
2708845 | 2708845 | 2020-07-17 | Italy | Veneto | 19525 | 2047 | 16976 | 502 | 45.43490485 | 12.33845213 | 2020-07-18 04:34:45 | Veneto, Italy | ||
3061403 | 3061403 | 2020-06-13 | Italy | Toscana | 10172 | 1082 | 8588 | 502 | 43.76923077 | 11.25588885 | 2020-06-14 03:33:15 | Toscana, Italy | ||
1728464 | 1728464 | 2020-11-08 | Italy | Calabria | 7465 | 140 | 2305 | 5020 | 38.90597598 | 16.59440194 | 2020-11-09 05:25:45 | Calabria, Italy | ||
388202 | 388202 | 2021-04-04 | Italy | Basilicata | 20018 | 452 | 14544 | 5022 | 40.63947052 | 15.80514834 | 2021-04-05 04:20:35 | Basilicata, Italy | ||
605668 | 605668 | 2021-04-09 | Italy | Basilicata | 20564 | 479 | 15062 | 5023 | 40.63947052 | 15.80514834 | 2021-04-10 04:20:59 | Basilicata, Italy | ||
272153 | 272153 | 2020-11-10 | Italy | Veneto | 84255 | 2643 | 31362 | 50250 | 45.43490485 | 12.33845213 | 2020-11-11 05:25:30 | Veneto, Italy | ||
774333 | 774333 | 2021-01-12 | Italy | Liguria | 64276 | 3046 | 56202 | 5028 | 44.41149315 | 8.9326992 | 2021-01-13 05:22:15 | Liguria, Italy | ||
613680 | 613680 | 2021-02-08 | Italy | Puglia | 129467 | 3422 | 75760 | 50285 | 41.12559576 | 16.86736689 | 2021-02-09 05:23:30 | Puglia, Italy | ||
754280 | 754280 | 2020-10-28 | Italy | Abruzzo | 9193 | 534 | 3630 | 5029 | 42.35122196 | 13.39843823 | 2020-10-29 04:24:49 | Abruzzo, Italy | ||
2426899 | 2426899 | 2021-01-23 | Italy | Umbria | 33822 | 732 | 28061 | 5029 | 43.10675841 | 12.38824698 | 2021-01-24 05:22:35 | Umbria, Italy | ||
1219552 | 1219552 | 2021-03-27 | Italy | Lazio | 278815 | 6515 | 222009 | 50291 | 41.89277044 | 12.48366722 | 2021-03-28 05:28:10 | Lazio, Italy | ||
1744536 | 1744536 | 2021-03-20 | Italy | Valle d'Aosta | 8575 | 419 | 7653 | 503 | 45.73750286 | 7.320149366 | 2021-03-21 05:25:44 | Valle d'Aosta, Italy | ||
3054188 | 3054188 | 2021-05-13 | Italy | Valle d'Aosta | 11311 | 466 | 10342 | 503 | 45.73750286 | 7.320149366 | 2021-05-14 04:20:41 | Valle d'Aosta, Italy | ||
1616225 | 1616225 | 2021-03-05 | Italy | Emilia-Romagna | 273376 | 10721 | 212341 | 50314 | 44.49436681 | 11.3417208 | 2021-03-06 04:23:41 | Emilia-Romagna, Italy | ||
2567660 | 2567660 | 2021-01-25 | Italy | Umbria | 34135 | 746 | 28357 | 5032 | 43.10675841 | 12.38824698 | 2021-01-26 05:22:02 | Umbria, Italy | ||
3480297 | 3480297 | 2020-10-26 | Italy | Lombardia | 157933 | 17252 | 90356 | 50325 | 45.46679409 | 9.190347404 | 2020-10-27 04:24:45 | Lombardia, Italy | ||
3515388 | 3515388 | 2021-01-15 | Italy | Liguria | 65214 | 3084 | 57096 | 5034 | 44.41149315 | 8.9326992 | 2021-01-16 05:22:40 | Liguria, Italy | ||
3675637 | 3675637 | 2021-05-04 | Italy | Liguria | 100133 | 4210 | 90886 | 5037 | 44.41149315 | 8.9326992 | 2021-05-05 04:20:43 | Liguria, Italy | ||
79067 | 79067 | 2020-10-14 | Italy | Basilicata | 1075 | 37 | 534 | 504 | 40.63947052 | 15.80514834 | 2020-10-15 04:24:28 | Basilicata, Italy | ||
1306138 | 1306138 | 2021-07-27 | Italy | Friuli Venezia Giulia | 107680 | 3789 | 103387 | 504 | 45.6494354 | 13.76813649 | 2021-07-28 04:21:39 | Friuli Venezia Giulia, Italy | ||
2147188 | 2147188 | 2020-03-23 | Italy | 63927 | 6077 | 7432 | 50418 | 41.87194 | 12.56738 | 2020-03-23 23:19:21 | Italy | |||
2410836 | 2410836 | 2021-04-19 | Italy | Puglia | 220815 | 5484 | 164905 | 50426 | 41.12559576 | 16.86736689 | 2021-04-20 04:20:41 | Puglia, Italy | ||
3643549 | 3643549 | 2021-03-30 | Italy | Umbria | 50746 | 1252 | 44449 | 5045 | 43.10675841 | 12.38824698 | 2021-03-31 04:26:25 | Umbria, Italy | ||
3003297 | 3003297 | 2021-04-06 | Italy | Puglia | 202347 | 5001 | 146892 | 50454 | 41.12559576 | 16.86736689 | 2021-04-07 04:20:53 | Puglia, Italy | ||
2410828 | 2410828 | 2021-04-19 | Italy | Lazio | 311428 | 7328 | 253642 | 50458 | 41.89277044 | 12.48366722 | 2021-04-20 04:20:41 | Lazio, Italy | ||
3801879 | 3801879 | 2020-10-05 | Italy | Emilia-Romagna | 36089 | 4487 | 26556 | 5046 | 44.49436681 | 11.3417208 | 2020-10-06 04:23:33 | Emilia-Romagna, Italy | ||
954847 | 954847 | 2021-04-25 | Italy | Emilia-Romagna | 364782 | 12784 | 301517 | 50481 | 44.49436681 | 11.3417208 | 2021-04-26 04:21:04 | Emilia-Romagna, Italy | ||
237226 | 237226 | 2021-01-18 | Italy | Liguria | 66026 | 3128 | 57849 | 5049 | 44.41149315 | 8.9326992 | 2021-01-19 05:22:15 | Liguria, Italy | ||
1404448 | 1404448 | 2020-05-14 | Italy | P.A. Trento | 4315 | 448 | 3362 | 505 | 46.06893511 | 11.12123097 | 2020-05-15 02:33:02 | P.A. Trento, Italy | ||
1510625 | 1510625 | 2020-06-22 | Italy | Marche | 6774 | 994 | 5275 | 505 | 43.61675973 | 13.5188753 | 2020-06-23 04:33:22 | Marche, Italy | ||
2653749 | 2653749 | 2020-09-23 | Italy | Calabria | 1887 | 98 | 1284 | 505 | 38.90597598 | 16.59440194 | 2020-09-24 04:23:00 | Calabria, Italy | ||
2991264 | 2991264 | 2020-08-24 | Italy | Puglia | 5070 | 555 | 4010 | 505 | 41.12559576 | 16.86736689 | 2020-08-25 04:28:02 | Puglia, Italy | ||
3276196 | 3276196 | 2020-05-15 | Italy | Calabria | 1144 | 95 | 544 | 505 | 38.90597598 | 16.59440194 | 2020-05-16 02:32:19 | Calabria, Italy | ||
1338260 | 1338260 | 2021-02-15 | Italy | Liguria | 74009 | 3522 | 65436 | 5051 | 44.41149315 | 8.9326992 | 2021-02-16 05:24:38 | Liguria, Italy | ||
562965 | 562965 | 2021-06-22 | Italy | Veneto | 425113 | 11609 | 408452 | 5052 | 45.43490485 | 12.33845213 | 2021-06-23 04:21:46 | Veneto, Italy | ||
3785887 | 3785887 | 2020-10-11 | Italy | Piemonte | 38503 | 4177 | 29270 | 5056 | 45.0732745 | 7.680687483 | 2020-10-12 04:23:45 | Piemonte, Italy | ||
2915165 | 2915165 | 2020-11-14 | Italy | Emilia-Romagna | 85699 | 5008 | 30129 | 50562 | 44.49436681 | 11.3417208 | 2020-11-15 05:26:53 | Emilia-Romagna, Italy | ||
2171526 | 2171526 | 2020-09-09 | Italy | Abruzzo | 3921 | 472 | 2943 | 506 | 42.35122196 | 13.39843823 | 2020-09-10 04:29:01 | Abruzzo, Italy | ||
1452580 | 1452580 | 2020-10-27 | Italy | Sardegna | 8164 | 199 | 2904 | 5061 | 39.21531192 | 9.110616306 | 2020-10-28 04:24:39 | Sardegna, Italy | ||
2283412 | 2283412 | 2021-02-14 | Italy | Lombardia | 563078 | 27781 | 484680 | 50617 | 45.46679409 | 9.190347404 | 2021-02-15 05:24:49 | Lombardia, Italy | ||
805441 | 805441 | 2020-06-01 | Italy | Piemonte | 30658 | 3876 | 21720 | 5062 | 45.0732745 | 7.680687483 | 2020-06-02 02:33:08 | Piemonte, Italy | ||
1310152 | 1310152 | 2021-05-26 | Italy | Friuli Venezia Giulia | 106834 | 3782 | 97989 | 5063 | 45.6494354 | 13.76813649 | 2021-05-27 04:20:59 | Friuli Venezia Giulia, Italy | ||
1535924 | 1535924 | 2021-03-28 | Italy | Umbria | 50511 | 1247 | 44201 | 5063 | 43.10675841 | 12.38824698 | 2021-03-29 04:28:35 | Umbria, Italy | ||
2548859 | 2548859 | 2021-04-15 | Italy | Lazio | 306499 | 7201 | 248667 | 50631 | 41.89277044 | 12.48366722 | 2021-04-16 04:20:46 | Lazio, Italy | ||
1177479 | 1177479 | 2020-10-22 | Italy | Liguria | 20581 | 1673 | 13842 | 5066 | 44.41149315 | 8.9326992 | 2020-10-23 04:24:46 | Liguria, Italy | ||
2653750 | 2653750 | 2020-09-23 | Italy | Campania | 10907 | 457 | 5383 | 5067 | 40.83956555 | 14.25084984 | 2020-09-24 04:23:00 | Campania, Italy | ||
3054178 | 3054178 | 2021-05-13 | Italy | Marche | 100408 | 2981 | 92358 | 5069 | 43.61675973 | 13.5188753 | 2021-05-14 04:20:41 | Marche, Italy | ||
1350313 | 1350313 | 2020-11-24 | Italy | Toscana | 96990 | 2311 | 43973 | 50706 | 43.76923077 | 11.25588885 | 2020-11-25 05:27:20 | Toscana, Italy | ||
2498000 | 2498000 | 2020-11-03 | Italy | Campania | 65432 | 724 | 13989 | 50719 | 40.83956555 | 14.25084984 | 2020-11-04 05:25:09 | Campania, Italy | ||
2247387 | 2247387 | 2021-04-07 | Italy | Puglia | 203602 | 5044 | 147829 | 50729 | 41.12559576 | 16.86736689 | 2021-04-08 04:21:13 | Puglia, Italy | ||
2426885 | 2426885 | 2021-01-23 | Italy | Emilia-Romagna | 209235 | 9084 | 149419 | 50732 | 44.49436681 | 11.3417208 | 2021-01-24 05:22:35 | Emilia-Romagna, Italy | ||
3879561 | 3879561 | 2021-01-14 | Italy | Liguria | 64960 | 3074 | 56812 | 5074 | 44.41149315 | 8.9326992 | 2021-01-15 05:22:24 | Liguria, Italy | ||
1857990 | 1857990 | 2021-02-25 | Italy | Liguria | 77028 | 3615 | 68338 | 5075 | 44.41149315 | 8.9326992 | 2021-02-26 05:22:40 | Liguria, Italy | ||
2645745 | 2645745 | 2021-04-08 | Italy | Puglia | 205576 | 5095 | 149726 | 50755 | 41.12559576 | 16.86736689 | 2021-04-09 04:21:13 | Puglia, Italy | ||
3129505 | 3129505 | 2021-04-18 | Italy | Lazio | 310478 | 7290 | 252398 | 50790 | 41.89277044 | 12.48366722 | 2021-04-19 04:20:57 | Lazio, Italy | ||
1515390 | 1515390 | 2020-09-28 | Italy | Umbria | 2385 | 85 | 1792 | 508 | 43.10675841 | 12.38824698 | 2020-09-29 04:23:42 | Umbria, Italy | ||
2812729 | 2812729 | 2020-09-25 | Italy | Calabria | 1906 | 98 | 1300 | 508 | 38.90597598 | 16.59440194 | 2020-09-26 04:23:00 | Calabria, Italy | ||
3476295 | 3476295 | 2021-07-22 | Italy | Lazio | 351937 | 8389 | 338467 | 5081 | 41.89277044 | 12.48366722 | 2021-07-23 04:21:29 | Lazio, Italy | ||
3741079 | 3741079 | 2021-07-12 | Italy | Veneto | 426489 | 11622 | 409786 | 5081 | 45.43490485 | 12.33845213 | 2021-07-13 04:21:18 | Veneto, Italy | ||
190054 | 190054 | 2021-01-11 | Italy | Liguria | 64000 | 3018 | 55900 | 5082 | 44.41149315 | 8.9326992 | 2021-01-12 05:22:15 | Liguria, Italy | ||
982933 | 982933 | 2021-04-17 | Italy | Lazio | 309351 | 7265 | 251258 | 50828 | 41.89277044 | 12.48366722 | 2021-04-18 04:20:41 | Lazio, Italy | ||
2689680 | 2689680 | 2020-10-08 | Italy | Veneto | 29909 | 2206 | 22620 | 5083 | 45.43490485 | 12.33845213 | 2020-10-09 04:23:59 | Veneto, Italy | ||
860673 | 860673 | 2020-12-11 | Italy | Umbria | 25834 | 507 | 20238 | 5089 | 43.10675841 | 12.38824698 | 2020-12-12 05:26:19 | Umbria, Italy | ||
3060956 | 3060956 | 2020-06-13 | Italy | Abruzzo | 3275 | 454 | 2312 | 509 | 42.35122196 | 13.39843823 | 2020-06-14 03:33:15 | Abruzzo, Italy | ||
3161599 | 3161599 | 2020-09-06 | Italy | Abruzzo | 3891 | 472 | 2910 | 509 | 42.35122196 | 13.39843823 | 2020-09-07 04:28:30 | Abruzzo, 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]);