viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 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 |
---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
9388 | 9388 | 1024 | 2022-06-21 | 2155 | 177 | 1667 | 0 | 2023-03-13 20:38:18 |
9389 | 9389 | 1024 | 2022-06-21 | 1436 | 124 | 1667 | 0 | 2023-03-13 20:38:18 |
9390 | 9390 | 1024 | 2022-06-21 | 596 | 106 | 1667 | 0 | 2023-03-13 20:38:18 |
9391 | 9391 | 1024 | 2022-06-21 | 2154 | 31 | 1667 | 0 | 2023-03-13 20:38:18 |
9392 | 9392 | 1024 | 2022-06-21 | 226 | 4 | 1667 | 0 | 2023-03-13 20:38:18 |
9393 | 9393 | 1024 | 2022-06-21 | 382 | 87 | 1667 | 0 | 2023-03-13 20:38:18 |
9394 | 9394 | 1024 | 2022-06-21 | 1030 | 4 | 1667 | 0 | 2023-03-13 20:38:18 |
9395 | 9395 | 1024 | 2022-06-21 | 2153 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9396 | 9396 | 1024 | 2022-06-21 | 2302 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9397 | 9397 | 1024 | 2022-06-21 | 693 | 2 | 1667 | 0 | 2023-03-13 20:38:18 |
9398 | 9398 | 1024 | 2022-06-21 | 465 | 14 | 1667 | 0 | 2023-03-13 20:38:18 |
9399 | 9399 | 1024 | 2022-06-21 | 927 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9400 | 9400 | 1024 | 2022-06-21 | 2671 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9401 | 9401 | 1024 | 2022-06-21 | 2737 | 2 | 1667 | 0 | 2023-03-13 20:38:18 |
9402 | 9402 | 1024 | 2022-06-21 | 2794 | 25 | 1667 | 0 | 2023-03-13 20:38:18 |
9403 | 9403 | 1024 | 2022-06-21 | 2861 | 50 | 1667 | 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 |
5692 | 5692 | 1106 | 2021-11-14 | 1160 | 26 | 1658 | 0 | 2023-03-13 20:38:18 |
5693 | 5693 | 1106 | 2021-11-14 | 2836 | 25 | 1658 | 0 | 2023-03-13 20:38:18 |
5694 | 5694 | 1106 | 2021-11-14 | 57 | 16 | 1658 | 0 | 2023-03-13 20:38:18 |
5695 | 5695 | 1106 | 2021-11-14 | 2640 | 13 | 1658 | 0 | 2023-03-13 20:38:18 |
5660 | 5660 | 1102 | 2021-07-11 | 2836 | 65 | 1657 | 0 | 2023-03-13 20:38:18 |
5661 | 5661 | 1102 | 2021-07-11 | 1541 | 63 | 1657 | 0 | 2023-03-13 20:38:18 |
5662 | 5662 | 1102 | 2021-07-11 | 1160 | 36 | 1657 | 0 | 2023-03-13 20:38:18 |
5663 | 5663 | 1102 | 2021-07-11 | 57 | 34 | 1657 | 0 | 2023-03-13 20:38:18 |
5664 | 5664 | 1102 | 2021-07-11 | 1286 | 29 | 1657 | 0 | 2023-03-13 20:38:18 |
5665 | 5665 | 1102 | 2021-07-11 | 2838 | 13 | 1657 | 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 |
5617 | 5617 | 1097 | 2021-03-17 | 1409 | 34 | 1648 | 0 | 2023-03-13 20:38:18 |
5618 | 5618 | 1097 | 2021-03-17 | 1501 | 17 | 1648 | 0 | 2023-03-13 20:38:18 |
5619 | 5619 | 1097 | 2021-03-17 | 235 | 15 | 1648 | 0 | 2023-03-13 20:38:18 |
5620 | 5620 | 1097 | 2021-03-17 | 345 | 24 | 1648 | 0 | 2023-03-13 20:38:18 |
5621 | 5621 | 1097 | 2021-03-17 | 756 | 8 | 1648 | 0 | 2023-03-13 20:38:18 |
5622 | 5622 | 1097 | 2021-03-17 | 357 | 9 | 1648 | 0 | 2023-03-13 20:38:18 |
5623 | 5623 | 1097 | 2021-03-17 | 742 | 9 | 1648 | 0 | 2023-03-13 20:38:18 |
5624 | 5624 | 1097 | 2021-03-17 | 1206 | 5 | 1648 | 0 | 2023-03-13 20:38:18 |
5625 | 5625 | 1097 | 2021-03-17 | 990 | 6 | 1648 | 0 | 2023-03-13 20:38:18 |
5626 | 5626 | 1097 | 2021-03-17 | 2109 | 1 | 1648 | 0 | 2023-03-13 20:38:18 |
5627 | 5627 | 1097 | 2021-03-17 | 1251 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5628 | 5628 | 1097 | 2021-03-17 | 2641 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5629 | 5629 | 1097 | 2021-03-17 | 2642 | 8 | 1648 | 0 | 2023-03-13 20:38:18 |
5630 | 5630 | 1097 | 2021-03-17 | 2735 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5631 | 5631 | 1097 | 2021-03-17 | 2823 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5632 | 5632 | 1097 | 2021-03-17 | 2824 | 1 | 1648 | 0 | 2023-03-13 20:38:18 |
5633 | 5633 | 1097 | 2021-03-17 | 2288 | 1 | 1648 | 0 | 2023-03-13 20:38:18 |
5634 | 5634 | 1098 | 2021-10-31 | 1193 | 72 | 1647 | 0 | 2023-03-13 20:38:18 |
5635 | 5635 | 1098 | 2021-10-31 | 1540 | 9 | 1647 | 0 | 2023-03-13 20:38:18 |
5636 | 5636 | 1098 | 2021-10-31 | 2657 | 39 | 1647 | 0 | 2023-03-13 20:38:18 |
5637 | 5637 | 1098 | 2021-10-31 | 2826 | 25 | 1647 | 0 | 2023-03-13 20:38:18 |
5638 | 5638 | 1098 | 2021-10-31 | 837 | 23 | 1647 | 0 | 2023-03-13 20:38:18 |
5639 | 5639 | 1098 | 2021-10-31 | 2827 | 5 | 1647 | 0 | 2023-03-13 20:38:18 |
5640 | 5640 | 1098 | 2021-10-31 | 2828 | 3 | 1647 | 0 | 2023-03-13 20:38:18 |
5641 | 5641 | 1100 | 2021-03-23 | 678 | 30 | 1645 | 0 | 2023-03-13 20:38:18 |
5642 | 5642 | 1100 | 2021-03-23 | 2321 | 17 | 1645 | 0 | 2023-03-13 20:38:18 |
5643 | 5643 | 1100 | 2021-03-23 | 788 | 9 | 1645 | 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 );