daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "United Kingdom" and province_or_state = "Scotland" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-22 | United Kingdom | Scotland | 82603 | 0 | 37 | 0 | 0 | 56.4907 | -4.2026 | 3/22/20 23:45 | Scotland, United Kingdom | |
2020-01-25 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/25/20 17:00 | ||||
2020-04-07 | United Kingdom | Scotland | 82603 | 0 | 816 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-07 23:04:49 | Scotland, United Kingdom | |
2020-05-04 | United Kingdom | Scotland | 82603 | 0 | 3052 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-05 02:32:34 | Scotland, United Kingdom | |
2020-02-10 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-10T23:33:02 | ||||
2020-02-23 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-23T11:33:03 | ||||
2020-03-06 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-06T14:23:04 | ||||
2020-02-11 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-11T23:33:02 | ||||
2020-02-29 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-29T12:13:10 | ||||
2020-02-07 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-07T23:43:02 | ||||
2020-05-18 | United Kingdom | Scotland | 82603 | 0 | 3707 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-19 02:32:18 | Scotland, United Kingdom | |
2020-05-15 | United Kingdom | Scotland | 82603 | 0 | 3602 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-16 02:32:19 | Scotland, United Kingdom | |
2020-05-07 | United Kingdom | Scotland | 82603 | 0 | 3239 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-08 02:32:32 | Scotland, United Kingdom | |
2020-05-11 | United Kingdom | Scotland | 82603 | 0 | 3430 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-12 03:32:27 | Scotland, United Kingdom | |
2020-04-14 | United Kingdom | Scotland | 82603 | 0 | 1464 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-14 23:33:31 | Scotland, United Kingdom | |
2020-02-09 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-09T23:33:02 | ||||
2020-04-01 | United Kingdom | Scotland | 82603 | 0 | 362 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-01 21:58:49 | Scotland, United Kingdom | |
2020-02-01 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2/1/2020 11:53 | ||||
2020-05-17 | United Kingdom | Scotland | 82603 | 0 | 3673 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-18 02:32:21 | Scotland, United Kingdom | |
2020-05-10 | United Kingdom | Scotland | 82603 | 0 | 3385 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-11 02:32:30 | Scotland, United Kingdom | |
2020-02-04 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-04T23:43:01 | ||||
2020-04-25 | United Kingdom | Scotland | 82603 | 0 | 2444 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-26 02:30:51 | Scotland, United Kingdom | |
2020-02-24 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-24T11:13:09 | ||||
2020-04-08 | United Kingdom | Scotland | 82603 | 0 | 908 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-08 22:51:58 | Scotland, United Kingdom | |
2020-04-27 | United Kingdom | Scotland | 82603 | 0 | 2607 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-28 02:30:51 | Scotland, United Kingdom | |
2020-04-26 | United Kingdom | Scotland | 82603 | 0 | 2522 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-27 02:30:52 | Scotland, United Kingdom | |
2020-04-06 | United Kingdom | Scotland | 82603 | 0 | 731 | 0 | 0 | 56.4907 | -4.2026 | 4/6/20 23:22 | Scotland, United Kingdom | |
2020-05-30 | United Kingdom | Scotland | 82603 | 0 | 3968 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-31 02:32:45 | Scotland, United Kingdom | |
2020-04-02 | United Kingdom | Scotland | 82603 | 0 | 423 | 0 | 0 | 56.4907 | -4.2026 | 4/2/20 23:25 | Scotland, United Kingdom | |
2020-03-20 | United Kingdom | Scotland | 0 | 24 | 0 | 56.4907 | -4.2026 | 2020-03-20T07:43:02 | ||||
2020-04-03 | United Kingdom | Scotland | 82603 | 0 | 498 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-03 22:46:37 | Scotland, United Kingdom | |
2020-03-10 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-10T15:13:05 | ||||
2020-01-27 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/27/20 23:59 | ||||
2020-01-31 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/31/2020 23:59 | ||||
2020-03-13 | United Kingdom | Scotland | 0 | 2 | 0 | 56.4907 | -4.2026 | 2020-03-13T11:09:03 | ||||
2020-03-31 | United Kingdom | Scotland | 82603 | 0 | 297 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-31 23:43:56 | Scotland, United Kingdom | |
2020-05-13 | United Kingdom | Scotland | 82603 | 0 | 3518 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-14 03:32:28 | Scotland, United Kingdom | |
2020-06-03 | United Kingdom | Scotland | 82603 | 0 | 4011 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-04 02:33:14 | Scotland, United Kingdom | |
2020-03-17 | United Kingdom | Scotland | 0 | 11 | 0 | 56.4907 | -4.2026 | 2020-03-17T11:53:10 | ||||
2020-03-28 | United Kingdom | Scotland | 82603 | 0 | 162 | 0 | 0 | 56.4907 | -4.2026 | 3/28/20 23:05 | Scotland, United Kingdom | |
2020-04-09 | United Kingdom | Scotland | 82603 | 0 | 1016 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-09 23:02:37 | Scotland, United Kingdom | |
2020-06-11 | United Kingdom | Scotland | 15682 | 4079 | 0 | 13248 | 56.4907 | -4.2026 | 2020-06-12 05:09:52 | Scotland, United Kingdom | ||
2020-06-15 | United Kingdom | Scotland | 15687 | 4105 | 0 | 13239 | 56.4907 | -4.2026 | 2020-06-16 04:33:09 | Scotland, United Kingdom | ||
2020-06-16 | United Kingdom | Scotland | 15697 | 4113 | 0 | 13249 | 56.4907 | -4.2026 | 2020-06-17 04:33:21 | Scotland, United Kingdom | ||
2020-06-12 | United Kingdom | Scotland | 15709 | 4083 | 0 | 13270 | 56.4907 | -4.2026 | 2020-06-13 03:33:14 | Scotland, United Kingdom | ||
2020-06-17 | United Kingdom | Scotland | 15712 | 4123 | 0 | 13259 | 56.4907 | -4.2026 | 2020-06-18 04:33:18 | Scotland, United Kingdom | ||
2020-06-18 | United Kingdom | Scotland | 15718 | 4132 | 0 | 13256 | 56.4907 | -4.2026 | 2020-06-19 04:33:17 | Scotland, United Kingdom | ||
2020-06-13 | United Kingdom | Scotland | 15730 | 4089 | 0 | 13288 | 56.4907 | -4.2026 | 2020-06-14 03:33:15 | Scotland, United Kingdom | ||
2020-06-19 | United Kingdom | Scotland | 15742 | 4134 | 0 | 13278 | 56.4907 | -4.2026 | 2020-06-20 04:33:19 | Scotland, United Kingdom | ||
2020-06-14 | United Kingdom | Scotland | 15755 | 4096 | 0 | 13308 | 56.4907 | -4.2026 | 2020-06-15 03:33:14 | Scotland, United Kingdom | ||
2020-06-20 | United Kingdom | Scotland | 15757 | 4141 | 0 | 13287 | 56.4907 | -4.2026 | 2020-06-21 04:33:19 | Scotland, United Kingdom | ||
2020-06-21 | United Kingdom | Scotland | 15774 | 4149 | 0 | 13302 | 56.4907 | -4.2026 | 2020-06-22 04:33:20 | Scotland, United Kingdom | ||
2020-06-22 | United Kingdom | Scotland | 15784 | 4155 | 0 | 13312 | 56.4907 | -4.2026 | 2020-06-23 04:33:22 | Scotland, United Kingdom | ||
2020-06-23 | United Kingdom | Scotland | 15794 | 4158 | 0 | 13322 | 56.4907 | -4.2026 | 2020-06-24 04:33:28 | Scotland, United Kingdom | ||
2020-06-25 | United Kingdom | Scotland | 15802 | 4163 | 0 | 13322 | 56.4907 | -4.2026 | 2020-06-26 04:33:43 | Scotland, United Kingdom | ||
2020-06-24 | United Kingdom | Scotland | 15802 | 4161 | 0 | 13326 | 56.4907 | -4.2026 | 2020-06-25 05:26:54 | Scotland, United Kingdom | ||
2020-06-26 | United Kingdom | Scotland | 15807 | 4166 | 0 | 13325 | 56.4907 | -4.2026 | 2020-06-27 04:33:35 | Scotland, United Kingdom | ||
2020-06-27 | United Kingdom | Scotland | 15814 | 4171 | 0 | 13332 | 56.4907 | -4.2026 | 2020-06-28 04:34:04 | Scotland, United Kingdom | ||
2020-06-28 | United Kingdom | Scotland | 15815 | 4172 | 0 | 13333 | 56.4907 | -4.2026 | 2020-06-29 04:33:44 | Scotland, United Kingdom | ||
2020-06-29 | United Kingdom | Scotland | 15818 | 4174 | 0 | 13336 | 56.4907 | -4.2026 | 2020-06-30 04:33:48 | Scotland, United Kingdom | ||
2020-06-30 | United Kingdom | Scotland | 15822 | 4176 | 0 | 13340 | 56.4907 | -4.2026 | 2020-07-01 04:33:52 | Scotland, United Kingdom | ||
2020-07-01 | United Kingdom | Scotland | 15827 | 4180 | 0 | 13342 | 56.4907 | -4.2026 | 2020-07-02 04:33:46 | Scotland, United Kingdom | ||
2020-07-09 | United Kingdom | Scotland | 15851 | 4190 | 0 | 13361 | 56.4907 | -4.2026 | 2020-07-10 04:34:24 | Scotland, United Kingdom | ||
2020-07-02 | United Kingdom | Scotland | 18264 | 4181 | 0 | 15778 | 56.4907 | -4.2026 | 2020-07-03 04:33:54 | Scotland, United Kingdom | ||
2020-07-03 | United Kingdom | Scotland | 18276 | 4182 | 0 | 15789 | 56.4907 | -4.2026 | 2020-07-04 04:33:51 | Scotland, United Kingdom | ||
2020-07-04 | United Kingdom | Scotland | 18287 | 4185 | 0 | 15799 | 56.4907 | -4.2026 | 2020-07-05 04:33:46 | Scotland, United Kingdom | ||
2020-07-05 | United Kingdom | Scotland | 18296 | 4186 | 0 | 15808 | 56.4907 | -4.2026 | 2020-07-06 04:33:57 | Scotland, United Kingdom | ||
2020-07-06 | United Kingdom | Scotland | 18300 | 4189 | 0 | 15812 | 56.4907 | -4.2026 | 2020-07-07 04:34:00 | Scotland, United Kingdom | ||
2020-07-07 | United Kingdom | Scotland | 18302 | 4189 | 0 | 15814 | 56.4907 | -4.2026 | 2020-07-08 05:33:48 | Scotland, United Kingdom | ||
2020-07-08 | United Kingdom | Scotland | 18309 | 4190 | 0 | 15820 | 56.4907 | -4.2026 | 2020-07-09 04:34:23 | Scotland, United Kingdom | ||
2020-07-10 | United Kingdom | Scotland | 18333 | 4190 | 0 | 15843 | 56.4907 | -4.2026 | 2020-07-11 04:34:26 | Scotland, United Kingdom | ||
2020-07-11 | United Kingdom | Scotland | 18340 | 4193 | 0 | 15850 | 56.4907 | -4.2026 | 2020-07-12 04:34:30 | Scotland, United Kingdom | ||
2020-07-12 | United Kingdom | Scotland | 18359 | 4193 | 0 | 15869 | 56.4907 | -4.2026 | 2020-07-13 04:43:04 | Scotland, United Kingdom | ||
2020-07-13 | United Kingdom | Scotland | 18365 | 4194 | 0 | 15875 | 56.4907 | -4.2026 | 2020-07-14 04:34:46 | Scotland, United Kingdom | ||
2020-07-14 | United Kingdom | Scotland | 18368 | 4197 | 0 | 15878 | 56.4907 | -4.2026 | 2020-07-15 04:34:39 | Scotland, United Kingdom | ||
2020-07-15 | United Kingdom | Scotland | 18373 | 4199 | 0 | 15883 | 56.4907 | -4.2026 | 2020-07-16 04:44:59 | Scotland, United Kingdom | ||
2020-07-16 | United Kingdom | Scotland | 18384 | 4199 | 0 | 15894 | 56.4907 | -4.2026 | 2020-07-17 04:34:50 | Scotland, United Kingdom | ||
2020-07-17 | United Kingdom | Scotland | 18401 | 4199 | 0 | 15910 | 56.4907 | -4.2026 | 2020-07-18 04:34:45 | Scotland, United Kingdom | ||
2020-07-18 | United Kingdom | Scotland | 18422 | 4201 | 0 | 15931 | 56.4907 | -4.2026 | 2020-07-19 04:34:58 | Scotland, United Kingdom | ||
2020-07-19 | United Kingdom | Scotland | 18445 | 4203 | 0 | 15954 | 56.4907 | -4.2026 | 2020-07-20 05:34:40 | Scotland, United Kingdom | ||
2020-07-20 | United Kingdom | Scotland | 18452 | 4204 | 0 | 15961 | 56.4907 | -4.2026 | 2020-07-21 04:38:46 | Scotland, United Kingdom | ||
2020-07-21 | United Kingdom | Scotland | 18474 | 4204 | 0 | 15983 | 56.4907 | -4.2026 | 2020-07-22 04:34:42 | Scotland, United Kingdom | ||
2020-07-22 | United Kingdom | Scotland | 18484 | 4204 | 0 | 15993 | 56.4907 | -4.2026 | 2020-07-23 05:15:04 | Scotland, United Kingdom | ||
2020-07-23 | United Kingdom | Scotland | 18500 | 4204 | 0 | 16009 | 56.4907 | -4.2026 | 2020-07-24 05:30:40 | Scotland, United Kingdom | ||
2020-07-24 | United Kingdom | Scotland | 18520 | 4205 | 0 | 16029 | 56.4907 | -4.2026 | 2020-07-25 04:47:39 | Scotland, United Kingdom | ||
2020-07-25 | United Kingdom | Scotland | 18547 | 4206 | 0 | 16056 | 56.4907 | -4.2026 | 2020-07-26 04:35:00 | Scotland, United Kingdom | ||
2020-07-26 | United Kingdom | Scotland | 18551 | 4207 | 0 | 16060 | 56.4907 | -4.2026 | 2020-07-27 04:35:02 | Scotland, United Kingdom | ||
2020-07-27 | United Kingdom | Scotland | 18554 | 4207 | 0 | 16063 | 56.4907 | -4.2026 | 2020-07-28 04:58:43 | Scotland, United Kingdom | ||
2020-07-28 | United Kingdom | Scotland | 18554 | 4211 | 0 | 16063 | 56.4907 | -4.2026 | 2020-07-29 04:35:11 | Scotland, United Kingdom | ||
2020-07-29 | United Kingdom | Scotland | 18580 | 4213 | 0 | 16089 | 56.4907 | -4.2026 | 2020-07-30 04:35:05 | Scotland, United Kingdom | ||
2020-07-30 | United Kingdom | Scotland | 18597 | 4213 | 0 | 16106 | 56.4907 | -4.2026 | 2020-07-31 04:35:18 | Scotland, United Kingdom | ||
2020-07-31 | United Kingdom | Scotland | 18627 | 4213 | 0 | 16136 | 56.4907 | -4.2026 | 2020-08-01 04:36:27 | Scotland, United Kingdom | ||
2020-08-01 | United Kingdom | Scotland | 18645 | 4213 | 0 | 16154 | 56.4907 | -4.2026 | 2020-08-02 04:34:47 | Scotland, United Kingdom | ||
2020-08-02 | United Kingdom | Scotland | 18676 | 4213 | 0 | 16185 | 56.4907 | -4.2026 | 2020-08-03 04:34:35 | Scotland, United Kingdom | ||
2020-08-03 | United Kingdom | Scotland | 18694 | 4214 | 0 | 16203 | 56.4907 | -4.2026 | 2020-08-04 04:41:59 | Scotland, United Kingdom | ||
2020-08-04 | United Kingdom | Scotland | 18717 | 4215 | 0 | 16226 | 56.4907 | -4.2026 | 2020-08-05 04:34:43 | Scotland, United Kingdom | ||
2020-08-05 | United Kingdom | Scotland | 18781 | 4217 | 0 | 16290 | 56.4907 | -4.2026 | 2020-08-06 04:35:02 | Scotland, United Kingdom | ||
2020-08-06 | United Kingdom | Scotland | 18847 | 4218 | 0 | 16356 | 56.4907 | -4.2026 | 2020-08-07 04:35:11 | Scotland, United Kingdom | ||
2020-08-07 | United Kingdom | Scotland | 18890 | 4218 | 0 | 16399 | 56.4907 | -4.2026 | 2020-08-08 04:34:53 | Scotland, United Kingdom | ||
2020-08-08 | United Kingdom | Scotland | 18950 | 4218 | 0 | 16459 | 56.4907 | -4.2026 | 2020-08-09 04:34:54 | Scotland, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;