constituency_areas
Data license: Open Parliament Licence · Data source: UK Parliament election results website
57 rows where boundary_set_id = 3
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 |
|---|---|---|---|---|---|---|---|---|
| 652 | Aberdeen North | S14000060 | Scotland 5 | Burgh 2 | 3 3 | 4449 | 1 | |
| 653 | Aberdeen South | S14000061 | Scotland 5 | Burgh 2 | 3 3 | 4450 | 1 | |
| 654 | Aberdeenshire North and Moray East | S14000062 | Scotland 5 | County 1 | 3 3 | 4451 | 1 | |
| 655 | Airdrie and Shotts | S14000063 | Scotland 5 | County 1 | 3 3 | 4452 | 1 | |
| 658 | Alloa and Grangemouth | S14000064 | Scotland 5 | County 1 | 3 3 | 4453 | 1 | |
| 662 | Angus and Perthshire Glens | S14000065 | Scotland 5 | County 1 | 3 3 | 4454 | 1 | |
| 663 | Arbroath and Broughty Ferry | S14000066 | Scotland 5 | County 1 | 3 3 | 4455 | 1 | |
| 664 | Argyll, Bute and South Lochaber | S14000067 | Scotland 5 | County 1 | 3 3 | 4456 | 1 | |
| 670 | Ayr, Carrick and Cumnock | S14000107 | Scotland 5 | County 1 | 3 3 | 4439 | 1 | |
| 681 | Bathgate and Linlithgow | S14000068 | Scotland 5 | County 1 | 3 3 | 4457 | 1 | |
| 691 | Berwickshire, Roxburgh and Selkirk | S14000108 | Scotland 5 | County 1 | 3 3 | 4440 | 1 | |
| 758 | Caithness, Sutherland and Easter Ross | S14000069 | Scotland 5 | County 1 | 3 3 | 4458 | 1 | |
| 771 | Central Ayrshire | S14000109 | Scotland 5 | County 1 | 3 3 | 4441 | 1 | |
| 796 | Coatbridge and Bellshill | S14000070 | Scotland 5 | Burgh 2 | 3 3 | 4459 | 1 | |
| 804 | Cowdenbeath and Kirkcaldy | S14000071 | Scotland 5 | County 1 | 3 3 | 4460 | 1 | |
| 811 | Cumbernauld and Kirkintilloch | S14000072 | Scotland 5 | County 1 | 3 3 | 4461 | 1 | |
| 829 | Dumfries and Galloway | S14000073 | Scotland 5 | County 1 | 3 3 | 4462 | 1 | |
| 830 | Dumfriesshire, Clydesdale and Tweeddale | S14000074 | Scotland 5 | County 1 | 3 3 | 4463 | 1 | |
| 831 | Dundee Central | S14000075 | Scotland 5 | Burgh 2 | 3 3 | 4464 | 1 | |
| 832 | Dunfermline and Dollar | S14000076 | Scotland 5 | County 1 | 3 3 | 4465 | 1 | |
| 844 | East Kilbride and Strathaven | S14000077 | Scotland 5 | County 1 | 3 3 | 4466 | 1 | |
| 846 | East Renfrewshire | S14000021 | Scotland 5 | County 1 | 3 3 | 4442 | 1 | |
| 853 | Edinburgh East and Musselburgh | S14000078 | Scotland 5 | Burgh 2 | 3 3 | 4467 | 1 | |
| 854 | Edinburgh North and Leith | S14000079 | Scotland 5 | Burgh 2 | 3 3 | 4468 | 1 | |
| 855 | Edinburgh South | S14000080 | Scotland 5 | Burgh 2 | 3 3 | 4469 | 1 | |
| 856 | Edinburgh South West | S14000081 | Scotland 5 | Burgh 2 | 3 3 | 4470 | 1 | |
| 857 | Edinburgh West | S14000082 | Scotland 5 | Burgh 2 | 3 3 | 4471 | 1 | |
| 870 | Falkirk | S14000083 | Scotland 5 | County 1 | 3 3 | 4472 | 1 | |
| 887 | Glasgow East | S14000084 | Scotland 5 | Burgh 2 | 3 3 | 4473 | 1 | |
| 888 | Glasgow North | S14000085 | Scotland 5 | Burgh 2 | 3 3 | 4474 | 1 | |
| 889 | Glasgow North East | S14000086 | Scotland 5 | Burgh 2 | 3 3 | 4475 | 1 | |
| 890 | Glasgow South | S14000087 | Scotland 5 | Burgh 2 | 3 3 | 4476 | 1 | |
| 891 | Glasgow South West | S14000088 | Scotland 5 | Burgh 2 | 3 3 | 4477 | 1 | |
| 892 | Glasgow West | S14000089 | Scotland 5 | Burgh 2 | 3 3 | 4478 | 1 | |
| 894 | Glenrothes and Mid Fife | S14000090 | Scotland 5 | County 1 | 3 3 | 4479 | 1 | |
| 898 | Gordon and Buchan | S14000091 | Scotland 5 | County 1 | 3 3 | 4480 | 1 | |
| 913 | Hamilton and Clyde Valley | S14000092 | Scotland 5 | County 1 | 3 3 | 4481 | 1 | |
| 952 | Inverclyde and Renfrewshire West | S14000093 | Scotland 5 | County 1 | 3 3 | 4482 | 1 | |
| 953 | Inverness, Skye and West Ross-shire | S14000094 | Scotland 5 | County 1 | 3 3 | 4483 | 1 | |
| 964 | Kilmarnock and Loudoun | S14000110 | Scotland 5 | County 1 | 3 3 | 4444 | 1 | |
| 996 | Livingston | S14000095 | Scotland 5 | County 1 | 3 3 | 4484 | 1 | |
| 998 | Lothian East | S14000096 | Scotland 5 | County 1 | 3 3 | 4485 | 1 | |
| 1023 | Mid Dunbartonshire | S14000097 | Scotland 5 | County 1 | 3 3 | 4486 | 1 | |
| 1030 | Midlothian | S14000045 | Scotland 5 | County 1 | 3 3 | 4445 | 1 | |
| 1036 | Moray West, Nairn and Strathspey | S14000098 | Scotland 5 | County 1 | 3 3 | 4487 | 1 | |
| 1038 | Motherwell, Wishaw and Carluke | S14000099 | Scotland 5 | County 1 | 3 3 | 4488 | 1 | |
| 1039 | Na h-Eileanan an Iar | S14000027 | Scotland 5 | County 1 | 3 3 | 4443 | 1 | |
| 1056 | North Ayrshire and Arran | S14000048 | Scotland 5 | County 1 | 3 3 | 4446 | 1 | |
| 1066 | North East Fife | S14000100 | Scotland 5 | County 1 | 3 3 | 4489 | 1 | |
| 1092 | Orkney and Shetland | S14000051 | Scotland 5 | County 1 | 3 3 | 4447 | 1 | |
| 1097 | Paisley and Renfrewshire North | S14000101 | Scotland 5 | Burgh 2 | 3 3 | 4490 | 1 | |
| 1098 | Paisley and Renfrewshire South | S14000102 | Scotland 5 | County 1 | 3 3 | 4491 | 1 | |
| 1103 | Perth and Kinross-shire | S14000103 | Scotland 5 | County 1 | 3 3 | 4492 | 1 | |
| 1139 | Rutherglen | S14000104 | Scotland 5 | Burgh 2 | 3 3 | 4493 | 1 | |
| 1201 | Stirling and Strathallan | S14000105 | Scotland 5 | County 1 | 3 3 | 4494 | 1 | |
| 1264 | West Aberdeenshire and Kincardine | S14000111 | Scotland 5 | County 1 | 3 3 | 4448 | 1 | |
| 1267 | West Dunbartonshire | S14000106 | Scotland 5 | County 1 | 3 3 | 4495 | 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] INTEGER,
[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]);