daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 9 and country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 4
country_or_region 1
- United Kingdom · 32 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-17 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-18 04:27:56 | British Virgin Islands, United Kingdom | ||
2020-08-16 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-17 04:27:20 | British Virgin Islands, United Kingdom | ||
2020-08-15 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-16 04:27:42 | British Virgin Islands, United Kingdom | ||
2020-08-14 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-15 04:27:31 | British Virgin Islands, United Kingdom | ||
2020-08-13 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-14 04:51:19 | British Virgin Islands, United Kingdom | ||
2020-08-12 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-13 04:29:15 | British Virgin Islands, United Kingdom | ||
2020-08-11 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-12 04:27:29 | British Virgin Islands, United Kingdom | ||
2020-08-10 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-11 04:35:08 | British Virgin Islands, United Kingdom | ||
2020-08-09 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-10 04:34:55 | British Virgin Islands, United Kingdom | ||
2020-08-08 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-09 04:34:54 | British Virgin Islands, United Kingdom | ||
2020-08-07 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-08 04:34:53 | British Virgin Islands, United Kingdom | ||
2020-08-06 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-07 04:35:11 | British Virgin Islands, United Kingdom | ||
2020-08-05 | United Kingdom | British Virgin Islands | 9 | 1 | 7 | 1 | 18.4207 | -64.64 | 2020-08-06 04:35:02 | British Virgin Islands, United Kingdom | ||
2020-04-12 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366 | 2020-04-12 23:17:00 | Montserrat, United Kingdom | ||
2020-04-12 | United Kingdom | Turks and Caicos Islands | 9 | 1 | 0 | 8 | 21.694 | -71.7979 | 2020-04-12 23:17:00 | Turks and Caicos Islands, United Kingdom | ||
2020-04-11 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366000000004 | 2020-04-11 22:45:13 | Montserrat, United Kingdom | ||
2020-04-10 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366000000004 | 2020-04-10 22:53:48 | Montserrat, United Kingdom | ||
2020-04-09 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366000000004 | 2020-04-09 23:02:19 | Montserrat, United Kingdom | ||
2020-04-08 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366000000004 | 2020-04-08 22:51:39 | Montserrat, United Kingdom | ||
2020-04-07 | United Kingdom | Montserrat | 9 | 0 | 0 | 9 | 16.742498 | -62.187366000000004 | 2020-04-07 23:04:29 | Montserrat, United Kingdom | ||
2020-02-23 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-22 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-21 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-20 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-19 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-18 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-17 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-16 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2020-02-15 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
2020-02-14 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
2020-02-13 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
2020-02-12 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;