viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by election_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 |
---|---|---|---|---|---|---|---|---|
20601 | 20601 | 1117 | 2022-12-29 | 678 | 32 | 1686 | 1 | 2023-03-13 20:38:18 |
20602 | 20602 | 1117 | 2022-12-29 | 2321 | 24 | 1686 | 1 | 2023-03-13 20:38:18 |
20603 | 20603 | 1117 | 2022-12-29 | 1846 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20604 | 20604 | 1117 | 2022-12-29 | 1816 | 6 | 1686 | 1 | 2023-03-13 20:38:18 |
20605 | 20605 | 1117 | 2022-12-29 | 2725 | 12 | 1686 | 1 | 2023-03-13 20:38:18 |
20606 | 20606 | 1117 | 2022-12-29 | 1357 | 14 | 1686 | 1 | 2023-03-13 20:38:18 |
20607 | 20607 | 1117 | 2022-12-29 | 732 | 5 | 1686 | 1 | 2023-03-13 20:38:18 |
20608 | 20608 | 1117 | 2022-12-29 | 244 | 4 | 1686 | 1 | 2023-03-13 20:38:18 |
20609 | 20609 | 1117 | 2022-12-29 | 788 | 11 | 1686 | 1 | 2023-03-13 20:38:18 |
20610 | 20610 | 1117 | 2022-12-29 | 1303 | 7 | 1686 | 1 | 2023-03-13 20:38:18 |
20838 | 20838 | 1117 | 2022-12-29 | 2889 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20839 | 20839 | 1117 | 2022-12-29 | 2322 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20840 | 20840 | 1117 | 2022-12-29 | 265 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20841 | 20841 | 1117 | 2022-12-29 | 249 | 0 | 1686 | 1 | 2023-03-13 20:38:18 |
20578 | 20578 | 1116 | 2022-12-15 | 1629 | 50 | 1684 | 1 | 2023-03-13 20:38:18 |
20579 | 20579 | 1116 | 2022-12-15 | 211 | 7 | 1684 | 1 | 2023-03-13 20:38:18 |
20580 | 20580 | 1116 | 2022-12-15 | 590 | 10 | 1684 | 1 | 2023-03-13 20:38:18 |
20581 | 20581 | 1116 | 2022-12-15 | 2781 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20582 | 20582 | 1116 | 2022-12-15 | 1644 | 15 | 1684 | 1 | 2023-03-13 20:38:18 |
20583 | 20583 | 1116 | 2022-12-15 | 2887 | 16 | 1684 | 1 | 2023-03-13 20:38:18 |
20584 | 20584 | 1116 | 2022-12-15 | 1418 | 5 | 1684 | 1 | 2023-03-13 20:38:18 |
20585 | 20585 | 1116 | 2022-12-15 | 1605 | 23 | 1684 | 1 | 2023-03-13 20:38:18 |
20586 | 20586 | 1116 | 2022-12-15 | 306 | 9 | 1684 | 1 | 2023-03-13 20:38:18 |
20587 | 20587 | 1116 | 2022-12-15 | 2567 | 6 | 1684 | 1 | 2023-03-13 20:38:18 |
20588 | 20588 | 1116 | 2022-12-15 | 376 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20589 | 20589 | 1116 | 2022-12-15 | 2888 | 14 | 1684 | 1 | 2023-03-13 20:38:18 |
20590 | 20590 | 1116 | 2022-12-15 | 1891 | 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 |
20592 | 20592 | 1116 | 2022-12-15 | 1892 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20593 | 20593 | 1116 | 2022-12-15 | 1894 | 1 | 1684 | 1 | 2023-03-13 20:38:18 |
20594 | 20594 | 1115 | 2022-12-14 | 1666 | 26 | 1685 | 1 | 2023-03-13 20:38:18 |
20595 | 20595 | 1115 | 2022-12-14 | 466 | 16 | 1685 | 1 | 2023-03-13 20:38:18 |
20596 | 20596 | 1115 | 2022-12-14 | 2875 | 11 | 1685 | 1 | 2023-03-13 20:38:18 |
20597 | 20597 | 1115 | 2022-12-14 | 521 | 13 | 1685 | 1 | 2023-03-13 20:38:18 |
20598 | 20598 | 1115 | 2022-12-14 | 2876 | 9 | 1685 | 1 | 2023-03-13 20:38:18 |
20599 | 20599 | 1115 | 2022-12-14 | 2716 | 10 | 1685 | 1 | 2023-03-13 20:38:18 |
20600 | 20600 | 1115 | 2022-12-14 | 1001 | 15 | 1685 | 1 | 2023-03-13 20:38:18 |
20837 | 20837 | 1115 | 2022-12-14 | 2366 | 0 | 1685 | 1 | 2023-03-13 20:38:18 |
20556 | 20556 | 1113 | 2022-10-22 | 2154 | 118 | 1682 | 1 | 2023-03-13 20:38:18 |
20557 | 20557 | 1113 | 2022-10-22 | 596 | 44 | 1682 | 1 | 2023-03-13 20:38:18 |
20558 | 20558 | 1113 | 2022-10-22 | 382 | 69 | 1682 | 1 | 2023-03-13 20:38:18 |
20559 | 20559 | 1113 | 2022-10-22 | 2737 | 3 | 1682 | 1 | 2023-03-13 20:38:18 |
20560 | 20560 | 1113 | 2022-10-22 | 2155 | 52 | 1682 | 1 | 2023-03-13 20:38:18 |
20561 | 20561 | 1113 | 2022-10-22 | 1436 | 66 | 1682 | 1 | 2023-03-13 20:38:18 |
20562 | 20562 | 1113 | 2022-10-22 | 1278 | 11 | 1682 | 1 | 2023-03-13 20:38:18 |
20563 | 20563 | 1113 | 2022-10-22 | 2794 | 21 | 1682 | 1 | 2023-03-13 20:38:18 |
20564 | 20564 | 1113 | 2022-10-22 | 2302 | 1 | 1682 | 1 | 2023-03-13 20:38:18 |
20565 | 20565 | 1113 | 2022-10-22 | 1030 | 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 |
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 |
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 |
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 |
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 |
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 |
20443 | 20443 | 1107 | 2022-05-16 | 2745 | 6 | 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 );