johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

6,236 rows where country_or_region = "Italy" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date)

province_or_state

country_or_region

  • Italy · 6,236 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
801264 801264 2021-03-01 Italy Abruzzo     54664 1709 39844 13111 42.35122196 13.39843823 2021-03-02 05:23:30 Abruzzo, Italy
801265 801265 2021-03-01 Italy Basilicata     15710 374 11242 4094 40.63947052 15.80514834 2021-03-02 05:23:30 Basilicata, Italy
801266 801266 2021-03-01 Italy Calabria     38031 688 31070 6273 38.90597598 16.59440194 2021-03-02 05:23:30 Calabria, Italy
801267 801267 2021-03-01 Italy Campania     269515 4298 187264 77953 40.83956555 14.25084984 2021-03-02 05:23:30 Campania, Italy
801268 801268 2021-03-01 Italy Emilia-Romagna     263194 10566 208350 44278 44.49436681 11.3417208 2021-03-02 05:23:30 Emilia-Romagna, Italy
801269 801269 2021-03-01 Italy Friuli Venezia Giulia     76984 2844 63978 10162 45.6494354 13.76813649 2021-03-02 05:23:30 Friuli Venezia Giulia, Italy
801270 801270 2021-03-01 Italy Lazio     235272 5911 193638 35723 41.89277044 12.48366722 2021-03-02 05:23:30 Lazio, Italy
801271 801271 2021-03-01 Italy Liguria     78287 3636 69166 5485 44.41149315 8.9326992 2021-03-02 05:23:30 Liguria, Italy
801272 801272 2021-03-01 Italy Lombardia     605216 28403 511811 65002 45.46679409 9.190347404 2021-03-02 05:23:30 Lombardia, Italy
801273 801273 2021-03-01 Italy Marche     68303 2259 56059 9985 43.61675973 13.5188753 2021-03-02 05:23:30 Marche, Italy
801274 801274 2021-03-01 Italy Molise     10732 352 8646 1734 41.55774754 14.65916051 2021-03-02 05:23:30 Molise, Italy
801275 801275 2021-03-01 Italy P.A. Bolzano     53925 1039 46160 6726 46.49933453 11.35662422 2021-03-02 05:23:30 P.A. Bolzano, Italy
801276 801276 2021-03-01 Italy P.A. Trento     34115 1208 29210 3697 46.06893511 11.12123097 2021-03-02 05:23:30 P.A. Trento, Italy
801277 801277 2021-03-01 Italy Piemonte     248289 9375 222293 16621 45.0732745 7.680687483 2021-03-02 05:23:30 Piemonte, Italy
801278 801278 2021-03-01 Italy Puglia     147681 3952 110767 32962 41.12559576 16.86736689 2021-03-02 05:23:30 Puglia, Italy
801279 801279 2021-03-01 Italy Sardegna     41236 1166 27265 12805 39.21531192 9.110616306 2021-03-02 05:23:30 Sardegna, Italy
801280 801280 2021-03-01 Italy Sicilia     153036 4156 122699 26181 38.11569725 13.362356699999998 2021-03-02 05:23:30 Sicilia, Italy
801281 801281 2021-03-01 Italy Toscana     157112 4686 133961 18465 43.76923077 11.25588885 2021-03-02 05:23:30 Toscana, Italy
801282 801282 2021-03-01 Italy Umbria     44762 1056 35708 7998 43.10675841 12.38824698 2021-03-02 05:23:30 Umbria, Italy
801283 801283 2021-03-01 Italy Valle d'Aosta     8057 415 7474 168 45.73750286 7.320149366 2021-03-02 05:23:30 Valle d'Aosta, Italy
801284 801284 2021-03-01 Italy Veneto     334250 9852 299488 24910 45.43490485 12.33845213 2021-03-02 05:23:30 Veneto, Italy
1066406 1066406 2021-02-28 Italy Abruzzo     54468 1701 39523 13244 42.35122196 13.39843823 2021-03-01 05:23:01 Abruzzo, Italy
1066407 1066407 2021-02-28 Italy Basilicata     15635 371 11232 4032 40.63947052 15.80514834 2021-03-01 05:23:01 Basilicata, Italy
1066408 1066408 2021-02-28 Italy Calabria     37880 683 30933 6264 38.90597598 16.59440194 2021-03-01 05:23:01 Calabria, Italy
1066409 1066409 2021-02-28 Italy Campania     267619 4278 186318 77023 40.83956555 14.25084984 2021-03-01 05:23:01 Campania, Italy
1066410 1066410 2021-02-28 Italy Emilia-Romagna     260602 10543 207381 42678 44.49436681 11.3417208 2021-03-01 05:23:01 Emilia-Romagna, Italy
1066411 1066411 2021-02-28 Italy Friuli Venezia Giulia     76812 2841 63889 10082 45.6494354 13.76813649 2021-03-01 05:23:01 Friuli Venezia Giulia, Italy
1066412 1066412 2021-02-28 Italy Lazio     234228 5883 192544 35801 41.89277044 12.48366722 2021-03-01 05:23:01 Lazio, Italy
1066413 1066413 2021-02-28 Italy Liguria     77978 3630 68965 5383 44.41149315 8.9326992 2021-03-01 05:23:01 Liguria, Italy
1066414 1066414 2021-02-28 Italy Lombardia     603081 28361 508379 66341 45.46679409 9.190347404 2021-03-01 05:23:01 Lombardia, Italy
1066415 1066415 2021-02-28 Italy Marche     67857 2252 55375 10230 43.61675973 13.5188753 2021-03-01 05:23:01 Marche, Italy
1066416 1066416 2021-02-28 Italy Molise     10691 351 8564 1776 41.55774754 14.65916051 2021-03-01 05:23:01 Molise, Italy
1066417 1066417 2021-02-28 Italy P.A. Bolzano     53804 1031 46071 6702 46.49933453 11.35662422 2021-03-01 05:23:01 P.A. Bolzano, Italy
1066418 1066418 2021-02-28 Italy P.A. Trento     34058 1206 28919 3933 46.06893511 11.12123097 2021-03-01 05:23:01 P.A. Trento, Italy
1066419 1066419 2021-02-28 Italy Piemonte     247134 9369 221688 16077 45.0732745 7.680687483 2021-03-01 05:23:01 Piemonte, Italy
1066420 1066420 2021-02-28 Italy Puglia     147050 3923 110046 33081 41.12559576 16.86736689 2021-03-01 05:23:01 Puglia, Italy
1066421 1066421 2021-02-28 Italy Sardegna     41191 1158 27178 12855 39.21531192 9.110616306 2021-03-01 05:23:01 Sardegna, Italy
1066422 1066422 2021-02-28 Italy Sicilia     152558 4138 122438 25982 38.11569725 13.362356699999998 2021-03-01 05:23:01 Sicilia, Italy
1066423 1066423 2021-02-28 Italy Toscana     156235 4668 133518 18049 43.76923077 11.25588885 2021-03-01 05:23:01 Toscana, Italy
1066424 1066424 2021-02-28 Italy Umbria     44683 1050 35492 8141 43.10675841 12.38824698 2021-03-01 05:23:01 Umbria, Italy
1066425 1066425 2021-02-28 Italy Valle d'Aosta     8054 415 7465 174 45.73750286 7.320149366 2021-03-01 05:23:01 Valle d'Aosta, Italy
1066426 1066426 2021-02-28 Italy Veneto     333647 9847 299281 24519 45.43490485 12.33845213 2021-03-01 05:23:01 Veneto, Italy
744799 744799 2021-02-27 Italy Abruzzo     53900 1698 39479 12723 42.35122196 13.39843823 2021-02-28 05:22:20 Abruzzo, Italy
744800 744800 2021-02-27 Italy Basilicata     15534 371 11212 3951 40.63947052 15.80514834 2021-02-28 05:22:20 Basilicata, Italy
744801 744801 2021-02-27 Italy Calabria     37720 680 30736 6304 38.90597598 16.59440194 2021-02-28 05:22:20 Calabria, Italy
744802 744802 2021-02-27 Italy Campania     265058 4273 185794 74991 40.83956555 14.25084984 2021-02-28 05:22:20 Campania, Italy
744803 744803 2021-02-27 Italy Emilia-Romagna     258007 10521 206815 40671 44.49436681 11.3417208 2021-02-28 05:22:20 Emilia-Romagna, Italy
744804 744804 2021-02-27 Italy Friuli Venezia Giulia     76471 2834 63652 9985 45.6494354 13.76813649 2021-02-28 05:22:20 Friuli Venezia Giulia, Italy
744805 744805 2021-02-27 Italy Lazio     232887 5871 191352 35664 41.89277044 12.48366722 2021-02-28 05:22:20 Lazio, Italy
744806 744806 2021-02-27 Italy Liguria     77730 3628 68901 5201 44.41149315 8.9326992 2021-02-28 05:22:20 Liguria, Italy
744807 744807 2021-02-27 Italy Lombardia     599552 28324 507514 63714 45.46679409 9.190347404 2021-02-28 05:22:20 Lombardia, Italy
744808 744808 2021-02-27 Italy Marche     67269 2240 54970 10059 43.61675973 13.5188753 2021-02-28 05:22:20 Marche, Italy
744809 744809 2021-02-27 Italy Molise     10547 349 8460 1738 41.55774754 14.65916051 2021-02-28 05:22:20 Molise, Italy
744810 744810 2021-02-27 Italy P.A. Bolzano     53578 1026 45768 6784 46.49933453 11.35662422 2021-02-28 05:22:20 P.A. Bolzano, Italy
744811 744811 2021-02-27 Italy P.A. Trento     33729 1206 28868 3655 46.06893511 11.12123097 2021-02-28 05:22:20 P.A. Trento, Italy
744812 744812 2021-02-27 Italy Piemonte     246232 9365 221224 15643 45.0732745 7.680687483 2021-02-28 05:22:20 Piemonte, Italy
744813 744813 2021-02-27 Italy Puglia     145997 3907 109633 32457 41.12559576 16.86736689 2021-02-28 05:22:20 Puglia, Italy
744814 744814 2021-02-27 Italy Sardegna     41114 1153 27126 12835 39.21531192 9.110616306 2021-02-28 05:22:20 Sardegna, Italy
744815 744815 2021-02-27 Italy Sicilia     152105 4117 122217 25771 38.11569725 13.362356699999998 2021-02-28 05:22:20 Sicilia, Italy
744816 744816 2021-02-27 Italy Toscana     155167 4655 133083 17429 43.76923077 11.25588885 2021-02-28 05:22:20 Toscana, Italy
744817 744817 2021-02-27 Italy Umbria     44471 1037 35219 8215 43.10675841 12.38824698 2021-02-28 05:22:20 Umbria, Italy
744818 744818 2021-02-27 Italy Valle d'Aosta     8021 415 7462 144 45.73750286 7.320149366 2021-02-28 05:22:20 Valle d'Aosta, Italy
744819 744819 2021-02-27 Italy Veneto     332736 9837 298867 24032 45.43490485 12.33845213 2021-02-28 05:22:20 Veneto, Italy
950943 950943 2021-02-26 Italy Abruzzo     53545 1689 39125 12731 42.35122196 13.39843823 2021-02-27 05:22:28 Abruzzo, Italy
950944 950944 2021-02-26 Italy Basilicata     15414 370 11184 3860 40.63947052 15.80514834 2021-02-27 05:22:28 Basilicata, Italy
950945 950945 2021-02-26 Italy Calabria     37533 677 30617 6239 38.90597598 16.59440194 2021-02-27 05:22:28 Calabria, Italy
950946 950946 2021-02-26 Italy Campania     262843 4259 184883 73701 40.83956555 14.25084984 2021-02-27 05:22:28 Campania, Italy
950947 950947 2021-02-26 Italy Emilia-Romagna     255479 10489 205768 39222 44.49436681 11.3417208 2021-02-27 05:22:28 Emilia-Romagna, Italy
950948 950948 2021-02-26 Italy Friuli Venezia Giulia     76003 2823 63305 9875 45.6494354 13.76813649 2021-02-27 05:22:28 Friuli Venezia Giulia, Italy
950949 950949 2021-02-26 Italy Lazio     231540 5851 190256 35433 41.89277044 12.48366722 2021-02-27 05:22:28 Lazio, Italy
950950 950950 2021-02-26 Italy Liguria     77379 3620 68576 5183 44.41149315 8.9326992 2021-02-27 05:22:28 Liguria, Italy
950951 950951 2021-02-26 Italy Lombardia     595361 28275 505819 61267 45.46679409 9.190347404 2021-02-27 05:22:28 Lombardia, Italy
950952 950952 2021-02-26 Italy Marche     66471 2224 54503 9744 43.61675973 13.5188753 2021-02-27 05:22:28 Marche, Italy
950953 950953 2021-02-26 Italy Molise     10484 349 8389 1746 41.55774754 14.65916051 2021-02-27 05:22:28 Molise, Italy
950954 950954 2021-02-26 Italy P.A. Bolzano     53207 1022 45410 6775 46.49933453 11.35662422 2021-02-27 05:22:28 P.A. Bolzano, Italy
950955 950955 2021-02-26 Italy P.A. Trento     33388 1204 28663 3521 46.06893511 11.12123097 2021-02-27 05:22:28 P.A. Trento, Italy
950956 950956 2021-02-26 Italy Piemonte     245044 9351 220570 15123 45.0732745 7.680687483 2021-02-27 05:22:28 Piemonte, Italy
950957 950957 2021-02-26 Italy Puglia     144874 3887 108948 32039 41.12559576 16.86736689 2021-02-27 05:22:28 Puglia, Italy
950958 950958 2021-02-26 Italy Sardegna     41027 1147 27063 12817 39.21531192 9.110616306 2021-02-27 05:22:28 Sardegna, Italy
950959 950959 2021-02-26 Italy Sicilia     151587 4096 120894 26597 38.11569725 13.362356699999998 2021-02-27 05:22:28 Sicilia, Italy
950960 950960 2021-02-26 Italy Toscana     154041 4635 132523 16883 43.76923077 11.25588885 2021-02-27 05:22:28 Toscana, Italy
950961 950961 2021-02-26 Italy Umbria     44241 1030 34883 8328 43.10675841 12.38824698 2021-02-27 05:22:28 Umbria, Italy
950962 950962 2021-02-26 Italy Valle d'Aosta     8011 415 7455 141 45.73750286 7.320149366 2021-02-27 05:22:28 Valle d'Aosta, Italy
950963 950963 2021-02-26 Italy Veneto     331451 9814 298198 23439 45.43490485 12.33845213 2021-02-27 05:22:28 Veneto, Italy
1279899 1279899 2021-02-25 Italy Abruzzo     52951 1678 38638 12635 42.35122196 13.39843823 2021-02-26 05:22:40 Abruzzo, Italy
1279900 1279900 2021-02-25 Italy Basilicata     15327 370 11094 3863 40.63947052 15.80514834 2021-02-26 05:22:40 Basilicata, Italy
1279901 1279901 2021-02-25 Italy Calabria     37292 674 30484 6134 38.90597598 16.59440194 2021-02-26 05:22:40 Calabria, Italy
1279902 1279902 2021-02-25 Italy Campania     260324 4248 183104 72972 40.83956555 14.25084984 2021-02-26 05:22:40 Campania, Italy
1279903 1279903 2021-02-25 Italy Emilia-Romagna     252915 10459 204763 37693 44.49436681 11.3417208 2021-02-26 05:22:40 Emilia-Romagna, Italy
1279904 1279904 2021-02-25 Italy Friuli Venezia Giulia     75535 2817 63078 9640 45.6494354 13.76813649 2021-02-26 05:22:40 Friuli Venezia Giulia, Italy
1279905 1279905 2021-02-25 Italy Lazio     230001 5832 189174 34995 41.89277044 12.48366722 2021-02-26 05:22:40 Lazio, Italy
1279906 1279906 2021-02-25 Italy Liguria     77028 3615 68338 5075 44.41149315 8.9326992 2021-02-26 05:22:40 Liguria, Italy
1279907 1279907 2021-02-25 Italy Lombardia     590804 28228 504748 57828 45.46679409 9.190347404 2021-02-26 05:22:40 Lombardia, Italy
1279908 1279908 2021-02-25 Italy Marche     65785 2219 53956 9610 43.61675973 13.5188753 2021-02-26 05:22:40 Marche, Italy
1279909 1279909 2021-02-25 Italy Molise     10353 346 8309 1698 41.55774754 14.65916051 2021-02-26 05:22:40 Molise, Italy
1279910 1279910 2021-02-25 Italy P.A. Bolzano     52857 1015 44913 6929 46.49933453 11.35662422 2021-02-26 05:22:40 P.A. Bolzano, Italy
1279911 1279911 2021-02-25 Italy P.A. Trento     33037 1203 28519 3315 46.06893511 11.12123097 2021-02-26 05:22:40 P.A. Trento, Italy
1279912 1279912 2021-02-25 Italy Piemonte     243518 9346 219849 14323 45.0732745 7.680687483 2021-02-26 05:22:40 Piemonte, Italy
1279913 1279913 2021-02-25 Italy Puglia     143770 3865 107933 31972 41.12559576 16.86736689 2021-02-26 05:22:40 Puglia, Italy
1279914 1279914 2021-02-25 Italy Sardegna     40957 1142 26923 12892 39.21531192 9.110616306 2021-02-26 05:22:40 Sardegna, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);