home / psephology

enablings

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

73 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: enabling_legislation_id

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

Advanced export

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

CSV options:

CREATE TABLE "enablings" (
   [id] INTEGER PRIMARY KEY,
   [enabling_legislation_id] INTEGER REFERENCES [legislation_items]([id]),
   [enabled_legislation_id] INTEGER REFERENCES [legislation_items]([id])
);
CREATE INDEX [idx_enablings_enabled_legislation_id]
    ON [enablings] ([enabled_legislation_id]);
CREATE INDEX [idx_enablings_enabling_legislation_id]
    ON [enablings] ([enabling_legislation_id]);
Powered by Datasette · Queries took 5.14ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website