viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by party_id descending
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id ▲ | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5447 | 5447 | 1077 | 2019-06-05 | 2781 | 4 | 1497 | 0 | 2023-03-13 20:38:18 |
5781 | 5781 | 1116 | 2022-11-01 | 2781 | 6 | 1598 | 0 | 2023-03-13 20:38:18 |
9439 | 9439 | 1077 | 2021-01-01 | 2781 | 4 | 1598 | 0 | 2023-03-13 20:38:18 |
19890 | 19890 | 1077 | 2019-06-27 | 2781 | 4 | 1598 | 1 | 2023-03-13 20:38:18 |
20581 | 20581 | 1116 | 2022-12-15 | 2781 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
5462 | 5462 | 1078 | 2019-07-07 | 2780 | 10 | 1593 | 0 | 2023-03-13 20:38:18 |
19885 | 19885 | 1078 | 2019-07-08 | 2780 | 10 | 1597 | 1 | 2023-03-13 20:38:18 |
5561 | 5561 | 1088 | 2020-02-08 | 2776 | 5 | 1641 | 1 | 2023-03-13 20:38:18 |
20230 | 20230 | 1088 | 2020-06-27 | 2776 | 5 | 1642 | 1 | 2023-03-13 20:38:18 |
5605 | 5605 | 1094 | 2020-07-05 | 2772 | 3 | 1512 | 0 | 2023-03-13 20:38:18 |
20185 | 20185 | 1094 | 2020-07-23 | 2772 | 3 | 1637 | 1 | 2023-03-13 20:38:18 |
5585 | 5585 | 1091 | 2020-10-11 | 2763 | 3 | 1615 | 0 | 2023-03-13 20:38:18 |
9366 | 9366 | 1009 | 2017-10-19 | 2763 | 12 | 1614 | 1 | 2023-03-13 20:38:18 |
20017 | 20017 | 1009 | 2019-07-23 | 2763 | 12 | 1615 | 1 | 2023-03-13 20:38:18 |
20240 | 20240 | 1091 | 2020-11-24 | 2763 | 3 | 1643 | 1 | 2023-03-13 20:38:18 |
5696 | 5696 | 1107 | 2022-04-03 | 2745 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
20443 | 20443 | 1107 | 2022-05-16 | 2745 | 6 | 1670 | 1 | 2023-03-13 20:38:18 |
5463 | 5463 | 1078 | 2019-07-07 | 2742 | 9 | 1593 | 0 | 2023-03-13 20:38:18 |
19886 | 19886 | 1078 | 2019-07-08 | 2742 | 9 | 1597 | 1 | 2023-03-13 20:38:18 |
5616 | 5616 | 1095 | 2021-05-30 | 2741 | 4 | 1659 | 1 | 2023-03-13 20:38:18 |
5490 | 5490 | 1082 | 2019-10-13 | 2740 | 19 | 1526 | 0 | 2023-03-13 20:38:18 |
19984 | 19984 | 1082 | 2019-11-15 | 2740 | 19 | 1611 | 1 | 2023-03-13 20:38:18 |
5198 | 5198 | 1024 | 2018-03-04 | 2737 | 2 | 1501 | 0 | 2023-03-13 20:38:18 |
5755 | 5755 | 1113 | 2022-09-25 | 2737 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
9386 | 9386 | 1024 | 2019-09-17 | 2737 | 2 | 1603 | 0 | 2023-03-13 20:38:18 |
9401 | 9401 | 1024 | 2022-06-21 | 2737 | 2 | 1667 | 0 | 2023-03-13 20:38:18 |
19270 | 19270 | 1024 | 2018-06-01 | 2737 | 2 | 1532 | 1 | 2023-03-13 20:38:18 |
19928 | 19928 | 1024 | 2019-09-05 | 2737 | 2 | 1603 | 1 | 2023-03-13 20:38:18 |
20413 | 20413 | 1024 | 2021-02-13 | 2737 | 2 | 1667 | 1 | 2023-03-13 20:38:18 |
20553 | 20553 | 1024 | 2022-07-21 | 2737 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20559 | 20559 | 1113 | 2022-10-22 | 2737 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
5630 | 5630 | 1097 | 2021-03-17 | 2735 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
20439 | 20439 | 1097 | 2022-01-10 | 2735 | 3 | 1669 | 1 | 2023-03-13 20:38:18 |
5545 | 5545 | 1086 | 2019-12-12 | 2731 | 1 | 1599 | 0 | 2023-03-13 20:38:18 |
19956 | 19956 | 1086 | 2019-12-13 | 2731 | 1 | 1606 | 1 | 2023-03-13 20:38:18 |
20505 | 20505 | 1086 | 2022-09-06 | 2731 | 1 | 1676 | 1 | 2023-03-13 20:38:18 |
20577 | 20577 | 1086 | 2022-10-25 | 2731 | 1 | 1683 | 1 | 2023-03-13 20:38:18 |
5427 | 5427 | 1047 | 2019-04-09 | 2726 | 5 | 1602 | 1 | 2023-03-13 20:38:18 |
5470 | 5470 | 1079 | 2019-09-17 | 2726 | 7 | 1613 | 1 | 2023-03-13 20:38:18 |
5576 | 5576 | 1090 | 2020-03-02 | 2726 | 6 | 1613 | 0 | 2023-03-13 20:38:18 |
5645 | 5645 | 1100 | 2021-03-23 | 2726 | 7 | 1645 | 0 | 2023-03-13 20:38:18 |
20258 | 20258 | 1090 | 2020-05-17 | 2726 | 6 | 1645 | 1 | 2023-03-13 20:38:18 |
20299 | 20299 | 1100 | 2021-06-13 | 2726 | 7 | 1650 | 1 | 2023-03-13 20:38:18 |
20510 | 20510 | 1100 | 2022-07-01 | 2726 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
5422 | 5422 | 1047 | 2019-04-09 | 2725 | 35 | 1602 | 1 | 2023-03-13 20:38:18 |
5464 | 5464 | 1079 | 2019-09-17 | 2725 | 33 | 1613 | 1 | 2023-03-13 20:38:18 |
5571 | 5571 | 1090 | 2020-03-02 | 2725 | 33 | 1613 | 0 | 2023-03-13 20:38:18 |
5644 | 5644 | 1100 | 2021-03-23 | 2725 | 8 | 1645 | 0 | 2023-03-13 20:38:18 |
5798 | 5798 | 1117 | 2022-11-01 | 2725 | 12 | 1677 | 0 | 2023-03-13 20:38:18 |
20253 | 20253 | 1090 | 2020-05-17 | 2725 | 33 | 1645 | 1 | 2023-03-13 20:38:18 |
20298 | 20298 | 1100 | 2021-06-13 | 2725 | 8 | 1650 | 1 | 2023-03-13 20:38:18 |
20509 | 20509 | 1100 | 2022-07-01 | 2725 | 8 | 1677 | 1 | 2023-03-13 20:38:18 |
20605 | 20605 | 1117 | 2022-12-29 | 2725 | 12 | 1686 | 1 | 2023-03-13 20:38:18 |
20815 | 20815 | 1085 | 2020-01-07 | 2724 | 0 | 1605 | 1 | 2023-03-13 20:38:18 |
5416 | 5416 | 1046 | 2019-04-28 | 2723 | 2 | 1601 | 1 | 2023-03-13 20:38:18 |
5525 | 5525 | 1085 | 2019-11-10 | 2723 | 2 | 1601 | 0 | 2023-03-13 20:38:18 |
19936 | 19936 | 1085 | 2020-01-07 | 2723 | 2 | 1605 | 1 | 2023-03-13 20:38:18 |
9269 | 9269 | 852 | 2018-12-31 | 2718 | 3 | 1589 | 0 | 2023-03-13 20:38:18 |
9281 | 9281 | 852 | 2019-01-01 | 2718 | 3 | 1589 | 0 | 2023-03-13 20:38:18 |
9293 | 9293 | 852 | 2019-01-09 | 2718 | 3 | 1589 | 0 | 2023-03-13 20:38:18 |
5378 | 5378 | 1042 | 2018-10-06 | 2717 | 16 | 1591 | 1 | 2023-03-13 20:38:18 |
19850 | 19850 | 1042 | 2019-01-23 | 2717 | 16 | 1592 | 1 | 2023-03-13 20:38:18 |
5776 | 5776 | 1115 | 2022-10-01 | 2716 | 10 | 1592 | 0 | 2023-03-13 20:38:18 |
20599 | 20599 | 1115 | 2022-12-14 | 2716 | 10 | 1685 | 1 | 2023-03-13 20:38:18 |
5382 | 5382 | 1042 | 2018-10-06 | 2715 | 16 | 1591 | 1 | 2023-03-13 20:38:18 |
19854 | 19854 | 1042 | 2019-01-23 | 2715 | 16 | 1592 | 1 | 2023-03-13 20:38:18 |
4623 | 4623 | 940 | 1929-07-03 | 2714 | 1 | 1259 | 0 | 2023-03-13 20:38:18 |
17837 | 17837 | 940 | 1929-08-10 | 2714 | 1 | 1258 | 1 | 2023-03-13 20:38:18 |
9419 | 9419 | 1036 | 1929-12-28 | 2713 | 12 | 1576 | 0 | 2023-03-13 20:38:18 |
9435 | 9435 | 1036 | 1930-01-28 | 2713 | 21 | 1576 | 0 | 2023-03-13 20:38:18 |
19754 | 19754 | 1036 | 1930-03-30 | 2713 | 21 | 1581 | 1 | 2023-03-13 20:38:18 |
5314 | 5314 | 1036 | 1928-05-20 | 2712 | 1 | 1575 | 0 | 2023-03-13 20:38:18 |
5330 | 5330 | 1037 | 1930-09-14 | 2712 | 1 | 1581 | 0 | 2023-03-13 20:38:18 |
9418 | 9418 | 1036 | 1929-12-28 | 2712 | 1 | 1576 | 0 | 2023-03-13 20:38:18 |
9434 | 9434 | 1036 | 1930-01-28 | 2712 | 1 | 1576 | 0 | 2023-03-13 20:38:18 |
19680 | 19680 | 1036 | 1928-06-29 | 2712 | 1 | 1576 | 1 | 2023-03-13 20:38:18 |
19724 | 19724 | 1037 | 1932-06-02 | 2712 | 1 | 1579 | 1 | 2023-03-13 20:38:18 |
19753 | 19753 | 1036 | 1930-03-30 | 2712 | 1 | 1581 | 1 | 2023-03-13 20:38:18 |
19770 | 19770 | 1037 | 1930-10-16 | 2712 | 1 | 1582 | 1 | 2023-03-13 20:38:18 |
19786 | 19786 | 1037 | 1930-12-05 | 2712 | 1 | 1583 | 1 | 2023-03-13 20:38:18 |
19802 | 19802 | 1037 | 1931-10-10 | 2712 | 1 | 1584 | 1 | 2023-03-13 20:38:18 |
5328 | 5328 | 1037 | 1930-09-14 | 2711 | 4 | 1581 | 0 | 2023-03-13 20:38:18 |
19722 | 19722 | 1037 | 1932-06-02 | 2711 | 4 | 1579 | 1 | 2023-03-13 20:38:18 |
19768 | 19768 | 1037 | 1930-10-16 | 2711 | 4 | 1582 | 1 | 2023-03-13 20:38:18 |
19784 | 19784 | 1037 | 1930-12-05 | 2711 | 4 | 1583 | 1 | 2023-03-13 20:38:18 |
19800 | 19800 | 1037 | 1931-10-10 | 2711 | 4 | 1584 | 1 | 2023-03-13 20:38:18 |
5312 | 5312 | 1036 | 1928-05-20 | 2710 | 2 | 1575 | 0 | 2023-03-13 20:38:18 |
5343 | 5343 | 1038 | 1932-07-31 | 2710 | 1 | 1579 | 0 | 2023-03-13 20:38:18 |
9416 | 9416 | 1036 | 1929-12-28 | 2710 | 2 | 1576 | 0 | 2023-03-13 20:38:18 |
9432 | 9432 | 1036 | 1930-01-28 | 2710 | 2 | 1576 | 0 | 2023-03-13 20:38:18 |
19678 | 19678 | 1036 | 1928-06-29 | 2710 | 2 | 1576 | 1 | 2023-03-13 20:38:18 |
19737 | 19737 | 1038 | 1932-09-12 | 2710 | 1 | 1580 | 1 | 2023-03-13 20:38:18 |
19751 | 19751 | 1036 | 1930-03-30 | 2710 | 2 | 1581 | 1 | 2023-03-13 20:38:18 |
5311 | 5311 | 1036 | 1928-05-20 | 2709 | 9 | 1575 | 0 | 2023-03-13 20:38:18 |
5324 | 5324 | 1037 | 1930-09-14 | 2709 | 19 | 1581 | 0 | 2023-03-13 20:38:18 |
19677 | 19677 | 1036 | 1928-06-29 | 2709 | 9 | 1576 | 1 | 2023-03-13 20:38:18 |
19718 | 19718 | 1037 | 1932-06-02 | 2709 | 19 | 1579 | 1 | 2023-03-13 20:38:18 |
19764 | 19764 | 1037 | 1930-10-16 | 2709 | 19 | 1582 | 1 | 2023-03-13 20:38:18 |
19780 | 19780 | 1037 | 1930-12-05 | 2709 | 19 | 1583 | 1 | 2023-03-13 20:38:18 |
19796 | 19796 | 1037 | 1931-10-10 | 2709 | 19 | 1584 | 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 );