daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,730 rows where country_or_region = "United Kingdom" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | England | 0 | 7 | 0 | 52.3555 | -1.1743 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-05T14:53:03 | ||||
2021-11-02 | United Kingdom | Anguilla | 944 | 1 | 0 | 18.2206 | -63.0686 | 2021-11-03 06:22:09 | Anguilla, United Kingdom | |||
2021-11-02 | United Kingdom | Bermuda | 5657 | 104 | 0 | 32.3078 | -64.7505 | 2021-11-03 06:22:09 | Bermuda, United Kingdom | |||
2021-11-02 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-11-03 06:22:09 | British Virgin Islands, United Kingdom | |||
2021-11-02 | United Kingdom | Cayman Islands | 1650 | 2 | 0 | 19.3133 | -81.2546 | 2021-11-03 06:22:09 | Cayman Islands, United Kingdom | |||
2021-11-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-03 06:22:09 | Channel Islands, United Kingdom | |||
2021-11-02 | United Kingdom | England | 7760671 | 144560 | 0 | 52.3555 | -1.1743 | 2021-11-03 06:22:09 | England, United Kingdom | |||
2021-11-02 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-11-03 06:22:09 | Falkland Islands (Malvinas), United Kingdom | |||
2021-11-02 | United Kingdom | Gibraltar | 6029 | 98 | 0 | 36.1408 | -5.3536 | 2021-11-03 06:22:09 | Gibraltar, United Kingdom | |||
2021-11-02 | United Kingdom | Isle of Man | 9796 | 57 | 0 | 54.2361 | -4.5481 | 2021-11-03 06:22:09 | Isle of Man, United Kingdom | |||
2021-11-02 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-03 06:22:09 | Montserrat, United Kingdom | |||
2021-11-02 | United Kingdom | Northern Ireland | 277334 | 3717 | 0 | 54.7877 | -6.4923 | 2021-11-03 06:22:09 | Northern Ireland, United Kingdom | |||
2021-11-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-11-03 06:22:09 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2021-11-02 | United Kingdom | Scotland | 647689 | 11857 | 0 | 56.4907 | -4.2026 | 2021-11-03 06:22:09 | Scotland, United Kingdom | |||
2021-11-02 | United Kingdom | Turks and Caicos Islands | 2989 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-03 06:22:09 | Turks and Caicos Islands, United Kingdom | |||
2021-11-02 | United Kingdom | Unknown | 0 | 231 | 0 | 55.3781 | -3.436 | 2021-11-03 06:22:09 | Unknown, United Kingdom | |||
2021-11-02 | United Kingdom | Wales | 445163 | 8804 | 0 | 52.1307 | -3.7837 | 2021-11-03 06:22:09 | Wales, United Kingdom | |||
2020-03-07 | United Kingdom | Unknown | 206 | 0 | 18 | 55.0 | -3.0 | 2020-03-07T17:43:05 | ||||
2020-03-07 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | England | 0 | 9 | 0 | 52.3555 | -1.1743 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-07T11:13:04 | ||||
2020-03-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-07T11:13:04 | ||||
2022-11-12 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-13 04:21:14 | Anguilla, United Kingdom | |||
2022-11-12 | United Kingdom | Bermuda | 18428 | 149 | 0 | 32.3078 | -64.7505 | 2022-11-13 04:21:14 | Bermuda, United Kingdom | |||
2022-11-12 | United Kingdom | British Virgin Islands | 7305 | 64 | 0 | 18.4207 | -64.64 | 2022-11-13 04:21:14 | British Virgin Islands, United Kingdom | |||
2022-11-12 | United Kingdom | Cayman Islands | 31194 | 36 | 0 | 19.3133 | -81.2546 | 2022-11-13 04:21:14 | Cayman Islands, United Kingdom | |||
2022-11-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-13 04:21:14 | Channel Islands, United Kingdom | |||
2022-11-12 | United Kingdom | England | 20228010 | 179815 | 0 | 52.3555 | -1.1743 | 2022-11-13 04:21:14 | England, United Kingdom | |||
2022-11-12 | United Kingdom | Falkland Islands (Malvinas) | 1930 | 0 | 0 | -51.7963 | -59.5236 | 2022-11-13 04:21:14 | Falkland Islands (Malvinas), United Kingdom | |||
2022-11-12 | United Kingdom | Gibraltar | 20166 | 110 | 0 | 36.1408 | -5.3536 | 2022-11-13 04:21:14 | Gibraltar, United Kingdom | |||
2022-11-12 | United Kingdom | Guernsey | 32562 | 65 | 0 | 49.448196 | -2.58949 | 2022-11-13 04:21:14 | Guernsey, United Kingdom | |||
2022-11-12 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-11-13 04:21:14 | Isle of Man, United Kingdom | |||
2022-11-12 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-13 04:21:14 | Jersey, United Kingdom | |||
2022-11-12 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-11-13 04:21:14 | Montserrat, United Kingdom | |||
2022-11-12 | United Kingdom | Northern Ireland | 713294 | 4950 | 0 | 54.7877 | -6.4923 | 2022-11-13 04:21:14 | Northern Ireland, United Kingdom | |||
2022-11-12 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-13 04:21:14 | Pitcairn Islands, United Kingdom | |||
2022-11-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2115 | 0 | 0 | -7.9467 | -14.3559 | 2022-11-13 04:21:14 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2022-11-12 | United Kingdom | Scotland | 2123527 | 16081 | 0 | 56.4907 | -4.2026 | 2022-11-13 04:21:14 | Scotland, United Kingdom | |||
2022-11-12 | United Kingdom | Turks and Caicos Islands | 6431 | 36 | 0 | 21.694 | -71.7979 | 2022-11-13 04:21:14 | Turks and Caicos Islands, United Kingdom | |||
2022-11-12 | United Kingdom | Unknown | 0 | 325 | 0 | 55.3781 | -3.436 | 2022-11-13 04:21:14 | Unknown, United Kingdom | |||
2022-11-12 | United Kingdom | Wales | 889361 | 11064 | 0 | 52.1307 | -3.7837 | 2022-11-13 04:21:14 | Wales, United Kingdom | |||
2021-09-01 | United Kingdom | Anguilla | 217 | 0 | 0 | 18.2206 | -63.0686 | 2021-09-02 04:21:15 | Anguilla, United Kingdom | |||
2021-09-01 | United Kingdom | Bermuda | 2923 | 34 | 0 | 32.3078 | -64.7505 | 2021-09-02 04:21:15 | Bermuda, United Kingdom | |||
2021-09-01 | United Kingdom | British Virgin Islands | 2568 | 37 | 0 | 18.4207 | -64.64 | 2021-09-02 04:21:15 | British Virgin Islands, United Kingdom | |||
2021-09-01 | United Kingdom | Cayman Islands | 688 | 2 | 0 | 19.3133 | -81.2546 | 2021-09-02 04:21:15 | Cayman Islands, United Kingdom | |||
2021-09-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-02 04:21:15 | Channel Islands, United Kingdom | |||
2021-09-01 | United Kingdom | England | 5904664 | 137772 | 0 | 52.3555 | -1.1743 | 2021-09-02 04:21:15 | England, United Kingdom | |||
2021-09-01 | United Kingdom | Falkland Islands (Malvinas) | 67 | 0 | 0 | -51.7963 | -59.5236 | 2021-09-02 04:21:15 | Falkland Islands (Malvinas), United Kingdom | |||
2021-09-01 | United Kingdom | Gibraltar | 5367 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-02 04:21:15 | Gibraltar, United Kingdom | |||
2021-09-01 | United Kingdom | Isle of Man | 6694 | 38 | 0 | 54.2361 | -4.5481 | 2021-09-02 04:21:15 | Isle of Man, United Kingdom | |||
2021-09-01 | United Kingdom | Montserrat | 29 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-02 04:21:15 | Montserrat, United Kingdom | |||
2021-09-01 | United Kingdom | Northern Ireland | 202132 | 3271 | 0 | 54.7877 | -6.4923 | 2021-09-02 04:21:15 | Northern Ireland, United Kingdom | |||
2021-09-01 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-09-02 04:21:15 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2021-09-01 | United Kingdom | Scotland | 436688 | 10642 | 0 | 56.4907 | -4.2026 | 2021-09-02 04:21:15 | Scotland, United Kingdom | |||
2021-09-01 | United Kingdom | Turks and Caicos Islands | 2653 | 20 | 0 | 21.69400000000001 | -71.7979 | 2021-09-02 04:21:15 | Turks and Caicos Islands, United Kingdom | |||
2021-09-01 | United Kingdom | Unknown | 0 | 207 | 0 | 55.3781 | -3.436 | 2021-09-02 04:21:15 | Unknown, United Kingdom | |||
2021-09-01 | United Kingdom | Wales | 281590 | 8095 | 0 | 52.1307 | -3.7837 | 2021-09-02 04:21:15 | Wales, United Kingdom | |||
2022-02-07 | United Kingdom | Anguilla | 2436 | 9 | 0 | 18.2206 | -63.0686 | 2022-02-08 04:21:15 | Anguilla, United Kingdom | |||
2022-02-07 | United Kingdom | Bermuda | 11058 | 119 | 0 | 32.3078 | -64.7505 | 2022-02-08 04:21:15 | Bermuda, United Kingdom | |||
2022-02-07 | United Kingdom | British Virgin Islands | 5928 | 51 | 0 | 18.4207 | -64.64 | 2022-02-08 04:21:15 | British Virgin Islands, United Kingdom | |||
2022-02-07 | United Kingdom | Cayman Islands | 15934 | 16 | 0 | 19.3133 | -81.2546 | 2022-02-08 04:21:15 | Cayman Islands, United Kingdom | |||
2022-02-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-02-08 04:21:15 | Channel Islands, United Kingdom | |||
2022-02-07 | United Kingdom | England | 15331148 | 157905 | 0 | 52.3555 | -1.1743 | 2022-02-08 04:21:15 | England, United Kingdom | |||
2022-02-07 | United Kingdom | Falkland Islands (Malvinas) | 91 | 0 | 0 | -51.7963 | -59.5236 | 2022-02-08 04:21:15 | Falkland Islands (Malvinas), United Kingdom | |||
2022-02-07 | United Kingdom | Gibraltar | 13740 | 101 | 0 | 36.1408 | -5.3536 | 2022-02-08 04:21:15 | Gibraltar, United Kingdom | |||
2022-02-07 | United Kingdom | Isle of Man | 21918 | 73 | 0 | 54.2361 | -4.5481 | 2022-02-08 04:21:15 | Isle of Man, United Kingdom | |||
2022-02-07 | United Kingdom | Montserrat | 163 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-02-08 04:21:15 | Montserrat, United Kingdom | |||
2022-02-07 | United Kingdom | Northern Ireland | 569282 | 4248 | 0 | 54.7877 | -6.4923 | 2022-02-08 04:21:15 | Northern Ireland, United Kingdom | |||
2022-02-07 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2022-02-08 04:21:15 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2022-02-07 | United Kingdom | Scotland | 1173535 | 13185 | 0 | 56.4907 | -4.2026 | 2022-02-08 04:21:15 | Scotland, United Kingdom | |||
2022-02-07 | United Kingdom | Turks and Caicos Islands | 5789 | 35 | 0 | 21.69400000000001 | -71.7979 | 2022-02-08 04:21:15 | Turks and Caicos Islands, United Kingdom | |||
2022-02-07 | United Kingdom | Unknown | 0 | 270 | 0 | 55.3781 | -3.436 | 2022-02-08 04:21:15 | Unknown, United Kingdom | |||
2022-02-07 | United Kingdom | Wales | 792667 | 9684 | 0 | 52.1307 | -3.7837 | 2022-02-08 04:21:15 | Wales, United Kingdom | |||
2021-11-09 | United Kingdom | Anguilla | 1039 | 1 | 0 | 18.2206 | -63.0686 | 2021-11-10 04:21:38 | Anguilla, United Kingdom | |||
2021-11-09 | United Kingdom | Bermuda | 5688 | 106 | 0 | 32.3078 | -64.7505 | 2021-11-10 04:21:38 | Bermuda, United Kingdom | |||
2021-11-09 | United Kingdom | British Virgin Islands | 2745 | 38 | 0 | 18.4207 | -64.64 | 2021-11-10 04:21:38 | British Virgin Islands, United Kingdom | |||
2021-11-09 | United Kingdom | Cayman Islands | 2676 | 2 | 0 | 19.3133 | -81.2546 | 2021-11-10 04:21:38 | Cayman Islands, United Kingdom | |||
2021-11-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-10 04:21:38 | Channel Islands, United Kingdom | |||
2021-11-09 | United Kingdom | England | 7953228 | 145474 | 0 | 52.3555 | -1.1743 | 2021-11-10 04:21:38 | England, United Kingdom | |||
2021-11-09 | United Kingdom | Falkland Islands (Malvinas) | 78 | 0 | 0 | -51.7963 | -59.5236 | 2021-11-10 04:21:38 | Falkland Islands (Malvinas), United Kingdom | |||
2021-11-09 | United Kingdom | Gibraltar | 6206 | 98 | 0 | 36.1408 | -5.3536 | 2021-11-10 04:21:38 | Gibraltar, United Kingdom | |||
2021-11-09 | United Kingdom | Isle of Man | 10046 | 60 | 0 | 54.2361 | -4.5481 | 2021-11-10 04:21:38 | Isle of Man, United Kingdom | |||
2021-11-09 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-10 04:21:38 | Montserrat, United Kingdom | |||
2021-11-09 | United Kingdom | Northern Ireland | 285459 | 3780 | 0 | 54.7877 | -6.4923 | 2021-11-10 04:21:38 | Northern Ireland, United Kingdom | |||
2021-11-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-11-10 04:21:38 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2021-11-09 | United Kingdom | Scotland | 666880 | 11976 | 0 | 56.4907 | -4.2026 | 2021-11-10 04:21:38 | Scotland, United Kingdom | |||
2021-11-09 | United Kingdom | Turks and Caicos Islands | 3018 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-10 04:21:38 | Turks and Caicos Islands, United Kingdom | |||
2021-11-09 | United Kingdom | Unknown | 0 | 233 | 0 | 55.3781 | -3.436 | 2021-11-10 04:21:38 | Unknown, United Kingdom | |||
2021-11-09 | United Kingdom | Wales | 461109 | 8875 | 0 | 52.1307 | -3.7837 | 2021-11-10 04:21:38 | Wales, United Kingdom | |||
2022-07-23 | United Kingdom | Anguilla | 3543 | 10 | 0 | 18.2206 | -63.0686 | 2022-07-24 04:20:47 | Anguilla, United Kingdom | |||
2022-07-23 | United Kingdom | Bermuda | 16988 | 142 | 0 | 32.3078 | -64.7505 | 2022-07-24 04:20:47 | Bermuda, United Kingdom | |||
2022-07-23 | United Kingdom | British Virgin Islands | 7131 | 63 | 0 | 18.4207 | -64.64 | 2022-07-24 04:20:47 | British Virgin Islands, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;