elections
Data license: Open Parliament Licence · Data source: UK Parliament election results website
5 rows where "declaration_at" is on date 2017-06-08 and "polling_on" is on date 2017-06-08
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 940 | 2017-06-08 | 0 | 41480 | 77 | 12341 | 2017-06-08T23:10:00 | Houghton and Sunderland South 290 | 3 3 | 1 1 | 939 939 | 57 57 | 2017-05-03 |
| 1036 | 2017-06-08 | 0 | 37094 | 79 | 14937 | 2017-06-08T23:01:00 | Newcastle upon Tyne Central 386 | 3 3 | 1 1 | 1035 1035 | 57 57 | 2017-05-03 |
| 1037 | 2017-06-08 | 0 | 41637 | 84 | 19261 | 2017-06-08T23:56:00 | Newcastle upon Tyne East 387 | 3 3 | 1 1 | 1036 1036 | 57 57 | 2017-05-03 |
| 1063 | 2017-06-08 | 0 | 54911 | 104 | 8335 | 2017-06-08T23:58:00 | North Swindon 413 | 3 3 | 2 2 | 1062 1062 | 57 57 | 2017-05-03 |
| 1209 | 2017-06-08 | 0 | 45111 | 76 | 9997 | 2017-06-08T23:45:00 | Sunderland Central 559 | 3 3 | 1 1 | 1208 1208 | 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]);