cases

1,974 rows where Country = "Scotland"

✎ View and edit SQL

This data as json, CSV (advanced)

Country ✖

  • Scotland · 1,428 ✖
Link Date Country AreaCode Area TotalCases
2020-04-15,Scotland,S08000015,Ayrshire and Arran 2020-04-15 Scotland S08000015 Ayrshire and Arran 457
2020-04-15,Scotland,S08000016,Borders 2020-04-15 Scotland S08000016 Borders 215
2020-04-15,Scotland,S08000017,Dumfries and Galloway 2020-04-15 Scotland S08000017 Dumfries and Galloway 207
2020-04-15,Scotland,S08000019,Forth Valley 2020-04-15 Scotland S08000019 Forth Valley 380
2020-04-15,Scotland,S08000020,Grampian 2020-04-15 Scotland S08000020 Grampian 357
2020-04-15,Scotland,S08000022,Highland 2020-04-15 Scotland S08000022 Highland 180
2020-04-15,Scotland,S08000024,Lothian 2020-04-15 Scotland S08000024 Lothian 1040
2020-04-15,Scotland,S08000025,Orkney 2020-04-15 Scotland S08000025 Orkney 5
2020-04-15,Scotland,S08000026,Shetland 2020-04-15 Scotland S08000026 Shetland 45
2020-04-15,Scotland,S08000028,Western Isles 2020-04-15 Scotland S08000028 Western Isles 6
2020-04-15,Scotland,S08000029,Fife 2020-04-15 Scotland S08000029 Fife 424
2020-04-15,Scotland,S08000030,Tayside 2020-04-15 Scotland S08000030 Tayside 898
2020-04-15,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-15 Scotland S08000031 Greater Glasgow and Clyde 1661
2020-04-15,Scotland,S08000032,Lanarkshire 2020-04-15 Scotland S08000032 Lanarkshire 873
2020-04-16,Scotland,S08000015,Ayrshire and Arran 2020-04-16 Scotland S08000015 Ayrshire and Arran 503
2020-04-16,Scotland,S08000016,Borders 2020-04-16 Scotland S08000016 Borders 220
2020-04-16,Scotland,S08000017,Dumfries and Galloway 2020-04-16 Scotland S08000017 Dumfries and Galloway 207
2020-04-16,Scotland,S08000019,Forth Valley 2020-04-16 Scotland S08000019 Forth Valley 400
2020-04-16,Scotland,S08000020,Grampian 2020-04-16 Scotland S08000020 Grampian 389
2020-04-16,Scotland,S08000022,Highland 2020-04-16 Scotland S08000022 Highland 184
2020-04-16,Scotland,S08000024,Lothian 2020-04-16 Scotland S08000024 Lothian 1107
2020-04-16,Scotland,S08000025,Orkney 2020-04-16 Scotland S08000025 Orkney 5
2020-04-16,Scotland,S08000026,Shetland 2020-04-16 Scotland S08000026 Shetland 45
2020-04-16,Scotland,S08000028,Western Isles 2020-04-16 Scotland S08000028 Western Isles 6
2020-04-16,Scotland,S08000029,Fife 2020-04-16 Scotland S08000029 Fife 446
2020-04-16,Scotland,S08000030,Tayside 2020-04-16 Scotland S08000030 Tayside 937
2020-04-16,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-16 Scotland S08000031 Greater Glasgow and Clyde 1742
2020-04-16,Scotland,S08000032,Lanarkshire 2020-04-16 Scotland S08000032 Lanarkshire 911
2020-04-17,Scotland,S08000015,Ayrshire and Arran 2020-04-17 Scotland S08000015 Ayrshire and Arran 536
2020-04-17,Scotland,S08000016,Borders 2020-04-17 Scotland S08000016 Borders 229
2020-04-17,Scotland,S08000017,Dumfries and Galloway 2020-04-17 Scotland S08000017 Dumfries and Galloway 209
2020-04-17,Scotland,S08000019,Forth Valley 2020-04-17 Scotland S08000019 Forth Valley 431
2020-04-17,Scotland,S08000020,Grampian 2020-04-17 Scotland S08000020 Grampian 394
2020-04-17,Scotland,S08000022,Highland 2020-04-17 Scotland S08000022 Highland 187
2020-04-17,Scotland,S08000024,Lothian 2020-04-17 Scotland S08000024 Lothian 1172
2020-04-17,Scotland,S08000025,Orkney 2020-04-17 Scotland S08000025 Orkney 5
2020-04-17,Scotland,S08000026,Shetland 2020-04-17 Scotland S08000026 Shetland 45
2020-04-17,Scotland,S08000028,Western Isles 2020-04-17 Scotland S08000028 Western Isles 6
2020-04-17,Scotland,S08000029,Fife 2020-04-17 Scotland S08000029 Fife 488
2020-04-17,Scotland,S08000030,Tayside 2020-04-17 Scotland S08000030 Tayside 979
2020-04-17,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-17 Scotland S08000031 Greater Glasgow and Clyde 1794
2020-04-17,Scotland,S08000032,Lanarkshire 2020-04-17 Scotland S08000032 Lanarkshire 934
2020-04-18,Scotland,S08000015,Ayrshire and Arran 2020-04-18 Scotland S08000015 Ayrshire and Arran 560
2020-04-18,Scotland,S08000016,Borders 2020-04-18 Scotland S08000016 Borders 231
2020-04-18,Scotland,S08000017,Dumfries and Galloway 2020-04-18 Scotland S08000017 Dumfries and Galloway 222
2020-04-18,Scotland,S08000019,Forth Valley 2020-04-18 Scotland S08000019 Forth Valley 451
2020-04-18,Scotland,S08000020,Grampian 2020-04-18 Scotland S08000020 Grampian 432
2020-04-18,Scotland,S08000022,Highland 2020-04-18 Scotland S08000022 Highland 193
2020-04-18,Scotland,S08000024,Lothian 2020-04-18 Scotland S08000024 Lothian 1239
2020-04-18,Scotland,S08000025,Orkney 2020-04-18 Scotland S08000025 Orkney 5
2020-04-18,Scotland,S08000026,Shetland 2020-04-18 Scotland S08000026 Shetland 45
2020-04-18,Scotland,S08000028,Western Isles 2020-04-18 Scotland S08000028 Western Isles 6
2020-04-18,Scotland,S08000029,Fife 2020-04-18 Scotland S08000029 Fife 514
2020-04-18,Scotland,S08000030,Tayside 2020-04-18 Scotland S08000030 Tayside 1022
2020-04-18,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-18 Scotland S08000031 Greater Glasgow and Clyde 1905
2020-04-18,Scotland,S08000032,Lanarkshire 2020-04-18 Scotland S08000032 Lanarkshire 995
2020-04-19,Scotland,S08000015,Ayrshire and Arran 2020-04-19 Scotland S08000015 Ayrshire and Arran 586
2020-04-19,Scotland,S08000016,Borders 2020-04-19 Scotland S08000016 Borders 237
2020-04-19,Scotland,S08000017,Dumfries and Galloway 2020-04-19 Scotland S08000017 Dumfries and Galloway 229
2020-04-19,Scotland,S08000019,Forth Valley 2020-04-19 Scotland S08000019 Forth Valley 509
2020-04-19,Scotland,S08000020,Grampian 2020-04-19 Scotland S08000020 Grampian 464
2020-04-19,Scotland,S08000022,Highland 2020-04-19 Scotland S08000022 Highland 197
2020-04-19,Scotland,S08000024,Lothian 2020-04-19 Scotland S08000024 Lothian 1344
2020-04-19,Scotland,S08000025,Orkney 2020-04-19 Scotland S08000025 Orkney 5
2020-04-19,Scotland,S08000026,Shetland 2020-04-19 Scotland S08000026 Shetland 51
2020-04-19,Scotland,S08000028,Western Isles 2020-04-19 Scotland S08000028 Western Isles 6
2020-04-19,Scotland,S08000029,Fife 2020-04-19 Scotland S08000029 Fife 532
2020-04-19,Scotland,S08000030,Tayside 2020-04-19 Scotland S08000030 Tayside 1056
2020-04-19,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-19 Scotland S08000031 Greater Glasgow and Clyde 1949
2020-04-19,Scotland,S08000032,Lanarkshire 2020-04-19 Scotland S08000032 Lanarkshire 1022
2020-04-20,Scotland,S08000015,Ayrshire and Arran 2020-04-20 Scotland S08000015 Ayrshire and Arran 604
2020-04-20,Scotland,S08000016,Borders 2020-04-20 Scotland S08000016 Borders 239
2020-04-20,Scotland,S08000017,Dumfries and Galloway 2020-04-20 Scotland S08000017 Dumfries and Galloway 231
2020-04-20,Scotland,S08000019,Forth Valley 2020-04-20 Scotland S08000019 Forth Valley 542
2020-04-20,Scotland,S08000020,Grampian 2020-04-20 Scotland S08000020 Grampian 490
2020-04-20,Scotland,S08000022,Highland 2020-04-20 Scotland S08000022 Highland 198
2020-04-20,Scotland,S08000024,Lothian 2020-04-20 Scotland S08000024 Lothian 1399
2020-04-20,Scotland,S08000025,Orkney 2020-04-20 Scotland S08000025 Orkney 6
2020-04-20,Scotland,S08000026,Shetland 2020-04-20 Scotland S08000026 Shetland 51
2020-04-20,Scotland,S08000028,Western Isles 2020-04-20 Scotland S08000028 Western Isles 6
2020-04-20,Scotland,S08000029,Fife 2020-04-20 Scotland S08000029 Fife 542
2020-04-20,Scotland,S08000030,Tayside 2020-04-20 Scotland S08000030 Tayside 1071
2020-04-20,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-20 Scotland S08000031 Greater Glasgow and Clyde 2020
2020-04-20,Scotland,S08000032,Lanarkshire 2020-04-20 Scotland S08000032 Lanarkshire 1051
2020-04-21,Scotland,S08000015,Ayrshire and Arran 2020-04-21 Scotland S08000015 Ayrshire and Arran 623
2020-04-21,Scotland,S08000016,Borders 2020-04-21 Scotland S08000016 Borders 240
2020-04-21,Scotland,S08000017,Dumfries and Galloway 2020-04-21 Scotland S08000017 Dumfries and Galloway 231
2020-04-21,Scotland,S08000019,Forth Valley 2020-04-21 Scotland S08000019 Forth Valley 562
2020-04-21,Scotland,S08000020,Grampian 2020-04-21 Scotland S08000020 Grampian 519
2020-04-21,Scotland,S08000022,Highland 2020-04-21 Scotland S08000022 Highland 201
2020-04-21,Scotland,S08000024,Lothian 2020-04-21 Scotland S08000024 Lothian 1426
2020-04-21,Scotland,S08000025,Orkney 2020-04-21 Scotland S08000025 Orkney 6
2020-04-21,Scotland,S08000026,Shetland 2020-04-21 Scotland S08000026 Shetland 52
2020-04-21,Scotland,S08000028,Western Isles 2020-04-21 Scotland S08000028 Western Isles 6
2020-04-21,Scotland,S08000029,Fife 2020-04-21 Scotland S08000029 Fife 561
2020-04-21,Scotland,S08000030,Tayside 2020-04-21 Scotland S08000030 Tayside 1084
2020-04-21,Scotland,S08000031,Greater Glasgow and Clyde 2020-04-21 Scotland S08000031 Greater Glasgow and Clyde 2085
2020-04-21,Scotland,S08000032,Lanarkshire 2020-04-21 Scotland S08000032 Lanarkshire 1076
2020-04-22,Scotland,S08000015,Ayrshire and Arran 2020-04-22 Scotland S08000015 Ayrshire and Arran 640
2020-04-22,Scotland,S08000016,Borders 2020-04-22 Scotland S08000016 Borders 243

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 35.423ms · About: https://github.com/tomwhite/covid-19-uk-data