constituency_area_overlaps
Data license: Open Parliament Licence · Data source: UK Parliament election results website
4 rows where to_constituency_area_id = 689
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 |
---|---|---|---|---|---|---|---|---|---|---|
1169 | 0.07954478 | 0.08997973 | 0.021169081 | 0.02720899 | 0.06659351 | 0.070147835 | Belfast North 36 | Belfast West 689 | 0 | 0 |
1173 | 0.000241286 | 0.000289539 | 0.000149521 | 0.000171254 | 0.0 | 0.0 | Belfast South 37 | Belfast West 689 | 0 | 0 |
1176 | 0.94796354 | 0.849618 | 0.77075475 | 0.88908345 | 0.9521109 | 0.87556577 | Belfast West 38 | Belfast West 689 | 0 | 0 |
1189 | 0.057091486 | 0.060112696 | 0.006988545 | 0.08353633 | 0.0495738 | 0.05428638 | Lagan Valley 317 | Belfast West 689 | 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]);