constituency_areas

Data license: Open Parliament Licence · Data source: UK Parliament election results website

116 rows where country_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_area_type_id, boundary_set_id

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

Next page

Advanced export

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

CSV options: 

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])
);
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]);