viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by cabinet_id descending
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 |
---|---|---|---|---|---|---|---|---|
20601 | 20601 | 1117 | 2022-12-29 | 678 | 32 | 1686 | 1 | 2023-03-13 20:38:18 |
20602 | 20602 | 1117 | 2022-12-29 | 2321 | 24 | 1686 | 1 | 2023-03-13 20:38:18 |
20603 | 20603 | 1117 | 2022-12-29 | 1846 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20604 | 20604 | 1117 | 2022-12-29 | 1816 | 6 | 1686 | 1 | 2023-03-13 20:38:18 |
20605 | 20605 | 1117 | 2022-12-29 | 2725 | 12 | 1686 | 1 | 2023-03-13 20:38:18 |
20606 | 20606 | 1117 | 2022-12-29 | 1357 | 14 | 1686 | 1 | 2023-03-13 20:38:18 |
20607 | 20607 | 1117 | 2022-12-29 | 732 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20608 | 20608 | 1117 | 2022-12-29 | 244 | 4 | 1686 | 1 | 2023-03-13 20:38:18 |
20609 | 20609 | 1117 | 2022-12-29 | 788 | 11 | 1686 | 1 | 2023-03-13 20:38:18 |
20610 | 20610 | 1117 | 2022-12-29 | 1303 | 7 | 1686 | 1 | 2023-03-13 20:38:18 |
20838 | 20838 | 1117 | 2022-12-29 | 2889 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20839 | 20839 | 1117 | 2022-12-29 | 2322 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20840 | 20840 | 1117 | 2022-12-29 | 265 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20841 | 20841 | 1117 | 2022-12-29 | 249 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20594 | 20594 | 1115 | 2022-12-14 | 1666 | 26 | 1685 | 1 | 2023-03-13 20:38:18 |
20595 | 20595 | 1115 | 2022-12-14 | 466 | 16 | 1685 | 1 | 2023-03-13 20:38:18 |
20596 | 20596 | 1115 | 2022-12-14 | 2875 | 11 | 1685 | 1 | 2023-03-13 20:38:18 |
20597 | 20597 | 1115 | 2022-12-14 | 521 | 13 | 1685 | 1 | 2023-03-13 20:38:18 |
20598 | 20598 | 1115 | 2022-12-14 | 2876 | 9 | 1685 | 1 | 2023-03-13 20:38:18 |
20599 | 20599 | 1115 | 2022-12-14 | 2716 | 10 | 1685 | 1 | 2023-03-13 20:38:18 |
20600 | 20600 | 1115 | 2022-12-14 | 1001 | 15 | 1685 | 1 | 2023-03-13 20:38:18 |
20837 | 20837 | 1115 | 2022-12-14 | 2366 | 0 | 1685 | 1 | 2023-03-13 20:38:18 |
20578 | 20578 | 1116 | 2022-12-15 | 1629 | 50 | 1684 | 1 | 2023-03-13 20:38:18 |
20579 | 20579 | 1116 | 2022-12-15 | 211 | 7 | 1684 | 1 | 2023-03-13 20:38:18 |
20580 | 20580 | 1116 | 2022-12-15 | 590 | 10 | 1684 | 1 | 2023-03-13 20:38:18 |
20581 | 20581 | 1116 | 2022-12-15 | 2781 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20582 | 20582 | 1116 | 2022-12-15 | 1644 | 15 | 1684 | 1 | 2023-03-13 20:38:18 |
20583 | 20583 | 1116 | 2022-12-15 | 2887 | 16 | 1684 | 1 | 2023-03-13 20:38:18 |
20584 | 20584 | 1116 | 2022-12-15 | 1418 | 5 | 1684 | 1 | 2023-03-13 20:38:18 |
20585 | 20585 | 1116 | 2022-12-15 | 1605 | 23 | 1684 | 1 | 2023-03-13 20:38:18 |
20586 | 20586 | 1116 | 2022-12-15 | 306 | 9 | 1684 | 1 | 2023-03-13 20:38:18 |
20587 | 20587 | 1116 | 2022-12-15 | 2567 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20588 | 20588 | 1116 | 2022-12-15 | 376 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20589 | 20589 | 1116 | 2022-12-15 | 2888 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20590 | 20590 | 1116 | 2022-12-15 | 1891 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20591 | 20591 | 1116 | 2022-12-15 | 74 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20592 | 20592 | 1116 | 2022-12-15 | 1892 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20593 | 20593 | 1116 | 2022-12-15 | 1894 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20568 | 20568 | 1086 | 2022-10-25 | 773 | 365 | 1683 | 1 | 2023-03-13 20:38:18 |
20569 | 20569 | 1086 | 2022-10-25 | 1556 | 203 | 1683 | 1 | 2023-03-13 20:38:18 |
20570 | 20570 | 1086 | 2022-10-25 | 1284 | 48 | 1683 | 1 | 2023-03-13 20:38:18 |
20571 | 20571 | 1086 | 2022-10-25 | 659 | 11 | 1683 | 1 | 2023-03-13 20:38:18 |
20572 | 20572 | 1086 | 2022-10-25 | 319 | 8 | 1683 | 1 | 2023-03-13 20:38:18 |
20573 | 20573 | 1086 | 2022-10-25 | 689 | 7 | 1683 | 1 | 2023-03-13 20:38:18 |
20574 | 20574 | 1086 | 2022-10-25 | 311 | 4 | 1683 | 1 | 2023-03-13 20:38:18 |
20575 | 20575 | 1086 | 2022-10-25 | 1023 | 2 | 1683 | 1 | 2023-03-13 20:38:18 |
20576 | 20576 | 1086 | 2022-10-25 | 467 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
20577 | 20577 | 1086 | 2022-10-25 | 2731 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
20556 | 20556 | 1113 | 2022-10-22 | 2154 | 118 | 1682 | 1 | 2023-03-13 20:38:18 |
20557 | 20557 | 1113 | 2022-10-22 | 596 | 44 | 1682 | 1 | 2023-03-13 20:38:18 |
20558 | 20558 | 1113 | 2022-10-22 | 382 | 69 | 1682 | 1 | 2023-03-13 20:38:18 |
20559 | 20559 | 1113 | 2022-10-22 | 2737 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20560 | 20560 | 1113 | 2022-10-22 | 2155 | 52 | 1682 | 1 | 2023-03-13 20:38:18 |
20561 | 20561 | 1113 | 2022-10-22 | 1436 | 66 | 1682 | 1 | 2023-03-13 20:38:18 |
20562 | 20562 | 1113 | 2022-10-22 | 1278 | 11 | 1682 | 1 | 2023-03-13 20:38:18 |
20563 | 20563 | 1113 | 2022-10-22 | 2794 | 21 | 1682 | 1 | 2023-03-13 20:38:18 |
20564 | 20564 | 1113 | 2022-10-22 | 2302 | 1 | 1682 | 1 | 2023-03-13 20:38:18 |
20565 | 20565 | 1113 | 2022-10-22 | 1030 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20566 | 20566 | 1113 | 2022-10-22 | 226 | 9 | 1682 | 1 | 2023-03-13 20:38:18 |
20567 | 20567 | 1113 | 2022-10-22 | 825 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20836 | 20836 | 1113 | 2022-10-22 | 1552 | 0 | 1682 | 1 | 2023-03-13 20:38:18 |
5752 | 5752 | 1113 | 2022-09-25 | 2154 | 118 | 1681 | 0 | 2023-03-13 20:38:18 |
5753 | 5753 | 1113 | 2022-09-25 | 596 | 44 | 1681 | 0 | 2023-03-13 20:38:18 |
5754 | 5754 | 1113 | 2022-09-25 | 382 | 69 | 1681 | 0 | 2023-03-13 20:38:18 |
5755 | 5755 | 1113 | 2022-09-25 | 2737 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
5756 | 5756 | 1113 | 2022-09-25 | 2155 | 52 | 1681 | 0 | 2023-03-13 20:38:18 |
5757 | 5757 | 1113 | 2022-09-25 | 1436 | 66 | 1681 | 0 | 2023-03-13 20:38:18 |
5758 | 5758 | 1113 | 2022-09-25 | 1278 | 11 | 1681 | 0 | 2023-03-13 20:38:18 |
5759 | 5759 | 1113 | 2022-09-25 | 2794 | 21 | 1681 | 0 | 2023-03-13 20:38:18 |
5760 | 5760 | 1113 | 2022-09-25 | 2302 | 1 | 1681 | 0 | 2023-03-13 20:38:18 |
5761 | 5761 | 1113 | 2022-09-25 | 1030 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
5762 | 5762 | 1113 | 2022-09-25 | 226 | 9 | 1681 | 0 | 2023-03-13 20:38:18 |
5763 | 5763 | 1113 | 2022-09-25 | 825 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
20540 | 20540 | 1024 | 2022-07-21 | 2155 | 177 | 1681 | 1 | 2023-03-13 20:38:18 |
20541 | 20541 | 1024 | 2022-07-21 | 1436 | 124 | 1681 | 1 | 2023-03-13 20:38:18 |
20542 | 20542 | 1024 | 2022-07-21 | 596 | 106 | 1681 | 1 | 2023-03-13 20:38:18 |
20543 | 20543 | 1024 | 2022-07-21 | 2154 | 31 | 1681 | 1 | 2023-03-13 20:38:18 |
20544 | 20544 | 1024 | 2022-07-21 | 226 | 4 | 1681 | 1 | 2023-03-13 20:38:18 |
20545 | 20545 | 1024 | 2022-07-21 | 382 | 87 | 1681 | 1 | 2023-03-13 20:38:18 |
20546 | 20546 | 1024 | 2022-07-21 | 1030 | 4 | 1681 | 1 | 2023-03-13 20:38:18 |
20547 | 20547 | 1024 | 2022-07-21 | 2153 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20548 | 20548 | 1024 | 2022-07-21 | 2302 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20549 | 20549 | 1024 | 2022-07-21 | 693 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20550 | 20550 | 1024 | 2022-07-21 | 465 | 14 | 1681 | 1 | 2023-03-13 20:38:18 |
20551 | 20551 | 1024 | 2022-07-21 | 927 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20552 | 20552 | 1024 | 2022-07-21 | 2671 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20553 | 20553 | 1024 | 2022-07-21 | 2737 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20554 | 20554 | 1024 | 2022-07-21 | 2794 | 25 | 1681 | 1 | 2023-03-13 20:38:18 |
20555 | 20555 | 1024 | 2022-07-21 | 2861 | 50 | 1681 | 1 | 2023-03-13 20:38:18 |
20835 | 20835 | 1024 | 2022-07-21 | 2001 | 0 | 1681 | 1 | 2023-03-13 20:38:18 |
20532 | 20532 | 1112 | 2022-10-17 | 657 | 68 | 1680 | 1 | 2023-03-13 20:38:18 |
20533 | 20533 | 1112 | 2022-10-17 | 1461 | 24 | 1680 | 1 | 2023-03-13 20:38:18 |
20534 | 20534 | 1112 | 2022-10-17 | 282 | 19 | 1680 | 1 | 2023-03-13 20:38:18 |
20535 | 20535 | 1112 | 2022-10-17 | 904 | 107 | 1680 | 1 | 2023-03-13 20:38:18 |
20536 | 20536 | 1112 | 2022-10-17 | 1546 | 73 | 1680 | 1 | 2023-03-13 20:38:18 |
20537 | 20537 | 1112 | 2022-10-17 | 892 | 16 | 1680 | 1 | 2023-03-13 20:38:18 |
20538 | 20538 | 1112 | 2022-10-17 | 882 | 24 | 1680 | 1 | 2023-03-13 20:38:18 |
20539 | 20539 | 1112 | 2022-10-17 | 1154 | 18 | 1680 | 1 | 2023-03-13 20:38:18 |
20526 | 20526 | 1089 | 2022-09-13 | 1759 | 53 | 1679 | 1 | 2023-03-13 20:38:18 |
20527 | 20527 | 1089 | 2022-09-13 | 220 | 38 | 1679 | 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 );