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 729
- Basilicata 729
- Calabria 729
- Campania 729
- Emilia-Romagna 729
- Friuli Venezia Giulia 729
- Lazio 729
- Liguria 729
- Lombardia 729
- Marche 729
- Molise 729
- P.A. Bolzano 729
- P.A. Trento 729
- Piemonte 729
- Puglia 729
- Sardegna 729
- Sicilia 729
- Toscana 729
- Umbria 729
- Valle d'Aosta 729
- Veneto 729
country_or_region 1
- Italy · 15,413 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533360 | 2533360 | 2022-05-12 | Italy | Abruzzo | 391588 | 3258 | 0 | 42.35122196 | 13.39843823 | 2022-05-13 04:20:51 | Abruzzo, Italy | |||
2533361 | 2533361 | 2022-05-12 | Italy | Basilicata | 133101 | 906 | 0 | 40.63947052 | 15.80514834 | 2022-05-13 04:20:51 | Basilicata, Italy | |||
2533362 | 2533362 | 2022-05-12 | Italy | Calabria | 374647 | 2545 | 0 | 38.90597598 | 16.59440194 | 2022-05-13 04:20:51 | Calabria, Italy | |||
2533363 | 2533363 | 2022-05-12 | Italy | Campania | 1660375 | 10392 | 0 | 40.83956555 | 14.25084984 | 2022-05-13 04:20:51 | Campania, Italy | |||
2533364 | 2533364 | 2022-05-12 | Italy | Emilia-Romagna | 1449920 | 16767 | 0 | 44.49436681 | 11.3417208 | 2022-05-13 04:20:51 | Emilia-Romagna, Italy | |||
2533365 | 2533365 | 2022-05-12 | Italy | Friuli Venezia Giulia | 371718 | 5057 | 0 | 45.6494354 | 13.76813649 | 2022-05-13 04:20:51 | Friuli Venezia Giulia, Italy | |||
2533366 | 2533366 | 2022-05-12 | Italy | Lazio | 1528501 | 11217 | 0 | 41.89277044 | 12.48366722 | 2022-05-13 04:20:51 | Lazio, Italy | |||
2533367 | 2533367 | 2022-05-12 | Italy | Liguria | 438795 | 5299 | 0 | 44.41149315 | 8.9326992 | 2022-05-13 04:20:51 | Liguria, Italy | |||
2533368 | 2533368 | 2022-05-12 | Italy | Lombardia | 2831859 | 40222 | 0 | 45.46679409 | 9.190347404 | 2022-05-13 04:20:51 | Lombardia, Italy | |||
2533369 | 2533369 | 2022-05-12 | Italy | Marche | 460176 | 3864 | 0 | 43.61675973 | 13.5188753 | 2022-05-13 04:20:51 | Marche, Italy | |||
2533370 | 2533370 | 2022-05-12 | Italy | Molise | 63243 | 622 | 0 | 41.55774754 | 14.65916051 | 2022-05-13 04:20:51 | Molise, Italy | |||
2533371 | 2533371 | 2022-05-12 | Italy | P.A. Bolzano | 214673 | 1469 | 0 | 46.49933453 | 11.35662422 | 2022-05-13 04:20:51 | P.A. Bolzano, Italy | |||
2533372 | 2533372 | 2022-05-12 | Italy | P.A. Trento | 164617 | 1560 | 0 | 46.06893511 | 11.12123097 | 2022-05-13 04:20:51 | P.A. Trento, Italy | |||
2533373 | 2533373 | 2022-05-12 | Italy | Piemonte | 1171535 | 13379 | 0 | 45.0732745 | 7.680687483 | 2022-05-13 04:20:51 | Piemonte, Italy | |||
2533374 | 2533374 | 2022-05-12 | Italy | Puglia | 1102284 | 8377 | 0 | 41.12559576 | 16.86736689 | 2022-05-13 04:20:51 | Puglia, Italy | |||
2533375 | 2533375 | 2022-05-12 | Italy | Sardegna | 294931 | 2399 | 0 | 39.21531192 | 9.110616306 | 2022-05-13 04:20:51 | Sardegna, Italy | |||
2533376 | 2533376 | 2022-05-12 | Italy | Sicilia | 1148469 | 10737 | 0 | 38.11569725 | 13.3623567 | 2022-05-13 04:20:51 | Sicilia, Italy | |||
2533377 | 2533377 | 2022-05-12 | Italy | Toscana | 1124848 | 9970 | 0 | 43.76923077 | 11.25588885 | 2022-05-13 04:20:51 | Toscana, Italy | |||
2533378 | 2533378 | 2022-05-12 | Italy | Umbria | 277339 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-13 04:20:51 | Umbria, Italy | |||
2533379 | 2533379 | 2022-05-12 | Italy | Valle d'Aosta | 35833 | 534 | 0 | 45.73750286 | 7.320149366 | 2022-05-13 04:20:51 | Valle d'Aosta, Italy | |||
2533380 | 2533380 | 2022-05-12 | Italy | Veneto | 1716332 | 14563 | 0 | 45.43490485 | 12.33845213 | 2022-05-13 04:20:51 | Veneto, Italy | |||
3444806 | 3444806 | 2022-05-11 | Italy | Abruzzo | 390106 | 3255 | 0 | 42.35122196 | 13.39843823 | 2022-05-12 04:20:54 | Abruzzo, Italy | |||
3444807 | 3444807 | 2022-05-11 | Italy | Basilicata | 132701 | 905 | 0 | 40.63947052 | 15.80514834 | 2022-05-12 04:20:54 | Basilicata, Italy | |||
3444808 | 3444808 | 2022-05-11 | Italy | Calabria | 373435 | 2544 | 0 | 38.90597598 | 16.59440194 | 2022-05-12 04:20:54 | Calabria, Italy | |||
3444809 | 3444809 | 2022-05-11 | Italy | Campania | 1655642 | 10383 | 0 | 40.83956555 | 14.25084984 | 2022-05-12 04:20:54 | Campania, Italy | |||
3444810 | 3444810 | 2022-05-11 | Italy | Emilia-Romagna | 1446347 | 16751 | 0 | 44.49436681 | 11.3417208 | 2022-05-12 04:20:54 | Emilia-Romagna, Italy | |||
3444811 | 3444811 | 2022-05-11 | Italy | Friuli Venezia Giulia | 370923 | 5055 | 0 | 45.6494354 | 13.76813649 | 2022-05-12 04:20:54 | Friuli Venezia Giulia, Italy | |||
3444812 | 3444812 | 2022-05-11 | Italy | Lazio | 1524672 | 11210 | 0 | 41.89277044 | 12.48366722 | 2022-05-12 04:20:54 | Lazio, Italy | |||
3444813 | 3444813 | 2022-05-11 | Italy | Liguria | 437808 | 5299 | 0 | 44.41149315 | 8.9326992 | 2022-05-12 04:20:54 | Liguria, Italy | |||
3444814 | 3444814 | 2022-05-11 | Italy | Lombardia | 2825767 | 40198 | 0 | 45.46679409 | 9.190347404 | 2022-05-12 04:20:54 | Lombardia, Italy | |||
3444815 | 3444815 | 2022-05-11 | Italy | Marche | 458859 | 3864 | 0 | 43.61675973 | 13.5188753 | 2022-05-12 04:20:54 | Marche, Italy | |||
3444816 | 3444816 | 2022-05-11 | Italy | Molise | 62960 | 622 | 0 | 41.55774754 | 14.65916051 | 2022-05-12 04:20:54 | Molise, Italy | |||
3444817 | 3444817 | 2022-05-11 | Italy | P.A. Bolzano | 214327 | 1468 | 0 | 46.49933453 | 11.35662422 | 2022-05-12 04:20:54 | P.A. Bolzano, Italy | |||
3444818 | 3444818 | 2022-05-11 | Italy | P.A. Trento | 164291 | 1559 | 0 | 46.06893511 | 11.12123097 | 2022-05-12 04:20:54 | P.A. Trento, Italy | |||
3444819 | 3444819 | 2022-05-11 | Italy | Piemonte | 1169923 | 13369 | 0 | 45.0732745 | 7.680687483 | 2022-05-12 04:20:54 | Piemonte, Italy | |||
3444820 | 3444820 | 2022-05-11 | Italy | Puglia | 1099404 | 8368 | 0 | 41.12559576 | 16.86736689 | 2022-05-12 04:20:54 | Puglia, Italy | |||
3444821 | 3444821 | 2022-05-11 | Italy | Sardegna | 293659 | 2392 | 0 | 39.21531192 | 9.110616306 | 2022-05-12 04:20:54 | Sardegna, Italy | |||
3444822 | 3444822 | 2022-05-11 | Italy | Sicilia | 1147314 | 10727 | 0 | 38.11569725 | 13.3623567 | 2022-05-12 04:20:54 | Sicilia, Italy | |||
3444823 | 3444823 | 2022-05-11 | Italy | Toscana | 1122491 | 9961 | 0 | 43.76923077 | 11.25588885 | 2022-05-12 04:20:54 | Toscana, Italy | |||
3444824 | 3444824 | 2022-05-11 | Italy | Umbria | 276511 | 1838 | 0 | 43.10675841 | 12.38824698 | 2022-05-12 04:20:54 | Umbria, Italy | |||
3444825 | 3444825 | 2022-05-11 | Italy | Valle d'Aosta | 35761 | 534 | 0 | 45.73750286 | 7.320149366 | 2022-05-12 04:20:54 | Valle d'Aosta, Italy | |||
3444826 | 3444826 | 2022-05-11 | Italy | Veneto | 1712400 | 14544 | 0 | 45.43490485 | 12.33845213 | 2022-05-12 04:20:54 | Veneto, Italy | |||
3535423 | 3535423 | 2022-05-10 | Italy | Abruzzo | 388718 | 3253 | 0 | 42.35122196 | 13.39843823 | 2022-05-11 04:20:48 | Abruzzo, Italy | |||
3535424 | 3535424 | 2022-05-10 | Italy | Basilicata | 132249 | 904 | 0 | 40.63947052 | 15.80514834 | 2022-05-11 04:20:48 | Basilicata, Italy | |||
3535425 | 3535425 | 2022-05-10 | Italy | Calabria | 372126 | 2542 | 0 | 38.90597598 | 16.59440194 | 2022-05-11 04:20:48 | Calabria, Italy | |||
3535426 | 3535426 | 2022-05-10 | Italy | Campania | 1651286 | 10370 | 0 | 40.83956555 | 14.25084984 | 2022-05-11 04:20:48 | Campania, Italy | |||
3535427 | 3535427 | 2022-05-10 | Italy | Emilia-Romagna | 1442456 | 16740 | 0 | 44.49436681 | 11.3417208 | 2022-05-11 04:20:48 | Emilia-Romagna, Italy | |||
3535428 | 3535428 | 2022-05-10 | Italy | Friuli Venezia Giulia | 370133 | 5051 | 0 | 45.6494354 | 13.76813649 | 2022-05-11 04:20:48 | Friuli Venezia Giulia, Italy | |||
3535429 | 3535429 | 2022-05-10 | Italy | Lazio | 1520813 | 11201 | 0 | 41.89277044 | 12.48366722 | 2022-05-11 04:20:48 | Lazio, Italy | |||
3535430 | 3535430 | 2022-05-10 | Italy | Liguria | 436867 | 5298 | 0 | 44.41149315 | 8.9326992 | 2022-05-11 04:20:48 | Liguria, Italy | |||
3535431 | 3535431 | 2022-05-10 | Italy | Lombardia | 2819610 | 40186 | 0 | 45.46679409 | 9.190347404 | 2022-05-11 04:20:48 | Lombardia, Italy | |||
3535432 | 3535432 | 2022-05-10 | Italy | Marche | 457584 | 3863 | 0 | 43.61675973 | 13.5188753 | 2022-05-11 04:20:48 | Marche, Italy | |||
3535433 | 3535433 | 2022-05-10 | Italy | Molise | 62658 | 622 | 0 | 41.55774754 | 14.65916051 | 2022-05-11 04:20:48 | Molise, Italy | |||
3535434 | 3535434 | 2022-05-10 | Italy | P.A. Bolzano | 213959 | 1468 | 0 | 46.49933453 | 11.35662422 | 2022-05-11 04:20:48 | P.A. Bolzano, Italy | |||
3535435 | 3535435 | 2022-05-10 | Italy | P.A. Trento | 164000 | 1559 | 0 | 46.06893511 | 11.12123097 | 2022-05-11 04:20:48 | P.A. Trento, Italy | |||
3535436 | 3535436 | 2022-05-10 | Italy | Piemonte | 1167442 | 13362 | 0 | 45.0732745 | 7.680687483 | 2022-05-11 04:20:48 | Piemonte, Italy | |||
3535437 | 3535437 | 2022-05-10 | Italy | Puglia | 1096731 | 8360 | 0 | 41.12559576 | 16.86736689 | 2022-05-11 04:20:48 | Puglia, Italy | |||
3535438 | 3535438 | 2022-05-10 | Italy | Sardegna | 292079 | 2380 | 0 | 39.21531192 | 9.110616306 | 2022-05-11 04:20:48 | Sardegna, Italy | |||
3535439 | 3535439 | 2022-05-10 | Italy | Sicilia | 1144106 | 10722 | 0 | 38.11569725 | 13.3623567 | 2022-05-11 04:20:48 | Sicilia, Italy | |||
3535440 | 3535440 | 2022-05-10 | Italy | Toscana | 1120126 | 9949 | 0 | 43.76923077 | 11.25588885 | 2022-05-11 04:20:48 | Toscana, Italy | |||
3535441 | 3535441 | 2022-05-10 | Italy | Umbria | 275722 | 1837 | 0 | 43.10675841 | 12.38824698 | 2022-05-11 04:20:48 | Umbria, Italy | |||
3535442 | 3535442 | 2022-05-10 | Italy | Valle d'Aosta | 35694 | 533 | 0 | 45.73750286 | 7.320149366 | 2022-05-11 04:20:48 | Valle d'Aosta, Italy | |||
3535443 | 3535443 | 2022-05-10 | Italy | Veneto | 1708259 | 14531 | 0 | 45.43490485 | 12.33845213 | 2022-05-11 04:20:48 | Veneto, Italy | |||
221958 | 221958 | 2022-05-09 | Italy | Abruzzo | 386656 | 3248 | 0 | 42.35122196 | 13.39843823 | 2022-05-10 04:20:50 | Abruzzo, Italy | |||
221959 | 221959 | 2022-05-09 | Italy | Basilicata | 131652 | 903 | 0 | 40.63947052 | 15.80514834 | 2022-05-10 04:20:50 | Basilicata, Italy | |||
221960 | 221960 | 2022-05-09 | Italy | Calabria | 370117 | 2539 | 0 | 38.90597598 | 16.59440194 | 2022-05-10 04:20:50 | Calabria, Italy | |||
221961 | 221961 | 2022-05-09 | Italy | Campania | 1644870 | 10358 | 0 | 40.83956555 | 14.25084984 | 2022-05-10 04:20:50 | Campania, Italy | |||
221962 | 221962 | 2022-05-09 | Italy | Emilia-Romagna | 1440297 | 16722 | 0 | 44.49436681 | 11.3417208 | 2022-05-10 04:20:50 | Emilia-Romagna, Italy | |||
221963 | 221963 | 2022-05-09 | Italy | Friuli Venezia Giulia | 369083 | 5045 | 0 | 45.6494354 | 13.76813649 | 2022-05-10 04:20:50 | Friuli Venezia Giulia, Italy | |||
221964 | 221964 | 2022-05-09 | Italy | Lazio | 1515949 | 11186 | 0 | 41.89277044 | 12.48366722 | 2022-05-10 04:20:50 | Lazio, Italy | |||
221965 | 221965 | 2022-05-09 | Italy | Liguria | 435412 | 5293 | 0 | 44.41149315 | 8.9326992 | 2022-05-10 04:20:50 | Liguria, Italy | |||
221966 | 221966 | 2022-05-09 | Italy | Lombardia | 2810129 | 40152 | 0 | 45.46679409 | 9.190347404 | 2022-05-10 04:20:50 | Lombardia, Italy | |||
221967 | 221967 | 2022-05-09 | Italy | Marche | 455853 | 3863 | 0 | 43.61675973 | 13.5188753 | 2022-05-10 04:20:50 | Marche, Italy | |||
221968 | 221968 | 2022-05-09 | Italy | Molise | 62385 | 622 | 0 | 41.55774754 | 14.65916051 | 2022-05-10 04:20:50 | Molise, Italy | |||
221969 | 221969 | 2022-05-09 | Italy | P.A. Bolzano | 213408 | 1465 | 0 | 46.49933453 | 11.35662422 | 2022-05-10 04:20:50 | P.A. Bolzano, Italy | |||
221970 | 221970 | 2022-05-09 | Italy | P.A. Trento | 163574 | 1559 | 0 | 46.06893511 | 11.12123097 | 2022-05-10 04:20:50 | P.A. Trento, Italy | |||
221971 | 221971 | 2022-05-09 | Italy | Piemonte | 1164181 | 13354 | 0 | 45.0732745 | 7.680687483 | 2022-05-10 04:20:50 | Piemonte, Italy | |||
221972 | 221972 | 2022-05-09 | Italy | Puglia | 1092617 | 8353 | 0 | 41.12559576 | 16.86736689 | 2022-05-10 04:20:50 | Puglia, Italy | |||
221973 | 221973 | 2022-05-09 | Italy | Sardegna | 290282 | 2379 | 0 | 39.21531192 | 9.110616306 | 2022-05-10 04:20:50 | Sardegna, Italy | |||
221974 | 221974 | 2022-05-09 | Italy | Sicilia | 1140150 | 10705 | 0 | 38.11569725 | 13.3623567 | 2022-05-10 04:20:50 | Sicilia, Italy | |||
221975 | 221975 | 2022-05-09 | Italy | Toscana | 1116801 | 9940 | 0 | 43.76923077 | 11.25588885 | 2022-05-10 04:20:50 | Toscana, Italy | |||
221976 | 221976 | 2022-05-09 | Italy | Umbria | 274861 | 1837 | 0 | 43.10675841 | 12.38824698 | 2022-05-10 04:20:50 | Umbria, Italy | |||
221977 | 221977 | 2022-05-09 | Italy | Valle d'Aosta | 35602 | 533 | 0 | 45.73750286 | 7.320149366 | 2022-05-10 04:20:50 | Valle d'Aosta, Italy | |||
221978 | 221978 | 2022-05-09 | Italy | Veneto | 1702540 | 14517 | 0 | 45.43490485 | 12.33845213 | 2022-05-10 04:20:50 | Veneto, Italy | |||
2331343 | 2331343 | 2022-05-08 | Italy | Abruzzo | 386071 | 3247 | 0 | 42.35122196 | 13.39843823 | 2022-05-09 04:20:54 | Abruzzo, Italy | |||
2331344 | 2331344 | 2022-05-08 | Italy | Basilicata | 131382 | 901 | 0 | 40.63947052 | 15.80514834 | 2022-05-09 04:20:54 | Basilicata, Italy | |||
2331345 | 2331345 | 2022-05-08 | Italy | Calabria | 369423 | 2537 | 0 | 38.90597598 | 16.59440194 | 2022-05-09 04:20:54 | Calabria, Italy | |||
2331346 | 2331346 | 2022-05-08 | Italy | Campania | 1643042 | 10350 | 0 | 40.83956555 | 14.25084984 | 2022-05-09 04:20:54 | Campania, Italy | |||
2331347 | 2331347 | 2022-05-08 | Italy | Emilia-Romagna | 1438202 | 16717 | 0 | 44.49436681 | 11.3417208 | 2022-05-09 04:20:54 | Emilia-Romagna, Italy | |||
2331348 | 2331348 | 2022-05-08 | Italy | Friuli Venezia Giulia | 368926 | 5039 | 0 | 45.6494354 | 13.76813649 | 2022-05-09 04:20:54 | Friuli Venezia Giulia, Italy | |||
2331349 | 2331349 | 2022-05-08 | Italy | Lazio | 1514187 | 11182 | 0 | 41.89277044 | 12.48366722 | 2022-05-09 04:20:54 | Lazio, Italy | |||
2331350 | 2331350 | 2022-05-08 | Italy | Liguria | 435068 | 5293 | 0 | 44.41149315 | 8.9326992 | 2022-05-09 04:20:54 | Liguria, Italy | |||
2331351 | 2331351 | 2022-05-08 | Italy | Lombardia | 2807778 | 40131 | 0 | 45.46679409 | 9.190347404 | 2022-05-09 04:20:54 | Lombardia, Italy | |||
2331352 | 2331352 | 2022-05-08 | Italy | Marche | 455273 | 3861 | 0 | 43.61675973 | 13.5188753 | 2022-05-09 04:20:54 | Marche, Italy | |||
2331353 | 2331353 | 2022-05-08 | Italy | Molise | 62266 | 622 | 0 | 41.55774754 | 14.65916051 | 2022-05-09 04:20:54 | Molise, Italy | |||
2331354 | 2331354 | 2022-05-08 | Italy | P.A. Bolzano | 213309 | 1465 | 0 | 46.49933453 | 11.35662422 | 2022-05-09 04:20:54 | P.A. Bolzano, Italy | |||
2331355 | 2331355 | 2022-05-08 | Italy | P.A. Trento | 163508 | 1559 | 0 | 46.06893511 | 11.12123097 | 2022-05-09 04:20:54 | P.A. Trento, Italy | |||
2331356 | 2331356 | 2022-05-08 | Italy | Piemonte | 1163167 | 13351 | 0 | 45.0732745 | 7.680687483 | 2022-05-09 04:20:54 | Piemonte, Italy | |||
2331357 | 2331357 | 2022-05-08 | Italy | Puglia | 1091408 | 8349 | 0 | 41.12559576 | 16.86736689 | 2022-05-09 04:20:54 | Puglia, Italy | |||
2331358 | 2331358 | 2022-05-08 | Italy | Sardegna | 289782 | 2374 | 0 | 39.21531192 | 9.110616306 | 2022-05-09 04:20:54 | 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]);