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

7 rows where country_or_region = "Italy" and recovered = 1237 sorted by day descending

✎ View and edit SQL

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

Suggested facets: deaths, active, latitude, longitude, combined_key, day (date), last_update (date)

province_or_state 2

country_or_region 1

  • Italy · 7 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
821558 821558 2020-11-19 Italy Molise     3520 84 1237 2199 41.55774754 14.65916051 2020-11-20 05:26:28 Molise, Italy
2808112 2808112 2020-08-02 Italy Sardegna     1414 134 1237 43 39.21531192 9.110616306 2020-08-03 04:34:35 Sardegna, Italy
753680 753680 2020-08-01 Italy Sardegna     1410 134 1237 39 39.21531192 9.110616306 2020-08-02 04:34:47 Sardegna, Italy
3264845 3264845 2020-07-31 Italy Sardegna     1404 134 1237 33 39.21531192 9.110616306 2020-08-01 04:36:27 Sardegna, Italy
1928552 1928552 2020-07-30 Italy Sardegna     1394 134 1237 23 39.21531192 9.110616306 2020-07-31 04:35:18 Sardegna, Italy
2958720 2958720 2020-07-29 Italy Sardegna     1394 134 1237 23 39.21531192 9.110616306 2020-07-30 04:35:05 Sardegna, Italy
3185336 3185336 2020-07-28 Italy Sardegna     1392 134 1237 21 39.21531192 9.110616306 2020-07-29 04:35:11 Sardegna, 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]);