johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "United Kingdom" and province_or_state = "Unknown" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40164 | 40164 | 2020-03-05 | United Kingdom | Unknown | 115 | 0 | 8 | 55.0 | -3.0 | 2020-03-05T18:03:03 | ||||
62498 | 62498 | 2020-03-07 | United Kingdom | Unknown | 206 | 0 | 18 | 55.0 | -3.0 | 2020-03-07T17:43:05 | ||||
98838 | 98838 | 2020-03-04 | United Kingdom | Unknown | 85 | 0 | 8 | 55.0 | -3.0 | 2020-03-04T19:33:03 | ||||
261057 | 261057 | 2020-03-03 | United Kingdom | Unknown | 51 | 0 | 8 | 55.0 | -3.0 | 2020-03-03T15:13:26 | ||||
562537 | 562537 | 2020-03-01 | United Kingdom | Unknown | 36 | 0 | 8 | 55.0 | -3.0 | 2020-03-01T23:23:02 | ||||
657707 | 657707 | 2020-03-09 | United Kingdom | Unknown | 321 | 0 | 18 | 55.0 | -3.0 | 2020-03-09T18:33:03 | ||||
1152677 | 1152677 | 2020-03-02 | United Kingdom | Unknown | 40 | 0 | 8 | 55.0 | -3.0 | 2020-03-02T20:33:02 | ||||
1527224 | 1527224 | 2020-03-08 | United Kingdom | Unknown | 273 | 0 | 18 | 55.0 | -3.0 | 2020-03-08T22:03:10 | ||||
3177504 | 3177504 | 2020-03-06 | United Kingdom | Unknown | 163 | 0 | 8 | 55.0 | -3.0 | 2020-03-06T15:33:03 | ||||
3752838 | 3752838 | 2020-03-10 | United Kingdom | Unknown | 382 | 0 | 18 | 55.0 | -3.0 | 2020-03-10T23:53:02 | ||||
3996 | 3996 | 2021-12-02 | United Kingdom | Unknown | 0 | 239 | 0 | 55.3781 | -3.436 | 2021-12-03 04:23:05 | Unknown, United Kingdom | |||
8011 | 8011 | 2021-10-28 | United Kingdom | Unknown | 0 | 228 | 0 | 55.3781 | -3.436 | 2021-10-29 04:22:03 | Unknown, United Kingdom | |||
11983 | 11983 | 2020-10-25 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-26 04:25:02 | Unknown, United Kingdom | ||
15996 | 15996 | 2021-01-26 | United Kingdom | Unknown | 0 | 137 | 0 | 0 | 55.3781 | -3.436 | 2021-01-27 05:23:41 | Unknown, United Kingdom | ||
20018 | 20018 | 2021-09-18 | United Kingdom | Unknown | 0 | 214 | 0 | 55.3781 | -3.436 | 2021-09-19 04:21:34 | Unknown, United Kingdom | |||
24029 | 24029 | 2021-05-28 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-29 04:20:41 | Unknown, United Kingdom | ||
28069 | 28069 | 2022-03-20 | United Kingdom | Unknown | 0 | 282 | 0 | 55.3781 | -3.436 | 2022-03-21 04:20:50 | Unknown, United Kingdom | |||
32082 | 32082 | 2021-11-11 | United Kingdom | Unknown | 0 | 235 | 0 | 55.3781 | -3.436 | 2021-11-12 04:22:01 | Unknown, United Kingdom | |||
36078 | 36078 | 2021-08-25 | United Kingdom | Unknown | 0 | 206 | 0 | 55.3781 | -3.436 | 2021-08-26 04:21:28 | Unknown, United Kingdom | |||
40088 | 40088 | 2021-04-12 | United Kingdom | Unknown | 0 | 182 | 0 | 0 | 55.3781 | -3.436 | 2021-04-13 04:20:37 | Unknown, United Kingdom | ||
43333 | 43333 | 2020-04-13 | United Kingdom | Unknown | 88621 | 40 | 0 | 77292 | 55.3781 | -3.436 | 2020-04-13 23:07:34 | United Kingdom | ||
47374 | 47374 | 2021-11-02 | United Kingdom | Unknown | 0 | 231 | 0 | 55.3781 | -3.436 | 2021-11-03 06:22:09 | Unknown, United Kingdom | |||
50432 | 50432 | 2020-04-17 | United Kingdom | Unknown | 108692 | 50 | 0 | 94116 | 55.3781 | -3.436 | 2020-04-17 23:30:32 | United Kingdom | ||
54450 | 54450 | 2021-05-29 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-30 04:20:55 | Unknown, United Kingdom | ||
58461 | 58461 | 2021-03-07 | United Kingdom | Unknown | 0 | 176 | 0 | 0 | 55.3781 | -3.436 | 2021-03-08 05:24:48 | Unknown, United Kingdom | ||
62187 | 62187 | 2020-07-23 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-24 05:30:40 | Unknown, United Kingdom | ||
66736 | 66736 | 2022-11-12 | United Kingdom | Unknown | 0 | 325 | 0 | 55.3781 | -3.436 | 2022-11-13 04:21:14 | Unknown, United Kingdom | |||
70723 | 70723 | 2021-09-01 | United Kingdom | Unknown | 0 | 207 | 0 | 55.3781 | -3.436 | 2021-09-02 04:21:15 | Unknown, United Kingdom | |||
74757 | 74757 | 2022-02-07 | United Kingdom | Unknown | 0 | 270 | 0 | 55.3781 | -3.436 | 2022-02-08 04:21:15 | Unknown, United Kingdom | |||
78743 | 78743 | 2020-12-03 | United Kingdom | Unknown | 0 | 88 | 0 | 0 | 55.3781 | -3.436 | 2020-12-04 05:27:27 | Unknown, United Kingdom | ||
82737 | 82737 | 2020-10-14 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-15 04:24:28 | Unknown, United Kingdom | ||
86753 | 86753 | 2021-05-25 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-26 04:20:35 | Unknown, United Kingdom | ||
90791 | 90791 | 2021-11-09 | United Kingdom | Unknown | 0 | 233 | 0 | 55.3781 | -3.436 | 2021-11-10 04:21:38 | Unknown, United Kingdom | |||
94812 | 94812 | 2022-07-23 | United Kingdom | Unknown | 0 | 307 | 0 | 55.3781 | -3.436 | 2022-07-24 04:20:47 | Unknown, United Kingdom | |||
98548 | 98548 | 2020-08-04 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-08-05 04:34:43 | Unknown, United Kingdom | ||
102992 | 102992 | 2022-01-14 | United Kingdom | Unknown | 0 | 262 | 0 | 55.3781 | -3.436 | 2022-01-15 04:21:07 | Unknown, United Kingdom | |||
106988 | 106988 | 2021-08-15 | United Kingdom | Unknown | 0 | 201 | 0 | 55.3781 | -3.436 | 2021-08-16 04:21:31 | Unknown, United Kingdom | |||
107068 | 107068 | 2020-02-15 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
111112 | 111112 | 2021-06-19 | United Kingdom | Unknown | 0 | 185 | 0 | 0 | 55.3781 | -3.436 | 2021-06-20 04:21:48 | Unknown, United Kingdom | ||
114374 | 114374 | 2020-05-08 | United Kingdom | Unknown | 211364 | 65 | 0 | 180123 | 55.3781 | -3.436 | 2020-05-09 02:32:35 | United Kingdom | ||
118422 | 118422 | 2022-09-06 | United Kingdom | Unknown | 0 | 319 | 0 | 55.3781 | -3.436 | 2022-09-07 04:20:59 | Unknown, United Kingdom | |||
122139 | 122139 | 2020-07-19 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-20 05:34:40 | Unknown, United Kingdom | ||
126358 | 126358 | 2020-11-18 | United Kingdom | Unknown | 0 | 80 | 0 | 0 | 55.3781 | -3.436 | 2020-11-19 05:25:23 | Unknown, United Kingdom | ||
130399 | 130399 | 2022-01-09 | United Kingdom | Unknown | 0 | 259 | 0 | 55.3781 | -3.436 | 2022-01-10 04:22:07 | Unknown, United Kingdom | |||
134424 | 134424 | 2022-10-04 | United Kingdom | Unknown | 0 | 320 | 0 | 55.3781 | -3.436 | 2022-10-05 04:23:06 | Unknown, United Kingdom | |||
137596 | 137596 | 2020-04-29 | United Kingdom | Unknown | 165221 | 60 | 0 | 139124 | 55.3781 | -3.436 | 2020-04-30 02:32:27 | United Kingdom | ||
141637 | 141637 | 2021-12-04 | United Kingdom | Unknown | 0 | 240 | 0 | 55.3781 | -3.436 | 2021-12-05 04:22:25 | Unknown, United Kingdom | |||
145657 | 145657 | 2022-07-09 | United Kingdom | Unknown | 0 | 302 | 0 | 55.3781 | -3.436 | 2022-07-10 04:20:54 | Unknown, United Kingdom | |||
149610 | 149610 | 2020-08-15 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-08-16 04:27:42 | Unknown, United Kingdom | ||
153650 | 153650 | 2021-11-29 | United Kingdom | Unknown | 0 | 239 | 0 | 55.3781 | -3.436 | 2021-11-30 04:22:53 | Unknown, United Kingdom | |||
157637 | 157637 | 2021-01-08 | United Kingdom | Unknown | 0 | 107 | 0 | 0 | 55.3781 | -3.436 | 2021-01-09 05:22:18 | Unknown, United Kingdom | ||
161681 | 161681 | 2022-03-29 | United Kingdom | Unknown | 0 | 285 | 0 | 55.3781 | -3.436 | 2022-03-30 04:20:45 | Unknown, United Kingdom | |||
165694 | 165694 | 2021-11-19 | United Kingdom | Unknown | 0 | 236 | 0 | 55.3781 | -3.436 | 2021-11-20 04:22:17 | Unknown, United Kingdom | |||
169714 | 169714 | 2022-06-21 | United Kingdom | Unknown | 0 | 297 | 0 | 55.3781 | -3.436 | 2022-06-22 04:20:54 | Unknown, United Kingdom | |||
173702 | 173702 | 2021-04-16 | United Kingdom | Unknown | 0 | 182 | 0 | 0 | 55.3781 | -3.436 | 2021-04-17 04:20:40 | Unknown, United Kingdom | ||
177457 | 177457 | 2020-07-27 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-28 04:58:43 | Unknown, United Kingdom | ||
181688 | 181688 | 2021-09-02 | United Kingdom | Unknown | 0 | 208 | 0 | 55.3781 | -3.436 | 2021-09-03 04:21:20 | Unknown, United Kingdom | |||
185696 | 185696 | 2021-02-21 | United Kingdom | Unknown | 0 | 167 | 0 | 0 | 55.3781 | -3.436 | 2021-02-22 05:24:21 | Unknown, United Kingdom | ||
189737 | 189737 | 2022-02-13 | United Kingdom | Unknown | 0 | 272 | 0 | 55.3781 | -3.436 | 2022-02-14 04:20:51 | Unknown, United Kingdom | |||
193723 | 193723 | 2021-01-11 | United Kingdom | Unknown | 0 | 111 | 0 | 0 | 55.3781 | -3.436 | 2021-01-12 05:22:15 | Unknown, United Kingdom | ||
197714 | 197714 | 2020-08-31 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-01 04:28:31 | Unknown, United Kingdom | ||
197833 | 197833 | 2020-01-24 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/24/20 17:00 | ||||
197924 | 197924 | 2020-01-29 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/29/20 19:30 | ||||
201933 | 201933 | 2022-10-19 | United Kingdom | Unknown | 0 | 323 | 0 | 55.3781 | -3.436 | 2022-10-20 04:22:59 | Unknown, United Kingdom | |||
205910 | 205910 | 2020-12-25 | United Kingdom | Unknown | 0 | 93 | 0 | 0 | 55.3781 | -3.436 | 2020-12-26 05:22:28 | Unknown, United Kingdom | ||
209896 | 209896 | 2020-08-19 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-08-20 04:27:43 | Unknown, United Kingdom | ||
213892 | 213892 | 2020-10-29 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-30 04:24:49 | Unknown, United Kingdom | ||
217602 | 217602 | 2020-06-08 | United Kingdom | Unknown | 287399 | 70 | 0 | 246802 | 55.3781 | -3.436 | 2020-06-09 03:33:03 | United Kingdom | ||
221654 | 221654 | 2022-12-26 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-27 04:21:07 | Unknown, United Kingdom | |||
225664 | 225664 | 2022-05-09 | United Kingdom | Unknown | 0 | 291 | 0 | 55.3781 | -3.436 | 2022-05-10 04:20:50 | Unknown, United Kingdom | |||
228851 | 228851 | 2020-04-30 | United Kingdom | Unknown | 171253 | 60 | 0 | 144482 | 55.3781 | -3.436 | 2020-05-01 02:32:28 | United Kingdom | ||
232896 | 232896 | 2022-05-31 | United Kingdom | Unknown | 0 | 293 | 0 | 55.3781 | -3.436 | 2022-06-01 04:20:55 | Unknown, United Kingdom | |||
236909 | 236909 | 2022-02-11 | United Kingdom | Unknown | 0 | 272 | 0 | 55.3781 | -3.436 | 2022-02-12 04:21:06 | Unknown, United Kingdom | |||
240896 | 240896 | 2021-01-18 | United Kingdom | Unknown | 0 | 126 | 0 | 0 | 55.3781 | -3.436 | 2021-01-19 05:22:15 | Unknown, United Kingdom | ||
244913 | 244913 | 2021-04-02 | United Kingdom | Unknown | 0 | 181 | 0 | 0 | 55.3781 | -3.436 | 2021-04-03 04:20:44 | Unknown, United Kingdom | ||
248931 | 248931 | 2021-08-17 | United Kingdom | Unknown | 0 | 201 | 0 | 55.3781 | -3.436 | 2021-08-18 04:21:35 | Unknown, United Kingdom | |||
252945 | 252945 | 2021-09-04 | United Kingdom | Unknown | 0 | 210 | 0 | 55.3781 | -3.436 | 2021-09-05 04:21:33 | Unknown, United Kingdom | |||
256984 | 256984 | 2022-09-08 | United Kingdom | Unknown | 0 | 319 | 0 | 55.3781 | -3.436 | 2022-09-09 04:21:11 | Unknown, United Kingdom | |||
261004 | 261004 | 2022-12-10 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-11 04:20:50 | Unknown, United Kingdom | |||
265201 | 265201 | 2022-03-15 | United Kingdom | Unknown | 0 | 280 | 0 | 55.3781 | -3.436 | 2022-03-16 04:20:50 | Unknown, United Kingdom | |||
268607 | 268607 | 2020-05-21 | United Kingdom | Unknown | 250908 | 68 | 0 | 214866 | 55.3781 | -3.436 | 2020-05-22 02:36:51 | United Kingdom | ||
271810 | 271810 | 2020-04-28 | United Kingdom | Unknown | 161145 | 60 | 0 | 139467 | 55.3781 | -3.436 | 2020-04-29 02:32:29 | United Kingdom | ||
275808 | 275808 | 2020-11-10 | United Kingdom | Unknown | 0 | 79 | 0 | 0 | 55.3781 | -3.436 | 2020-11-11 05:25:30 | Unknown, United Kingdom | ||
279849 | 279849 | 2021-11-03 | United Kingdom | Unknown | 0 | 231 | 0 | 55.3781 | -3.436 | 2021-11-04 04:22:20 | Unknown, United Kingdom | |||
283839 | 283839 | 2021-02-24 | United Kingdom | Unknown | 0 | 171 | 0 | 0 | 55.3781 | -3.436 | 2021-02-25 05:24:57 | Unknown, United Kingdom | ||
287421 | 287421 | 2020-06-15 | United Kingdom | Unknown | 104221 | 70 | 0 | 104221 | 55.3781 | -3.436 | 2020-06-16 04:33:09 | Unknown, United Kingdom | ||
291661 | 291661 | 2021-10-31 | United Kingdom | Unknown | 0 | 229 | 0 | 55.3781 | -3.436 | 2021-11-01 04:22:01 | Unknown, United Kingdom | |||
295687 | 295687 | 2022-11-15 | United Kingdom | Unknown | 0 | 325 | 0 | 55.3781 | -3.436 | 2022-11-16 04:21:09 | Unknown, United Kingdom | |||
299674 | 299674 | 2021-07-15 | United Kingdom | Unknown | 0 | 191 | 0 | 0 | 55.3781 | -3.436 | 2021-07-16 04:21:22 | Unknown, United Kingdom | ||
303293 | 303293 | 2020-07-01 | United Kingdom | Unknown | 116237 | 72 | 0 | 116237 | 55.3781 | -3.436 | 2020-07-02 04:33:46 | Unknown, United Kingdom | ||
307537 | 307537 | 2022-04-16 | United Kingdom | Unknown | 0 | 288 | 0 | 55.3781 | -3.436 | 2022-04-17 04:20:59 | Unknown, United Kingdom | |||
311559 | 311559 | 2022-12-13 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-14 04:21:04 | Unknown, United Kingdom | |||
315575 | 315575 | 2022-11-13 | United Kingdom | Unknown | 0 | 325 | 0 | 55.3781 | -3.436 | 2022-11-14 04:21:09 | Unknown, United Kingdom | |||
319583 | 319583 | 2022-02-12 | United Kingdom | Unknown | 0 | 272 | 0 | 55.3781 | -3.436 | 2022-02-13 04:21:00 | Unknown, United Kingdom | |||
323607 | 323607 | 2022-10-30 | United Kingdom | Unknown | 0 | 324 | 0 | 55.3781 | -3.436 | 2022-10-31 04:21:36 | Unknown, United Kingdom | |||
327234 | 327234 | 2020-07-20 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-21 04:38:46 | Unknown, United Kingdom | ||
331581 | 331581 | 2022-12-27 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-28 04:21:04 | Unknown, United Kingdom | |||
335568 | 335568 | 2021-08-04 | United Kingdom | Unknown | 0 | 198 | 0 | 0 | 55.3781 | -3.436 | 2021-08-05 04:21:51 | Unknown, United Kingdom | ||
339605 | 339605 | 2022-03-18 | United Kingdom | Unknown | 0 | 281 | 0 | 55.3781 | -3.436 | 2022-03-19 04:20:47 | Unknown, United Kingdom | |||
339632 | 339632 | 2020-03-21 | United Kingdom | Unknown | 5018 | 3 | 65 | 55.3781 | -3.436 | 2020-03-21T20:43:03 |
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]);