electorates

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

5 rows where constituency_group_id = 505

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ population_count constituency_group_id
505 83281 Somerton and Frome 505
1154 84437 Somerton and Frome 505
1804 85866 Somerton and Frome 505
3104 81548 Somerton and Frome 505
3914 87921 Somerton and Frome 505

Advanced export

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

CSV options: 

CREATE TABLE "electorates" (
   [id] INTEGER PRIMARY KEY,
   [population_count] INTEGER,
   [constituency_group_id] INTEGER REFERENCES [constituency_groups]([id])
);
CREATE INDEX [idx_electorates_constituency_group_id]
    ON [electorates] ([constituency_group_id]);