viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by seats descending
This data as json, CSV (advanced)
Suggested facets: date (date), calculation_date (date)
Link | rowid | election_id | date | party_id | seats ▲ | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
4427 | 4427 | 910 | 1931-10-27 | 773 | 470 | 1290 | 0 | 2023-03-13 20:38:18 |
1451 | 1451 | 315 | 1997-05-01 | 1556 | 419 | 678 | 0 | 2023-03-13 20:38:18 |
4415 | 4415 | 908 | 1924-10-29 | 773 | 412 | 1292 | 0 | 2023-03-13 20:38:18 |
2814 | 2814 | 609 | 1945-07-05 | 1556 | 393 | 1520 | 0 | 2023-03-13 20:38:18 |
9326 | 9326 | 905 | 1918-12-14 | 773 | 382 | 0 | 2023-03-13 20:38:18 | |
5536 | 5536 | 1086 | 2019-12-12 | 773 | 365 | 1599 | 0 | 2023-03-13 20:38:18 |
6114 | 6114 | 403 | 2002-06-25 | 658 | 365 | 820 | 0 | 2023-03-13 20:38:18 |
2677 | 2677 | 583 | 1966-03-31 | 1556 | 364 | 760 | 0 | 2023-03-13 20:38:18 |
4002 | 4002 | 808 | 2002-11-03 | 901 | 363 | 1101 | 0 | 2023-03-13 20:38:18 |
1827 | 1827 | 403 | 2002-06-16 | 658 | 356 | 711 | 0 | 2023-03-13 20:38:18 |
1076 | 1076 | 233 | 2005-05-05 | 1556 | 355 | 19 | 0 | 2023-03-13 20:38:18 |
734 | 734 | 161 | 1959-10-08 | 773 | 345 | 404 | 0 | 2023-03-13 20:38:18 |
4403 | 4403 | 906 | 1922-11-15 | 773 | 344 | 1294 | 0 | 2023-03-13 20:38:18 |
3995 | 3995 | 807 | 2007-07-22 | 901 | 341 | 1077 | 0 | 2023-03-13 20:38:18 |
1126 | 1126 | 243 | 1979-05-03 | 773 | 339 | 590 | 0 | 2023-03-13 20:38:18 |
4146 | 4146 | 856 | 2015-05-07 | 773 | 331 | 874 | 0 | 2023-03-13 20:38:18 |
1425 | 1425 | 311 | 1970-06-18 | 773 | 330 | 733 | 0 | 2023-03-13 20:38:18 |
3990 | 3990 | 806 | 2011-06-12 | 901 | 327 | 1076 | 0 | 2023-03-13 20:38:18 |
6119 | 6119 | 171 | 2007-06-26 | 658 | 320 | 306 | 0 | 2023-03-13 20:38:18 |
6817 | 6817 | 445 | 1990-12-02 | 1727 | 319 | 286 | 0 | 2023-03-13 20:38:18 |
5100 | 5100 | 1013 | 2017-06-08 | 773 | 318 | 1489 | 0 | 2023-03-13 20:38:18 |
1045 | 1045 | 223 | 1964-10-15 | 1556 | 317 | 63 | 0 | 2023-03-13 20:38:18 |
4960 | 4960 | 997 | 2015-11-01 | 901 | 317 | 1173 | 0 | 2023-03-13 20:38:18 |
2877 | 2877 | 625 | 1950-02-23 | 1556 | 315 | 99 | 0 | 2023-03-13 20:38:18 |
774 | 774 | 171 | 2007-06-17 | 658 | 313 | 807 | 0 | 2023-03-13 20:38:18 |
6671 | 6671 | 327 | 2009-10-26 | 439 | 311 | 374 | 0 | 2023-03-13 20:38:18 |
6679 | 6679 | 327 | 2010-04-10 | 439 | 311 | 374 | 0 | 2023-03-13 20:38:18 |
9186 | 9186 | 800 | 2013-10-22 | 1727 | 311 | 472 | 0 | 2023-03-13 20:38:18 |
1494 | 1494 | 327 | 2009-08-30 | 439 | 308 | 494 | 0 | 2023-03-13 20:38:18 |
5109 | 5109 | 1014 | 2017-06-18 | 2643 | 308 | 1508 | 0 | 2023-03-13 20:38:18 |
2667 | 2667 | 582 | 2010-05-06 | 773 | 307 | 119 | 0 | 2023-03-13 20:38:18 |
5909 | 5909 | 554 | 2007-08-07 | 1193 | 306 | 679 | 0 | 2023-03-13 20:38:18 |
2100 | 2100 | 467 | 1948-04-18 | 1633 | 305 | 501 | 0 | 2023-03-13 20:38:18 |
5916 | 5916 | 554 | 2007-01-25 | 1193 | 305 | 679 | 0 | 2023-03-13 20:38:18 |
7019 | 7019 | 554 | 2007-09-10 | 1193 | 305 | 390 | 0 | 2023-03-13 20:38:18 |
481 | 481 | 102 | 1951-10-25 | 773 | 302 | 88 | 0 | 2023-03-13 20:38:18 |
6688 | 6688 | 327 | 2012-01-04 | 439 | 302 | 969 | 0 | 2023-03-13 20:38:18 |
2592 | 2592 | 568 | 1974-02-28 | 1556 | 301 | 216 | 0 | 2023-03-13 20:38:18 |
1578 | 1578 | 345 | 1960-11-20 | 1193 | 300 | 241 | 0 | 2023-03-13 20:38:18 |
2293 | 2293 | 506 | 1986-07-06 | 1193 | 300 | 568 | 0 | 2023-03-13 20:38:18 |
1046 | 1046 | 223 | 1964-10-15 | 773 | 298 | 63 | 0 | 2023-03-13 20:38:18 |
3011 | 3011 | 645 | 1958-05-22 | 1193 | 298 | 887 | 0 | 2023-03-13 20:38:18 |
7311 | 7311 | 679 | 1998-09-27 | 558 | 298 | 778 | 0 | 2023-03-13 20:38:18 |
2594 | 2594 | 568 | 1974-02-28 | 773 | 297 | 216 | 0 | 2023-03-13 20:38:18 |
3893 | 3893 | 789 | 2013-02-25 | 382 | 297 | 983 | 0 | 2023-03-13 20:38:18 |
7341 | 7341 | 692 | 1955-11-15 | 1193 | 297 | 899 | 0 | 2023-03-13 20:38:18 |
2536 | 2536 | 554 | 2005-09-11 | 1193 | 296 | 770 | 0 | 2023-03-13 20:38:18 |
476 | 476 | 102 | 1951-10-25 | 1556 | 295 | 88 | 0 | 2023-03-13 20:38:18 |
5249 | 5249 | 1032 | 2018-06-24 | 901 | 295 | 1487 | 0 | 2023-03-13 20:38:18 |
2984 | 2984 | 640 | 1963-11-21 | 1193 | 294 | 48 | 0 | 2023-03-13 20:38:18 |
3873 | 3873 | 788 | 2012-12-16 | 1193 | 294 | 969 | 0 | 2023-03-13 20:38:18 |
5932 | 5932 | 554 | 2006-01-20 | 1193 | 294 | 850 | 0 | 2023-03-13 20:38:18 |
7138 | 7138 | 595 | 1994-10-16 | 1727 | 294 | 862 | 0 | 2023-03-13 20:38:18 |
9130 | 9130 | 788 | 2012-12-27 | 1193 | 294 | 1044 | 0 | 2023-03-13 20:38:18 |
6068 | 6068 | 386 | 1968-07-11 | 1094 | 293 | 662 | 0 | 2023-03-13 20:38:18 |
4021 | 4021 | 812 | 1987-10-29 | 1334 | 292 | 1087 | 0 | 2023-03-13 20:38:18 |
6126 | 6126 | 782 | 2012-06-26 | 1539 | 292 | 1038 | 0 | 2023-03-13 20:38:18 |
9204 | 9204 | 812 | 1990-06-07 | 1334 | 292 | 1088 | 0 | 2023-03-13 20:38:18 |
4099 | 4099 | 850 | 2014-12-14 | 1193 | 290 | 1044 | 0 | 2023-03-13 20:38:18 |
1423 | 1423 | 311 | 1970-06-18 | 1556 | 288 | 733 | 0 | 2023-03-13 20:38:18 |
2765 | 2765 | 603 | 1969-12-27 | 1193 | 288 | 787 | 0 | 2023-03-13 20:38:18 |
5366 | 5366 | 1040 | 1933-03-05 | 2695 | 288 | 1578 | 0 | 2023-03-13 20:38:18 |
4423 | 4423 | 909 | 1929-05-30 | 1556 | 287 | 1291 | 0 | 2023-03-13 20:38:18 |
6086 | 6086 | 20 | 1981-07-02 | 1539 | 285 | 116 | 0 | 2023-03-13 20:38:18 |
549 | 549 | 113 | 1980-06-22 | 1193 | 284 | 727 | 0 | 2023-03-13 20:38:18 |
1741 | 1741 | 386 | 1968-06-30 | 1094 | 282 | 662 | 0 | 2023-03-13 20:38:18 |
2878 | 2878 | 625 | 1950-02-23 | 773 | 282 | 99 | 0 | 2023-03-13 20:38:18 |
5168 | 5168 | 1022 | 2017-10-22 | 1193 | 281 | 1156 | 0 | 2023-03-13 20:38:18 |
1656 | 1656 | 367 | 1967-01-29 | 1193 | 280 | 8 | 0 | 2023-03-13 20:38:18 |
3816 | 3816 | 782 | 2012-06-17 | 1539 | 280 | 1037 | 0 | 2023-03-13 20:38:18 |
6718 | 6718 | 331 | 1960-09-20 | 1727 | 279 | 906 | 0 | 2023-03-13 20:38:18 |
5955 | 5955 | 25 | 1992-07-26 | 1193 | 278 | 253 | 0 | 2023-03-13 20:38:18 |
538 | 538 | 111 | 2008-04-13 | 596 | 276 | 117 | 0 | 2023-03-13 20:38:18 |
93 | 93 | 25 | 1990-02-18 | 1193 | 275 | 106 | 0 | 2023-03-13 20:38:18 |
6097 | 6097 | 643 | 1988-07-16 | 1539 | 275 | 712 | 0 | 2023-03-13 20:38:18 |
2300 | 2300 | 507 | 1958-05-25 | 1633 | 273 | 280 | 0 | 2023-03-13 20:38:18 |
1530 | 1530 | 333 | 1972-12-10 | 1193 | 271 | 656 | 0 | 2023-03-13 20:38:18 |
6709 | 6709 | 331 | 1957-09-15 | 1727 | 270 | 633 | 0 | 2023-03-13 20:38:18 |
1130 | 1130 | 243 | 1979-05-03 | 1556 | 269 | 590 | 0 | 2023-03-13 20:38:18 |
62 | 62 | 20 | 1981-06-21 | 1539 | 268 | 1148 | 0 | 2023-03-13 20:38:18 |
276 | 276 | 65 | 1972-05-07 | 1633 | 266 | 398 | 0 | 2023-03-13 20:38:18 |
1227 | 1227 | 261 | 1968-05-19 | 1633 | 266 | 433 | 0 | 2023-03-13 20:38:18 |
5814 | 5814 | 628 | 1999-07-06 | 1193 | 266 | 916 | 0 | 2023-03-13 20:38:18 |
6570 | 6570 | 261 | 1969-07-06 | 1633 | 266 | 554 | 0 | 2023-03-13 20:38:18 |
5804 | 5804 | 628 | 1999-01-11 | 1193 | 265 | 915 | 0 | 2023-03-13 20:38:18 |
6697 | 6697 | 327 | 2012-07-02 | 439 | 265 | 969 | 0 | 2023-03-13 20:38:18 |
3229 | 3229 | 695 | 1949-01-23 | 1726 | 264 | 894 | 0 | 2023-03-13 20:38:18 |
2945 | 2945 | 633 | 1990-05-20 | 419 | 263 | 1604 | 0 | 2023-03-13 20:38:18 |
2991 | 2991 | 642 | 1953-06-07 | 1633 | 263 | 597 | 0 | 2023-03-13 20:38:18 |
2276 | 2276 | 502 | 1976-06-20 | 1633 | 262 | 842 | 0 | 2023-03-13 20:38:18 |
2773 | 2773 | 604 | 1979-06-03 | 1633 | 262 | 638 | 0 | 2023-03-13 20:38:18 |
5101 | 5101 | 1013 | 2017-06-08 | 1556 | 262 | 1489 | 0 | 2023-03-13 20:38:18 |
1710 | 1710 | 380 | 1963-04-28 | 1633 | 260 | 347 | 0 | 2023-03-13 20:38:18 |
3004 | 3004 | 643 | 1988-06-12 | 1539 | 260 | 1150 | 0 | 2023-03-13 20:38:18 |
4422 | 4422 | 909 | 1929-05-30 | 773 | 260 | 1291 | 0 | 2023-03-13 20:38:18 |
6011 | 6011 | 628 | 1998-01-12 | 1193 | 259 | 371 | 0 | 2023-03-13 20:38:18 |
738 | 738 | 161 | 1959-10-08 | 1556 | 258 | 404 | 0 | 2023-03-13 20:38:18 |
2671 | 2671 | 582 | 2010-05-06 | 1556 | 258 | 119 | 0 | 2023-03-13 20:38:18 |
4410 | 4410 | 907 | 1923-12-06 | 773 | 258 | 1293 | 0 | 2023-03-13 20:38:18 |
4807 | 4807 | 975 | 2015-06-07 | 901 | 258 | 1143 | 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 );