home / psephology

political_party_registrations

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

363 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_id, start_on (date), end_on (date), political_party_name_last_updated_on (date)

id ▼ electoral_commission_id start_on end_on political_party_name_last_updated_on political_party_id country_id
1 PP790 2009-12-10 2010-07-28 2010-11-16 A Vote Against MP Expense Abuse 186 Great Britain 1
2 PP2802 2015-07-03 2020-11-04 2020-07-23 Abolish the Welsh Assembly Party 271 Great Britain 1
3 PP12653 2021-01-06     Abolish the Welsh Assembly Party 271 Great Britain 1
4 PP6667 2018-01-22 2020-10-01   Advance Together 163 Great Britain 1
5 PP2399 2014-09-12 2017-11-02 2014-12-09 Al-Zebabist Nation of Ooog 109 Great Britain 1
6 PP12700 2021-02-08   2021-08-02 Alba Party 258 Great Britain 1
7 PP2137 2013-08-21 2020-04-17   All People's Party 26 Great Britain 1
8 PP856 2010-03-29 2014-04-23   All The South Party 184 Great Britain 1
9 PP103 1999-02-25   2001-02-02 Alliance 19 Northern Ireland 4
10 PP10288 2020-08-20     Alliance for Democracy and Freedom 268 Great Britain 1
11 PP67 1999-02-25   2001-02-02 Alliance for Green Socialism 84 Great Britain 1
12 PP766 2009-06-23 2015-09-23   Alliance for Workers' Liberty 201 Great Britain 1
13 PP2464 2014-12-08 2016-07-22 2015-12-14 Alter Change - Politics. Only Different. 53 Great Britain 1
14 PP4041 2016-04-06     Animal Welfare Party 76 Northern Ireland 4
15 PP616 2007-01-22   2014-01-28 Animal Welfare Party 76 Great Britain 1
16 PP828 2010-03-10 2012-05-21   Anticapitalists - Workers Power 252 Great Britain 1
17 PP7968 2019-03-25     Aontú 155 Northern Ireland 4
18 PP2719 2015-04-01 2016-01-07   Apni Party 65 Great Britain 1
19 PP845 2010-03-22     Apolitical Democrats 93 Great Britain 1
20 PP3902 2016-07-28     Ashfield Independents 128 Great Britain 1
21 PP764 2009-06-22 2010-11-02 2010-11-02 Best of a Bad Bunch 217 Great Britain 1
22 PP4230 2016-08-11 2017-08-23   Better for Bradford 135 Great Britain 1
23 PP10337 2019-11-06 2020-02-17   Birkenhead Social Justice Party 156 Great Britain 1
24 PP618 2007-01-30 2010-11-18 2011-02-22 Blaenau Gwent People's Voice 193 Great Britain 1
25 PP857 2010-03-29 2013-11-05   Blue Environment Party 208 Great Britain 1
26 PP6342 2017-03-16     Blue Revolution 134 Great Britain 1
27 PP2503 2014-12-15 2017-02-10   Bournemouth Independent Alliance 43 Great Britain 1
28 PP6381 2017-08-17 2018-08-06   Bournemouth Independent Alliance 43 Great Britain 1
29 PP1765 2011-05-23     British Democratic Party 45 Great Britain 1
30 PP2165 2013-11-28 2022-11-11   British Independents 63 Great Britain 1
31 PP105 2011-02-02 2015-11-04   British National Party 40 Northern Ireland 4
32 PP106 1999-02-25 2016-01-08 2001-02-02 British National Party 40 Great Britain 1
33 PP3960 2016-02-10     British National Party 40 Great Britain 1
34 PP2834 2015-08-21   2020-02-12 British Unionist Party B.U.P. 259 Great Britain 1
35 PP869 2010-04-13 2011-09-07   Bromsgrove Independent Conservative 199 Great Britain 1
36 PP6725 2018-02-26 2023-08-30   Burnley and Padiham Independent Party 161 Great Britain 1
37 PP785 2009-11-30 2010-11-02   Bushra Irfan of Blackburn 191 Great Britain 1
38 PP803 2010-01-27 2016-11-03   Cambridge Socialists 202 Great Britain 1
39 PP2566 2015-04-07 2015-06-30   Campaign 78 Great Britain 1
40 PP714 2008-05-16 2010-11-18 2011-02-22 Campaign for Independent Politicians 245 Great Britain 1
41 PP2552 2015-02-27 2016-11-03   Cannabis Is Safer Than Alcohol 29 Great Britain 1
42 PP2724 2015-04-07 2016-11-03   Cannabis Is Safer Than Alcohol 29 Northern Ireland 4
43 PP2883 2016-02-18   2017-05-04 Chesterfield And North Derbyshire Independents (CANDI) 274 Great Britain 1
44 PP2567 2015-02-27   2017-09-13 Children of the Atom 106 Great Britain 1
45 PP839 2010-03-15 2017-11-02   Christian Movement for Great Britain 59 Great Britain 1
46 PP392 2004-04-29 2012-07-26   Christian Party, Proclaiming Christ's Lordship 34 Great Britain 1
47 PP2893 2015-12-15   2019-06-24 Christian Party, Proclaiming Christ's Lordship 34 Great Britain 1
48 PP1992 2013-01-29 2015-11-04   Christian Party, Proclaiming Christ's Lordship 34 Great Britain 1
49 PP79 1999-03-24   2001-02-02 Christian Peoples Alliance 54 Great Britain 1
50 PP171 2001-05-15 2008-12-16 2008-12-16 Church of the Militant Elvis Party 146 Great Britain 1
51 PP843 2010-03-17 2023-11-09   Church of the Militant Elvis Party 146 Great Britain 1
52 PP873 2010-04-14 2011-02-22 2011-02-22 Citizens for Undead Rights and Equality 198 Great Britain 1
53 PP6335 2017-02-01   2019-10-25 Citizens Independent Social Thought Alliance 151 Northern Ireland 4
54 PP396 2004-06-16     City Independents 248 Great Britain 1
55 PP2269 2014-02-25 2015-07-06   Class War 58 Great Britain 1
56 PP488 2005-04-12 2017-09-28 2015-04-01 Clause 28, Children's Protection Christian Democrats 254 Great Britain 1
57 PP12958 2022-03-22     Climate Party 263 Great Britain 1
58 PP375 2004-04-01   2011-09-12 Common Good 131 Great Britain 1
59 PP376 2004-04-01   2011-09-12 Common Good 131 Northern Ireland 4
60 PP2730 2015-04-07     Common Sense Party 111 Great Britain 1
61 PP351 2003-10-23 2013-11-05   Common Sense Party 111 Great Britain 1
62 PP17412 2024-02-02   2024-02-02 Communist Future 286 Great Britain 1
63 PP823 2010-03-03 2020-11-06   Communist League Election Campaign 77 Great Britain 1
64 PP12791 2023-07-12     Communist League Election Campaign 77 Great Britain 1
65 PP78 1999-02-25   2001-02-02 Communist Party of Britain 36 Great Britain 1
66 PP844 2010-03-17     Communities United Party 30 Great Britain 1
67 PP4089 2016-05-19 2017-08-31 2017-03-20 Compass Party 152 Great Britain 1
68 PP3983 2016-02-18 2019-11-04   Concordia 137 Great Britain 1
69 PP12939 2022-03-03   2022-03-03 Confelicity 297 Great Britain 1
70 PP2626 2015-03-25 2016-12-29   Consensus 92 Great Britain 1
71 PP14170 2023-06-08   2023-06-08 Consensus 92 Great Britain 1
72 PP52 1999-01-14   2016-03-15 Conservative 1 Great Britain 1
73 PP51 2001-02-16   2011-09-12 Conservative 1 Northern Ireland 4
74 PP12685 2021-03-18     Count Binface Party 292 Great Britain 1
75 PP4037 2016-03-14   2016-03-14 Cross-Community Labour Alternative 280 Northern Ireland 4
76 PP7918 2019-01-14     Cumbria First 173 Great Britain 1
77 PP861 2010-04-13 2012-12-05   Cut The Deficit 200 Great Britain 1
78 PP14064 2022-06-07   2022-06-07 Democracy for Chorley 275 Great Britain 1
79 PP41 1999-02-25 2011-07-05 2001-02-02 Democratic Labour Party 253 Great Britain 1
80 PP706 2008-03-28 2012-12-11 2011-01-25 Democratic Nationalists 197 Great Britain 1
81 PP707 2008-03-28 2010-11-02 2011-01-25 Democratic Nationalists 197 Northern Ireland 4
82 PP775 2009-10-01 2013-11-05 2009-10-15 Democratic Reform Party 87 Great Britain 1
83 PP2216 2014-02-20 2016-11-03   Democratic Reform Party 87 Great Britain 1
84 PP70 1999-01-14   2001-02-02 Democratic Unionist Party 20 Northern Ireland 4
85 PP6318 2017-01-30 2020-09-28 2017-10-12 Demos Direct Initiative Party 147 Great Britain 1
86 PP2728 2015-04-07 2016-02-09   Digital Democracy 83 Great Britain 1
87 PP667 2007-06-06   2008-11-03 Direct Democracy (Communist) Party 222 Great Britain 1
88 PP668 2007-06-06 2008-11-01 2008-11-05 Direct Democracy (Communist) Party 222 Northern Ireland 4
89 PP12881 2021-11-16     English Constitution Party 272 Great Britain 1
90 PP17 1999-11-15   2014-03-18 English Democrats 15 Great Britain 1
91 PP5 2000-04-18 2015-05-19 2001-02-02 English Independence Party 181 Great Britain 1
92 PP526 2006-02-22 2020-11-06   Equal Parenting Alliance 239 Great Britain 1
93 PP2309 2014-04-01 2015-11-04   Europeans Party 66 Great Britain 1
94 PP3903 2016-02-18 2021-04-12   Europeans Party 66 Great Britain 1
95 PP17415 2023-12-13   2023-12-13 Fairer Voting Party 281 Great Britain 1
96 PP188 2001-05-17 2017-11-02   Fancy Dress Party 213 Great Britain 1
97 PP89 2000-05-09   2001-02-02 Fight For an Anti-War Government 244 Great Britain 1
98 PP866 2010-04-13 2015-07-28   Free Public Transport Party 115 Great Britain 1
99 PP12667 2021-03-16 2023-11-09 2023-01-13 Freedom Alliance 269 Great Britain 1
100 PP17509 2024-02-29     Freedom Alliance 269 Great Britain 1

Next page

Advanced export

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

CSV options:

CREATE TABLE "political_party_registrations" (
   [id] INTEGER PRIMARY KEY,
   [electoral_commission_id] TEXT,
   [start_on] TEXT,
   [end_on] TEXT,
   [political_party_name_last_updated_on] TEXT,
   [political_party_id] INTEGER REFERENCES [political_parties]([id]),
   [country_id] INTEGER REFERENCES [countries]([id])
);
CREATE INDEX [idx_political_party_registrations_country_id]
    ON [political_party_registrations] ([country_id]);
CREATE INDEX [idx_political_party_registrations_political_party_id]
    ON [political_party_registrations] ([political_party_id]);
Powered by Datasette · Queries took 15.67ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website