viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: cabinet_formation
date (date) >30 ✖
- 1999-12-21 43
- 2002-07-30 31
- 1996-03-11 29
- 1996-01-11 28
- 1999-03-25 26
- 2019-09-17 26
- 2022-11-01 26
- 1933-01-31 25
- 1977-02-15 25
- 1999-07-06 25
- 2020-01-07 25
- 1958-07-01 24
- 2017-03-15 24
- 1970-05-14 23
- 1991-10-20 23
- 1993-01-12 23
- 1996-10-20 23
- 2006-04-09 23
- 2011-12-04 23
- 1925-10-29 22
- 1968-01-23 22
- 2008-09-21 22
- 1935-06-07 21
- 1959-12-17 21
- 1995-01-17 21
- 2012-06-17 21
- 2016-12-12 21
- 1981-05-19 20
- 1991-10-27 20
- 1991-12-23 20
- …
calculation_date (date) 1 ✖
- 2023-03-13 20,841
Link | rowid ▲ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
20841 | 20841 | 1117 | 2022-12-29 | 249 | 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 |
20839 | 20839 | 1117 | 2022-12-29 | 2322 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20838 | 20838 | 1117 | 2022-12-29 | 2889 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20837 | 20837 | 1115 | 2022-12-14 | 2366 | 0 | 1685 | 1 | 2023-03-13 20:38:18 |
20836 | 20836 | 1113 | 2022-10-22 | 1552 | 0 | 1682 | 1 | 2023-03-13 20:38:18 |
20835 | 20835 | 1024 | 2022-07-21 | 2001 | 0 | 1681 | 1 | 2023-03-13 20:38:18 |
20834 | 20834 | 1089 | 2022-09-13 | 1359 | 0 | 1679 | 1 | 2023-03-13 20:38:18 |
20833 | 20833 | 1106 | 2022-08-01 | 133 | 0 | 1678 | 1 | 2023-03-13 20:38:18 |
20832 | 20832 | 1110 | 2022-06-19 | 2857 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20831 | 20831 | 1110 | 2022-06-19 | 2862 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20830 | 20830 | 1110 | 2022-06-19 | 509 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20829 | 20829 | 1014 | 2022-05-20 | 2857 | 0 | 1673 | 1 | 2023-03-13 20:38:18 |
20828 | 20828 | 1014 | 2022-05-20 | 2862 | 0 | 1673 | 1 | 2023-03-13 20:38:18 |
20827 | 20827 | 1085 | 2020-01-07 | 118 | 0 | 1605 | 1 | 2023-03-13 20:38:18 |
20826 | 20826 | 1107 | 2022-05-16 | 437 | 0 | 1670 | 1 | 2023-03-13 20:38:18 |
20825 | 20825 | 1024 | 2021-02-13 | 2001 | 0 | 1667 | 1 | 2023-03-13 20:38:18 |
20824 | 20824 | 1102 | 2021-09-16 | 133 | 0 | 1658 | 1 | 2023-03-13 20:38:18 |
20823 | 20823 | 1101 | 2021-05-12 | 133 | 0 | 1657 | 1 | 2023-03-13 20:38:18 |
20822 | 20822 | 1090 | 2020-05-17 | 214 | 0 | 1645 | 1 | 2023-03-13 20:38:18 |
20821 | 20821 | 1090 | 2020-05-17 | 2787 | 0 | 1645 | 1 | 2023-03-13 20:38:18 |
20820 | 20820 | 1088 | 2020-02-08 | 2622 | 0 | 1641 | 1 | 2023-03-13 20:38:18 |
20819 | 20819 | 1024 | 2019-09-05 | 2794 | 0 | 1603 | 1 | 2023-03-13 20:38:18 |
20818 | 20818 | 1079 | 2019-09-17 | 214 | 0 | 1613 | 1 | 2023-03-13 20:38:18 |
20817 | 20817 | 1079 | 2019-09-17 | 2410 | 0 | 1613 | 1 | 2023-03-13 20:38:18 |
20816 | 20816 | 1080 | 2019-09-29 | 272 | 0 | 1608 | 1 | 2023-03-13 20:38:18 |
20815 | 20815 | 1085 | 2020-01-07 | 2724 | 0 | 1605 | 1 | 2023-03-13 20:38:18 |
20814 | 20814 | 815 | 2013-03-18 | 1816 | 0 | 1134 | 1 | 2023-03-13 20:38:18 |
20813 | 20813 | 1019 | 2019-06-03 | 272 | 0 | 1600 | 1 | 2023-03-13 20:38:18 |
20812 | 20812 | 1024 | 2019-09-05 | 2001 | 0 | 1603 | 1 | 2023-03-13 20:38:18 |
20811 | 20811 | 1047 | 2019-04-09 | 214 | 0 | 1602 | 1 | 2023-03-13 20:38:18 |
20810 | 20810 | 1042 | 2019-01-23 | 2392 | 0 | 1592 | 1 | 2023-03-13 20:38:18 |
20809 | 20809 | 1039 | 1932-12-03 | 610 | 0 | 1577 | 1 | 2023-03-13 20:38:18 |
20808 | 20808 | 1039 | 1932-12-03 | 2709 | 0 | 1577 | 1 | 2023-03-13 20:38:18 |
20807 | 20807 | 1038 | 1932-09-12 | 610 | 0 | 1580 | 1 | 2023-03-13 20:38:18 |
20806 | 20806 | 1037 | 1932-06-02 | 610 | 0 | 1579 | 1 | 2023-03-13 20:38:18 |
20805 | 20805 | 1035 | 1926-01-20 | 610 | 0 | 1573 | 1 | 2023-03-13 20:38:18 |
20804 | 20804 | 1035 | 1925-10-29 | 610 | 0 | 1572 | 1 | 2023-03-13 20:38:18 |
20803 | 20803 | 1035 | 1925-01-16 | 610 | 0 | 1571 | 1 | 2023-03-13 20:38:18 |
20802 | 20802 | 1028 | 1929-09-26 | 272 | 0 | 1549 | 1 | 2023-03-13 20:38:18 |
20801 | 20801 | 1026 | 1922-01-27 | 272 | 0 | 1540 | 1 | 2023-03-13 20:38:18 |
20800 | 20800 | 1026 | 1921-06-21 | 272 | 0 | 1539 | 1 | 2023-03-13 20:38:18 |
20799 | 20799 | 1024 | 2018-06-01 | 2001 | 0 | 1532 | 1 | 2023-03-13 20:38:18 |
20798 | 20798 | 1030 | 1920-07-07 | 2674 | 0 | 1537 | 1 | 2023-03-13 20:38:18 |
20797 | 20797 | 782 | 2017-06-14 | 2643 | 0 | 1508 | 1 | 2023-03-13 20:38:18 |
20796 | 20796 | 782 | 2017-06-14 | 509 | 0 | 1508 | 1 | 2023-03-13 20:38:18 |
20795 | 20795 | 840 | 2017-01-25 | 423 | 0 | 1503 | 1 | 2023-03-13 20:38:18 |
20794 | 20794 | 840 | 2017-01-25 | 982 | 0 | 1503 | 1 | 2023-03-13 20:38:18 |
20793 | 20793 | 782 | 2016-12-06 | 2813 | 0 | 1498 | 1 | 2023-03-13 20:38:18 |
20792 | 20792 | 1004 | 2016-05-22 | 491 | 0 | 1492 | 1 | 2023-03-13 20:38:18 |
20791 | 20791 | 892 | 1920-04-05 | 1128 | 0 | 1481 | 1 | 2023-03-13 20:38:18 |
20790 | 20790 | 892 | 1920-03-30 | 1128 | 0 | 1480 | 1 | 2023-03-13 20:38:18 |
20789 | 20789 | 247 | 1975-04-25 | 729 | 0 | 1477 | 1 | 2023-03-13 20:38:18 |
20788 | 20788 | 934 | 1932-04-11 | 2140 | 0 | 1451 | 1 | 2023-03-13 20:38:18 |
20787 | 20787 | 923 | 1923-10-27 | 2561 | 0 | 1426 | 1 | 2023-03-13 20:38:18 |
20786 | 20786 | 983 | 1940-06-16 | 2617 | 0 | 1416 | 1 | 2023-03-13 20:38:18 |
20785 | 20785 | 983 | 1940-06-16 | 947 | 0 | 1416 | 1 | 2023-03-13 20:38:18 |
20784 | 20784 | 983 | 1940-03-22 | 2617 | 0 | 1415 | 1 | 2023-03-13 20:38:18 |
20783 | 20783 | 983 | 1940-03-22 | 2587 | 0 | 1415 | 1 | 2023-03-13 20:38:18 |
20782 | 20782 | 985 | 1932-01-14 | 2583 | 0 | 1414 | 1 | 2023-03-13 20:38:18 |
20781 | 20781 | 988 | 1913-01-21 | 401 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
20780 | 20780 | 988 | 1913-01-21 | 2587 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
20779 | 20779 | 988 | 1911-06-27 | 2587 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
20778 | 20778 | 988 | 1910-05-08 | 2587 | 0 | 1412 | 1 | 2023-03-13 20:38:18 |
20777 | 20777 | 988 | 1910-05-08 | 401 | 0 | 1412 | 1 | 2023-03-13 20:38:18 |
20776 | 20776 | 983 | 1939-09-13 | 2587 | 0 | 1302 | 1 | 2023-03-13 20:38:18 |
20775 | 20775 | 983 | 1939-05-11 | 2585 | 0 | 1303 | 1 | 2023-03-13 20:38:18 |
20774 | 20774 | 983 | 1939-05-11 | 2587 | 0 | 1303 | 1 | 2023-03-13 20:38:18 |
20773 | 20773 | 989 | 1914-08-26 | 2587 | 0 | 1401 | 1 | 2023-03-13 20:38:18 |
20772 | 20772 | 984 | 1935-06-07 | 2618 | 0 | 1328 | 1 | 2023-03-13 20:38:18 |
20771 | 20771 | 984 | 1935-06-01 | 2618 | 0 | 1329 | 1 | 2023-03-13 20:38:18 |
20770 | 20770 | 984 | 1934-02-09 | 2618 | 0 | 1331 | 1 | 2023-03-13 20:38:18 |
20769 | 20769 | 984 | 1933-11-26 | 2617 | 0 | 1333 | 1 | 2023-03-13 20:38:18 |
20768 | 20768 | 984 | 1933-10-26 | 2617 | 0 | 1334 | 1 | 2023-03-13 20:38:18 |
20767 | 20767 | 984 | 1933-01-31 | 2617 | 0 | 1335 | 1 | 2023-03-13 20:38:18 |
20766 | 20766 | 984 | 1932-12-18 | 2617 | 0 | 1336 | 1 | 2023-03-13 20:38:18 |
20765 | 20765 | 984 | 1932-06-03 | 2617 | 0 | 1337 | 1 | 2023-03-13 20:38:18 |
20764 | 20764 | 983 | 1938-04-12 | 2583 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20763 | 20763 | 983 | 1938-04-12 | 2585 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20762 | 20762 | 983 | 1938-04-12 | 2587 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20761 | 20761 | 984 | 1935-06-07 | 947 | 0 | 1328 | 1 | 2023-03-13 20:38:18 |
20760 | 20760 | 985 | 1932-02-20 | 2583 | 0 | 1338 | 1 | 2023-03-13 20:38:18 |
20759 | 20759 | 985 | 1931-01-27 | 2583 | 0 | 1340 | 1 | 2023-03-13 20:38:18 |
20758 | 20758 | 985 | 1930-03-02 | 2583 | 0 | 1342 | 1 | 2023-03-13 20:38:18 |
20757 | 20757 | 991 | 1926-07-23 | 2585 | 0 | 1347 | 1 | 2023-03-13 20:38:18 |
20756 | 20756 | 991 | 1926-07-23 | 2594 | 0 | 1347 | 1 | 2023-03-13 20:38:18 |
20755 | 20755 | 991 | 1926-07-19 | 2585 | 0 | 1348 | 1 | 2023-03-13 20:38:18 |
20754 | 20754 | 991 | 1926-07-19 | 2594 | 0 | 1348 | 1 | 2023-03-13 20:38:18 |
20753 | 20753 | 991 | 1925-11-28 | 2585 | 0 | 1350 | 1 | 2023-03-13 20:38:18 |
20752 | 20752 | 991 | 1925-11-28 | 2594 | 0 | 1350 | 1 | 2023-03-13 20:38:18 |
20751 | 20751 | 991 | 1925-04-17 | 2594 | 0 | 1351 | 1 | 2023-03-13 20:38:18 |
20750 | 20750 | 991 | 1924-06-14 | 2594 | 0 | 1352 | 1 | 2023-03-13 20:38:18 |
20749 | 20749 | 990 | 1920-02-18 | 947 | 0 | 1357 | 1 | 2023-03-13 20:38:18 |
20748 | 20748 | 990 | 1920-01-20 | 947 | 0 | 1358 | 1 | 2023-03-13 20:38:18 |
20747 | 20747 | 989 | 1917-11-16 | 2587 | 0 | 1359 | 1 | 2023-03-13 20:38:18 |
20746 | 20746 | 989 | 1917-03-20 | 2587 | 0 | 1404 | 1 | 2023-03-13 20:38:18 |
20745 | 20745 | 989 | 1915-10-29 | 2593 | 0 | 1402 | 1 | 2023-03-13 20:38:18 |
20744 | 20744 | 989 | 1914-06-13 | 2587 | 0 | 1400 | 1 | 2023-03-13 20:38:18 |
20743 | 20743 | 989 | 1914-06-09 | 2587 | 0 | 1399 | 1 | 2023-03-13 20:38:18 |
20742 | 20742 | 988 | 1913-12-22 | 2587 | 0 | 1398 | 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 );