political_party_registrations

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

38 rows where country_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start_on, end_on, political_party_name_last_updated_on, 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
9 PP103 1999-02-25   2001-02-02 Alliance 19 Northern Ireland 4
14 PP4041 2016-04-06     Animal Welfare Party 76 Northern Ireland 4
17 PP7968 2019-03-25     Aontú 155 Northern Ireland 4
31 PP105 2011-02-02 2015-11-04   British National Party 40 Northern Ireland 4
42 PP2724 2015-04-07 2016-11-03   Cannabis Is Safer Than Alcohol 29 Northern Ireland 4
53 PP6335 2017-02-01   2019-10-25 Citizens Independent Social Thought Alliance 151 Northern Ireland 4
59 PP376 2004-04-01   2011-09-12 Common Good 131 Northern Ireland 4
73 PP51 2001-02-16   2011-09-12 Conservative 1 Northern Ireland 4
75 PP4037 2016-03-14   2016-03-14 Cross-Community Labour Alternative 280 Northern Ireland 4
81 PP707 2008-03-28 2010-11-02 2011-01-25 Democratic Nationalists 197 Northern Ireland 4
84 PP70 1999-01-14   2001-02-02 Democratic Unionist Party 20 Northern Ireland 4
88 PP668 2007-06-06 2008-11-01 2008-11-05 Direct Democracy (Communist) Party 222 Northern Ireland 4
114 PP12553 2022-02-15     Heritage Party 256 Northern Ireland 4
118 PP835 2010-03-12 2021-04-20   Humanity 64 Northern Ireland 4
126 PP812 2010-02-10 2011-04-21   INDEPENDENT Leave-the-EU Alliance 243 Northern Ireland 4
128 PP4072 2016-04-06     Independent Network 168 Northern Ireland 4
151 PP685 2007-11-21     Libertarian Party 130 Northern Ireland 4
166 PP514 2005-09-07 2014-03-07   Money Reform Party 204 Northern Ireland 4
171 PP118 2001-02-20 2014-11-01   National Front 10 Northern Ireland 4
172 PP2708 2015-04-07 2021-11-10   National Front 10 Northern Ireland 4
176 PP671 2007-06-12 2012-11-30   Nationwide Reform Party 236 Northern Ireland 4
182 PP35 2001-02-16 2004-08-24 2004-08-24 No Candidate Deserves My Vote! 247 Northern Ireland 4
187 PP65 2001-02-16 2007-08-13   Official Monster Raving Loony Party 12 Northern Ireland 4
195 PP773 2009-09-01   2023-12-04 People Before Profit Alliance 25 Northern Ireland 4
222 PP837 2010-03-12     Restoration Party 183 Northern Ireland 4
240 PP39 1999-01-14   2001-02-02 Sinn Féin 21 Northern Ireland 4
241 PP55 1999-01-14   2001-02-02 Social Democratic & Labour Party 22 Northern Ireland 4
255 PP550 2006-03-21 2009-04-03 2009-04-03 Space Navies Party 133 Northern Ireland 4
265 PP602 2006-11-02 2016-11-03   Animal Protection Party 226 Northern Ireland 4
287 PP353 2003-10-23 2010-07-01   The New Party 206 Northern Ireland 4
313 PP127 2001-03-15   2013-05-14 The Workers' Party 23 Northern Ireland 4
319 PP680 2007-10-10     Traditional Unionist Voice 69 Northern Ireland 4
325 PP84 2001-02-16   2016-02-22 UK Independence Party 8 Northern Ireland 4
327 PP9058 2020-06-23     UK Voice 296 Northern Ireland 4
328 PP83 1999-01-14   2001-02-02 Ulster Unionist Party 24 Northern Ireland 4
346 PP629 2007-02-05 2013-05-22   You Party 194 Northern Ireland 4
349 PP305 2003-04-10     Green Party Northern Ireland 267 Northern Ireland 4
354 PP3913 2015-12-14 2016-07-04   Britain First 309 Northern Ireland 4

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]);