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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193721 | 193721 | 2021-01-11 | United Kingdom | Scotland | 151548 | 7382 | 0 | 146579 | 56.4907 | -4.2026 | 2021-01-12 05:22:15 | Scotland, United Kingdom | ||
2629524 | 2629524 | 2021-01-10 | United Kingdom | Scotland | 149766 | 7328 | 0 | 144798 | 56.4907 | -4.2026 | 2021-01-11 05:21:50 | Scotland, United Kingdom | ||
3903612 | 3903612 | 2021-01-09 | United Kingdom | Scotland | 147889 | 7264 | 0 | 142924 | 56.4907 | -4.2026 | 2021-01-10 05:22:12 | Scotland, United Kingdom | ||
157635 | 157635 | 2021-01-08 | United Kingdom | Scotland | 146024 | 7225 | 0 | 141152 | 56.4907 | -4.2026 | 2021-01-09 05:22:18 | Scotland, United Kingdom | ||
2545059 | 2545059 | 2021-01-07 | United Kingdom | Scotland | 143715 | 7175 | 0 | 138936 | 56.4907 | -4.2026 | 2021-01-08 05:22:42 | Scotland, United Kingdom | ||
2868368 | 2868368 | 2021-01-06 | United Kingdom | Scotland | 141066 | 7127 | 0 | 136365 | 56.4907 | -4.2026 | 2021-01-07 05:22:03 | Scotland, United Kingdom | ||
3037955 | 3037955 | 2021-01-05 | United Kingdom | Scotland | 139027 | 7072 | 0 | 134394 | 56.4907 | -4.2026 | 2021-01-06 05:22:16 | Scotland, United Kingdom | ||
1065500 | 1065500 | 2021-01-04 | United Kingdom | Scotland | 136498 | 7028 | 0 | 131920 | 56.4907 | -4.2026 | 2021-01-05 05:21:49 | Scotland, United Kingdom | ||
3234103 | 3234103 | 2021-01-03 | United Kingdom | Scotland | 134593 | 6987 | 0 | 130015 | 56.4907 | -4.2026 | 2021-01-04 05:22:02 | Scotland, United Kingdom | ||
2231172 | 2231172 | 2021-01-02 | United Kingdom | Scotland | 132129 | 6939 | 0 | 127551 | 56.4907 | -4.2026 | 2021-01-03 05:22:52 | Scotland, United Kingdom | ||
1140536 | 1140536 | 2021-01-01 | United Kingdom | Scotland | 129992 | 6890 | 0 | 125414 | 56.4907 | -4.2026 | 2021-01-02 05:22:33 | Scotland, United Kingdom | ||
3699142 | 3699142 | 2020-12-31 | United Kingdom | Scotland | 127453 | 6853 | 0 | 122875 | 56.4907 | -4.2026 | 2021-01-01 05:23:07 | Scotland, United Kingdom | ||
1013957 | 1013957 | 2020-12-30 | United Kingdom | Scotland | 124831 | 6811 | 0 | 120321 | 56.4907 | -4.2026 | 2020-12-31 05:22:49 | Scotland, United Kingdom | ||
769972 | 769972 | 2020-12-29 | United Kingdom | Scotland | 122786 | 6775 | 0 | 118319 | 56.4907 | -4.2026 | 2020-12-30 05:22:34 | Scotland, United Kingdom | ||
3765236 | 3765236 | 2020-12-28 | United Kingdom | Scotland | 120891 | 6743 | 0 | 116475 | 56.4907 | -4.2026 | 2020-12-29 05:22:37 | Scotland, United Kingdom | ||
3781556 | 3781556 | 2020-12-27 | United Kingdom | Scotland | 119924 | 6711 | 0 | 115508 | 56.4907 | -4.2026 | 2020-12-28 05:22:06 | Scotland, United Kingdom | ||
2227161 | 2227161 | 2020-12-26 | United Kingdom | Scotland | 119184 | 6670 | 0 | 114768 | 56.4907 | -4.2026 | 2020-12-27 05:22:55 | Scotland, United Kingdom | ||
205908 | 205908 | 2020-12-25 | United Kingdom | Scotland | 118035 | 6635 | 0 | 113619 | 56.4907 | -4.2026 | 2020-12-26 05:22:28 | Scotland, United Kingdom | ||
3695131 | 3695131 | 2020-12-24 | United Kingdom | Scotland | 116870 | 6593 | 0 | 112454 | 56.4907 | -4.2026 | 2020-12-25 05:22:48 | Scotland, United Kingdom | ||
2410483 | 2410483 | 2020-12-23 | United Kingdom | Scotland | 115556 | 6551 | 0 | 111183 | 56.4907 | -4.2026 | 2020-12-24 05:23:04 | Scotland, United Kingdom | ||
3773529 | 3773529 | 2020-12-22 | United Kingdom | Scotland | 114366 | 6515 | 0 | 110040 | 56.4907 | -4.2026 | 2020-12-23 05:22:03 | Scotland, United Kingdom | ||
931345 | 931345 | 2020-12-21 | United Kingdom | Scotland | 113050 | 6484 | 0 | 108767 | 56.4907 | -4.2026 | 2020-12-22 05:22:33 | Scotland, United Kingdom | ||
2123366 | 2123366 | 2020-12-20 | United Kingdom | Scotland | 111546 | 6454 | 0 | 107263 | 56.4907 | -4.2026 | 2020-12-21 05:27:58 | Scotland, United Kingdom | ||
2934873 | 2934873 | 2020-12-19 | United Kingdom | Scotland | 110612 | 6422 | 0 | 106332 | 56.4907 | -4.2026 | 2020-12-20 05:27:32 | Scotland, United Kingdom | ||
1904819 | 1904819 | 2020-12-18 | United Kingdom | Scotland | 110040 | 6391 | 0 | 105801 | 56.4907 | -4.2026 | 2020-12-19 05:27:52 | Scotland, United Kingdom | ||
2131645 | 2131645 | 2020-12-17 | United Kingdom | Scotland | 109296 | 6366 | 0 | 105093 | 56.4907 | -4.2026 | 2020-12-18 05:28:18 | Scotland, United Kingdom | ||
3153245 | 3153245 | 2020-12-16 | United Kingdom | Scotland | 108438 | 6327 | 0 | 104265 | 56.4907 | -4.2026 | 2020-12-17 05:28:12 | Scotland, United Kingdom | ||
1038026 | 1038026 | 2020-12-15 | United Kingdom | Scotland | 107749 | 6293 | 0 | 103614 | 56.4907 | -4.2026 | 2020-12-16 05:28:04 | Scotland, United Kingdom | ||
1754920 | 1754920 | 2020-12-14 | United Kingdom | Scotland | 106904 | 6255 | 0 | 102793 | 56.4907 | -4.2026 | 2020-12-15 05:26:38 | Scotland, United Kingdom | ||
3851440 | 3851440 | 2020-12-13 | United Kingdom | Scotland | 106170 | 6217 | 0 | 102059 | 56.4907 | -4.2026 | 2020-12-14 05:26:27 | Scotland, United Kingdom | ||
849222 | 849222 | 2020-12-12 | United Kingdom | Scotland | 105370 | 6191 | 0 | 101261 | 56.4907 | -4.2026 | 2020-12-13 05:27:20 | Scotland, United Kingdom | ||
864329 | 864329 | 2020-12-11 | United Kingdom | Scotland | 104306 | 6165 | 0 | 100237 | 56.4907 | -4.2026 | 2020-12-12 05:26:19 | Scotland, United Kingdom | ||
1603871 | 1603871 | 2020-12-10 | United Kingdom | Scotland | 103305 | 6142 | 0 | 99266 | 56.4907 | -4.2026 | 2020-12-11 05:26:59 | Scotland, United Kingdom | ||
2978880 | 2978880 | 2020-12-09 | United Kingdom | Scotland | 102372 | 6110 | 0 | 98383 | 56.4907 | -4.2026 | 2020-12-10 05:26:19 | Scotland, United Kingdom | ||
1822440 | 1822440 | 2020-12-08 | United Kingdom | Scotland | 101475 | 6083 | 0 | 97525 | 56.4907 | -4.2026 | 2020-12-09 05:28:01 | Scotland, United Kingdom | ||
2351076 | 2351076 | 2020-12-07 | United Kingdom | Scotland | 100783 | 6050 | 0 | 96866 | 56.4907 | -4.2026 | 2020-12-08 05:27:42 | Scotland, United Kingdom | ||
1009946 | 1009946 | 2020-12-06 | United Kingdom | Scotland | 100106 | 6016 | 0 | 96190 | 56.4907 | -4.2026 | 2020-12-07 05:26:14 | Scotland, United Kingdom | ||
1635955 | 1635955 | 2020-12-05 | United Kingdom | Scotland | 99463 | 5987 | 0 | 95552 | 56.4907 | -4.2026 | 2020-12-06 05:26:18 | Scotland, United Kingdom | ||
3863483 | 3863483 | 2020-12-04 | United Kingdom | Scotland | 98686 | 5966 | 0 | 94797 | 56.4907 | -4.2026 | 2020-12-05 05:27:36 | Scotland, United Kingdom | ||
78741 | 78741 | 2020-12-03 | United Kingdom | Scotland | 97720 | 5933 | 0 | 93872 | 56.4907 | -4.2026 | 2020-12-04 05:27:27 | Scotland, United Kingdom | ||
741953 | 741953 | 2020-12-02 | United Kingdom | Scotland | 96762 | 5893 | 0 | 92965 | 56.4907 | -4.2026 | 2020-12-03 05:28:22 | Scotland, United Kingdom | ||
2541047 | 2541047 | 2020-12-01 | United Kingdom | Scotland | 95811 | 5867 | 0 | 92052 | 56.4907 | -4.2026 | 2020-12-02 05:27:41 | Scotland, United Kingdom | ||
1587816 | 1587816 | 2020-11-30 | United Kingdom | Scotland | 95058 | 5839 | 0 | 91333 | 56.4907 | -4.2026 | 2020-12-01 05:26:18 | Scotland, United Kingdom | ||
3570219 | 3570219 | 2020-11-29 | United Kingdom | Scotland | 94689 | 5798 | 0 | 90967 | 56.4907 | -4.2026 | 2020-11-30 05:26:13 | Scotland, United Kingdom | ||
2938884 | 2938884 | 2020-11-28 | United Kingdom | Scotland | 93943 | 5767 | 0 | 90223 | 56.4907 | -4.2026 | 2020-11-29 05:25:55 | Scotland, United Kingdom | ||
395887 | 395887 | 2020-11-27 | United Kingdom | Scotland | 93155 | 5724 | 0 | 89479 | 56.4907 | -4.2026 | 2020-11-28 05:25:50 | Scotland, United Kingdom | ||
927334 | 927334 | 2020-11-26 | United Kingdom | Scotland | 92186 | 5694 | 0 | 88547 | 56.4907 | -4.2026 | 2020-11-27 05:26:53 | Scotland, United Kingdom | ||
1976239 | 1976239 | 2020-11-25 | United Kingdom | Scotland | 90961 | 5665 | 0 | 87373 | 56.4907 | -4.2026 | 2020-11-26 05:27:44 | Scotland, United Kingdom | ||
1353970 | 1353970 | 2020-11-24 | United Kingdom | Scotland | 90081 | 5627 | 0 | 86537 | 56.4907 | -4.2026 | 2020-11-25 05:27:20 | Scotland, United Kingdom | ||
681964 | 681964 | 2020-11-23 | United Kingdom | Scotland | 89310 | 5594 | 0 | 85807 | 56.4907 | -4.2026 | 2020-11-24 05:27:31 | Scotland, United Kingdom | ||
3193640 | 3193640 | 2020-11-22 | United Kingdom | Scotland | 88361 | 5557 | 0 | 84858 | 56.4907 | -4.2026 | 2020-11-23 05:25:26 | Scotland, United Kingdom | ||
3840134 | 3840134 | 2020-11-21 | United Kingdom | Scotland | 87517 | 5515 | 0 | 84021 | 56.4907 | -4.2026 | 2020-11-22 05:25:45 | Scotland, United Kingdom | ||
2705162 | 2705162 | 2020-11-20 | United Kingdom | Scotland | 86630 | 5479 | 0 | 83171 | 56.4907 | -4.2026 | 2020-11-21 05:25:51 | Scotland, United Kingdom | ||
825222 | 825222 | 2020-11-19 | United Kingdom | Scotland | 85612 | 5446 | 0 | 82185 | 56.4907 | -4.2026 | 2020-11-20 05:26:28 | Scotland, United Kingdom | ||
126356 | 126356 | 2020-11-18 | United Kingdom | Scotland | 84523 | 5417 | 0 | 81146 | 56.4907 | -4.2026 | 2020-11-19 05:25:23 | Scotland, United Kingdom | ||
3342244 | 3342244 | 2020-11-17 | United Kingdom | Scotland | 83259 | 5389 | 0 | 79936 | 56.4907 | -4.2026 | 2020-11-18 05:40:31 | Scotland, United Kingdom | ||
3173289 | 3173289 | 2020-11-16 | United Kingdom | Scotland | 82011 | 5351 | 0 | 78725 | 56.4907 | -4.2026 | 2020-11-17 05:25:54 | Scotland, United Kingdom | ||
2883857 | 2883857 | 2020-11-15 | United Kingdom | Scotland | 81294 | 5317 | 0 | 78014 | 56.4907 | -4.2026 | 2020-11-16 05:25:57 | Scotland, United Kingdom | ||
2918835 | 2918835 | 2020-11-14 | United Kingdom | Scotland | 80135 | 5281 | 0 | 76855 | 56.4907 | -4.2026 | 2020-11-15 05:26:53 | Scotland, United Kingdom | ||
2788657 | 2788657 | 2020-11-13 | United Kingdom | Scotland | 79017 | 5235 | 0 | 75773 | 56.4907 | -4.2026 | 2020-11-14 05:25:37 | Scotland, United Kingdom | ||
868422 | 868422 | 2020-11-12 | United Kingdom | Scotland | 77660 | 5194 | 0 | 74472 | 56.4907 | -4.2026 | 2020-11-13 05:25:30 | Scotland, United Kingdom | ||
3444466 | 3444466 | 2020-11-11 | United Kingdom | Scotland | 76448 | 5161 | 0 | 73305 | 56.4907 | -4.2026 | 2020-11-12 05:25:55 | Scotland, United Kingdom | ||
275806 | 275806 | 2020-11-10 | United Kingdom | Scotland | 75187 | 5122 | 0 | 72108 | 56.4907 | -4.2026 | 2020-11-11 05:25:30 | Scotland, United Kingdom | ||
1992283 | 1992283 | 2020-11-09 | United Kingdom | Scotland | 74355 | 5081 | 0 | 71315 | 56.4907 | -4.2026 | 2020-11-10 05:40:07 | Scotland, United Kingdom | ||
1732135 | 1732135 | 2020-11-08 | United Kingdom | Scotland | 73443 | 5038 | 0 | 70404 | 56.4907 | -4.2026 | 2020-11-09 05:25:45 | Scotland, United Kingdom | ||
1547595 | 1547595 | 2020-11-07 | United Kingdom | Scotland | 72328 | 4998 | 0 | 69292 | 56.4907 | -4.2026 | 2020-11-08 05:24:56 | Scotland, United Kingdom | ||
379833 | 379833 | 2020-11-06 | United Kingdom | Scotland | 70732 | 4960 | 0 | 67735 | 56.4907 | -4.2026 | 2020-11-07 05:24:52 | Scotland, United Kingdom | ||
895771 | 895771 | 2020-11-05 | United Kingdom | Scotland | 69660 | 4930 | 0 | 66694 | 56.4907 | -4.2026 | 2020-11-06 05:24:55 | Scotland, United Kingdom | ||
2922833 | 2922833 | 2020-11-04 | United Kingdom | Scotland | 68444 | 4885 | 0 | 65517 | 56.4907 | -4.2026 | 2020-11-05 06:05:03 | Scotland, United Kingdom | ||
2501669 | 2501669 | 2020-11-03 | United Kingdom | Scotland | 67011 | 4863 | 0 | 64134 | 56.4907 | -4.2026 | 2020-11-04 05:25:09 | Scotland, United Kingdom | ||
3307844 | 3307844 | 2020-11-02 | United Kingdom | Scotland | 66012 | 4830 | 0 | 63163 | 56.4907 | -4.2026 | 2020-11-03 06:00:16 | Scotland, United Kingdom | ||
3413093 | 3413093 | 2020-11-01 | United Kingdom | Scotland | 65061 | 4801 | 0 | 62212 | 56.4907 | -4.2026 | 2020-11-02 05:25:04 | Scotland, United Kingdom | ||
2083582 | 2083582 | 2020-10-31 | United Kingdom | Scotland | 63913 | 4763 | 0 | 61070 | 56.4907 | -4.2026 | 2020-11-01 04:36:19 | Scotland, United Kingdom | ||
2247035 | 2247035 | 2020-10-30 | United Kingdom | Scotland | 62812 | 4736 | 0 | 59993 | 56.4907 | -4.2026 | 2020-10-31 04:24:44 | Scotland, United Kingdom | ||
213890 | 213890 | 2020-10-29 | United Kingdom | Scotland | 61531 | 4700 | 0 | 58740 | 56.4907 | -4.2026 | 2020-10-30 04:24:49 | Scotland, United Kingdom | ||
757952 | 757952 | 2020-10-28 | United Kingdom | Scotland | 60403 | 4670 | 0 | 57649 | 56.4907 | -4.2026 | 2020-10-29 04:24:49 | Scotland, United Kingdom | ||
1456236 | 1456236 | 2020-10-27 | United Kingdom | Scotland | 59201 | 4640 | 0 | 56475 | 56.4907 | -4.2026 | 2020-10-28 04:24:39 | Scotland, United Kingdom | ||
3483960 | 3483960 | 2020-10-26 | United Kingdom | Scotland | 57874 | 4619 | 0 | 55173 | 56.4907 | -4.2026 | 2020-10-27 04:24:45 | Scotland, United Kingdom | ||
11981 | 11981 | 2020-10-25 | United Kingdom | Scotland | 56752 | 4587 | 0 | 54052 | 56.4907 | -4.2026 | 2020-10-26 04:25:02 | Scotland, United Kingdom | ||
3655218 | 3655218 | 2020-10-24 | United Kingdom | Scotland | 55449 | 4565 | 0 | 52750 | 56.4907 | -4.2026 | 2020-10-25 04:24:36 | Scotland, United Kingdom | ||
1057473 | 1057473 | 2020-10-23 | United Kingdom | Scotland | 54016 | 4544 | 0 | 51328 | 56.4907 | -4.2026 | 2020-10-24 04:24:46 | Scotland, United Kingdom | ||
1181143 | 1181143 | 2020-10-22 | United Kingdom | Scotland | 52615 | 4525 | 0 | 49945 | 56.4907 | -4.2026 | 2020-10-23 04:24:46 | Scotland, United Kingdom | ||
2195248 | 2195248 | 2020-10-21 | United Kingdom | Scotland | 50903 | 4505 | 0 | 48250 | 56.4907 | -4.2026 | 2020-10-22 04:24:27 | Scotland, United Kingdom | ||
3994259 | 3994259 | 2020-10-20 | United Kingdom | Scotland | 49164 | 4490 | 0 | 46539 | 56.4907 | -4.2026 | 2020-10-21 04:24:14 | Scotland, United Kingdom | ||
1798279 | 1798279 | 2020-10-19 | United Kingdom | Scotland | 47708 | 4471 | 0 | 45098 | 56.4907 | -4.2026 | 2020-10-20 04:24:22 | Scotland, United Kingdom | ||
765962 | 765962 | 2020-10-18 | United Kingdom | Scotland | 46715 | 4453 | 0 | 44106 | 56.4907 | -4.2026 | 2020-10-19 04:24:16 | Scotland, United Kingdom | ||
1030000 | 1030000 | 2020-10-17 | United Kingdom | Scotland | 46399 | 4432 | 0 | 43790 | 56.4907 | -4.2026 | 2020-10-18 04:24:25 | Scotland, United Kingdom | ||
2860495 | 2860495 | 2020-10-16 | United Kingdom | Scotland | 45232 | 4422 | 0 | 42638 | 56.4907 | -4.2026 | 2020-10-17 04:24:12 | Scotland, United Kingdom | ||
790024 | 790024 | 2020-10-15 | United Kingdom | Scotland | 44036 | 4398 | 0 | 41451 | 56.4907 | -4.2026 | 2020-10-16 04:24:01 | Scotland, United Kingdom | ||
82735 | 82735 | 2020-10-14 | United Kingdom | Scotland | 42685 | 4382 | 0 | 40113 | 56.4907 | -4.2026 | 2020-10-15 04:24:28 | Scotland, United Kingdom | ||
3785550 | 3785550 | 2020-10-13 | United Kingdom | Scotland | 41256 | 4376 | 0 | 38699 | 56.4907 | -4.2026 | 2020-10-14 04:24:05 | Scotland, United Kingdom | ||
2295090 | 2295090 | 2020-10-12 | United Kingdom | Scotland | 39959 | 4362 | 0 | 37409 | 56.4907 | -4.2026 | 2020-10-13 04:24:02 | Scotland, United Kingdom | ||
3789542 | 3789542 | 2020-10-11 | United Kingdom | Scotland | 38998 | 4351 | 0 | 36448 | 56.4907 | -4.2026 | 2020-10-12 04:23:45 | Scotland, United Kingdom | ||
2605680 | 2605680 | 2020-10-10 | United Kingdom | Scotland | 38042 | 4339 | 0 | 35492 | 56.4907 | -4.2026 | 2020-10-11 04:23:46 | Scotland, United Kingdom | ||
821213 | 821213 | 2020-10-09 | United Kingdom | Scotland | 37033 | 4325 | 0 | 34489 | 56.4907 | -4.2026 | 2020-10-10 04:23:57 | Scotland, United Kingdom | ||
2693328 | 2693328 | 2020-10-08 | United Kingdom | Scotland | 35787 | 4318 | 0 | 33249 | 56.4907 | -4.2026 | 2020-10-09 04:23:59 | Scotland, United Kingdom | ||
1045470 | 1045470 | 2020-10-07 | United Kingdom | Scotland | 34760 | 4307 | 0 | 32227 | 56.4907 | -4.2026 | 2020-10-08 04:23:56 | Scotland, United Kingdom | ||
3121131 | 3121131 | 2020-10-06 | United Kingdom | Scotland | 33706 | 4297 | 0 | 31174 | 56.4907 | -4.2026 | 2020-10-07 04:23:40 | Scotland, United Kingdom | ||
3805543 | 3805543 | 2020-10-05 | United Kingdom | Scotland | 32906 | 4290 | 0 | 30376 | 56.4907 | -4.2026 | 2020-10-06 04:23:33 | Scotland, United Kingdom | ||
1826433 | 1826433 | 2020-10-04 | United Kingdom | Scotland | 32209 | 4289 | 0 | 29679 | 56.4907 | -4.2026 | 2020-10-05 04:23:33 | 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]);