constituency_areas

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

56 rows where english_region_id = 9

✎ 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
41 Berwick-Upon-Tweed E14000554 North East 9 England 2 County 1 6 6
56 Bishop Auckland E14000569 North East 9 England 2 County 1 6 6
62 Blaydon E14000574 North East 9 England 2 Borough 3 6 6
63 Blyth Valley E14000575 North East 9 England 2 Borough 3 6 6
141 City Of Durham E14000641 North East 9 England 2 County 1 6 6
163 Darlington E14000658 North East 9 England 2 Borough 3 6 6
189 Easington E14000677 North East 9 England 2 County 1 6 6
235 Gateshead E14000709 North East 9 England 2 Borough 3 6 6
269 Hartlepool E14000733 North East 9 England 2 Borough 3 6 6
282 Hexham E14000746 North East 9 England 2 County 1 6 6
290 Houghton and Sunderland South E14000754 North East 9 England 2 Borough 3 6 6
304 Jarrow E14000765 North East 9 England 2 Borough 3 6 6
367 Middlesbrough E14000819 North East 9 England 2 Borough 3 6 6
368 Middlesbrough South and East Cleveland E14000820 North East 9 England 2 County 1 6 6
386 Newcastle Upon Tyne Central E14000831 North East 9 England 2 Borough 3 6 6
387 Newcastle Upon Tyne East E14000832 North East 9 England 2 Borough 3 6 6
388 Newcastle Upon Tyne North E14000833 North East 9 England 2 Borough 3 6 6
401 North Durham E14000840 North East 9 England 2 County 1 6 6
415 North Tyneside E14000853 North East 9 England 2 Borough 3 6 6
418 North West Durham E14000856 North East 9 England 2 County 1 6 6
461 Redcar E14000891 North East 9 England 2 Borough 3 6 6
488 Sedgefield E14000915 North East 9 England 2 County 1 6 6
519 South Shields E14000944 North East 9 England 2 Borough 3 6 6
546 Stockton North E14000970 North East 9 England 2 Borough 3 6 6
547 Stockton South E14000971 North East 9 England 2 Borough 3 6 6
559 Sunderland Central E14000982 North East 9 England 2 Borough 3 6 6
586 Tynemouth E14001006 North East 9 England 2 Borough 3 6 6
597 Wansbeck E14001014 North East 9 England 2 County 1 6 6
603 Washington and Sunderland West E14001020 North East 9 England 2 Borough 3 6 6
707 Bishop Auckland E14001101 North East 9 England 2 County 1 1 1
713 Blaydon and Consett E14001106 North East 9 England 2 County 1 1 1
714 Blyth and Ashington E14001107 North East 9 England 2 County 1 1 1
791 City of Durham E14001173 North East 9 England 2 County 1 1 1
805 Cramlington and Killingworth E14001183 North East 9 England 2 County 1 1 1
813 Darlington E14001190 North East 9 England 2 County 1 1 1
839 Easington E14001211 North East 9 England 2 County 1 1 1
884 Gateshead Central and Whickham E14001244 North East 9 England 2 Borough 3 1 1
922 Hartlepool E14001272 North East 9 England 2 County 1 1 1
935 Hexham E14001285 North East 9 England 2 County 1 1 1
945 Houghton and Sunderland South E14001295 North East 9 England 2 County 1 1 1
959 Jarrow and Gateshead East E14001307 North East 9 England 2 Borough 3 1 1
1028 Middlesbrough and Thornaby East E14001367 North East 9 England 2 Borough 3 1 1
1029 Middlesbrough South and East Cleveland E14001368 North East 9 England 2 County 1 1 1
1045 Newcastle upon Tyne Central and West E14001377 North East 9 England 2 Borough 3 1 1
1046 Newcastle upon Tyne East and Wallsend E14001378 North East 9 England 2 Borough 3 1 1
1047 Newcastle upon Tyne North E14001379 North East 9 England 2 Borough 3 1 1
1053 Newton Aycliffe and Spennymoor E14001382 North East 9 England 2 County 1 1 1
1063 North Durham E14001389 North East 9 England 2 County 1 1 1
1072 North Northumberland E14001397 North East 9 England 2 County 1 1 1
1120 Redcar E14001440 North East 9 England 2 Borough 3 1 1
1176 South Shields E14001492 North East 9 England 2 Borough 3 1 1
1203 Stockton North E14001518 North East 9 England 2 County 1 1 1
1204 Stockton West E14001519 North East 9 England 2 County 1 1 1
1217 Sunderland Central E14001531 North East 9 England 2 Borough 3 1 1
1245 Tynemouth E14001557 North East 9 England 2 Borough 3 1 1
1257 Washington and Gateshead South E14001567 North East 9 England 2 Borough 3 1 1

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])
);
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]);