constituency_group_sets

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

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start_on, end_on, country_id, start_on (date), end_on (date)

id ▼ start_on end_on country_id parent_constituency_group_set_id description
1 2010-04-13 2024-05-30 Wales 6    
2 2005-04-12 2024-05-30 Scotland 5    
3 2010-04-13 2024-05-30 England 2    
4 2010-04-13 2024-05-30 Northern Ireland 4    
5 2024-05-31   Wales 6    
6 2024-05-31   Scotland 5    
7 2024-05-31   England 2    
8 2024-05-31   Northern Ireland 4    
9 1997-04-09 2010-04-12 Wales 6    
10 1997-04-09 2005-04-11 Scotland 5    
11 1997-04-09 2010-04-12 England 2    
12 1997-04-09 2010-04-12 Northern Ireland 4    

Advanced export

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

CSV options: 

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