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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185694 | 185694 | 2021-02-21 | United Kingdom | Scotland | 197469 | 9547 | 0 | 190519 | 56.4907 | -4.2026 | 2021-02-22 05:24:21 | Scotland, United Kingdom | ||
745968 | 745968 | 2021-02-20 | United Kingdom | Scotland | 196642 | 9519 | 0 | 189697 | 56.4907 | -4.2026 | 2021-02-21 05:24:33 | Scotland, United Kingdom | ||
475066 | 475066 | 2021-02-19 | United Kingdom | Scotland | 195839 | 9483 | 0 | 188923 | 56.4907 | -4.2026 | 2021-02-20 05:22:51 | Scotland, United Kingdom | ||
1156775 | 1156775 | 2021-02-18 | United Kingdom | Scotland | 194954 | 9433 | 0 | 188069 | 56.4907 | -4.2026 | 2021-02-19 05:24:16 | Scotland, United Kingdom | ||
3604695 | 3604695 | 2021-02-17 | United Kingdom | Scotland | 194269 | 9392 | 0 | 187441 | 56.4907 | -4.2026 | 2021-02-18 05:22:58 | Scotland, United Kingdom | ||
3053830 | 3053830 | 2021-02-16 | United Kingdom | Scotland | 193148 | 9357 | 0 | 186384 | 56.4907 | -4.2026 | 2021-02-17 05:23:10 | Scotland, United Kingdom | ||
1341929 | 1341929 | 2021-02-15 | United Kingdom | Scotland | 192375 | 9323 | 0 | 185660 | 56.4907 | -4.2026 | 2021-02-16 05:24:38 | Scotland, United Kingdom | ||
2287080 | 2287080 | 2021-02-14 | United Kingdom | Scotland | 191816 | 9282 | 0 | 185101 | 56.4907 | -4.2026 | 2021-02-15 05:24:49 | Scotland, United Kingdom | ||
2681480 | 2681480 | 2021-02-13 | United Kingdom | Scotland | 190913 | 9240 | 0 | 184202 | 56.4907 | -4.2026 | 2021-02-14 05:23:43 | Scotland, United Kingdom | ||
3543113 | 3543113 | 2021-02-12 | United Kingdom | Scotland | 190005 | 9205 | 0 | 183339 | 56.4907 | -4.2026 | 2021-02-13 05:22:12 | Scotland, United Kingdom | ||
2641376 | 2641376 | 2021-02-11 | United Kingdom | Scotland | 189175 | 9158 | 0 | 182576 | 56.4907 | -4.2026 | 2021-02-12 05:23:29 | Scotland, United Kingdom | ||
3982231 | 3982231 | 2021-02-10 | United Kingdom | Scotland | 188345 | 9113 | 0 | 181794 | 56.4907 | -4.2026 | 2021-02-11 05:23:55 | Scotland, United Kingdom | ||
1531551 | 1531551 | 2021-02-09 | United Kingdom | Scotland | 187542 | 9071 | 0 | 181041 | 56.4907 | -4.2026 | 2021-02-10 05:22:41 | Scotland, United Kingdom | ||
617342 | 617342 | 2021-02-08 | United Kingdom | Scotland | 186720 | 9013 | 0 | 180277 | 56.4907 | -4.2026 | 2021-02-09 05:23:30 | Scotland, United Kingdom | ||
1676111 | 1676111 | 2021-02-07 | United Kingdom | Scotland | 185792 | 8969 | 0 | 179354 | 56.4907 | -4.2026 | 2021-02-08 05:22:39 | Scotland, United Kingdom | ||
978572 | 978572 | 2021-02-06 | United Kingdom | Scotland | 185208 | 8921 | 0 | 178777 | 56.4907 | -4.2026 | 2021-02-07 05:23:00 | Scotland, United Kingdom | ||
1591830 | 1591830 | 2021-02-05 | United Kingdom | Scotland | 184313 | 8869 | 0 | 177930 | 56.4907 | -4.2026 | 2021-02-06 05:23:55 | Scotland, United Kingdom | ||
794037 | 794037 | 2021-02-04 | United Kingdom | Scotland | 183418 | 8819 | 0 | 177096 | 56.4907 | -4.2026 | 2021-02-05 05:22:38 | Scotland, United Kingdom | ||
343929 | 343929 | 2021-02-03 | United Kingdom | Scotland | 182269 | 8779 | 0 | 176000 | 56.4907 | -4.2026 | 2021-02-04 05:22:26 | Scotland, United Kingdom | ||
1688155 | 1688155 | 2021-02-02 | United Kingdom | Scotland | 181291 | 8727 | 0 | 175110 | 56.4907 | -4.2026 | 2021-02-03 05:22:52 | Scotland, United Kingdom | ||
1680125 | 1680125 | 2021-02-01 | United Kingdom | Scotland | 180533 | 8676 | 0 | 174421 | 56.4907 | -4.2026 | 2021-02-02 05:22:49 | Scotland, United Kingdom | ||
1463413 | 1463413 | 2021-01-31 | United Kingdom | Scotland | 179685 | 8627 | 0 | 173579 | 56.4907 | -4.2026 | 2021-02-01 05:22:53 | Scotland, United Kingdom | ||
2215321 | 2215321 | 2021-01-30 | United Kingdom | Scotland | 178682 | 8576 | 0 | 172582 | 56.4907 | -4.2026 | 2021-01-31 05:22:42 | Scotland, United Kingdom | ||
1900808 | 1900808 | 2021-01-29 | United Kingdom | Scotland | 177688 | 8526 | 0 | 171648 | 56.4907 | -4.2026 | 2021-01-30 05:22:49 | Scotland, United Kingdom | ||
2485624 | 2485624 | 2021-01-28 | United Kingdom | Scotland | 176533 | 8464 | 0 | 170563 | 56.4907 | -4.2026 | 2021-01-29 05:22:23 | Scotland, United Kingdom | ||
3157259 | 3157259 | 2021-01-27 | United Kingdom | Scotland | 175332 | 8413 | 0 | 169444 | 56.4907 | -4.2026 | 2021-01-28 05:22:24 | Scotland, United Kingdom | ||
15994 | 15994 | 2021-01-26 | United Kingdom | Scotland | 174002 | 8349 | 0 | 168206 | 56.4907 | -4.2026 | 2021-01-27 05:23:41 | Scotland, United Kingdom | ||
2571318 | 2571318 | 2021-01-25 | United Kingdom | Scotland | 172953 | 8295 | 0 | 167244 | 56.4907 | -4.2026 | 2021-01-26 05:22:02 | Scotland, United Kingdom | ||
1762950 | 1762950 | 2021-01-24 | United Kingdom | Scotland | 172201 | 8239 | 0 | 166496 | 56.4907 | -4.2026 | 2021-01-25 05:22:16 | Scotland, United Kingdom | ||
2430557 | 2430557 | 2021-01-23 | United Kingdom | Scotland | 171006 | 8165 | 0 | 165302 | 56.4907 | -4.2026 | 2021-01-24 05:22:35 | Scotland, United Kingdom | ||
2470459 | 2470459 | 2021-01-22 | United Kingdom | Scotland | 169699 | 8108 | 0 | 164071 | 56.4907 | -4.2026 | 2021-01-23 05:22:03 | Scotland, United Kingdom | ||
439010 | 439010 | 2021-01-21 | United Kingdom | Scotland | 168219 | 8031 | 0 | 162662 | 56.4907 | -4.2026 | 2021-01-22 05:22:10 | Scotland, United Kingdom | ||
1097741 | 1097741 | 2021-01-20 | United Kingdom | Scotland | 166583 | 7964 | 0 | 161115 | 56.4907 | -4.2026 | 2021-01-21 05:22:01 | Scotland, United Kingdom | ||
911831 | 911831 | 2021-01-19 | United Kingdom | Scotland | 164927 | 7896 | 0 | 159551 | 56.4907 | -4.2026 | 2021-01-20 05:21:54 | Scotland, United Kingdom | ||
240894 | 240894 | 2021-01-18 | United Kingdom | Scotland | 163762 | 7819 | 0 | 158457 | 56.4907 | -4.2026 | 2021-01-19 05:22:15 | Scotland, United Kingdom | ||
3507011 | 3507011 | 2021-01-17 | United Kingdom | Scotland | 162333 | 7747 | 0 | 157028 | 56.4907 | -4.2026 | 2021-01-18 05:22:34 | Scotland, United Kingdom | ||
3105094 | 3105094 | 2021-01-16 | United Kingdom | Scotland | 160992 | 7697 | 0 | 155687 | 56.4907 | -4.2026 | 2021-01-17 05:22:17 | Scotland, United Kingdom | ||
3519056 | 3519056 | 2021-01-15 | United Kingdom | Scotland | 159239 | 7620 | 0 | 154012 | 56.4907 | -4.2026 | 2021-01-16 05:22:40 | Scotland, United Kingdom | ||
3883228 | 3883228 | 2021-01-14 | United Kingdom | Scotland | 157079 | 7556 | 0 | 151913 | 56.4907 | -4.2026 | 2021-01-15 05:22:24 | Scotland, United Kingdom | ||
3311855 | 3311855 | 2021-01-13 | United Kingdom | Scotland | 155372 | 7492 | 0 | 150270 | 56.4907 | -4.2026 | 2021-01-14 05:22:32 | Scotland, United Kingdom | ||
778000 | 778000 | 2021-01-12 | United Kingdom | Scotland | 153423 | 7439 | 0 | 148400 | 56.4907 | -4.2026 | 2021-01-13 05:22:15 | Scotland, United Kingdom | ||
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 |
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]);