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 = "Denmark" and province_or_state = "Denmark" sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

  • Denmark · 11 ✖

country_or_region 1

  • Denmark · 11 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
339642 339642 2020-03-21 Denmark Denmark     1326 13 1   56.2639 9.5018 2020-03-21T12:43:08  
3733938 3733938 2020-03-20 Denmark Denmark     1255 9 1   56.2639 9.5018 2020-03-20T18:13:12  
1526890 1526890 2020-03-19 Denmark Denmark     1151 6 1   56.2639 9.5018 2020-03-19T17:13:42  
1176893 1176893 2020-03-18 Denmark Denmark     1057 4 1   56.2639 9.5018 2020-03-18T16:59:35  
3891327 3891327 2020-03-17 Denmark Denmark     977 4 1   56.2639 9.5018 2020-03-17T16:33:04  
2255133 2255133 2020-03-16 Denmark Denmark     914 3 1   56.2639 9.5018 2020-03-16T18:33:03  
1463480 1463480 2020-03-15 Denmark Denmark     864 2 1   56.2639 9.5018 2020-03-15T18:20:19  
2111104 2111104 2020-03-14 Denmark Denmark     827 1 1   56.2639 9.5018 2020-03-14T22:13:32  
3765369 3765369 2020-03-13 Denmark Denmark     801 0 1   56.2639 9.5018 2020-03-11T20:00:00  
2282879 2282879 2020-03-12 Denmark Denmark     615 0 1   56.2639 9.5018 2020-03-12T09:53:06  
2127455 2127455 2020-03-11 Denmark Denmark     442 0 1   56.2639 9.5018 2020-03-11T22:13:13  

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]);