constituency_areas
Data license: Open Parliament Licence · Data source: UK Parliament election results website
59 rows where boundary_set_id = 8
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 | 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 |
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]);