constituency_area_overlaps

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

3 rows where to_constituency_area_id = 993

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ from_constituency_residential to_constituency_residential from_constituency_geographical to_constituency_geographical from_constituency_population to_constituency_population from_constituency_area_id to_constituency_area_id formed_from_whole_of forms_whole_of
577 0.63010526 0.62732124 0.70048916 0.54611546 0.65167874 0.60297304 Liverpool, Walton 338 Liverpool Walton 993 0 0
581 0.331714 0.31043756 0.38487914 0.31302148 0.35405725 0.33141345 Liverpool, West Derby 340 Liverpool Walton 993 0 0
840 0.07458945 0.062241197 0.03682199 0.14086305 0.0779189 0.0656135 Sefton Central 489 Liverpool Walton 993 0 0

Advanced export

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

CSV options: 

CREATE TABLE "constituency_area_overlaps" (
   [id] INTEGER PRIMARY KEY,
   [from_constituency_residential] FLOAT,
   [to_constituency_residential] FLOAT,
   [from_constituency_geographical] FLOAT,
   [to_constituency_geographical] FLOAT,
   [from_constituency_population] FLOAT,
   [to_constituency_population] FLOAT,
   [from_constituency_area_id] INTEGER REFERENCES [constituency_areas]([id]),
   [to_constituency_area_id] INTEGER REFERENCES [constituency_areas]([id]),
   [formed_from_whole_of] INTEGER,
   [forms_whole_of] INTEGER
);
CREATE INDEX [idx_constituency_area_overlaps_to_constituency_area_id]
    ON [constituency_area_overlaps] ([to_constituency_area_id]);
CREATE INDEX [idx_constituency_area_overlaps_from_constituency_area_id]
    ON [constituency_area_overlaps] ([from_constituency_area_id]);