constituency_group_set_legislation_items

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

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: legislation_item_id

id ▼ constituency_group_set_id legislation_item_id
1 1 1 Parliamentary Constituencies and Assembly Electoral Regions (Wales) Order 2006 12
2 2 2 Parliamentary Constituencies (Scotland) Order 2005 13
3 3 3 Parliamentary Constituencies (England) Order 2007 11
4 4 4 Parliamentary Constituencies (Northern Ireland) Order 2008 10
5 5 5 Parliamentary Constituencies Order 2023 9
6 6 6 Parliamentary Constituencies Order 2023 9
7 7 7 Parliamentary Constituencies Order 2023 9
8 8 8 Parliamentary Constituencies Order 2023 9
9 9 9 Parliamentary Constituencies (Wales) Order 1995 17
10 10 10 Parliamentary Constituencies (Scotland) Order 1995 16
11 11 11 Parliamentary Constituencies (England) Order 1995 15
12 12 12 Parliamentary Constituencies (Northern Ireland) Order 1995 14

Advanced export

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

CSV options: 

CREATE TABLE "constituency_group_set_legislation_items" (
   [id] INTEGER PRIMARY KEY,
   [constituency_group_set_id] INTEGER REFERENCES [constituency_group_sets]([id]),
   [legislation_item_id] INTEGER REFERENCES [legislation_items]([id])
);
CREATE INDEX [idx_constituency_group_set_legislation_items_legislation_item_id]
    ON [constituency_group_set_legislation_items] ([legislation_item_id]);
CREATE INDEX [idx_constituency_group_set_legislation_items_constituency_group_set_id]
    ON [constituency_group_set_legislation_items] ([constituency_group_set_id]);