boundary_set_legislation_items

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

83 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ boundary_set_id legislation_item_id
1 1 1 Parliamentary Constituencies Order 2023 9
2 2 2 Parliamentary Constituencies Order 2023 9
3 3 3 Parliamentary Constituencies Order 2023 9
4 4 4 Parliamentary Constituencies Order 2023 9
5 5 5 Parliamentary Constituencies (Northern Ireland) Order 2008 10
6 6 6 Parliamentary Constituencies (England) Order 2007 11
7 7 7 Parliamentary Constituencies and Assembly Electoral Regions (Wales) Order 2006 12
8 8 8 Parliamentary Constituencies (Scotland) Order 2005 13
9 9 9 Parliamentary Constituencies (Northern Ireland) Order 1995 14
10 10 10 Parliamentary Constituencies (England) Order 1995 15
11 11 11 Parliamentary Constituencies (Scotland) Order 1995 16
12 12 12 Parliamentary Constituencies (Wales) Order 1995 17
13 13 13 Parliamentary Constituencies (England) (Miscellaneous Changes) Order 1990 18
14 14 14 Parliamentary Constituencies (Scotland) Order 1983 19
15 15 15 Parliamentary Constituencies (Wales) Order 1983 20
16 16 16 Parliamentary Constituencies (England) Order 1983 21
17 17 17 Parliamentary Constituencies (Northern Ireland) Order 1982 22
18 18 18 Parliamentary Constituencies (Scotland) Order 1970 23
19 19 19 Parliamentary Constituencies (Northern Ireland) Order 1970 24
20 20 20 Parliamentary Constituencies (Wales) Order 1970 25
21 21 21 Parliamentary Constituencies (England) Order 1970 26
22 22 22 Parliamentary Constituencies (Newport and Monmouth) Order 1955 27
23 22 22 Parliamentary Constituencies (Swansea) Order 1955 28
24 22 22 Parliamentary Constituencies (Carmarthenshire) Order 1955 29
25 23 23 Parliamentary Constituencies (Sheffield) Order 1955 30
26 23 23 Parliamentary Constituencies (Leeds) Order 1955 31
27 23 23 Parliamentary Constituencies (Wakefield and Hemsworth) Order 1955 32
28 23 23 Parliamentary Constituencies (Bradford, Brighouse and Spenborough and Dewsbury) Order 1955 33
29 23 23 Parliamentary Constituencies (Huddersfield, Colne Valley and Penistone) Order 1955 34
30 23 23 Parliamentary Constituencies (Yorkshire, East Riding) Order 1955 35
31 23 23 Parliamentary Constituencies (Birmingham and North Warwickshire) Order 1955 36
32 23 23 Parliamentary Constituencies (Sussex) Order 1955 37
33 23 23 Parliamentary Constituencies (Kingston upon Thames, Surbiton and Wimbledon) Order 1955 38
34 23 23 Parliamentary Constituencies (Croydon) Order 1955 39
35 23 23 Parliamentary Constituencies (Wolverhampton) Order 1955 40
36 23 23 Parliamentary Constituencies (Stoke on Trent) Order 1955 41
37 23 23 Parliamentary Constituencies (Dudley and South Staffordshire) Order 1955 42
38 23 23 Parliamentary Constituencies (South-East Staffordshire) Order 1955 43
39 23 23 Parliamentary Constituencies (Nottinghamshire) Order 1955 44
40 23 23 Parliamentary Constituencies (Newcastle upon Tyne) Order 1955 45
41 23 23 Parliamentary Constituencies (Harrow) Order 1955 46
42 23 23 Parliamentary Constituencies (Spelthorne, Feltham and Heston and Isleworth) Order 1955 47
43 23 23 Parliamentary Constituencies (Woolwich) Order 1955 48
44 24 24 Parliamentary Constituencies (Scotland) (Glasgow Springburn, Glasgow Central and Glasgow Kelvingrove) Order 1955 49
45 24 24 Parliamentary Constituencies (Scotland) (Midlothian, Roxburgh, Selkirk and Peebles, and Edinburgh East) Order 1955 50
46 24 24 Parliamentary Constituencies (Scotland) (Bute and North Ayrshire and Central Ayrshire) Order 1955 51
47 24 24 Parliamentary Constituencies (Scotland) (Edinburgh North and Edinburgh West) Order 1955 52
48 24 24 Parliamentary Constituencies (Scotland) (East Aberdeenshire, West Aberdeenshire, Aberdeen North and Aberdeen South) Order 1955 53
49 24 24 Parliamentary Constituencies (Scotland) (Glasgow Pollok, Glasgow Craigton, Glasgow Govan and Glasgow Gorbals) Order 1955 54
50 24 24 Parliamentary Constituencies (Scotland) (Glasgow Scotstoun, Glasgow Hillhead and Glasgow Woodside) Order 1955 55
51 24 24 Parliamentary Constituencies (Scotland) (Edinburgh Central and Edinburgh Pentlands) Order 1955 56
52 24 24 Parliamentary Constituencies (Scotland) (Glasgow Bridgeton, Glasgow Provan and Glasgow Shettleston) Order 1955 57
53 24 24 Parliamentary Constituencies (Scotland) (West Stirlingshire and Stirling and Falkirk Burghs) Order 1955 58
54 23 23 Parliamentary Constituencies (Fulham and Hammersmith) Order 1955 59
55 23 23 Parliamentary Constituencies (Bethnal Green, Hackney and Stoke Newington) Order 1955 60
56 23 23 Parliamentary Constituencies (Harborough and Leicester South East) Order 1955 61
57 23 23 Parliamentary Constituencies (Bosworth and Loughborough) Order 1955 62
58 23 23 Parliamentary Constituencies (Warrington and Newton) Order 1955 63
59 23 23 Parliamentary Constituencies (Manchester, Oldham and Ashton under Lyne) Order 1955 64
60 23 23 Parliamentary Constituencies (Liverpool and South-West Lancashire) Order 1955 65
61 23 23 Parliamentary Constituencies (Blackburn, Chorley and Darwen) Order 1955 66
62 23 23 Parliamentary Constituencies (North Kent) Order 1955 67
63 23 23 Parliamentary Constituencies (Hertfordshire) Order 1955 68
64 23 23 Parliamentary Constituencies (Hampshire) Order 1955 69
65 23 23 Parliamentary Constituencies (Gloucestershire) Order 1955 70
66 23 23 Parliamentary Constituencies (Chelmsford, Chigwell and Woodford) Order 1955 71
67 23 23 Parliamentary Constituencies (Billericay, South East Essex, Romford and Southend) Order 1955 72
68 23 23 Parliamentary Constituencies (Gateshead and Jarrow) Order 1955 73
69 23 23 Parliamentary Constituencies (Plymouth) Order 1955 74
70 23 23 Parliamentary Constituencies (Derby and South East Derbyshire) Order 1955 75
71 23 23 Parliamentary Constituencies (Crewe, Knutsford, Nantwich and Northwich) Order 1955 76
72 23 23 Parliamentary Constituencies (Reading, Newbury and Wokingham) Order 1955 77
73 23 23 Parliamentary Constituencies (Bedford and Mid-Bedfordshire) Order 1955 78
74 25 25 House of Commons (Redistribution of Seats) Order 1945 79
75 26 26 Representation of the People Act 1948 4
76 27 27 Representation of the People Act 1948 4
77 28 28 Representation of the People Act 1948 4
78 29 29 Representation of the People Act 1948 4
79 30 30 Government of Ireland Act 1920 6
80 31 31 Redistribution of Seats (Ireland) Act 1918 7
81 32 32 Representation of the People Act 1918 8
82 33 33 Representation of the People Act 1918 8
83 34 34 Representation of the People Act 1918 8

Advanced export

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

CSV options: 

CREATE TABLE "boundary_set_legislation_items" (
   [id] INTEGER PRIMARY KEY,
   [boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]),
   [legislation_item_id] INTEGER REFERENCES [legislation_items]([id])
);
CREATE INDEX [idx_boundary_set_legislation_items_legislation_item_id]
    ON [boundary_set_legislation_items] ([legislation_item_id]);
CREATE INDEX [idx_boundary_set_legislation_items_boundary_set_id]
    ON [boundary_set_legislation_items] ([boundary_set_id]);