cases

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

✎ View and edit SQL

This data as json, CSV (advanced)

Country ✖

  • Scotland · 387 ✖
Link Date Country ▼ AreaCode Area TotalCases
2020-06-28,Scotland,S08000022,Highland 2020-06-28 Scotland S08000022 Highland 375
2020-06-28,Scotland,S08000024,Lothian 2020-06-28 Scotland S08000024 Lothian 3151
2020-06-28,Scotland,S08000025,Orkney 2020-06-28 Scotland S08000025 Orkney 9
2020-06-28,Scotland,S08000026,Shetland 2020-06-28 Scotland S08000026 Shetland 54
2020-06-28,Scotland,S08000028,Western Isles 2020-06-28 Scotland S08000028 Western Isles 7
2020-06-28,Scotland,S08000029,Fife 2020-06-28 Scotland S08000029 Fife 930
2020-06-28,Scotland,S08000030,Tayside 2020-06-28 Scotland S08000030 Tayside 1768
2020-06-28,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-28 Scotland S08000031 Greater Glasgow and Clyde 4850
2020-06-28,Scotland,S08000032,Lanarkshire 2020-06-28 Scotland S08000032 Lanarkshire 2722
2020-06-29,Scotland,S08000015,Ayrshire and Arran 2020-06-29 Scotland S08000015 Ayrshire and Arran 1255
2020-06-29,Scotland,S08000016,Borders 2020-06-29 Scotland S08000016 Borders 345
2020-06-29,Scotland,S08000017,Dumfries and Galloway 2020-06-29 Scotland S08000017 Dumfries and Galloway 285
2020-06-29,Scotland,S08000019,Forth Valley 2020-06-29 Scotland S08000019 Forth Valley 1069
2020-06-29,Scotland,S08000020,Grampian 2020-06-29 Scotland S08000020 Grampian 1419
2020-06-29,Scotland,S08000022,Highland 2020-06-29 Scotland S08000022 Highland 375
2020-06-29,Scotland,S08000024,Lothian 2020-06-29 Scotland S08000024 Lothian 3151
2020-06-29,Scotland,S08000025,Orkney 2020-06-29 Scotland S08000025 Orkney 9
2020-06-29,Scotland,S08000026,Shetland 2020-06-29 Scotland S08000026 Shetland 54
2020-06-29,Scotland,S08000028,Western Isles 2020-06-29 Scotland S08000028 Western Isles 7
2020-06-29,Scotland,S08000029,Fife 2020-06-29 Scotland S08000029 Fife 930
2020-06-29,Scotland,S08000030,Tayside 2020-06-29 Scotland S08000030 Tayside 1768
2020-06-29,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-29 Scotland S08000031 Greater Glasgow and Clyde 4851
2020-06-29,Scotland,S08000032,Lanarkshire 2020-06-29 Scotland S08000032 Lanarkshire 2723
2020-06-30,Scotland,S08000015,Ayrshire and Arran 2020-06-30 Scotland S08000015 Ayrshire and Arran 1255
2020-06-30,Scotland,S08000016,Borders 2020-06-30 Scotland S08000016 Borders 345
2020-06-30,Scotland,S08000017,Dumfries and Galloway 2020-06-30 Scotland S08000017 Dumfries and Galloway 290
2020-06-30,Scotland,S08000019,Forth Valley 2020-06-30 Scotland S08000019 Forth Valley 1070
2020-06-30,Scotland,S08000020,Grampian 2020-06-30 Scotland S08000020 Grampian 1419
2020-06-30,Scotland,S08000022,Highland 2020-06-30 Scotland S08000022 Highland 375
2020-06-30,Scotland,S08000024,Lothian 2020-06-30 Scotland S08000024 Lothian 3151
2020-06-30,Scotland,S08000025,Orkney 2020-06-30 Scotland S08000025 Orkney 9
2020-06-30,Scotland,S08000026,Shetland 2020-06-30 Scotland S08000026 Shetland 54
2020-06-30,Scotland,S08000028,Western Isles 2020-06-30 Scotland S08000028 Western Isles 7
2020-06-30,Scotland,S08000029,Fife 2020-06-30 Scotland S08000029 Fife 930
2020-06-30,Scotland,S08000030,Tayside 2020-06-30 Scotland S08000030 Tayside 1769
2020-06-30,Scotland,S08000031,Greater Glasgow and Clyde 2020-06-30 Scotland S08000031 Greater Glasgow and Clyde 4853
2020-06-30,Scotland,S08000032,Lanarkshire 2020-06-30 Scotland S08000032 Lanarkshire 2724
2020-07-01,Scotland,S08000015,Ayrshire and Arran 2020-07-01 Scotland S08000015 Ayrshire and Arran 1255
2020-07-01,Scotland,S08000016,Borders 2020-07-01 Scotland S08000016 Borders 345
2020-07-01,Scotland,S08000017,Dumfries and Galloway 2020-07-01 Scotland S08000017 Dumfries and Galloway 291
2020-07-01,Scotland,S08000019,Forth Valley 2020-07-01 Scotland S08000019 Forth Valley 1070
2020-07-01,Scotland,S08000020,Grampian 2020-07-01 Scotland S08000020 Grampian 1421
2020-07-01,Scotland,S08000022,Highland 2020-07-01 Scotland S08000022 Highland 375
2020-07-01,Scotland,S08000024,Lothian 2020-07-01 Scotland S08000024 Lothian 3151
2020-07-01,Scotland,S08000025,Orkney 2020-07-01 Scotland S08000025 Orkney 9
2020-07-01,Scotland,S08000026,Shetland 2020-07-01 Scotland S08000026 Shetland 54
2020-07-01,Scotland,S08000028,Western Isles 2020-07-01 Scotland S08000028 Western Isles 7
2020-07-01,Scotland,S08000029,Fife 2020-07-01 Scotland S08000029 Fife 930
2020-07-01,Scotland,S08000030,Tayside 2020-07-01 Scotland S08000030 Tayside 1769
2020-07-01,Scotland,S08000031,Greater Glasgow and Clyde 2020-07-01 Scotland S08000031 Greater Glasgow and Clyde 4858
2020-07-01,Scotland,S08000032,Lanarkshire 2020-07-01 Scotland S08000032 Lanarkshire 2724
2020-07-02,Scotland,S08000015,Ayrshire and Arran 2020-07-02 Scotland S08000015 Ayrshire and Arran 1255
2020-07-02,Scotland,S08000016,Borders 2020-07-02 Scotland S08000016 Borders 345
2020-07-02,Scotland,S08000017,Dumfries and Galloway 2020-07-02 Scotland S08000017 Dumfries and Galloway 292
2020-07-02,Scotland,S08000019,Forth Valley 2020-07-02 Scotland S08000019 Forth Valley 1070
2020-07-02,Scotland,S08000020,Grampian 2020-07-02 Scotland S08000020 Grampian 1423
2020-07-02,Scotland,S08000022,Highland 2020-07-02 Scotland S08000022 Highland 375
2020-07-02,Scotland,S08000024,Lothian 2020-07-02 Scotland S08000024 Lothian 3151
2020-07-02,Scotland,S08000025,Orkney 2020-07-02 Scotland S08000025 Orkney 9
2020-07-02,Scotland,S08000026,Shetland 2020-07-02 Scotland S08000026 Shetland 54
2020-07-02,Scotland,S08000028,Western Isles 2020-07-02 Scotland S08000028 Western Isles 7
2020-07-02,Scotland,S08000029,Fife 2020-07-02 Scotland S08000029 Fife 930
2020-07-02,Scotland,S08000030,Tayside 2020-07-02 Scotland S08000030 Tayside 1769
2020-07-02,Scotland,S08000031,Greater Glasgow and Clyde 2020-07-02 Scotland S08000031 Greater Glasgow and Clyde 4858
2020-07-02,Scotland,S08000032,Lanarkshire 2020-07-02 Scotland S08000032 Lanarkshire 2726
2020-07-03,Scotland,S08000015,Ayrshire and Arran 2020-07-03 Scotland S08000015 Ayrshire and Arran 1256
2020-07-03,Scotland,S08000016,Borders 2020-07-03 Scotland S08000016 Borders 345
2020-07-03,Scotland,S08000017,Dumfries and Galloway 2020-07-03 Scotland S08000017 Dumfries and Galloway 292
2020-07-03,Scotland,S08000019,Forth Valley 2020-07-03 Scotland S08000019 Forth Valley 1076
2020-07-03,Scotland,S08000020,Grampian 2020-07-03 Scotland S08000020 Grampian 1423
2020-07-03,Scotland,S08000022,Highland 2020-07-03 Scotland S08000022 Highland 375
2020-07-03,Scotland,S08000024,Lothian 2020-07-03 Scotland S08000024 Lothian 3153
2020-07-03,Scotland,S08000025,Orkney 2020-07-03 Scotland S08000025 Orkney 9
2020-07-03,Scotland,S08000026,Shetland 2020-07-03 Scotland S08000026 Shetland 54
2020-07-03,Scotland,S08000028,Western Isles 2020-07-03 Scotland S08000028 Western Isles 7
2020-07-03,Scotland,S08000029,Fife 2020-07-03 Scotland S08000029 Fife 932
2020-07-03,Scotland,S08000030,Tayside 2020-07-03 Scotland S08000030 Tayside 1769
2020-07-03,Scotland,S08000031,Greater Glasgow and Clyde 2020-07-03 Scotland S08000031 Greater Glasgow and Clyde 4858
2020-07-03,Scotland,S08000032,Lanarkshire 2020-07-03 Scotland S08000032 Lanarkshire 2727
2020-07-04,Scotland,S08000015,Ayrshire and Arran 2020-07-04 Scotland S08000015 Ayrshire and Arran 1256
2020-07-04,Scotland,S08000016,Borders 2020-07-04 Scotland S08000016 Borders 345
2020-07-04,Scotland,S08000017,Dumfries and Galloway 2020-07-04 Scotland S08000017 Dumfries and Galloway 293
2020-07-04,Scotland,S08000019,Forth Valley 2020-07-04 Scotland S08000019 Forth Valley 1076
2020-07-04,Scotland,S08000020,Grampian 2020-07-04 Scotland S08000020 Grampian 1425
2020-07-04,Scotland,S08000022,Highland 2020-07-04 Scotland S08000022 Highland 375
2020-07-04,Scotland,S08000024,Lothian 2020-07-04 Scotland S08000024 Lothian 3156
2020-07-04,Scotland,S08000025,Orkney 2020-07-04 Scotland S08000025 Orkney 9
2020-07-04,Scotland,S08000026,Shetland 2020-07-04 Scotland S08000026 Shetland 54
2020-07-04,Scotland,S08000028,Western Isles 2020-07-04 Scotland S08000028 Western Isles 7
2020-07-04,Scotland,S08000029,Fife 2020-07-04 Scotland S08000029 Fife 932
2020-07-04,Scotland,S08000030,Tayside 2020-07-04 Scotland S08000030 Tayside 1771
2020-07-04,Scotland,S08000031,Greater Glasgow and Clyde 2020-07-04 Scotland S08000031 Greater Glasgow and Clyde 4860
2020-07-04,Scotland,S08000032,Lanarkshire 2020-07-04 Scotland S08000032 Lanarkshire 2728
2020-07-05,Scotland,S08000015,Ayrshire and Arran 2020-07-05 Scotland S08000015 Ayrshire and Arran 1257
2020-07-05,Scotland,S08000016,Borders 2020-07-05 Scotland S08000016 Borders 345
2020-07-05,Scotland,S08000017,Dumfries and Galloway 2020-07-05 Scotland S08000017 Dumfries and Galloway 294
2020-07-05,Scotland,S08000019,Forth Valley 2020-07-05 Scotland S08000019 Forth Valley 1076
2020-07-05,Scotland,S08000020,Grampian 2020-07-05 Scotland S08000020 Grampian 1426
2020-07-05,Scotland,S08000022,Highland 2020-07-05 Scotland S08000022 Highland 376
2020-07-05,Scotland,S08000024,Lothian 2020-07-05 Scotland S08000024 Lothian 3157

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