boundary_set_legislation_items

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

4 rows where legislation_item_id = 9

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ boundary_set_id legislation_item_id
1 1 1 Parliamentary Constituencies Order 2023 9
2 2 2 Parliamentary Constituencies Order 2023 9
3 3 3 Parliamentary Constituencies Order 2023 9
4 4 4 Parliamentary Constituencies Order 2023 9

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