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 = "2020-07-18 04:34:45" sorted by day descending

✎ View and edit SQL

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

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
2708355 2708355 2020-07-17 Italy Abruzzo     3334 468 2747 119 42.35122196 13.39843823 2020-07-18 04:34:45 Abruzzo, Italy
2708404 2708404 2020-07-17 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-18 04:34:45 Basilicata, Italy
2708424 2708424 2020-07-17 Italy Calabria     1231 97 1065 69 38.90597598 16.59440194 2020-07-18 04:34:45 Calabria, Italy
2708427 2708427 2020-07-17 Italy Campania     4803 433 4098 272 40.83956555 14.25084984 2020-07-18 04:34:45 Campania, Italy
2708478 2708478 2020-07-17 Italy Emilia-Romagna     29087 4273 23586 1228 44.49436681 11.341720800000001 2020-07-18 04:34:45 Emilia-Romagna, Italy
2708488 2708488 2020-07-17 Italy Friuli Venezia Giulia     3346 345 2905 96 45.6494354 13.76813649 2020-07-18 04:34:45 Friuli Venezia Giulia, Italy
2708596 2708596 2020-07-17 Italy Lazio     8399 849 6698 852 41.89277044 12.48366722 2020-07-18 04:34:45 Lazio, Italy
2708599 2708599 2020-07-17 Italy Liguria     10052 1565 8301 186 44.41149315 8.9326992 2020-07-18 04:34:45 Liguria, Italy
2708603 2708603 2020-07-17 Italy Lombardia     95371 16778 71172 7421 45.46679409 9.190347404 2020-07-18 04:34:45 Lombardia, Italy
2708620 2708620 2020-07-17 Italy Marche     6809 987 5667 155 43.61675973 13.5188753 2020-07-18 04:34:45 Marche, Italy
2708639 2708639 2020-07-17 Italy Molise     446 23 415 8 41.55774754 14.65916051 2020-07-18 04:34:45 Molise, Italy
2708696 2708696 2020-07-17 Italy P.A. Bolzano     2682 292 2289 101 46.49933453 11.35662422 2020-07-18 04:34:45 P.A. Bolzano, Italy
2708697 2708697 2020-07-17 Italy P.A. Trento     4881 405 4460 16 46.06893511 11.12123097 2020-07-18 04:34:45 P.A. Trento, Italy
2708707 2708707 2020-07-17 Italy Piemonte     31530 4119 26555 856 45.0732745 7.680687483 2020-07-18 04:34:45 Piemonte, Italy
2708717 2708717 2020-07-17 Italy Puglia     4547 548 3929 70 41.12559576 16.86736689 2020-07-18 04:34:45 Puglia, Italy
2708760 2708760 2020-07-17 Italy Sardegna     1377 134 1233 10 39.21531192 9.110616306 2020-07-18 04:34:45 Sardegna, Italy
2708774 2708774 2020-07-17 Italy Sicilia     3136 283 2695 158 38.11569725 13.362356699999998 2020-07-18 04:34:45 Sicilia, Italy
2708810 2708810 2020-07-17 Italy Toscana     10356 1129 8909 318 43.76923077 11.25588885 2020-07-18 04:34:45 Toscana, Italy
2708823 2708823 2020-07-17 Italy Umbria     1454 80 1362 12 43.10675841 12.38824698 2020-07-18 04:34:45 Umbria, Italy
2708836 2708836 2020-07-17 Italy Valle d'Aosta     1196 146 1048 2 45.73750286 7.320149366 2020-07-18 04:34:45 Valle d'Aosta, Italy
2708845 2708845 2020-07-17 Italy Veneto     19525 2047 16976 502 45.43490485 12.33845213 2020-07-18 04:34:45 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]);