constituency_areas

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

59 rows where boundary_set_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_area_type_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

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