viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
291 rows where seats = 20
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 2006-07-04 3
- 1971-11-07 2
- 1972-01-21 2
- 1973-01-26 2
- 1980-10-18 2
- 2006-06-17 2
- 1902-05-25 1
- 1902-10-26 1
- 1902-12-11 1
- 1910-05-20 1
- 1910-07-05 1
- 1912-10-21 1
- 1913-01-31 1
- 1914-05-24 1
- 1915-10-21 1
- 1917-10-28 1
- 1917-12-13 1
- 1918-06-01 1
- 1918-11-21 1
- 1920-06-06 1
- 1920-06-26 1
- 1921-02-20 1
- 1921-05-10 1
- 1921-10-26 1
- 1922-01-31 1
- 1922-03-31 1
- 1922-07-05 1
- 1922-09-18 1
- 1922-11-19 1
- 1922-11-22 1
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
38 | 38 | 15 | 1999-03-21 | 1292 | 20 | 100 | 0 | 2023-03-13 20:38:18 |
95 | 95 | 27 | 1998-06-20 | 1245 | 20 | 76 | 0 | 2023-03-13 20:38:18 |
121 | 121 | 35 | 1946-06-30 | 1342 | 20 | 703 | 1 | 2023-03-13 20:38:18 |
126 | 126 | 36 | 2009-04-25 | 1006 | 20 | 651 | 1 | 2023-03-13 20:38:18 |
272 | 272 | 64 | 1973-12-04 | 211 | 20 | 320 | 0 | 2023-03-13 20:38:18 |
278 | 278 | 65 | 1972-05-07 | 487 | 20 | 398 | 0 | 2023-03-13 20:38:18 |
437 | 437 | 97 | 1966-11-22 | 1644 | 20 | 825 | 1 | 2023-03-13 20:38:18 |
652 | 652 | 142 | 1936-07-01 | 1118 | 20 | 1201 | 0 | 2023-03-13 20:38:18 |
737 | 737 | 161 | 1959-10-08 | 1017 | 20 | 404 | 0 | 2023-03-13 20:38:18 |
803 | 803 | 175 | 1982-09-19 | 882 | 20 | 142 | 0 | 2023-03-13 20:38:18 |
818 | 818 | 178 | 2003-05-10 | 1006 | 20 | 177 | 0 | 2023-03-13 20:38:18 |
822 | 822 | 179 | 1981-12-08 | 1605 | 20 | 379 | 0 | 2023-03-13 20:38:18 |
850 | 850 | 184 | 1968-03-31 | 290 | 20 | 353 | 0 | 2023-03-13 20:38:18 |
878 | 878 | 190 | 2007-05-24 | 318 | 20 | 179 | 0 | 2023-03-13 20:38:18 |
894 | 894 | 192 | 2006-06-17 | 1072 | 20 | 185 | 0 | 2023-03-13 20:38:18 |
897 | 897 | 192 | 2006-06-17 | 559 | 20 | 185 | 0 | 2023-03-13 20:38:18 |
902 | 902 | 194 | 2006-04-09 | 1426 | 20 | 188 | 0 | 2023-03-13 20:38:18 |
1005 | 1005 | 214 | 2004-10-24 | 1277 | 20 | 1634 | 0 | 2023-03-13 20:38:18 |
1025 | 1025 | 217 | 1950-06-04 | 63 | 20 | 746 | 0 | 2023-03-13 20:38:18 |
1030 | 1030 | 218 | 2002-09-21 | 559 | 20 | 699 | 0 | 2023-03-13 20:38:18 |
1036 | 1036 | 220 | 1945-10-08 | 647 | 20 | 666 | 0 | 2023-03-13 20:38:18 |
1094 | 1094 | 237 | 2000-06-25 | 1540 | 20 | 211 | 0 | 2023-03-13 20:38:18 |
1115 | 1115 | 242 | 1979-10-23 | 978 | 20 | 824 | 0 | 2023-03-13 20:38:18 |
1217 | 1217 | 260 | 2002-10-05 | 811 | 20 | 23 | 0 | 2023-03-13 20:38:18 |
1259 | 1259 | 269 | 1930-10-01 | 585 | 20 | 1204 | 0 | 2023-03-13 20:38:18 |
1271 | 1271 | 275 | 1978-06-25 | 1342 | 20 | 849 | 0 | 2023-03-13 20:38:18 |
1415 | 1415 | 310 | 2007-10-21 | 141 | 20 | 855 | 0 | 2023-03-13 20:38:18 |
1513 | 1513 | 330 | 1996-05-26 | 1575 | 20 | 911 | 1 | 2023-03-13 20:38:18 |
1517 | 1517 | 332 | 1995-05-21 | 1029 | 20 | 624 | 0 | 2023-03-13 20:38:18 |
1561 | 1561 | 339 | 2001-05-27 | 572 | 20 | 910 | 1 | 2023-03-13 20:38:18 |
1564 | 1564 | 340 | 1927-07-01 | 1292 | 20 | 1208 | 0 | 2023-03-13 20:38:18 |
1570 | 1570 | 342 | 1991-05-19 | 1575 | 20 | 912 | 1 | 2023-03-13 20:38:18 |
1783 | 1783 | 393 | 1959-06-28 | 1342 | 20 | 351 | 1 | 2023-03-13 20:38:18 |
1791 | 1791 | 396 | 1985-10-13 | 1192 | 20 | 724 | 0 | 2023-03-13 20:38:18 |
1809 | 1809 | 401 | 2007-06-10 | 1378 | 20 | 886 | 1 | 2023-03-13 20:38:18 |
1905 | 1905 | 418 | 1991-11-24 | 454 | 20 | 570 | 1 | 2023-03-13 20:38:18 |
1923 | 1923 | 420 | 1977-04-17 | 290 | 20 | 451 | 0 | 2023-03-13 20:38:18 |
1939 | 1939 | 425 | 1961-03-26 | 63 | 20 | 144 | 0 | 2023-03-13 20:38:18 |
1965 | 1965 | 428 | 1988-09-18 | 1154 | 20 | 220 | 1 | 2023-03-13 20:38:18 |
2072 | 2072 | 463 | 2002-04-21 | 1426 | 20 | 827 | 0 | 2023-03-13 20:38:18 |
2127 | 2127 | 473 | 1979-09-16 | 882 | 20 | 587 | 0 | 2023-03-13 20:38:18 |
2263 | 2263 | 501 | 1981-11-08 | 290 | 20 | 429 | 0 | 2023-03-13 20:38:18 |
2332 | 2332 | 512 | 2010-09-19 | 1546 | 20 | 854 | 1 | 2023-03-13 20:38:18 |
2344 | 2344 | 514 | 1992-04-09 | 659 | 20 | 678 | 1 | 2023-03-13 20:38:18 |
2394 | 2394 | 523 | 1973-09-09 | 1538 | 20 | 822 | 0 | 2023-03-13 20:38:18 |
2630 | 2630 | 573 | 1958-06-01 | 63 | 20 | 745 | 0 | 2023-03-13 20:38:18 |
2663 | 2663 | 580 | 1969-09-07 | 702 | 20 | 657 | 1 | 2023-03-13 20:38:18 |
2701 | 2701 | 591 | 1971-11-07 | 1110 | 20 | 586 | 0 | 2023-03-13 20:38:18 |
2704 | 2704 | 591 | 1971-11-07 | 1192 | 20 | 586 | 0 | 2023-03-13 20:38:18 |
2776 | 2776 | 604 | 1979-06-03 | 242 | 20 | 638 | 0 | 2023-03-13 20:38:18 |
2805 | 2805 | 607 | 2008-09-28 | 1429 | 20 | 583 | 0 | 2023-03-13 20:38:18 |
2849 | 2849 | 618 | 2005-06-25 | 784 | 20 | 575 | 0 | 2023-03-13 20:38:18 |
2860 | 2860 | 620 | 1994-05-29 | 921 | 20 | 13 | 0 | 2023-03-13 20:38:18 |
3033 | 3033 | 650 | 1997-06-02 | 794 | 20 | 785 | 0 | 2023-03-13 20:38:18 |
3248 | 3248 | 698 | 2011-02-25 | 280 | 20 | 173 | 0 | 2023-03-13 20:38:18 |
3267 | 3267 | 701 | 2011-05-22 | 1575 | 20 | 921 | 1 | 2023-03-13 20:38:18 |
3296 | 3296 | 705 | 1951-07-30 | 1472 | 20 | 1137 | 0 | 2023-03-13 20:38:18 |
3552 | 3552 | 735 | 1969-10-25 | 184 | 20 | 795 | 0 | 2023-03-13 20:38:18 |
3555 | 3555 | 736 | 1980-10-18 | 184 | 20 | 421 | 0 | 2023-03-13 20:38:18 |
3581 | 3581 | 741 | 1963-11-30 | 184 | 20 | 288 | 0 | 2023-03-13 20:38:18 |
3653 | 3653 | 759 | 1972-12-02 | 184 | 20 | 671 | 0 | 2023-03-13 20:38:18 |
3675 | 3675 | 765 | 2011-09-17 | 1666 | 20 | 882 | 0 | 2023-03-13 20:38:18 |
3805 | 3805 | 780 | 1942-10-19 | 1342 | 20 | 1434 | 0 | 2023-03-13 20:38:18 |
3839 | 3839 | 784 | 2012-06-17 | 2091 | 20 | 1039 | 0 | 2023-03-13 20:38:18 |
3999 | 3999 | 807 | 2007-07-22 | 2305 | 20 | 1077 | 0 | 2023-03-13 20:38:18 |
4048 | 4048 | 816 | 2014-05-25 | 915 | 20 | 1140 | 1 | 2023-03-13 20:38:18 |
4171 | 4171 | 859 | 1926-09-14 | 2566 | 20 | 1168 | 0 | 2023-03-13 20:38:18 |
4212 | 4212 | 869 | 1902-05-25 | 63 | 20 | 1376 | 1 | 2023-03-13 20:38:18 |
4239 | 4239 | 875 | 1914-05-24 | 63 | 20 | 1283 | 1 | 2023-03-13 20:38:18 |
4317 | 4317 | 890 | 1910-05-20 | 211 | 20 | 1361 | 0 | 2023-03-13 20:38:18 |
4341 | 4341 | 895 | 1924-04-11 | 211 | 20 | 1247 | 0 | 2023-03-13 20:38:18 |
4514 | 4514 | 926 | 1933-07-16 | 1342 | 20 | 1431 | 0 | 2023-03-13 20:38:18 |
4518 | 4518 | 927 | 1934-06-24 | 1342 | 20 | 1431 | 0 | 2023-03-13 20:38:18 |
4527 | 4527 | 929 | 1942-07-05 | 1455 | 20 | 1434 | 0 | 2023-03-13 20:38:18 |
4593 | 4593 | 938 | 1922-07-05 | 1451 | 20 | 1262 | 0 | 2023-03-13 20:38:18 |
4666 | 4666 | 947 | 1912-10-21 | 1435 | 20 | 1384 | 0 | 2023-03-13 20:38:18 |
4672 | 4672 | 948 | 1915-10-21 | 1435 | 20 | 1239 | 1 | 2023-03-13 20:38:18 |
4781 | 4781 | 969 | 1932-09-18 | 892 | 20 | 1184 | 0 | 2023-03-13 20:38:18 |
4826 | 4826 | 977 | 1917-10-28 | 35 | 20 | 1463 | 0 | 2023-03-13 20:38:18 |
4854 | 4854 | 982 | 1902-10-26 | 458 | 20 | 0 | 2023-03-13 20:38:18 | |
5088 | 5088 | 1012 | 2017-03-15 | 1501 | 20 | 1506 | 1 | 2023-03-13 20:38:18 |
5129 | 5129 | 1015 | 2016-12-11 | 2647 | 20 | 1197 | 0 | 2023-03-13 20:38:18 |
5177 | 5177 | 1023 | 2018-04-08 | 1591 | 20 | 1104 | 0 | 2023-03-13 20:38:18 |
5259 | 5259 | 1033 | 1920-06-06 | 2697 | 20 | 1559 | 0 | 2023-03-13 20:38:18 |
5317 | 5317 | 1037 | 1930-09-14 | 2691 | 20 | 1581 | 0 | 2023-03-13 20:38:18 |
5349 | 5349 | 1039 | 1932-11-06 | 2697 | 20 | 1580 | 0 | 2023-03-13 20:38:18 |
5372 | 5372 | 1041 | 2018-09-09 | 892 | 20 | 1587 | 1 | 2023-03-13 20:38:18 |
5401 | 5401 | 1045 | 2019-04-14 | 1062 | 20 | 1510 | 0 | 2023-03-13 20:38:18 |
5443 | 5443 | 1048 | 2019-05-26 | 1378 | 20 | 1621 | 1 | 2023-03-13 20:38:18 |
5492 | 5492 | 1082 | 2019-10-13 | 664 | 20 | 1526 | 0 | 2023-03-13 20:38:18 |
5768 | 5768 | 1114 | 2022-10-02 | 2638 | 20 | 1678 | 0 | 2023-03-13 20:38:18 |
5827 | 5827 | 628 | 2000-04-05 | 1382 | 20 | 211 | 1 | 2023-03-13 20:38:18 |
5837 | 5837 | 237 | 2002-01-21 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5846 | 5846 | 237 | 2002-04-28 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5855 | 5855 | 237 | 2002-12-25 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5863 | 5863 | 237 | 2003-01-20 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5872 | 5872 | 237 | 2003-04-27 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5880 | 5880 | 237 | 2003-09-24 | 1540 | 20 | 840 | 0 | 2023-03-13 20:38:18 |
5905 | 5905 | 237 | 2000-10-20 | 1540 | 20 | 163 | 0 | 2023-03-13 20:38:18 |
5930 | 5930 | 554 | 2006-09-26 | 905 | 20 | 679 | 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 );