viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
493 rows where seats = 7
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 2021-03-23 4
- 2021-06-13 4
- 2022-07-01 4
- 1972-11-29 3
- 1973-05-11 3
- 1999-03-25 3
- 2008-09-24 3
- 2020-03-02 3
- 2020-05-17 3
- 1935-10-14 2
- 1935-10-23 2
- 1947-10-26 2
- 1947-12-11 2
- 1954-11-01 2
- 1955-06-29 2
- 1967-02-15 2
- 1967-04-05 2
- 1968-04-26 2
- 1970-05-14 2
- 1974-02-28 2
- 1974-03-04 2
- 1977-02-15 2
- 1978-08-30 2
- 1978-09-14 2
- 1979-05-15 2
- 1979-07-17 2
- 1981-06-15 2
- 1995-04-13 2
- 1995-10-22 2
- 1995-12-13 2
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
78 | 78 | 24 | 1995-03-19 | 1463 | 7 | 206 | 0 | 2023-03-13 20:38:18 |
185 | 185 | 51 | 1972-11-29 | 342 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
186 | 186 | 51 | 1972-11-29 | 1194 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
192 | 192 | 51 | 1972-11-29 | 405 | 7 | 291 | 0 | 2023-03-13 20:38:18 |
242 | 242 | 60 | 1948-02-04 | 923 | 7 | 151 | 0 | 2023-03-13 20:38:18 |
270 | 270 | 64 | 1973-12-04 | 1331 | 7 | 320 | 0 | 2023-03-13 20:38:18 |
313 | 313 | 74 | 2002-05-15 | 345 | 7 | 749 | 0 | 2023-03-13 20:38:18 |
349 | 349 | 80 | 2004-10-03 | 16 | 7 | 292 | 0 | 2023-03-13 20:38:18 |
368 | 368 | 82 | 1995-04-08 | 228 | 7 | 640 | 0 | 2023-03-13 20:38:18 |
385 | 385 | 84 | 1979-03-19 | 200 | 7 | 492 | 0 | 2023-03-13 20:38:18 |
399 | 399 | 88 | 1953-06-28 | 1319 | 7 | 766 | 0 | 2023-03-13 20:38:18 |
490 | 490 | 105 | 1995-10-22 | 458 | 7 | 773 | 0 | 2023-03-13 20:38:18 |
491 | 491 | 105 | 1995-10-22 | 1602 | 7 | 773 | 0 | 2023-03-13 20:38:18 |
581 | 581 | 119 | 1994-10-01 | 2247 | 7 | 817 | 0 | 2023-03-13 20:38:18 |
656 | 656 | 142 | 1936-07-01 | 1219 | 7 | 1201 | 0 | 2023-03-13 20:38:18 |
713 | 713 | 157 | 1990-12-12 | 211 | 7 | 57 | 0 | 2023-03-13 20:38:18 |
752 | 752 | 164 | 2004-03-14 | 1361 | 7 | 309 | 0 | 2023-03-13 20:38:18 |
773 | 773 | 171 | 2007-06-17 | 1492 | 7 | 807 | 0 | 2023-03-13 20:38:18 |
783 | 783 | 172 | 2009-06-07 | 310 | 7 | 12 | 0 | 2023-03-13 20:38:18 |
810 | 810 | 176 | 1971-10-31 | 564 | 7 | 777 | 0 | 2023-03-13 20:38:18 |
844 | 844 | 184 | 1968-03-31 | 969 | 7 | 353 | 0 | 2023-03-13 20:38:18 |
907 | 907 | 197 | 2006-10-01 | 1536 | 7 | 888 | 0 | 2023-03-13 20:38:18 |
930 | 930 | 204 | 1967-02-15 | 345 | 7 | 455 | 0 | 2023-03-13 20:38:18 |
934 | 934 | 204 | 1967-02-15 | 1595 | 7 | 455 | 0 | 2023-03-13 20:38:18 |
979 | 979 | 211 | 1991-10-27 | 900 | 7 | 75 | 0 | 2023-03-13 20:38:18 |
1003 | 1003 | 213 | 1953-04-21 | 1239 | 7 | 359 | 1 | 2023-03-13 20:38:18 |
1027 | 1027 | 217 | 1950-06-04 | 708 | 7 | 746 | 0 | 2023-03-13 20:38:18 |
1093 | 1093 | 237 | 2000-06-25 | 1382 | 7 | 211 | 0 | 2023-03-13 20:38:18 |
1102 | 1102 | 239 | 1999-03-07 | 486 | 7 | 303 | 0 | 2023-03-13 20:38:18 |
1105 | 1105 | 239 | 1999-03-07 | 417 | 7 | 303 | 0 | 2023-03-13 20:38:18 |
1137 | 1137 | 244 | 1951-05-06 | 1274 | 7 | 1472 | 1 | 2023-03-13 20:38:18 |
1140 | 1140 | 246 | 2010-08-21 | 184 | 7 | 736 | 0 | 2023-03-13 20:38:18 |
1182 | 1182 | 253 | 2003-03-16 | 1463 | 7 | 663 | 0 | 2023-03-13 20:38:18 |
1187 | 1187 | 254 | 1986-06-22 | 118 | 7 | 238 | 0 | 2023-03-13 20:38:18 |
1198 | 1198 | 257 | 1990-04-08 | 1617 | 7 | 0 | 2023-03-13 20:38:18 | |
1213 | 1213 | 259 | 1949-10-24 | 228 | 7 | 742 | 0 | 2023-03-13 20:38:18 |
1215 | 1215 | 260 | 2002-10-05 | 521 | 7 | 23 | 0 | 2023-03-13 20:38:18 |
1246 | 1246 | 265 | 2007-05-12 | 1455 | 7 | 246 | 0 | 2023-03-13 20:38:18 |
1352 | 1352 | 291 | 1967-03-12 | 1414 | 7 | 349 | 0 | 2023-03-13 20:38:18 |
1388 | 1388 | 299 | 1999-06-13 | 1582 | 7 | 621 | 0 | 2023-03-13 20:38:18 |
1440 | 1440 | 314 | 2007-03-18 | 1463 | 7 | 759 | 0 | 2023-03-13 20:38:18 |
1491 | 1491 | 327 | 2009-08-30 | 940 | 7 | 494 | 0 | 2023-03-13 20:38:18 |
1573 | 1573 | 342 | 1991-05-19 | 945 | 7 | 912 | 1 | 2023-03-13 20:38:18 |
1728 | 1728 | 383 | 2004-06-13 | 310 | 7 | 196 | 0 | 2023-03-13 20:38:18 |
1759 | 1759 | 389 | 1998-03-11 | 211 | 7 | 630 | 1 | 2023-03-13 20:38:18 |
1781 | 1781 | 393 | 1959-06-28 | 1360 | 7 | 351 | 1 | 2023-03-13 20:38:18 |
1822 | 1822 | 403 | 2002-06-16 | 285 | 7 | 711 | 0 | 2023-03-13 20:38:18 |
1828 | 1828 | 403 | 2002-06-16 | 1492 | 7 | 711 | 0 | 2023-03-13 20:38:18 |
1863 | 1863 | 409 | 1977-02-15 | 1239 | 7 | 248 | 1 | 2023-03-13 20:38:18 |
1865 | 1865 | 409 | 1977-02-15 | 1644 | 7 | 248 | 1 | 2023-03-13 20:38:18 |
1907 | 1907 | 418 | 1991-11-24 | 1594 | 7 | 570 | 1 | 2023-03-13 20:38:18 |
1933 | 1933 | 423 | 2003-03-02 | 846 | 7 | 152 | 0 | 2023-03-13 20:38:18 |
1974 | 1974 | 430 | 1950-09-05 | 1239 | 7 | 408 | 0 | 2023-03-13 20:38:18 |
2017 | 2017 | 437 | 1956-06-13 | 1194 | 7 | 366 | 0 | 2023-03-13 20:38:18 |
2041 | 2041 | 451 | 1999-11-27 | 1171 | 7 | 388 | 0 | 2023-03-13 20:38:18 |
2065 | 2065 | 460 | 1966-03-21 | 1108 | 7 | 139 | 0 | 2023-03-13 20:38:18 |
2077 | 2077 | 464 | 1975-01-09 | 1239 | 7 | 744 | 0 | 2023-03-13 20:38:18 |
2143 | 2143 | 479 | 1997-06-01 | 2143 | 7 | 422 | 0 | 2023-03-13 20:38:18 |
2151 | 2151 | 480 | 1987-07-19 | 341 | 7 | 734 | 0 | 2023-03-13 20:38:18 |
2204 | 2204 | 493 | 1979-03-01 | 1361 | 7 | 205 | 0 | 2023-03-13 20:38:18 |
2280 | 2280 | 503 | 1946-06-02 | 1330 | 7 | 0 | 2023-03-13 20:38:18 | |
2386 | 2386 | 522 | 2008-09-21 | 1587 | 7 | 407 | 0 | 2023-03-13 20:38:18 |
2477 | 2477 | 538 | 1990-06-09 | 1000 | 7 | 0 | 2023-03-13 20:38:18 | |
2508 | 2508 | 550 | 1947-10-27 | 984 | 7 | 1470 | 1 | 2023-03-13 20:38:18 |
2531 | 2531 | 554 | 2005-09-11 | 940 | 7 | 770 | 0 | 2023-03-13 20:38:18 |
2575 | 2575 | 564 | 1993-06-06 | 928 | 7 | 595 | 0 | 2023-03-13 20:38:18 |
2591 | 2591 | 568 | 1974-02-28 | 1284 | 7 | 216 | 0 | 2023-03-13 20:38:18 |
2597 | 2597 | 568 | 1974-02-28 | 1210 | 7 | 216 | 0 | 2023-03-13 20:38:18 |
2641 | 2641 | 577 | 1929-07-01 | 1219 | 7 | 1206 | 0 | 2023-03-13 20:38:18 |
2653 | 2653 | 578 | 2006-11-22 | 756 | 7 | 65 | 0 | 2023-03-13 20:38:18 |
2694 | 2694 | 590 | 1989-06-15 | 433 | 7 | 77 | 0 | 2023-03-13 20:38:18 |
2750 | 2750 | 602 | 1991-03-17 | 200 | 7 | 41 | 0 | 2023-03-13 20:38:18 |
2789 | 2789 | 605 | 1992-04-05 | 1296 | 7 | 202 | 0 | 2023-03-13 20:38:18 |
2838 | 2838 | 617 | 1983-06-26 | 1424 | 7 | 87 | 0 | 2023-03-13 20:38:18 |
2968 | 2968 | 636 | 1972-01-03 | 1219 | 7 | 391 | 0 | 2023-03-13 20:38:18 |
3131 | 3131 | 673 | 1987-04-25 | 828 | 7 | 393 | 0 | 2023-03-13 20:38:18 |
3144 | 3144 | 675 | 2005-09-17 | 891 | 7 | 845 | 0 | 2023-03-13 20:38:18 |
3164 | 3164 | 684 | 1947-10-26 | 458 | 7 | 972 | 0 | 2023-03-13 20:38:18 |
3167 | 3167 | 684 | 1947-10-26 | 1167 | 7 | 972 | 0 | 2023-03-13 20:38:18 |
3172 | 3172 | 687 | 2000-03-12 | 1361 | 7 | 370 | 0 | 2023-03-13 20:38:18 |
3230 | 3230 | 695 | 1949-01-23 | 1736 | 7 | 894 | 0 | 2023-03-13 20:38:18 |
3287 | 3287 | 704 | 1949-01-25 | 1472 | 7 | 1084 | 1 | 2023-03-13 20:38:18 |
3327 | 3327 | 707 | 1959-11-03 | 1343 | 7 | 1083 | 0 | 2023-03-13 20:38:18 |
3439 | 3439 | 717 | 1996-05-29 | 277 | 7 | 960 | 0 | 2023-03-13 20:38:18 |
3451 | 3451 | 719 | 2003-01-28 | 1357 | 7 | 1124 | 0 | 2023-03-13 20:38:18 |
3466 | 3466 | 720 | 2006-03-28 | 1873 | 7 | 1129 | 0 | 2023-03-13 20:38:18 |
3708 | 3708 | 769 | 1935-10-27 | 1264 | 7 | 975 | 0 | 2023-03-13 20:38:18 |
3731 | 3731 | 771 | 1943-10-31 | 1264 | 7 | 973 | 0 | 2023-03-13 20:38:18 |
3756 | 3756 | 774 | 1925-10-25 | 458 | 7 | 980 | 0 | 2023-03-13 20:38:18 |
3777 | 3777 | 777 | 2011-11-20 | 845 | 7 | 497 | 0 | 2023-03-13 20:38:18 |
3808 | 3808 | 780 | 1942-10-19 | 228 | 7 | 1434 | 0 | 2023-03-13 20:38:18 |
3858 | 3858 | 786 | 2012-10-14 | 2121 | 7 | 1026 | 0 | 2023-03-13 20:38:18 |
3901 | 3901 | 793 | 2007-11-25 | 1384 | 7 | 1053 | 0 | 2023-03-13 20:38:18 |
3941 | 3941 | 798 | 2013-04-27 | 210 | 7 | 651 | 0 | 2023-03-13 20:38:18 |
3954 | 3954 | 801 | 2013-09-09 | 81 | 7 | 551 | 0 | 2023-03-13 20:38:18 |
4020 | 4020 | 811 | 1991-10-20 | 329 | 7 | 1090 | 0 | 2023-03-13 20:38:18 |
4040 | 4040 | 815 | 2013-01-22 | 1303 | 7 | 1107 | 0 | 2023-03-13 20:38:18 |
4089 | 4089 | 831 | 2014-10-04 | 2365 | 7 | 1073 | 0 | 2023-03-13 20:38:18 |
4117 | 4117 | 852 | 2015-03-17 | 788 | 7 | 1155 | 0 | 2023-03-13 20:38:18 |
4130 | 4130 | 853 | 2015-03-01 | 417 | 7 | 1095 | 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 );