johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where province_or_state = "Alberta" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, day (date), last_update (date)
active 417 ✖
- 1036 6
- 1386 4
- 1433 4
- 14555 4
- 1580 4
- 1655 4
- 2224 4
- 5172 4
- 1107 3
- 1125 3
- 1144 3
- 1185 3
- 1341 3
- 1424 3
- 1444 3
- 1497 3
- 1558 3
- 2836 3
- 3651 3
- 572 3
- 579 3
- 675 3
- 859 3
- 895 3
- 1004 2
- 1055 2
- 1193 2
- 1430 2
- 1520 2
- 1527 2
- 1692 2
- 1822 2
- 336 2
- 356 2
- 4546 2
- 4649 2
- 520 2
- 540 2
- 542 2
- 547 2
- 5831 2
- 584 2
- 592 2
- 6110 2
- 676 2
- 745 2
- 799 2
- 8653 2
- 956 2
- 9753 2
- 10017 1
- 10031 1
- 10057 1
- 10068 1
- 10256 1
- 10382 1
- 1044 1
- 10565 1
- 1057 1
- 10582 1
- 1064 1
- 10655 1
- 1073 1
- 10809 1
- 1083 1
- 1084 1
- 1090 1
- 10953 1
- 1109 1
- 11096 1
- 11274 1
- 1131 1
- 1132 1
- 1134 1
- 1146 1
- 11464 1
- 1158 1
- 1161 1
- 1169 1
- 1172 1
- 1173 1
- 1176 1
- 1191 1
- 11923 1
- 12078 1
- 12187 1
- 12189 1
- 12195 1
- 12234 1
- 1227 1
- 12434 1
- 1261 1
- 12713 1
- 12838 1
- 1293 1
- 13059 1
- 13166 1
- 13220 1
- 13298 1
- 1334 1
- 13349 1
- 13411 1
- 13450 1
- 1347 1
- 1349 1
- 13608 1
- 13628 1
- 13687 1
- 1370 1
- 13719 1
- 13839 1
- 13917 1
- 1394 1
- 1397 1
- 1398 1
- 1403 1
- 14052 1
- 1408 1
- 14116 1
- 1415 1
- 1419 1
- 14217 1
- 14293 1
- 14437 1
- 1447 1
- 14533 1
- 1459 1
- 1462 1
- 14785 1
- 14849 1
- 1491 1
- 14931 1
- 1494 1
- 1495 1
- 15087 1
- 1538 1
- 15487 1
- 1549 1
- 15502 1
- 15569 1
- 1565 1
- 15692 1
- 1571 1
- 1582 1
- 1596 1
- 16223 1
- 16454 1
- 16577 1
- 16628 1
- 16759 1
- 1676 1
- 1686 1
- 17144 1
- 17307 1
- 17675 1
- 1773 1
- 17743 1
- 17821 1
- 1783 1
- 17935 1
- 18243 1
- 18311 1
- 18355 1
- 18424 1
- 18481 1
- 18798 1
- 18806 1
- 18813 1
- 1900 1
- 1910 1
- 19165 1
- 19182 1
- 19201 1
- 19260 1
- 19446 1
- 1948 1
- 19484 1
- 19607 1
- 19702 1
- 19865 1
- 19971 1
- 20013 1
- 2003 1
- 20067 1
- 20072 1
- 20136 1
- 20161 1
- 20163 1
- 20169 1
- 20180 1
- 20199 1
- 20388 1
- 20562 1
- 20610 1
- 20649 1
- 20721 1
- 20868 1
- 20938 1
- 2097 1
- 21123 1
- 2127 1
- 21288 1
- 21300 1
- 21385 1
- 2170 1
- 2176 1
- 21828 1
- 22280 1
- 22504 1
- 2282 1
- 22920 1
- 22993 1
- 2336 1
- 2347 1
- 23608 1
- 23623 1
- 23873 1
- 24156 1
- 24497 1
- 24586 1
- 2471 1
- 24860 1
- 24962 1
- 24998 1
- 2511 1
- 25155 1
- 25197 1
- 25438 1
- 258 1
- 2615 1
- 2639 1
- 2689 1
- 2738 1
- 2752 1
- 2804 1
- 2849 1
- 300 1
- 3034 1
- 3089 1
- 3138 1
- 3180 1
- 3203 1
- 3247 1
- 328 1
- 3335 1
- 334 1
- 3372 1
- 344 1
- 3519 1
- 3529 1
- 355 1
- 358 1
- 3652 1
- 371 1
- 377 1
- 379 1
- 3810 1
- 386 1
- 3945 1
- 400 1
- 403 1
- 4160 1
- 4204 1
- 422 1
- 440 1
- 4407 1
- 4431 1
- 4463 1
- 4470 1
- 4477 1
- 4484 1
- 4488 1
- 449 1
- 4505 1
- 4516 1
- 4545 1
- 4584 1
- 4594 1
- 4613 1
- 4621 1
- 4631 1
- 4633 1
- 4639 1
- 4674 1
- 4675 1
- 4697 1
- 4707 1
- 4738 1
- 4758 1
- 4770 1
- 4776 1
- 4793 1
- 4803 1
- 4811 1
- 484 1
- 4840 1
- 4857 1
- 486 1
- 4884 1
- 4887 1
- 489 1
- 4918 1
- 4921 1
- 4949 1
- 4993 1
- 506 1
- 5071 1
- 5078 1
- 5084 1
- 509 1
- 512 1
- 5215 1
- 5222 1
- 525 1
- 5265 1
- 5271 1
- 532 1
- 534 1
- 538 1
- 5407 1
- 5415 1
- 5429 1
- 5481 1
- 5501 1
- 5576 1
- 559 1
- 5618 1
- 5671 1
- 569 1
- 5706 1
- 5732 1
- 578 1
- 5787 1
- 5851 1
- 5903 1
- 591 1
- 5971 1
- 5983 1
- 599 1
- 604 1
- 6041 1
- 605 1
- 606 1
- 607 1
- 608 1
- 6136 1
- 616 1
- 6176 1
- 6183 1
- 619 1
- 6196 1
- 620 1
- 6227 1
- 6230 1
- 6231 1
- 624 1
- 6242 1
- 6266 1
- 6287 1
- 6305 1
- 6407 1
- 649 1
- 652 1
- 6534 1
- 658 1
- 6588 1
- 6599 1
- 6771 1
- 679 1
- 682 1
- 6822 1
- 6835 1
- 6912 1
- 697 1
- 701 1
- 704 1
- 7077 1
- 714 1
- 7366 1
- 7387 1
- 7505 1
- 7530 1
- 762 1
- 763 1
- 7646 1
- 7698 1
- 772 1
- 7736 1
- 7805 1
- 7922 1
- 7965 1
- 7975 1
- 801 1
- 8041 1
- 807 1
- 8073 1
- 8090 1
- 814 1
- 8203 1
- 8305 1
- 831 1
- 8350 1
- 8457 1
- 8474 1
- 8593 1
- 865 1
- 8652 1
- 8755 1
- 926 1
- 9277 1
- 9339 1
- 9511 1
- 9616 1
- 9618 1
- 970 1
- 9727 1
- 9987 1
province_or_state 1
- Alberta · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
3765432 | 3765432 | 2020-03-13 | Canada | Alberta | 29 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T20:00:00 | ||||
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 | ||||
2910581 | 2910581 | 2020-03-22 | Canada | Alberta | 259 | 1 | 0 | 258 | 53.9333 | -116.5765 | 3/22/20 23:48 | Alberta, Canada | ||
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 | ||
3946916 | 3946916 | 2020-03-28 | Canada | Alberta | 542 | 2 | 0 | 540 | 53.9333 | -116.5765 | 3/28/20 23:10 | Alberta, Canada | ||
2875580 | 2875580 | 2020-03-29 | Canada | Alberta | 621 | 2 | 0 | 619 | 53.9333 | -116.5765 | 3/29/20 23:13 | Alberta, Canada | ||
1872343 | 1872343 | 2020-03-30 | Canada | Alberta | 661 | 3 | 0 | 658 | 53.9333 | -116.5765 | 3/30/20 22:58 | 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 | ||
3701494 | 3701494 | 2020-04-02 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 4/2/20 23:31 | 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 | ||
1750652 | 1750652 | 2020-04-04 | Canada | Alberta | 1075 | 18 | 0 | 1057 | 53.9333 | -116.5765 | 4/4/20 23:40 | 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 | ||
3627320 | 3627320 | 2020-04-06 | Canada | Alberta | 1250 | 23 | 0 | 1227 | 53.9333 | -116.5765 | 4/6/20 23: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 |
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]);