result_summaries
Data license: Open Parliament Licence · Data source: Original Data Source
6 rows where from_political_party_id = 1
This data as json, CSV (advanced)
Suggested facets: is_to_commons_speaker
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 |
---|---|---|---|---|---|---|---|---|
2 | Con hold | Conservative hold | 0 | 0 | 0 | 0 | Conservative 1 | Conservative 1 |
14 | Lab gain from Con | Labour gain from Conservatives | 0 | 0 | 0 | 0 | Conservative 1 | Labour 3 |
18 | UKIP gain from Con | UKIP gain from Conservative | 0 | 0 | 0 | 0 | Conservative 1 | UK Independence Party 8 |
25 | LD gain from Con | Liberal Democrats gain from Conservative | 0 | 0 | 0 | 0 | Conservative 1 | Liberal Democrat 4 |
34 | SNP gain from Con | SNP gain from Conservative | 0 | 0 | 0 | 0 | Conservative 1 | Scottish National Party 11 |
47 | Spk gain from Con | Speaker gain from Conservative | 0 | 0 | 1 | 0 | Conservative 1 |
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]);