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 361
- Guernsey 361
- Jersey 361
- Northern Ireland 361
- Pitcairn Islands 361
- Scotland 361
- Unknown 361
- Wales 361
- Channel Islands 312
- Gibraltar 312
- Cayman Islands 307
- Montserrat 305
- Bermuda 304
- Isle of Man 303
- Saint Helena, Ascension and Tristan da Cunha 298
- Anguilla 295
- British Virgin Islands 295
- Turks and Caicos Islands 295
- Falkland Islands (Malvinas) 285
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 6,202 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3105082 | 3105082 | 2021-01-16 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-17 05:22:17 | Anguilla, United Kingdom | ||
3105083 | 3105083 | 2021-01-16 | United Kingdom | Bermuda | 670 | 12 | 583 | 75 | 32.3078 | -64.7505 | 2021-01-17 05:22:17 | Bermuda, United Kingdom | ||
3105084 | 3105084 | 2021-01-16 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-17 05:22:17 | British Virgin Islands, United Kingdom | ||
3105085 | 3105085 | 2021-01-16 | United Kingdom | Cayman Islands | 374 | 2 | 328 | 44 | 19.3133 | -81.2546 | 2021-01-17 05:22:17 | Cayman Islands, United Kingdom | ||
3105086 | 3105086 | 2021-01-16 | United Kingdom | Channel Islands | 0 | 0 | 2997 | 283 | 49.3723 | -2.3644 | 2021-01-17 05:22:17 | Channel Islands, United Kingdom | ||
3105087 | 3105087 | 2021-01-16 | United Kingdom | England | 2922841 | 96356 | 0 | 2845363 | 52.3555 | -1.1743 | 2021-01-17 05:22:17 | England, United Kingdom | ||
3105088 | 3105088 | 2021-01-16 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-17 05:22:17 | Falkland Islands (Malvinas), United Kingdom | ||
3105089 | 3105089 | 2021-01-16 | United Kingdom | Gibraltar | 3637 | 34 | 2588 | 1015 | 36.1408 | -5.3536 | 2021-01-17 05:22:17 | Gibraltar, United Kingdom | ||
3105090 | 3105090 | 2021-01-16 | United Kingdom | Isle of Man | 419 | 25 | 354 | 40 | 54.2361 | -4.5481 | 2021-01-17 05:22:17 | Isle of Man, United Kingdom | ||
3105091 | 3105091 | 2021-01-16 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-17 05:22:17 | Montserrat, United Kingdom | ||
3105092 | 3105092 | 2021-01-16 | United Kingdom | Northern Ireland | 94539 | 2241 | 0 | 92958 | 54.7877 | -6.4923 | 2021-01-17 05:22:17 | Northern Ireland, United Kingdom | ||
3105093 | 3105093 | 2021-01-16 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-01-17 05:22:17 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3105094 | 3105094 | 2021-01-16 | United Kingdom | Scotland | 160992 | 7697 | 0 | 155687 | 56.4907 | -4.2026 | 2021-01-17 05:22:17 | Scotland, United Kingdom | ||
3105095 | 3105095 | 2021-01-16 | United Kingdom | Turks and Caicos Islands | 1079 | 6 | 863 | 210 | 21.694000000000006 | -71.7979 | 2021-01-17 05:22:17 | Turks and Caicos Islands, United Kingdom | ||
3105096 | 3105096 | 2021-01-16 | United Kingdom | Unknown | 0 | 122 | 0 | 0 | 55.3781 | -3.436 | 2021-01-17 05:22:17 | Unknown, United Kingdom | ||
3105097 | 3105097 | 2021-01-16 | United Kingdom | Wales | 178989 | 6245 | 0 | 174763 | 52.1307 | -3.7837 | 2021-01-17 05:22:17 | Wales, United Kingdom | ||
3105134 | 3105134 | 2021-01-16 | United Kingdom | Jersey | 3033 | 60 | 0 | 0 | 49.2138 | -2.1358 | 2021-01-17 05:22:17 | Jersey, United Kingdom | ||
3105135 | 3105135 | 2021-01-16 | United Kingdom | Guernsey | 309 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2021-01-17 05:22:17 | Guernsey, United Kingdom | ||
3105141 | 3105141 | 2021-01-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-17 05:22:17 | Pitcairn Islands, United Kingdom | ||
3519044 | 3519044 | 2021-01-15 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-16 05:22:40 | Anguilla, United Kingdom | ||
3519045 | 3519045 | 2021-01-15 | United Kingdom | Bermuda | 667 | 12 | 571 | 84 | 32.3078 | -64.7505 | 2021-01-16 05:22:40 | Bermuda, United Kingdom | ||
3519046 | 3519046 | 2021-01-15 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-16 05:22:40 | British Virgin Islands, United Kingdom | ||
3519047 | 3519047 | 2021-01-15 | United Kingdom | Cayman Islands | 374 | 2 | 328 | 44 | 19.3133 | -81.2546 | 2021-01-16 05:22:40 | Cayman Islands, United Kingdom | ||
3519048 | 3519048 | 2021-01-15 | United Kingdom | Channel Islands | 0 | 0 | 2997 | 280 | 49.3723 | -2.3644 | 2021-01-16 05:22:40 | Channel Islands, United Kingdom | ||
3519049 | 3519049 | 2021-01-15 | United Kingdom | England | 2885082 | 95115 | 0 | 2808744 | 52.3555 | -1.1743 | 2021-01-16 05:22:40 | England, United Kingdom | ||
3519050 | 3519050 | 2021-01-15 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-16 05:22:40 | Falkland Islands (Malvinas), United Kingdom | ||
3519051 | 3519051 | 2021-01-15 | United Kingdom | Gibraltar | 3575 | 30 | 2432 | 1113 | 36.1408 | -5.3536 | 2021-01-16 05:22:40 | Gibraltar, United Kingdom | ||
3519052 | 3519052 | 2021-01-15 | United Kingdom | Isle of Man | 418 | 25 | 354 | 39 | 54.2361 | -4.5481 | 2021-01-16 05:22:40 | Isle of Man, United Kingdom | ||
3519053 | 3519053 | 2021-01-15 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-16 05:22:40 | Montserrat, United Kingdom | ||
3519054 | 3519054 | 2021-01-15 | United Kingdom | Northern Ireland | 93834 | 2218 | 0 | 92275 | 54.7877 | -6.4923 | 2021-01-16 05:22:40 | Northern Ireland, United Kingdom | ||
3519055 | 3519055 | 2021-01-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-01-16 05:22:40 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3519056 | 3519056 | 2021-01-15 | United Kingdom | Scotland | 159239 | 7620 | 0 | 154012 | 56.4907 | -4.2026 | 2021-01-16 05:22:40 | Scotland, United Kingdom | ||
3519057 | 3519057 | 2021-01-15 | United Kingdom | Turks and Caicos Islands | 1062 | 6 | 862 | 194 | 21.694000000000006 | -71.7979 | 2021-01-16 05:22:40 | Turks and Caicos Islands, United Kingdom | ||
3519058 | 3519058 | 2021-01-15 | United Kingdom | Unknown | 0 | 118 | 0 | 0 | 55.3781 | -3.436 | 2021-01-16 05:22:40 | Unknown, United Kingdom | ||
3519059 | 3519059 | 2021-01-15 | United Kingdom | Wales | 177864 | 6171 | 0 | 173693 | 52.1307 | -3.7837 | 2021-01-16 05:22:40 | Wales, United Kingdom | ||
3519096 | 3519096 | 2021-01-15 | United Kingdom | Jersey | 3022 | 60 | 0 | 0 | 49.2138 | -2.1358 | 2021-01-16 05:22:40 | Jersey, United Kingdom | ||
3519097 | 3519097 | 2021-01-15 | United Kingdom | Guernsey | 308 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2021-01-16 05:22:40 | Guernsey, United Kingdom | ||
3519103 | 3519103 | 2021-01-15 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-16 05:22:40 | Pitcairn Islands, United Kingdom | ||
3883216 | 3883216 | 2021-01-14 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-15 05:22:24 | Anguilla, United Kingdom | ||
3883217 | 3883217 | 2021-01-14 | United Kingdom | Bermuda | 664 | 12 | 566 | 86 | 32.3078 | -64.7505 | 2021-01-15 05:22:24 | Bermuda, United Kingdom | ||
3883218 | 3883218 | 2021-01-14 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-15 05:22:24 | British Virgin Islands, United Kingdom | ||
3883219 | 3883219 | 2021-01-14 | United Kingdom | Cayman Islands | 368 | 2 | 326 | 40 | 19.3133 | -81.2546 | 2021-01-15 05:22:24 | Cayman Islands, United Kingdom | ||
3883220 | 3883220 | 2021-01-14 | United Kingdom | Channel Islands | 0 | 0 | 2997 | 264 | 49.3723 | -2.3644 | 2021-01-15 05:22:24 | Channel Islands, United Kingdom | ||
3883221 | 3883221 | 2021-01-14 | United Kingdom | England | 2834341 | 93953 | 0 | 2759142 | 52.3555 | -1.1743 | 2021-01-15 05:22:24 | England, United Kingdom | ||
3883222 | 3883222 | 2021-01-14 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-15 05:22:24 | Falkland Islands (Malvinas), United Kingdom | ||
3883223 | 3883223 | 2021-01-14 | United Kingdom | Gibraltar | 3509 | 25 | 2343 | 1141 | 36.1408 | -5.3536 | 2021-01-15 05:22:24 | Gibraltar, United Kingdom | ||
3883224 | 3883224 | 2021-01-14 | United Kingdom | Isle of Man | 417 | 25 | 354 | 38 | 54.2361 | -4.5481 | 2021-01-15 05:22:24 | Isle of Man, United Kingdom | ||
3883225 | 3883225 | 2021-01-14 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-15 05:22:24 | Montserrat, United Kingdom | ||
3883226 | 3883226 | 2021-01-14 | United Kingdom | Northern Ireland | 92782 | 2189 | 0 | 91249 | 54.7877 | -6.4923 | 2021-01-15 05:22:24 | Northern Ireland, United Kingdom | ||
3883227 | 3883227 | 2021-01-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-01-15 05:22:24 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3883228 | 3883228 | 2021-01-14 | United Kingdom | Scotland | 157079 | 7556 | 0 | 151913 | 56.4907 | -4.2026 | 2021-01-15 05:22:24 | Scotland, United Kingdom | ||
3883229 | 3883229 | 2021-01-14 | United Kingdom | Turks and Caicos Islands | 1030 | 6 | 847 | 177 | 21.694000000000006 | -71.7979 | 2021-01-15 05:22:24 | Turks and Caicos Islands, United Kingdom | ||
3883230 | 3883230 | 2021-01-14 | United Kingdom | Unknown | 0 | 116 | 0 | 0 | 55.3781 | -3.436 | 2021-01-15 05:22:24 | Unknown, United Kingdom | ||
3883231 | 3883231 | 2021-01-14 | United Kingdom | Wales | 176056 | 6104 | 0 | 171939 | 52.1307 | -3.7837 | 2021-01-15 05:22:24 | Wales, United Kingdom | ||
3883268 | 3883268 | 2021-01-14 | United Kingdom | Jersey | 3005 | 59 | 0 | 0 | 49.2138 | -2.1358 | 2021-01-15 05:22:24 | Jersey, United Kingdom | ||
3883269 | 3883269 | 2021-01-14 | United Kingdom | Guernsey | 308 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2021-01-15 05:22:24 | Guernsey, United Kingdom | ||
3883275 | 3883275 | 2021-01-14 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-15 05:22:24 | Pitcairn Islands, United Kingdom | ||
3311843 | 3311843 | 2021-01-13 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-14 05:22:32 | Anguilla, United Kingdom | ||
3311844 | 3311844 | 2021-01-13 | United Kingdom | Bermuda | 661 | 12 | 558 | 91 | 32.3078 | -64.7505 | 2021-01-14 05:22:32 | Bermuda, United Kingdom | ||
3311845 | 3311845 | 2021-01-13 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-14 05:22:32 | British Virgin Islands, United Kingdom | ||
3311846 | 3311846 | 2021-01-13 | United Kingdom | Cayman Islands | 362 | 2 | 325 | 35 | 19.3133 | -81.2546 | 2021-01-14 05:22:32 | Cayman Islands, United Kingdom | ||
3311847 | 3311847 | 2021-01-13 | United Kingdom | Channel Islands | 0 | 0 | 2969 | 279 | 49.3723 | -2.3644 | 2021-01-14 05:22:32 | Channel Islands, United Kingdom | ||
3311848 | 3311848 | 2021-01-13 | United Kingdom | England | 2789983 | 92786 | 0 | 2715898 | 52.3555 | -1.1743 | 2021-01-14 05:22:32 | England, United Kingdom | ||
3311849 | 3311849 | 2021-01-13 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-14 05:22:32 | Falkland Islands (Malvinas), United Kingdom | ||
3311850 | 3311850 | 2021-01-13 | United Kingdom | Gibraltar | 3431 | 20 | 2259 | 1152 | 36.1408 | -5.3536 | 2021-01-14 05:22:32 | Gibraltar, United Kingdom | ||
3311851 | 3311851 | 2021-01-13 | United Kingdom | Isle of Man | 414 | 25 | 353 | 36 | 54.2361 | -4.5481 | 2021-01-14 05:22:32 | Isle of Man, United Kingdom | ||
3311852 | 3311852 | 2021-01-13 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-14 05:22:32 | Montserrat, United Kingdom | ||
3311853 | 3311853 | 2021-01-13 | United Kingdom | Northern Ireland | 91809 | 2155 | 0 | 90292 | 54.7877 | -6.4923 | 2021-01-14 05:22:32 | Northern Ireland, United Kingdom | ||
3311854 | 3311854 | 2021-01-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-01-14 05:22:32 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3311855 | 3311855 | 2021-01-13 | United Kingdom | Scotland | 155372 | 7492 | 0 | 150270 | 56.4907 | -4.2026 | 2021-01-14 05:22:32 | Scotland, United Kingdom | ||
3311856 | 3311856 | 2021-01-13 | United Kingdom | Turks and Caicos Islands | 1011 | 6 | 819 | 186 | 21.694000000000006 | -71.7979 | 2021-01-14 05:22:32 | Turks and Caicos Islands, United Kingdom | ||
3311857 | 3311857 | 2021-01-13 | United Kingdom | Unknown | 0 | 116 | 0 | 0 | 55.3781 | -3.436 | 2021-01-14 05:22:32 | Unknown, United Kingdom | ||
3311858 | 3311858 | 2021-01-13 | United Kingdom | Wales | 174412 | 6028 | 0 | 170349 | 52.1307 | -3.7837 | 2021-01-14 05:22:32 | Wales, United Kingdom | ||
3311895 | 3311895 | 2021-01-13 | United Kingdom | Jersey | 2996 | 59 | 0 | 0 | 49.2138 | -2.1358 | 2021-01-14 05:22:32 | Jersey, United Kingdom | ||
3311896 | 3311896 | 2021-01-13 | United Kingdom | Guernsey | 307 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2021-01-14 05:22:32 | Guernsey, United Kingdom | ||
3311902 | 3311902 | 2021-01-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-14 05:22:32 | Pitcairn Islands, United Kingdom | ||
777988 | 777988 | 2021-01-12 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-13 05:22:15 | Anguilla, United Kingdom | ||
777989 | 777989 | 2021-01-12 | United Kingdom | Bermuda | 656 | 12 | 554 | 90 | 32.3078 | -64.7505 | 2021-01-13 05:22:15 | Bermuda, United Kingdom | ||
777990 | 777990 | 2021-01-12 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-13 05:22:15 | British Virgin Islands, United Kingdom | ||
777991 | 777991 | 2021-01-12 | United Kingdom | Cayman Islands | 362 | 2 | 316 | 44 | 19.3133 | -81.2546 | 2021-01-13 05:22:15 | Cayman Islands, United Kingdom | ||
777992 | 777992 | 2021-01-12 | United Kingdom | Channel Islands | 0 | 0 | 2948 | 287 | 49.3723 | -2.3644 | 2021-01-13 05:22:15 | Channel Islands, United Kingdom | ||
777993 | 777993 | 2021-01-12 | United Kingdom | England | 2747085 | 91625 | 0 | 2674400 | 52.3555 | -1.1743 | 2021-01-13 05:22:15 | England, United Kingdom | ||
777994 | 777994 | 2021-01-12 | United Kingdom | Falkland Islands (Malvinas) | 29 | 0 | 27 | 2 | -51.7963 | -59.5236 | 2021-01-13 05:22:15 | Falkland Islands (Malvinas), United Kingdom | ||
777995 | 777995 | 2021-01-12 | United Kingdom | Gibraltar | 3324 | 17 | 2213 | 1094 | 36.1408 | -5.3536 | 2021-01-13 05:22:15 | Gibraltar, United Kingdom | ||
777996 | 777996 | 2021-01-12 | United Kingdom | Isle of Man | 406 | 25 | 351 | 30 | 54.2361 | -4.5481 | 2021-01-13 05:22:15 | Isle of Man, United Kingdom | ||
777997 | 777997 | 2021-01-12 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-13 05:22:15 | Montserrat, United Kingdom | ||
777998 | 777998 | 2021-01-12 | United Kingdom | Northern Ireland | 90664 | 2131 | 0 | 89166 | 54.7877 | -6.4923 | 2021-01-13 05:22:15 | Northern Ireland, United Kingdom | ||
777999 | 777999 | 2021-01-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 4 | 0 | -7.9467 | -14.3559 | 2021-01-13 05:22:15 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
778000 | 778000 | 2021-01-12 | United Kingdom | Scotland | 153423 | 7439 | 0 | 148400 | 56.4907 | -4.2026 | 2021-01-13 05:22:15 | Scotland, United Kingdom | ||
778001 | 778001 | 2021-01-12 | United Kingdom | Turks and Caicos Islands | 1011 | 6 | 819 | 186 | 21.694000000000006 | -71.7979 | 2021-01-13 05:22:15 | Turks and Caicos Islands, United Kingdom | ||
778002 | 778002 | 2021-01-12 | United Kingdom | Unknown | 0 | 113 | 0 | 0 | 55.3781 | -3.436 | 2021-01-13 05:22:15 | Unknown, United Kingdom | ||
778003 | 778003 | 2021-01-12 | United Kingdom | Wales | 172879 | 5960 | 0 | 168882 | 52.1307 | -3.7837 | 2021-01-13 05:22:15 | Wales, United Kingdom | ||
778040 | 778040 | 2021-01-12 | United Kingdom | Jersey | 2982 | 57 | 0 | 0 | 49.2138 | -2.1358 | 2021-01-13 05:22:15 | Jersey, United Kingdom | ||
778041 | 778041 | 2021-01-12 | United Kingdom | Guernsey | 306 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2021-01-13 05:22:15 | Guernsey, United Kingdom | ||
778047 | 778047 | 2021-01-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-13 05:22:15 | Pitcairn Islands, United Kingdom | ||
193709 | 193709 | 2021-01-11 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-12 05:22:15 | Anguilla, United Kingdom | ||
193710 | 193710 | 2021-01-11 | United Kingdom | Bermuda | 656 | 12 | 554 | 90 | 32.3078 | -64.7505 | 2021-01-12 05:22:15 | Bermuda, United Kingdom | ||
193711 | 193711 | 2021-01-11 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-12 05:22:15 | British Virgin Islands, United Kingdom | ||
193712 | 193712 | 2021-01-11 | United Kingdom | Cayman Islands | 362 | 2 | 316 | 44 | 19.3133 | -81.2546 | 2021-01-12 05:22:15 | Cayman Islands, United Kingdom | ||
193713 | 193713 | 2021-01-11 | United Kingdom | Channel Islands | 0 | 0 | 2850 | 376 | 49.3723 | -2.3644 | 2021-01-12 05:22:15 | 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]);