result_summaries
Data license: Open Parliament Licence · Data source: UK Parliament election results website
4 rows where from_political_party_id = 11
This data as json, CSV (advanced)
id ▼ | short_summary | summary | is_from_commons_speaker | is_from_independent | is_to_commons_speaker | is_to_independent | from_political_party_id | to_political_party_id |
---|---|---|---|---|---|---|---|---|
4 | SNP hold | SNP hold | 0 | 0 | 0 | 0 | Scottish National Party 11 | Scottish National Party 11 |
24 | Con gain from SNP | Conservative gain from SNP | 0 | 0 | 0 | 0 | Scottish National Party 11 | Conservative 1 |
27 | LD gain from SNP | Liberal Democrats gain from SNP | 0 | 0 | 0 | 0 | Scottish National Party 11 | Liberal Democrat 4 |
30 | Lab gain from SNP | Labour gain from SNP | 0 | 0 | 0 | 0 | Scottish National Party 11 | Labour 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "result_summaries" ( [id] INTEGER PRIMARY KEY, [short_summary] TEXT, [summary] TEXT, [is_from_commons_speaker] INTEGER, [is_from_independent] INTEGER, [is_to_commons_speaker] INTEGER, [is_to_independent] INTEGER, [from_political_party_id] INTEGER REFERENCES [political_parties]([id]), [to_political_party_id] INTEGER REFERENCES [political_parties]([id]) ); CREATE INDEX [idx_result_summaries_to_political_party_id] ON [result_summaries] ([to_political_party_id]); CREATE INDEX [idx_result_summaries_from_political_party_id] ON [result_summaries] ([from_political_party_id]);