viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by election_id descending
This data as json, CSV (advanced)
Link | rowid | election_id ▲ | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
20566 | 20566 | 1113 | 2022-10-22 | 226 | 9 | 1682 | 1 | 2023-03-13 20:38:18 |
20567 | 20567 | 1113 | 2022-10-22 | 825 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20836 | 20836 | 1113 | 2022-10-22 | 1552 | 0 | 1682 | 1 | 2023-03-13 20:38:18 |
5744 | 5744 | 1112 | 2022-09-11 | 657 | 68 | 1652 | 0 | 2023-03-13 20:38:18 |
5745 | 5745 | 1112 | 2022-09-11 | 1461 | 24 | 1652 | 0 | 2023-03-13 20:38:18 |
5746 | 5746 | 1112 | 2022-09-11 | 282 | 19 | 1652 | 0 | 2023-03-13 20:38:18 |
5747 | 5747 | 1112 | 2022-09-11 | 904 | 107 | 1652 | 0 | 2023-03-13 20:38:18 |
5748 | 5748 | 1112 | 2022-09-11 | 1546 | 73 | 1652 | 0 | 2023-03-13 20:38:18 |
5749 | 5749 | 1112 | 2022-09-11 | 892 | 16 | 1652 | 0 | 2023-03-13 20:38:18 |
5750 | 5750 | 1112 | 2022-09-11 | 882 | 24 | 1652 | 0 | 2023-03-13 20:38:18 |
5751 | 5751 | 1112 | 2022-09-11 | 1154 | 18 | 1652 | 0 | 2023-03-13 20:38:18 |
20532 | 20532 | 1112 | 2022-10-17 | 657 | 68 | 1680 | 1 | 2023-03-13 20:38:18 |
20533 | 20533 | 1112 | 2022-10-17 | 1461 | 24 | 1680 | 1 | 2023-03-13 20:38:18 |
20534 | 20534 | 1112 | 2022-10-17 | 282 | 19 | 1680 | 1 | 2023-03-13 20:38:18 |
20535 | 20535 | 1112 | 2022-10-17 | 904 | 107 | 1680 | 1 | 2023-03-13 20:38:18 |
20536 | 20536 | 1112 | 2022-10-17 | 1546 | 73 | 1680 | 1 | 2023-03-13 20:38:18 |
20537 | 20537 | 1112 | 2022-10-17 | 892 | 16 | 1680 | 1 | 2023-03-13 20:38:18 |
20538 | 20538 | 1112 | 2022-10-17 | 882 | 24 | 1680 | 1 | 2023-03-13 20:38:18 |
20539 | 20539 | 1112 | 2022-10-17 | 1154 | 18 | 1680 | 1 | 2023-03-13 20:38:18 |
5735 | 5735 | 1111 | 2022-05-21 | 1428 | 58 | 1616 | 0 | 2023-03-13 20:38:18 |
5736 | 5736 | 1111 | 2022-05-21 | 1411 | 27 | 1616 | 0 | 2023-03-13 20:38:18 |
5737 | 5737 | 1111 | 2022-05-21 | 154 | 21 | 1616 | 0 | 2023-03-13 20:38:18 |
5738 | 5738 | 1111 | 2022-05-21 | 184 | 10 | 1616 | 0 | 2023-03-13 20:38:18 |
5739 | 5739 | 1111 | 2022-05-21 | 1253 | 77 | 1616 | 0 | 2023-03-13 20:38:18 |
5740 | 5740 | 1111 | 2022-05-21 | 751 | 4 | 1616 | 0 | 2023-03-13 20:38:18 |
5741 | 5741 | 1111 | 2022-05-21 | 2630 | 1 | 1616 | 0 | 2023-03-13 20:38:18 |
5742 | 5742 | 1111 | 2022-05-21 | 2258 | 1 | 1616 | 0 | 2023-03-13 20:38:18 |
5743 | 5743 | 1111 | 2022-05-21 | 1396 | 10 | 1616 | 0 | 2023-03-13 20:38:18 |
20464 | 20464 | 1111 | 2022-05-23 | 1428 | 58 | 1672 | 1 | 2023-03-13 20:38:18 |
20465 | 20465 | 1111 | 2022-05-23 | 1411 | 27 | 1672 | 1 | 2023-03-13 20:38:18 |
20466 | 20466 | 1111 | 2022-05-23 | 154 | 21 | 1672 | 1 | 2023-03-13 20:38:18 |
20467 | 20467 | 1111 | 2022-05-23 | 184 | 10 | 1672 | 1 | 2023-03-13 20:38:18 |
20468 | 20468 | 1111 | 2022-05-23 | 1253 | 77 | 1672 | 1 | 2023-03-13 20:38:18 |
20469 | 20469 | 1111 | 2022-05-23 | 751 | 4 | 1672 | 1 | 2023-03-13 20:38:18 |
20470 | 20470 | 1111 | 2022-05-23 | 2630 | 1 | 1672 | 1 | 2023-03-13 20:38:18 |
20471 | 20471 | 1111 | 2022-05-23 | 2258 | 1 | 1672 | 1 | 2023-03-13 20:38:18 |
20472 | 20472 | 1111 | 2022-05-23 | 1396 | 10 | 1672 | 1 | 2023-03-13 20:38:18 |
5724 | 5724 | 1110 | 2022-06-19 | 177 | 22 | 1675 | 1 | 2023-03-13 20:38:18 |
5725 | 5725 | 1110 | 2022-06-19 | 285 | 10 | 1675 | 1 | 2023-03-13 20:38:18 |
5726 | 5726 | 1110 | 2022-06-19 | 270 | 89 | 1675 | 1 | 2023-03-13 20:38:18 |
5727 | 5727 | 1110 | 2022-06-19 | 2643 | 245 | 1675 | 1 | 2023-03-13 20:38:18 |
5728 | 5728 | 1110 | 2022-06-19 | 658 | 61 | 1675 | 1 | 2023-03-13 20:38:18 |
5729 | 5729 | 1110 | 2022-06-19 | 2644 | 131 | 1675 | 1 | 2023-03-13 20:38:18 |
5730 | 5730 | 1110 | 2022-06-19 | 947 | 10 | 1675 | 1 | 2023-03-13 20:38:18 |
5731 | 5731 | 1110 | 2022-06-19 | 2273 | 3 | 1675 | 1 | 2023-03-13 20:38:18 |
5732 | 5732 | 1110 | 2022-06-19 | 1328 | 1 | 1675 | 1 | 2023-03-13 20:38:18 |
5733 | 5733 | 1110 | 2022-06-19 | 2858 | 4 | 1675 | 1 | 2023-03-13 20:38:18 |
5734 | 5734 | 1110 | 2022-06-19 | 2859 | 1 | 1675 | 1 | 2023-03-13 20:38:18 |
20830 | 20830 | 1110 | 2022-06-19 | 509 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20831 | 20831 | 1110 | 2022-06-19 | 2862 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
20832 | 20832 | 1110 | 2022-06-19 | 2857 | 0 | 1675 | 1 | 2023-03-13 20:38:18 |
5714 | 5714 | 1109 | 2022-01-30 | 2788 | 8 | 1610 | 0 | 2023-03-13 20:38:18 |
5715 | 5715 | 1109 | 2022-01-30 | 2374 | 1 | 1610 | 0 | 2023-03-13 20:38:18 |
5716 | 5716 | 1109 | 2022-01-30 | 1781 | 1 | 1610 | 0 | 2023-03-13 20:38:18 |
5717 | 5717 | 1109 | 2022-01-30 | 514 | 6 | 1610 | 0 | 2023-03-13 20:38:18 |
5718 | 5718 | 1109 | 2022-01-30 | 1273 | 72 | 1610 | 0 | 2023-03-13 20:38:18 |
5719 | 5719 | 1109 | 2022-01-30 | 2789 | 12 | 1610 | 0 | 2023-03-13 20:38:18 |
5720 | 5720 | 1109 | 2022-01-30 | 725 | 120 | 1610 | 0 | 2023-03-13 20:38:18 |
5721 | 5721 | 1109 | 2022-01-30 | 557 | 5 | 1610 | 0 | 2023-03-13 20:38:18 |
5722 | 5722 | 1109 | 2022-01-30 | 251 | 3 | 1610 | 0 | 2023-03-13 20:38:18 |
5723 | 5723 | 1109 | 2022-01-30 | 107 | 2 | 1610 | 0 | 2023-03-13 20:38:18 |
20454 | 20454 | 1109 | 2022-03-30 | 2788 | 8 | 1671 | 1 | 2023-03-13 20:38:18 |
20455 | 20455 | 1109 | 2022-03-30 | 2374 | 1 | 1671 | 1 | 2023-03-13 20:38:18 |
20456 | 20456 | 1109 | 2022-03-30 | 1781 | 1 | 1671 | 1 | 2023-03-13 20:38:18 |
20457 | 20457 | 1109 | 2022-03-30 | 514 | 6 | 1671 | 1 | 2023-03-13 20:38:18 |
20458 | 20458 | 1109 | 2022-03-30 | 1273 | 72 | 1671 | 1 | 2023-03-13 20:38:18 |
20459 | 20459 | 1109 | 2022-03-30 | 2789 | 12 | 1671 | 1 | 2023-03-13 20:38:18 |
20460 | 20460 | 1109 | 2022-03-30 | 725 | 120 | 1671 | 1 | 2023-03-13 20:38:18 |
20461 | 20461 | 1109 | 2022-03-30 | 557 | 5 | 1671 | 1 | 2023-03-13 20:38:18 |
20462 | 20462 | 1109 | 2022-03-30 | 251 | 3 | 1671 | 1 | 2023-03-13 20:38:18 |
20463 | 20463 | 1109 | 2022-03-30 | 107 | 2 | 1671 | 1 | 2023-03-13 20:38:18 |
5707 | 5707 | 1108 | 2022-04-22 | 179 | 27 | 1668 | 0 | 2023-03-13 20:38:18 |
5708 | 5708 | 1108 | 2022-04-22 | 1047 | 8 | 1668 | 0 | 2023-03-13 20:38:18 |
5709 | 5709 | 1108 | 2022-04-22 | 2670 | 5 | 1668 | 0 | 2023-03-13 20:38:18 |
5710 | 5710 | 1108 | 2022-04-22 | 2856 | 41 | 1668 | 0 | 2023-03-13 20:38:18 |
5711 | 5711 | 1108 | 2022-04-22 | 706 | 7 | 1668 | 0 | 2023-03-13 20:38:18 |
5712 | 5712 | 1108 | 2022-04-22 | 199 | 1 | 1668 | 0 | 2023-03-13 20:38:18 |
5713 | 5713 | 1108 | 2022-04-22 | 65 | 1 | 1668 | 0 | 2023-03-13 20:38:18 |
20489 | 20489 | 1108 | 2022-06-01 | 179 | 27 | 1674 | 1 | 2023-03-13 20:38:18 |
20490 | 20490 | 1108 | 2022-06-01 | 1047 | 8 | 1674 | 1 | 2023-03-13 20:38:18 |
20491 | 20491 | 1108 | 2022-06-01 | 2670 | 5 | 1674 | 1 | 2023-03-13 20:38:18 |
20492 | 20492 | 1108 | 2022-06-01 | 2856 | 41 | 1674 | 1 | 2023-03-13 20:38:18 |
20493 | 20493 | 1108 | 2022-06-01 | 706 | 7 | 1674 | 1 | 2023-03-13 20:38:18 |
20494 | 20494 | 1108 | 2022-06-01 | 199 | 1 | 1674 | 1 | 2023-03-13 20:38:18 |
20495 | 20495 | 1108 | 2022-06-01 | 65 | 1 | 1674 | 1 | 2023-03-13 20:38:18 |
5696 | 5696 | 1107 | 2022-04-03 | 2745 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
5697 | 5697 | 1107 | 2022-04-03 | 921 | 117 | 1531 | 0 | 2023-03-13 20:38:18 |
5698 | 5698 | 1107 | 2022-04-03 | 434 | 18 | 1531 | 0 | 2023-03-13 20:38:18 |
5699 | 5699 | 1107 | 2022-04-03 | 1591 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5700 | 5700 | 1107 | 2022-04-03 | 600 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5701 | 5701 | 1107 | 2022-04-03 | 2659 | 10 | 1531 | 0 | 2023-03-13 20:38:18 |
5702 | 5702 | 1107 | 2022-04-03 | 403 | 5 | 1531 | 0 | 2023-03-13 20:38:18 |
5703 | 5703 | 1107 | 2022-04-03 | 1970 | 15 | 1531 | 0 | 2023-03-13 20:38:18 |
5704 | 5704 | 1107 | 2022-04-03 | 952 | 1 | 1531 | 0 | 2023-03-13 20:38:18 |
5705 | 5705 | 1107 | 2022-04-03 | 2349 | 6 | 1531 | 0 | 2023-03-13 20:38:18 |
5706 | 5706 | 1107 | 2022-04-03 | 1617 | 1 | 1531 | 0 | 2023-03-13 20:38:18 |
20443 | 20443 | 1107 | 2022-05-16 | 2745 | 6 | 1670 | 1 | 2023-03-13 20:38:18 |
20444 | 20444 | 1107 | 2022-05-16 | 921 | 117 | 1670 | 1 | 2023-03-13 20:38:18 |
20445 | 20445 | 1107 | 2022-05-16 | 434 | 18 | 1670 | 1 | 2023-03-13 20:38:18 |
20446 | 20446 | 1107 | 2022-05-16 | 1591 | 10 | 1670 | 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 );