johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,730 rows where country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- England 630
- Guernsey 630
- Jersey 630
- Northern Ireland 630
- Pitcairn Islands 630
- Scotland 630
- Unknown 630
- Wales 630
- Channel Islands 581
- Gibraltar 581
- Cayman Islands 576
- Montserrat 574
- Bermuda 573
- Isle of Man 572
- Saint Helena, Ascension and Tristan da Cunha 567
- Anguilla 564
- British Virgin Islands 564
- Turks and Caicos Islands 564
- Falkland Islands (Malvinas) 554
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 11,313 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495253 | 1495253 | 2021-10-12 | United Kingdom | Anguilla | 594 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-13 04:20:51 | Anguilla, United Kingdom | |||
1495254 | 1495254 | 2021-10-12 | United Kingdom | Bermuda | 5536 | 92 | 0 | 32.3078 | -64.7505 | 2021-10-13 04:20:51 | Bermuda, United Kingdom | |||
1495255 | 1495255 | 2021-10-12 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-13 04:20:51 | British Virgin Islands, United Kingdom | |||
1495256 | 1495256 | 2021-10-12 | United Kingdom | Cayman Islands | 996 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-13 04:20:51 | Cayman Islands, United Kingdom | |||
1495257 | 1495257 | 2021-10-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-13 04:20:51 | Channel Islands, United Kingdom | |||
1495258 | 1495258 | 2021-10-12 | United Kingdom | England | 7000356 | 141986 | 0 | 52.3555 | -1.1743 | 2021-10-13 04:20:51 | England, United Kingdom | |||
1495259 | 1495259 | 2021-10-12 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-13 04:20:51 | Falkland Islands (Malvinas), United Kingdom | |||
1495260 | 1495260 | 2021-10-12 | United Kingdom | Gibraltar | 5682 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-13 04:20:51 | Gibraltar, United Kingdom | |||
1495261 | 1495261 | 2021-10-12 | United Kingdom | Isle of Man | 8184 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-13 04:20:51 | Isle of Man, United Kingdom | |||
1495262 | 1495262 | 2021-10-12 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-13 04:20:51 | Montserrat, United Kingdom | |||
1495263 | 1495263 | 2021-10-12 | United Kingdom | Northern Ireland | 252208 | 3550 | 0 | 54.7877 | -6.4923 | 2021-10-13 04:20:51 | Northern Ireland, United Kingdom | |||
1495264 | 1495264 | 2021-10-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-13 04:20:51 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1495265 | 1495265 | 2021-10-12 | United Kingdom | Scotland | 594623 | 11451 | 0 | 56.4907 | -4.2026 | 2021-10-13 04:20:51 | Scotland, United Kingdom | |||
1495266 | 1495266 | 2021-10-12 | United Kingdom | Turks and Caicos Islands | 2898 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-13 04:20:51 | Turks and Caicos Islands, United Kingdom | |||
1495267 | 1495267 | 2021-10-12 | United Kingdom | Unknown | 0 | 222 | 0 | 55.3781 | -3.436 | 2021-10-13 04:20:51 | Unknown, United Kingdom | |||
1495268 | 1495268 | 2021-10-12 | United Kingdom | Wales | 384250 | 8532 | 0 | 52.1307 | -3.7837 | 2021-10-13 04:20:51 | Wales, United Kingdom | |||
1495281 | 1495281 | 2021-10-12 | United Kingdom | Jersey | 10248 | 79 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-13 04:20:51 | Jersey, United Kingdom | ||
1495282 | 1495282 | 2021-10-12 | United Kingdom | Guernsey | 1718 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-13 04:20:51 | Guernsey, United Kingdom | ||
1495288 | 1495288 | 2021-10-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-13 04:20:51 | Pitcairn Islands, United Kingdom | ||
3010986 | 3010986 | 2021-10-11 | United Kingdom | Anguilla | 594 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-12 04:21:09 | Anguilla, United Kingdom | |||
3010987 | 3010987 | 2021-10-11 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-12 04:21:09 | Bermuda, United Kingdom | |||
3010988 | 3010988 | 2021-10-11 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-12 04:21:09 | British Virgin Islands, United Kingdom | |||
3010989 | 3010989 | 2021-10-11 | United Kingdom | Cayman Islands | 983 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-12 04:21:09 | Cayman Islands, United Kingdom | |||
3010990 | 3010990 | 2021-10-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-12 04:21:09 | Channel Islands, United Kingdom | |||
3010991 | 3010991 | 2021-10-11 | United Kingdom | England | 6967915 | 141890 | 0 | 52.3555 | -1.1743 | 2021-10-12 04:21:09 | England, United Kingdom | |||
3010992 | 3010992 | 2021-10-11 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-12 04:21:09 | Falkland Islands (Malvinas), United Kingdom | |||
3010993 | 3010993 | 2021-10-11 | United Kingdom | Gibraltar | 5655 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-12 04:21:09 | Gibraltar, United Kingdom | |||
3010994 | 3010994 | 2021-10-11 | United Kingdom | Isle of Man | 8121 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-12 04:21:09 | Isle of Man, United Kingdom | |||
3010995 | 3010995 | 2021-10-11 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-12 04:21:09 | Montserrat, United Kingdom | |||
3010996 | 3010996 | 2021-10-11 | United Kingdom | Northern Ireland | 250930 | 3545 | 0 | 54.7877 | -6.4923 | 2021-10-12 04:21:09 | Northern Ireland, United Kingdom | |||
3010997 | 3010997 | 2021-10-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-12 04:21:09 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3010998 | 3010998 | 2021-10-11 | United Kingdom | Scotland | 592721 | 11431 | 0 | 56.4907 | -4.2026 | 2021-10-12 04:21:09 | Scotland, United Kingdom | |||
3010999 | 3010999 | 2021-10-11 | United Kingdom | Turks and Caicos Islands | 2898 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-12 04:21:09 | Turks and Caicos Islands, United Kingdom | |||
3011000 | 3011000 | 2021-10-11 | United Kingdom | Unknown | 0 | 222 | 0 | 55.3781 | -3.436 | 2021-10-12 04:21:09 | Unknown, United Kingdom | |||
3011001 | 3011001 | 2021-10-11 | United Kingdom | Wales | 382203 | 8517 | 0 | 52.1307 | -3.7837 | 2021-10-12 04:21:09 | Wales, United Kingdom | |||
3011014 | 3011014 | 2021-10-11 | United Kingdom | Jersey | 10225 | 79 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-12 04:21:09 | Jersey, United Kingdom | ||
3011015 | 3011015 | 2021-10-11 | United Kingdom | Guernsey | 1699 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-12 04:21:09 | Guernsey, United Kingdom | ||
3011021 | 3011021 | 2021-10-11 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-12 04:21:09 | Pitcairn Islands, United Kingdom | ||
427002 | 427002 | 2021-10-10 | United Kingdom | Anguilla | 544 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-11 04:21:31 | Anguilla, United Kingdom | |||
427003 | 427003 | 2021-10-10 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-11 04:21:31 | Bermuda, United Kingdom | |||
427004 | 427004 | 2021-10-10 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-11 04:21:31 | British Virgin Islands, United Kingdom | |||
427005 | 427005 | 2021-10-10 | United Kingdom | Cayman Islands | 960 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-11 04:21:31 | Cayman Islands, United Kingdom | |||
427006 | 427006 | 2021-10-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-11 04:21:31 | Channel Islands, United Kingdom | |||
427007 | 427007 | 2021-10-10 | United Kingdom | England | 6936327 | 141793 | 0 | 52.3555 | -1.1743 | 2021-10-11 04:21:31 | England, United Kingdom | |||
427008 | 427008 | 2021-10-10 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-11 04:21:31 | Falkland Islands (Malvinas), United Kingdom | |||
427009 | 427009 | 2021-10-10 | United Kingdom | Gibraltar | 5626 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-11 04:21:31 | Gibraltar, United Kingdom | |||
427010 | 427010 | 2021-10-10 | United Kingdom | Isle of Man | 8073 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-11 04:21:31 | Isle of Man, United Kingdom | |||
427011 | 427011 | 2021-10-10 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-11 04:21:31 | Montserrat, United Kingdom | |||
427012 | 427012 | 2021-10-10 | United Kingdom | Northern Ireland | 249821 | 3539 | 0 | 54.7877 | -6.4923 | 2021-10-11 04:21:31 | Northern Ireland, United Kingdom | |||
427013 | 427013 | 2021-10-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-11 04:21:31 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
427014 | 427014 | 2021-10-10 | United Kingdom | Scotland | 590424 | 11404 | 0 | 56.4907 | -4.2026 | 2021-10-11 04:21:31 | Scotland, United Kingdom | |||
427015 | 427015 | 2021-10-10 | United Kingdom | Turks and Caicos Islands | 2898 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-11 04:21:31 | Turks and Caicos Islands, United Kingdom | |||
427016 | 427016 | 2021-10-10 | United Kingdom | Unknown | 0 | 222 | 0 | 55.3781 | -3.436 | 2021-10-11 04:21:31 | Unknown, United Kingdom | |||
427017 | 427017 | 2021-10-10 | United Kingdom | Wales | 377734 | 8509 | 0 | 52.1307 | -3.7837 | 2021-10-11 04:21:31 | Wales, United Kingdom | |||
427030 | 427030 | 2021-10-10 | United Kingdom | Jersey | 10198 | 79 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-11 04:21:31 | Jersey, United Kingdom | ||
427031 | 427031 | 2021-10-10 | United Kingdom | Guernsey | 1690 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-11 04:21:31 | Guernsey, United Kingdom | ||
427037 | 427037 | 2021-10-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-11 04:21:31 | Pitcairn Islands, United Kingdom | ||
2879859 | 2879859 | 2021-10-09 | United Kingdom | Anguilla | 544 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-10 04:21:38 | Anguilla, United Kingdom | |||
2879860 | 2879860 | 2021-10-09 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-10 04:21:38 | Bermuda, United Kingdom | |||
2879861 | 2879861 | 2021-10-09 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-10 04:21:38 | British Virgin Islands, United Kingdom | |||
2879862 | 2879862 | 2021-10-09 | United Kingdom | Cayman Islands | 960 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-10 04:21:38 | Cayman Islands, United Kingdom | |||
2879863 | 2879863 | 2021-10-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-10 04:21:38 | Channel Islands, United Kingdom | |||
2879864 | 2879864 | 2021-10-09 | United Kingdom | England | 6906211 | 141711 | 0 | 52.3555 | -1.1743 | 2021-10-10 04:21:38 | England, United Kingdom | |||
2879865 | 2879865 | 2021-10-09 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-10 04:21:38 | Falkland Islands (Malvinas), United Kingdom | |||
2879866 | 2879866 | 2021-10-09 | United Kingdom | Gibraltar | 5613 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-10 04:21:38 | Gibraltar, United Kingdom | |||
2879867 | 2879867 | 2021-10-09 | United Kingdom | Isle of Man | 8028 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-10 04:21:38 | Isle of Man, United Kingdom | |||
2879868 | 2879868 | 2021-10-09 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-10 04:21:38 | Montserrat, United Kingdom | |||
2879869 | 2879869 | 2021-10-09 | United Kingdom | Northern Ireland | 248706 | 3536 | 0 | 54.7877 | -6.4923 | 2021-10-10 04:21:38 | Northern Ireland, United Kingdom | |||
2879870 | 2879870 | 2021-10-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-10 04:21:38 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2879871 | 2879871 | 2021-10-09 | United Kingdom | Scotland | 588062 | 11387 | 0 | 56.4907 | -4.2026 | 2021-10-10 04:21:38 | Scotland, United Kingdom | |||
2879872 | 2879872 | 2021-10-09 | United Kingdom | Turks and Caicos Islands | 2895 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-10 04:21:38 | Turks and Caicos Islands, United Kingdom | |||
2879873 | 2879873 | 2021-10-09 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-10 04:21:38 | Unknown, United Kingdom | |||
2879874 | 2879874 | 2021-10-09 | United Kingdom | Wales | 377734 | 8497 | 0 | 52.1307 | -3.7837 | 2021-10-10 04:21:38 | Wales, United Kingdom | |||
2879887 | 2879887 | 2021-10-09 | United Kingdom | Jersey | 10176 | 79 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-10 04:21:38 | Jersey, United Kingdom | ||
2879888 | 2879888 | 2021-10-09 | United Kingdom | Guernsey | 1674 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-10 04:21:38 | Guernsey, United Kingdom | ||
2879894 | 2879894 | 2021-10-09 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-10 04:21:38 | Pitcairn Islands, United Kingdom | ||
2963025 | 2963025 | 2021-10-08 | United Kingdom | Anguilla | 544 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-09 04:21:34 | Anguilla, United Kingdom | |||
2963026 | 2963026 | 2021-10-08 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-09 04:21:34 | Bermuda, United Kingdom | |||
2963027 | 2963027 | 2021-10-08 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-09 04:21:34 | British Virgin Islands, United Kingdom | |||
2963028 | 2963028 | 2021-10-08 | United Kingdom | Cayman Islands | 960 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-09 04:21:34 | Cayman Islands, United Kingdom | |||
2963029 | 2963029 | 2021-10-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-09 04:21:34 | Channel Islands, United Kingdom | |||
2963030 | 2963030 | 2021-10-08 | United Kingdom | England | 6876192 | 141617 | 0 | 52.3555 | -1.1743 | 2021-10-09 04:21:34 | England, United Kingdom | |||
2963031 | 2963031 | 2021-10-08 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-09 04:21:34 | Falkland Islands (Malvinas), United Kingdom | |||
2963032 | 2963032 | 2021-10-08 | United Kingdom | Gibraltar | 5608 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-09 04:21:34 | Gibraltar, United Kingdom | |||
2963033 | 2963033 | 2021-10-08 | United Kingdom | Isle of Man | 7959 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-09 04:21:34 | Isle of Man, United Kingdom | |||
2963034 | 2963034 | 2021-10-08 | United Kingdom | Montserrat | 40 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-09 04:21:34 | Montserrat, United Kingdom | |||
2963035 | 2963035 | 2021-10-08 | United Kingdom | Northern Ireland | 247432 | 3530 | 0 | 54.7877 | -6.4923 | 2021-10-09 04:21:34 | Northern Ireland, United Kingdom | |||
2963036 | 2963036 | 2021-10-08 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-09 04:21:34 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2963037 | 2963037 | 2021-10-08 | United Kingdom | Scotland | 585647 | 11372 | 0 | 56.4907 | -4.2026 | 2021-10-09 04:21:34 | Scotland, United Kingdom | |||
2963038 | 2963038 | 2021-10-08 | United Kingdom | Turks and Caicos Islands | 2890 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-09 04:21:34 | Turks and Caicos Islands, United Kingdom | |||
2963039 | 2963039 | 2021-10-08 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-09 04:21:34 | Unknown, United Kingdom | |||
2963040 | 2963040 | 2021-10-08 | United Kingdom | Wales | 372029 | 8491 | 0 | 52.1307 | -3.7837 | 2021-10-09 04:21:34 | Wales, United Kingdom | |||
2963053 | 2963053 | 2021-10-08 | United Kingdom | Jersey | 10146 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-09 04:21:34 | Jersey, United Kingdom | ||
2963054 | 2963054 | 2021-10-08 | United Kingdom | Guernsey | 1666 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-09 04:21:34 | Guernsey, United Kingdom | ||
2963060 | 2963060 | 2021-10-08 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-09 04:21:34 | Pitcairn Islands, United Kingdom | ||
471063 | 471063 | 2021-10-07 | United Kingdom | Anguilla | 499 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-08 04:21:25 | Anguilla, United Kingdom | |||
471064 | 471064 | 2021-10-07 | United Kingdom | Bermuda | 5455 | 87 | 0 | 32.3078 | -64.7505 | 2021-10-08 04:21:25 | Bermuda, United Kingdom | |||
471065 | 471065 | 2021-10-07 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-08 04:21:25 | British Virgin Islands, United Kingdom | |||
471066 | 471066 | 2021-10-07 | United Kingdom | Cayman Islands | 939 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-08 04:21:25 | Cayman Islands, United Kingdom | |||
471067 | 471067 | 2021-10-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-08 04:21:25 | Channel Islands, United Kingdom |
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]);