political_party_registrations

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

0 rows where country_id = 5

✎ View and edit SQL

This data as json

0 records

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