constituency_areas
Data license: Open Parliament Licence · Data source: UK Parliament election results website
188 rows where country_id = 5
This data as json, CSV (advanced)
Suggested facets: constituency_area_type_id, boundary_set_id, is_geographic_code_issued_by_ons
| id ▼ | name | geographic_code | english_region_id | country_id | constituency_area_type_id | boundary_set_id | mnis_id | is_geographic_code_issued_by_ons |
|---|---|---|---|---|---|---|---|---|
| 3 | Aberdeen North | S14000001 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 4 | Aberdeen South | S14000002 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 5 | Airdrie and Shotts | S14000003 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 11 | Angus | S14000004 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 13 | Argyll and Bute | S14000005 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 19 | Ayr, Carrick and Cumnock | S14000006 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 21 | Banff and Buchan | S14000007 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 40 | Berwickshire, Roxburgh and Selkirk | S14000008 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 105 | Caithness, Sutherland and Easter Ross | S14000009 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 121 | Central Ayrshire | S14000010 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 146 | Coatbridge, Chryston and Bellshill | S14000011 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 160 | Cumbernauld, Kilsyth and Kirkintilloch East | S14000012 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 180 | Dumfries and Galloway | S14000013 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 181 | Dumfriesshire, Clydesdale and Tweeddale | S14000014 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 182 | Dundee East | S14000015 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 183 | Dundee West | S14000016 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 184 | Dunfermline and West Fife | S14000017 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 192 | East Dunbartonshire | S14000018 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 195 | East Kilbride, Strathaven and Lesmahagow | S14000019 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 197 | East Lothian | S14000020 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 198 | East Renfrewshire | S14000021 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 205 | Edinburgh East | S14000022 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 206 | Edinburgh North and Leith | S14000023 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 207 | Edinburgh South | S14000024 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 208 | Edinburgh South West | S14000025 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 209 | Edinburgh West | S14000026 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 222 | Falkirk | S14000028 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 238 | Glasgow Central | S14000029 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 239 | Glasgow East | S14000030 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 240 | Glasgow North | S14000031 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 241 | Glasgow North East | S14000032 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 242 | Glasgow North West | S14000033 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 243 | Glasgow South | S14000034 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 244 | Glasgow South West | S14000035 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 245 | Glenrothes | S14000036 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 247 | Gordon | S14000037 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 297 | Inverclyde | S14000038 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 298 | Inverness, Nairn, Badenoch and Strathspey | S14000039 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 309 | Kilmarnock and Loudoun | S14000040 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 315 | Kirkcaldy and Cowdenbeath | S14000041 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 318 | Lanark and Hamilton East | S14000042 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 336 | Linlithgow and East Falkirk | S14000043 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 341 | Livingston | S14000044 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 369 | Midlothian | S14000045 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 376 | Moray | S14000046 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 379 | Motherwell and Wishaw | S14000047 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 380 | Na h-Eileanan An Iar | S14000027 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 396 | North Ayrshire and Arran | S14000048 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 405 | North East Fife | S14000049 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 431 | Ochil and South Perthshire | S14000050 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 436 | Orkney and Shetland | S14000051 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 440 | Paisley and Renfrewshire North | S14000052 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 441 | Paisley and Renfrewshire South | S14000053 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 445 | Perth and North Perthshire | S14000054 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 473 | Ross, Skye and Lochaber | S14000055 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 481 | Rutherglen and Hamilton West | S14000056 | Scotland 5 | Burgh 2 | 8 8 | 1 | ||
| 544 | Stirling | S14000057 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 612 | West Aberdeenshire and Kincardine | S14000058 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 616 | West Dunbartonshire | S14000059 | Scotland 5 | County 1 | 8 8 | 1 | ||
| 652 | Aberdeen North | S14000060 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 653 | Aberdeen South | S14000061 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 654 | Aberdeenshire North and Moray East | S14000062 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 655 | Airdrie and Shotts | S14000063 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 658 | Alloa and Grangemouth | S14000064 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 662 | Angus and Perthshire Glens | S14000065 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 663 | Arbroath and Broughty Ferry | S14000066 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 664 | Argyll, Bute and South Lochaber | S14000067 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 670 | Ayr, Carrick and Cumnock | S14000107 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 681 | Bathgate and Linlithgow | S14000068 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 691 | Berwickshire, Roxburgh and Selkirk | S14000108 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 758 | Caithness, Sutherland and Easter Ross | S14000069 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 771 | Central Ayrshire | S14000109 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 796 | Coatbridge and Bellshill | S14000070 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 804 | Cowdenbeath and Kirkcaldy | S14000071 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 811 | Cumbernauld and Kirkintilloch | S14000072 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 829 | Dumfries and Galloway | S14000073 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 830 | Dumfriesshire, Clydesdale and Tweeddale | S14000074 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 831 | Dundee Central | S14000075 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 832 | Dunfermline and Dollar | S14000076 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 844 | East Kilbride and Strathaven | S14000077 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 846 | East Renfrewshire | S14000021 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 853 | Edinburgh East and Musselburgh | S14000078 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 854 | Edinburgh North and Leith | S14000079 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 855 | Edinburgh South | S14000080 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 856 | Edinburgh South West | S14000081 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 857 | Edinburgh West | S14000082 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 870 | Falkirk | S14000083 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 887 | Glasgow East | S14000084 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 888 | Glasgow North | S14000085 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 889 | Glasgow North East | S14000086 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 890 | Glasgow South | S14000087 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 891 | Glasgow South West | S14000088 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 892 | Glasgow West | S14000089 | Scotland 5 | Burgh 2 | 3 3 | 1 | ||
| 894 | Glenrothes and Mid Fife | S14000090 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 898 | Gordon and Buchan | S14000091 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 913 | Hamilton and Clyde Valley | S14000092 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 952 | Inverclyde and Renfrewshire West | S14000093 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 953 | Inverness, Skye and West Ross-shire | S14000094 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 964 | Kilmarnock and Loudoun | S14000110 | Scotland 5 | County 1 | 3 3 | 1 | ||
| 996 | Livingston | S14000095 | Scotland 5 | County 1 | 3 3 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "constituency_areas" (
[id] INTEGER PRIMARY KEY,
[name] TEXT,
[geographic_code] TEXT,
[english_region_id] INTEGER REFERENCES [english_regions]([id]),
[country_id] INTEGER REFERENCES [countries]([id]),
[constituency_area_type_id] INTEGER REFERENCES [constituency_area_types]([id]),
[boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]),
[mnis_id] TEXT,
[is_geographic_code_issued_by_ons] INTEGER
);
CREATE INDEX [idx_constituency_areas_boundary_set_id]
ON [constituency_areas] ([boundary_set_id]);
CREATE INDEX [idx_constituency_areas_constituency_area_type_id]
ON [constituency_areas] ([constituency_area_type_id]);
CREATE INDEX [idx_constituency_areas_country_id]
ON [constituency_areas] ([country_id]);
CREATE INDEX [idx_constituency_areas_english_region_id]
ON [constituency_areas] ([english_region_id]);