viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 1999-12-21 43
- 2002-07-30 31
- 1996-03-11 29
- 1996-01-11 28
- 1999-03-25 26
- 2019-09-17 26
- 2022-11-01 26
- 1933-01-31 25
- 1977-02-15 25
- 1999-07-06 25
- 2020-01-07 25
- 1958-07-01 24
- 2017-03-15 24
- 1970-05-14 23
- 1991-10-20 23
- 1993-01-12 23
- 1996-10-20 23
- 2006-04-09 23
- 2011-12-04 23
- 1925-10-29 22
- 1968-01-23 22
- 2008-09-21 22
- 1935-06-07 21
- 1959-12-17 21
- 1995-01-17 21
- 2012-06-17 21
- 2016-12-12 21
- 1981-05-19 20
- 1991-10-27 20
- 1991-12-23 20
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1972-11-25 | 997 | 32 | 569 | 0 | 2023-03-13 20:38:18 |
2 | 2 | 1 | 1972-11-25 | 878 | 55 | 569 | 0 | 2023-03-13 20:38:18 |
3 | 3 | 2 | 1999-06-13 | 1029 | 14 | 95 | 0 | 2023-03-13 20:38:18 |
4 | 4 | 2 | 1999-06-13 | 1594 | 9 | 95 | 0 | 2023-03-13 20:38:18 |
5 | 5 | 2 | 1999-06-13 | 1378 | 19 | 95 | 0 | 2023-03-13 20:38:18 |
6 | 6 | 2 | 1999-06-13 | 723 | 22 | 95 | 0 | 2023-03-13 20:38:18 |
7 | 7 | 2 | 1999-06-13 | 171 | 1 | 95 | 0 | 2023-03-13 20:38:18 |
8 | 8 | 2 | 1999-06-13 | 1192 | 10 | 95 | 0 | 2023-03-13 20:38:18 |
9 | 9 | 2 | 1999-06-13 | 454 | 18 | 95 | 0 | 2023-03-13 20:38:18 |
10 | 10 | 2 | 1999-06-13 | 161 | 11 | 95 | 0 | 2023-03-13 20:38:18 |
11 | 11 | 2 | 1999-06-13 | 290 | 8 | 95 | 0 | 2023-03-13 20:38:18 |
12 | 12 | 2 | 1999-06-13 | 993 | 15 | 95 | 0 | 2023-03-13 20:38:18 |
13 | 13 | 2 | 1999-06-13 | 1110 | 23 | 95 | 0 | 2023-03-13 20:38:18 |
14 | 14 | 3 | 2005-09-12 | 1435 | 23 | 300 | 0 | 2023-03-13 20:38:18 |
15 | 15 | 3 | 2005-09-12 | 1538 | 11 | 300 | 0 | 2023-03-13 20:38:18 |
16 | 16 | 3 | 2005-09-12 | 647 | 10 | 300 | 0 | 2023-03-13 20:38:18 |
17 | 17 | 3 | 2005-09-12 | 104 | 61 | 300 | 0 | 2023-03-13 20:38:18 |
18 | 18 | 3 | 2005-09-12 | 702 | 11 | 300 | 0 | 2023-03-13 20:38:18 |
19 | 19 | 3 | 2005-09-12 | 81 | 15 | 300 | 0 | 2023-03-13 20:38:18 |
20 | 20 | 3 | 2005-09-12 | 351 | 38 | 300 | 0 | 2023-03-13 20:38:18 |
21 | 21 | 6 | 1977-06-16 | 318 | 17 | 315 | 0 | 2023-03-13 20:38:18 |
22 | 22 | 6 | 1977-06-16 | 1393 | 43 | 315 | 0 | 2023-03-13 20:38:18 |
23 | 23 | 6 | 1977-06-16 | 30 | 4 | 315 | 0 | 2023-03-13 20:38:18 |
24 | 24 | 6 | 1977-06-16 | 280 | 84 | 315 | 0 | 2023-03-13 20:38:18 |
25 | 25 | 8 | 1971-06-14 | 1003 | 28 | 681 | 0 | 2023-03-13 20:38:18 |
26 | 26 | 8 | 1971-06-14 | 984 | 27 | 681 | 0 | 2023-03-13 20:38:18 |
27 | 27 | 11 | 1953-02-22 | 769 | 4 | 560 | 0 | 2023-03-13 20:38:18 |
28 | 28 | 11 | 1953-02-22 | 50 | 14 | 560 | 0 | 2023-03-13 20:38:18 |
29 | 29 | 11 | 1953-02-22 | 973 | 73 | 560 | 0 | 2023-03-13 20:38:18 |
30 | 30 | 11 | 1953-02-22 | 1013 | 74 | 560 | 0 | 2023-03-13 20:38:18 |
31 | 31 | 15 | 1999-03-21 | 94 | 48 | 100 | 0 | 2023-03-13 20:38:18 |
32 | 32 | 15 | 1999-03-21 | 585 | 11 | 100 | 0 | 2023-03-13 20:38:18 |
33 | 33 | 15 | 1999-03-21 | 200 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
34 | 34 | 15 | 1999-03-21 | 1062 | 11 | 100 | 0 | 2023-03-13 20:38:18 |
35 | 35 | 15 | 1999-03-21 | 1118 | 46 | 100 | 0 | 2023-03-13 20:38:18 |
36 | 36 | 15 | 1999-03-21 | 395 | 51 | 100 | 0 | 2023-03-13 20:38:18 |
37 | 37 | 15 | 1999-03-21 | 66 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
38 | 38 | 15 | 1999-03-21 | 1292 | 20 | 100 | 0 | 2023-03-13 20:38:18 |
39 | 39 | 15 | 1999-03-21 | 1463 | 10 | 100 | 0 | 2023-03-13 20:38:18 |
40 | 40 | 15 | 1999-03-21 | 638 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
41 | 41 | 17 | 1987-06-14 | 242 | 17 | 737 | 0 | 2023-03-13 20:38:18 |
42 | 42 | 17 | 1987-06-14 | 1560 | 1 | 737 | 0 | 2023-03-13 20:38:18 |
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 |
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 |
61 | 61 | 20 | 1981-06-21 | 138 | 80 | 1148 | 0 | 2023-03-13 20:38:18 |
62 | 62 | 20 | 1981-06-21 | 1539 | 268 | 1148 | 0 | 2023-03-13 20:38:18 |
63 | 63 | 20 | 1981-06-21 | 509 | 59 | 1148 | 0 | 2023-03-13 20:38:18 |
64 | 64 | 20 | 1981-06-21 | 686 | 43 | 1148 | 0 | 2023-03-13 20:38:18 |
65 | 65 | 20 | 1981-06-21 | 1492 | 14 | 1148 | 0 | 2023-03-13 20:38:18 |
66 | 66 | 20 | 1981-06-21 | 1414 | 10 | 1148 | 0 | 2023-03-13 20:38:18 |
67 | 67 | 21 | 1951-10-28 | 1167 | 5 | 556 | 0 | 2023-03-13 20:38:18 |
68 | 68 | 21 | 1951-10-28 | 531 | 48 | 556 | 0 | 2023-03-13 20:38:18 |
69 | 69 | 21 | 1951-10-28 | 602 | 1 | 556 | 0 | 2023-03-13 20:38:18 |
70 | 70 | 21 | 1951-10-28 | 26 | 51 | 556 | 0 | 2023-03-13 20:38:18 |
71 | 71 | 21 | 1951-10-28 | 458 | 5 | 556 | 0 | 2023-03-13 20:38:18 |
72 | 72 | 21 | 1951-10-28 | 886 | 4 | 556 | 0 | 2023-03-13 20:38:18 |
73 | 73 | 21 | 1951-10-28 | 35 | 49 | 556 | 0 | 2023-03-13 20:38:18 |
74 | 74 | 21 | 1951-10-28 | 750 | 23 | 556 | 0 | 2023-03-13 20:38:18 |
75 | 75 | 21 | 1951-10-28 | 1264 | 10 | 556 | 0 | 2023-03-13 20:38:18 |
76 | 76 | 24 | 1995-03-19 | 94 | 44 | 206 | 0 | 2023-03-13 20:38:18 |
77 | 77 | 24 | 1995-03-19 | 1292 | 22 | 206 | 0 | 2023-03-13 20:38:18 |
78 | 78 | 24 | 1995-03-19 | 1463 | 7 | 206 | 0 | 2023-03-13 20:38:18 |
79 | 79 | 24 | 1995-03-19 | 66 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
80 | 80 | 24 | 1995-03-19 | 1062 | 9 | 206 | 0 | 2023-03-13 20:38:18 |
81 | 81 | 24 | 1995-03-19 | 200 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
82 | 82 | 24 | 1995-03-19 | 585 | 11 | 206 | 0 | 2023-03-13 20:38:18 |
83 | 83 | 24 | 1995-03-19 | 1009 | 2 | 206 | 0 | 2023-03-13 20:38:18 |
84 | 84 | 24 | 1995-03-19 | 1105 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
85 | 85 | 24 | 1995-03-19 | 395 | 63 | 206 | 0 | 2023-03-13 20:38:18 |
86 | 86 | 24 | 1995-03-19 | 1118 | 39 | 206 | 0 | 2023-03-13 20:38:18 |
87 | 87 | 25 | 1990-02-18 | 1540 | 16 | 106 | 0 | 2023-03-13 20:38:18 |
88 | 88 | 25 | 1990-02-18 | 940 | 136 | 106 | 0 | 2023-03-13 20:38:18 |
89 | 89 | 25 | 1990-02-18 | 905 | 21 | 106 | 0 | 2023-03-13 20:38:18 |
90 | 90 | 25 | 1990-02-18 | 837 | 45 | 106 | 0 | 2023-03-13 20:38:18 |
91 | 91 | 25 | 1990-02-18 | 86 | 4 | 106 | 0 | 2023-03-13 20:38:18 |
92 | 92 | 25 | 1990-02-18 | 2297 | 1 | 106 | 0 | 2023-03-13 20:38:18 |
93 | 93 | 25 | 1990-02-18 | 1193 | 275 | 106 | 0 | 2023-03-13 20:38:18 |
94 | 94 | 25 | 1990-02-18 | 1053 | 14 | 106 | 0 | 2023-03-13 20:38:18 |
95 | 95 | 27 | 1998-06-20 | 1245 | 20 | 76 | 0 | 2023-03-13 20:38:18 |
96 | 96 | 27 | 1998-06-20 | 789 | 74 | 76 | 0 | 2023-03-13 20:38:18 |
97 | 97 | 27 | 1998-06-20 | 688 | 19 | 76 | 0 | 2023-03-13 20:38:18 |
98 | 98 | 27 | 1998-06-20 | 1173 | 24 | 76 | 0 | 2023-03-13 20:38:18 |
99 | 99 | 27 | 1998-06-20 | 829 | 63 | 76 | 0 | 2023-03-13 20:38:18 |
100 | 100 | 30 | 1955-10-30 | 602 | 1 | 814 | 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 );