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

13 rows where country_or_region = "Canada" and province_or_state = "Montreal, QC" sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

  • Montreal, QC · 13 ✖

country_or_region 1

  • Canada · 13 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1527323 1527323 2020-03-08 Canada Montreal, QC     14 0 0   45.5017 -73.5673 2020-03-08T16:03:05  
62587 62587 2020-03-07 Canada Montreal, QC     13 0 0   45.5017 -73.5673 2020-03-07T02:23:08  
3177592 3177592 2020-03-06 Canada Montreal, QC     13 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
40237 40237 2020-03-05 Canada Montreal, QC     11 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
98920 98920 2020-03-04 Canada Montreal, QC     10 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
261127 261127 2020-03-03 Canada Montreal, QC     8 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
1152735 1152735 2020-03-02 Canada Montreal, QC     6 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
562589 562589 2020-03-01 Canada Montreal, QC     3 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
3205869 3205869 2020-02-29 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
2883989 2883989 2020-02-28 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
617446 617446 2020-02-27 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-27T22:43:02  
2509803 2509803 2020-02-26 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-24T14:43:03  
479184 479184 2020-02-25 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-24T14:43:03  

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