⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

5,242 rows where country_or_region = "United Kingdom" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • United Kingdom · 5,242
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
908069 2021-03-03 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-03-04 05:24:24 Anguilla, United Kingdom
908070 2021-03-03 United Kingdom Bermuda     713 12 682 19 32.3078 -64.7505 2021-03-04 05:24:24 Bermuda, United Kingdom
908071 2021-03-03 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-03-04 05:24:24 British Virgin Islands, United Kingdom
908072 2021-03-03 United Kingdom Cayman Islands     447 2 415 30 19.3133 -81.2546 2021-03-04 05:24:24 Cayman Islands, United Kingdom
908073 2021-03-03 United Kingdom Channel Islands     4040 86 3944 10 49.3723 -2.3644 2021-03-04 05:24:24 Channel Islands, United Kingdom
908074 2021-03-03 United Kingdom England     3674028 108993 0 3565035 52.3555 -1.1743 2021-03-04 05:24:24 England, United Kingdom
908075 2021-03-03 United Kingdom Falkland Islands (Malvinas)     54 0 51 3 -51.7963 -59.5236 2021-03-04 05:24:24 Falkland Islands (Malvinas), United Kingdom
908076 2021-03-03 United Kingdom Gibraltar     4243 93 4127 23 36.1408 -5.3536 2021-03-04 05:24:24 Gibraltar, United Kingdom
908077 2021-03-03 United Kingdom Isle of Man     511 25 416 70 54.2361 -4.5481 2021-03-04 05:24:24 Isle of Man, United Kingdom
908078 2021-03-03 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-03-04 05:24:24 Montserrat, United Kingdom
908079 2021-03-03 United Kingdom Northern Ireland     113006 2063 0 110943 54.7877 -6.4923 2021-03-04 05:24:24 Northern Ireland, United Kingdom
908080 2021-03-03 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-04 05:24:24 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
908081 2021-03-03 United Kingdom Scotland     203555 7371 0 196184 56.4907 -4.2026 2021-03-04 05:24:24 Scotland, United Kingdom
908082 2021-03-03 United Kingdom Turks and Caicos Islands     2132 14 1940 178 21.694000000000006 -71.7979 2021-03-04 05:24:24 Turks and Caicos Islands, United Kingdom
908083 2021-03-03 United Kingdom Unknown     0 0 0 0     2021-03-04 05:24:24 Unknown, United Kingdom
908084 2021-03-03 United Kingdom Wales     204196 5356 0 198840 52.1307 -3.7837 2021-03-04 05:24:24 Wales, United Kingdom
70450 2021-03-02 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-03-03 05:23:28 Anguilla, United Kingdom
70451 2021-03-02 United Kingdom Bermuda     713 12 682 19 32.3078 -64.7505 2021-03-03 05:23:28 Bermuda, United Kingdom
70452 2021-03-02 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-03-03 05:23:28 British Virgin Islands, United Kingdom
70453 2021-03-02 United Kingdom Cayman Islands     447 2 415 30 19.3133 -81.2546 2021-03-03 05:23:28 Cayman Islands, United Kingdom
70454 2021-03-02 United Kingdom Channel Islands     4039 86 3939 14 49.3723 -2.3644 2021-03-03 05:23:28 Channel Islands, United Kingdom
70455 2021-03-02 United Kingdom England     3668620 108729 0 3559891 52.3555 -1.1743 2021-03-03 05:23:28 England, United Kingdom
70456 2021-03-02 United Kingdom Falkland Islands (Malvinas)     54 0 46 8 -51.7963 -59.5236 2021-03-03 05:23:28 Falkland Islands (Malvinas), United Kingdom
70457 2021-03-02 United Kingdom Gibraltar     4243 93 4127 23 36.1408 -5.3536 2021-03-03 05:23:28 Gibraltar, United Kingdom
70458 2021-03-02 United Kingdom Isle of Man     494 25 411 58 54.2361 -4.5481 2021-03-03 05:23:28 Isle of Man, United Kingdom
70459 2021-03-02 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-03-03 05:23:28 Montserrat, United Kingdom
70460 2021-03-02 United Kingdom Northern Ireland     112780 2059 0 110721 54.7877 -6.4923 2021-03-03 05:23:28 Northern Ireland, United Kingdom
70461 2021-03-02 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-03 05:23:28 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
70462 2021-03-02 United Kingdom Scotland     203012 7164 0 195848 56.4907 -4.2026 2021-03-03 05:23:28 Scotland, United Kingdom
70463 2021-03-02 United Kingdom Turks and Caicos Islands     2115 14 1876 225 21.694000000000006 -71.7979 2021-03-03 05:23:28 Turks and Caicos Islands, United Kingdom
70464 2021-03-02 United Kingdom Unknown     0 0 0 0     2021-03-03 05:23:28 Unknown, United Kingdom
70465 2021-03-02 United Kingdom Wales     203988 5344 0 198644 52.1307 -3.7837 2021-03-03 05:23:28 Wales, United Kingdom
1295028 2021-03-01 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-03-02 05:23:30 Anguilla, United Kingdom
1295029 2021-03-01 United Kingdom Bermuda     707 12 682 13 32.3078 -64.7505 2021-03-02 05:23:30 Bermuda, United Kingdom
1295030 2021-03-01 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-03-02 05:23:30 British Virgin Islands, United Kingdom
1295031 2021-03-01 United Kingdom Cayman Islands     447 2 415 30 19.3133 -81.2546 2021-03-02 05:23:30 Cayman Islands, United Kingdom
1295032 2021-03-01 United Kingdom Channel Islands     4038 86 3928 24 49.3723 -2.3644 2021-03-02 05:23:30 Channel Islands, United Kingdom
1295033 2021-03-01 United Kingdom England     3663090 108422 0 3554668 52.3555 -1.1743 2021-03-02 05:23:30 England, United Kingdom
1295034 2021-03-01 United Kingdom Falkland Islands (Malvinas)     54 0 46 8 -51.7963 -59.5236 2021-03-02 05:23:30 Falkland Islands (Malvinas), United Kingdom
1295035 2021-03-01 United Kingdom Gibraltar     4239 93 4125 21 36.1408 -5.3536 2021-03-02 05:23:30 Gibraltar, United Kingdom
1295036 2021-03-01 United Kingdom Isle of Man     486 25 411 50 54.2361 -4.5481 2021-03-02 05:23:30 Isle of Man, United Kingdom
1295037 2021-03-01 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-03-02 05:23:30 Montserrat, United Kingdom
1295038 2021-03-01 United Kingdom Northern Ireland     112631 2057 0 110574 54.7877 -6.4923 2021-03-02 05:23:30 Northern Ireland, United Kingdom
1295039 2021-03-01 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-02 05:23:30 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
1295040 2021-03-01 United Kingdom Scotland     202470 7131 0 195339 56.4907 -4.2026 2021-03-02 05:23:30 Scotland, United Kingdom
1295041 2021-03-01 United Kingdom Turks and Caicos Islands     2114 14 1873 227 21.694000000000006 -71.7979 2021-03-02 05:23:30 Turks and Caicos Islands, United Kingdom
1295042 2021-03-01 United Kingdom Unknown     0 0 0 0     2021-03-02 05:23:30 Unknown, United Kingdom
1295043 2021-03-01 United Kingdom Wales     203818 5343 0 198475 52.1307 -3.7837 2021-03-02 05:23:30 Wales, United Kingdom
583443 2021-02-28 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-03-01 05:23:01 Anguilla, United Kingdom
583444 2021-02-28 United Kingdom Bermuda     705 12 682 11 32.3078 -64.7505 2021-03-01 05:23:01 Bermuda, United Kingdom
583445 2021-02-28 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-03-01 05:23:01 British Virgin Islands, United Kingdom
583446 2021-02-28 United Kingdom Cayman Islands     444 2 413 29 19.3133 -81.2546 2021-03-01 05:23:01 Cayman Islands, United Kingdom
583447 2021-02-28 United Kingdom Channel Islands     4038 86 3928 24 49.3723 -2.3644 2021-03-01 05:23:01 Channel Islands, United Kingdom
583448 2021-02-28 United Kingdom England     3658352 108323 0 3550029 52.3555 -1.1743 2021-03-01 05:23:01 England, United Kingdom
583449 2021-02-28 United Kingdom Falkland Islands (Malvinas)     54 0 46 8 -51.7963 -59.5236 2021-03-01 05:23:01 Falkland Islands (Malvinas), United Kingdom
583450 2021-02-28 United Kingdom Gibraltar     4239 93 4124 22 36.1408 -5.3536 2021-03-01 05:23:01 Gibraltar, United Kingdom
583451 2021-02-28 United Kingdom Isle of Man     484 25 411 48 54.2361 -4.5481 2021-03-01 05:23:01 Isle of Man, United Kingdom
583452 2021-02-28 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-03-01 05:23:01 Montserrat, United Kingdom
583453 2021-02-28 United Kingdom Northern Ireland     112493 2055 0 110438 54.7877 -6.4923 2021-03-01 05:23:01 Northern Ireland, United Kingdom
583454 2021-02-28 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-03-01 05:23:01 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
583455 2021-02-28 United Kingdom Scotland     202084 7131 0 194953 56.4907 -4.2026 2021-03-01 05:23:01 Scotland, United Kingdom
583456 2021-02-28 United Kingdom Turks and Caicos Islands     2114 14 1873 227 21.694000000000006 -71.7979 2021-03-01 05:23:01 Turks and Caicos Islands, United Kingdom
583457 2021-02-28 United Kingdom Unknown     0 0 0 0     2021-03-01 05:23:01 Unknown, United Kingdom
583458 2021-02-28 United Kingdom Wales     203625 5340 0 198285 52.1307 -3.7837 2021-03-01 05:23:01 Wales, United Kingdom
684169 2021-02-27 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-02-28 05:22:20 Anguilla, United Kingdom
684170 2021-02-27 United Kingdom Bermuda     705 12 682 11 32.3078 -64.7505 2021-02-28 05:22:20 Bermuda, United Kingdom
684171 2021-02-27 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-02-28 05:22:20 British Virgin Islands, United Kingdom
684172 2021-02-27 United Kingdom Cayman Islands     444 2 413 29 19.3133 -81.2546 2021-02-28 05:22:20 Cayman Islands, United Kingdom
684173 2021-02-27 United Kingdom Channel Islands     4034 86 3893 55 49.3723 -2.3644 2021-02-28 05:22:20 Channel Islands, United Kingdom
684174 2021-02-27 United Kingdom England     3653272 108208 0 3545064 52.3555 -1.1743 2021-02-28 05:22:20 England, United Kingdom
684175 2021-02-27 United Kingdom Falkland Islands (Malvinas)     54 0 46 8 -51.7963 -59.5236 2021-02-28 05:22:20 Falkland Islands (Malvinas), United Kingdom
684176 2021-02-27 United Kingdom Gibraltar     4238 93 4122 23 36.1408 -5.3536 2021-02-28 05:22:20 Gibraltar, United Kingdom
684177 2021-02-27 United Kingdom Isle of Man     484 25 410 49 54.2361 -4.5481 2021-02-28 05:22:20 Isle of Man, United Kingdom
684178 2021-02-27 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-02-28 05:22:20 Montserrat, United Kingdom
684179 2021-02-27 United Kingdom Northern Ireland     112357 2052 0 110305 54.7877 -6.4923 2021-02-28 05:22:20 Northern Ireland, United Kingdom
684180 2021-02-27 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-02-28 05:22:20 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
684181 2021-02-27 United Kingdom Scotland     201512 7129 0 194383 56.4907 -4.2026 2021-02-28 05:22:20 Scotland, United Kingdom
684182 2021-02-27 United Kingdom Turks and Caicos Islands     2099 14 1870 215 21.694000000000006 -71.7979 2021-02-28 05:22:20 Turks and Caicos Islands, United Kingdom
684183 2021-02-27 United Kingdom Unknown     0 0 0 0     2021-02-28 05:22:20 Unknown, United Kingdom
684184 2021-02-27 United Kingdom Wales     203378 5316 0 198062 52.1307 -3.7837 2021-02-28 05:22:20 Wales, United Kingdom
877197 2021-02-26 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-02-27 05:22:28 Anguilla, United Kingdom
877198 2021-02-26 United Kingdom Bermuda     705 12 682 11 32.3078 -64.7505 2021-02-27 05:22:28 Bermuda, United Kingdom
877199 2021-02-26 United Kingdom British Virgin Islands     153 1 131 21 18.4207 -64.64 2021-02-27 05:22:28 British Virgin Islands, United Kingdom
877200 2021-02-26 United Kingdom Cayman Islands     444 2 413 29 19.3133 -81.2546 2021-02-27 05:22:28 Cayman Islands, United Kingdom
877201 2021-02-26 United Kingdom Channel Islands     4033 86 3893 54 49.3723 -2.3644 2021-02-27 05:22:28 Channel Islands, United Kingdom
877202 2021-02-26 United Kingdom England     3646745 107954 0 3538791 52.3555 -1.1743 2021-02-27 05:22:28 England, United Kingdom
877203 2021-02-26 United Kingdom Falkland Islands (Malvinas)     54 0 46 8 -51.7963 -59.5236 2021-02-27 05:22:28 Falkland Islands (Malvinas), United Kingdom
877204 2021-02-26 United Kingdom Gibraltar     4236 92 4122 22 36.1408 -5.3536 2021-02-27 05:22:28 Gibraltar, United Kingdom
877205 2021-02-26 United Kingdom Isle of Man     475 25 410 40 54.2361 -4.5481 2021-02-27 05:22:28 Isle of Man, United Kingdom
877206 2021-02-26 United Kingdom Montserrat     20 1 13 6 16.742498 -62.187366 2021-02-27 05:22:28 Montserrat, United Kingdom
877207 2021-02-26 United Kingdom Northern Ireland     112173 2050 0 110123 54.7877 -6.4923 2021-02-27 05:22:28 Northern Ireland, United Kingdom
877208 2021-02-26 United Kingdom Saint Helena, Ascension and Tristan da Cunha     4 0 4 0 -7.9467 -14.3559 2021-02-27 05:22:28 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
877209 2021-02-26 United Kingdom Scotland     200987 7111 0 193876 56.4907 -4.2026 2021-02-27 05:22:28 Scotland, United Kingdom
877210 2021-02-26 United Kingdom Turks and Caicos Islands     2088 14 1847 227 21.694000000000006 -71.7979 2021-02-27 05:22:28 Turks and Caicos Islands, United Kingdom
877211 2021-02-26 United Kingdom Unknown     0 0 0 0     2021-02-27 05:22:28 Unknown, United Kingdom
877212 2021-02-26 United Kingdom Wales     203180 5300 0 197880 52.1307 -3.7837 2021-02-27 05:22:28 Wales, United Kingdom
391852 2021-02-25 United Kingdom Anguilla     18 0 18 0 18.2206 -63.0686 2021-02-26 05:22:40 Anguilla, United Kingdom
391853 2021-02-25 United Kingdom Bermuda     705 12 682 11 32.3078 -64.7505 2021-02-26 05:22:40 Bermuda, United Kingdom
391854 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
391855 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);