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 401
- Guernsey 401
- Jersey 401
- Northern Ireland 401
- Pitcairn Islands 401
- Scotland 401
- Unknown 401
- Wales 401
- Channel Islands 352
- Gibraltar 352
- Cayman Islands 347
- Montserrat 345
- Bermuda 344
- Isle of Man 343
- Saint Helena, Ascension and Tristan da Cunha 338
- Anguilla 335
- British Virgin Islands 335
- Turks and Caicos Islands 335
- Falkland Islands (Malvinas) 325
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 6,962 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1861647 | 1861647 | 2021-02-25 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-26 05:22:40 | Anguilla, United Kingdom | ||
1861648 | 1861648 | 2021-02-25 | United Kingdom | Bermuda | 705 | 12 | 682 | 11 | 32.3078 | -64.7505 | 2021-02-26 05:22:40 | Bermuda, United Kingdom | ||
1861649 | 1861649 | 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 | ||
1861650 | 1861650 | 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 | ||
1861651 | 1861651 | 2021-02-25 | United Kingdom | Channel Islands | 0 | 0 | 3893 | 53 | 49.3723 | -2.3644 | 2021-02-26 05:22:40 | Channel Islands, United Kingdom | ||
1861652 | 1861652 | 2021-02-25 | United Kingdom | England | 3639352 | 127225 | 0 | 3531698 | 52.3555 | -1.1743 | 2021-02-26 05:22:40 | England, United Kingdom | ||
1861653 | 1861653 | 2021-02-25 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-02-26 05:22:40 | Falkland Islands (Malvinas), United Kingdom | ||
1861654 | 1861654 | 2021-02-25 | United Kingdom | Gibraltar | 4235 | 92 | 4119 | 24 | 36.1408 | -5.3536 | 2021-02-26 05:22:40 | Gibraltar, United Kingdom | ||
1861655 | 1861655 | 2021-02-25 | United Kingdom | Isle of Man | 475 | 25 | 410 | 40 | 54.2361 | -4.5481 | 2021-02-26 05:22:40 | Isle of Man, United Kingdom | ||
1861656 | 1861656 | 2021-02-25 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-26 05:22:40 | Montserrat, United Kingdom | ||
1861657 | 1861657 | 2021-02-25 | United Kingdom | Northern Ireland | 111932 | 2825 | 0 | 109884 | 54.7877 | -6.4923 | 2021-02-26 05:22:40 | Northern Ireland, United Kingdom | ||
1861658 | 1861658 | 2021-02-25 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-26 05:22:40 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1861659 | 1861659 | 2021-02-25 | United Kingdom | Scotland | 200406 | 9642 | 0 | 193322 | 56.4907 | -4.2026 | 2021-02-26 05:22:40 | Scotland, United Kingdom | ||
1861660 | 1861660 | 2021-02-25 | United Kingdom | Turks and Caicos Islands | 2070 | 14 | 1819 | 237 | 21.694000000000006 | -71.7979 | 2021-02-26 05:22:40 | Turks and Caicos Islands, United Kingdom | ||
1861661 | 1861661 | 2021-02-25 | United Kingdom | Unknown | 0 | 171 | 0 | 0 | 55.3781 | -3.436 | 2021-02-26 05:22:40 | Unknown, United Kingdom | ||
1861662 | 1861662 | 2021-02-25 | United Kingdom | Wales | 202872 | 7644 | 0 | 197588 | 52.1307 | -3.7837 | 2021-02-26 05:22:40 | Wales, United Kingdom | ||
1861698 | 1861698 | 2021-02-25 | United Kingdom | Jersey | 3211 | 68 | 0 | 0 | 49.2138 | -2.1358 | 2021-02-26 05:22:40 | Jersey, United Kingdom | ||
1861699 | 1861699 | 2021-02-25 | United Kingdom | Guernsey | 818 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-02-26 05:22:40 | Guernsey, United Kingdom | ||
1861705 | 1861705 | 2021-02-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-26 05:22:40 | Pitcairn Islands, United Kingdom | ||
283825 | 283825 | 2021-02-24 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-25 05:24:57 | Anguilla, United Kingdom | ||
283826 | 283826 | 2021-02-24 | United Kingdom | Bermuda | 703 | 12 | 681 | 10 | 32.3078 | -64.7505 | 2021-02-25 05:24:57 | Bermuda, United Kingdom | ||
283827 | 283827 | 2021-02-24 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-25 05:24:57 | British Virgin Islands, United Kingdom | ||
283828 | 283828 | 2021-02-24 | United Kingdom | Cayman Islands | 431 | 2 | 405 | 24 | 19.3133 | -81.2546 | 2021-02-25 05:24:57 | Cayman Islands, United Kingdom | ||
283829 | 283829 | 2021-02-24 | United Kingdom | Channel Islands | 0 | 0 | 3893 | 52 | 49.3723 | -2.3644 | 2021-02-25 05:24:57 | Channel Islands, United Kingdom | ||
283830 | 283830 | 2021-02-24 | United Kingdom | England | 3630729 | 126917 | 0 | 3523341 | 52.3555 | -1.1743 | 2021-02-25 05:24:57 | England, United Kingdom | ||
283831 | 283831 | 2021-02-24 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-02-25 05:24:57 | Falkland Islands (Malvinas), United Kingdom | ||
283832 | 283832 | 2021-02-24 | United Kingdom | Gibraltar | 4234 | 91 | 4113 | 30 | 36.1408 | -5.3536 | 2021-02-25 05:24:57 | Gibraltar, United Kingdom | ||
283833 | 283833 | 2021-02-24 | United Kingdom | Isle of Man | 470 | 25 | 410 | 35 | 54.2361 | -4.5481 | 2021-02-25 05:24:57 | Isle of Man, United Kingdom | ||
283834 | 283834 | 2021-02-24 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-25 05:24:57 | Montserrat, United Kingdom | ||
283835 | 283835 | 2021-02-24 | United Kingdom | Northern Ireland | 111651 | 2818 | 0 | 109608 | 54.7877 | -6.4923 | 2021-02-25 05:24:57 | Northern Ireland, United Kingdom | ||
283836 | 283836 | 2021-02-24 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-23 05:23:41 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
283837 | 283837 | 2021-02-24 | United Kingdom | Scotland | 199637 | 9619 | 0 | 192584 | 56.4907 | -4.2026 | 2021-02-25 05:24:57 | Scotland, United Kingdom | ||
283838 | 283838 | 2021-02-24 | United Kingdom | Turks and Caicos Islands | 2051 | 14 | 1796 | 241 | 21.694000000000006 | -71.7979 | 2021-02-25 05:24:57 | Turks and Caicos Islands, United Kingdom | ||
283839 | 283839 | 2021-02-24 | United Kingdom | Unknown | 0 | 171 | 0 | 0 | 55.3781 | -3.436 | 2021-02-25 05:24:57 | Unknown, United Kingdom | ||
283840 | 283840 | 2021-02-24 | United Kingdom | Wales | 202560 | 7627 | 0 | 197297 | 52.1307 | -3.7837 | 2021-02-25 05:24:57 | Wales, United Kingdom | ||
283876 | 283876 | 2021-02-24 | United Kingdom | Jersey | 3211 | 68 | 0 | 0 | 49.2138 | -2.1358 | 2021-02-25 05:24:57 | Jersey, United Kingdom | ||
283877 | 283877 | 2021-02-24 | United Kingdom | Guernsey | 817 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-02-25 05:24:57 | Guernsey, United Kingdom | ||
283883 | 283883 | 2021-02-24 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-25 05:24:57 | Pitcairn Islands, United Kingdom | ||
1940093 | 1940093 | 2021-02-23 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-24 05:29:16 | Anguilla, United Kingdom | ||
1940094 | 1940094 | 2021-02-23 | United Kingdom | Bermuda | 703 | 12 | 681 | 10 | 32.3078 | -64.7505 | 2021-02-24 05:29:16 | Bermuda, United Kingdom | ||
1940095 | 1940095 | 2021-02-23 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-24 05:29:16 | British Virgin Islands, United Kingdom | ||
1940096 | 1940096 | 2021-02-23 | United Kingdom | Cayman Islands | 431 | 2 | 403 | 26 | 19.3133 | -81.2546 | 2021-02-24 05:29:16 | Cayman Islands, United Kingdom | ||
1940097 | 1940097 | 2021-02-23 | United Kingdom | Channel Islands | 0 | 0 | 3879 | 66 | 49.3723 | -2.3644 | 2021-02-24 05:29:16 | Channel Islands, United Kingdom | ||
1940098 | 1940098 | 2021-02-23 | United Kingdom | England | 3622085 | 126600 | 0 | 3515077 | 52.3555 | -1.1743 | 2021-02-24 05:29:16 | England, United Kingdom | ||
1940099 | 1940099 | 2021-02-23 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 46 | 8 | -51.7963 | -59.5236 | 2021-02-24 05:29:16 | Falkland Islands (Malvinas), United Kingdom | ||
1940100 | 1940100 | 2021-02-23 | United Kingdom | Gibraltar | 4234 | 91 | 4113 | 30 | 36.1408 | -5.3536 | 2021-02-24 05:29:16 | Gibraltar, United Kingdom | ||
1940101 | 1940101 | 2021-02-23 | United Kingdom | Isle of Man | 462 | 25 | 409 | 28 | 54.2361 | -4.5481 | 2021-02-24 05:29:16 | Isle of Man, United Kingdom | ||
1940102 | 1940102 | 2021-02-23 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-24 05:29:16 | Montserrat, United Kingdom | ||
1940103 | 1940103 | 2021-02-23 | United Kingdom | Northern Ireland | 111391 | 2810 | 0 | 109350 | 54.7877 | -6.4923 | 2021-02-24 05:29:16 | Northern Ireland, United Kingdom | ||
1940104 | 1940104 | 2021-02-23 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-23 05:23:41 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1940105 | 1940105 | 2021-02-23 | United Kingdom | Scotland | 198839 | 9595 | 0 | 191833 | 56.4907 | -4.2026 | 2021-02-24 05:29:16 | Scotland, United Kingdom | ||
1940106 | 1940106 | 2021-02-23 | United Kingdom | Turks and Caicos Islands | 2051 | 14 | 1796 | 241 | 21.694000000000006 | -71.7979 | 2021-02-24 05:29:16 | Turks and Caicos Islands, United Kingdom | ||
1940107 | 1940107 | 2021-02-23 | United Kingdom | Unknown | 0 | 170 | 0 | 0 | 55.3781 | -3.436 | 2021-02-24 05:29:16 | Unknown, United Kingdom | ||
1940108 | 1940108 | 2021-02-23 | United Kingdom | Wales | 202324 | 7610 | 0 | 197074 | 52.1307 | -3.7837 | 2021-02-24 05:29:16 | Wales, United Kingdom | ||
1940144 | 1940144 | 2021-02-23 | United Kingdom | Jersey | 3211 | 68 | 0 | 0 | 49.2138 | -2.1358 | 2021-02-24 05:29:16 | Jersey, United Kingdom | ||
1940145 | 1940145 | 2021-02-23 | United Kingdom | Guernsey | 817 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-02-24 05:29:16 | Guernsey, United Kingdom | ||
1940151 | 1940151 | 2021-02-23 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-24 05:29:16 | Pitcairn Islands, United Kingdom | ||
534348 | 534348 | 2021-02-22 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-23 05:23:41 | Anguilla, United Kingdom | ||
534349 | 534349 | 2021-02-22 | United Kingdom | Bermuda | 699 | 12 | 679 | 8 | 32.3078 | -64.7505 | 2021-02-23 05:23:41 | Bermuda, United Kingdom | ||
534350 | 534350 | 2021-02-22 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-23 05:23:41 | British Virgin Islands, United Kingdom | ||
534351 | 534351 | 2021-02-22 | United Kingdom | Cayman Islands | 431 | 2 | 403 | 26 | 19.3133 | -81.2546 | 2021-02-23 05:23:41 | Cayman Islands, United Kingdom | ||
534352 | 534352 | 2021-02-22 | United Kingdom | Channel Islands | 0 | 0 | 3858 | 87 | 49.3723 | -2.3644 | 2021-02-23 05:23:41 | Channel Islands, United Kingdom | ||
534353 | 534353 | 2021-02-22 | United Kingdom | England | 3614793 | 126265 | 0 | 3508268 | 52.3555 | -1.1743 | 2021-02-23 05:23:41 | England, United Kingdom | ||
534354 | 534354 | 2021-02-22 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 43 | 11 | -51.7963 | -59.5236 | 2021-02-23 05:23:41 | Falkland Islands (Malvinas), United Kingdom | ||
534355 | 534355 | 2021-02-22 | United Kingdom | Gibraltar | 4232 | 91 | 4103 | 38 | 36.1408 | -5.3536 | 2021-02-23 05:23:41 | Gibraltar, United Kingdom | ||
534356 | 534356 | 2021-02-22 | United Kingdom | Isle of Man | 456 | 25 | 409 | 22 | 54.2361 | -4.5481 | 2021-02-23 05:23:41 | Isle of Man, United Kingdom | ||
534357 | 534357 | 2021-02-22 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-23 05:23:41 | Montserrat, United Kingdom | ||
534358 | 534358 | 2021-02-22 | United Kingdom | Northern Ireland | 111166 | 2807 | 0 | 109130 | 54.7877 | -6.4923 | 2021-02-23 05:23:41 | Northern Ireland, United Kingdom | ||
534359 | 534359 | 2021-02-22 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-23 05:23:41 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
534360 | 534360 | 2021-02-22 | United Kingdom | Scotland | 198184 | 9573 | 0 | 191234 | 56.4907 | -4.2026 | 2021-02-23 05:23:41 | Scotland, United Kingdom | ||
534361 | 534361 | 2021-02-22 | United Kingdom | Turks and Caicos Islands | 2029 | 14 | 1721 | 294 | 21.694000000000006 | -71.7979 | 2021-02-23 05:23:41 | Turks and Caicos Islands, United Kingdom | ||
534362 | 534362 | 2021-02-22 | United Kingdom | Unknown | 0 | 168 | 0 | 0 | 55.3781 | -3.436 | 2021-02-23 05:23:41 | Unknown, United Kingdom | ||
534363 | 534363 | 2021-02-22 | United Kingdom | Wales | 202007 | 7592 | 0 | 196761 | 52.1307 | -3.7837 | 2021-02-23 05:23:41 | Wales, United Kingdom | ||
534399 | 534399 | 2021-02-22 | United Kingdom | Jersey | 3211 | 68 | 0 | 0 | 49.2138 | -2.1358 | 2021-02-23 05:23:41 | Jersey, United Kingdom | ||
534400 | 534400 | 2021-02-22 | United Kingdom | Guernsey | 813 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-02-23 05:23:41 | Guernsey, United Kingdom | ||
534406 | 534406 | 2021-02-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-23 05:23:41 | Pitcairn Islands, United Kingdom | ||
185682 | 185682 | 2021-02-21 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-22 05:24:21 | Anguilla, United Kingdom | ||
185683 | 185683 | 2021-02-21 | United Kingdom | Bermuda | 699 | 12 | 679 | 8 | 32.3078 | -64.7505 | 2021-02-22 05:24:21 | Bermuda, United Kingdom | ||
185684 | 185684 | 2021-02-21 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-22 05:24:21 | British Virgin Islands, United Kingdom | ||
185685 | 185685 | 2021-02-21 | United Kingdom | Cayman Islands | 428 | 2 | 394 | 32 | 19.3133 | -81.2546 | 2021-02-22 05:24:21 | Cayman Islands, United Kingdom | ||
185686 | 185686 | 2021-02-21 | United Kingdom | Channel Islands | 0 | 0 | 3842 | 99 | 49.3723 | -2.3644 | 2021-02-22 05:24:21 | Channel Islands, United Kingdom | ||
185687 | 185687 | 2021-02-21 | United Kingdom | England | 3605373 | 125940 | 0 | 3499013 | 52.3555 | -1.1743 | 2021-02-22 05:24:21 | England, United Kingdom | ||
185688 | 185688 | 2021-02-21 | United Kingdom | Falkland Islands (Malvinas) | 54 | 0 | 43 | 11 | -51.7963 | -59.5236 | 2021-02-22 05:24:21 | Falkland Islands (Malvinas), United Kingdom | ||
185689 | 185689 | 2021-02-21 | United Kingdom | Gibraltar | 4228 | 90 | 4097 | 41 | 36.1408 | -5.3536 | 2021-02-22 05:24:21 | Gibraltar, United Kingdom | ||
185690 | 185690 | 2021-02-21 | United Kingdom | Isle of Man | 450 | 25 | 409 | 16 | 54.2361 | -4.5481 | 2021-02-22 05:24:21 | Isle of Man, United Kingdom | ||
185691 | 185691 | 2021-02-21 | United Kingdom | Montserrat | 20 | 1 | 13 | 6 | 16.742498 | -62.187366 | 2021-02-22 05:24:21 | Montserrat, United Kingdom | ||
185692 | 185692 | 2021-02-21 | United Kingdom | Northern Ireland | 110979 | 2795 | 0 | 108946 | 54.7877 | -6.4923 | 2021-02-22 05:24:21 | Northern Ireland, United Kingdom | ||
185693 | 185693 | 2021-02-21 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-02-22 05:24:21 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
185694 | 185694 | 2021-02-21 | United Kingdom | Scotland | 197469 | 9547 | 0 | 190519 | 56.4907 | -4.2026 | 2021-02-22 05:24:21 | Scotland, United Kingdom | ||
185695 | 185695 | 2021-02-21 | United Kingdom | Turks and Caicos Islands | 2028 | 14 | 1721 | 293 | 21.694000000000006 | -71.7979 | 2021-02-22 05:24:21 | Turks and Caicos Islands, United Kingdom | ||
185696 | 185696 | 2021-02-21 | United Kingdom | Unknown | 0 | 167 | 0 | 0 | 55.3781 | -3.436 | 2021-02-22 05:24:21 | Unknown, United Kingdom | ||
185697 | 185697 | 2021-02-21 | United Kingdom | Wales | 201688 | 7577 | 0 | 196451 | 52.1307 | -3.7837 | 2021-02-22 05:24:21 | Wales, United Kingdom | ||
185733 | 185733 | 2021-02-21 | United Kingdom | Jersey | 3211 | 68 | 0 | 0 | 49.2138 | -2.1358 | 2021-02-22 05:24:21 | Jersey, United Kingdom | ||
185734 | 185734 | 2021-02-21 | United Kingdom | Guernsey | 812 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-02-22 05:24:21 | Guernsey, United Kingdom | ||
185740 | 185740 | 2021-02-21 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-22 05:24:21 | Pitcairn Islands, United Kingdom | ||
745956 | 745956 | 2021-02-20 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-21 05:24:33 | Anguilla, United Kingdom | ||
745957 | 745957 | 2021-02-20 | United Kingdom | Bermuda | 699 | 12 | 679 | 8 | 32.3078 | -64.7505 | 2021-02-21 05:24:33 | Bermuda, United Kingdom | ||
745958 | 745958 | 2021-02-20 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-02-21 05:24:33 | British Virgin Islands, United Kingdom | ||
745959 | 745959 | 2021-02-20 | United Kingdom | Cayman Islands | 428 | 2 | 394 | 32 | 19.3133 | -81.2546 | 2021-02-21 05:24:33 | Cayman Islands, United Kingdom | ||
745960 | 745960 | 2021-02-20 | United Kingdom | Channel Islands | 0 | 0 | 3829 | 111 | 49.3723 | -2.3644 | 2021-02-21 05:24:33 | 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]);