political_party_registrations

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

4 rows where political_party_id = 309

✎ 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
352 PP12823 2021-09-27     Britain First 309 Great Britain 1
353 PP2214 2014-01-10 2017-11-02   Britain First 309 Great Britain 1
354 PP3913 2015-12-14 2016-07-04   Britain First 309 Northern Ireland 4
355 PP1830 2011-11-17 2013-11-05 2012-09-13 Britain First 309 Great Britain 1

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