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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
longitude 23 ✖
- -1.1743 1,073
- -128.3242 1,073
- -2.1358 1,073
- -2.58949 1,073
- -3.7837 1,073
- -4.2026 1,073
- -6.4923 1,073
- -3.436 1,063
- -5.3536 1,024
- -2.3644 1,023
- -81.2546 1,019
- -64.7505 1,016
- -4.5481 1,015
- -14.3559 1,010
- -63.0686 1,007
- -64.64 1,007
- -71.7979 1,007
- -59.5236 1,000
- -62.187366 663
- -62.187366000000004 350
- -3.0 10
- -62.1874 4
- -2.364351 1
province_or_state 20
- England 1,073
- Guernsey 1,073
- Jersey 1,073
- Northern Ireland 1,073
- Pitcairn Islands 1,073
- Scotland 1,073
- Unknown 1,073
- Wales 1,073
- Channel Islands 1,024
- Gibraltar 1,024
- Cayman Islands 1,019
- Montserrat 1,017
- Bermuda 1,016
- Isle of Man 1,015
- Saint Helena, Ascension and Tristan da Cunha 1,010
- Anguilla 1,007
- British Virgin Islands 1,007
- Turks and Caicos Islands 1,007
- Falkland Islands (Malvinas) 997
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 19,730 ✖
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4006343 | 4006343 | 2022-10-08 | United Kingdom | Wales | 886426 | 10892 | 0 | 52.1307 | -3.7837 | 2022-10-09 04:21:16 | Wales, United Kingdom | |||
4006342 | 4006342 | 2022-10-08 | United Kingdom | Unknown | 0 | 320 | 0 | 55.3781 | -3.436 | 2022-10-09 04:21:16 | Unknown, United Kingdom | |||
4006341 | 4006341 | 2022-10-08 | United Kingdom | Turks and Caicos Islands | 6380 | 36 | 0 | 21.694 | -71.7979 | 2022-10-09 04:21:16 | Turks and Caicos Islands, United Kingdom | |||
4006340 | 4006340 | 2022-10-08 | United Kingdom | Scotland | 2107886 | 15854 | 0 | 56.4907 | -4.2026 | 2022-10-09 04:21:16 | Scotland, United Kingdom | |||
4006339 | 4006339 | 2022-10-08 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 1826 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-09 04:21:16 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
4006338 | 4006338 | 2022-10-08 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-09 04:21:16 | Pitcairn Islands, United Kingdom | |||
4006337 | 4006337 | 2022-10-08 | United Kingdom | Northern Ireland | 713294 | 4889 | 0 | 54.7877 | -6.4923 | 2022-10-09 04:21:16 | Northern Ireland, United Kingdom | |||
4006336 | 4006336 | 2022-10-08 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-10-09 04:21:16 | Montserrat, United Kingdom | |||
4006335 | 4006335 | 2022-10-08 | United Kingdom | Jersey | 60646 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-09 04:21:16 | Jersey, United Kingdom | |||
4006334 | 4006334 | 2022-10-08 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-10-09 04:21:16 | Isle of Man, United Kingdom | |||
4006333 | 4006333 | 2022-10-08 | United Kingdom | Guernsey | 31545 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-09 04:21:16 | Guernsey, United Kingdom | |||
4006332 | 4006332 | 2022-10-08 | United Kingdom | Gibraltar | 20095 | 108 | 0 | 36.1408 | -5.3536 | 2022-10-09 04:21:16 | Gibraltar, United Kingdom | |||
4006331 | 4006331 | 2022-10-08 | United Kingdom | Falkland Islands (Malvinas) | 1930 | 0 | 0 | -51.7963 | -59.5236 | 2022-10-09 04:21:16 | Falkland Islands (Malvinas), United Kingdom | |||
4006330 | 4006330 | 2022-10-08 | United Kingdom | England | 20027667 | 177119 | 0 | 52.3555 | -1.1743 | 2022-10-09 04:21:16 | England, United Kingdom | |||
4006329 | 4006329 | 2022-10-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-10-09 04:21:16 | Channel Islands, United Kingdom | |||
4006328 | 4006328 | 2022-10-08 | United Kingdom | Cayman Islands | 30809 | 34 | 0 | 19.3133 | -81.2546 | 2022-10-09 04:21:16 | Cayman Islands, United Kingdom | |||
4006327 | 4006327 | 2022-10-08 | United Kingdom | British Virgin Islands | 7305 | 64 | 0 | 18.4207 | -64.64 | 2022-10-09 04:21:16 | British Virgin Islands, United Kingdom | |||
4006326 | 4006326 | 2022-10-08 | United Kingdom | Bermuda | 18220 | 148 | 0 | 32.3078 | -64.7505 | 2022-10-09 04:21:16 | Bermuda, United Kingdom | |||
4006325 | 4006325 | 2022-10-08 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-09 04:21:16 | Anguilla, United Kingdom | |||
4002337 | 4002337 | 2021-12-30 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-12-31 04:21:50 | Pitcairn Islands, United Kingdom | ||
4002331 | 4002331 | 2021-12-30 | United Kingdom | Guernsey | 7408 | 24 | 0 | 0 | 49.448196 | -2.58949 | 2021-12-31 04:21:50 | Guernsey, United Kingdom | ||
4002330 | 4002330 | 2021-12-30 | United Kingdom | Jersey | 18589 | 89 | 0 | 0 | 49.2138 | -2.1358 | 2021-12-31 04:21:50 | Jersey, United Kingdom | ||
4002318 | 4002318 | 2021-12-30 | United Kingdom | Wales | 621732 | 9293 | 0 | 52.1307 | -3.7837 | 2021-12-31 04:21:50 | Wales, United Kingdom | |||
4002317 | 4002317 | 2021-12-30 | United Kingdom | Unknown | 0 | 253 | 0 | 55.3781 | -3.436 | 2021-12-31 04:21:50 | Unknown, United Kingdom | |||
4002316 | 4002316 | 2021-12-30 | United Kingdom | Turks and Caicos Islands | 3283 | 26 | 0 | 21.69400000000001 | -71.7979 | 2021-12-31 04:21:50 | Turks and Caicos Islands, United Kingdom | |||
4002315 | 4002315 | 2021-12-30 | United Kingdom | Scotland | 902889 | 12560 | 0 | 56.4907 | -4.2026 | 2021-12-31 04:21:50 | Scotland, United Kingdom | |||
4002314 | 4002314 | 2021-12-30 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-12-31 04:21:50 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
4002313 | 4002313 | 2021-12-30 | United Kingdom | Northern Ireland | 394854 | 4048 | 0 | 54.7877 | -6.4923 | 2021-12-31 04:21:50 | Northern Ireland, United Kingdom | |||
4002312 | 4002312 | 2021-12-30 | United Kingdom | Montserrat | 46 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-31 04:21:50 | Montserrat, United Kingdom | |||
4002311 | 4002311 | 2021-12-30 | United Kingdom | Isle of Man | 13578 | 67 | 0 | 54.2361 | -4.5481 | 2021-12-31 04:21:50 | Isle of Man, United Kingdom | |||
4002310 | 4002310 | 2021-12-30 | United Kingdom | Gibraltar | 8533 | 100 | 0 | 36.1408 | -5.3536 | 2021-12-31 04:21:50 | Gibraltar, United Kingdom | |||
4002309 | 4002309 | 2021-12-30 | United Kingdom | Falkland Islands (Malvinas) | 83 | 0 | 0 | -51.7963 | -59.5236 | 2021-12-31 04:21:50 | Falkland Islands (Malvinas), United Kingdom | |||
4002308 | 4002308 | 2021-12-30 | United Kingdom | England | 10828575 | 151080 | 0 | 52.3555 | -1.1743 | 2021-12-31 04:21:50 | England, United Kingdom | |||
4002307 | 4002307 | 2021-12-30 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-12-31 04:21:50 | Channel Islands, United Kingdom | |||
4002306 | 4002306 | 2021-12-30 | United Kingdom | Cayman Islands | 8818 | 11 | 0 | 19.3133 | -81.2546 | 2021-12-31 04:21:50 | Cayman Islands, United Kingdom | |||
4002305 | 4002305 | 2021-12-30 | United Kingdom | British Virgin Islands | 3397 | 39 | 0 | 18.4207 | -64.64 | 2021-12-31 04:21:50 | British Virgin Islands, United Kingdom | |||
4002304 | 4002304 | 2021-12-30 | United Kingdom | Bermuda | 6420 | 110 | 0 | 32.3078 | -64.7505 | 2021-12-31 04:21:50 | Bermuda, United Kingdom | |||
4002303 | 4002303 | 2021-12-30 | United Kingdom | Anguilla | 1674 | 5 | 0 | 18.2206 | -63.0686 | 2021-12-31 04:21:50 | Anguilla, United Kingdom | |||
3998311 | 3998311 | 2022-09-27 | United Kingdom | Wales | 885103 | 10837 | 0 | 52.1307 | -3.7837 | 2022-09-28 04:23:01 | Wales, United Kingdom | |||
3998310 | 3998310 | 2022-09-27 | United Kingdom | Unknown | 0 | 320 | 0 | 55.3781 | -3.436 | 2022-09-28 04:23:01 | Unknown, United Kingdom | |||
3998309 | 3998309 | 2022-09-27 | United Kingdom | Turks and Caicos Islands | 6380 | 36 | 0 | 21.694 | -71.7979 | 2022-09-28 04:23:01 | Turks and Caicos Islands, United Kingdom | |||
3998308 | 3998308 | 2022-09-27 | United Kingdom | Scotland | 2101498 | 15782 | 0 | 56.4907 | -4.2026 | 2022-09-28 04:23:01 | Scotland, United Kingdom | |||
3998307 | 3998307 | 2022-09-27 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 1521 | 0 | 0 | -7.9467 | -14.3559 | 2022-09-28 04:23:01 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3998306 | 3998306 | 2022-09-27 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-28 04:23:01 | Pitcairn Islands, United Kingdom | |||
3998305 | 3998305 | 2022-09-27 | United Kingdom | Northern Ireland | 713294 | 4871 | 0 | 54.7877 | -6.4923 | 2022-09-28 04:23:01 | Northern Ireland, United Kingdom | |||
3998304 | 3998304 | 2022-09-27 | United Kingdom | Montserrat | 1396 | 8 | 0 | 16.742498 | -62.187366 | 2022-09-28 04:23:01 | Montserrat, United Kingdom | |||
3998303 | 3998303 | 2022-09-27 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-28 04:23:01 | Jersey, United Kingdom | |||
3998302 | 3998302 | 2022-09-27 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-09-28 04:23:01 | Isle of Man, United Kingdom | |||
3998301 | 3998301 | 2022-09-27 | United Kingdom | Guernsey | 31099 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-28 04:23:01 | Guernsey, United Kingdom | |||
3998300 | 3998300 | 2022-09-27 | United Kingdom | Gibraltar | 20092 | 108 | 0 | 36.1408 | -5.3536 | 2022-09-28 04:23:01 | Gibraltar, United Kingdom | |||
3998299 | 3998299 | 2022-09-27 | United Kingdom | Falkland Islands (Malvinas) | 1886 | 0 | 0 | -51.7963 | -59.5236 | 2022-09-28 04:23:01 | Falkland Islands (Malvinas), United Kingdom | |||
3998298 | 3998298 | 2022-09-27 | United Kingdom | England | 19922057 | 176394 | 0 | 52.3555 | -1.1743 | 2022-09-28 04:23:01 | England, United Kingdom | |||
3998297 | 3998297 | 2022-09-27 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-09-28 04:23:01 | Channel Islands, United Kingdom | |||
3998296 | 3998296 | 2022-09-27 | United Kingdom | Cayman Islands | 30545 | 31 | 0 | 19.3133 | -81.2546 | 2022-09-28 04:23:01 | Cayman Islands, United Kingdom | |||
3998295 | 3998295 | 2022-09-27 | United Kingdom | British Virgin Islands | 7305 | 64 | 0 | 18.4207 | -64.64 | 2022-09-28 04:23:01 | British Virgin Islands, United Kingdom | |||
3998294 | 3998294 | 2022-09-27 | United Kingdom | Bermuda | 18122 | 148 | 0 | 32.3078 | -64.7505 | 2022-09-28 04:23:01 | Bermuda, United Kingdom | |||
3998293 | 3998293 | 2022-09-27 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-28 04:23:01 | Anguilla, United Kingdom | |||
3994305 | 3994305 | 2020-10-20 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-10-21 04:24:14 | Pitcairn Islands, United Kingdom | ||
3994299 | 3994299 | 2020-10-20 | United Kingdom | Guernsey | 258 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-10-21 04:24:14 | Guernsey, United Kingdom | ||
3994298 | 3994298 | 2020-10-20 | United Kingdom | Jersey | 505 | 32 | 0 | 0 | 49.2138 | -2.1358 | 2020-10-21 04:24:14 | Jersey, United Kingdom | ||
3994262 | 3994262 | 2020-10-20 | United Kingdom | Wales | 37400 | 2786 | 0 | 35678 | 52.1307 | -3.7837 | 2020-10-21 04:24:14 | Wales, United Kingdom | ||
3994261 | 3994261 | 2020-10-20 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-21 04:24:14 | Unknown, United Kingdom | ||
3994260 | 3994260 | 2020-10-20 | United Kingdom | Turks and Caicos Islands | 698 | 6 | 689 | 3 | 21.694000000000006 | -71.7979 | 2020-10-21 04:24:14 | Turks and Caicos Islands, United Kingdom | ||
3994259 | 3994259 | 2020-10-20 | United Kingdom | Scotland | 49164 | 4490 | 0 | 46539 | 56.4907 | -4.2026 | 2020-10-21 04:24:14 | Scotland, United Kingdom | ||
3994258 | 3994258 | 2020-10-20 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-21 04:24:14 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3994257 | 3994257 | 2020-10-20 | United Kingdom | Northern Ireland | 28953 | 968 | 0 | 28329 | 54.7877 | -6.4923 | 2020-10-21 04:24:14 | Northern Ireland, United Kingdom | ||
3994256 | 3994256 | 2020-10-20 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2020-10-21 04:24:14 | Montserrat, United Kingdom | ||
3994255 | 3994255 | 2020-10-20 | United Kingdom | Isle of Man | 348 | 24 | 321 | 3 | 54.2361 | -4.5481 | 2020-10-21 04:24:14 | Isle of Man, United Kingdom | ||
3994254 | 3994254 | 2020-10-20 | United Kingdom | Gibraltar | 608 | 0 | 471 | 137 | 36.1408 | -5.3536 | 2020-10-21 04:24:14 | Gibraltar, United Kingdom | ||
3994253 | 3994253 | 2020-10-20 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-10-21 04:24:14 | Falkland Islands (Malvinas), United Kingdom | ||
3994252 | 3994252 | 2020-10-20 | United Kingdom | England | 647025 | 52866 | 0 | 608029 | 52.3555 | -1.1743 | 2020-10-21 04:24:14 | England, United Kingdom | ||
3994251 | 3994251 | 2020-10-20 | United Kingdom | Channel Islands | 0 | 0 | 659 | 61 | 49.3723 | -2.3644 | 2020-10-21 04:24:14 | Channel Islands, United Kingdom | ||
3994250 | 3994250 | 2020-10-20 | United Kingdom | Cayman Islands | 235 | 1 | 214 | 20 | 19.3133 | -81.2546 | 2020-10-21 04:24:14 | Cayman Islands, United Kingdom | ||
3994249 | 3994249 | 2020-10-20 | United Kingdom | British Virgin Islands | 71 | 1 | 70 | 0 | 18.4207 | -64.64 | 2020-10-21 04:24:14 | British Virgin Islands, United Kingdom | ||
3994248 | 3994248 | 2020-10-20 | United Kingdom | Bermuda | 188 | 9 | 174 | 5 | 32.3078 | -64.7505 | 2020-10-21 04:24:14 | Bermuda, United Kingdom | ||
3994247 | 3994247 | 2020-10-20 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-10-21 04:24:14 | Anguilla, United Kingdom | ||
3990310 | 3990310 | 2022-09-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-16 04:21:19 | Pitcairn Islands, United Kingdom | ||
3990299 | 3990299 | 2022-09-15 | United Kingdom | Wales | 884792 | 10813 | 0 | 52.1307 | -3.7837 | 2022-09-16 04:21:19 | Wales, United Kingdom | |||
3990298 | 3990298 | 2022-09-15 | United Kingdom | Unknown | 0 | 319 | 0 | 55.3781 | -3.436 | 2022-09-16 04:21:19 | Unknown, United Kingdom | |||
3990297 | 3990297 | 2022-09-15 | United Kingdom | Turks and Caicos Islands | 6380 | 36 | 0 | 21.694 | -71.7979 | 2022-09-16 04:21:19 | Turks and Caicos Islands, United Kingdom | |||
3990296 | 3990296 | 2022-09-15 | United Kingdom | Scotland | 2098635 | 15710 | 0 | 56.4907 | -4.2026 | 2022-09-16 04:21:19 | Scotland, United Kingdom | |||
3990295 | 3990295 | 2022-09-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 117 | 0 | 0 | -7.9467 | -14.3559 | 2022-09-16 04:21:19 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3990294 | 3990294 | 2022-09-15 | United Kingdom | Northern Ireland | 713294 | 4860 | 0 | 54.7877 | -6.4923 | 2022-09-16 04:21:19 | Northern Ireland, United Kingdom | |||
3990293 | 3990293 | 2022-09-15 | United Kingdom | Montserrat | 1326 | 8 | 0 | 16.742498 | -62.187366 | 2022-09-16 04:21:19 | Montserrat, United Kingdom | |||
3990292 | 3990292 | 2022-09-15 | United Kingdom | Jersey | 59270 | 137 | 0 | 49.2138 | -2.1358 | 2022-09-16 04:21:19 | Jersey, United Kingdom | |||
3990291 | 3990291 | 2022-09-15 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-09-16 04:21:19 | Isle of Man, United Kingdom | |||
3990290 | 3990290 | 2022-09-15 | United Kingdom | Guernsey | 30992 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-16 04:21:19 | Guernsey, United Kingdom | |||
3990289 | 3990289 | 2022-09-15 | United Kingdom | Gibraltar | 20069 | 108 | 0 | 36.1408 | -5.3536 | 2022-09-16 04:21:19 | Gibraltar, United Kingdom | |||
3990288 | 3990288 | 2022-09-15 | United Kingdom | Falkland Islands (Malvinas) | 1886 | 0 | 0 | -51.7963 | -59.5236 | 2022-09-16 04:21:19 | Falkland Islands (Malvinas), United Kingdom | |||
3990287 | 3990287 | 2022-09-15 | United Kingdom | England | 19888584 | 175935 | 0 | 52.3555 | -1.1743 | 2022-09-16 04:21:19 | England, United Kingdom | |||
3990286 | 3990286 | 2022-09-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-09-16 04:21:19 | Channel Islands, United Kingdom | |||
3990285 | 3990285 | 2022-09-15 | United Kingdom | Cayman Islands | 30545 | 31 | 0 | 19.3133 | -81.2546 | 2022-09-16 04:21:19 | Cayman Islands, United Kingdom | |||
3990284 | 3990284 | 2022-09-15 | United Kingdom | British Virgin Islands | 7305 | 64 | 0 | 18.4207 | -64.64 | 2022-09-16 04:21:19 | British Virgin Islands, United Kingdom | |||
3990283 | 3990283 | 2022-09-15 | United Kingdom | Bermuda | 18077 | 148 | 0 | 32.3078 | -64.7505 | 2022-09-16 04:21:19 | Bermuda, United Kingdom | |||
3990282 | 3990282 | 2022-09-15 | United Kingdom | Anguilla | 3856 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-16 04:21:19 | Anguilla, United Kingdom | |||
3986294 | 3986294 | 2022-06-15 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-06-16 04:20:55 | Pitcairn Islands, United Kingdom | ||
3986279 | 3986279 | 2022-06-15 | United Kingdom | Wales | 875029 | 10416 | 0 | 52.1307 | -3.7837 | 2022-06-16 04:20:55 | Wales, United Kingdom | |||
3986278 | 3986278 | 2022-06-15 | United Kingdom | Unknown | 0 | 297 | 0 | 55.3781 | -3.436 | 2022-06-16 04:20:55 | Unknown, United Kingdom | |||
3986277 | 3986277 | 2022-06-15 | United Kingdom | Turks and Caicos Islands | 6189 | 36 | 0 | 21.694 | -71.7979 | 2022-06-16 04:20:55 | Turks and Caicos Islands, United Kingdom | |||
3986276 | 3986276 | 2022-06-15 | United Kingdom | Scotland | 1975331 | 14914 | 0 | 56.4907 | -4.2026 | 2022-06-16 04:20:55 | Scotland, 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]);