daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where province_or_state = "Quebec" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
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-14 | Canada | Quebec | 55 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-13T13:33:03 | ||||
2020-03-15 | Canada | Quebec | 68 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-15T01:53:02 | ||||
2020-03-16 | Canada | Quebec | 85 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-16T20:13:20 | ||||
2020-03-17 | Canada | Quebec | 128 | 1 | 0 | 52.9399 | -73.5491 | 2020-03-17T19:33:03 | ||||
2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
2020-03-19 | Canada | Quebec | 242 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-19T17:43:04 | ||||
2020-03-20 | Canada | Quebec | 371 | 4 | 0 | 52.9399 | -73.5491 | 2020-03-20T21:13:29 | ||||
2020-03-21 | Canada | Quebec | 557 | 5 | 0 | 52.9399 | -73.5491 | 2020-03-21T21:13:30 | ||||
2020-03-22 | Canada | Quebec | 795 | 5 | 0 | 790 | 52.9399 | -73.5491 | 3/22/20 23:48 | Quebec, Canada | ||
2020-03-23 | Canada | Quebec | 1140 | 8 | 0 | 1132 | 52.9399 | -73.5491 | 2020-03-23 23:23:10 | Quebec, Canada | ||
2020-03-24 | Canada | Quebec | 1408 | 11 | 0 | 1397 | 52.9399 | -73.5491 | 2020-03-24 23:41:36 | Quebec, Canada | ||
2020-03-25 | Canada | Quebec | 1774 | 18 | 0 | 1756 | 52.9399 | -73.5491 | 2020-03-25 23:37:36 | Quebec, Canada | ||
2020-03-26 | Canada | Quebec | 2140 | 27 | 0 | 2113 | 52.9399 | -73.5491 | 2020-03-26 23:53:11 | Quebec, Canada | ||
2020-03-27 | Canada | Quebec | 2591 | 30 | 0 | 2561 | 52.9399 | -73.5491 | 2020-03-27 23:27:32 | Quebec, Canada | ||
2020-03-28 | Canada | Quebec | 3007 | 43 | 0 | 2964 | 52.9399 | -73.5491 | 3/28/20 23:10 | Quebec, Canada | ||
2020-03-29 | Canada | Quebec | 3575 | 54 | 0 | 3521 | 52.9399 | -73.5491 | 3/29/20 23:13 | Quebec, Canada | ||
2020-03-30 | Canada | Quebec | 4153 | 67 | 0 | 4086 | 52.9399 | -73.5491 | 3/30/20 22:58 | Quebec, Canada | ||
2020-03-31 | Canada | Quebec | 4881 | 82 | 0 | 4799 | 52.9399 | -73.5491 | 2020-03-31 23:49:13 | Quebec, Canada | ||
2020-04-01 | Canada | Quebec | 5578 | 99 | 0 | 5479 | 52.9399 | -73.5491 | 2020-04-01 22:04:44 | Quebec, Canada | ||
2020-04-02 | Canada | Quebec | 6453 | 121 | 0 | 6332 | 52.9399 | -73.5491 | 4/2/20 23:31 | Quebec, Canada | ||
2020-04-03 | Canada | Quebec | 7223 | 159 | 0 | 7064 | 52.9399 | -73.5491 | 2020-04-03 22:52:30 | Quebec, Canada | ||
2020-04-04 | Canada | Quebec | 8029 | 203 | 0 | 7826 | 52.9399 | -73.5491 | 4/4/20 23:40 | Quebec, Canada | ||
2020-04-05 | Canada | Quebec | 8663 | 251 | 0 | 8412 | 52.9399 | -73.5491 | 2020-04-05 23:13:28 | Quebec, Canada | ||
2020-04-06 | Canada | Quebec | 9538 | 302 | 0 | 9236 | 52.9399 | -73.5491 | 4/6/20 23:28 | Quebec, Canada | ||
2020-04-07 | Canada | Quebec | 10326 | 356 | 0 | 9970 | 52.9399 | -73.5491 | 2020-04-07 23:11:15 | Quebec, Canada | ||
2020-04-08 | Canada | Quebec | 11012 | 416 | 0 | 10596 | 52.9399 | -73.5491 | 2020-04-08 22:58:44 | Quebec, Canada | ||
2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
2020-04-10 | Canada | Quebec | 12395 | 551 | 0 | 11844 | 52.9399 | -73.5491 | 2020-04-10 23:01:26 | Quebec, Canada | ||
2020-04-11 | Canada | Quebec | 13060 | 621 | 0 | 12439 | 52.9399 | -73.5491 | 2020-04-11 22:52:28 | Quebec, Canada | ||
2020-04-12 | Canada | Quebec | 13850 | 709 | 0 | 13141 | 52.9399 | -73.5491 | 2020-04-12 23:24:00 | Quebec, Canada | ||
2020-04-13 | Canada | Quebec | 14814 | 804 | 0 | 14010 | 52.9399 | -73.5491 | 2020-04-13 23:15:25 | Quebec, Canada | ||
2020-04-14 | Canada | Quebec | 15776 | 895 | 0 | 14881 | 52.9399 | -73.5491 | 2020-04-14 23:40:54 | Quebec, Canada | ||
2020-04-15 | Canada | Quebec | 16874 | 994 | 0 | 15880 | 52.9399 | -73.5491 | 2020-04-15 23:04:09 | Quebec, Canada | ||
2020-04-16 | Canada | Quebec | 17838 | 1089 | 0 | 16749 | 52.9399 | -73.5491 | 2020-04-16 23:38:03 | Quebec, Canada | ||
2020-04-17 | Canada | Quebec | 18860 | 1176 | 0 | 17684 | 52.9399 | -73.5491 | 2020-04-17 23:38:31 | Quebec, Canada | ||
2020-04-18 | Canada | Quebec | 19523 | 1274 | 0 | 18249 | 52.9399 | -73.5491 | 2020-04-18 22:40:03 | Quebec, Canada | ||
2020-04-19 | Canada | Quebec | 20343 | 1400 | 0 | 18943 | 52.9399 | -73.5491 | 2020-04-19 23:48:49 | Quebec, Canada | ||
2020-04-20 | Canada | Quebec | 21252 | 1503 | 0 | 19749 | 52.9399 | -73.5491 | 2020-04-20 23:44:34 | Quebec, Canada | ||
2020-04-21 | Canada | Quebec | 22058 | 1618 | 0 | 20440 | 52.9399 | -73.5491 | 2020-04-21 23:38:53 | Quebec, Canada | ||
2020-04-22 | Canada | Quebec | 22943 | 1735 | 0 | 21208 | 52.9399 | -73.5491 | 2020-04-22 23:38:42 | Quebec, Canada | ||
2020-04-23 | Canada | Quebec | 23849 | 1852 | 0 | 21997 | 52.9399 | -73.5491 | 2020-04-24 03:31:19 | Quebec, Canada | ||
2020-04-24 | Canada | Quebec | 24704 | 1968 | 0 | 22736 | 52.9399 | -73.5491 | 2020-04-25 06:30:55 | Quebec, Canada | ||
2020-04-25 | Canada | Quebec | 25466 | 2092 | 0 | 23374 | 52.9399 | -73.5491 | 2020-04-26 02:30:54 | Quebec, Canada | ||
2020-04-26 | Canada | Quebec | 26078 | 2203 | 0 | 23875 | 52.9399 | -73.5491 | 2020-04-27 02:30:55 | Quebec, Canada | ||
2020-04-27 | Canada | Quebec | 26988 | 2318 | 0 | 24670 | 52.9399 | -73.5491 | 2020-04-28 02:30:53 | Quebec, Canada | ||
2020-04-28 | Canada | Quebec | 27908 | 2456 | 0 | 25452 | 52.9399 | -73.5491 | 2020-04-29 02:32:29 | Quebec, Canada | ||
2020-04-29 | Canada | Quebec | 28806 | 2607 | 0 | 26199 | 52.9399 | -73.5491 | 2020-04-30 02:32:27 | Quebec, Canada | ||
2020-04-30 | Canada | Quebec | 29809 | 2728 | 0 | 27081 | 52.9399 | -73.5491 | 2020-05-01 02:32:28 | Quebec, Canada | ||
2020-05-01 | Canada | Quebec | 30862 | 2866 | 0 | 27996 | 52.9399 | -73.5491 | 2020-05-02 02:32:27 | Quebec, Canada | ||
2020-05-02 | Canada | Quebec | 31761 | 2981 | 0 | 28780 | 52.9399 | -73.5491 | 2020-05-03 02:32:28 | Quebec, Canada | ||
2020-05-03 | Canada | Quebec | 32552 | 3080 | 0 | 29472 | 52.9399 | -73.5491 | 2020-05-04 02:32:28 | Quebec, Canada | ||
2020-05-04 | Canada | Quebec | 33417 | 3189 | 0 | 30228 | 52.9399 | -73.5491 | 2020-05-05 02:32:34 | Quebec, Canada | ||
2020-05-05 | Canada | Quebec | 34310 | 3290 | 0 | 31020 | 52.9399 | -73.5491 | 2020-05-06 02:32:31 | Quebec, Canada | ||
2020-05-06 | Canada | Quebec | 35343 | 3385 | 0 | 31958 | 52.9399 | -73.5491 | 2020-05-07 02:32:28 | Quebec, Canada | ||
2020-05-07 | Canada | Quebec | 36194 | 3478 | 0 | 32716 | 52.9399 | -73.5491 | 2020-05-08 02:32:32 | Quebec, Canada | ||
2020-05-08 | Canada | Quebec | 36972 | 3569 | 0 | 33403 | 52.9399 | -73.5491 | 2020-05-09 02:32:35 | Quebec, Canada | ||
2020-05-09 | Canada | Quebec | 37724 | 3668 | 0 | 34056 | 52.9399 | -73.5491 | 2020-05-10 02:32:30 | Quebec, Canada | ||
2020-05-10 | Canada | Quebec | 38377 | 3760 | 0 | 34617 | 52.9399 | -73.5491 | 2020-05-11 02:32:30 | Quebec, Canada | ||
2020-05-11 | Canada | Quebec | 39102 | 3855 | 0 | 35247 | 52.9399 | -73.5491 | 2020-05-12 03:32:27 | Quebec, Canada | ||
2020-05-12 | Canada | Quebec | 39899 | 3939 | 0 | 35960 | 52.9399 | -73.5491 | 2020-05-13 03:32:26 | Quebec, Canada | ||
2020-05-13 | Canada | Quebec | 40679 | 4006 | 0 | 36673 | 52.9399 | -73.5491 | 2020-05-14 03:32:28 | Quebec, Canada | ||
2020-05-14 | Canada | Quebec | 41379 | 4091 | 10829 | 26459 | 52.9399 | -73.5491 | 2020-05-15 02:33:02 | Quebec, Canada | ||
2020-05-15 | Canada | Quebec | 42161 | 4175 | 11039 | 26947 | 52.9399 | -73.5491 | 2020-05-16 02:32:19 | Quebec, Canada | ||
2020-05-16 | Canada | Quebec | 42857 | 4255 | 11458 | 27144 | 52.9399 | -73.5491 | 2020-05-17 02:32:32 | Quebec, Canada | ||
2020-05-17 | Canada | Quebec | 43588 | 4321 | 11754 | 27513 | 52.9399 | -73.5491 | 2020-05-18 02:32:21 | Quebec, Canada | ||
2020-05-18 | Canada | Quebec | 44258 | 4390 | 12045 | 27823 | 52.9399 | -73.5491 | 2020-05-19 02:32:18 | Quebec, Canada | ||
2020-05-19 | Canada | Quebec | 44896 | 4448 | 12497 | 27951 | 52.9399 | -73.5491 | 2020-05-20 02:32:19 | Quebec, Canada | ||
2020-05-20 | Canada | Quebec | 45697 | 4519 | 12822 | 28356 | 52.9399 | -73.5491 | 2020-05-21 02:32:48 | Quebec, Canada | ||
2020-05-21 | Canada | Quebec | 46412 | 4580 | 13327 | 28505 | 52.9399 | -73.5491 | 2020-05-22 02:36:51 | Quebec, Canada | ||
2020-05-22 | Canada | Quebec | 47017 | 4650 | 13819 | 28548 | 52.9399 | -73.5491 | 2020-05-23 02:32:42 | Quebec, Canada | ||
2020-05-23 | Canada | Quebec | 47519 | 4713 | 14044 | 28762 | 52.9399 | -73.5491 | 2020-05-24 02:32:43 | Quebec, Canada | ||
2020-05-24 | Canada | Quebec | 48063 | 4777 | 14331 | 28955 | 52.9399 | -73.5491 | 2020-05-25 02:32:44 | Quebec, Canada | ||
2020-05-25 | Canada | Quebec | 48571 | 4835 | 14654 | 29082 | 52.9399 | -73.5491 | 2020-05-26 02:32:35 | Quebec, Canada | ||
2020-05-26 | Canada | Quebec | 49019 | 4899 | 14999 | 29121 | 52.9399 | -73.5491 | 2020-05-27 02:32:31 | Quebec, Canada | ||
2020-05-27 | Canada | Quebec | 49539 | 4959 | 15319 | 29261 | 52.9399 | -73.5491 | 2020-05-28 02:32:31 | Quebec, Canada | ||
2020-05-28 | Canada | Quebec | 49954 | 5038 | 15618 | 29298 | 52.9399 | -73.5491 | 2020-05-29 02:32:50 | Quebec, Canada | ||
2020-05-29 | Canada | Quebec | 50377 | 5097 | 15908 | 29372 | 52.9399 | -73.5491 | 2020-05-30 02:32:48 | Quebec, Canada | ||
2020-05-30 | Canada | Quebec | 50775 | 5137 | 16070 | 29568 | 52.9399 | -73.5491 | 2020-05-31 02:32:45 | Quebec, Canada | ||
2020-05-31 | Canada | Quebec | 51068 | 5173 | 16346 | 29549 | 52.9399 | -73.5491 | 2020-06-01 02:32:46 | Quebec, Canada | ||
2020-06-01 | Canada | Quebec | 51396 | 5209 | 16597 | 29590 | 52.9399 | -73.5491 | 2020-06-02 02:33:08 | Quebec, Canada | ||
2020-06-02 | Canada | Quebec | 51624 | 5243 | 16803 | 29578 | 52.9399 | -73.5491 | 2020-06-03 02:33:13 | Quebec, Canada | ||
2020-06-03 | Canada | Quebec | 51901 | 5277 | 17098 | 29526 | 52.9399 | -73.5491 | 2020-06-04 02:33:14 | Quebec, Canada | ||
2020-06-04 | Canada | Quebec | 52157 | 5294 | 17336 | 29527 | 52.9399 | -73.5491 | 2020-06-05 02:33:06 | Quebec, Canada | ||
2020-06-05 | Canada | Quebec | 52400 | 5323 | 17764 | 29313 | 52.9399 | -73.5491 | 2020-06-06 02:33:00 | Quebec, Canada | ||
2020-06-06 | Canada | Quebec | 52646 | 5348 | 18412 | 28886 | 52.9399 | -73.5491 | 2020-06-07 03:53:30 | Quebec, Canada | ||
2020-06-07 | Canada | Quebec | 52835 | 5370 | 18714 | 28751 | 52.9399 | -73.5491 | 2020-06-08 03:33:22 | Quebec, Canada | ||
2020-06-08 | Canada | Quebec | 52953 | 5387 | 18994 | 28572 | 52.9399 | -73.5491 | 2020-06-09 03:33:03 | Quebec, Canada | ||
2020-06-09 | Canada | Quebec | 53118 | 5406 | 19361 | 28351 | 52.9399 | -73.5491 | 2020-06-10 04:07:00 | Quebec, Canada | ||
2020-06-10 | Canada | Quebec | 53290 | 5425 | 19841 | 28024 | 52.9399 | -73.5491 | 2020-06-11 03:33:41 | Quebec, Canada | ||
2020-06-11 | Canada | Quebec | 53444 | 5447 | 20299 | 27698 | 52.9399 | -73.5491 | 2020-06-12 05:09:52 | Quebec, Canada | ||
2020-06-12 | Canada | Quebec | 53619 | 5465 | 20823 | 27331 | 52.9399 | -73.5491 | 2020-06-13 03:33:14 | Quebec, Canada | ||
2020-06-13 | Canada | Quebec | 53740 | 5482 | 21281 | 26977 | 52.9399 | -73.5491 | 2020-06-14 03:33:15 | Quebec, Canada | ||
2020-06-14 | Canada | Quebec | 53834 | 5493 | 21742 | 26599 | 52.9399 | -73.5491 | 2020-06-15 03:33:14 | Quebec, Canada | ||
2020-06-15 | Canada | Quebec | 53946 | 5511 | 22213 | 26222 | 52.9399 | -73.5491 | 2020-06-16 04:33:09 | Quebec, Canada | ||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;