elections
Data license: Open Parliament Licence · Data source: UK Parliament election results website
12 rows where result_summary_id = 24
This data as json, CSV (advanced)
Suggested facets: declaration_at, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 654 | 2017-06-08 | 0 | 44493 | 63 | 4752 | 2017-06-09T03:08:00 | Aberdeen South 4 | 3 3 | 24 24 | 654 654 | 57 57 | 2017-05-03 |
| 661 | 2017-06-08 | 0 | 40192 | 65 | 2645 | 2017-06-09T01:52:00 | Angus 11 | 3 3 | 24 24 | 661 661 | 57 57 | 2017-05-03 |
| 669 | 2017-06-08 | 0 | 46222 | 74 | 2774 | 2017-06-09T03:08:00 | Ayr, Carrick and Cumnock 19 | 3 3 | 24 24 | 669 669 | 57 57 | 2017-05-03 |
| 671 | 2017-06-08 | 0 | 41643 | 46 | 3693 | 2017-06-09T04:38:00 | Banff and Buchan 21 | 3 3 | 24 24 | 671 671 | 57 57 | 2017-05-03 |
| 690 | 2017-06-08 | 0 | 52367 | 96 | 11060 | 2017-06-09T03:59:00 | Berwickshire, Roxburgh and Selkirk 40 | 3 3 | 24 24 | 690 690 | 57 57 | 2017-05-03 |
| 830 | 2017-06-08 | 0 | 51599 | 45 | 5643 | 2017-06-09T05:36:00 | Dumfries and Galloway 180 | 3 3 | 24 24 | 829 829 | 57 57 | 2017-05-03 |
| 848 | 2017-06-08 | 0 | 53738 | 67 | 4712 | 2017-06-09T02:41:00 | East Renfrewshire 198 | 3 3 | 24 24 | 847 847 | 57 57 | 2017-05-03 |
| 897 | 2017-06-08 | 0 | 53685 | 55 | 2607 | 2017-06-09T04:21:00 | Gordon 247 | 3 3 | 24 24 | 896 896 | 57 57 | 2017-05-03 |
| 1026 | 2017-06-08 | 0 | 47605 | 62 | 4159 | 2017-06-09T02:18:00 | Moray 376 | 3 3 | 24 24 | 1025 1025 | 57 57 | 2017-05-03 |
| 1081 | 2017-06-08 | 0 | 54168 | 77 | 3359 | 2017-06-09T02:24:00 | Ochil and South Perthshire 431 | 3 3 | 24 24 | 1080 1080 | 57 57 | 2017-05-03 |
| 1194 | 2017-06-08 | 0 | 49356 | 72 | 148 | 2017-06-09T04:00:00 | Stirling 544 | 3 3 | 24 24 | 1193 1193 | 57 57 | 2017-05-03 |
| 1262 | 2017-06-08 | 0 | 51625 | 49 | 7950 | 2017-06-09T03:59:00 | West Aberdeenshire and Kincardine 612 | 3 3 | 24 24 | 1261 1261 | 57 57 | 2017-05-03 |
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]);