elections
Data license: Open Parliament Licence · Data source: Original Data Source
39 rows where result_summary_id = 14
This data as json, CSV (advanced)
Suggested facets: polling_on, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
82 | 2015-05-07 | 0 | 57355 | 147 | 465 | 2015-05-08T04:57:00 | Brentford and Isleworth 82 | 2 2 | 14 14 | 82 82 | 56 56 |
140 | 2015-05-07 | 0 | 51161 | 228 | 93 | 2015-05-08T07:15:00 | City Of Chester 140 | 2 2 | 14 14 | 140 140 | 56 56 |
172 | 2015-05-07 | 0 | 53630 | 238 | 1451 | 2015-05-08T07:24:00 | Dewsbury 172 | 2 2 | 14 14 | 172 172 | 56 56 |
186 | 2015-05-07 | 0 | 50894 | 165 | 274 | 2015-05-08T02:57:00 | Ealing Central and Acton 186 | 2 2 | 14 14 | 186 186 | 56 56 |
214 | 2015-05-07 | 0 | 46137 | 117 | 1086 | 2015-05-08T04:46:00 | Enfield North 214 | 2 2 | 14 14 | 214 214 | 56 56 |
291 | 2015-05-07 | 0 | 52214 | 234 | 1236 | 2015-05-08T07:20:00 | Hove 291 | 2 2 | 14 14 | 291 291 | 56 56 |
295 | 2015-05-07 | 0 | 48932 | 105 | 589 | 2015-05-08T03:53:00 | Ilford North 295 | 2 2 | 14 14 | 295 295 | 56 56 |
319 | 2015-05-07 | 0 | 41738 | 172 | 1265 | 2015-05-08T08:09:00 | Lancaster and Fleetwood 319 | 2 2 | 14 14 | 319 319 | 56 56 |
630 | 2015-05-07 | 0 | 41858 | 150 | 417 | 2015-05-08T05:00:00 | Wirral West 630 | 2 2 | 14 14 | 630 630 | 56 56 |
637 | 2015-05-07 | 0 | 40209 | 139 | 801 | 2015-05-08T05:39:00 | Wolverhampton South West 637 | 2 2 | 14 14 | 637 637 | 56 56 |
681 | 2017-06-08 | 0 | 55058 | 112 | 2416 | 2017-06-09T02:02:00 | Battersea 31 | 3 3 | 14 14 | 681 681 | 57 57 |
684 | 2017-06-08 | 0 | 48480 | 176 | 789 | 2017-06-09T03:14:00 | Bedford 34 | 3 3 | 14 14 | 684 684 | 57 57 |
737 | 2017-06-08 | 0 | 49207 | 154 | 9868 | 2017-06-09T04:42:00 | Brighton, Kemptown 87 | 3 3 | 14 14 | 737 737 | 57 57 |
740 | 2017-06-08 | 0 | 54096 | 132 | 4761 | 2017-06-09T02:55:00 | Bristol North West 90 | 3 3 | 14 14 | 740 740 | 57 57 |
751 | 2017-06-08 | 0 | 47903 | 156 | 4375 | 2017-06-09T02:11:00 | Bury North 101 | 3 3 | 14 14 | 101 101 | 57 57 |
761 | 2017-06-08 | 0 | 56800 | 178 | 187 | 2017-06-09T03:29:00 | Canterbury 111 | 3 3 | 14 14 | 760 760 | 57 57 |
763 | 2017-06-08 | 0 | 52022 | 98 | 4174 | 2017-06-09T03:09:00 | Cardiff North 113 | 3 3 | 14 14 | 762 762 | 57 57 |
798 | 2017-06-08 | 0 | 60420 | 158 | 915 | 2017-06-09T04:26:00 | Colne Valley 148 | 3 3 | 14 14 | 797 797 | 57 57 |
806 | 2017-06-08 | 0 | 55027 | 101 | 48 | 2017-06-09T06:26:00 | Crewe and Nantwich 156 | 3 3 | 14 14 | 805 805 | 57 57 |
807 | 2017-06-08 | 0 | 57091 | 109 | 5652 | 2017-06-09T04:01:00 | Croydon Central 157 | 3 3 | 14 14 | 806 806 | 57 57 |
818 | 2017-06-08 | 0 | 48672 | 109 | 2015 | 2017-06-09T03:38:00 | Derby North 168 | 3 3 | 14 14 | 817 817 | 57 57 |
865 | 2017-06-08 | 0 | 48328 | 158 | 4355 | 2017-06-09T04:52:00 | Enfield, Southgate 215 | 3 3 | 14 14 | 864 864 | 57 57 |
899 | 2017-06-08 | 0 | 45576 | 53 | 3269 | 2017-06-09T02:46:00 | Gower 249 | 3 3 | 14 14 | 898 898 | 57 57 |
934 | 2017-06-08 | 0 | 53853 | 160 | 2322 | 2017-06-09T02:43:00 | High Peak 284 | 3 3 | 14 14 | 933 933 | 57 57 |
949 | 2017-06-08 | 0 | 51137 | 100 | 831 | 2017-06-09T02:59:00 | Ipswich 299 | 3 3 | 14 14 | 948 948 | 57 57 |
955 | 2017-06-08 | 0 | 51714 | 91 | 239 | 2017-06-09T04:53:00 | Keighley 305 | 3 3 | 14 14 | 954 954 | 57 57 |
957 | 2017-06-08 | 0 | 38677 | 118 | 20 | 2017-06-09T21:03:00 | Kensington 307 | 3 3 | 14 14 | 956 956 | 57 57 |
985 | 2017-06-08 | 0 | 48718 | 79 | 1538 | 2017-06-09T04:03:00 | Lincoln 335 | 3 3 | 14 14 | 984 984 | 57 57 |
1096 | 2017-06-08 | 0 | 47738 | 145 | 607 | 2017-06-09T03:13:00 | Peterborough 446 | 3 3 | 14 14 | 1095 1095 | 57 57 |
1098 | 2017-06-08 | 0 | 51208 | 83 | 6807 | 2017-06-09T04:23:00 | Plymouth, Sutton and Devonport 448 | 3 3 | 14 14 | 1097 1097 | 57 57 |
1103 | 2017-06-08 | 0 | 44566 | 94 | 1554 | 2017-06-09T03:25:00 | Portsmouth South 453 | 3 3 | 14 14 | 1102 1102 | 57 57 |
1109 | 2017-06-08 | 0 | 55238 | 132 | 3749 | 2017-06-09T04:14:00 | Reading East 459 | 3 3 | 14 14 | 1108 1108 | 57 57 |
1197 | 2017-06-08 | 0 | 53824 | 82 | 888 | 2017-06-09T02:02:00 | Stockton South 547 | 3 3 | 14 14 | 1196 1196 | 57 57 |
1207 | 2017-06-08 | 0 | 63816 | 97 | 687 | 2017-06-09T02:52:00 | Stroud 557 | 3 3 | 14 14 | 1206 1206 | 57 57 |
1239 | 2017-06-08 | 0 | 38684 | 91 | 2379 | 2017-06-09T01:40:00 | Vale Of Clwyd 589 | 3 3 | 14 14 | 1238 1238 | 57 57 |
1251 | 2017-06-08 | 0 | 61995 | 120 | 2549 | 2017-06-09T04:03:00 | Warrington South 601 | 3 3 | 14 14 | 1250 1250 | 57 57 |
1252 | 2017-06-08 | 0 | 54055 | 125 | 1206 | 2017-06-09T03:32:00 | Warwick and Leamington 602 | 3 3 | 14 14 | 1251 1251 | 57 57 |
1257 | 2017-06-08 | 0 | 50613 | 108 | 3928 | 2017-06-09T03:57:00 | Weaver Vale 607 | 3 3 | 14 14 | 1256 1256 | 57 57 |
1757 | 2019-12-12 | 0 | 50467 | 119 | 4774 | 2019-12-13T01:54:00 | Putney 457 | 4 4 | 14 14 | 1756 1756 | 58 58 |
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]);