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

20,264 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: combined_key, day (date), last_update (date)

province_or_state 21

country_or_region 1

  • Italy · 20,264 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752866 2752866 2022-12-29 Italy Abruzzo     630829 3816 0   42.35122196 13.39843823 2022-12-30 04:21:04 Abruzzo, Italy
2752867 2752867 2022-12-29 Italy Basilicata     195598 1009 0   40.63947052 15.80514834 2022-12-30 04:21:04 Basilicata, Italy
2752868 2752868 2022-12-29 Italy Calabria     611274 3181 0   38.90597598 16.59440194 2022-12-30 04:21:04 Calabria, Italy
2752869 2752869 2022-12-29 Italy Campania     2394783 11501 0   40.83956555 14.25084984 2022-12-30 04:21:04 Campania, Italy
2752870 2752870 2022-12-29 Italy Emilia-Romagna     2095414 18849 0   44.49436681 11.3417208 2022-12-30 04:21:04 Emilia-Romagna, Italy
2752871 2752871 2022-12-29 Italy Friuli Venezia Giulia     561996 5815 0   45.6494354 13.76813649 2022-12-30 04:21:04 Friuli Venezia Giulia, Italy
2752872 2752872 2022-12-29 Italy Lazio     2309905 12504 0   41.89277044 12.48366722 2022-12-30 04:21:04 Lazio, Italy
2752873 2752873 2022-12-29 Italy Liguria     649217 5735 0   44.41149315 8.9326992 2022-12-30 04:21:04 Liguria, Italy
2752874 2752874 2022-12-29 Italy Lombardia     4043487 44489 0   45.46679409 9.190347404 2022-12-30 04:21:04 Lombardia, Italy
2752875 2752875 2022-12-29 Italy Marche     698559 4271 0   43.61675973 13.5188753 2022-12-30 04:21:04 Marche, Italy
2752876 2752876 2022-12-29 Italy Molise     99054 702 0   41.55774754 14.65916051 2022-12-30 04:21:04 Molise, Italy
2752877 2752877 2022-12-29 Italy P.A. Bolzano     289320 1598 0   46.49933453 11.35662422 2022-12-30 04:21:04 P.A. Bolzano, Italy
2752878 2752878 2022-12-29 Italy P.A. Trento     239668 1631 0   46.06893511 11.12123097 2022-12-30 04:21:04 P.A. Trento, Italy
2752879 2752879 2022-12-29 Italy Piemonte     1694793 13762 0   45.0732745 7.680687483 2022-12-30 04:21:04 Piemonte, Italy
2752880 2752880 2022-12-29 Italy Puglia     1586253 9385 0   41.12559576 16.86736689 2022-12-30 04:21:04 Puglia, Italy
2752881 2752881 2022-12-29 Italy Sardegna     495931 2862 0   39.21531192 9.110616306 2022-12-30 04:21:04 Sardegna, Italy
2752882 2752882 2022-12-29 Italy Sicilia     1767494 12410 0   38.11569725 13.3623567 2022-12-30 04:21:04 Sicilia, Italy
2752883 2752883 2022-12-29 Italy Toscana     1559572 11308 0   43.76923077 11.25588885 2022-12-30 04:21:04 Toscana, Italy
2752884 2752884 2022-12-29 Italy Umbria     425121 2320 0   43.10675841 12.38824698 2022-12-30 04:21:04 Umbria, Italy
2752885 2752885 2022-12-29 Italy Valle d'Aosta     49791 562 0   45.73750286 7.320149366 2022-12-30 04:21:04 Valle d'Aosta, Italy
2752886 2752886 2022-12-29 Italy Veneto     2623547 16226 0   45.43490485 12.33845213 2022-12-30 04:21:04 Veneto, Italy
1073872 1073872 2022-12-28 Italy Abruzzo     630829 3816 0   42.35122196 13.39843823 2022-12-29 04:21:01 Abruzzo, Italy
1073873 1073873 2022-12-28 Italy Basilicata     195598 1009 0   40.63947052 15.80514834 2022-12-29 04:21:01 Basilicata, Italy
1073874 1073874 2022-12-28 Italy Calabria     611274 3181 0   38.90597598 16.59440194 2022-12-29 04:21:01 Calabria, Italy
1073875 1073875 2022-12-28 Italy Campania     2394783 11501 0   40.83956555 14.25084984 2022-12-29 04:21:01 Campania, Italy
1073876 1073876 2022-12-28 Italy Emilia-Romagna     2095414 18849 0   44.49436681 11.3417208 2022-12-29 04:21:01 Emilia-Romagna, Italy
1073877 1073877 2022-12-28 Italy Friuli Venezia Giulia     561996 5815 0   45.6494354 13.76813649 2022-12-29 04:21:01 Friuli Venezia Giulia, Italy
1073878 1073878 2022-12-28 Italy Lazio     2309905 12504 0   41.89277044 12.48366722 2022-12-29 04:21:01 Lazio, Italy
1073879 1073879 2022-12-28 Italy Liguria     649217 5735 0   44.41149315 8.9326992 2022-12-29 04:21:01 Liguria, Italy
1073880 1073880 2022-12-28 Italy Lombardia     4043487 44489 0   45.46679409 9.190347404 2022-12-29 04:21:01 Lombardia, Italy
1073881 1073881 2022-12-28 Italy Marche     698559 4271 0   43.61675973 13.5188753 2022-12-29 04:21:01 Marche, Italy
1073882 1073882 2022-12-28 Italy Molise     99054 702 0   41.55774754 14.65916051 2022-12-29 04:21:01 Molise, Italy
1073883 1073883 2022-12-28 Italy P.A. Bolzano     289320 1598 0   46.49933453 11.35662422 2022-12-29 04:21:01 P.A. Bolzano, Italy
1073884 1073884 2022-12-28 Italy P.A. Trento     239668 1631 0   46.06893511 11.12123097 2022-12-29 04:21:01 P.A. Trento, Italy
1073885 1073885 2022-12-28 Italy Piemonte     1694793 13762 0   45.0732745 7.680687483 2022-12-29 04:21:01 Piemonte, Italy
1073886 1073886 2022-12-28 Italy Puglia     1586253 9385 0   41.12559576 16.86736689 2022-12-29 04:21:01 Puglia, Italy
1073887 1073887 2022-12-28 Italy Sardegna     495931 2862 0   39.21531192 9.110616306 2022-12-29 04:21:01 Sardegna, Italy
1073888 1073888 2022-12-28 Italy Sicilia     1767494 12410 0   38.11569725 13.3623567 2022-12-29 04:21:01 Sicilia, Italy
1073889 1073889 2022-12-28 Italy Toscana     1559572 11308 0   43.76923077 11.25588885 2022-12-29 04:21:01 Toscana, Italy
1073890 1073890 2022-12-28 Italy Umbria     425121 2320 0   43.10675841 12.38824698 2022-12-29 04:21:01 Umbria, Italy
1073891 1073891 2022-12-28 Italy Valle d'Aosta     49791 562 0   45.73750286 7.320149366 2022-12-29 04:21:01 Valle d'Aosta, Italy
1073892 1073892 2022-12-28 Italy Veneto     2623547 16226 0   45.43490485 12.33845213 2022-12-29 04:21:01 Veneto, Italy
327869 327869 2022-12-27 Italy Abruzzo     630829 3816 0   42.35122196 13.39843823 2022-12-28 04:21:04 Abruzzo, Italy
327870 327870 2022-12-27 Italy Basilicata     195598 1009 0   40.63947052 15.80514834 2022-12-28 04:21:04 Basilicata, Italy
327871 327871 2022-12-27 Italy Calabria     611274 3181 0   38.90597598 16.59440194 2022-12-28 04:21:04 Calabria, Italy
327872 327872 2022-12-27 Italy Campania     2394783 11501 0   40.83956555 14.25084984 2022-12-28 04:21:04 Campania, Italy
327873 327873 2022-12-27 Italy Emilia-Romagna     2095414 18849 0   44.49436681 11.3417208 2022-12-28 04:21:04 Emilia-Romagna, Italy
327874 327874 2022-12-27 Italy Friuli Venezia Giulia     561996 5815 0   45.6494354 13.76813649 2022-12-28 04:21:04 Friuli Venezia Giulia, Italy
327875 327875 2022-12-27 Italy Lazio     2309905 12504 0   41.89277044 12.48366722 2022-12-28 04:21:04 Lazio, Italy
327876 327876 2022-12-27 Italy Liguria     649217 5735 0   44.41149315 8.9326992 2022-12-28 04:21:04 Liguria, Italy
327877 327877 2022-12-27 Italy Lombardia     4043487 44489 0   45.46679409 9.190347404 2022-12-28 04:21:04 Lombardia, Italy
327878 327878 2022-12-27 Italy Marche     698559 4271 0   43.61675973 13.5188753 2022-12-28 04:21:04 Marche, Italy
327879 327879 2022-12-27 Italy Molise     99054 702 0   41.55774754 14.65916051 2022-12-28 04:21:04 Molise, Italy
327880 327880 2022-12-27 Italy P.A. Bolzano     289320 1598 0   46.49933453 11.35662422 2022-12-28 04:21:04 P.A. Bolzano, Italy
327881 327881 2022-12-27 Italy P.A. Trento     239668 1631 0   46.06893511 11.12123097 2022-12-28 04:21:04 P.A. Trento, Italy
327882 327882 2022-12-27 Italy Piemonte     1694793 13762 0   45.0732745 7.680687483 2022-12-28 04:21:04 Piemonte, Italy
327883 327883 2022-12-27 Italy Puglia     1586253 9385 0   41.12559576 16.86736689 2022-12-28 04:21:04 Puglia, Italy
327884 327884 2022-12-27 Italy Sardegna     495931 2862 0   39.21531192 9.110616306 2022-12-28 04:21:04 Sardegna, Italy
327885 327885 2022-12-27 Italy Sicilia     1767494 12410 0   38.11569725 13.3623567 2022-12-28 04:21:04 Sicilia, Italy
327886 327886 2022-12-27 Italy Toscana     1559572 11308 0   43.76923077 11.25588885 2022-12-28 04:21:04 Toscana, Italy
327887 327887 2022-12-27 Italy Umbria     425121 2320 0   43.10675841 12.38824698 2022-12-28 04:21:04 Umbria, Italy
327888 327888 2022-12-27 Italy Valle d'Aosta     49791 562 0   45.73750286 7.320149366 2022-12-28 04:21:04 Valle d'Aosta, Italy
327889 327889 2022-12-27 Italy Veneto     2623547 16226 0   45.43490485 12.33845213 2022-12-28 04:21:04 Veneto, Italy
217942 217942 2022-12-26 Italy Abruzzo     630829 3816 0   42.35122196 13.39843823 2022-12-27 04:21:07 Abruzzo, Italy
217943 217943 2022-12-26 Italy Basilicata     195598 1009 0   40.63947052 15.80514834 2022-12-27 04:21:07 Basilicata, Italy
217944 217944 2022-12-26 Italy Calabria     611274 3181 0   38.90597598 16.59440194 2022-12-27 04:21:07 Calabria, Italy
217945 217945 2022-12-26 Italy Campania     2394783 11501 0   40.83956555 14.25084984 2022-12-27 04:21:07 Campania, Italy
217946 217946 2022-12-26 Italy Emilia-Romagna     2095414 18849 0   44.49436681 11.3417208 2022-12-27 04:21:07 Emilia-Romagna, Italy
217947 217947 2022-12-26 Italy Friuli Venezia Giulia     561996 5815 0   45.6494354 13.76813649 2022-12-27 04:21:07 Friuli Venezia Giulia, Italy
217948 217948 2022-12-26 Italy Lazio     2309905 12504 0   41.89277044 12.48366722 2022-12-27 04:21:07 Lazio, Italy
217949 217949 2022-12-26 Italy Liguria     649217 5735 0   44.41149315 8.9326992 2022-12-27 04:21:07 Liguria, Italy
217950 217950 2022-12-26 Italy Lombardia     4043487 44489 0   45.46679409 9.190347404 2022-12-27 04:21:07 Lombardia, Italy
217951 217951 2022-12-26 Italy Marche     698559 4271 0   43.61675973 13.5188753 2022-12-27 04:21:07 Marche, Italy
217952 217952 2022-12-26 Italy Molise     99054 702 0   41.55774754 14.65916051 2022-12-27 04:21:07 Molise, Italy
217953 217953 2022-12-26 Italy P.A. Bolzano     289320 1598 0   46.49933453 11.35662422 2022-12-27 04:21:07 P.A. Bolzano, Italy
217954 217954 2022-12-26 Italy P.A. Trento     239668 1631 0   46.06893511 11.12123097 2022-12-27 04:21:07 P.A. Trento, Italy
217955 217955 2022-12-26 Italy Piemonte     1694793 13762 0   45.0732745 7.680687483 2022-12-27 04:21:07 Piemonte, Italy
217956 217956 2022-12-26 Italy Puglia     1586253 9385 0   41.12559576 16.86736689 2022-12-27 04:21:07 Puglia, Italy
217957 217957 2022-12-26 Italy Sardegna     495931 2862 0   39.21531192 9.110616306 2022-12-27 04:21:07 Sardegna, Italy
217958 217958 2022-12-26 Italy Sicilia     1767494 12410 0   38.11569725 13.3623567 2022-12-27 04:21:07 Sicilia, Italy
217959 217959 2022-12-26 Italy Toscana     1559572 11308 0   43.76923077 11.25588885 2022-12-27 04:21:07 Toscana, Italy
217960 217960 2022-12-26 Italy Umbria     425121 2320 0   43.10675841 12.38824698 2022-12-27 04:21:07 Umbria, Italy
217961 217961 2022-12-26 Italy Valle d'Aosta     49791 562 0   45.73750286 7.320149366 2022-12-27 04:21:07 Valle d'Aosta, Italy
217962 217962 2022-12-26 Italy Veneto     2623547 16226 0   45.43490485 12.33845213 2022-12-27 04:21:07 Veneto, Italy
3222399 3222399 2022-12-25 Italy Abruzzo     630829 3816 0   42.35122196 13.39843823 2022-12-26 04:21:06 Abruzzo, Italy
3222400 3222400 2022-12-25 Italy Basilicata     195598 1009 0   40.63947052 15.80514834 2022-12-26 04:21:06 Basilicata, Italy
3222401 3222401 2022-12-25 Italy Calabria     611274 3181 0   38.90597598 16.59440194 2022-12-26 04:21:06 Calabria, Italy
3222402 3222402 2022-12-25 Italy Campania     2394783 11501 0   40.83956555 14.25084984 2022-12-26 04:21:06 Campania, Italy
3222403 3222403 2022-12-25 Italy Emilia-Romagna     2095414 18849 0   44.49436681 11.3417208 2022-12-26 04:21:06 Emilia-Romagna, Italy
3222404 3222404 2022-12-25 Italy Friuli Venezia Giulia     561996 5815 0   45.6494354 13.76813649 2022-12-26 04:21:06 Friuli Venezia Giulia, Italy
3222405 3222405 2022-12-25 Italy Lazio     2309905 12504 0   41.89277044 12.48366722 2022-12-26 04:21:06 Lazio, Italy
3222406 3222406 2022-12-25 Italy Liguria     649217 5735 0   44.41149315 8.9326992 2022-12-26 04:21:06 Liguria, Italy
3222407 3222407 2022-12-25 Italy Lombardia     4043487 44489 0   45.46679409 9.190347404 2022-12-26 04:21:06 Lombardia, Italy
3222408 3222408 2022-12-25 Italy Marche     698559 4271 0   43.61675973 13.5188753 2022-12-26 04:21:06 Marche, Italy
3222409 3222409 2022-12-25 Italy Molise     99054 702 0   41.55774754 14.65916051 2022-12-26 04:21:06 Molise, Italy
3222410 3222410 2022-12-25 Italy P.A. Bolzano     289320 1598 0   46.49933453 11.35662422 2022-12-26 04:21:06 P.A. Bolzano, Italy
3222411 3222411 2022-12-25 Italy P.A. Trento     239668 1631 0   46.06893511 11.12123097 2022-12-26 04:21:06 P.A. Trento, Italy
3222412 3222412 2022-12-25 Italy Piemonte     1694793 13762 0   45.0732745 7.680687483 2022-12-26 04:21:06 Piemonte, Italy
3222413 3222413 2022-12-25 Italy Puglia     1586253 9385 0   41.12559576 16.86736689 2022-12-26 04:21:06 Puglia, Italy
3222414 3222414 2022-12-25 Italy Sardegna     495931 2862 0   39.21531192 9.110616306 2022-12-26 04:21:06 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]);