boundary_set_legislation_items

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

3 rows where boundary_set_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ boundary_set_id legislation_item_id
22 22 22 Parliamentary Constituencies (Newport and Monmouth) Order 1955 27
23 22 22 Parliamentary Constituencies (Swansea) Order 1955 28
24 22 22 Parliamentary Constituencies (Carmarthenshire) Order 1955 29

Advanced export

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

CSV options: 

CREATE TABLE "boundary_set_legislation_items" (
   [id] INTEGER PRIMARY KEY,
   [boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]),
   [legislation_item_id] INTEGER REFERENCES [legislation_items]([id])
);
CREATE INDEX [idx_boundary_set_legislation_items_legislation_item_id]
    ON [boundary_set_legislation_items] ([legislation_item_id]);
CREATE INDEX [idx_boundary_set_legislation_items_boundary_set_id]
    ON [boundary_set_legislation_items] ([boundary_set_id]);