daily_reports (view)
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)
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
- …
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-05-14 | Italy | Campania | 4639 | 394 | 2480 | 1765 | 40.83956555 | 14.25084984 | 2020-05-15 02:33:02 | Campania, Italy | ||
2020-05-14 | Italy | Emilia-Romagna | 27056 | 3930 | 16825 | 6301 | 44.49436681 | 11.341720800000001 | 2020-05-15 02:33:02 | Emilia-Romagna, Italy | ||
2020-05-14 | Italy | Friuli Venezia Giulia | 3161 | 317 | 2074 | 770 | 45.6494354 | 13.76813649 | 2020-05-15 02:33:02 | Friuli Venezia Giulia, Italy | ||
2020-05-14 | Italy | Lazio | 7291 | 595 | 2600 | 4096 | 41.89277044 | 12.48366722 | 2020-05-15 02:33:02 | Lazio, Italy | ||
2020-05-14 | Italy | Liguria | 8995 | 1329 | 5006 | 2660 | 44.41149315 | 8.9326992 | 2020-05-15 02:33:02 | Liguria, Italy | ||
2020-05-14 | Italy | Lombardia | 83820 | 15296 | 38568 | 29956 | 45.46679409 | 9.190347404 | 2020-05-15 02:33:02 | Lombardia, Italy | ||
2020-05-14 | Italy | Marche | 6603 | 974 | 2725 | 2904 | 43.61675973 | 13.5188753 | 2020-05-15 02:33:02 | Marche, Italy | ||
2020-05-14 | Italy | Molise | 403 | 22 | 152 | 229 | 41.55774754 | 14.65916051 | 2020-05-15 02:33:02 | Molise, Italy | ||
2020-05-14 | Italy | P.A. Bolzano | 2578 | 290 | 1908 | 380 | 46.49933453 | 11.35662422 | 2020-05-15 02:33:02 | P.A. Bolzano, Italy | ||
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 | ||
2020-05-14 | Italy | Piemonte | 29209 | 3493 | 13825 | 11891 | 45.0732745 | 7.680687483 | 2020-05-15 02:33:02 | Piemonte, Italy | ||
2020-05-14 | Italy | Puglia | 4357 | 461 | 1643 | 2253 | 41.12559576 | 16.86736689 | 2020-05-15 02:33:02 | Puglia, Italy | ||
2020-05-14 | Italy | Sardegna | 1345 | 125 | 755 | 465 | 39.21531192 | 9.110616306 | 2020-05-15 02:33:02 | Sardegna, Italy | ||
2020-05-14 | Italy | Sicilia | 3366 | 263 | 1249 | 1854 | 38.11569725 | 13.362356699999998 | 2020-05-15 02:33:02 | Sicilia, Italy | ||
2020-05-14 | Italy | Toscana | 9859 | 973 | 5498 | 3388 | 43.76923077 | 11.25588885 | 2020-05-15 02:33:02 | Toscana, Italy | ||
2020-05-14 | Italy | Umbria | 1420 | 73 | 1255 | 92 | 43.10675841 | 12.38824698 | 2020-05-15 02:33:02 | Umbria, Italy | ||
2020-05-14 | Italy | Valle d'Aosta | 1166 | 141 | 945 | 80 | 45.73750286 | 7.320149366 | 2020-05-15 02:33:02 | Valle d'Aosta, Italy | ||
2020-05-14 | Italy | Veneto | 18845 | 1743 | 12384 | 4718 | 45.43490485 | 12.33845213 | 2020-05-15 02:33:02 | Veneto, Italy | ||
2020-05-15 | Italy | Abruzzo | 3148 | 381 | 1313 | 1454 | 42.35122196 | 13.39843823 | 2020-05-16 02:32:19 | Abruzzo, Italy | ||
2020-05-15 | Italy | Basilicata | 389 | 27 | 242 | 120 | 40.63947052 | 15.80514834 | 2020-05-16 02:32:19 | Basilicata, Italy | ||
2020-05-15 | Italy | Calabria | 1144 | 95 | 544 | 505 | 38.90597598 | 16.59440194 | 2020-05-16 02:32:19 | Calabria, Italy | ||
2020-05-15 | Italy | Campania | 4654 | 396 | 2522 | 1736 | 40.83956555 | 14.25084984 | 2020-05-16 02:32:19 | Campania, Italy | ||
2020-05-15 | Italy | Emilia-Romagna | 27110 | 3943 | 17166 | 6001 | 44.49436681 | 11.341720800000001 | 2020-05-16 02:32:19 | Emilia-Romagna, Italy | ||
2020-05-15 | Italy | Friuli Venezia Giulia | 3175 | 318 | 2116 | 741 | 45.6494354 | 13.76813649 | 2020-05-16 02:32:19 | Friuli Venezia Giulia, Italy | ||
2020-05-15 | Italy | Lazio | 7364 | 604 | 2672 | 4088 | 41.89277044 | 12.48366722 | 2020-05-16 02:32:19 | Lazio, Italy | ||
2020-05-15 | Italy | Liguria | 9060 | 1336 | 5121 | 2603 | 44.41149315 | 8.9326992 | 2020-05-16 02:32:19 | Liguria, Italy | ||
2020-05-15 | Italy | Lombardia | 84119 | 15411 | 40962 | 27746 | 45.46679409 | 9.190347404 | 2020-05-16 02:32:19 | Lombardia, Italy | ||
2020-05-15 | Italy | Marche | 6619 | 977 | 2847 | 2795 | 43.61675973 | 13.5188753 | 2020-05-16 02:32:19 | Marche, Italy | ||
2020-05-15 | Italy | Molise | 407 | 22 | 158 | 227 | 41.55774754 | 14.65916051 | 2020-05-16 02:32:19 | Molise, Italy | ||
2020-05-15 | Italy | P.A. Bolzano | 2578 | 290 | 1929 | 359 | 46.49933453 | 11.35662422 | 2020-05-16 02:32:19 | P.A. Bolzano, Italy | ||
2020-05-15 | Italy | P.A. Trento | 4318 | 451 | 3461 | 406 | 46.06893511 | 11.12123097 | 2020-05-16 02:32:19 | P.A. Trento, Italy | ||
2020-05-15 | Italy | Piemonte | 29346 | 3557 | 14676 | 11113 | 45.0732745 | 7.680687483 | 2020-05-16 02:32:19 | Piemonte, Italy | ||
2020-05-15 | Italy | Puglia | 4366 | 461 | 1724 | 2181 | 41.12559576 | 16.86736689 | 2020-05-16 02:32:19 | Puglia, Italy | ||
2020-05-15 | Italy | Sardegna | 1348 | 125 | 762 | 461 | 39.21531192 | 9.110616306 | 2020-05-16 02:32:19 | Sardegna, Italy | ||
2020-05-15 | Italy | Sicilia | 3374 | 263 | 1351 | 1760 | 38.11569725 | 13.362356699999998 | 2020-05-16 02:32:19 | Sicilia, Italy | ||
2020-05-15 | Italy | Toscana | 9883 | 976 | 5739 | 3168 | 43.76923077 | 11.25588885 | 2020-05-16 02:32:19 | Toscana, Italy | ||
2020-05-15 | Italy | Umbria | 1422 | 73 | 1259 | 90 | 43.10675841 | 12.38824698 | 2020-05-16 02:32:19 | Umbria, Italy | ||
2020-05-15 | Italy | Valle d'Aosta | 1172 | 142 | 953 | 77 | 45.73750286 | 7.320149366 | 2020-05-16 02:32:19 | Valle d'Aosta, Italy | ||
2020-05-15 | Italy | Veneto | 18889 | 1762 | 12688 | 4439 | 45.43490485 | 12.33845213 | 2020-05-16 02:32:19 | Veneto, Italy | ||
2020-05-16 | Italy | Abruzzo | 3178 | 383 | 1372 | 1423 | 42.35122196 | 13.39843823 | 2020-05-17 02:32:32 | Abruzzo, Italy | ||
2020-05-16 | Italy | Basilicata | 390 | 27 | 250 | 113 | 40.63947052 | 15.80514834 | 2020-05-17 02:32:32 | Basilicata, Italy | ||
2020-05-16 | Italy | Calabria | 1151 | 95 | 582 | 474 | 38.90597598 | 16.59440194 | 2020-05-17 02:32:32 | Calabria, Italy | ||
2020-05-16 | Italy | Campania | 4668 | 396 | 2562 | 1710 | 40.83956555 | 14.25084984 | 2020-05-17 02:32:32 | Campania, Italy | ||
2020-05-16 | Italy | Emilia-Romagna | 27182 | 3960 | 17370 | 5852 | 44.49436681 | 11.341720800000001 | 2020-05-17 02:32:32 | Emilia-Romagna, Italy | ||
2020-05-16 | Italy | Friuli Venezia Giulia | 3183 | 319 | 2184 | 680 | 45.6494354 | 13.76813649 | 2020-05-17 02:32:32 | Friuli Venezia Giulia, Italy | ||
2020-05-16 | Italy | Lazio | 7396 | 616 | 2758 | 4022 | 41.89277044 | 12.48366722 | 2020-05-17 02:32:32 | Lazio, Italy | ||
2020-05-16 | Italy | Liguria | 9111 | 1346 | 5232 | 2533 | 44.41149315 | 8.9326992 | 2020-05-17 02:32:32 | Liguria, Italy | ||
2020-05-16 | Italy | Lombardia | 84518 | 15450 | 41389 | 27679 | 45.46679409 | 9.190347404 | 2020-05-17 02:32:32 | Lombardia, Italy | ||
2020-05-16 | Italy | Marche | 6642 | 982 | 3003 | 2657 | 43.61675973 | 13.5188753 | 2020-05-17 02:32:32 | Marche, Italy | ||
2020-05-16 | Italy | Molise | 410 | 22 | 173 | 215 | 41.55774754 | 14.65916051 | 2020-05-17 02:32:32 | Molise, Italy | ||
2020-05-16 | Italy | P.A. Bolzano | 2578 | 290 | 1945 | 343 | 46.49933453 | 11.35662422 | 2020-05-17 02:32:32 | P.A. Bolzano, Italy | ||
2020-05-16 | Italy | P.A. Trento | 4326 | 453 | 3528 | 345 | 46.06893511 | 11.12123097 | 2020-05-17 02:32:32 | P.A. Trento, Italy | ||
2020-05-16 | Italy | Piemonte | 29483 | 3594 | 15187 | 10702 | 45.0732745 | 7.680687483 | 2020-05-17 02:32:32 | Piemonte, Italy | ||
2020-05-16 | Italy | Puglia | 4374 | 463 | 1807 | 2104 | 41.12559576 | 16.86736689 | 2020-05-17 02:32:32 | Puglia, Italy | ||
2020-05-16 | Italy | Sardegna | 1352 | 125 | 812 | 415 | 39.21531192 | 9.110616306 | 2020-05-17 02:32:32 | Sardegna, Italy | ||
2020-05-16 | Italy | Sicilia | 3382 | 265 | 1458 | 1659 | 38.11569725 | 13.362356699999998 | 2020-05-17 02:32:32 | Sicilia, Italy | ||
2020-05-16 | Italy | Toscana | 9913 | 979 | 5991 | 2943 | 43.76923077 | 11.25588885 | 2020-05-17 02:32:32 | Toscana, Italy | ||
2020-05-16 | Italy | Umbria | 1422 | 73 | 1268 | 81 | 43.10675841 | 12.38824698 | 2020-05-17 02:32:32 | Umbria, Italy | ||
2020-05-16 | Italy | Valle d'Aosta | 1173 | 142 | 956 | 75 | 45.73750286 | 7.320149366 | 2020-05-17 02:32:32 | Valle d'Aosta, Italy | ||
2020-05-16 | Italy | Veneto | 18928 | 1783 | 12983 | 4162 | 45.43490485 | 12.33845213 | 2020-05-17 02:32:32 | Veneto, Italy | ||
2020-05-17 | Italy | Abruzzo | 3186 | 385 | 1379 | 1422 | 42.35122196 | 13.39843823 | 2020-05-18 02:32:21 | Abruzzo, Italy | ||
2020-05-17 | Italy | Basilicata | 392 | 27 | 261 | 104 | 40.63947052 | 15.80514834 | 2020-05-18 02:32:21 | Basilicata, Italy | ||
2020-05-17 | Italy | Calabria | 1151 | 95 | 634 | 422 | 38.90597598 | 16.59440194 | 2020-05-18 02:32:21 | Calabria, Italy | ||
2020-05-17 | Italy | Campania | 4684 | 396 | 2592 | 1696 | 40.83956555 | 14.25084984 | 2020-05-18 02:32:21 | Campania, Italy | ||
2020-05-17 | Italy | Emilia-Romagna | 27232 | 3973 | 17603 | 5656 | 44.49436681 | 11.341720800000001 | 2020-05-18 02:32:21 | Emilia-Romagna, Italy | ||
2020-05-17 | Italy | Friuli Venezia Giulia | 3191 | 319 | 2218 | 654 | 45.6494354 | 13.76813649 | 2020-05-18 02:32:21 | Friuli Venezia Giulia, Italy | ||
2020-05-17 | Italy | Lazio | 7446 | 622 | 2914 | 3910 | 41.89277044 | 12.48366722 | 2020-05-18 02:32:21 | Lazio, Italy | ||
2020-05-17 | Italy | Liguria | 9159 | 1355 | 5348 | 2456 | 44.41149315 | 8.9326992 | 2020-05-18 02:32:21 | Liguria, Italy | ||
2020-05-17 | Italy | Lombardia | 84844 | 15519 | 41895 | 27430 | 45.46679409 | 9.190347404 | 2020-05-18 02:32:21 | Lombardia, Italy | ||
2020-05-17 | Italy | Marche | 6667 | 984 | 3118 | 2565 | 43.61675973 | 13.5188753 | 2020-05-18 02:32:21 | Marche, Italy | ||
2020-05-17 | Italy | Molise | 411 | 22 | 173 | 216 | 41.55774754 | 14.65916051 | 2020-05-18 02:32:21 | Molise, Italy | ||
2020-05-17 | Italy | P.A. Bolzano | 2581 | 290 | 1977 | 314 | 46.49933453 | 11.35662422 | 2020-05-18 02:32:21 | P.A. Bolzano, Italy | ||
2020-05-17 | Italy | P.A. Trento | 4338 | 453 | 3584 | 301 | 46.06893511 | 11.12123097 | 2020-05-18 02:32:21 | P.A. Trento, Italy | ||
2020-05-17 | Italy | Piemonte | 29547 | 3612 | 15696 | 10239 | 45.0732745 | 7.680687483 | 2020-05-18 02:32:21 | Piemonte, Italy | ||
2020-05-17 | Italy | Puglia | 4379 | 470 | 1892 | 2017 | 41.12559576 | 16.86736689 | 2020-05-18 02:32:21 | Puglia, Italy | ||
2020-05-17 | Italy | Sardegna | 1353 | 125 | 823 | 405 | 39.21531192 | 9.110616306 | 2020-05-18 02:32:21 | Sardegna, Italy | ||
2020-05-17 | Italy | Sicilia | 3388 | 267 | 1566 | 1555 | 38.11569725 | 13.362356699999998 | 2020-05-18 02:32:21 | Sicilia, Italy | ||
2020-05-17 | Italy | Toscana | 9948 | 984 | 6162 | 2802 | 43.76923077 | 11.25588885 | 2020-05-18 02:32:21 | Toscana, Italy | ||
2020-05-17 | Italy | Umbria | 1424 | 73 | 1273 | 78 | 43.10675841 | 12.38824698 | 2020-05-18 02:32:21 | Umbria, Italy | ||
2020-05-17 | Italy | Valle d'Aosta | 1173 | 143 | 962 | 68 | 45.73750286 | 7.320149366 | 2020-05-18 02:32:21 | Valle d'Aosta, Italy | ||
2020-05-17 | Italy | Veneto | 18941 | 1794 | 13106 | 4041 | 45.43490485 | 12.33845213 | 2020-05-18 02:32:21 | Veneto, Italy | ||
2020-05-18 | Italy | Abruzzo | 3193 | 388 | 1392 | 1413 | 42.35122196 | 13.39843823 | 2020-05-19 02:32:18 | Abruzzo, Italy | ||
2020-05-18 | Italy | Basilicata | 392 | 27 | 272 | 93 | 40.63947052 | 15.80514834 | 2020-05-19 02:32:18 | Basilicata, Italy | ||
2020-05-18 | Italy | Calabria | 1151 | 95 | 655 | 401 | 38.90597598 | 16.59440194 | 2020-05-19 02:32:18 | Calabria, Italy | ||
2020-05-18 | Italy | Campania | 4695 | 399 | 2623 | 1673 | 40.83956555 | 14.25084984 | 2020-05-19 02:32:18 | Campania, Italy | ||
2020-05-18 | Italy | Emilia-Romagna | 27267 | 3986 | 17756 | 5525 | 44.49436681 | 11.341720800000001 | 2020-05-19 02:32:18 | Emilia-Romagna, Italy | ||
2020-05-18 | Italy | Friuli Venezia Giulia | 3198 | 320 | 2257 | 621 | 45.6494354 | 13.76813649 | 2020-05-19 02:32:18 | Friuli Venezia Giulia, Italy | ||
2020-05-18 | Italy | Lazio | 7485 | 628 | 3031 | 3826 | 41.89277044 | 12.48366722 | 2020-05-19 02:32:18 | Lazio, Italy | ||
2020-05-18 | Italy | Liguria | 9191 | 1367 | 5485 | 2339 | 44.41149315 | 8.9326992 | 2020-05-19 02:32:18 | Liguria, Italy | ||
2020-05-18 | Italy | Lombardia | 85019 | 15543 | 42403 | 27073 | 45.46679409 | 9.190347404 | 2020-05-19 02:32:18 | Lombardia, Italy | ||
2020-05-18 | Italy | Marche | 6678 | 984 | 3379 | 2315 | 43.61675973 | 13.5188753 | 2020-05-19 02:32:18 | Marche, Italy | ||
2020-05-18 | Italy | Molise | 422 | 22 | 183 | 217 | 41.55774754 | 14.65916051 | 2020-05-19 02:32:18 | Molise, Italy | ||
2020-05-18 | Italy | P.A. Bolzano | 2582 | 291 | 1984 | 307 | 46.49933453 | 11.35662422 | 2020-05-19 02:32:18 | P.A. Bolzano, Italy | ||
2020-05-18 | Italy | P.A. Trento | 4351 | 453 | 3650 | 248 | 46.06893511 | 11.12123097 | 2020-05-19 02:32:18 | P.A. Trento, Italy | ||
2020-05-18 | Italy | Piemonte | 29619 | 3632 | 16113 | 9874 | 45.0732745 | 7.680687483 | 2020-05-19 02:32:18 | Piemonte, Italy | ||
2020-05-18 | Italy | Puglia | 4386 | 471 | 1920 | 1995 | 41.12559576 | 16.86736689 | 2020-05-19 02:32:18 | Puglia, Italy | ||
2020-05-18 | Italy | Sardegna | 1353 | 126 | 847 | 380 | 39.21531192 | 9.110616306 | 2020-05-19 02:32:18 | Sardegna, Italy | ||
2020-05-18 | Italy | Sicilia | 3395 | 267 | 1589 | 1539 | 38.11569725 | 13.362356699999998 | 2020-05-19 02:32:18 | Sicilia, Italy | ||
2020-05-18 | Italy | Toscana | 9961 | 989 | 6399 | 2573 | 43.76923077 | 11.25588885 | 2020-05-19 02:32:18 | Toscana, Italy | ||
2020-05-18 | Italy | Umbria | 1424 | 73 | 1274 | 77 | 43.10675841 | 12.38824698 | 2020-05-19 02:32:18 | Umbria, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;