constituency_areas

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

18 rows where boundary_set_id = 5

✎ 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
35 Belfast East N06000001   Northern Ireland 4 Borough 3 5 5
36 Belfast North N06000002   Northern Ireland 4 Borough 3 5 5
37 Belfast South N06000003   Northern Ireland 4 Borough 3 5 5
38 Belfast West N06000004   Northern Ireland 4 Borough 3 5 5
190 East Antrim N06000005   Northern Ireland 4 County 1 5 5
196 East Londonderry N06000006   Northern Ireland 4 County 1 5 5
226 Fermanagh and South Tyrone N06000007   Northern Ireland 4 County 1 5 5
231 Foyle N06000008   Northern Ireland 4 County 1 5 5
317 Lagan Valley N06000009   Northern Ireland 4 County 1 5 5
365 Mid Ulster N06000010   Northern Ireland 4 County 1 5 5
392 Newry and Armagh N06000011   Northern Ireland 4 County 1 5 5
395 North Antrim N06000012   Northern Ireland 4 County 1 5 5
400 North Down N06000013   Northern Ireland 4 County 1 5 5
506 South Antrim N06000014   Northern Ireland 4 County 1 5 5
511 South Down N06000015   Northern Ireland 4 County 1 5 5
553 Strangford N06000016   Northern Ireland 4 County 1 5 5
587 Upper Bann N06000017   Northern Ireland 4 County 1 5 5
620 West Tyrone N06000018   Northern Ireland 4 County 1 5 5

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