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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-09 | Canada | Quebec | 15 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-09T08:43:03 | ||||
2020-03-10 | Canada | Quebec | 17 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-10T00:53:03 | ||||
2020-03-11 | Canada | Quebec | 27 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T23:13:06 | ||||
2020-03-12 | Canada | Quebec | 33 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-12T01:53:03 | ||||
2020-03-13 | Canada | Quebec | 37 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T20:00:00 | ||||
2020-03-13 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-11T20:00:00 | ||||
2020-03-14 | Canada | Quebec | 55 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-13T13:33:03 | ||||
2020-03-14 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
2020-03-15 | Canada | Quebec | 68 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-15T01:53:02 | ||||
2020-03-15 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
2020-03-16 | Canada | Quebec | 85 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-16T20:13:20 | ||||
2020-03-16 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
2020-03-17 | Canada | Quebec | 128 | 1 | 0 | 52.9399 | -73.5491 | 2020-03-17T19:33:03 | ||||
2020-03-17 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
2020-03-18 | Canada | Saskatchewan | 8 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-18T11:53:04 | ||||
2020-03-19 | Canada | Quebec | 242 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-19T17:43:04 | ||||
2020-03-19 | Canada | Saskatchewan | 16 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-19T01:03:51 | ||||
2020-03-20 | Canada | Quebec | 371 | 4 | 0 | 52.9399 | -73.5491 | 2020-03-20T21:13:29 | ||||
2020-03-20 | Canada | Saskatchewan | 20 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-20T03:13:18 | ||||
2020-03-21 | Canada | Quebec | 557 | 5 | 0 | 52.9399 | -73.5491 | 2020-03-21T21:13:30 | ||||
2020-03-21 | Canada | Saskatchewan | 26 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-21T02:43:03 | ||||
2020-03-22 | Canada | Quebec | 795 | 5 | 0 | 790 | 52.9399 | -73.5491 | 3/22/20 23:48 | Quebec, Canada | ||
2020-03-22 | Canada | Saskatchewan | 52 | 0 | 0 | 52 | 52.9399 | -106.4509 | 3/22/20 23:48 | Saskatchewan, Canada | ||
2020-03-23 | Canada | Quebec | 1140 | 8 | 0 | 1132 | 52.9399 | -73.5491 | 2020-03-23 23:23:10 | Quebec, Canada | ||
2020-03-23 | Canada | Saskatchewan | 66 | 0 | 0 | 66 | 52.9399 | -106.4509 | 2020-03-23 23:23:10 | Saskatchewan, Canada | ||
2020-03-24 | Canada | Quebec | 1408 | 11 | 0 | 1397 | 52.9399 | -73.5491 | 2020-03-24 23:41:36 | Quebec, Canada | ||
2020-03-24 | Canada | Saskatchewan | 72 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-24 23:41:36 | Saskatchewan, Canada | ||
2020-03-25 | Canada | Quebec | 1774 | 18 | 0 | 1756 | 52.9399 | -73.5491 | 2020-03-25 23:37:36 | Quebec, Canada | ||
2020-03-25 | Canada | Saskatchewan | 86 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-25 23:37:36 | Saskatchewan, Canada | ||
2020-03-26 | Canada | Quebec | 2140 | 27 | 0 | 2113 | 52.9399 | -73.5491 | 2020-03-26 23:53:11 | Quebec, Canada | ||
2020-03-26 | Canada | Saskatchewan | 95 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-26 23:53:11 | Saskatchewan, Canada | ||
2020-03-27 | Canada | Quebec | 2591 | 30 | 0 | 2561 | 52.9399 | -73.5491 | 2020-03-27 23:27:32 | Quebec, Canada | ||
2020-03-27 | Canada | Saskatchewan | 104 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-27 23:27:32 | Saskatchewan, Canada | ||
2020-03-28 | Canada | Quebec | 3007 | 43 | 0 | 2964 | 52.9399 | -73.5491 | 3/28/20 23:10 | Quebec, Canada | ||
2020-03-28 | Canada | Saskatchewan | 134 | 0 | 0 | 134 | 52.9399 | -106.4509 | 3/28/20 23:10 | Saskatchewan, Canada | ||
2020-03-29 | Canada | Quebec | 3575 | 54 | 0 | 3521 | 52.9399 | -73.5491 | 3/29/20 23:13 | Quebec, Canada | ||
2020-03-29 | Canada | Saskatchewan | 134 | 0 | 0 | 156 | 52.9399 | -106.4509 | 3/29/20 23:13 | Saskatchewan, Canada | ||
2020-03-30 | Canada | Quebec | 4153 | 67 | 0 | 4086 | 52.9399 | -73.5491 | 3/30/20 22:58 | Quebec, Canada | ||
2020-03-30 | Canada | Saskatchewan | 175 | 2 | 0 | 154 | 52.9399 | -106.4509 | 3/30/20 22:58 | Saskatchewan, Canada | ||
2020-03-31 | Canada | Quebec | 4881 | 82 | 0 | 4799 | 52.9399 | -73.5491 | 2020-03-31 23:49:13 | Quebec, Canada | ||
2020-03-31 | Canada | Saskatchewan | 184 | 2 | 0 | 182 | 52.9399 | -106.4509 | 2020-03-31 23:49:13 | Saskatchewan, Canada | ||
2020-04-01 | Canada | Quebec | 5578 | 99 | 0 | 5479 | 52.9399 | -73.5491 | 2020-04-01 22:04:44 | Quebec, Canada | ||
2020-04-01 | Canada | Saskatchewan | 193 | 3 | 0 | 190 | 52.9399 | -106.4509 | 2020-04-01 22:04:44 | Saskatchewan, Canada | ||
2020-04-02 | Canada | Quebec | 6453 | 121 | 0 | 6332 | 52.9399 | -73.5491 | 4/2/20 23:31 | Quebec, Canada | ||
2020-04-02 | Canada | Saskatchewan | 206 | 3 | 0 | 203 | 52.9399 | -106.4509 | 4/2/20 23:31 | Saskatchewan, Canada | ||
2020-04-03 | Canada | Quebec | 7223 | 159 | 0 | 7064 | 52.9399 | -73.5491 | 2020-04-03 22:52:30 | Quebec, Canada | ||
2020-04-03 | Canada | Saskatchewan | 220 | 3 | 0 | 217 | 52.9399 | -106.4509 | 2020-04-03 22:52:30 | Saskatchewan, Canada | ||
2020-04-04 | Canada | Quebec | 8029 | 203 | 0 | 7826 | 52.9399 | -73.5491 | 4/4/20 23:40 | Quebec, Canada | ||
2020-04-04 | Canada | Saskatchewan | 231 | 3 | 0 | 217 | 52.9399 | -106.4509 | 4/4/20 23:40 | Saskatchewan, Canada | ||
2020-04-05 | Canada | Quebec | 8663 | 251 | 0 | 8412 | 52.9399 | -73.5491 | 2020-04-05 23:13:28 | Quebec, Canada | ||
2020-04-05 | Canada | Saskatchewan | 249 | 3 | 0 | 246 | 52.9399 | -106.4509 | 2020-04-05 23:13:28 | Saskatchewan, Canada | ||
2020-04-06 | Canada | Quebec | 9538 | 302 | 0 | 9236 | 52.9399 | -73.5491 | 4/6/20 23:28 | Quebec, Canada | ||
2020-04-06 | Canada | Saskatchewan | 253 | 3 | 0 | 246 | 52.9399 | -106.4509 | 4/6/20 23:28 | Saskatchewan, Canada | ||
2020-04-07 | Canada | Quebec | 10326 | 356 | 0 | 9970 | 52.9399 | -73.5491 | 2020-04-07 23:11:15 | Quebec, Canada | ||
2020-04-07 | Canada | Saskatchewan | 260 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-07 23:11:15 | Saskatchewan, Canada | ||
2020-04-08 | Canada | Quebec | 11012 | 416 | 0 | 10596 | 52.9399 | -73.5491 | 2020-04-08 22:58:44 | Quebec, Canada | ||
2020-04-08 | Canada | Saskatchewan | 271 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-08 22:58:44 | Saskatchewan, Canada | ||
2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
2020-04-09 | Canada | Saskatchewan | 278 | 3 | 0 | 268 | 52.9399 | -106.4509 | 2020-04-09 23:09:01 | Saskatchewan, Canada | ||
2020-04-10 | Canada | Quebec | 12395 | 551 | 0 | 11844 | 52.9399 | -73.5491 | 2020-04-10 23:01:26 | Quebec, Canada | ||
2020-04-10 | Canada | Saskatchewan | 285 | 3 | 0 | 282 | 52.9399 | -106.4509 | 2020-04-10 23:01:26 | Saskatchewan, Canada | ||
2020-04-11 | Canada | Quebec | 13060 | 621 | 0 | 12439 | 52.9399 | -73.5491 | 2020-04-11 22:52:28 | Quebec, Canada | ||
2020-04-11 | Canada | Saskatchewan | 289 | 4 | 0 | 285 | 52.9399 | -106.4509 | 2020-04-11 22:52:28 | Saskatchewan, Canada | ||
2020-04-12 | Canada | Quebec | 13850 | 709 | 0 | 13141 | 52.9399 | -73.5491 | 2020-04-12 23:24:00 | Quebec, Canada | ||
2020-04-12 | Canada | Saskatchewan | 298 | 4 | 0 | 294 | 52.9399 | -106.4509 | 2020-04-12 23:24:00 | Saskatchewan, Canada | ||
2020-04-13 | Canada | Quebec | 14814 | 804 | 0 | 14010 | 52.9399 | -73.5491 | 2020-04-13 23:15:25 | Quebec, Canada | ||
2020-04-13 | Canada | Saskatchewan | 300 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-13 23:15:25 | Saskatchewan, Canada | ||
2020-04-14 | Canada | Quebec | 15776 | 895 | 0 | 14881 | 52.9399 | -73.5491 | 2020-04-14 23:40:54 | Quebec, Canada | ||
2020-04-14 | Canada | Saskatchewan | 301 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-14 23:40:54 | Saskatchewan, Canada | ||
2020-04-15 | Canada | Quebec | 16874 | 994 | 0 | 15880 | 52.9399 | -73.5491 | 2020-04-15 23:04:09 | Quebec, Canada | ||
2020-04-15 | Canada | Saskatchewan | 304 | 4 | 0 | 300 | 52.9399 | -106.4509 | 2020-04-15 23:04:09 | Saskatchewan, Canada | ||
2020-04-16 | Canada | Quebec | 17838 | 1089 | 0 | 16749 | 52.9399 | -73.5491 | 2020-04-16 23:38:03 | Quebec, Canada | ||
2020-04-16 | Canada | Saskatchewan | 305 | 4 | 0 | 301 | 52.9399 | -106.4509 | 2020-04-16 23:38:03 | Saskatchewan, Canada | ||
2020-04-17 | Canada | Quebec | 18860 | 1176 | 0 | 17684 | 52.9399 | -73.5491 | 2020-04-17 23:38:31 | Quebec, Canada | ||
2020-04-17 | Canada | Saskatchewan | 307 | 4 | 0 | 303 | 52.9399 | -106.4509 | 2020-04-17 23:38:31 | Saskatchewan, Canada | ||
2020-04-18 | Canada | Quebec | 19523 | 1274 | 0 | 18249 | 52.9399 | -73.5491 | 2020-04-18 22:40:03 | Quebec, Canada | ||
2020-04-18 | Canada | Saskatchewan | 313 | 4 | 0 | 309 | 52.9399 | -106.4509 | 2020-04-18 22:40:03 | Saskatchewan, Canada | ||
2020-04-19 | Canada | Quebec | 20343 | 1400 | 0 | 18943 | 52.9399 | -73.5491 | 2020-04-19 23:48:49 | Quebec, Canada | ||
2020-04-19 | Canada | Saskatchewan | 315 | 4 | 0 | 311 | 52.9399 | -106.4509 | 2020-04-19 23:48:49 | Saskatchewan, Canada | ||
2020-04-20 | Canada | Quebec | 21252 | 1503 | 0 | 19749 | 52.9399 | -73.5491 | 2020-04-20 23:44:34 | Quebec, Canada | ||
2020-04-20 | Canada | Saskatchewan | 316 | 4 | 0 | 312 | 52.9399 | -106.4509 | 2020-04-20 23:44:34 | Saskatchewan, Canada | ||
2020-04-21 | Canada | Quebec | 22058 | 1618 | 0 | 20440 | 52.9399 | -73.5491 | 2020-04-21 23:38:53 | Quebec, Canada | ||
2020-04-21 | Canada | Saskatchewan | 320 | 4 | 0 | 316 | 52.9399 | -106.4509 | 2020-04-21 23:38:53 | Saskatchewan, Canada | ||
2020-04-22 | Canada | Quebec | 22943 | 1735 | 0 | 21208 | 52.9399 | -73.5491 | 2020-04-22 23:38:42 | Quebec, Canada | ||
2020-04-22 | Canada | Saskatchewan | 326 | 4 | 0 | 322 | 52.9399 | -106.4509 | 2020-04-22 23:38:42 | Saskatchewan, Canada | ||
2020-04-23 | Canada | Quebec | 23849 | 1852 | 0 | 21997 | 52.9399 | -73.5491 | 2020-04-24 03:31:19 | Quebec, Canada | ||
2020-04-23 | Canada | Saskatchewan | 331 | 4 | 0 | 327 | 52.9399 | -106.4509 | 2020-04-24 03:31:19 | Saskatchewan, Canada | ||
2020-04-24 | Canada | Quebec | 24704 | 1968 | 0 | 22736 | 52.9399 | -73.5491 | 2020-04-25 06:30:55 | Quebec, Canada | ||
2020-04-24 | Canada | Saskatchewan | 341 | 4 | 0 | 337 | 52.9399 | -106.4509 | 2020-04-25 06:30:55 | Saskatchewan, Canada | ||
2020-04-25 | Canada | Quebec | 25466 | 2092 | 0 | 23374 | 52.9399 | -73.5491 | 2020-04-26 02:30:54 | Quebec, Canada | ||
2020-04-25 | Canada | Saskatchewan | 349 | 4 | 0 | 345 | 52.9399 | -106.4509 | 2020-04-26 02:30:54 | Saskatchewan, Canada | ||
2020-04-26 | Canada | Quebec | 26078 | 2203 | 0 | 23875 | 52.9399 | -73.5491 | 2020-04-27 02:30:55 | Quebec, Canada | ||
2020-04-26 | Canada | Saskatchewan | 353 | 4 | 0 | 349 | 52.9399 | -106.4509 | 2020-04-27 02:30:55 | Saskatchewan, Canada | ||
2020-04-27 | Canada | Quebec | 26988 | 2318 | 0 | 24670 | 52.9399 | -73.5491 | 2020-04-28 02:30:53 | Quebec, Canada | ||
2020-04-27 | Canada | Saskatchewan | 365 | 5 | 0 | 360 | 52.9399 | -106.4509 | 2020-04-28 02:30:53 | Saskatchewan, Canada | ||
2020-04-28 | Canada | Quebec | 27908 | 2456 | 0 | 25452 | 52.9399 | -73.5491 | 2020-04-29 02:32:29 | Quebec, Canada | ||
2020-04-28 | Canada | Saskatchewan | 366 | 5 | 0 | 361 | 52.9399 | -106.4509 | 2020-04-29 02:32:29 | Saskatchewan, Canada | ||
2020-04-29 | Canada | Quebec | 28806 | 2607 | 0 | 26199 | 52.9399 | -73.5491 | 2020-04-30 02:32:27 | Quebec, Canada | ||
2020-04-29 | Canada | Saskatchewan | 383 | 6 | 0 | 377 | 52.9399 | -106.4509 | 2020-04-30 02:32:27 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;