viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where cabinet_formation = 1 and "date" is on date 2021-05-12
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 |
---|---|---|---|---|---|---|---|---|
20347 | 20347 | 1101 | 2021-05-12 | 1541 | 75 | 1657 | 1 | 2023-03-13 20:38:18 |
20348 | 20348 | 1101 | 2021-05-12 | 2836 | 51 | 1657 | 1 | 2023-03-13 20:38:18 |
20349 | 20349 | 1101 | 2021-05-12 | 1160 | 43 | 1657 | 1 | 2023-03-13 20:38:18 |
20350 | 20350 | 1101 | 2021-05-12 | 1286 | 30 | 1657 | 1 | 2023-03-13 20:38:18 |
20351 | 20351 | 1101 | 2021-05-12 | 57 | 27 | 1657 | 1 | 2023-03-13 20:38:18 |
20352 | 20352 | 1101 | 2021-05-12 | 2838 | 14 | 1657 | 1 | 2023-03-13 20:38:18 |
20823 | 20823 | 1101 | 2021-05-12 | 133 | 0 | 1657 | 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 );