viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
138 rows where seats = 28
This data as json, CSV (advanced)
Suggested facets: election_id, date, party_id, cabinet_id, cabinet_formation, calculation_date (date)
date (date) 132 ✖
- 2003-03-02 2
- 2003-04-10 2
- 2005-04-13 2
- 2010-10-26 2
- 2011-06-27 2
- 2011-07-05 2
- 1919-03-03 1
- 1919-04-17 1
- 1919-08-15 1
- 1920-03-15 1
- 1920-04-26 1
- 1920-05-05 1
- 1921-04-09 1
- 1922-06-02 1
- 1924-04-11 1
- 1924-04-23 1
- 1924-05-04 1
- 1924-06-04 1
- 1924-09-21 1
- 1924-10-18 1
- 1925-01-24 1
- 1926-06-07 1
- 1927-10-17 1
- 1928-01-28 1
- 1928-02-15 1
- 1928-09-21 1
- 1928-10-02 1
- 1928-11-14 1
- 1928-12-10 1
- 1929-05-25 1
- 1929-05-26 1
- 1929-07-01 1
- 1929-08-16 1
- 1930-05-28 1
- 1930-06-07 1
- 1930-07-04 1
- 1931-06-06 1
- 1931-12-02 1
- 1932-10-22 1
- 1933-04-26 1
- 1933-05-26 1
- 1935-07-31 1
- 1935-10-22 1
- 1935-11-04 1
- 1937-10-23 1
- 1939-04-07 1
- 1939-04-26 1
- 1940-03-14 1
- 1940-09-15 1
- 1943-03-23 1
- 1945-03-18 1
- 1945-04-17 1
- 1945-05-05 1
- 1945-06-11 1
- 1946-03-26 1
- 1948-11-15 1
- 1951-07-03 1
- 1951-09-20 1
- 1953-07-09 1
- 1953-11-17 1
- 1966-03-28 1
- 1966-04-07 1
- 1971-06-14 1
- 1971-06-21 1
- 1974-09-30 1
- 1977-05-25 1
- 1977-12-19 1
- 1981-11-08 1
- 1981-12-17 1
- 1987-07-19 1
- 1987-08-17 1
- 1989-06-18 1
- 1989-07-02 1
- 1989-10-11 1
- 1991-10-27 1
- 1991-11-24 1
- 1991-12-23 1
- 1992-03-07 1
- 1992-06-05 1
- 1992-07-11 1
- 1993-02-04 1
- 1993-05-28 1
- 1993-09-13 1
- 1996-10-25 1
- 1999-03-07 1
- 1999-03-25 1
- 2002-01-28 1
- 2002-06-16 1
- 2002-06-17 1
- 2002-09-21 1
- 2002-10-16 1
- 2003-01-22 1
- 2003-02-07 1
- 2003-05-27 1
- 2003-10-19 1
- 2003-12-10 1
- 2006-09-17 1
- 2006-10-05 1
- 2008-09-21 1
- 2008-11-21 1
- 2009-02-10 1
- 2009-03-31 1
- 2009-12-01 1
- 2010-06-12 1
- 2010-07-08 1
- 2011-01-17 1
- 2011-01-24 1
- 2011-02-10 1
- 2011-05-23 1
- 2011-09-29 1
- 2011-10-09 1
- 2011-10-20 1
- 2011-10-23 1
- 2011-11-18 1
- 2011-12-04 1
- 2011-12-14 1
- 2012-01-28 1
- 2012-05-08 1
- 2012-11-19 1
- 2013-03-20 1
- 2014-09-22 1
- 2015-10-25 1
- 2015-11-16 1
- 2017-12-11 1
- 2018-09-09 1
- 2019-01-18 1
- 2019-10-20 1
- 2019-12-11 1
- 2021-07-09 1
- 2021-09-13 1
- 2021-10-14 1
- 2021-11-30 1
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
25 | 25 | 8 | 1971-06-14 | 1003 | 28 | 681 | 0 | 2023-03-13 20:38:18 |
469 | 469 | 101 | 1945-03-18 | 1118 | 28 | 120 | 0 | 2023-03-13 20:38:18 |
873 | 873 | 189 | 1945-06-11 | 296 | 28 | 608 | 1 | 2023-03-13 20:38:18 |
939 | 939 | 205 | 1989-06-18 | 1441 | 28 | 39 | 0 | 2023-03-13 20:38:18 |
952 | 952 | 206 | 2003-10-19 | 531 | 28 | 198 | 0 | 2023-03-13 20:38:18 |
994 | 994 | 211 | 1991-10-27 | 619 | 28 | 75 | 0 | 2023-03-13 20:38:18 |
1033 | 1033 | 218 | 2002-09-21 | 131 | 28 | 699 | 0 | 2023-03-13 20:38:18 |
1106 | 1106 | 239 | 1999-03-07 | 1137 | 28 | 303 | 0 | 2023-03-13 20:38:18 |
1539 | 1539 | 335 | 2003-01-22 | 1409 | 28 | 1105 | 0 | 2023-03-13 20:38:18 |
1821 | 1821 | 403 | 2002-06-16 | 509 | 28 | 711 | 0 | 2023-03-13 20:38:18 |
1832 | 1832 | 404 | 1993-09-13 | 1435 | 28 | 572 | 1 | 2023-03-13 20:38:18 |
1909 | 1909 | 418 | 1991-11-24 | 1029 | 28 | 570 | 1 | 2023-03-13 20:38:18 |
1914 | 1914 | 419 | 1966-03-28 | 984 | 28 | 589 | 0 | 2023-03-13 20:38:18 |
1928 | 1928 | 423 | 2003-03-02 | 428 | 28 | 152 | 0 | 2023-03-13 20:38:18 |
1932 | 1932 | 423 | 2003-03-02 | 1137 | 28 | 152 | 0 | 2023-03-13 20:38:18 |
2148 | 2148 | 480 | 1987-07-19 | 514 | 28 | 734 | 0 | 2023-03-13 20:38:18 |
2264 | 2264 | 501 | 1981-11-08 | 1110 | 28 | 429 | 0 | 2023-03-13 20:38:18 |
2383 | 2383 | 522 | 2008-09-21 | 179 | 28 | 407 | 0 | 2023-03-13 20:38:18 |
2400 | 2400 | 524 | 2010-06-12 | 131 | 28 | 269 | 0 | 2023-03-13 20:38:18 |
2636 | 2636 | 575 | 1951-07-03 | 1118 | 28 | 639 | 0 | 2023-03-13 20:38:18 |
2639 | 2639 | 577 | 1929-07-01 | 1118 | 28 | 1206 | 0 | 2023-03-13 20:38:18 |
2901 | 2901 | 629 | 2006-09-17 | 892 | 28 | 641 | 0 | 2023-03-13 20:38:18 |
2963 | 2963 | 635 | 1977-05-25 | 1409 | 28 | 324 | 1 | 2023-03-13 20:38:18 |
3472 | 3472 | 721 | 2009-02-10 | 1870 | 28 | 1135 | 0 | 2023-03-13 20:38:18 |
3600 | 3600 | 745 | 1937-10-23 | 1912 | 28 | 1018 | 1 | 2023-03-13 20:38:18 |
3683 | 3683 | 766 | 2011-10-09 | 664 | 28 | 164 | 0 | 2023-03-13 20:38:18 |
3785 | 3785 | 778 | 2011-12-04 | 1987 | 28 | 907 | 0 | 2023-03-13 20:38:18 |
3795 | 3795 | 779 | 2011-10-23 | 531 | 28 | 903 | 0 | 2023-03-13 20:38:18 |
4260 | 4260 | 879 | 1929-05-25 | 63 | 28 | 1275 | 0 | 2023-03-13 20:38:18 |
4329 | 4329 | 893 | 1920-04-26 | 590 | 28 | 1481 | 0 | 2023-03-13 20:38:18 |
4340 | 4340 | 895 | 1924-04-11 | 590 | 28 | 1247 | 0 | 2023-03-13 20:38:18 |
4364 | 4364 | 899 | 1935-10-22 | 1605 | 28 | 1243 | 0 | 2023-03-13 20:38:18 |
4381 | 4381 | 901 | 1943-03-23 | 1605 | 28 | 1241 | 0 | 2023-03-13 20:38:18 |
4393 | 4393 | 903 | 1919-03-03 | 1118 | 28 | 1220 | 0 | 2023-03-13 20:38:18 |
4624 | 4624 | 941 | 1933-04-26 | 2539 | 28 | 1258 | 0 | 2023-03-13 20:38:18 |
4720 | 4720 | 957 | 1928-11-14 | 2471 | 28 | 1313 | 0 | 2023-03-13 20:38:18 |
4726 | 4726 | 958 | 1931-12-02 | 2471 | 28 | 1319 | 1 | 2023-03-13 20:38:18 |
4767 | 4767 | 967 | 1924-09-21 | 892 | 28 | 1189 | 0 | 2023-03-13 20:38:18 |
4774 | 4774 | 968 | 1928-09-21 | 892 | 28 | 1186 | 0 | 2023-03-13 20:38:18 |
4793 | 4793 | 971 | 1940-09-15 | 1461 | 28 | 1180 | 1 | 2023-03-13 20:38:18 |
4954 | 4954 | 996 | 2015-10-25 | 2601 | 28 | 1146 | 0 | 2023-03-13 20:38:18 |
5269 | 5269 | 1034 | 1924-05-04 | 2691 | 28 | 1569 | 0 | 2023-03-13 20:38:18 |
5375 | 5375 | 1041 | 2018-09-09 | 882 | 28 | 1587 | 1 | 2023-03-13 20:38:18 |
5507 | 5507 | 1083 | 2019-10-20 | 141 | 28 | 1212 | 0 | 2023-03-13 20:38:18 |
5673 | 5673 | 1104 | 2021-09-13 | 702 | 28 | 1617 | 0 | 2023-03-13 20:38:18 |
6530 | 6530 | 218 | 2003-02-07 | 131 | 28 | 547 | 0 | 2023-03-13 20:38:18 |
6666 | 6666 | 325 | 1993-02-04 | 50 | 28 | 524 | 0 | 2023-03-13 20:38:18 |
6913 | 6913 | 522 | 2009-12-01 | 179 | 28 | 803 | 0 | 2023-03-13 20:38:18 |
6921 | 6921 | 522 | 2010-10-26 | 706 | 28 | 803 | 0 | 2023-03-13 20:38:18 |
6923 | 6923 | 522 | 2010-10-26 | 179 | 28 | 803 | 0 | 2023-03-13 20:38:18 |
6931 | 6931 | 522 | 2011-07-05 | 706 | 28 | 907 | 0 | 2023-03-13 20:38:18 |
6933 | 6933 | 522 | 2011-07-05 | 179 | 28 | 907 | 0 | 2023-03-13 20:38:18 |
6943 | 6943 | 522 | 2011-09-29 | 179 | 28 | 907 | 0 | 2023-03-13 20:38:18 |
6953 | 6953 | 524 | 2011-01-24 | 131 | 28 | 319 | 0 | 2023-03-13 20:38:18 |
6962 | 6962 | 524 | 2011-02-10 | 131 | 28 | 319 | 0 | 2023-03-13 20:38:18 |
6971 | 6971 | 524 | 2011-05-23 | 131 | 28 | 319 | 0 | 2023-03-13 20:38:18 |
9050 | 9050 | 721 | 2011-01-17 | 1870 | 28 | 1032 | 1 | 2023-03-13 20:38:18 |
9063 | 9063 | 721 | 2012-11-19 | 1870 | 28 | 1107 | 0 | 2023-03-13 20:38:18 |
9315 | 9315 | 867 | 1927-10-17 | 1435 | 28 | 1230 | 1 | 2023-03-13 20:38:18 |
9524 | 9524 | 901 | 1945-05-05 | 1605 | 28 | 10 | 1 | 2023-03-13 20:38:18 |
9911 | 9911 | 211 | 1992-07-11 | 619 | 28 | 68 | 1 | 2023-03-13 20:38:18 |
10300 | 10300 | 335 | 2003-05-27 | 1409 | 28 | 124 | 1 | 2023-03-13 20:38:18 |
10302 | 10302 | 101 | 1946-03-26 | 1118 | 28 | 125 | 1 | 2023-03-13 20:38:18 |
10376 | 10376 | 211 | 1991-12-23 | 619 | 28 | 132 | 1 | 2023-03-13 20:38:18 |
10409 | 10409 | 423 | 2003-04-10 | 428 | 28 | 138 | 1 | 2023-03-13 20:38:18 |
10413 | 10413 | 423 | 2003-04-10 | 1137 | 28 | 138 | 1 | 2023-03-13 20:38:18 |
10519 | 10519 | 239 | 2002-01-28 | 1137 | 28 | 152 | 1 | 2023-03-13 20:38:18 |
10830 | 10830 | 575 | 1951-09-20 | 1118 | 28 | 200 | 1 | 2023-03-13 20:38:18 |
11044 | 11044 | 575 | 1953-07-09 | 1118 | 28 | 232 | 1 | 2023-03-13 20:38:18 |
11322 | 11322 | 423 | 2005-04-13 | 428 | 28 | 274 | 1 | 2023-03-13 20:38:18 |
11326 | 11326 | 423 | 2005-04-13 | 1137 | 28 | 274 | 1 | 2023-03-13 20:38:18 |
11485 | 11485 | 8 | 1971-06-21 | 1003 | 28 | 295 | 1 | 2023-03-13 20:38:18 |
11630 | 11630 | 524 | 2010-07-08 | 131 | 28 | 319 | 1 | 2023-03-13 20:38:18 |
12644 | 12644 | 629 | 2006-10-05 | 892 | 28 | 475 | 1 | 2023-03-13 20:38:18 |
12681 | 12681 | 239 | 1999-03-25 | 1137 | 28 | 480 | 1 | 2023-03-13 20:38:18 |
13059 | 13059 | 189 | 1948-11-15 | 296 | 28 | 534 | 1 | 2023-03-13 20:38:18 |
13135 | 13135 | 218 | 2002-10-16 | 131 | 28 | 547 | 1 | 2023-03-13 20:38:18 |
13257 | 13257 | 635 | 1977-12-19 | 1409 | 28 | 563 | 1 | 2023-03-13 20:38:18 |
13536 | 13536 | 211 | 1992-06-05 | 619 | 28 | 605 | 1 | 2023-03-13 20:38:18 |
13633 | 13633 | 418 | 1992-03-07 | 1029 | 28 | 624 | 1 | 2023-03-13 20:38:18 |
13968 | 13968 | 419 | 1966-04-07 | 984 | 28 | 681 | 1 | 2023-03-13 20:38:18 |
14163 | 14163 | 480 | 1987-08-17 | 514 | 28 | 718 | 1 | 2023-03-13 20:38:18 |
14183 | 14183 | 205 | 1989-10-11 | 1441 | 28 | 721 | 1 | 2023-03-13 20:38:18 |
14215 | 14215 | 501 | 1981-12-17 | 1110 | 28 | 724 | 1 | 2023-03-13 20:38:18 |
14258 | 14258 | 211 | 1993-05-28 | 619 | 28 | 730 | 1 | 2023-03-13 20:38:18 |
14320 | 14320 | 575 | 1953-11-17 | 1118 | 28 | 738 | 1 | 2023-03-13 20:38:18 |
14621 | 14621 | 205 | 1989-07-02 | 1441 | 28 | 782 | 1 | 2023-03-13 20:38:18 |
14745 | 14745 | 522 | 2008-11-21 | 179 | 28 | 803 | 1 | 2023-03-13 20:38:18 |
14831 | 14831 | 404 | 1996-10-25 | 1435 | 28 | 813 | 1 | 2023-03-13 20:38:18 |
14848 | 14848 | 101 | 1945-04-17 | 1118 | 28 | 815 | 1 | 2023-03-13 20:38:18 |
14855 | 14855 | 8 | 1974-09-30 | 1003 | 28 | 816 | 1 | 2023-03-13 20:38:18 |
14886 | 14886 | 403 | 2002-06-17 | 509 | 28 | 820 | 1 | 2023-03-13 20:38:18 |
15127 | 15127 | 206 | 2003-12-10 | 531 | 28 | 855 | 1 | 2023-03-13 20:38:18 |
15416 | 15416 | 522 | 2011-06-27 | 706 | 28 | 907 | 1 | 2023-03-13 20:38:18 |
15418 | 15418 | 522 | 2011-06-27 | 179 | 28 | 907 | 1 | 2023-03-13 20:38:18 |
16015 | 16015 | 524 | 2011-10-20 | 131 | 28 | 982 | 1 | 2023-03-13 20:38:18 |
16039 | 16039 | 766 | 2011-11-18 | 664 | 28 | 985 | 1 | 2023-03-13 20:38:18 |
16076 | 16076 | 779 | 2011-12-14 | 531 | 28 | 989 | 1 | 2023-03-13 20:38:18 |
16086 | 16086 | 778 | 2012-01-28 | 1987 | 28 | 990 | 1 | 2023-03-13 20:38:18 |
16209 | 16209 | 745 | 1939-04-07 | 1912 | 28 | 1019 | 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 );