viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by election_id
This data as json, CSV (advanced)
Link | rowid | election_id ▼ | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
5956 | 5956 | 25 | 1992-07-26 | 940 | 138 | 253 | 0 | 2023-03-13 20:38:18 |
5957 | 5957 | 25 | 1992-07-26 | 837 | 46 | 253 | 0 | 2023-03-13 20:38:18 |
5958 | 5958 | 25 | 1992-07-26 | 1540 | 16 | 253 | 0 | 2023-03-13 20:38:18 |
5959 | 5959 | 25 | 1992-07-26 | 1053 | 14 | 253 | 0 | 2023-03-13 20:38:18 |
5960 | 5960 | 25 | 1992-07-26 | 905 | 10 | 253 | 0 | 2023-03-13 20:38:18 |
5961 | 5961 | 25 | 1992-07-26 | 1812 | 10 | 253 | 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 |
101 | 101 | 30 | 1955-10-30 | 1264 | 10 | 814 | 0 | 2023-03-13 20:38:18 |
102 | 102 | 30 | 1955-10-30 | 531 | 47 | 814 | 0 | 2023-03-13 20:38:18 |
103 | 103 | 30 | 1955-10-30 | 886 | 4 | 814 | 0 | 2023-03-13 20:38:18 |
104 | 104 | 30 | 1955-10-30 | 26 | 50 | 814 | 0 | 2023-03-13 20:38:18 |
105 | 105 | 30 | 1955-10-30 | 35 | 53 | 814 | 0 | 2023-03-13 20:38:18 |
106 | 106 | 30 | 1955-10-30 | 1167 | 4 | 814 | 0 | 2023-03-13 20:38:18 |
107 | 107 | 30 | 1955-10-30 | 750 | 22 | 814 | 0 | 2023-03-13 20:38:18 |
108 | 108 | 30 | 1955-10-30 | 458 | 5 | 814 | 0 | 2023-03-13 20:38:18 |
109 | 109 | 32 | 1991-10-13 | 1286 | 24 | 0 | 2023-03-13 20:38:18 | |
110 | 110 | 32 | 1991-10-13 | 1160 | 106 | 0 | 2023-03-13 20:38:18 | |
111 | 111 | 32 | 1991-10-13 | 423 | 110 | 0 | 2023-03-13 20:38:18 | |
112 | 112 | 33 | 1998-09-20 | 882 | 43 | 156 | 0 | 2023-03-13 20:38:18 |
113 | 113 | 33 | 1998-09-20 | 1461 | 18 | 156 | 0 | 2023-03-13 20:38:18 |
114 | 114 | 33 | 1998-09-20 | 904 | 131 | 156 | 0 | 2023-03-13 20:38:18 |
115 | 115 | 33 | 1998-09-20 | 282 | 42 | 156 | 0 | 2023-03-13 20:38:18 |
116 | 116 | 33 | 1998-09-20 | 892 | 17 | 156 | 0 | 2023-03-13 20:38:18 |
117 | 117 | 33 | 1998-09-20 | 1154 | 16 | 156 | 0 | 2023-03-13 20:38:18 |
118 | 118 | 33 | 1998-09-20 | 657 | 82 | 156 | 0 | 2023-03-13 20:38:18 |
6155 | 6155 | 36 | 2009-08-14 | 1455 | 9 | 651 | 0 | 2023-03-13 20:38:18 |
6156 | 6156 | 36 | 2009-08-14 | 1342 | 16 | 651 | 0 | 2023-03-13 20:38:18 |
6157 | 6157 | 36 | 2009-08-14 | 210 | 14 | 651 | 0 | 2023-03-13 20:38:18 |
6158 | 6158 | 36 | 2009-08-14 | 1006 | 20 | 651 | 0 | 2023-03-13 20:38:18 |
6159 | 6159 | 36 | 2009-08-14 | 587 | 3 | 651 | 0 | 2023-03-13 20:38:18 |
6160 | 6160 | 36 | 2009-08-14 | 134 | 1 | 651 | 0 | 2023-03-13 20:38:18 |
6161 | 6161 | 36 | 2011-03-21 | 1455 | 9 | 651 | 0 | 2023-03-13 20:38:18 |
6162 | 6162 | 36 | 2011-03-21 | 1342 | 16 | 651 | 0 | 2023-03-13 20:38:18 |
6163 | 6163 | 36 | 2011-03-21 | 210 | 12 | 651 | 0 | 2023-03-13 20:38:18 |
6164 | 6164 | 36 | 2011-03-21 | 1006 | 20 | 651 | 0 | 2023-03-13 20:38:18 |
6165 | 6165 | 36 | 2011-03-21 | 587 | 3 | 651 | 0 | 2023-03-13 20:38:18 |
6166 | 6166 | 36 | 2011-03-21 | 134 | 3 | 651 | 0 | 2023-03-13 20:38:18 |
6167 | 6167 | 36 | 2011-06-03 | 1455 | 10 | 651 | 0 | 2023-03-13 20:38:18 |
6168 | 6168 | 36 | 2011-06-03 | 1342 | 16 | 651 | 0 | 2023-03-13 20:38:18 |
6169 | 6169 | 36 | 2011-06-03 | 210 | 11 | 651 | 0 | 2023-03-13 20:38:18 |
6170 | 6170 | 36 | 2011-06-03 | 1006 | 20 | 651 | 0 | 2023-03-13 20:38:18 |
6171 | 6171 | 36 | 2011-06-03 | 587 | 3 | 651 | 0 | 2023-03-13 20:38:18 |
6172 | 6172 | 36 | 2011-06-03 | 134 | 3 | 651 | 0 | 2023-03-13 20:38:18 |
128 | 128 | 39 | 1992-06-06 | 1218 | 16 | 262 | 0 | 2023-03-13 20:38:18 |
129 | 129 | 39 | 1992-06-06 | 19 | 14 | 262 | 0 | 2023-03-13 20:38:18 |
130 | 130 | 39 | 1992-06-06 | 1245 | 15 | 262 | 0 | 2023-03-13 20:38:18 |
131 | 131 | 39 | 1992-06-06 | 1123 | 14 | 262 | 0 | 2023-03-13 20:38:18 |
132 | 132 | 39 | 1992-06-06 | 1173 | 35 | 262 | 0 | 2023-03-13 20:38:18 |
133 | 133 | 39 | 1992-06-06 | 829 | 66 | 262 | 0 | 2023-03-13 20:38:18 |
134 | 134 | 39 | 1992-06-06 | 789 | 16 | 262 | 0 | 2023-03-13 20:38:18 |
135 | 135 | 39 | 1992-06-06 | 872 | 14 | 262 | 0 | 2023-03-13 20:38:18 |
136 | 136 | 39 | 1992-06-06 | 440 | 10 | 262 | 0 | 2023-03-13 20:38:18 |
6173 | 6173 | 39 | 1995-05-09 | 1218 | 16 | 835 | 0 | 2023-03-13 20:38:18 |
6174 | 6174 | 39 | 1995-05-09 | 19 | 14 | 835 | 0 | 2023-03-13 20:38:18 |
6175 | 6175 | 39 | 1995-05-09 | 1245 | 15 | 835 | 0 | 2023-03-13 20:38:18 |
6176 | 6176 | 39 | 1995-05-09 | 1123 | 14 | 835 | 0 | 2023-03-13 20:38:18 |
6177 | 6177 | 39 | 1995-05-09 | 1173 | 35 | 835 | 0 | 2023-03-13 20:38:18 |
6178 | 6178 | 39 | 1995-05-09 | 829 | 66 | 835 | 0 | 2023-03-13 20:38:18 |
6179 | 6179 | 39 | 1995-05-09 | 789 | 16 | 835 | 0 | 2023-03-13 20:38:18 |
6180 | 6180 | 39 | 1995-05-09 | 872 | 14 | 835 | 0 | 2023-03-13 20:38:18 |
6181 | 6181 | 39 | 1995-05-09 | 440 | 5 | 835 | 0 | 2023-03-13 20:38:18 |
6182 | 6182 | 39 | 1995-05-09 | 1567 | 5 | 835 | 0 | 2023-03-13 20:38:18 |
147 | 147 | 42 | 1977-06-15 | 118 | 19 | 0 | 2023-03-13 20:38:18 | |
148 | 148 | 42 | 1977-06-15 | 902 | 118 | 0 | 2023-03-13 20:38:18 | |
149 | 149 | 42 | 1977-06-15 | 135 | 166 | 0 | 2023-03-13 20:38:18 | |
150 | 150 | 42 | 1977-06-15 | 62 | 2 | 0 | 2023-03-13 20:38:18 | |
151 | 151 | 42 | 1977-06-15 | 1361 | 8 | 0 | 2023-03-13 20:38:18 | |
152 | 152 | 42 | 1977-06-15 | 1221 | 1 | 0 | 2023-03-13 20:38:18 | |
153 | 153 | 42 | 1977-06-15 | 645 | 16 | 0 | 2023-03-13 20:38:18 | |
154 | 154 | 42 | 1977-06-15 | 1377 | 1 | 0 | 2023-03-13 20:38:18 | |
155 | 155 | 42 | 1977-06-15 | 894 | 11 | 0 | 2023-03-13 20:38:18 | |
156 | 156 | 42 | 1977-06-15 | 1026 | 1 | 0 | 2023-03-13 20:38:18 | |
157 | 157 | 42 | 1977-06-15 | 1790 | 6 | 0 | 2023-03-13 20:38:18 | |
158 | 158 | 42 | 1977-06-15 | 757 | 1 | 0 | 2023-03-13 20:38:18 | |
159 | 159 | 43 | 1987-02-17 | 379 | 1 | 867 | 0 | 2023-03-13 20:38:18 |
160 | 160 | 43 | 1987-02-17 | 1393 | 51 | 867 | 0 | 2023-03-13 20:38:18 |
161 | 161 | 43 | 1987-02-17 | 318 | 12 | 867 | 0 | 2023-03-13 20:38:18 |
162 | 162 | 43 | 1987-02-17 | 651 | 14 | 867 | 0 | 2023-03-13 20:38:18 |
163 | 163 | 43 | 1987-02-17 | 433 | 4 | 867 | 0 | 2023-03-13 20:38:18 |
164 | 164 | 43 | 1987-02-17 | 280 | 81 | 867 | 0 | 2023-03-13 20:38:18 |
165 | 165 | 43 | 1987-02-17 | 30 | 3 | 867 | 0 | 2023-03-13 20:38:18 |
166 | 166 | 47 | 1981-06-11 | 2298 | 1 | 442 | 0 | 2023-03-13 20:38:18 |
167 | 167 | 47 | 1981-06-11 | 1323 | 2 | 442 | 0 | 2023-03-13 20:38:18 |
168 | 168 | 47 | 1981-06-11 | 280 | 78 | 442 | 0 | 2023-03-13 20:38:18 |
169 | 169 | 47 | 1981-06-11 | 30 | 4 | 442 | 0 | 2023-03-13 20:38:18 |
170 | 170 | 47 | 1981-06-11 | 433 | 1 | 442 | 0 | 2023-03-13 20:38:18 |
171 | 171 | 47 | 1981-06-11 | 318 | 15 | 442 | 0 | 2023-03-13 20:38:18 |
172 | 172 | 47 | 1981-06-11 | 1393 | 65 | 442 | 0 | 2023-03-13 20:38:18 |
6189 | 6189 | 49 | 1996-11-03 | 1601 | 10 | 102 | 0 | 2023-03-13 20:38:18 |
6190 | 6190 | 49 | 1996-11-03 | 713 | 19 | 102 | 0 | 2023-03-13 20:38:18 |
6191 | 6191 | 49 | 1996-11-03 | 1120 | 91 | 102 | 0 | 2023-03-13 20:38:18 |
6192 | 6192 | 49 | 1996-11-03 | 648 | 18 | 102 | 0 | 2023-03-13 20:38:18 |
6193 | 6193 | 49 | 1996-11-03 | 948 | 25 | 102 | 0 | 2023-03-13 20:38:18 |
6194 | 6194 | 49 | 1996-11-03 | 419 | 43 | 102 | 0 | 2023-03-13 20:38:18 |
6195 | 6195 | 49 | 1996-11-03 | 425 | 15 | 102 | 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 );