viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by party_id descending
This data as json, CSV (advanced)
Suggested facets: date (date), calculation_date (date)
Link | rowid | election_id | date | party_id ▲ | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5789 | 5789 | 1116 | 2022-11-01 | 2888 | 14 | 1598 | 0 | 2023-03-13 20:38:18 |
5783 | 5783 | 1116 | 2022-11-01 | 2887 | 16 | 1598 | 0 | 2023-03-13 20:38:18 |
9450 | 9450 | 1077 | 2021-01-01 | 2887 | 1 | 1598 | 0 | 2023-03-13 20:38:18 |
5775 | 5775 | 1115 | 2022-10-01 | 2876 | 9 | 1592 | 0 | 2023-03-13 20:38:18 |
5773 | 5773 | 1115 | 2022-10-01 | 2875 | 11 | 1592 | 0 | 2023-03-13 20:38:18 |
5770 | 5770 | 1114 | 2022-10-02 | 2871 | 12 | 1678 | 0 | 2023-03-13 20:38:18 |
9403 | 9403 | 1024 | 2022-06-21 | 2861 | 50 | 1667 | 0 | 2023-03-13 20:38:18 |
5710 | 5710 | 1108 | 2022-04-22 | 2856 | 41 | 1668 | 0 | 2023-03-13 20:38:18 |
7128 | 7128 | 581 | 1949-08-14 | 2850 | 1 | 1578 | 0 | 2023-03-13 20:38:18 |
9456 | 9456 | 1096 | 2021-09-26 | 2850 | 1 | 1528 | 0 | 2023-03-13 20:38:18 |
5689 | 5689 | 1106 | 2021-11-14 | 2847 | 67 | 1658 | 0 | 2023-03-13 20:38:18 |
5765 | 5765 | 1114 | 2022-10-02 | 2847 | 53 | 1678 | 0 | 2023-03-13 20:38:18 |
5659 | 5659 | 1101 | 2021-04-04 | 2838 | 14 | 1505 | 0 | 2023-03-13 20:38:18 |
5665 | 5665 | 1102 | 2021-07-11 | 2838 | 13 | 1657 | 0 | 2023-03-13 20:38:18 |
5655 | 5655 | 1101 | 2021-04-04 | 2836 | 51 | 1505 | 0 | 2023-03-13 20:38:18 |
5660 | 5660 | 1102 | 2021-07-11 | 2836 | 65 | 1657 | 0 | 2023-03-13 20:38:18 |
5693 | 5693 | 1106 | 2021-11-14 | 2836 | 25 | 1658 | 0 | 2023-03-13 20:38:18 |
5651 | 5651 | 1100 | 2021-03-23 | 2835 | 6 | 1645 | 0 | 2023-03-13 20:38:18 |
5640 | 5640 | 1098 | 2021-10-31 | 2828 | 3 | 1647 | 0 | 2023-03-13 20:38:18 |
5639 | 5639 | 1098 | 2021-10-31 | 2827 | 5 | 1647 | 0 | 2023-03-13 20:38:18 |
5637 | 5637 | 1098 | 2021-10-31 | 2826 | 25 | 1647 | 0 | 2023-03-13 20:38:18 |
5632 | 5632 | 1097 | 2021-03-17 | 2824 | 1 | 1648 | 0 | 2023-03-13 20:38:18 |
5631 | 5631 | 1097 | 2021-03-17 | 2823 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5604 | 5604 | 1094 | 2020-07-05 | 2810 | 7 | 1512 | 0 | 2023-03-13 20:38:18 |
5602 | 5602 | 1094 | 2020-07-05 | 2809 | 16 | 1512 | 0 | 2023-03-13 20:38:18 |
5597 | 5597 | 1093 | 2020-12-06 | 2807 | 33 | 1626 | 0 | 2023-03-13 20:38:18 |
5582 | 5582 | 1091 | 2020-10-11 | 2805 | 11 | 1615 | 0 | 2023-03-13 20:38:18 |
5533 | 5533 | 1085 | 2019-11-10 | 2804 | 2 | 1601 | 0 | 2023-03-13 20:38:18 |
5406 | 5406 | 1045 | 2019-04-14 | 2801 | 1 | 1510 | 0 | 2023-03-13 20:38:18 |
5569 | 5569 | 1089 | 2020-02-29 | 2796 | 12 | 1529 | 0 | 2023-03-13 20:38:18 |
5759 | 5759 | 1113 | 2022-09-25 | 2794 | 21 | 1681 | 0 | 2023-03-13 20:38:18 |
9387 | 9387 | 1024 | 2019-09-17 | 2794 | 25 | 1603 | 0 | 2023-03-13 20:38:18 |
9402 | 9402 | 1024 | 2022-06-21 | 2794 | 25 | 1667 | 0 | 2023-03-13 20:38:18 |
5532 | 5532 | 1085 | 2019-11-10 | 2792 | 2 | 1601 | 0 | 2023-03-13 20:38:18 |
5491 | 5491 | 1082 | 2019-10-13 | 2790 | 6 | 1526 | 0 | 2023-03-13 20:38:18 |
5486 | 5486 | 1081 | 2019-10-06 | 2789 | 1 | 1198 | 0 | 2023-03-13 20:38:18 |
5719 | 5719 | 1109 | 2022-01-30 | 2789 | 12 | 1610 | 0 | 2023-03-13 20:38:18 |
5485 | 5485 | 1081 | 2019-10-06 | 2788 | 1 | 1198 | 0 | 2023-03-13 20:38:18 |
5714 | 5714 | 1109 | 2022-01-30 | 2788 | 8 | 1610 | 0 | 2023-03-13 20:38:18 |
3878 | 3878 | 788 | 2012-12-16 | 2785 | 9 | 969 | 0 | 2023-03-13 20:38:18 |
9135 | 9135 | 788 | 2012-12-27 | 2785 | 9 | 1044 | 0 | 2023-03-13 20:38:18 |
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 |
5462 | 5462 | 1078 | 2019-07-07 | 2780 | 10 | 1593 | 0 | 2023-03-13 20:38:18 |
5605 | 5605 | 1094 | 2020-07-05 | 2772 | 3 | 1512 | 0 | 2023-03-13 20:38:18 |
5585 | 5585 | 1091 | 2020-10-11 | 2763 | 3 | 1615 | 0 | 2023-03-13 20:38:18 |
5696 | 5696 | 1107 | 2022-04-03 | 2745 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
5463 | 5463 | 1078 | 2019-07-07 | 2742 | 9 | 1593 | 0 | 2023-03-13 20:38:18 |
5490 | 5490 | 1082 | 2019-10-13 | 2740 | 19 | 1526 | 0 | 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 |
5630 | 5630 | 1097 | 2021-03-17 | 2735 | 3 | 1648 | 0 | 2023-03-13 20:38:18 |
5545 | 5545 | 1086 | 2019-12-12 | 2731 | 1 | 1599 | 0 | 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 |
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 |
5525 | 5525 | 1085 | 2019-11-10 | 2723 | 2 | 1601 | 0 | 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 |
5776 | 5776 | 1115 | 2022-10-01 | 2716 | 10 | 1592 | 0 | 2023-03-13 20:38:18 |
4623 | 4623 | 940 | 1929-07-03 | 2714 | 1 | 1259 | 0 | 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 |
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 |
5328 | 5328 | 1037 | 1930-09-14 | 2711 | 4 | 1581 | 0 | 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 |
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 |
5310 | 5310 | 1036 | 1928-05-20 | 2708 | 2 | 1575 | 0 | 2023-03-13 20:38:18 |
9415 | 9415 | 1036 | 1929-12-28 | 2708 | 2 | 1576 | 0 | 2023-03-13 20:38:18 |
9431 | 9431 | 1036 | 1930-01-28 | 2708 | 2 | 1576 | 0 | 2023-03-13 20:38:18 |
5283 | 5283 | 1034 | 1924-05-04 | 2707 | 1 | 1569 | 0 | 2023-03-13 20:38:18 |
5296 | 5296 | 1035 | 1924-12-07 | 2707 | 1 | 1570 | 0 | 2023-03-13 20:38:18 |
5282 | 5282 | 1034 | 1924-05-04 | 2706 | 2 | 1569 | 0 | 2023-03-13 20:38:18 |
5295 | 5295 | 1035 | 1924-12-07 | 2706 | 1 | 1570 | 0 | 2023-03-13 20:38:18 |
5278 | 5278 | 1034 | 1924-05-04 | 2705 | 4 | 1569 | 0 | 2023-03-13 20:38:18 |
5266 | 5266 | 1033 | 1920-06-06 | 2704 | 3 | 1559 | 0 | 2023-03-13 20:38:18 |
5281 | 5281 | 1034 | 1924-05-04 | 2704 | 2 | 1569 | 0 | 2023-03-13 20:38:18 |
5294 | 5294 | 1035 | 1924-12-07 | 2704 | 2 | 1570 | 0 | 2023-03-13 20:38:18 |
5340 | 5340 | 1038 | 1932-07-31 | 2704 | 1 | 1579 | 0 | 2023-03-13 20:38:18 |
5358 | 5358 | 1039 | 1932-11-06 | 2704 | 1 | 1580 | 0 | 2023-03-13 20:38:18 |
6140 | 6140 | 1033 | 1921-02-20 | 2704 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
5265 | 5265 | 1033 | 1920-06-06 | 2703 | 3 | 1559 | 0 | 2023-03-13 20:38:18 |
5280 | 5280 | 1034 | 1924-05-04 | 2703 | 4 | 1569 | 0 | 2023-03-13 20:38:18 |
5293 | 5293 | 1035 | 1924-12-07 | 2703 | 4 | 1570 | 0 | 2023-03-13 20:38:18 |
5309 | 5309 | 1036 | 1928-05-20 | 2703 | 3 | 1575 | 0 | 2023-03-13 20:38:18 |
5325 | 5325 | 1037 | 1930-09-14 | 2703 | 3 | 1581 | 0 | 2023-03-13 20:38:18 |
5341 | 5341 | 1038 | 1932-07-31 | 2703 | 2 | 1579 | 0 | 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 );