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 day
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-05-01 | United Kingdom | Scotland | 82603 | 0 | 2870 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-02 02:32:27 | Scotland, United Kingdom | |
2020-05-02 | United Kingdom | Scotland | 82603 | 0 | 2930 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-03 02:32:28 | Scotland, United Kingdom | |
2020-05-03 | United Kingdom | Scotland | 82603 | 0 | 2990 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-04 02:32:28 | 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-05-05 | United Kingdom | Scotland | 82603 | 0 | 3119 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-06 02:32:31 | Scotland, United Kingdom | |
2020-05-06 | United Kingdom | Scotland | 82603 | 0 | 3178 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-07 02:32:28 | 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-08 | United Kingdom | Scotland | 82603 | 0 | 3297 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-09 02:32:35 | Scotland, United Kingdom | |
2020-05-09 | United Kingdom | Scotland | 82603 | 0 | 3347 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-10 02:32:30 | 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-05-11 | United Kingdom | Scotland | 82603 | 0 | 3430 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-12 03:32:27 | Scotland, United Kingdom | |
2020-05-12 | United Kingdom | Scotland | 82603 | 0 | 3465 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-13 03:32:26 | 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-05-14 | United Kingdom | Scotland | 82603 | 0 | 3568 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-15 02:33:02 | 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-16 | United Kingdom | Scotland | 82603 | 0 | 3639 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-17 02:32:32 | Scotland, United Kingdom | |
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-18 | United Kingdom | Scotland | 82603 | 0 | 3707 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-19 02:32:18 | Scotland, United Kingdom | |
2020-05-19 | United Kingdom | Scotland | 82603 | 0 | 3738 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-20 02:32:19 | Scotland, United Kingdom | |
2020-05-20 | United Kingdom | Scotland | 82603 | 0 | 3767 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-21 02:32:48 | Scotland, United Kingdom | |
2020-05-21 | United Kingdom | Scotland | 82603 | 0 | 3801 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-22 02:36:51 | Scotland, United Kingdom | |
2020-05-22 | United Kingdom | Scotland | 82603 | 0 | 3820 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-23 02:32:42 | Scotland, United Kingdom | |
2020-05-23 | United Kingdom | Scotland | 82603 | 0 | 3835 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-24 02:32:43 | Scotland, United Kingdom | |
2020-05-24 | United Kingdom | Scotland | 82603 | 0 | 3849 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-25 02:32:44 | Scotland, United Kingdom | |
2020-05-25 | United Kingdom | Scotland | 82603 | 0 | 3871 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-26 02:32:35 | Scotland, United Kingdom | |
2020-05-26 | United Kingdom | Scotland | 82603 | 0 | 3892 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-27 02:32:31 | Scotland, United Kingdom | |
2020-05-27 | United Kingdom | Scotland | 82603 | 0 | 3915 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-28 02:32:31 | Scotland, United Kingdom | |
2020-05-28 | United Kingdom | Scotland | 82603 | 0 | 3937 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-29 02:32:50 | Scotland, United Kingdom | |
2020-05-29 | United Kingdom | Scotland | 82603 | 0 | 3956 | 0 | 0 | 56.4907 | -4.2026 | 2020-05-30 02:32:48 | 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-05-31 | United Kingdom | Scotland | 82603 | 0 | 3979 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-01 02:32:46 | Scotland, United Kingdom | |
2020-06-01 | United Kingdom | Scotland | 82603 | 0 | 3985 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-02 02:33:08 | Scotland, United Kingdom | |
2020-06-02 | United Kingdom | Scotland | 82603 | 0 | 3999 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-03 02:33:13 | 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-06-04 | United Kingdom | Scotland | 82603 | 0 | 4016 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-05 02:33:06 | Scotland, United Kingdom | |
2020-06-05 | United Kingdom | Scotland | 82603 | 0 | 4031 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-06 02:33:00 | Scotland, United Kingdom | |
2020-06-06 | United Kingdom | Scotland | 82603 | 0 | 4039 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-07 03:53:30 | Scotland, United Kingdom | |
2020-06-07 | United Kingdom | Scotland | 82603 | 0 | 4049 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-08 03:33:22 | Scotland, United Kingdom | |
2020-06-08 | United Kingdom | Scotland | 82603 | 0 | 4058 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-09 03:33:03 | Scotland, United Kingdom | |
2020-06-09 | United Kingdom | Scotland | 82603 | 0 | 4063 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-10 04:07:00 | Scotland, United Kingdom | |
2020-06-10 | United Kingdom | Scotland | 82603 | 0 | 4075 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-11 03:33:41 | 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-12 | United Kingdom | Scotland | 15709 | 4083 | 0 | 13270 | 56.4907 | -4.2026 | 2020-06-13 03:33:14 | 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-14 | United Kingdom | Scotland | 15755 | 4096 | 0 | 13308 | 56.4907 | -4.2026 | 2020-06-15 03:33:14 | 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-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-19 | United Kingdom | Scotland | 15742 | 4134 | 0 | 13278 | 56.4907 | -4.2026 | 2020-06-20 04:33:19 | 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-24 | United Kingdom | Scotland | 15802 | 4161 | 0 | 13326 | 56.4907 | -4.2026 | 2020-06-25 05:26:54 | 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-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-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-09 | United Kingdom | Scotland | 15851 | 4190 | 0 | 13361 | 56.4907 | -4.2026 | 2020-07-10 04:34:24 | 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;