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 935
- Guernsey 935
- Jersey 935
- Northern Ireland 935
- Pitcairn Islands 935
- Scotland 935
- Unknown 935
- Wales 935
- Channel Islands 886
- Gibraltar 886
- Cayman Islands 881
- Montserrat 879
- Bermuda 878
- Isle of Man 877
- Saint Helena, Ascension and Tristan da Cunha 872
- Anguilla 869
- British Virgin Islands 869
- Turks and Caicos Islands 869
- Falkland Islands (Malvinas) 859
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 17,108 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1972244 | 1972244 | 2022-08-13 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-14 04:20:55 | Anguilla, United Kingdom | |||
1972245 | 1972245 | 2022-08-13 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-14 04:20:55 | Bermuda, United Kingdom | |||
1972246 | 1972246 | 2022-08-13 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-14 04:20:55 | British Virgin Islands, United Kingdom | |||
1972247 | 1972247 | 2022-08-13 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-14 04:20:55 | Cayman Islands, United Kingdom | |||
1972248 | 1972248 | 2022-08-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-14 04:20:55 | Channel Islands, United Kingdom | |||
1972249 | 1972249 | 2022-08-13 | United Kingdom | England | 19745612 | 174482 | 0 | 52.3555 | -1.1743 | 2022-08-14 04:20:55 | England, United Kingdom | |||
1972250 | 1972250 | 2022-08-13 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-14 04:20:55 | Falkland Islands (Malvinas), United Kingdom | |||
1972251 | 1972251 | 2022-08-13 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-14 04:20:55 | Gibraltar, United Kingdom | |||
1972252 | 1972252 | 2022-08-13 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-14 04:20:55 | Guernsey, United Kingdom | |||
1972253 | 1972253 | 2022-08-13 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-14 04:20:55 | Isle of Man, United Kingdom | |||
1972254 | 1972254 | 2022-08-13 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-14 04:20:55 | Jersey, United Kingdom | |||
1972255 | 1972255 | 2022-08-13 | United Kingdom | Montserrat | 1097 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-14 04:20:55 | Montserrat, United Kingdom | |||
1972256 | 1972256 | 2022-08-13 | United Kingdom | Northern Ireland | 713294 | 4821 | 0 | 54.7877 | -6.4923 | 2022-08-14 04:20:55 | Northern Ireland, United Kingdom | |||
1972257 | 1972257 | 2022-08-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-14 04:20:55 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1972258 | 1972258 | 2022-08-13 | United Kingdom | Scotland | 2079366 | 15521 | 0 | 56.4907 | -4.2026 | 2022-08-14 04:20:55 | Scotland, United Kingdom | |||
1972259 | 1972259 | 2022-08-13 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-14 04:20:55 | Turks and Caicos Islands, United Kingdom | |||
1972260 | 1972260 | 2022-08-13 | United Kingdom | Unknown | 0 | 315 | 0 | 55.3781 | -3.436 | 2022-08-14 04:20:55 | Unknown, United Kingdom | |||
1972261 | 1972261 | 2022-08-13 | United Kingdom | Wales | 882554 | 10706 | 0 | 52.1307 | -3.7837 | 2022-08-14 04:20:55 | Wales, United Kingdom | |||
1972275 | 1972275 | 2022-08-13 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-14 04:20:55 | Pitcairn Islands, United Kingdom | ||
2892053 | 2892053 | 2022-08-12 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-13 04:20:52 | Anguilla, United Kingdom | |||
2892054 | 2892054 | 2022-08-12 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-13 04:20:52 | Bermuda, United Kingdom | |||
2892055 | 2892055 | 2022-08-12 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-13 04:20:52 | British Virgin Islands, United Kingdom | |||
2892056 | 2892056 | 2022-08-12 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-13 04:20:52 | Cayman Islands, United Kingdom | |||
2892057 | 2892057 | 2022-08-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-13 04:20:52 | Channel Islands, United Kingdom | |||
2892058 | 2892058 | 2022-08-12 | United Kingdom | England | 19745612 | 174408 | 0 | 52.3555 | -1.1743 | 2022-08-13 04:20:52 | England, United Kingdom | |||
2892059 | 2892059 | 2022-08-12 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-13 04:20:52 | Falkland Islands (Malvinas), United Kingdom | |||
2892060 | 2892060 | 2022-08-12 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-13 04:20:52 | Gibraltar, United Kingdom | |||
2892061 | 2892061 | 2022-08-12 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-13 04:20:52 | Guernsey, United Kingdom | |||
2892062 | 2892062 | 2022-08-12 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-13 04:20:52 | Isle of Man, United Kingdom | |||
2892063 | 2892063 | 2022-08-12 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-13 04:20:52 | Jersey, United Kingdom | |||
2892064 | 2892064 | 2022-08-12 | United Kingdom | Montserrat | 1097 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-13 04:20:52 | Montserrat, United Kingdom | |||
2892065 | 2892065 | 2022-08-12 | United Kingdom | Northern Ireland | 713294 | 4817 | 0 | 54.7877 | -6.4923 | 2022-08-13 04:20:52 | Northern Ireland, United Kingdom | |||
2892066 | 2892066 | 2022-08-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-13 04:20:52 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2892067 | 2892067 | 2022-08-12 | United Kingdom | Scotland | 2079366 | 15518 | 0 | 56.4907 | -4.2026 | 2022-08-13 04:20:52 | Scotland, United Kingdom | |||
2892068 | 2892068 | 2022-08-12 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-13 04:20:52 | Turks and Caicos Islands, United Kingdom | |||
2892069 | 2892069 | 2022-08-12 | United Kingdom | Unknown | 0 | 315 | 0 | 55.3781 | -3.436 | 2022-08-13 04:20:52 | Unknown, United Kingdom | |||
2892070 | 2892070 | 2022-08-12 | United Kingdom | Wales | 882554 | 10699 | 0 | 52.1307 | -3.7837 | 2022-08-13 04:20:52 | Wales, United Kingdom | |||
2892084 | 2892084 | 2022-08-12 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-13 04:20:52 | Pitcairn Islands, United Kingdom | ||
3911658 | 3911658 | 2022-08-11 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-12 04:20:54 | Anguilla, United Kingdom | |||
3911659 | 3911659 | 2022-08-11 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-12 04:20:54 | Bermuda, United Kingdom | |||
3911660 | 3911660 | 2022-08-11 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-12 04:20:54 | British Virgin Islands, United Kingdom | |||
3911661 | 3911661 | 2022-08-11 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-12 04:20:54 | Cayman Islands, United Kingdom | |||
3911662 | 3911662 | 2022-08-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-12 04:20:54 | Channel Islands, United Kingdom | |||
3911663 | 3911663 | 2022-08-11 | United Kingdom | England | 19745612 | 174316 | 0 | 52.3555 | -1.1743 | 2022-08-12 04:20:54 | England, United Kingdom | |||
3911664 | 3911664 | 2022-08-11 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-12 04:20:54 | Falkland Islands (Malvinas), United Kingdom | |||
3911665 | 3911665 | 2022-08-11 | United Kingdom | Gibraltar | 19999 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-12 04:20:54 | Gibraltar, United Kingdom | |||
3911666 | 3911666 | 2022-08-11 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-12 04:20:54 | Guernsey, United Kingdom | |||
3911667 | 3911667 | 2022-08-11 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-12 04:20:54 | Isle of Man, United Kingdom | |||
3911668 | 3911668 | 2022-08-11 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-12 04:20:54 | Jersey, United Kingdom | |||
3911669 | 3911669 | 2022-08-11 | United Kingdom | Montserrat | 1084 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-12 04:20:54 | Montserrat, United Kingdom | |||
3911670 | 3911670 | 2022-08-11 | United Kingdom | Northern Ireland | 713294 | 4817 | 0 | 54.7877 | -6.4923 | 2022-08-12 04:20:54 | Northern Ireland, United Kingdom | |||
3911671 | 3911671 | 2022-08-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-12 04:20:54 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3911672 | 3911672 | 2022-08-11 | United Kingdom | Scotland | 2079366 | 15511 | 0 | 56.4907 | -4.2026 | 2022-08-12 04:20:54 | Scotland, United Kingdom | |||
3911673 | 3911673 | 2022-08-11 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-12 04:20:54 | Turks and Caicos Islands, United Kingdom | |||
3911674 | 3911674 | 2022-08-11 | United Kingdom | Unknown | 0 | 314 | 0 | 55.3781 | -3.436 | 2022-08-12 04:20:54 | Unknown, United Kingdom | |||
3911675 | 3911675 | 2022-08-11 | United Kingdom | Wales | 882554 | 10695 | 0 | 52.1307 | -3.7837 | 2022-08-12 04:20:54 | Wales, United Kingdom | |||
3911689 | 3911689 | 2022-08-11 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-12 04:20:54 | Pitcairn Islands, United Kingdom | ||
1349975 | 1349975 | 2022-08-10 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-11 04:20:49 | Anguilla, United Kingdom | |||
1349976 | 1349976 | 2022-08-10 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-11 04:20:49 | Bermuda, United Kingdom | |||
1349977 | 1349977 | 2022-08-10 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-11 04:20:49 | British Virgin Islands, United Kingdom | |||
1349978 | 1349978 | 2022-08-10 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-11 04:20:49 | Cayman Islands, United Kingdom | |||
1349979 | 1349979 | 2022-08-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-11 04:20:49 | Channel Islands, United Kingdom | |||
1349980 | 1349980 | 2022-08-10 | United Kingdom | England | 19745612 | 174231 | 0 | 52.3555 | -1.1743 | 2022-08-11 04:20:49 | England, United Kingdom | |||
1349981 | 1349981 | 2022-08-10 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-11 04:20:49 | Falkland Islands (Malvinas), United Kingdom | |||
1349982 | 1349982 | 2022-08-10 | United Kingdom | Gibraltar | 19999 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-11 04:20:49 | Gibraltar, United Kingdom | |||
1349983 | 1349983 | 2022-08-10 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-11 04:20:49 | Guernsey, United Kingdom | |||
1349984 | 1349984 | 2022-08-10 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-11 04:20:49 | Isle of Man, United Kingdom | |||
1349985 | 1349985 | 2022-08-10 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-11 04:20:49 | Jersey, United Kingdom | |||
1349986 | 1349986 | 2022-08-10 | United Kingdom | Montserrat | 1077 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-11 04:20:49 | Montserrat, United Kingdom | |||
1349987 | 1349987 | 2022-08-10 | United Kingdom | Northern Ireland | 713294 | 4816 | 0 | 54.7877 | -6.4923 | 2022-08-11 04:20:49 | Northern Ireland, United Kingdom | |||
1349988 | 1349988 | 2022-08-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-11 04:20:49 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1349989 | 1349989 | 2022-08-10 | United Kingdom | Scotland | 2079366 | 15502 | 0 | 56.4907 | -4.2026 | 2022-08-11 04:20:49 | Scotland, United Kingdom | |||
1349990 | 1349990 | 2022-08-10 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-11 04:20:49 | Turks and Caicos Islands, United Kingdom | |||
1349991 | 1349991 | 2022-08-10 | United Kingdom | Unknown | 0 | 313 | 0 | 55.3781 | -3.436 | 2022-08-11 04:20:49 | Unknown, United Kingdom | |||
1349992 | 1349992 | 2022-08-10 | United Kingdom | Wales | 882554 | 10693 | 0 | 52.1307 | -3.7837 | 2022-08-11 04:20:49 | Wales, United Kingdom | |||
1350006 | 1350006 | 2022-08-10 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-11 04:20:49 | Pitcairn Islands, United Kingdom | ||
1089730 | 1089730 | 2022-08-09 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-10 04:20:57 | Anguilla, United Kingdom | |||
1089731 | 1089731 | 2022-08-09 | United Kingdom | Bermuda | 17356 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-10 04:20:57 | Bermuda, United Kingdom | |||
1089732 | 1089732 | 2022-08-09 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-10 04:20:57 | British Virgin Islands, United Kingdom | |||
1089733 | 1089733 | 2022-08-09 | United Kingdom | Cayman Islands | 29419 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-10 04:20:57 | Cayman Islands, United Kingdom | |||
1089734 | 1089734 | 2022-08-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-10 04:20:57 | Channel Islands, United Kingdom | |||
1089735 | 1089735 | 2022-08-09 | United Kingdom | England | 19699384 | 174170 | 0 | 52.3555 | -1.1743 | 2022-08-10 04:20:57 | England, United Kingdom | |||
1089736 | 1089736 | 2022-08-09 | United Kingdom | Falkland Islands (Malvinas) | 1847 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-10 04:20:57 | Falkland Islands (Malvinas), United Kingdom | |||
1089737 | 1089737 | 2022-08-09 | United Kingdom | Gibraltar | 19999 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-10 04:20:57 | Gibraltar, United Kingdom | |||
1089738 | 1089738 | 2022-08-09 | United Kingdom | Guernsey | 30198 | 60 | 0 | 49.448196 | -2.58949 | 2022-08-10 04:20:57 | Guernsey, United Kingdom | |||
1089739 | 1089739 | 2022-08-09 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-10 04:20:57 | Isle of Man, United Kingdom | |||
1089740 | 1089740 | 2022-08-09 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-10 04:20:57 | Jersey, United Kingdom | |||
1089741 | 1089741 | 2022-08-09 | United Kingdom | Montserrat | 1077 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-10 04:20:57 | Montserrat, United Kingdom | |||
1089742 | 1089742 | 2022-08-09 | United Kingdom | Northern Ireland | 713294 | 4813 | 0 | 54.7877 | -6.4923 | 2022-08-10 04:20:57 | Northern Ireland, United Kingdom | |||
1089743 | 1089743 | 2022-08-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-10 04:20:57 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1089744 | 1089744 | 2022-08-09 | United Kingdom | Scotland | 2074217 | 15499 | 0 | 56.4907 | -4.2026 | 2022-08-10 04:20:57 | Scotland, United Kingdom | |||
1089745 | 1089745 | 2022-08-09 | United Kingdom | Turks and Caicos Islands | 6328 | 36 | 0 | 21.694 | -71.7979 | 2022-08-10 04:20:57 | Turks and Caicos Islands, United Kingdom | |||
1089746 | 1089746 | 2022-08-09 | United Kingdom | Unknown | 0 | 312 | 0 | 55.3781 | -3.436 | 2022-08-10 04:20:57 | Unknown, United Kingdom | |||
1089747 | 1089747 | 2022-08-09 | United Kingdom | Wales | 882004 | 10687 | 0 | 52.1307 | -3.7837 | 2022-08-10 04:20:57 | Wales, United Kingdom | |||
1089761 | 1089761 | 2022-08-09 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-08-10 04:20:57 | Pitcairn Islands, United Kingdom | ||
3547145 | 3547145 | 2022-08-08 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-09 04:20:34 | Anguilla, United Kingdom | |||
3547146 | 3547146 | 2022-08-08 | United Kingdom | Bermuda | 17356 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-09 04:20:34 | Bermuda, United Kingdom | |||
3547147 | 3547147 | 2022-08-08 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-09 04:20:34 | British Virgin Islands, United Kingdom | |||
3547148 | 3547148 | 2022-08-08 | United Kingdom | Cayman Islands | 29419 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-09 04:20:34 | Cayman Islands, United Kingdom | |||
3547149 | 3547149 | 2022-08-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-09 04:20:34 | 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]);