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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802411 | 1802411 | 2020-01-22 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/22/2020 17:00 | ||||
864455 | 864455 | 2020-01-23 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/23/20 17:00 | ||||
197833 | 197833 | 2020-01-24 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/24/20 17:00 | ||||
2939008 | 2939008 | 2020-01-25 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/25/20 17:00 | ||||
415910 | 415910 | 2020-01-26 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/26/20 16:00 | ||||
3753139 | 3753139 | 2020-01-27 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/27/20 23:59 | ||||
1305837 | 1305837 | 2020-01-28 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/28/20 23:00 | ||||
197924 | 197924 | 2020-01-29 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/29/20 19:30 | ||||
1527580 | 1527580 | 2020-01-30 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/30/20 16:00 | ||||
3761224 | 3761224 | 2020-01-31 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 1/31/2020 23:59 | ||||
3413187 | 3413187 | 2020-02-01 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2/1/2020 1:52 | ||||
566719 | 566719 | 2020-02-06 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2091712 | 2091712 | 2020-02-05 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2379278 | 2379278 | 2020-02-02 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2860592 | 2860592 | 2020-02-03 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
3471928 | 3471928 | 2020-02-04 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
1366089 | 1366089 | 2020-02-08 | United Kingdom | Unknown | 3 | 0 | 0 | 55.3781 | -3.436 | 2020-02-07T18:33:02 | ||||
3222048 | 3222048 | 2020-02-07 | United Kingdom | Unknown | 3 | 0 | 0 | 55.3781 | -3.436 | 2020-02-07T18:33:02 | ||||
3362419 | 3362419 | 2020-02-09 | United Kingdom | Unknown | 3 | 0 | 0 | 55.3781 | -3.436 | 2020-02-07T18:33:02 | ||||
3089042 | 3089042 | 2020-02-10 | United Kingdom | Unknown | 8 | 0 | 0 | 55.3781 | -3.436 | 2020-02-10T19:03:02 | ||||
3197743 | 3197743 | 2020-02-11 | United Kingdom | Unknown | 8 | 0 | 0 | 55.3781 | -3.436 | 2020-02-10T19:03:02 | ||||
107068 | 107068 | 2020-02-15 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
1192487 | 1192487 | 2020-02-14 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
1559694 | 1559694 | 2020-02-13 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
2567284 | 2567284 | 2020-02-12 | United Kingdom | Unknown | 9 | 0 | 1 | 55.3781 | -3.436 | 2020-02-12T19:03:06 | ||||
1085671 | 1085671 | 2020-02-22 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1243389 | 1243389 | 2020-02-17 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1720083 | 1720083 | 2020-02-19 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1783115 | 1783115 | 2020-02-18 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1888742 | 1888742 | 2020-02-16 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2135752 | 2135752 | 2020-02-21 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2263491 | 2263491 | 2020-02-20 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
3173382 | 3173382 | 2020-02-23 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
479173 | 479173 | 2020-02-25 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
2509792 | 2509792 | 2020-02-26 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
3551235 | 3551235 | 2020-02-24 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
617436 | 617436 | 2020-02-27 | United Kingdom | Unknown | 15 | 0 | 8 | 55.3781 | -3.436 | 2020-02-27T13:23:02 | ||||
2883949 | 2883949 | 2020-02-28 | United Kingdom | Unknown | 20 | 0 | 8 | 55.3781 | -3.436 | 2020-02-28T20:13:09 | ||||
3205826 | 3205826 | 2020-02-29 | United Kingdom | Unknown | 23 | 0 | 8 | 55.3781 | -3.436 | 2020-02-29T18:03:05 | ||||
562537 | 562537 | 2020-03-01 | United Kingdom | Unknown | 36 | 0 | 8 | 55.0 | -3.0 | 2020-03-01T23:23:02 | ||||
1152677 | 1152677 | 2020-03-02 | United Kingdom | Unknown | 40 | 0 | 8 | 55.0 | -3.0 | 2020-03-02T20:33:02 | ||||
261057 | 261057 | 2020-03-03 | United Kingdom | Unknown | 51 | 0 | 8 | 55.0 | -3.0 | 2020-03-03T15:13:26 | ||||
98838 | 98838 | 2020-03-04 | United Kingdom | Unknown | 85 | 0 | 8 | 55.0 | -3.0 | 2020-03-04T19:33:03 | ||||
40164 | 40164 | 2020-03-05 | United Kingdom | Unknown | 115 | 0 | 8 | 55.0 | -3.0 | 2020-03-05T18:03:03 | ||||
3177504 | 3177504 | 2020-03-06 | United Kingdom | Unknown | 163 | 0 | 8 | 55.0 | -3.0 | 2020-03-06T15:33:03 | ||||
62498 | 62498 | 2020-03-07 | United Kingdom | Unknown | 206 | 0 | 18 | 55.0 | -3.0 | 2020-03-07T17:43:05 | ||||
1527224 | 1527224 | 2020-03-08 | United Kingdom | Unknown | 273 | 0 | 18 | 55.0 | -3.0 | 2020-03-08T22:03:10 | ||||
657707 | 657707 | 2020-03-09 | United Kingdom | Unknown | 321 | 0 | 18 | 55.0 | -3.0 | 2020-03-09T18:33:03 | ||||
3752838 | 3752838 | 2020-03-10 | United Kingdom | Unknown | 382 | 0 | 18 | 55.0 | -3.0 | 2020-03-10T23:53:02 | ||||
3765370 | 3765370 | 2020-03-13 | United Kingdom | Unknown | 798 | 0 | 18 | 55.3781 | -3.436 | 2020-03-11T20:00:00 | ||||
2127454 | 2127454 | 2020-03-11 | United Kingdom | Unknown | 456 | 0 | 18 | 55.3781 | -3.436 | 2020-03-11T21:33:03 | ||||
2282885 | 2282885 | 2020-03-12 | United Kingdom | Unknown | 456 | 0 | 18 | 55.3781 | -3.436 | 2020-03-11T21:33:03 | ||||
1463473 | 1463473 | 2020-03-15 | United Kingdom | Unknown | 1140 | 1 | 18 | 55.3781 | -3.436 | 2020-03-14T14:53:04 | ||||
2111097 | 2111097 | 2020-03-14 | United Kingdom | Unknown | 1140 | 0 | 18 | 55.3781 | -3.436 | 2020-03-14T14:53:04 | ||||
2255120 | 2255120 | 2020-03-16 | United Kingdom | Unknown | 1543 | 2 | 20 | 55.3781 | -3.436 | 2020-03-16T19:13:13 | ||||
3891314 | 3891314 | 2020-03-17 | United Kingdom | Unknown | 1950 | 2 | 52 | 55.3781 | -3.436 | 2020-03-17T15:13:09 | ||||
1176883 | 1176883 | 2020-03-18 | United Kingdom | Unknown | 2626 | 2 | 65 | 55.3781 | -3.436 | 2020-03-18T14:53:05 | ||||
1526880 | 1526880 | 2020-03-19 | United Kingdom | Unknown | 2689 | 2 | 65 | 55.3781 | -3.436 | 2020-03-19T17:13:27 | ||||
3733929 | 3733929 | 2020-03-20 | United Kingdom | Unknown | 3983 | 2 | 65 | 55.3781 | -3.436 | 2020-03-20T20:13:18 | ||||
339632 | 339632 | 2020-03-21 | United Kingdom | Unknown | 5018 | 3 | 65 | 55.3781 | -3.436 | 2020-03-21T20:43:03 | ||||
2147268 | 2147268 | 2020-03-23 | United Kingdom | Unknown | 6650 | 5 | 135 | 6180 | 55.3781 | -3.436 | 2020-03-23 23:19:21 | United Kingdom | ||
1479214 | 1479214 | 2020-03-24 | United Kingdom | Unknown | 8077 | 5 | 135 | 7520 | 55.3781 | -3.436 | 2020-03-24 23:37:15 | United Kingdom | ||
1132710 | 1132710 | 2020-03-25 | United Kingdom | Unknown | 9529 | 5 | 135 | 8929 | 55.3781 | -3.436 | 2020-03-25 23:33:04 | United Kingdom | ||
919310 | 919310 | 2020-03-26 | United Kingdom | Unknown | 11658 | 8 | 135 | 10945 | 55.3781 | -3.436 | 2020-03-26 23:48:18 | United Kingdom | ||
809218 | 809218 | 2020-03-27 | United Kingdom | Unknown | 14543 | 8 | 135 | 13649 | 55.3781 | -3.436 | 2020-03-27 23:23:03 | United Kingdom | ||
3816048 | 3816048 | 2020-03-31 | United Kingdom | Unknown | 25150 | 14 | 135 | 23226 | 55.3781 | -3.436 | 2020-03-31 23:43:43 | United Kingdom | ||
3364955 | 3364955 | 2020-04-01 | United Kingdom | Unknown | 29474 | 16 | 135 | 26987 | 55.3781 | -3.436 | 2020-04-01 21:58:34 | United Kingdom | ||
3740722 | 3740722 | 2020-04-03 | United Kingdom | Unknown | 38168 | 22 | 135 | 34428 | 55.3781 | -3.436 | 2020-04-03 22:46:20 | United Kingdom | ||
589269 | 589269 | 2020-04-05 | United Kingdom | Unknown | 47806 | 24 | 135 | 42737 | 55.3781 | -3.436 | 2020-04-05 23:06:26 | United Kingdom | ||
3021900 | 3021900 | 2020-04-07 | United Kingdom | Unknown | 55242 | 27 | 135 | 48948 | 55.3781 | -3.436 | 2020-04-07 23:04:29 | United Kingdom | ||
3562225 | 3562225 | 2020-04-08 | United Kingdom | Unknown | 60733 | 29 | 135 | 53501 | 55.3781 | -3.436 | 2020-04-08 22:51:39 | United Kingdom | ||
3950118 | 3950118 | 2020-04-09 | United Kingdom | Unknown | 65077 | 33 | 135 | 56964 | 55.3781 | -3.436 | 2020-04-09 23:02:19 | United Kingdom | ||
1250381 | 1250381 | 2020-04-10 | United Kingdom | Unknown | 73758 | 33 | 344 | 64456 | 55.3781 | -3.436 | 2020-04-10 22:53:48 | United Kingdom | ||
2567196 | 2567196 | 2020-04-11 | United Kingdom | Unknown | 78991 | 36 | 344 | 68772 | 55.3781 | -3.436 | 2020-04-11 22:45:13 | United Kingdom | ||
2578359 | 2578359 | 2020-04-12 | United Kingdom | Unknown | 84279 | 38 | 344 | 73323 | 55.3781 | -3.436 | 2020-04-12 23:17:00 | 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 | ||
3338236 | 3338236 | 2020-04-14 | United Kingdom | Unknown | 93873 | 42 | 0 | 81766 | 55.3781 | -3.436 | 2020-04-14 23:33:12 | United Kingdom | ||
860320 | 860320 | 2020-04-15 | United Kingdom | Unknown | 98476 | 43 | 0 | 85608 | 55.3781 | -3.436 | 2020-04-15 22:56:32 | United Kingdom | ||
934426 | 934426 | 2020-04-16 | United Kingdom | Unknown | 103093 | 45 | 0 | 89364 | 55.3781 | -3.436 | 2020-04-16 23:30:31 | 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 | ||
418960 | 418960 | 2020-04-18 | United Kingdom | Unknown | 114217 | 51 | 0 | 98753 | 55.3781 | -3.436 | 2020-04-18 22:32:28 | United Kingdom | ||
1385272 | 1385272 | 2020-04-19 | United Kingdom | Unknown | 120067 | 51 | 0 | 104007 | 55.3781 | -3.436 | 2020-04-19 23:40:41 | United Kingdom | ||
2473580 | 2473580 | 2020-04-20 | United Kingdom | Unknown | 124743 | 52 | 0 | 108234 | 55.3781 | -3.436 | 2020-04-20 23:36:27 | United Kingdom | ||
522498 | 522498 | 2020-04-21 | United Kingdom | Unknown | 129044 | 55 | 0 | 111707 | 55.3781 | -3.436 | 2020-04-21 23:30:30 | United Kingdom | ||
1199432 | 1199432 | 2020-04-22 | United Kingdom | Unknown | 133495 | 56 | 0 | 115395 | 55.3781 | -3.436 | 2020-04-22 23:30:32 | United Kingdom | ||
2524982 | 2524982 | 2020-04-23 | United Kingdom | Unknown | 138078 | 57 | 0 | 119340 | 55.3781 | -3.436 | 2020-04-24 03:30:31 | United Kingdom | ||
1459393 | 1459393 | 2020-04-24 | United Kingdom | Unknown | 143464 | 58 | 0 | 123958 | 55.3781 | -3.436 | 2020-04-25 06:30:33 | United Kingdom | ||
3502992 | 3502992 | 2020-04-25 | United Kingdom | Unknown | 148377 | 59 | 0 | 128058 | 55.3781 | -3.436 | 2020-04-26 02:30:31 | United Kingdom | ||
3592643 | 3592643 | 2020-04-26 | United Kingdom | Unknown | 152840 | 59 | 0 | 132108 | 55.3781 | -3.436 | 2020-04-27 02:30:33 | United Kingdom | ||
3589465 | 3589465 | 2020-04-27 | United Kingdom | Unknown | 157149 | 59 | 0 | 136057 | 55.3781 | -3.436 | 2020-04-28 02:30:32 | 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 | ||
137596 | 137596 | 2020-04-29 | United Kingdom | Unknown | 165221 | 60 | 0 | 139124 | 55.3781 | -3.436 | 2020-04-30 02:32:27 | 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 | ||
1184370 | 1184370 | 2020-05-01 | United Kingdom | Unknown | 177454 | 61 | 0 | 149944 | 55.3781 | -3.436 | 2020-05-02 02:32:27 | United Kingdom | ||
2043476 | 2043476 | 2020-05-02 | United Kingdom | Unknown | 182260 | 61 | 0 | 154129 | 55.3781 | -3.436 | 2020-05-03 02:32:28 | United Kingdom | ||
2278800 | 2278800 | 2020-05-03 | United Kingdom | Unknown | 186599 | 62 | 0 | 158153 | 55.3781 | -3.436 | 2020-05-04 02:32:28 | United Kingdom | ||
3084941 | 3084941 | 2020-05-04 | United Kingdom | Unknown | 190584 | 62 | 0 | 161850 | 55.3781 | -3.436 | 2020-05-05 02:32:34 | United Kingdom | ||
1932078 | 1932078 | 2020-05-05 | United Kingdom | Unknown | 194990 | 62 | 0 | 165563 | 55.3781 | -3.436 | 2020-05-06 02:32:31 | United Kingdom | ||
2111038 | 2111038 | 2020-05-06 | United Kingdom | Unknown | 201101 | 62 | 0 | 171025 | 55.3781 | -3.436 | 2020-05-07 02:32:28 | United Kingdom | ||
3295817 | 3295817 | 2020-05-07 | United Kingdom | Unknown | 206715 | 64 | 0 | 176100 | 55.3781 | -3.436 | 2020-05-08 02:32:32 | 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]);