constituency_areas

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

164 rows where english_region_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_area_type_id, boundary_set_id

id ▼ name geographic_code english_region_id country_id constituency_area_type_id boundary_set_id mnis_id is_geographic_code_issued_by_ons
29 Bath E14000547 South West 8 England 2 Borough 3 6 6 3308 1
72 Bournemouth East E14000584 South West 8 England 2 Borough 3 6 6 3350 1
73 Bournemouth West E14000585 South West 8 England 2 Borough 3 6 6 3351 1
85 Bridgwater and West Somerset E14000595 South West 8 England 2 County 1 6 6 3363 1
89 Bristol East E14000599 South West 8 England 2 Borough 3 6 6 3367 1
90 Bristol North West E14000600 South West 8 England 2 Borough 3 6 6 3368 1
91 Bristol South E14000601 South West 8 England 2 Borough 3 6 6 3369 1
92 Bristol West E14000602 South West 8 England 2 Borough 3 6 6 3370 1
108 Camborne and Redruth E14000616 South West 8 England 2 County 1 6 6 3385 1
122 Central Devon E14000623 South West 8 England 2 County 1 6 6 3398 1
130 Cheltenham E14000630 South West 8 England 2 Borough 3 6 6 3406 1
135 Chippenham E14000635 South West 8 England 2 County 1 6 6 3411 1
138 Christchurch E14000638 South West 8 England 2 County 1 6 6 3414 1
171 Devizes E14000665 South West 8 England 2 County 1 6 6 3445 1
191 East Devon E14000678 South West 8 England 2 County 1 6 6 3460 1
221 Exeter E14000698 South West 8 England 2 Borough 3 6 6 3481 1
227 Filton and Bradley Stoke E14000702 South West 8 England 2 County 1 6 6 3486 1
230 Forest of Dean E14000705 South West 8 England 2 County 1 6 6 3489 1
246 Gloucester E14000712 South West 8 England 2 Borough 3 6 6 3497 1
314 Kingswood E14000774 South West 8 England 2 Borough 3 6 6 3561 1
362 Mid Dorset and North Poole E14000815 South West 8 England 2 County 1 6 6 3605 1
393 Newton Abbot E14000835 South West 8 England 2 County 1 6 6 3632 1
397 North Cornwall E14000837 South West 8 England 2 County 1 6 6 3635 1
398 North Devon E14000838 South West 8 England 2 County 1 6 6 3636 1
399 North Dorset E14000839 South West 8 England 2 County 1 6 6 3637 1
408 North East Somerset E14000846 South West 8 England 2 County 1 6 6 3645 1
412 North Somerset E14000850 South West 8 England 2 County 1 6 6 3649 1
413 North Swindon E14000851 South West 8 England 2 County 1 6 6 3650 1
422 North Wiltshire E14000860 South West 8 England 2 County 1 6 6 3659 1
447 Plymouth, Moor View E14000879 South West 8 England 2 Borough 3 6 6 3679 1
448 Plymouth, Sutton and Devonport E14000880 South West 8 England 2 Borough 3 6 6 3680 1
450 Poole E14000881 South West 8 England 2 Borough 3 6 6 3682 1
485 Salisbury E14000912 South West 8 England 2 County 1 6 6 3715 1
505 Somerton and Frome E14000932 South West 8 England 2 County 1 6 6 3735 1
510 South Dorset E14000936 South West 8 England 2 County 1 6 6 3740 1
513 South East Cornwall E14000938 South West 8 England 2 County 1 6 6 3743 1
522 South Swindon E14000947 South West 8 England 2 County 1 6 6 3752 1
525 South West Devon E14000950 South West 8 England 2 County 1 6 6 3755 1
529 South West Wiltshire E14000954 South West 8 England 2 County 1 6 6 3759 1
536 St Austell and Newquay E14000961 South West 8 England 2 County 1 6 6 3766 1
539 St Ives E14000964 South West 8 England 2 County 1 6 6 3769 1
557 Stroud E14000980 South West 8 England 2 County 1 6 6 3786 1
567 Taunton Deane E14000988 South West 8 England 2 County 1 6 6 3796 1
569 Tewkesbury E14000990 South West 8 England 2 County 1 6 6 3798 1
570 The Cotswolds E14000991 South West 8 England 2 County 1 6 6 3799 1
573 Thornbury and Yate E14000994 South West 8 England 2 County 1 6 6 3802 1
575 Tiverton and Honiton E14000996 South West 8 England 2 County 1 6 6 3804 1
578 Torbay E14000999 South West 8 England 2 Borough 3 6 6 3807 1
580 Torridge and West Devon E14001000 South West 8 England 2 County 1 6 6 3809 1
581 Totnes E14001001 South West 8 England 2 County 1 6 6 3810 1
583 Truro and Falmouth E14001003 South West 8 England 2 County 1 6 6 3812 1
609 Wells E14001026 South West 8 England 2 County 1 6 6 3838 1
615 West Dorset E14001031 South West 8 England 2 County 1 6 6 3843 1
624 Weston-Super-Mare E14001038 South West 8 England 2 County 1 6 6 3851 1
647 Yeovil E14001060 South West 8 England 2 County 1 6 6 3874 1
680 Bath E14001080 South West 8 England 2 County 1 1 1 3895 1
722 Bournemouth East E14001115 South West 8 England 2 Borough 3 1 1 3930 1
723 Bournemouth West E14001116 South West 8 England 2 Borough 3 1 1 3931 1
735 Bridgwater E14001126 South West 8 England 2 County 1 1 1 3941 1
740 Bristol Central E14001131 South West 8 England 2 Borough 3 1 1 3946 1
741 Bristol East E14001132 South West 8 England 2 Borough 3 1 1 3947 1
742 Bristol North East E14001133 South West 8 England 2 Borough 3 1 1 3948 1
743 Bristol North West E14001134 South West 8 England 2 Borough 3 1 1 3949 1
744 Bristol South E14001135 South West 8 England 2 Borough 3 1 1 3950 1
760 Camborne and Redruth E14001148 South West 8 England 2 County 1 1 1 3963 1
772 Central Devon E14001155 South West 8 England 2 County 1 1 1 3970 1
779 Cheltenham E14001161 South West 8 England 2 Borough 3 1 1 3976 1
786 Chippenham E14001168 South West 8 England 2 County 1 1 1 3983 1
789 Christchurch E14001171 South West 8 England 2 County 1 1 1 3986 1
849 East Wiltshire E14001217 South West 8 England 2 County 1 1 1 4032 1
868 Exeter E14001231 South West 8 England 2 Borough 3 1 1 4046 1
869 Exmouth and Exeter East E14001232 South West 8 England 2 County 1 1 1 4047 1
876 Filton and Bradley Stoke E14001237 South West 8 England 2 Borough 3 1 1 4052 1
879 Forest of Dean E14001240 South West 8 England 2 County 1 1 1 4055 1
881 Frome and East Somerset E14001241 South West 8 England 2 County 1 1 1 4056 1
893 Glastonbury and Somerton E14001247 South West 8 England 2 County 1 1 1 4062 1
895 Gloucester E14001248 South West 8 England 2 Borough 3 1 1 4063 1
941 Honiton and Sidmouth E14001291 South West 8 England 2 County 1 1 1 4106 1
1013 Melksham and Devizes E14001356 South West 8 England 2 County 1 1 1 4171 1
1022 Mid Dorset and North Poole E14001363 South West 8 England 2 County 1 1 1 4178 1
1052 Newton Abbot E14001381 South West 8 England 2 County 1 1 1 4196 1
1058 North Cornwall E14001385 South West 8 England 2 County 1 1 1 4200 1
1059 North Cotswolds E14001386 South West 8 England 2 County 1 1 1 4201 1
1060 North Devon E14001387 South West 8 England 2 County 1 1 1 4202 1
1061 North Dorset E14001388 South West 8 England 2 County 1 1 1 4203 1
1069 North East Somerset and Hanham E14001394 South West 8 England 2 County 1 1 1 4209 1
1074 North Somerset E14001399 South West 8 England 2 County 1 1 1 4214 1
1105 Plymouth Moor View E14001426 South West 8 England 2 Borough 3 1 1 4241 1
1106 Plymouth Sutton and Devonport E14001427 South West 8 England 2 Borough 3 1 1 4242 1
1109 Poole E14001429 South West 8 England 2 Borough 3 1 1 4244 1
1142 Salisbury E14001460 South West 8 England 2 County 1 1 1 4275 1
1165 South Cotswolds E14001482 South West 8 England 2 County 1 1 1 4297 1
1167 South Devon E14001484 South West 8 England 2 County 1 1 1 4299 1
1168 South Dorset E14001485 South West 8 England 2 County 1 1 1 4300 1
1170 South East Cornwall E14001486 South West 8 England 2 County 1 1 1 4301 1
1179 South West Devon E14001495 South West 8 England 2 County 1 1 1 4310 1
1182 South West Wiltshire E14001498 South West 8 England 2 County 1 1 1 4313 1
1192 St Austell and Newquay E14001508 South West 8 England 2 County 1 1 1 4323 1
1195 St Ives E14001511 South West 8 England 2 County 1 1 1 4326 1
1215 Stroud E14001529 South West 8 England 2 County 1 1 1 4344 1

Next page

Advanced export

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

CSV options: 

CREATE TABLE "constituency_areas" (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [geographic_code] TEXT,
   [english_region_id] INTEGER REFERENCES [english_regions]([id]),
   [country_id] INTEGER REFERENCES [countries]([id]),
   [constituency_area_type_id] INTEGER REFERENCES [constituency_area_types]([id]),
   [boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]),
   [mnis_id] INTEGER,
   [is_geographic_code_issued_by_ons] INTEGER
);
CREATE INDEX [idx_constituency_areas_boundary_set_id]
    ON [constituency_areas] ([boundary_set_id]);
CREATE INDEX [idx_constituency_areas_constituency_area_type_id]
    ON [constituency_areas] ([constituency_area_type_id]);
CREATE INDEX [idx_constituency_areas_country_id]
    ON [constituency_areas] ([country_id]);
CREATE INDEX [idx_constituency_areas_english_region_id]
    ON [constituency_areas] ([english_region_id]);