viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows 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 |
5789 | 5789 | 1116 | 2022-11-01 | 2888 | 14 | 1598 | 0 | 2023-03-13 20:38:18 |
20589 | 20589 | 1116 | 2022-12-15 | 2888 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
5783 | 5783 | 1116 | 2022-11-01 | 2887 | 16 | 1598 | 0 | 2023-03-13 20:38:18 |
9450 | 9450 | 1077 | 2021-01-01 | 2887 | 1 | 1598 | 0 | 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 |
5775 | 5775 | 1115 | 2022-10-01 | 2876 | 9 | 1592 | 0 | 2023-03-13 20:38:18 |
20598 | 20598 | 1115 | 2022-12-14 | 2876 | 9 | 1685 | 1 | 2023-03-13 20:38:18 |
5773 | 5773 | 1115 | 2022-10-01 | 2875 | 11 | 1592 | 0 | 2023-03-13 20:38:18 |
20596 | 20596 | 1115 | 2022-12-14 | 2875 | 11 | 1685 | 1 | 2023-03-13 20:38:18 |
5770 | 5770 | 1114 | 2022-10-02 | 2871 | 12 | 1678 | 0 | 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 |
9403 | 9403 | 1024 | 2022-06-21 | 2861 | 50 | 1667 | 0 | 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 |
5710 | 5710 | 1108 | 2022-04-22 | 2856 | 41 | 1668 | 0 | 2023-03-13 20:38:18 |
20492 | 20492 | 1108 | 2022-06-01 | 2856 | 41 | 1674 | 1 | 2023-03-13 20:38:18 |
7128 | 7128 | 581 | 1949-08-14 | 2850 | 1 | 1578 | 0 | 2023-03-13 20:38:18 |
9456 | 9456 | 1096 | 2021-09-26 | 2850 | 1 | 1528 | 0 | 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 |
5689 | 5689 | 1106 | 2021-11-14 | 2847 | 67 | 1658 | 0 | 2023-03-13 20:38:18 |
5765 | 5765 | 1114 | 2022-10-02 | 2847 | 53 | 1678 | 0 | 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 |
5659 | 5659 | 1101 | 2021-04-04 | 2838 | 14 | 1505 | 0 | 2023-03-13 20:38:18 |
5665 | 5665 | 1102 | 2021-07-11 | 2838 | 13 | 1657 | 0 | 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 |
5655 | 5655 | 1101 | 2021-04-04 | 2836 | 51 | 1505 | 0 | 2023-03-13 20:38:18 |
5660 | 5660 | 1102 | 2021-07-11 | 2836 | 65 | 1657 | 0 | 2023-03-13 20:38:18 |
5693 | 5693 | 1106 | 2021-11-14 | 2836 | 25 | 1658 | 0 | 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 |
5651 | 5651 | 1100 | 2021-03-23 | 2835 | 6 | 1645 | 0 | 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 |
5640 | 5640 | 1098 | 2021-10-31 | 2828 | 3 | 1647 | 0 | 2023-03-13 20:38:18 |
20266 | 20266 | 1098 | 2021-11-10 | 2828 | 3 | 1646 | 1 | 2023-03-13 20:38:18 |
5639 | 5639 | 1098 | 2021-10-31 | 2827 | 5 | 1647 | 0 | 2023-03-13 20:38:18 |
20265 | 20265 | 1098 | 2021-11-10 | 2827 | 5 | 1646 | 1 | 2023-03-13 20:38:18 |
5637 | 5637 | 1098 | 2021-10-31 | 2826 | 25 | 1647 | 0 | 2023-03-13 20:38:18 |
20263 | 20263 | 1098 | 2021-11-10 | 2826 | 25 | 1646 | 1 | 2023-03-13 20:38:18 |
5632 | 5632 | 1097 | 2021-03-17 | 2824 | 1 | 1648 | 0 | 2023-03-13 20:38:18 |
20441 | 20441 | 1097 | 2022-01-10 | 2824 | 1 | 1669 | 1 | 2023-03-13 20:38:18 |
5631 | 5631 | 1097 | 2021-03-17 | 2823 | 3 | 1648 | 0 | 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 |
5604 | 5604 | 1094 | 2020-07-05 | 2810 | 7 | 1512 | 0 | 2023-03-13 20:38:18 |
20184 | 20184 | 1094 | 2020-07-23 | 2810 | 7 | 1637 | 1 | 2023-03-13 20:38:18 |
5602 | 5602 | 1094 | 2020-07-05 | 2809 | 16 | 1512 | 0 | 2023-03-13 20:38:18 |
20182 | 20182 | 1094 | 2020-07-23 | 2809 | 16 | 1637 | 1 | 2023-03-13 20:38:18 |
5597 | 5597 | 1093 | 2020-12-06 | 2807 | 33 | 1626 | 0 | 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 |
5582 | 5582 | 1091 | 2020-10-11 | 2805 | 11 | 1615 | 0 | 2023-03-13 20:38:18 |
20237 | 20237 | 1091 | 2020-11-24 | 2805 | 11 | 1643 | 1 | 2023-03-13 20:38:18 |
5533 | 5533 | 1085 | 2019-11-10 | 2804 | 2 | 1601 | 0 | 2023-03-13 20:38:18 |
19944 | 19944 | 1085 | 2020-01-07 | 2804 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
5406 | 5406 | 1045 | 2019-04-14 | 2801 | 1 | 1510 | 0 | 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 |
5569 | 5569 | 1089 | 2020-02-29 | 2796 | 12 | 1529 | 0 | 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 |
5759 | 5759 | 1113 | 2022-09-25 | 2794 | 21 | 1681 | 0 | 2023-03-13 20:38:18 |
9387 | 9387 | 1024 | 2019-09-17 | 2794 | 25 | 1603 | 0 | 2023-03-13 20:38:18 |
9402 | 9402 | 1024 | 2022-06-21 | 2794 | 25 | 1667 | 0 | 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 |
5532 | 5532 | 1085 | 2019-11-10 | 2792 | 2 | 1601 | 0 | 2023-03-13 20:38:18 |
19943 | 19943 | 1085 | 2020-01-07 | 2792 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
5491 | 5491 | 1082 | 2019-10-13 | 2790 | 6 | 1526 | 0 | 2023-03-13 20:38:18 |
19985 | 19985 | 1082 | 2019-11-15 | 2790 | 6 | 1611 | 1 | 2023-03-13 20:38:18 |
5486 | 5486 | 1081 | 2019-10-06 | 2789 | 1 | 1198 | 0 | 2023-03-13 20:38:18 |
5719 | 5719 | 1109 | 2022-01-30 | 2789 | 12 | 1610 | 0 | 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 |
5485 | 5485 | 1081 | 2019-10-06 | 2788 | 1 | 1198 | 0 | 2023-03-13 20:38:18 |
5714 | 5714 | 1109 | 2022-01-30 | 2788 | 8 | 1610 | 0 | 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 |
3878 | 3878 | 788 | 2012-12-16 | 2785 | 9 | 969 | 0 | 2023-03-13 20:38:18 |
9135 | 9135 | 788 | 2012-12-27 | 2785 | 9 | 1044 | 0 | 2023-03-13 20:38:18 |
16366 | 16366 | 788 | 2012-12-26 | 2785 | 9 | 1044 | 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 );