viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 sorted by election_id
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 |
---|---|---|---|---|---|---|---|---|
10112 | 10112 | 1 | 1972-12-08 | 997 | 32 | 97 | 1 | 2023-03-13 20:38:18 |
10113 | 10113 | 1 | 1972-12-08 | 878 | 55 | 97 | 1 | 2023-03-13 20:38:18 |
12211 | 12211 | 1 | 1974-09-06 | 997 | 32 | 413 | 1 | 2023-03-13 20:38:18 |
12212 | 12212 | 1 | 1974-09-06 | 878 | 55 | 413 | 1 | 2023-03-13 20:38:18 |
10771 | 10771 | 2 | 1999-07-12 | 1029 | 14 | 193 | 1 | 2023-03-13 20:38:18 |
10772 | 10772 | 2 | 1999-07-12 | 1594 | 9 | 193 | 1 | 2023-03-13 20:38:18 |
10773 | 10773 | 2 | 1999-07-12 | 1378 | 19 | 193 | 1 | 2023-03-13 20:38:18 |
10774 | 10774 | 2 | 1999-07-12 | 723 | 22 | 193 | 1 | 2023-03-13 20:38:18 |
10775 | 10775 | 2 | 1999-07-12 | 171 | 1 | 193 | 1 | 2023-03-13 20:38:18 |
10776 | 10776 | 2 | 1999-07-12 | 1192 | 10 | 193 | 1 | 2023-03-13 20:38:18 |
10777 | 10777 | 2 | 1999-07-12 | 454 | 18 | 193 | 1 | 2023-03-13 20:38:18 |
10778 | 10778 | 2 | 1999-07-12 | 161 | 11 | 193 | 1 | 2023-03-13 20:38:18 |
10779 | 10779 | 2 | 1999-07-12 | 290 | 8 | 193 | 1 | 2023-03-13 20:38:18 |
10780 | 10780 | 2 | 1999-07-12 | 993 | 15 | 193 | 1 | 2023-03-13 20:38:18 |
10781 | 10781 | 2 | 1999-07-12 | 1110 | 23 | 193 | 1 | 2023-03-13 20:38:18 |
14032 | 14032 | 3 | 2005-10-17 | 1435 | 23 | 693 | 1 | 2023-03-13 20:38:18 |
14033 | 14033 | 3 | 2005-10-17 | 1538 | 11 | 693 | 1 | 2023-03-13 20:38:18 |
14034 | 14034 | 3 | 2005-10-17 | 647 | 10 | 693 | 1 | 2023-03-13 20:38:18 |
14035 | 14035 | 3 | 2005-10-17 | 104 | 61 | 693 | 1 | 2023-03-13 20:38:18 |
14036 | 14036 | 3 | 2005-10-17 | 702 | 11 | 693 | 1 | 2023-03-13 20:38:18 |
14037 | 14037 | 3 | 2005-10-17 | 81 | 15 | 693 | 1 | 2023-03-13 20:38:18 |
14038 | 14038 | 3 | 2005-10-17 | 351 | 38 | 693 | 1 | 2023-03-13 20:38:18 |
12422 | 12422 | 6 | 1979-12-12 | 318 | 17 | 442 | 1 | 2023-03-13 20:38:18 |
12423 | 12423 | 6 | 1979-12-12 | 1393 | 43 | 442 | 1 | 2023-03-13 20:38:18 |
12424 | 12424 | 6 | 1979-12-12 | 30 | 4 | 442 | 1 | 2023-03-13 20:38:18 |
12425 | 12425 | 6 | 1979-12-12 | 280 | 84 | 442 | 1 | 2023-03-13 20:38:18 |
14683 | 14683 | 6 | 1977-07-05 | 318 | 17 | 794 | 1 | 2023-03-13 20:38:18 |
14684 | 14684 | 6 | 1977-07-05 | 1393 | 43 | 794 | 1 | 2023-03-13 20:38:18 |
14685 | 14685 | 6 | 1977-07-05 | 30 | 4 | 794 | 1 | 2023-03-13 20:38:18 |
14686 | 14686 | 6 | 1977-07-05 | 280 | 84 | 794 | 1 | 2023-03-13 20:38:18 |
11485 | 11485 | 8 | 1971-06-21 | 1003 | 28 | 295 | 1 | 2023-03-13 20:38:18 |
11486 | 11486 | 8 | 1971-06-21 | 984 | 27 | 295 | 1 | 2023-03-13 20:38:18 |
14855 | 14855 | 8 | 1974-09-30 | 1003 | 28 | 816 | 1 | 2023-03-13 20:38:18 |
14856 | 14856 | 8 | 1974-09-30 | 984 | 27 | 816 | 1 | 2023-03-13 20:38:18 |
13834 | 13834 | 11 | 1953-04-02 | 769 | 4 | 659 | 1 | 2023-03-13 20:38:18 |
13835 | 13835 | 11 | 1953-04-02 | 50 | 14 | 659 | 1 | 2023-03-13 20:38:18 |
13836 | 13836 | 11 | 1953-04-02 | 973 | 73 | 659 | 1 | 2023-03-13 20:38:18 |
13837 | 13837 | 11 | 1953-04-02 | 1013 | 74 | 659 | 1 | 2023-03-13 20:38:18 |
11803 | 11803 | 15 | 1999-04-15 | 94 | 48 | 352 | 1 | 2023-03-13 20:38:18 |
11804 | 11804 | 15 | 1999-04-15 | 585 | 11 | 352 | 1 | 2023-03-13 20:38:18 |
11805 | 11805 | 15 | 1999-04-15 | 200 | 1 | 352 | 1 | 2023-03-13 20:38:18 |
11806 | 11806 | 15 | 1999-04-15 | 1062 | 11 | 352 | 1 | 2023-03-13 20:38:18 |
11807 | 11807 | 15 | 1999-04-15 | 1118 | 46 | 352 | 1 | 2023-03-13 20:38:18 |
11808 | 11808 | 15 | 1999-04-15 | 395 | 51 | 352 | 1 | 2023-03-13 20:38:18 |
11809 | 11809 | 15 | 1999-04-15 | 66 | 1 | 352 | 1 | 2023-03-13 20:38:18 |
11810 | 11810 | 15 | 1999-04-15 | 1292 | 20 | 352 | 1 | 2023-03-13 20:38:18 |
11811 | 11811 | 15 | 1999-04-15 | 1463 | 10 | 352 | 1 | 2023-03-13 20:38:18 |
11812 | 11812 | 15 | 1999-04-15 | 638 | 1 | 352 | 1 | 2023-03-13 20:38:18 |
13857 | 13857 | 15 | 2002-05-31 | 94 | 48 | 663 | 1 | 2023-03-13 20:38:18 |
13858 | 13858 | 15 | 2002-05-31 | 585 | 11 | 663 | 1 | 2023-03-13 20:38:18 |
13859 | 13859 | 15 | 2002-05-31 | 200 | 1 | 663 | 1 | 2023-03-13 20:38:18 |
13860 | 13860 | 15 | 2002-05-31 | 1062 | 11 | 663 | 1 | 2023-03-13 20:38:18 |
13861 | 13861 | 15 | 2002-05-31 | 1118 | 46 | 663 | 1 | 2023-03-13 20:38:18 |
13862 | 13862 | 15 | 2002-05-31 | 395 | 51 | 663 | 1 | 2023-03-13 20:38:18 |
13863 | 13863 | 15 | 2002-05-31 | 66 | 1 | 663 | 1 | 2023-03-13 20:38:18 |
13864 | 13864 | 15 | 2002-05-31 | 1292 | 20 | 663 | 1 | 2023-03-13 20:38:18 |
13865 | 13865 | 15 | 2002-05-31 | 1463 | 10 | 663 | 1 | 2023-03-13 20:38:18 |
13866 | 13866 | 15 | 2002-05-31 | 638 | 1 | 663 | 1 | 2023-03-13 20:38:18 |
10842 | 10842 | 17 | 1991-04-13 | 242 | 17 | 202 | 1 | 2023-03-13 20:38:18 |
10843 | 10843 | 17 | 1991-04-13 | 1560 | 1 | 202 | 1 | 2023-03-13 20:38:18 |
10844 | 10844 | 17 | 1991-04-13 | 974 | 1 | 202 | 1 | 2023-03-13 20:38:18 |
10845 | 10845 | 17 | 1991-04-13 | 487 | 11 | 202 | 1 | 2023-03-13 20:38:18 |
10846 | 10846 | 17 | 1991-04-13 | 831 | 35 | 202 | 1 | 2023-03-13 20:38:18 |
10847 | 10847 | 17 | 1991-04-13 | 1088 | 177 | 202 | 1 | 2023-03-13 20:38:18 |
10848 | 10848 | 17 | 1991-04-13 | 1296 | 13 | 202 | 1 | 2023-03-13 20:38:18 |
10849 | 10849 | 17 | 1991-04-13 | 1633 | 234 | 202 | 1 | 2023-03-13 20:38:18 |
10850 | 10850 | 17 | 1991-04-13 | 93 | 21 | 202 | 1 | 2023-03-13 20:38:18 |
10851 | 10851 | 17 | 1991-04-13 | 1424 | 8 | 202 | 1 | 2023-03-13 20:38:18 |
10852 | 10852 | 17 | 1991-04-13 | 1304 | 13 | 202 | 1 | 2023-03-13 20:38:18 |
10853 | 10853 | 17 | 1991-04-13 | 1475 | 94 | 202 | 1 | 2023-03-13 20:38:18 |
10854 | 10854 | 17 | 1991-04-13 | 1030 | 3 | 202 | 1 | 2023-03-13 20:38:18 |
10855 | 10855 | 17 | 1991-04-13 | 335 | 2 | 202 | 1 | 2023-03-13 20:38:18 |
12567 | 12567 | 17 | 1989-07-23 | 242 | 17 | 460 | 1 | 2023-03-13 20:38:18 |
12568 | 12568 | 17 | 1989-07-23 | 1560 | 1 | 460 | 1 | 2023-03-13 20:38:18 |
12569 | 12569 | 17 | 1989-07-23 | 974 | 1 | 460 | 1 | 2023-03-13 20:38:18 |
12570 | 12570 | 17 | 1989-07-23 | 487 | 11 | 460 | 1 | 2023-03-13 20:38:18 |
12571 | 12571 | 17 | 1989-07-23 | 831 | 35 | 460 | 1 | 2023-03-13 20:38:18 |
12572 | 12572 | 17 | 1989-07-23 | 1088 | 177 | 460 | 1 | 2023-03-13 20:38:18 |
12573 | 12573 | 17 | 1989-07-23 | 1296 | 13 | 460 | 1 | 2023-03-13 20:38:18 |
12574 | 12574 | 17 | 1989-07-23 | 1633 | 234 | 460 | 1 | 2023-03-13 20:38:18 |
12575 | 12575 | 17 | 1989-07-23 | 93 | 21 | 460 | 1 | 2023-03-13 20:38:18 |
12576 | 12576 | 17 | 1989-07-23 | 1424 | 8 | 460 | 1 | 2023-03-13 20:38:18 |
12577 | 12577 | 17 | 1989-07-23 | 1304 | 13 | 460 | 1 | 2023-03-13 20:38:18 |
12578 | 12578 | 17 | 1989-07-23 | 1475 | 94 | 460 | 1 | 2023-03-13 20:38:18 |
12579 | 12579 | 17 | 1989-07-23 | 1030 | 3 | 460 | 1 | 2023-03-13 20:38:18 |
12580 | 12580 | 17 | 1989-07-23 | 335 | 2 | 460 | 1 | 2023-03-13 20:38:18 |
14434 | 14434 | 17 | 1987-07-28 | 242 | 17 | 756 | 1 | 2023-03-13 20:38:18 |
14435 | 14435 | 17 | 1987-07-28 | 1560 | 1 | 756 | 1 | 2023-03-13 20:38:18 |
14436 | 14436 | 17 | 1987-07-28 | 974 | 1 | 756 | 1 | 2023-03-13 20:38:18 |
14437 | 14437 | 17 | 1987-07-28 | 487 | 11 | 756 | 1 | 2023-03-13 20:38:18 |
14438 | 14438 | 17 | 1987-07-28 | 831 | 35 | 756 | 1 | 2023-03-13 20:38:18 |
14439 | 14439 | 17 | 1987-07-28 | 1088 | 177 | 756 | 1 | 2023-03-13 20:38:18 |
14440 | 14440 | 17 | 1987-07-28 | 1296 | 13 | 756 | 1 | 2023-03-13 20:38:18 |
14441 | 14441 | 17 | 1987-07-28 | 1633 | 234 | 756 | 1 | 2023-03-13 20:38:18 |
14442 | 14442 | 17 | 1987-07-28 | 93 | 21 | 756 | 1 | 2023-03-13 20:38:18 |
14443 | 14443 | 17 | 1987-07-28 | 1424 | 8 | 756 | 1 | 2023-03-13 20:38:18 |
14444 | 14444 | 17 | 1987-07-28 | 1304 | 13 | 756 | 1 | 2023-03-13 20:38:18 |
14445 | 14445 | 17 | 1987-07-28 | 1475 | 94 | 756 | 1 | 2023-03-13 20:38:18 |
14446 | 14446 | 17 | 1987-07-28 | 1030 | 3 | 756 | 1 | 2023-03-13 20:38:18 |
14447 | 14447 | 17 | 1987-07-28 | 335 | 2 | 756 | 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 );