electorates

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

4 rows where constituency_group_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ population_count constituency_group_id
123 76666 Central Suffolk and North Ipswich 123
772 78116 Central Suffolk and North Ipswich 123
1422 80037 Central Suffolk and North Ipswich 123
2722 75786 Central Suffolk and North Ipswich 123

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