viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
374 rows where seats = 12
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, date (date), calculation_date (date)
| Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
|---|---|---|---|---|---|---|---|---|
| 161 | 161 | 43 | 1987-02-17 | 318 | 12 | 867 | 0 | 2023-03-13 20:38:18 |
| 244 | 244 | 60 | 1948-02-04 | 30 | 12 | 151 | 0 | 2023-03-13 20:38:18 |
| 295 | 295 | 70 | 1981-05-24 | 572 | 12 | 914 | 1 | 2023-03-13 20:38:18 |
| 296 | 296 | 70 | 1981-05-24 | 1575 | 12 | 914 | 1 | 2023-03-13 20:38:18 |
| 300 | 300 | 71 | 1954-03-08 | 585 | 12 | 738 | 0 | 2023-03-13 20:38:18 |
| 393 | 393 | 85 | 1982-10-28 | 894 | 12 | 406 | 0 | 2023-03-13 20:38:18 |
| 547 | 547 | 113 | 1980-06-22 | 170 | 12 | 727 | 0 | 2023-03-13 20:38:18 |
| 619 | 619 | 129 | 1990-04-12 | 1252 | 12 | 0 | 2023-03-13 20:38:18 | |
| 628 | 628 | 135 | 1950-09-04 | 984 | 12 | 1471 | 1 | 2023-03-13 20:38:18 |
| 700 | 700 | 150 | 1965-05-23 | 290 | 12 | 613 | 0 | 2023-03-13 20:38:18 |
| 720 | 720 | 157 | 1990-12-12 | 978 | 12 | 57 | 0 | 2023-03-13 20:38:18 |
| 820 | 820 | 178 | 2003-05-10 | 1455 | 12 | 177 | 0 | 2023-03-13 20:38:18 |
| 919 | 919 | 201 | 2004-03-07 | 614 | 12 | 190 | 0 | 2023-03-13 20:38:18 |
| 927 | 927 | 204 | 1967-02-15 | 405 | 12 | 455 | 0 | 2023-03-13 20:38:18 |
| 957 | 957 | 207 | 1985-09-08 | 702 | 12 | 310 | 1 | 2023-03-13 20:38:18 |
| 971 | 971 | 210 | 2005-02-20 | 251 | 12 | 755 | 0 | 2023-03-13 20:38:18 |
| 974 | 974 | 210 | 2005-02-20 | 514 | 12 | 755 | 0 | 2023-03-13 20:38:18 |
| 1216 | 1216 | 260 | 2002-10-05 | 466 | 12 | 23 | 0 | 2023-03-13 20:38:18 |
| 1273 | 1273 | 275 | 1978-06-25 | 1455 | 12 | 849 | 0 | 2023-03-13 20:38:18 |
| 1397 | 1397 | 306 | 1994-06-12 | 967 | 12 | 418 | 0 | 2023-03-13 20:38:18 |
| 1519 | 1519 | 332 | 1995-05-21 | 1192 | 12 | 624 | 0 | 2023-03-13 20:38:18 |
| 1724 | 1724 | 382 | 1992-12-06 | 981 | 12 | 9 | 0 | 2023-03-13 20:38:18 |
| 1853 | 1853 | 408 | 2002-05-17 | 30 | 12 | 126 | 0 | 2023-03-13 20:38:18 |
| 1908 | 1908 | 418 | 1991-11-24 | 993 | 12 | 570 | 1 | 2023-03-13 20:38:18 |
| 1970 | 1970 | 429 | 1957-10-07 | 1538 | 12 | 61 | 1 | 2023-03-13 20:38:18 |
| 1973 | 1973 | 430 | 1950-09-05 | 211 | 12 | 408 | 0 | 2023-03-13 20:38:18 |
| 1976 | 1976 | 430 | 1950-09-05 | 1606 | 12 | 408 | 0 | 2023-03-13 20:38:18 |
| 2051 | 2051 | 453 | 1985-06-02 | 614 | 12 | 713 | 0 | 2023-03-13 20:38:18 |
| 2052 | 2052 | 455 | 2000-11-27 | 794 | 12 | 55 | 1 | 2023-03-13 20:38:18 |
| 2057 | 2057 | 456 | 1983-04-24 | 50 | 12 | 463 | 0 | 2023-03-13 20:38:18 |
| 2106 | 2106 | 469 | 1957-03-05 | 318 | 12 | 626 | 0 | 2023-03-13 20:38:18 |
| 2164 | 2164 | 486 | 2010-06-13 | 993 | 12 | 675 | 1 | 2023-03-13 20:38:18 |
| 2241 | 2241 | 499 | 1977-09-11 | 702 | 12 | 653 | 1 | 2023-03-13 20:38:18 |
| 2421 | 2421 | 527 | 1987-03-16 | 585 | 12 | 650 | 0 | 2023-03-13 20:38:18 |
| 2493 | 2493 | 543 | 1952-06-25 | 300 | 12 | 243 | 0 | 2023-03-13 20:38:18 |
| 2574 | 2574 | 564 | 1993-06-06 | 1368 | 12 | 595 | 0 | 2023-03-13 20:38:18 |
| 2678 | 2678 | 583 | 1966-03-31 | 659 | 12 | 760 | 0 | 2023-03-13 20:38:18 |
| 2707 | 2707 | 592 | 1999-05-08 | 1455 | 12 | 158 | 0 | 2023-03-13 20:38:18 |
| 2792 | 2792 | 605 | 1992-04-05 | 366 | 12 | 202 | 0 | 2023-03-13 20:38:18 |
| 2817 | 2817 | 609 | 1945-07-05 | 659 | 12 | 1520 | 0 | 2023-03-13 20:38:18 |
| 2883 | 2883 | 627 | 1989-09-06 | 345 | 12 | 550 | 0 | 2023-03-13 20:38:18 |
| 2929 | 2929 | 632 | 2001-11-20 | 1644 | 12 | 630 | 0 | 2023-03-13 20:38:18 |
| 2944 | 2944 | 633 | 1990-05-20 | 1639 | 12 | 1604 | 0 | 2023-03-13 20:38:18 |
| 2946 | 2946 | 633 | 1990-05-20 | 888 | 12 | 1604 | 0 | 2023-03-13 20:38:18 |
| 3007 | 3007 | 644 | 1949-06-26 | 708 | 12 | 40 | 0 | 2023-03-13 20:38:18 |
| 3040 | 3040 | 653 | 1974-11-17 | 1338 | 12 | 0 | 2023-03-13 20:38:18 | |
| 3098 | 3098 | 667 | 1959-03-12 | 405 | 12 | 741 | 0 | 2023-03-13 20:38:18 |
| 3109 | 3109 | 670 | 1992-09-20 | 1448 | 12 | 0 | 2023-03-13 20:38:18 | |
| 3217 | 3217 | 693 | 1953-04-19 | 1055 | 12 | 896 | 0 | 2023-03-13 20:38:18 |
| 3324 | 3324 | 707 | 1959-11-03 | 214 | 12 | 1083 | 0 | 2023-03-13 20:38:18 |
| 3337 | 3337 | 708 | 1961-08-15 | 214 | 12 | 1136 | 0 | 2023-03-13 20:38:18 |
| 3360 | 3360 | 710 | 1969-10-28 | 214 | 12 | 938 | 0 | 2023-03-13 20:38:18 |
| 3374 | 3374 | 712 | 1977-05-17 | 214 | 12 | 944 | 0 | 2023-03-13 20:38:18 |
| 3426 | 3426 | 716 | 1992-06-23 | 1419 | 12 | 957 | 0 | 2023-03-13 20:38:18 |
| 3462 | 3462 | 720 | 2006-03-28 | 788 | 12 | 1129 | 0 | 2023-03-13 20:38:18 |
| 3463 | 3463 | 720 | 2006-03-28 | 678 | 12 | 1129 | 0 | 2023-03-13 20:38:18 |
| 3491 | 3491 | 722 | 2011-09-15 | 306 | 12 | 71 | 0 | 2023-03-13 20:38:18 |
| 3562 | 3562 | 737 | 1943-08-21 | 1912 | 12 | 995 | 0 | 2023-03-13 20:38:18 |
| 3572 | 3572 | 739 | 1946-09-28 | 184 | 12 | 574 | 0 | 2023-03-13 20:38:18 |
| 3596 | 3596 | 745 | 1937-10-23 | 184 | 12 | 1018 | 1 | 2023-03-13 20:38:18 |
| 3607 | 3607 | 746 | 1934-09-15 | 184 | 12 | 1016 | 0 | 2023-03-13 20:38:18 |
| 3667 | 3667 | 762 | 2004-10-09 | 184 | 12 | 812 | 0 | 2023-03-13 20:38:18 |
| 3801 | 3801 | 779 | 2011-10-23 | 308 | 12 | 903 | 0 | 2023-03-13 20:38:18 |
| 3817 | 3817 | 782 | 2012-06-17 | 1492 | 12 | 1037 | 0 | 2023-03-13 20:38:18 |
| 3824 | 3824 | 782 | 2012-06-17 | 1058 | 12 | 1037 | 0 | 2023-03-13 20:38:18 |
| 3842 | 3842 | 784 | 2012-06-17 | 614 | 12 | 1039 | 0 | 2023-03-13 20:38:18 |
| 3848 | 3848 | 785 | 2012-09-12 | 345 | 12 | 1028 | 0 | 2023-03-13 20:38:18 |
| 3859 | 3859 | 786 | 2012-10-14 | 1421 | 12 | 1026 | 0 | 2023-03-13 20:38:18 |
| 4038 | 4038 | 815 | 2013-01-22 | 214 | 12 | 1107 | 0 | 2023-03-13 20:38:18 |
| 4141 | 4141 | 855 | 2015-04-19 | 1292 | 12 | 1145 | 0 | 2023-03-13 20:38:18 |
| 4166 | 4166 | 858 | 1930-07-28 | 2566 | 12 | 1167 | 0 | 2023-03-13 20:38:18 |
| 4299 | 4299 | 887 | 1903-06-16 | 590 | 12 | 1366 | 1 | 2023-03-13 20:38:18 |
| 4300 | 4300 | 887 | 1903-06-16 | 2430 | 12 | 1366 | 1 | 2023-03-13 20:38:18 |
| 4304 | 4304 | 888 | 1906-05-29 | 590 | 12 | 1367 | 1 | 2023-03-13 20:38:18 |
| 4469 | 4469 | 915 | 1927-09-15 | 30 | 12 | 1439 | 0 | 2023-03-13 20:38:18 |
| 4551 | 4551 | 933 | 1928-06-03 | 701 | 12 | 1450 | 0 | 2023-03-13 20:38:18 |
| 4615 | 4615 | 940 | 1929-07-03 | 300 | 12 | 1259 | 0 | 2023-03-13 20:38:18 |
| 4717 | 4717 | 956 | 1925-11-04 | 878 | 12 | 1313 | 0 | 2023-03-13 20:38:18 |
| 4828 | 4828 | 977 | 1917-10-28 | 458 | 12 | 1463 | 0 | 2023-03-13 20:38:18 |
| 4865 | 4865 | 984 | 1932-05-08 | 686 | 12 | 1338 | 0 | 2023-03-13 20:38:18 |
| 4972 | 4972 | 998 | 2015-12-20 | 2606 | 12 | 1421 | 1 | 2023-03-13 20:38:18 |
| 5009 | 5009 | 1002 | 2016-02-26 | 30 | 12 | 904 | 0 | 2023-03-13 20:38:18 |
| 5033 | 5033 | 1005 | 2016-06-26 | 2606 | 12 | 1493 | 1 | 2023-03-13 20:38:18 |
| 5086 | 5086 | 1011 | 2017-03-26 | 2637 | 12 | 1503 | 0 | 2023-03-13 20:38:18 |
| 5103 | 5103 | 1013 | 2017-06-08 | 659 | 12 | 1489 | 0 | 2023-03-13 20:38:18 |
| 5116 | 5116 | 1014 | 2017-06-18 | 177 | 12 | 1508 | 0 | 2023-03-13 20:38:18 |
| 5171 | 5171 | 1022 | 2017-10-22 | 1540 | 12 | 1156 | 0 | 2023-03-13 20:38:18 |
| 5220 | 5220 | 1028 | 1927-04-24 | 2674 | 12 | 1546 | 0 | 2023-03-13 20:38:18 |
| 5297 | 5297 | 1035 | 1924-12-07 | 2698 | 12 | 1570 | 0 | 2023-03-13 20:38:18 |
| 5306 | 5306 | 1036 | 1928-05-20 | 2695 | 12 | 1575 | 0 | 2023-03-13 20:38:18 |
| 5389 | 5389 | 1043 | 2018-10-14 | 967 | 12 | 1069 | 0 | 2023-03-13 20:38:18 |
| 5395 | 5395 | 1044 | 2019-03-03 | 1597 | 12 | 1495 | 0 | 2023-03-13 20:38:18 |
| 5433 | 5433 | 1048 | 2019-05-26 | 1110 | 12 | 1621 | 1 | 2023-03-13 20:38:18 |
| 5438 | 5438 | 1048 | 2019-05-26 | 723 | 12 | 1621 | 1 | 2023-03-13 20:38:18 |
| 5440 | 5440 | 1048 | 2019-05-26 | 256 | 12 | 1621 | 1 | 2023-03-13 20:38:18 |
| 5446 | 5446 | 1077 | 2019-06-05 | 590 | 12 | 1497 | 0 | 2023-03-13 20:38:18 |
| 5481 | 5481 | 1081 | 2019-10-06 | 1295 | 12 | 1198 | 0 | 2023-03-13 20:38:18 |
| 5558 | 5558 | 1088 | 2020-02-08 | 1573 | 12 | 1641 | 1 | 2023-03-13 20:38:18 |
| 5569 | 5569 | 1089 | 2020-02-29 | 2796 | 12 | 1529 | 0 | 2023-03-13 20:38:18 |
| 5719 | 5719 | 1109 | 2022-01-30 | 2789 | 12 | 1610 | 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 );