viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by party_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 |
---|---|---|---|---|---|---|---|---|
20838 | 20838 | 1117 | 2022-12-29 | 2889 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20589 | 20589 | 1116 | 2022-12-15 | 2888 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20583 | 20583 | 1116 | 2022-12-15 | 2887 | 16 | 1684 | 1 | 2023-03-13 20:38:18 |
5384 | 5384 | 1042 | 2018-10-06 | 2878 | 13 | 1591 | 1 | 2023-03-13 20:38:18 |
19856 | 19856 | 1042 | 2019-01-23 | 2878 | 13 | 1592 | 1 | 2023-03-13 20:38:18 |
20598 | 20598 | 1115 | 2022-12-14 | 2876 | 9 | 1685 | 1 | 2023-03-13 20:38:18 |
20596 | 20596 | 1115 | 2022-12-14 | 2875 | 11 | 1685 | 1 | 2023-03-13 20:38:18 |
20828 | 20828 | 1014 | 2022-05-20 | 2862 | 0 | 1673 | 1 | 2023-03-13 20:38:18 |
20831 | 20831 | 1110 | 2022-06-19 | 2862 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20555 | 20555 | 1024 | 2022-07-21 | 2861 | 50 | 1681 | 1 | 2023-03-13 20:38:18 |
5734 | 5734 | 1110 | 2022-06-19 | 2859 | 1 | 1675 | 1 | 2023-03-13 20:38:18 |
5733 | 5733 | 1110 | 2022-06-19 | 2858 | 4 | 1675 | 1 | 2023-03-13 20:38:18 |
20829 | 20829 | 1014 | 2022-05-20 | 2857 | 0 | 1673 | 1 | 2023-03-13 20:38:18 |
20832 | 20832 | 1110 | 2022-06-19 | 2857 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20492 | 20492 | 1108 | 2022-06-01 | 2856 | 41 | 1674 | 1 | 2023-03-13 20:38:18 |
10483 | 10483 | 581 | 1949-09-20 | 2850 | 1 | 147 | 1 | 2023-03-13 20:38:18 |
20371 | 20371 | 1096 | 2021-12-08 | 2850 | 1 | 1661 | 1 | 2023-03-13 20:38:18 |
20359 | 20359 | 1106 | 2021-12-13 | 2847 | 67 | 1660 | 1 | 2023-03-13 20:38:18 |
20519 | 20519 | 1106 | 2022-08-01 | 2847 | 67 | 1678 | 1 | 2023-03-13 20:38:18 |
20352 | 20352 | 1101 | 2021-05-12 | 2838 | 14 | 1657 | 1 | 2023-03-13 20:38:18 |
20358 | 20358 | 1102 | 2021-09-16 | 2838 | 13 | 1658 | 1 | 2023-03-13 20:38:18 |
20348 | 20348 | 1101 | 2021-05-12 | 2836 | 51 | 1657 | 1 | 2023-03-13 20:38:18 |
20353 | 20353 | 1102 | 2021-09-16 | 2836 | 65 | 1658 | 1 | 2023-03-13 20:38:18 |
20363 | 20363 | 1106 | 2021-12-13 | 2836 | 25 | 1660 | 1 | 2023-03-13 20:38:18 |
20523 | 20523 | 1106 | 2022-08-01 | 2836 | 25 | 1678 | 1 | 2023-03-13 20:38:18 |
20305 | 20305 | 1100 | 2021-06-13 | 2835 | 6 | 1650 | 1 | 2023-03-13 20:38:18 |
20516 | 20516 | 1100 | 2022-07-01 | 2835 | 6 | 1677 | 1 | 2023-03-13 20:38:18 |
20266 | 20266 | 1098 | 2021-11-10 | 2828 | 3 | 1646 | 1 | 2023-03-13 20:38:18 |
20265 | 20265 | 1098 | 2021-11-10 | 2827 | 5 | 1646 | 1 | 2023-03-13 20:38:18 |
20263 | 20263 | 1098 | 2021-11-10 | 2826 | 25 | 1646 | 1 | 2023-03-13 20:38:18 |
20441 | 20441 | 1097 | 2022-01-10 | 2824 | 1 | 1669 | 1 | 2023-03-13 20:38:18 |
20440 | 20440 | 1097 | 2022-01-10 | 2823 | 3 | 1669 | 1 | 2023-03-13 20:38:18 |
20729 | 20729 | 782 | 2016-02-11 | 2813 | 0 | 1406 | 1 | 2023-03-13 20:38:18 |
20793 | 20793 | 782 | 2016-12-06 | 2813 | 0 | 1498 | 1 | 2023-03-13 20:38:18 |
20184 | 20184 | 1094 | 2020-07-23 | 2810 | 7 | 1637 | 1 | 2023-03-13 20:38:18 |
20182 | 20182 | 1094 | 2020-07-23 | 2809 | 16 | 1637 | 1 | 2023-03-13 20:38:18 |
20177 | 20177 | 1093 | 2020-12-23 | 2807 | 33 | 1636 | 1 | 2023-03-13 20:38:18 |
20391 | 20391 | 1093 | 2021-11-25 | 2807 | 33 | 1665 | 1 | 2023-03-13 20:38:18 |
20237 | 20237 | 1091 | 2020-11-24 | 2805 | 11 | 1643 | 1 | 2023-03-13 20:38:18 |
19944 | 19944 | 1085 | 2020-01-07 | 2804 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
19880 | 19880 | 1045 | 2019-06-06 | 2801 | 1 | 1596 | 1 | 2023-03-13 20:38:18 |
19966 | 19966 | 1045 | 2019-12-10 | 2801 | 1 | 1607 | 1 | 2023-03-13 20:38:18 |
20072 | 20072 | 1089 | 2020-03-21 | 2796 | 12 | 1625 | 1 | 2023-03-13 20:38:18 |
20399 | 20399 | 1089 | 2021-04-01 | 2796 | 12 | 1666 | 1 | 2023-03-13 20:38:18 |
20531 | 20531 | 1089 | 2022-09-13 | 2796 | 12 | 1679 | 1 | 2023-03-13 20:38:18 |
5562 | 5562 | 1088 | 2020-02-08 | 2795 | 1 | 1641 | 1 | 2023-03-13 20:38:18 |
20231 | 20231 | 1088 | 2020-06-27 | 2795 | 1 | 1642 | 1 | 2023-03-13 20:38:18 |
20414 | 20414 | 1024 | 2021-02-13 | 2794 | 25 | 1667 | 1 | 2023-03-13 20:38:18 |
20554 | 20554 | 1024 | 2022-07-21 | 2794 | 25 | 1681 | 1 | 2023-03-13 20:38:18 |
20563 | 20563 | 1113 | 2022-10-22 | 2794 | 21 | 1682 | 1 | 2023-03-13 20:38:18 |
20819 | 20819 | 1024 | 2019-09-05 | 2794 | 0 | 1603 | 1 | 2023-03-13 20:38:18 |
19943 | 19943 | 1085 | 2020-01-07 | 2792 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
19985 | 19985 | 1082 | 2019-11-15 | 2790 | 6 | 1611 | 1 | 2023-03-13 20:38:18 |
19980 | 19980 | 1081 | 2019-10-26 | 2789 | 1 | 1610 | 1 | 2023-03-13 20:38:18 |
20459 | 20459 | 1109 | 2022-03-30 | 2789 | 12 | 1671 | 1 | 2023-03-13 20:38:18 |
19979 | 19979 | 1081 | 2019-10-26 | 2788 | 1 | 1610 | 1 | 2023-03-13 20:38:18 |
20454 | 20454 | 1109 | 2022-03-30 | 2788 | 8 | 1671 | 1 | 2023-03-13 20:38:18 |
20821 | 20821 | 1090 | 2020-05-17 | 2787 | 0 | 1645 | 1 | 2023-03-13 20:38:18 |
16366 | 16366 | 788 | 2012-12-26 | 2785 | 9 | 1044 | 1 | 2023-03-13 20:38:18 |
19890 | 19890 | 1077 | 2019-06-27 | 2781 | 4 | 1598 | 1 | 2023-03-13 20:38:18 |
20581 | 20581 | 1116 | 2022-12-15 | 2781 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
19885 | 19885 | 1078 | 2019-07-08 | 2780 | 10 | 1597 | 1 | 2023-03-13 20:38:18 |
5561 | 5561 | 1088 | 2020-02-08 | 2776 | 5 | 1641 | 1 | 2023-03-13 20:38:18 |
20230 | 20230 | 1088 | 2020-06-27 | 2776 | 5 | 1642 | 1 | 2023-03-13 20:38:18 |
20185 | 20185 | 1094 | 2020-07-23 | 2772 | 3 | 1637 | 1 | 2023-03-13 20:38:18 |
9366 | 9366 | 1009 | 2017-10-19 | 2763 | 12 | 1614 | 1 | 2023-03-13 20:38:18 |
20017 | 20017 | 1009 | 2019-07-23 | 2763 | 12 | 1615 | 1 | 2023-03-13 20:38:18 |
20240 | 20240 | 1091 | 2020-11-24 | 2763 | 3 | 1643 | 1 | 2023-03-13 20:38:18 |
20443 | 20443 | 1107 | 2022-05-16 | 2745 | 6 | 1670 | 1 | 2023-03-13 20:38:18 |
19886 | 19886 | 1078 | 2019-07-08 | 2742 | 9 | 1597 | 1 | 2023-03-13 20:38:18 |
5616 | 5616 | 1095 | 2021-05-30 | 2741 | 4 | 1659 | 1 | 2023-03-13 20:38:18 |
19984 | 19984 | 1082 | 2019-11-15 | 2740 | 19 | 1611 | 1 | 2023-03-13 20:38:18 |
19270 | 19270 | 1024 | 2018-06-01 | 2737 | 2 | 1532 | 1 | 2023-03-13 20:38:18 |
19928 | 19928 | 1024 | 2019-09-05 | 2737 | 2 | 1603 | 1 | 2023-03-13 20:38:18 |
20413 | 20413 | 1024 | 2021-02-13 | 2737 | 2 | 1667 | 1 | 2023-03-13 20:38:18 |
20553 | 20553 | 1024 | 2022-07-21 | 2737 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20559 | 20559 | 1113 | 2022-10-22 | 2737 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20439 | 20439 | 1097 | 2022-01-10 | 2735 | 3 | 1669 | 1 | 2023-03-13 20:38:18 |
19956 | 19956 | 1086 | 2019-12-13 | 2731 | 1 | 1606 | 1 | 2023-03-13 20:38:18 |
20505 | 20505 | 1086 | 2022-09-06 | 2731 | 1 | 1676 | 1 | 2023-03-13 20:38:18 |
20577 | 20577 | 1086 | 2022-10-25 | 2731 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
5427 | 5427 | 1047 | 2019-04-09 | 2726 | 5 | 1602 | 1 | 2023-03-13 20:38:18 |
5470 | 5470 | 1079 | 2019-09-17 | 2726 | 7 | 1613 | 1 | 2023-03-13 20:38:18 |
20258 | 20258 | 1090 | 2020-05-17 | 2726 | 6 | 1645 | 1 | 2023-03-13 20:38:18 |
20299 | 20299 | 1100 | 2021-06-13 | 2726 | 7 | 1650 | 1 | 2023-03-13 20:38:18 |
20510 | 20510 | 1100 | 2022-07-01 | 2726 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
5422 | 5422 | 1047 | 2019-04-09 | 2725 | 35 | 1602 | 1 | 2023-03-13 20:38:18 |
5464 | 5464 | 1079 | 2019-09-17 | 2725 | 33 | 1613 | 1 | 2023-03-13 20:38:18 |
20253 | 20253 | 1090 | 2020-05-17 | 2725 | 33 | 1645 | 1 | 2023-03-13 20:38:18 |
20298 | 20298 | 1100 | 2021-06-13 | 2725 | 8 | 1650 | 1 | 2023-03-13 20:38:18 |
20509 | 20509 | 1100 | 2022-07-01 | 2725 | 8 | 1677 | 1 | 2023-03-13 20:38:18 |
20605 | 20605 | 1117 | 2022-12-29 | 2725 | 12 | 1686 | 1 | 2023-03-13 20:38:18 |
20815 | 20815 | 1085 | 2020-01-07 | 2724 | 0 | 1605 | 1 | 2023-03-13 20:38:18 |
5416 | 5416 | 1046 | 2019-04-28 | 2723 | 2 | 1601 | 1 | 2023-03-13 20:38:18 |
19936 | 19936 | 1085 | 2020-01-07 | 2723 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
5378 | 5378 | 1042 | 2018-10-06 | 2717 | 16 | 1591 | 1 | 2023-03-13 20:38:18 |
19850 | 19850 | 1042 | 2019-01-23 | 2717 | 16 | 1592 | 1 | 2023-03-13 20:38:18 |
20599 | 20599 | 1115 | 2022-12-14 | 2716 | 10 | 1685 | 1 | 2023-03-13 20:38:18 |
5382 | 5382 | 1042 | 2018-10-06 | 2715 | 16 | 1591 | 1 | 2023-03-13 20:38:18 |
19854 | 19854 | 1042 | 2019-01-23 | 2715 | 16 | 1592 | 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 );