viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by seats descending
This data as json, CSV (advanced)
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
- 1959-12-17 21
- 1995-01-17 21
- 2012-06-17 21
- 2016-12-12 21
- 1935-06-07 20
- 1981-05-19 20
- 1991-10-27 20
- 1991-12-23 20
- …
Link | rowid | election_id | date | party_id | seats ▲ | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5892 | 5892 | 554 | 2008-09-24 | 1193 | 304 | 494 | 1 | 2023-03-13 20:38:18 |
481 | 481 | 102 | 1951-10-25 | 773 | 302 | 88 | 0 | 2023-03-13 20:38:18 |
6688 | 6688 | 327 | 2012-01-04 | 439 | 302 | 969 | 0 | 2023-03-13 20:38:18 |
14026 | 14026 | 102 | 1951-10-26 | 773 | 302 | 691 | 1 | 2023-03-13 20:38:18 |
14240 | 14240 | 102 | 1955-04-06 | 773 | 302 | 729 | 1 | 2023-03-13 20:38:18 |
2592 | 2592 | 568 | 1974-02-28 | 1556 | 301 | 216 | 0 | 2023-03-13 20:38:18 |
12253 | 12253 | 568 | 1974-03-04 | 1556 | 301 | 419 | 1 | 2023-03-13 20:38:18 |
1578 | 1578 | 345 | 1960-11-20 | 1193 | 300 | 241 | 0 | 2023-03-13 20:38:18 |
2293 | 2293 | 506 | 1986-07-06 | 1193 | 300 | 568 | 0 | 2023-03-13 20:38:18 |
9786 | 9786 | 345 | 1960-12-08 | 1193 | 300 | 48 | 1 | 2023-03-13 20:38:18 |
10169 | 10169 | 506 | 1989-08-10 | 1193 | 300 | 106 | 1 | 2023-03-13 20:38:18 |
10468 | 10468 | 506 | 1986-07-22 | 1193 | 300 | 146 | 1 | 2023-03-13 20:38:18 |
11399 | 11399 | 506 | 1987-11-06 | 1193 | 300 | 283 | 1 | 2023-03-13 20:38:18 |
14351 | 14351 | 506 | 1989-06-03 | 1193 | 300 | 743 | 1 | 2023-03-13 20:38:18 |
1046 | 1046 | 223 | 1964-10-15 | 773 | 298 | 63 | 0 | 2023-03-13 20:38:18 |
3011 | 3011 | 645 | 1958-05-22 | 1193 | 298 | 887 | 0 | 2023-03-13 20:38:18 |
7311 | 7311 | 679 | 1998-09-27 | 558 | 298 | 778 | 0 | 2023-03-13 20:38:18 |
10175 | 10175 | 679 | 1998-10-27 | 558 | 298 | 107 | 1 | 2023-03-13 20:38:18 |
11099 | 11099 | 645 | 1960-07-19 | 1193 | 298 | 241 | 1 | 2023-03-13 20:38:18 |
14470 | 14470 | 223 | 1964-10-16 | 773 | 298 | 760 | 1 | 2023-03-13 20:38:18 |
14614 | 14614 | 645 | 1958-06-12 | 1193 | 298 | 780 | 1 | 2023-03-13 20:38:18 |
2594 | 2594 | 568 | 1974-02-28 | 773 | 297 | 216 | 0 | 2023-03-13 20:38:18 |
3893 | 3893 | 789 | 2013-02-25 | 382 | 297 | 983 | 0 | 2023-03-13 20:38:18 |
7341 | 7341 | 692 | 1955-11-15 | 1193 | 297 | 899 | 0 | 2023-03-13 20:38:18 |
9151 | 9151 | 789 | 2013-11-18 | 382 | 297 | 1068 | 1 | 2023-03-13 20:38:18 |
12255 | 12255 | 568 | 1974-03-04 | 773 | 297 | 419 | 1 | 2023-03-13 20:38:18 |
15309 | 15309 | 692 | 1957-02-25 | 1193 | 297 | 887 | 1 | 2023-03-13 20:38:18 |
15377 | 15377 | 692 | 1955-11-22 | 1193 | 297 | 900 | 1 | 2023-03-13 20:38:18 |
15382 | 15382 | 692 | 1956-12-20 | 1193 | 297 | 901 | 1 | 2023-03-13 20:38:18 |
16398 | 16398 | 789 | 2013-04-27 | 382 | 297 | 1048 | 1 | 2023-03-13 20:38:18 |
16656 | 16656 | 789 | 2014-02-22 | 382 | 297 | 1079 | 1 | 2023-03-13 20:38:18 |
19047 | 19047 | 789 | 2016-12-12 | 382 | 297 | 1501 | 1 | 2023-03-13 20:38:18 |
2536 | 2536 | 554 | 2005-09-11 | 1193 | 296 | 770 | 0 | 2023-03-13 20:38:18 |
15107 | 15107 | 554 | 2005-10-31 | 1193 | 296 | 850 | 1 | 2023-03-13 20:38:18 |
476 | 476 | 102 | 1951-10-25 | 1556 | 295 | 88 | 0 | 2023-03-13 20:38:18 |
5249 | 5249 | 1032 | 2018-06-24 | 901 | 295 | 1487 | 0 | 2023-03-13 20:38:18 |
14021 | 14021 | 102 | 1951-10-26 | 1556 | 295 | 691 | 1 | 2023-03-13 20:38:18 |
14235 | 14235 | 102 | 1955-04-06 | 1556 | 295 | 729 | 1 | 2023-03-13 20:38:18 |
20169 | 20169 | 1032 | 2018-07-09 | 901 | 295 | 1635 | 1 | 2023-03-13 20:38:18 |
2984 | 2984 | 640 | 1963-11-21 | 1193 | 294 | 48 | 0 | 2023-03-13 20:38:18 |
3873 | 3873 | 788 | 2012-12-16 | 1193 | 294 | 969 | 0 | 2023-03-13 20:38:18 |
5932 | 5932 | 554 | 2006-01-20 | 1193 | 294 | 850 | 0 | 2023-03-13 20:38:18 |
7138 | 7138 | 595 | 1994-10-16 | 1727 | 294 | 862 | 0 | 2023-03-13 20:38:18 |
9130 | 9130 | 788 | 2012-12-27 | 1193 | 294 | 1044 | 0 | 2023-03-13 20:38:18 |
9508 | 9508 | 640 | 1964-11-09 | 1193 | 294 | 8 | 1 | 2023-03-13 20:38:18 |
13777 | 13777 | 640 | 1963-12-09 | 1193 | 294 | 649 | 1 | 2023-03-13 20:38:18 |
14606 | 14606 | 595 | 1994-11-17 | 1727 | 294 | 778 | 1 | 2023-03-13 20:38:18 |
16361 | 16361 | 788 | 2012-12-26 | 1193 | 294 | 1044 | 1 | 2023-03-13 20:38:18 |
6068 | 6068 | 386 | 1968-07-11 | 1094 | 293 | 662 | 0 | 2023-03-13 20:38:18 |
10196 | 10196 | 386 | 1969-06-22 | 1094 | 293 | 111 | 1 | 2023-03-13 20:38:18 |
10353 | 10353 | 386 | 1968-07-12 | 1094 | 293 | 131 | 1 | 2023-03-13 20:38:18 |
12328 | 12328 | 386 | 1972-07-06 | 1094 | 293 | 430 | 1 | 2023-03-13 20:38:18 |
4021 | 4021 | 812 | 1987-10-29 | 1334 | 292 | 1087 | 0 | 2023-03-13 20:38:18 |
5924 | 5924 | 554 | 2006-09-26 | 1193 | 292 | 679 | 1 | 2023-03-13 20:38:18 |
6126 | 6126 | 782 | 2012-06-26 | 1539 | 292 | 1038 | 0 | 2023-03-13 20:38:18 |
9204 | 9204 | 812 | 1990-06-07 | 1334 | 292 | 1088 | 0 | 2023-03-13 20:38:18 |
16697 | 16697 | 812 | 1987-12-21 | 1334 | 292 | 1088 | 1 | 2023-03-13 20:38:18 |
16700 | 16700 | 812 | 1990-11-09 | 1334 | 292 | 1089 | 1 | 2023-03-13 20:38:18 |
16704 | 16704 | 812 | 1991-06-23 | 1334 | 292 | 1090 | 1 | 2023-03-13 20:38:18 |
16773 | 16773 | 782 | 2014-03-31 | 1539 | 292 | 1103 | 1 | 2023-03-13 20:38:18 |
17134 | 17134 | 782 | 2014-08-26 | 1539 | 292 | 1141 | 1 | 2023-03-13 20:38:18 |
18647 | 18647 | 782 | 2016-02-11 | 1539 | 292 | 1406 | 1 | 2023-03-13 20:38:18 |
19013 | 19013 | 782 | 2016-12-06 | 1539 | 292 | 1498 | 1 | 2023-03-13 20:38:18 |
19085 | 19085 | 782 | 2017-06-14 | 1539 | 292 | 1508 | 1 | 2023-03-13 20:38:18 |
4099 | 4099 | 850 | 2014-12-14 | 1193 | 290 | 1044 | 0 | 2023-03-13 20:38:18 |
17251 | 17251 | 850 | 2014-12-24 | 1193 | 290 | 1156 | 1 | 2023-03-13 20:38:18 |
1423 | 1423 | 311 | 1970-06-18 | 1556 | 288 | 733 | 0 | 2023-03-13 20:38:18 |
2765 | 2765 | 603 | 1969-12-27 | 1193 | 288 | 787 | 0 | 2023-03-13 20:38:18 |
5366 | 5366 | 1040 | 1933-03-05 | 2695 | 288 | 1578 | 0 | 2023-03-13 20:38:18 |
10944 | 10944 | 311 | 1970-06-19 | 1556 | 288 | 216 | 1 | 2023-03-13 20:38:18 |
13821 | 13821 | 603 | 1972-07-07 | 1193 | 288 | 656 | 1 | 2023-03-13 20:38:18 |
14664 | 14664 | 603 | 1970-01-14 | 1193 | 288 | 789 | 1 | 2023-03-13 20:38:18 |
4423 | 4423 | 909 | 1929-05-30 | 1556 | 287 | 1291 | 0 | 2023-03-13 20:38:18 |
18022 | 18022 | 909 | 1929-06-05 | 1556 | 287 | 1290 | 1 | 2023-03-13 20:38:18 |
6086 | 6086 | 20 | 1981-07-02 | 1539 | 285 | 116 | 0 | 2023-03-13 20:38:18 |
12310 | 12310 | 20 | 1983-03-22 | 1539 | 285 | 428 | 1 | 2023-03-13 20:38:18 |
15053 | 15053 | 20 | 1984-07-17 | 1539 | 285 | 843 | 1 | 2023-03-13 20:38:18 |
549 | 549 | 113 | 1980-06-22 | 1193 | 284 | 727 | 0 | 2023-03-13 20:38:18 |
10698 | 10698 | 113 | 1980-07-17 | 1193 | 284 | 180 | 1 | 2023-03-13 20:38:18 |
11106 | 11106 | 113 | 1982-11-27 | 1193 | 284 | 242 | 1 | 2023-03-13 20:38:18 |
1741 | 1741 | 386 | 1968-06-30 | 1094 | 282 | 662 | 0 | 2023-03-13 20:38:18 |
2878 | 2878 | 625 | 1950-02-23 | 773 | 282 | 99 | 0 | 2023-03-13 20:38:18 |
10044 | 10044 | 625 | 1950-02-28 | 773 | 282 | 88 | 1 | 2023-03-13 20:38:18 |
5168 | 5168 | 1022 | 2017-10-22 | 1193 | 281 | 1156 | 0 | 2023-03-13 20:38:18 |
19200 | 19200 | 1022 | 2017-11-01 | 1193 | 281 | 1525 | 1 | 2023-03-13 20:38:18 |
20244 | 20244 | 1022 | 2020-09-16 | 1193 | 281 | 1644 | 1 | 2023-03-13 20:38:18 |
20267 | 20267 | 1022 | 2021-10-04 | 1193 | 281 | 1647 | 1 | 2023-03-13 20:38:18 |
1656 | 1656 | 367 | 1967-01-29 | 1193 | 280 | 8 | 0 | 2023-03-13 20:38:18 |
3816 | 3816 | 782 | 2012-06-17 | 1539 | 280 | 1037 | 0 | 2023-03-13 20:38:18 |
14643 | 14643 | 367 | 1967-02-17 | 1193 | 280 | 787 | 1 | 2023-03-13 20:38:18 |
16307 | 16307 | 782 | 2012-06-18 | 1539 | 280 | 1038 | 1 | 2023-03-13 20:38:18 |
6718 | 6718 | 331 | 1960-09-20 | 1727 | 279 | 906 | 0 | 2023-03-13 20:38:18 |
5955 | 5955 | 25 | 1992-07-26 | 1193 | 278 | 253 | 0 | 2023-03-13 20:38:18 |
145 | 145 | 40 | 1974-10-10 | 773 | 277 | 7 | 1 | 2023-03-13 20:38:18 |
3152 | 3152 | 678 | 1955-05-26 | 1556 | 277 | 184 | 1 | 2023-03-13 20:38:18 |
12143 | 12143 | 678 | 1957-01-10 | 1556 | 277 | 404 | 1 | 2023-03-13 20:38:18 |
13412 | 13412 | 40 | 1976-04-05 | 773 | 277 | 590 | 1 | 2023-03-13 20:38:18 |
538 | 538 | 111 | 2008-04-13 | 596 | 276 | 117 | 0 | 2023-03-13 20:38:18 |
14911 | 14911 | 111 | 2008-05-08 | 596 | 276 | 823 | 1 | 2023-03-13 20:38:18 |
93 | 93 | 25 | 1990-02-18 | 1193 | 275 | 106 | 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 );