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

21 rows where country_or_region = "Italy" and last_update = "2022-04-25 04:20:56" sorted by day descending

✎ View and edit SQL

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

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

country_or_region 1

  • Italy · 21 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2028732 2028732 2022-04-24 Italy Abruzzo     362539 3188 0   42.35122196 13.39843823 2022-04-25 04:20:56 Abruzzo, Italy
2028733 2028733 2022-04-24 Italy Basilicata     123502 873 0   40.63947052 15.80514834 2022-04-25 04:20:56 Basilicata, Italy
2028734 2028734 2022-04-24 Italy Calabria     347234 2465 0   38.90597598 16.59440194 2022-04-25 04:20:56 Calabria, Italy
2028735 2028735 2022-04-24 Italy Campania     1566189 10232 0   40.83956555 14.25084984 2022-04-25 04:20:56 Campania, Italy
2028736 2028736 2022-04-24 Italy Emilia-Romagna     1386761 16540 0   44.49436681 11.341720800000001 2022-04-25 04:20:56 Emilia-Romagna, Italy
2028737 2028737 2022-04-24 Italy Friuli Venezia Giulia     358052 4982 0   45.6494354 13.76813649 2022-04-25 04:20:56 Friuli Venezia Giulia, Italy
2028738 2028738 2022-04-24 Italy Lazio     1451389 11025 0   41.89277044 12.48366722 2022-04-25 04:20:56 Lazio, Italy
2028739 2028739 2022-04-24 Italy Liguria     419513 5253 0   44.41149315 8.9326992 2022-04-25 04:20:56 Liguria, Italy
2028740 2028740 2022-04-24 Italy Lombardia     2723970 39814 0   45.46679409 9.190347404 2022-04-25 04:20:56 Lombardia, Italy
2028741 2028741 2022-04-24 Italy Marche     434734 3821 0   43.61675973 13.5188753 2022-04-25 04:20:56 Marche, Italy
2028742 2028742 2022-04-24 Italy Molise     57768 610 0   41.55774754 14.65916051 2022-04-25 04:20:56 Molise, Italy
2028743 2028743 2022-04-24 Italy P.A. Bolzano     208814 1460 0   46.49933453 11.35662422 2022-04-25 04:20:56 P.A. Bolzano, Italy
2028744 2028744 2022-04-24 Italy P.A. Trento     158953 1553 0   46.06893511 11.12123097 2022-04-25 04:20:56 P.A. Trento, Italy
2028745 2028745 2022-04-24 Italy Piemonte     1125530 13292 0   45.0732745 7.680687483 2022-04-25 04:20:56 Piemonte, Italy
2028746 2028746 2022-04-24 Italy Puglia     1040836 8220 0   41.12559576 16.86736689 2022-04-25 04:20:56 Puglia, Italy
2028747 2028747 2022-04-24 Italy Sardegna     270265 2331 0   39.21531192 9.110616306 2022-04-25 04:20:56 Sardegna, Italy
2028748 2028748 2022-04-24 Italy Sicilia     1088091 10486 0   38.11569725 13.362356699999998 2022-04-25 04:20:56 Sicilia, Italy
2028749 2028749 2022-04-24 Italy Toscana     1078868 9791 0   43.76923077 11.25588885 2022-04-25 04:20:56 Toscana, Italy
2028750 2028750 2022-04-24 Italy Umbria     262399 1831 0   43.10675841 12.38824698 2022-04-25 04:20:56 Umbria, Italy
2028751 2028751 2022-04-24 Italy Valle d'Aosta     34598 529 0   45.73750286 7.320149366 2022-04-25 04:20:56 Valle d'Aosta, Italy
2028752 2028752 2022-04-24 Italy Veneto     1636052 14392 0   45.43490485 12.33845213 2022-04-25 04:20:56 Veneto, Italy

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