viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by election_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 |
---|---|---|---|---|---|---|---|---|
5794 | 5794 | 1117 | 2022-11-01 | 678 | 32 | 1677 | 0 | 2023-03-13 20:38:18 |
5795 | 5795 | 1117 | 2022-11-01 | 2321 | 24 | 1677 | 0 | 2023-03-13 20:38:18 |
5796 | 5796 | 1117 | 2022-11-01 | 1846 | 5 | 1677 | 0 | 2023-03-13 20:38:18 |
5797 | 5797 | 1117 | 2022-11-01 | 1816 | 6 | 1677 | 0 | 2023-03-13 20:38:18 |
5798 | 5798 | 1117 | 2022-11-01 | 2725 | 12 | 1677 | 0 | 2023-03-13 20:38:18 |
5799 | 5799 | 1117 | 2022-11-01 | 1357 | 14 | 1677 | 0 | 2023-03-13 20:38:18 |
5800 | 5800 | 1117 | 2022-11-01 | 732 | 5 | 1677 | 0 | 2023-03-13 20:38:18 |
5801 | 5801 | 1117 | 2022-11-01 | 244 | 4 | 1677 | 0 | 2023-03-13 20:38:18 |
5802 | 5802 | 1117 | 2022-11-01 | 788 | 11 | 1677 | 0 | 2023-03-13 20:38:18 |
5803 | 5803 | 1117 | 2022-11-01 | 1303 | 7 | 1677 | 0 | 2023-03-13 20:38:18 |
5778 | 5778 | 1116 | 2022-11-01 | 1629 | 50 | 1598 | 0 | 2023-03-13 20:38:18 |
5779 | 5779 | 1116 | 2022-11-01 | 211 | 7 | 1598 | 0 | 2023-03-13 20:38:18 |
5780 | 5780 | 1116 | 2022-11-01 | 590 | 10 | 1598 | 0 | 2023-03-13 20:38:18 |
5781 | 5781 | 1116 | 2022-11-01 | 2781 | 6 | 1598 | 0 | 2023-03-13 20:38:18 |
5782 | 5782 | 1116 | 2022-11-01 | 1644 | 15 | 1598 | 0 | 2023-03-13 20:38:18 |
5783 | 5783 | 1116 | 2022-11-01 | 2887 | 16 | 1598 | 0 | 2023-03-13 20:38:18 |
5784 | 5784 | 1116 | 2022-11-01 | 1418 | 5 | 1598 | 0 | 2023-03-13 20:38:18 |
5785 | 5785 | 1116 | 2022-11-01 | 1605 | 23 | 1598 | 0 | 2023-03-13 20:38:18 |
5786 | 5786 | 1116 | 2022-11-01 | 306 | 9 | 1598 | 0 | 2023-03-13 20:38:18 |
5787 | 5787 | 1116 | 2022-11-01 | 2567 | 6 | 1598 | 0 | 2023-03-13 20:38:18 |
5788 | 5788 | 1116 | 2022-11-01 | 376 | 14 | 1598 | 0 | 2023-03-13 20:38:18 |
5789 | 5789 | 1116 | 2022-11-01 | 2888 | 14 | 1598 | 0 | 2023-03-13 20:38:18 |
5790 | 5790 | 1116 | 2022-11-01 | 1891 | 1 | 1598 | 0 | 2023-03-13 20:38:18 |
5791 | 5791 | 1116 | 2022-11-01 | 74 | 1 | 1598 | 0 | 2023-03-13 20:38:18 |
5792 | 5792 | 1116 | 2022-11-01 | 1892 | 1 | 1598 | 0 | 2023-03-13 20:38:18 |
5793 | 5793 | 1116 | 2022-11-01 | 1894 | 1 | 1598 | 0 | 2023-03-13 20:38:18 |
5771 | 5771 | 1115 | 2022-10-01 | 1666 | 26 | 1592 | 0 | 2023-03-13 20:38:18 |
5772 | 5772 | 1115 | 2022-10-01 | 466 | 16 | 1592 | 0 | 2023-03-13 20:38:18 |
5773 | 5773 | 1115 | 2022-10-01 | 2875 | 11 | 1592 | 0 | 2023-03-13 20:38:18 |
5774 | 5774 | 1115 | 2022-10-01 | 521 | 13 | 1592 | 0 | 2023-03-13 20:38:18 |
5775 | 5775 | 1115 | 2022-10-01 | 2876 | 9 | 1592 | 0 | 2023-03-13 20:38:18 |
5776 | 5776 | 1115 | 2022-10-01 | 2716 | 10 | 1592 | 0 | 2023-03-13 20:38:18 |
5777 | 5777 | 1115 | 2022-10-01 | 1001 | 15 | 1592 | 0 | 2023-03-13 20:38:18 |
5764 | 5764 | 1114 | 2022-10-02 | 1286 | 36 | 1678 | 0 | 2023-03-13 20:38:18 |
5765 | 5765 | 1114 | 2022-10-02 | 2847 | 53 | 1678 | 0 | 2023-03-13 20:38:18 |
5766 | 5766 | 1114 | 2022-10-02 | 2640 | 27 | 1678 | 0 | 2023-03-13 20:38:18 |
5767 | 5767 | 1114 | 2022-10-02 | 1541 | 67 | 1678 | 0 | 2023-03-13 20:38:18 |
5768 | 5768 | 1114 | 2022-10-02 | 2638 | 20 | 1678 | 0 | 2023-03-13 20:38:18 |
5769 | 5769 | 1114 | 2022-10-02 | 982 | 25 | 1678 | 0 | 2023-03-13 20:38:18 |
5770 | 5770 | 1114 | 2022-10-02 | 2871 | 12 | 1678 | 0 | 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 |
5744 | 5744 | 1112 | 2022-09-11 | 657 | 68 | 1652 | 0 | 2023-03-13 20:38:18 |
5745 | 5745 | 1112 | 2022-09-11 | 1461 | 24 | 1652 | 0 | 2023-03-13 20:38:18 |
5746 | 5746 | 1112 | 2022-09-11 | 282 | 19 | 1652 | 0 | 2023-03-13 20:38:18 |
5747 | 5747 | 1112 | 2022-09-11 | 904 | 107 | 1652 | 0 | 2023-03-13 20:38:18 |
5748 | 5748 | 1112 | 2022-09-11 | 1546 | 73 | 1652 | 0 | 2023-03-13 20:38:18 |
5749 | 5749 | 1112 | 2022-09-11 | 892 | 16 | 1652 | 0 | 2023-03-13 20:38:18 |
5750 | 5750 | 1112 | 2022-09-11 | 882 | 24 | 1652 | 0 | 2023-03-13 20:38:18 |
5751 | 5751 | 1112 | 2022-09-11 | 1154 | 18 | 1652 | 0 | 2023-03-13 20:38:18 |
5735 | 5735 | 1111 | 2022-05-21 | 1428 | 58 | 1616 | 0 | 2023-03-13 20:38:18 |
5736 | 5736 | 1111 | 2022-05-21 | 1411 | 27 | 1616 | 0 | 2023-03-13 20:38:18 |
5737 | 5737 | 1111 | 2022-05-21 | 154 | 21 | 1616 | 0 | 2023-03-13 20:38:18 |
5738 | 5738 | 1111 | 2022-05-21 | 184 | 10 | 1616 | 0 | 2023-03-13 20:38:18 |
5739 | 5739 | 1111 | 2022-05-21 | 1253 | 77 | 1616 | 0 | 2023-03-13 20:38:18 |
5740 | 5740 | 1111 | 2022-05-21 | 751 | 4 | 1616 | 0 | 2023-03-13 20:38:18 |
5741 | 5741 | 1111 | 2022-05-21 | 2630 | 1 | 1616 | 0 | 2023-03-13 20:38:18 |
5742 | 5742 | 1111 | 2022-05-21 | 2258 | 1 | 1616 | 0 | 2023-03-13 20:38:18 |
5743 | 5743 | 1111 | 2022-05-21 | 1396 | 10 | 1616 | 0 | 2023-03-13 20:38:18 |
5714 | 5714 | 1109 | 2022-01-30 | 2788 | 8 | 1610 | 0 | 2023-03-13 20:38:18 |
5715 | 5715 | 1109 | 2022-01-30 | 2374 | 1 | 1610 | 0 | 2023-03-13 20:38:18 |
5716 | 5716 | 1109 | 2022-01-30 | 1781 | 1 | 1610 | 0 | 2023-03-13 20:38:18 |
5717 | 5717 | 1109 | 2022-01-30 | 514 | 6 | 1610 | 0 | 2023-03-13 20:38:18 |
5718 | 5718 | 1109 | 2022-01-30 | 1273 | 72 | 1610 | 0 | 2023-03-13 20:38:18 |
5719 | 5719 | 1109 | 2022-01-30 | 2789 | 12 | 1610 | 0 | 2023-03-13 20:38:18 |
5720 | 5720 | 1109 | 2022-01-30 | 725 | 120 | 1610 | 0 | 2023-03-13 20:38:18 |
5721 | 5721 | 1109 | 2022-01-30 | 557 | 5 | 1610 | 0 | 2023-03-13 20:38:18 |
5722 | 5722 | 1109 | 2022-01-30 | 251 | 3 | 1610 | 0 | 2023-03-13 20:38:18 |
5723 | 5723 | 1109 | 2022-01-30 | 107 | 2 | 1610 | 0 | 2023-03-13 20:38:18 |
5707 | 5707 | 1108 | 2022-04-22 | 179 | 27 | 1668 | 0 | 2023-03-13 20:38:18 |
5708 | 5708 | 1108 | 2022-04-22 | 1047 | 8 | 1668 | 0 | 2023-03-13 20:38:18 |
5709 | 5709 | 1108 | 2022-04-22 | 2670 | 5 | 1668 | 0 | 2023-03-13 20:38:18 |
5710 | 5710 | 1108 | 2022-04-22 | 2856 | 41 | 1668 | 0 | 2023-03-13 20:38:18 |
5711 | 5711 | 1108 | 2022-04-22 | 706 | 7 | 1668 | 0 | 2023-03-13 20:38:18 |
5712 | 5712 | 1108 | 2022-04-22 | 199 | 1 | 1668 | 0 | 2023-03-13 20:38:18 |
5713 | 5713 | 1108 | 2022-04-22 | 65 | 1 | 1668 | 0 | 2023-03-13 20:38:18 |
5696 | 5696 | 1107 | 2022-04-03 | 2745 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
5697 | 5697 | 1107 | 2022-04-03 | 921 | 117 | 1531 | 0 | 2023-03-13 20:38:18 |
5698 | 5698 | 1107 | 2022-04-03 | 434 | 18 | 1531 | 0 | 2023-03-13 20:38:18 |
5699 | 5699 | 1107 | 2022-04-03 | 1591 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5700 | 5700 | 1107 | 2022-04-03 | 600 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5701 | 5701 | 1107 | 2022-04-03 | 2659 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5702 | 5702 | 1107 | 2022-04-03 | 403 | 5 | 1531 | 0 | 2023-03-13 20:38:18 |
5703 | 5703 | 1107 | 2022-04-03 | 1970 | 15 | 1531 | 0 | 2023-03-13 20:38:18 |
5704 | 5704 | 1107 | 2022-04-03 | 952 | 1 | 1531 | 0 | 2023-03-13 20:38:18 |
5705 | 5705 | 1107 | 2022-04-03 | 2349 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
5706 | 5706 | 1107 | 2022-04-03 | 1617 | 1 | 1531 | 0 | 2023-03-13 20:38:18 |
5689 | 5689 | 1106 | 2021-11-14 | 2847 | 67 | 1658 | 0 | 2023-03-13 20:38:18 |
5690 | 5690 | 1106 | 2021-11-14 | 1541 | 59 | 1658 | 0 | 2023-03-13 20:38:18 |
5691 | 5691 | 1106 | 2021-11-14 | 1286 | 34 | 1658 | 0 | 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 );