constituency_groups

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

1,959 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_group_set_id

id ▼ name constituency_area_id constituency_group_set_id
1 Aberavon Aberavon 1 1 1
2 Aberconwy Aberconwy 2 1 1
3 Aberdeen North Aberdeen North 3 2 2
4 Aberdeen South Aberdeen South 4 2 2
5 Airdrie and Shotts Airdrie and Shotts 5 2 2
6 Aldershot Aldershot 6 3 3
7 Aldridge-Brownhills Aldridge-Brownhills 7 3 3
8 Altrincham and Sale West Altrincham and Sale West 8 3 3
9 Alyn and Deeside Alyn and Deeside 9 1 1
10 Amber Valley Amber Valley 10 3 3
11 Angus Angus 11 2 2
12 Arfon Arfon 12 1 1
13 Argyll and Bute Argyll and Bute 13 2 2
14 Arundel and South Downs Arundel and South Downs 14 3 3
15 Ashfield Ashfield 15 3 3
16 Ashford Ashford 16 3 3
17 Ashton-Under-Lyne Ashton-Under-Lyne 17 3 3
18 Aylesbury Aylesbury 18 3 3
19 Ayr, Carrick and Cumnock Ayr, Carrick and Cumnock 19 2 2
20 Banbury Banbury 20 3 3
21 Banff and Buchan Banff and Buchan 21 2 2
22 Barking Barking 22 3 3
23 Barnsley Central Barnsley Central 23 3 3
24 Barnsley East Barnsley East 24 3 3
25 Barrow and Furness Barrow and Furness 25 3 3
26 Basildon and Billericay Basildon and Billericay 26 3 3
27 Basingstoke Basingstoke 27 3 3
28 Bassetlaw Bassetlaw 28 3 3
29 Bath Bath 29 3 3
30 Batley and Spen Batley and Spen 30 3 3
31 Battersea Battersea 31 3 3
32 Beaconsfield Beaconsfield 32 3 3
33 Beckenham Beckenham 33 3 3
34 Bedford Bedford 34 3 3
35 Belfast East Belfast East 35 4 4
36 Belfast North Belfast North 36 4 4
37 Belfast South Belfast South 37 4 4
38 Belfast West Belfast West 38 4 4
39 Bermondsey and Old Southwark Bermondsey and Old Southwark 39 3 3
40 Berwickshire, Roxburgh and Selkirk Berwickshire, Roxburgh and Selkirk 40 2 2
41 Berwick-Upon-Tweed Berwick-Upon-Tweed 41 3 3
42 Bethnal Green and Bow Bethnal Green and Bow 42 3 3
43 Beverley and Holderness Beverley and Holderness 43 3 3
44 Bexhill and Battle Bexhill and Battle 44 3 3
45 Bexleyheath and Crayford Bexleyheath and Crayford 45 3 3
46 Birkenhead Birkenhead 46 3 3
47 Birmingham, Edgbaston Birmingham, Edgbaston 47 3 3
48 Birmingham, Erdington Birmingham, Erdington 48 3 3
49 Birmingham, Hall Green Birmingham, Hall Green 49 3 3
50 Birmingham, Hodge Hill Birmingham, Hodge Hill 50 3 3
51 Birmingham, Ladywood Birmingham, Ladywood 51 3 3
52 Birmingham, Northfield Birmingham, Northfield 52 3 3
53 Birmingham, Perry Barr Birmingham, Perry Barr 53 3 3
54 Birmingham, Selly Oak Birmingham, Selly Oak 54 3 3
55 Birmingham, Yardley Birmingham, Yardley 55 3 3
56 Bishop Auckland Bishop Auckland 56 3 3
57 Blackburn Blackburn 57 3 3
58 Blackley and Broughton Blackley and Broughton 58 3 3
59 Blackpool North and Cleveleys Blackpool North and Cleveleys 59 3 3
60 Blackpool South Blackpool South 60 3 3
61 Blaenau Gwent Blaenau Gwent 61 1 1
62 Blaydon Blaydon 62 3 3
63 Blyth Valley Blyth Valley 63 3 3
64 Bognor Regis and Littlehampton Bognor Regis and Littlehampton 64 3 3
65 Bolsover Bolsover 65 3 3
66 Bolton North East Bolton North East 66 3 3
67 Bolton South East Bolton South East 67 3 3
68 Bolton West Bolton West 68 3 3
69 Bootle Bootle 69 3 3
70 Boston and Skegness Boston and Skegness 70 3 3
71 Bosworth Bosworth 71 3 3
72 Bournemouth East Bournemouth East 72 3 3
73 Bournemouth West Bournemouth West 73 3 3
74 Bracknell Bracknell 74 3 3
75 Bradford East Bradford East 75 3 3
76 Bradford South Bradford South 76 3 3
77 Bradford West Bradford West 77 3 3
78 Braintree Braintree 78 3 3
79 Brecon and Radnorshire Brecon and Radnorshire 79 1 1
80 Brent Central Brent Central 80 3 3
81 Brent North Brent North 81 3 3
82 Brentford and Isleworth Brentford and Isleworth 82 3 3
83 Brentwood and Ongar Brentwood and Ongar 83 3 3
84 Bridgend Bridgend 84 1 1
85 Bridgwater and West Somerset Bridgwater and West Somerset 85 3 3
86 Brigg and Goole Brigg and Goole 86 3 3
87 Brighton, Kemptown Brighton, Kemptown 87 3 3
88 Brighton, Pavilion Brighton, Pavilion 88 3 3
89 Bristol East Bristol East 89 3 3
90 Bristol North West Bristol North West 90 3 3
91 Bristol South Bristol South 91 3 3
92 Bristol West Bristol West 92 3 3
93 Broadland Broadland 93 3 3
94 Bromley and Chislehurst Bromley and Chislehurst 94 3 3
95 Bromsgrove Bromsgrove 95 3 3
96 Broxbourne Broxbourne 96 3 3
97 Broxtowe Broxtowe 97 3 3
98 Buckingham Buckingham 98 3 3
99 Burnley Burnley 99 3 3
100 Burton Burton 100 3 3

Next page

Advanced export

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

CSV options: 

CREATE TABLE "constituency_groups" (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [constituency_area_id] INTEGER REFERENCES [constituency_areas]([id]),
   [constituency_group_set_id] INTEGER REFERENCES [constituency_group_sets]([id])
);
CREATE INDEX [idx_constituency_groups_constituency_group_set_id]
    ON [constituency_groups] ([constituency_group_set_id]);
CREATE INDEX [idx_constituency_groups_constituency_area_id]
    ON [constituency_groups] ([constituency_area_id]);