general_elections

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

1 row where parliament_period_id = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_on (date)

CREATE TABLE "general_elections" (
   [id] INTEGER PRIMARY KEY,
   [polling_on] TEXT,
   [is_notional] INTEGER,
   [commons_library_briefing_url] TEXT,
   [valid_vote_count] INTEGER,
   [invalid_vote_count] INTEGER,
   [electorate_population_count] INTEGER,
   [parliament_period_id] INTEGER REFERENCES [parliament_periods]([id])
);
CREATE INDEX [idx_general_elections_parliament_period_id]
    ON [general_elections] ([parliament_period_id]);