constituency_area_overlaps

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

4 rows where to_constituency_area_id = 805

✎ 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
104 0.5345933 0.47945878 0.72260886 0.5247781 0.5347022 0.47085878 Blyth Valley 63 Cramlington and Killingworth 805 0 0
662 0.05420864 0.054292064 0.24508883 0.17587574 0.05159249 0.05271424 Newcastle upon Tyne North 388 Cramlington and Killingworth 805 0 0
706 0.29054534 0.3318442 0.45661885 0.20967673 0.30166513 0.33385685 North Tyneside 415 Cramlington and Killingworth 805 0 0
1037 0.13014323 0.13440493 0.22544143 0.08966939 0.13710453 0.14257014 Tynemouth 586 Cramlington and Killingworth 805 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]);