johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,242 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 358
- Gibraltar 358
- Cayman Islands 353
- Montserrat 351
- Bermuda 350
- Isle of Man 349
- Saint Helena, Ascension and Tristan da Cunha 344
- Anguilla 341
- British Virgin Islands 341
- Turks and Caicos Islands 341
- Falkland Islands (Malvinas) 331
- England 266
- Northern Ireland 266
- Scotland 266
- Unknown 266
- Wales 266
- United Kingdom 9
- Falkland Islands (Islas Malvinas) 3
- UK 2
country_or_region
- United Kingdom · 5,242 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908069 | 908069 | 2021-03-03 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-03-04 05:24:24 | Anguilla, United Kingdom | ||
908070 | 908070 | 2021-03-03 | United Kingdom | Bermuda | 713 | 12 | 682 | 19 | 32.3078 | -64.7505 | 2021-03-04 05:24:24 | Bermuda, United Kingdom | ||
908071 | 908071 | 2021-03-03 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-03-04 05:24:24 | British Virgin Islands, United Kingdom | ||
908072 | 908072 | 2021-03-03 | United Kingdom | Cayman Islands | 447 | 2 | 415 | 30 | 19.3133 | -81.2546 | 2021-03-04 05:24:24 | Cayman Islands, United Kingdom | ||
908073 | 908073 | 2021-03-03 | United Kingdom | Channel Islands | 4040 | 86 | 3944 | 10 | 49.3723 | -2.3644 | 2021-03-04 05:24:24 | Channel Islands, United Kingdom | ||
908074 | 908074 | 2021-03-03 | United Kingdom | England | 3674028 | 108993 | 0 | 3565035 | 52.3555 | -1.1743 | 2021-03-04 05:24:24 | England, United Kingdom | ||
908075 | 908075 | 2021-03-03 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 51 | 3 | -51.7963 | -59.5236 | 2021-03-04 05:24:24 | Falkland Islands (Malvinas), United Kingdom | ||
908076 | 908076 | 2021-03-03 | United Kingdom | Gibraltar | 4243 | 93 | 4127 | 23 | 36.1408 | -5.3536 | 2021-03-04 05:24:24 | Gibraltar, United Kingdom | ||
908077 | 908077 | 2021-03-03 | United Kingdom | Isle of Man | 511 | 25 | 416 | 70 | 54.2361 | -4.5481 | 2021-03-04 05:24:24 | Isle of Man, United Kingdom | ||
908078 | 908078 | 2021-03-03 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-03-04 05:24:24 | Montserrat, United Kingdom | ||
908079 | 908079 | 2021-03-03 | United Kingdom | Northern Ireland | 113006 | 2063 | 0 | 110943 | 54.7877 | -6.4923 | 2021-03-04 05:24:24 | Northern Ireland, United Kingdom | ||
908080 | 908080 | 2021-03-03 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-03-04 05:24:24 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
908081 | 908081 | 2021-03-03 | United Kingdom | Scotland | 203555 | 7371 | 0 | 196184 | 56.4907 | -4.2026 | 2021-03-04 05:24:24 | Scotland, United Kingdom | ||
908082 | 908082 | 2021-03-03 | United Kingdom | Turks and Caicos Islands | 2132 | 14 | 1940 | 178 | 21.694000000000006 | -71.7979 | 2021-03-04 05:24:24 | Turks and Caicos Islands, United Kingdom | ||
908083 | 908083 | 2021-03-03 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-03-04 05:24:24 | Unknown, United Kingdom | ||||
908084 | 908084 | 2021-03-03 | United Kingdom | Wales | 204196 | 5356 | 0 | 198840 | 52.1307 | -3.7837 | 2021-03-04 05:24:24 | Wales, United Kingdom | ||
70450 | 70450 | 2021-03-02 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-03-03 05:23:28 | Anguilla, United Kingdom | ||
70451 | 70451 | 2021-03-02 | United Kingdom | Bermuda | 713 | 12 | 682 | 19 | 32.3078 | -64.7505 | 2021-03-03 05:23:28 | Bermuda, United Kingdom | ||
70452 | 70452 | 2021-03-02 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-03-03 05:23:28 | British Virgin Islands, United Kingdom | ||
70453 | 70453 | 2021-03-02 | United Kingdom | Cayman Islands | 447 | 2 | 415 | 30 | 19.3133 | -81.2546 | 2021-03-03 05:23:28 | Cayman Islands, United Kingdom | ||
70454 | 70454 | 2021-03-02 | United Kingdom | Channel Islands | 4039 | 86 | 3939 | 14 | 49.3723 | -2.3644 | 2021-03-03 05:23:28 | Channel Islands, United Kingdom | ||
70455 | 70455 | 2021-03-02 | United Kingdom | England | 3668620 | 108729 | 0 | 3559891 | 52.3555 | -1.1743 | 2021-03-03 05:23:28 | England, United Kingdom | ||
70456 | 70456 | 2021-03-02 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-03-03 05:23:28 | Falkland Islands (Malvinas), United Kingdom | ||
70457 | 70457 | 2021-03-02 | United Kingdom | Gibraltar | 4243 | 93 | 4127 | 23 | 36.1408 | -5.3536 | 2021-03-03 05:23:28 | Gibraltar, United Kingdom | ||
70458 | 70458 | 2021-03-02 | United Kingdom | Isle of Man | 494 | 25 | 411 | 58 | 54.2361 | -4.5481 | 2021-03-03 05:23:28 | Isle of Man, United Kingdom | ||
70459 | 70459 | 2021-03-02 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-03-03 05:23:28 | Montserrat, United Kingdom | ||
70460 | 70460 | 2021-03-02 | United Kingdom | Northern Ireland | 112780 | 2059 | 0 | 110721 | 54.7877 | -6.4923 | 2021-03-03 05:23:28 | Northern Ireland, United Kingdom | ||
70461 | 70461 | 2021-03-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-03-03 05:23:28 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
70462 | 70462 | 2021-03-02 | United Kingdom | Scotland | 203012 | 7164 | 0 | 195848 | 56.4907 | -4.2026 | 2021-03-03 05:23:28 | Scotland, United Kingdom | ||
70463 | 70463 | 2021-03-02 | United Kingdom | Turks and Caicos Islands | 2115 | 14 | 1876 | 225 | 21.694000000000006 | -71.7979 | 2021-03-03 05:23:28 | Turks and Caicos Islands, United Kingdom | ||
70464 | 70464 | 2021-03-02 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-03-03 05:23:28 | Unknown, United Kingdom | ||||
70465 | 70465 | 2021-03-02 | United Kingdom | Wales | 203988 | 5344 | 0 | 198644 | 52.1307 | -3.7837 | 2021-03-03 05:23:28 | Wales, United Kingdom | ||
1295028 | 1295028 | 2021-03-01 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-03-02 05:23:30 | Anguilla, United Kingdom | ||
1295029 | 1295029 | 2021-03-01 | United Kingdom | Bermuda | 707 | 12 | 682 | 13 | 32.3078 | -64.7505 | 2021-03-02 05:23:30 | Bermuda, United Kingdom | ||
1295030 | 1295030 | 2021-03-01 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-03-02 05:23:30 | British Virgin Islands, United Kingdom | ||
1295031 | 1295031 | 2021-03-01 | United Kingdom | Cayman Islands | 447 | 2 | 415 | 30 | 19.3133 | -81.2546 | 2021-03-02 05:23:30 | Cayman Islands, United Kingdom | ||
1295032 | 1295032 | 2021-03-01 | United Kingdom | Channel Islands | 4038 | 86 | 3928 | 24 | 49.3723 | -2.3644 | 2021-03-02 05:23:30 | Channel Islands, United Kingdom | ||
1295033 | 1295033 | 2021-03-01 | United Kingdom | England | 3663090 | 108422 | 0 | 3554668 | 52.3555 | -1.1743 | 2021-03-02 05:23:30 | England, United Kingdom | ||
1295034 | 1295034 | 2021-03-01 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-03-02 05:23:30 | Falkland Islands (Malvinas), United Kingdom | ||
1295035 | 1295035 | 2021-03-01 | United Kingdom | Gibraltar | 4239 | 93 | 4125 | 21 | 36.1408 | -5.3536 | 2021-03-02 05:23:30 | Gibraltar, United Kingdom | ||
1295036 | 1295036 | 2021-03-01 | United Kingdom | Isle of Man | 486 | 25 | 411 | 50 | 54.2361 | -4.5481 | 2021-03-02 05:23:30 | Isle of Man, United Kingdom | ||
1295037 | 1295037 | 2021-03-01 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-03-02 05:23:30 | Montserrat, United Kingdom | ||
1295038 | 1295038 | 2021-03-01 | United Kingdom | Northern Ireland | 112631 | 2057 | 0 | 110574 | 54.7877 | -6.4923 | 2021-03-02 05:23:30 | Northern Ireland, United Kingdom | ||
1295039 | 1295039 | 2021-03-01 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-03-02 05:23:30 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1295040 | 1295040 | 2021-03-01 | United Kingdom | Scotland | 202470 | 7131 | 0 | 195339 | 56.4907 | -4.2026 | 2021-03-02 05:23:30 | Scotland, United Kingdom | ||
1295041 | 1295041 | 2021-03-01 | United Kingdom | Turks and Caicos Islands | 2114 | 14 | 1873 | 227 | 21.694000000000006 | -71.7979 | 2021-03-02 05:23:30 | Turks and Caicos Islands, United Kingdom | ||
1295042 | 1295042 | 2021-03-01 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-03-02 05:23:30 | Unknown, United Kingdom | ||||
1295043 | 1295043 | 2021-03-01 | United Kingdom | Wales | 203818 | 5343 | 0 | 198475 | 52.1307 | -3.7837 | 2021-03-02 05:23:30 | Wales, United Kingdom | ||
583443 | 583443 | 2021-02-28 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-03-01 05:23:01 | Anguilla, United Kingdom | ||
583444 | 583444 | 2021-02-28 | United Kingdom | Bermuda | 705 | 12 | 682 | 11 | 32.3078 | -64.7505 | 2021-03-01 05:23:01 | Bermuda, United Kingdom | ||
583445 | 583445 | 2021-02-28 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-03-01 05:23:01 | British Virgin Islands, United Kingdom | ||
583446 | 583446 | 2021-02-28 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-03-01 05:23:01 | Cayman Islands, United Kingdom | ||
583447 | 583447 | 2021-02-28 | United Kingdom | Channel Islands | 4038 | 86 | 3928 | 24 | 49.3723 | -2.3644 | 2021-03-01 05:23:01 | Channel Islands, United Kingdom | ||
583448 | 583448 | 2021-02-28 | United Kingdom | England | 3658352 | 108323 | 0 | 3550029 | 52.3555 | -1.1743 | 2021-03-01 05:23:01 | England, United Kingdom | ||
583449 | 583449 | 2021-02-28 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-03-01 05:23:01 | Falkland Islands (Malvinas), United Kingdom | ||
583450 | 583450 | 2021-02-28 | United Kingdom | Gibraltar | 4239 | 93 | 4124 | 22 | 36.1408 | -5.3536 | 2021-03-01 05:23:01 | Gibraltar, United Kingdom | ||
583451 | 583451 | 2021-02-28 | United Kingdom | Isle of Man | 484 | 25 | 411 | 48 | 54.2361 | -4.5481 | 2021-03-01 05:23:01 | Isle of Man, United Kingdom | ||
583452 | 583452 | 2021-02-28 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-03-01 05:23:01 | Montserrat, United Kingdom | ||
583453 | 583453 | 2021-02-28 | United Kingdom | Northern Ireland | 112493 | 2055 | 0 | 110438 | 54.7877 | -6.4923 | 2021-03-01 05:23:01 | Northern Ireland, United Kingdom | ||
583454 | 583454 | 2021-02-28 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-03-01 05:23:01 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
583455 | 583455 | 2021-02-28 | United Kingdom | Scotland | 202084 | 7131 | 0 | 194953 | 56.4907 | -4.2026 | 2021-03-01 05:23:01 | Scotland, United Kingdom | ||
583456 | 583456 | 2021-02-28 | United Kingdom | Turks and Caicos Islands | 2114 | 14 | 1873 | 227 | 21.694000000000006 | -71.7979 | 2021-03-01 05:23:01 | Turks and Caicos Islands, United Kingdom | ||
583457 | 583457 | 2021-02-28 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-03-01 05:23:01 | Unknown, United Kingdom | ||||
583458 | 583458 | 2021-02-28 | United Kingdom | Wales | 203625 | 5340 | 0 | 198285 | 52.1307 | -3.7837 | 2021-03-01 05:23:01 | Wales, United Kingdom | ||
684169 | 684169 | 2021-02-27 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-28 05:22:20 | Anguilla, United Kingdom | ||
684170 | 684170 | 2021-02-27 | United Kingdom | Bermuda | 705 | 12 | 682 | 11 | 32.3078 | -64.7505 | 2021-02-28 05:22:20 | Bermuda, United Kingdom | ||
684171 | 684171 | 2021-02-27 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-02-28 05:22:20 | British Virgin Islands, United Kingdom | ||
684172 | 684172 | 2021-02-27 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-02-28 05:22:20 | Cayman Islands, United Kingdom | ||
684173 | 684173 | 2021-02-27 | United Kingdom | Channel Islands | 4034 | 86 | 3893 | 55 | 49.3723 | -2.3644 | 2021-02-28 05:22:20 | Channel Islands, United Kingdom | ||
684174 | 684174 | 2021-02-27 | United Kingdom | England | 3653272 | 108208 | 0 | 3545064 | 52.3555 | -1.1743 | 2021-02-28 05:22:20 | England, United Kingdom | ||
684175 | 684175 | 2021-02-27 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-02-28 05:22:20 | Falkland Islands (Malvinas), United Kingdom | ||
684176 | 684176 | 2021-02-27 | United Kingdom | Gibraltar | 4238 | 93 | 4122 | 23 | 36.1408 | -5.3536 | 2021-02-28 05:22:20 | Gibraltar, United Kingdom | ||
684177 | 684177 | 2021-02-27 | United Kingdom | Isle of Man | 484 | 25 | 410 | 49 | 54.2361 | -4.5481 | 2021-02-28 05:22:20 | Isle of Man, United Kingdom | ||
684178 | 684178 | 2021-02-27 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-28 05:22:20 | Montserrat, United Kingdom | ||
684179 | 684179 | 2021-02-27 | United Kingdom | Northern Ireland | 112357 | 2052 | 0 | 110305 | 54.7877 | -6.4923 | 2021-02-28 05:22:20 | Northern Ireland, United Kingdom | ||
684180 | 684180 | 2021-02-27 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-28 05:22:20 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
684181 | 684181 | 2021-02-27 | United Kingdom | Scotland | 201512 | 7129 | 0 | 194383 | 56.4907 | -4.2026 | 2021-02-28 05:22:20 | Scotland, United Kingdom | ||
684182 | 684182 | 2021-02-27 | United Kingdom | Turks and Caicos Islands | 2099 | 14 | 1870 | 215 | 21.694000000000006 | -71.7979 | 2021-02-28 05:22:20 | Turks and Caicos Islands, United Kingdom | ||
684183 | 684183 | 2021-02-27 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-02-28 05:22:20 | Unknown, United Kingdom | ||||
684184 | 684184 | 2021-02-27 | United Kingdom | Wales | 203378 | 5316 | 0 | 198062 | 52.1307 | -3.7837 | 2021-02-28 05:22:20 | Wales, United Kingdom | ||
877197 | 877197 | 2021-02-26 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-27 05:22:28 | Anguilla, United Kingdom | ||
877198 | 877198 | 2021-02-26 | United Kingdom | Bermuda | 705 | 12 | 682 | 11 | 32.3078 | -64.7505 | 2021-02-27 05:22:28 | Bermuda, United Kingdom | ||
877199 | 877199 | 2021-02-26 | United Kingdom | British Virgin Islands | 153 | 1 | 131 | 21 | 18.4207 | -64.64 | 2021-02-27 05:22:28 | British Virgin Islands, United Kingdom | ||
877200 | 877200 | 2021-02-26 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-02-27 05:22:28 | Cayman Islands, United Kingdom | ||
877201 | 877201 | 2021-02-26 | United Kingdom | Channel Islands | 4033 | 86 | 3893 | 54 | 49.3723 | -2.3644 | 2021-02-27 05:22:28 | Channel Islands, United Kingdom | ||
877202 | 877202 | 2021-02-26 | United Kingdom | England | 3646745 | 107954 | 0 | 3538791 | 52.3555 | -1.1743 | 2021-02-27 05:22:28 | England, United Kingdom | ||
877203 | 877203 | 2021-02-26 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-02-27 05:22:28 | Falkland Islands (Malvinas), United Kingdom | ||
877204 | 877204 | 2021-02-26 | United Kingdom | Gibraltar | 4236 | 92 | 4122 | 22 | 36.1408 | -5.3536 | 2021-02-27 05:22:28 | Gibraltar, United Kingdom | ||
877205 | 877205 | 2021-02-26 | United Kingdom | Isle of Man | 475 | 25 | 410 | 40 | 54.2361 | -4.5481 | 2021-02-27 05:22:28 | Isle of Man, United Kingdom | ||
877206 | 877206 | 2021-02-26 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-27 05:22:28 | Montserrat, United Kingdom | ||
877207 | 877207 | 2021-02-26 | United Kingdom | Northern Ireland | 112173 | 2050 | 0 | 110123 | 54.7877 | -6.4923 | 2021-02-27 05:22:28 | Northern Ireland, United Kingdom | ||
877208 | 877208 | 2021-02-26 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-27 05:22:28 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
877209 | 877209 | 2021-02-26 | United Kingdom | Scotland | 200987 | 7111 | 0 | 193876 | 56.4907 | -4.2026 | 2021-02-27 05:22:28 | Scotland, United Kingdom | ||
877210 | 877210 | 2021-02-26 | United Kingdom | Turks and Caicos Islands | 2088 | 14 | 1847 | 227 | 21.694000000000006 | -71.7979 | 2021-02-27 05:22:28 | Turks and Caicos Islands, United Kingdom | ||
877211 | 877211 | 2021-02-26 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-02-27 05:22:28 | Unknown, United Kingdom | ||||
877212 | 877212 | 2021-02-26 | United Kingdom | Wales | 203180 | 5300 | 0 | 197880 | 52.1307 | -3.7837 | 2021-02-27 05:22:28 | Wales, United Kingdom | ||
391852 | 391852 | 2021-02-25 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-26 05:22:40 | Anguilla, United Kingdom | ||
391853 | 391853 | 2021-02-25 | United Kingdom | Bermuda | 705 | 12 | 682 | 11 | 32.3078 | -64.7505 | 2021-02-26 05:22:40 | Bermuda, United Kingdom | ||
391854 | 391854 | 2021-02-25 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-26 05:22:40 | British Virgin Islands, United Kingdom | ||
391855 | 391855 | 2021-02-25 | United Kingdom | Cayman Islands | 438 | 2 | 405 | 31 | 19.3133 | -81.2546 | 2021-02-26 05:22:40 | 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]);