enablings

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

10 rows where enabling_legislation_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ enabling_legislation_id enabled_legislation_id
1 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies Order 2023 9
2 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (Northern Ireland) Order 2008 10
3 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (England) Order 2007 11
4 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies and Assembly Electoral Regions (Wales) Order 2006 12
5 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (Scotland) Order 2005 13
6 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (Northern Ireland) Order 1995 14
8 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (England) Order 1995 15
9 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (Scotland) Order 1995 16
10 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (Wales) Order 1995 17
11 Parliamentary Constituencies Act 1986 1 Parliamentary Constituencies (England) (Miscellaneous Changes) Order 1990 18

Advanced export

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

CSV options: 

CREATE TABLE "enablings" (
   [id] INTEGER PRIMARY KEY,
   [enabling_legislation_id] INTEGER REFERENCES [legislation_items]([id]),
   [enabled_legislation_id] INTEGER REFERENCES [legislation_items]([id])
);
CREATE INDEX [idx_enablings_enabled_legislation_id]
    ON [enablings] ([enabled_legislation_id]);
CREATE INDEX [idx_enablings_enabling_legislation_id]
    ON [enablings] ([enabling_legislation_id]);