general_elections

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

2 rows where parliament_period_id = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_on (date)

id ▼ polling_on is_notional commons_library_briefing_url valid_vote_count invalid_vote_count electorate_population_count parliament_period_id
4 2019-12-12 0 https://commonslibrary.parliament.uk/research-briefings/cbp-8749/ 32014110 117919 47562702 58 58
5 2019-12-12 1   32014119 0 47558398 58 58

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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