home / psephology

constituency_group_sets

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

0 rows where parent_constituency_group_set_id = 7

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "constituency_group_sets" (
   [id] INTEGER PRIMARY KEY,
   [start_on] TEXT,
   [end_on] TEXT,
   [country_id] INTEGER REFERENCES [countries]([id]),
   [parent_constituency_group_set_id] TEXT REFERENCES [constituency_group_sets]([id]),
   [description] TEXT
);
CREATE INDEX [idx_constituency_group_sets_parent_constituency_group_set_id]
    ON [constituency_group_sets] ([parent_constituency_group_set_id]);
CREATE INDEX [idx_constituency_group_sets_country_id]
    ON [constituency_group_sets] ([country_id]);
Powered by Datasette · Queries took 7.406ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website