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 = "Alberta" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-12-02 5
- 2020-03-11 3
- 2020-03-09 2
- 2022-04-13 2
- 2022-05-26 2
- 2020-03-14 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
- 2020-04-13 1
- 2020-04-14 1
- …
province_or_state 1
- Alberta · 1,026 ✖
country_or_region 1
- Canada · 1,026 ✖
combined_key 1 ✖
- Alberta, Canada 1,013
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657790 | 657790 | 2020-03-09 | Canada | Alberta | 7 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-09T17:53:24 | ||||
3752929 | 3752929 | 2020-03-10 | Canada | Alberta | 7 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-09T17:53:24 | ||||
3765432 | 3765432 | 2020-03-13 | Canada | Alberta | 29 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T20:00:00 | ||||
2127525 | 2127525 | 2020-03-11 | Canada | Alberta | 19 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T23:13:07 | ||||
2282960 | 2282960 | 2020-03-12 | Canada | Alberta | 19 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T23:13:07 | ||||
2111198 | 2111198 | 2020-03-14 | Canada | Alberta | 29 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-14T00:13:05 | ||||
1463570 | 1463570 | 2020-03-15 | Canada | Alberta | 39 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-15T01:53:03 | ||||
2255212 | 2255212 | 2020-03-16 | Canada | Alberta | 56 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-16T02:33:09 | ||||
3891403 | 3891403 | 2020-03-17 | Canada | Alberta | 74 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-17T03:13:18 | ||||
1176969 | 1176969 | 2020-03-18 | Canada | Alberta | 97 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-18T03:33:03 | ||||
1526970 | 1526970 | 2020-03-19 | Canada | Alberta | 119 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-19T03:13:26 | ||||
3734013 | 3734013 | 2020-03-20 | Canada | Alberta | 146 | 1 | 0 | 53.9333 | -116.5765 | 2020-03-20T03:13:18 | ||||
339714 | 339714 | 2020-03-21 | Canada | Alberta | 195 | 1 | 0 | 53.9333 | -116.5765 | 2020-03-21T02:43:03 | ||||
2147030 | 2147030 | 2020-03-23 | Canada | Alberta | 301 | 1 | 0 | 300 | 53.9333 | -116.5765 | 2020-03-23 23:23:10 | Alberta, Canada | ||
1478972 | 1478972 | 2020-03-24 | Canada | Alberta | 359 | 1 | 0 | 358 | 53.9333 | -116.5765 | 2020-03-24 23:41:36 | Alberta, Canada | ||
1132464 | 1132464 | 2020-03-25 | Canada | Alberta | 358 | 2 | 0 | 356 | 53.9333 | -116.5765 | 2020-03-25 23:37:36 | Alberta, Canada | ||
919061 | 919061 | 2020-03-26 | Canada | Alberta | 486 | 2 | 0 | 484 | 53.9333 | -116.5765 | 2020-03-26 23:53:11 | Alberta, Canada | ||
808968 | 808968 | 2020-03-27 | Canada | Alberta | 542 | 2 | 0 | 540 | 53.9333 | -116.5765 | 2020-03-27 23:27:32 | Alberta, Canada | ||
3815792 | 3815792 | 2020-03-31 | Canada | Alberta | 690 | 8 | 0 | 682 | 53.9333 | -116.5765 | 2020-03-31 23:49:13 | Alberta, Canada | ||
3364699 | 3364699 | 2020-04-01 | Canada | Alberta | 754 | 9 | 0 | 745 | 53.9333 | -116.5765 | 2020-04-01 22:04:44 | Alberta, Canada | ||
3740464 | 3740464 | 2020-04-03 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 2020-04-03 22:52:30 | Alberta, Canada | ||
589008 | 589008 | 2020-04-05 | Canada | Alberta | 1181 | 20 | 0 | 1161 | 53.9333 | -116.5765 | 2020-04-05 23:13:28 | Alberta, Canada | ||
3021638 | 3021638 | 2020-04-07 | Canada | Alberta | 1373 | 24 | 0 | 1349 | 53.9333 | -116.5765 | 2020-04-07 23:11:15 | Alberta, Canada | ||
3561963 | 3561963 | 2020-04-08 | Canada | Alberta | 1373 | 26 | 0 | 1347 | 53.9333 | -116.5765 | 2020-04-08 22:58:44 | Alberta, Canada | ||
3949856 | 3949856 | 2020-04-09 | Canada | Alberta | 1423 | 29 | 0 | 1394 | 53.9333 | -116.5765 | 2020-04-09 23:09:01 | Alberta, Canada | ||
1250119 | 1250119 | 2020-04-10 | Canada | Alberta | 1451 | 32 | 0 | 1419 | 53.9333 | -116.5765 | 2020-04-10 23:01:26 | Alberta, Canada | ||
2566934 | 2566934 | 2020-04-11 | Canada | Alberta | 1567 | 40 | 0 | 1527 | 53.9333 | -116.5765 | 2020-04-11 22:52:28 | Alberta, Canada | ||
2578098 | 2578098 | 2020-04-12 | Canada | Alberta | 1567 | 40 | 0 | 1527 | 53.9333 | -116.5765 | 2020-04-12 23:24:00 | Alberta, Canada | ||
43072 | 43072 | 2020-04-13 | Canada | Alberta | 1732 | 46 | 0 | 1686 | 53.9333 | -116.5765 | 2020-04-13 23:15:25 | Alberta, Canada | ||
3337975 | 3337975 | 2020-04-14 | Canada | Alberta | 1870 | 48 | 0 | 1822 | 53.9333 | -116.5765 | 2020-04-14 23:40:54 | Alberta, Canada | ||
860059 | 860059 | 2020-04-15 | Canada | Alberta | 1870 | 48 | 0 | 1822 | 53.9333 | -116.5765 | 2020-04-15 23:04:09 | Alberta, Canada | ||
934165 | 934165 | 2020-04-16 | Canada | Alberta | 1996 | 48 | 0 | 1948 | 53.9333 | -116.5765 | 2020-04-16 23:38:03 | Alberta, Canada | ||
50171 | 50171 | 2020-04-17 | Canada | Alberta | 2397 | 50 | 0 | 2347 | 53.9333 | -116.5765 | 2020-04-17 23:38:31 | Alberta, Canada | ||
418699 | 418699 | 2020-04-18 | Canada | Alberta | 2562 | 51 | 0 | 2511 | 53.9333 | -116.5765 | 2020-04-18 22:40:03 | Alberta, Canada | ||
1385011 | 1385011 | 2020-04-19 | Canada | Alberta | 2803 | 51 | 0 | 2752 | 53.9333 | -116.5765 | 2020-04-19 23:48:49 | Alberta, Canada | ||
2473319 | 2473319 | 2020-04-20 | Canada | Alberta | 2908 | 59 | 0 | 2849 | 53.9333 | -116.5765 | 2020-04-20 23:44:34 | Alberta, Canada | ||
522237 | 522237 | 2020-04-21 | Canada | Alberta | 3095 | 61 | 0 | 3034 | 53.9333 | -116.5765 | 2020-04-21 23:38:53 | Alberta, Canada | ||
1199172 | 1199172 | 2020-04-22 | Canada | Alberta | 3401 | 66 | 0 | 3335 | 53.9333 | -116.5765 | 2020-04-22 23:38:42 | Alberta, Canada | ||
2524729 | 2524729 | 2020-04-23 | Canada | Alberta | 3720 | 68 | 0 | 3652 | 53.9333 | -116.5765 | 2020-04-24 03:31:19 | Alberta, Canada | ||
1459143 | 1459143 | 2020-04-24 | Canada | Alberta | 4017 | 72 | 0 | 3945 | 53.9333 | -116.5765 | 2020-04-25 06:30:55 | Alberta, Canada | ||
3502742 | 3502742 | 2020-04-25 | Canada | Alberta | 4233 | 73 | 0 | 4160 | 53.9333 | -116.5765 | 2020-04-26 02:30:54 | Alberta, Canada | ||
3592393 | 3592393 | 2020-04-26 | Canada | Alberta | 4480 | 73 | 0 | 4407 | 53.9333 | -116.5765 | 2020-04-27 02:30:55 | Alberta, Canada | ||
3589211 | 3589211 | 2020-04-27 | Canada | Alberta | 4696 | 75 | 0 | 4621 | 53.9333 | -116.5765 | 2020-04-28 02:30:53 | Alberta, Canada | ||
271548 | 271548 | 2020-04-28 | Canada | Alberta | 4850 | 80 | 0 | 4770 | 53.9333 | -116.5765 | 2020-04-29 02:32:29 | Alberta, Canada | ||
137334 | 137334 | 2020-04-29 | Canada | Alberta | 5165 | 87 | 0 | 5078 | 53.9333 | -116.5765 | 2020-04-30 02:32:27 | Alberta, Canada | ||
228587 | 228587 | 2020-04-30 | Canada | Alberta | 5355 | 90 | 0 | 5265 | 53.9333 | -116.5765 | 2020-05-01 02:32:28 | Alberta, Canada | ||
1184106 | 1184106 | 2020-05-01 | Canada | Alberta | 5573 | 92 | 0 | 5481 | 53.9333 | -116.5765 | 2020-05-02 02:32:27 | Alberta, Canada | ||
2043212 | 2043212 | 2020-05-02 | Canada | Alberta | 5670 | 94 | 0 | 5576 | 53.9333 | -116.5765 | 2020-05-03 02:32:28 | Alberta, Canada | ||
2278536 | 2278536 | 2020-05-03 | Canada | Alberta | 5766 | 95 | 0 | 5671 | 53.9333 | -116.5765 | 2020-05-04 02:32:28 | Alberta, Canada | ||
3084677 | 3084677 | 2020-05-04 | Canada | Alberta | 5836 | 104 | 0 | 5732 | 53.9333 | -116.5765 | 2020-05-05 02:32:34 | Alberta, Canada | ||
1931814 | 1931814 | 2020-05-05 | Canada | Alberta | 5893 | 106 | 0 | 5787 | 53.9333 | -116.5765 | 2020-05-06 02:32:31 | Alberta, Canada | ||
2110774 | 2110774 | 2020-05-06 | Canada | Alberta | 5963 | 112 | 0 | 5851 | 53.9333 | -116.5765 | 2020-05-07 02:32:28 | Alberta, Canada | ||
3295553 | 3295553 | 2020-05-07 | Canada | Alberta | 6017 | 114 | 0 | 5903 | 53.9333 | -116.5765 | 2020-05-08 02:32:32 | Alberta, Canada | ||
114110 | 114110 | 2020-05-08 | Canada | Alberta | 6098 | 115 | 0 | 5983 | 53.9333 | -116.5765 | 2020-05-09 02:32:35 | Alberta, Canada | ||
2899061 | 2899061 | 2020-05-09 | Canada | Alberta | 6157 | 116 | 0 | 6041 | 53.9333 | -116.5765 | 2020-05-10 02:32:30 | Alberta, Canada | ||
3459520 | 3459520 | 2020-05-10 | Canada | Alberta | 6253 | 117 | 0 | 6136 | 53.9333 | -116.5765 | 2020-05-11 02:32:30 | Alberta, Canada | ||
3330905 | 3330905 | 2020-05-11 | Canada | Alberta | 6300 | 117 | 0 | 6183 | 53.9333 | -116.5765 | 2020-05-12 03:32:27 | Alberta, Canada | ||
2581371 | 2581371 | 2020-05-12 | Canada | Alberta | 6345 | 118 | 0 | 6227 | 53.9333 | -116.5765 | 2020-05-13 03:32:26 | Alberta, Canada | ||
3847164 | 3847164 | 2020-05-13 | Canada | Alberta | 6407 | 120 | 0 | 6287 | 53.9333 | -116.5765 | 2020-05-14 03:32:28 | Alberta, Canada | ||
1404349 | 1404349 | 2020-05-14 | Canada | Alberta | 6457 | 121 | 5205 | 1131 | 53.9333 | -116.5765 | 2020-05-15 02:33:02 | Alberta, Canada | ||
3276175 | 3276175 | 2020-05-15 | Canada | Alberta | 6515 | 125 | 5317 | 1073 | 53.9333 | -116.5765 | 2020-05-16 02:32:19 | Alberta, Canada | ||
1829459 | 1829459 | 2020-05-16 | Canada | Alberta | 6587 | 126 | 5377 | 1084 | 53.9333 | -116.5765 | 2020-05-17 02:32:32 | Alberta, Canada | ||
3416225 | 3416225 | 2020-05-17 | Canada | Alberta | 6644 | 127 | 5453 | 1064 | 53.9333 | -116.5765 | 2020-05-18 02:32:21 | Alberta, Canada | ||
3260831 | 3260831 | 2020-05-18 | Canada | Alberta | 6683 | 128 | 5519 | 1036 | 53.9333 | -116.5765 | 2020-05-19 02:32:18 | Alberta, Canada | ||
2390092 | 2390092 | 2020-05-19 | Canada | Alberta | 6716 | 128 | 5584 | 1004 | 53.9333 | -116.5765 | 2020-05-20 02:32:19 | Alberta, Canada | ||
1431801 | 1431801 | 2020-05-20 | Canada | Alberta | 6735 | 128 | 5637 | 970 | 53.9333 | -116.5765 | 2020-05-21 02:32:48 | Alberta, Canada | ||
268218 | 268218 | 2020-05-21 | Canada | Alberta | 6768 | 132 | 5710 | 926 | 53.9333 | -116.5765 | 2020-05-22 02:36:51 | Alberta, Canada | ||
1864712 | 1864712 | 2020-05-22 | Canada | Alberta | 6800 | 134 | 5801 | 865 | 53.9333 | -116.5765 | 2020-05-23 02:32:42 | Alberta, Canada | ||
997689 | 997689 | 2020-05-23 | Canada | Alberta | 6818 | 135 | 5869 | 814 | 53.9333 | -116.5765 | 2020-05-24 02:32:43 | Alberta, Canada | ||
875498 | 875498 | 2020-05-24 | Canada | Alberta | 6860 | 135 | 5924 | 801 | 53.9333 | -116.5765 | 2020-05-25 02:32:44 | Alberta, Canada | ||
1104818 | 1104818 | 2020-05-25 | Canada | Alberta | 6879 | 138 | 5979 | 762 | 53.9333 | -116.5765 | 2020-05-26 02:32:35 | Alberta, Canada | ||
1041088 | 1041088 | 2020-05-26 | Canada | Alberta | 6901 | 139 | 6048 | 714 | 53.9333 | -116.5765 | 2020-05-27 02:32:31 | Alberta, Canada | ||
2548125 | 2548125 | 2020-05-27 | Canada | Alberta | 6926 | 141 | 6106 | 679 | 53.9333 | -116.5765 | 2020-05-28 02:32:31 | Alberta, Canada | ||
2712107 | 2712107 | 2020-05-28 | Canada | Alberta | 6955 | 143 | 6160 | 652 | 53.9333 | -116.5765 | 2020-05-29 02:32:50 | Alberta, Canada | ||
1790227 | 1790227 | 2020-05-29 | Canada | Alberta | 6979 | 143 | 6220 | 616 | 53.9333 | -116.5765 | 2020-05-30 02:32:48 | Alberta, Canada | ||
3638686 | 3638686 | 2020-05-30 | Canada | Alberta | 6992 | 143 | 6245 | 604 | 53.9333 | -116.5765 | 2020-05-31 02:32:45 | Alberta, Canada | ||
1793793 | 1793793 | 2020-05-31 | Canada | Alberta | 7010 | 143 | 6283 | 584 | 53.9333 | -116.5765 | 2020-06-01 02:32:46 | Alberta, Canada | ||
805149 | 805149 | 2020-06-01 | Canada | Alberta | 7044 | 143 | 6501 | 400 | 53.9333 | -116.5765 | 2020-06-02 02:33:08 | Alberta, Canada | ||
2555613 | 2555613 | 2020-06-02 | Canada | Alberta | 7057 | 143 | 6537 | 377 | 53.9333 | -116.5765 | 2020-06-03 02:33:13 | Alberta, Canada | ||
3866570 | 3866570 | 2020-06-03 | Canada | Alberta | 7076 | 145 | 6587 | 344 | 53.9333 | -116.5765 | 2020-06-04 02:33:14 | Alberta, Canada | ||
1281015 | 1281015 | 2020-06-04 | Canada | Alberta | 7091 | 146 | 6611 | 334 | 53.9333 | -116.5765 | 2020-06-05 02:33:06 | Alberta, Canada | ||
1269534 | 1269534 | 2020-06-05 | Canada | Alberta | 7098 | 146 | 6624 | 328 | 53.9333 | -116.5765 | 2020-06-06 02:33:00 | Alberta, Canada | ||
573837 | 573837 | 2020-06-06 | Canada | Alberta | 7138 | 146 | 6656 | 336 | 53.9333 | -116.5765 | 2020-06-07 03:53:30 | Alberta, Canada | ||
2799781 | 2799781 | 2020-06-07 | Canada | Alberta | 7138 | 146 | 6656 | 336 | 53.9333 | -116.5765 | 2020-06-08 03:33:22 | Alberta, Canada | ||
216984 | 216984 | 2020-06-08 | Canada | Alberta | 7202 | 149 | 6698 | 355 | 53.9333 | -116.5765 | 2020-06-09 03:33:03 | Alberta, Canada | ||
1210557 | 1210557 | 2020-06-09 | Canada | Alberta | 7229 | 151 | 6722 | 356 | 53.9333 | -116.5765 | 2020-06-10 04:07:00 | Alberta, Canada | ||
2863697 | 2863697 | 2020-06-10 | Canada | Alberta | 7276 | 151 | 6754 | 371 | 53.9333 | -116.5765 | 2020-06-11 03:33:41 | Alberta, Canada | ||
1273253 | 1273253 | 2020-06-11 | Canada | Alberta | 7316 | 149 | 6788 | 379 | 53.9333 | -116.5765 | 2020-06-12 05:09:52 | Alberta, Canada | ||
737283 | 737283 | 2020-06-12 | Canada | Alberta | 7346 | 149 | 6811 | 386 | 53.9333 | -116.5765 | 2020-06-13 03:33:14 | Alberta, Canada | ||
3060963 | 3060963 | 2020-06-13 | Canada | Alberta | 7383 | 150 | 6830 | 403 | 53.9333 | -116.5765 | 2020-06-14 03:33:15 | Alberta, Canada | ||
1836911 | 1836911 | 2020-06-14 | Canada | Alberta | 7433 | 150 | 6861 | 422 | 53.9333 | -116.5765 | 2020-06-15 03:33:14 | Alberta, Canada | ||
286960 | 286960 | 2020-06-15 | Canada | Alberta | 7453 | 151 | 6862 | 440 | 53.9333 | -116.5765 | 2020-06-16 04:33:09 | Alberta, Canada | ||
2386397 | 2386397 | 2020-06-16 | Canada | Alberta | 7482 | 151 | 6882 | 449 | 53.9333 | -116.5765 | 2020-06-17 04:33:21 | Alberta, Canada | ||
1195634 | 1195634 | 2020-06-17 | Canada | Alberta | 7530 | 151 | 6893 | 486 | 53.9333 | -116.5765 | 2020-06-18 04:33:18 | Alberta, Canada | ||
3682431 | 3682431 | 2020-06-18 | Canada | Alberta | 7579 | 152 | 6938 | 489 | 53.9333 | -116.5765 | 2020-06-19 04:33:17 | Alberta, Canada | ||
1691282 | 1691282 | 2020-06-19 | Canada | Alberta | 7625 | 152 | 6961 | 512 | 53.9333 | -116.5765 | 2020-06-20 04:33:19 | Alberta, Canada | ||
2437704 | 2437704 | 2020-06-20 | Canada | Alberta | 7673 | 152 | 6996 | 525 | 53.9333 | -116.5765 | 2020-06-21 04:33:19 | Alberta, Canada | ||
3249111 | 3249111 | 2020-06-21 | Canada | Alberta | 7704 | 152 | 7018 | 534 | 53.9333 | -116.5765 | 2020-06-22 04:33:20 | Alberta, Canada | ||
1510372 | 1510372 | 2020-06-22 | Canada | Alberta | 7736 | 153 | 7041 | 542 | 53.9333 | -116.5765 | 2020-06-23 04:33:22 | Alberta, Canada | ||
1522178 | 1522178 | 2020-06-23 | Canada | Alberta | 7781 | 153 | 7096 | 532 | 53.9333 | -116.5765 | 2020-06-24 04:33:28 | Alberta, 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]);