viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by cabinet_id
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id | seats | cabinet_id ▼ | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
2359 | 2359 | 520 | 1992-02-22 | 1003 | 31 | 3 | 0 | 2023-03-13 20:38:18 |
2360 | 2360 | 520 | 1992-02-22 | 984 | 34 | 3 | 0 | 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 |
7178 | 7178 | 600 | 1995-03-05 | 1590 | 6 | 4 | 0 | 2023-03-13 20:38:18 |
7179 | 7179 | 600 | 1995-03-05 | 1448 | 6 | 4 | 0 | 2023-03-13 20:38:18 |
7180 | 7180 | 600 | 1995-03-05 | 1137 | 16 | 4 | 0 | 2023-03-13 20:38:18 |
7181 | 7181 | 600 | 1995-03-05 | 486 | 18 | 4 | 0 | 2023-03-13 20:38:18 |
7182 | 7182 | 600 | 1995-03-05 | 243 | 8 | 4 | 0 | 2023-03-13 20:38:18 |
7183 | 7183 | 600 | 1995-03-05 | 1395 | 5 | 4 | 0 | 2023-03-13 20:38:18 |
7184 | 7184 | 600 | 1995-03-05 | 113 | 19 | 4 | 0 | 2023-03-13 20:38:18 |
7185 | 7185 | 600 | 1995-03-05 | 2402 | 6 | 4 | 0 | 2023-03-13 20:38:18 |
7186 | 7186 | 600 | 1995-03-05 | 2403 | 9 | 4 | 0 | 2023-03-13 20:38:18 |
7187 | 7187 | 600 | 1995-03-05 | 417 | 8 | 4 | 0 | 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 |
3048 | 3048 | 657 | 2002-03-17 | 514 | 10 | 5 | 0 | 2023-03-13 20:38:18 |
3049 | 3049 | 657 | 2002-03-17 | 557 | 3 | 5 | 0 | 2023-03-13 20:38:18 |
3050 | 3050 | 657 | 2002-03-17 | 725 | 96 | 5 | 0 | 2023-03-13 20:38:18 |
3051 | 3051 | 657 | 2002-03-17 | 251 | 14 | 5 | 0 | 2023-03-13 20:38:18 |
3052 | 3052 | 657 | 2002-03-17 | 1535 | 2 | 5 | 0 | 2023-03-13 20:38:18 |
3053 | 3053 | 657 | 2002-03-17 | 1273 | 105 | 5 | 0 | 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 |
560 | 560 | 116 | 1982-09-08 | 275 | 1 | 6 | 0 | 2023-03-13 20:38:18 |
561 | 561 | 116 | 1982-09-08 | 625 | 1 | 6 | 0 | 2023-03-13 20:38:18 |
562 | 562 | 116 | 1982-09-08 | 1194 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
563 | 563 | 116 | 1982-09-08 | 1409 | 36 | 6 | 0 | 2023-03-13 20:38:18 |
564 | 564 | 116 | 1982-09-08 | 1452 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
565 | 565 | 116 | 1982-09-08 | 235 | 45 | 6 | 0 | 2023-03-13 20:38:18 |
566 | 566 | 116 | 1982-09-08 | 342 | 2 | 6 | 0 | 2023-03-13 20:38:18 |
567 | 567 | 116 | 1982-09-08 | 1251 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
568 | 568 | 116 | 1982-09-08 | 345 | 6 | 6 | 0 | 2023-03-13 20:38:18 |
569 | 569 | 116 | 1982-09-08 | 742 | 47 | 6 | 0 | 2023-03-13 20:38:18 |
570 | 570 | 116 | 1982-09-08 | 212 | 2 | 6 | 0 | 2023-03-13 20:38:18 |
571 | 571 | 116 | 1982-09-08 | 2288 | 1 | 6 | 0 | 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 |
1654 | 1654 | 367 | 1967-01-29 | 1540 | 5 | 8 | 0 | 2023-03-13 20:38:18 |
1655 | 1655 | 367 | 1967-01-29 | 837 | 25 | 8 | 0 | 2023-03-13 20:38:18 |
1656 | 1656 | 367 | 1967-01-29 | 1193 | 280 | 8 | 0 | 2023-03-13 20:38:18 |
1657 | 1657 | 367 | 1967-01-29 | 940 | 141 | 8 | 0 | 2023-03-13 20:38:18 |
1658 | 1658 | 367 | 1967-01-29 | 1053 | 30 | 8 | 0 | 2023-03-13 20:38:18 |
1659 | 1659 | 367 | 1967-01-29 | 905 | 5 | 8 | 0 | 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 |
1716 | 1716 | 382 | 1992-12-06 | 199 | 1 | 9 | 0 | 2023-03-13 20:38:18 |
1717 | 1717 | 382 | 1992-12-06 | 65 | 1 | 9 | 0 | 2023-03-13 20:38:18 |
1718 | 1718 | 382 | 1992-12-06 | 179 | 4 | 9 | 0 | 2023-03-13 20:38:18 |
1719 | 1719 | 382 | 1992-12-06 | 1047 | 15 | 9 | 0 | 2023-03-13 20:38:18 |
1720 | 1720 | 382 | 1992-12-06 | 706 | 14 | 9 | 0 | 2023-03-13 20:38:18 |
1721 | 1721 | 382 | 1992-12-06 | 1252 | 22 | 9 | 0 | 2023-03-13 20:38:18 |
1722 | 1722 | 382 | 1992-12-06 | 16 | 10 | 9 | 0 | 2023-03-13 20:38:18 |
1723 | 1723 | 382 | 1992-12-06 | 143 | 6 | 9 | 0 | 2023-03-13 20:38:18 |
1724 | 1724 | 382 | 1992-12-06 | 981 | 12 | 9 | 0 | 2023-03-13 20:38:18 |
1725 | 1725 | 382 | 1992-12-06 | 1619 | 5 | 9 | 0 | 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 |
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 );