⚠️ 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

4,298 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 · 4,298
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
93323 2021-01-22 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-23 05:22:03 Anguilla, United Kingdom
93324 2021-01-22 United Kingdom Bermuda     684 12 625 47 32.3078 -64.7505 2021-01-23 05:22:03 Bermuda, United Kingdom
93325 2021-01-22 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-23 05:22:03 British Virgin Islands, United Kingdom
93326 2021-01-22 United Kingdom Cayman Islands     382 2 346 34 19.3133 -81.2546 2021-01-23 05:22:03 Cayman Islands, United Kingdom
93327 2021-01-22 United Kingdom Channel Islands     3414 78 3148 188 49.3723 -2.3644 2021-01-23 05:22:03 Channel Islands, United Kingdom
93328 2021-01-22 United Kingdom England     3129156 84190 0 3044966 52.3555 -1.1743 2021-01-23 05:22:03 England, United Kingdom
93329 2021-01-22 United Kingdom Falkland Islands (Malvinas)     35 0 29 6 -51.7963 -59.5236 2021-01-23 05:22:03 Falkland Islands (Malvinas), United Kingdom
93330 2021-01-22 United Kingdom Gibraltar     3905 59 3097 749 36.1408 -5.3536 2021-01-23 05:22:03 Gibraltar, United Kingdom
93331 2021-01-22 United Kingdom Isle of Man     432 25 357 50 54.2361 -4.5481 2021-01-23 05:22:03 Isle of Man, United Kingdom
93332 2021-01-22 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-23 05:22:03 Montserrat, United Kingdom
93333 2021-01-22 United Kingdom Northern Ireland     99216 1704 0 97512 54.7877 -6.4923 2021-01-23 05:22:03 Northern Ireland, United Kingdom
93334 2021-01-22 United Kingdom Scotland     169699 5628 0 164071 56.4907 -4.2026 2021-01-23 05:22:03 Scotland, United Kingdom
93335 2021-01-22 United Kingdom Turks and Caicos Islands     1193 7 954 232 21.694000000000006 -71.7979 2021-01-23 05:22:03 Turks and Caicos Islands, United Kingdom
93336 2021-01-22 United Kingdom Unknown     0 0 0 0     2021-01-23 05:22:03 Unknown, United Kingdom
93337 2021-01-22 United Kingdom Wales     185836 4459 0 181377 52.1307 -3.7837 2021-01-23 05:22:03 Wales, United Kingdom
306229 2021-01-21 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-22 05:22:10 Anguilla, United Kingdom
306230 2021-01-21 United Kingdom Bermuda     684 12 611 61 32.3078 -64.7505 2021-01-22 05:22:10 Bermuda, United Kingdom
306231 2021-01-21 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-22 05:22:10 British Virgin Islands, United Kingdom
306232 2021-01-21 United Kingdom Cayman Islands     382 2 346 34 19.3133 -81.2546 2021-01-22 05:22:10 Cayman Islands, United Kingdom
306233 2021-01-21 United Kingdom Channel Islands     3407 78 3148 181 49.3723 -2.3644 2021-01-22 05:22:10 Channel Islands, United Kingdom
306234 2021-01-21 United Kingdom England     3092041 82939 0 3009102 52.3555 -1.1743 2021-01-22 05:22:10 England, United Kingdom
306235 2021-01-21 United Kingdom Falkland Islands (Malvinas)     35 0 29 6 -51.7963 -59.5236 2021-01-22 05:22:10 Falkland Islands (Malvinas), United Kingdom
306236 2021-01-21 United Kingdom Gibraltar     3881 59 3033 789 36.1408 -5.3536 2021-01-22 05:22:10 Gibraltar, United Kingdom
306237 2021-01-21 United Kingdom Isle of Man     432 25 357 50 54.2361 -4.5481 2021-01-22 05:22:10 Isle of Man, United Kingdom
306238 2021-01-21 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-22 05:22:10 Montserrat, United Kingdom
306239 2021-01-21 United Kingdom Northern Ireland     98351 1692 0 96659 54.7877 -6.4923 2021-01-22 05:22:10 Northern Ireland, United Kingdom
306240 2021-01-21 United Kingdom Scotland     168219 5557 0 162662 56.4907 -4.2026 2021-01-22 05:22:10 Scotland, United Kingdom
306241 2021-01-21 United Kingdom Turks and Caicos Islands     1164 7 935 222 21.694000000000006 -71.7979 2021-01-22 05:22:10 Turks and Caicos Islands, United Kingdom
306242 2021-01-21 United Kingdom Unknown     0 0 0 0     2021-01-22 05:22:10 Unknown, United Kingdom
306243 2021-01-21 United Kingdom Wales     185035 4392 0 180643 52.1307 -3.7837 2021-01-22 05:22:10 Wales, United Kingdom
897280 2021-01-20 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-21 05:22:01 Anguilla, United Kingdom
897281 2021-01-20 United Kingdom Bermuda     684 12 611 61 32.3078 -64.7505 2021-01-21 05:22:01 Bermuda, United Kingdom
897282 2021-01-20 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-21 05:22:01 British Virgin Islands, United Kingdom
897283 2021-01-20 United Kingdom Cayman Islands     381 2 341 38 19.3133 -81.2546 2021-01-21 05:22:01 Cayman Islands, United Kingdom
897284 2021-01-20 United Kingdom Channel Islands     3398 78 3107 213 49.3723 -2.3644 2021-01-21 05:22:01 Channel Islands, United Kingdom
897285 2021-01-20 United Kingdom England     3057670 81805 0 2975865 52.3555 -1.1743 2021-01-21 05:22:01 England, United Kingdom
897286 2021-01-20 United Kingdom Falkland Islands (Malvinas)     35 0 29 6 -51.7963 -59.5236 2021-01-21 05:22:01 Falkland Islands (Malvinas), United Kingdom
897287 2021-01-20 United Kingdom Gibraltar     3845 53 2994 798 36.1408 -5.3536 2021-01-21 05:22:01 Gibraltar, United Kingdom
897288 2021-01-20 United Kingdom Isle of Man     432 25 357 50 54.2361 -4.5481 2021-01-21 05:22:01 Isle of Man, United Kingdom
897289 2021-01-20 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-21 05:22:01 Montserrat, United Kingdom
897290 2021-01-20 United Kingdom Northern Ireland     97619 1671 0 95948 54.7877 -6.4923 2021-01-21 05:22:01 Northern Ireland, United Kingdom
897291 2021-01-20 United Kingdom Scotland     166583 5468 0 161115 56.4907 -4.2026 2021-01-21 05:22:01 Scotland, United Kingdom
897292 2021-01-20 United Kingdom Turks and Caicos Islands     1125 7 931 187 21.694000000000006 -71.7979 2021-01-21 05:22:01 Turks and Caicos Islands, United Kingdom
897293 2021-01-20 United Kingdom Unknown     0 0 0 0     2021-01-21 05:22:01 Unknown, United Kingdom
897294 2021-01-20 United Kingdom Wales     183882 4346 0 179536 52.1307 -3.7837 2021-01-21 05:22:01 Wales, United Kingdom
325847 2021-01-19 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-20 05:21:54 Anguilla, United Kingdom
325848 2021-01-19 United Kingdom Bermuda     684 12 603 69 32.3078 -64.7505 2021-01-20 05:21:54 Bermuda, United Kingdom
325849 2021-01-19 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-20 05:21:54 British Virgin Islands, United Kingdom
325850 2021-01-19 United Kingdom Cayman Islands     381 2 334 45 19.3133 -81.2546 2021-01-20 05:21:54 Cayman Islands, United Kingdom
325851 2021-01-19 United Kingdom Channel Islands     3386 78 3107 201 49.3723 -2.3644 2021-01-20 05:21:54 Channel Islands, United Kingdom
325852 2021-01-19 United Kingdom England     3022609 80143 0 2942466 52.3555 -1.1743 2021-01-20 05:21:54 England, United Kingdom
325853 2021-01-19 United Kingdom Falkland Islands (Malvinas)     32 0 27 5 -51.7963 -59.5236 2021-01-20 05:21:54 Falkland Islands (Malvinas), United Kingdom
325854 2021-01-19 United Kingdom Gibraltar     3793 47 2914 832 36.1408 -5.3536 2021-01-20 05:21:54 Gibraltar, United Kingdom
325855 2021-01-19 United Kingdom Isle of Man     432 25 354 53 54.2361 -4.5481 2021-01-20 05:21:54 Isle of Man, United Kingdom
325856 2021-01-19 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-20 05:21:54 Montserrat, United Kingdom
325857 2021-01-19 United Kingdom Northern Ireland     96714 1649 0 95065 54.7877 -6.4923 2021-01-20 05:21:54 Northern Ireland, United Kingdom
325858 2021-01-19 United Kingdom Scotland     164927 5376 0 159551 56.4907 -4.2026 2021-01-20 05:21:54 Scotland, United Kingdom
325859 2021-01-19 United Kingdom Turks and Caicos Islands     1105 7 902 196 21.694000000000006 -71.7979 2021-01-20 05:21:54 Turks and Caicos Islands, United Kingdom
325860 2021-01-19 United Kingdom Unknown     0 0 0 0     2021-01-20 05:21:54 Unknown, United Kingdom
325861 2021-01-19 United Kingdom Wales     182599 4302 0 178297 52.1307 -3.7837 2021-01-20 05:21:54 Wales, United Kingdom
577833 2021-01-18 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-19 05:22:15 Anguilla, United Kingdom
577834 2021-01-18 United Kingdom Bermuda     683 12 598 73 32.3078 -64.7505 2021-01-19 05:22:15 Bermuda, United Kingdom
577835 2021-01-18 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-19 05:22:15 British Virgin Islands, United Kingdom
577836 2021-01-18 United Kingdom Cayman Islands     380 2 330 48 19.3133 -81.2546 2021-01-19 05:22:15 Cayman Islands, United Kingdom
577837 2021-01-18 United Kingdom Channel Islands     3370 78 3073 219 49.3723 -2.3644 2021-01-19 05:22:15 Channel Islands, United Kingdom
577838 2021-01-18 United Kingdom England     2992238 78636 0 2913602 52.3555 -1.1743 2021-01-19 05:22:15 England, United Kingdom
577839 2021-01-18 United Kingdom Falkland Islands (Malvinas)     32 0 27 5 -51.7963 -59.5236 2021-01-19 05:22:15 Falkland Islands (Malvinas), United Kingdom
577840 2021-01-18 United Kingdom Gibraltar     3712 45 2840 827 36.1408 -5.3536 2021-01-19 05:22:15 Gibraltar, United Kingdom
577841 2021-01-18 United Kingdom Isle of Man     432 25 354 53 54.2361 -4.5481 2021-01-19 05:22:15 Isle of Man, United Kingdom
577842 2021-01-18 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-19 05:22:15 Montserrat, United Kingdom
577843 2021-01-18 United Kingdom Northern Ireland     96001 1625 0 94376 54.7877 -6.4923 2021-01-19 05:22:15 Northern Ireland, United Kingdom
577844 2021-01-18 United Kingdom Scotland     163762 5305 0 158457 56.4907 -4.2026 2021-01-19 05:22:15 Scotland, United Kingdom
577845 2021-01-18 United Kingdom Turks and Caicos Islands     1105 7 902 196 21.694000000000006 -71.7979 2021-01-19 05:22:15 Turks and Caicos Islands, United Kingdom
577846 2021-01-18 United Kingdom Unknown     0 0 0 0     2021-01-19 05:22:15 Unknown, United Kingdom
577847 2021-01-18 United Kingdom Wales     181493 4294 0 177199 52.1307 -3.7837 2021-01-19 05:22:15 Wales, United Kingdom
542396 2021-01-17 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-18 05:22:34 Anguilla, United Kingdom
542397 2021-01-17 United Kingdom Bermuda     670 12 583 75 32.3078 -64.7505 2021-01-18 05:22:34 Bermuda, United Kingdom
542398 2021-01-17 United Kingdom British Virgin Islands     114 1 95 18 18.4207 -64.64 2021-01-18 05:22:34 British Virgin Islands, United Kingdom
542399 2021-01-17 United Kingdom Cayman Islands     374 2 328 44 19.3133 -81.2546 2021-01-18 05:22:34 Cayman Islands, United Kingdom
542400 2021-01-17 United Kingdom Channel Islands     3363 78 3049 236 49.3723 -2.3644 2021-01-18 05:22:34 Channel Islands, United Kingdom
542401 2021-01-17 United Kingdom England     2958104 78076 0 2880028 52.3555 -1.1743 2021-01-18 05:22:34 England, United Kingdom
542402 2021-01-17 United Kingdom Falkland Islands (Malvinas)     32 0 27 5 -51.7963 -59.5236 2021-01-18 05:22:34 Falkland Islands (Malvinas), United Kingdom
542403 2021-01-17 United Kingdom Gibraltar     3670 43 2689 938 36.1408 -5.3536 2021-01-18 05:22:34 Gibraltar, United Kingdom
542404 2021-01-17 United Kingdom Isle of Man     428 25 354 49 54.2361 -4.5481 2021-01-18 05:22:34 Isle of Man, United Kingdom
542405 2021-01-17 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-18 05:22:34 Montserrat, United Kingdom
542406 2021-01-17 United Kingdom Northern Ireland     95361 1606 0 93755 54.7877 -6.4923 2021-01-18 05:22:34 Northern Ireland, United Kingdom
542407 2021-01-17 United Kingdom Scotland     162333 5305 0 157028 56.4907 -4.2026 2021-01-18 05:22:34 Scotland, United Kingdom
542408 2021-01-17 United Kingdom Turks and Caicos Islands     1102 6 890 206 21.694000000000006 -71.7979 2021-01-18 05:22:34 Turks and Caicos Islands, United Kingdom
542409 2021-01-17 United Kingdom Unknown     0 0 0 0     2021-01-18 05:22:34 Unknown, United Kingdom
542410 2021-01-17 United Kingdom Wales     180161 4274 0 175887 52.1307 -3.7837 2021-01-18 05:22:34 Wales, United Kingdom
623184 2021-01-16 United Kingdom Anguilla     15 0 15 0 18.2206 -63.0686 2021-01-17 05:22:17 Anguilla, United Kingdom
623185 2021-01-16 United Kingdom Bermuda     670 12 583 75 32.3078 -64.7505 2021-01-17 05:22:17 Bermuda, United Kingdom
623186 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
623187 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
623188 2021-01-16 United Kingdom Channel Islands     3356 76 2997 283 49.3723 -2.3644 2021-01-17 05:22:17 Channel Islands, United Kingdom
623189 2021-01-16 United Kingdom England     2922841 77478 0 2845363 52.3555 -1.1743 2021-01-17 05:22:17 England, United Kingdom
623190 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
623191 2021-01-16 United Kingdom Gibraltar     3637 34 2588 1015 36.1408 -5.3536 2021-01-17 05:22:17 Gibraltar, United Kingdom
623192 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
623193 2021-01-16 United Kingdom Montserrat     13 1 12 0 16.742498 -62.187366 2021-01-17 05:22:17 Montserrat, 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]);