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 = "Scotland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2732648 | 2732648 | 2020-09-15 | United Kingdom | Scotland | 23016 | 4246 | 0 | 20516 | 56.4907 | -4.2026 | 2020-09-16 04:22:53 | Scotland, United Kingdom | ||
347920 | 347920 | 2020-09-14 | United Kingdom | Scotland | 22749 | 4246 | 0 | 20250 | 56.4907 | -4.2026 | 2020-09-15 03:22:50 | Scotland, United Kingdom | ||
2872359 | 2872359 | 2020-09-13 | United Kingdom | Scotland | 22679 | 4243 | 0 | 20180 | 56.4907 | -4.2026 | 2020-09-14 04:26:00 | Scotland, United Kingdom | ||
550398 | 550398 | 2020-09-12 | United Kingdom | Scotland | 22435 | 4242 | 0 | 19936 | 56.4907 | -4.2026 | 2020-09-13 04:30:52 | Scotland, United Kingdom | ||
1448227 | 1448227 | 2020-09-11 | United Kingdom | Scotland | 22214 | 4240 | 0 | 19715 | 56.4907 | -4.2026 | 2020-09-12 04:25:05 | Scotland, United Kingdom | ||
1176828 | 1176828 | 2020-09-10 | United Kingdom | Scotland | 22039 | 4239 | 0 | 19540 | 56.4907 | -4.2026 | 2020-09-11 04:46:23 | Scotland, United Kingdom | ||
2175193 | 2175193 | 2020-09-09 | United Kingdom | Scotland | 21878 | 4239 | 0 | 19379 | 56.4907 | -4.2026 | 2020-09-10 04:29:01 | Scotland, United Kingdom | ||
1247402 | 1247402 | 2020-09-08 | United Kingdom | Scotland | 21719 | 4236 | 0 | 19220 | 56.4907 | -4.2026 | 2020-09-09 04:28:48 | Scotland, United Kingdom | ||
430981 | 430981 | 2020-09-07 | United Kingdom | Scotland | 21543 | 4236 | 0 | 19047 | 56.4907 | -4.2026 | 2020-09-08 04:28:25 | Scotland, United Kingdom | ||
3165266 | 3165266 | 2020-09-06 | United Kingdom | Scotland | 21397 | 4236 | 0 | 18901 | 56.4907 | -4.2026 | 2020-09-07 04:28:30 | Scotland, United Kingdom | ||
817221 | 817221 | 2020-09-05 | United Kingdom | Scotland | 21189 | 4236 | 0 | 18693 | 56.4907 | -4.2026 | 2020-09-06 04:28:33 | Scotland, United Kingdom | ||
2665421 | 2665421 | 2020-09-04 | United Kingdom | Scotland | 21048 | 4235 | 0 | 18552 | 56.4907 | -4.2026 | 2020-09-05 04:28:19 | Scotland, United Kingdom | ||
1357961 | 1357961 | 2020-09-03 | United Kingdom | Scotland | 20889 | 4234 | 0 | 18393 | 56.4907 | -4.2026 | 2020-09-04 04:28:26 | Scotland, United Kingdom | ||
1109198 | 1109198 | 2020-09-02 | United Kingdom | Scotland | 20788 | 4233 | 0 | 18293 | 56.4907 | -4.2026 | 2020-09-03 04:28:22 | Scotland, United Kingdom | ||
2063527 | 2063527 | 2020-09-01 | United Kingdom | Scotland | 20632 | 4232 | 0 | 18138 | 56.4907 | -4.2026 | 2020-09-02 04:28:25 | Scotland, United Kingdom | ||
197712 | 197712 | 2020-08-31 | United Kingdom | Scotland | 20478 | 4232 | 0 | 17984 | 56.4907 | -4.2026 | 2020-09-01 04:28:31 | Scotland, United Kingdom | ||
3935667 | 3935667 | 2020-08-30 | United Kingdom | Scotland | 20318 | 4232 | 0 | 17824 | 56.4907 | -4.2026 | 2020-08-31 04:28:27 | Scotland, United Kingdom | ||
613329 | 613329 | 2020-08-29 | United Kingdom | Scotland | 20195 | 4231 | 0 | 17701 | 56.4907 | -4.2026 | 2020-08-30 04:28:22 | Scotland, United Kingdom | ||
1526824 | 1526824 | 2020-08-28 | United Kingdom | Scotland | 20107 | 4231 | 0 | 17613 | 56.4907 | -4.2026 | 2020-08-29 04:28:19 | Scotland, United Kingdom | ||
2513825 | 2513825 | 2020-08-27 | United Kingdom | Scotland | 20056 | 4230 | 0 | 17562 | 56.4907 | -4.2026 | 2020-08-28 04:28:11 | Scotland, United Kingdom | ||
2000285 | 2000285 | 2020-08-26 | United Kingdom | Scotland | 19988 | 4229 | 0 | 17494 | 56.4907 | -4.2026 | 2020-08-27 04:28:15 | Scotland, United Kingdom | ||
3566209 | 3566209 | 2020-08-25 | United Kingdom | Scotland | 19921 | 4228 | 0 | 17429 | 56.4907 | -4.2026 | 2020-08-26 04:28:11 | Scotland, United Kingdom | ||
2994913 | 2994913 | 2020-08-24 | United Kingdom | Scotland | 19877 | 4227 | 0 | 17385 | 56.4907 | -4.2026 | 2020-08-25 04:28:02 | Scotland, United Kingdom | ||
2219308 | 2219308 | 2020-08-23 | United Kingdom | Scotland | 19811 | 4227 | 0 | 17319 | 56.4907 | -4.2026 | 2020-08-24 04:27:56 | Scotland, United Kingdom | ||
2303090 | 2303090 | 2020-08-22 | United Kingdom | Scotland | 19728 | 4226 | 0 | 17236 | 56.4907 | -4.2026 | 2020-08-23 04:27:48 | Scotland, United Kingdom | ||
1483196 | 1483196 | 2020-08-21 | United Kingdom | Scotland | 19605 | 4225 | 0 | 17113 | 56.4907 | -4.2026 | 2020-08-22 04:27:49 | Scotland, United Kingdom | ||
3487945 | 3487945 | 2020-08-20 | United Kingdom | Scotland | 19534 | 4225 | 0 | 17042 | 56.4907 | -4.2026 | 2020-08-21 04:27:41 | Scotland, United Kingdom | ||
209894 | 209894 | 2020-08-19 | United Kingdom | Scotland | 19457 | 4225 | 0 | 16965 | 56.4907 | -4.2026 | 2020-08-20 04:27:43 | Scotland, United Kingdom | ||
3181646 | 3181646 | 2020-08-18 | United Kingdom | Scotland | 19407 | 4223 | 0 | 16916 | 56.4907 | -4.2026 | 2020-08-19 04:27:00 | Scotland, United Kingdom | ||
841250 | 841250 | 2020-08-17 | United Kingdom | Scotland | 19358 | 4222 | 0 | 16867 | 56.4907 | -4.2026 | 2020-08-18 04:27:56 | Scotland, United Kingdom | ||
1559606 | 1559606 | 2020-08-16 | United Kingdom | Scotland | 19332 | 4221 | 0 | 16841 | 56.4907 | -4.2026 | 2020-08-17 04:27:20 | Scotland, United Kingdom | ||
149608 | 149608 | 2020-08-15 | United Kingdom | Scotland | 19289 | 4220 | 0 | 16798 | 56.4907 | -4.2026 | 2020-08-16 04:27:42 | Scotland, United Kingdom | ||
1615883 | 1615883 | 2020-08-14 | United Kingdom | Scotland | 19126 | 4219 | 0 | 16635 | 56.4907 | -4.2026 | 2020-08-15 04:27:31 | Scotland, United Kingdom | ||
586467 | 586467 | 2020-08-13 | United Kingdom | Scotland | 19126 | 4219 | 0 | 16635 | 56.4907 | -4.2026 | 2020-08-14 04:51:19 | Scotland, United Kingdom | ||
3535084 | 3535084 | 2020-08-12 | United Kingdom | Scotland | 19126 | 4218 | 0 | 16635 | 56.4907 | -4.2026 | 2020-08-13 04:29:15 | Scotland, United Kingdom | ||
662674 | 662674 | 2020-08-11 | United Kingdom | Scotland | 19027 | 4218 | 0 | 16536 | 56.4907 | -4.2026 | 2020-08-12 04:27:29 | Scotland, United Kingdom | ||
1920568 | 1920568 | 2020-08-10 | United Kingdom | Scotland | 19027 | 4218 | 0 | 16536 | 56.4907 | -4.2026 | 2020-08-11 04:35:08 | Scotland, United Kingdom | ||
3923377 | 3923377 | 2020-08-09 | United Kingdom | Scotland | 18998 | 4218 | 0 | 16507 | 56.4907 | -4.2026 | 2020-08-10 04:34:55 | Scotland, United Kingdom | ||
371545 | 371545 | 2020-08-08 | United Kingdom | Scotland | 18950 | 4218 | 0 | 16459 | 56.4907 | -4.2026 | 2020-08-09 04:34:54 | Scotland, United Kingdom | ||
458729 | 458729 | 2020-08-07 | United Kingdom | Scotland | 18890 | 4218 | 0 | 16399 | 56.4907 | -4.2026 | 2020-08-08 04:34:53 | Scotland, United Kingdom | ||
3612414 | 3612414 | 2020-08-06 | United Kingdom | Scotland | 18847 | 4218 | 0 | 16356 | 56.4907 | -4.2026 | 2020-08-07 04:35:11 | Scotland, United Kingdom | ||
3793244 | 3793244 | 2020-08-05 | United Kingdom | Scotland | 18781 | 4217 | 0 | 16290 | 56.4907 | -4.2026 | 2020-08-06 04:35:02 | Scotland, United Kingdom | ||
98480 | 98480 | 2020-08-04 | United Kingdom | Scotland | 18717 | 4215 | 0 | 16226 | 56.4907 | -4.2026 | 2020-08-05 04:34:43 | Scotland, United Kingdom | ||
2740363 | 2740363 | 2020-08-03 | United Kingdom | Scotland | 18694 | 4214 | 0 | 16203 | 56.4907 | -4.2026 | 2020-08-04 04:41:59 | Scotland, United Kingdom | ||
2808115 | 2808115 | 2020-08-02 | United Kingdom | Scotland | 18676 | 4213 | 0 | 16185 | 56.4907 | -4.2026 | 2020-08-03 04:34:35 | Scotland, United Kingdom | ||
753683 | 753683 | 2020-08-01 | United Kingdom | Scotland | 18645 | 4213 | 0 | 16154 | 56.4907 | -4.2026 | 2020-08-02 04:34:47 | Scotland, United Kingdom | ||
3264848 | 3264848 | 2020-07-31 | United Kingdom | Scotland | 18627 | 4213 | 0 | 16136 | 56.4907 | -4.2026 | 2020-08-01 04:36:27 | Scotland, United Kingdom | ||
1928555 | 1928555 | 2020-07-30 | United Kingdom | Scotland | 18597 | 4213 | 0 | 16106 | 56.4907 | -4.2026 | 2020-07-31 04:35:18 | Scotland, United Kingdom | ||
2958723 | 2958723 | 2020-07-29 | United Kingdom | Scotland | 18580 | 4213 | 0 | 16089 | 56.4907 | -4.2026 | 2020-07-30 04:35:05 | Scotland, United Kingdom | ||
3185339 | 3185339 | 2020-07-28 | United Kingdom | Scotland | 18554 | 4211 | 0 | 16063 | 56.4907 | -4.2026 | 2020-07-29 04:35:11 | Scotland, United Kingdom | ||
177390 | 177390 | 2020-07-27 | United Kingdom | Scotland | 18554 | 4207 | 0 | 16063 | 56.4907 | -4.2026 | 2020-07-28 04:58:43 | Scotland, United Kingdom | ||
442703 | 442703 | 2020-07-26 | United Kingdom | Scotland | 18551 | 4207 | 0 | 16060 | 56.4907 | -4.2026 | 2020-07-27 04:35:02 | Scotland, United Kingdom | ||
1502947 | 1502947 | 2020-07-25 | United Kingdom | Scotland | 18547 | 4206 | 0 | 16056 | 56.4907 | -4.2026 | 2020-07-26 04:35:00 | Scotland, United Kingdom | ||
2563917 | 2563917 | 2020-07-24 | United Kingdom | Scotland | 18520 | 4205 | 0 | 16029 | 56.4907 | -4.2026 | 2020-07-25 04:47:39 | Scotland, United Kingdom | ||
62125 | 62125 | 2020-07-23 | United Kingdom | Scotland | 18500 | 4204 | 0 | 16009 | 56.4907 | -4.2026 | 2020-07-24 05:30:40 | Scotland, United Kingdom | ||
844937 | 844937 | 2020-07-22 | United Kingdom | Scotland | 18484 | 4204 | 0 | 15993 | 56.4907 | -4.2026 | 2020-07-23 05:15:04 | Scotland, United Kingdom | ||
1707676 | 1707676 | 2020-07-21 | United Kingdom | Scotland | 18474 | 4204 | 0 | 15983 | 56.4907 | -4.2026 | 2020-07-22 04:34:42 | Scotland, United Kingdom | ||
327167 | 327167 | 2020-07-20 | United Kingdom | Scotland | 18452 | 4204 | 0 | 15961 | 56.4907 | -4.2026 | 2020-07-21 04:38:46 | Scotland, United Kingdom | ||
122072 | 122072 | 2020-07-19 | United Kingdom | Scotland | 18445 | 4203 | 0 | 15954 | 56.4907 | -4.2026 | 2020-07-20 05:34:40 | Scotland, United Kingdom | ||
3205461 | 3205461 | 2020-07-18 | United Kingdom | Scotland | 18422 | 4201 | 0 | 15931 | 56.4907 | -4.2026 | 2020-07-19 04:34:58 | Scotland, United Kingdom | ||
2708763 | 2708763 | 2020-07-17 | United Kingdom | Scotland | 18401 | 4199 | 0 | 15910 | 56.4907 | -4.2026 | 2020-07-18 04:34:45 | Scotland, United Kingdom | ||
367573 | 367573 | 2020-07-16 | United Kingdom | Scotland | 18384 | 4199 | 0 | 15894 | 56.4907 | -4.2026 | 2020-07-17 04:34:50 | Scotland, United Kingdom | ||
2748241 | 2748241 | 2020-07-15 | United Kingdom | Scotland | 18373 | 4199 | 0 | 15883 | 56.4907 | -4.2026 | 2020-07-16 04:44:59 | Scotland, United Kingdom | ||
2158885 | 2158885 | 2020-07-14 | United Kingdom | Scotland | 18368 | 4197 | 0 | 15878 | 56.4907 | -4.2026 | 2020-07-15 04:34:39 | Scotland, United Kingdom | ||
3491526 | 3491526 | 2020-07-13 | United Kingdom | Scotland | 18365 | 4194 | 0 | 15875 | 56.4907 | -4.2026 | 2020-07-14 04:34:46 | Scotland, United Kingdom | ||
3737789 | 3737789 | 2020-07-12 | United Kingdom | Scotland | 18359 | 4193 | 0 | 15869 | 56.4907 | -4.2026 | 2020-07-13 04:43:04 | Scotland, United Kingdom | ||
3436184 | 3436184 | 2020-07-11 | United Kingdom | Scotland | 18340 | 4193 | 0 | 15850 | 56.4907 | -4.2026 | 2020-07-12 04:34:30 | Scotland, United Kingdom | ||
3237682 | 3237682 | 2020-07-10 | United Kingdom | Scotland | 18333 | 4190 | 0 | 15843 | 56.4907 | -4.2026 | 2020-07-11 04:34:26 | Scotland, United Kingdom | ||
1005667 | 1005667 | 2020-07-09 | United Kingdom | Scotland | 15851 | 4190 | 0 | 13361 | 56.4907 | -4.2026 | 2020-07-10 04:34:24 | Scotland, United Kingdom | ||
2222883 | 2222883 | 2020-07-08 | United Kingdom | Scotland | 18309 | 4190 | 0 | 15820 | 56.4907 | -4.2026 | 2020-07-09 04:34:23 | Scotland, United Kingdom | ||
887492 | 887492 | 2020-07-07 | United Kingdom | Scotland | 18302 | 4189 | 0 | 15814 | 56.4907 | -4.2026 | 2020-07-08 05:33:48 | Scotland, United Kingdom | ||
2685052 | 2685052 | 2020-07-06 | United Kingdom | Scotland | 18300 | 4189 | 0 | 15812 | 56.4907 | -4.2026 | 2020-07-07 04:34:00 | Scotland, United Kingdom | ||
415517 | 415517 | 2020-07-05 | United Kingdom | Scotland | 18296 | 4186 | 0 | 15808 | 56.4907 | -4.2026 | 2020-07-06 04:33:57 | Scotland, United Kingdom | ||
530079 | 530079 | 2020-07-04 | United Kingdom | Scotland | 18287 | 4185 | 0 | 15799 | 56.4907 | -4.2026 | 2020-07-05 04:33:46 | Scotland, United Kingdom | ||
2234740 | 2234740 | 2020-07-03 | United Kingdom | Scotland | 18276 | 4182 | 0 | 15789 | 56.4907 | -4.2026 | 2020-07-04 04:33:51 | Scotland, United Kingdom | ||
3045534 | 3045534 | 2020-07-02 | United Kingdom | Scotland | 18264 | 4181 | 0 | 15778 | 56.4907 | -4.2026 | 2020-07-03 04:33:54 | Scotland, United Kingdom | ||
303225 | 303225 | 2020-07-01 | United Kingdom | Scotland | 15827 | 4180 | 0 | 13342 | 56.4907 | -4.2026 | 2020-07-02 04:33:46 | Scotland, United Kingdom | ||
2974603 | 2974603 | 2020-06-30 | United Kingdom | Scotland | 15822 | 4176 | 0 | 13340 | 56.4907 | -4.2026 | 2020-07-01 04:33:52 | Scotland, United Kingdom | ||
2633080 | 2633080 | 2020-06-29 | United Kingdom | Scotland | 15818 | 4174 | 0 | 13336 | 56.4907 | -4.2026 | 2020-06-30 04:33:48 | Scotland, United Kingdom | ||
2306643 | 2306643 | 2020-06-28 | United Kingdom | Scotland | 15815 | 4172 | 0 | 13333 | 56.4907 | -4.2026 | 2020-06-29 04:33:44 | Scotland, United Kingdom | ||
2039978 | 2039978 | 2020-06-27 | United Kingdom | Scotland | 15814 | 4171 | 0 | 13332 | 56.4907 | -4.2026 | 2020-06-28 04:34:04 | Scotland, United Kingdom | ||
1136259 | 1136259 | 2020-06-26 | United Kingdom | Scotland | 15807 | 4166 | 0 | 13325 | 56.4907 | -4.2026 | 2020-06-27 04:33:35 | Scotland, United Kingdom | ||
2625246 | 2625246 | 2020-06-25 | United Kingdom | Scotland | 15802 | 4163 | 0 | 13322 | 56.4907 | -4.2026 | 2020-06-26 04:33:43 | Scotland, United Kingdom | ||
2700886 | 2700886 | 2020-06-24 | United Kingdom | Scotland | 15802 | 4161 | 0 | 13326 | 56.4907 | -4.2026 | 2020-06-25 05:26:54 | Scotland, United Kingdom | ||
1522571 | 1522571 | 2020-06-23 | United Kingdom | Scotland | 15794 | 4158 | 0 | 13322 | 56.4907 | -4.2026 | 2020-06-24 04:33:28 | Scotland, United Kingdom | ||
1510765 | 1510765 | 2020-06-22 | United Kingdom | Scotland | 15784 | 4155 | 0 | 13312 | 56.4907 | -4.2026 | 2020-06-23 04:33:22 | Scotland, United Kingdom | ||
3249504 | 3249504 | 2020-06-21 | United Kingdom | Scotland | 15774 | 4149 | 0 | 13302 | 56.4907 | -4.2026 | 2020-06-22 04:33:20 | Scotland, United Kingdom | ||
2438097 | 2438097 | 2020-06-20 | United Kingdom | Scotland | 15757 | 4141 | 0 | 13287 | 56.4907 | -4.2026 | 2020-06-21 04:33:19 | Scotland, United Kingdom | ||
1691675 | 1691675 | 2020-06-19 | United Kingdom | Scotland | 15742 | 4134 | 0 | 13278 | 56.4907 | -4.2026 | 2020-06-20 04:33:19 | Scotland, United Kingdom | ||
3682824 | 3682824 | 2020-06-18 | United Kingdom | Scotland | 15718 | 4132 | 0 | 13256 | 56.4907 | -4.2026 | 2020-06-19 04:33:17 | Scotland, United Kingdom | ||
1196027 | 1196027 | 2020-06-17 | United Kingdom | Scotland | 15712 | 4123 | 0 | 13259 | 56.4907 | -4.2026 | 2020-06-18 04:33:18 | Scotland, United Kingdom | ||
2386790 | 2386790 | 2020-06-16 | United Kingdom | Scotland | 15697 | 4113 | 0 | 13249 | 56.4907 | -4.2026 | 2020-06-17 04:33:21 | Scotland, United Kingdom | ||
287353 | 287353 | 2020-06-15 | United Kingdom | Scotland | 15687 | 4105 | 0 | 13239 | 56.4907 | -4.2026 | 2020-06-16 04:33:09 | Scotland, United Kingdom | ||
1837304 | 1837304 | 2020-06-14 | United Kingdom | Scotland | 15755 | 4096 | 0 | 13308 | 56.4907 | -4.2026 | 2020-06-15 03:33:14 | Scotland, United Kingdom | ||
3061356 | 3061356 | 2020-06-13 | United Kingdom | Scotland | 15730 | 4089 | 0 | 13288 | 56.4907 | -4.2026 | 2020-06-14 03:33:15 | Scotland, United Kingdom | ||
737676 | 737676 | 2020-06-12 | United Kingdom | Scotland | 15709 | 4083 | 0 | 13270 | 56.4907 | -4.2026 | 2020-06-13 03:33:14 | Scotland, United Kingdom | ||
1273646 | 1273646 | 2020-06-11 | United Kingdom | Scotland | 15682 | 4079 | 0 | 13248 | 56.4907 | -4.2026 | 2020-06-12 05:09:52 | Scotland, United Kingdom | ||
2864398 | 2864398 | 2020-06-10 | United Kingdom | Scotland | 82603 | 0 | 4075 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-11 03:33:41 | Scotland, United Kingdom | |
1211217 | 1211217 | 2020-06-09 | United Kingdom | Scotland | 82603 | 0 | 4063 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-10 04:07:00 | Scotland, United Kingdom | |
217644 | 217644 | 2020-06-08 | United Kingdom | Scotland | 82603 | 0 | 4058 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-09 03:33:03 | Scotland, 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]);