viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by election_id
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
These facets timed out: date
seats 310 ✖
- 1 2,371
- 2 1,353
- 3 1,140
- 4 1,024
- 5 832
- 6 692
- 8 541
- 9 525
- 7 493
- 10 482
- 12 374
- 11 371
- 14 354
- 15 348
- 17 326
- 13 321
- 16 319
- 20 291
- 18 283
- 19 266
- 0 246
- 26 230
- 22 229
- 21 228
- 23 223
- 25 171
- 27 165
- 30 165
- 24 161
- 29 159
- 31 150
- 33 146
- 28 138
- 32 121
- 42 121
- 35 119
- 39 116
- 45 116
- 34 113
- 38 113
- 40 112
- 44 112
- 41 111
- 37 109
- 47 107
- 43 106
- 52 100
- 48 94
- 62 91
- 53 90
- 49 89
- 55 86
- 36 83
- 51 83
- 50 81
- 73 80
- 56 79
- 54 77
- 46 73
- 76 68
- 74 67
- 66 65
- 57 63
- 67 58
- 69 58
- 72 57
- 70 55
- 61 54
- 75 53
- 59 48
- 60 48
- 68 48
- 65 46
- 58 43
- 64 40
- 71 39
- 80 36
- 107 36
- 86 34
- 77 33
- 93 32
- 103 32
- 81 31
- 104 31
- 85 30
- 115 30
- 78 28
- 99 28
- 105 28
- 112 28
- 131 26
- 91 25
- 109 25
- 129 25
- 82 24
- 92 24
- 95 24
- 117 24
- 84 22
- 137 22
- 141 21
- 177 21
- 63 20
- 79 20
- 83 20
- 88 20
- 100 20
- 106 20
- 120 20
- 123 20
- 166 20
- 90 19
- 143 18
- 145 18
- 154 18
- 96 17
- 108 17
- 150 17
- 113 16
- 132 16
- 157 16
- 201 16
- 266 16
- 110 15
- 124 15
- 125 15
- 158 15
- 134 14
- 148 14
- 169 14
- 178 14
- 184 14
- 262 14
- 121 13
- 149 13
- 155 13
- 160 13
- 167 13
- 173 13
- 239 13
- 87 12
- 94 12
- 97 12
- 116 12
- 140 12
- 156 12
- 171 12
- 199 12
- 222 12
- 227 12
- 292 12
- 102 11
- 111 11
- 118 11
- 135 11
- 136 11
- 146 11
- 151 11
- 164 11
- 263 11
- 297 11
- 182 10
- 198 10
- 204 10
- 209 10
- 243 10
- 250 10
- 128 9
- 153 9
- 161 9
- 162 9
- 206 9
- 207 9
- 242 9
- 258 9
- 260 9
- 294 9
- 89 8
- 133 8
- 138 8
- 144 8
- 190 8
- 365 8
- 98 7
- 114 7
- 127 7
- 130 7
- 165 7
- 183 7
- 225 7
- 245 7
- 298 7
- 300 7
- 305 7
- 119 6
- 147 6
- 170 6
- 175 6
- 179 6
- 186 6
- 194 6
- 230 6
- 248 6
- 273 6
- 275 6
- 288 6
- 311 6
- 152 5
- 193 5
- 202 5
- 215 5
- 223 5
- 226 5
- 234 5
- 235 5
- 295 5
- 308 5
- 317 5
- 101 4
- 126 4
- 139 4
- 159 4
- 197 4
- 203 4
- 211 4
- 217 4
- 220 4
- 228 4
- 232 4
- 233 4
- 252 4
- 271 4
- 277 4
- 280 4
- 281 4
- 293 4
- 302 4
- 319 4
- 387 4
- 142 3
- 168 3
- 185 3
- 191 3
- 196 3
- 200 3
- 218 3
- 224 3
- 229 3
- 241 3
- 244 3
- 246 3
- 249 3
- 251 3
- 257 3
- 265 3
- 270 3
- 282 3
- 284 3
- 285 3
- 318 3
- 320 3
- 327 3
- 331 3
- 345 3
- 355 3
- 363 3
- 382 3
- 412 3
- 470 3
- 172 2
- 212 2
- 214 2
- 237 2
- 240 2
- 247 2
- 264 2
- 268 2
- 269 2
- 276 2
- 287 2
- 290 2
- 296 2
- 301 2
- 306 2
- 307 2
- 313 2
- 315 2
- 324 2
- 330 2
- 339 2
- 341 2
- 344 2
- 356 2
- 364 2
- 376 2
- 393 2
- 419 2
- 163 1
- 181 1
- 208 1
- 238 1
- 255 1
- 259 1
- 267 1
- 278 1
- 279 1
- 304 1
- 312 1
- 336 1
- 397 1
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 );