viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where cabinet_formation = 1 and "date" is on date 1940-03-22
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 |
---|---|---|---|---|---|---|---|---|
18691 | 18691 | 983 | 1940-03-22 | 1539 | 149 | 1415 | 1 | 2023-03-13 20:38:18 |
18692 | 18692 | 983 | 1940-03-22 | 401 | 109 | 1415 | 1 | 2023-03-13 20:38:18 |
18693 | 18693 | 983 | 1940-03-22 | 2594 | 56 | 1415 | 1 | 2023-03-13 20:38:18 |
18694 | 18694 | 983 | 1940-03-22 | 686 | 72 | 1415 | 1 | 2023-03-13 20:38:18 |
18695 | 18695 | 983 | 1940-03-22 | 2581 | 222 | 1415 | 1 | 2023-03-13 20:38:18 |
20783 | 20783 | 983 | 1940-03-22 | 2587 | 0 | 1415 | 1 | 2023-03-13 20:38:18 |
20784 | 20784 | 983 | 1940-03-22 | 2617 | 0 | 1415 | 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 );