electorates

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

3,930 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ population_count constituency_group_id
1 49821 Aberavon 1
2 45525 Aberconwy 2
3 67745 Aberdeen North 3
4 68056 Aberdeen South 4
5 66792 Airdrie and Shotts 5
6 72430 Aldershot 6
7 60215 Aldridge-Brownhills 7
8 71511 Altrincham and Sale West 8
9 62016 Alyn and Deeside 9
10 69510 Amber Valley 10
11 65792 Angus 11
12 40492 Arfon 12
13 68875 Argyll and Bute 13
14 77242 Arundel and South Downs 14
15 77091 Ashfield 15
16 85177 Ashford 16
17 68343 Ashton-under-Lyne 17
18 80315 Aylesbury 18
19 72995 Ayr, Carrick and Cumnock 19
20 86420 Banbury 20
21 68609 Banff and Buchan 21
22 73977 Barking 22
23 64534 Barnsley Central 23
24 69135 Barnsley East 24
25 68338 Barrow and Furness 25
26 66347 Basildon and Billericay 26
27 79665 Basingstoke 27
28 76796 Bassetlaw 28
29 63084 Bath 29
30 78373 Batley and Spen 30
31 76111 Battersea 31
32 74726 Beaconsfield 32
33 67439 Beckenham 33
34 69311 Bedford 34
35 63157 Belfast East 35
36 68553 Belfast North 36
37 64927 Belfast South 37
38 62697 Belfast West 38
39 83298 Bermondsey and Old Southwark 39
40 74214 Berwickshire, Roxburgh and Selkirk 40
41 56969 Berwick-upon-Tweed 41
42 82727 Bethnal Green and Bow 42
43 80805 Beverley and Holderness 43
44 78796 Bexhill and Battle 44
45 64828 Bexleyheath and Crayford 45
46 62410 Birkenhead 46
47 65591 Birmingham, Edgbaston 47
48 65128 Birmingham, Erdington 48
49 76330 Birmingham, Hall Green 49
50 75302 Birmingham, Hodge Hill 50
51 68128 Birmingham, Ladywood 51
52 71428 Birmingham, Northfield 52
53 69943 Birmingham, Perry Barr 53
54 75092 Birmingham, Selly Oak 54
55 72146 Birmingham, Yardley 55
56 66070 Bishop Auckland 56
57 73260 Blackburn 57
58 71913 Blackley and Broughton 58
59 62468 Blackpool North and Cleveleys 59
60 57411 Blackpool South 60
61 51335 Blaenau Gwent 61
62 67901 Blaydon 62
63 61247 Blyth Valley 63
64 72995 Bognor Regis and Littlehampton 64
65 71979 Bolsover 65
66 67895 Bolton North East 66
67 69687 Bolton South East 67
68 72719 Bolton West 68
69 70145 Bootle 69
70 67064 Boston and Skegness 70
71 79738 Bosworth 71
72 72275 Bournemouth East 72
73 72082 Bournemouth West 73
74 81271 Bracknell 74
75 66121 Bradford East 75
76 63674 Bradford South 76
77 63372 Bradford West 77
78 73557 Braintree 78
79 54441 Brecon and Radnorshire 79
80 77038 Brent Central 80
81 82196 Brent North 81
82 84602 Brentford and Isleworth 82
83 71918 Brentwood and Ongar 83
84 59998 Bridgend 84
85 80491 Bridgwater and West Somerset 85
86 68488 Brigg and Goole 86
87 67858 Brighton, Kemptown 87
88 76557 Brighton, Pavilion 88
89 71193 Bristol East 89
90 74743 Bristol North West 90
91 81496 Bristol South 91
92 91236 Bristol West 92
93 73552 Broadland 93
94 65477 Bromley and Chislehurst 94
95 73337 Bromsgrove 95
96 72944 Broxbourne 96
97 71764 Broxtowe 97
98 77425 Buckingham 98
99 64477 Burnley 99
100 75248 Burton 100

Next page

Advanced export

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

CSV options: 

CREATE TABLE "electorates" (
   [id] INTEGER PRIMARY KEY,
   [population_count] INTEGER,
   [constituency_group_id] INTEGER REFERENCES [constituency_groups]([id])
);
CREATE INDEX [idx_electorates_constituency_group_id]
    ON [electorates] ([constituency_group_id]);