viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by party_id
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
- 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 |
---|---|---|---|---|---|---|---|---|
2743 | 2743 | 599 | 2010-05-29 | 2 | 38 | 157 | 0 | 2023-03-13 20:38:18 |
3983 | 3983 | 805 | 2013-10-25 | 2 | 21 | 1062 | 0 | 2023-03-13 20:38:18 |
5156 | 5156 | 1020 | 2017-10-21 | 2 | 7 | 1072 | 0 | 2023-03-13 20:38:18 |
6210 | 6210 | 50 | 2009-06-07 | 2 | 3 | 157 | 0 | 2023-03-13 20:38:18 |
7150 | 7150 | 599 | 2011-04-08 | 2 | 38 | 708 | 0 | 2023-03-13 20:38:18 |
7157 | 7157 | 599 | 2011-10-07 | 2 | 38 | 708 | 0 | 2023-03-13 20:38:18 |
7165 | 7165 | 599 | 2011-11-16 | 2 | 38 | 708 | 0 | 2023-03-13 20:38:18 |
7173 | 7173 | 599 | 2012-04-17 | 2 | 38 | 708 | 0 | 2023-03-13 20:38:18 |
9463 | 9463 | 1099 | 2021-10-09 | 2 | 14 | 1534 | 0 | 2023-03-13 20:38:18 |
14105 | 14105 | 599 | 2010-06-28 | 2 | 38 | 708 | 1 | 2023-03-13 20:38:18 |
16273 | 16273 | 599 | 2012-04-27 | 2 | 38 | 1030 | 1 | 2023-03-13 20:38:18 |
16546 | 16546 | 599 | 2013-07-10 | 2 | 38 | 1062 | 1 | 2023-03-13 20:38:18 |
16604 | 16604 | 805 | 2014-01-17 | 2 | 21 | 1072 | 1 | 2023-03-13 20:38:18 |
19188 | 19188 | 1020 | 2017-12-13 | 2 | 7 | 1522 | 1 | 2023-03-13 20:38:18 |
19288 | 19288 | 1020 | 2018-06-27 | 2 | 7 | 1534 | 1 | 2023-03-13 20:38:18 |
20293 | 20293 | 1099 | 2021-12-17 | 2 | 14 | 1649 | 1 | 2023-03-13 20:38:18 |
2223 | 2223 | 497 | 1948-07-07 | 3 | 1 | 96 | 0 | 2023-03-13 20:38:18 |
2487 | 2487 | 543 | 1952-06-25 | 3 | 2 | 243 | 0 | 2023-03-13 20:38:18 |
10332 | 10332 | 497 | 1948-08-07 | 3 | 1 | 128 | 1 | 2023-03-13 20:38:18 |
11118 | 11118 | 497 | 1951-03-15 | 3 | 1 | 243 | 1 | 2023-03-13 20:38:18 |
11883 | 11883 | 543 | 1952-09-02 | 3 | 2 | 366 | 1 | 2023-03-13 20:38:18 |
1498 | 1498 | 327 | 2009-08-30 | 4 | 3 | 494 | 0 | 2023-03-13 20:38:18 |
2534 | 2534 | 554 | 2005-09-11 | 4 | 4 | 770 | 0 | 2023-03-13 20:38:18 |
3882 | 3882 | 788 | 2012-12-16 | 4 | 1 | 969 | 0 | 2023-03-13 20:38:18 |
5890 | 5890 | 327 | 2009-09-16 | 4 | 3 | 374 | 1 | 2023-03-13 20:38:18 |
5897 | 5897 | 554 | 2008-09-24 | 4 | 7 | 494 | 1 | 2023-03-13 20:38:18 |
5914 | 5914 | 554 | 2007-08-07 | 4 | 6 | 679 | 0 | 2023-03-13 20:38:18 |
5921 | 5921 | 554 | 2007-01-25 | 4 | 6 | 679 | 0 | 2023-03-13 20:38:18 |
5929 | 5929 | 554 | 2006-09-26 | 4 | 6 | 679 | 1 | 2023-03-13 20:38:18 |
5937 | 5937 | 554 | 2006-01-20 | 4 | 6 | 850 | 0 | 2023-03-13 20:38:18 |
6676 | 6676 | 327 | 2009-10-26 | 4 | 3 | 374 | 0 | 2023-03-13 20:38:18 |
6684 | 6684 | 327 | 2010-04-10 | 4 | 3 | 374 | 0 | 2023-03-13 20:38:18 |
6693 | 6693 | 327 | 2012-01-04 | 4 | 3 | 969 | 0 | 2023-03-13 20:38:18 |
6702 | 6702 | 327 | 2012-07-02 | 4 | 3 | 969 | 0 | 2023-03-13 20:38:18 |
7024 | 7024 | 554 | 2007-09-10 | 4 | 6 | 390 | 0 | 2023-03-13 20:38:18 |
9139 | 9139 | 788 | 2012-12-27 | 4 | 1 | 1044 | 0 | 2023-03-13 20:38:18 |
10387 | 10387 | 554 | 2007-09-26 | 4 | 6 | 134 | 1 | 2023-03-13 20:38:18 |
12053 | 12053 | 554 | 2007-08-27 | 4 | 6 | 390 | 1 | 2023-03-13 20:38:18 |
12762 | 12762 | 327 | 2010-06-04 | 4 | 3 | 493 | 1 | 2023-03-13 20:38:18 |
15105 | 15105 | 554 | 2005-10-31 | 4 | 4 | 850 | 1 | 2023-03-13 20:38:18 |
15896 | 15896 | 327 | 2011-08-30 | 4 | 3 | 969 | 1 | 2023-03-13 20:38:18 |
16370 | 16370 | 788 | 2012-12-26 | 4 | 1 | 1044 | 1 | 2023-03-13 20:38:18 |
1472 | 1472 | 319 | 2008-11-30 | 5 | 4 | 118 | 0 | 2023-03-13 20:38:18 |
3867 | 3867 | 787 | 2012-12-09 | 5 | 13 | 1033 | 0 | 2023-03-13 20:38:18 |
6657 | 6657 | 319 | 2010-05-02 | 5 | 4 | 993 | 0 | 2023-03-13 20:38:18 |
9117 | 9117 | 787 | 2012-12-20 | 5 | 13 | 1033 | 0 | 2023-03-13 20:38:18 |
9124 | 9124 | 787 | 2014-07-03 | 5 | 13 | 1085 | 0 | 2023-03-13 20:38:18 |
13076 | 13076 | 319 | 2010-05-19 | 5 | 4 | 537 | 1 | 2023-03-13 20:38:18 |
13482 | 13482 | 319 | 2008-12-22 | 5 | 4 | 599 | 1 | 2023-03-13 20:38:18 |
16119 | 16119 | 319 | 2009-12-23 | 5 | 4 | 993 | 1 | 2023-03-13 20:38:18 |
16356 | 16356 | 787 | 2012-12-21 | 5 | 13 | 1043 | 1 | 2023-03-13 20:38:18 |
16683 | 16683 | 787 | 2014-03-04 | 5 | 13 | 1085 | 1 | 2023-03-13 20:38:18 |
17232 | 17232 | 787 | 2014-12-15 | 5 | 13 | 1154 | 1 | 2023-03-13 20:38:18 |
17510 | 17510 | 787 | 2015-11-10 | 5 | 13 | 1197 | 1 | 2023-03-13 20:38:18 |
20639 | 20639 | 165 | 2004-12-29 | 5 | 0 | 509 | 1 | 2023-03-13 20:38:18 |
20691 | 20691 | 336 | 2000-12-20 | 5 | 0 | 64 | 1 | 2023-03-13 20:38:18 |
20692 | 20692 | 319 | 2012-05-07 | 5 | 0 | 1033 | 1 | 2023-03-13 20:38:18 |
1559 | 1559 | 339 | 2001-05-27 | 6 | 1 | 910 | 1 | 2023-03-13 20:38:18 |
11758 | 11758 | 339 | 2003-02-28 | 6 | 1 | 342 | 1 | 2023-03-13 20:38:18 |
349 | 349 | 80 | 2004-10-03 | 16 | 7 | 292 | 0 | 2023-03-13 20:38:18 |
624 | 624 | 129 | 1990-04-12 | 16 | 11 | 0 | 2023-03-13 20:38:18 | |
1549 | 1549 | 338 | 1996-11-10 | 16 | 19 | 562 | 0 | 2023-03-13 20:38:18 |
1722 | 1722 | 382 | 1992-12-06 | 16 | 10 | 9 | 0 | 2023-03-13 20:38:18 |
2385 | 2385 | 522 | 2008-09-21 | 16 | 5 | 407 | 0 | 2023-03-13 20:38:18 |
2408 | 2408 | 525 | 2000-10-15 | 16 | 9 | 768 | 0 | 2023-03-13 20:38:18 |
3790 | 3790 | 778 | 2011-12-04 | 16 | 6 | 907 | 0 | 2023-03-13 20:38:18 |
6279 | 6279 | 80 | 2007-03-09 | 16 | 7 | 407 | 0 | 2023-03-13 20:38:18 |
6915 | 6915 | 522 | 2009-12-01 | 16 | 5 | 803 | 0 | 2023-03-13 20:38:18 |
6925 | 6925 | 522 | 2010-10-26 | 16 | 5 | 803 | 0 | 2023-03-13 20:38:18 |
6935 | 6935 | 522 | 2011-07-05 | 16 | 5 | 907 | 0 | 2023-03-13 20:38:18 |
6945 | 6945 | 522 | 2011-09-29 | 16 | 5 | 907 | 0 | 2023-03-13 20:38:18 |
9518 | 9518 | 129 | 1992-04-22 | 16 | 11 | 9 | 1 | 2023-03-13 20:38:18 |
10462 | 10462 | 382 | 1994-04-08 | 16 | 10 | 145 | 1 | 2023-03-13 20:38:18 |
10738 | 10738 | 525 | 2002-12-19 | 16 | 9 | 187 | 1 | 2023-03-13 20:38:18 |
11461 | 11461 | 525 | 2004-04-08 | 16 | 9 | 292 | 1 | 2023-03-13 20:38:18 |
12174 | 12174 | 80 | 2004-12-03 | 16 | 7 | 407 | 1 | 2023-03-13 20:38:18 |
12834 | 12834 | 525 | 2000-11-30 | 16 | 9 | 505 | 1 | 2023-03-13 20:38:18 |
13014 | 13014 | 129 | 1990-05-16 | 16 | 11 | 527 | 1 | 2023-03-13 20:38:18 |
13230 | 13230 | 382 | 1993-01-12 | 16 | 10 | 559 | 1 | 2023-03-13 20:38:18 |
13247 | 13247 | 382 | 1996-01-26 | 16 | 10 | 562 | 1 | 2023-03-13 20:38:18 |
13753 | 13753 | 338 | 1997-02-27 | 16 | 19 | 644 | 1 | 2023-03-13 20:38:18 |
14533 | 14533 | 338 | 2000-06-07 | 16 | 19 | 768 | 1 | 2023-03-13 20:38:18 |
14747 | 14747 | 522 | 2008-11-21 | 16 | 5 | 803 | 1 | 2023-03-13 20:38:18 |
15420 | 15420 | 522 | 2011-06-27 | 16 | 5 | 907 | 1 | 2023-03-13 20:38:18 |
16091 | 16091 | 778 | 2012-01-28 | 16 | 6 | 990 | 1 | 2023-03-13 20:38:18 |
16385 | 16385 | 778 | 2013-03-20 | 16 | 6 | 1047 | 1 | 2023-03-13 20:38:18 |
20676 | 20676 | 864 | 1945-06-25 | 17 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
978 | 978 | 211 | 1991-10-27 | 18 | 4 | 75 | 0 | 2023-03-13 20:38:18 |
9895 | 9895 | 211 | 1992-07-11 | 18 | 4 | 68 | 1 | 2023-03-13 20:38:18 |
10360 | 10360 | 211 | 1991-12-23 | 18 | 4 | 132 | 1 | 2023-03-13 20:38:18 |
13520 | 13520 | 211 | 1992-06-05 | 18 | 4 | 605 | 1 | 2023-03-13 20:38:18 |
14242 | 14242 | 211 | 1993-05-28 | 18 | 4 | 730 | 1 | 2023-03-13 20:38:18 |
129 | 129 | 39 | 1992-06-06 | 19 | 14 | 262 | 0 | 2023-03-13 20:38:18 |
261 | 261 | 63 | 1990-06-09 | 19 | 22 | 0 | 2023-03-13 20:38:18 | |
6174 | 6174 | 39 | 1995-05-09 | 19 | 14 | 835 | 0 | 2023-03-13 20:38:18 |
10598 | 10598 | 39 | 1992-07-02 | 19 | 14 | 165 | 1 | 2023-03-13 20:38:18 |
11227 | 11227 | 63 | 1990-06-29 | 19 | 22 | 262 | 1 | 2023-03-13 20:38:18 |
14980 | 14980 | 39 | 1993-01-01 | 19 | 14 | 835 | 1 | 2023-03-13 20:38:18 |
6735 | 6735 | 349 | 2001-07-28 | 20 | 8 | 699 | 0 | 2023-03-13 20:38:18 |
6742 | 6742 | 349 | 2002-01-31 | 20 | 8 | 699 | 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 );