johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where country_or_region = "Canada" and province_or_state = "Quebec" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-12-02 5
- 2020-03-11 2
- 2022-04-13 2
- 2022-05-26 2
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- …
province_or_state 1
- Quebec · 1,026 ✖
country_or_region 1
- Canada · 1,026 ✖
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 | ||||
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 | ||||
3765373 | 3765373 | 2020-03-13 | Canada | Quebec | 37 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T20:00:00 | ||||
2111225 | 2111225 | 2020-03-14 | Canada | Quebec | 55 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-13T13:33:03 | ||||
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 | ||||
3891404 | 3891404 | 2020-03-17 | Canada | Quebec | 128 | 1 | 0 | 52.9399 | -73.5491 | 2020-03-17T19:33:03 | ||||
1176971 | 1176971 | 2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
1526969 | 1526969 | 2020-03-19 | Canada | Quebec | 242 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-19T17:43:04 | ||||
3734017 | 3734017 | 2020-03-20 | Canada | Quebec | 371 | 4 | 0 | 52.9399 | -73.5491 | 2020-03-20T21:13:29 | ||||
339718 | 339718 | 2020-03-21 | Canada | Quebec | 557 | 5 | 0 | 52.9399 | -73.5491 | 2020-03-21T21:13:30 | ||||
2910582 | 2910582 | 2020-03-22 | Canada | Quebec | 795 | 5 | 0 | 790 | 52.9399 | -73.5491 | 3/22/20 23:48 | Quebec, Canada | ||
2147090 | 2147090 | 2020-03-23 | Canada | Quebec | 1140 | 8 | 0 | 1132 | 52.9399 | -73.5491 | 2020-03-23 23:23:10 | Quebec, Canada | ||
1479031 | 1479031 | 2020-03-24 | Canada | Quebec | 1408 | 11 | 0 | 1397 | 52.9399 | -73.5491 | 2020-03-24 23:41:36 | Quebec, Canada | ||
1132523 | 1132523 | 2020-03-25 | Canada | Quebec | 1774 | 18 | 0 | 1756 | 52.9399 | -73.5491 | 2020-03-25 23:37:36 | Quebec, Canada | ||
919121 | 919121 | 2020-03-26 | Canada | Quebec | 2140 | 27 | 0 | 2113 | 52.9399 | -73.5491 | 2020-03-26 23:53:11 | Quebec, Canada | ||
809028 | 809028 | 2020-03-27 | Canada | Quebec | 2591 | 30 | 0 | 2561 | 52.9399 | -73.5491 | 2020-03-27 23:27:32 | Quebec, Canada | ||
3946978 | 3946978 | 2020-03-28 | Canada | Quebec | 3007 | 43 | 0 | 2964 | 52.9399 | -73.5491 | 3/28/20 23:10 | Quebec, Canada | ||
2875642 | 2875642 | 2020-03-29 | Canada | Quebec | 3575 | 54 | 0 | 3521 | 52.9399 | -73.5491 | 3/29/20 23:13 | Quebec, Canada | ||
1872405 | 1872405 | 2020-03-30 | Canada | Quebec | 4153 | 67 | 0 | 4086 | 52.9399 | -73.5491 | 3/30/20 22:58 | Quebec, Canada | ||
3815853 | 3815853 | 2020-03-31 | Canada | Quebec | 4881 | 82 | 0 | 4799 | 52.9399 | -73.5491 | 2020-03-31 23:49:13 | Quebec, Canada | ||
3364760 | 3364760 | 2020-04-01 | Canada | Quebec | 5578 | 99 | 0 | 5479 | 52.9399 | -73.5491 | 2020-04-01 22:04:44 | Quebec, Canada | ||
3701556 | 3701556 | 2020-04-02 | Canada | Quebec | 6453 | 121 | 0 | 6332 | 52.9399 | -73.5491 | 4/2/20 23:31 | Quebec, Canada | ||
3740526 | 3740526 | 2020-04-03 | Canada | Quebec | 7223 | 159 | 0 | 7064 | 52.9399 | -73.5491 | 2020-04-03 22:52:30 | Quebec, Canada | ||
1750715 | 1750715 | 2020-04-04 | Canada | Quebec | 8029 | 203 | 0 | 7826 | 52.9399 | -73.5491 | 4/4/20 23:40 | Quebec, Canada | ||
589071 | 589071 | 2020-04-05 | Canada | Quebec | 8663 | 251 | 0 | 8412 | 52.9399 | -73.5491 | 2020-04-05 23:13:28 | Quebec, Canada | ||
3627383 | 3627383 | 2020-04-06 | Canada | Quebec | 9538 | 302 | 0 | 9236 | 52.9399 | -73.5491 | 4/6/20 23:28 | Quebec, Canada | ||
3021701 | 3021701 | 2020-04-07 | Canada | Quebec | 10326 | 356 | 0 | 9970 | 52.9399 | -73.5491 | 2020-04-07 23:11:15 | Quebec, Canada | ||
3562026 | 3562026 | 2020-04-08 | Canada | Quebec | 11012 | 416 | 0 | 10596 | 52.9399 | -73.5491 | 2020-04-08 22:58:44 | Quebec, Canada | ||
3949919 | 3949919 | 2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
1250182 | 1250182 | 2020-04-10 | Canada | Quebec | 12395 | 551 | 0 | 11844 | 52.9399 | -73.5491 | 2020-04-10 23:01:26 | Quebec, Canada | ||
2566997 | 2566997 | 2020-04-11 | Canada | Quebec | 13060 | 621 | 0 | 12439 | 52.9399 | -73.5491 | 2020-04-11 22:52:28 | Quebec, Canada | ||
2578160 | 2578160 | 2020-04-12 | Canada | Quebec | 13850 | 709 | 0 | 13141 | 52.9399 | -73.5491 | 2020-04-12 23:24:00 | Quebec, Canada | ||
43134 | 43134 | 2020-04-13 | Canada | Quebec | 14814 | 804 | 0 | 14010 | 52.9399 | -73.5491 | 2020-04-13 23:15:25 | Quebec, Canada | ||
3338037 | 3338037 | 2020-04-14 | Canada | Quebec | 15776 | 895 | 0 | 14881 | 52.9399 | -73.5491 | 2020-04-14 23:40:54 | Quebec, Canada | ||
860121 | 860121 | 2020-04-15 | Canada | Quebec | 16874 | 994 | 0 | 15880 | 52.9399 | -73.5491 | 2020-04-15 23:04:09 | Quebec, Canada | ||
934227 | 934227 | 2020-04-16 | Canada | Quebec | 17838 | 1089 | 0 | 16749 | 52.9399 | -73.5491 | 2020-04-16 23:38:03 | Quebec, Canada | ||
50233 | 50233 | 2020-04-17 | Canada | Quebec | 18860 | 1176 | 0 | 17684 | 52.9399 | -73.5491 | 2020-04-17 23:38:31 | Quebec, Canada | ||
418761 | 418761 | 2020-04-18 | Canada | Quebec | 19523 | 1274 | 0 | 18249 | 52.9399 | -73.5491 | 2020-04-18 22:40:03 | Quebec, Canada | ||
1385073 | 1385073 | 2020-04-19 | Canada | Quebec | 20343 | 1400 | 0 | 18943 | 52.9399 | -73.5491 | 2020-04-19 23:48:49 | Quebec, Canada | ||
2473381 | 2473381 | 2020-04-20 | Canada | Quebec | 21252 | 1503 | 0 | 19749 | 52.9399 | -73.5491 | 2020-04-20 23:44:34 | Quebec, Canada | ||
522299 | 522299 | 2020-04-21 | Canada | Quebec | 22058 | 1618 | 0 | 20440 | 52.9399 | -73.5491 | 2020-04-21 23:38:53 | Quebec, Canada | ||
1199233 | 1199233 | 2020-04-22 | Canada | Quebec | 22943 | 1735 | 0 | 21208 | 52.9399 | -73.5491 | 2020-04-22 23:38:42 | Quebec, Canada | ||
2524788 | 2524788 | 2020-04-23 | Canada | Quebec | 23849 | 1852 | 0 | 21997 | 52.9399 | -73.5491 | 2020-04-24 03:31:19 | Quebec, Canada | ||
1459200 | 1459200 | 2020-04-24 | Canada | Quebec | 24704 | 1968 | 0 | 22736 | 52.9399 | -73.5491 | 2020-04-25 06:30:55 | Quebec, Canada | ||
3502799 | 3502799 | 2020-04-25 | Canada | Quebec | 25466 | 2092 | 0 | 23374 | 52.9399 | -73.5491 | 2020-04-26 02:30:54 | Quebec, Canada | ||
3592450 | 3592450 | 2020-04-26 | Canada | Quebec | 26078 | 2203 | 0 | 23875 | 52.9399 | -73.5491 | 2020-04-27 02:30:55 | Quebec, Canada | ||
3589271 | 3589271 | 2020-04-27 | Canada | Quebec | 26988 | 2318 | 0 | 24670 | 52.9399 | -73.5491 | 2020-04-28 02:30:53 | Quebec, Canada | ||
271611 | 271611 | 2020-04-28 | Canada | Quebec | 27908 | 2456 | 0 | 25452 | 52.9399 | -73.5491 | 2020-04-29 02:32:29 | Quebec, Canada | ||
137397 | 137397 | 2020-04-29 | Canada | Quebec | 28806 | 2607 | 0 | 26199 | 52.9399 | -73.5491 | 2020-04-30 02:32:27 | Quebec, Canada | ||
228650 | 228650 | 2020-04-30 | Canada | Quebec | 29809 | 2728 | 0 | 27081 | 52.9399 | -73.5491 | 2020-05-01 02:32:28 | Quebec, Canada | ||
1184169 | 1184169 | 2020-05-01 | Canada | Quebec | 30862 | 2866 | 0 | 27996 | 52.9399 | -73.5491 | 2020-05-02 02:32:27 | Quebec, Canada | ||
2043275 | 2043275 | 2020-05-02 | Canada | Quebec | 31761 | 2981 | 0 | 28780 | 52.9399 | -73.5491 | 2020-05-03 02:32:28 | Quebec, Canada | ||
2278599 | 2278599 | 2020-05-03 | Canada | Quebec | 32552 | 3080 | 0 | 29472 | 52.9399 | -73.5491 | 2020-05-04 02:32:28 | Quebec, Canada | ||
3084740 | 3084740 | 2020-05-04 | Canada | Quebec | 33417 | 3189 | 0 | 30228 | 52.9399 | -73.5491 | 2020-05-05 02:32:34 | Quebec, Canada | ||
1931877 | 1931877 | 2020-05-05 | Canada | Quebec | 34310 | 3290 | 0 | 31020 | 52.9399 | -73.5491 | 2020-05-06 02:32:31 | Quebec, Canada | ||
2110837 | 2110837 | 2020-05-06 | Canada | Quebec | 35343 | 3385 | 0 | 31958 | 52.9399 | -73.5491 | 2020-05-07 02:32:28 | Quebec, Canada | ||
3295616 | 3295616 | 2020-05-07 | Canada | Quebec | 36194 | 3478 | 0 | 32716 | 52.9399 | -73.5491 | 2020-05-08 02:32:32 | Quebec, Canada | ||
114173 | 114173 | 2020-05-08 | Canada | Quebec | 36972 | 3569 | 0 | 33403 | 52.9399 | -73.5491 | 2020-05-09 02:32:35 | Quebec, Canada | ||
2899124 | 2899124 | 2020-05-09 | Canada | Quebec | 37724 | 3668 | 0 | 34056 | 52.9399 | -73.5491 | 2020-05-10 02:32:30 | Quebec, Canada | ||
3459583 | 3459583 | 2020-05-10 | Canada | Quebec | 38377 | 3760 | 0 | 34617 | 52.9399 | -73.5491 | 2020-05-11 02:32:30 | Quebec, Canada | ||
3330968 | 3330968 | 2020-05-11 | Canada | Quebec | 39102 | 3855 | 0 | 35247 | 52.9399 | -73.5491 | 2020-05-12 03:32:27 | Quebec, Canada | ||
2581434 | 2581434 | 2020-05-12 | Canada | Quebec | 39899 | 3939 | 0 | 35960 | 52.9399 | -73.5491 | 2020-05-13 03:32:26 | Quebec, Canada | ||
3847227 | 3847227 | 2020-05-13 | Canada | Quebec | 40679 | 4006 | 0 | 36673 | 52.9399 | -73.5491 | 2020-05-14 03:32:28 | Quebec, Canada | ||
1404455 | 1404455 | 2020-05-14 | Canada | Quebec | 41379 | 4091 | 10829 | 26459 | 52.9399 | -73.5491 | 2020-05-15 02:33:02 | Quebec, Canada | ||
3276281 | 3276281 | 2020-05-15 | Canada | Quebec | 42161 | 4175 | 11039 | 26947 | 52.9399 | -73.5491 | 2020-05-16 02:32:19 | Quebec, Canada | ||
1829565 | 1829565 | 2020-05-16 | Canada | Quebec | 42857 | 4255 | 11458 | 27144 | 52.9399 | -73.5491 | 2020-05-17 02:32:32 | Quebec, Canada | ||
3416331 | 3416331 | 2020-05-17 | Canada | Quebec | 43588 | 4321 | 11754 | 27513 | 52.9399 | -73.5491 | 2020-05-18 02:32:21 | Quebec, Canada | ||
3260937 | 3260937 | 2020-05-18 | Canada | Quebec | 44258 | 4390 | 12045 | 27823 | 52.9399 | -73.5491 | 2020-05-19 02:32:18 | Quebec, Canada | ||
2390199 | 2390199 | 2020-05-19 | Canada | Quebec | 44896 | 4448 | 12497 | 27951 | 52.9399 | -73.5491 | 2020-05-20 02:32:19 | Quebec, Canada | ||
1431957 | 1431957 | 2020-05-20 | Canada | Quebec | 45697 | 4519 | 12822 | 28356 | 52.9399 | -73.5491 | 2020-05-21 02:32:48 | Quebec, Canada | ||
268374 | 268374 | 2020-05-21 | Canada | Quebec | 46412 | 4580 | 13327 | 28505 | 52.9399 | -73.5491 | 2020-05-22 02:36:51 | Quebec, Canada | ||
1864868 | 1864868 | 2020-05-22 | Canada | Quebec | 47017 | 4650 | 13819 | 28548 | 52.9399 | -73.5491 | 2020-05-23 02:32:42 | Quebec, Canada | ||
997845 | 997845 | 2020-05-23 | Canada | Quebec | 47519 | 4713 | 14044 | 28762 | 52.9399 | -73.5491 | 2020-05-24 02:32:43 | Quebec, Canada | ||
875654 | 875654 | 2020-05-24 | Canada | Quebec | 48063 | 4777 | 14331 | 28955 | 52.9399 | -73.5491 | 2020-05-25 02:32:44 | Quebec, Canada | ||
1104974 | 1104974 | 2020-05-25 | Canada | Quebec | 48571 | 4835 | 14654 | 29082 | 52.9399 | -73.5491 | 2020-05-26 02:32:35 | Quebec, Canada | ||
1041244 | 1041244 | 2020-05-26 | Canada | Quebec | 49019 | 4899 | 14999 | 29121 | 52.9399 | -73.5491 | 2020-05-27 02:32:31 | Quebec, Canada | ||
2548281 | 2548281 | 2020-05-27 | Canada | Quebec | 49539 | 4959 | 15319 | 29261 | 52.9399 | -73.5491 | 2020-05-28 02:32:31 | Quebec, Canada | ||
2712337 | 2712337 | 2020-05-28 | Canada | Quebec | 49954 | 5038 | 15618 | 29298 | 52.9399 | -73.5491 | 2020-05-29 02:32:50 | Quebec, Canada | ||
1790458 | 1790458 | 2020-05-29 | Canada | Quebec | 50377 | 5097 | 15908 | 29372 | 52.9399 | -73.5491 | 2020-05-30 02:32:48 | Quebec, Canada | ||
3638917 | 3638917 | 2020-05-30 | Canada | Quebec | 50775 | 5137 | 16070 | 29568 | 52.9399 | -73.5491 | 2020-05-31 02:32:45 | Quebec, Canada | ||
1794024 | 1794024 | 2020-05-31 | Canada | Quebec | 51068 | 5173 | 16346 | 29549 | 52.9399 | -73.5491 | 2020-06-01 02:32:46 | Quebec, Canada | ||
805454 | 805454 | 2020-06-01 | Canada | Quebec | 51396 | 5209 | 16597 | 29590 | 52.9399 | -73.5491 | 2020-06-02 02:33:08 | Quebec, Canada | ||
2555917 | 2555917 | 2020-06-02 | Canada | Quebec | 51624 | 5243 | 16803 | 29578 | 52.9399 | -73.5491 | 2020-06-03 02:33:13 | Quebec, Canada | ||
3866875 | 3866875 | 2020-06-03 | Canada | Quebec | 51901 | 5277 | 17098 | 29526 | 52.9399 | -73.5491 | 2020-06-04 02:33:14 | Quebec, Canada | ||
1281320 | 1281320 | 2020-06-04 | Canada | Quebec | 52157 | 5294 | 17336 | 29527 | 52.9399 | -73.5491 | 2020-06-05 02:33:06 | Quebec, Canada | ||
1269851 | 1269851 | 2020-06-05 | Canada | Quebec | 52400 | 5323 | 17764 | 29313 | 52.9399 | -73.5491 | 2020-06-06 02:33:00 | Quebec, Canada | ||
574154 | 574154 | 2020-06-06 | Canada | Quebec | 52646 | 5348 | 18412 | 28886 | 52.9399 | -73.5491 | 2020-06-07 03:53:30 | Quebec, Canada | ||
2800098 | 2800098 | 2020-06-07 | Canada | Quebec | 52835 | 5370 | 18714 | 28751 | 52.9399 | -73.5491 | 2020-06-08 03:33:22 | Quebec, Canada | ||
217302 | 217302 | 2020-06-08 | Canada | Quebec | 52953 | 5387 | 18994 | 28572 | 52.9399 | -73.5491 | 2020-06-09 03:33:03 | Quebec, Canada | ||
1210875 | 1210875 | 2020-06-09 | Canada | Quebec | 53118 | 5406 | 19361 | 28351 | 52.9399 | -73.5491 | 2020-06-10 04:07:00 | Quebec, Canada | ||
2864048 | 2864048 | 2020-06-10 | Canada | Quebec | 53290 | 5425 | 19841 | 28024 | 52.9399 | -73.5491 | 2020-06-11 03:33:41 | Quebec, Canada | ||
1273606 | 1273606 | 2020-06-11 | Canada | Quebec | 53444 | 5447 | 20299 | 27698 | 52.9399 | -73.5491 | 2020-06-12 05:09:52 | Quebec, Canada | ||
737636 | 737636 | 2020-06-12 | Canada | Quebec | 53619 | 5465 | 20823 | 27331 | 52.9399 | -73.5491 | 2020-06-13 03:33:14 | Quebec, Canada | ||
3061316 | 3061316 | 2020-06-13 | Canada | Quebec | 53740 | 5482 | 21281 | 26977 | 52.9399 | -73.5491 | 2020-06-14 03:33:15 | Quebec, Canada | ||
1837264 | 1837264 | 2020-06-14 | Canada | Quebec | 53834 | 5493 | 21742 | 26599 | 52.9399 | -73.5491 | 2020-06-15 03:33:14 | Quebec, Canada | ||
287313 | 287313 | 2020-06-15 | Canada | Quebec | 53946 | 5511 | 22213 | 26222 | 52.9399 | -73.5491 | 2020-06-16 04:33:09 | Quebec, Canada | ||
2386750 | 2386750 | 2020-06-16 | Canada | Quebec | 54080 | 5519 | 22350 | 26211 | 52.9399 | -73.5491 | 2020-06-17 04:33:21 | Quebec, 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]);