johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15,650 rows where country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key, day (date), last_update (date)
province_or_state 21
- Guernsey 940
- Jersey 940
- Channel Islands 891
- Gibraltar 891
- Cayman Islands 886
- Montserrat 884
- Bermuda 883
- Isle of Man 882
- Saint Helena, Ascension and Tristan da Cunha 877
- Anguilla 874
- British Virgin Islands 874
- Turks and Caicos Islands 874
- Falkland Islands (Malvinas) 864
- England 799
- Northern Ireland 799
- Scotland 799
- Unknown 799
- Wales 799
- United Kingdom 9
- Falkland Islands (Islas Malvinas) 3
- UK 2
country_or_region 1
- United Kingdom · 15,650 ✖
| Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 651232 | 651232 | 2022-08-18 | United Kingdom | Anguilla | 3746 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-19 04:20:54 | Anguilla, United Kingdom | |||
| 651233 | 651233 | 2022-08-18 | United Kingdom | Bermuda | 17674 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-19 04:20:54 | Bermuda, United Kingdom | |||
| 651234 | 651234 | 2022-08-18 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-19 04:20:54 | British Virgin Islands, United Kingdom | |||
| 651235 | 651235 | 2022-08-18 | United Kingdom | Cayman Islands | 29907 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-19 04:20:54 | Cayman Islands, United Kingdom | |||
| 651236 | 651236 | 2022-08-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-19 04:20:54 | Channel Islands, United Kingdom | |||
| 651237 | 651237 | 2022-08-18 | United Kingdom | England | 19780734 | 163445 | 0 | 52.3555 | -1.1743 | 2022-08-19 04:20:54 | England, United Kingdom | |||
| 651238 | 651238 | 2022-08-18 | United Kingdom | Falkland Islands (Malvinas) | 1881 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-19 04:20:54 | Falkland Islands (Malvinas), United Kingdom | |||
| 651239 | 651239 | 2022-08-18 | United Kingdom | Gibraltar | 20049 | 107 | 0 | 36.1408 | -5.3536 | 2022-08-19 04:20:54 | Gibraltar, United Kingdom | |||
| 651240 | 651240 | 2022-08-18 | United Kingdom | Guernsey | 30519 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-19 04:20:54 | Guernsey, United Kingdom | |||
| 651241 | 651241 | 2022-08-18 | United Kingdom | Isle of Man | 37794 | 115 | 0 | 54.2361 | -4.5481 | 2022-08-19 04:20:54 | Isle of Man, United Kingdom | |||
| 651242 | 651242 | 2022-08-18 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-19 04:20:54 | Jersey, United Kingdom | |||
| 651243 | 651243 | 2022-08-18 | United Kingdom | Montserrat | 1106 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-19 04:20:54 | Montserrat, United Kingdom | |||
| 651244 | 651244 | 2022-08-18 | United Kingdom | Northern Ireland | 713294 | 3445 | 0 | 54.7877 | -6.4923 | 2022-08-19 04:20:54 | Northern Ireland, United Kingdom | |||
| 651245 | 651245 | 2022-08-18 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-19 04:20:54 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 651246 | 651246 | 2022-08-18 | United Kingdom | Scotland | 2083741 | 12389 | 0 | 56.4907 | -4.2026 | 2022-08-19 04:20:54 | Scotland, United Kingdom | |||
| 651247 | 651247 | 2022-08-18 | United Kingdom | Turks and Caicos Islands | 6351 | 36 | 0 | 21.694 | -71.7979 | 2022-08-19 04:20:54 | Turks and Caicos Islands, United Kingdom | |||
| 651248 | 651248 | 2022-08-18 | United Kingdom | Unknown | 0 | 0 | 0 | 2022-08-19 04:20:54 | Unknown, United Kingdom | |||||
| 651249 | 651249 | 2022-08-18 | United Kingdom | Wales | 883018 | 7739 | 0 | 52.1307 | -3.7837 | 2022-08-19 04:20:54 | Wales, United Kingdom | |||
| 2710004 | 2710004 | 2022-08-17 | United Kingdom | Anguilla | 3746 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-18 04:21:11 | Anguilla, United Kingdom | |||
| 2710005 | 2710005 | 2022-08-17 | United Kingdom | Bermuda | 17674 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-18 04:21:11 | Bermuda, United Kingdom | |||
| 2710006 | 2710006 | 2022-08-17 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-18 04:21:11 | British Virgin Islands, United Kingdom | |||
| 2710007 | 2710007 | 2022-08-17 | United Kingdom | Cayman Islands | 29907 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-18 04:21:11 | Cayman Islands, United Kingdom | |||
| 2710008 | 2710008 | 2022-08-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-18 04:21:11 | Channel Islands, United Kingdom | |||
| 2710009 | 2710009 | 2022-08-17 | United Kingdom | England | 19780734 | 163445 | 0 | 52.3555 | -1.1743 | 2022-08-18 04:21:11 | England, United Kingdom | |||
| 2710010 | 2710010 | 2022-08-17 | United Kingdom | Falkland Islands (Malvinas) | 1881 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-18 04:21:11 | Falkland Islands (Malvinas), United Kingdom | |||
| 2710011 | 2710011 | 2022-08-17 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-18 04:21:11 | Gibraltar, United Kingdom | |||
| 2710012 | 2710012 | 2022-08-17 | United Kingdom | Guernsey | 30519 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-18 04:21:11 | Guernsey, United Kingdom | |||
| 2710013 | 2710013 | 2022-08-17 | United Kingdom | Isle of Man | 37794 | 115 | 0 | 54.2361 | -4.5481 | 2022-08-18 04:21:11 | Isle of Man, United Kingdom | |||
| 2710014 | 2710014 | 2022-08-17 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-18 04:21:11 | Jersey, United Kingdom | |||
| 2710015 | 2710015 | 2022-08-17 | United Kingdom | Montserrat | 1106 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-18 04:21:11 | Montserrat, United Kingdom | |||
| 2710016 | 2710016 | 2022-08-17 | United Kingdom | Northern Ireland | 713294 | 3445 | 0 | 54.7877 | -6.4923 | 2022-08-18 04:21:11 | Northern Ireland, United Kingdom | |||
| 2710017 | 2710017 | 2022-08-17 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-18 04:21:11 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 2710018 | 2710018 | 2022-08-17 | United Kingdom | Scotland | 2083741 | 12389 | 0 | 56.4907 | -4.2026 | 2022-08-18 04:21:11 | Scotland, United Kingdom | |||
| 2710019 | 2710019 | 2022-08-17 | United Kingdom | Turks and Caicos Islands | 6351 | 36 | 0 | 21.694 | -71.7979 | 2022-08-18 04:21:11 | Turks and Caicos Islands, United Kingdom | |||
| 2710020 | 2710020 | 2022-08-17 | United Kingdom | Unknown | 0 | 0 | 0 | 2022-08-18 04:21:11 | Unknown, United Kingdom | |||||
| 2710021 | 2710021 | 2022-08-17 | United Kingdom | Wales | 883018 | 7739 | 0 | 52.1307 | -3.7837 | 2022-08-18 04:21:11 | Wales, United Kingdom | |||
| 2399671 | 2399671 | 2022-08-16 | United Kingdom | Anguilla | 3746 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-17 04:20:59 | Anguilla, United Kingdom | |||
| 2399672 | 2399672 | 2022-08-16 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-17 04:20:59 | Bermuda, United Kingdom | |||
| 2399673 | 2399673 | 2022-08-16 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-17 04:20:59 | British Virgin Islands, United Kingdom | |||
| 2399674 | 2399674 | 2022-08-16 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-17 04:20:59 | Cayman Islands, United Kingdom | |||
| 2399675 | 2399675 | 2022-08-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-17 04:20:59 | Channel Islands, United Kingdom | |||
| 2399676 | 2399676 | 2022-08-16 | United Kingdom | England | 19745612 | 162550 | 0 | 52.3555 | -1.1743 | 2022-08-17 04:20:59 | England, United Kingdom | |||
| 2399677 | 2399677 | 2022-08-16 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-17 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
| 2399678 | 2399678 | 2022-08-16 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-17 04:20:59 | Gibraltar, United Kingdom | |||
| 2399679 | 2399679 | 2022-08-16 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-17 04:20:59 | Guernsey, United Kingdom | |||
| 2399680 | 2399680 | 2022-08-16 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-17 04:20:59 | Isle of Man, United Kingdom | |||
| 2399681 | 2399681 | 2022-08-16 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-17 04:20:59 | Jersey, United Kingdom | |||
| 2399682 | 2399682 | 2022-08-16 | United Kingdom | Montserrat | 1097 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-17 04:20:59 | Montserrat, United Kingdom | |||
| 2399683 | 2399683 | 2022-08-16 | United Kingdom | Northern Ireland | 713294 | 3445 | 0 | 54.7877 | -6.4923 | 2022-08-17 04:20:59 | Northern Ireland, United Kingdom | |||
| 2399684 | 2399684 | 2022-08-16 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-17 04:20:59 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 2399685 | 2399685 | 2022-08-16 | United Kingdom | Scotland | 2079366 | 12389 | 0 | 56.4907 | -4.2026 | 2022-08-17 04:20:59 | Scotland, United Kingdom | |||
| 2399686 | 2399686 | 2022-08-16 | United Kingdom | Turks and Caicos Islands | 6351 | 36 | 0 | 21.694 | -71.7979 | 2022-08-17 04:20:59 | Turks and Caicos Islands, United Kingdom | |||
| 2399687 | 2399687 | 2022-08-16 | United Kingdom | Unknown | 0 | 0 | 0 | 2022-08-17 04:20:59 | Unknown, United Kingdom | |||||
| 2399688 | 2399688 | 2022-08-16 | United Kingdom | Wales | 882554 | 7703 | 0 | 52.1307 | -3.7837 | 2022-08-17 04:20:59 | Wales, United Kingdom | |||
| 2360383 | 2360383 | 2022-08-15 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-16 04:20:58 | Anguilla, United Kingdom | |||
| 2360384 | 2360384 | 2022-08-15 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-16 04:20:58 | Bermuda, United Kingdom | |||
| 2360385 | 2360385 | 2022-08-15 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-16 04:20:58 | British Virgin Islands, United Kingdom | |||
| 2360386 | 2360386 | 2022-08-15 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-16 04:20:58 | Cayman Islands, United Kingdom | |||
| 2360387 | 2360387 | 2022-08-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-16 04:20:58 | Channel Islands, United Kingdom | |||
| 2360388 | 2360388 | 2022-08-15 | United Kingdom | England | 19745612 | 162550 | 0 | 52.3555 | -1.1743 | 2022-08-16 04:20:58 | England, United Kingdom | |||
| 2360389 | 2360389 | 2022-08-15 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-16 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
| 2360390 | 2360390 | 2022-08-15 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-16 04:20:58 | Gibraltar, United Kingdom | |||
| 2360391 | 2360391 | 2022-08-15 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-16 04:20:58 | Guernsey, United Kingdom | |||
| 2360392 | 2360392 | 2022-08-15 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-16 04:20:58 | Isle of Man, United Kingdom | |||
| 2360393 | 2360393 | 2022-08-15 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-16 04:20:58 | Jersey, United Kingdom | |||
| 2360394 | 2360394 | 2022-08-15 | United Kingdom | Montserrat | 1097 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-16 04:20:58 | Montserrat, United Kingdom | |||
| 2360395 | 2360395 | 2022-08-15 | United Kingdom | Northern Ireland | 713294 | 3445 | 0 | 54.7877 | -6.4923 | 2022-08-16 04:20:58 | Northern Ireland, United Kingdom | |||
| 2360396 | 2360396 | 2022-08-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-16 04:20:58 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 2360397 | 2360397 | 2022-08-15 | United Kingdom | Scotland | 2079366 | 12389 | 0 | 56.4907 | -4.2026 | 2022-08-16 04:20:58 | Scotland, United Kingdom | |||
| 2360398 | 2360398 | 2022-08-15 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-16 04:20:58 | Turks and Caicos Islands, United Kingdom | |||
| 2360399 | 2360399 | 2022-08-15 | United Kingdom | Unknown | 0 | 0 | 0 | 2022-08-16 04:20:58 | Unknown, United Kingdom | |||||
| 2360400 | 2360400 | 2022-08-15 | United Kingdom | Wales | 882554 | 7703 | 0 | 52.1307 | -3.7837 | 2022-08-16 04:20:58 | Wales, United Kingdom | |||
| 1838851 | 1838851 | 2022-08-14 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-15 04:20:59 | Anguilla, United Kingdom | |||
| 1838852 | 1838852 | 2022-08-14 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-15 04:20:59 | Bermuda, United Kingdom | |||
| 1838853 | 1838853 | 2022-08-14 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-08-15 04:20:59 | British Virgin Islands, United Kingdom | |||
| 1838854 | 1838854 | 2022-08-14 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-15 04:20:59 | Cayman Islands, United Kingdom | |||
| 1838855 | 1838855 | 2022-08-14 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-15 04:20:59 | Channel Islands, United Kingdom | |||
| 1838856 | 1838856 | 2022-08-14 | United Kingdom | England | 19745612 | 162550 | 0 | 52.3555 | -1.1743 | 2022-08-15 04:20:59 | England, United Kingdom | |||
| 1838857 | 1838857 | 2022-08-14 | United Kingdom | Falkland Islands (Malvinas) | 1867 | 0 | 0 | -51.7963 | -59.5236 | 2022-08-15 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
| 1838858 | 1838858 | 2022-08-14 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-15 04:20:59 | Gibraltar, United Kingdom | |||
| 1838859 | 1838859 | 2022-08-14 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-15 04:20:59 | Guernsey, United Kingdom | |||
| 1838860 | 1838860 | 2022-08-14 | United Kingdom | Isle of Man | 37794 | 114 | 0 | 54.2361 | -4.5481 | 2022-08-15 04:20:59 | Isle of Man, United Kingdom | |||
| 1838861 | 1838861 | 2022-08-14 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-15 04:20:59 | Jersey, United Kingdom | |||
| 1838862 | 1838862 | 2022-08-14 | United Kingdom | Montserrat | 1097 | 8 | 0 | 16.742498 | -62.187366 | 2022-08-15 04:20:59 | Montserrat, United Kingdom | |||
| 1838863 | 1838863 | 2022-08-14 | United Kingdom | Northern Ireland | 713294 | 3445 | 0 | 54.7877 | -6.4923 | 2022-08-15 04:20:59 | Northern Ireland, United Kingdom | |||
| 1838864 | 1838864 | 2022-08-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-08-15 04:20:59 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
| 1838865 | 1838865 | 2022-08-14 | United Kingdom | Scotland | 2079366 | 12389 | 0 | 56.4907 | -4.2026 | 2022-08-15 04:20:59 | Scotland, United Kingdom | |||
| 1838866 | 1838866 | 2022-08-14 | United Kingdom | Turks and Caicos Islands | 6338 | 36 | 0 | 21.694 | -71.7979 | 2022-08-15 04:20:59 | Turks and Caicos Islands, United Kingdom | |||
| 1838867 | 1838867 | 2022-08-14 | United Kingdom | Unknown | 0 | 0 | 0 | 2022-08-15 04:20:59 | Unknown, United Kingdom | |||||
| 1838868 | 1838868 | 2022-08-14 | United Kingdom | Wales | 882554 | 7703 | 0 | 52.1307 | -3.7837 | 2022-08-15 04:20:59 | Wales, United Kingdom | |||
| 1612737 | 1612737 | 2022-08-13 | United Kingdom | Anguilla | 3620 | 10 | 0 | 18.2206 | -63.0686 | 2022-08-14 04:20:55 | Anguilla, United Kingdom | |||
| 1612738 | 1612738 | 2022-08-13 | United Kingdom | Bermuda | 17556 | 148 | 0 | 32.3078 | -64.7505 | 2022-08-14 04:20:55 | Bermuda, United Kingdom | |||
| 1612739 | 1612739 | 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 | |||
| 1612740 | 1612740 | 2022-08-13 | United Kingdom | Cayman Islands | 29653 | 29 | 0 | 19.3133 | -81.2546 | 2022-08-14 04:20:55 | Cayman Islands, United Kingdom | |||
| 1612741 | 1612741 | 2022-08-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-08-14 04:20:55 | Channel Islands, United Kingdom | |||
| 1612742 | 1612742 | 2022-08-13 | United Kingdom | England | 19745612 | 162550 | 0 | 52.3555 | -1.1743 | 2022-08-14 04:20:55 | England, United Kingdom | |||
| 1612743 | 1612743 | 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 | |||
| 1612744 | 1612744 | 2022-08-13 | United Kingdom | Gibraltar | 20034 | 106 | 0 | 36.1408 | -5.3536 | 2022-08-14 04:20:55 | Gibraltar, United Kingdom | |||
| 1612745 | 1612745 | 2022-08-13 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-14 04:20:55 | Guernsey, United Kingdom | |||
| 1612746 | 1612746 | 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 |
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]);