johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,227 rows where country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-12-21 352
- 2020-07-13 44
- 2020-02-12 26
- 2020-02-04 25
- 2020-03-11 16
- 2020-03-26 16
- 2020-03-27 16
- 2020-03-31 16
- 2020-04-01 16
- 2020-04-03 16
- 2020-04-05 16
- 2020-04-07 16
- 2020-04-08 16
- 2020-04-09 16
- 2020-04-10 16
- 2020-04-11 16
- 2020-04-28 16
- 2020-04-29 16
- 2020-04-30 16
- 2020-05-01 16
- 2020-05-02 16
- 2020-05-03 16
- 2020-05-04 16
- 2020-05-05 16
- 2020-05-06 16
- 2020-05-07 16
- 2020-05-08 16
- 2020-05-09 16
- 2020-05-10 16
- 2020-05-11 16
- …
province_or_state 22
- British Columbia 496
- Ontario 465
- Quebec 456
- Alberta 455
- New Brunswick 454
- Manitoba 452
- Saskatchewan 452
- Newfoundland and Labrador 450
- Prince Edward Island 450
- Nova Scotia 446
- Grand Princess 444
- Northwest Territories 441
- Nunavut 440
- Yukon 439
- Diamond Princess 430
- Repatriated Travellers 196
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 7,103 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3145348 | 3145348 | 2021-06-07 | Canada | Manitoba | 52919 | 1077 | 47880 | 3962 | 53.7609 | -98.8139 | 2021-06-08 04:22:35 | Manitoba, Canada | ||
3145349 | 3145349 | 2021-06-07 | Canada | New Brunswick | 2266 | 44 | 2110 | 112 | 46.5653 | -66.4619 | 2021-06-08 04:22:35 | New Brunswick, Canada | ||
3145350 | 3145350 | 2021-06-07 | Canada | Newfoundland and Labrador | 1354 | 6 | 1274 | 74 | 53.1355 | -57.6604 | 2021-06-08 04:22:35 | Newfoundland and Labrador, Canada | ||
3145351 | 3145351 | 2021-06-07 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-08 04:22:35 | Northwest Territories,Canada | ||
3145352 | 3145352 | 2021-06-07 | Canada | Nova Scotia | 5680 | 88 | 5407 | 185 | 44.682 | -63.7443 | 2021-06-08 04:22:35 | Nova Scotia, Canada | ||
3145353 | 3145353 | 2021-06-07 | Canada | Nunavut | 649 | 4 | 644 | 1 | 70.2998 | -83.1076 | 2021-06-08 04:22:35 | Nunavut, Canada | ||
3145354 | 3145354 | 2021-06-07 | Canada | Ontario | 541231 | 8869 | 527970 | 7524 | 51.2538 | -85.3232 | 2021-06-08 04:22:35 | Ontario, Canada | ||
3145355 | 3145355 | 2021-06-07 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-08 04:22:35 | Prince Edward Island, Canada | ||
3145356 | 3145356 | 2021-06-07 | Canada | Quebec | 372417 | 11152 | 358221 | 3044 | 52.9399 | -73.5491 | 2021-06-08 04:22:35 | Quebec, Canada | ||
3145357 | 3145357 | 2021-06-07 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-08 04:22:35 | Repatriated Travellers, Canada | ||||
3145358 | 3145358 | 2021-06-07 | Canada | Saskatchewan | 47427 | 549 | 45736 | 1142 | 52.9399 | -106.4509 | 2021-06-08 04:22:35 | Saskatchewan, Canada | ||
3145359 | 3145359 | 2021-06-07 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-08 04:22:35 | Yukon, Canada | ||
825346 | 825346 | 2021-06-06 | Canada | Alberta | 229192 | 2246 | 222062 | 4884 | 53.9333 | -116.5765 | 2021-06-07 04:22:51 | Alberta, Canada | ||
825347 | 825347 | 2021-06-06 | Canada | British Columbia | 145049 | 1710 | 140835 | 2504 | 53.7267 | -127.6476 | 2021-06-07 04:22:51 | British Columbia, Canada | ||
825348 | 825348 | 2021-06-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
825349 | 825349 | 2021-06-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
825350 | 825350 | 2021-06-06 | Canada | Manitoba | 52751 | 1075 | 47607 | 4069 | 53.7609 | -98.8139 | 2021-06-07 04:22:51 | Manitoba, Canada | ||
825351 | 825351 | 2021-06-06 | Canada | New Brunswick | 2265 | 44 | 2087 | 134 | 46.5653 | -66.4619 | 2021-06-07 04:22:51 | New Brunswick, Canada | ||
825352 | 825352 | 2021-06-06 | Canada | Newfoundland and Labrador | 1352 | 6 | 1274 | 72 | 53.1355 | -57.6604 | 2021-06-07 04:22:51 | Newfoundland and Labrador, Canada | ||
825353 | 825353 | 2021-06-06 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-07 04:22:51 | Northwest Territories,Canada | ||
825354 | 825354 | 2021-06-06 | Canada | Nova Scotia | 5663 | 88 | 5371 | 204 | 44.682 | -63.7443 | 2021-06-07 04:22:51 | Nova Scotia, Canada | ||
825355 | 825355 | 2021-06-06 | Canada | Nunavut | 649 | 4 | 642 | 3 | 70.2998 | -83.1076 | 2021-06-07 04:22:51 | Nunavut, Canada | ||
825356 | 825356 | 2021-06-06 | Canada | Ontario | 540795 | 8854 | 526480 | 8267 | 51.2538 | -85.3232 | 2021-06-07 04:22:51 | Ontario, Canada | ||
825357 | 825357 | 2021-06-06 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-07 04:22:51 | Prince Edward Island, Canada | ||
825358 | 825358 | 2021-06-06 | Canada | Quebec | 372254 | 11149 | 357867 | 3238 | 52.9399 | -73.5491 | 2021-06-07 04:22:51 | Quebec, Canada | ||
825359 | 825359 | 2021-06-06 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-07 04:22:51 | Repatriated Travellers, Canada | ||||
825360 | 825360 | 2021-06-06 | Canada | Saskatchewan | 47359 | 546 | 45617 | 1196 | 52.9399 | -106.4509 | 2021-06-07 04:22:51 | Saskatchewan, Canada | ||
825361 | 825361 | 2021-06-06 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-07 04:22:51 | Yukon, Canada | ||
2585751 | 2585751 | 2021-06-05 | Canada | Alberta | 228961 | 2246 | 221644 | 5071 | 53.9333 | -116.5765 | 2021-06-06 04:24:03 | Alberta, Canada | ||
2585752 | 2585752 | 2021-06-05 | Canada | British Columbia | 145049 | 1710 | 140835 | 2504 | 53.7267 | -127.6476 | 2021-06-06 04:24:03 | British Columbia, Canada | ||
2585753 | 2585753 | 2021-06-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2585754 | 2585754 | 2021-06-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2585755 | 2585755 | 2021-06-05 | Canada | Manitoba | 52531 | 1072 | 47345 | 4114 | 53.7609 | -98.8139 | 2021-06-06 04:24:03 | Manitoba, Canada | ||
2585756 | 2585756 | 2021-06-05 | Canada | New Brunswick | 2262 | 44 | 2068 | 150 | 46.5653 | -66.4619 | 2021-06-06 04:24:03 | New Brunswick, Canada | ||
2585757 | 2585757 | 2021-06-05 | Canada | Newfoundland and Labrador | 1347 | 6 | 1266 | 75 | 53.1355 | -57.6604 | 2021-06-06 04:24:03 | Newfoundland and Labrador, Canada | ||
2585758 | 2585758 | 2021-06-05 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-06 04:24:03 | Northwest Territories,Canada | ||
2585759 | 2585759 | 2021-06-05 | Canada | Nova Scotia | 5651 | 88 | 5339 | 224 | 44.682 | -63.7443 | 2021-06-06 04:24:03 | Nova Scotia, Canada | ||
2585760 | 2585760 | 2021-06-05 | Canada | Nunavut | 649 | 4 | 642 | 3 | 70.2998 | -83.1076 | 2021-06-06 04:24:03 | Nunavut, Canada | ||
2585761 | 2585761 | 2021-06-05 | Canada | Ontario | 540305 | 8844 | 525521 | 8585 | 51.2538 | -85.3232 | 2021-06-06 04:24:03 | Ontario, Canada | ||
2585762 | 2585762 | 2021-06-05 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-06 04:24:03 | Prince Edward Island, Canada | ||
2585763 | 2585763 | 2021-06-05 | Canada | Quebec | 372101 | 11150 | 357425 | 3526 | 52.9399 | -73.5491 | 2021-06-06 04:24:03 | Quebec, Canada | ||
2585764 | 2585764 | 2021-06-05 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-06 04:24:03 | Repatriated Travellers, Canada | ||||
2585765 | 2585765 | 2021-06-05 | Canada | Saskatchewan | 47285 | 546 | 45498 | 1241 | 52.9399 | -106.4509 | 2021-06-06 04:24:03 | Saskatchewan, Canada | ||
2585766 | 2585766 | 2021-06-05 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-06 04:24:03 | Yukon, Canada | ||
2315065 | 2315065 | 2021-06-04 | Canada | Alberta | 228668 | 2243 | 221010 | 5415 | 53.9333 | -116.5765 | 2021-06-05 04:23:03 | Alberta, Canada | ||
2315066 | 2315066 | 2021-06-04 | Canada | British Columbia | 145049 | 1710 | 140835 | 2504 | 53.7267 | -127.6476 | 2021-06-05 04:23:03 | British Columbia, Canada | ||
2315067 | 2315067 | 2021-06-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2315068 | 2315068 | 2021-06-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2315069 | 2315069 | 2021-06-04 | Canada | Manitoba | 52261 | 1071 | 46999 | 4191 | 53.7609 | -98.8139 | 2021-06-05 04:23:03 | Manitoba, Canada | ||
2315070 | 2315070 | 2021-06-04 | Canada | New Brunswick | 2253 | 44 | 2061 | 148 | 46.5653 | -66.4619 | 2021-06-05 04:23:03 | New Brunswick, Canada | ||
2315071 | 2315071 | 2021-06-04 | Canada | Newfoundland and Labrador | 1342 | 6 | 1252 | 84 | 53.1355 | -57.6604 | 2021-06-05 04:23:03 | Newfoundland and Labrador, Canada | ||
2315072 | 2315072 | 2021-06-04 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-05 04:23:03 | Northwest Territories,Canada | ||
2315073 | 2315073 | 2021-06-04 | Canada | Nova Scotia | 5633 | 88 | 5294 | 251 | 44.682 | -63.7443 | 2021-06-05 04:23:03 | Nova Scotia, Canada | ||
2315074 | 2315074 | 2021-06-04 | Canada | Nunavut | 649 | 4 | 635 | 10 | 70.2998 | -83.1076 | 2021-06-05 04:23:03 | Nunavut, Canada | ||
2315075 | 2315075 | 2021-06-04 | Canada | Ontario | 539713 | 8820 | 524973 | 8733 | 51.2538 | -85.3232 | 2021-06-05 04:23:03 | Ontario, Canada | ||
2315076 | 2315076 | 2021-06-04 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-05 04:23:03 | Prince Edward Island, Canada | ||
2315077 | 2315077 | 2021-06-04 | Canada | Quebec | 371889 | 11148 | 356998 | 3743 | 52.9399 | -73.5491 | 2021-06-05 04:23:03 | Quebec, Canada | ||
2315078 | 2315078 | 2021-06-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-05 04:23:03 | Repatriated Travellers, Canada | ||||
2315079 | 2315079 | 2021-06-04 | Canada | Saskatchewan | 47186 | 543 | 45351 | 1292 | 52.9399 | -106.4509 | 2021-06-05 04:23:03 | Saskatchewan, Canada | ||
2315080 | 2315080 | 2021-06-04 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-05 04:23:03 | Yukon, Canada | ||
1448350 | 1448350 | 2021-06-03 | Canada | Alberta | 228424 | 2236 | 220357 | 5831 | 53.9333 | -116.5765 | 2021-06-04 04:23:37 | Alberta, Canada | ||
1448351 | 1448351 | 2021-06-03 | Canada | British Columbia | 144866 | 1709 | 140537 | 2620 | 53.7267 | -127.6476 | 2021-06-04 04:23:37 | British Columbia, Canada | ||
1448352 | 1448352 | 2021-06-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1448353 | 1448353 | 2021-06-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1448354 | 1448354 | 2021-06-03 | Canada | Manitoba | 51935 | 1067 | 46689 | 4179 | 53.7609 | -98.8139 | 2021-06-04 04:23:37 | Manitoba, Canada | ||
1448355 | 1448355 | 2021-06-03 | Canada | New Brunswick | 2243 | 44 | 2052 | 147 | 46.5653 | -66.4619 | 2021-06-04 04:23:37 | New Brunswick, Canada | ||
1448356 | 1448356 | 2021-06-03 | Canada | Newfoundland and Labrador | 1340 | 6 | 1240 | 94 | 53.1355 | -57.6604 | 2021-06-04 04:23:37 | Newfoundland and Labrador, Canada | ||
1448357 | 1448357 | 2021-06-03 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-04 04:23:37 | Northwest Territories,Canada | ||
1448358 | 1448358 | 2021-06-03 | Canada | Nova Scotia | 5618 | 88 | 5257 | 273 | 44.682 | -63.7443 | 2021-06-04 04:23:37 | Nova Scotia, Canada | ||
1448359 | 1448359 | 2021-06-03 | Canada | Nunavut | 648 | 4 | 635 | 9 | 70.2998 | -83.1076 | 2021-06-04 04:23:37 | Nunavut, Canada | ||
1448360 | 1448360 | 2021-06-03 | Canada | Ontario | 539004 | 8801 | 523853 | 8987 | 51.2538 | -85.3232 | 2021-06-04 04:23:37 | Ontario, Canada | ||
1448361 | 1448361 | 2021-06-03 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-04 04:23:37 | Prince Edward Island, Canada | ||
1448362 | 1448362 | 2021-06-03 | Canada | Quebec | 371655 | 11144 | 356582 | 3929 | 52.9399 | -73.5491 | 2021-06-04 04:23:37 | Quebec, Canada | ||
1448363 | 1448363 | 2021-06-03 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-04 04:23:37 | Repatriated Travellers, Canada | ||||
1448364 | 1448364 | 2021-06-03 | Canada | Saskatchewan | 47097 | 543 | 45240 | 1314 | 52.9399 | -106.4509 | 2021-06-04 04:23:37 | Saskatchewan, Canada | ||
1448365 | 1448365 | 2021-06-03 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-04 04:23:37 | Yukon, Canada | ||
1708074 | 1708074 | 2021-06-02 | Canada | Alberta | 228128 | 2231 | 219592 | 6305 | 53.9333 | -116.5765 | 2021-06-03 04:23:32 | Alberta, Canada | ||
1708075 | 1708075 | 2021-06-02 | Canada | British Columbia | 144667 | 1707 | 140238 | 2722 | 53.7267 | -127.6476 | 2021-06-03 04:23:32 | British Columbia, Canada | ||
1708076 | 1708076 | 2021-06-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1708077 | 1708077 | 2021-06-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1708078 | 1708078 | 2021-06-02 | Canada | Manitoba | 51580 | 1062 | 46251 | 4267 | 53.7609 | -98.8139 | 2021-06-03 04:23:32 | Manitoba, Canada | ||
1708079 | 1708079 | 2021-06-02 | Canada | New Brunswick | 2227 | 43 | 2043 | 141 | 46.5653 | -66.4619 | 2021-06-03 04:23:32 | New Brunswick, Canada | ||
1708080 | 1708080 | 2021-06-02 | Canada | Newfoundland and Labrador | 1334 | 6 | 1234 | 94 | 53.1355 | -57.6604 | 2021-06-03 04:23:32 | Newfoundland and Labrador, Canada | ||
1708081 | 1708081 | 2021-06-02 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-03 04:23:32 | Northwest Territories,Canada | ||
1708082 | 1708082 | 2021-06-02 | Canada | Nova Scotia | 5593 | 87 | 5197 | 311 | 44.682 | -63.7443 | 2021-06-03 04:23:32 | Nova Scotia, Canada | ||
1708083 | 1708083 | 2021-06-02 | Canada | Nunavut | 648 | 4 | 635 | 9 | 70.2998 | -83.1076 | 2021-06-03 04:23:32 | Nunavut, Canada | ||
1708084 | 1708084 | 2021-06-02 | Canada | Ontario | 538148 | 8791 | 522551 | 9421 | 51.2538 | -85.3232 | 2021-06-03 04:23:32 | Ontario, Canada | ||
1708085 | 1708085 | 2021-06-02 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-03 04:23:32 | Prince Edward Island, Canada | ||
1708086 | 1708086 | 2021-06-02 | Canada | Quebec | 371384 | 11138 | 356202 | 4044 | 52.9399 | -73.5491 | 2021-06-03 04:23:32 | Quebec, Canada | ||
1708087 | 1708087 | 2021-06-02 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-03 04:23:32 | Repatriated Travellers, Canada | ||||
1708088 | 1708088 | 2021-06-02 | Canada | Saskatchewan | 46966 | 541 | 45138 | 1285 | 52.9399 | -106.4509 | 2021-06-03 04:23:32 | Saskatchewan, Canada | ||
1708089 | 1708089 | 2021-06-02 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-03 04:23:32 | Yukon, Canada | ||
2103892 | 2103892 | 2021-06-01 | Canada | Alberta | 227718 | 2228 | 218719 | 6771 | 53.9333 | -116.5765 | 2021-06-02 04:24:34 | Alberta, Canada | ||
2103893 | 2103893 | 2021-06-01 | Canada | British Columbia | 144473 | 1703 | 139899 | 2871 | 53.7267 | -127.6476 | 2021-06-02 04:24:34 | British Columbia, Canada | ||
2103894 | 2103894 | 2021-06-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2103895 | 2103895 | 2021-06-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2103896 | 2103896 | 2021-06-01 | Canada | Manitoba | 51316 | 1056 | 45927 | 4333 | 53.7609 | -98.8139 | 2021-06-02 04:24:34 | Manitoba, Canada | ||
2103897 | 2103897 | 2021-06-01 | Canada | New Brunswick | 2215 | 43 | 2029 | 143 | 46.5653 | -66.4619 | 2021-06-02 04:24:34 | New Brunswick, Canada | ||
2103898 | 2103898 | 2021-06-01 | Canada | Newfoundland and Labrador | 1317 | 6 | 1217 | 94 | 53.1355 | -57.6604 | 2021-06-02 04:24:34 | Newfoundland and Labrador, Canada | ||
2103899 | 2103899 | 2021-06-01 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-02 04:24:34 | Northwest Territories,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]);