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

11 rows where country_or_region = "Italy" and recovered = 432 sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

country_or_region 1

  • Italy · 11 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1354304 1354304 2020-09-03 Italy Molise     530 23 432 75 41.55774754 14.65916051 2020-09-04 04:28:26 Molise, Italy
1105541 1105541 2020-09-02 Italy Molise     528 23 432 73 41.55774754 14.65916051 2020-09-03 04:28:22 Molise, Italy
2059870 2059870 2020-09-01 Italy Molise     528 23 432 73 41.55774754 14.65916051 2020-09-02 04:28:25 Molise, Italy
194055 194055 2020-08-31 Italy Molise     525 23 432 70 41.55774754 14.65916051 2020-09-01 04:28:31 Molise, Italy
3932014 3932014 2020-08-30 Italy Molise     525 23 432 70 41.55774754 14.65916051 2020-08-31 04:28:27 Molise, Italy
609676 609676 2020-08-29 Italy Molise     524 23 432 69 41.55774754 14.65916051 2020-08-30 04:28:22 Molise, Italy
1523171 1523171 2020-08-28 Italy Molise     522 23 432 67 41.55774754 14.65916051 2020-08-29 04:28:19 Molise, Italy
2510172 2510172 2020-08-27 Italy Molise     521 23 432 66 41.55774754 14.65916051 2020-08-28 04:28:11 Molise, Italy
1996632 1996632 2020-08-26 Italy Molise     520 23 432 65 41.55774754 14.65916051 2020-08-27 04:28:15 Molise, Italy
3562556 3562556 2020-08-25 Italy Molise     511 23 432 56 41.55774754 14.65916051 2020-08-26 04:28:11 Molise, Italy
2991260 2991260 2020-08-24 Italy Molise     511 23 432 56 41.55774754 14.65916051 2020-08-25 04:28:02 Molise, 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]);