johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,986 rows where country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)
province_or_state
- Channel Islands 592
- Gibraltar 592
- Cayman Islands 587
- Montserrat 585
- Bermuda 584
- Isle of Man 583
- Saint Helena, Ascension and Tristan da Cunha 578
- Anguilla 575
- British Virgin Islands 575
- Turks and Caicos Islands 575
- Falkland Islands (Malvinas) 565
- England 500
- Northern Ireland 500
- Scotland 500
- Unknown 500
- Wales 500
- United Kingdom 9
- Falkland Islands (Islas Malvinas) 3
- UK 2
country_or_region
- United Kingdom · 8,986 ✖
| Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35934 | 35934 | 2021-10-23 | United Kingdom | Anguilla | 793 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-24 04:21:22 | Anguilla, United Kingdom | |||
| 35935 | 35935 | 2021-10-23 | United Kingdom | Bermuda | 5612 | 96 | 0 | 32.3078 | -64.7505 | 2021-10-24 04:21:22 | Bermuda, United Kingdom | |||
| 35936 | 35936 | 2021-10-23 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-24 04:21:22 | British Virgin Islands, United Kingdom | |||
| 35937 | 35937 | 2021-10-23 | United Kingdom | Cayman Islands | 1196 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-24 04:21:22 | Cayman Islands, United Kingdom | |||
| 35938 | 35938 | 2021-10-23 | United Kingdom | Channel Islands | 12594 | 102 | 0 | 49.3723 | -2.3644 | 2021-10-24 04:21:22 | Channel Islands, United Kingdom | |||
| 35939 | 35939 | 2021-10-23 | United Kingdom | England | 7430143 | 121700 | 0 | 52.3555 | -1.1743 | 2021-10-24 04:21:22 | England, United Kingdom | |||
| 35940 | 35940 | 2021-10-23 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-24 04:21:22 | Falkland Islands (Malvinas), United Kingdom | |||
| 35941 | 35941 | 2021-10-23 | United Kingdom | Gibraltar | 5858 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-24 04:21:22 | Gibraltar, United Kingdom | |||
| 35942 | 35942 | 2021-10-23 | United Kingdom | Isle of Man | 9107 | 57 | 0 | 54.2361 | -4.5481 | 2021-10-24 04:21:22 | Isle of Man, United Kingdom | |||
| 35943 | 35943 | 2021-10-23 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-24 04:21:22 | Montserrat, United Kingdom | |||
| 35944 | 35944 | 2021-10-23 | United Kingdom | Northern Ireland | 266126 | 2656 | 0 | 54.7877 | -6.4923 | 2021-10-24 04:21:22 | Northern Ireland, United Kingdom | |||
| 35945 | 35945 | 2021-10-23 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-24 04:21:22 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 35946 | 35946 | 2021-10-23 | United Kingdom | Scotland | 622836 | 9031 | 0 | 56.4907 | -4.2026 | 2021-10-24 04:21:22 | Scotland, United Kingdom | |||
| 35947 | 35947 | 2021-10-23 | United Kingdom | Turks and Caicos Islands | 2956 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-24 04:21:22 | Turks and Caicos Islands, United Kingdom | |||
| 35948 | 35948 | 2021-10-23 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-24 04:21:22 | Unknown, United Kingdom | |||||
| 35949 | 35949 | 2021-10-23 | United Kingdom | Wales | 415829 | 6074 | 0 | 52.1307 | -3.7837 | 2021-10-24 04:21:22 | Wales, United Kingdom | |||
| 316418 | 316418 | 2021-10-22 | United Kingdom | Anguilla | 793 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-23 04:21:32 | Anguilla, United Kingdom | |||
| 316419 | 316419 | 2021-10-22 | United Kingdom | Bermuda | 5612 | 96 | 0 | 32.3078 | -64.7505 | 2021-10-23 04:21:32 | Bermuda, United Kingdom | |||
| 316420 | 316420 | 2021-10-22 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-23 04:21:32 | British Virgin Islands, United Kingdom | |||
| 316421 | 316421 | 2021-10-22 | United Kingdom | Cayman Islands | 1165 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-23 04:21:32 | Cayman Islands, United Kingdom | |||
| 316422 | 316422 | 2021-10-22 | United Kingdom | Channel Islands | 12594 | 102 | 0 | 49.3723 | -2.3644 | 2021-10-23 04:21:32 | Channel Islands, United Kingdom | |||
| 316423 | 316423 | 2021-10-22 | United Kingdom | England | 7388884 | 121575 | 0 | 52.3555 | -1.1743 | 2021-10-23 04:21:32 | England, United Kingdom | |||
| 316424 | 316424 | 2021-10-22 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-23 04:21:32 | Falkland Islands (Malvinas), United Kingdom | |||
| 316425 | 316425 | 2021-10-22 | United Kingdom | Gibraltar | 5842 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-23 04:21:32 | Gibraltar, United Kingdom | |||
| 316426 | 316426 | 2021-10-22 | United Kingdom | Isle of Man | 9042 | 57 | 0 | 54.2361 | -4.5481 | 2021-10-23 04:21:32 | Isle of Man, United Kingdom | |||
| 316427 | 316427 | 2021-10-22 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-23 04:21:32 | Montserrat, United Kingdom | |||
| 316428 | 316428 | 2021-10-22 | United Kingdom | Northern Ireland | 264803 | 2646 | 0 | 54.7877 | -6.4923 | 2021-10-23 04:21:32 | Northern Ireland, United Kingdom | |||
| 316429 | 316429 | 2021-10-22 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-23 04:21:32 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 316430 | 316430 | 2021-10-22 | United Kingdom | Scotland | 620433 | 9031 | 0 | 56.4907 | -4.2026 | 2021-10-23 04:21:32 | Scotland, United Kingdom | |||
| 316431 | 316431 | 2021-10-22 | United Kingdom | Turks and Caicos Islands | 2951 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-23 04:21:32 | Turks and Caicos Islands, United Kingdom | |||
| 316432 | 316432 | 2021-10-22 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-23 04:21:32 | Unknown, United Kingdom | |||||
| 316433 | 316433 | 2021-10-22 | United Kingdom | Wales | 415829 | 6074 | 0 | 52.1307 | -3.7837 | 2021-10-23 04:21:32 | Wales, United Kingdom | |||
| 2138440 | 2138440 | 2021-10-21 | United Kingdom | Anguilla | 743 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-22 04:21:14 | Anguilla, United Kingdom | |||
| 2138441 | 2138441 | 2021-10-21 | United Kingdom | Bermuda | 5593 | 95 | 0 | 32.3078 | -64.7505 | 2021-10-22 04:21:14 | Bermuda, United Kingdom | |||
| 2138442 | 2138442 | 2021-10-21 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-22 04:21:14 | British Virgin Islands, United Kingdom | |||
| 2138443 | 2138443 | 2021-10-21 | United Kingdom | Cayman Islands | 1165 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-22 04:21:14 | Cayman Islands, United Kingdom | |||
| 2138444 | 2138444 | 2021-10-21 | United Kingdom | Channel Islands | 12531 | 102 | 0 | 49.3723 | -2.3644 | 2021-10-22 04:21:14 | Channel Islands, United Kingdom | |||
| 2138445 | 2138445 | 2021-10-21 | United Kingdom | England | 7347703 | 121432 | 0 | 52.3555 | -1.1743 | 2021-10-22 04:21:14 | England, United Kingdom | |||
| 2138446 | 2138446 | 2021-10-21 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-22 04:21:14 | Falkland Islands (Malvinas), United Kingdom | |||
| 2138447 | 2138447 | 2021-10-21 | United Kingdom | Gibraltar | 5824 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-22 04:21:14 | Gibraltar, United Kingdom | |||
| 2138448 | 2138448 | 2021-10-21 | United Kingdom | Isle of Man | 8931 | 57 | 0 | 54.2361 | -4.5481 | 2021-10-22 04:21:14 | Isle of Man, United Kingdom | |||
| 2138449 | 2138449 | 2021-10-21 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-22 04:21:14 | Montserrat, United Kingdom | |||
| 2138450 | 2138450 | 2021-10-21 | United Kingdom | Northern Ireland | 263448 | 2639 | 0 | 54.7877 | -6.4923 | 2021-10-22 04:21:14 | Northern Ireland, United Kingdom | |||
| 2138451 | 2138451 | 2021-10-21 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-22 04:21:14 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 2138452 | 2138452 | 2021-10-21 | United Kingdom | Scotland | 617536 | 9012 | 0 | 56.4907 | -4.2026 | 2021-10-22 04:21:14 | Scotland, United Kingdom | |||
| 2138453 | 2138453 | 2021-10-21 | United Kingdom | Turks and Caicos Islands | 2948 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-22 04:21:14 | Turks and Caicos Islands, United Kingdom | |||
| 2138454 | 2138454 | 2021-10-21 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-22 04:21:14 | Unknown, United Kingdom | |||||
| 2138455 | 2138455 | 2021-10-21 | United Kingdom | Wales | 412534 | 6063 | 0 | 52.1307 | -3.7837 | 2021-10-22 04:21:14 | Wales, United Kingdom | |||
| 229759 | 229759 | 2021-10-20 | United Kingdom | Anguilla | 743 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-21 04:21:18 | Anguilla, United Kingdom | |||
| 229760 | 229760 | 2021-10-20 | United Kingdom | Bermuda | 5593 | 95 | 0 | 32.3078 | -64.7505 | 2021-10-21 04:21:18 | Bermuda, United Kingdom | |||
| 229761 | 229761 | 2021-10-20 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-21 04:21:18 | British Virgin Islands, United Kingdom | |||
| 229762 | 229762 | 2021-10-20 | United Kingdom | Cayman Islands | 1136 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-21 04:21:18 | Cayman Islands, United Kingdom | |||
| 229763 | 229763 | 2021-10-20 | United Kingdom | Channel Islands | 12467 | 100 | 0 | 49.3723 | -2.3644 | 2021-10-21 04:21:18 | Channel Islands, United Kingdom | |||
| 229764 | 229764 | 2021-10-20 | United Kingdom | England | 7303864 | 121366 | 0 | 52.3555 | -1.1743 | 2021-10-21 04:21:18 | England, United Kingdom | |||
| 229765 | 229765 | 2021-10-20 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-21 04:21:18 | Falkland Islands (Malvinas), United Kingdom | |||
| 229766 | 229766 | 2021-10-20 | United Kingdom | Gibraltar | 5803 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-21 04:21:18 | Gibraltar, United Kingdom | |||
| 229767 | 229767 | 2021-10-20 | United Kingdom | Isle of Man | 8817 | 56 | 0 | 54.2361 | -4.5481 | 2021-10-21 04:21:18 | Isle of Man, United Kingdom | |||
| 229768 | 229768 | 2021-10-20 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-21 04:21:18 | Montserrat, United Kingdom | |||
| 229769 | 229769 | 2021-10-20 | United Kingdom | Northern Ireland | 262397 | 2635 | 0 | 54.7877 | -6.4923 | 2021-10-21 04:21:18 | Northern Ireland, United Kingdom | |||
| 229770 | 229770 | 2021-10-20 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-21 04:21:18 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 229771 | 229771 | 2021-10-20 | United Kingdom | Scotland | 615182 | 8980 | 0 | 56.4907 | -4.2026 | 2021-10-21 04:21:18 | Scotland, United Kingdom | |||
| 229772 | 229772 | 2021-10-20 | United Kingdom | Turks and Caicos Islands | 2941 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-21 04:21:18 | Turks and Caicos Islands, United Kingdom | |||
| 229773 | 229773 | 2021-10-20 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-21 04:21:18 | Unknown, United Kingdom | |||||
| 229774 | 229774 | 2021-10-20 | United Kingdom | Wales | 408294 | 6050 | 0 | 52.1307 | -3.7837 | 2021-10-21 04:21:18 | Wales, United Kingdom | |||
| 816599 | 816599 | 2021-10-19 | United Kingdom | Anguilla | 698 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-20 04:21:00 | Anguilla, United Kingdom | |||
| 816600 | 816600 | 2021-10-19 | United Kingdom | Bermuda | 5593 | 95 | 0 | 32.3078 | -64.7505 | 2021-10-20 04:21:00 | Bermuda, United Kingdom | |||
| 816601 | 816601 | 2021-10-19 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-20 04:21:00 | British Virgin Islands, United Kingdom | |||
| 816602 | 816602 | 2021-10-19 | United Kingdom | Cayman Islands | 1095 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-20 04:21:00 | Cayman Islands, United Kingdom | |||
| 816603 | 816603 | 2021-10-19 | United Kingdom | Channel Islands | 12413 | 100 | 0 | 49.3723 | -2.3644 | 2021-10-20 04:21:00 | Channel Islands, United Kingdom | |||
| 816604 | 816604 | 2021-10-19 | United Kingdom | England | 7262958 | 121232 | 0 | 52.3555 | -1.1743 | 2021-10-20 04:21:00 | England, United Kingdom | |||
| 816605 | 816605 | 2021-10-19 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-20 04:21:00 | Falkland Islands (Malvinas), United Kingdom | |||
| 816606 | 816606 | 2021-10-19 | United Kingdom | Gibraltar | 5780 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-20 04:21:00 | Gibraltar, United Kingdom | |||
| 816607 | 816607 | 2021-10-19 | United Kingdom | Isle of Man | 8742 | 56 | 0 | 54.2361 | -4.5481 | 2021-10-20 04:21:00 | Isle of Man, United Kingdom | |||
| 816608 | 816608 | 2021-10-19 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-20 04:21:00 | Montserrat, United Kingdom | |||
| 816609 | 816609 | 2021-10-19 | United Kingdom | Northern Ireland | 260974 | 2629 | 0 | 54.7877 | -6.4923 | 2021-10-20 04:21:00 | Northern Ireland, United Kingdom | |||
| 816610 | 816610 | 2021-10-19 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-20 04:21:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 816611 | 816611 | 2021-10-19 | United Kingdom | Scotland | 612416 | 8954 | 0 | 56.4907 | -4.2026 | 2021-10-20 04:21:00 | Scotland, United Kingdom | |||
| 816612 | 816612 | 2021-10-19 | United Kingdom | Turks and Caicos Islands | 2926 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-20 04:21:00 | Turks and Caicos Islands, United Kingdom | |||
| 816613 | 816613 | 2021-10-19 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-20 04:21:00 | Unknown, United Kingdom | |||||
| 816614 | 816614 | 2021-10-19 | United Kingdom | Wales | 404844 | 6037 | 0 | 52.1307 | -3.7837 | 2021-10-20 04:21:00 | Wales, United Kingdom | |||
| 1917120 | 1917120 | 2021-10-18 | United Kingdom | Anguilla | 698 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-19 04:20:54 | Anguilla, United Kingdom | |||
| 1917121 | 1917121 | 2021-10-18 | United Kingdom | Bermuda | 5567 | 95 | 0 | 32.3078 | -64.7505 | 2021-10-19 04:20:54 | Bermuda, United Kingdom | |||
| 1917122 | 1917122 | 2021-10-18 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-19 04:20:54 | British Virgin Islands, United Kingdom | |||
| 1917123 | 1917123 | 2021-10-18 | United Kingdom | Cayman Islands | 1011 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-19 04:20:54 | Cayman Islands, United Kingdom | |||
| 1917124 | 1917124 | 2021-10-18 | United Kingdom | Channel Islands | 12326 | 100 | 0 | 49.3723 | -2.3644 | 2021-10-19 04:20:54 | Channel Islands, United Kingdom | |||
| 1917125 | 1917125 | 2021-10-18 | United Kingdom | England | 7226658 | 121043 | 0 | 52.3555 | -1.1743 | 2021-10-19 04:20:54 | England, United Kingdom | |||
| 1917126 | 1917126 | 2021-10-18 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-19 04:20:54 | Falkland Islands (Malvinas), United Kingdom | |||
| 1917127 | 1917127 | 2021-10-18 | United Kingdom | Gibraltar | 5769 | 98 | 0 | 36.1408 | -5.3536 | 2021-10-19 04:20:54 | Gibraltar, United Kingdom | |||
| 1917128 | 1917128 | 2021-10-18 | United Kingdom | Isle of Man | 8647 | 56 | 0 | 54.2361 | -4.5481 | 2021-10-19 04:20:54 | Isle of Man, United Kingdom | |||
| 1917129 | 1917129 | 2021-10-18 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-19 04:20:54 | Montserrat, United Kingdom | |||
| 1917130 | 1917130 | 2021-10-18 | United Kingdom | Northern Ireland | 259607 | 2621 | 0 | 54.7877 | -6.4923 | 2021-10-19 04:20:54 | Northern Ireland, United Kingdom | |||
| 1917131 | 1917131 | 2021-10-18 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-19 04:20:54 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 1917132 | 1917132 | 2021-10-18 | United Kingdom | Scotland | 609959 | 8930 | 0 | 56.4907 | -4.2026 | 2021-10-19 04:20:54 | Scotland, United Kingdom | |||
| 1917133 | 1917133 | 2021-10-18 | United Kingdom | Turks and Caicos Islands | 2926 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-19 04:20:54 | Turks and Caicos Islands, United Kingdom | |||
| 1917134 | 1917134 | 2021-10-18 | United Kingdom | Unknown | 0 | 0 | 0 | 2021-10-19 04:20:54 | Unknown, United Kingdom | |||||
| 1917135 | 1917135 | 2021-10-18 | United Kingdom | Wales | 401644 | 6035 | 0 | 52.1307 | -3.7837 | 2021-10-19 04:20:54 | Wales, United Kingdom | |||
| 2227750 | 2227750 | 2021-10-17 | United Kingdom | Anguilla | 668 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-18 04:21:10 | Anguilla, United Kingdom | |||
| 2227751 | 2227751 | 2021-10-17 | United Kingdom | Bermuda | 5567 | 95 | 0 | 32.3078 | -64.7505 | 2021-10-18 04:21:10 | Bermuda, United Kingdom | |||
| 2227752 | 2227752 | 2021-10-17 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-18 04:21:10 | British Virgin Islands, United Kingdom | |||
| 2227753 | 2227753 | 2021-10-17 | United Kingdom | Cayman Islands | 1011 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-18 04:21:10 | Cayman 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] INTEGER,
[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]);