viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by party_id
This data as json, CSV (advanced)
Suggested facets: date (date), calculation_date (date)
Link | rowid | election_id | date | party_id ▼ | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
5929 | 5929 | 554 | 2006-09-26 | 4 | 6 | 679 | 1 | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
4833 | 4833 | 978 | 1914-10-25 | 26 | 112 | 1465 | 1 | 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 |
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 |
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 );