boundary_sets

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

8 rows where country_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ start_on end_on country_id
3 2024-05-31   Scotland 5
8 2005-04-12 2024-05-30 Scotland 5
11 1997-04-09 2005-04-11 Scotland 5
14 1983-05-14 1997-04-08 Scotland 5
18 1974-02-09 1983-05-13 Scotland 5
24 1955-05-07 1974-02-08 Scotland 5
28 1950-02-04 1955-05-06 Scotland 5
34 1918-11-26 1950-02-03 Scotland 5

Advanced export

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

CSV options: 

CREATE TABLE "boundary_sets" (
   [id] INTEGER PRIMARY KEY,
   [start_on] TEXT,
   [end_on] TEXT,
   [country_id] INTEGER REFERENCES [countries]([id])
);
CREATE INDEX [idx_boundary_sets_country_id]
    ON [boundary_sets] ([country_id]);