viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1 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 |
---|---|---|---|---|---|---|---|---|
18003 | 18003 | 910 | 1935-06-07 | 773 | 470 | 1287 | 1 | 2023-03-13 20:38:18 |
18012 | 18012 | 910 | 1931-11-05 | 773 | 470 | 1289 | 1 | 2023-03-13 20:38:18 |
15013 | 15013 | 315 | 1997-05-02 | 1556 | 419 | 838 | 1 | 2023-03-13 20:38:18 |
962 | 962 | 208 | 2001-06-07 | 1556 | 412 | 19 | 1 | 2023-03-13 20:38:18 |
18026 | 18026 | 908 | 1924-11-06 | 773 | 412 | 1291 | 1 | 2023-03-13 20:38:18 |
1338 | 1338 | 290 | 1983-06-09 | 773 | 397 | 646 | 1 | 2023-03-13 20:38:18 |
10119 | 10119 | 609 | 1945-07-26 | 1556 | 393 | 99 | 1 | 2023-03-13 20:38:18 |
4436 | 4436 | 911 | 1935-11-14 | 773 | 387 | 1288 | 1 | 2023-03-13 20:38:18 |
17993 | 17993 | 911 | 1937-05-28 | 773 | 387 | 1286 | 1 | 2023-03-13 20:38:18 |
19158 | 19158 | 911 | 1940-05-10 | 773 | 387 | 1519 | 1 | 2023-03-13 20:38:18 |
19168 | 19168 | 911 | 1945-05-23 | 773 | 387 | 1520 | 1 | 2023-03-13 20:38:18 |
18045 | 18045 | 905 | 1922-10-24 | 773 | 382 | 1294 | 1 | 2023-03-13 20:38:18 |
18057 | 18057 | 905 | 1919-01-10 | 773 | 382 | 1295 | 1 | 2023-03-13 20:38:18 |
2184 | 2184 | 490 | 1987-06-11 | 773 | 376 | 297 | 1 | 2023-03-13 20:38:18 |
12903 | 12903 | 490 | 1990-11-28 | 773 | 376 | 515 | 1 | 2023-03-13 20:38:18 |
9762 | 9762 | 403 | 2005-05-31 | 658 | 365 | 46 | 1 | 2023-03-13 20:38:18 |
14736 | 14736 | 403 | 2004-03-30 | 658 | 365 | 802 | 1 | 2023-03-13 20:38:18 |
14777 | 14777 | 403 | 2007-05-18 | 658 | 365 | 807 | 1 | 2023-03-13 20:38:18 |
19947 | 19947 | 1086 | 2019-12-13 | 773 | 365 | 1606 | 1 | 2023-03-13 20:38:18 |
20496 | 20496 | 1086 | 2022-09-06 | 773 | 365 | 1676 | 1 | 2023-03-13 20:38:18 |
20568 | 20568 | 1086 | 2022-10-25 | 773 | 365 | 1683 | 1 | 2023-03-13 20:38:18 |
14273 | 14273 | 583 | 1966-04-05 | 1556 | 364 | 733 | 1 | 2023-03-13 20:38:18 |
16641 | 16641 | 808 | 2003-03-14 | 901 | 363 | 1077 | 1 | 2023-03-13 20:38:18 |
16644 | 16644 | 808 | 2002-11-16 | 901 | 363 | 1078 | 1 | 2023-03-13 20:38:18 |
14892 | 14892 | 403 | 2002-06-17 | 658 | 356 | 820 | 1 | 2023-03-13 20:38:18 |
10264 | 10264 | 233 | 2007-06-27 | 1556 | 355 | 119 | 1 | 2023-03-13 20:38:18 |
12914 | 12914 | 233 | 2005-05-06 | 1556 | 355 | 516 | 1 | 2023-03-13 20:38:18 |
9869 | 9869 | 161 | 1963-10-18 | 773 | 345 | 63 | 1 | 2023-03-13 20:38:18 |
11071 | 11071 | 161 | 1959-10-14 | 773 | 345 | 237 | 1 | 2023-03-13 20:38:18 |
18038 | 18038 | 906 | 1923-05-25 | 773 | 344 | 1293 | 1 | 2023-03-13 20:38:18 |
16634 | 16634 | 807 | 2007-08-29 | 901 | 341 | 1076 | 1 | 2023-03-13 20:38:18 |
11314 | 11314 | 243 | 1979-05-04 | 773 | 339 | 273 | 1 | 2023-03-13 20:38:18 |
2342 | 2342 | 514 | 1992-04-09 | 773 | 336 | 678 | 1 | 2023-03-13 20:38:18 |
17309 | 17309 | 856 | 2015-05-08 | 773 | 331 | 1162 | 1 | 2023-03-13 20:38:18 |
18941 | 18941 | 856 | 2016-07-13 | 773 | 331 | 1489 | 1 | 2023-03-13 20:38:18 |
10946 | 10946 | 311 | 1970-06-19 | 773 | 330 | 216 | 1 | 2023-03-13 20:38:18 |
16629 | 16629 | 806 | 2011-07-06 | 901 | 327 | 1075 | 1 | 2023-03-13 20:38:18 |
17147 | 17147 | 806 | 2014-08-28 | 901 | 327 | 1143 | 1 | 2023-03-13 20:38:18 |
3150 | 3150 | 678 | 1955-05-26 | 773 | 324 | 184 | 1 | 2023-03-13 20:38:18 |
12141 | 12141 | 678 | 1957-01-10 | 773 | 324 | 404 | 1 | 2023-03-13 20:38:18 |
15291 | 15291 | 171 | 2010-11-14 | 658 | 320 | 883 | 1 | 2023-03-13 20:38:18 |
16301 | 16301 | 171 | 2012-05-15 | 658 | 320 | 1037 | 1 | 2023-03-13 20:38:18 |
141 | 141 | 40 | 1974-10-10 | 1556 | 319 | 7 | 1 | 2023-03-13 20:38:18 |
13408 | 13408 | 40 | 1976-04-05 | 1556 | 319 | 590 | 1 | 2023-03-13 20:38:18 |
15169 | 15169 | 445 | 1991-01-18 | 1727 | 319 | 862 | 1 | 2023-03-13 20:38:18 |
19074 | 19074 | 1013 | 2017-06-11 | 773 | 318 | 1507 | 1 | 2023-03-13 20:38:18 |
19901 | 19901 | 1013 | 2019-07-24 | 773 | 318 | 1599 | 1 | 2023-03-13 20:38:18 |
14469 | 14469 | 223 | 1964-10-16 | 1556 | 317 | 760 | 1 | 2023-03-13 20:38:18 |
17501 | 17501 | 997 | 2015-11-30 | 901 | 317 | 1195 | 1 | 2023-03-13 20:38:18 |
18934 | 18934 | 997 | 2016-05-24 | 901 | 317 | 1487 | 1 | 2023-03-13 20:38:18 |
10043 | 10043 | 625 | 1950-02-28 | 1556 | 315 | 88 | 1 | 2023-03-13 20:38:18 |
11549 | 11549 | 171 | 2007-06-18 | 658 | 313 | 306 | 1 | 2023-03-13 20:38:18 |
5885 | 5885 | 327 | 2009-09-16 | 439 | 312 | 374 | 1 | 2023-03-13 20:38:18 |
12757 | 12757 | 327 | 2010-06-04 | 439 | 311 | 493 | 1 | 2023-03-13 20:38:18 |
15891 | 15891 | 327 | 2011-08-30 | 439 | 311 | 969 | 1 | 2023-03-13 20:38:18 |
16602 | 16602 | 800 | 2013-12-17 | 1727 | 311 | 1071 | 1 | 2023-03-13 20:38:18 |
19090 | 19090 | 1014 | 2017-06-21 | 2643 | 308 | 1509 | 1 | 2023-03-13 20:38:18 |
20207 | 20207 | 1014 | 2020-07-03 | 2643 | 308 | 1640 | 1 | 2023-03-13 20:38:18 |
20473 | 20473 | 1014 | 2022-05-20 | 2643 | 308 | 1673 | 1 | 2023-03-13 20:38:18 |
15230 | 15230 | 582 | 2010-05-11 | 773 | 307 | 874 | 1 | 2023-03-13 20:38:18 |
12048 | 12048 | 554 | 2007-08-27 | 1193 | 306 | 390 | 1 | 2023-03-13 20:38:18 |
10290 | 10290 | 467 | 1950-01-21 | 1633 | 305 | 123 | 1 | 2023-03-13 20:38:18 |
10382 | 10382 | 554 | 2007-09-26 | 1193 | 305 | 134 | 1 | 2023-03-13 20:38:18 |
13467 | 13467 | 467 | 1951-07-26 | 1633 | 305 | 597 | 1 | 2023-03-13 20:38:18 |
13948 | 13948 | 467 | 1948-05-23 | 1633 | 305 | 676 | 1 | 2023-03-13 20:38:18 |
5892 | 5892 | 554 | 2008-09-24 | 1193 | 304 | 494 | 1 | 2023-03-13 20:38:18 |
14026 | 14026 | 102 | 1951-10-26 | 773 | 302 | 691 | 1 | 2023-03-13 20:38:18 |
14240 | 14240 | 102 | 1955-04-06 | 773 | 302 | 729 | 1 | 2023-03-13 20:38:18 |
12253 | 12253 | 568 | 1974-03-04 | 1556 | 301 | 419 | 1 | 2023-03-13 20:38:18 |
9786 | 9786 | 345 | 1960-12-08 | 1193 | 300 | 48 | 1 | 2023-03-13 20:38:18 |
10169 | 10169 | 506 | 1989-08-10 | 1193 | 300 | 106 | 1 | 2023-03-13 20:38:18 |
10468 | 10468 | 506 | 1986-07-22 | 1193 | 300 | 146 | 1 | 2023-03-13 20:38:18 |
11399 | 11399 | 506 | 1987-11-06 | 1193 | 300 | 283 | 1 | 2023-03-13 20:38:18 |
14351 | 14351 | 506 | 1989-06-03 | 1193 | 300 | 743 | 1 | 2023-03-13 20:38:18 |
10175 | 10175 | 679 | 1998-10-27 | 558 | 298 | 107 | 1 | 2023-03-13 20:38:18 |
11099 | 11099 | 645 | 1960-07-19 | 1193 | 298 | 241 | 1 | 2023-03-13 20:38:18 |
14470 | 14470 | 223 | 1964-10-16 | 773 | 298 | 760 | 1 | 2023-03-13 20:38:18 |
14614 | 14614 | 645 | 1958-06-12 | 1193 | 298 | 780 | 1 | 2023-03-13 20:38:18 |
9151 | 9151 | 789 | 2013-11-18 | 382 | 297 | 1068 | 1 | 2023-03-13 20:38:18 |
12255 | 12255 | 568 | 1974-03-04 | 773 | 297 | 419 | 1 | 2023-03-13 20:38:18 |
15309 | 15309 | 692 | 1957-02-25 | 1193 | 297 | 887 | 1 | 2023-03-13 20:38:18 |
15377 | 15377 | 692 | 1955-11-22 | 1193 | 297 | 900 | 1 | 2023-03-13 20:38:18 |
15382 | 15382 | 692 | 1956-12-20 | 1193 | 297 | 901 | 1 | 2023-03-13 20:38:18 |
16398 | 16398 | 789 | 2013-04-27 | 382 | 297 | 1048 | 1 | 2023-03-13 20:38:18 |
16656 | 16656 | 789 | 2014-02-22 | 382 | 297 | 1079 | 1 | 2023-03-13 20:38:18 |
19047 | 19047 | 789 | 2016-12-12 | 382 | 297 | 1501 | 1 | 2023-03-13 20:38:18 |
15107 | 15107 | 554 | 2005-10-31 | 1193 | 296 | 850 | 1 | 2023-03-13 20:38:18 |
14021 | 14021 | 102 | 1951-10-26 | 1556 | 295 | 691 | 1 | 2023-03-13 20:38:18 |
14235 | 14235 | 102 | 1955-04-06 | 1556 | 295 | 729 | 1 | 2023-03-13 20:38:18 |
20169 | 20169 | 1032 | 2018-07-09 | 901 | 295 | 1635 | 1 | 2023-03-13 20:38:18 |
9508 | 9508 | 640 | 1964-11-09 | 1193 | 294 | 8 | 1 | 2023-03-13 20:38:18 |
13777 | 13777 | 640 | 1963-12-09 | 1193 | 294 | 649 | 1 | 2023-03-13 20:38:18 |
14606 | 14606 | 595 | 1994-11-17 | 1727 | 294 | 778 | 1 | 2023-03-13 20:38:18 |
16361 | 16361 | 788 | 2012-12-26 | 1193 | 294 | 1044 | 1 | 2023-03-13 20:38:18 |
10196 | 10196 | 386 | 1969-06-22 | 1094 | 293 | 111 | 1 | 2023-03-13 20:38:18 |
10353 | 10353 | 386 | 1968-07-12 | 1094 | 293 | 131 | 1 | 2023-03-13 20:38:18 |
12328 | 12328 | 386 | 1972-07-06 | 1094 | 293 | 430 | 1 | 2023-03-13 20:38:18 |
5924 | 5924 | 554 | 2006-09-26 | 1193 | 292 | 679 | 1 | 2023-03-13 20:38:18 |
16697 | 16697 | 812 | 1987-12-21 | 1334 | 292 | 1088 | 1 | 2023-03-13 20:38:18 |
16700 | 16700 | 812 | 1990-11-09 | 1334 | 292 | 1089 | 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 );