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
- Sicilia 53
- Toscana 53
- Umbria 53
- Valle d'Aosta 53
- Veneto 53
- Abruzzo 52
- Basilicata 52
- Calabria 52
- Campania 52
- Emilia-Romagna 52
- Friuli Venezia Giulia 52
- Lazio 52
- Liguria 52
- Lombardia 52
- Marche 52
- Molise 52
- P.A. Bolzano 52
- P.A. Trento 52
- Piemonte 52
- Puglia 52
- Sardegna 52
country_or_region 1
- Italy · 1,201 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
415528 | 415528 | 2020-07-05 | Italy | Sicilia | 3094 | 282 | 2674 | 138 | 38.11569725 | 13.362356699999998 | 2020-07-06 04:33:57 | Sicilia, Italy | ||
415564 | 415564 | 2020-07-05 | Italy | Toscana | 10285 | 1114 | 8841 | 330 | 43.76923077 | 11.25588885 | 2020-07-06 04:33:57 | Toscana, Italy | ||
415577 | 415577 | 2020-07-05 | Italy | Umbria | 1447 | 80 | 1358 | 9 | 43.10675841 | 12.38824698 | 2020-07-06 04:33:57 | Umbria, Italy | ||
415588 | 415588 | 2020-07-05 | Italy | Valle d'Aosta | 1196 | 146 | 1045 | 5 | 45.73750286 | 7.320149366 | 2020-07-06 04:33:57 | Valle d'Aosta, Italy | ||
415597 | 415597 | 2020-07-05 | Italy | Veneto | 19326 | 2023 | 16915 | 388 | 45.43490485 | 12.33845213 | 2020-07-06 04:33:57 | Veneto, Italy | ||
529679 | 529679 | 2020-07-04 | Italy | Abruzzo | 3305 | 464 | 2682 | 159 | 42.35122196 | 13.39843823 | 2020-07-05 04:33:46 | Abruzzo, Italy | ||
529728 | 529728 | 2020-07-04 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-05 04:33:46 | Basilicata, Italy | ||
529748 | 529748 | 2020-07-04 | Italy | Calabria | 1183 | 97 | 1060 | 26 | 38.90597598 | 16.59440194 | 2020-07-05 04:33:46 | Calabria, Italy | ||
529751 | 529751 | 2020-07-04 | Italy | Campania | 4714 | 432 | 4084 | 198 | 40.83956555 | 14.25084984 | 2020-07-05 04:33:46 | Campania, Italy | ||
529801 | 529801 | 2020-07-04 | Italy | Emilia-Romagna | 28613 | 4267 | 23309 | 1037 | 44.49436681 | 11.341720800000001 | 2020-07-05 04:33:46 | Emilia-Romagna, Italy | ||
529809 | 529809 | 2020-07-04 | Italy | Friuli Venezia Giulia | 3326 | 345 | 2908 | 73 | 45.6494354 | 13.76813649 | 2020-07-05 04:33:46 | Friuli Venezia Giulia, Italy | ||
529916 | 529916 | 2020-07-04 | Italy | Lazio | 8172 | 841 | 6477 | 854 | 41.89277044 | 12.48366722 | 2020-07-05 04:33:46 | Lazio, Italy | ||
529919 | 529919 | 2020-07-04 | Italy | Liguria | 9991 | 1558 | 8150 | 283 | 44.41149315 | 8.9326992 | 2020-07-05 04:33:46 | Liguria, Italy | ||
529922 | 529922 | 2020-07-04 | Italy | Lombardia | 94318 | 16691 | 68201 | 9426 | 45.46679409 | 9.190347404 | 2020-07-05 04:33:46 | Lombardia, Italy | ||
529939 | 529939 | 2020-07-04 | Italy | Marche | 6789 | 987 | 5599 | 203 | 43.61675973 | 13.5188753 | 2020-07-05 04:33:46 | Marche, Italy | ||
529958 | 529958 | 2020-07-04 | Italy | Molise | 445 | 23 | 401 | 21 | 41.55774754 | 14.65916051 | 2020-07-05 04:33:46 | Molise, Italy | ||
530012 | 530012 | 2020-07-04 | Italy | P.A. Bolzano | 2645 | 292 | 2268 | 85 | 46.49933453 | 11.35662422 | 2020-07-05 04:33:46 | P.A. Bolzano, Italy | ||
530013 | 530013 | 2020-07-04 | Italy | P.A. Trento | 4873 | 405 | 4420 | 48 | 46.06893511 | 11.12123097 | 2020-07-05 04:33:46 | P.A. Trento, Italy | ||
530023 | 530023 | 2020-07-04 | Italy | Piemonte | 31405 | 4102 | 26086 | 1217 | 45.0732745 | 7.680687483 | 2020-07-05 04:33:46 | Piemonte, Italy | ||
530033 | 530033 | 2020-07-04 | Italy | Puglia | 4536 | 545 | 3880 | 111 | 41.12559576 | 16.86736689 | 2020-07-05 04:33:46 | Puglia, Italy | ||
530076 | 530076 | 2020-07-04 | Italy | Sardegna | 1369 | 133 | 1223 | 13 | 39.21531192 | 9.110616306 | 2020-07-05 04:33:46 | Sardegna, Italy | ||
530090 | 530090 | 2020-07-04 | Italy | Sicilia | 3094 | 282 | 2674 | 138 | 38.11569725 | 13.362356699999998 | 2020-07-05 04:33:46 | Sicilia, Italy | ||
530126 | 530126 | 2020-07-04 | Italy | Toscana | 10276 | 1114 | 8838 | 324 | 43.76923077 | 11.25588885 | 2020-07-05 04:33:46 | Toscana, Italy | ||
530139 | 530139 | 2020-07-04 | Italy | Umbria | 1447 | 80 | 1358 | 9 | 43.10675841 | 12.38824698 | 2020-07-05 04:33:46 | Umbria, Italy | ||
530150 | 530150 | 2020-07-04 | Italy | Valle d'Aosta | 1196 | 146 | 1046 | 4 | 45.73750286 | 7.320149366 | 2020-07-05 04:33:46 | Valle d'Aosta, Italy | ||
530159 | 530159 | 2020-07-04 | Italy | Veneto | 19318 | 2023 | 16907 | 388 | 45.43490485 | 12.33845213 | 2020-07-05 04:33:46 | Veneto, Italy | ||
2234340 | 2234340 | 2020-07-03 | Italy | Abruzzo | 3298 | 464 | 2678 | 156 | 42.35122196 | 13.39843823 | 2020-07-04 04:33:51 | Abruzzo, Italy | ||
2234389 | 2234389 | 2020-07-03 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-04 04:33:51 | Basilicata, Italy | ||
2234409 | 2234409 | 2020-07-03 | Italy | Calabria | 1182 | 97 | 1060 | 25 | 38.90597598 | 16.59440194 | 2020-07-04 04:33:51 | Calabria, Italy | ||
2234412 | 2234412 | 2020-07-03 | Italy | Campania | 4712 | 432 | 4083 | 197 | 40.83956555 | 14.25084984 | 2020-07-04 04:33:51 | Campania, Italy | ||
2234462 | 2234462 | 2020-07-03 | Italy | Emilia-Romagna | 28562 | 4267 | 23284 | 1011 | 44.49436681 | 11.341720800000001 | 2020-07-04 04:33:51 | Emilia-Romagna, Italy | ||
2234470 | 2234470 | 2020-07-03 | Italy | Friuli Venezia Giulia | 3318 | 345 | 2905 | 68 | 45.6494354 | 13.76813649 | 2020-07-04 04:33:51 | Friuli Venezia Giulia, Italy | ||
2234577 | 2234577 | 2020-07-03 | Italy | Lazio | 8141 | 840 | 6475 | 826 | 41.89277044 | 12.48366722 | 2020-07-04 04:33:51 | Lazio, Italy | ||
2234580 | 2234580 | 2020-07-03 | Italy | Liguria | 9987 | 1558 | 8146 | 283 | 44.41149315 | 8.9326992 | 2020-07-04 04:33:51 | Liguria, Italy | ||
2234583 | 2234583 | 2020-07-03 | Italy | Lombardia | 94223 | 16675 | 67871 | 9677 | 45.46679409 | 9.190347404 | 2020-07-04 04:33:51 | Lombardia, Italy | ||
2234600 | 2234600 | 2020-07-03 | Italy | Marche | 6789 | 987 | 5575 | 227 | 43.61675973 | 13.5188753 | 2020-07-04 04:33:51 | Marche, Italy | ||
2234619 | 2234619 | 2020-07-03 | Italy | Molise | 445 | 23 | 401 | 21 | 41.55774754 | 14.65916051 | 2020-07-04 04:33:51 | Molise, Italy | ||
2234673 | 2234673 | 2020-07-03 | Italy | P.A. Bolzano | 2642 | 292 | 2267 | 83 | 46.49933453 | 11.35662422 | 2020-07-04 04:33:51 | P.A. Bolzano, Italy | ||
2234674 | 2234674 | 2020-07-03 | Italy | P.A. Trento | 4871 | 405 | 4420 | 46 | 46.06893511 | 11.12123097 | 2020-07-04 04:33:51 | P.A. Trento, Italy | ||
2234684 | 2234684 | 2020-07-03 | Italy | Piemonte | 31394 | 4100 | 26019 | 1275 | 45.0732745 | 7.680687483 | 2020-07-04 04:33:51 | Piemonte, Italy | ||
2234694 | 2234694 | 2020-07-03 | Italy | Puglia | 4533 | 545 | 3879 | 109 | 41.12559576 | 16.86736689 | 2020-07-04 04:33:51 | Puglia, Italy | ||
2234737 | 2234737 | 2020-07-03 | Italy | Sardegna | 1369 | 133 | 1222 | 14 | 39.21531192 | 9.110616306 | 2020-07-04 04:33:51 | Sardegna, Italy | ||
2234751 | 2234751 | 2020-07-03 | Italy | Sicilia | 3091 | 282 | 2674 | 135 | 38.11569725 | 13.362356699999998 | 2020-07-04 04:33:51 | Sicilia, Italy | ||
2234787 | 2234787 | 2020-07-03 | Italy | Toscana | 10267 | 1112 | 8832 | 323 | 43.76923077 | 11.25588885 | 2020-07-04 04:33:51 | Toscana, Italy | ||
2234800 | 2234800 | 2020-07-03 | Italy | Umbria | 1446 | 80 | 1356 | 10 | 43.10675841 | 12.38824698 | 2020-07-04 04:33:51 | Umbria, Italy | ||
2234811 | 2234811 | 2020-07-03 | Italy | Valle d'Aosta | 1196 | 146 | 1046 | 4 | 45.73750286 | 7.320149366 | 2020-07-04 04:33:51 | Valle d'Aosta, Italy | ||
2234820 | 2234820 | 2020-07-03 | Italy | Veneto | 19314 | 2023 | 16901 | 390 | 45.43490485 | 12.33845213 | 2020-07-04 04:33:51 | Veneto, Italy | ||
3045134 | 3045134 | 2020-07-02 | Italy | Abruzzo | 3292 | 464 | 2668 | 160 | 42.35122196 | 13.39843823 | 2020-07-03 04:33:54 | Abruzzo, Italy | ||
3045183 | 3045183 | 2020-07-02 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-03 04:33:54 | Basilicata, Italy | ||
3045203 | 3045203 | 2020-07-02 | Italy | Calabria | 1181 | 97 | 1059 | 25 | 38.90597598 | 16.59440194 | 2020-07-03 04:33:54 | Calabria, Italy | ||
3045206 | 3045206 | 2020-07-02 | Italy | Campania | 4702 | 432 | 4080 | 190 | 40.83956555 | 14.25084984 | 2020-07-03 04:33:54 | Campania, Italy | ||
3045256 | 3045256 | 2020-07-02 | Italy | Emilia-Romagna | 28535 | 4265 | 23267 | 1003 | 44.49436681 | 11.3417208 | 2020-07-03 04:33:54 | Emilia-Romagna, Italy | ||
3045264 | 3045264 | 2020-07-02 | Italy | Friuli Venezia Giulia | 3314 | 345 | 2907 | 62 | 45.6494354 | 13.76813649 | 2020-07-03 04:33:54 | Friuli Venezia Giulia, Italy | ||
3045371 | 3045371 | 2020-07-02 | Italy | Lazio | 8130 | 839 | 6460 | 831 | 41.89277044 | 12.48366722 | 2020-07-03 04:33:54 | Lazio, Italy | ||
3045374 | 3045374 | 2020-07-02 | Italy | Liguria | 9984 | 1558 | 8145 | 281 | 44.41149315 | 8.9326992 | 2020-07-03 04:33:54 | Liguria, Italy | ||
3045377 | 3045377 | 2020-07-02 | Italy | Lombardia | 94108 | 16671 | 67610 | 9827 | 45.46679409 | 9.190347404 | 2020-07-03 04:33:54 | Lombardia, Italy | ||
3045394 | 3045394 | 2020-07-02 | Italy | Marche | 6789 | 987 | 5564 | 238 | 43.61675973 | 13.5188753 | 2020-07-03 04:33:54 | Marche, Italy | ||
3045413 | 3045413 | 2020-07-02 | Italy | Molise | 445 | 23 | 401 | 21 | 41.55774754 | 14.65916051 | 2020-07-03 04:33:54 | Molise, Italy | ||
3045467 | 3045467 | 2020-07-02 | Italy | P.A. Bolzano | 2642 | 292 | 2266 | 84 | 46.49933453 | 11.35662422 | 2020-07-03 04:33:54 | P.A. Bolzano, Italy | ||
3045468 | 3045468 | 2020-07-02 | Italy | P.A. Trento | 4865 | 405 | 4414 | 46 | 46.06893511 | 11.12123097 | 2020-07-03 04:33:54 | P.A. Trento, Italy | ||
3045478 | 3045478 | 2020-07-02 | Italy | Piemonte | 31378 | 4096 | 25983 | 1299 | 45.0732745 | 7.680687483 | 2020-07-03 04:33:54 | Piemonte, Italy | ||
3045488 | 3045488 | 2020-07-02 | Italy | Puglia | 4530 | 545 | 3876 | 109 | 41.12559576 | 16.86736689 | 2020-07-03 04:33:54 | Puglia, Italy | ||
3045531 | 3045531 | 2020-07-02 | Italy | Sardegna | 1368 | 133 | 1222 | 13 | 39.21531192 | 9.110616306 | 2020-07-03 04:33:54 | Sardegna, Italy | ||
3045545 | 3045545 | 2020-07-02 | Italy | Sicilia | 3090 | 282 | 2674 | 134 | 38.11569725 | 13.362356699999998 | 2020-07-03 04:33:54 | Sicilia, Italy | ||
3045581 | 3045581 | 2020-07-02 | Italy | Toscana | 10258 | 1109 | 8825 | 324 | 43.76923077 | 11.25588885 | 2020-07-03 04:33:54 | Toscana, Italy | ||
3045594 | 3045594 | 2020-07-02 | Italy | Umbria | 1444 | 80 | 1353 | 11 | 43.10675841 | 12.38824698 | 2020-07-03 04:33:54 | Umbria, Italy | ||
3045606 | 3045606 | 2020-07-02 | Italy | Valle d'Aosta | 1195 | 146 | 1046 | 3 | 45.73750286 | 7.320149366 | 2020-07-03 04:33:54 | Valle d'Aosta, Italy | ||
3045615 | 3045615 | 2020-07-02 | Italy | Veneto | 19309 | 2022 | 16890 | 397 | 45.43490485 | 12.33845213 | 2020-07-03 04:33:54 | Veneto, Italy | ||
302825 | 302825 | 2020-07-01 | Italy | Abruzzo | 3289 | 464 | 2655 | 170 | 42.35122196 | 13.39843823 | 2020-07-02 04:33:46 | Abruzzo, Italy | ||
302874 | 302874 | 2020-07-01 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-02 04:33:46 | Basilicata, Italy | ||
302894 | 302894 | 2020-07-01 | Italy | Calabria | 1181 | 97 | 1058 | 26 | 38.90597598 | 16.59440194 | 2020-07-02 04:33:46 | Calabria, Italy | ||
302897 | 302897 | 2020-07-01 | Italy | Campania | 4699 | 432 | 4078 | 189 | 40.83956555 | 14.25084984 | 2020-07-02 04:33:46 | Campania, Italy | ||
302947 | 302947 | 2020-07-01 | Italy | Emilia-Romagna | 28508 | 4264 | 23242 | 1002 | 44.49436681 | 11.341720800000001 | 2020-07-02 04:33:46 | Emilia-Romagna, Italy | ||
302955 | 302955 | 2020-07-01 | Italy | Friuli Venezia Giulia | 3312 | 345 | 2911 | 56 | 45.6494354 | 13.76813649 | 2020-07-02 04:33:46 | Friuli Venezia Giulia, Italy | ||
303062 | 303062 | 2020-07-01 | Italy | Lazio | 8119 | 839 | 6448 | 832 | 41.89277044 | 12.48366722 | 2020-07-02 04:33:46 | Lazio, Italy | ||
303065 | 303065 | 2020-07-01 | Italy | Liguria | 9982 | 1558 | 8144 | 280 | 44.41149315 | 8.9326992 | 2020-07-02 04:33:46 | Liguria, Italy | ||
303068 | 303068 | 2020-07-01 | Italy | Lombardia | 94010 | 16650 | 67422 | 9938 | 45.46679409 | 9.190347404 | 2020-07-02 04:33:46 | Lombardia, Italy | ||
303085 | 303085 | 2020-07-01 | Italy | Marche | 6786 | 987 | 5551 | 248 | 43.61675973 | 13.5188753 | 2020-07-02 04:33:46 | Marche, Italy | ||
303104 | 303104 | 2020-07-01 | Italy | Molise | 445 | 23 | 397 | 25 | 41.55774754 | 14.65916051 | 2020-07-02 04:33:46 | Molise, Italy | ||
303158 | 303158 | 2020-07-01 | Italy | P.A. Bolzano | 2642 | 292 | 2266 | 84 | 46.49933453 | 11.35662422 | 2020-07-02 04:33:46 | P.A. Bolzano, Italy | ||
303159 | 303159 | 2020-07-01 | Italy | P.A. Trento | 4864 | 405 | 4412 | 47 | 46.06893511 | 11.12123097 | 2020-07-02 04:33:46 | P.A. Trento, Italy | ||
303169 | 303169 | 2020-07-01 | Italy | Piemonte | 31365 | 4091 | 25921 | 1353 | 45.0732745 | 7.680687483 | 2020-07-02 04:33:46 | Piemonte, Italy | ||
303179 | 303179 | 2020-07-01 | Italy | Puglia | 4530 | 545 | 3873 | 112 | 41.12559576 | 16.86736689 | 2020-07-02 04:33:46 | Puglia, Italy | ||
303222 | 303222 | 2020-07-01 | Italy | Sardegna | 1366 | 133 | 1222 | 11 | 39.21531192 | 9.110616306 | 2020-07-02 04:33:46 | Sardegna, Italy | ||
303236 | 303236 | 2020-07-01 | Italy | Sicilia | 3081 | 282 | 2673 | 126 | 38.11569725 | 13.362356699999998 | 2020-07-02 04:33:46 | Sicilia, Italy | ||
303272 | 303272 | 2020-07-01 | Italy | Toscana | 10254 | 1106 | 8825 | 323 | 43.76923077 | 11.25588885 | 2020-07-02 04:33:46 | Toscana, Italy | ||
303285 | 303285 | 2020-07-01 | Italy | Umbria | 1441 | 80 | 1351 | 10 | 43.10675841 | 12.38824698 | 2020-07-02 04:33:46 | Umbria, Italy | ||
303297 | 303297 | 2020-07-01 | Italy | Valle d'Aosta | 1195 | 146 | 1046 | 3 | 45.73750286 | 7.320149366 | 2020-07-02 04:33:46 | Valle d'Aosta, Italy | ||
303306 | 303306 | 2020-07-01 | Italy | Veneto | 19289 | 2022 | 16849 | 418 | 45.43490485 | 12.33845213 | 2020-07-02 04:33:46 | Veneto, Italy | ||
2974203 | 2974203 | 2020-06-30 | Italy | Abruzzo | 3287 | 464 | 2626 | 197 | 42.35122196 | 13.39843823 | 2020-07-01 04:33:52 | Abruzzo, Italy | ||
2974252 | 2974252 | 2020-06-30 | Italy | Basilicata | 402 | 27 | 372 | 3 | 40.63947052 | 15.80514834 | 2020-07-01 04:33:52 | Basilicata, Italy | ||
2974272 | 2974272 | 2020-06-30 | Italy | Calabria | 1181 | 97 | 1057 | 27 | 38.90597598 | 16.59440194 | 2020-07-01 04:33:52 | Calabria, Italy | ||
2974275 | 2974275 | 2020-06-30 | Italy | Campania | 4690 | 432 | 4077 | 181 | 40.83956555 | 14.25084984 | 2020-07-01 04:33:52 | Campania, Italy | ||
2974325 | 2974325 | 2020-06-30 | Italy | Emilia-Romagna | 28492 | 4260 | 23222 | 1010 | 44.49436681 | 11.341720800000001 | 2020-07-01 04:33:52 | Emilia-Romagna, Italy | ||
2974333 | 2974333 | 2020-06-30 | Italy | Friuli Venezia Giulia | 3308 | 345 | 2918 | 45 | 45.6494354 | 13.76813649 | 2020-07-01 04:33:52 | Friuli Venezia Giulia, Italy | ||
2974440 | 2974440 | 2020-06-30 | Italy | Lazio | 8110 | 837 | 6437 | 836 | 41.89277044 | 12.48366722 | 2020-07-01 04:33:52 | Lazio, Italy | ||
2974443 | 2974443 | 2020-06-30 | Italy | Liguria | 9977 | 1558 | 8139 | 280 | 44.41149315 | 8.9326992 | 2020-07-01 04:33:52 | Liguria, Italy | ||
2974446 | 2974446 | 2020-06-30 | Italy | Lombardia | 93901 | 16644 | 67197 | 10060 | 45.46679409 | 9.190347404 | 2020-07-01 04:33:52 | Lombardia, Italy | ||
2974463 | 2974463 | 2020-06-30 | Italy | Marche | 6785 | 991 | 5528 | 266 | 43.61675973 | 13.5188753 | 2020-07-01 04:33:52 | Marche, Italy | ||
2974482 | 2974482 | 2020-06-30 | Italy | Molise | 445 | 23 | 397 | 25 | 41.55774754 | 14.65916051 | 2020-07-01 04:33:52 | Molise, 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]);