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 625
- Guernsey 625
- Jersey 625
- Northern Ireland 625
- Pitcairn Islands 625
- Scotland 625
- Unknown 625
- Wales 625
- Gibraltar 576
- Channel Islands 575
- Cayman Islands 570
- Montserrat 569
- Bermuda 567
- Isle of Man 567
- Saint Helena, Ascension and Tristan da Cunha 562
- Turks and Caicos Islands 559
- Anguilla 558
- British Virgin Islands 558
- Falkland Islands (Malvinas) 549
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 11,213 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
471068 | 471068 | 2021-10-07 | United Kingdom | England | 6845186 | 141522 | 0 | 52.3555 | -1.1743 | 2021-10-08 04:21:25 | England, United Kingdom | |||
471069 | 471069 | 2021-10-07 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-08 04:21:25 | Falkland Islands (Malvinas), United Kingdom | |||
471070 | 471070 | 2021-10-07 | United Kingdom | Gibraltar | 5606 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-08 04:21:25 | Gibraltar, United Kingdom | |||
471071 | 471071 | 2021-10-07 | United Kingdom | Isle of Man | 7899 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-08 04:21:25 | Isle of Man, United Kingdom | |||
471072 | 471072 | 2021-10-07 | United Kingdom | Montserrat | 40 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-08 04:21:25 | Montserrat, United Kingdom | |||
471073 | 471073 | 2021-10-07 | United Kingdom | Northern Ireland | 246156 | 3525 | 0 | 54.7877 | -6.4923 | 2021-10-08 04:21:25 | Northern Ireland, United Kingdom | |||
471074 | 471074 | 2021-10-07 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-08 04:21:25 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
471075 | 471075 | 2021-10-07 | United Kingdom | Scotland | 583019 | 11359 | 0 | 56.4907 | -4.2026 | 2021-10-08 04:21:25 | Scotland, United Kingdom | |||
471076 | 471076 | 2021-10-07 | United Kingdom | Turks and Caicos Islands | 2885 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-08 04:21:25 | Turks and Caicos Islands, United Kingdom | |||
471077 | 471077 | 2021-10-07 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-08 04:21:25 | Unknown, United Kingdom | |||
471078 | 471078 | 2021-10-07 | United Kingdom | Wales | 372029 | 8482 | 0 | 52.1307 | -3.7837 | 2021-10-08 04:21:25 | Wales, United Kingdom | |||
471091 | 471091 | 2021-10-07 | United Kingdom | Jersey | 10128 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-08 04:21:25 | Jersey, United Kingdom | ||
471092 | 471092 | 2021-10-07 | United Kingdom | Guernsey | 1658 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-08 04:21:25 | Guernsey, United Kingdom | ||
471098 | 471098 | 2021-10-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-08 04:21:25 | Pitcairn Islands, United Kingdom | ||
2462443 | 2462443 | 2021-10-06 | United Kingdom | Anguilla | 453 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-07 04:21:36 | Anguilla, United Kingdom | |||
2462444 | 2462444 | 2021-10-06 | United Kingdom | Bermuda | 5455 | 87 | 0 | 32.3078 | -64.7505 | 2021-10-07 04:21:36 | Bermuda, United Kingdom | |||
2462445 | 2462445 | 2021-10-06 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-07 04:21:36 | British Virgin Islands, United Kingdom | |||
2462446 | 2462446 | 2021-10-06 | United Kingdom | Cayman Islands | 920 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-07 04:21:36 | Cayman Islands, United Kingdom | |||
2462447 | 2462447 | 2021-10-06 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-07 04:21:36 | Channel Islands, United Kingdom | |||
2462448 | 2462448 | 2021-10-06 | United Kingdom | England | 6812848 | 141427 | 0 | 52.3555 | -1.1743 | 2021-10-07 04:21:36 | England, United Kingdom | |||
2462449 | 2462449 | 2021-10-06 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-07 04:21:36 | Falkland Islands (Malvinas), United Kingdom | |||
2462450 | 2462450 | 2021-10-06 | United Kingdom | Gibraltar | 5597 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-07 04:21:36 | Gibraltar, United Kingdom | |||
2462451 | 2462451 | 2021-10-06 | United Kingdom | Isle of Man | 7843 | 52 | 0 | 54.2361 | -4.5481 | 2021-10-07 04:21:36 | Isle of Man, United Kingdom | |||
2462452 | 2462452 | 2021-10-06 | United Kingdom | Montserrat | 40 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-07 04:21:36 | Montserrat, United Kingdom | |||
2462453 | 2462453 | 2021-10-06 | United Kingdom | Northern Ireland | 244851 | 3520 | 0 | 54.7877 | -6.4923 | 2021-10-07 04:21:36 | Northern Ireland, United Kingdom | |||
2462454 | 2462454 | 2021-10-06 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-07 04:21:36 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2462455 | 2462455 | 2021-10-06 | United Kingdom | Scotland | 580332 | 11339 | 0 | 56.4907 | -4.2026 | 2021-10-07 04:21:36 | Scotland, United Kingdom | |||
2462456 | 2462456 | 2021-10-06 | United Kingdom | Turks and Caicos Islands | 2884 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-07 04:21:36 | Turks and Caicos Islands, United Kingdom | |||
2462457 | 2462457 | 2021-10-06 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-07 04:21:36 | Unknown, United Kingdom | |||
2462458 | 2462458 | 2021-10-06 | United Kingdom | Wales | 368629 | 8469 | 0 | 52.1307 | -3.7837 | 2021-10-07 04:21:36 | Wales, United Kingdom | |||
2462471 | 2462471 | 2021-10-06 | United Kingdom | Jersey | 10105 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-07 04:21:36 | Jersey, United Kingdom | ||
2462472 | 2462472 | 2021-10-06 | United Kingdom | Guernsey | 1654 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-07 04:21:36 | Guernsey, United Kingdom | ||
2462478 | 2462478 | 2021-10-06 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-07 04:21:36 | Pitcairn Islands, United Kingdom | ||
3836136 | 3836136 | 2021-10-05 | United Kingdom | Anguilla | 453 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-06 04:21:33 | Anguilla, United Kingdom | |||
3836137 | 3836137 | 2021-10-05 | United Kingdom | Bermuda | 5419 | 82 | 0 | 32.3078 | -64.7505 | 2021-10-06 04:21:33 | Bermuda, United Kingdom | |||
3836138 | 3836138 | 2021-10-05 | United Kingdom | British Virgin Islands | 2642 | 37 | 0 | 18.4207 | -64.64 | 2021-10-06 04:21:33 | British Virgin Islands, United Kingdom | |||
3836139 | 3836139 | 2021-10-05 | United Kingdom | Cayman Islands | 920 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-06 04:21:33 | Cayman Islands, United Kingdom | |||
3836140 | 3836140 | 2021-10-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-06 04:21:33 | Channel Islands, United Kingdom | |||
3836141 | 3836141 | 2021-10-05 | United Kingdom | England | 6780567 | 141348 | 0 | 52.3555 | -1.1743 | 2021-10-06 04:21:33 | England, United Kingdom | |||
3836142 | 3836142 | 2021-10-05 | United Kingdom | Falkland Islands (Malvinas) | 67 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-06 04:21:33 | Falkland Islands (Malvinas), United Kingdom | |||
3836143 | 3836143 | 2021-10-05 | United Kingdom | Gibraltar | 5590 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-06 04:21:33 | Gibraltar, United Kingdom | |||
3836144 | 3836144 | 2021-10-05 | United Kingdom | Isle of Man | 7770 | 52 | 0 | 54.2361 | -4.5481 | 2021-10-06 04:21:33 | Isle of Man, United Kingdom | |||
3836145 | 3836145 | 2021-10-05 | United Kingdom | Montserrat | 40 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-06 04:21:33 | Montserrat, United Kingdom | |||
3836146 | 3836146 | 2021-10-05 | United Kingdom | Northern Ireland | 243512 | 3514 | 0 | 54.7877 | -6.4923 | 2021-10-06 04:21:33 | Northern Ireland, United Kingdom | |||
3836147 | 3836147 | 2021-10-05 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-06 04:21:33 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3836148 | 3836148 | 2021-10-05 | United Kingdom | Scotland | 577282 | 11326 | 0 | 56.4907 | -4.2026 | 2021-10-06 04:21:33 | Scotland, United Kingdom | |||
3836149 | 3836149 | 2021-10-05 | United Kingdom | Turks and Caicos Islands | 2875 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-06 04:21:33 | Turks and Caicos Islands, United Kingdom | |||
3836150 | 3836150 | 2021-10-05 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-06 04:21:33 | Unknown, United Kingdom | |||
3836151 | 3836151 | 2021-10-05 | United Kingdom | Wales | 366624 | 8453 | 0 | 52.1307 | -3.7837 | 2021-10-06 04:21:33 | Wales, United Kingdom | |||
3836164 | 3836164 | 2021-10-05 | United Kingdom | Jersey | 10074 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-06 04:21:33 | Jersey, United Kingdom | ||
3836165 | 3836165 | 2021-10-05 | United Kingdom | Guernsey | 1647 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-06 04:21:33 | Guernsey, United Kingdom | ||
3836171 | 3836171 | 2021-10-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-06 04:21:33 | Pitcairn Islands, United Kingdom | ||
990629 | 990629 | 2021-10-04 | United Kingdom | Anguilla | 453 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-05 04:21:27 | Anguilla, United Kingdom | |||
990630 | 990630 | 2021-10-04 | United Kingdom | Bermuda | 5419 | 82 | 0 | 32.3078 | -64.7505 | 2021-10-05 04:21:27 | Bermuda, United Kingdom | |||
990631 | 990631 | 2021-10-04 | United Kingdom | British Virgin Islands | 2642 | 37 | 0 | 18.4207 | -64.64 | 2021-10-05 04:21:27 | British Virgin Islands, United Kingdom | |||
990632 | 990632 | 2021-10-04 | United Kingdom | Cayman Islands | 905 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-05 04:21:27 | Cayman Islands, United Kingdom | |||
990633 | 990633 | 2021-10-04 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-05 04:21:27 | Channel Islands, United Kingdom | |||
990634 | 990634 | 2021-10-04 | United Kingdom | England | 6752536 | 141252 | 0 | 52.3555 | -1.1743 | 2021-10-05 04:21:27 | England, United Kingdom | |||
990635 | 990635 | 2021-10-04 | United Kingdom | Falkland Islands (Malvinas) | 67 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-05 04:21:27 | Falkland Islands (Malvinas), United Kingdom | |||
990636 | 990636 | 2021-10-04 | United Kingdom | Gibraltar | 5579 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-05 04:21:27 | Gibraltar, United Kingdom | |||
990637 | 990637 | 2021-10-04 | United Kingdom | Isle of Man | 7698 | 52 | 0 | 54.2361 | -4.5481 | 2021-10-05 04:21:27 | Isle of Man, United Kingdom | |||
990638 | 990638 | 2021-10-04 | United Kingdom | Montserrat | 34 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-05 04:21:27 | Montserrat, United Kingdom | |||
990639 | 990639 | 2021-10-04 | United Kingdom | Northern Ireland | 242303 | 3511 | 0 | 54.7877 | -6.4923 | 2021-10-05 04:21:27 | Northern Ireland, United Kingdom | |||
990640 | 990640 | 2021-10-04 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-05 04:21:27 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
990641 | 990641 | 2021-10-04 | United Kingdom | Scotland | 575231 | 11298 | 0 | 56.4907 | -4.2026 | 2021-10-05 04:21:27 | Scotland, United Kingdom | |||
990642 | 990642 | 2021-10-04 | United Kingdom | Turks and Caicos Islands | 2868 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-05 04:21:27 | Turks and Caicos Islands, United Kingdom | |||
990643 | 990643 | 2021-10-04 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-05 04:21:27 | Unknown, United Kingdom | |||
990644 | 990644 | 2021-10-04 | United Kingdom | Wales | 364866 | 8445 | 0 | 52.1307 | -3.7837 | 2021-10-05 04:21:27 | Wales, United Kingdom | |||
990657 | 990657 | 2021-10-04 | United Kingdom | Jersey | 10061 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-05 04:21:27 | Jersey, United Kingdom | ||
990658 | 990658 | 2021-10-04 | United Kingdom | Guernsey | 1636 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-05 04:21:27 | Guernsey, United Kingdom | ||
990664 | 990664 | 2021-10-04 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-05 04:21:27 | Pitcairn Islands, United Kingdom | ||
1277939 | 1277939 | 2021-10-03 | United Kingdom | Anguilla | 425 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-04 04:21:31 | Anguilla, United Kingdom | |||
1277940 | 1277940 | 2021-10-03 | United Kingdom | Bermuda | 5336 | 75 | 0 | 32.3078 | -64.7505 | 2021-10-04 04:21:31 | Bermuda, United Kingdom | |||
1277941 | 1277941 | 2021-10-03 | United Kingdom | British Virgin Islands | 2642 | 37 | 0 | 18.4207 | -64.64 | 2021-10-04 04:21:31 | British Virgin Islands, United Kingdom | |||
1277942 | 1277942 | 2021-10-03 | United Kingdom | Cayman Islands | 853 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-04 04:21:31 | Cayman Islands, United Kingdom | |||
1277943 | 1277943 | 2021-10-03 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-04 04:21:31 | Channel Islands, United Kingdom | |||
1277944 | 1277944 | 2021-10-03 | United Kingdom | England | 6725105 | 141168 | 0 | 52.3555 | -1.1743 | 2021-10-04 04:21:31 | England, United Kingdom | |||
1277945 | 1277945 | 2021-10-03 | United Kingdom | Falkland Islands (Malvinas) | 67 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-04 04:21:31 | Falkland Islands (Malvinas), United Kingdom | |||
1277946 | 1277946 | 2021-10-03 | United Kingdom | Gibraltar | 5573 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-04 04:21:31 | Gibraltar, United Kingdom | |||
1277947 | 1277947 | 2021-10-03 | United Kingdom | Isle of Man | 7671 | 52 | 0 | 54.2361 | -4.5481 | 2021-10-04 04:21:31 | Isle of Man, United Kingdom | |||
1277948 | 1277948 | 2021-10-03 | United Kingdom | Montserrat | 34 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-04 04:21:31 | Montserrat, United Kingdom | |||
1277949 | 1277949 | 2021-10-03 | United Kingdom | Northern Ireland | 241223 | 3506 | 0 | 54.7877 | -6.4923 | 2021-10-04 04:21:31 | Northern Ireland, United Kingdom | |||
1277950 | 1277950 | 2021-10-03 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-04 04:21:31 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1277951 | 1277951 | 2021-10-03 | United Kingdom | Scotland | 573471 | 11282 | 0 | 56.4907 | -4.2026 | 2021-10-04 04:21:31 | Scotland, United Kingdom | |||
1277952 | 1277952 | 2021-10-03 | United Kingdom | Turks and Caicos Islands | 2868 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-04 04:21:31 | Turks and Caicos Islands, United Kingdom | |||
1277953 | 1277953 | 2021-10-03 | United Kingdom | Unknown | 0 | 221 | 0 | 55.3781 | -3.436 | 2021-10-04 04:21:31 | Unknown, United Kingdom | |||
1277954 | 1277954 | 2021-10-03 | United Kingdom | Wales | 360881 | 8437 | 0 | 52.1307 | -3.7837 | 2021-10-04 04:21:31 | Wales, United Kingdom | |||
1277967 | 1277967 | 2021-10-03 | United Kingdom | Jersey | 10051 | 78 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-04 04:21:31 | Jersey, United Kingdom | ||
1277968 | 1277968 | 2021-10-03 | United Kingdom | Guernsey | 1631 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-04 04:21:31 | Guernsey, United Kingdom | ||
1277974 | 1277974 | 2021-10-03 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-04 04:21:31 | Pitcairn Islands, United Kingdom | ||
3931692 | 3931692 | 2021-10-02 | United Kingdom | Anguilla | 425 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-03 04:21:24 | Anguilla, United Kingdom | |||
3931693 | 3931693 | 2021-10-02 | United Kingdom | Bermuda | 5336 | 75 | 0 | 32.3078 | -64.7505 | 2021-10-03 04:21:24 | Bermuda, United Kingdom | |||
3931694 | 3931694 | 2021-10-02 | United Kingdom | British Virgin Islands | 2642 | 37 | 0 | 18.4207 | -64.64 | 2021-10-03 04:21:24 | British Virgin Islands, United Kingdom | |||
3931695 | 3931695 | 2021-10-02 | United Kingdom | Cayman Islands | 853 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-03 04:21:24 | Cayman Islands, United Kingdom | |||
3931696 | 3931696 | 2021-10-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-03 04:21:24 | Channel Islands, United Kingdom | |||
3931697 | 3931697 | 2021-10-02 | United Kingdom | England | 6700702 | 141090 | 0 | 52.3555 | -1.1743 | 2021-10-03 04:21:24 | England, United Kingdom | |||
3931698 | 3931698 | 2021-10-02 | United Kingdom | Falkland Islands (Malvinas) | 67 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-03 04:21:24 | Falkland Islands (Malvinas), United Kingdom | |||
3931699 | 3931699 | 2021-10-02 | United Kingdom | Gibraltar | 5566 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-03 04:21:24 | Gibraltar, United Kingdom | |||
3931700 | 3931700 | 2021-10-02 | United Kingdom | Isle of Man | 7634 | 52 | 0 | 54.2361 | -4.5481 | 2021-10-03 04:21:24 | Isle of Man, United Kingdom | |||
3931701 | 3931701 | 2021-10-02 | United Kingdom | Montserrat | 34 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-03 04:21:24 | Montserrat, 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]);