viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0
This data as json, CSV (advanced)
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
179 | 179 | 50 | 2006-06-03 | 789 | 74 | 15 | 0 | 2023-03-13 20:38:18 |
180 | 180 | 50 | 2006-06-03 | 1245 | 13 | 15 | 0 | 2023-03-13 20:38:18 |
181 | 181 | 50 | 2006-06-03 | 829 | 81 | 15 | 0 | 2023-03-13 20:38:18 |
182 | 182 | 50 | 2006-06-03 | 1173 | 26 | 15 | 0 | 2023-03-13 20:38:18 |
183 | 183 | 50 | 2006-06-03 | 196 | 6 | 15 | 0 | 2023-03-13 20:38:18 |
184 | 184 | 51 | 1972-11-29 | 1452 | 2 | 291 | 0 | 2023-03-13 20:38:18 |
185 | 185 | 51 | 1972-11-29 | 342 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
186 | 186 | 51 | 1972-11-29 | 1194 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
187 | 187 | 51 | 1972-11-29 | 742 | 43 | 291 | 0 | 2023-03-13 20:38:18 |
188 | 188 | 51 | 1972-11-29 | 1251 | 3 | 291 | 0 | 2023-03-13 20:38:18 |
189 | 189 | 51 | 1972-11-29 | 300 | 14 | 291 | 0 | 2023-03-13 20:38:18 |
190 | 190 | 51 | 1972-11-29 | 1595 | 3 | 291 | 0 | 2023-03-13 20:38:18 |
191 | 191 | 51 | 1972-11-29 | 1409 | 22 | 291 | 0 | 2023-03-13 20:38:18 |
192 | 192 | 51 | 1972-11-29 | 405 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
193 | 193 | 51 | 1972-11-29 | 625 | 2 | 291 | 0 | 2023-03-13 20:38:18 |
194 | 194 | 51 | 1972-11-29 | 402 | 6 | 291 | 0 | 2023-03-13 20:38:18 |
195 | 195 | 51 | 1972-11-29 | 345 | 6 | 291 | 0 | 2023-03-13 20:38:18 |
196 | 196 | 51 | 1972-11-29 | 451 | 27 | 291 | 0 | 2023-03-13 20:38:18 |
197 | 197 | 51 | 1972-11-29 | 2288 | 1 | 291 | 0 | 2023-03-13 20:38:18 |
198 | 198 | 52 | 2006-10-07 | 1520 | 6 | 535 | 0 | 2023-03-13 20:38:18 |
199 | 199 | 52 | 2006-10-07 | 1518 | 18 | 535 | 0 | 2023-03-13 20:38:18 |
200 | 200 | 52 | 2006-10-07 | 521 | 8 | 535 | 0 | 2023-03-13 20:38:18 |
201 | 201 | 52 | 2006-10-07 | 1100 | 17 | 535 | 0 | 2023-03-13 20:38:18 |
202 | 202 | 52 | 2006-10-07 | 466 | 18 | 535 | 0 | 2023-03-13 20:38:18 |
203 | 203 | 52 | 2006-10-07 | 662 | 10 | 535 | 0 | 2023-03-13 20:38:18 |
204 | 204 | 52 | 2006-10-07 | 811 | 23 | 535 | 0 | 2023-03-13 20:38:18 |
205 | 205 | 53 | 1976-12-05 | 837 | 55 | 59 | 0 | 2023-03-13 20:38:18 |
206 | 206 | 53 | 1976-12-05 | 1193 | 249 | 59 | 0 | 2023-03-13 20:38:18 |
207 | 207 | 53 | 1976-12-05 | 1540 | 17 | 59 | 0 | 2023-03-13 20:38:18 |
208 | 208 | 53 | 1976-12-05 | 170 | 17 | 59 | 0 | 2023-03-13 20:38:18 |
209 | 209 | 53 | 1976-12-05 | 940 | 123 | 59 | 0 | 2023-03-13 20:38:18 |
210 | 210 | 53 | 1976-12-05 | 905 | 21 | 59 | 0 | 2023-03-13 20:38:18 |
211 | 211 | 53 | 1976-12-05 | 1053 | 29 | 59 | 0 | 2023-03-13 20:38:18 |
212 | 212 | 56 | 1984-07-14 | 878 | 56 | 259 | 0 | 2023-03-13 20:38:18 |
213 | 213 | 56 | 1984-07-14 | 1636 | 2 | 259 | 0 | 2023-03-13 20:38:18 |
214 | 214 | 56 | 1984-07-14 | 997 | 37 | 259 | 0 | 2023-03-13 20:38:18 |
215 | 215 | 57 | 1993-07-18 | 1540 | 15 | 253 | 0 | 2023-03-13 20:38:18 |
216 | 216 | 57 | 1993-07-18 | 1146 | 13 | 253 | 0 | 2023-03-13 20:38:18 |
217 | 217 | 57 | 1993-07-18 | 940 | 70 | 253 | 0 | 2023-03-13 20:38:18 |
218 | 218 | 57 | 1993-07-18 | 1327 | 35 | 253 | 0 | 2023-03-13 20:38:18 |
219 | 219 | 57 | 1993-07-18 | 1053 | 15 | 253 | 0 | 2023-03-13 20:38:18 |
220 | 220 | 57 | 1993-07-18 | 86 | 4 | 253 | 0 | 2023-03-13 20:38:18 |
221 | 221 | 57 | 1993-07-18 | 837 | 51 | 253 | 0 | 2023-03-13 20:38:18 |
222 | 222 | 57 | 1993-07-18 | 547 | 55 | 253 | 0 | 2023-03-13 20:38:18 |
223 | 223 | 57 | 1993-07-18 | 1193 | 223 | 253 | 0 | 2023-03-13 20:38:18 |
224 | 224 | 57 | 1993-07-18 | 905 | 30 | 253 | 0 | 2023-03-13 20:38:18 |
225 | 225 | 59 | 2000-10-08 | 652 | 1 | 735 | 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 );