boundary_sets

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

4 rows where end_on = "1950-02-03"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ start_on end_on country_id parent_boundary_set_id description
25 1945-06-16 1950-02-03 England 2    
30 1922-10-27 1950-02-03 Northern Ireland 4    
33 1918-11-26 1950-02-03 Wales 6    
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]),
   [parent_boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]),
   [description] TEXT
);
CREATE INDEX [idx_boundary_sets_parent_boundary_set_id]
    ON [boundary_sets] ([parent_boundary_set_id]);
CREATE INDEX [idx_boundary_sets_country_id]
    ON [boundary_sets] ([country_id]);