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 2021-07-03 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
1495580 1495580 2021-07-03 Italy Abruzzo     74924 2512 71526 886 42.35122196 13.39843823 2021-07-04 04:21:38 Abruzzo, Italy
1495581 1495581 2021-07-03 Italy Basilicata     26979 590 25711 678 40.63947052 15.80514834 2021-07-04 04:21:38 Basilicata, Italy
1495582 1495582 2021-07-03 Italy Calabria     69058 1228 64450 3380 38.90597598 16.59440194 2021-07-04 04:21:38 Calabria, Italy
1495583 1495583 2021-07-03 Italy Campania     424656 7504 409559 7593 40.83956555 14.25084984 2021-07-04 04:21:38 Campania, Italy
1495584 1495584 2021-07-03 Italy Emilia-Romagna     386998 13264 371061 2673 44.49436681 11.3417208 2021-07-04 04:21:38 Emilia-Romagna, Italy
1495585 1495585 2021-07-03 Italy Friuli Venezia Giulia     106987 3789 103009 189 45.6494354 13.76813649 2021-07-04 04:21:38 Friuli Venezia Giulia, Italy
1495586 1495586 2021-07-03 Italy Lazio     346186 8347 335002 2837 41.89277044 12.48366722 2021-07-04 04:21:38 Lazio, Italy
1495587 1495587 2021-07-03 Italy Liguria     103463 4352 98983 128 44.41149315 8.9326992 2021-07-04 04:21:38 Liguria, Italy
1495588 1495588 2021-07-03 Italy Lombardia     842244 33785 799005 9454 45.46679409 9.190347404 2021-07-04 04:21:38 Lombardia, Italy
1495589 1495589 2021-07-03 Italy Marche     103746 3037 99455 1254 43.61675973 13.5188753 2021-07-04 04:21:38 Marche, Italy
1495590 1495590 2021-07-03 Italy Molise     13721 492 13165 64 41.55774754 14.65916051 2021-07-04 04:21:38 Molise, Italy
1495591 1495591 2021-07-03 Italy P.A. Bolzano     73326 1180 72025 121 46.49933453 11.35662422 2021-07-04 04:21:38 P.A. Bolzano, Italy
1495592 1495592 2021-07-03 Italy P.A. Trento     45785 1362 44372 51 46.06893511 11.12123097 2021-07-04 04:21:38 P.A. Trento, Italy
1495593 1495593 2021-07-03 Italy Piemonte     363004 11696 350554 754 45.0732745 7.680687483 2021-07-04 04:21:38 Piemonte, Italy
1495594 1495594 2021-07-03 Italy Puglia     253471 6642 244165 2664 41.12559576 16.86736689 2021-07-04 04:21:38 Puglia, Italy
1495595 1495595 2021-07-03 Italy Sardegna     57279 1492 53482 2305 39.21531192 9.110616306 2021-07-04 04:21:38 Sardegna, Italy
1495596 1495596 2021-07-03 Italy Sicilia     232082 5979 222428 3675 38.11569725 13.362356699999998 2021-07-04 04:21:38 Sicilia, Italy
1495597 1495597 2021-07-03 Italy Toscana     244435 6874 235960 1601 43.76923077 11.25588885 2021-07-04 04:21:38 Toscana, Italy
1495598 1495598 2021-07-03 Italy Umbria     56870 1420 54759 691 43.10675841 12.38824698 2021-07-04 04:21:38 Umbria, Italy
1495599 1495599 2021-07-03 Italy Valle d'Aosta     11696 473 11189 34 45.73750286 7.320149366 2021-07-04 04:21:38 Valle d'Aosta, Italy
1495600 1495600 2021-07-03 Italy Veneto     425601 11619 409438 4544 45.43490485 12.33845213 2021-07-04 04:21:38 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]);