viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
9 rows where cabinet_id = 1508 and "date" is on date 2017-06-14
This data as json, CSV (advanced)
Suggested facets: seats, date (date), calculation_date (date)
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
19083 | 19083 | 782 | 2017-06-14 | 658 | 199 | 1508 | 1 | 2023-03-13 20:38:18 |
19084 | 19084 | 782 | 2017-06-14 | 873 | 17 | 1508 | 1 | 2023-03-13 20:38:18 |
19085 | 19085 | 782 | 2017-06-14 | 1539 | 292 | 1508 | 1 | 2023-03-13 20:38:18 |
19086 | 19086 | 782 | 2017-06-14 | 947 | 8 | 1508 | 1 | 2023-03-13 20:38:18 |
19087 | 19087 | 782 | 2017-06-14 | 2273 | 30 | 1508 | 1 | 2023-03-13 20:38:18 |
19088 | 19088 | 782 | 2017-06-14 | 1492 | 16 | 1508 | 1 | 2023-03-13 20:38:18 |
19089 | 19089 | 782 | 2017-06-14 | 2272 | 15 | 1508 | 1 | 2023-03-13 20:38:18 |
20796 | 20796 | 782 | 2017-06-14 | 509 | 0 | 1508 | 1 | 2023-03-13 20:38:18 |
20797 | 20797 | 782 | 2017-06-14 | 2643 | 0 | 1508 | 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 );