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

16 rows where country_or_region = "Canada" and "day" is on date 2021-06-27 sorted by day descending

✎ View and edit SQL

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

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

country_or_region 1

  • Canada · 16 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2589765 2589765 2021-06-27 Canada Alberta     231641 2293 227768 1580 53.9333 -116.5765 2021-06-28 04:21:29 Alberta, Canada
2589766 2589766 2021-06-27 Canada British Columbia     147418 1749 144554 1115 53.7267 -127.6476 2021-06-28 04:21:29 British Columbia, Canada
2589767 2589767 2021-06-27 Canada Diamond Princess     0 1 0 0 0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
2589768 2589768 2021-06-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
2589769 2589769 2021-06-27 Canada Manitoba     55975 1139 53356 1480 53.7609 -98.8139 2021-06-28 04:21:29 Manitoba, Canada
2589770 2589770 2021-06-27 Canada New Brunswick     2325 45 2254 26 46.5653 -66.4619 2021-06-28 04:21:29 New Brunswick, Canada
2589771 2589771 2021-06-27 Canada Newfoundland and Labrador     1384 7 1366 11 53.1355 -57.6604 2021-06-28 04:21:29 Newfoundland and Labrador, Canada
2589772 2589772 2021-06-27 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-28 04:21:29 Northwest Territories,Canada
2589773 2589773 2021-06-27 Canada Nova Scotia     5828 92 5678 58 44.682 -63.7443 2021-06-28 04:21:29 Nova Scotia, Canada
2589774 2589774 2021-06-27 Canada Nunavut     657 4 653 0 70.2998 -83.1076 2021-06-28 04:21:29 Nunavut, Canada
2589775 2589775 2021-06-27 Canada Ontario     548331 9126 539504 2965 51.2538 -85.3232 2021-06-28 04:21:29 Ontario, Canada
2589776 2589776 2021-06-27 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-28 04:21:29 Prince Edward Island, Canada
2589777 2589777 2021-06-27 Canada Quebec     374921 11202 362130 1589 52.9399 -73.5491 2021-06-28 04:21:29 Quebec, Canada
2589778 2589778 2021-06-27 Canada Repatriated Travellers     13 0 13 0     2021-06-28 04:21:29 Repatriated Travellers, Canada
2589779 2589779 2021-06-27 Canada Saskatchewan     48754 566 47639 549 52.9399 -106.4509 2021-06-28 04:21:29 Saskatchewan, Canada
2589780 2589780 2021-06-27 Canada Yukon     264 4 152 108 64.2823 -135.0 2021-06-28 04:21:29 Yukon, 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] 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]);