viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by seats
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 |
---|---|---|---|---|---|---|---|---|
6139 | 6139 | 1033 | 1921-02-20 | 2703 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
6140 | 6140 | 1033 | 1921-02-20 | 2704 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
6142 | 6142 | 1033 | 1921-02-20 | 2289 | 0 | 1560 | 0 | 2023-03-13 20:38:18 |
7 | 7 | 2 | 1999-06-13 | 171 | 1 | 95 | 0 | 2023-03-13 20:38:18 |
33 | 33 | 15 | 1999-03-21 | 200 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
37 | 37 | 15 | 1999-03-21 | 66 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
40 | 40 | 15 | 1999-03-21 | 638 | 1 | 100 | 0 | 2023-03-13 20:38:18 |
42 | 42 | 17 | 1987-06-14 | 1560 | 1 | 737 | 0 | 2023-03-13 20:38:18 |
43 | 43 | 17 | 1987-06-14 | 974 | 1 | 737 | 0 | 2023-03-13 20:38:18 |
56 | 56 | 19 | 1946-02-17 | 1181 | 1 | 204 | 0 | 2023-03-13 20:38:18 |
69 | 69 | 21 | 1951-10-28 | 602 | 1 | 556 | 0 | 2023-03-13 20:38:18 |
79 | 79 | 24 | 1995-03-19 | 66 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
81 | 81 | 24 | 1995-03-19 | 200 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
84 | 84 | 24 | 1995-03-19 | 1105 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
92 | 92 | 25 | 1990-02-18 | 2297 | 1 | 106 | 0 | 2023-03-13 20:38:18 |
100 | 100 | 30 | 1955-10-30 | 602 | 1 | 814 | 0 | 2023-03-13 20:38:18 |
152 | 152 | 42 | 1977-06-15 | 1221 | 1 | 0 | 2023-03-13 20:38:18 | |
154 | 154 | 42 | 1977-06-15 | 1377 | 1 | 0 | 2023-03-13 20:38:18 | |
156 | 156 | 42 | 1977-06-15 | 1026 | 1 | 0 | 2023-03-13 20:38:18 | |
158 | 158 | 42 | 1977-06-15 | 757 | 1 | 0 | 2023-03-13 20:38:18 | |
159 | 159 | 43 | 1987-02-17 | 379 | 1 | 867 | 0 | 2023-03-13 20:38:18 |
166 | 166 | 47 | 1981-06-11 | 2298 | 1 | 442 | 0 | 2023-03-13 20:38:18 |
170 | 170 | 47 | 1981-06-11 | 433 | 1 | 442 | 0 | 2023-03-13 20:38:18 |
197 | 197 | 51 | 1972-11-29 | 2288 | 1 | 291 | 0 | 2023-03-13 20:38:18 |
225 | 225 | 59 | 2000-10-08 | 652 | 1 | 735 | 0 | 2023-03-13 20:38:18 |
226 | 226 | 59 | 2000-10-08 | 493 | 1 | 735 | 0 | 2023-03-13 20:38:18 |
229 | 229 | 59 | 2000-10-08 | 1562 | 1 | 735 | 0 | 2023-03-13 20:38:18 |
234 | 234 | 59 | 2000-10-08 | 383 | 1 | 735 | 0 | 2023-03-13 20:38:18 |
241 | 241 | 59 | 2000-10-08 | 709 | 1 | 735 | 0 | 2023-03-13 20:38:18 |
250 | 250 | 62 | 1986-05-21 | 212 | 1 | 270 | 0 | 2023-03-13 20:38:18 |
251 | 251 | 62 | 1986-05-21 | 1452 | 1 | 270 | 0 | 2023-03-13 20:38:18 |
257 | 257 | 62 | 1986-05-21 | 625 | 1 | 270 | 0 | 2023-03-13 20:38:18 |
274 | 274 | 64 | 1973-12-04 | 812 | 1 | 320 | 0 | 2023-03-13 20:38:18 |
275 | 275 | 64 | 1973-12-04 | 538 | 1 | 320 | 0 | 2023-03-13 20:38:18 |
277 | 277 | 65 | 1972-05-07 | 974 | 1 | 398 | 0 | 2023-03-13 20:38:18 |
301 | 301 | 71 | 1954-03-08 | 66 | 1 | 738 | 0 | 2023-03-13 20:38:18 |
311 | 311 | 73 | 1960-11-15 | 812 | 1 | 467 | 0 | 2023-03-13 20:38:18 |
335 | 335 | 77 | 1970-03-16 | 66 | 1 | 203 | 0 | 2023-03-13 20:38:18 |
342 | 342 | 77 | 1970-03-16 | 1463 | 1 | 203 | 0 | 2023-03-13 20:38:18 |
355 | 355 | 80 | 2004-10-03 | 65 | 1 | 292 | 0 | 2023-03-13 20:38:18 |
357 | 357 | 80 | 2004-10-03 | 199 | 1 | 292 | 0 | 2023-03-13 20:38:18 |
366 | 366 | 81 | 1981-05-26 | 625 | 1 | 563 | 0 | 2023-03-13 20:38:18 |
388 | 388 | 84 | 1979-03-19 | 66 | 1 | 492 | 0 | 2023-03-13 20:38:18 |
391 | 391 | 85 | 1982-10-28 | 757 | 1 | 406 | 0 | 2023-03-13 20:38:18 |
396 | 396 | 85 | 1982-10-28 | 1026 | 1 | 406 | 0 | 2023-03-13 20:38:18 |
408 | 408 | 89 | 1994-09-21 | 1128 | 1 | 740 | 0 | 2023-03-13 20:38:18 |
413 | 413 | 89 | 1994-09-21 | 2575 | 1 | 740 | 0 | 2023-03-13 20:38:18 |
414 | 414 | 89 | 1994-09-21 | 2574 | 1 | 740 | 0 | 2023-03-13 20:38:18 |
415 | 415 | 89 | 1994-09-21 | 1892 | 1 | 740 | 0 | 2023-03-13 20:38:18 |
416 | 416 | 89 | 1994-09-21 | 2576 | 1 | 740 | 0 | 2023-03-13 20:38:18 |
421 | 421 | 90 | 1991-10-06 | 82 | 1 | 718 | 0 | 2023-03-13 20:38:18 |
427 | 427 | 91 | 1968-06-25 | 1189 | 1 | 565 | 0 | 2023-03-13 20:38:18 |
443 | 443 | 98 | 1975-09-22 | 1389 | 1 | 143 | 0 | 2023-03-13 20:38:18 |
444 | 444 | 98 | 1975-09-22 | 66 | 1 | 143 | 0 | 2023-03-13 20:38:18 |
445 | 445 | 98 | 1975-09-22 | 139 | 1 | 143 | 0 | 2023-03-13 20:38:18 |
455 | 455 | 99 | 1996-03-03 | 845 | 1 | 654 | 0 | 2023-03-13 20:38:18 |
457 | 457 | 99 | 1996-03-03 | 443 | 1 | 654 | 0 | 2023-03-13 20:38:18 |
459 | 459 | 99 | 1996-03-03 | 757 | 1 | 654 | 0 | 2023-03-13 20:38:18 |
474 | 474 | 101 | 1945-03-18 | 1565 | 1 | 120 | 0 | 2023-03-13 20:38:18 |
478 | 478 | 102 | 1951-10-25 | 2296 | 1 | 88 | 0 | 2023-03-13 20:38:18 |
488 | 488 | 105 | 1995-10-22 | 1500 | 1 | 773 | 0 | 2023-03-13 20:38:18 |
489 | 489 | 105 | 1995-10-22 | 1318 | 1 | 773 | 0 | 2023-03-13 20:38:18 |
493 | 493 | 105 | 1995-10-22 | 1012 | 1 | 773 | 0 | 2023-03-13 20:38:18 |
499 | 499 | 106 | 1985-10-06 | 1535 | 1 | 885 | 0 | 2023-03-13 20:38:18 |
510 | 510 | 107 | 2006-04-09 | 2302 | 1 | 567 | 0 | 2023-03-13 20:38:18 |
511 | 511 | 107 | 2006-04-09 | 1063 | 1 | 567 | 0 | 2023-03-13 20:38:18 |
515 | 515 | 107 | 2006-04-09 | 927 | 1 | 567 | 0 | 2023-03-13 20:38:18 |
534 | 534 | 111 | 2008-04-13 | 927 | 1 | 117 | 0 | 2023-03-13 20:38:18 |
535 | 535 | 111 | 2008-04-13 | 1063 | 1 | 117 | 0 | 2023-03-13 20:38:18 |
560 | 560 | 116 | 1982-09-08 | 275 | 1 | 6 | 0 | 2023-03-13 20:38:18 |
561 | 561 | 116 | 1982-09-08 | 625 | 1 | 6 | 0 | 2023-03-13 20:38:18 |
571 | 571 | 116 | 1982-09-08 | 2288 | 1 | 6 | 0 | 2023-03-13 20:38:18 |
580 | 580 | 119 | 1994-10-01 | 2246 | 1 | 817 | 0 | 2023-03-13 20:38:18 |
588 | 588 | 121 | 1945-10-30 | 1634 | 1 | 10 | 0 | 2023-03-13 20:38:18 |
606 | 606 | 125 | 1971-04-28 | 1595 | 1 | 172 | 0 | 2023-03-13 20:38:18 |
617 | 617 | 129 | 1990-04-12 | 65 | 1 | 0 | 2023-03-13 20:38:18 | |
620 | 620 | 129 | 1990-04-12 | 199 | 1 | 0 | 2023-03-13 20:38:18 | |
638 | 638 | 137 | 2006-01-23 | 1189 | 1 | 308 | 0 | 2023-03-13 20:38:18 |
655 | 655 | 142 | 1936-07-01 | 920 | 1 | 1201 | 0 | 2023-03-13 20:38:18 |
659 | 659 | 142 | 1936-07-01 | 2292 | 1 | 1201 | 0 | 2023-03-13 20:38:18 |
663 | 663 | 143 | 2003-05-18 | 171 | 1 | 193 | 0 | 2023-03-13 20:38:18 |
665 | 665 | 143 | 2003-05-18 | 501 | 1 | 193 | 0 | 2023-03-13 20:38:18 |
674 | 674 | 144 | 1945-10-21 | 2452 | 1 | 340 | 0 | 2023-03-13 20:38:18 |
684 | 684 | 146 | 1994-03-27 | 2302 | 1 | 801 | 0 | 2023-03-13 20:38:18 |
685 | 685 | 146 | 1994-03-27 | 436 | 1 | 801 | 0 | 2023-03-13 20:38:18 |
689 | 689 | 146 | 1994-03-27 | 974 | 1 | 801 | 0 | 2023-03-13 20:38:18 |
721 | 721 | 157 | 1990-12-12 | 2575 | 1 | 57 | 0 | 2023-03-13 20:38:18 |
722 | 722 | 157 | 1990-12-12 | 74 | 1 | 57 | 0 | 2023-03-13 20:38:18 |
723 | 723 | 157 | 1990-12-12 | 2574 | 1 | 57 | 0 | 2023-03-13 20:38:18 |
724 | 724 | 157 | 1990-12-12 | 1894 | 1 | 57 | 0 | 2023-03-13 20:38:18 |
733 | 733 | 159 | 1984-09-04 | 1189 | 1 | 670 | 0 | 2023-03-13 20:38:18 |
735 | 735 | 161 | 1959-10-08 | 453 | 1 | 404 | 0 | 2023-03-13 20:38:18 |
745 | 745 | 164 | 2004-03-14 | 845 | 1 | 309 | 0 | 2023-03-13 20:38:18 |
749 | 749 | 164 | 2004-03-14 | 1367 | 1 | 309 | 0 | 2023-03-13 20:38:18 |
754 | 754 | 164 | 2004-03-14 | 385 | 1 | 309 | 0 | 2023-03-13 20:38:18 |
778 | 778 | 171 | 2007-06-17 | 2077 | 1 | 807 | 0 | 2023-03-13 20:38:18 |
779 | 779 | 171 | 2007-06-17 | 947 | 1 | 807 | 0 | 2023-03-13 20:38:18 |
780 | 780 | 171 | 2007-06-17 | 1101 | 1 | 807 | 0 | 2023-03-13 20:38:18 |
785 | 785 | 172 | 2009-06-07 | 457 | 1 | 12 | 0 | 2023-03-13 20:38:18 |
797 | 797 | 174 | 2007-11-13 | 1892 | 1 | 316 | 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 );