boundary_set_legislation_items

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

10 rows where boundary_set_id = 24

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ boundary_set_id legislation_item_id
44 24 24 Parliamentary Constituencies (Scotland) (Glasgow Springburn, Glasgow Central and Glasgow Kelvingrove) Order 1955 49
45 24 24 Parliamentary Constituencies (Scotland) (Midlothian, Roxburgh, Selkirk and Peebles, and Edinburgh East) Order 1955 50
46 24 24 Parliamentary Constituencies (Scotland) (Bute and North Ayrshire and Central Ayrshire) Order 1955 51
47 24 24 Parliamentary Constituencies (Scotland) (Edinburgh North and Edinburgh West) Order 1955 52
48 24 24 Parliamentary Constituencies (Scotland) (East Aberdeenshire, West Aberdeenshire, Aberdeen North and Aberdeen South) Order 1955 53
49 24 24 Parliamentary Constituencies (Scotland) (Glasgow Pollok, Glasgow Craigton, Glasgow Govan and Glasgow Gorbals) Order 1955 54
50 24 24 Parliamentary Constituencies (Scotland) (Glasgow Scotstoun, Glasgow Hillhead and Glasgow Woodside) Order 1955 55
51 24 24 Parliamentary Constituencies (Scotland) (Edinburgh Central and Edinburgh Pentlands) Order 1955 56
52 24 24 Parliamentary Constituencies (Scotland) (Glasgow Bridgeton, Glasgow Provan and Glasgow Shettleston) Order 1955 57
53 24 24 Parliamentary Constituencies (Scotland) (West Stirlingshire and Stirling and Falkirk Burghs) Order 1955 58

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