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 admin2
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-07-16 | United Kingdom | Scotland | 18384 | 4199 | 0 | 15894 | 56.4907 | -4.2026 | 2020-07-17 04:34:50 | 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 | ||
2022-09-13 | United Kingdom | Scotland | 2095171 | 15700 | 0 | 56.4907 | -4.2026 | 2022-09-14 04:20:44 | Scotland, United Kingdom | |||
2020-11-06 | United Kingdom | Scotland | 70732 | 4960 | 0 | 67735 | 56.4907 | -4.2026 | 2020-11-07 05:24:52 | Scotland, United Kingdom | ||
2021-04-30 | United Kingdom | Scotland | 226052 | 10116 | 0 | 218393 | 56.4907 | -4.2026 | 2021-05-01 04:20:47 | Scotland, United Kingdom | ||
2022-09-23 | United Kingdom | Scotland | 2101498 | 15754 | 0 | 56.4907 | -4.2026 | 2022-09-24 04:21:40 | Scotland, United Kingdom | |||
2021-04-04 | United Kingdom | Scotland | 219986 | 10040 | 0 | 212372 | 56.4907 | -4.2026 | 2021-04-05 04:20:35 | Scotland, United Kingdom | ||
2020-11-27 | United Kingdom | Scotland | 93155 | 5724 | 0 | 89479 | 56.4907 | -4.2026 | 2020-11-28 05:25:50 | Scotland, United Kingdom | ||
2022-10-07 | United Kingdom | Scotland | 2107886 | 15848 | 0 | 56.4907 | -4.2026 | 2022-10-08 04:22:56 | Scotland, United Kingdom | |||
2021-06-29 | United Kingdom | Scotland | 277335 | 10207 | 0 | 269622 | 56.4907 | -4.2026 | 2021-06-30 04:21:41 | Scotland, United Kingdom | ||
2021-12-07 | United Kingdom | Scotland | 746549 | 12356 | 0 | 56.4907 | -4.2026 | 2021-12-08 04:22:46 | Scotland, United Kingdom | |||
2021-07-28 | United Kingdom | Scotland | 341307 | 10399 | 0 | 333396 | 56.4907 | -4.2026 | 2021-07-29 04:21:33 | 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-01-26 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/26/20 16:00 | ||||
2020-04-18 | United Kingdom | Scotland | 82603 | 0 | 1838 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-18 22:32:47 | Scotland, United Kingdom | |
2022-09-18 | United Kingdom | Scotland | 2098635 | 15733 | 0 | 56.4907 | -4.2026 | 2022-09-19 04:21:49 | Scotland, United Kingdom | |||
2021-10-10 | United Kingdom | Scotland | 590424 | 11404 | 0 | 56.4907 | -4.2026 | 2021-10-11 04:21:31 | Scotland, United Kingdom | |||
2020-09-07 | United Kingdom | Scotland | 21543 | 4236 | 0 | 19047 | 56.4907 | -4.2026 | 2020-09-08 04:28:25 | Scotland, United Kingdom | ||
2022-11-03 | United Kingdom | Scotland | 2121084 | 16015 | 0 | 56.4907 | -4.2026 | 2022-11-04 04:22:11 | Scotland, United Kingdom | |||
2021-01-21 | United Kingdom | Scotland | 168219 | 8031 | 0 | 162662 | 56.4907 | -4.2026 | 2021-01-22 05:22:10 | 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 | ||
2021-10-20 | United Kingdom | Scotland | 615182 | 11589 | 0 | 56.4907 | -4.2026 | 2021-10-21 04:21:18 | Scotland, United Kingdom | |||
2021-11-17 | United Kingdom | Scotland | 691939 | 12089 | 0 | 56.4907 | -4.2026 | 2021-11-18 04:21:33 | Scotland, United Kingdom | |||
2022-12-21 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-22 04:20:56 | 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 | ||
2022-02-02 | United Kingdom | Scotland | 1151614 | 13130 | 0 | 56.4907 | -4.2026 | 2022-02-03 04:21:21 | Scotland, United Kingdom | |||
2022-05-02 | United Kingdom | Scotland | 1922160 | 14637 | 0 | 56.4907 | -4.2026 | 2022-05-03 04:21:00 | Scotland, United Kingdom | |||
2021-10-07 | United Kingdom | Scotland | 583019 | 11359 | 0 | 56.4907 | -4.2026 | 2021-10-08 04:21:25 | Scotland, United Kingdom | |||
2021-02-19 | United Kingdom | Scotland | 195839 | 9483 | 0 | 188923 | 56.4907 | -4.2026 | 2021-02-20 05:22:51 | Scotland, United Kingdom | ||
2022-06-26 | United Kingdom | Scotland | 1990859 | 14999 | 0 | 56.4907 | -4.2026 | 2022-06-27 04:21:00 | Scotland, United Kingdom | |||
2020-02-25 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-25T15:23:04 | ||||
2022-11-08 | United Kingdom | Scotland | 2121084 | 16049 | 0 | 56.4907 | -4.2026 | 2022-11-09 04:21:22 | Scotland, United Kingdom | |||
2021-07-19 | United Kingdom | Scotland | 330851 | 10339 | 0 | 323051 | 56.4907 | -4.2026 | 2021-07-20 04:21:48 | Scotland, United Kingdom | ||
2022-11-25 | United Kingdom | Scotland | 2125838 | 16144 | 0 | 56.4907 | -4.2026 | 2022-11-26 04:21:11 | Scotland, United Kingdom | |||
2021-10-14 | United Kingdom | Scotland | 599837 | 11489 | 0 | 56.4907 | -4.2026 | 2021-10-15 04:21:26 | Scotland, United Kingdom | |||
2021-11-06 | United Kingdom | Scotland | 659738 | 11938 | 0 | 56.4907 | -4.2026 | 2021-11-07 04:21:53 | Scotland, United Kingdom | |||
2022-04-02 | United Kingdom | Scotland | 1800581 | 14158 | 0 | 56.4907 | -4.2026 | 2022-04-03 04:20:48 | Scotland, United Kingdom | |||
2022-12-17 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-18 04:21:03 | Scotland, United Kingdom | |||
2021-08-14 | United Kingdom | Scotland | 362366 | 10515 | 0 | 56.4907 | -4.2026 | 2021-08-15 04:21:41 | Scotland, United Kingdom | |||
2021-08-19 | United Kingdom | Scotland | 373143 | 10544 | 0 | 56.4907 | -4.2026 | 2021-08-20 04:21:33 | Scotland, United Kingdom | |||
2022-10-15 | United Kingdom | Scotland | 2111605 | 15891 | 0 | 56.4907 | -4.2026 | 2022-10-16 04:22:39 | Scotland, United Kingdom | |||
2020-04-21 | United Kingdom | Scotland | 82603 | 0 | 2129 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-21 23:30:50 | Scotland, United Kingdom | |
2021-06-09 | United Kingdom | Scotland | 242875 | 10156 | 0 | 235197 | 56.4907 | -4.2026 | 2021-06-10 04:23:17 | 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 | ||
2021-02-22 | United Kingdom | Scotland | 198184 | 9573 | 0 | 191234 | 56.4907 | -4.2026 | 2021-02-23 05:23:41 | Scotland, United Kingdom | ||
2021-10-27 | United Kingdom | Scotland | 632397 | 11732 | 0 | 56.4907 | -4.2026 | 2021-10-28 04:22:08 | Scotland, United Kingdom | |||
2022-10-26 | United Kingdom | Scotland | 2114972 | 15964 | 0 | 56.4907 | -4.2026 | 2022-10-27 04:22:01 | Scotland, United Kingdom | |||
2022-12-15 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-16 04:21:01 | Scotland, United Kingdom | |||
2020-09-12 | United Kingdom | Scotland | 22435 | 4242 | 0 | 19936 | 56.4907 | -4.2026 | 2020-09-13 04:30:52 | Scotland, United Kingdom | ||
2021-12-08 | United Kingdom | Scotland | 749620 | 12366 | 0 | 56.4907 | -4.2026 | 2021-12-09 04:22:49 | Scotland, United Kingdom | |||
2022-01-16 | United Kingdom | Scotland | 1090165 | 12846 | 0 | 56.4907 | -4.2026 | 2022-01-17 04:21:08 | Scotland, United Kingdom | |||
2022-06-16 | United Kingdom | Scotland | 1975331 | 14921 | 0 | 56.4907 | -4.2026 | 2022-06-17 04:20:56 | Scotland, United Kingdom | |||
2020-03-01 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-01T10:13:19 | ||||
2021-06-22 | United Kingdom | Scotland | 257742 | 10183 | 0 | 250046 | 56.4907 | -4.2026 | 2021-06-23 04:21:46 | Scotland, United Kingdom | ||
2020-02-06 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-06T23:23:02 | ||||
2021-10-29 | United Kingdom | Scotland | 637266 | 11779 | 0 | 56.4907 | -4.2026 | 2021-10-30 04:22:03 | 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 | |
2022-02-25 | United Kingdom | Scotland | 1374798 | 13396 | 0 | 56.4907 | -4.2026 | 2022-02-26 04:21:12 | Scotland, United Kingdom | |||
2021-07-13 | United Kingdom | Scotland | 318566 | 10295 | 0 | 310805 | 56.4907 | -4.2026 | 2021-07-14 04:21:35 | Scotland, United Kingdom | ||
2020-08-13 | United Kingdom | Scotland | 19126 | 4219 | 0 | 16635 | 56.4907 | -4.2026 | 2020-08-14 04:51:19 | Scotland, United Kingdom | ||
2020-04-05 | United Kingdom | Scotland | 82603 | 0 | 640 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-05 23:06:45 | Scotland, United Kingdom | |
2021-08-08 | United Kingdom | Scotland | 354538 | 10478 | 0 | 56.4907 | -4.2026 | 2021-08-09 04:21:24 | Scotland, United Kingdom | |||
2022-07-01 | United Kingdom | Scotland | 2005335 | 15059 | 0 | 56.4907 | -4.2026 | 2022-07-02 04:21:16 | Scotland, United Kingdom | |||
2021-10-19 | United Kingdom | Scotland | 612416 | 11570 | 0 | 56.4907 | -4.2026 | 2021-10-20 04:21:00 | Scotland, United Kingdom | |||
2021-09-23 | United Kingdom | Scotland | 546426 | 11074 | 0 | 56.4907 | -4.2026 | 2021-09-24 04:21:44 | Scotland, United Kingdom | |||
2021-04-09 | United Kingdom | Scotland | 221431 | 10059 | 0 | 213805 | 56.4907 | -4.2026 | 2021-04-10 04:20:59 | Scotland, United Kingdom | ||
2020-08-29 | United Kingdom | Scotland | 20195 | 4231 | 0 | 17701 | 56.4907 | -4.2026 | 2020-08-30 04:28:22 | Scotland, United Kingdom | ||
2021-02-08 | United Kingdom | Scotland | 186720 | 9013 | 0 | 180277 | 56.4907 | -4.2026 | 2021-02-09 05:23:30 | Scotland, United Kingdom | ||
2020-02-27 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-27T12:13:14 | ||||
2022-11-05 | United Kingdom | Scotland | 2121084 | 16034 | 0 | 56.4907 | -4.2026 | 2022-11-06 04:21:24 | Scotland, United Kingdom | |||
2022-05-22 | United Kingdom | Scotland | 1960940 | 14792 | 0 | 56.4907 | -4.2026 | 2022-05-26 04:20:50 | Scotland, United Kingdom | |||
2021-07-10 | United Kingdom | Scotland | 311855 | 10275 | 0 | 304098 | 56.4907 | -4.2026 | 2021-07-11 04:21:43 | Scotland, United Kingdom | ||
2022-07-12 | United Kingdom | Scotland | 2028133 | 15200 | 0 | 56.4907 | -4.2026 | 2022-07-13 04:20:58 | Scotland, United Kingdom | |||
2021-10-13 | United Kingdom | Scotland | 597199 | 11468 | 0 | 56.4907 | -4.2026 | 2021-10-14 04:21:29 | Scotland, United Kingdom | |||
2021-03-31 | United Kingdom | Scotland | 218432 | 10025 | 0 | 210830 | 56.4907 | -4.2026 | 2021-04-01 04:27:05 | Scotland, United Kingdom | ||
2021-09-07 | United Kingdom | Scotland | 475027 | 10723 | 0 | 56.4907 | -4.2026 | 2021-09-08 04:21:31 | Scotland, United Kingdom | |||
2021-05-05 | United Kingdom | Scotland | 226729 | 10121 | 0 | 219069 | 56.4907 | -4.2026 | 2021-05-06 04:20:38 | Scotland, United Kingdom | ||
2021-08-09 | United Kingdom | Scotland | 355388 | 10484 | 0 | 56.4907 | -4.2026 | 2021-08-10 04:21:27 | Scotland, United Kingdom | |||
2021-10-22 | United Kingdom | Scotland | 620433 | 11630 | 0 | 56.4907 | -4.2026 | 2021-10-23 04:21:32 | Scotland, United Kingdom | |||
2020-03-09 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-09T14:33:03 | ||||
2022-05-13 | United Kingdom | Scotland | 1939321 | 14728 | 0 | 56.4907 | -4.2026 | 2022-05-14 04:20:48 | Scotland, United Kingdom | |||
2020-08-11 | United Kingdom | Scotland | 19027 | 4218 | 0 | 16536 | 56.4907 | -4.2026 | 2020-08-12 04:27:29 | Scotland, United Kingdom | ||
2020-09-16 | United Kingdom | Scotland | 23283 | 4246 | 0 | 20782 | 56.4907 | -4.2026 | 2020-09-17 04:22:00 | Scotland, United Kingdom | ||
2022-07-21 | United Kingdom | Scotland | 2058616 | 15305 | 0 | 56.4907 | -4.2026 | 2022-07-22 04:21:15 | Scotland, United Kingdom | |||
2022-07-30 | United Kingdom | Scotland | 2067712 | 15403 | 0 | 56.4907 | -4.2026 | 2022-07-31 04:21:02 | Scotland, United Kingdom | |||
2020-11-23 | United Kingdom | Scotland | 89310 | 5594 | 0 | 85807 | 56.4907 | -4.2026 | 2020-11-24 05:27:31 | Scotland, United Kingdom | ||
2021-10-24 | United Kingdom | Scotland | 625363 | 11681 | 0 | 56.4907 | -4.2026 | 2021-10-25 04:22:31 | Scotland, United Kingdom | |||
2021-11-13 | United Kingdom | Scotland | 680455 | 12031 | 0 | 56.4907 | -4.2026 | 2021-11-14 04:21:31 | Scotland, United Kingdom | |||
2022-12-23 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-24 04:21:02 | Scotland, United Kingdom | |||
2022-03-17 | United Kingdom | Scotland | 1643664 | 13747 | 0 | 56.4907 | -4.2026 | 2022-03-18 04:20:55 | Scotland, United Kingdom | |||
2021-11-04 | United Kingdom | Scotland | 653975 | 11902 | 0 | 56.4907 | -4.2026 | 2021-11-05 04:21:54 | Scotland, United Kingdom | |||
2021-03-16 | United Kingdom | Scotland | 210605 | 9908 | 0 | 203088 | 56.4907 | -4.2026 | 2021-03-17 05:25:07 | Scotland, United Kingdom | ||
2021-09-29 | United Kingdom | Scotland | 563326 | 11205 | 0 | 56.4907 | -4.2026 | 2021-09-30 04:21:20 | Scotland, United Kingdom | |||
2022-11-01 | United Kingdom | Scotland | 2118188 | 16000 | 0 | 56.4907 | -4.2026 | 2022-11-02 04:22:09 | Scotland, United Kingdom | |||
2021-11-12 | United Kingdom | Scotland | 677408 | 12019 | 0 | 56.4907 | -4.2026 | 2021-11-13 04:21:38 | Scotland, United Kingdom | |||
2022-12-04 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-05 04:20:58 | Scotland, United Kingdom | |||
2021-11-20 | United Kingdom | Scotland | 701719 | 12124 | 0 | 56.4907 | -4.2026 | 2021-11-21 04:22:13 | Scotland, United Kingdom | |||
2021-05-22 | United Kingdom | Scotland | 231652 | 10134 | 0 | 223988 | 56.4907 | -4.2026 | 2021-05-23 04:20:51 | Scotland, United Kingdom | ||
2021-12-27 | United Kingdom | Scotland | 860964 | 12520 | 0 | 56.4907 | -4.2026 | 2021-12-28 04:21:47 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;