viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
20741 | 20741 | 988 | 1913-12-22 | 401 | 0 | 1398 | 1 | 2023-03-13 20:38:18 |
20740 | 20740 | 988 | 1913-03-22 | 401 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
20739 | 20739 | 988 | 1913-03-22 | 2587 | 0 | 1397 | 1 | 2023-03-13 20:38:18 |
20738 | 20738 | 988 | 1912-01-14 | 401 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
20737 | 20737 | 988 | 1912-01-14 | 2587 | 0 | 1395 | 1 | 2023-03-13 20:38:18 |
20736 | 20736 | 988 | 1911-06-27 | 401 | 0 | 1394 | 1 | 2023-03-13 20:38:18 |
20735 | 20735 | 988 | 1911-03-02 | 2587 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
20734 | 20734 | 988 | 1911-03-02 | 401 | 0 | 1393 | 1 | 2023-03-13 20:38:18 |
20733 | 20733 | 988 | 1910-11-03 | 2587 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
20732 | 20732 | 988 | 1910-11-03 | 401 | 0 | 1392 | 1 | 2023-03-13 20:38:18 |
20731 | 20731 | 987 | 1906-03-14 | 2590 | 0 | 1409 | 1 | 2023-03-13 20:38:18 |
20730 | 20730 | 1001 | 2016-01-22 | 2197 | 0 | 1408 | 1 | 2023-03-13 20:38:18 |
20729 | 20729 | 782 | 2016-02-11 | 2813 | 0 | 1406 | 1 | 2023-03-13 20:38:18 |
20728 | 20728 | 963 | 1914-09-13 | 2608 | 0 | 1371 | 1 | 2023-03-13 20:38:18 |
20727 | 20727 | 963 | 1914-09-13 | 786 | 0 | 1371 | 1 | 2023-03-13 20:38:18 |
20726 | 20726 | 963 | 1917-03-13 | 786 | 0 | 1368 | 1 | 2023-03-13 20:38:18 |
20725 | 20725 | 963 | 1917-03-13 | 2608 | 0 | 1368 | 1 | 2023-03-13 20:38:18 |
20724 | 20724 | 961 | 1914-02-17 | 2608 | 0 | 1369 | 1 | 2023-03-13 20:38:18 |
20723 | 20723 | 961 | 1914-02-17 | 786 | 0 | 1369 | 1 | 2023-03-13 20:38:18 |
20722 | 20722 | 902 | 1918-11-27 | 1219 | 0 | 1220 | 1 | 2023-03-13 20:38:18 |
20721 | 20721 | 902 | 1918-11-27 | 1118 | 0 | 1220 | 1 | 2023-03-13 20:38:18 |
20720 | 20720 | 903 | 1922-06-02 | 1119 | 0 | 1215 | 1 | 2023-03-13 20:38:18 |
20719 | 20719 | 904 | 1924-01-18 | 1119 | 0 | 1213 | 1 | 2023-03-13 20:38:18 |
20718 | 20718 | 787 | 2015-11-10 | 761 | 0 | 1197 | 1 | 2023-03-13 20:38:18 |
20717 | 20717 | 965 | 1920-10-27 | 786 | 0 | 1192 | 1 | 2023-03-13 20:38:18 |
20716 | 20716 | 965 | 1921-02-23 | 786 | 0 | 1191 | 1 | 2023-03-13 20:38:18 |
20715 | 20715 | 993 | 2015-10-30 | 251 | 0 | 1177 | 1 | 2023-03-13 20:38:18 |
20714 | 20714 | 787 | 2014-12-15 | 2002 | 0 | 1154 | 1 | 2023-03-13 20:38:18 |
20713 | 20713 | 312 | 1956-01-31 | 890 | 0 | 591 | 1 | 2023-03-13 20:38:18 |
20712 | 20712 | 293 | 1954-06-19 | 890 | 0 | 414 | 1 | 2023-03-13 20:38:18 |
20711 | 20711 | 496 | 1981-05-22 | 1492 | 0 | 1148 | 1 | 2023-03-13 20:38:18 |
20710 | 20710 | 75 | 1948-09-10 | 890 | 0 | 355 | 1 | 2023-03-13 20:38:18 |
20709 | 20709 | 799 | 2014-08-05 | 133 | 0 | 1139 | 1 | 2023-03-13 20:38:18 |
20708 | 20708 | 983 | 1944-11-10 | 947 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20707 | 20707 | 787 | 2014-03-04 | 2002 | 0 | 1085 | 1 | 2023-03-13 20:38:18 |
20706 | 20706 | 704 | 1949-01-25 | 123 | 0 | 1084 | 1 | 2023-03-13 20:38:18 |
20705 | 20705 | 789 | 2014-02-22 | 1296 | 0 | 1079 | 1 | 2023-03-13 20:38:18 |
20704 | 20704 | 789 | 2013-11-18 | 1296 | 0 | 1068 | 1 | 2023-03-13 20:38:18 |
20703 | 20703 | 789 | 2013-04-27 | 1296 | 0 | 1048 | 1 | 2023-03-13 20:38:18 |
20702 | 20702 | 247 | 1975-09-19 | 729 | 0 | 1067 | 1 | 2023-03-13 20:38:18 |
20701 | 20701 | 301 | 1998-01-02 | 1567 | 0 | 76 | 1 | 2023-03-13 20:38:18 |
20700 | 20700 | 799 | 2013-05-29 | 133 | 0 | 1058 | 1 | 2023-03-13 20:38:18 |
20699 | 20699 | 795 | 2003-12-23 | 1081 | 0 | 1052 | 1 | 2023-03-13 20:38:18 |
20698 | 20698 | 797 | 2002-07-30 | 90 | 0 | 1051 | 1 | 2023-03-13 20:38:18 |
20697 | 20697 | 79 | 2013-03-13 | 133 | 0 | 1045 | 1 | 2023-03-13 20:38:18 |
20696 | 20696 | 783 | 2012-05-16 | 1358 | 0 | 1039 | 1 | 2023-03-13 20:38:18 |
20695 | 20695 | 171 | 2012-05-15 | 1492 | 0 | 1037 | 1 | 2023-03-13 20:38:18 |
20694 | 20694 | 171 | 2012-05-15 | 873 | 0 | 1037 | 1 | 2023-03-13 20:38:18 |
20693 | 20693 | 57 | 1993-08-06 | 163 | 0 | 417 | 1 | 2023-03-13 20:38:18 |
20692 | 20692 | 319 | 2012-05-07 | 5 | 0 | 1033 | 1 | 2023-03-13 20:38:18 |
20691 | 20691 | 336 | 2000-12-20 | 5 | 0 | 64 | 1 | 2023-03-13 20:38:18 |
20690 | 20690 | 336 | 2000-12-20 | 1601 | 0 | 64 | 1 | 2023-03-13 20:38:18 |
20689 | 20689 | 780 | 1942-12-16 | 134 | 0 | 1025 | 1 | 2023-03-13 20:38:18 |
20688 | 20688 | 724 | 1917-02-17 | 1905 | 0 | 1008 | 1 | 2023-03-13 20:38:18 |
20687 | 20687 | 146 | 1996-01-11 | 2001 | 0 | 991 | 1 | 2023-03-13 20:38:18 |
20686 | 20686 | 146 | 1995-01-17 | 2001 | 0 | 382 | 1 | 2023-03-13 20:38:18 |
20685 | 20685 | 551 | 2000-04-28 | 2001 | 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 |
20683 | 20683 | 551 | 2000-04-28 | 1278 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20682 | 20682 | 111 | 2011-11-16 | 2001 | 0 | 983 | 1 | 2023-03-13 20:38:18 |
20681 | 20681 | 651 | 2011-11-11 | 1358 | 0 | 984 | 1 | 2023-03-13 20:38:18 |
20680 | 20680 | 342 | 1991-05-19 | 534 | 0 | 912 | 1 | 2023-03-13 20:38:18 |
20679 | 20679 | 330 | 1996-05-26 | 1071 | 0 | 911 | 1 | 2023-03-13 20:38:18 |
20678 | 20678 | 339 | 2001-05-27 | 1151 | 0 | 910 | 1 | 2023-03-13 20:38:18 |
20677 | 20677 | 864 | 1945-06-25 | 27 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
20676 | 20676 | 864 | 1945-06-25 | 17 | 0 | 666 | 1 | 2023-03-13 20:38:18 |
20675 | 20675 | 534 | 1997-02-13 | 1001 | 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 |
20673 | 20673 | 534 | 1997-02-13 | 1368 | 0 | 377 | 1 | 2023-03-13 20:38:18 |
20672 | 20672 | 534 | 1995-12-21 | 1001 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20671 | 20671 | 534 | 1995-12-21 | 1368 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20670 | 20670 | 297 | 1944-11-17 | 1119 | 0 | 120 | 1 | 2023-03-13 20:38:18 |
20669 | 20669 | 297 | 1944-11-17 | 1292 | 0 | 120 | 1 | 2023-03-13 20:38:18 |
20668 | 20668 | 200 | 1978-08-29 | 729 | 0 | 542 | 1 | 2023-03-13 20:38:18 |
20667 | 20667 | 534 | 1997-02-13 | 288 | 0 | 377 | 1 | 2023-03-13 20:38:18 |
20666 | 20666 | 534 | 1995-12-21 | 288 | 0 | 235 | 1 | 2023-03-13 20:38:18 |
20665 | 20665 | 101 | 1945-04-17 | 1119 | 0 | 815 | 1 | 2023-03-13 20:38:18 |
20664 | 20664 | 357 | 1976-08-17 | 401 | 0 | 21 | 1 | 2023-03-13 20:38:18 |
20663 | 20663 | 71 | 1957-09-02 | 1108 | 0 | 631 | 1 | 2023-03-13 20:38:18 |
20662 | 20662 | 77 | 1971-10-29 | 1119 | 0 | 391 | 1 | 2023-03-13 20:38:18 |
20661 | 20661 | 77 | 1970-05-14 | 1119 | 0 | 707 | 1 | 2023-03-13 20:38:18 |
20660 | 20660 | 636 | 1975-06-13 | 1119 | 0 | 143 | 1 | 2023-03-13 20:38:18 |
20659 | 20659 | 354 | 1963-12-18 | 1119 | 0 | 332 | 1 | 2023-03-13 20:38:18 |
20658 | 20658 | 71 | 1957-11-29 | 1119 | 0 | 860 | 1 | 2023-03-13 20:38:18 |
20657 | 20657 | 71 | 1958-04-25 | 1119 | 0 | 791 | 1 | 2023-03-13 20:38:18 |
20656 | 20656 | 633 | 1991-10-16 | 761 | 0 | 710 | 1 | 2023-03-13 20:38:18 |
20655 | 20655 | 508 | 1990-02-13 | 1358 | 0 | 716 | 1 | 2023-03-13 20:38:18 |
20654 | 20654 | 205 | 1989-10-11 | 1358 | 0 | 721 | 1 | 2023-03-13 20:38:18 |
20653 | 20653 | 508 | 1989-11-23 | 1358 | 0 | 454 | 1 | 2023-03-13 20:38:18 |
20652 | 20652 | 49 | 1999-12-21 | 761 | 0 | 171 | 1 | 2023-03-13 20:38:18 |
20651 | 20651 | 32 | 1994-10-16 | 133 | 0 | 109 | 1 | 2023-03-13 20:38:18 |
20650 | 20650 | 551 | 2000-04-28 | 961 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20649 | 20649 | 551 | 2000-04-28 | 399 | 0 | 239 | 1 | 2023-03-13 20:38:18 |
20648 | 20648 | 551 | 1999-12-21 | 961 | 0 | 522 | 1 | 2023-03-13 20:38:18 |
20647 | 20647 | 551 | 1999-12-21 | 399 | 0 | 522 | 1 | 2023-03-13 20:38:18 |
20646 | 20646 | 605 | 1993-04-29 | 2001 | 0 | 801 | 1 | 2023-03-13 20:38:18 |
20645 | 20645 | 416 | 1996-09-02 | 761 | 0 | 102 | 1 | 2023-03-13 20:38:18 |
20644 | 20644 | 416 | 1994-08-18 | 761 | 0 | 447 | 1 | 2023-03-13 20:38:18 |
20643 | 20643 | 416 | 1992-11-13 | 761 | 0 | 839 | 1 | 2023-03-13 20:38:18 |
20642 | 20642 | 127 | 1988-02-28 | 534 | 0 | 784 | 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 );