viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
1,140 rows where seats = 3
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 1992-05-17 5
- 1999-03-29 5
- 2005-05-18 5
- 2006-01-26 5
- 1981-05-26 4
- 1981-09-11 4
- 1982-05-29 4
- 1987-06-11 4
- 1990-11-28 4
- 1990-12-25 4
- 1991-02-05 4
- 1992-01-21 4
- 1999-03-08 4
- 1999-03-25 4
- 2001-03-07 4
- 2001-03-26 4
- 2002-07-30 4
- 2002-11-06 4
- 2002-12-10 4
- 2005-01-12 4
- 2005-03-21 4
- 2005-11-23 4
- 2006-01-18 4
- 2006-02-01 4
- 2006-02-05 4
- 2012-12-03 4
- 2015-11-08 4
- 2016-01-22 4
- 2021-03-17 4
- 2022-01-10 4
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
53 | 53 | 17 | 1987-06-14 | 1030 | 3 | 737 | 0 | 2023-03-13 20:38:18 |
137 | 137 | 40 | 1974-10-10 | 646 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
142 | 142 | 40 | 1974-10-10 | 311 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
165 | 165 | 43 | 1987-02-17 | 30 | 3 | 867 | 0 | 2023-03-13 20:38:18 |
188 | 188 | 51 | 1972-11-29 | 1251 | 3 | 291 | 0 | 2023-03-13 20:38:18 |
190 | 190 | 51 | 1972-11-29 | 1595 | 3 | 291 | 0 | 2023-03-13 20:38:18 |
233 | 233 | 59 | 2000-10-08 | 58 | 3 | 735 | 0 | 2023-03-13 20:38:18 |
238 | 238 | 59 | 2000-10-08 | 1261 | 3 | 735 | 0 | 2023-03-13 20:38:18 |
239 | 239 | 59 | 2000-10-08 | 863 | 3 | 735 | 0 | 2023-03-13 20:38:18 |
256 | 256 | 62 | 1986-05-21 | 1251 | 3 | 270 | 0 | 2023-03-13 20:38:18 |
281 | 281 | 65 | 1972-05-07 | 1030 | 3 | 398 | 0 | 2023-03-13 20:38:18 |
297 | 297 | 70 | 1981-05-24 | 945 | 3 | 914 | 1 | 2023-03-13 20:38:18 |
360 | 360 | 81 | 1981-05-26 | 1194 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
361 | 361 | 81 | 1981-05-26 | 1452 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
363 | 363 | 81 | 1981-05-26 | 342 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
365 | 365 | 81 | 1981-05-26 | 1251 | 3 | 563 | 0 | 2023-03-13 20:38:18 |
370 | 370 | 82 | 1995-04-08 | 147 | 3 | 640 | 0 | 2023-03-13 20:38:18 |
483 | 483 | 105 | 1995-10-22 | 1167 | 3 | 773 | 0 | 2023-03-13 20:38:18 |
486 | 486 | 105 | 1995-10-22 | 1264 | 3 | 773 | 0 | 2023-03-13 20:38:18 |
487 | 487 | 105 | 1995-10-22 | 628 | 3 | 773 | 0 | 2023-03-13 20:38:18 |
501 | 501 | 106 | 1985-10-06 | 1281 | 3 | 885 | 0 | 2023-03-13 20:38:18 |
553 | 553 | 113 | 1980-06-22 | 86 | 3 | 727 | 0 | 2023-03-13 20:38:18 |
559 | 559 | 114 | 1983-04-23 | 147 | 3 | 752 | 0 | 2023-03-13 20:38:18 |
562 | 562 | 116 | 1982-09-08 | 1194 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
564 | 564 | 116 | 1982-09-08 | 1452 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
567 | 567 | 116 | 1982-09-08 | 1251 | 3 | 6 | 0 | 2023-03-13 20:38:18 |
591 | 591 | 121 | 1945-10-30 | 1606 | 3 | 10 | 0 | 2023-03-13 20:38:18 |
605 | 605 | 125 | 1971-04-28 | 1251 | 3 | 172 | 0 | 2023-03-13 20:38:18 |
625 | 625 | 129 | 1990-04-12 | 875 | 3 | 0 | 2023-03-13 20:38:18 | |
648 | 648 | 138 | 1983-12-18 | 86 | 3 | 242 | 0 | 2023-03-13 20:38:18 |
680 | 680 | 146 | 1994-03-27 | 1030 | 3 | 801 | 0 | 2023-03-13 20:38:18 |
698 | 698 | 150 | 1965-05-23 | 969 | 3 | 613 | 0 | 2023-03-13 20:38:18 |
703 | 703 | 153 | 1954-05-30 | 151 | 3 | 532 | 0 | 2023-03-13 20:38:18 |
746 | 746 | 164 | 2004-03-14 | 234 | 3 | 309 | 0 | 2023-03-13 20:38:18 |
768 | 768 | 169 | 1956-05-13 | 769 | 3 | 659 | 0 | 2023-03-13 20:38:18 |
771 | 771 | 171 | 2007-06-17 | 509 | 3 | 807 | 0 | 2023-03-13 20:38:18 |
812 | 812 | 176 | 1971-10-31 | 602 | 3 | 777 | 0 | 2023-03-13 20:38:18 |
886 | 886 | 191 | 1987-12-13 | 161 | 3 | 92 | 0 | 2023-03-13 20:38:18 |
892 | 892 | 191 | 1987-12-13 | 969 | 3 | 92 | 0 | 2023-03-13 20:38:18 |
935 | 935 | 204 | 1967-02-15 | 1251 | 3 | 455 | 0 | 2023-03-13 20:38:18 |
953 | 953 | 206 | 2003-10-19 | 602 | 3 | 198 | 0 | 2023-03-13 20:38:18 |
967 | 967 | 208 | 2001-06-07 | 1023 | 3 | 19 | 1 | 2023-03-13 20:38:18 |
985 | 985 | 211 | 1991-10-27 | 181 | 3 | 75 | 0 | 2023-03-13 20:38:18 |
991 | 991 | 211 | 1991-10-27 | 1549 | 3 | 75 | 0 | 2023-03-13 20:38:18 |
1070 | 1070 | 228 | 1982-02-18 | 433 | 3 | 335 | 0 | 2023-03-13 20:38:18 |
1071 | 1071 | 233 | 2005-05-05 | 311 | 3 | 19 | 0 | 2023-03-13 20:38:18 |
1073 | 1073 | 233 | 2005-05-05 | 453 | 3 | 19 | 0 | 2023-03-13 20:38:18 |
1078 | 1078 | 233 | 2005-05-05 | 1023 | 3 | 19 | 0 | 2023-03-13 20:38:18 |
1128 | 1128 | 243 | 1979-05-03 | 319 | 3 | 590 | 0 | 2023-03-13 20:38:18 |
1158 | 1158 | 248 | 1979-12-02 | 1281 | 3 | 384 | 0 | 2023-03-13 20:38:18 |
1178 | 1178 | 253 | 2003-03-16 | 200 | 3 | 663 | 0 | 2023-03-13 20:38:18 |
1226 | 1226 | 261 | 1968-05-19 | 1030 | 3 | 433 | 0 | 2023-03-13 20:38:18 |
1252 | 1252 | 268 | 1993-09-19 | 900 | 3 | 730 | 0 | 2023-03-13 20:38:18 |
1264 | 1264 | 272 | 1953-12-14 | 1274 | 3 | 1473 | 1 | 2023-03-13 20:38:18 |
1341 | 1341 | 290 | 1983-06-09 | 319 | 3 | 646 | 1 | 2023-03-13 20:38:18 |
1348 | 1348 | 291 | 1967-03-12 | 516 | 3 | 349 | 0 | 2023-03-13 20:38:18 |
1401 | 1401 | 307 | 1982-11-24 | 30 | 3 | 54 | 0 | 2023-03-13 20:38:18 |
1417 | 1417 | 310 | 2007-10-21 | 308 | 3 | 855 | 0 | 2023-03-13 20:38:18 |
1429 | 1429 | 312 | 1956-01-02 | 1328 | 3 | 397 | 0 | 2023-03-13 20:38:18 |
1448 | 1448 | 315 | 1997-05-01 | 1023 | 3 | 678 | 0 | 2023-03-13 20:38:18 |
1498 | 1498 | 327 | 2009-08-30 | 4 | 3 | 494 | 0 | 2023-03-13 20:38:18 |
1534 | 1534 | 335 | 2003-01-22 | 1206 | 3 | 1105 | 0 | 2023-03-13 20:38:18 |
1574 | 1574 | 345 | 1960-11-20 | 1540 | 3 | 241 | 0 | 2023-03-13 20:38:18 |
1627 | 1627 | 358 | 1987-10-18 | 602 | 3 | 129 | 0 | 2023-03-13 20:38:18 |
1635 | 1635 | 358 | 1987-10-18 | 964 | 3 | 129 | 0 | 2023-03-13 20:38:18 |
1638 | 1638 | 358 | 1987-10-18 | 628 | 3 | 129 | 0 | 2023-03-13 20:38:18 |
1662 | 1662 | 371 | 1975-10-26 | 602 | 3 | 79 | 0 | 2023-03-13 20:38:18 |
1675 | 1675 | 372 | 1998-05-06 | 212 | 3 | 637 | 0 | 2023-03-13 20:38:18 |
1681 | 1681 | 372 | 1998-05-06 | 1251 | 3 | 637 | 0 | 2023-03-13 20:38:18 |
1682 | 1682 | 373 | 1967-10-29 | 886 | 3 | 513 | 0 | 2023-03-13 20:38:18 |
1684 | 1684 | 373 | 1967-10-29 | 602 | 3 | 513 | 0 | 2023-03-13 20:38:18 |
1708 | 1708 | 380 | 1963-04-28 | 1030 | 3 | 347 | 0 | 2023-03-13 20:38:18 |
1732 | 1732 | 384 | 1974-03-10 | 640 | 3 | 859 | 0 | 2023-03-13 20:38:18 |
1773 | 1773 | 390 | 1959-02-01 | 151 | 3 | 544 | 0 | 2023-03-13 20:38:18 |
1795 | 1795 | 396 | 1985-10-13 | 969 | 3 | 724 | 0 | 2023-03-13 20:38:18 |
1825 | 1825 | 403 | 2002-06-16 | 873 | 3 | 711 | 0 | 2023-03-13 20:38:18 |
1829 | 1829 | 403 | 2002-06-16 | 177 | 3 | 711 | 0 | 2023-03-13 20:38:18 |
1901 | 1901 | 418 | 1991-11-24 | 969 | 3 | 570 | 1 | 2023-03-13 20:38:18 |
1903 | 1903 | 418 | 1991-11-24 | 748 | 3 | 570 | 1 | 2023-03-13 20:38:18 |
1948 | 1948 | 427 | 1999-10-24 | 602 | 3 | 38 | 0 | 2023-03-13 20:38:18 |
1996 | 1996 | 435 | 1979-10-21 | 1167 | 3 | 20 | 0 | 2023-03-13 20:38:18 |
2002 | 2002 | 435 | 1979-10-21 | 602 | 3 | 20 | 0 | 2023-03-13 20:38:18 |
2012 | 2012 | 437 | 1956-06-13 | 1251 | 3 | 366 | 0 | 2023-03-13 20:38:18 |
2075 | 2075 | 464 | 1975-01-09 | 1324 | 3 | 744 | 0 | 2023-03-13 20:38:18 |
2102 | 2102 | 467 | 1948-04-18 | 1030 | 3 | 501 | 0 | 2023-03-13 20:38:18 |
2103 | 2103 | 469 | 1957-03-05 | 923 | 3 | 626 | 0 | 2023-03-13 20:38:18 |
2180 | 2180 | 490 | 1987-06-11 | 319 | 3 | 297 | 1 | 2023-03-13 20:38:18 |
2185 | 2185 | 490 | 1987-06-11 | 1284 | 3 | 297 | 1 | 2023-03-13 20:38:18 |
2188 | 2188 | 490 | 1987-06-11 | 311 | 3 | 297 | 1 | 2023-03-13 20:38:18 |
2189 | 2189 | 490 | 1987-06-11 | 1023 | 3 | 297 | 1 | 2023-03-13 20:38:18 |
2197 | 2197 | 493 | 1979-03-01 | 1317 | 3 | 205 | 0 | 2023-03-13 20:38:18 |
2224 | 2224 | 498 | 2001-05-13 | 1287 | 3 | 239 | 0 | 2023-03-13 20:38:18 |
2230 | 2230 | 498 | 2001-05-13 | 1030 | 3 | 239 | 0 | 2023-03-13 20:38:18 |
2236 | 2236 | 498 | 2001-05-13 | 2302 | 3 | 239 | 0 | 2023-03-13 20:38:18 |
2250 | 2250 | 500 | 2008-03-09 | 757 | 3 | 806 | 0 | 2023-03-13 20:38:18 |
2258 | 2258 | 501 | 1981-11-08 | 1440 | 3 | 429 | 0 | 2023-03-13 20:38:18 |
2277 | 2277 | 502 | 1976-06-20 | 1030 | 3 | 842 | 0 | 2023-03-13 20:38:18 |
2290 | 2290 | 503 | 1946-06-02 | 2302 | 3 | 0 | 2023-03-13 20:38:18 | |
2308 | 2308 | 507 | 1958-05-25 | 1030 | 3 | 280 | 0 | 2023-03-13 20:38:18 |
2341 | 2341 | 514 | 1992-04-09 | 1284 | 3 | 678 | 1 | 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 );