home / psephology

general_elections

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

0 rows where parliament_period_id = 23

✎ View and edit SQL

This data as json

0 records

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]);
Powered by Datasette · Queries took 8.868ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website