viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
1,353 rows where seats = 2
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 2019-11-10 6
- 2020-01-07 6
- 1969-10-28 5
- 1969-12-15 5
- 1970-08-07 5
- 1972-04-25 5
- 1973-07-17 5
- 1996-03-11 5
- 2002-07-30 5
- 2006-02-07 5
- 2015-11-08 5
- 2016-01-22 5
- 1925-10-29 4
- 1931-06-07 4
- 1932-04-11 4
- 1965-09-01 4
- 1971-04-28 4
- 1971-06-07 4
- 1972-01-04 4
- 1973-05-22 4
- 1981-11-08 4
- 1981-12-17 4
- 1988-02-15 4
- 1988-11-01 4
- 1988-12-22 4
- 1989-10-29 4
- 1989-12-05 4
- 1990-03-15 4
- 1990-06-11 4
- 1990-06-18 4
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
54 | 54 | 17 | 1987-06-14 | 335 | 2 | 737 | 0 | 2023-03-13 20:38:18 |
83 | 83 | 24 | 1995-03-19 | 1009 | 2 | 206 | 0 | 2023-03-13 20:38:18 |
150 | 150 | 42 | 1977-06-15 | 62 | 2 | 0 | 2023-03-13 20:38:18 | |
167 | 167 | 47 | 1981-06-11 | 1323 | 2 | 442 | 0 | 2023-03-13 20:38:18 |
184 | 184 | 51 | 1972-11-29 | 1452 | 2 | 291 | 0 | 2023-03-13 20:38:18 |
193 | 193 | 51 | 1972-11-29 | 625 | 2 | 291 | 0 | 2023-03-13 20:38:18 |
213 | 213 | 56 | 1984-07-14 | 1636 | 2 | 259 | 0 | 2023-03-13 20:38:18 |
227 | 227 | 59 | 2000-10-08 | 887 | 2 | 735 | 0 | 2023-03-13 20:38:18 |
228 | 228 | 59 | 2000-10-08 | 28 | 2 | 735 | 0 | 2023-03-13 20:38:18 |
232 | 232 | 59 | 2000-10-08 | 675 | 2 | 735 | 0 | 2023-03-13 20:38:18 |
255 | 255 | 62 | 1986-05-21 | 342 | 2 | 270 | 0 | 2023-03-13 20:38:18 |
316 | 316 | 74 | 2002-05-15 | 744 | 2 | 749 | 0 | 2023-03-13 20:38:18 |
322 | 322 | 74 | 2002-05-15 | 1251 | 2 | 749 | 0 | 2023-03-13 20:38:18 |
362 | 362 | 81 | 1981-05-26 | 212 | 2 | 563 | 0 | 2023-03-13 20:38:18 |
389 | 389 | 85 | 1982-10-28 | 637 | 2 | 406 | 0 | 2023-03-13 20:38:18 |
398 | 398 | 85 | 1982-10-28 | 1317 | 2 | 406 | 0 | 2023-03-13 20:38:18 |
403 | 403 | 88 | 1953-06-28 | 1172 | 2 | 766 | 0 | 2023-03-13 20:38:18 |
418 | 418 | 90 | 1991-10-06 | 1535 | 2 | 718 | 0 | 2023-03-13 20:38:18 |
449 | 449 | 98 | 1975-09-22 | 200 | 2 | 143 | 0 | 2023-03-13 20:38:18 |
451 | 451 | 99 | 1996-03-03 | 520 | 2 | 654 | 0 | 2023-03-13 20:38:18 |
453 | 453 | 99 | 1996-03-03 | 1317 | 2 | 654 | 0 | 2023-03-13 20:38:18 |
467 | 467 | 100 | 1981-09-14 | 647 | 2 | 81 | 0 | 2023-03-13 20:38:18 |
480 | 480 | 102 | 1951-10-25 | 332 | 2 | 88 | 0 | 2023-03-13 20:38:18 |
492 | 492 | 105 | 1995-10-22 | 569 | 2 | 773 | 0 | 2023-03-13 20:38:18 |
496 | 496 | 105 | 1995-10-22 | 602 | 2 | 773 | 0 | 2023-03-13 20:38:18 |
521 | 521 | 108 | 1963-10-27 | 602 | 2 | 623 | 0 | 2023-03-13 20:38:18 |
533 | 533 | 111 | 2008-04-13 | 1030 | 2 | 117 | 0 | 2023-03-13 20:38:18 |
566 | 566 | 116 | 1982-09-08 | 342 | 2 | 6 | 0 | 2023-03-13 20:38:18 |
570 | 570 | 116 | 1982-09-08 | 212 | 2 | 6 | 0 | 2023-03-13 20:38:18 |
601 | 601 | 125 | 1971-04-28 | 342 | 2 | 172 | 0 | 2023-03-13 20:38:18 |
602 | 602 | 125 | 1971-04-28 | 1452 | 2 | 172 | 0 | 2023-03-13 20:38:18 |
610 | 610 | 125 | 1971-04-28 | 87 | 2 | 172 | 0 | 2023-03-13 20:38:18 |
612 | 612 | 125 | 1971-04-28 | 625 | 2 | 172 | 0 | 2023-03-13 20:38:18 |
693 | 693 | 146 | 1994-03-27 | 671 | 2 | 801 | 0 | 2023-03-13 20:38:18 |
701 | 701 | 150 | 1965-05-23 | 2300 | 2 | 613 | 0 | 2023-03-13 20:38:18 |
751 | 751 | 164 | 2004-03-14 | 520 | 2 | 309 | 0 | 2023-03-13 20:38:18 |
833 | 833 | 182 | 1946-05-17 | 1251 | 2 | 767 | 0 | 2023-03-13 20:38:18 |
839 | 839 | 183 | 1984-06-17 | 151 | 2 | 27 | 0 | 2023-03-13 20:38:18 |
840 | 840 | 183 | 1984-06-17 | 310 | 2 | 27 | 0 | 2023-03-13 20:38:18 |
864 | 864 | 188 | 2005-09-25 | 900 | 2 | 322 | 0 | 2023-03-13 20:38:18 |
869 | 869 | 189 | 1945-06-11 | 1307 | 2 | 608 | 1 | 2023-03-13 20:38:18 |
876 | 876 | 190 | 2007-05-24 | 651 | 2 | 179 | 0 | 2023-03-13 20:38:18 |
887 | 887 | 191 | 1987-12-13 | 993 | 2 | 92 | 0 | 2023-03-13 20:38:18 |
942 | 942 | 206 | 2003-10-19 | 1167 | 2 | 198 | 0 | 2023-03-13 20:38:18 |
951 | 951 | 206 | 2003-10-19 | 1318 | 2 | 198 | 0 | 2023-03-13 20:38:18 |
958 | 958 | 207 | 1985-09-08 | 351 | 2 | 310 | 1 | 2023-03-13 20:38:18 |
963 | 963 | 208 | 2001-06-07 | 453 | 2 | 19 | 1 | 2023-03-13 20:38:18 |
972 | 972 | 210 | 2005-02-20 | 1535 | 2 | 755 | 0 | 2023-03-13 20:38:18 |
993 | 993 | 211 | 1991-10-27 | 1208 | 2 | 75 | 0 | 2023-03-13 20:38:18 |
1000 | 1000 | 213 | 1953-04-21 | 1634 | 2 | 359 | 1 | 2023-03-13 20:38:18 |
1010 | 1010 | 214 | 2004-10-24 | 28 | 2 | 1634 | 0 | 2023-03-13 20:38:18 |
1019 | 1019 | 216 | 1995-10-01 | 1535 | 2 | 282 | 0 | 2023-03-13 20:38:18 |
1125 | 1125 | 243 | 1979-05-03 | 453 | 2 | 590 | 0 | 2023-03-13 20:38:18 |
1127 | 1127 | 243 | 1979-05-03 | 1284 | 2 | 590 | 0 | 2023-03-13 20:38:18 |
1132 | 1132 | 243 | 1979-05-03 | 311 | 2 | 590 | 0 | 2023-03-13 20:38:18 |
1174 | 1174 | 252 | 1993-06-06 | 1317 | 2 | 37 | 0 | 2023-03-13 20:38:18 |
1190 | 1190 | 254 | 1986-06-22 | 1026 | 2 | 238 | 0 | 2023-03-13 20:38:18 |
1199 | 1199 | 257 | 1990-04-08 | 1183 | 2 | 0 | 2023-03-13 20:38:18 | |
1282 | 1282 | 281 | 1980-10-05 | 1281 | 2 | 328 | 1 | 2023-03-13 20:38:18 |
1289 | 1289 | 282 | 1965-11-08 | 1189 | 2 | 857 | 0 | 2023-03-13 20:38:18 |
1296 | 1296 | 283 | 1973-02-28 | 30 | 2 | 863 | 0 | 2023-03-13 20:38:18 |
1300 | 1300 | 284 | 1990-04-08 | 1059 | 2 | 716 | 0 | 2023-03-13 20:38:18 |
1311 | 1311 | 285 | 2009-09-14 | 647 | 2 | 693 | 0 | 2023-03-13 20:38:18 |
1323 | 1323 | 289 | 1989-10-29 | 370 | 2 | 834 | 0 | 2023-03-13 20:38:18 |
1331 | 1331 | 289 | 1989-10-29 | 443 | 2 | 834 | 0 | 2023-03-13 20:38:18 |
1334 | 1334 | 289 | 1989-10-29 | 1026 | 2 | 834 | 0 | 2023-03-13 20:38:18 |
1335 | 1335 | 289 | 1989-10-29 | 845 | 2 | 834 | 0 | 2023-03-13 20:38:18 |
1336 | 1336 | 290 | 1983-06-09 | 311 | 2 | 646 | 1 | 2023-03-13 20:38:18 |
1343 | 1343 | 290 | 1983-06-09 | 1284 | 2 | 646 | 1 | 2023-03-13 20:38:18 |
1383 | 1383 | 297 | 1939-07-01 | 2293 | 2 | 1199 | 0 | 2023-03-13 20:38:18 |
1404 | 1404 | 307 | 1982-11-24 | 433 | 2 | 54 | 0 | 2023-03-13 20:38:18 |
1416 | 1416 | 310 | 2007-10-21 | 602 | 2 | 855 | 0 | 2023-03-13 20:38:18 |
1420 | 1420 | 311 | 1970-06-18 | 349 | 2 | 733 | 0 | 2023-03-13 20:38:18 |
1445 | 1445 | 315 | 1997-05-01 | 689 | 2 | 678 | 0 | 2023-03-13 20:38:18 |
1452 | 1452 | 315 | 1997-05-01 | 319 | 2 | 678 | 0 | 2023-03-13 20:38:18 |
1460 | 1460 | 316 | 1997-06-06 | 1573 | 2 | 573 | 0 | 2023-03-13 20:38:18 |
1486 | 1486 | 323 | 1965-04-07 | 30 | 2 | 667 | 0 | 2023-03-13 20:38:18 |
1508 | 1508 | 328 | 2001-09-10 | 647 | 2 | 333 | 0 | 2023-03-13 20:38:18 |
1509 | 1509 | 330 | 1996-05-26 | 1523 | 2 | 911 | 1 | 2023-03-13 20:38:18 |
1518 | 1518 | 332 | 1995-05-21 | 171 | 2 | 624 | 0 | 2023-03-13 20:38:18 |
1531 | 1531 | 333 | 1972-12-10 | 1055 | 2 | 656 | 0 | 2023-03-13 20:38:18 |
1535 | 1535 | 335 | 2003-01-22 | 1251 | 2 | 1105 | 0 | 2023-03-13 20:38:18 |
1579 | 1579 | 345 | 1960-11-20 | 905 | 2 | 241 | 0 | 2023-03-13 20:38:18 |
1600 | 1600 | 352 | 1999-10-10 | 557 | 2 | 265 | 0 | 2023-03-13 20:38:18 |
1601 | 1601 | 352 | 1999-10-10 | 1535 | 2 | 265 | 0 | 2023-03-13 20:38:18 |
1609 | 1609 | 354 | 1962-02-05 | 1108 | 2 | 598 | 0 | 2023-03-13 20:38:18 |
1620 | 1620 | 357 | 1973-03-11 | 516 | 2 | 430 | 0 | 2023-03-13 20:38:18 |
1631 | 1631 | 358 | 1987-10-18 | 1602 | 2 | 129 | 0 | 2023-03-13 20:38:18 |
1672 | 1672 | 371 | 1975-10-26 | 628 | 2 | 79 | 0 | 2023-03-13 20:38:18 |
1679 | 1679 | 372 | 1998-05-06 | 625 | 2 | 637 | 0 | 2023-03-13 20:38:18 |
1826 | 1826 | 403 | 2002-06-16 | 1101 | 2 | 711 | 0 | 2023-03-13 20:38:18 |
1848 | 1848 | 407 | 1962-11-25 | 516 | 2 | 526 | 0 | 2023-03-13 20:38:18 |
1883 | 1883 | 413 | 1961-10-04 | 923 | 2 | 364 | 0 | 2023-03-13 20:38:18 |
1888 | 1888 | 413 | 1961-10-04 | 523 | 2 | 364 | 0 | 2023-03-13 20:38:18 |
1916 | 1916 | 420 | 1977-04-17 | 708 | 2 | 451 | 0 | 2023-03-13 20:38:18 |
1925 | 1925 | 420 | 1977-04-17 | 640 | 2 | 451 | 0 | 2023-03-13 20:38:18 |
1945 | 1945 | 427 | 1999-10-24 | 1167 | 2 | 38 | 0 | 2023-03-13 20:38:18 |
1949 | 1949 | 427 | 1999-10-24 | 1500 | 2 | 38 | 0 | 2023-03-13 20:38:18 |
1975 | 1975 | 430 | 1950-09-05 | 1634 | 2 | 408 | 0 | 2023-03-13 20:38:18 |
1984 | 1984 | 433 | 1979-10-07 | 86 | 2 | 227 | 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 );