viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows 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 |
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 |
1451 | 1451 | 315 | 1997-05-01 | 1556 | 419 | 678 | 0 | 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 |
4415 | 4415 | 908 | 1924-10-29 | 773 | 412 | 1292 | 0 | 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 |
2814 | 2814 | 609 | 1945-07-05 | 1556 | 393 | 1520 | 0 | 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 |
9326 | 9326 | 905 | 1918-12-14 | 773 | 382 | 0 | 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 |
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 |
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 |
2677 | 2677 | 583 | 1966-03-31 | 1556 | 364 | 760 | 0 | 2023-03-13 20:38:18 |
14273 | 14273 | 583 | 1966-04-05 | 1556 | 364 | 733 | 1 | 2023-03-13 20:38:18 |
4002 | 4002 | 808 | 2002-11-03 | 901 | 363 | 1101 | 0 | 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 |
1827 | 1827 | 403 | 2002-06-16 | 658 | 356 | 711 | 0 | 2023-03-13 20:38:18 |
14892 | 14892 | 403 | 2002-06-17 | 658 | 356 | 820 | 1 | 2023-03-13 20:38:18 |
1076 | 1076 | 233 | 2005-05-05 | 1556 | 355 | 19 | 0 | 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 |
734 | 734 | 161 | 1959-10-08 | 773 | 345 | 404 | 0 | 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 |
4403 | 4403 | 906 | 1922-11-15 | 773 | 344 | 1294 | 0 | 2023-03-13 20:38:18 |
18038 | 18038 | 906 | 1923-05-25 | 773 | 344 | 1293 | 1 | 2023-03-13 20:38:18 |
3995 | 3995 | 807 | 2007-07-22 | 901 | 341 | 1077 | 0 | 2023-03-13 20:38:18 |
16634 | 16634 | 807 | 2007-08-29 | 901 | 341 | 1076 | 1 | 2023-03-13 20:38:18 |
1126 | 1126 | 243 | 1979-05-03 | 773 | 339 | 590 | 0 | 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 |
4146 | 4146 | 856 | 2015-05-07 | 773 | 331 | 874 | 0 | 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 |
1425 | 1425 | 311 | 1970-06-18 | 773 | 330 | 733 | 0 | 2023-03-13 20:38:18 |
10946 | 10946 | 311 | 1970-06-19 | 773 | 330 | 216 | 1 | 2023-03-13 20:38:18 |
3990 | 3990 | 806 | 2011-06-12 | 901 | 327 | 1076 | 0 | 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 |
6119 | 6119 | 171 | 2007-06-26 | 658 | 320 | 306 | 0 | 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 |
6817 | 6817 | 445 | 1990-12-02 | 1727 | 319 | 286 | 0 | 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 |
5100 | 5100 | 1013 | 2017-06-08 | 773 | 318 | 1489 | 0 | 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 |
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 |
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 |
2877 | 2877 | 625 | 1950-02-23 | 1556 | 315 | 99 | 0 | 2023-03-13 20:38:18 |
10043 | 10043 | 625 | 1950-02-28 | 1556 | 315 | 88 | 1 | 2023-03-13 20:38:18 |
774 | 774 | 171 | 2007-06-17 | 658 | 313 | 807 | 0 | 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 |
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 |
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 |
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 |
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 |
2667 | 2667 | 582 | 2010-05-06 | 773 | 307 | 119 | 0 | 2023-03-13 20:38:18 |
15230 | 15230 | 582 | 2010-05-11 | 773 | 307 | 874 | 1 | 2023-03-13 20:38:18 |
5909 | 5909 | 554 | 2007-08-07 | 1193 | 306 | 679 | 0 | 2023-03-13 20:38:18 |
12048 | 12048 | 554 | 2007-08-27 | 1193 | 306 | 390 | 1 | 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 |
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 |
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 );