johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,048 rows where country_or_region = "Canada" and latitude = "52.9399" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, day (date), last_update (date)
province_or_state 2
- Quebec 1,026
- Saskatchewan 1,022
country_or_region 1
- Canada · 2,048 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657822 | 657822 | 2020-03-09 | Canada | Quebec | 15 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-09T08:43:03 | ||||
3752954 | 3752954 | 2020-03-10 | Canada | Quebec | 17 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-10T00:53:03 | ||||
3765373 | 3765373 | 2020-03-13 | Canada | Quebec | 37 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T20:00:00 | ||||
3765395 | 3765395 | 2020-03-13 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-11T20:00:00 | ||||
2127557 | 2127557 | 2020-03-11 | Canada | Quebec | 27 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T23:13:06 | ||||
2282994 | 2282994 | 2020-03-12 | Canada | Quebec | 33 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-12T01:53:03 | ||||
2111225 | 2111225 | 2020-03-14 | Canada | Quebec | 55 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-13T13:33:03 | ||||
1463666 | 1463666 | 2020-03-15 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
2111283 | 2111283 | 2020-03-14 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
1463588 | 1463588 | 2020-03-15 | Canada | Quebec | 68 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-15T01:53:02 | ||||
2255225 | 2255225 | 2020-03-16 | Canada | Quebec | 85 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-16T20:13:20 | ||||
2255299 | 2255299 | 2020-03-16 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
3891508 | 3891508 | 2020-03-17 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
3891404 | 3891404 | 2020-03-17 | Canada | Quebec | 128 | 1 | 0 | 52.9399 | -73.5491 | 2020-03-17T19:33:03 | ||||
1177077 | 1177077 | 2020-03-18 | Canada | Saskatchewan | 8 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-18T11:53:04 | ||||
1176971 | 1176971 | 2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
1527057 | 1527057 | 2020-03-19 | Canada | Saskatchewan | 16 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-19T01:03:51 | ||||
1526969 | 1526969 | 2020-03-19 | Canada | Quebec | 242 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-19T17:43:04 | ||||
3734107 | 3734107 | 2020-03-20 | Canada | Saskatchewan | 20 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-20T03:13:18 | ||||
3734017 | 3734017 | 2020-03-20 | Canada | Quebec | 371 | 4 | 0 | 52.9399 | -73.5491 | 2020-03-20T21:13:29 | ||||
339809 | 339809 | 2020-03-21 | Canada | Saskatchewan | 26 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-21T02:43:03 | ||||
339718 | 339718 | 2020-03-21 | Canada | Quebec | 557 | 5 | 0 | 52.9399 | -73.5491 | 2020-03-21T21:13:30 | ||||
2147090 | 2147090 | 2020-03-23 | Canada | Quebec | 1140 | 8 | 0 | 1132 | 52.9399 | -73.5491 | 2020-03-23 23:23:10 | Quebec, Canada | ||
2147095 | 2147095 | 2020-03-23 | Canada | Saskatchewan | 66 | 0 | 0 | 66 | 52.9399 | -106.4509 | 2020-03-23 23:23:10 | Saskatchewan, Canada | ||
1479031 | 1479031 | 2020-03-24 | Canada | Quebec | 1408 | 11 | 0 | 1397 | 52.9399 | -73.5491 | 2020-03-24 23:41:36 | Quebec, Canada | ||
1479038 | 1479038 | 2020-03-24 | Canada | Saskatchewan | 72 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-24 23:41:36 | Saskatchewan, Canada | ||
1132523 | 1132523 | 2020-03-25 | Canada | Quebec | 1774 | 18 | 0 | 1756 | 52.9399 | -73.5491 | 2020-03-25 23:37:36 | Quebec, Canada | ||
1132530 | 1132530 | 2020-03-25 | Canada | Saskatchewan | 86 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-25 23:37:36 | Saskatchewan, Canada | ||
919121 | 919121 | 2020-03-26 | Canada | Quebec | 2140 | 27 | 0 | 2113 | 52.9399 | -73.5491 | 2020-03-26 23:53:11 | Quebec, Canada | ||
919128 | 919128 | 2020-03-26 | Canada | Saskatchewan | 95 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-26 23:53:11 | Saskatchewan, Canada | ||
809028 | 809028 | 2020-03-27 | Canada | Quebec | 2591 | 30 | 0 | 2561 | 52.9399 | -73.5491 | 2020-03-27 23:27:32 | Quebec, Canada | ||
809035 | 809035 | 2020-03-27 | Canada | Saskatchewan | 104 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-27 23:27:32 | Saskatchewan, Canada | ||
3815853 | 3815853 | 2020-03-31 | Canada | Quebec | 4881 | 82 | 0 | 4799 | 52.9399 | -73.5491 | 2020-03-31 23:49:13 | Quebec, Canada | ||
3815860 | 3815860 | 2020-03-31 | Canada | Saskatchewan | 184 | 2 | 0 | 182 | 52.9399 | -106.4509 | 2020-03-31 23:49:13 | Saskatchewan, Canada | ||
3364760 | 3364760 | 2020-04-01 | Canada | Quebec | 5578 | 99 | 0 | 5479 | 52.9399 | -73.5491 | 2020-04-01 22:04:44 | Quebec, Canada | ||
3364767 | 3364767 | 2020-04-01 | Canada | Saskatchewan | 193 | 3 | 0 | 190 | 52.9399 | -106.4509 | 2020-04-01 22:04:44 | Saskatchewan, Canada | ||
3740526 | 3740526 | 2020-04-03 | Canada | Quebec | 7223 | 159 | 0 | 7064 | 52.9399 | -73.5491 | 2020-04-03 22:52:30 | Quebec, Canada | ||
3740533 | 3740533 | 2020-04-03 | Canada | Saskatchewan | 220 | 3 | 0 | 217 | 52.9399 | -106.4509 | 2020-04-03 22:52:30 | Saskatchewan, Canada | ||
589071 | 589071 | 2020-04-05 | Canada | Quebec | 8663 | 251 | 0 | 8412 | 52.9399 | -73.5491 | 2020-04-05 23:13:28 | Quebec, Canada | ||
589079 | 589079 | 2020-04-05 | Canada | Saskatchewan | 249 | 3 | 0 | 246 | 52.9399 | -106.4509 | 2020-04-05 23:13:28 | Saskatchewan, Canada | ||
3021701 | 3021701 | 2020-04-07 | Canada | Quebec | 10326 | 356 | 0 | 9970 | 52.9399 | -73.5491 | 2020-04-07 23:11:15 | Quebec, Canada | ||
3021709 | 3021709 | 2020-04-07 | Canada | Saskatchewan | 260 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-07 23:11:15 | Saskatchewan, Canada | ||
3562026 | 3562026 | 2020-04-08 | Canada | Quebec | 11012 | 416 | 0 | 10596 | 52.9399 | -73.5491 | 2020-04-08 22:58:44 | Quebec, Canada | ||
3562034 | 3562034 | 2020-04-08 | Canada | Saskatchewan | 271 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-08 22:58:44 | Saskatchewan, Canada | ||
3949919 | 3949919 | 2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
3949927 | 3949927 | 2020-04-09 | Canada | Saskatchewan | 278 | 3 | 0 | 268 | 52.9399 | -106.4509 | 2020-04-09 23:09:01 | Saskatchewan, Canada | ||
1250182 | 1250182 | 2020-04-10 | Canada | Quebec | 12395 | 551 | 0 | 11844 | 52.9399 | -73.5491 | 2020-04-10 23:01:26 | Quebec, Canada | ||
1250190 | 1250190 | 2020-04-10 | Canada | Saskatchewan | 285 | 3 | 0 | 282 | 52.9399 | -106.4509 | 2020-04-10 23:01:26 | Saskatchewan, Canada | ||
2566997 | 2566997 | 2020-04-11 | Canada | Quebec | 13060 | 621 | 0 | 12439 | 52.9399 | -73.5491 | 2020-04-11 22:52:28 | Quebec, Canada | ||
2567005 | 2567005 | 2020-04-11 | Canada | Saskatchewan | 289 | 4 | 0 | 285 | 52.9399 | -106.4509 | 2020-04-11 22:52:28 | Saskatchewan, Canada | ||
2578160 | 2578160 | 2020-04-12 | Canada | Quebec | 13850 | 709 | 0 | 13141 | 52.9399 | -73.5491 | 2020-04-12 23:24:00 | Quebec, Canada | ||
2578168 | 2578168 | 2020-04-12 | Canada | Saskatchewan | 298 | 4 | 0 | 294 | 52.9399 | -106.4509 | 2020-04-12 23:24:00 | Saskatchewan, Canada | ||
43134 | 43134 | 2020-04-13 | Canada | Quebec | 14814 | 804 | 0 | 14010 | 52.9399 | -73.5491 | 2020-04-13 23:15:25 | Quebec, Canada | ||
43142 | 43142 | 2020-04-13 | Canada | Saskatchewan | 300 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-13 23:15:25 | Saskatchewan, Canada | ||
3338037 | 3338037 | 2020-04-14 | Canada | Quebec | 15776 | 895 | 0 | 14881 | 52.9399 | -73.5491 | 2020-04-14 23:40:54 | Quebec, Canada | ||
3338045 | 3338045 | 2020-04-14 | Canada | Saskatchewan | 301 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-14 23:40:54 | Saskatchewan, Canada | ||
860121 | 860121 | 2020-04-15 | Canada | Quebec | 16874 | 994 | 0 | 15880 | 52.9399 | -73.5491 | 2020-04-15 23:04:09 | Quebec, Canada | ||
860129 | 860129 | 2020-04-15 | Canada | Saskatchewan | 304 | 4 | 0 | 300 | 52.9399 | -106.4509 | 2020-04-15 23:04:09 | Saskatchewan, Canada | ||
934227 | 934227 | 2020-04-16 | Canada | Quebec | 17838 | 1089 | 0 | 16749 | 52.9399 | -73.5491 | 2020-04-16 23:38:03 | Quebec, Canada | ||
934235 | 934235 | 2020-04-16 | Canada | Saskatchewan | 305 | 4 | 0 | 301 | 52.9399 | -106.4509 | 2020-04-16 23:38:03 | Saskatchewan, Canada | ||
50233 | 50233 | 2020-04-17 | Canada | Quebec | 18860 | 1176 | 0 | 17684 | 52.9399 | -73.5491 | 2020-04-17 23:38:31 | Quebec, Canada | ||
50241 | 50241 | 2020-04-17 | Canada | Saskatchewan | 307 | 4 | 0 | 303 | 52.9399 | -106.4509 | 2020-04-17 23:38:31 | Saskatchewan, Canada | ||
418761 | 418761 | 2020-04-18 | Canada | Quebec | 19523 | 1274 | 0 | 18249 | 52.9399 | -73.5491 | 2020-04-18 22:40:03 | Quebec, Canada | ||
418769 | 418769 | 2020-04-18 | Canada | Saskatchewan | 313 | 4 | 0 | 309 | 52.9399 | -106.4509 | 2020-04-18 22:40:03 | Saskatchewan, Canada | ||
1385073 | 1385073 | 2020-04-19 | Canada | Quebec | 20343 | 1400 | 0 | 18943 | 52.9399 | -73.5491 | 2020-04-19 23:48:49 | Quebec, Canada | ||
1385081 | 1385081 | 2020-04-19 | Canada | Saskatchewan | 315 | 4 | 0 | 311 | 52.9399 | -106.4509 | 2020-04-19 23:48:49 | Saskatchewan, Canada | ||
2473381 | 2473381 | 2020-04-20 | Canada | Quebec | 21252 | 1503 | 0 | 19749 | 52.9399 | -73.5491 | 2020-04-20 23:44:34 | Quebec, Canada | ||
2473389 | 2473389 | 2020-04-20 | Canada | Saskatchewan | 316 | 4 | 0 | 312 | 52.9399 | -106.4509 | 2020-04-20 23:44:34 | Saskatchewan, Canada | ||
522299 | 522299 | 2020-04-21 | Canada | Quebec | 22058 | 1618 | 0 | 20440 | 52.9399 | -73.5491 | 2020-04-21 23:38:53 | Quebec, Canada | ||
522307 | 522307 | 2020-04-21 | Canada | Saskatchewan | 320 | 4 | 0 | 316 | 52.9399 | -106.4509 | 2020-04-21 23:38:53 | Saskatchewan, Canada | ||
1199233 | 1199233 | 2020-04-22 | Canada | Quebec | 22943 | 1735 | 0 | 21208 | 52.9399 | -73.5491 | 2020-04-22 23:38:42 | Quebec, Canada | ||
1199241 | 1199241 | 2020-04-22 | Canada | Saskatchewan | 326 | 4 | 0 | 322 | 52.9399 | -106.4509 | 2020-04-22 23:38:42 | Saskatchewan, Canada | ||
2524788 | 2524788 | 2020-04-23 | Canada | Quebec | 23849 | 1852 | 0 | 21997 | 52.9399 | -73.5491 | 2020-04-24 03:31:19 | Quebec, Canada | ||
2524795 | 2524795 | 2020-04-23 | Canada | Saskatchewan | 331 | 4 | 0 | 327 | 52.9399 | -106.4509 | 2020-04-24 03:31:19 | Saskatchewan, Canada | ||
1459200 | 1459200 | 2020-04-24 | Canada | Quebec | 24704 | 1968 | 0 | 22736 | 52.9399 | -73.5491 | 2020-04-25 06:30:55 | Quebec, Canada | ||
1459206 | 1459206 | 2020-04-24 | Canada | Saskatchewan | 341 | 4 | 0 | 337 | 52.9399 | -106.4509 | 2020-04-25 06:30:55 | Saskatchewan, Canada | ||
3502799 | 3502799 | 2020-04-25 | Canada | Quebec | 25466 | 2092 | 0 | 23374 | 52.9399 | -73.5491 | 2020-04-26 02:30:54 | Quebec, Canada | ||
3502805 | 3502805 | 2020-04-25 | Canada | Saskatchewan | 349 | 4 | 0 | 345 | 52.9399 | -106.4509 | 2020-04-26 02:30:54 | Saskatchewan, Canada | ||
3592450 | 3592450 | 2020-04-26 | Canada | Quebec | 26078 | 2203 | 0 | 23875 | 52.9399 | -73.5491 | 2020-04-27 02:30:55 | Quebec, Canada | ||
3592456 | 3592456 | 2020-04-26 | Canada | Saskatchewan | 353 | 4 | 0 | 349 | 52.9399 | -106.4509 | 2020-04-27 02:30:55 | Saskatchewan, Canada | ||
3589271 | 3589271 | 2020-04-27 | Canada | Quebec | 26988 | 2318 | 0 | 24670 | 52.9399 | -73.5491 | 2020-04-28 02:30:53 | Quebec, Canada | ||
3589278 | 3589278 | 2020-04-27 | Canada | Saskatchewan | 365 | 5 | 0 | 360 | 52.9399 | -106.4509 | 2020-04-28 02:30:53 | Saskatchewan, Canada | ||
271611 | 271611 | 2020-04-28 | Canada | Quebec | 27908 | 2456 | 0 | 25452 | 52.9399 | -73.5491 | 2020-04-29 02:32:29 | Quebec, Canada | ||
271619 | 271619 | 2020-04-28 | Canada | Saskatchewan | 366 | 5 | 0 | 361 | 52.9399 | -106.4509 | 2020-04-29 02:32:29 | Saskatchewan, Canada | ||
137397 | 137397 | 2020-04-29 | Canada | Quebec | 28806 | 2607 | 0 | 26199 | 52.9399 | -73.5491 | 2020-04-30 02:32:27 | Quebec, Canada | ||
137405 | 137405 | 2020-04-29 | Canada | Saskatchewan | 383 | 6 | 0 | 377 | 52.9399 | -106.4509 | 2020-04-30 02:32:27 | Saskatchewan, Canada | ||
228650 | 228650 | 2020-04-30 | Canada | Quebec | 29809 | 2728 | 0 | 27081 | 52.9399 | -73.5491 | 2020-05-01 02:32:28 | Quebec, Canada | ||
228658 | 228658 | 2020-04-30 | Canada | Saskatchewan | 389 | 6 | 0 | 382 | 52.9399 | -106.4509 | 2020-05-01 02:32:28 | Saskatchewan, Canada | ||
1184169 | 1184169 | 2020-05-01 | Canada | Quebec | 30862 | 2866 | 0 | 27996 | 52.9399 | -73.5491 | 2020-05-02 02:32:27 | Quebec, Canada | ||
1184177 | 1184177 | 2020-05-01 | Canada | Saskatchewan | 415 | 6 | 0 | 408 | 52.9399 | -106.4509 | 2020-05-02 02:32:27 | Saskatchewan, Canada | ||
2043275 | 2043275 | 2020-05-02 | Canada | Quebec | 31761 | 2981 | 0 | 28780 | 52.9399 | -73.5491 | 2020-05-03 02:32:28 | Quebec, Canada | ||
2043283 | 2043283 | 2020-05-02 | Canada | Saskatchewan | 421 | 6 | 0 | 414 | 52.9399 | -106.4509 | 2020-05-03 02:32:28 | Saskatchewan, Canada | ||
2278599 | 2278599 | 2020-05-03 | Canada | Quebec | 32552 | 3080 | 0 | 29472 | 52.9399 | -73.5491 | 2020-05-04 02:32:28 | Quebec, Canada | ||
2278607 | 2278607 | 2020-05-03 | Canada | Saskatchewan | 433 | 6 | 0 | 426 | 52.9399 | -106.4509 | 2020-05-04 02:32:28 | Saskatchewan, Canada | ||
3084740 | 3084740 | 2020-05-04 | Canada | Quebec | 33417 | 3189 | 0 | 30228 | 52.9399 | -73.5491 | 2020-05-05 02:32:34 | Quebec, Canada | ||
3084748 | 3084748 | 2020-05-04 | Canada | Saskatchewan | 467 | 6 | 0 | 460 | 52.9399 | -106.4509 | 2020-05-05 02:32:34 | Saskatchewan, Canada | ||
1931877 | 1931877 | 2020-05-05 | Canada | Quebec | 34310 | 3290 | 0 | 31020 | 52.9399 | -73.5491 | 2020-05-06 02:32:31 | Quebec, Canada | ||
1931885 | 1931885 | 2020-05-05 | Canada | Saskatchewan | 487 | 6 | 0 | 480 | 52.9399 | -106.4509 | 2020-05-06 02:32:31 | Saskatchewan, Canada | ||
2110837 | 2110837 | 2020-05-06 | Canada | Quebec | 35343 | 3385 | 0 | 31958 | 52.9399 | -73.5491 | 2020-05-07 02:32:28 | Quebec, Canada | ||
2110845 | 2110845 | 2020-05-06 | Canada | Saskatchewan | 512 | 6 | 0 | 505 | 52.9399 | -106.4509 | 2020-05-07 02:32:28 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
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]);