constituency_area_overlaps
Data license: Open Parliament Licence · Data source: UK Parliament election results website
5 rows where to_constituency_area_id = 1169
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 |
---|---|---|---|---|---|---|---|---|---|---|
1192 | 0.001565309 | 0.001780601 | 0.011864617 | 0.004951927 | 0.004310765 | 0.004639618 | Lagan Valley 317 | South Down 1169 | 0 | 0 |
1198 | 0.010925245 | 0.012367959 | 0.008387383 | 0.008093369 | 0.01495783 | 0.01726969 | Newry and Armagh 392 | South Down 1169 | 0 | 0 |
1208 | 0.8689155 | 0.9570009 | 0.851713 | 0.9493669 | 0.8577916 | 0.95209545 | South Down 511 | South Down 1169 | 0 | 0 |
1212 | 7.19804e-05 | 7.21865e-05 | 8.35343e-05 | 4.88187e-05 | 0.0 | 0.0 | Strangford 553 | South Down 1169 | 0 | 0 |
1215 | 0.022340108 | 0.028778363 | 0.08770945 | 0.037538975 | 0.020918798 | 0.025995227 | Upper Bann 587 | South Down 1169 | 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]);