constituency_area_overlaps
Data license: Open Parliament Licence · Data source: UK Parliament election results website
4 rows where to_constituency_area_id = 1277
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 |
---|---|---|---|---|---|---|---|---|---|---|
394 | 0.20006809 | 0.22391827 | 0.32530716 | 0.2919152 | 0.20363931 | 0.22464658 | Garston and Halewood 234 | Widnes and Halewood 1277 | 0 | 0 |
427 | 0.6438711 | 0.6923535 | 0.670552 | 0.58648807 | 0.6593248 | 0.69508016 | Halton 261 | Widnes and Halewood 1277 | 0 | 0 |
532 | 0.0 | 0.0 | 0.000607776 | 0.000464183 | 0.0 | 0.0 | Knowsley 316 | Widnes and Halewood 1277 | 0 | 0 |
951 | 0.06965825 | 0.08372824 | 0.1340277 | 0.12113252 | 0.07018503 | 0.080273256 | St Helens South and Whiston 538 | Widnes and Halewood 1277 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);