viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where cabinet_formation = 1 and "date" is on date 2018-01-29
This data as json, CSV (advanced)
Suggested facets: date (date), calculation_date (date)
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
19214 | 19214 | 1015 | 2018-01-29 | 1120 | 154 | 1527 | 1 | 2023-03-13 20:38:18 |
19215 | 19215 | 1015 | 2018-01-29 | 1015 | 69 | 1527 | 1 | 2023-03-13 20:38:18 |
19216 | 19216 | 1015 | 2018-01-29 | 2646 | 30 | 1527 | 1 | 2023-03-13 20:38:18 |
19217 | 19217 | 1015 | 2018-01-29 | 948 | 21 | 1527 | 1 | 2023-03-13 20:38:18 |
19218 | 19218 | 1015 | 2018-01-29 | 2647 | 20 | 1527 | 1 | 2023-03-13 20:38:18 |
19219 | 19219 | 1015 | 2018-01-29 | 2395 | 18 | 1527 | 1 | 2023-03-13 20:38:18 |
19220 | 19220 | 1015 | 2018-01-29 | 425 | 17 | 1527 | 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 );