home / psephology

electorates

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

6 rows where constituency_group_id = 1136

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ population_count constituency_group_id
2442 70950 Runcorn and Helsby 1136
3735 70801 Runcorn and Helsby 1136
3928 32740 Runcorn and Helsby 1136
3929 70261 Runcorn and Helsby 1136
3930 70666 Runcorn and Helsby 1136
3931 32655 Runcorn and Helsby 1136

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]);
Powered by Datasette · Queries took 7.275ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website