constituency_areas

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

222 rows where english_region_id = 5

✎ 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
22 Barking E14000540 London 5 England 2 Borough 3 6 6   1
31 Battersea E14000549 London 5 England 2 Borough 3 6 6   1
33 Beckenham E14000551 London 5 England 2 Borough 3 6 6   1
39 Bermondsey and Old Southwark E14000553 London 5 England 2 Borough 3 6 6   1
42 Bethnal Green and Bow E14000555 London 5 England 2 Borough 3 6 6   1
45 Bexleyheath and Crayford E14000558 London 5 England 2 Borough 3 6 6   1
80 Brent Central E14000591 London 5 England 2 Borough 3 6 6   1
81 Brent North E14000592 London 5 England 2 Borough 3 6 6   1
82 Brentford and Isleworth E14000593 London 5 England 2 Borough 3 6 6   1
94 Bromley and Chislehurst E14000604 London 5 England 2 Borough 3 6 6   1
107 Camberwell and Peckham E14000615 London 5 England 2 Borough 3 6 6   1
119 Carshalton and Wallington E14000621 London 5 England 2 Borough 3 6 6   1
129 Chelsea and Fulham E14000629 London 5 England 2 Borough 3 6 6   1
134 Chingford and Woodford Green E14000634 London 5 England 2 County 1 6 6   1
136 Chipping Barnet E14000636 London 5 England 2 Borough 3 6 6   1
139 Cities Of London and Westminster E14000639 London 5 England 2 Borough 3 6 6   1
157 Croydon Central E14000654 London 5 England 2 Borough 3 6 6   1
158 Croydon North E14000655 London 5 England 2 Borough 3 6 6   1
159 Croydon South E14000656 London 5 England 2 Borough 3 6 6   1
162 Dagenham and Rainham E14000657 London 5 England 2 Borough 3 6 6   1
179 Dulwich and West Norwood E14000673 London 5 England 2 Borough 3 6 6   1
186 Ealing Central and Acton E14000674 London 5 England 2 Borough 3 6 6   1
187 Ealing North E14000675 London 5 England 2 Borough 3 6 6   1
188 Ealing, Southall E14000676 London 5 England 2 Borough 3 6 6   1
193 East Ham E14000679 London 5 England 2 Borough 3 6 6   1
210 Edmonton E14000687 London 5 England 2 Borough 3 6 6   1
213 Eltham E14000690 London 5 England 2 Borough 3 6 6   1
214 Enfield North E14000691 London 5 England 2 Borough 3 6 6   1
215 Enfield, Southgate E14000692 London 5 England 2 Borough 3 6 6   1
219 Erith and Thamesmead E14000696 London 5 England 2 Borough 3 6 6   1
225 Feltham and Heston E14000701 London 5 England 2 Borough 3 6 6   1
228 Finchley and Golders Green E14000703 London 5 England 2 Borough 3 6 6   1
254 Greenwich and Woolwich E14000718 London 5 England 2 Borough 3 6 6   1
256 Hackney North and Stoke Newington E14000720 London 5 England 2 Borough 3 6 6   1
257 Hackney South and Shoreditch E14000721 London 5 England 2 Borough 3 6 6   1
262 Hammersmith E14000726 London 5 England 2 Borough 3 6 6   1
263 Hampstead and Kilburn E14000727 London 5 England 2 Borough 3 6 6   1
267 Harrow East E14000731 London 5 England 2 Borough 3 6 6   1
268 Harrow West E14000732 London 5 England 2 Borough 3 6 6   1
273 Hayes and Harlington E14000737 London 5 England 2 Borough 3 6 6   1
277 Hendon E14000741 London 5 England 2 Borough 3 6 6   1
286 Holborn and St Pancras E14000750 London 5 England 2 Borough 3 6 6   1
287 Hornchurch and Upminster E14000751 London 5 England 2 Borough 3 6 6   1
288 Hornsey and Wood Green E14000752 London 5 England 2 Borough 3 6 6   1
295 Ilford North E14000759 London 5 England 2 Borough 3 6 6   1
296 Ilford South E14000760 London 5 England 2 Borough 3 6 6   1
301 Islington North E14000763 London 5 England 2 Borough 3 6 6   1
302 Islington South and Finsbury E14000764 London 5 England 2 Borough 3 6 6   1
307 Kensington E14000768 London 5 England 2 Borough 3 6 6   1
310 Kingston and Surbiton E14000770 London 5 England 2 Borough 3 6 6   1
330 Lewisham East E14000787 London 5 England 2 Borough 3 6 6   1
331 Lewisham West and Penge E14000788 London 5 England 2 Borough 3 6 6   1
332 Lewisham, Deptford E14000789 London 5 England 2 Borough 3 6 6   1
333 Leyton and Wanstead E14000790 London 5 England 2 County 1 6 6   1
372 Mitcham and Morden E14000823 London 5 England 2 Borough 3 6 6   1
433 Old Bexley and Sidcup E14000869 London 5 England 2 Borough 3 6 6   1
437 Orpington E14000872 London 5 England 2 Borough 3 6 6   1
451 Poplar and Limehouse E14000882 London 5 England 2 Borough 3 6 6   1
457 Putney E14000887 London 5 England 2 Borough 3 6 6   1
467 Richmond Park E14000896 London 5 England 2 Borough 3 6 6   1
471 Romford E14000900 London 5 England 2 Borough 3 6 6   1
478 Ruislip, Northwood and Pinner E14000906 London 5 England 2 Borough 3 6 6   1
555 Streatham E14000978 London 5 England 2 Borough 3 6 6   1
561 Sutton and Cheam E14000984 London 5 England 2 Borough 3 6 6   1
577 Tooting E14000998 London 5 England 2 Borough 3 6 6   1
582 Tottenham E14001002 London 5 England 2 Borough 3 6 6   1
585 Twickenham E14001005 London 5 England 2 Borough 3 6 6   1
588 Uxbridge and South Ruislip E14001007 London 5 England 2 Borough 3 6 6   1
591 Vauxhall E14001008 London 5 England 2 Borough 3 6 6   1
596 Walthamstow E14001013 London 5 England 2 County 1 6 6   1
617 West Ham E14001032 London 5 England 2 Borough 3 6 6   1
622 Westminster North E14001036 London 5 England 2 Borough 3 6 6   1
626 Wimbledon E14001040 London 5 England 2 Borough 3 6 6   1
673 Barking E14001073 London 5 England 2 Borough 3 1 1   1
682 Battersea E14001081 London 5 England 2 Borough 3 1 1   1
684 Beckenham and Penge E14001083 London 5 England 2 Borough 3 1 1   1
690 Bermondsey and Old Southwark E14001085 London 5 England 2 Borough 3 1 1   1
692 Bethnal Green and Stepney E14001086 London 5 England 2 Borough 3 1 1   1
695 Bexleyheath and Crayford E14001089 London 5 England 2 Borough 3 1 1   1
730 Brent East E14001122 London 5 England 2 Borough 3 1 1   1
731 Brent West E14001123 London 5 England 2 Borough 3 1 1   1
732 Brentford and Isleworth E14001124 London 5 England 2 Borough 3 1 1   1
746 Bromley and Biggin Hill E14001137 London 5 England 2 Borough 3 1 1   1
769 Carshalton and Wallington E14001153 London 5 England 2 Borough 3 1 1   1
778 Chelsea and Fulham E14001160 London 5 England 2 Borough 3 1 1   1
785 Chingford and Woodford Green E14001167 London 5 England 2 Borough 3 1 1   1
787 Chipping Barnet E14001169 London 5 England 2 Borough 3 1 1   1
790 Cities of London and Westminster E14001172 London 5 England 2 Borough 3 1 1   1
793 Clapham and Brixton Hill E14001175 London 5 England 2 Borough 3 1 1   1
808 Croydon East E14001186 London 5 England 2 Borough 3 1 1   1
809 Croydon South E14001187 London 5 England 2 Borough 3 1 1   1
810 Croydon West E14001188 London 5 England 2 Borough 3 1 1   1
812 Dagenham and Rainham E14001189 London 5 England 2 Borough 3 1 1   1
828 Dulwich and West Norwood E14001205 London 5 England 2 Borough 3 1 1   1
835 Ealing Central and Acton E14001207 London 5 England 2 Borough 3 1 1   1
836 Ealing North E14001208 London 5 England 2 Borough 3 1 1   1
837 Ealing Southall E14001209 London 5 England 2 Borough 3 1 1   1
842 East Ham E14001213 London 5 England 2 Borough 3 1 1   1
858 Edmonton and Winchmore Hill E14001221 London 5 England 2 Borough 3 1 1   1
860 Eltham and Chislehurst E14001223 London 5 England 2 Borough 3 1 1   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] TEXT,
   [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]);