daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

545 rows where country_or_region = "Italy" sorted by admin2

View and edit SQL

Suggested facets: longitude, day (date), last_update (date)

country_or_region

  • Italy · 545
day country_or_region province_or_state admin2 ▼ fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-04-30 Italy       205463 27967 75945 101551 41.87194 12.56738 2020-05-01 02:32:28 Italy
2020-03-26 Italy       80589 8215 10361 62013 41.87194 12.56738 2020-03-26 23:48:18 Italy
2020-05-11 Italy       219814 30739 106587 82488 41.87194 12.56738 2020-05-12 03:32:27 Italy
2020-02-01 Italy       2 0 0       1/31/2020 8:15  
2020-03-19 Italy       41035 3405 4440   41.8719 12.5674 2020-03-19T17:43:03  
2020-04-02 Italy       115242 13915 18278 83049 41.87194 12.56738 4/2/20 23:25 Italy
2020-04-20 Italy       181228 24114 48877 108237 41.87194 12.56738 2020-04-20 23:36:27 Italy
2020-04-27 Italy       199414 26977 66624 105813 41.87194 12.56738 2020-04-28 02:30:32 Italy
2020-03-14 Italy       21157 1441 1966   41.8719 12.5674 2020-03-14T20:13:16  
2020-02-14 Italy       3 0 0       2020-02-07T17:53:02  
2020-05-23 Italy Abruzzo     3221 394 1659 1168 42.35122196 13.39843823 2020-05-24 02:32:43 Abruzzo, Italy
2020-05-23 Italy Basilicata     398 27 330 41 40.63947052 15.80514834 2020-05-24 02:32:43 Basilicata, Italy
2020-05-23 Italy Calabria     1157 96 773 288 38.90597598 16.59440194 2020-05-24 02:32:43 Calabria, Italy
2020-05-23 Italy Campania     4744 404 3067 1273 40.83956555 14.25084984 2020-05-24 02:32:43 Campania, Italy
2020-05-23 Italy Emilia-Romagna     27513 4047 18896 4570 44.49436681 11.3417208 2020-05-24 02:32:43 Emilia-Romagna, Italy
2020-05-23 Italy Friuli Venezia Giulia     3233 327 2447 459 45.6494354 13.76813649 2020-05-24 02:32:43 Friuli Venezia Giulia, Italy
2020-05-23 Italy Lazio     7607 676 3350 3581 41.89277044 12.48366722 2020-05-24 02:32:43 Lazio, Italy
2020-05-23 Italy Liguria     9427 1414 6279 1734 44.41149315 8.9326992 2020-05-24 02:32:43 Liguria, Italy
2020-05-23 Italy Lombardia     86825 15840 45355 25630 45.46679409 9.190347404 2020-05-24 02:32:43 Lombardia, Italy
2020-05-23 Italy Marche     6701 993 3995 1713 43.61675973 13.5188753 2020-05-24 02:32:43 Marche, Italy
2020-05-23 Italy Molise     431 22 220 189 41.55774754 14.65916051 2020-05-24 02:32:43 Molise, Italy
2020-05-23 Italy P.A. Bolzano     2590 291 2085 214 46.49933453 11.35662422 2020-05-24 02:32:43 P.A. Bolzano, Italy
2020-05-23 Italy P.A. Trento     4395 456 3374 565 46.06893511 11.12123097 2020-05-24 02:32:43 P.A. Trento, Italy
2020-05-23 Italy Piemonte     30137 3771 18341 8025 45.0732745 7.680687483 2020-05-24 02:32:43 Piemonte, Italy
2020-05-23 Italy Puglia     4448 486 2157 1805 41.12559576 16.86736689 2020-05-24 02:32:43 Puglia, Italy
2020-05-23 Italy Sardegna     1356 129 940 287 39.21531192 9.110616306 2020-05-24 02:32:43 Sardegna, Italy
2020-05-23 Italy Sicilia     3421 269 1640 1512 38.11569725 13.362356699999998 2020-05-24 02:32:43 Sicilia, Italy
2020-05-23 Italy Toscana     10047 1011 7270 1766 43.76923077 11.25588885 2020-05-24 02:32:43 Toscana, Italy
2020-05-23 Italy Umbria     1430 74 1300 56 43.10675841 12.38824698 2020-05-24 02:32:43 Umbria, Italy
2020-05-23 Italy Valle d'Aosta     1177 143 999 35 45.73750286 7.320149366 2020-05-24 02:32:43 Valle d'Aosta, Italy
2020-05-23 Italy Veneto     19069 1865 14363 2841 45.43490485 12.33845213 2020-05-24 02:32:43 Veneto, Italy
2020-02-03 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-26 Italy       453 12 3       2020-02-26T23:43:03  
2020-05-03 Italy       210717 28884 81654 100179 41.87194 12.56738 2020-05-04 02:32:28 Italy
2020-03-22 Italy       59138 5476 7024 46638 41.87194 12.56738 3/22/20 23:45 Italy
2020-02-17 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-20 Italy       3 0 0       2020-02-07T17:53:02  
2020-02-02 Italy       2 0 0       2020-01-31T08:15:53  
2020-02-29 Italy       1128 29 46       2020-02-29T18:03:05  
2020-04-23 Italy       189973 25549 57576 106848 41.87194 12.56738 2020-04-24 03:30:31 Italy
2020-02-19 Italy       3 0 0       2020-02-07T17:53:02  
2020-03-20 Italy       47021 4032 4440   41.8719 12.5674 2020-03-20T17:43:03  
2020-05-28 Italy Abruzzo     3237 402 2011 824 42.35122196 13.39843823 2020-05-29 02:32:50 Abruzzo, Italy
2020-05-28 Italy Basilicata     399 27 338 34 40.63947052 15.80514834 2020-05-29 02:32:50 Basilicata, Italy
2020-05-28 Italy Calabria     1158 96 892 170 38.90597598 16.59440194 2020-05-29 02:32:50 Calabria, Italy
2020-05-28 Italy Campania     4777 410 3355 1012 40.83956555 14.25084984 2020-05-29 02:32:50 Campania, Italy
2020-05-28 Italy Emilia-Romagna     27701 4094 19857 3750 44.49436681 11.341720800000001 2020-05-29 02:32:50 Emilia-Romagna, Italy
2020-05-28 Italy Friuli Venezia Giulia     3262 333 2593 336 45.6494354 13.76813649 2020-05-29 02:32:50 Friuli Venezia Giulia, Italy
2020-05-28 Italy Lazio     7693 708 3580 3405 41.89277044 12.48366722 2020-05-29 02:32:50 Lazio, Italy
2020-05-28 Italy Liguria     9605 1445 7015 1145 44.41149315 8.9326992 2020-05-29 02:32:50 Liguria, Italy
2020-05-28 Italy Lombardia     88183 15974 49296 22913 45.46679409 9.190347404 2020-05-29 02:32:50 Lombardia, Italy
2020-05-28 Italy Marche     6719 997 4376 1346 43.61675973 13.5188753 2020-05-29 02:32:50 Marche, Italy
2020-05-28 Italy Molise     435 22 250 163 41.55774754 14.65916051 2020-05-29 02:32:50 Molise, Italy
2020-05-28 Italy P.A. Bolzano     2595 291 2147 157 46.49933453 11.35662422 2020-05-29 02:32:50 P.A. Bolzano, Italy
2020-05-28 Italy P.A. Trento     4425 462 3505 458 46.06893511 11.12123097 2020-05-29 02:32:50 P.A. Trento, Italy
2020-05-28 Italy Piemonte     30445 3838 20535 6072 45.0732745 7.680687483 2020-05-29 02:32:50 Piemonte, Italy
2020-05-28 Italy Puglia     4481 496 2590 1395 41.12559576 16.86736689 2020-05-29 02:32:50 Puglia, Italy
2020-05-28 Italy Sardegna     1355 130 1025 200 39.21531192 9.110616306 2020-05-29 02:32:50 Sardegna, Italy
2020-05-28 Italy Sicilia     3438 272 2021 1145 38.11569725 13.362356699999998 2020-05-29 02:32:50 Sicilia, Italy
2020-05-28 Italy Toscana     10086 1029 7677 1380 43.76923077 11.25588885 2020-05-29 02:32:50 Toscana, Italy
2020-05-28 Italy Umbria     1431 75 1323 33 43.10675841 12.38824698 2020-05-29 02:32:50 Umbria, Italy
2020-05-28 Italy Valle d'Aosta     1182 143 1016 23 45.73750286 7.320149366 2020-05-29 02:32:50 Valle d'Aosta, Italy
2020-05-28 Italy Veneto     19125 1898 15202 2025 45.43490485 12.33845213 2020-05-29 02:32:50 Veneto, Italy
2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
2020-05-29 Italy Abruzzo     3237 404 2063 770 42.35122196 13.39843823 2020-05-30 02:32:48 Abruzzo, Italy
2020-05-29 Italy Basilicata     399 27 339 33 40.63947052 15.80514834 2020-05-30 02:32:48 Basilicata, Italy
2020-05-29 Italy Calabria     1158 97 902 159 38.90597598 16.59440194 2020-05-30 02:32:48 Calabria, Italy
2020-05-29 Italy Campania     4787 411 3390 986 40.83956555 14.25084984 2020-05-30 02:32:48 Campania, Italy
2020-05-29 Italy Emilia-Romagna     27739 4102 20073 3564 44.49436681 11.341720800000001 2020-05-30 02:32:48 Emilia-Romagna, Italy
2020-05-29 Italy Friuli Venezia Giulia     3267 333 2611 323 45.6494354 13.76813649 2020-05-30 02:32:48 Friuli Venezia Giulia, Italy
2020-05-29 Italy Lazio     7709 721 3825 3163 41.89277044 12.48366722 2020-05-30 02:32:48 Lazio, Italy
2020-05-29 Italy Liguria     9619 1452 7173 994 44.41149315 8.9326992 2020-05-30 02:32:48 Liguria, Italy
2020-05-29 Italy Lombardia     88537 16012 49842 22683 45.46679409 9.190347404 2020-05-30 02:32:48 Lombardia, Italy
2020-05-29 Italy Marche     6723 986 4385 1352 43.61675973 13.5188753 2020-05-30 02:32:48 Marche, Italy
2020-05-29 Italy Molise     436 22 252 162 41.55774754 14.65916051 2020-05-30 02:32:48 Molise, Italy
2020-05-29 Italy P.A. Bolzano     2595 291 2150 154 46.49933453 11.35662422 2020-05-30 02:32:48 P.A. Bolzano, Italy
2020-05-29 Italy P.A. Trento     4428 462 3556 410 46.06893511 11.12123097 2020-05-30 02:32:48 P.A. Trento, Italy
2020-05-29 Italy Piemonte     30501 3851 20992 5658 45.0732745 7.680687483 2020-05-30 02:32:48 Piemonte, Italy
2020-05-29 Italy Puglia     4482 500 2699 1283 41.12559576 16.86736689 2020-05-30 02:32:48 Puglia, Italy
2020-05-29 Italy Sardegna     1356 130 1036 190 39.21531192 9.110616306 2020-05-30 02:32:48 Sardegna, Italy
2020-05-29 Italy Sicilia     3440 272 2031 1137 38.11569725 13.362356699999998 2020-05-30 02:32:48 Sicilia, Italy
2020-05-29 Italy Toscana     10088 1031 7802 1255 43.76923077 11.25588885 2020-05-30 02:32:48 Toscana, Italy
2020-05-29 Italy Umbria     1431 76 1324 31 43.10675841 12.38824698 2020-05-30 02:32:48 Umbria, Italy
2020-05-29 Italy Valle d'Aosta     1182 143 1020 19 45.73750286 7.320149366 2020-05-30 02:32:48 Valle d'Aosta, Italy
2020-05-29 Italy Veneto     19134 1906 15379 1849 45.43490485 12.33845213 2020-05-30 02:32:48 Veneto, Italy
2020-02-28 Italy       888 21 46       2020-02-28T20:13:09  
2020-03-29 Italy       97689 10779 13030 73880 41.87194 12.56738 3/29/20 23:08 Italy
2020-05-08 Italy       217185 30201 99023 87961 41.87194 12.56738 2020-05-09 02:32:35 Italy
2020-02-24 Italy       229 7 1       2020-02-24T23:43:01  
2020-05-02 Italy       209328 28710 79914 100704 41.87194 12.56738 2020-05-03 02:32:28 Italy
2020-03-16 Italy       27980 2158 2749   41.8719 12.5674 2020-03-16T17:33:03  
2020-05-14 Italy Abruzzo     3136 379 1275 1482 42.35122196 13.39843823 2020-05-15 02:33:02 Abruzzo, Italy
2020-05-14 Italy Basilicata     389 27 235 127 40.63947052 15.80514834 2020-05-15 02:33:02 Basilicata, Italy
2020-05-14 Italy Calabria     1143 95 524 524 38.90597598 16.59440194 2020-05-15 02:33:02 Calabria, Italy
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 1988.274ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette