johns_hopkins_csse_daily_reports

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

1,268 rows where country_or_region = "United Kingdom" sorted by day descending

View and edit SQL

country_or_region

  • United Kingdom · 1,268
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311646 2020-07-04 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-07-05 04:33:46 Anguilla, United Kingdom
311681 2020-07-04 United Kingdom Bermuda     146 9 137 0 32.3078 -64.7505 2020-07-05 04:33:46 Bermuda, United Kingdom
311691 2020-07-04 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-07-05 04:33:46 British Virgin Islands, United Kingdom
311710 2020-07-04 United Kingdom Cayman Islands     201 1 194 6 19.3133 -81.2546 2020-07-05 04:33:46 Cayman Islands, United Kingdom
311715 2020-07-04 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-07-05 04:33:46 Channel Islands, United Kingdom
311750 2020-07-04 United Kingdom England     244991 39626 0 205365 52.3555 -1.1743 2020-07-05 04:33:46 England, United Kingdom
311753 2020-07-04 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-07-05 04:33:46 Falkland Islands (Malvinas), United Kingdom
311765 2020-07-04 United Kingdom Gibraltar     178 0 176 2 36.1408 -5.3536 2020-07-05 04:33:46 Gibraltar, United Kingdom
311811 2020-07-04 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-07-05 04:33:46 Isle of Man, United Kingdom
311907 2020-07-04 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366000000004 2020-07-05 04:33:46 Montserrat, United Kingdom
311936 2020-07-04 United Kingdom Northern Ireland     5747 554 0 5193 54.7877 -6.4923 2020-07-05 04:33:46 Northern Ireland, United Kingdom
312025 2020-07-04 United Kingdom Scotland     18287 2488 0 15799 56.4907 -4.2026 2020-07-05 04:33:46 Scotland, United Kingdom
312078 2020-07-04 United Kingdom Turks and Caicos Islands     45 2 11 32 21.69400000000001 -71.7979 2020-07-05 04:33:46 Turks and Caicos Islands, United Kingdom
312092 2020-07-04 United Kingdom Unknown     0 0 0 0     2020-07-05 04:33:46 Unknown, United Kingdom
312117 2020-07-04 United Kingdom Wales     15875 1530 0 14345 52.1307 -3.7837 2020-07-05 04:33:46 Wales, United Kingdom
252080 2020-07-03 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-07-04 04:33:51 Anguilla, United Kingdom
252115 2020-07-03 United Kingdom Bermuda     146 9 137 0 32.3078 -64.7505 2020-07-04 04:33:51 Bermuda, United Kingdom
252125 2020-07-03 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-07-04 04:33:51 British Virgin Islands, United Kingdom
252144 2020-07-03 United Kingdom Cayman Islands     201 1 194 6 19.3133 -81.2546 2020-07-04 04:33:51 Cayman Islands, United Kingdom
252149 2020-07-03 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-07-04 04:33:51 Channel Islands, United Kingdom
252184 2020-07-03 United Kingdom England     244412 39567 0 204845 52.3555 -1.1743 2020-07-04 04:33:51 England, United Kingdom
252187 2020-07-03 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-07-04 04:33:51 Falkland Islands (Malvinas), United Kingdom
252199 2020-07-03 United Kingdom Gibraltar     178 0 176 2 36.1408 -5.3536 2020-07-04 04:33:51 Gibraltar, United Kingdom
252245 2020-07-03 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-07-04 04:33:51 Isle of Man, United Kingdom
252341 2020-07-03 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366000000004 2020-07-04 04:33:51 Montserrat, United Kingdom
252370 2020-07-03 United Kingdom Northern Ireland     5747 552 0 5195 54.7877 -6.4923 2020-07-04 04:33:51 Northern Ireland, United Kingdom
252459 2020-07-03 United Kingdom Scotland     18276 2487 0 15789 56.4907 -4.2026 2020-07-04 04:33:51 Scotland, United Kingdom
252512 2020-07-03 United Kingdom Turks and Caicos Islands     44 2 11 31 21.69400000000001 -71.7979 2020-07-04 04:33:51 Turks and Caicos Islands, United Kingdom
252526 2020-07-03 United Kingdom Unknown     0 0 0 0     2020-07-04 04:33:51 Unknown, United Kingdom
252551 2020-07-03 United Kingdom Wales     15841 1525 0 14316 52.1307 -3.7837 2020-07-04 04:33:51 Wales, United Kingdom
203461 2020-07-02 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-07-03 04:33:54 Anguilla, United Kingdom
203496 2020-07-02 United Kingdom Bermuda     146 9 135 2 32.3078 -64.7505 2020-07-03 04:33:54 Bermuda, United Kingdom
203506 2020-07-02 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-07-03 04:33:54 British Virgin Islands, United Kingdom
203525 2020-07-02 United Kingdom Cayman Islands     201 1 194 6 19.3133 -81.2546 2020-07-03 04:33:54 Cayman Islands, United Kingdom
203530 2020-07-02 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-07-03 04:33:54 Channel Islands, United Kingdom
203565 2020-07-02 United Kingdom England     243910 39434 0 204476 52.3555 -1.1743 2020-07-03 04:33:54 England, United Kingdom
203568 2020-07-02 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-07-03 04:33:54 Falkland Islands (Malvinas), United Kingdom
203580 2020-07-02 United Kingdom Gibraltar     178 0 176 2 36.1408 -5.3536 2020-07-03 04:33:54 Gibraltar, United Kingdom
203626 2020-07-02 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-07-03 04:33:54 Isle of Man, United Kingdom
203722 2020-07-02 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366 2020-07-03 04:33:54 Montserrat, United Kingdom
203751 2020-07-02 United Kingdom Northern Ireland     5768 551 0 5217 54.7877 -6.4923 2020-07-03 04:33:54 Northern Ireland, United Kingdom
203840 2020-07-02 United Kingdom Scotland     18264 2486 0 15778 56.4907 -4.2026 2020-07-03 04:33:54 Scotland, United Kingdom
203893 2020-07-02 United Kingdom Turks and Caicos Islands     44 2 11 31 21.69400000000001 -71.7979 2020-07-03 04:33:54 Turks and Caicos Islands, United Kingdom
203908 2020-07-02 United Kingdom Unknown     0 0 0 0     2020-07-03 04:33:54 Unknown, United Kingdom
203933 2020-07-02 United Kingdom Wales     15815 1524 0 14291 52.1307 -3.7837 2020-07-03 04:33:54 Wales, United Kingdom
159702 2020-07-01 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-07-02 04:33:46 Anguilla, United Kingdom
159737 2020-07-01 United Kingdom Bermuda     146 9 135 2 32.3078 -64.7505 2020-07-02 04:33:46 Bermuda, United Kingdom
159747 2020-07-01 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-07-02 04:33:46 British Virgin Islands, United Kingdom
159766 2020-07-01 United Kingdom Cayman Islands     201 1 193 7 19.3133 -81.2546 2020-07-02 04:33:46 Cayman Islands, United Kingdom
159771 2020-07-01 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-07-02 04:33:46 Channel Islands, United Kingdom
159806 2020-07-01 United Kingdom England     160764 39354 0 121410 52.3555 -1.1743 2020-07-02 04:33:46 England, United Kingdom
159809 2020-07-01 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-07-02 04:33:46 Falkland Islands (Malvinas), United Kingdom
159821 2020-07-01 United Kingdom Gibraltar     178 0 176 2 36.1408 -5.3536 2020-07-02 04:33:46 Gibraltar, United Kingdom
159867 2020-07-01 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-07-02 04:33:46 Isle of Man, United Kingdom
159963 2020-07-01 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366000000004 2020-07-02 04:33:46 Montserrat, United Kingdom
159992 2020-07-01 United Kingdom Northern Ireland     4880 551 0 4329 54.7877 -6.4923 2020-07-02 04:33:46 Northern Ireland, United Kingdom
160081 2020-07-01 United Kingdom Scotland     15827 2485 0 13342 56.4907 -4.2026 2020-07-02 04:33:46 Scotland, United Kingdom
160134 2020-07-01 United Kingdom Turks and Caicos Islands     42 2 11 29 21.69400000000001 -71.7979 2020-07-02 04:33:46 Turks and Caicos Islands, United Kingdom
160149 2020-07-01 United Kingdom Unknown     116237 0 0 116237     2020-07-02 04:33:46 Unknown, United Kingdom
160174 2020-07-01 United Kingdom Wales     15775 1516 0 14259 52.1307 -3.7837 2020-07-02 04:33:46 Wales, United Kingdom
325697 2020-06-30 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-07-01 04:33:52 Anguilla, United Kingdom
325732 2020-06-30 United Kingdom Bermuda     146 9 135 2 32.3078 -64.7505 2020-07-01 04:33:52 Bermuda, United Kingdom
325742 2020-06-30 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-07-01 04:33:52 British Virgin Islands, United Kingdom
325761 2020-06-30 United Kingdom Cayman Islands     200 1 191 8 19.3133 -81.2546 2020-07-01 04:33:52 Cayman Islands, United Kingdom
325766 2020-06-30 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-07-01 04:33:52 Channel Islands, United Kingdom
325801 2020-06-30 United Kingdom England     160587 39187 0 121400 52.3555 -1.1743 2020-07-01 04:33:52 England, United Kingdom
325804 2020-06-30 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-07-01 04:33:52 Falkland Islands (Malvinas), United Kingdom
325816 2020-06-30 United Kingdom Gibraltar     177 0 176 1 36.1408 -5.3536 2020-07-01 04:33:52 Gibraltar, United Kingdom
325862 2020-06-30 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-07-01 04:33:52 Isle of Man, United Kingdom
325958 2020-06-30 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366000000004 2020-07-01 04:33:52 Montserrat, United Kingdom
325987 2020-06-30 United Kingdom Northern Ireland     4880 551 0 4329 54.7877 -6.4923 2020-07-01 04:33:52 Northern Ireland, United Kingdom
326076 2020-06-30 United Kingdom Scotland     15822 2482 0 13340 56.4907 -4.2026 2020-07-01 04:33:52 Scotland, United Kingdom
326129 2020-06-30 United Kingdom Turks and Caicos Islands     41 2 11 28 21.69400000000001 -71.7979 2020-07-01 04:33:52 Turks and Caicos Islands, United Kingdom
326144 2020-06-30 United Kingdom Unknown     115622 0 0 115622     2020-07-01 04:33:52 Unknown, United Kingdom
326169 2020-06-30 United Kingdom Wales     15743 1510 0 14233 52.1307 -3.7837 2020-07-01 04:33:52 Wales, United Kingdom
49501 2020-06-29 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-06-30 04:33:48 Anguilla, United Kingdom
49536 2020-06-29 United Kingdom Bermuda     146 9 135 2 32.3078 -64.7505 2020-06-30 04:33:48 Bermuda, United Kingdom
49546 2020-06-29 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-06-30 04:33:48 British Virgin Islands, United Kingdom
49565 2020-06-29 United Kingdom Cayman Islands     199 1 189 9 19.3133 -81.2546 2020-06-30 04:33:48 Cayman Islands, United Kingdom
49570 2020-06-29 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-06-30 04:33:48 Channel Islands, United Kingdom
49605 2020-06-29 United Kingdom England     160391 39036 0 121355 52.3555 -1.1743 2020-06-30 04:33:48 England, United Kingdom
49608 2020-06-29 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-06-30 04:33:48 Falkland Islands (Malvinas), United Kingdom
49620 2020-06-29 United Kingdom Gibraltar     177 0 176 1 36.1408 -5.3536 2020-06-30 04:33:48 Gibraltar, United Kingdom
49666 2020-06-29 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-06-30 04:33:48 Isle of Man, United Kingdom
49762 2020-06-29 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366 2020-06-30 04:33:48 Montserrat, United Kingdom
49791 2020-06-29 United Kingdom Northern Ireland     4880 550 0 4330 54.7877 -6.4923 2020-06-30 04:33:48 Northern Ireland, United Kingdom
49880 2020-06-29 United Kingdom Scotland     15818 2482 0 13336 56.4907 -4.2026 2020-06-30 04:33:48 Scotland, United Kingdom
49933 2020-06-29 United Kingdom Turks and Caicos Islands     41 1 11 29 21.69400000000001 -71.7979 2020-06-30 04:33:48 Turks and Caicos Islands, United Kingdom
49948 2020-06-29 United Kingdom Unknown     115159 0 0 115159     2020-06-30 04:33:48 Unknown, United Kingdom
49973 2020-06-29 United Kingdom Wales     15717 1507 0 14210 52.1307 -3.7837 2020-06-30 04:33:48 Wales, United Kingdom
56207 2020-06-28 United Kingdom Anguilla     3 0 3 0 18.2206 -63.0686 2020-06-29 04:33:44 Anguilla, United Kingdom
56242 2020-06-28 United Kingdom Bermuda     146 9 134 3 32.3078 -64.7505 2020-06-29 04:33:44 Bermuda, United Kingdom
56252 2020-06-28 United Kingdom British Virgin Islands     8 1 7 0 18.4207 -64.64 2020-06-29 04:33:44 British Virgin Islands, United Kingdom
56271 2020-06-28 United Kingdom Cayman Islands     196 1 186 9 19.3133 -81.2546 2020-06-29 04:33:44 Cayman Islands, United Kingdom
56276 2020-06-28 United Kingdom Channel Islands     571 47 512 12 49.3723 -2.3644 2020-06-29 04:33:44 Channel Islands, United Kingdom
56311 2020-06-28 United Kingdom England     160292 39015 0 121277 52.3555 -1.1743 2020-06-29 04:33:44 England, United Kingdom
56314 2020-06-28 United Kingdom Falkland Islands (Malvinas)     13 0 13 0 -51.7963 -59.5236 2020-06-29 04:33:44 Falkland Islands (Malvinas), United Kingdom
56326 2020-06-28 United Kingdom Gibraltar     177 0 176 1 36.1408 -5.3536 2020-06-29 04:33:44 Gibraltar, United Kingdom
56372 2020-06-28 United Kingdom Isle of Man     336 24 312 0 54.2361 -4.5481 2020-06-29 04:33:44 Isle of Man, United Kingdom
56468 2020-06-28 United Kingdom Montserrat     11 1 10 0 16.742498 -62.187366000000004 2020-06-29 04:33:44 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
);
Powered by Datasette · Query took 2370.532ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette