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 = "2022-09-21" sorted by day descending

✎ View and edit SQL

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

Suggested facets: confirmed, deaths, latitude, last_update, 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
1370241 1370241 2022-09-21 Canada Alberta     605757 4872 0   53.9333 -116.5765 2022-09-22 04:22:56 Alberta, Canada
1370242 1370242 2022-09-21 Canada British Columbia     383628 4216 0   53.7267 -127.6476 2022-09-22 04:22:56 British Columbia, Canada
1370243 1370243 2022-09-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1370244 1370244 2022-09-21 Canada Grand Princess     13 0 0   37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1370245 1370245 2022-09-21 Canada Manitoba     149245 2137 0   53.7609 -98.8139 2022-09-22 04:22:56 Manitoba, Canada
1370246 1370246 2022-09-21 Canada New Brunswick     76316 476 0   46.5653 -66.4619 2022-09-22 04:22:56 New Brunswick, Canada
1370247 1370247 2022-09-21 Canada Newfoundland and Labrador     51446 235 0   53.1355 -57.6604 2022-09-22 04:22:56 Newfoundland and Labrador, Canada
1370248 1370248 2022-09-21 Canada Northwest Territories     11511 22 0   64.8255 -124.8457 2022-09-22 04:22:56 Northwest Territories,Canada
1370249 1370249 2022-09-21 Canada Nova Scotia     123549 518 0   44.682 -63.7443 2022-09-22 04:22:56 Nova Scotia, Canada
1370250 1370250 2022-09-21 Canada Nunavut     3531 7 0   70.2998 -83.1076 2022-09-22 04:22:56 Nunavut, Canada
1370251 1370251 2022-09-21 Canada Ontario     1453813 14291 0   51.2538 -85.3232 2022-09-22 04:22:56 Ontario, Canada
1370252 1370252 2022-09-21 Canada Prince Edward Island     51410 57 0   46.5107 -63.4168 2022-09-22 04:22:56 Prince Edward Island, Canada
1370253 1370253 2022-09-21 Canada Quebec     1193035 16697 0   52.9399 -73.5491 2022-09-22 04:22:56 Quebec, Canada
1370254 1370254 2022-09-21 Canada Repatriated Travellers     13 0 0       2022-09-22 04:22:56 Repatriated Travellers, Canada
1370255 1370255 2022-09-21 Canada Saskatchewan     143747 1507 0   52.9399 -106.4509 2022-09-22 04:22:56 Saskatchewan, Canada
1370256 1370256 2022-09-21 Canada Yukon     4884 31 0   64.2823 -135.0 2022-09-22 04:22:56 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]);