viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by seats
This data as json, CSV (advanced)
Suggested facets: calculation_date (date)
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
- …
Link | rowid | election_id | date | party_id | seats ▼ | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
6139 | 6139 | 1033 | 1921-02-20 | 2703 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
6140 | 6140 | 1033 | 1921-02-20 | 2704 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
6142 | 6142 | 1033 | 1921-02-20 | 2289 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
19474 | 19474 | 1033 | 1921-05-10 | 2703 | 0 | 1561 | 1 | 2023-03-13 20:38:18 |
19475 | 19475 | 1033 | 1921-05-10 | 2704 | 0 | 1561 | 1 | 2023-03-13 20:38:18 |
19477 | 19477 | 1033 | 1921-05-10 | 2289 | 0 | 1561 | 1 | 2023-03-13 20:38:18 |
19487 | 19487 | 1033 | 1921-10-26 | 2703 | 0 | 1562 | 1 | 2023-03-13 20:38:18 |
19488 | 19488 | 1033 | 1921-10-26 | 2704 | 0 | 1562 | 1 | 2023-03-13 20:38:18 |
19490 | 19490 | 1033 | 1921-10-26 | 2289 | 0 | 1562 | 1 | 2023-03-13 20:38:18 |
19500 | 19500 | 1033 | 1922-01-31 | 2703 | 0 | 1563 | 1 | 2023-03-13 20:38:18 |
19501 | 19501 | 1033 | 1922-01-31 | 2704 | 0 | 1563 | 1 | 2023-03-13 20:38:18 |
19503 | 19503 | 1033 | 1922-01-31 | 2289 | 0 | 1563 | 1 | 2023-03-13 20:38:18 |
19513 | 19513 | 1033 | 1922-03-31 | 2703 | 0 | 1564 | 1 | 2023-03-13 20:38:18 |
19514 | 19514 | 1033 | 1922-03-31 | 2704 | 0 | 1564 | 1 | 2023-03-13 20:38:18 |
19516 | 19516 | 1033 | 1922-03-31 | 2289 | 0 | 1564 | 1 | 2023-03-13 20:38:18 |
20611 | 20611 | 1029 | 1945-04-27 | 769 | 0 | 452 | 1 | 2023-03-13 20:38:18 |
20612 | 20612 | 882 | 1944-09-26 | 167 | 0 | 593 | 1 | 2023-03-13 20:38:18 |
20613 | 20613 | 882 | 1944-09-26 | 1051 | 0 | 593 | 1 | 2023-03-13 20:38:18 |
20614 | 20614 | 882 | 1944-12-12 | 167 | 0 | 29 | 1 | 2023-03-13 20:38:18 |
20615 | 20615 | 882 | 1944-12-12 | 1051 | 0 | 29 | 1 | 2023-03-13 20:38:18 |
20616 | 20616 | 882 | 1945-02-12 | 167 | 0 | 808 | 1 | 2023-03-13 20:38:18 |
20617 | 20617 | 882 | 1945-02-12 | 1051 | 0 | 808 | 1 | 2023-03-13 20:38:18 |
20618 | 20618 | 882 | 1945-08-02 | 167 | 0 | 204 | 1 | 2023-03-13 20:38:18 |
20619 | 20619 | 342 | 1993-02-28 | 1071 | 0 | 645 | 1 | 2023-03-13 20:38:18 |
20620 | 20620 | 330 | 1998-02-28 | 1151 | 0 | 731 | 1 | 2023-03-13 20:38:18 |
20621 | 20621 | 301 | 1998-01-02 | 688 | 0 | 76 | 1 | 2023-03-13 20:38:18 |
20622 | 20622 | 901 | 1945-05-05 | 1239 | 0 | 10 | 1 | 2023-03-13 20:38:18 |
20623 | 20623 | 983 | 1944-11-10 | 1086 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20624 | 20624 | 983 | 1944-11-10 | 1094 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20625 | 20625 | 983 | 1944-11-10 | 1297 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20626 | 20626 | 75 | 1947-11-24 | 890 | 0 | 753 | 1 | 2023-03-13 20:38:18 |
20627 | 20627 | 75 | 1948-08-31 | 890 | 0 | 363 | 1 | 2023-03-13 20:38:18 |
20628 | 20628 | 375 | 1959-01-08 | 401 | 0 | 692 | 1 | 2023-03-13 20:38:18 |
20629 | 20629 | 386 | 1972-07-06 | 885 | 0 | 430 | 1 | 2023-03-13 20:38:18 |
20630 | 20630 | 503 | 1947-05-31 | 242 | 0 | 501 | 1 | 2023-03-13 20:38:18 |
20631 | 20631 | 498 | 2005-05-28 | 93 | 0 | 567 | 1 | 2023-03-13 20:38:18 |
20632 | 20632 | 534 | 1998-04-08 | 1368 | 0 | 2 | 1 | 2023-03-13 20:38:18 |
20633 | 20633 | 936 | 1944-11-23 | 1234 | 0 | 340 | 1 | 2023-03-13 20:38:18 |
20634 | 20634 | 942 | 1945-06-24 | 451 | 0 | 767 | 1 | 2023-03-13 20:38:18 |
20635 | 20635 | 158 | 1991-01-12 | 1544 | 0 | 75 | 1 | 2023-03-13 20:38:18 |
20636 | 20636 | 158 | 1991-01-12 | 369 | 0 | 75 | 1 | 2023-03-13 20:38:18 |
20637 | 20637 | 129 | 1992-04-22 | 143 | 0 | 9 | 1 | 2023-03-13 20:38:18 |
20638 | 20638 | 403 | 2007-05-18 | 1058 | 0 | 807 | 1 | 2023-03-13 20:38:18 |
20639 | 20639 | 165 | 2004-12-29 | 5 | 0 | 509 | 1 | 2023-03-13 20:38:18 |
20640 | 20640 | 194 | 2009-04-14 | 1617 | 0 | 162 | 1 | 2023-03-13 20:38:18 |
20641 | 20641 | 32 | 1992-12-30 | 133 | 0 | 462 | 1 | 2023-03-13 20:38:18 |
20642 | 20642 | 127 | 1988-02-28 | 534 | 0 | 784 | 1 | 2023-03-13 20:38:18 |
20643 | 20643 | 416 | 1992-11-13 | 761 | 0 | 839 | 1 | 2023-03-13 20:38:18 |
20644 | 20644 | 416 | 1994-08-18 | 761 | 0 | 447 | 1 | 2023-03-13 20:38:18 |
20645 | 20645 | 416 | 1996-09-02 | 761 | 0 | 102 | 1 | 2023-03-13 20:38:18 |
20646 | 20646 | 605 | 1993-04-29 | 2001 | 0 | 801 | 1 | 2023-03-13 20:38:18 |
20647 | 20647 | 551 | 1999-12-21 | 399 | 0 | 522 | 1 | 2023-03-13 20:38:18 |
20648 | 20648 | 551 | 1999-12-21 | 961 | 0 | 522 | 1 | 2023-03-13 20:38:18 |
20649 | 20649 | 551 | 2000-04-28 | 399 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20650 | 20650 | 551 | 2000-04-28 | 961 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20651 | 20651 | 32 | 1994-10-16 | 133 | 0 | 109 | 1 | 2023-03-13 20:38:18 |
20652 | 20652 | 49 | 1999-12-21 | 761 | 0 | 171 | 1 | 2023-03-13 20:38:18 |
20653 | 20653 | 508 | 1989-11-23 | 1358 | 0 | 454 | 1 | 2023-03-13 20:38:18 |
20654 | 20654 | 205 | 1989-10-11 | 1358 | 0 | 721 | 1 | 2023-03-13 20:38:18 |
20655 | 20655 | 508 | 1990-02-13 | 1358 | 0 | 716 | 1 | 2023-03-13 20:38:18 |
20656 | 20656 | 633 | 1991-10-16 | 761 | 0 | 710 | 1 | 2023-03-13 20:38:18 |
20657 | 20657 | 71 | 1958-04-25 | 1119 | 0 | 791 | 1 | 2023-03-13 20:38:18 |
20658 | 20658 | 71 | 1957-11-29 | 1119 | 0 | 860 | 1 | 2023-03-13 20:38:18 |
20659 | 20659 | 354 | 1963-12-18 | 1119 | 0 | 332 | 1 | 2023-03-13 20:38:18 |
20660 | 20660 | 636 | 1975-06-13 | 1119 | 0 | 143 | 1 | 2023-03-13 20:38:18 |
20661 | 20661 | 77 | 1970-05-14 | 1119 | 0 | 707 | 1 | 2023-03-13 20:38:18 |
20662 | 20662 | 77 | 1971-10-29 | 1119 | 0 | 391 | 1 | 2023-03-13 20:38:18 |
20663 | 20663 | 71 | 1957-09-02 | 1108 | 0 | 631 | 1 | 2023-03-13 20:38:18 |
20664 | 20664 | 357 | 1976-08-17 | 401 | 0 | 21 | 1 | 2023-03-13 20:38:18 |
20665 | 20665 | 101 | 1945-04-17 | 1119 | 0 | 815 | 1 | 2023-03-13 20:38:18 |
20666 | 20666 | 534 | 1995-12-21 | 288 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20667 | 20667 | 534 | 1997-02-13 | 288 | 0 | 377 | 1 | 2023-03-13 20:38:18 |
20668 | 20668 | 200 | 1978-08-29 | 729 | 0 | 542 | 1 | 2023-03-13 20:38:18 |
20669 | 20669 | 297 | 1944-11-17 | 1292 | 0 | 120 | 1 | 2023-03-13 20:38:18 |
20670 | 20670 | 297 | 1944-11-17 | 1119 | 0 | 120 | 1 | 2023-03-13 20:38:18 |
20671 | 20671 | 534 | 1995-12-21 | 1368 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20672 | 20672 | 534 | 1995-12-21 | 1001 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20673 | 20673 | 534 | 1997-02-13 | 1368 | 0 | 377 | 1 | 2023-03-13 20:38:18 |
20674 | 20674 | 534 | 1997-08-07 | 1368 | 0 | 878 | 1 | 2023-03-13 20:38:18 |
20675 | 20675 | 534 | 1997-02-13 | 1001 | 0 | 377 | 1 | 2023-03-13 20:38:18 |
20676 | 20676 | 864 | 1945-06-25 | 17 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
20677 | 20677 | 864 | 1945-06-25 | 27 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
20678 | 20678 | 339 | 2001-05-27 | 1151 | 0 | 910 | 1 | 2023-03-13 20:38:18 |
20679 | 20679 | 330 | 1996-05-26 | 1071 | 0 | 911 | 1 | 2023-03-13 20:38:18 |
20680 | 20680 | 342 | 1991-05-19 | 534 | 0 | 912 | 1 | 2023-03-13 20:38:18 |
20681 | 20681 | 651 | 2011-11-11 | 1358 | 0 | 984 | 1 | 2023-03-13 20:38:18 |
20682 | 20682 | 111 | 2011-11-16 | 2001 | 0 | 983 | 1 | 2023-03-13 20:38:18 |
20683 | 20683 | 551 | 2000-04-28 | 1278 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20684 | 20684 | 551 | 1998-10-21 | 1278 | 0 | 214 | 1 | 2023-03-13 20:38:18 |
20685 | 20685 | 551 | 2000-04-28 | 2001 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20686 | 20686 | 146 | 1995-01-17 | 2001 | 0 | 382 | 1 | 2023-03-13 20:38:18 |
20687 | 20687 | 146 | 1996-01-11 | 2001 | 0 | 991 | 1 | 2023-03-13 20:38:18 |
20688 | 20688 | 724 | 1917-02-17 | 1905 | 0 | 1008 | 1 | 2023-03-13 20:38:18 |
20689 | 20689 | 780 | 1942-12-16 | 134 | 0 | 1025 | 1 | 2023-03-13 20:38:18 |
20690 | 20690 | 336 | 2000-12-20 | 1601 | 0 | 64 | 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 |
20693 | 20693 | 57 | 1993-08-06 | 163 | 0 | 417 | 1 | 2023-03-13 20:38:18 |
20694 | 20694 | 171 | 2012-05-15 | 873 | 0 | 1037 | 1 | 2023-03-13 20:38:18 |
20695 | 20695 | 171 | 2012-05-15 | 1492 | 0 | 1037 | 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 );