johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "United Kingdom" and recovered = 6 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed
province_or_state 3
country_or_region 1
- United Kingdom · 26 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1041118 | 1041118 | 2020-05-26 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-27 02:32:31 | British Virgin Islands, United Kingdom | ||
1104848 | 1104848 | 2020-05-25 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-26 02:32:35 | British Virgin Islands, United Kingdom | ||
875528 | 875528 | 2020-05-24 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-25 02:32:44 | British Virgin Islands, United Kingdom | ||
997719 | 997719 | 2020-05-23 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-24 02:32:43 | British Virgin Islands, United Kingdom | ||
1864742 | 1864742 | 2020-05-22 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-23 02:32:42 | British Virgin Islands, United Kingdom | ||
268248 | 268248 | 2020-05-21 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-22 02:36:51 | British Virgin Islands, United Kingdom | ||
1431831 | 1431831 | 2020-05-20 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-21 02:32:48 | British Virgin Islands, United Kingdom | ||
2390111 | 2390111 | 2020-05-19 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-20 02:32:19 | British Virgin Islands, United Kingdom | ||
3260850 | 3260850 | 2020-05-18 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-19 02:32:18 | British Virgin Islands, United Kingdom | ||
3416244 | 3416244 | 2020-05-17 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-18 02:32:21 | British Virgin Islands, United Kingdom | ||
1829478 | 1829478 | 2020-05-16 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-17 02:32:32 | British Virgin Islands, United Kingdom | ||
3276194 | 3276194 | 2020-05-15 | United Kingdom | British Virgin Islands | 8 | 1 | 6 | 1 | 18.4207 | -64.64 | 2020-05-16 02:32:19 | British Virgin Islands, United Kingdom | ||
3295636 | 3295636 | 2020-05-07 | United Kingdom | Turks and Caicos Islands | 12 | 1 | 6 | 5 | 21.69400000000001 | -71.7979 | 2020-05-08 02:32:32 | Turks and Caicos Islands, United Kingdom | ||
2110857 | 2110857 | 2020-05-06 | United Kingdom | Turks and Caicos Islands | 12 | 1 | 6 | 5 | 21.69400000000001 | -71.7979 | 2020-05-07 02:32:28 | Turks and Caicos Islands, United Kingdom | ||
1931897 | 1931897 | 2020-05-05 | United Kingdom | Turks and Caicos Islands | 12 | 1 | 6 | 5 | 21.69400000000001 | -71.7979 | 2020-05-06 02:32:31 | Turks and Caicos Islands, United Kingdom | ||
3084760 | 3084760 | 2020-05-04 | United Kingdom | Turks and Caicos Islands | 12 | 1 | 6 | 5 | 21.69400000000001 | -71.7979 | 2020-05-05 02:32:34 | Turks and Caicos Islands, United Kingdom | ||
934175 | 934175 | 2020-04-16 | United Kingdom | Cayman Islands | 60 | 1 | 6 | 53 | 19.3133 | -81.2546 | 2020-04-16 23:30:31 | Cayman Islands, United Kingdom | ||
860069 | 860069 | 2020-04-15 | United Kingdom | Cayman Islands | 54 | 1 | 6 | 47 | 19.3133 | -81.2546 | 2020-04-15 22:56:32 | Cayman Islands, United Kingdom | ||
3337985 | 3337985 | 2020-04-14 | United Kingdom | Cayman Islands | 54 | 1 | 6 | 47 | 19.3133 | -81.2546 | 2020-04-14 23:33:12 | Cayman Islands, United Kingdom | ||
43082 | 43082 | 2020-04-13 | United Kingdom | Cayman Islands | 53 | 1 | 6 | 46 | 19.3133 | -81.2546 | 2020-04-13 23:07:34 | Cayman Islands, United Kingdom | ||
2578108 | 2578108 | 2020-04-12 | United Kingdom | Cayman Islands | 53 | 1 | 6 | 46 | 19.3133 | -81.2546 | 2020-04-12 23:17:00 | Cayman Islands, United Kingdom | ||
2566944 | 2566944 | 2020-04-11 | United Kingdom | Cayman Islands | 45 | 1 | 6 | 38 | 19.3133 | -81.2546 | 2020-04-11 22:45:13 | Cayman Islands, United Kingdom | ||
1250129 | 1250129 | 2020-04-10 | United Kingdom | Cayman Islands | 45 | 1 | 6 | 38 | 19.3133 | -81.2546 | 2020-04-10 22:53:48 | Cayman Islands, United Kingdom | ||
3949866 | 3949866 | 2020-04-09 | United Kingdom | Cayman Islands | 45 | 1 | 6 | 38 | 19.3133 | -81.2546 | 2020-04-09 23:02:19 | Cayman Islands, United Kingdom | ||
3561973 | 3561973 | 2020-04-08 | United Kingdom | Cayman Islands | 45 | 1 | 6 | 38 | 19.3133 | -81.2546 | 2020-04-08 22:51:39 | Cayman Islands, United Kingdom | ||
3021648 | 3021648 | 2020-04-07 | United Kingdom | Cayman Islands | 45 | 1 | 6 | 38 | 19.3133 | -81.2546 | 2020-04-07 23:04:29 | Cayman Islands, 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]);