home / psephology

constituency_group_set_legislation_items

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

1 row where constituency_group_set_id = 2

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ constituency_group_set_id legislation_item_id
2 2 2 Parliamentary Constituencies (Scotland) Order 2005 13

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]);
Powered by Datasette · Queries took 11.906ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows