daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,048 rows where country_or_region = "Canada" and latitude = "52.9399" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 2
- Quebec 1,026
- Saskatchewan 1,022
country_or_region 1
- Canada · 2,048 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | Canada | Quebec | 1282260 | 17670 | 0 | 52.9399 | -73.5491 | 2022-12-30 04:21:04 | Quebec, Canada | |||
2022-12-29 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-30 04:21:04 | Saskatchewan, Canada | |||
2022-12-28 | Canada | Quebec | 1281152 | 17644 | 0 | 52.9399 | -73.5491 | 2022-12-29 04:21:01 | Quebec, Canada | |||
2022-12-28 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-29 04:21:01 | Saskatchewan, Canada | |||
2022-12-27 | Canada | Quebec | 1280200 | 17628 | 0 | 52.9399 | -73.5491 | 2022-12-28 04:21:04 | Quebec, Canada | |||
2022-12-27 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-28 04:21:04 | Saskatchewan, Canada | |||
2022-12-26 | Canada | Quebec | 1279432 | 17626 | 0 | 52.9399 | -73.5491 | 2022-12-27 04:21:07 | Quebec, Canada | |||
2022-12-26 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-27 04:21:07 | Saskatchewan, Canada | |||
2022-12-25 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-26 04:21:06 | Quebec, Canada | |||
2022-12-25 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-26 04:21:06 | Saskatchewan, Canada | |||
2022-12-24 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-25 04:21:04 | Quebec, Canada | |||
2022-12-24 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-25 04:21:04 | Saskatchewan, Canada | |||
2022-12-23 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-24 04:21:02 | Quebec, Canada | |||
2022-12-23 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-24 04:21:02 | Saskatchewan, Canada | |||
2022-12-22 | Canada | Quebec | 1276752 | 17593 | 0 | 52.9399 | -73.5491 | 2022-12-23 04:21:04 | Quebec, Canada | |||
2022-12-22 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-23 04:21:04 | Saskatchewan, Canada | |||
2022-12-21 | Canada | Quebec | 1275579 | 17586 | 0 | 52.9399 | -73.5491 | 2022-12-22 04:20:56 | Quebec, Canada | |||
2022-12-21 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-22 04:20:56 | Saskatchewan, Canada | |||
2022-12-20 | Canada | Quebec | 1274140 | 17570 | 0 | 52.9399 | -73.5491 | 2022-12-21 04:21:03 | Quebec, Canada | |||
2022-12-20 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-21 04:21:03 | Saskatchewan, Canada | |||
2022-12-19 | Canada | Quebec | 1272878 | 17542 | 0 | 52.9399 | -73.5491 | 2022-12-20 04:21:04 | Quebec, Canada | |||
2022-12-19 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-20 04:21:04 | Saskatchewan, Canada | |||
2022-12-18 | Canada | Quebec | 1272029 | 17540 | 0 | 52.9399 | -73.5491 | 2022-12-19 04:21:03 | Quebec, Canada | |||
2022-12-18 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-19 04:21:03 | Saskatchewan, Canada | |||
2022-12-17 | Canada | Quebec | 1271168 | 17537 | 0 | 52.9399 | -73.5491 | 2022-12-18 04:21:03 | Quebec, Canada | |||
2022-12-17 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-18 04:21:03 | Saskatchewan, Canada | |||
2022-12-16 | Canada | Quebec | 1270133 | 17533 | 0 | 52.9399 | -73.5491 | 2022-12-17 04:21:04 | Quebec, Canada | |||
2022-12-16 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-17 04:21:04 | Saskatchewan, Canada | |||
2022-12-15 | Canada | Quebec | 1268912 | 17514 | 0 | 52.9399 | -73.5491 | 2022-12-16 04:21:01 | Quebec, Canada | |||
2022-12-15 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-16 04:21:01 | Saskatchewan, Canada | |||
2022-12-14 | Canada | Quebec | 1267561 | 17497 | 0 | 52.9399 | -73.5491 | 2022-12-15 04:20:58 | Quebec, Canada | |||
2022-12-14 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-15 04:20:58 | Saskatchewan, Canada | |||
2022-12-13 | Canada | Quebec | 1266261 | 17485 | 0 | 52.9399 | -73.5491 | 2022-12-14 04:21:04 | Quebec, Canada | |||
2022-12-13 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-14 04:21:04 | Saskatchewan, Canada | |||
2022-12-12 | Canada | Quebec | 1265044 | 17463 | 0 | 52.9399 | -73.5491 | 2022-12-13 04:21:01 | Quebec, Canada | |||
2022-12-12 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-13 04:21:01 | Saskatchewan, Canada | |||
2022-12-11 | Canada | Quebec | 1264296 | 17462 | 0 | 52.9399 | -73.5491 | 2022-12-12 04:21:01 | Quebec, Canada | |||
2022-12-11 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-12 04:21:01 | Saskatchewan, Canada | |||
2022-12-10 | Canada | Quebec | 1263490 | 17461 | 0 | 52.9399 | -73.5491 | 2022-12-11 04:20:50 | Quebec, Canada | |||
2022-12-10 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-11 04:20:50 | Saskatchewan, Canada | |||
2022-12-09 | Canada | Quebec | 1262542 | 17442 | 0 | 52.9399 | -73.5491 | 2022-12-10 04:21:02 | Quebec, Canada | |||
2022-12-09 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-10 04:21:02 | Saskatchewan, Canada | |||
2022-12-08 | Canada | Quebec | 1261462 | 17426 | 0 | 52.9399 | -73.5491 | 2022-12-09 04:21:05 | Quebec, Canada | |||
2022-12-08 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-09 04:21:05 | Saskatchewan, Canada | |||
2022-12-07 | Canada | Quebec | 1260221 | 17415 | 0 | 52.9399 | -73.5491 | 2022-12-08 04:21:07 | Quebec, Canada | |||
2022-12-07 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-08 04:21:07 | Saskatchewan, Canada | |||
2022-12-06 | Canada | Quebec | 1258503 | 17409 | 0 | 52.9399 | -73.5491 | 2022-12-07 04:20:58 | Quebec, Canada | |||
2022-12-06 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-07 04:20:58 | Saskatchewan, Canada | |||
2022-12-05 | Canada | Quebec | 1258503 | 17409 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2022-12-05 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2022-12-04 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2022-12-04 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2022-12-03 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2022-12-03 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2022-12-02 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2022-12-02 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2022-12-01 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 04:21:07 | Quebec, Canada | |||
2022-12-01 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 04:21:07 | Saskatchewan, Canada | |||
2022-11-30 | Canada | Quebec | 1248200 | 17354 | 0 | 52.9399 | -73.5491 | 2022-12-01 04:21:03 | Quebec, Canada | |||
2022-11-30 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-01 04:21:03 | Saskatchewan, Canada | |||
2022-11-29 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-30 04:21:07 | Quebec, Canada | |||
2022-11-29 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-11-30 04:21:07 | Saskatchewan, Canada | |||
2022-11-28 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-29 04:21:05 | Quebec, Canada | |||
2022-11-28 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-11-29 04:21:05 | Saskatchewan, Canada | |||
2022-11-27 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-28 04:21:02 | Quebec, Canada | |||
2022-11-27 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-28 04:21:02 | Saskatchewan, Canada | |||
2022-11-26 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-27 04:21:05 | Quebec, Canada | |||
2022-11-26 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-27 04:21:05 | Saskatchewan, Canada | |||
2022-11-25 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-26 04:21:11 | Quebec, Canada | |||
2022-11-25 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-26 04:21:11 | Saskatchewan, Canada | |||
2022-11-24 | Canada | Quebec | 1247245 | 17302 | 0 | 52.9399 | -73.5491 | 2022-11-25 04:21:06 | Quebec, Canada | |||
2022-11-24 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-25 04:21:06 | Saskatchewan, Canada | |||
2022-11-23 | Canada | Quebec | 1246205 | 17292 | 0 | 52.9399 | -73.5491 | 2022-11-24 04:21:09 | Quebec, Canada | |||
2022-11-23 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-24 04:21:09 | Saskatchewan, Canada | |||
2022-11-22 | Canada | Quebec | 1244873 | 17290 | 0 | 52.9399 | -73.5491 | 2022-11-23 04:21:06 | Quebec, Canada | |||
2022-11-22 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-23 04:21:06 | Saskatchewan, Canada | |||
2022-11-21 | Canada | Quebec | 1243933 | 17272 | 0 | 52.9399 | -73.5491 | 2022-11-22 04:20:47 | Quebec, Canada | |||
2022-11-21 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-22 04:20:47 | Saskatchewan, Canada | |||
2022-11-20 | Canada | Quebec | 1243392 | 17270 | 0 | 52.9399 | -73.5491 | 2022-11-21 04:21:05 | Quebec, Canada | |||
2022-11-20 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-21 04:21:05 | Saskatchewan, Canada | |||
2022-11-19 | Canada | Quebec | 1242808 | 17270 | 0 | 52.9399 | -73.5491 | 2022-11-20 04:21:08 | Quebec, Canada | |||
2022-11-19 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-20 04:21:08 | Saskatchewan, Canada | |||
2022-11-18 | Canada | Quebec | 1242143 | 17264 | 0 | 52.9399 | -73.5491 | 2022-11-19 04:21:14 | Quebec, Canada | |||
2022-11-18 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-19 04:21:14 | Saskatchewan, Canada | |||
2022-11-17 | Canada | Quebec | 1241406 | 17253 | 0 | 52.9399 | -73.5491 | 2022-11-18 04:21:15 | Quebec, Canada | |||
2022-11-17 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-18 04:21:15 | Saskatchewan, Canada | |||
2022-11-16 | Canada | Quebec | 1240569 | 17244 | 0 | 52.9399 | -73.5491 | 2022-11-17 04:21:11 | Quebec, Canada | |||
2022-11-16 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-17 04:21:11 | Saskatchewan, Canada | |||
2022-11-15 | Canada | Quebec | 1239532 | 17190 | 0 | 52.9399 | -73.5491 | 2022-11-16 04:21:09 | Quebec, Canada | |||
2022-11-15 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-16 04:21:09 | Saskatchewan, Canada | |||
2022-11-14 | Canada | Quebec | 1238739 | 17178 | 0 | 52.9399 | -73.5491 | 2022-11-15 04:21:16 | Quebec, Canada | |||
2022-11-14 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-15 04:21:16 | Saskatchewan, Canada | |||
2022-11-13 | Canada | Quebec | 1238219 | 17176 | 0 | 52.9399 | -73.5491 | 2022-11-14 04:21:09 | Quebec, Canada | |||
2022-11-13 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-14 04:21:09 | Saskatchewan, Canada | |||
2022-11-12 | Canada | Quebec | 1237705 | 17175 | 0 | 52.9399 | -73.5491 | 2022-11-13 04:21:14 | Quebec, Canada | |||
2022-11-12 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-13 04:21:14 | Saskatchewan, Canada | |||
2022-11-11 | Canada | Quebec | 1237025 | 17166 | 0 | 52.9399 | -73.5491 | 2022-11-12 04:20:41 | Quebec, Canada | |||
2022-11-11 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-12 04:20:41 | Saskatchewan, Canada | |||
2022-11-10 | Canada | Quebec | 1236286 | 17152 | 0 | 52.9399 | -73.5491 | 2022-11-11 04:21:22 | Quebec, Canada | |||
2022-11-10 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-11 04:21:22 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;