result_summaries
Data license: Open Parliament Licence · Data source: UK Parliament election results website
5 rows where from_political_party_id = 4
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 |
---|---|---|---|---|---|---|---|---|
6 | SNP gain from LD | SNP gain from Liberal Democrats | 0 | 0 | 0 | 0 | Liberal Democrat 4 | Scottish National Party 11 |
7 | Con gain from LD | Conservative gain from Liberal Democrats | 0 | 0 | 0 | 0 | Liberal Democrat 4 | Conservative 1 |
12 | Lab gain from LD | Labour gain from Liberal Democrats | 0 | 0 | 0 | 0 | Liberal Democrat 4 | Labour 3 |
17 | LD hold | Liberal Democrats hold | 0 | 0 | 0 | 0 | Liberal Democrat 4 | Liberal Democrat 4 |
28 | PC gain from LD | Plaid Cymru gain from LD | 0 | 0 | 0 | 0 | Liberal Democrat 4 | Plaid Cymru 5 |
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]);