viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|
20641 | 20641 | 32 | 1992-12-30 | 133 | 0 | 462 | 1 | 2023-03-13 20:38:18 |
20640 | 20640 | 194 | 2009-04-14 | 1617 | 0 | 162 | 1 | 2023-03-13 20:38:18 |
20639 | 20639 | 165 | 2004-12-29 | 5 | 0 | 509 | 1 | 2023-03-13 20:38:18 |
20638 | 20638 | 403 | 2007-05-18 | 1058 | 0 | 807 | 1 | 2023-03-13 20:38:18 |
20637 | 20637 | 129 | 1992-04-22 | 143 | 0 | 9 | 1 | 2023-03-13 20:38:18 |
20636 | 20636 | 158 | 1991-01-12 | 369 | 0 | 75 | 1 | 2023-03-13 20:38:18 |
20635 | 20635 | 158 | 1991-01-12 | 1544 | 0 | 75 | 1 | 2023-03-13 20:38:18 |
20634 | 20634 | 942 | 1945-06-24 | 451 | 0 | 767 | 1 | 2023-03-13 20:38:18 |
20633 | 20633 | 936 | 1944-11-23 | 1234 | 0 | 340 | 1 | 2023-03-13 20:38:18 |
20632 | 20632 | 534 | 1998-04-08 | 1368 | 0 | 2 | 1 | 2023-03-13 20:38:18 |
20631 | 20631 | 498 | 2005-05-28 | 93 | 0 | 567 | 1 | 2023-03-13 20:38:18 |
20630 | 20630 | 503 | 1947-05-31 | 242 | 0 | 501 | 1 | 2023-03-13 20:38:18 |
20629 | 20629 | 386 | 1972-07-06 | 885 | 0 | 430 | 1 | 2023-03-13 20:38:18 |
20628 | 20628 | 375 | 1959-01-08 | 401 | 0 | 692 | 1 | 2023-03-13 20:38:18 |
20627 | 20627 | 75 | 1948-08-31 | 890 | 0 | 363 | 1 | 2023-03-13 20:38:18 |
20626 | 20626 | 75 | 1947-11-24 | 890 | 0 | 753 | 1 | 2023-03-13 20:38:18 |
20625 | 20625 | 983 | 1944-11-10 | 1297 | 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 |
20623 | 20623 | 983 | 1944-11-10 | 1086 | 0 | 329 | 1 | 2023-03-13 20:38:18 |
20622 | 20622 | 901 | 1945-05-05 | 1239 | 0 | 10 | 1 | 2023-03-13 20:38:18 |
20621 | 20621 | 301 | 1998-01-02 | 688 | 0 | 76 | 1 | 2023-03-13 20:38:18 |
20620 | 20620 | 330 | 1998-02-28 | 1151 | 0 | 731 | 1 | 2023-03-13 20:38:18 |
20619 | 20619 | 342 | 1993-02-28 | 1071 | 0 | 645 | 1 | 2023-03-13 20:38:18 |
20618 | 20618 | 882 | 1945-08-02 | 167 | 0 | 204 | 1 | 2023-03-13 20:38:18 |
20617 | 20617 | 882 | 1945-02-12 | 1051 | 0 | 808 | 1 | 2023-03-13 20:38:18 |
20616 | 20616 | 882 | 1945-02-12 | 167 | 0 | 808 | 1 | 2023-03-13 20:38:18 |
20615 | 20615 | 882 | 1944-12-12 | 1051 | 0 | 29 | 1 | 2023-03-13 20:38:18 |
20614 | 20614 | 882 | 1944-12-12 | 167 | 0 | 29 | 1 | 2023-03-13 20:38:18 |
20613 | 20613 | 882 | 1944-09-26 | 1051 | 0 | 593 | 1 | 2023-03-13 20:38:18 |
20612 | 20612 | 882 | 1944-09-26 | 167 | 0 | 593 | 1 | 2023-03-13 20:38:18 |
20611 | 20611 | 1029 | 1945-04-27 | 769 | 0 | 452 | 1 | 2023-03-13 20:38:18 |
20610 | 20610 | 1117 | 2022-12-29 | 1303 | 7 | 1686 | 1 | 2023-03-13 20:38:18 |
20609 | 20609 | 1117 | 2022-12-29 | 788 | 11 | 1686 | 1 | 2023-03-13 20:38:18 |
20608 | 20608 | 1117 | 2022-12-29 | 244 | 4 | 1686 | 1 | 2023-03-13 20:38:18 |
20607 | 20607 | 1117 | 2022-12-29 | 732 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20606 | 20606 | 1117 | 2022-12-29 | 1357 | 14 | 1686 | 1 | 2023-03-13 20:38:18 |
20605 | 20605 | 1117 | 2022-12-29 | 2725 | 12 | 1686 | 1 | 2023-03-13 20:38:18 |
20604 | 20604 | 1117 | 2022-12-29 | 1816 | 6 | 1686 | 1 | 2023-03-13 20:38:18 |
20603 | 20603 | 1117 | 2022-12-29 | 1846 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20602 | 20602 | 1117 | 2022-12-29 | 2321 | 24 | 1686 | 1 | 2023-03-13 20:38:18 |
20601 | 20601 | 1117 | 2022-12-29 | 678 | 32 | 1686 | 1 | 2023-03-13 20:38:18 |
20600 | 20600 | 1115 | 2022-12-14 | 1001 | 15 | 1685 | 1 | 2023-03-13 20:38:18 |
20599 | 20599 | 1115 | 2022-12-14 | 2716 | 10 | 1685 | 1 | 2023-03-13 20:38:18 |
20598 | 20598 | 1115 | 2022-12-14 | 2876 | 9 | 1685 | 1 | 2023-03-13 20:38:18 |
20597 | 20597 | 1115 | 2022-12-14 | 521 | 13 | 1685 | 1 | 2023-03-13 20:38:18 |
20596 | 20596 | 1115 | 2022-12-14 | 2875 | 11 | 1685 | 1 | 2023-03-13 20:38:18 |
20595 | 20595 | 1115 | 2022-12-14 | 466 | 16 | 1685 | 1 | 2023-03-13 20:38:18 |
20594 | 20594 | 1115 | 2022-12-14 | 1666 | 26 | 1685 | 1 | 2023-03-13 20:38:18 |
20593 | 20593 | 1116 | 2022-12-15 | 1894 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20592 | 20592 | 1116 | 2022-12-15 | 1892 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20591 | 20591 | 1116 | 2022-12-15 | 74 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20590 | 20590 | 1116 | 2022-12-15 | 1891 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20589 | 20589 | 1116 | 2022-12-15 | 2888 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20588 | 20588 | 1116 | 2022-12-15 | 376 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20587 | 20587 | 1116 | 2022-12-15 | 2567 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20586 | 20586 | 1116 | 2022-12-15 | 306 | 9 | 1684 | 1 | 2023-03-13 20:38:18 |
20585 | 20585 | 1116 | 2022-12-15 | 1605 | 23 | 1684 | 1 | 2023-03-13 20:38:18 |
20584 | 20584 | 1116 | 2022-12-15 | 1418 | 5 | 1684 | 1 | 2023-03-13 20:38:18 |
20583 | 20583 | 1116 | 2022-12-15 | 2887 | 16 | 1684 | 1 | 2023-03-13 20:38:18 |
20582 | 20582 | 1116 | 2022-12-15 | 1644 | 15 | 1684 | 1 | 2023-03-13 20:38:18 |
20581 | 20581 | 1116 | 2022-12-15 | 2781 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20580 | 20580 | 1116 | 2022-12-15 | 590 | 10 | 1684 | 1 | 2023-03-13 20:38:18 |
20579 | 20579 | 1116 | 2022-12-15 | 211 | 7 | 1684 | 1 | 2023-03-13 20:38:18 |
20578 | 20578 | 1116 | 2022-12-15 | 1629 | 50 | 1684 | 1 | 2023-03-13 20:38:18 |
20577 | 20577 | 1086 | 2022-10-25 | 2731 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
20576 | 20576 | 1086 | 2022-10-25 | 467 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
20575 | 20575 | 1086 | 2022-10-25 | 1023 | 2 | 1683 | 1 | 2023-03-13 20:38:18 |
20574 | 20574 | 1086 | 2022-10-25 | 311 | 4 | 1683 | 1 | 2023-03-13 20:38:18 |
20573 | 20573 | 1086 | 2022-10-25 | 689 | 7 | 1683 | 1 | 2023-03-13 20:38:18 |
20572 | 20572 | 1086 | 2022-10-25 | 319 | 8 | 1683 | 1 | 2023-03-13 20:38:18 |
20571 | 20571 | 1086 | 2022-10-25 | 659 | 11 | 1683 | 1 | 2023-03-13 20:38:18 |
20570 | 20570 | 1086 | 2022-10-25 | 1284 | 48 | 1683 | 1 | 2023-03-13 20:38:18 |
20569 | 20569 | 1086 | 2022-10-25 | 1556 | 203 | 1683 | 1 | 2023-03-13 20:38:18 |
20568 | 20568 | 1086 | 2022-10-25 | 773 | 365 | 1683 | 1 | 2023-03-13 20:38:18 |
20567 | 20567 | 1113 | 2022-10-22 | 825 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20566 | 20566 | 1113 | 2022-10-22 | 226 | 9 | 1682 | 1 | 2023-03-13 20:38:18 |
20565 | 20565 | 1113 | 2022-10-22 | 1030 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20564 | 20564 | 1113 | 2022-10-22 | 2302 | 1 | 1682 | 1 | 2023-03-13 20:38:18 |
20563 | 20563 | 1113 | 2022-10-22 | 2794 | 21 | 1682 | 1 | 2023-03-13 20:38:18 |
20562 | 20562 | 1113 | 2022-10-22 | 1278 | 11 | 1682 | 1 | 2023-03-13 20:38:18 |
20561 | 20561 | 1113 | 2022-10-22 | 1436 | 66 | 1682 | 1 | 2023-03-13 20:38:18 |
20560 | 20560 | 1113 | 2022-10-22 | 2155 | 52 | 1682 | 1 | 2023-03-13 20:38:18 |
20559 | 20559 | 1113 | 2022-10-22 | 2737 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20558 | 20558 | 1113 | 2022-10-22 | 382 | 69 | 1682 | 1 | 2023-03-13 20:38:18 |
20557 | 20557 | 1113 | 2022-10-22 | 596 | 44 | 1682 | 1 | 2023-03-13 20:38:18 |
20556 | 20556 | 1113 | 2022-10-22 | 2154 | 118 | 1682 | 1 | 2023-03-13 20:38:18 |
20555 | 20555 | 1024 | 2022-07-21 | 2861 | 50 | 1681 | 1 | 2023-03-13 20:38:18 |
20554 | 20554 | 1024 | 2022-07-21 | 2794 | 25 | 1681 | 1 | 2023-03-13 20:38:18 |
20553 | 20553 | 1024 | 2022-07-21 | 2737 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20552 | 20552 | 1024 | 2022-07-21 | 2671 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20551 | 20551 | 1024 | 2022-07-21 | 927 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20550 | 20550 | 1024 | 2022-07-21 | 465 | 14 | 1681 | 1 | 2023-03-13 20:38:18 |
20549 | 20549 | 1024 | 2022-07-21 | 693 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20548 | 20548 | 1024 | 2022-07-21 | 2302 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20547 | 20547 | 1024 | 2022-07-21 | 2153 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20546 | 20546 | 1024 | 2022-07-21 | 1030 | 4 | 1681 | 1 | 2023-03-13 20:38:18 |
20545 | 20545 | 1024 | 2022-07-21 | 382 | 87 | 1681 | 1 | 2023-03-13 20:38:18 |
20544 | 20544 | 1024 | 2022-07-21 | 226 | 4 | 1681 | 1 | 2023-03-13 20:38:18 |
20543 | 20543 | 1024 | 2022-07-21 | 2154 | 31 | 1681 | 1 | 2023-03-13 20:38:18 |
20542 | 20542 | 1024 | 2022-07-21 | 596 | 106 | 1681 | 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 );