viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by cabinet_id descending
This data as json, CSV (advanced)
Link | rowid | election_id | date | party_id | seats | cabinet_id ▲ | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
5764 | 5764 | 1114 | 2022-10-02 | 1286 | 36 | 1678 | 0 | 2023-03-13 20:38:18 |
5765 | 5765 | 1114 | 2022-10-02 | 2847 | 53 | 1678 | 0 | 2023-03-13 20:38:18 |
5766 | 5766 | 1114 | 2022-10-02 | 2640 | 27 | 1678 | 0 | 2023-03-13 20:38:18 |
5767 | 5767 | 1114 | 2022-10-02 | 1541 | 67 | 1678 | 0 | 2023-03-13 20:38:18 |
5768 | 5768 | 1114 | 2022-10-02 | 2638 | 20 | 1678 | 0 | 2023-03-13 20:38:18 |
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 |
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 |
5794 | 5794 | 1117 | 2022-11-01 | 678 | 32 | 1677 | 0 | 2023-03-13 20:38:18 |
5795 | 5795 | 1117 | 2022-11-01 | 2321 | 24 | 1677 | 0 | 2023-03-13 20:38:18 |
5796 | 5796 | 1117 | 2022-11-01 | 1846 | 5 | 1677 | 0 | 2023-03-13 20:38:18 |
5797 | 5797 | 1117 | 2022-11-01 | 1816 | 6 | 1677 | 0 | 2023-03-13 20:38:18 |
5798 | 5798 | 1117 | 2022-11-01 | 2725 | 12 | 1677 | 0 | 2023-03-13 20:38:18 |
5799 | 5799 | 1117 | 2022-11-01 | 1357 | 14 | 1677 | 0 | 2023-03-13 20:38:18 |
5800 | 5800 | 1117 | 2022-11-01 | 732 | 5 | 1677 | 0 | 2023-03-13 20:38:18 |
5801 | 5801 | 1117 | 2022-11-01 | 244 | 4 | 1677 | 0 | 2023-03-13 20:38:18 |
5802 | 5802 | 1117 | 2022-11-01 | 788 | 11 | 1677 | 0 | 2023-03-13 20:38:18 |
5803 | 5803 | 1117 | 2022-11-01 | 1303 | 7 | 1677 | 0 | 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 |
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 |
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 |
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 |
20473 | 20473 | 1014 | 2022-05-20 | 2643 | 308 | 1673 | 1 | 2023-03-13 20:38:18 |
20474 | 20474 | 1014 | 2022-05-20 | 658 | 112 | 1673 | 1 | 2023-03-13 20:38:18 |
20475 | 20475 | 1014 | 2022-05-20 | 509 | 42 | 1673 | 1 | 2023-03-13 20:38:18 |
20476 | 20476 | 1014 | 2022-05-20 | 2273 | 18 | 1673 | 1 | 2023-03-13 20:38:18 |
20477 | 20477 | 1014 | 2022-05-20 | 1539 | 30 | 1673 | 1 | 2023-03-13 20:38:18 |
20478 | 20478 | 1014 | 2022-05-20 | 686 | 10 | 1673 | 1 | 2023-03-13 20:38:18 |
20479 | 20479 | 1014 | 2022-05-20 | 1492 | 3 | 1673 | 1 | 2023-03-13 20:38:18 |
20480 | 20480 | 1014 | 2022-05-20 | 177 | 12 | 1673 | 1 | 2023-03-13 20:38:18 |
20481 | 20481 | 1014 | 2022-05-20 | 285 | 6 | 1673 | 1 | 2023-03-13 20:38:18 |
20482 | 20482 | 1014 | 2022-05-20 | 270 | 8 | 1673 | 1 | 2023-03-13 20:38:18 |
20483 | 20483 | 1014 | 2022-05-20 | 873 | 1 | 1673 | 1 | 2023-03-13 20:38:18 |
20484 | 20484 | 1014 | 2022-05-20 | 2399 | 1 | 1673 | 1 | 2023-03-13 20:38:18 |
20485 | 20485 | 1014 | 2022-05-20 | 2644 | 17 | 1673 | 1 | 2023-03-13 20:38:18 |
20486 | 20486 | 1014 | 2022-05-20 | 2079 | 1 | 1673 | 1 | 2023-03-13 20:38:18 |
20487 | 20487 | 1014 | 2022-05-20 | 1328 | 3 | 1673 | 1 | 2023-03-13 20:38:18 |
20488 | 20488 | 1014 | 2022-05-20 | 947 | 5 | 1673 | 1 | 2023-03-13 20:38:18 |
20828 | 20828 | 1014 | 2022-05-20 | 2862 | 0 | 1673 | 1 | 2023-03-13 20:38:18 |
20829 | 20829 | 1014 | 2022-05-20 | 2857 | 0 | 1673 | 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 |
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 );