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 238
- Guernsey 238
- Jersey 238
- Northern Ireland 238
- Pitcairn Islands 238
- Scotland 238
- Unknown 238
- Wales 238
- Channel Islands 189
- Gibraltar 189
- Cayman Islands 184
- Montserrat 182
- Bermuda 181
- Isle of Man 180
- Saint Helena, Ascension and Tristan da Cunha 175
- Anguilla 172
- British Virgin Islands 172
- Turks and Caicos Islands 172
- Falkland Islands (Malvinas) 162
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 3,865 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2732636 | 2732636 | 2020-09-15 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-16 04:22:53 | Anguilla, United Kingdom | ||
2732637 | 2732637 | 2020-09-15 | United Kingdom | Bermuda | 177 | 9 | 164 | 4 | 32.3078 | -64.7505 | 2020-09-16 04:22:53 | Bermuda, United Kingdom | ||
2732638 | 2732638 | 2020-09-15 | United Kingdom | British Virgin Islands | 66 | 1 | 37 | 28 | 18.4207 | -64.64 | 2020-09-16 04:22:53 | British Virgin Islands, United Kingdom | ||
2732639 | 2732639 | 2020-09-15 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-16 04:22:53 | Cayman Islands, United Kingdom | ||
2732640 | 2732640 | 2020-09-15 | United Kingdom | Channel Islands | 0 | 0 | 575 | 16 | 49.3723 | -2.3644 | 2020-09-16 04:22:53 | Channel Islands, United Kingdom | ||
2732641 | 2732641 | 2020-09-15 | United Kingdom | England | 323029 | 50347 | 0 | 286033 | 52.3555 | -1.1743 | 2020-09-16 04:22:53 | England, United Kingdom | ||
2732642 | 2732642 | 2020-09-15 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-09-16 04:22:53 | Falkland Islands (Malvinas), United Kingdom | ||
2732643 | 2732643 | 2020-09-15 | United Kingdom | Gibraltar | 334 | 0 | 307 | 27 | 36.1408 | -5.3536 | 2020-09-16 04:22:53 | Gibraltar, United Kingdom | ||
2732644 | 2732644 | 2020-09-15 | United Kingdom | Isle of Man | 339 | 24 | 312 | 3 | 54.2361 | -4.5481 | 2020-09-16 04:22:53 | Isle of Man, United Kingdom | ||
2732645 | 2732645 | 2020-09-15 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2020-09-16 04:22:53 | Montserrat, United Kingdom | ||
2732646 | 2732646 | 2020-09-15 | United Kingdom | Northern Ireland | 8502 | 890 | 0 | 7931 | 54.7877 | -6.4923 | 2020-09-16 04:22:53 | Northern Ireland, United Kingdom | ||
2732647 | 2732647 | 2020-09-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-16 04:22:53 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2732648 | 2732648 | 2020-09-15 | United Kingdom | Scotland | 23016 | 4246 | 0 | 20516 | 56.4907 | -4.2026 | 2020-09-16 04:22:53 | Scotland, United Kingdom | ||
2732649 | 2732649 | 2020-09-15 | United Kingdom | Turks and Caicos Islands | 650 | 5 | 557 | 88 | 21.694000000000006 | -71.7979 | 2020-09-16 04:22:53 | Turks and Caicos Islands, United Kingdom | ||
2732650 | 2732650 | 2020-09-15 | United Kingdom | Unknown | 0 | 74 | 0 | 0 | 55.3781 | -3.436 | 2020-09-16 04:22:53 | Unknown, United Kingdom | ||
2732651 | 2732651 | 2020-09-15 | United Kingdom | Wales | 19681 | 2596 | 0 | 18084 | 52.1307 | -3.7837 | 2020-09-16 04:22:53 | Wales, United Kingdom | ||
2732687 | 2732687 | 2020-09-15 | United Kingdom | Jersey | 382 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-09-16 04:22:53 | Jersey, United Kingdom | ||
2732688 | 2732688 | 2020-09-15 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-16 04:22:53 | Guernsey, United Kingdom | ||
2732694 | 2732694 | 2020-09-15 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-16 04:22:53 | Pitcairn Islands, United Kingdom | ||
347908 | 347908 | 2020-09-14 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-15 03:22:50 | Anguilla, United Kingdom | ||
347909 | 347909 | 2020-09-14 | United Kingdom | Bermuda | 177 | 9 | 161 | 7 | 32.3078 | -64.7505 | 2020-09-15 03:22:50 | Bermuda, United Kingdom | ||
347910 | 347910 | 2020-09-14 | United Kingdom | British Virgin Islands | 66 | 1 | 37 | 28 | 18.4207 | -64.64 | 2020-09-15 03:22:50 | British Virgin Islands, United Kingdom | ||
347911 | 347911 | 2020-09-14 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-15 03:22:50 | Cayman Islands, United Kingdom | ||
347912 | 347912 | 2020-09-14 | United Kingdom | Channel Islands | 0 | 0 | 575 | 10 | 49.3723 | -2.3644 | 2020-09-15 03:22:50 | Channel Islands, United Kingdom | ||
347913 | 347913 | 2020-09-14 | United Kingdom | England | 320380 | 50325 | 0 | 283409 | 52.3555 | -1.1743 | 2020-09-15 03:22:50 | England, United Kingdom | ||
347914 | 347914 | 2020-09-14 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-09-15 03:22:50 | Falkland Islands (Malvinas), United Kingdom | ||
347915 | 347915 | 2020-09-14 | United Kingdom | Gibraltar | 330 | 0 | 303 | 27 | 36.1408 | -5.3536 | 2020-09-15 03:22:50 | Gibraltar, United Kingdom | ||
347916 | 347916 | 2020-09-14 | United Kingdom | Isle of Man | 339 | 24 | 312 | 3 | 54.2361 | -4.5481 | 2020-09-15 03:22:50 | Isle of Man, United Kingdom | ||
347917 | 347917 | 2020-09-14 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2020-09-15 03:22:50 | Montserrat, United Kingdom | ||
347918 | 347918 | 2020-09-14 | United Kingdom | Northern Ireland | 8423 | 888 | 0 | 7853 | 54.7877 | -6.4923 | 2020-09-15 03:22:50 | Northern Ireland, United Kingdom | ||
347919 | 347919 | 2020-09-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-15 03:22:50 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
347920 | 347920 | 2020-09-14 | United Kingdom | Scotland | 22749 | 4246 | 0 | 20250 | 56.4907 | -4.2026 | 2020-09-15 03:22:50 | Scotland, United Kingdom | ||
347921 | 347921 | 2020-09-14 | United Kingdom | Turks and Caicos Islands | 648 | 5 | 532 | 111 | 21.694000000000006 | -71.7979 | 2020-09-15 03:22:50 | Turks and Caicos Islands, United Kingdom | ||
347922 | 347922 | 2020-09-14 | United Kingdom | Unknown | 0 | 74 | 0 | 0 | 55.3781 | -3.436 | 2020-09-15 03:22:50 | Unknown, United Kingdom | ||
347923 | 347923 | 2020-09-14 | United Kingdom | Wales | 19573 | 2594 | 0 | 17976 | 52.1307 | -3.7837 | 2020-09-15 03:22:50 | Wales, United Kingdom | ||
347959 | 347959 | 2020-09-14 | United Kingdom | Jersey | 381 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-09-15 03:22:50 | Jersey, United Kingdom | ||
347960 | 347960 | 2020-09-14 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-15 03:22:50 | Guernsey, United Kingdom | ||
347966 | 347966 | 2020-09-14 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-15 03:22:50 | Pitcairn Islands, United Kingdom | ||
2872347 | 2872347 | 2020-09-13 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-14 04:26:00 | Anguilla, United Kingdom | ||
2872348 | 2872348 | 2020-09-13 | United Kingdom | Bermuda | 177 | 9 | 161 | 7 | 32.3078 | -64.7505 | 2020-09-14 04:26:00 | Bermuda, United Kingdom | ||
2872349 | 2872349 | 2020-09-13 | United Kingdom | British Virgin Islands | 66 | 1 | 37 | 28 | 18.4207 | -64.64 | 2020-09-14 04:26:00 | British Virgin Islands, United Kingdom | ||
2872350 | 2872350 | 2020-09-13 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-14 04:26:00 | Cayman Islands, United Kingdom | ||
2872351 | 2872351 | 2020-09-13 | United Kingdom | Channel Islands | 0 | 0 | 575 | 10 | 49.3723 | -2.3644 | 2020-09-14 04:26:00 | Channel Islands, United Kingdom | ||
2872352 | 2872352 | 2020-09-13 | United Kingdom | England | 318121 | 50308 | 0 | 281157 | 52.3555 | -1.1743 | 2020-09-14 04:26:00 | England, United Kingdom | ||
2872353 | 2872353 | 2020-09-13 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-09-14 04:26:00 | Falkland Islands (Malvinas), United Kingdom | ||
2872354 | 2872354 | 2020-09-13 | United Kingdom | Gibraltar | 330 | 0 | 298 | 32 | 36.1408 | -5.3536 | 2020-09-14 04:26:00 | Gibraltar, United Kingdom | ||
2872355 | 2872355 | 2020-09-13 | United Kingdom | Isle of Man | 337 | 24 | 312 | 1 | 54.2361 | -4.5481 | 2020-09-14 04:26:00 | Isle of Man, United Kingdom | ||
2872356 | 2872356 | 2020-09-13 | United Kingdom | Montserrat | 13 | 1 | 11 | 1 | 16.742498 | -62.187366 | 2020-09-14 04:26:00 | Montserrat, United Kingdom | ||
2872357 | 2872357 | 2020-09-13 | United Kingdom | Northern Ireland | 8314 | 887 | 0 | 7746 | 54.7877 | -6.4923 | 2020-09-14 04:26:00 | Northern Ireland, United Kingdom | ||
2872358 | 2872358 | 2020-09-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-14 04:26:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2872359 | 2872359 | 2020-09-13 | United Kingdom | Scotland | 22679 | 4243 | 0 | 20180 | 56.4907 | -4.2026 | 2020-09-14 04:26:00 | Scotland, United Kingdom | ||
2872360 | 2872360 | 2020-09-13 | United Kingdom | Turks and Caicos Islands | 646 | 5 | 532 | 109 | 21.694 | -71.7979 | 2020-09-14 04:26:00 | Turks and Caicos Islands, United Kingdom | ||
2872361 | 2872361 | 2020-09-13 | United Kingdom | Unknown | 0 | 74 | 0 | 0 | 55.3781 | -3.436 | 2020-09-14 04:26:00 | Unknown, United Kingdom | ||
2872362 | 2872362 | 2020-09-13 | United Kingdom | Wales | 19390 | 2594 | 0 | 17793 | 52.1307 | -3.7837 | 2020-09-14 04:26:00 | Wales, United Kingdom | ||
2872398 | 2872398 | 2020-09-13 | United Kingdom | Jersey | 379 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-09-14 04:26:00 | Jersey, United Kingdom | ||
2872399 | 2872399 | 2020-09-13 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-14 04:26:00 | Guernsey, United Kingdom | ||
2872405 | 2872405 | 2020-09-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-14 04:26:00 | Pitcairn Islands, United Kingdom | ||
550386 | 550386 | 2020-09-12 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-13 04:30:52 | Anguilla, United Kingdom | ||
550387 | 550387 | 2020-09-12 | United Kingdom | Bermuda | 177 | 9 | 161 | 7 | 32.3078 | -64.7505 | 2020-09-13 04:30:52 | Bermuda, United Kingdom | ||
550388 | 550388 | 2020-09-12 | United Kingdom | British Virgin Islands | 66 | 1 | 37 | 28 | 18.4207 | -64.64 | 2020-09-13 04:30:52 | British Virgin Islands, United Kingdom | ||
550389 | 550389 | 2020-09-12 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-13 04:30:52 | Cayman Islands, United Kingdom | ||
550390 | 550390 | 2020-09-12 | United Kingdom | Channel Islands | 0 | 0 | 575 | 10 | 49.3723 | -2.3644 | 2020-09-13 04:30:52 | Channel Islands, United Kingdom | ||
550391 | 550391 | 2020-09-12 | United Kingdom | England | 315284 | 50290 | 0 | 278325 | 52.3555 | -1.1743 | 2020-09-13 04:30:52 | England, United Kingdom | ||
550392 | 550392 | 2020-09-12 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-09-13 04:30:52 | Falkland Islands (Malvinas), United Kingdom | ||
550393 | 550393 | 2020-09-12 | United Kingdom | Gibraltar | 327 | 0 | 294 | 33 | 36.1408 | -5.3536 | 2020-09-13 04:30:52 | Gibraltar, United Kingdom | ||
550394 | 550394 | 2020-09-12 | United Kingdom | Isle of Man | 337 | 24 | 312 | 1 | 54.2361 | -4.5481 | 2020-09-13 04:30:52 | Isle of Man, United Kingdom | ||
550395 | 550395 | 2020-09-12 | United Kingdom | Montserrat | 13 | 1 | 11 | 1 | 16.742498 | -62.187366 | 2020-09-13 04:30:52 | Montserrat, United Kingdom | ||
550396 | 550396 | 2020-09-12 | United Kingdom | Northern Ireland | 8227 | 887 | 0 | 7659 | 54.7877 | -6.4923 | 2020-09-13 04:30:52 | Northern Ireland, United Kingdom | ||
550397 | 550397 | 2020-09-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-13 04:30:52 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
550398 | 550398 | 2020-09-12 | United Kingdom | Scotland | 22435 | 4242 | 0 | 19936 | 56.4907 | -4.2026 | 2020-09-13 04:30:52 | Scotland, United Kingdom | ||
550399 | 550399 | 2020-09-12 | United Kingdom | Turks and Caicos Islands | 641 | 5 | 270 | 366 | 21.694000000000006 | -71.7979 | 2020-09-13 04:30:52 | Turks and Caicos Islands, United Kingdom | ||
550400 | 550400 | 2020-09-12 | United Kingdom | Unknown | 0 | 74 | 0 | 0 | 55.3781 | -3.436 | 2020-09-13 04:30:52 | Unknown, United Kingdom | ||
550401 | 550401 | 2020-09-12 | United Kingdom | Wales | 19228 | 2593 | 0 | 17631 | 52.1307 | -3.7837 | 2020-09-13 04:30:52 | Wales, United Kingdom | ||
550437 | 550437 | 2020-09-12 | United Kingdom | Jersey | 378 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-09-13 04:30:52 | Jersey, United Kingdom | ||
550438 | 550438 | 2020-09-12 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-13 04:30:52 | Guernsey, United Kingdom | ||
550444 | 550444 | 2020-09-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-13 04:30:52 | Pitcairn Islands, United Kingdom | ||
1448215 | 1448215 | 2020-09-11 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-12 04:25:05 | Anguilla, United Kingdom | ||
1448216 | 1448216 | 2020-09-11 | United Kingdom | Bermuda | 177 | 9 | 161 | 7 | 32.3078 | -64.7505 | 2020-09-12 04:25:05 | Bermuda, United Kingdom | ||
1448217 | 1448217 | 2020-09-11 | United Kingdom | British Virgin Islands | 63 | 1 | 10 | 52 | 18.4207 | -64.64 | 2020-09-12 04:25:05 | British Virgin Islands, United Kingdom | ||
1448218 | 1448218 | 2020-09-11 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-12 04:25:05 | Cayman Islands, United Kingdom | ||
1448219 | 1448219 | 2020-09-11 | United Kingdom | Channel Islands | 0 | 0 | 575 | 10 | 49.3723 | -2.3644 | 2020-09-12 04:25:05 | Channel Islands, United Kingdom | ||
1448220 | 1448220 | 2020-09-11 | United Kingdom | England | 312276 | 50269 | 0 | 275326 | 52.3555 | -1.1743 | 2020-09-12 04:25:05 | England, United Kingdom | ||
1448221 | 1448221 | 2020-09-11 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-09-12 04:25:05 | Falkland Islands (Malvinas), United Kingdom | ||
1448222 | 1448222 | 2020-09-11 | United Kingdom | Gibraltar | 323 | 0 | 289 | 34 | 36.1408 | -5.3536 | 2020-09-12 04:25:05 | Gibraltar, United Kingdom | ||
1448223 | 1448223 | 2020-09-11 | United Kingdom | Isle of Man | 337 | 24 | 312 | 1 | 54.2361 | -4.5481 | 2020-09-12 04:25:05 | Isle of Man, United Kingdom | ||
1448224 | 1448224 | 2020-09-11 | United Kingdom | Montserrat | 13 | 1 | 11 | 1 | 16.742498 | -62.187366 | 2020-09-12 04:25:05 | Montserrat, United Kingdom | ||
1448225 | 1448225 | 2020-09-11 | United Kingdom | Northern Ireland | 8123 | 887 | 0 | 7555 | 54.7877 | -6.4923 | 2020-09-12 04:25:05 | Northern Ireland, United Kingdom | ||
1448226 | 1448226 | 2020-09-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-12 04:25:05 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1448227 | 1448227 | 2020-09-11 | United Kingdom | Scotland | 22214 | 4240 | 0 | 19715 | 56.4907 | -4.2026 | 2020-09-12 04:25:05 | Scotland, United Kingdom | ||
1448228 | 1448228 | 2020-09-11 | United Kingdom | Turks and Caicos Islands | 641 | 5 | 270 | 366 | 21.694000000000006 | -71.7979 | 2020-09-12 04:25:05 | Turks and Caicos Islands, United Kingdom | ||
1448229 | 1448229 | 2020-09-11 | United Kingdom | Unknown | 0 | 74 | 0 | 0 | 55.3781 | -3.436 | 2020-09-12 04:25:05 | Unknown, United Kingdom | ||
1448230 | 1448230 | 2020-09-11 | United Kingdom | Wales | 19064 | 2593 | 0 | 17467 | 52.1307 | -3.7837 | 2020-09-12 04:25:05 | Wales, United Kingdom | ||
1448266 | 1448266 | 2020-09-11 | United Kingdom | Jersey | 377 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-09-12 04:25:05 | Jersey, United Kingdom | ||
1448267 | 1448267 | 2020-09-11 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-12 04:25:05 | Guernsey, United Kingdom | ||
1448273 | 1448273 | 2020-09-11 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-12 04:25:05 | Pitcairn Islands, United Kingdom | ||
1176816 | 1176816 | 2020-09-10 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-11 04:46:23 | Anguilla, United Kingdom | ||
1176817 | 1176817 | 2020-09-10 | United Kingdom | Bermuda | 177 | 9 | 160 | 8 | 32.3078 | -64.7505 | 2020-09-11 04:46:23 | Bermuda, United Kingdom | ||
1176818 | 1176818 | 2020-09-10 | United Kingdom | British Virgin Islands | 63 | 1 | 10 | 52 | 18.4207 | -64.64 | 2020-09-11 04:46:23 | British Virgin Islands, United Kingdom | ||
1176819 | 1176819 | 2020-09-10 | United Kingdom | Cayman Islands | 208 | 1 | 204 | 3 | 19.3133 | -81.2546 | 2020-09-11 04:46:23 | Cayman Islands, United Kingdom | ||
1176820 | 1176820 | 2020-09-10 | United Kingdom | Channel Islands | 0 | 0 | 575 | 8 | 49.3723 | -2.3644 | 2020-09-11 04:46:23 | 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]);