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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, day (date), last_update (date)
recovered 370 ✖
- 0 578
- 75070 5
- 84827 5
- 9261 4
- 10796 4
- 12799 4
- 17488 4
- 22169 4
- 138560 4
- 227768 4
- 230312 4
- 7532 3
- 7844 3
- 8193 3
- 8567 3
- 10097 3
- 11374 3
- 12054 3
- 13718 3
- 14702 3
- 15585 3
- 16527 3
- 18651 3
- 20310 3
- 24684 3
- 228901 3
- 229429 3
- 229783 3
- 6656 2
- 7407 2
- 8363 2
- 11167 2
- 13154 2
- 23484 2
- 26407 2
- 28321 2
- 128974 2
- 153002 2
- 228631 2
- 230039 2
- 230066 2
- 5205 1
- 5317 1
- 5377 1
- 5453 1
- 5519 1
- 5584 1
- 5637 1
- 5710 1
- 5801 1
- 5869 1
- 5924 1
- 5979 1
- 6048 1
- 6106 1
- 6160 1
- 6220 1
- 6245 1
- 6283 1
- 6501 1
- 6537 1
- 6587 1
- 6611 1
- 6624 1
- 6698 1
- 6722 1
- 6754 1
- 6788 1
- 6811 1
- 6830 1
- 6861 1
- 6862 1
- 6882 1
- 6893 1
- 6938 1
- 6961 1
- 6996 1
- 7018 1
- 7041 1
- 7096 1
- 7134 1
- 7191 1
- 7225 1
- 7283 1
- 7322 1
- 7354 1
- 7505 1
- 7627 1
- 7659 1
- 7716 1
- 7774 1
- 7989 1
- 8048 1
- 8127 1
- 8142 1
- 8308 1
- 8506 1
- 8774 1
- 8886 1
- 8983 1
- 9113 1
- 9754 1
- 9891 1
- 9984 1
- 10384 1
- 10552 1
- 10632 1
- 10713 1
- 11025 1
- 11600 1
- 11714 1
- 11799 1
- 11923 1
- 12293 1
- 12427 1
- 12535 1
- 12653 1
- 13557 1
- 14041 1
- 14212 1
- 14379 1
- 14573 1
- 15024 1
- 15066 1
- 15252 1
- 15467 1
- 15935 1
- 16072 1
- 16213 1
- 16370 1
- 16872 1
- 17030 1
- 17163 1
- 17338 1
- 18055 1
- 18223 1
- 18417 1
- 19243 1
- 19500 1
- 19734 1
- 20014 1
- 20949 1
- 21108 1
- 21459 1
- 21803 1
- 23874 1
- 25826 1
- 27707 1
- 29304 1
- 29731 1
- 30462 1
- 31192 1
- 31964 1
- 32835 1
- 33543 1
- 34206 1
- 34779 1
- 35695 1
- 36582 1
- 37316 1
- 38369 1
- 39381 1
- 40219 1
- 41182 1
- 42305 1
- 43464 1
- 44705 1
- 46018 1
- 47328 1
- 48467 1
- 49603 1
- 51000 1
- 52636 1
- 54225 1
- 55947 1
- 57613 1
- 58818 1
- 60130 1
- 61934 1
- 63668 1
- 65513 1
- 67159 1
- 68832 1
- 70167 1
- 71434 1
- 73298 1
- 81780 1
- 83328 1
- 90554 1
- 91799 1
- 92858 1
- 93954 1
- 94783 1
- 94932 1
- 96052 1
- 96867 1
- 98178 1
- 99412 1
- 100762 1
- 101779 1
- 101957 1
- 103167 1
- 103941 1
- 105208 1
- 106387 1
- 107358 1
- 108258 1
- 109078 1
- 109733 1
- 110622 1
- 111662 1
- 112558 1
- 113174 1
- 113939 1
- 114586 1
- 115064 1
- 115527 1
- 116259 1
- 116820 1
- 117400 1
- 117968 1
- 118445 1
- 118816 1
- 119130 1
- 119678 1
- 120136 1
- 120676 1
- 121068 1
- 121494 1
- 121829 1
- 122071 1
- 122554 1
- 122960 1
- 123338 1
- 123703 1
- 124114 1
- 124478 1
- 124818 1
- 125234 1
- 125622 1
- 126074 1
- 126406 1
- 126774 1
- 127034 1
- 127233 1
- 127531 1
- 127903 1
- 128261 1
- 128644 1
- 129566 1
- 129978 1
- 130382 1
- 130716 1
- 131081 1
- 131502 1
- 131781 1
- 132028 1
- 132415 1
- 132748 1
- 133086 1
- 133437 1
- 133800 1
- 134000 1
- 134246 1
- 134653 1
- 135040 1
- 135500 1
- 135972 1
- 136350 1
- 136659 1
- 136980 1
- 137499 1
- 137992 1
- 140614 1
- 141315 1
- 142010 1
- 142713 1
- 143360 1
- 144020 1
- 144596 1
- 145171 1
- 146011 1
- 146933 1
- 147920 1
- 149000 1
- 149935 1
- 150820 1
- 151719 1
- 155851 1
- 157272 1
- 158603 1
- 159603 1
- 160617 1
- 162052 1
- 163668 1
- 165267 1
- 166824 1
- 168580 1
- 169892 1
- 171212 1
- 172931 1
- 174666 1
- 176536 1
- 178149 1
- 179894 1
- 181483 1
- 182832 1
- 184719 1
- 186550 1
- 188475 1
- 190616 1
- 192688 1
- 194538 1
- 196246 1
- 198394 1
- 200496 1
- 202442 1
- 204270 1
- 205960 1
- 207486 1
- 208856 1
- 210764 1
- 212273 1
- 213721 1
- 214966 1
- 216167 1
- 216954 1
- 217636 1
- 218719 1
- 219592 1
- 220357 1
- 221010 1
- 221644 1
- 222062 1
- 222364 1
- 222776 1
- 223311 1
- 223877 1
- 224325 1
- 224782 1
- 225013 1
- 225219 1
- 225627 1
- 225941 1
- 226257 1
- 226513 1
- 226800 1
- 226942 1
- 227124 1
- 227413 1
- 227600 1
- 228294 1
- 228480 1
- 229102 1
- 229201 1
- 229284 1
- 229355 1
- 229570 1
- 229627 1
- 229702 1
- 229745 1
- 229885 1
- 229951 1
- 229989 1
- 230142 1
- 230183 1
- 230216 1
- 230263 1
- 230534 1
- 230634 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752651 | 2752651 | 2022-12-29 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-30 04:21:04 | Alberta, Canada | |||
1073657 | 1073657 | 2022-12-28 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-29 04:21:01 | Alberta, Canada | |||
327654 | 327654 | 2022-12-27 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-28 04:21:04 | Alberta, Canada | |||
217727 | 217727 | 2022-12-26 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-27 04:21:07 | Alberta, Canada | |||
3222184 | 3222184 | 2022-12-25 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-26 04:21:06 | Alberta, Canada | |||
1018098 | 1018098 | 2022-12-24 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-25 04:21:04 | Alberta, Canada | |||
690121 | 690121 | 2022-12-23 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-24 04:21:02 | Alberta, Canada | |||
2179331 | 2179331 | 2022-12-22 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-23 04:21:04 | Alberta, Canada | |||
451135 | 451135 | 2022-12-21 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-22 04:20:56 | Alberta, Canada | |||
2951134 | 2951134 | 2022-12-20 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-21 04:21:03 | Alberta, Canada | |||
3173536 | 3173536 | 2022-12-19 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-20 04:21:04 | Alberta, Canada | |||
1628053 | 1628053 | 2022-12-18 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-19 04:21:03 | Alberta, Canada | |||
503432 | 503432 | 2022-12-17 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-18 04:21:03 | Alberta, Canada | |||
3324004 | 3324004 | 2022-12-16 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-17 04:21:04 | Alberta, Canada | |||
542516 | 542516 | 2022-12-15 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-16 04:21:01 | Alberta, Canada | |||
348044 | 348044 | 2022-12-14 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-15 04:20:58 | Alberta, Canada | |||
307632 | 307632 | 2022-12-13 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-14 04:21:04 | Alberta, Canada | |||
1148693 | 1148693 | 2022-12-12 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-13 04:21:01 | Alberta, Canada | |||
868547 | 868547 | 2022-12-11 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-12 04:21:01 | Alberta, Canada | |||
257077 | 257077 | 2022-12-10 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-11 04:20:50 | Alberta, Canada | |||
3935791 | 3935791 | 2022-12-09 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-10 04:21:02 | Alberta, Canada | |||
3377123 | 3377123 | 2022-12-08 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-09 04:21:05 | Alberta, Canada | |||
1984394 | 1984394 | 2022-12-07 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-08 04:21:07 | Alberta, Canada | |||
3713917 | 3713917 | 2022-12-06 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-07 04:20:58 | Alberta, Canada | |||
2414622 | 2414622 | 2022-12-05 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
718230 | 718230 | 2022-12-04 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
2816519 | 2816519 | 2022-12-03 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
833375 | 833375 | 2022-12-02 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
2135905 | 2135905 | 2022-12-01 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 04:21:07 | Alberta, Canada | |||
1964321 | 1964321 | 2022-11-30 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-01 04:21:03 | Alberta, Canada | |||
2556335 | 2556335 | 2022-11-29 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-30 04:21:07 | Alberta, Canada | |||
1239409 | 1239409 | 2022-11-28 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-29 04:21:05 | Alberta, Canada | |||
3551397 | 3551397 | 2022-11-27 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-28 04:21:02 | Alberta, Canada | |||
2099877 | 2099877 | 2022-11-26 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-27 04:21:05 | Alberta, Canada | |||
487368 | 487368 | 2022-11-25 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-26 04:21:11 | Alberta, Canada | |||
3523197 | 3523197 | 2022-11-24 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-25 04:21:06 | Alberta, Canada | |||
3311980 | 3311980 | 2022-11-23 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-24 04:21:09 | Alberta, Canada | |||
1620021 | 1620021 | 2022-11-22 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-23 04:21:06 | Alberta, Canada | |||
3459909 | 3459909 | 2022-11-21 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-22 04:20:47 | Alberta, Canada | |||
1640094 | 1640094 | 2022-11-20 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-21 04:21:05 | Alberta, Canada | |||
2063651 | 2063651 | 2022-11-19 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-20 04:21:08 | Alberta, Canada | |||
1755045 | 1755045 | 2022-11-18 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-19 04:21:14 | Alberta, Canada | |||
3026038 | 3026038 | 2022-11-17 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-18 04:21:15 | Alberta, Canada | |||
2485749 | 2485749 | 2022-11-16 | Canada | Alberta | 616682 | 5137 | 0 | 53.9333 | -116.5765 | 2022-11-17 04:21:11 | Alberta, Canada | |||
291760 | 291760 | 2022-11-15 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-16 04:21:09 | Alberta, Canada | |||
3596790 | 3596790 | 2022-11-14 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-15 04:21:16 | Alberta, Canada | |||
311648 | 311648 | 2022-11-13 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-14 04:21:09 | Alberta, Canada | |||
62809 | 62809 | 2022-11-12 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-13 04:21:14 | Alberta, Canada | |||
2926971 | 2926971 | 2022-11-11 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-12 04:20:41 | Alberta, Canada | |||
2505807 | 2505807 | 2022-11-10 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-11 04:21:22 | Alberta, Canada | |||
2430682 | 2430682 | 2022-11-09 | Canada | Alberta | 615359 | 5093 | 0 | 53.9333 | -116.5765 | 2022-11-10 04:21:16 | Alberta, Canada | |||
479338 | 479338 | 2022-11-08 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-09 04:21:22 | Alberta, Canada | |||
2438488 | 2438488 | 2022-11-07 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-08 04:21:21 | Alberta, Canada | |||
1049586 | 1049586 | 2022-11-06 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-07 04:21:26 | Alberta, Canada | |||
617610 | 617610 | 2022-11-05 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-06 04:21:24 | Alberta, Canada | |||
1022114 | 1022114 | 2022-11-04 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-05 04:21:52 | Alberta, Canada | |||
431105 | 431105 | 2022-11-03 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-04 04:22:11 | Alberta, Canada | |||
849347 | 849347 | 2022-11-02 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-03 04:22:05 | Alberta, Canada | |||
710198 | 710198 | 2022-11-01 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-11-02 04:22:09 | Alberta, Canada | |||
3284647 | 3284647 | 2022-10-31 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-11-01 04:22:36 | Alberta, Canada | |||
319680 | 319680 | 2022-10-30 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-31 04:21:36 | Alberta, Canada | |||
911956 | 911956 | 2022-10-29 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-30 04:22:14 | Alberta, Canada | |||
1366225 | 1366225 | 2022-10-28 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-29 04:21:13 | Alberta, Canada | |||
3038080 | 3038080 | 2022-10-27 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-28 04:22:31 | Alberta, Canada | |||
538500 | 538500 | 2022-10-26 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-27 04:22:01 | Alberta, Canada | |||
1829901 | 1829901 | 2022-10-25 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-26 04:22:19 | Alberta, Canada | |||
794162 | 794162 | 2022-10-24 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-25 04:21:53 | Alberta, Canada | |||
3276617 | 3276617 | 2022-10-23 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-24 04:22:29 | Alberta, Canada | |||
2267655 | 2267655 | 2022-10-22 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-23 04:22:46 | Alberta, Canada | |||
1591955 | 1591955 | 2022-10-21 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-22 04:22:53 | Alberta, Canada | |||
2271671 | 2271671 | 2022-10-20 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-21 04:22:23 | Alberta, Canada | |||
198006 | 198006 | 2022-10-19 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-20 04:22:59 | Alberta, Canada | |||
2756667 | 2756667 | 2022-10-18 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-19 04:22:26 | Alberta, Canada | |||
2024501 | 2024501 | 2022-10-17 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-18 04:22:42 | Alberta, Canada | |||
2159279 | 2159279 | 2022-10-16 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-17 04:20:31 | Alberta, Canada | |||
515476 | 515476 | 2022-10-15 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-16 04:22:39 | Alberta, Canada | |||
2032533 | 2032533 | 2022-10-14 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-15 04:22:00 | Alberta, Canada | |||
3753221 | 3753221 | 2022-10-13 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-14 04:22:28 | Alberta, Canada | |||
3214046 | 3214046 | 2022-10-12 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-13 04:22:39 | Alberta, Canada | |||
3249895 | 3249895 | 2022-10-11 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-12 04:22:51 | Alberta, Canada | |||
2967154 | 2967154 | 2022-10-10 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-11 04:23:05 | Alberta, Canada | |||
3097190 | 3097190 | 2022-10-09 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-10 04:22:32 | Alberta, Canada | |||
4002415 | 4002415 | 2022-10-08 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-09 04:21:16 | Alberta, Canada | |||
396012 | 396012 | 2022-10-07 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-08 04:22:56 | Alberta, Canada | |||
2529129 | 2529129 | 2022-10-06 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-07 04:23:08 | Alberta, Canada | |||
1810523 | 1810523 | 2022-10-05 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-06 04:21:22 | Alberta, Canada | |||
130497 | 130497 | 2022-10-04 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-05 04:23:06 | Alberta, Canada | |||
2685444 | 2685444 | 2022-10-03 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-04 04:22:55 | Alberta, Canada | |||
2259511 | 2259511 | 2022-10-02 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-03 04:23:11 | Alberta, Canada | |||
2995037 | 2995037 | 2022-10-01 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-02 04:21:23 | Alberta, Canada | |||
853363 | 853363 | 2022-09-30 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-01 04:23:01 | Alberta, Canada | |||
2375289 | 2375289 | 2022-09-29 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-09-30 04:23:09 | Alberta, Canada | |||
1559840 | 1559840 | 2022-09-28 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-09-29 04:22:34 | Alberta, Canada | |||
3994383 | 3994383 | 2022-09-27 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-28 04:23:01 | Alberta, Canada | |||
2768711 | 2768711 | 2022-09-26 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-27 04:23:01 | Alberta, Canada | |||
1976364 | 1976364 | 2022-09-25 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-26 04:20:52 | Alberta, Canada | |||
2649531 | 2649531 | 2022-09-24 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-25 04:23:31 | Alberta, Canada | |||
383971 | 383971 | 2022-09-23 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-24 04:21:40 | Alberta, Canada | |||
1624037 | 1624037 | 2022-09-22 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-23 04:23:13 | Alberta, Canada | |||
1370241 | 1370241 | 2022-09-21 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-22 04:22:56 | 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]);