⚠️ 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

51 rows where country_or_region = "Canada" and province_or_state = "Recovered" sorted by day descending

View and edit SQL

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

province_or_state

  • Recovered · 51

country_or_region

  • Canada · 51
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1612837 2020-05-13 Canada Recovered     0 0 35177 -35177 0.0 0.0 2020-05-14 03:32:28 Recovered, Canada
817256 2020-05-12 Canada Recovered     0 0 34055 -34055 0.0 0.0 2020-05-13 03:32:26 Recovered, Canada
28434 2020-05-11 Canada Recovered     0 0 33007 -33007 0.0 0.0 2020-05-12 03:32:27 Recovered, Canada
339058 2020-05-10 Canada Recovered     0 0 32109 -32109 0.0 0.0 2020-05-11 02:32:30 Recovered, Canada
47543 2020-05-09 Canada Recovered     0 0 31262 -31262 0.0 0.0 2020-05-10 02:32:30 Recovered, Canada
720323 2020-05-08 Canada Recovered     0 0 30239 -30239 0.0 0.0 2020-05-09 02:32:35 Recovered, Canada
1697576 2020-05-07 Canada Recovered     0 0 29260 -29260 0.0 0.0 2020-05-08 02:32:32 Recovered, Canada
585287 2020-05-06 Canada Recovered     0 0 28184 -28184 0.0 0.0 2020-05-07 02:32:28 Recovered, Canada
1222069 2020-05-05 Canada Recovered     0 0 27006 -27006 0.0 0.0 2020-05-06 02:32:31 Recovered, Canada
1172930 2020-05-04 Canada Recovered     0 0 26030 -26030 0.0 0.0 2020-05-05 02:32:34 Recovered, Canada
1545347 2020-05-03 Canada Recovered     0 0 24921 -24921 0.0 0.0 2020-05-04 02:32:28 Recovered, Canada
1548589 2020-05-02 Canada Recovered     0 0 23814 -23814 0.0 0.0 2020-05-03 02:32:28 Recovered, Canada
433810 2020-05-01 Canada Recovered     0 0 22764 -22764 0.0 0.0 2020-05-02 02:32:27 Recovered, Canada
866144 2020-04-30 Canada Recovered     0 0 21424 -21424 0.0 0.0 2020-05-01 02:32:28 Recovered, Canada
1655671 2020-04-29 Canada Recovered     0 0 20327 -20327 0.0 0.0 2020-04-30 02:32:27 Recovered, Canada
1539117 2020-04-28 Canada Recovered     0 0 19231 -19231 0.0 0.0 2020-04-29 02:32:29 Recovered, Canada
985326 2020-04-27 Canada Recovered     0 0 18268 -18268 0.0 0.0 2020-04-28 02:30:53 Recovered, Canada
187106 2020-04-26 Canada Recovered     0 0 16883 -16883 0.0 0.0 2020-04-27 02:30:55 Recovered, Canada
603580 2020-04-25 Canada Recovered     0 0 16013 -16013 0.0 0.0 2020-04-26 02:30:54 Recovered, Canada
21232 2020-04-24 Canada Recovered     0 0 15149 -15149 0.0 0.0 2020-04-25 06:30:55 Recovered, Canada
896653 2020-04-23 Canada Recovered     0 0 14761 -14761 0.0 0.0 2020-04-24 03:31:19 Recovered, Canada
422652 2020-04-22 Canada Recovered     0 0 14454 -14454 0.0 0.0 2020-04-22 23:38:42 Recovered, Canada
919602 2020-04-21 Canada Recovered     0 0 13188 -13188 0.0 0.0 2020-04-21 23:38:53 Recovered, Canada
1012096 2020-04-20 Canada Recovered     0 0 12543 -12543 0.0 0.0 2020-04-20 23:44:34 Recovered, Canada
2868 2020-04-19 Canada Recovered     0 0 11847 -11847 0.0 0.0 2020-04-19 23:48:49 Recovered, Canada
391576 2020-04-18 Canada Recovered     0 0 10964 -10964 0.0 0.0 2020-04-18 22:40:03 Recovered, Canada
1662701 2020-04-17 Canada Recovered     0 0 10545 -10545 0.0 0.0 2020-04-17 23:38:31 Recovered, Canada
1169650 2020-04-16 Canada Recovered     0 0 9698 -9698 0.0 0.0 2020-04-16 23:38:03 Recovered, Canada
1348645 2020-04-15 Canada Recovered     0 0 8966 -8966 0.0 0.0 2020-04-15 23:04:09 Recovered, Canada
1593715 2020-04-14 Canada Recovered     0 0 8210 -8210 0.0 0.0 2020-04-14 23:40:54 Recovered, Canada
1574509 2020-04-13 Canada Recovered     0 0 7758 -7758 0.0 0.0 2020-04-13 23:15:25 Recovered, Canada
592478 2020-04-12 Canada Recovered     0 0 7123 -7123 0.0 0.0 2020-04-12 23:24:00 Recovered, Canada
342030 2020-04-11 Canada Recovered     0 0 6589 0 0.0 0.0 2020-04-11 22:52:28 Recovered, Canada
930617 2020-04-10 Canada Recovered     0 0 5855 0 0.0 0.0 2020-04-10 23:01:26 Recovered, Canada
1495966 2020-04-09 Canada Recovered     0 0 5162 0 0.0 0.0 2020-04-09 23:09:01 Recovered, Canada
1563469 2020-04-08 Canada Recovered     0 0 4154 0 0.0 0.0 2020-04-08 22:58:44 Recovered, Canada
1367344 2020-04-07 Canada Recovered     0 0 3791 0 0.0 0.0 2020-04-07 23:11:15 Recovered, Canada
1542147 2020-04-06 Canada Recovered     0 0 3256 0 0.0 0.0 4/6/20 23:28 Recovered, Canada
511186 2020-04-05 Canada Recovered     0 0 3012 0 0.0 0.0 2020-04-05 23:13:28 Recovered, Canada
176571 2020-04-04 Canada Recovered     0 0 2577 0 0.0 0.0 4/4/20 23:40 Recovered, Canada
1045190 2020-04-03 Canada Recovered     0 0 2175 0 0.0 0.0 2020-04-03 22:52:30 Recovered, Canada
1306287 2020-04-02 Canada Recovered     0 0 1735 0 0.0 0.0 4/2/20 23:31 Recovered, Canada
1291827 2020-04-01 Canada Recovered     0 0 1324 0 0.0 0.0 2020-04-01 22:04:44 Recovered, Canada
850944 2020-03-31 Canada Recovered     0 0 1592 0 0.0 0.0 2020-03-31 23:49:13 Recovered, Canada
10284 2020-03-30 Canada Recovered     0 0 466 0 0.0 0.0 3/30/20 22:58 Recovered, Canada
277031 2020-03-29 Canada Recovered     0 0 466 0 0.0 0.0 3/29/20 23:13 Recovered, Canada
130225 2020-03-28 Canada Recovered     0 0 466 0 0.0 0.0 3/28/20 23:10 Recovered, Canada
739682 2020-03-27 Canada Recovered     0 0 256 0 0.0 0.0 2020-03-27 23:27:32 Recovered, Canada
1652510 2020-03-26 Canada Recovered     0 0 184 0 0.0 0.0 2020-03-26 23:53:11 Recovered, Canada
304512 2020-03-25 Canada Recovered     0 0 183 0 0.0 0.0 2020-03-25 23:37:36 Recovered, Canada
202544 2020-03-24 Canada Recovered     0 0 110 0 0.0 0.0 2020-03-24 23:41:36 Recovered, Canada

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] INTEGER,
   [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]);