viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where cabinet_formation = 1 and "date" is on date 1933-03-03
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 |
---|---|---|---|---|---|---|---|---|
17669 | 17669 | 866 | 1933-03-03 | 1435 | 37 | 1225 | 1 | 2023-03-13 20:38:18 |
17670 | 17670 | 866 | 1933-03-03 | 647 | 33 | 1225 | 1 | 2023-03-13 20:38:18 |
17671 | 17671 | 866 | 1933-03-03 | 104 | 47 | 1225 | 1 | 2023-03-13 20:38:18 |
17672 | 17672 | 866 | 1933-03-03 | 702 | 25 | 1225 | 1 | 2023-03-13 20:38:18 |
17673 | 17673 | 866 | 1933-03-03 | 2415 | 1 | 1225 | 1 | 2023-03-13 20:38:18 |
17674 | 17674 | 866 | 1933-03-03 | 2472 | 5 | 1225 | 1 | 2023-03-13 20:38:18 |
17675 | 17675 | 866 | 1933-03-03 | 2578 | 2 | 1225 | 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 );