general_elections

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

1 row where parliament_period_id = 59

✎ 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
6 2024-07-04 0 https://commonslibrary.parliament.uk/research-briefings/cbp-10009/ 28809340 116253 48253193 59 59

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