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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- Abruzzo 517
- Basilicata 517
- Calabria 517
- Campania 517
- Emilia-Romagna 517
- Friuli Venezia Giulia 517
- Lazio 517
- Liguria 517
- Lombardia 517
- Marche 517
- Molise 517
- P.A. Bolzano 517
- P.A. Trento 517
- Piemonte 517
- Puglia 517
- Sardegna 517
- Sicilia 517
- Toscana 517
- Umbria 517
- Valle d'Aosta 517
- Veneto 517
country_or_region 1
- Italy · 10,961 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491564 | 1491564 | 2021-10-12 | Italy | Abruzzo | 81685 | 2550 | 0 | 42.35122196 | 13.39843823 | 2021-10-13 04:20:51 | Abruzzo, Italy | |||
1491565 | 1491565 | 2021-10-12 | Italy | Basilicata | 30464 | 620 | 0 | 40.63947052 | 15.80514834 | 2021-10-13 04:20:51 | Basilicata, Italy | |||
1491566 | 1491566 | 2021-10-12 | Italy | Calabria | 85102 | 1425 | 0 | 38.90597598 | 16.59440194 | 2021-10-13 04:20:51 | Calabria, Italy | |||
1491567 | 1491567 | 2021-10-12 | Italy | Campania | 459419 | 7993 | 0 | 40.83956555 | 14.25084984 | 2021-10-13 04:20:51 | Campania, Italy | |||
1491568 | 1491568 | 2021-10-12 | Italy | Emilia-Romagna | 426771 | 13516 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-13 04:20:51 | Emilia-Romagna, Italy | |||
1491569 | 1491569 | 2021-10-12 | Italy | Friuli Venezia Giulia | 114465 | 3829 | 0 | 45.6494354 | 13.76813649 | 2021-10-13 04:20:51 | Friuli Venezia Giulia, Italy | |||
1491570 | 1491570 | 2021-10-12 | Italy | Lazio | 387620 | 8693 | 0 | 41.89277044 | 12.48366722 | 2021-10-13 04:20:51 | Lazio, Italy | |||
1491571 | 1491571 | 2021-10-12 | Italy | Liguria | 113430 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-13 04:20:51 | Liguria, Italy | |||
1491572 | 1491572 | 2021-10-12 | Italy | Lombardia | 887200 | 34093 | 0 | 45.46679409 | 9.190347404 | 2021-10-13 04:20:51 | Lombardia, Italy | |||
1491573 | 1491573 | 2021-10-12 | Italy | Marche | 114603 | 3083 | 0 | 43.61675973 | 13.5188753 | 2021-10-13 04:20:51 | Marche, Italy | |||
1491574 | 1491574 | 2021-10-12 | Italy | Molise | 14546 | 497 | 0 | 41.55774754 | 14.65916051 | 2021-10-13 04:20:51 | Molise, Italy | |||
1491575 | 1491575 | 2021-10-12 | Italy | P.A. Bolzano | 77509 | 1197 | 0 | 46.49933453 | 11.35662422 | 2021-10-13 04:20:51 | P.A. Bolzano, Italy | |||
1491576 | 1491576 | 2021-10-12 | Italy | P.A. Trento | 48675 | 1375 | 0 | 46.06893511 | 11.12123097 | 2021-10-13 04:20:51 | P.A. Trento, Italy | |||
1491577 | 1491577 | 2021-10-12 | Italy | Piemonte | 380875 | 11781 | 0 | 45.0732745 | 7.680687483 | 2021-10-13 04:20:51 | Piemonte, Italy | |||
1491578 | 1491578 | 2021-10-12 | Italy | Puglia | 269952 | 6810 | 0 | 41.12559576 | 16.86736689 | 2021-10-13 04:20:51 | Puglia, Italy | |||
1491579 | 1491579 | 2021-10-12 | Italy | Sardegna | 75707 | 1654 | 0 | 39.21531192 | 9.110616306 | 2021-10-13 04:20:51 | Sardegna, Italy | |||
1491580 | 1491580 | 2021-10-12 | Italy | Sicilia | 302162 | 6909 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-13 04:20:51 | Sicilia, Italy | |||
1491581 | 1491581 | 2021-10-12 | Italy | Toscana | 284755 | 7216 | 0 | 43.76923077 | 11.25588885 | 2021-10-13 04:20:51 | Toscana, Italy | |||
1491582 | 1491582 | 2021-10-12 | Italy | Umbria | 64151 | 1455 | 0 | 43.10675841 | 12.38824698 | 2021-10-13 04:20:51 | Umbria, Italy | |||
1491583 | 1491583 | 2021-10-12 | Italy | Valle d'Aosta | 12213 | 474 | 0 | 45.73750286 | 7.320149366 | 2021-10-13 04:20:51 | Valle d'Aosta, Italy | |||
1491584 | 1491584 | 2021-10-12 | Italy | Veneto | 473014 | 11798 | 0 | 45.43490485 | 12.33845213 | 2021-10-13 04:20:51 | Veneto, Italy | |||
3007297 | 3007297 | 2021-10-11 | Italy | Abruzzo | 81630 | 2549 | 0 | 42.35122196 | 13.39843823 | 2021-10-12 04:21:09 | Abruzzo, Italy | |||
3007298 | 3007298 | 2021-10-11 | Italy | Basilicata | 30444 | 619 | 0 | 40.63947052 | 15.80514834 | 2021-10-12 04:21:09 | Basilicata, Italy | |||
3007299 | 3007299 | 2021-10-11 | Italy | Calabria | 84932 | 1425 | 0 | 38.90597598 | 16.59440194 | 2021-10-12 04:21:09 | Calabria, Italy | |||
3007300 | 3007300 | 2021-10-11 | Italy | Campania | 459211 | 7987 | 0 | 40.83956555 | 14.25084984 | 2021-10-12 04:21:09 | Campania, Italy | |||
3007301 | 3007301 | 2021-10-11 | Italy | Emilia-Romagna | 426620 | 13514 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-12 04:21:09 | Emilia-Romagna, Italy | |||
3007302 | 3007302 | 2021-10-11 | Italy | Friuli Venezia Giulia | 114405 | 3828 | 0 | 45.6494354 | 13.76813649 | 2021-10-12 04:21:09 | Friuli Venezia Giulia, Italy | |||
3007303 | 3007303 | 2021-10-11 | Italy | Lazio | 387399 | 8690 | 0 | 41.89277044 | 12.48366722 | 2021-10-12 04:21:09 | Lazio, Italy | |||
3007304 | 3007304 | 2021-10-11 | Italy | Liguria | 113371 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-12 04:21:09 | Liguria, Italy | |||
3007305 | 3007305 | 2021-10-11 | Italy | Lombardia | 886894 | 34090 | 0 | 45.46679409 | 9.190347404 | 2021-10-12 04:21:09 | Lombardia, Italy | |||
3007306 | 3007306 | 2021-10-11 | Italy | Marche | 114549 | 3082 | 0 | 43.61675973 | 13.5188753 | 2021-10-12 04:21:09 | Marche, Italy | |||
3007307 | 3007307 | 2021-10-11 | Italy | Molise | 14546 | 497 | 0 | 41.55774754 | 14.65916051 | 2021-10-12 04:21:09 | Molise, Italy | |||
3007308 | 3007308 | 2021-10-11 | Italy | P.A. Bolzano | 77479 | 1197 | 0 | 46.49933453 | 11.35662422 | 2021-10-12 04:21:09 | P.A. Bolzano, Italy | |||
3007309 | 3007309 | 2021-10-11 | Italy | P.A. Trento | 48652 | 1375 | 0 | 46.06893511 | 11.12123097 | 2021-10-12 04:21:09 | P.A. Trento, Italy | |||
3007310 | 3007310 | 2021-10-11 | Italy | Piemonte | 380686 | 11779 | 0 | 45.0732745 | 7.680687483 | 2021-10-12 04:21:09 | Piemonte, Italy | |||
3007311 | 3007311 | 2021-10-11 | Italy | Puglia | 269834 | 6803 | 0 | 41.12559576 | 16.86736689 | 2021-10-12 04:21:09 | Puglia, Italy | |||
3007312 | 3007312 | 2021-10-11 | Italy | Sardegna | 75664 | 1652 | 0 | 39.21531192 | 9.110616306 | 2021-10-12 04:21:09 | Sardegna, Italy | |||
3007313 | 3007313 | 2021-10-11 | Italy | Sicilia | 301889 | 6897 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-12 04:21:09 | Sicilia, Italy | |||
3007314 | 3007314 | 2021-10-11 | Italy | Toscana | 284620 | 7212 | 0 | 43.76923077 | 11.25588885 | 2021-10-12 04:21:09 | Toscana, Italy | |||
3007315 | 3007315 | 2021-10-11 | Italy | Umbria | 64128 | 1455 | 0 | 43.10675841 | 12.38824698 | 2021-10-12 04:21:09 | Umbria, Italy | |||
3007316 | 3007316 | 2021-10-11 | Italy | Valle d'Aosta | 12207 | 474 | 0 | 45.73750286 | 7.320149366 | 2021-10-12 04:21:09 | Valle d'Aosta, Italy | |||
3007317 | 3007317 | 2021-10-11 | Italy | Veneto | 472672 | 11794 | 0 | 45.43490485 | 12.33845213 | 2021-10-12 04:21:09 | Veneto, Italy | |||
423313 | 423313 | 2021-10-10 | Italy | Abruzzo | 81624 | 2549 | 0 | 42.35122196 | 13.39843823 | 2021-10-11 04:21:31 | Abruzzo, Italy | |||
423314 | 423314 | 2021-10-10 | Italy | Basilicata | 30435 | 619 | 0 | 40.63947052 | 15.80514834 | 2021-10-11 04:21:31 | Basilicata, Italy | |||
423315 | 423315 | 2021-10-10 | Italy | Calabria | 84867 | 1424 | 0 | 38.90597598 | 16.59440194 | 2021-10-11 04:21:31 | Calabria, Italy | |||
423316 | 423316 | 2021-10-10 | Italy | Campania | 459082 | 7986 | 0 | 40.83956555 | 14.25084984 | 2021-10-11 04:21:31 | Campania, Italy | |||
423317 | 423317 | 2021-10-10 | Italy | Emilia-Romagna | 426429 | 13508 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-11 04:21:31 | Emilia-Romagna, Italy | |||
423318 | 423318 | 2021-10-10 | Italy | Friuli Venezia Giulia | 114375 | 3828 | 0 | 45.6494354 | 13.76813649 | 2021-10-11 04:21:31 | Friuli Venezia Giulia, Italy | |||
423319 | 423319 | 2021-10-10 | Italy | Lazio | 387211 | 8685 | 0 | 41.89277044 | 12.48366722 | 2021-10-11 04:21:31 | Lazio, Italy | |||
423320 | 423320 | 2021-10-10 | Italy | Liguria | 113352 | 4415 | 0 | 44.41149315 | 8.9326992 | 2021-10-11 04:21:31 | Liguria, Italy | |||
423321 | 423321 | 2021-10-10 | Italy | Lombardia | 886807 | 34085 | 0 | 45.46679409 | 9.190347404 | 2021-10-11 04:21:31 | Lombardia, Italy | |||
423322 | 423322 | 2021-10-10 | Italy | Marche | 114532 | 3082 | 0 | 43.61675973 | 13.5188753 | 2021-10-11 04:21:31 | Marche, Italy | |||
423323 | 423323 | 2021-10-10 | Italy | Molise | 14546 | 497 | 0 | 41.55774754 | 14.65916051 | 2021-10-11 04:21:31 | Molise, Italy | |||
423324 | 423324 | 2021-10-10 | Italy | P.A. Bolzano | 77477 | 1196 | 0 | 46.49933453 | 11.35662422 | 2021-10-11 04:21:31 | P.A. Bolzano, Italy | |||
423325 | 423325 | 2021-10-10 | Italy | P.A. Trento | 48642 | 1375 | 0 | 46.06893511 | 11.12123097 | 2021-10-11 04:21:31 | P.A. Trento, Italy | |||
423326 | 423326 | 2021-10-10 | Italy | Piemonte | 380577 | 11778 | 0 | 45.0732745 | 7.680687483 | 2021-10-11 04:21:31 | Piemonte, Italy | |||
423327 | 423327 | 2021-10-10 | Italy | Puglia | 269758 | 6803 | 0 | 41.12559576 | 16.86736689 | 2021-10-11 04:21:31 | Puglia, Italy | |||
423328 | 423328 | 2021-10-10 | Italy | Sardegna | 75641 | 1652 | 0 | 39.21531192 | 9.110616306 | 2021-10-11 04:21:31 | Sardegna, Italy | |||
423329 | 423329 | 2021-10-10 | Italy | Sicilia | 301658 | 6892 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-11 04:21:31 | Sicilia, Italy | |||
423330 | 423330 | 2021-10-10 | Italy | Toscana | 284458 | 7206 | 0 | 43.76923077 | 11.25588885 | 2021-10-11 04:21:31 | Toscana, Italy | |||
423331 | 423331 | 2021-10-10 | Italy | Umbria | 64122 | 1455 | 0 | 43.10675841 | 12.38824698 | 2021-10-11 04:21:31 | Umbria, Italy | |||
423332 | 423332 | 2021-10-10 | Italy | Valle d'Aosta | 12207 | 474 | 0 | 45.73750286 | 7.320149366 | 2021-10-11 04:21:31 | Valle d'Aosta, Italy | |||
423333 | 423333 | 2021-10-10 | Italy | Veneto | 472516 | 11792 | 0 | 45.43490485 | 12.33845213 | 2021-10-11 04:21:31 | Veneto, Italy | |||
2876170 | 2876170 | 2021-10-09 | Italy | Abruzzo | 81605 | 2549 | 0 | 42.35122196 | 13.39843823 | 2021-10-10 04:21:38 | Abruzzo, Italy | |||
2876171 | 2876171 | 2021-10-09 | Italy | Basilicata | 30417 | 618 | 0 | 40.63947052 | 15.80514834 | 2021-10-10 04:21:38 | Basilicata, Italy | |||
2876172 | 2876172 | 2021-10-09 | Italy | Calabria | 84778 | 1424 | 0 | 38.90597598 | 16.59440194 | 2021-10-10 04:21:38 | Calabria, Italy | |||
2876173 | 2876173 | 2021-10-09 | Italy | Campania | 458837 | 7984 | 0 | 40.83956555 | 14.25084984 | 2021-10-10 04:21:38 | Campania, Italy | |||
2876174 | 2876174 | 2021-10-09 | Italy | Emilia-Romagna | 426190 | 13504 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-10 04:21:38 | Emilia-Romagna, Italy | |||
2876175 | 2876175 | 2021-10-09 | Italy | Friuli Venezia Giulia | 114338 | 3825 | 0 | 45.6494354 | 13.76813649 | 2021-10-10 04:21:38 | Friuli Venezia Giulia, Italy | |||
2876176 | 2876176 | 2021-10-09 | Italy | Lazio | 386990 | 8682 | 0 | 41.89277044 | 12.48366722 | 2021-10-10 04:21:38 | Lazio, Italy | |||
2876177 | 2876177 | 2021-10-09 | Italy | Liguria | 113282 | 4415 | 0 | 44.41149315 | 8.9326992 | 2021-10-10 04:21:38 | Liguria, Italy | |||
2876178 | 2876178 | 2021-10-09 | Italy | Lombardia | 886529 | 34083 | 0 | 45.46679409 | 9.190347404 | 2021-10-10 04:21:38 | Lombardia, Italy | |||
2876179 | 2876179 | 2021-10-09 | Italy | Marche | 114441 | 3082 | 0 | 43.61675973 | 13.5188753 | 2021-10-10 04:21:38 | Marche, Italy | |||
2876180 | 2876180 | 2021-10-09 | Italy | Molise | 14540 | 497 | 0 | 41.55774754 | 14.65916051 | 2021-10-10 04:21:38 | Molise, Italy | |||
2876181 | 2876181 | 2021-10-09 | Italy | P.A. Bolzano | 77431 | 1195 | 0 | 46.49933453 | 11.35662422 | 2021-10-10 04:21:38 | P.A. Bolzano, Italy | |||
2876182 | 2876182 | 2021-10-09 | Italy | P.A. Trento | 48607 | 1375 | 0 | 46.06893511 | 11.12123097 | 2021-10-10 04:21:38 | P.A. Trento, Italy | |||
2876183 | 2876183 | 2021-10-09 | Italy | Piemonte | 380463 | 11778 | 0 | 45.0732745 | 7.680687483 | 2021-10-10 04:21:38 | Piemonte, Italy | |||
2876184 | 2876184 | 2021-10-09 | Italy | Puglia | 269696 | 6802 | 0 | 41.12559576 | 16.86736689 | 2021-10-10 04:21:38 | Puglia, Italy | |||
2876185 | 2876185 | 2021-10-09 | Italy | Sardegna | 75628 | 1651 | 0 | 39.21531192 | 9.110616306 | 2021-10-10 04:21:38 | Sardegna, Italy | |||
2876186 | 2876186 | 2021-10-09 | Italy | Sicilia | 301408 | 6889 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-10 04:21:38 | Sicilia, Italy | |||
2876187 | 2876187 | 2021-10-09 | Italy | Toscana | 284250 | 7202 | 0 | 43.76923077 | 11.25588885 | 2021-10-10 04:21:38 | Toscana, Italy | |||
2876188 | 2876188 | 2021-10-09 | Italy | Umbria | 64110 | 1455 | 0 | 43.10675841 | 12.38824698 | 2021-10-10 04:21:38 | Umbria, Italy | |||
2876189 | 2876189 | 2021-10-09 | Italy | Valle d'Aosta | 12206 | 474 | 0 | 45.73750286 | 7.320149366 | 2021-10-10 04:21:38 | Valle d'Aosta, Italy | |||
2876190 | 2876190 | 2021-10-09 | Italy | Veneto | 472292 | 11790 | 0 | 45.43490485 | 12.33845213 | 2021-10-10 04:21:38 | Veneto, Italy | |||
2959336 | 2959336 | 2021-10-08 | Italy | Abruzzo | 81557 | 2548 | 0 | 42.35122196 | 13.39843823 | 2021-10-09 04:21:34 | Abruzzo, Italy | |||
2959337 | 2959337 | 2021-10-08 | Italy | Basilicata | 30392 | 617 | 0 | 40.63947052 | 15.80514834 | 2021-10-09 04:21:34 | Basilicata, Italy | |||
2959338 | 2959338 | 2021-10-08 | Italy | Calabria | 84642 | 1423 | 0 | 38.90597598 | 16.59440194 | 2021-10-09 04:21:34 | Calabria, Italy | |||
2959339 | 2959339 | 2021-10-08 | Italy | Campania | 458568 | 7977 | 0 | 40.83956555 | 14.25084984 | 2021-10-09 04:21:34 | Campania, Italy | |||
2959340 | 2959340 | 2021-10-08 | Italy | Emilia-Romagna | 425923 | 13499 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-09 04:21:34 | Emilia-Romagna, Italy | |||
2959341 | 2959341 | 2021-10-08 | Italy | Friuli Venezia Giulia | 114283 | 3825 | 0 | 45.6494354 | 13.76813649 | 2021-10-09 04:21:34 | Friuli Venezia Giulia, Italy | |||
2959342 | 2959342 | 2021-10-08 | Italy | Lazio | 386760 | 8679 | 0 | 41.89277044 | 12.48366722 | 2021-10-09 04:21:34 | Lazio, Italy | |||
2959343 | 2959343 | 2021-10-08 | Italy | Liguria | 113217 | 4414 | 0 | 44.41149315 | 8.9326992 | 2021-10-09 04:21:34 | Liguria, Italy | |||
2959344 | 2959344 | 2021-10-08 | Italy | Lombardia | 886245 | 34078 | 0 | 45.46679409 | 9.190347404 | 2021-10-09 04:21:34 | Lombardia, Italy | |||
2959345 | 2959345 | 2021-10-08 | Italy | Marche | 114392 | 3079 | 0 | 43.61675973 | 13.5188753 | 2021-10-09 04:21:34 | Marche, Italy | |||
2959346 | 2959346 | 2021-10-08 | Italy | Molise | 14539 | 497 | 0 | 41.55774754 | 14.65916051 | 2021-10-09 04:21:34 | Molise, Italy | |||
2959347 | 2959347 | 2021-10-08 | Italy | P.A. Bolzano | 77379 | 1195 | 0 | 46.49933453 | 11.35662422 | 2021-10-09 04:21:34 | P.A. Bolzano, Italy | |||
2959348 | 2959348 | 2021-10-08 | Italy | P.A. Trento | 48585 | 1374 | 0 | 46.06893511 | 11.12123097 | 2021-10-09 04:21:34 | P.A. Trento, Italy | |||
2959349 | 2959349 | 2021-10-08 | Italy | Piemonte | 380267 | 11776 | 0 | 45.0732745 | 7.680687483 | 2021-10-09 04:21:34 | Piemonte, Italy | |||
2959350 | 2959350 | 2021-10-08 | Italy | Puglia | 269578 | 6801 | 0 | 41.12559576 | 16.86736689 | 2021-10-09 04:21:34 | Puglia, Italy | |||
2959351 | 2959351 | 2021-10-08 | Italy | Sardegna | 75609 | 1650 | 0 | 39.21531192 | 9.110616306 | 2021-10-09 04:21:34 | Sardegna, 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]);