constituency_areas

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

18 rows where boundary_set_id = 4

✎ 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 mnis_id is_geographic_code_issued_by_ons
686 Belfast East N05000001   Northern Ireland 4 Borough 3 4 4 4421 1
687 Belfast North N05000002   Northern Ireland 4 Borough 3 4 4 4422 1
688 Belfast South and Mid Down N05000003   Northern Ireland 4 Borough 3 4 4 4423 1
689 Belfast West N05000004   Northern Ireland 4 Borough 3 4 4 4424 1
840 East Antrim N05000005   Northern Ireland 4 County 1 4 4 4425 1
845 East Londonderry N05000006   Northern Ireland 4 County 1 4 4 4426 1
875 Fermanagh and South Tyrone N05000007   Northern Ireland 4 County 1 4 4 4427 1
880 Foyle N05000008   Northern Ireland 4 County 1 4 4 4428 1
971 Lagan Valley N05000009   Northern Ireland 4 County 1 4 4 4429 1
1027 Mid Ulster N05000010   Northern Ireland 4 County 1 4 4 4430 1
1051 Newry and Armagh N05000011   Northern Ireland 4 County 1 4 4 4431 1
1055 North Antrim N05000012   Northern Ireland 4 County 1 4 4 4432 1
1062 North Down N05000013   Northern Ireland 4 County 1 4 4 4433 1
1162 South Antrim N05000014   Northern Ireland 4 County 1 4 4 4434 1
1169 South Down N05000015   Northern Ireland 4 County 1 4 4 4435 1
1210 Strangford N05000016   Northern Ireland 4 County 1 4 4 4436 1
1246 Upper Bann N05000017   Northern Ireland 4 County 1 4 4 4437 1
1271 West Tyrone N05000018   Northern Ireland 4 County 1 4 4 4438 1

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