viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows
This data as json, CSV (advanced)
Suggested facets: cabinet_formation
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
calculation_date (date) 1 ✖
- 2023-03-13 20,841
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 );