viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
1,024 rows where seats = 4
This data as json, CSV (advanced)
Suggested facets: cabinet_formation, calculation_date (date)
date (date) >30 ✖
- 1966-11-22 4
- 1984-10-22 4
- 1999-03-17 4
- 1968-01-23 3
- 1969-02-11 3
- 1969-03-17 3
- 1969-10-28 3
- 1969-12-15 3
- 1970-08-07 3
- 1972-01-04 3
- 1974-03-10 3
- 1976-01-27 3
- 1976-06-08 3
- 1976-10-26 3
- 1976-12-22 3
- 1977-01-04 3
- 1977-01-25 3
- 1977-02-15 3
- 1981-06-30 3
- 1984-05-29 3
- 1984-07-23 3
- 1984-09-13 3
- 1986-07-29 3
- 1986-10-20 3
- 1987-05-26 3
- 1987-11-16 3
- 1988-02-15 3
- 1988-03-15 3
- 1991-10-27 3
- 1991-12-23 3
- …
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
23 | 23 | 6 | 1977-06-16 | 30 | 4 | 315 | 0 | 2023-03-13 20:38:18 |
27 | 27 | 11 | 1953-02-22 | 769 | 4 | 560 | 0 | 2023-03-13 20:38:18 |
55 | 55 | 19 | 1946-02-17 | 1335 | 4 | 204 | 0 | 2023-03-13 20:38:18 |
72 | 72 | 21 | 1951-10-28 | 886 | 4 | 556 | 0 | 2023-03-13 20:38:18 |
91 | 91 | 25 | 1990-02-18 | 86 | 4 | 106 | 0 | 2023-03-13 20:38:18 |
103 | 103 | 30 | 1955-10-30 | 886 | 4 | 814 | 0 | 2023-03-13 20:38:18 |
106 | 106 | 30 | 1955-10-30 | 1167 | 4 | 814 | 0 | 2023-03-13 20:38:18 |
127 | 127 | 36 | 2009-04-25 | 587 | 4 | 651 | 1 | 2023-03-13 20:38:18 |
163 | 163 | 43 | 1987-02-17 | 433 | 4 | 867 | 0 | 2023-03-13 20:38:18 |
169 | 169 | 47 | 1981-06-11 | 30 | 4 | 442 | 0 | 2023-03-13 20:38:18 |
220 | 220 | 57 | 1993-07-18 | 86 | 4 | 253 | 0 | 2023-03-13 20:38:18 |
235 | 235 | 59 | 2000-10-08 | 1632 | 4 | 735 | 0 | 2023-03-13 20:38:18 |
262 | 262 | 63 | 1990-06-09 | 440 | 4 | 0 | 2023-03-13 20:38:18 | |
265 | 265 | 64 | 1973-12-04 | 1634 | 4 | 320 | 0 | 2023-03-13 20:38:18 |
305 | 305 | 73 | 1960-11-15 | 1634 | 4 | 467 | 0 | 2023-03-13 20:38:18 |
320 | 320 | 74 | 2002-05-15 | 1206 | 4 | 749 | 0 | 2023-03-13 20:38:18 |
354 | 354 | 80 | 2004-10-03 | 1587 | 4 | 292 | 0 | 2023-03-13 20:38:18 |
372 | 372 | 82 | 1995-04-08 | 205 | 4 | 640 | 0 | 2023-03-13 20:38:18 |
381 | 381 | 84 | 1979-03-19 | 1219 | 4 | 492 | 0 | 2023-03-13 20:38:18 |
397 | 397 | 85 | 1982-10-28 | 118 | 4 | 406 | 0 | 2023-03-13 20:38:18 |
433 | 433 | 97 | 1966-11-22 | 1478 | 4 | 825 | 1 | 2023-03-13 20:38:18 |
436 | 436 | 97 | 1966-11-22 | 1634 | 4 | 825 | 1 | 2023-03-13 20:38:18 |
456 | 456 | 99 | 1996-03-03 | 234 | 4 | 654 | 0 | 2023-03-13 20:38:18 |
462 | 462 | 100 | 1981-09-14 | 81 | 4 | 81 | 0 | 2023-03-13 20:38:18 |
466 | 466 | 100 | 1981-09-14 | 351 | 4 | 81 | 0 | 2023-03-13 20:38:18 |
507 | 507 | 107 | 2006-04-09 | 52 | 4 | 567 | 0 | 2023-03-13 20:38:18 |
514 | 514 | 107 | 2006-04-09 | 1030 | 4 | 567 | 0 | 2023-03-13 20:38:18 |
523 | 523 | 108 | 1963-10-27 | 1167 | 4 | 623 | 0 | 2023-03-13 20:38:18 |
528 | 528 | 108 | 1963-10-27 | 886 | 4 | 623 | 0 | 2023-03-13 20:38:18 |
555 | 555 | 114 | 1983-04-23 | 988 | 4 | 752 | 0 | 2023-03-13 20:38:18 |
586 | 586 | 121 | 1945-10-30 | 412 | 4 | 10 | 0 | 2023-03-13 20:38:18 |
595 | 595 | 122 | 1944-05-30 | 156 | 4 | 1445 | 0 | 2023-03-13 20:38:18 |
633 | 633 | 135 | 1950-09-04 | 1033 | 4 | 1471 | 1 | 2023-03-13 20:38:18 |
664 | 664 | 143 | 2003-05-18 | 161 | 4 | 193 | 0 | 2023-03-13 20:38:18 |
675 | 675 | 146 | 1994-03-27 | 397 | 4 | 801 | 0 | 2023-03-13 20:38:18 |
716 | 716 | 157 | 1990-12-12 | 1331 | 4 | 57 | 0 | 2023-03-13 20:38:18 |
772 | 772 | 171 | 2007-06-17 | 873 | 4 | 807 | 0 | 2023-03-13 20:38:18 |
782 | 782 | 172 | 2009-06-07 | 1582 | 4 | 12 | 0 | 2023-03-13 20:38:18 |
793 | 793 | 174 | 2007-11-13 | 306 | 4 | 316 | 0 | 2023-03-13 20:38:18 |
806 | 806 | 176 | 1971-10-31 | 628 | 4 | 777 | 0 | 2023-03-13 20:38:18 |
817 | 817 | 178 | 2003-05-10 | 506 | 4 | 177 | 0 | 2023-03-13 20:38:18 |
827 | 827 | 179 | 1981-12-08 | 1331 | 4 | 379 | 0 | 2023-03-13 20:38:18 |
829 | 829 | 179 | 1981-12-08 | 1634 | 4 | 379 | 0 | 2023-03-13 20:38:18 |
877 | 877 | 190 | 2007-05-24 | 2217 | 4 | 179 | 0 | 2023-03-13 20:38:18 |
926 | 926 | 204 | 1967-02-15 | 1452 | 4 | 455 | 0 | 2023-03-13 20:38:18 |
946 | 946 | 206 | 2003-10-19 | 458 | 4 | 198 | 0 | 2023-03-13 20:38:18 |
966 | 966 | 208 | 2001-06-07 | 689 | 4 | 19 | 1 | 2023-03-13 20:38:18 |
968 | 968 | 208 | 2001-06-07 | 311 | 4 | 19 | 1 | 2023-03-13 20:38:18 |
978 | 978 | 211 | 1991-10-27 | 18 | 4 | 75 | 0 | 2023-03-13 20:38:18 |
981 | 981 | 211 | 1991-10-27 | 1074 | 4 | 75 | 0 | 2023-03-13 20:38:18 |
989 | 989 | 211 | 1991-10-27 | 696 | 4 | 75 | 0 | 2023-03-13 20:38:18 |
1026 | 1026 | 217 | 1950-06-04 | 1335 | 4 | 746 | 0 | 2023-03-13 20:38:18 |
1056 | 1056 | 226 | 1987-09-08 | 1331 | 4 | 195 | 0 | 2023-03-13 20:38:18 |
1061 | 1061 | 226 | 1987-09-08 | 367 | 4 | 195 | 0 | 2023-03-13 20:38:18 |
1067 | 1067 | 228 | 1982-02-18 | 30 | 4 | 335 | 0 | 2023-03-13 20:38:18 |
1121 | 1121 | 242 | 1979-10-23 | 1634 | 4 | 824 | 0 | 2023-03-13 20:38:18 |
1134 | 1134 | 244 | 1951-05-06 | 1033 | 4 | 1472 | 1 | 2023-03-13 20:38:18 |
1142 | 1142 | 246 | 2010-08-21 | 1396 | 4 | 736 | 0 | 2023-03-13 20:38:18 |
1166 | 1166 | 252 | 1993-06-06 | 234 | 4 | 37 | 0 | 2023-03-13 20:38:18 |
1241 | 1241 | 263 | 1957-05-14 | 1634 | 4 | 218 | 0 | 2023-03-13 20:38:18 |
1243 | 1243 | 265 | 2007-05-12 | 506 | 4 | 246 | 0 | 2023-03-13 20:38:18 |
1280 | 1280 | 281 | 1980-10-05 | 622 | 4 | 328 | 1 | 2023-03-13 20:38:18 |
1285 | 1285 | 281 | 1980-10-05 | 565 | 4 | 328 | 1 | 2023-03-13 20:38:18 |
1304 | 1304 | 284 | 1990-04-08 | 1358 | 4 | 716 | 0 | 2023-03-13 20:38:18 |
1317 | 1317 | 288 | 1964-09-22 | 1634 | 4 | 841 | 0 | 2023-03-13 20:38:18 |
1325 | 1325 | 289 | 1989-10-29 | 1317 | 4 | 834 | 0 | 2023-03-13 20:38:18 |
1358 | 1358 | 292 | 1953-08-10 | 1189 | 4 | 327 | 1 | 2023-03-13 20:38:18 |
1410 | 1410 | 310 | 2007-10-21 | 458 | 4 | 855 | 0 | 2023-03-13 20:38:18 |
1444 | 1444 | 315 | 1997-05-01 | 311 | 4 | 678 | 0 | 2023-03-13 20:38:18 |
1454 | 1454 | 316 | 1997-06-06 | 651 | 4 | 573 | 0 | 2023-03-13 20:38:18 |
1457 | 1457 | 316 | 1997-06-06 | 1580 | 4 | 573 | 0 | 2023-03-13 20:38:18 |
1472 | 1472 | 319 | 2008-11-30 | 5 | 4 | 118 | 0 | 2023-03-13 20:38:18 |
1551 | 1551 | 338 | 1996-11-10 | 981 | 4 | 562 | 0 | 2023-03-13 20:38:18 |
1560 | 1560 | 339 | 2001-05-27 | 945 | 4 | 910 | 1 | 2023-03-13 20:38:18 |
1641 | 1641 | 359 | 1992-11-25 | 1580 | 4 | 870 | 0 | 2023-03-13 20:38:18 |
1668 | 1668 | 371 | 1975-10-26 | 564 | 4 | 79 | 0 | 2023-03-13 20:38:18 |
1669 | 1669 | 371 | 1975-10-26 | 1167 | 4 | 79 | 0 | 2023-03-13 20:38:18 |
1718 | 1718 | 382 | 1992-12-06 | 179 | 4 | 9 | 0 | 2023-03-13 20:38:18 |
1739 | 1739 | 384 | 1974-03-10 | 708 | 4 | 859 | 0 | 2023-03-13 20:38:18 |
1750 | 1750 | 387 | 1988-05-10 | 1331 | 4 | 837 | 0 | 2023-03-13 20:38:18 |
1761 | 1761 | 389 | 1998-03-11 | 1331 | 4 | 630 | 1 | 2023-03-13 20:38:18 |
1767 | 1767 | 389 | 1998-03-11 | 978 | 4 | 630 | 1 | 2023-03-13 20:38:18 |
1787 | 1787 | 396 | 1985-10-13 | 1594 | 4 | 724 | 0 | 2023-03-13 20:38:18 |
1803 | 1803 | 400 | 1971-09-21 | 1634 | 4 | 596 | 0 | 2023-03-13 20:38:18 |
1813 | 1813 | 401 | 2007-06-10 | 1594 | 4 | 886 | 1 | 2023-03-13 20:38:18 |
1818 | 1818 | 402 | 1945-11-25 | 769 | 4 | 452 | 0 | 2023-03-13 20:38:18 |
1867 | 1867 | 409 | 1977-02-15 | 1634 | 4 | 248 | 1 | 2023-03-13 20:38:18 |
1897 | 1897 | 416 | 1992-09-27 | 792 | 4 | 710 | 0 | 2023-03-13 20:38:18 |
1991 | 1991 | 433 | 1979-10-07 | 170 | 4 | 227 | 0 | 2023-03-13 20:38:18 |
2019 | 2019 | 439 | 1992-11-15 | 432 | 4 | 512 | 0 | 2023-03-13 20:38:18 |
2026 | 2026 | 439 | 1992-11-15 | 28 | 4 | 512 | 0 | 2023-03-13 20:38:18 |
2083 | 2083 | 464 | 1975-01-09 | 1634 | 4 | 744 | 0 | 2023-03-13 20:38:18 |
2085 | 2085 | 464 | 1975-01-09 | 189 | 4 | 744 | 0 | 2023-03-13 20:38:18 |
2105 | 2105 | 469 | 1957-03-05 | 433 | 4 | 626 | 0 | 2023-03-13 20:38:18 |
2153 | 2153 | 480 | 1987-07-19 | 251 | 4 | 734 | 0 | 2023-03-13 20:38:18 |
2275 | 2275 | 502 | 1976-06-20 | 1296 | 4 | 842 | 0 | 2023-03-13 20:38:18 |
2282 | 2282 | 503 | 1946-06-02 | 1028 | 4 | 0 | 2023-03-13 20:38:18 | |
2298 | 2298 | 506 | 1986-07-06 | 86 | 4 | 568 | 0 | 2023-03-13 20:38:18 |
2318 | 2318 | 511 | 2003-11-09 | 1382 | 4 | 840 | 0 | 2023-03-13 20:38:18 |
2340 | 2340 | 514 | 1992-04-09 | 311 | 4 | 678 | 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 );