viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by party_id
This data as json, CSV (advanced)
calculation_date (date) 1 ✖
- 2023-03-13 20,641
Link | rowid | election_id | date | party_id ▼ | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5584 | 5584 | 1091 | 2020-10-11 | 28 | 3 | 1615 | 0 | 2023-03-13 20:38:18 |
6241 | 6241 | 59 | 2001-01-27 | 28 | 2 | 304 | 0 | 2023-03-13 20:38:18 |
6257 | 6257 | 59 | 2002-03-09 | 28 | 2 | 405 | 0 | 2023-03-13 20:38:18 |
6521 | 6521 | 214 | 2006-05-01 | 28 | 2 | 495 | 0 | 2023-03-13 20:38:18 |
7099 | 7099 | 566 | 1996-10-20 | 28 | 3 | 91 | 0 | 2023-03-13 20:38:18 |
7271 | 7271 | 646 | 2010-09-20 | 28 | 3 | 1632 | 0 | 2023-03-13 20:38:18 |
7282 | 7282 | 646 | 2010-09-21 | 28 | 3 | 1026 | 1 | 2023-03-13 20:38:18 |
9359 | 9359 | 1009 | 2017-10-19 | 28 | 8 | 1614 | 1 | 2023-03-13 20:38:18 |
9775 | 9775 | 566 | 1996-12-10 | 28 | 3 | 47 | 1 | 2023-03-13 20:38:18 |
10073 | 10073 | 439 | 1996-02-15 | 28 | 4 | 91 | 1 | 2023-03-13 20:38:18 |
11423 | 11423 | 214 | 2004-12-14 | 28 | 2 | 287 | 1 | 2023-03-13 20:38:18 |
11523 | 11523 | 59 | 2000-10-26 | 28 | 2 | 304 | 1 | 2023-03-13 20:38:18 |
12148 | 12148 | 59 | 2001-07-12 | 28 | 2 | 405 | 1 | 2023-03-13 20:38:18 |
12439 | 12439 | 566 | 1999-05-18 | 28 | 3 | 444 | 1 | 2023-03-13 20:38:18 |
12771 | 12771 | 214 | 2006-04-11 | 28 | 2 | 495 | 1 | 2023-03-13 20:38:18 |
13345 | 13345 | 214 | 2006-07-04 | 28 | 2 | 579 | 1 | 2023-03-13 20:38:18 |
13983 | 13983 | 439 | 1992-12-02 | 28 | 4 | 684 | 1 | 2023-03-13 20:38:18 |
14002 | 14002 | 646 | 2008-11-27 | 28 | 3 | 688 | 1 | 2023-03-13 20:38:18 |
14292 | 14292 | 566 | 1999-10-29 | 28 | 3 | 735 | 1 | 2023-03-13 20:38:18 |
14824 | 14824 | 439 | 1993-03-10 | 28 | 4 | 811 | 1 | 2023-03-13 20:38:18 |
16351 | 16351 | 786 | 2012-12-13 | 28 | 8 | 1042 | 1 | 2023-03-13 20:38:18 |
18991 | 18991 | 1009 | 2016-11-22 | 28 | 8 | 1496 | 1 | 2023-03-13 20:38:18 |
20010 | 20010 | 1009 | 2019-07-23 | 28 | 8 | 1615 | 1 | 2023-03-13 20:38:18 |
20108 | 20108 | 566 | 1998-03-10 | 28 | 3 | 1630 | 1 | 2023-03-13 20:38:18 |
20118 | 20118 | 59 | 2003-03-04 | 28 | 2 | 1631 | 1 | 2023-03-13 20:38:18 |
20136 | 20136 | 646 | 2009-07-16 | 28 | 3 | 1632 | 1 | 2023-03-13 20:38:18 |
20149 | 20149 | 786 | 2014-07-15 | 28 | 8 | 1633 | 1 | 2023-03-13 20:38:18 |
20155 | 20155 | 59 | 2004-07-13 | 28 | 2 | 1634 | 1 | 2023-03-13 20:38:18 |
20239 | 20239 | 1091 | 2020-11-24 | 28 | 3 | 1643 | 1 | 2023-03-13 20:38:18 |
7160 | 7160 | 599 | 2011-10-07 | 29 | 2 | 708 | 0 | 2023-03-13 20:38:18 |
7168 | 7168 | 599 | 2011-11-16 | 29 | 2 | 708 | 0 | 2023-03-13 20:38:18 |
7176 | 7176 | 599 | 2012-04-17 | 29 | 2 | 708 | 0 | 2023-03-13 20:38:18 |
16276 | 16276 | 599 | 2012-04-27 | 29 | 2 | 1030 | 1 | 2023-03-13 20:38:18 |
16549 | 16549 | 599 | 2013-07-10 | 29 | 2 | 1062 | 1 | 2023-03-13 20:38:18 |
23 | 23 | 6 | 1977-06-16 | 30 | 4 | 315 | 0 | 2023-03-13 20:38:18 |
165 | 165 | 43 | 1987-02-17 | 30 | 3 | 867 | 0 | 2023-03-13 20:38:18 |
169 | 169 | 47 | 1981-06-11 | 30 | 4 | 442 | 0 | 2023-03-13 20:38:18 |
244 | 244 | 60 | 1948-02-04 | 30 | 12 | 151 | 0 | 2023-03-13 20:38:18 |
598 | 598 | 122 | 1944-05-30 | 30 | 11 | 1445 | 0 | 2023-03-13 20:38:18 |
880 | 880 | 190 | 2007-05-24 | 30 | 5 | 179 | 0 | 2023-03-13 20:38:18 |
1067 | 1067 | 228 | 1982-02-18 | 30 | 4 | 335 | 0 | 2023-03-13 20:38:18 |
1296 | 1296 | 283 | 1973-02-28 | 30 | 2 | 863 | 0 | 2023-03-13 20:38:18 |
1401 | 1401 | 307 | 1982-11-24 | 30 | 3 | 54 | 0 | 2023-03-13 20:38:18 |
1461 | 1461 | 316 | 1997-06-06 | 30 | 6 | 573 | 0 | 2023-03-13 20:38:18 |
1486 | 1486 | 323 | 1965-04-07 | 30 | 2 | 667 | 0 | 2023-03-13 20:38:18 |
1644 | 1644 | 359 | 1992-11-25 | 30 | 5 | 870 | 0 | 2023-03-13 20:38:18 |
1853 | 1853 | 408 | 2002-05-17 | 30 | 12 | 126 | 0 | 2023-03-13 20:38:18 |
1887 | 1887 | 413 | 1961-10-04 | 30 | 6 | 364 | 0 | 2023-03-13 20:38:18 |
2108 | 2108 | 469 | 1957-03-05 | 30 | 9 | 626 | 0 | 2023-03-13 20:38:18 |
2351 | 2351 | 515 | 1951-05-30 | 30 | 14 | 154 | 0 | 2023-03-13 20:38:18 |
2684 | 2684 | 584 | 1954-05-18 | 30 | 5 | 643 | 0 | 2023-03-13 20:38:18 |
2696 | 2696 | 590 | 1989-06-15 | 30 | 4 | 77 | 0 | 2023-03-13 20:38:18 |
2990 | 2990 | 641 | 1969-06-18 | 30 | 1 | 602 | 0 | 2023-03-13 20:38:18 |
3249 | 3249 | 698 | 2011-02-25 | 30 | 14 | 173 | 0 | 2023-03-13 20:38:18 |
4449 | 4449 | 912 | 1922-06-22 | 30 | 9 | 0 | 2023-03-13 20:38:18 | |
4456 | 4456 | 913 | 1923-08-27 | 30 | 13 | 1446 | 0 | 2023-03-13 20:38:18 |
4465 | 4465 | 914 | 1927-06-09 | 30 | 16 | 1438 | 0 | 2023-03-13 20:38:18 |
4469 | 4469 | 915 | 1927-09-15 | 30 | 12 | 1439 | 0 | 2023-03-13 20:38:18 |
4476 | 4476 | 917 | 1932-02-16 | 30 | 14 | 1440 | 0 | 2023-03-13 20:38:18 |
4482 | 4482 | 918 | 1933-01-24 | 30 | 9 | 1441 | 0 | 2023-03-13 20:38:18 |
4486 | 4486 | 919 | 1937-07-01 | 30 | 8 | 1442 | 0 | 2023-03-13 20:38:18 |
4490 | 4490 | 920 | 1938-06-17 | 30 | 7 | 1443 | 0 | 2023-03-13 20:38:18 |
4494 | 4494 | 921 | 1943-06-23 | 30 | 11 | 1444 | 0 | 2023-03-13 20:38:18 |
5009 | 5009 | 1002 | 2016-02-26 | 30 | 12 | 904 | 0 | 2023-03-13 20:38:18 |
5557 | 5557 | 1088 | 2020-02-08 | 30 | 19 | 1641 | 1 | 2023-03-13 20:38:18 |
6747 | 6747 | 359 | 1994-06-09 | 30 | 5 | 748 | 0 | 2023-03-13 20:38:18 |
6754 | 6754 | 359 | 1994-06-10 | 30 | 5 | 748 | 0 | 2023-03-13 20:38:18 |
6761 | 6761 | 359 | 1996-04-02 | 30 | 5 | 573 | 0 | 2023-03-13 20:38:18 |
7265 | 7265 | 641 | 1972-06-27 | 30 | 1 | 863 | 0 | 2023-03-13 20:38:18 |
9825 | 9825 | 228 | 1982-03-09 | 30 | 4 | 54 | 1 | 2023-03-13 20:38:18 |
9974 | 9974 | 43 | 1987-03-10 | 30 | 3 | 77 | 1 | 2023-03-13 20:38:18 |
10316 | 10316 | 316 | 1997-06-26 | 30 | 6 | 126 | 1 | 2023-03-13 20:38:18 |
10513 | 10513 | 122 | 1944-06-09 | 30 | 11 | 151 | 1 | 2023-03-13 20:38:18 |
10529 | 10529 | 60 | 1948-02-18 | 30 | 12 | 154 | 1 | 2023-03-13 20:38:18 |
10649 | 10649 | 190 | 2008-05-07 | 30 | 5 | 173 | 1 | 2023-03-13 20:38:18 |
10686 | 10686 | 408 | 2002-06-06 | 30 | 12 | 179 | 1 | 2023-03-13 20:38:18 |
10938 | 10938 | 590 | 1989-07-12 | 30 | 4 | 215 | 1 | 2023-03-13 20:38:18 |
10951 | 10951 | 323 | 1965-04-21 | 30 | 2 | 217 | 1 | 2023-03-13 20:38:18 |
11596 | 11596 | 283 | 1973-03-14 | 30 | 2 | 315 | 1 | 2023-03-13 20:38:18 |
11717 | 11717 | 47 | 1981-06-30 | 30 | 4 | 335 | 1 | 2023-03-13 20:38:18 |
11878 | 11878 | 469 | 1959-06-23 | 30 | 9 | 364 | 1 | 2023-03-13 20:38:18 |
12424 | 12424 | 6 | 1979-12-12 | 30 | 4 | 442 | 1 | 2023-03-13 20:38:18 |
12983 | 12983 | 469 | 1957-03-20 | 30 | 9 | 523 | 1 | 2023-03-13 20:38:18 |
13309 | 13309 | 359 | 1994-12-15 | 30 | 5 | 573 | 1 | 2023-03-13 20:38:18 |
13499 | 13499 | 323 | 1966-11-10 | 30 | 2 | 602 | 1 | 2023-03-13 20:38:18 |
13645 | 13645 | 584 | 1954-06-02 | 30 | 5 | 626 | 1 | 2023-03-13 20:38:18 |
13749 | 13749 | 515 | 1951-06-13 | 30 | 14 | 643 | 1 | 2023-03-13 20:38:18 |
13891 | 13891 | 413 | 1961-10-11 | 30 | 6 | 667 | 1 | 2023-03-13 20:38:18 |
14391 | 14391 | 359 | 1993-01-12 | 30 | 5 | 748 | 1 | 2023-03-13 20:38:18 |
14685 | 14685 | 6 | 1977-07-05 | 30 | 4 | 794 | 1 | 2023-03-13 20:38:18 |
15173 | 15173 | 641 | 1969-07-02 | 30 | 1 | 863 | 1 | 2023-03-13 20:38:18 |
15178 | 15178 | 190 | 2007-06-14 | 30 | 5 | 864 | 1 | 2023-03-13 20:38:18 |
15189 | 15189 | 307 | 1982-12-14 | 30 | 3 | 867 | 1 | 2023-03-13 20:38:18 |
15213 | 15213 | 590 | 1992-02-11 | 30 | 4 | 870 | 1 | 2023-03-13 20:38:18 |
15405 | 15405 | 698 | 2011-03-09 | 30 | 14 | 904 | 1 | 2023-03-13 20:38:18 |
18747 | 18747 | 913 | 1923-09-19 | 30 | 13 | 1438 | 1 | 2023-03-13 20:38:18 |
18756 | 18756 | 914 | 1927-06-23 | 30 | 16 | 1439 | 1 | 2023-03-13 20:38:18 |
18760 | 18760 | 915 | 1927-10-11 | 30 | 12 | 1440 | 1 | 2023-03-13 20:38:18 |
18767 | 18767 | 917 | 1932-03-09 | 30 | 14 | 1441 | 1 | 2023-03-13 20:38:18 |
18773 | 18773 | 918 | 1933-02-08 | 30 | 9 | 1442 | 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 );