viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by seats
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id | seats ▼ | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
20696 | 20696 | 783 | 2012-05-16 | 1358 | 0 | 1039 | 1 | 2023-03-13 20:38:18 |
20697 | 20697 | 79 | 2013-03-13 | 133 | 0 | 1045 | 1 | 2023-03-13 20:38:18 |
20698 | 20698 | 797 | 2002-07-30 | 90 | 0 | 1051 | 1 | 2023-03-13 20:38:18 |
20699 | 20699 | 795 | 2003-12-23 | 1081 | 0 | 1052 | 1 | 2023-03-13 20:38:18 |
20700 | 20700 | 799 | 2013-05-29 | 133 | 0 | 1058 | 1 | 2023-03-13 20:38:18 |
20701 | 20701 | 301 | 1998-01-02 | 1567 | 0 | 76 | 1 | 2023-03-13 20:38:18 |
20702 | 20702 | 247 | 1975-09-19 | 729 | 0 | 1067 | 1 | 2023-03-13 20:38:18 |
20703 | 20703 | 789 | 2013-04-27 | 1296 | 0 | 1048 | 1 | 2023-03-13 20:38:18 |
20704 | 20704 | 789 | 2013-11-18 | 1296 | 0 | 1068 | 1 | 2023-03-13 20:38:18 |
20705 | 20705 | 789 | 2014-02-22 | 1296 | 0 | 1079 | 1 | 2023-03-13 20:38:18 |
20706 | 20706 | 704 | 1949-01-25 | 123 | 0 | 1084 | 1 | 2023-03-13 20:38:18 |
20707 | 20707 | 787 | 2014-03-04 | 2002 | 0 | 1085 | 1 | 2023-03-13 20:38:18 |
20708 | 20708 | 983 | 1944-11-10 | 947 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20709 | 20709 | 799 | 2014-08-05 | 133 | 0 | 1139 | 1 | 2023-03-13 20:38:18 |
20710 | 20710 | 75 | 1948-09-10 | 890 | 0 | 355 | 1 | 2023-03-13 20:38:18 |
20711 | 20711 | 496 | 1981-05-22 | 1492 | 0 | 1148 | 1 | 2023-03-13 20:38:18 |
20712 | 20712 | 293 | 1954-06-19 | 890 | 0 | 414 | 1 | 2023-03-13 20:38:18 |
20713 | 20713 | 312 | 1956-01-31 | 890 | 0 | 591 | 1 | 2023-03-13 20:38:18 |
20714 | 20714 | 787 | 2014-12-15 | 2002 | 0 | 1154 | 1 | 2023-03-13 20:38:18 |
20715 | 20715 | 993 | 2015-10-30 | 251 | 0 | 1177 | 1 | 2023-03-13 20:38:18 |
20716 | 20716 | 965 | 1921-02-23 | 786 | 0 | 1191 | 1 | 2023-03-13 20:38:18 |
20717 | 20717 | 965 | 1920-10-27 | 786 | 0 | 1192 | 1 | 2023-03-13 20:38:18 |
20718 | 20718 | 787 | 2015-11-10 | 761 | 0 | 1197 | 1 | 2023-03-13 20:38:18 |
20719 | 20719 | 904 | 1924-01-18 | 1119 | 0 | 1213 | 1 | 2023-03-13 20:38:18 |
20720 | 20720 | 903 | 1922-06-02 | 1119 | 0 | 1215 | 1 | 2023-03-13 20:38:18 |
20721 | 20721 | 902 | 1918-11-27 | 1118 | 0 | 1220 | 1 | 2023-03-13 20:38:18 |
20722 | 20722 | 902 | 1918-11-27 | 1219 | 0 | 1220 | 1 | 2023-03-13 20:38:18 |
20723 | 20723 | 961 | 1914-02-17 | 786 | 0 | 1369 | 1 | 2023-03-13 20:38:18 |
20724 | 20724 | 961 | 1914-02-17 | 2608 | 0 | 1369 | 1 | 2023-03-13 20:38:18 |
20725 | 20725 | 963 | 1917-03-13 | 2608 | 0 | 1368 | 1 | 2023-03-13 20:38:18 |
20726 | 20726 | 963 | 1917-03-13 | 786 | 0 | 1368 | 1 | 2023-03-13 20:38:18 |
20727 | 20727 | 963 | 1914-09-13 | 786 | 0 | 1371 | 1 | 2023-03-13 20:38:18 |
20728 | 20728 | 963 | 1914-09-13 | 2608 | 0 | 1371 | 1 | 2023-03-13 20:38:18 |
20729 | 20729 | 782 | 2016-02-11 | 2813 | 0 | 1406 | 1 | 2023-03-13 20:38:18 |
20730 | 20730 | 1001 | 2016-01-22 | 2197 | 0 | 1408 | 1 | 2023-03-13 20:38:18 |
20731 | 20731 | 987 | 1906-03-14 | 2590 | 0 | 1409 | 1 | 2023-03-13 20:38:18 |
20732 | 20732 | 988 | 1910-11-03 | 401 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
20733 | 20733 | 988 | 1910-11-03 | 2587 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
20734 | 20734 | 988 | 1911-03-02 | 401 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
20735 | 20735 | 988 | 1911-03-02 | 2587 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
20736 | 20736 | 988 | 1911-06-27 | 401 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
20737 | 20737 | 988 | 1912-01-14 | 2587 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
20738 | 20738 | 988 | 1912-01-14 | 401 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
20739 | 20739 | 988 | 1913-03-22 | 2587 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
20740 | 20740 | 988 | 1913-03-22 | 401 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
20741 | 20741 | 988 | 1913-12-22 | 401 | 0 | 1398 | 1 | 2023-03-13 20:38:18 |
20742 | 20742 | 988 | 1913-12-22 | 2587 | 0 | 1398 | 1 | 2023-03-13 20:38:18 |
20743 | 20743 | 989 | 1914-06-09 | 2587 | 0 | 1399 | 1 | 2023-03-13 20:38:18 |
20744 | 20744 | 989 | 1914-06-13 | 2587 | 0 | 1400 | 1 | 2023-03-13 20:38:18 |
20745 | 20745 | 989 | 1915-10-29 | 2593 | 0 | 1402 | 1 | 2023-03-13 20:38:18 |
20746 | 20746 | 989 | 1917-03-20 | 2587 | 0 | 1404 | 1 | 2023-03-13 20:38:18 |
20747 | 20747 | 989 | 1917-11-16 | 2587 | 0 | 1359 | 1 | 2023-03-13 20:38:18 |
20748 | 20748 | 990 | 1920-01-20 | 947 | 0 | 1358 | 1 | 2023-03-13 20:38:18 |
20749 | 20749 | 990 | 1920-02-18 | 947 | 0 | 1357 | 1 | 2023-03-13 20:38:18 |
20750 | 20750 | 991 | 1924-06-14 | 2594 | 0 | 1352 | 1 | 2023-03-13 20:38:18 |
20751 | 20751 | 991 | 1925-04-17 | 2594 | 0 | 1351 | 1 | 2023-03-13 20:38:18 |
20752 | 20752 | 991 | 1925-11-28 | 2594 | 0 | 1350 | 1 | 2023-03-13 20:38:18 |
20753 | 20753 | 991 | 1925-11-28 | 2585 | 0 | 1350 | 1 | 2023-03-13 20:38:18 |
20754 | 20754 | 991 | 1926-07-19 | 2594 | 0 | 1348 | 1 | 2023-03-13 20:38:18 |
20755 | 20755 | 991 | 1926-07-19 | 2585 | 0 | 1348 | 1 | 2023-03-13 20:38:18 |
20756 | 20756 | 991 | 1926-07-23 | 2594 | 0 | 1347 | 1 | 2023-03-13 20:38:18 |
20757 | 20757 | 991 | 1926-07-23 | 2585 | 0 | 1347 | 1 | 2023-03-13 20:38:18 |
20758 | 20758 | 985 | 1930-03-02 | 2583 | 0 | 1342 | 1 | 2023-03-13 20:38:18 |
20759 | 20759 | 985 | 1931-01-27 | 2583 | 0 | 1340 | 1 | 2023-03-13 20:38:18 |
20760 | 20760 | 985 | 1932-02-20 | 2583 | 0 | 1338 | 1 | 2023-03-13 20:38:18 |
20761 | 20761 | 984 | 1935-06-07 | 947 | 0 | 1328 | 1 | 2023-03-13 20:38:18 |
20762 | 20762 | 983 | 1938-04-12 | 2587 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20763 | 20763 | 983 | 1938-04-12 | 2585 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20764 | 20764 | 983 | 1938-04-12 | 2583 | 0 | 1304 | 1 | 2023-03-13 20:38:18 |
20765 | 20765 | 984 | 1932-06-03 | 2617 | 0 | 1337 | 1 | 2023-03-13 20:38:18 |
20766 | 20766 | 984 | 1932-12-18 | 2617 | 0 | 1336 | 1 | 2023-03-13 20:38:18 |
20767 | 20767 | 984 | 1933-01-31 | 2617 | 0 | 1335 | 1 | 2023-03-13 20:38:18 |
20768 | 20768 | 984 | 1933-10-26 | 2617 | 0 | 1334 | 1 | 2023-03-13 20:38:18 |
20769 | 20769 | 984 | 1933-11-26 | 2617 | 0 | 1333 | 1 | 2023-03-13 20:38:18 |
20770 | 20770 | 984 | 1934-02-09 | 2618 | 0 | 1331 | 1 | 2023-03-13 20:38:18 |
20771 | 20771 | 984 | 1935-06-01 | 2618 | 0 | 1329 | 1 | 2023-03-13 20:38:18 |
20772 | 20772 | 984 | 1935-06-07 | 2618 | 0 | 1328 | 1 | 2023-03-13 20:38:18 |
20773 | 20773 | 989 | 1914-08-26 | 2587 | 0 | 1401 | 1 | 2023-03-13 20:38:18 |
20774 | 20774 | 983 | 1939-05-11 | 2587 | 0 | 1303 | 1 | 2023-03-13 20:38:18 |
20775 | 20775 | 983 | 1939-05-11 | 2585 | 0 | 1303 | 1 | 2023-03-13 20:38:18 |
20776 | 20776 | 983 | 1939-09-13 | 2587 | 0 | 1302 | 1 | 2023-03-13 20:38:18 |
20777 | 20777 | 988 | 1910-05-08 | 401 | 0 | 1412 | 1 | 2023-03-13 20:38:18 |
20778 | 20778 | 988 | 1910-05-08 | 2587 | 0 | 1412 | 1 | 2023-03-13 20:38:18 |
20779 | 20779 | 988 | 1911-06-27 | 2587 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
20780 | 20780 | 988 | 1913-01-21 | 2587 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
20781 | 20781 | 988 | 1913-01-21 | 401 | 0 | 1396 | 1 | 2023-03-13 20:38:18 |
20782 | 20782 | 985 | 1932-01-14 | 2583 | 0 | 1414 | 1 | 2023-03-13 20:38:18 |
20783 | 20783 | 983 | 1940-03-22 | 2587 | 0 | 1415 | 1 | 2023-03-13 20:38:18 |
20784 | 20784 | 983 | 1940-03-22 | 2617 | 0 | 1415 | 1 | 2023-03-13 20:38:18 |
20785 | 20785 | 983 | 1940-06-16 | 947 | 0 | 1416 | 1 | 2023-03-13 20:38:18 |
20786 | 20786 | 983 | 1940-06-16 | 2617 | 0 | 1416 | 1 | 2023-03-13 20:38:18 |
20787 | 20787 | 923 | 1923-10-27 | 2561 | 0 | 1426 | 1 | 2023-03-13 20:38:18 |
20788 | 20788 | 934 | 1932-04-11 | 2140 | 0 | 1451 | 1 | 2023-03-13 20:38:18 |
20789 | 20789 | 247 | 1975-04-25 | 729 | 0 | 1477 | 1 | 2023-03-13 20:38:18 |
20790 | 20790 | 892 | 1920-03-30 | 1128 | 0 | 1480 | 1 | 2023-03-13 20:38:18 |
20791 | 20791 | 892 | 1920-04-05 | 1128 | 0 | 1481 | 1 | 2023-03-13 20:38:18 |
20792 | 20792 | 1004 | 2016-05-22 | 491 | 0 | 1492 | 1 | 2023-03-13 20:38:18 |
20793 | 20793 | 782 | 2016-12-06 | 2813 | 0 | 1498 | 1 | 2023-03-13 20:38:18 |
20794 | 20794 | 840 | 2017-01-25 | 982 | 0 | 1503 | 1 | 2023-03-13 20:38:18 |
20795 | 20795 | 840 | 2017-01-25 | 423 | 0 | 1503 | 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 );