daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,302 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Canada · 1,302
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-03 Canada Alberta     7076 145 6587 344 53.9333 -116.5765 2020-06-04 02:33:14 Alberta, Canada
2020-06-03 Canada British Columbia     2623 166 2243 214 53.7267 -127.6476 2020-06-04 02:33:14 British Columbia, Canada
2020-06-03 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-04 02:33:14 Diamond Princess, Canada
2020-06-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-04 02:33:14 Grand Princess, Canada
2020-06-03 Canada Manitoba     298 7 282 9 53.7609 -98.8139 2020-06-04 02:33:14 Manitoba, Canada
2020-06-03 Canada New Brunswick     135 0 120 15 46.5653 -66.4619 2020-06-04 02:33:14 New Brunswick, Canada
2020-06-03 Canada Newfoundland and Labrador     261 3 256 2 53.1355 -57.6604 2020-06-04 02:33:14 Newfoundland and Labrador, Canada
2020-06-03 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-04 02:33:14 Northwest Territories, Canada
2020-06-03 Canada Nova Scotia     1058 60 993 5 44.681999999999995 -63.7443 2020-06-04 02:33:14 Nova Scotia, Canada
2020-06-03 Canada Ontario     30603 2392 23269 4942 51.2538 -85.3232 2020-06-04 02:33:14 Ontario, Canada
2020-06-03 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-04 02:33:14 Prince Edward Island, Canada
2020-06-03 Canada Quebec     51884 4794 17098 29992 52.9399 -73.5491 2020-06-04 02:33:14 Quebec, Canada
2020-06-03 Canada Saskatchewan     647 11 602 34 52.9399 -106.4509 2020-06-04 02:33:14 Saskatchewan, Canada
2020-06-03 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-04 02:33:14 Yukon, Canada
2020-06-02 Canada Alberta     7057 143 6537 377 53.9333 -116.5765 2020-06-03 02:33:13 Alberta, Canada
2020-06-02 Canada British Columbia     2601 165 2229 207 53.7267 -127.6476 2020-06-03 02:33:13 British Columbia, Canada
2020-06-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-03 02:33:13 Grand Princess, Canada
2020-06-02 Canada Manitoba     297 7 278 12 53.7609 -98.8139 2020-06-03 02:33:13 Manitoba, Canada
2020-06-02 Canada New Brunswick     133 0 120 13 46.5653 -66.4619 2020-06-03 02:33:13 New Brunswick, Canada
2020-06-02 Canada Newfoundland and Labrador     261 3 256 2 53.1355 -57.6604 2020-06-03 02:33:13 Newfoundland and Labrador, Canada
2020-06-02 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-03 02:33:13 Northwest Territories, Canada
2020-06-02 Canada Nova Scotia     1057 60 992 5 44.681999999999995 -63.7443 2020-06-03 02:33:13 Nova Scotia, Canada
2020-06-02 Canada Ontario     30259 2375 22852 5032 51.2538 -85.3232 2020-06-03 02:33:13 Ontario, Canada
2020-06-02 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-03 02:33:13 Prince Edward Island, Canada
2020-06-02 Canada Quebec     51593 4713 16803 30077 52.9399 -73.5491 2020-06-03 02:33:13 Quebec, Canada
2020-06-02 Canada Saskatchewan     646 11 602 33 52.9399 -106.4509 2020-06-03 02:33:13 Saskatchewan, Canada
2020-06-02 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-03 02:33:13 Yukon, Canada
2020-06-01 Canada Alberta     7044 143 6501 400 53.9333 -116.5765 2020-06-02 02:33:08 Alberta, Canada
2020-06-01 Canada British Columbia     2597 165 2207 225 53.7267 -127.6476 2020-06-02 02:33:08 British Columbia, Canada
2020-06-01 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-06-02 02:33:08 Diamond Princess, Canada
2020-06-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-02 02:33:08 Grand Princess, Canada
2020-06-01 Canada Manitoba     295 7 278 10 53.7609 -98.8139 2020-06-02 02:33:08 Manitoba, Canada
2020-06-01 Canada New Brunswick     132 0 120 12 46.5653 -66.4619 2020-06-02 02:33:08 New Brunswick, Canada
2020-06-01 Canada Newfoundland and Labrador     261 3 255 3 53.1355 -57.6604 2020-06-02 02:33:08 Newfoundland and Labrador, Canada
2020-06-01 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-02 02:33:08 Northwest Territories, Canada
2020-06-01 Canada Nova Scotia     1057 60 984 13 44.681999999999995 -63.7443 2020-06-02 02:33:08 Nova Scotia, Canada
2020-06-01 Canada Ontario     29845 2353 22505 4987 51.2538 -85.3232 2020-06-02 02:33:08 Ontario, Canada
2020-06-01 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-02 02:33:08 Prince Edward Island, Canada
2020-06-01 Canada Quebec     51354 4661 16597 30096 52.9399 -73.5491 2020-06-02 02:33:08 Quebec, Canada
2020-06-01 Canada Saskatchewan     646 11 588 47 52.9399 -106.4509 2020-06-02 02:33:08 Saskatchewan, Canada
2020-06-01 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-02 02:33:08 Yukon, Canada
2020-05-31 Canada Alberta     7010 143 6283 584 53.9333 -116.5765 2020-06-01 02:32:46 Alberta, Canada
2020-05-31 Canada British Columbia     2573 164 2181 228 53.7267 -127.6476 2020-06-01 02:32:46 British Columbia, Canada
2020-05-31 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-06-01 02:32:46 Diamond Princess, Canada
2020-05-31 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-01 02:32:46 Grand Princess, Canada
2020-05-31 Canada Manitoba     295 7 278 10 53.7609 -98.8139 2020-06-01 02:32:46 Manitoba, Canada
2020-05-31 Canada New Brunswick     132 0 120 12 46.5653 -66.4619 2020-06-01 02:32:46 New Brunswick, Canada
2020-05-31 Canada Newfoundland and Labrador     261 3 255 3 53.1355 -57.6604 2020-06-01 02:32:46 Newfoundland and Labrador, Canada
2020-05-31 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-01 02:32:46 Northwest Territories, Canada
2020-05-31 Canada Nova Scotia     1056 60 981 15 44.681999999999995 -63.7443 2020-06-01 02:32:46 Nova Scotia, Canada
2020-05-31 Canada Ontario     29390 2344 22131 4915 51.2538 -85.3232 2020-06-01 02:32:46 Ontario, Canada
2020-05-31 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-01 02:32:46 Prince Edward Island, Canada
2020-05-31 Canada Quebec     51059 4641 16346 30072 52.9399 -73.5491 2020-06-01 02:32:46 Quebec, Canada
2020-05-31 Canada Saskatchewan     646 11 582 53 52.9399 -106.4509 2020-06-01 02:32:46 Saskatchewan, Canada
2020-05-31 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-01 02:32:46 Yukon, Canada
2020-05-30 Canada Alberta     6992 143 6245 604 53.9333 -116.5765 2020-05-31 02:32:45 Alberta, Canada
2020-05-30 Canada British Columbia     2573 164 2181 228 53.7267 -127.6476 2020-05-31 02:32:45 British Columbia, Canada
2020-05-30 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-31 02:32:45 Diamond Princess, Canada
2020-05-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-05-31 02:32:45 Grand Princess, Canada
2020-05-30 Canada Manitoba     294 7 278 9 53.7609 -98.8139 2020-05-31 02:32:45 Manitoba, Canada
2020-05-30 Canada New Brunswick     129 0 120 9 46.5653 -66.4619 2020-05-31 02:32:45 New Brunswick, Canada
2020-05-30 Canada Newfoundland and Labrador     261 3 255 3 53.1355 -57.6604 2020-05-31 02:32:45 Newfoundland and Labrador, Canada
2020-05-30 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-05-31 02:32:45 Northwest Territories, Canada
2020-05-30 Canada Nova Scotia     1056 60 978 18 44.681999999999995 -63.7443 2020-05-31 02:32:45 Nova Scotia, Canada
2020-05-30 Canada Ontario     29023 2332 21754 4937 51.2538 -85.3232 2020-05-31 02:32:45 Ontario, Canada
2020-05-30 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-05-31 02:32:45 Prince Edward Island, Canada
2020-05-30 Canada Quebec     50651 4439 16070 30142 52.9399 -73.5491 2020-05-31 02:32:45 Quebec, Canada
2020-05-30 Canada Saskatchewan     645 10 580 55 52.9399 -106.4509 2020-05-31 02:32:45 Saskatchewan, Canada
2020-05-30 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-05-31 02:32:45 Yukon, Canada
2020-05-29 Canada Alberta     6979 143 6220 616 53.9333 -116.5765 2020-05-30 02:32:48 Alberta, Canada
2020-05-29 Canada British Columbia     2562 164 2177 221 53.7267 -127.6476 2020-05-30 02:32:48 British Columbia, Canada
2020-05-29 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-30 02:32:48 Diamond Princess, Canada
2020-05-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-05-30 02:32:48 Grand Princess, Canada
2020-05-29 Canada Manitoba     294 7 273 14 53.7609 -98.8139 2020-05-30 02:32:48 Manitoba, Canada
2020-05-29 Canada New Brunswick     128 0 120 8 46.5653 -66.4619 2020-05-30 02:32:48 New Brunswick, Canada
2020-05-29 Canada Newfoundland and Labrador     261 3 255 3 53.1355 -57.6604 2020-05-30 02:32:48 Newfoundland and Labrador, Canada
2020-05-29 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-05-30 02:32:48 Northwest Territories, Canada
2020-05-29 Canada Nova Scotia     1055 59 978 18 44.681999999999995 -63.7443 2020-05-30 02:32:48 Nova Scotia, Canada
2020-05-29 Canada Ontario     28700 2313 21348 5039 51.2538 -85.3232 2020-05-30 02:32:48 Ontario, Canada
2020-05-29 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-05-30 02:32:48 Prince Edward Island, Canada
2020-05-29 Canada Quebec     50232 4363 15908 29961 52.9399 -73.5491 2020-05-30 02:32:48 Quebec, Canada
2020-05-29 Canada Saskatchewan     641 10 570 61 52.9399 -106.4509 2020-05-30 02:32:48 Saskatchewan, Canada
2020-05-29 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-05-30 02:32:48 Yukon, Canada
2020-05-28 Canada Alberta     6955 143 6160 652 53.9333 -116.5765 2020-05-29 02:32:50 Alberta, Canada
2020-05-28 Canada British Columbia     2558 164 2153 241 53.7267 -127.6476 2020-05-29 02:32:50 British Columbia, Canada
2020-05-28 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-29 02:32:50 Diamond Princess, Canada
2020-05-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-05-29 02:32:50 Grand Princess, Canada
2020-05-28 Canada Manitoba     294 7 273 14 53.7609 -98.8139 2020-05-29 02:32:50 Manitoba, Canada
2020-05-28 Canada New Brunswick     126 0 120 6 46.5653 -66.4619 2020-05-29 02:32:50 New Brunswick, Canada
2020-05-28 Canada Newfoundland and Labrador     261 3 255 3 53.1355 -57.6604 2020-05-29 02:32:50 Newfoundland and Labrador, Canada
2020-05-28 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-05-29 02:32:50 Northwest Territories, Canada
2020-05-28 Canada Nova Scotia     1055 59 977 19 44.681999999999995 -63.7443 2020-05-29 02:32:50 Nova Scotia, Canada
2020-05-28 Canada Ontario     28320 2292 20781 5247 51.2538 -85.3232 2020-05-29 02:32:50 Ontario, Canada
2020-05-28 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-05-29 02:32:50 Prince Edward Island, Canada
2020-05-28 Canada Quebec     49711 4303 15618 29790 52.9399 -73.5491 2020-05-29 02:32:50 Quebec, Canada
2020-05-28 Canada Saskatchewan     639 10 568 61 52.9399 -106.4509 2020-05-29 02:32:50 Saskatchewan, Canada
2020-05-28 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-05-29 02:32:50 Yukon, Canada
2020-05-27 Canada Alberta     6926 141 6106 679 53.9333 -116.5765 2020-05-28 02:32:31 Alberta, Canada
2020-05-27 Canada British Columbia     2550 162 2144 244 53.7267 -127.6476 2020-05-28 02:32:31 British Columbia, Canada
2020-05-27 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-28 02:32:31 Diamond Princess, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 2022.444ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette