viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
89 rows where seats = 49
This data as json, CSV (advanced)
Suggested facets: election_id, date, party_id, cabinet_id, cabinet_formation, calculation_date (date)
date (date) 86 ✖
- 1945-03-18 2
- 1945-04-17 2
- 1946-03-26 2
- 1910-05-22 1
- 1911-06-18 1
- 1925-10-25 1
- 1925-12-17 1
- 1931-10-25 1
- 1931-12-17 1
- 1934-03-22 1
- 1939-10-29 1
- 1939-12-13 1
- 1943-08-21 1
- 1943-09-21 1
- 1945-07-06 1
- 1945-07-13 1
- 1947-10-28 1
- 1947-11-13 1
- 1951-10-28 1
- 1951-12-13 1
- 1955-12-10 1
- 1956-01-11 1
- 1956-06-13 1
- 1956-10-12 1
- 1958-12-22 1
- 1959-03-12 1
- 1959-05-19 1
- 1965-09-19 1
- 1965-10-26 1
- 1966-03-21 1
- 1966-05-27 1
- 1966-12-01 1
- 1967-10-29 1
- 1967-12-14 1
- 1968-03-22 1
- 1971-10-31 1
- 1971-12-08 1
- 1977-03-15 1
- 1977-05-25 1
- 1977-12-19 1
- 1984-05-14 1
- 1984-05-29 1
- 1985-10-13 1
- 1985-11-28 1
- 1987-10-21 1
- 1989-09-06 1
- 1989-11-07 1
- 1991-10-27 1
- 1991-12-23 1
- 1992-06-05 1
- 1992-07-11 1
- 1993-03-13 1
- 1993-03-24 1
- 1993-05-28 1
- 1994-09-11 1
- 1994-10-16 1
- 1994-11-17 1
- 1995-12-24 1
- 1996-03-02 1
- 1996-03-06 1
- 1996-03-11 1
- 1996-06-28 1
- 1997-01-07 1
- 1997-06-30 1
- 1999-01-11 1
- 1999-11-27 1
- 1999-12-09 1
- 2008-10-14 1
- 2008-10-30 1
- 2011-10-22 1
- 2013-02-11 1
- 2014-09-14 1
- 2014-10-02 1
- 2015-04-19 1
- 2015-05-29 1
- 2016-03-06 1
- 2016-03-23 1
- 2016-09-01 1
- 2017-06-13 1
- 2017-09-11 1
- 2018-01-17 1
- 2018-03-22 1
- 2018-06-24 1
- 2018-07-09 1
- 2019-01-22 1
- 2020-01-24 1
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
73 | 73 | 21 | 1951-10-28 | 35 | 49 | 556 | 0 | 2023-03-13 20:38:18 |
470 | 470 | 101 | 1945-03-18 | 1292 | 49 | 120 | 0 | 2023-03-13 20:38:18 |
472 | 472 | 101 | 1945-03-18 | 94 | 49 | 120 | 0 | 2023-03-13 20:38:18 |
814 | 814 | 176 | 1971-10-31 | 26 | 49 | 777 | 0 | 2023-03-13 20:38:18 |
983 | 983 | 211 | 1991-10-27 | 1758 | 49 | 75 | 0 | 2023-03-13 20:38:18 |
1690 | 1690 | 373 | 1967-10-29 | 26 | 49 | 513 | 0 | 2023-03-13 20:38:18 |
1788 | 1788 | 396 | 1985-10-13 | 723 | 49 | 724 | 0 | 2023-03-13 20:38:18 |
2014 | 2014 | 437 | 1956-06-13 | 451 | 49 | 366 | 0 | 2023-03-13 20:38:18 |
2040 | 2040 | 451 | 1999-11-27 | 878 | 49 | 388 | 0 | 2023-03-13 20:38:18 |
2068 | 2068 | 460 | 1966-03-21 | 94 | 49 | 139 | 0 | 2023-03-13 20:38:18 |
2485 | 2485 | 541 | 1947-10-28 | 1605 | 49 | 387 | 0 | 2023-03-13 20:38:18 |
2748 | 2748 | 601 | 2008-10-14 | 448 | 49 | 610 | 0 | 2023-03-13 20:38:18 |
2889 | 2889 | 627 | 1989-09-06 | 742 | 49 | 550 | 0 | 2023-03-13 20:38:18 |
2966 | 2966 | 635 | 1977-05-25 | 235 | 49 | 324 | 1 | 2023-03-13 20:38:18 |
3096 | 3096 | 667 | 1959-03-12 | 451 | 49 | 741 | 0 | 2023-03-13 20:38:18 |
3557 | 3557 | 737 | 1943-08-21 | 1253 | 49 | 995 | 0 | 2023-03-13 20:38:18 |
3584 | 3584 | 742 | 1955-12-10 | 1253 | 49 | 178 | 0 | 2023-03-13 20:38:18 |
3628 | 3628 | 753 | 1993-03-13 | 1411 | 49 | 725 | 0 | 2023-03-13 20:38:18 |
3631 | 3631 | 754 | 1996-03-02 | 1253 | 49 | 49 | 0 | 2023-03-13 20:38:18 |
3687 | 3687 | 767 | 1939-10-29 | 26 | 49 | 974 | 0 | 2023-03-13 20:38:18 |
3698 | 3698 | 768 | 1931-10-25 | 35 | 49 | 978 | 0 | 2023-03-13 20:38:18 |
3754 | 3754 | 774 | 1925-10-25 | 35 | 49 | 980 | 0 | 2023-03-13 20:38:18 |
4015 | 4015 | 810 | 1995-12-24 | 507 | 49 | 1093 | 0 | 2023-03-13 20:38:18 |
4077 | 4077 | 828 | 2014-09-14 | 1546 | 49 | 854 | 0 | 2023-03-13 20:38:18 |
4140 | 4140 | 855 | 2015-04-19 | 94 | 49 | 1145 | 0 | 2023-03-13 20:38:18 |
4229 | 4229 | 873 | 1910-05-22 | 2423 | 49 | 1377 | 1 | 2023-03-13 20:38:18 |
5017 | 5017 | 1003 | 2016-03-06 | 220 | 49 | 1027 | 0 | 2023-03-13 20:38:18 |
5132 | 5132 | 1017 | 2017-09-11 | 104 | 49 | 1516 | 1 | 2023-03-13 20:38:18 |
5250 | 5250 | 1032 | 2018-06-24 | 408 | 49 | 1487 | 0 | 2023-03-13 20:38:18 |
6554 | 6554 | 250 | 1965-09-19 | 543 | 49 | 31 | 0 | 2023-03-13 20:38:18 |
7136 | 7136 | 595 | 1994-10-16 | 772 | 49 | 862 | 0 | 2023-03-13 20:38:18 |
7229 | 7229 | 634 | 1994-09-11 | 997 | 49 | 514 | 0 | 2023-03-13 20:38:18 |
7318 | 7318 | 688 | 2011-10-22 | 1591 | 49 | 846 | 0 | 2023-03-13 20:38:18 |
7325 | 7325 | 688 | 2013-02-11 | 1591 | 49 | 846 | 0 | 2023-03-13 20:38:18 |
7869 | 7869 | 711 | 1977-03-15 | 244 | 49 | 944 | 0 | 2023-03-13 20:38:18 |
8189 | 8189 | 713 | 1984-05-14 | 244 | 49 | 1114 | 0 | 2023-03-13 20:38:18 |
8201 | 8201 | 713 | 1984-05-29 | 244 | 49 | 1114 | 0 | 2023-03-13 20:38:18 |
9191 | 9191 | 810 | 1997-01-07 | 507 | 49 | 1098 | 0 | 2023-03-13 20:38:18 |
9301 | 9301 | 855 | 2017-06-13 | 94 | 49 | 1510 | 1 | 2023-03-13 20:38:18 |
9789 | 9789 | 753 | 1993-03-24 | 1411 | 49 | 49 | 1 | 2023-03-13 20:38:18 |
9900 | 9900 | 211 | 1992-07-11 | 1758 | 49 | 68 | 1 | 2023-03-13 20:38:18 |
9990 | 9990 | 176 | 1971-12-08 | 26 | 49 | 79 | 1 | 2023-03-13 20:38:18 |
10079 | 10079 | 396 | 1987-10-21 | 723 | 49 | 92 | 1 | 2023-03-13 20:38:18 |
10303 | 10303 | 101 | 1946-03-26 | 1292 | 49 | 125 | 1 | 2023-03-13 20:38:18 |
10305 | 10305 | 101 | 1946-03-26 | 94 | 49 | 125 | 1 | 2023-03-13 20:38:18 |
10365 | 10365 | 211 | 1991-12-23 | 1758 | 49 | 132 | 1 | 2023-03-13 20:38:18 |
10493 | 10493 | 627 | 1989-11-07 | 742 | 49 | 148 | 1 | 2023-03-13 20:38:18 |
10622 | 10622 | 250 | 1966-12-01 | 543 | 49 | 170 | 1 | 2023-03-13 20:38:18 |
10862 | 10862 | 460 | 1968-03-22 | 94 | 49 | 203 | 1 | 2023-03-13 20:38:18 |
10918 | 10918 | 451 | 1999-12-09 | 878 | 49 | 212 | 1 | 2023-03-13 20:38:18 |
11666 | 11666 | 250 | 1965-10-26 | 543 | 49 | 326 | 1 | 2023-03-13 20:38:18 |
11739 | 11739 | 460 | 1966-05-27 | 94 | 49 | 339 | 1 | 2023-03-13 20:38:18 |
11949 | 11949 | 396 | 1985-11-28 | 723 | 49 | 375 | 1 | 2023-03-13 20:38:18 |
12135 | 12135 | 754 | 1996-03-11 | 1253 | 49 | 402 | 1 | 2023-03-13 20:38:18 |
12188 | 12188 | 541 | 1947-11-13 | 1605 | 49 | 408 | 1 | 2023-03-13 20:38:18 |
12674 | 12674 | 742 | 1956-01-11 | 1253 | 49 | 479 | 1 | 2023-03-13 20:38:18 |
13260 | 13260 | 635 | 1977-12-19 | 235 | 49 | 563 | 1 | 2023-03-13 20:38:18 |
13313 | 13313 | 737 | 1945-07-13 | 1253 | 49 | 574 | 1 | 2023-03-13 20:38:18 |
13525 | 13525 | 211 | 1992-06-05 | 1758 | 49 | 605 | 1 | 2023-03-13 20:38:18 |
13562 | 13562 | 601 | 2008-10-30 | 448 | 49 | 612 | 1 | 2023-03-13 20:38:18 |
13665 | 13665 | 737 | 1945-07-06 | 1253 | 49 | 632 | 1 | 2023-03-13 20:38:18 |
14042 | 14042 | 667 | 1959-05-19 | 451 | 49 | 694 | 1 | 2023-03-13 20:38:18 |
14247 | 14247 | 211 | 1993-05-28 | 1758 | 49 | 730 | 1 | 2023-03-13 20:38:18 |
14340 | 14340 | 437 | 1958-12-22 | 451 | 49 | 741 | 1 | 2023-03-13 20:38:18 |
14474 | 14474 | 437 | 1956-10-12 | 451 | 49 | 761 | 1 | 2023-03-13 20:38:18 |
14599 | 14599 | 373 | 1967-12-14 | 26 | 49 | 777 | 1 | 2023-03-13 20:38:18 |
14604 | 14604 | 595 | 1994-11-17 | 772 | 49 | 778 | 1 | 2023-03-13 20:38:18 |
14845 | 14845 | 21 | 1951-12-13 | 35 | 49 | 814 | 1 | 2023-03-13 20:38:18 |
14849 | 14849 | 101 | 1945-04-17 | 1292 | 49 | 815 | 1 | 2023-03-13 20:38:18 |
14851 | 14851 | 101 | 1945-04-17 | 94 | 49 | 815 | 1 | 2023-03-13 20:38:18 |
15928 | 15928 | 767 | 1939-12-13 | 26 | 49 | 973 | 1 | 2023-03-13 20:38:18 |
15950 | 15950 | 768 | 1934-03-22 | 35 | 49 | 975 | 1 | 2023-03-13 20:38:18 |
15959 | 15959 | 768 | 1931-12-17 | 35 | 49 | 976 | 1 | 2023-03-13 20:38:18 |
15985 | 15985 | 774 | 1925-12-17 | 35 | 49 | 979 | 1 | 2023-03-13 20:38:18 |
16121 | 16121 | 737 | 1943-09-21 | 1253 | 49 | 994 | 1 | 2023-03-13 20:38:18 |
16747 | 16747 | 810 | 1996-03-06 | 507 | 49 | 1097 | 1 | 2023-03-13 20:38:18 |
16752 | 16752 | 810 | 1996-06-28 | 507 | 49 | 1098 | 1 | 2023-03-13 20:38:18 |
16757 | 16757 | 810 | 1997-06-30 | 507 | 49 | 1099 | 1 | 2023-03-13 20:38:18 |
16763 | 16763 | 810 | 1999-01-11 | 507 | 49 | 1100 | 1 | 2023-03-13 20:38:18 |
17202 | 17202 | 828 | 2014-10-02 | 1546 | 49 | 1149 | 1 | 2023-03-13 20:38:18 |
17324 | 17324 | 855 | 2015-05-29 | 94 | 49 | 1163 | 1 | 2023-03-13 20:38:18 |
17989 | 17989 | 873 | 1911-06-18 | 2423 | 49 | 1285 | 1 | 2023-03-13 20:38:18 |
18900 | 18900 | 1003 | 2016-03-23 | 220 | 49 | 1483 | 1 | 2023-03-13 20:38:18 |
18965 | 18965 | 1003 | 2016-09-01 | 220 | 49 | 1491 | 1 | 2023-03-13 20:38:18 |
19144 | 19144 | 1017 | 2018-01-17 | 104 | 49 | 1517 | 1 | 2023-03-13 20:38:18 |
19231 | 19231 | 1003 | 2018-03-22 | 220 | 49 | 1529 | 1 | 2023-03-13 20:38:18 |
19857 | 19857 | 1017 | 2019-01-22 | 104 | 49 | 1594 | 1 | 2023-03-13 20:38:18 |
20026 | 20026 | 1017 | 2020-01-24 | 104 | 49 | 1617 | 1 | 2023-03-13 20:38:18 |
20170 | 20170 | 1032 | 2018-07-09 | 408 | 49 | 1635 | 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 );