viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by date descending
This data as json, CSV (advanced)
Link | rowid | election_id | date ▲ | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5769 | 5769 | 1114 | 2022-10-02 | 982 | 25 | 1678 | 0 | 2023-03-13 20:38:18 |
5770 | 5770 | 1114 | 2022-10-02 | 2871 | 12 | 1678 | 0 | 2023-03-13 20:38:18 |
5771 | 5771 | 1115 | 2022-10-01 | 1666 | 26 | 1592 | 0 | 2023-03-13 20:38:18 |
5772 | 5772 | 1115 | 2022-10-01 | 466 | 16 | 1592 | 0 | 2023-03-13 20:38:18 |
5773 | 5773 | 1115 | 2022-10-01 | 2875 | 11 | 1592 | 0 | 2023-03-13 20:38:18 |
5774 | 5774 | 1115 | 2022-10-01 | 521 | 13 | 1592 | 0 | 2023-03-13 20:38:18 |
5775 | 5775 | 1115 | 2022-10-01 | 2876 | 9 | 1592 | 0 | 2023-03-13 20:38:18 |
5776 | 5776 | 1115 | 2022-10-01 | 2716 | 10 | 1592 | 0 | 2023-03-13 20:38:18 |
5777 | 5777 | 1115 | 2022-10-01 | 1001 | 15 | 1592 | 0 | 2023-03-13 20:38:18 |
5752 | 5752 | 1113 | 2022-09-25 | 2154 | 118 | 1681 | 0 | 2023-03-13 20:38:18 |
5753 | 5753 | 1113 | 2022-09-25 | 596 | 44 | 1681 | 0 | 2023-03-13 20:38:18 |
5754 | 5754 | 1113 | 2022-09-25 | 382 | 69 | 1681 | 0 | 2023-03-13 20:38:18 |
5755 | 5755 | 1113 | 2022-09-25 | 2737 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
5756 | 5756 | 1113 | 2022-09-25 | 2155 | 52 | 1681 | 0 | 2023-03-13 20:38:18 |
5757 | 5757 | 1113 | 2022-09-25 | 1436 | 66 | 1681 | 0 | 2023-03-13 20:38:18 |
5758 | 5758 | 1113 | 2022-09-25 | 1278 | 11 | 1681 | 0 | 2023-03-13 20:38:18 |
5759 | 5759 | 1113 | 2022-09-25 | 2794 | 21 | 1681 | 0 | 2023-03-13 20:38:18 |
5760 | 5760 | 1113 | 2022-09-25 | 2302 | 1 | 1681 | 0 | 2023-03-13 20:38:18 |
5761 | 5761 | 1113 | 2022-09-25 | 1030 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
5762 | 5762 | 1113 | 2022-09-25 | 226 | 9 | 1681 | 0 | 2023-03-13 20:38:18 |
5763 | 5763 | 1113 | 2022-09-25 | 825 | 3 | 1681 | 0 | 2023-03-13 20:38:18 |
20526 | 20526 | 1089 | 2022-09-13 | 1759 | 53 | 1679 | 1 | 2023-03-13 20:38:18 |
20527 | 20527 | 1089 | 2022-09-13 | 220 | 38 | 1679 | 1 | 2023-03-13 20:38:18 |
20528 | 20528 | 1089 | 2022-09-13 | 2623 | 17 | 1679 | 1 | 2023-03-13 20:38:18 |
20529 | 20529 | 1089 | 2022-09-13 | 586 | 17 | 1679 | 1 | 2023-03-13 20:38:18 |
20530 | 20530 | 1089 | 2022-09-13 | 1460 | 13 | 1679 | 1 | 2023-03-13 20:38:18 |
20531 | 20531 | 1089 | 2022-09-13 | 2796 | 12 | 1679 | 1 | 2023-03-13 20:38:18 |
20834 | 20834 | 1089 | 2022-09-13 | 1359 | 0 | 1679 | 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 |
20496 | 20496 | 1086 | 2022-09-06 | 773 | 365 | 1676 | 1 | 2023-03-13 20:38:18 |
20497 | 20497 | 1086 | 2022-09-06 | 1556 | 203 | 1676 | 1 | 2023-03-13 20:38:18 |
20498 | 20498 | 1086 | 2022-09-06 | 1284 | 48 | 1676 | 1 | 2023-03-13 20:38:18 |
20499 | 20499 | 1086 | 2022-09-06 | 659 | 11 | 1676 | 1 | 2023-03-13 20:38:18 |
20500 | 20500 | 1086 | 2022-09-06 | 319 | 8 | 1676 | 1 | 2023-03-13 20:38:18 |
20501 | 20501 | 1086 | 2022-09-06 | 689 | 7 | 1676 | 1 | 2023-03-13 20:38:18 |
20502 | 20502 | 1086 | 2022-09-06 | 311 | 4 | 1676 | 1 | 2023-03-13 20:38:18 |
20503 | 20503 | 1086 | 2022-09-06 | 1023 | 2 | 1676 | 1 | 2023-03-13 20:38:18 |
20504 | 20504 | 1086 | 2022-09-06 | 467 | 1 | 1676 | 1 | 2023-03-13 20:38:18 |
20505 | 20505 | 1086 | 2022-09-06 | 2731 | 1 | 1676 | 1 | 2023-03-13 20:38:18 |
20519 | 20519 | 1106 | 2022-08-01 | 2847 | 67 | 1678 | 1 | 2023-03-13 20:38:18 |
20520 | 20520 | 1106 | 2022-08-01 | 1541 | 59 | 1678 | 1 | 2023-03-13 20:38:18 |
20521 | 20521 | 1106 | 2022-08-01 | 1286 | 34 | 1678 | 1 | 2023-03-13 20:38:18 |
20522 | 20522 | 1106 | 2022-08-01 | 1160 | 26 | 1678 | 1 | 2023-03-13 20:38:18 |
20523 | 20523 | 1106 | 2022-08-01 | 2836 | 25 | 1678 | 1 | 2023-03-13 20:38:18 |
20524 | 20524 | 1106 | 2022-08-01 | 57 | 16 | 1678 | 1 | 2023-03-13 20:38:18 |
20525 | 20525 | 1106 | 2022-08-01 | 2640 | 13 | 1678 | 1 | 2023-03-13 20:38:18 |
20833 | 20833 | 1106 | 2022-08-01 | 133 | 0 | 1678 | 1 | 2023-03-13 20:38:18 |
20540 | 20540 | 1024 | 2022-07-21 | 2155 | 177 | 1681 | 1 | 2023-03-13 20:38:18 |
20541 | 20541 | 1024 | 2022-07-21 | 1436 | 124 | 1681 | 1 | 2023-03-13 20:38:18 |
20542 | 20542 | 1024 | 2022-07-21 | 596 | 106 | 1681 | 1 | 2023-03-13 20:38:18 |
20543 | 20543 | 1024 | 2022-07-21 | 2154 | 31 | 1681 | 1 | 2023-03-13 20:38:18 |
20544 | 20544 | 1024 | 2022-07-21 | 226 | 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 |
20546 | 20546 | 1024 | 2022-07-21 | 1030 | 4 | 1681 | 1 | 2023-03-13 20:38:18 |
20547 | 20547 | 1024 | 2022-07-21 | 2153 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20548 | 20548 | 1024 | 2022-07-21 | 2302 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20549 | 20549 | 1024 | 2022-07-21 | 693 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20550 | 20550 | 1024 | 2022-07-21 | 465 | 14 | 1681 | 1 | 2023-03-13 20:38:18 |
20551 | 20551 | 1024 | 2022-07-21 | 927 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20552 | 20552 | 1024 | 2022-07-21 | 2671 | 1 | 1681 | 1 | 2023-03-13 20:38:18 |
20553 | 20553 | 1024 | 2022-07-21 | 2737 | 2 | 1681 | 1 | 2023-03-13 20:38:18 |
20554 | 20554 | 1024 | 2022-07-21 | 2794 | 25 | 1681 | 1 | 2023-03-13 20:38:18 |
20555 | 20555 | 1024 | 2022-07-21 | 2861 | 50 | 1681 | 1 | 2023-03-13 20:38:18 |
20835 | 20835 | 1024 | 2022-07-21 | 2001 | 0 | 1681 | 1 | 2023-03-13 20:38:18 |
20506 | 20506 | 1100 | 2022-07-01 | 678 | 30 | 1677 | 1 | 2023-03-13 20:38:18 |
20507 | 20507 | 1100 | 2022-07-01 | 2321 | 17 | 1677 | 1 | 2023-03-13 20:38:18 |
20508 | 20508 | 1100 | 2022-07-01 | 788 | 9 | 1677 | 1 | 2023-03-13 20:38:18 |
20509 | 20509 | 1100 | 2022-07-01 | 2725 | 8 | 1677 | 1 | 2023-03-13 20:38:18 |
20510 | 20510 | 1100 | 2022-07-01 | 2726 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
20511 | 20511 | 1100 | 2022-07-01 | 244 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
20512 | 20512 | 1100 | 2022-07-01 | 1303 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
20513 | 20513 | 1100 | 2022-07-01 | 1816 | 7 | 1677 | 1 | 2023-03-13 20:38:18 |
20514 | 20514 | 1100 | 2022-07-01 | 1357 | 6 | 1677 | 1 | 2023-03-13 20:38:18 |
20515 | 20515 | 1100 | 2022-07-01 | 732 | 6 | 1677 | 1 | 2023-03-13 20:38:18 |
20516 | 20516 | 1100 | 2022-07-01 | 2835 | 6 | 1677 | 1 | 2023-03-13 20:38:18 |
20517 | 20517 | 1100 | 2022-07-01 | 1419 | 6 | 1677 | 1 | 2023-03-13 20:38:18 |
20518 | 20518 | 1100 | 2022-07-01 | 1846 | 4 | 1677 | 1 | 2023-03-13 20:38:18 |
9388 | 9388 | 1024 | 2022-06-21 | 2155 | 177 | 1667 | 0 | 2023-03-13 20:38:18 |
9389 | 9389 | 1024 | 2022-06-21 | 1436 | 124 | 1667 | 0 | 2023-03-13 20:38:18 |
9390 | 9390 | 1024 | 2022-06-21 | 596 | 106 | 1667 | 0 | 2023-03-13 20:38:18 |
9391 | 9391 | 1024 | 2022-06-21 | 2154 | 31 | 1667 | 0 | 2023-03-13 20:38:18 |
9392 | 9392 | 1024 | 2022-06-21 | 226 | 4 | 1667 | 0 | 2023-03-13 20:38:18 |
9393 | 9393 | 1024 | 2022-06-21 | 382 | 87 | 1667 | 0 | 2023-03-13 20:38:18 |
9394 | 9394 | 1024 | 2022-06-21 | 1030 | 4 | 1667 | 0 | 2023-03-13 20:38:18 |
9395 | 9395 | 1024 | 2022-06-21 | 2153 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9396 | 9396 | 1024 | 2022-06-21 | 2302 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9397 | 9397 | 1024 | 2022-06-21 | 693 | 2 | 1667 | 0 | 2023-03-13 20:38:18 |
9398 | 9398 | 1024 | 2022-06-21 | 465 | 14 | 1667 | 0 | 2023-03-13 20:38:18 |
9399 | 9399 | 1024 | 2022-06-21 | 927 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9400 | 9400 | 1024 | 2022-06-21 | 2671 | 1 | 1667 | 0 | 2023-03-13 20:38:18 |
9401 | 9401 | 1024 | 2022-06-21 | 2737 | 2 | 1667 | 0 | 2023-03-13 20:38:18 |
9402 | 9402 | 1024 | 2022-06-21 | 2794 | 25 | 1667 | 0 | 2023-03-13 20:38:18 |
9403 | 9403 | 1024 | 2022-06-21 | 2861 | 50 | 1667 | 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 );