johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where active = 13 and country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, last_update (date)
province_or_state 7
country_or_region 1
- United Kingdom · 47 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2768583 | 2768583 | 2021-07-01 | United Kingdom | British Virgin Islands | 313 | 1 | 299 | 13 | 18.4207 | -64.64 | 2021-07-02 04:21:47 | British Virgin Islands, United Kingdom | ||
403920 | 403920 | 2021-06-29 | United Kingdom | Isle of Man | 1611 | 29 | 1569 | 13 | 54.2361 | -4.5481 | 2021-06-30 04:21:41 | Isle of Man, United Kingdom | ||
3129156 | 3129156 | 2021-06-28 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-29 04:21:28 | Bermuda, United Kingdom | ||
2593651 | 2593651 | 2021-06-27 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-28 04:21:29 | Bermuda, United Kingdom | ||
3962155 | 3962155 | 2021-06-26 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-27 04:21:39 | Bermuda, United Kingdom | ||
1715974 | 1715974 | 2021-06-25 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-26 04:21:43 | Bermuda, United Kingdom | ||
2343048 | 2343048 | 2021-06-15 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-16 04:22:32 | Gibraltar, United Kingdom | ||
1567744 | 1567744 | 2021-06-14 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-15 04:22:22 | Gibraltar, United Kingdom | ||
1313826 | 1313826 | 2021-05-26 | United Kingdom | Turks and Caicos Islands | 2409 | 17 | 2379 | 13 | 21.694000000000006 | -71.7979 | 2021-05-27 04:20:59 | Turks and Caicos Islands, United Kingdom | ||
86752 | 86752 | 2021-05-25 | United Kingdom | Turks and Caicos Islands | 2409 | 17 | 2379 | 13 | 21.694000000000006 | -71.7979 | 2021-05-26 04:20:35 | Turks and Caicos Islands, United Kingdom | ||
1416714 | 1416714 | 2021-05-24 | United Kingdom | Turks and Caicos Islands | 2409 | 17 | 2379 | 13 | 21.694000000000006 | -71.7979 | 2021-05-25 04:21:08 | Turks and Caicos Islands, United Kingdom | ||
3057838 | 3057838 | 2021-05-13 | United Kingdom | Cayman Islands | 561 | 2 | 546 | 13 | 19.3133 | -81.2546 | 2021-05-14 04:20:41 | Cayman Islands, United Kingdom | ||
3679304 | 3679304 | 2021-05-04 | United Kingdom | Isle of Man | 1590 | 29 | 1548 | 13 | 54.2361 | -4.5481 | 2021-05-05 04:20:43 | Isle of Man, United Kingdom | ||
2764567 | 2764567 | 2021-05-03 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-05-04 04:20:34 | Channel Islands, United Kingdom | ||
2764571 | 2764571 | 2021-05-03 | United Kingdom | Isle of Man | 1590 | 29 | 1548 | 13 | 54.2361 | -4.5481 | 2021-05-04 04:20:34 | Isle of Man, United Kingdom | ||
2454420 | 2454420 | 2021-05-02 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-05-03 04:20:39 | Channel Islands, United Kingdom | ||
2454424 | 2454424 | 2021-05-02 | United Kingdom | Isle of Man | 1590 | 29 | 1548 | 13 | 54.2361 | -4.5481 | 2021-05-03 04:20:39 | Isle of Man, United Kingdom | ||
2828433 | 2828433 | 2021-05-01 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-05-02 04:20:48 | Channel Islands, United Kingdom | ||
383841 | 383841 | 2021-04-30 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-05-01 04:20:47 | Channel Islands, United Kingdom | ||
1639964 | 1639964 | 2021-04-29 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-04-30 04:21:03 | Channel Islands, United Kingdom | ||
1639968 | 1639968 | 2021-04-29 | United Kingdom | Isle of Man | 1587 | 29 | 1545 | 13 | 54.2361 | -4.5481 | 2021-04-30 04:21:03 | Isle of Man, United Kingdom | ||
3397043 | 3397043 | 2021-04-28 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-04-29 04:20:55 | Channel Islands, United Kingdom | ||
3397047 | 3397047 | 2021-04-28 | United Kingdom | Isle of Man | 1587 | 29 | 1545 | 13 | 54.2361 | -4.5481 | 2021-04-29 04:20:55 | Isle of Man, United Kingdom | ||
3705763 | 3705763 | 2021-04-27 | United Kingdom | Isle of Man | 1587 | 29 | 1545 | 13 | 54.2361 | -4.5481 | 2021-04-28 04:20:32 | Isle of Man, United Kingdom | ||
891772 | 891772 | 2021-04-26 | United Kingdom | Isle of Man | 1587 | 29 | 1545 | 13 | 54.2361 | -4.5481 | 2021-04-27 04:20:52 | Isle of Man, United Kingdom | ||
1571754 | 1571754 | 2021-04-22 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-04-23 04:20:52 | Channel Islands, United Kingdom | ||
3245975 | 3245975 | 2021-04-21 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 13 | 49.3723 | -2.3644 | 2021-04-22 04:20:53 | Channel Islands, United Kingdom | ||
3647202 | 3647202 | 2021-03-30 | United Kingdom | Gibraltar | 4274 | 94 | 4167 | 13 | 36.1408 | -5.3536 | 2021-03-31 04:26:25 | Gibraltar, United Kingdom | ||
1223217 | 1223217 | 2021-03-27 | United Kingdom | Gibraltar | 4273 | 94 | 4166 | 13 | 36.1408 | -5.3536 | 2021-03-28 05:28:10 | Gibraltar, United Kingdom | ||
1002082 | 1002082 | 2021-03-01 | United Kingdom | Bermuda | 707 | 12 | 682 | 13 | 32.3078 | -64.7505 | 2021-03-02 05:23:30 | Bermuda, United Kingdom | ||
825213 | 825213 | 2020-11-19 | United Kingdom | Cayman Islands | 258 | 2 | 243 | 13 | 19.3133 | -81.2546 | 2020-11-20 05:26:28 | Cayman Islands, United Kingdom | ||
126347 | 126347 | 2020-11-18 | United Kingdom | Cayman Islands | 258 | 2 | 243 | 13 | 19.3133 | -81.2546 | 2020-11-19 05:25:23 | Cayman Islands, United Kingdom | ||
2883848 | 2883848 | 2020-11-15 | United Kingdom | Cayman Islands | 254 | 1 | 240 | 13 | 19.3133 | -81.2546 | 2020-11-16 05:25:57 | Cayman Islands, United Kingdom | ||
2918826 | 2918826 | 2020-11-14 | United Kingdom | Cayman Islands | 254 | 1 | 240 | 13 | 19.3133 | -81.2546 | 2020-11-15 05:26:53 | Cayman Islands, United Kingdom | ||
1992274 | 1992274 | 2020-11-09 | United Kingdom | Cayman Islands | 250 | 1 | 236 | 13 | 19.3133 | -81.2546 | 2020-11-10 05:40:07 | Cayman Islands, United Kingdom | ||
1732126 | 1732126 | 2020-11-08 | United Kingdom | Cayman Islands | 250 | 1 | 236 | 13 | 19.3133 | -81.2546 | 2020-11-09 05:25:45 | Cayman Islands, United Kingdom | ||
1547586 | 1547586 | 2020-11-07 | United Kingdom | Cayman Islands | 250 | 1 | 236 | 13 | 19.3133 | -81.2546 | 2020-11-08 05:24:56 | Cayman Islands, United Kingdom | ||
213879 | 213879 | 2020-10-29 | United Kingdom | Bermuda | 198 | 9 | 176 | 13 | 32.3078 | -64.7505 | 2020-10-30 04:24:49 | Bermuda, United Kingdom | ||
371278 | 371278 | 2020-08-08 | United Kingdom | Gibraltar | 197 | 0 | 184 | 13 | 36.1408 | -5.3536 | 2020-08-09 04:34:54 | Gibraltar, United Kingdom | ||
1790323 | 1790323 | 2020-05-29 | United Kingdom | Gibraltar | 161 | 0 | 148 | 13 | 36.1408 | -5.3536 | 2020-05-30 02:32:48 | Gibraltar, United Kingdom | ||
1184128 | 1184128 | 2020-05-01 | United Kingdom | Gibraltar | 144 | 0 | 131 | 13 | 36.1408 | -5.3536 | 2020-05-02 02:32:27 | Gibraltar, United Kingdom | ||
228609 | 228609 | 2020-04-30 | United Kingdom | Gibraltar | 144 | 0 | 131 | 13 | 36.1408 | -5.3536 | 2020-05-01 02:32:28 | Gibraltar, United Kingdom | ||
3561969 | 3561969 | 2020-04-08 | United Kingdom | Bermuda | 39 | 3 | 23 | 13 | 32.3078 | -64.7505 | 2020-04-08 22:51:39 | Bermuda, United Kingdom | ||
3815801 | 3815801 | 2020-03-31 | United Kingdom | Cayman Islands | 14 | 1 | 0 | 13 | 19.3133 | -81.2546 | 2020-03-31 23:43:43 | Cayman Islands, United Kingdom | ||
919067 | 919067 | 2020-03-26 | United Kingdom | Bermuda | 15 | 0 | 2 | 13 | 32.3078 | -64.7505 | 2020-03-26 23:48:18 | Bermuda, United Kingdom | ||
2147067 | 2147067 | 2020-03-23 | United Kingdom | Isle of Man | 13 | 0 | 0 | 13 | 54.2361 | -4.5481 | 2020-03-23 23:19:21 | Isle of Man, United Kingdom | ||
2910755 | 2910755 | 2020-03-22 | United Kingdom | Gibraltar | 15 | 0 | 2 | 13 | 36.1408 | -5.3536 | 3/22/20 23:45 | Gibraltar, 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]);