constituency_groups

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

18 rows where constituency_group_set_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name constituency_area_id constituency_group_set_id
35 Belfast East Belfast East 35 4 4
36 Belfast North Belfast North 36 4 4
37 Belfast South Belfast South 37 4 4
38 Belfast West Belfast West 38 4 4
190 East Antrim East Antrim 190 4 4
196 East Londonderry East Londonderry 196 4 4
226 Fermanagh and South Tyrone Fermanagh and South Tyrone 226 4 4
231 Foyle Foyle 231 4 4
317 Lagan Valley Lagan Valley 317 4 4
365 Mid Ulster Mid Ulster 365 4 4
392 Newry and Armagh Newry and Armagh 392 4 4
395 North Antrim North Antrim 395 4 4
400 North Down North Down 400 4 4
506 South Antrim South Antrim 506 4 4
511 South Down South Down 511 4 4
553 Strangford Strangford 553 4 4
587 Upper Bann Upper Bann 587 4 4
620 West Tyrone West Tyrone 620 4 4

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "constituency_groups" (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [constituency_area_id] INTEGER REFERENCES [constituency_areas]([id]),
   [constituency_group_set_id] INTEGER REFERENCES [constituency_group_sets]([id])
);
CREATE INDEX [idx_constituency_groups_constituency_group_set_id]
    ON [constituency_groups] ([constituency_group_set_id]);
CREATE INDEX [idx_constituency_groups_constituency_area_id]
    ON [constituency_groups] ([constituency_area_id]);