elections
Data license: Open Parliament Licence · Data source: Original Data Source
10 rows where result_summary_id = 25
This data as json, CSV (advanced)
Suggested facets: polling_on, invalid_vote_count, constituency_group_id, general_election_id, parliament_period_id, polling_on (date), declaration_at (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 |
---|---|---|---|---|---|---|---|---|---|---|---|
679 | 2017-06-08 | 0 | 49583 | 112 | 5694 | 2017-06-09T03:15:00 | Bath 29 | 3 3 | 25 25 | 679 679 | 57 57 |
852 | 2017-06-08 | 0 | 57420 | 91 | 1609 | 2017-06-09T03:29:00 | Eastbourne 202 | 3 3 | 25 25 | 851 851 | 57 57 |
960 | 2017-06-08 | 0 | 62178 | 87 | 4124 | 2017-06-09T03:36:00 | Kingston and Surbiton 310 | 3 3 | 25 25 | 959 959 | 57 57 |
1089 | 2017-06-08 | 0 | 60020 | 114 | 816 | 2017-06-09T05:02:00 | Oxford West and Abingdon 439 | 3 3 | 25 25 | 1088 1088 | 57 57 |
1235 | 2017-06-08 | 0 | 66290 | 143 | 9762 | 2017-06-09T02:54:00 | Twickenham 585 | 3 3 | 25 25 | 1234 1234 | 57 57 |
1767 | 2019-12-12 | 0 | 65067 | 173 | 7766 | 2019-12-13T03:14:00 | Richmond Park 467 | 4 4 | 25 25 | 1765 1765 | 58 58 |
1835 | 2019-12-12 | 0 | 57599 | 173 | 6293 | 2019-12-13T03:51:00 | St Albans 535 | 4 4 | 25 25 | 1836 1836 | 58 58 |
2802 | 2010-05-06 | 0 | 52124 | 73 | 3435 | 2010-05-07T02:41:00 | Eastbourne 202 | 1 1 | 25 25 | 2801 2801 | 55 55 |
3104 | 2010-05-06 | 0 | 55129 | 101 | 175 | 2010-05-07T07:16:00 | Solihull 504 | 1 1 | 25 25 | 3103 3103 | 55 55 |
3209 | 2010-05-06 | 0 | 55864 | 99 | 800 | 2010-05-07T06:45:00 | Wells 609 | 1 1 | 25 25 | 3208 3208 | 55 55 |
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]) ); 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]);