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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-12-02 10
- 2022-04-13 4
- 2022-05-26 4
- 2020-03-11 3
- 2020-03-16 3
- 2020-03-14 2
- 2020-03-18 2
- 2020-03-19 2
- 2020-03-20 2
- 2020-03-21 2
- 2020-03-23 2
- 2020-03-24 2
- 2020-03-25 2
- 2020-03-26 2
- 2020-03-27 2
- 2020-03-31 2
- 2020-04-01 2
- 2020-04-03 2
- 2020-04-05 2
- 2020-04-07 2
- 2020-04-08 2
- 2020-04-09 2
- 2020-04-10 2
- 2020-04-11 2
- 2020-04-12 2
- 2020-04-13 2
- 2020-04-14 2
- 2020-04-15 2
- 2020-04-16 2
- 2020-04-17 2
- …
day (date) >30 ✖
- 2020-03-13 2
- 2020-03-14 2
- 2020-03-15 2
- 2020-03-16 2
- 2020-03-17 2
- 2020-03-18 2
- 2020-03-19 2
- 2020-03-20 2
- 2020-03-21 2
- 2020-03-22 2
- 2020-03-23 2
- 2020-03-24 2
- 2020-03-25 2
- 2020-03-26 2
- 2020-03-27 2
- 2020-03-28 2
- 2020-03-29 2
- 2020-03-30 2
- 2020-03-31 2
- 2020-04-01 2
- 2020-04-02 2
- 2020-04-03 2
- 2020-04-04 2
- 2020-04-05 2
- 2020-04-06 2
- 2020-04-07 2
- 2020-04-08 2
- 2020-04-09 2
- 2020-04-10 2
- 2020-04-11 2
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752663 | 2752663 | 2022-12-29 | Canada | Quebec | 1282260 | 17670 | 0 | 52.9399 | -73.5491 | 2022-12-30 04:21:04 | Quebec, Canada | |||
2752665 | 2752665 | 2022-12-29 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-30 04:21:04 | Saskatchewan, Canada | |||
1073669 | 1073669 | 2022-12-28 | Canada | Quebec | 1281152 | 17644 | 0 | 52.9399 | -73.5491 | 2022-12-29 04:21:01 | Quebec, Canada | |||
1073671 | 1073671 | 2022-12-28 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-29 04:21:01 | Saskatchewan, Canada | |||
327666 | 327666 | 2022-12-27 | Canada | Quebec | 1280200 | 17628 | 0 | 52.9399 | -73.5491 | 2022-12-28 04:21:04 | Quebec, Canada | |||
327668 | 327668 | 2022-12-27 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-28 04:21:04 | Saskatchewan, Canada | |||
217739 | 217739 | 2022-12-26 | Canada | Quebec | 1279432 | 17626 | 0 | 52.9399 | -73.5491 | 2022-12-27 04:21:07 | Quebec, Canada | |||
217741 | 217741 | 2022-12-26 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-27 04:21:07 | Saskatchewan, Canada | |||
3222196 | 3222196 | 2022-12-25 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-26 04:21:06 | Quebec, Canada | |||
3222198 | 3222198 | 2022-12-25 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-26 04:21:06 | Saskatchewan, Canada | |||
1018110 | 1018110 | 2022-12-24 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-25 04:21:04 | Quebec, Canada | |||
1018112 | 1018112 | 2022-12-24 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-25 04:21:04 | Saskatchewan, Canada | |||
690133 | 690133 | 2022-12-23 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-24 04:21:02 | Quebec, Canada | |||
690135 | 690135 | 2022-12-23 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-24 04:21:02 | Saskatchewan, Canada | |||
2179343 | 2179343 | 2022-12-22 | Canada | Quebec | 1276752 | 17593 | 0 | 52.9399 | -73.5491 | 2022-12-23 04:21:04 | Quebec, Canada | |||
2179345 | 2179345 | 2022-12-22 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-23 04:21:04 | Saskatchewan, Canada | |||
451147 | 451147 | 2022-12-21 | Canada | Quebec | 1275579 | 17586 | 0 | 52.9399 | -73.5491 | 2022-12-22 04:20:56 | Quebec, Canada | |||
451149 | 451149 | 2022-12-21 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-22 04:20:56 | Saskatchewan, Canada | |||
2951146 | 2951146 | 2022-12-20 | Canada | Quebec | 1274140 | 17570 | 0 | 52.9399 | -73.5491 | 2022-12-21 04:21:03 | Quebec, Canada | |||
2951148 | 2951148 | 2022-12-20 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-21 04:21:03 | Saskatchewan, Canada | |||
3173548 | 3173548 | 2022-12-19 | Canada | Quebec | 1272878 | 17542 | 0 | 52.9399 | -73.5491 | 2022-12-20 04:21:04 | Quebec, Canada | |||
3173550 | 3173550 | 2022-12-19 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-20 04:21:04 | Saskatchewan, Canada | |||
1628065 | 1628065 | 2022-12-18 | Canada | Quebec | 1272029 | 17540 | 0 | 52.9399 | -73.5491 | 2022-12-19 04:21:03 | Quebec, Canada | |||
1628067 | 1628067 | 2022-12-18 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-19 04:21:03 | Saskatchewan, Canada | |||
503444 | 503444 | 2022-12-17 | Canada | Quebec | 1271168 | 17537 | 0 | 52.9399 | -73.5491 | 2022-12-18 04:21:03 | Quebec, Canada | |||
503446 | 503446 | 2022-12-17 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-18 04:21:03 | Saskatchewan, Canada | |||
3324016 | 3324016 | 2022-12-16 | Canada | Quebec | 1270133 | 17533 | 0 | 52.9399 | -73.5491 | 2022-12-17 04:21:04 | Quebec, Canada | |||
3324018 | 3324018 | 2022-12-16 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-17 04:21:04 | Saskatchewan, Canada | |||
542528 | 542528 | 2022-12-15 | Canada | Quebec | 1268912 | 17514 | 0 | 52.9399 | -73.5491 | 2022-12-16 04:21:01 | Quebec, Canada | |||
542530 | 542530 | 2022-12-15 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-16 04:21:01 | Saskatchewan, Canada | |||
348056 | 348056 | 2022-12-14 | Canada | Quebec | 1267561 | 17497 | 0 | 52.9399 | -73.5491 | 2022-12-15 04:20:58 | Quebec, Canada | |||
348058 | 348058 | 2022-12-14 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-15 04:20:58 | Saskatchewan, Canada | |||
307644 | 307644 | 2022-12-13 | Canada | Quebec | 1266261 | 17485 | 0 | 52.9399 | -73.5491 | 2022-12-14 04:21:04 | Quebec, Canada | |||
307646 | 307646 | 2022-12-13 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-14 04:21:04 | Saskatchewan, Canada | |||
1148705 | 1148705 | 2022-12-12 | Canada | Quebec | 1265044 | 17463 | 0 | 52.9399 | -73.5491 | 2022-12-13 04:21:01 | Quebec, Canada | |||
1148707 | 1148707 | 2022-12-12 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-13 04:21:01 | Saskatchewan, Canada | |||
868559 | 868559 | 2022-12-11 | Canada | Quebec | 1264296 | 17462 | 0 | 52.9399 | -73.5491 | 2022-12-12 04:21:01 | Quebec, Canada | |||
868561 | 868561 | 2022-12-11 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-12 04:21:01 | Saskatchewan, Canada | |||
257089 | 257089 | 2022-12-10 | Canada | Quebec | 1263490 | 17461 | 0 | 52.9399 | -73.5491 | 2022-12-11 04:20:50 | Quebec, Canada | |||
257091 | 257091 | 2022-12-10 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-11 04:20:50 | Saskatchewan, Canada | |||
3935803 | 3935803 | 2022-12-09 | Canada | Quebec | 1262542 | 17442 | 0 | 52.9399 | -73.5491 | 2022-12-10 04:21:02 | Quebec, Canada | |||
3935805 | 3935805 | 2022-12-09 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-10 04:21:02 | Saskatchewan, Canada | |||
3377135 | 3377135 | 2022-12-08 | Canada | Quebec | 1261462 | 17426 | 0 | 52.9399 | -73.5491 | 2022-12-09 04:21:05 | Quebec, Canada | |||
3377137 | 3377137 | 2022-12-08 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-09 04:21:05 | Saskatchewan, Canada | |||
1984406 | 1984406 | 2022-12-07 | Canada | Quebec | 1260221 | 17415 | 0 | 52.9399 | -73.5491 | 2022-12-08 04:21:07 | Quebec, Canada | |||
1984408 | 1984408 | 2022-12-07 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-08 04:21:07 | Saskatchewan, Canada | |||
3713929 | 3713929 | 2022-12-06 | Canada | Quebec | 1258503 | 17409 | 0 | 52.9399 | -73.5491 | 2022-12-07 04:20:58 | Quebec, Canada | |||
3713931 | 3713931 | 2022-12-06 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-07 04:20:58 | Saskatchewan, Canada | |||
2414634 | 2414634 | 2022-12-05 | Canada | Quebec | 1258503 | 17409 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2414636 | 2414636 | 2022-12-05 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
718242 | 718242 | 2022-12-04 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
718244 | 718244 | 2022-12-04 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2816531 | 2816531 | 2022-12-03 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2816533 | 2816533 | 2022-12-03 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
833387 | 833387 | 2022-12-02 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
833389 | 833389 | 2022-12-02 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
2135917 | 2135917 | 2022-12-01 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 04:21:07 | Quebec, Canada | |||
2135919 | 2135919 | 2022-12-01 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 04:21:07 | Saskatchewan, Canada | |||
1964333 | 1964333 | 2022-11-30 | Canada | Quebec | 1248200 | 17354 | 0 | 52.9399 | -73.5491 | 2022-12-01 04:21:03 | Quebec, Canada | |||
1964335 | 1964335 | 2022-11-30 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-01 04:21:03 | Saskatchewan, Canada | |||
2556347 | 2556347 | 2022-11-29 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-30 04:21:07 | Quebec, Canada | |||
2556349 | 2556349 | 2022-11-29 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-11-30 04:21:07 | Saskatchewan, Canada | |||
1239421 | 1239421 | 2022-11-28 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-29 04:21:05 | Quebec, Canada | |||
1239423 | 1239423 | 2022-11-28 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-11-29 04:21:05 | Saskatchewan, Canada | |||
3551409 | 3551409 | 2022-11-27 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-28 04:21:02 | Quebec, Canada | |||
3551411 | 3551411 | 2022-11-27 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-28 04:21:02 | Saskatchewan, Canada | |||
2099889 | 2099889 | 2022-11-26 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-27 04:21:05 | Quebec, Canada | |||
2099891 | 2099891 | 2022-11-26 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-27 04:21:05 | Saskatchewan, Canada | |||
487380 | 487380 | 2022-11-25 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-26 04:21:11 | Quebec, Canada | |||
487382 | 487382 | 2022-11-25 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-26 04:21:11 | Saskatchewan, Canada | |||
3523209 | 3523209 | 2022-11-24 | Canada | Quebec | 1247245 | 17302 | 0 | 52.9399 | -73.5491 | 2022-11-25 04:21:06 | Quebec, Canada | |||
3523211 | 3523211 | 2022-11-24 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-25 04:21:06 | Saskatchewan, Canada | |||
3311992 | 3311992 | 2022-11-23 | Canada | Quebec | 1246205 | 17292 | 0 | 52.9399 | -73.5491 | 2022-11-24 04:21:09 | Quebec, Canada | |||
3311994 | 3311994 | 2022-11-23 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-24 04:21:09 | Saskatchewan, Canada | |||
1620033 | 1620033 | 2022-11-22 | Canada | Quebec | 1244873 | 17290 | 0 | 52.9399 | -73.5491 | 2022-11-23 04:21:06 | Quebec, Canada | |||
1620035 | 1620035 | 2022-11-22 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-23 04:21:06 | Saskatchewan, Canada | |||
3459921 | 3459921 | 2022-11-21 | Canada | Quebec | 1243933 | 17272 | 0 | 52.9399 | -73.5491 | 2022-11-22 04:20:47 | Quebec, Canada | |||
3459923 | 3459923 | 2022-11-21 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-22 04:20:47 | Saskatchewan, Canada | |||
1640106 | 1640106 | 2022-11-20 | Canada | Quebec | 1243392 | 17270 | 0 | 52.9399 | -73.5491 | 2022-11-21 04:21:05 | Quebec, Canada | |||
1640108 | 1640108 | 2022-11-20 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-21 04:21:05 | Saskatchewan, Canada | |||
2063663 | 2063663 | 2022-11-19 | Canada | Quebec | 1242808 | 17270 | 0 | 52.9399 | -73.5491 | 2022-11-20 04:21:08 | Quebec, Canada | |||
2063665 | 2063665 | 2022-11-19 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-20 04:21:08 | Saskatchewan, Canada | |||
1755057 | 1755057 | 2022-11-18 | Canada | Quebec | 1242143 | 17264 | 0 | 52.9399 | -73.5491 | 2022-11-19 04:21:14 | Quebec, Canada | |||
1755059 | 1755059 | 2022-11-18 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-19 04:21:14 | Saskatchewan, Canada | |||
3026050 | 3026050 | 2022-11-17 | Canada | Quebec | 1241406 | 17253 | 0 | 52.9399 | -73.5491 | 2022-11-18 04:21:15 | Quebec, Canada | |||
3026052 | 3026052 | 2022-11-17 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-18 04:21:15 | Saskatchewan, Canada | |||
2485761 | 2485761 | 2022-11-16 | Canada | Quebec | 1240569 | 17244 | 0 | 52.9399 | -73.5491 | 2022-11-17 04:21:11 | Quebec, Canada | |||
2485763 | 2485763 | 2022-11-16 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-17 04:21:11 | Saskatchewan, Canada | |||
291772 | 291772 | 2022-11-15 | Canada | Quebec | 1239532 | 17190 | 0 | 52.9399 | -73.5491 | 2022-11-16 04:21:09 | Quebec, Canada | |||
291774 | 291774 | 2022-11-15 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-16 04:21:09 | Saskatchewan, Canada | |||
3596802 | 3596802 | 2022-11-14 | Canada | Quebec | 1238739 | 17178 | 0 | 52.9399 | -73.5491 | 2022-11-15 04:21:16 | Quebec, Canada | |||
3596804 | 3596804 | 2022-11-14 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-15 04:21:16 | Saskatchewan, Canada | |||
311660 | 311660 | 2022-11-13 | Canada | Quebec | 1238219 | 17176 | 0 | 52.9399 | -73.5491 | 2022-11-14 04:21:09 | Quebec, Canada | |||
311662 | 311662 | 2022-11-13 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-14 04:21:09 | Saskatchewan, Canada | |||
62821 | 62821 | 2022-11-12 | Canada | Quebec | 1237705 | 17175 | 0 | 52.9399 | -73.5491 | 2022-11-13 04:21:14 | Quebec, Canada | |||
62823 | 62823 | 2022-11-12 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-13 04:21:14 | Saskatchewan, Canada | |||
2926983 | 2926983 | 2022-11-11 | Canada | Quebec | 1237025 | 17166 | 0 | 52.9399 | -73.5491 | 2022-11-12 04:20:41 | Quebec, Canada | |||
2926985 | 2926985 | 2022-11-11 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-12 04:20:41 | Saskatchewan, Canada | |||
2505819 | 2505819 | 2022-11-10 | Canada | Quebec | 1236286 | 17152 | 0 | 52.9399 | -73.5491 | 2022-11-11 04:21:22 | Quebec, Canada | |||
2505821 | 2505821 | 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 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]);