viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
11 rows where "date" is on date 2017-06-14 and election_id = 1002
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 |
---|---|---|---|---|---|---|---|---|
19106 | 19106 | 1002 | 2017-06-14 | 1393 | 50 | 1511 | 1 | 2023-03-13 20:38:18 |
19107 | 19107 | 1002 | 2017-06-14 | 280 | 44 | 1511 | 1 | 2023-03-13 20:38:18 |
19108 | 19108 | 1002 | 2017-06-14 | 2217 | 23 | 1511 | 1 | 2023-03-13 20:38:18 |
19109 | 19109 | 1002 | 2017-06-14 | 318 | 7 | 1511 | 1 | 2023-03-13 20:38:18 |
19110 | 19110 | 1002 | 2017-06-14 | 2619 | 3 | 1511 | 1 | 2023-03-13 20:38:18 |
19111 | 19111 | 1002 | 2017-06-14 | 1573 | 2 | 1511 | 1 | 2023-03-13 20:38:18 |
19112 | 19112 | 1002 | 2017-06-14 | 2298 | 1 | 1511 | 1 | 2023-03-13 20:38:18 |
19113 | 19113 | 1002 | 2017-06-14 | 30 | 12 | 1511 | 1 | 2023-03-13 20:38:18 |
19114 | 19114 | 1002 | 2017-06-14 | 2622 | 6 | 1511 | 1 | 2023-03-13 20:38:18 |
19115 | 19115 | 1002 | 2017-06-14 | 2621 | 4 | 1511 | 1 | 2023-03-13 20:38:18 |
19116 | 19116 | 1002 | 2017-06-14 | 1014 | 6 | 1511 | 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 );