viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by cabinet_id
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 |
---|---|---|---|---|---|---|---|---|
9465 | 9465 | 764 | 1968-01-10 | 1253 | 41 | 1 | 1 | 2023-03-13 20:38:18 |
9466 | 9466 | 764 | 1968-01-10 | 1411 | 61 | 1 | 1 | 2023-03-13 20:38:18 |
9467 | 9467 | 764 | 1968-01-10 | 184 | 21 | 1 | 1 | 2023-03-13 20:38:18 |
9468 | 9468 | 764 | 1968-01-10 | 1396 | 1 | 1 | 1 | 2023-03-13 20:38:18 |
9469 | 9469 | 534 | 1998-04-08 | 239 | 8 | 2 | 1 | 2023-03-13 20:38:18 |
9470 | 9470 | 534 | 1998-04-08 | 309 | 5 | 2 | 1 | 2023-03-13 20:38:18 |
9471 | 9471 | 534 | 1998-04-08 | 759 | 18 | 2 | 1 | 2023-03-13 20:38:18 |
9472 | 9472 | 534 | 1998-04-08 | 1557 | 4 | 2 | 1 | 2023-03-13 20:38:18 |
9473 | 9473 | 534 | 1998-04-08 | 32 | 6 | 2 | 1 | 2023-03-13 20:38:18 |
9474 | 9474 | 534 | 1998-04-08 | 526 | 17 | 2 | 1 | 2023-03-13 20:38:18 |
9475 | 9475 | 534 | 1998-04-08 | 1042 | 8 | 2 | 1 | 2023-03-13 20:38:18 |
9476 | 9476 | 534 | 1998-04-08 | 267 | 16 | 2 | 1 | 2023-03-13 20:38:18 |
9477 | 9477 | 534 | 1998-04-08 | 521 | 18 | 2 | 1 | 2023-03-13 20:38:18 |
20632 | 20632 | 534 | 1998-04-08 | 1368 | 0 | 2 | 1 | 2023-03-13 20:38:18 |
9478 | 9478 | 370 | 1987-05-12 | 984 | 35 | 3 | 1 | 2023-03-13 20:38:18 |
9479 | 9479 | 370 | 1987-05-12 | 1003 | 34 | 3 | 1 | 2023-03-13 20:38:18 |
9480 | 9480 | 670 | 1994-11-03 | 1448 | 12 | 4 | 1 | 2023-03-13 20:38:18 |
9481 | 9481 | 670 | 1994-11-03 | 552 | 10 | 4 | 1 | 2023-03-13 20:38:18 |
9482 | 9482 | 670 | 1994-11-03 | 1516 | 1 | 4 | 1 | 2023-03-13 20:38:18 |
9483 | 9483 | 670 | 1994-11-03 | 1064 | 8 | 4 | 1 | 2023-03-13 20:38:18 |
9484 | 9484 | 670 | 1994-11-03 | 486 | 17 | 4 | 1 | 2023-03-13 20:38:18 |
9485 | 9485 | 670 | 1994-11-03 | 2631 | 1 | 4 | 1 | 2023-03-13 20:38:18 |
9486 | 9486 | 670 | 1994-11-03 | 450 | 15 | 4 | 1 | 2023-03-13 20:38:18 |
9487 | 9487 | 670 | 1994-11-03 | 25 | 8 | 4 | 1 | 2023-03-13 20:38:18 |
9488 | 9488 | 670 | 1994-11-03 | 243 | 19 | 4 | 1 | 2023-03-13 20:38:18 |
9489 | 9489 | 670 | 1994-11-03 | 1395 | 10 | 4 | 1 | 2023-03-13 20:38:18 |
9490 | 9490 | 352 | 1999-10-25 | 251 | 15 | 5 | 1 | 2023-03-13 20:38:18 |
9491 | 9491 | 352 | 1999-10-25 | 1273 | 81 | 5 | 1 | 2023-03-13 20:38:18 |
9492 | 9492 | 352 | 1999-10-25 | 725 | 115 | 5 | 1 | 2023-03-13 20:38:18 |
9493 | 9493 | 352 | 1999-10-25 | 557 | 2 | 5 | 1 | 2023-03-13 20:38:18 |
9494 | 9494 | 352 | 1999-10-25 | 1535 | 2 | 5 | 1 | 2023-03-13 20:38:18 |
9495 | 9495 | 352 | 1999-10-25 | 514 | 15 | 5 | 1 | 2023-03-13 20:38:18 |
9496 | 9496 | 81 | 1982-05-29 | 345 | 17 | 6 | 1 | 2023-03-13 20:38:18 |
9497 | 9497 | 81 | 1982-05-29 | 1409 | 26 | 6 | 1 | 2023-03-13 20:38:18 |
9498 | 9498 | 81 | 1982-05-29 | 1194 | 3 | 6 | 1 | 2023-03-13 20:38:18 |
9499 | 9499 | 81 | 1982-05-29 | 1452 | 3 | 6 | 1 | 2023-03-13 20:38:18 |
9500 | 9500 | 81 | 1982-05-29 | 212 | 2 | 6 | 1 | 2023-03-13 20:38:18 |
9501 | 9501 | 81 | 1982-05-29 | 342 | 3 | 6 | 1 | 2023-03-13 20:38:18 |
9502 | 9502 | 81 | 1982-05-29 | 235 | 48 | 6 | 1 | 2023-03-13 20:38:18 |
9503 | 9503 | 81 | 1982-05-29 | 1251 | 3 | 6 | 1 | 2023-03-13 20:38:18 |
9504 | 9504 | 81 | 1982-05-29 | 625 | 1 | 6 | 1 | 2023-03-13 20:38:18 |
9505 | 9505 | 81 | 1982-05-29 | 742 | 44 | 6 | 1 | 2023-03-13 20:38:18 |
137 | 137 | 40 | 1974-10-10 | 646 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
138 | 138 | 40 | 1974-10-10 | 1210 | 6 | 7 | 1 | 2023-03-13 20:38:18 |
139 | 139 | 40 | 1974-10-10 | 319 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
140 | 140 | 40 | 1974-10-10 | 1284 | 11 | 7 | 1 | 2023-03-13 20:38:18 |
141 | 141 | 40 | 1974-10-10 | 1556 | 319 | 7 | 1 | 2023-03-13 20:38:18 |
142 | 142 | 40 | 1974-10-10 | 311 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
143 | 143 | 40 | 1974-10-10 | 659 | 13 | 7 | 1 | 2023-03-13 20:38:18 |
144 | 144 | 40 | 1974-10-10 | 1023 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
145 | 145 | 40 | 1974-10-10 | 773 | 277 | 7 | 1 | 2023-03-13 20:38:18 |
146 | 146 | 40 | 1974-10-10 | 1599 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
9506 | 9506 | 640 | 1964-11-09 | 940 | 144 | 8 | 1 | 2023-03-13 20:38:18 |
9507 | 9507 | 640 | 1964-11-09 | 1540 | 5 | 8 | 1 | 2023-03-13 20:38:18 |
9508 | 9508 | 640 | 1964-11-09 | 1193 | 294 | 8 | 1 | 2023-03-13 20:38:18 |
9509 | 9509 | 640 | 1964-11-09 | 1053 | 23 | 8 | 1 | 2023-03-13 20:38:18 |
9510 | 9510 | 640 | 1964-11-09 | 905 | 1 | 8 | 1 | 2023-03-13 20:38:18 |
9511 | 9511 | 129 | 1992-04-22 | 65 | 1 | 9 | 1 | 2023-03-13 20:38:18 |
9512 | 9512 | 129 | 1992-04-22 | 1371 | 8 | 9 | 1 | 2023-03-13 20:38:18 |
9513 | 9513 | 129 | 1992-04-22 | 1252 | 12 | 9 | 1 | 2023-03-13 20:38:18 |
9514 | 9514 | 129 | 1992-04-22 | 199 | 1 | 9 | 1 | 2023-03-13 20:38:18 |
9515 | 9515 | 129 | 1992-04-22 | 317 | 5 | 9 | 1 | 2023-03-13 20:38:18 |
9516 | 9516 | 129 | 1992-04-22 | 706 | 14 | 9 | 1 | 2023-03-13 20:38:18 |
9517 | 9517 | 129 | 1992-04-22 | 179 | 6 | 9 | 1 | 2023-03-13 20:38:18 |
9518 | 9518 | 129 | 1992-04-22 | 16 | 11 | 9 | 1 | 2023-03-13 20:38:18 |
9519 | 9519 | 129 | 1992-04-22 | 875 | 3 | 9 | 1 | 2023-03-13 20:38:18 |
9520 | 9520 | 129 | 1992-04-22 | 1047 | 11 | 9 | 1 | 2023-03-13 20:38:18 |
9521 | 9521 | 129 | 1992-04-22 | 1619 | 8 | 9 | 1 | 2023-03-13 20:38:18 |
20637 | 20637 | 129 | 1992-04-22 | 143 | 0 | 9 | 1 | 2023-03-13 20:38:18 |
9522 | 9522 | 901 | 1945-05-05 | 1629 | 66 | 10 | 1 | 2023-03-13 20:38:18 |
9523 | 9523 | 901 | 1945-05-05 | 590 | 31 | 10 | 1 | 2023-03-13 20:38:18 |
9524 | 9524 | 901 | 1945-05-05 | 1605 | 28 | 10 | 1 | 2023-03-13 20:38:18 |
9525 | 9525 | 901 | 1945-05-05 | 211 | 13 | 10 | 1 | 2023-03-13 20:38:18 |
9526 | 9526 | 901 | 1945-05-05 | 412 | 3 | 10 | 1 | 2023-03-13 20:38:18 |
9527 | 9527 | 901 | 1945-05-05 | 2432 | 3 | 10 | 1 | 2023-03-13 20:38:18 |
9528 | 9528 | 901 | 1945-05-05 | 1606 | 2 | 10 | 1 | 2023-03-13 20:38:18 |
9529 | 9529 | 901 | 1945-05-05 | 2428 | 2 | 10 | 1 | 2023-03-13 20:38:18 |
20622 | 20622 | 901 | 1945-05-05 | 1239 | 0 | 10 | 1 | 2023-03-13 20:38:18 |
9530 | 9530 | 157 | 1990-12-18 | 211 | 7 | 11 | 1 | 2023-03-13 20:38:18 |
9531 | 9531 | 157 | 1990-12-18 | 1644 | 15 | 11 | 1 | 2023-03-13 20:38:18 |
9532 | 9532 | 157 | 1990-12-18 | 1629 | 69 | 11 | 1 | 2023-03-13 20:38:18 |
9533 | 9533 | 157 | 1990-12-18 | 1331 | 4 | 11 | 1 | 2023-03-13 20:38:18 |
9534 | 9534 | 157 | 1990-12-18 | 1605 | 29 | 11 | 1 | 2023-03-13 20:38:18 |
9535 | 9535 | 157 | 1990-12-18 | 590 | 30 | 11 | 1 | 2023-03-13 20:38:18 |
9536 | 9536 | 157 | 1990-12-18 | 1324 | 9 | 11 | 1 | 2023-03-13 20:38:18 |
9537 | 9537 | 157 | 1990-12-18 | 978 | 12 | 11 | 1 | 2023-03-13 20:38:18 |
9538 | 9538 | 157 | 1990-12-18 | 2575 | 1 | 11 | 1 | 2023-03-13 20:38:18 |
9539 | 9539 | 157 | 1990-12-18 | 74 | 1 | 11 | 1 | 2023-03-13 20:38:18 |
9540 | 9540 | 157 | 1990-12-18 | 2574 | 1 | 11 | 1 | 2023-03-13 20:38:18 |
9541 | 9541 | 157 | 1990-12-18 | 1894 | 1 | 11 | 1 | 2023-03-13 20:38:18 |
9542 | 9542 | 383 | 2004-07-31 | 1582 | 5 | 12 | 1 | 2023-03-13 20:38:18 |
9543 | 9543 | 383 | 2004-07-31 | 1234 | 24 | 12 | 1 | 2023-03-13 20:38:18 |
9544 | 9544 | 383 | 2004-07-31 | 310 | 7 | 12 | 1 | 2023-03-13 20:38:18 |
9545 | 9545 | 383 | 2004-07-31 | 701 | 14 | 12 | 1 | 2023-03-13 20:38:18 |
9546 | 9546 | 383 | 2004-07-31 | 967 | 10 | 12 | 1 | 2023-03-13 20:38:18 |
9547 | 9547 | 257 | 1993-12-21 | 1426 | 93 | 13 | 1 | 2023-03-13 20:38:18 |
9548 | 9548 | 257 | 1993-12-21 | 1617 | 7 | 13 | 1 | 2023-03-13 20:38:18 |
9549 | 9549 | 257 | 1993-12-21 | 1183 | 2 | 13 | 1 | 2023-03-13 20:38:18 |
9550 | 9550 | 257 | 1993-12-21 | 921 | 22 | 13 | 1 | 2023-03-13 20:38:18 |
9551 | 9551 | 257 | 1993-12-21 | 870 | 44 | 13 | 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 );