elections
Data license: Open Parliament Licence · Data source: UK Parliament election results website
8 rows where result_summary_id = 34
This data as json, CSV (advanced)
Suggested facets: polling_on, invalid_vote_count, general_election_id, parliament_period_id, writ_issued_on, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1304 | 2019-12-12 | 0 | 45638 | 131 | 3990 | 2019-12-13T03:34:00 | Aberdeen South 4 | 4 4 | 34 34 | 1303 1303 | 58 58 | 2019-11-05 |
| 1311 | 2019-12-12 | 0 | 43170 | 92 | 3795 | 2019-12-13T01:55:00 | Angus 11 | 4 4 | 34 34 | 1310 1310 | 58 58 | 2019-11-05 |
| 1319 | 2019-12-12 | 0 | 46592 | 138 | 2329 | 2019-12-13T03:52:00 | Ayr, Carrick and Cumnock 19 | 4 4 | 34 34 | 1318 1318 | 58 58 | 2019-11-05 |
| 1498 | 2019-12-12 | 0 | 55357 | 176 | 5426 | 2019-12-13T03:04:00 | East Renfrewshire 198 | 4 4 | 34 34 | 1499 1499 | 58 58 | 2019-11-05 |
| 1547 | 2019-12-12 | 0 | 55916 | 148 | 819 | 2019-12-13T05:14:00 | Gordon 247 | 4 4 | 34 34 | 1546 1546 | 58 58 | 2019-11-05 |
| 1731 | 2019-12-12 | 0 | 57813 | 131 | 4498 | 2019-12-13T02:45:00 | Ochil and South Perthshire 431 | 4 4 | 34 34 | 1730 1730 | 58 58 | 2019-11-05 |
| 1844 | 2019-12-12 | 0 | 52620 | 105 | 9254 | 2019-12-13T03:19:00 | Stirling 544 | 4 4 | 34 34 | 1842 1842 | 58 58 | 2019-11-05 |
| 3254 | 2024-07-04 | 0 | 38188 | 170 | 942 | Aberdeenshire North and Moray East 654 | 6 6 | 34 34 | 3253 3253 | 59 59 | 2024-05-30 |
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]);