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 "day" is on date 2022-11-06 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
1049801 1049801 2022-11-06 Italy Abruzzo     590221 3720 0   42.35122196 13.39843823 2022-11-07 04:21:26 Abruzzo, Italy
1049802 1049802 2022-11-06 Italy Basilicata     189424 990 0   40.63947052 15.80514834 2022-11-07 04:21:26 Basilicata, Italy
1049803 1049803 2022-11-06 Italy Calabria     582921 3067 0   38.90597598 16.59440194 2022-11-07 04:21:26 Calabria, Italy
1049804 1049804 2022-11-06 Italy Campania     2299733 11299 0   40.83956555 14.25084984 2022-11-07 04:21:26 Campania, Italy
1049805 1049805 2022-11-06 Italy Emilia-Romagna     1966155 18280 0   44.49436681 11.3417208 2022-11-07 04:21:26 Emilia-Romagna, Italy
1049806 1049806 2022-11-06 Italy Friuli Venezia Giulia     527913 5587 0   45.6494354 13.76813649 2022-11-07 04:21:26 Friuli Venezia Giulia, Italy
1049807 1049807 2022-11-06 Italy Lazio     2177494 12237 0   41.89277044 12.48366722 2022-11-07 04:21:26 Lazio, Italy
1049808 1049808 2022-11-06 Italy Liguria     606695 5628 0   44.41149315 8.9326992 2022-11-07 04:21:26 Liguria, Italy
1049809 1049809 2022-11-06 Italy Lombardia     3797984 43188 0   45.46679409 9.190347404 2022-11-07 04:21:26 Lombardia, Italy
1049810 1049810 2022-11-06 Italy Marche     656096 4170 0   43.61675973 13.5188753 2022-11-07 04:21:26 Marche, Italy
1049811 1049811 2022-11-06 Italy Molise     94061 686 0   41.55774754 14.65916051 2022-11-07 04:21:26 Molise, Italy
1049812 1049812 2022-11-06 Italy P.A. Bolzano     282504 1575 0   46.49933453 11.35662422 2022-11-07 04:21:26 P.A. Bolzano, Italy
1049813 1049813 2022-11-06 Italy P.A. Trento     230403 1620 0   46.06893511 11.12123097 2022-11-07 04:21:26 P.A. Trento, Italy
1049814 1049814 2022-11-06 Italy Piemonte     1597214 13677 0   45.0732745 7.680687483 2022-11-07 04:21:26 Piemonte, Italy
1049815 1049815 2022-11-06 Italy Puglia     1522491 9175 0   41.12559576 16.86736689 2022-11-07 04:21:26 Puglia, Italy
1049816 1049816 2022-11-06 Italy Sardegna     470683 2789 0   39.21531192 9.110616306 2022-11-07 04:21:26 Sardegna, Italy
1049817 1049817 2022-11-06 Italy Sicilia     1692614 12249 0   38.11569725 13.3623567 2022-11-07 04:21:26 Sicilia, Italy
1049818 1049818 2022-11-06 Italy Toscana     1474898 11005 0   43.76923077 11.25588885 2022-11-07 04:21:26 Toscana, Italy
1049819 1049819 2022-11-06 Italy Umbria     403006 2192 0   43.10675841 12.38824698 2022-11-07 04:21:26 Umbria, Italy
1049820 1049820 2022-11-06 Italy Valle d'Aosta     47777 555 0   45.73750286 7.320149366 2022-11-07 04:21:26 Valle d'Aosta, Italy
1049821 1049821 2022-11-06 Italy Veneto     2431724 15747 0   45.43490485 12.33845213 2022-11-07 04:21:26 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]);