elections
Data license: Open Parliament Licence · Data source: UK Parliament election results website
4 rows where constituency_group_id = 25
This data as json, CSV (advanced)
Suggested facets: result_summary_id, polling_on (date), declaration_at (date), writ_issued_on (date)
| id ▼ | polling_on | is_notional | valid_vote_count | invalid_vote_count | majority | declaration_at | constituency_group_id | general_election_id | result_summary_id | electorate_id | parliament_period_id | writ_issued_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | 2015-05-07 | 0 | 43275 | 159 | 795 | 2015-05-08T06:53:00 | Barrow and Furness 25 | 2 2 | 1 1 | 25 25 | 56 56 | 2015-03-30 |
| 675 | 2017-06-08 | 0 | 47590 | 60 | 209 | 2017-06-09T04:42:00 | Barrow and Furness 25 | 3 3 | 1 1 | 675 675 | 57 57 | 2017-05-03 |
| 1325 | 2019-12-12 | 0 | 46046 | 92 | 5789 | 2019-12-13T03:20:00 | Barrow and Furness 25 | 4 4 | 21 21 | 1324 1324 | 58 58 | 2019-11-05 |
| 2625 | 2010-05-06 | 0 | 44124 | 86 | 5208 | 2010-05-07T04:15:00 | Barrow and Furness 25 | 1 1 | 1 1 | 2624 2624 | 55 55 | 2010-04-12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "elections" (
[id] INTEGER PRIMARY KEY,
[polling_on] TEXT,
[is_notional] INTEGER,
[valid_vote_count] INTEGER,
[invalid_vote_count] INTEGER,
[majority] INTEGER,
[declaration_at] TEXT,
[constituency_group_id] INTEGER REFERENCES [constituency_groups]([id]),
[general_election_id] INTEGER REFERENCES [general_elections]([id]),
[result_summary_id] INTEGER REFERENCES [result_summaries]([id]),
[electorate_id] INTEGER REFERENCES [electorates]([id]),
[parliament_period_id] INTEGER REFERENCES [parliament_periods]([id]),
[writ_issued_on] TEXT
);
CREATE INDEX [idx_elections_parliament_period_id]
ON [elections] ([parliament_period_id]);
CREATE INDEX [idx_elections_electorate_id]
ON [elections] ([electorate_id]);
CREATE INDEX [idx_elections_result_summary_id]
ON [elections] ([result_summary_id]);
CREATE INDEX [idx_elections_general_election_id]
ON [elections] ([general_election_id]);
CREATE INDEX [idx_elections_constituency_group_id]
ON [elections] ([constituency_group_id]);