viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by party_id
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id ▼ | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5077 | 5077 | 1009 | 2016-10-09 | 21 | 1 | 1633 | 0 | 2023-03-13 20:38:18 |
5587 | 5587 | 1091 | 2020-10-11 | 21 | 1 | 1615 | 0 | 2023-03-13 20:38:18 |
6831 | 6831 | 462 | 1990-03-10 | 21 | 4 | 0 | 2023-03-13 20:38:18 | |
9363 | 9363 | 1009 | 2017-10-19 | 21 | 1 | 1614 | 1 | 2023-03-13 20:38:18 |
11267 | 11267 | 462 | 1991-01-10 | 21 | 4 | 267 | 1 | 2023-03-13 20:38:18 |
12878 | 12878 | 462 | 1992-07-21 | 21 | 4 | 512 | 1 | 2023-03-13 20:38:18 |
13123 | 13123 | 462 | 1991-01-13 | 21 | 4 | 546 | 1 | 2023-03-13 20:38:18 |
13367 | 13367 | 462 | 1990-03-17 | 21 | 4 | 584 | 1 | 2023-03-13 20:38:18 |
18995 | 18995 | 1009 | 2016-11-22 | 21 | 1 | 1496 | 1 | 2023-03-13 20:38:18 |
20014 | 20014 | 1009 | 2019-07-23 | 21 | 1 | 1615 | 1 | 2023-03-13 20:38:18 |
20242 | 20242 | 1091 | 2020-11-24 | 21 | 1 | 1643 | 1 | 2023-03-13 20:38:18 |
3116 | 3116 | 670 | 1992-09-20 | 25 | 8 | 0 | 2023-03-13 20:38:18 | |
7308 | 7308 | 670 | 1994-09-01 | 25 | 8 | 564 | 0 | 2023-03-13 20:38:18 |
9487 | 9487 | 670 | 1994-11-03 | 25 | 8 | 4 | 1 | 2023-03-13 20:38:18 |
13269 | 13269 | 670 | 1992-10-21 | 25 | 8 | 564 | 1 | 2023-03-13 20:38:18 |
70 | 70 | 21 | 1951-10-28 | 26 | 51 | 556 | 0 | 2023-03-13 20:38:18 |
104 | 104 | 30 | 1955-10-30 | 26 | 50 | 814 | 0 | 2023-03-13 20:38:18 |
494 | 494 | 105 | 1995-10-22 | 26 | 45 | 773 | 0 | 2023-03-13 20:38:18 |
524 | 524 | 108 | 1963-10-27 | 26 | 51 | 623 | 0 | 2023-03-13 20:38:18 |
814 | 814 | 176 | 1971-10-31 | 26 | 49 | 777 | 0 | 2023-03-13 20:38:18 |
943 | 943 | 206 | 2003-10-19 | 26 | 36 | 198 | 0 | 2023-03-13 20:38:18 |
1408 | 1408 | 310 | 2007-10-21 | 26 | 31 | 855 | 0 | 2023-03-13 20:38:18 |
1629 | 1629 | 358 | 1987-10-18 | 26 | 51 | 129 | 0 | 2023-03-13 20:38:18 |
1665 | 1665 | 371 | 1975-10-26 | 26 | 47 | 79 | 0 | 2023-03-13 20:38:18 |
1690 | 1690 | 373 | 1967-10-29 | 26 | 49 | 513 | 0 | 2023-03-13 20:38:18 |
1951 | 1951 | 427 | 1999-10-24 | 26 | 43 | 38 | 0 | 2023-03-13 20:38:18 |
2005 | 2005 | 435 | 1979-10-21 | 26 | 51 | 20 | 0 | 2023-03-13 20:38:18 |
2367 | 2367 | 521 | 1991-10-20 | 26 | 44 | 426 | 0 | 2023-03-13 20:38:18 |
2922 | 2922 | 631 | 1983-10-23 | 26 | 54 | 723 | 0 | 2023-03-13 20:38:18 |
3138 | 3138 | 674 | 1959-10-25 | 26 | 51 | 635 | 0 | 2023-03-13 20:38:18 |
3166 | 3166 | 684 | 1947-10-26 | 26 | 52 | 972 | 0 | 2023-03-13 20:38:18 |
3687 | 3687 | 767 | 1939-10-29 | 26 | 49 | 974 | 0 | 2023-03-13 20:38:18 |
3699 | 3699 | 768 | 1931-10-25 | 26 | 52 | 978 | 0 | 2023-03-13 20:38:18 |
3712 | 3712 | 769 | 1935-10-27 | 26 | 48 | 975 | 0 | 2023-03-13 20:38:18 |
3722 | 3722 | 770 | 1919-10-26 | 26 | 60 | 1464 | 0 | 2023-03-13 20:38:18 |
3732 | 3732 | 771 | 1943-10-31 | 26 | 47 | 973 | 0 | 2023-03-13 20:38:18 |
3736 | 3736 | 772 | 1928-10-28 | 26 | 58 | 979 | 0 | 2023-03-13 20:38:18 |
3744 | 3744 | 773 | 1922-10-29 | 26 | 60 | 981 | 0 | 2023-03-13 20:38:18 |
3753 | 3753 | 774 | 1925-10-25 | 26 | 60 | 980 | 0 | 2023-03-13 20:38:18 |
3794 | 3794 | 779 | 2011-10-23 | 26 | 30 | 903 | 0 | 2023-03-13 20:38:18 |
4825 | 4825 | 977 | 1917-10-28 | 26 | 103 | 1463 | 0 | 2023-03-13 20:38:18 |
4833 | 4833 | 978 | 1914-10-25 | 26 | 112 | 1465 | 1 | 2023-03-13 20:38:18 |
4839 | 4839 | 979 | 1911-10-29 | 26 | 114 | 1458 | 0 | 2023-03-13 20:38:18 |
4845 | 4845 | 980 | 1908-10-25 | 26 | 105 | 1458 | 1 | 2023-03-13 20:38:18 |
4850 | 4850 | 981 | 1905-10-29 | 26 | 104 | 1457 | 1 | 2023-03-13 20:38:18 |
4855 | 4855 | 982 | 1902-10-26 | 26 | 100 | 0 | 2023-03-13 20:38:18 | |
4941 | 4941 | 995 | 2015-10-18 | 26 | 33 | 989 | 0 | 2023-03-13 20:38:18 |
5500 | 5500 | 1083 | 2019-10-20 | 26 | 29 | 1212 | 0 | 2023-03-13 20:38:18 |
6642 | 6642 | 310 | 2008-09-15 | 26 | 31 | 508 | 0 | 2023-03-13 20:38:18 |
9588 | 9588 | 371 | 1975-12-10 | 26 | 47 | 20 | 1 | 2023-03-13 20:38:18 |
9724 | 9724 | 105 | 1995-12-13 | 26 | 45 | 38 | 1 | 2023-03-13 20:38:18 |
9990 | 9990 | 176 | 1971-12-08 | 26 | 49 | 79 | 1 | 2023-03-13 20:38:18 |
10342 | 10342 | 631 | 1983-12-07 | 26 | 54 | 129 | 1 | 2023-03-13 20:38:18 |
10811 | 10811 | 427 | 1999-12-15 | 26 | 43 | 198 | 1 | 2023-03-13 20:38:18 |
12290 | 12290 | 358 | 1987-12-09 | 26 | 51 | 426 | 1 | 2023-03-13 20:38:18 |
12845 | 12845 | 310 | 2007-12-12 | 26 | 31 | 508 | 1 | 2023-03-13 20:38:18 |
12888 | 12888 | 108 | 1963-12-12 | 26 | 51 | 513 | 1 | 2023-03-13 20:38:18 |
13201 | 13201 | 684 | 1947-12-11 | 26 | 52 | 556 | 1 | 2023-03-13 20:38:18 |
13622 | 13622 | 674 | 1959-12-17 | 26 | 51 | 623 | 1 | 2023-03-13 20:38:18 |
13687 | 13687 | 30 | 1955-12-15 | 26 | 50 | 635 | 1 | 2023-03-13 20:38:18 |
14202 | 14202 | 435 | 1979-12-05 | 26 | 51 | 723 | 1 | 2023-03-13 20:38:18 |
14563 | 14563 | 521 | 1991-12-04 | 26 | 44 | 773 | 1 | 2023-03-13 20:38:18 |
14599 | 14599 | 373 | 1967-12-14 | 26 | 49 | 777 | 1 | 2023-03-13 20:38:18 |
14842 | 14842 | 21 | 1951-12-13 | 26 | 51 | 814 | 1 | 2023-03-13 20:38:18 |
15118 | 15118 | 206 | 2003-12-10 | 26 | 36 | 855 | 1 | 2023-03-13 20:38:18 |
15391 | 15391 | 310 | 2008-12-10 | 26 | 31 | 903 | 1 | 2023-03-13 20:38:18 |
15924 | 15924 | 771 | 1943-12-15 | 26 | 47 | 972 | 1 | 2023-03-13 20:38:18 |
15928 | 15928 | 767 | 1939-12-13 | 26 | 49 | 973 | 1 | 2023-03-13 20:38:18 |
15944 | 15944 | 769 | 1935-12-11 | 26 | 48 | 974 | 1 | 2023-03-13 20:38:18 |
15951 | 15951 | 768 | 1934-03-22 | 26 | 52 | 975 | 1 | 2023-03-13 20:38:18 |
15960 | 15960 | 768 | 1931-12-17 | 26 | 52 | 976 | 1 | 2023-03-13 20:38:18 |
15967 | 15967 | 772 | 1928-12-13 | 26 | 58 | 977 | 1 | 2023-03-13 20:38:18 |
15976 | 15976 | 772 | 1929-12-12 | 26 | 58 | 978 | 1 | 2023-03-13 20:38:18 |
15984 | 15984 | 774 | 1925-12-17 | 26 | 60 | 979 | 1 | 2023-03-13 20:38:18 |
15993 | 15993 | 773 | 1922-12-14 | 26 | 60 | 980 | 1 | 2023-03-13 20:38:18 |
16008 | 16008 | 770 | 1919-12-11 | 26 | 60 | 981 | 1 | 2023-03-13 20:38:18 |
16075 | 16075 | 779 | 2011-12-14 | 26 | 30 | 989 | 1 | 2023-03-13 20:38:18 |
17601 | 17601 | 995 | 2015-12-09 | 26 | 33 | 1212 | 1 | 2023-03-13 20:38:18 |
18856 | 18856 | 982 | 1902-12-11 | 26 | 100 | 1456 | 1 | 2023-03-13 20:38:18 |
18861 | 18861 | 979 | 1911-12-14 | 26 | 114 | 1459 | 1 | 2023-03-13 20:38:18 |
18867 | 18867 | 978 | 1917-06-26 | 26 | 112 | 1463 | 1 | 2023-03-13 20:38:18 |
18871 | 18871 | 977 | 1917-12-13 | 26 | 103 | 1464 | 1 | 2023-03-13 20:38:18 |
19994 | 19994 | 1083 | 2019-12-11 | 26 | 29 | 1612 | 1 | 2023-03-13 20:38:18 |
1038 | 1038 | 220 | 1945-10-08 | 27 | 11 | 666 | 0 | 2023-03-13 20:38:18 |
1968 | 1968 | 429 | 1957-10-07 | 27 | 1 | 61 | 1 | 2023-03-13 20:38:18 |
4696 | 4696 | 951 | 1924-10-21 | 27 | 6 | 1232 | 1 | 2023-03-13 20:38:18 |
6472 | 6472 | 167 | 1953-10-12 | 27 | 3 | 545 | 1 | 2023-03-13 20:38:18 |
9319 | 9319 | 867 | 1927-10-17 | 27 | 3 | 1230 | 1 | 2023-03-13 20:38:18 |
9852 | 9852 | 220 | 1945-11-05 | 27 | 11 | 58 | 1 | 2023-03-13 20:38:18 |
10965 | 10965 | 167 | 1955-01-22 | 27 | 3 | 221 | 1 | 2023-03-13 20:38:18 |
17694 | 17694 | 867 | 1928-02-15 | 27 | 3 | 1229 | 1 | 2023-03-13 20:38:18 |
17703 | 17703 | 951 | 1926-03-05 | 27 | 6 | 1231 | 1 | 2023-03-13 20:38:18 |
18090 | 18090 | 867 | 1928-01-28 | 27 | 3 | 1299 | 1 | 2023-03-13 20:38:18 |
20677 | 20677 | 864 | 1945-06-25 | 27 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
228 | 228 | 59 | 2000-10-08 | 28 | 2 | 735 | 0 | 2023-03-13 20:38:18 |
1010 | 1010 | 214 | 2004-10-24 | 28 | 2 | 1634 | 0 | 2023-03-13 20:38:18 |
2026 | 2026 | 439 | 1992-11-15 | 28 | 4 | 512 | 0 | 2023-03-13 20:38:18 |
3019 | 3019 | 646 | 2008-10-12 | 28 | 3 | 579 | 0 | 2023-03-13 20:38:18 |
3860 | 3860 | 786 | 2012-10-14 | 28 | 8 | 1026 | 0 | 2023-03-13 20:38:18 |
5073 | 5073 | 1009 | 2016-10-09 | 28 | 8 | 1633 | 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 );