cases

1,974 rows where Country = "Scotland" sorted by Country

✎ View and edit SQL

This data as json, CSV (advanced)

Country ✖

  • Scotland · 587 ✖
Link Date Country ▼ AreaCode Area TotalCases
2020-06-14,Scotland,S08000016,Borders 2020-06-14 Scotland S08000016 Borders 327
2020-06-14,Scotland,S08000017,Dumfries and Galloway 2020-06-14 Scotland S08000017 Dumfries and Galloway 261
2020-06-14,Scotland,S08000019,Forth Valley 2020-06-14 Scotland S08000019 Forth Valley 952
2020-06-14,Scotland,S08000020,Grampian 2020-06-14 Scotland S08000020 Grampian 1294
2020-06-14,Scotland,S08000022,Highland 2020-06-14 Scotland S08000022 Highland 341
2020-06-14,Scotland,S08000024,Lothian 2020-06-14 Scotland S08000024 Lothian 2807
2020-06-14,Scotland,S08000025,Orkney 2020-06-14 Scotland S08000025 Orkney 8
2020-06-14,Scotland,S08000026,Shetland 2020-06-14 Scotland S08000026 Shetland 54
2020-06-14,Scotland,S08000028,Western Isles 2020-06-14 Scotland S08000028 Western Isles 6
2020-06-14,Scotland,S08000029,Fife 2020-06-14 Scotland S08000029 Fife 885
2020-06-14,Scotland,S08000030,Tayside 2020-06-14 Scotland S08000030 Tayside 1687
2020-06-14,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-14 Scotland S08000031 Greater Glasgow and Clyde 4010
2020-06-14,Scotland,S08000032,Lanarkshire 2020-06-14 Scotland S08000032 Lanarkshire 2035
2020-06-15,Scotland,S08000015,Ayrshire and Arran 2020-06-15 Scotland S08000015 Ayrshire and Arran 1243
2020-06-15,Scotland,S08000016,Borders 2020-06-15 Scotland S08000016 Borders 345
2020-06-15,Scotland,S08000017,Dumfries and Galloway 2020-06-15 Scotland S08000017 Dumfries and Galloway 274
2020-06-15,Scotland,S08000019,Forth Valley 2020-06-15 Scotland S08000019 Forth Valley 1048
2020-06-15,Scotland,S08000020,Grampian 2020-06-15 Scotland S08000020 Grampian 1405
2020-06-15,Scotland,S08000022,Highland 2020-06-15 Scotland S08000022 Highland 373
2020-06-15,Scotland,S08000024,Lothian 2020-06-15 Scotland S08000024 Lothian 3110
2020-06-15,Scotland,S08000025,Orkney 2020-06-15 Scotland S08000025 Orkney 9
2020-06-15,Scotland,S08000026,Shetland 2020-06-15 Scotland S08000026 Shetland 54
2020-06-15,Scotland,S08000028,Western Isles 2020-06-15 Scotland S08000028 Western Isles 7
2020-06-15,Scotland,S08000029,Fife 2020-06-15 Scotland S08000029 Fife 926
2020-06-15,Scotland,S08000030,Tayside 2020-06-15 Scotland S08000030 Tayside 1760
2020-06-15,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-15 Scotland S08000031 Greater Glasgow and Clyde 4805
2020-06-15,Scotland,S08000032,Lanarkshire 2020-06-15 Scotland S08000032 Lanarkshire 2671
2020-06-16,Scotland,S08000015,Ayrshire and Arran 2020-06-16 Scotland S08000015 Ayrshire and Arran 1243
2020-06-16,Scotland,S08000016,Borders 2020-06-16 Scotland S08000016 Borders 345
2020-06-16,Scotland,S08000017,Dumfries and Galloway 2020-06-16 Scotland S08000017 Dumfries and Galloway 274
2020-06-16,Scotland,S08000019,Forth Valley 2020-06-16 Scotland S08000019 Forth Valley 1051
2020-06-16,Scotland,S08000020,Grampian 2020-06-16 Scotland S08000020 Grampian 1405
2020-06-16,Scotland,S08000022,Highland 2020-06-16 Scotland S08000022 Highland 373
2020-06-16,Scotland,S08000024,Lothian 2020-06-16 Scotland S08000024 Lothian 3116
2020-06-16,Scotland,S08000025,Orkney 2020-06-16 Scotland S08000025 Orkney 9
2020-06-16,Scotland,S08000026,Shetland 2020-06-16 Scotland S08000026 Shetland 54
2020-06-16,Scotland,S08000028,Western Isles 2020-06-16 Scotland S08000028 Western Isles 7
2020-06-16,Scotland,S08000029,Fife 2020-06-16 Scotland S08000029 Fife 926
2020-06-16,Scotland,S08000030,Tayside 2020-06-16 Scotland S08000030 Tayside 1760
2020-06-16,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-16 Scotland S08000031 Greater Glasgow and Clyde 4808
2020-06-16,Scotland,S08000032,Lanarkshire 2020-06-16 Scotland S08000032 Lanarkshire 2674
2020-06-17,Scotland,S08000015,Ayrshire and Arran 2020-06-17 Scotland S08000015 Ayrshire and Arran 1245
2020-06-17,Scotland,S08000016,Borders 2020-06-17 Scotland S08000016 Borders 345
2020-06-17,Scotland,S08000017,Dumfries and Galloway 2020-06-17 Scotland S08000017 Dumfries and Galloway 274
2020-06-17,Scotland,S08000019,Forth Valley 2020-06-17 Scotland S08000019 Forth Valley 1051
2020-06-17,Scotland,S08000020,Grampian 2020-06-17 Scotland S08000020 Grampian 1409
2020-06-17,Scotland,S08000022,Highland 2020-06-17 Scotland S08000022 Highland 373
2020-06-17,Scotland,S08000024,Lothian 2020-06-17 Scotland S08000024 Lothian 3123
2020-06-17,Scotland,S08000025,Orkney 2020-06-17 Scotland S08000025 Orkney 9
2020-06-17,Scotland,S08000026,Shetland 2020-06-17 Scotland S08000026 Shetland 54
2020-06-17,Scotland,S08000028,Western Isles 2020-06-17 Scotland S08000028 Western Isles 7
2020-06-17,Scotland,S08000029,Fife 2020-06-17 Scotland S08000029 Fife 928
2020-06-17,Scotland,S08000030,Tayside 2020-06-17 Scotland S08000030 Tayside 1760
2020-06-17,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-17 Scotland S08000031 Greater Glasgow and Clyde 4810
2020-06-17,Scotland,S08000032,Lanarkshire 2020-06-17 Scotland S08000032 Lanarkshire 2678
2020-06-18,Scotland,S08000015,Ayrshire and Arran 2020-06-18 Scotland S08000015 Ayrshire and Arran 1245
2020-06-18,Scotland,S08000016,Borders 2020-06-18 Scotland S08000016 Borders 345
2020-06-18,Scotland,S08000017,Dumfries and Galloway 2020-06-18 Scotland S08000017 Dumfries and Galloway 274
2020-06-18,Scotland,S08000019,Forth Valley 2020-06-18 Scotland S08000019 Forth Valley 1053
2020-06-18,Scotland,S08000020,Grampian 2020-06-18 Scotland S08000020 Grampian 1410
2020-06-18,Scotland,S08000022,Highland 2020-06-18 Scotland S08000022 Highland 373
2020-06-18,Scotland,S08000024,Lothian 2020-06-18 Scotland S08000024 Lothian 3125
2020-06-18,Scotland,S08000025,Orkney 2020-06-18 Scotland S08000025 Orkney 9
2020-06-18,Scotland,S08000026,Shetland 2020-06-18 Scotland S08000026 Shetland 54
2020-06-18,Scotland,S08000028,Western Isles 2020-06-18 Scotland S08000028 Western Isles 7
2020-06-18,Scotland,S08000029,Fife 2020-06-18 Scotland S08000029 Fife 928
2020-06-18,Scotland,S08000030,Tayside 2020-06-18 Scotland S08000030 Tayside 1760
2020-06-18,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-18 Scotland S08000031 Greater Glasgow and Clyde 4813
2020-06-18,Scotland,S08000032,Lanarkshire 2020-06-18 Scotland S08000032 Lanarkshire 2681
2020-06-19,Scotland,S08000015,Ayrshire and Arran 2020-06-19 Scotland S08000015 Ayrshire and Arran 1248
2020-06-19,Scotland,S08000016,Borders 2020-06-19 Scotland S08000016 Borders 345
2020-06-19,Scotland,S08000017,Dumfries and Galloway 2020-06-19 Scotland S08000017 Dumfries and Galloway 284
2020-06-19,Scotland,S08000019,Forth Valley 2020-06-19 Scotland S08000019 Forth Valley 1053
2020-06-19,Scotland,S08000020,Grampian 2020-06-19 Scotland S08000020 Grampian 1410
2020-06-19,Scotland,S08000022,Highland 2020-06-19 Scotland S08000022 Highland 373
2020-06-19,Scotland,S08000024,Lothian 2020-06-19 Scotland S08000024 Lothian 3134
2020-06-19,Scotland,S08000025,Orkney 2020-06-19 Scotland S08000025 Orkney 9
2020-06-19,Scotland,S08000026,Shetland 2020-06-19 Scotland S08000026 Shetland 54
2020-06-19,Scotland,S08000028,Western Isles 2020-06-19 Scotland S08000028 Western Isles 7
2020-06-19,Scotland,S08000029,Fife 2020-06-19 Scotland S08000029 Fife 928
2020-06-19,Scotland,S08000030,Tayside 2020-06-19 Scotland S08000030 Tayside 1760
2020-06-19,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-19 Scotland S08000031 Greater Glasgow and Clyde 4814
2020-06-19,Scotland,S08000032,Lanarkshire 2020-06-19 Scotland S08000032 Lanarkshire 2685
2020-06-20,Scotland,S08000015,Ayrshire and Arran 2020-06-20 Scotland S08000015 Ayrshire and Arran 1249
2020-06-20,Scotland,S08000016,Borders 2020-06-20 Scotland S08000016 Borders 345
2020-06-20,Scotland,S08000017,Dumfries and Galloway 2020-06-20 Scotland S08000017 Dumfries and Galloway 284
2020-06-20,Scotland,S08000019,Forth Valley 2020-06-20 Scotland S08000019 Forth Valley 1055
2020-06-20,Scotland,S08000020,Grampian 2020-06-20 Scotland S08000020 Grampian 1410
2020-06-20,Scotland,S08000022,Highland 2020-06-20 Scotland S08000022 Highland 373
2020-06-20,Scotland,S08000024,Lothian 2020-06-20 Scotland S08000024 Lothian 3139
2020-06-20,Scotland,S08000025,Orkney 2020-06-20 Scotland S08000025 Orkney 9
2020-06-20,Scotland,S08000026,Shetland 2020-06-20 Scotland S08000026 Shetland 54
2020-06-20,Scotland,S08000028,Western Isles 2020-06-20 Scotland S08000028 Western Isles 7
2020-06-20,Scotland,S08000029,Fife 2020-06-20 Scotland S08000029 Fife 928
2020-06-20,Scotland,S08000030,Tayside 2020-06-20 Scotland S08000030 Tayside 1760
2020-06-20,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-20 Scotland S08000031 Greater Glasgow and Clyde 4819
2020-06-20,Scotland,S08000032,Lanarkshire 2020-06-20 Scotland S08000032 Lanarkshire 2698
2020-06-21,Scotland,S08000015,Ayrshire and Arran 2020-06-21 Scotland S08000015 Ayrshire and Arran 1250
2020-06-21,Scotland,S08000016,Borders 2020-06-21 Scotland S08000016 Borders 346
2020-06-21,Scotland,S08000017,Dumfries and Galloway 2020-06-21 Scotland S08000017 Dumfries and Galloway 284

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 26.356ms · About: https://github.com/tomwhite/covid-19-uk-data