viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by election_id
This data as json, CSV (advanced)
calculation_date (date) 1 ✖
- 2023-03-13 20,741
Link | rowid | election_id ▼ | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
43 | 43 | 17 | 1987-06-14 | 974 | 1 | 737 | 0 | 2023-03-13 20:38:18 |
44 | 44 | 17 | 1987-06-14 | 487 | 11 | 737 | 0 | 2023-03-13 20:38:18 |
45 | 45 | 17 | 1987-06-14 | 831 | 35 | 737 | 0 | 2023-03-13 20:38:18 |
46 | 46 | 17 | 1987-06-14 | 1088 | 177 | 737 | 0 | 2023-03-13 20:38:18 |
47 | 47 | 17 | 1987-06-14 | 1296 | 13 | 737 | 0 | 2023-03-13 20:38:18 |
48 | 48 | 17 | 1987-06-14 | 1633 | 234 | 737 | 0 | 2023-03-13 20:38:18 |
49 | 49 | 17 | 1987-06-14 | 93 | 21 | 737 | 0 | 2023-03-13 20:38:18 |
50 | 50 | 17 | 1987-06-14 | 1424 | 8 | 737 | 0 | 2023-03-13 20:38:18 |
51 | 51 | 17 | 1987-06-14 | 1304 | 13 | 737 | 0 | 2023-03-13 20:38:18 |
52 | 52 | 17 | 1987-06-14 | 1475 | 94 | 737 | 0 | 2023-03-13 20:38:18 |
53 | 53 | 17 | 1987-06-14 | 1030 | 3 | 737 | 0 | 2023-03-13 20:38:18 |
54 | 54 | 17 | 1987-06-14 | 335 | 2 | 737 | 0 | 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 |
14791 | 14791 | 17 | 1988-04-13 | 242 | 17 | 809 | 1 | 2023-03-13 20:38:18 |
14792 | 14792 | 17 | 1988-04-13 | 1560 | 1 | 809 | 1 | 2023-03-13 20:38:18 |
14793 | 14793 | 17 | 1988-04-13 | 974 | 1 | 809 | 1 | 2023-03-13 20:38:18 |
14794 | 14794 | 17 | 1988-04-13 | 487 | 11 | 809 | 1 | 2023-03-13 20:38:18 |
14795 | 14795 | 17 | 1988-04-13 | 831 | 35 | 809 | 1 | 2023-03-13 20:38:18 |
14796 | 14796 | 17 | 1988-04-13 | 1088 | 177 | 809 | 1 | 2023-03-13 20:38:18 |
14797 | 14797 | 17 | 1988-04-13 | 1296 | 13 | 809 | 1 | 2023-03-13 20:38:18 |
14798 | 14798 | 17 | 1988-04-13 | 1633 | 234 | 809 | 1 | 2023-03-13 20:38:18 |
14799 | 14799 | 17 | 1988-04-13 | 93 | 21 | 809 | 1 | 2023-03-13 20:38:18 |
14800 | 14800 | 17 | 1988-04-13 | 1424 | 8 | 809 | 1 | 2023-03-13 20:38:18 |
14801 | 14801 | 17 | 1988-04-13 | 1304 | 13 | 809 | 1 | 2023-03-13 20:38:18 |
14802 | 14802 | 17 | 1988-04-13 | 1475 | 94 | 809 | 1 | 2023-03-13 20:38:18 |
14803 | 14803 | 17 | 1988-04-13 | 1030 | 3 | 809 | 1 | 2023-03-13 20:38:18 |
14804 | 14804 | 17 | 1988-04-13 | 335 | 2 | 809 | 1 | 2023-03-13 20:38:18 |
55 | 55 | 19 | 1946-02-17 | 1335 | 4 | 204 | 0 | 2023-03-13 20:38:18 |
56 | 56 | 19 | 1946-02-17 | 1181 | 1 | 204 | 0 | 2023-03-13 20:38:18 |
57 | 57 | 19 | 1946-02-17 | 63 | 16 | 204 | 0 | 2023-03-13 20:38:18 |
58 | 58 | 19 | 1946-02-17 | 708 | 23 | 204 | 0 | 2023-03-13 20:38:18 |
59 | 59 | 19 | 1946-02-17 | 167 | 66 | 204 | 0 | 2023-03-13 20:38:18 |
60 | 60 | 19 | 1946-02-17 | 1051 | 92 | 204 | 0 | 2023-03-13 20:38:18 |
9731 | 9731 | 19 | 1948-11-26 | 1335 | 4 | 40 | 1 | 2023-03-13 20:38:18 |
9732 | 9732 | 19 | 1948-11-26 | 1181 | 1 | 40 | 1 | 2023-03-13 20:38:18 |
9733 | 9733 | 19 | 1948-11-26 | 63 | 16 | 40 | 1 | 2023-03-13 20:38:18 |
9734 | 9734 | 19 | 1948-11-26 | 708 | 23 | 40 | 1 | 2023-03-13 20:38:18 |
9735 | 9735 | 19 | 1948-11-26 | 167 | 66 | 40 | 1 | 2023-03-13 20:38:18 |
9736 | 9736 | 19 | 1948-11-26 | 1051 | 92 | 40 | 1 | 2023-03-13 20:38:18 |
10610 | 10610 | 19 | 1946-03-13 | 1335 | 4 | 168 | 1 | 2023-03-13 20:38:18 |
10611 | 10611 | 19 | 1946-03-13 | 1181 | 1 | 168 | 1 | 2023-03-13 20:38:18 |
10612 | 10612 | 19 | 1946-03-13 | 63 | 16 | 168 | 1 | 2023-03-13 20:38:18 |
10613 | 10613 | 19 | 1946-03-13 | 708 | 23 | 168 | 1 | 2023-03-13 20:38:18 |
10614 | 10614 | 19 | 1946-03-13 | 167 | 66 | 168 | 1 | 2023-03-13 20:38:18 |
10615 | 10615 | 19 | 1946-03-13 | 1051 | 92 | 168 | 1 | 2023-03-13 20:38:18 |
12728 | 12728 | 19 | 1946-03-31 | 1335 | 4 | 489 | 1 | 2023-03-13 20:38:18 |
12729 | 12729 | 19 | 1946-03-31 | 1181 | 1 | 489 | 1 | 2023-03-13 20:38:18 |
12730 | 12730 | 19 | 1946-03-31 | 63 | 16 | 489 | 1 | 2023-03-13 20:38:18 |
12731 | 12731 | 19 | 1946-03-31 | 708 | 23 | 489 | 1 | 2023-03-13 20:38:18 |
12732 | 12732 | 19 | 1946-03-31 | 167 | 66 | 489 | 1 | 2023-03-13 20:38:18 |
12733 | 12733 | 19 | 1946-03-31 | 1051 | 92 | 489 | 1 | 2023-03-13 20:38:18 |
12774 | 12774 | 19 | 1947-03-20 | 1335 | 4 | 496 | 1 | 2023-03-13 20:38:18 |
12775 | 12775 | 19 | 1947-03-20 | 1181 | 1 | 496 | 1 | 2023-03-13 20:38:18 |
12776 | 12776 | 19 | 1947-03-20 | 63 | 16 | 496 | 1 | 2023-03-13 20:38:18 |
12777 | 12777 | 19 | 1947-03-20 | 708 | 23 | 496 | 1 | 2023-03-13 20:38:18 |
12778 | 12778 | 19 | 1947-03-20 | 167 | 66 | 496 | 1 | 2023-03-13 20:38:18 |
12779 | 12779 | 19 | 1947-03-20 | 1051 | 92 | 496 | 1 | 2023-03-13 20:38:18 |
13097 | 13097 | 19 | 1946-08-03 | 1335 | 4 | 540 | 1 | 2023-03-13 20:38:18 |
13098 | 13098 | 19 | 1946-08-03 | 1181 | 1 | 540 | 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 );