viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
13 rows where cabinet_formation = 1 and "date" is on date 2017-03-15
This data as json, CSV (advanced)
Suggested facets: seats
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5087 | 5087 | 1012 | 2017-03-15 | 1409 | 33 | 1506 | 1 | 2023-03-13 20:38:18 |
5088 | 5088 | 1012 | 2017-03-15 | 1501 | 20 | 1506 | 1 | 2023-03-13 20:38:18 |
5089 | 5089 | 1012 | 2017-03-15 | 235 | 19 | 1506 | 1 | 2023-03-13 20:38:18 |
5090 | 5090 | 1012 | 2017-03-15 | 345 | 19 | 1506 | 1 | 2023-03-13 20:38:18 |
5091 | 5091 | 1012 | 2017-03-15 | 756 | 14 | 1506 | 1 | 2023-03-13 20:38:18 |
5092 | 5092 | 1012 | 2017-03-15 | 357 | 14 | 1506 | 1 | 2023-03-13 20:38:18 |
5093 | 5093 | 1012 | 2017-03-15 | 742 | 9 | 1506 | 1 | 2023-03-13 20:38:18 |
5094 | 5094 | 1012 | 2017-03-15 | 1206 | 5 | 1506 | 1 | 2023-03-13 20:38:18 |
5095 | 5095 | 1012 | 2017-03-15 | 990 | 5 | 1506 | 1 | 2023-03-13 20:38:18 |
5096 | 5096 | 1012 | 2017-03-15 | 2109 | 4 | 1506 | 1 | 2023-03-13 20:38:18 |
5097 | 5097 | 1012 | 2017-03-15 | 1251 | 3 | 1506 | 1 | 2023-03-13 20:38:18 |
5098 | 5098 | 1012 | 2017-03-15 | 2641 | 3 | 1506 | 1 | 2023-03-13 20:38:18 |
5099 | 5099 | 1012 | 2017-03-15 | 2642 | 2 | 1506 | 1 | 2023-03-13 20:38:18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE `viewcalc_parliament_composition` ( `election_id` INTEGER, `date` TEXT, `party_id` INTEGER, `seats` INTEGER, `cabinet_id` INTEGER, `cabinet_formation` INTEGER, `calculation_date` TEXT );