viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1
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 |
|---|---|---|---|---|---|---|---|---|
| 119 | 119 | 35 | 1946-06-30 | 1319 | 10 | 703 | 1 | 2023-03-13 20:38:18 |
| 120 | 120 | 35 | 1946-06-30 | 228 | 9 | 703 | 1 | 2023-03-13 20:38:18 |
| 121 | 121 | 35 | 1946-06-30 | 1342 | 20 | 703 | 1 | 2023-03-13 20:38:18 |
| 122 | 122 | 35 | 1946-06-30 | 1455 | 13 | 703 | 1 | 2023-03-13 20:38:18 |
| 123 | 123 | 36 | 2009-04-25 | 1455 | 9 | 651 | 1 | 2023-03-13 20:38:18 |
| 124 | 124 | 36 | 2009-04-25 | 1342 | 16 | 651 | 1 | 2023-03-13 20:38:18 |
| 125 | 125 | 36 | 2009-04-25 | 210 | 14 | 651 | 1 | 2023-03-13 20:38:18 |
| 126 | 126 | 36 | 2009-04-25 | 1006 | 20 | 651 | 1 | 2023-03-13 20:38:18 |
| 127 | 127 | 36 | 2009-04-25 | 587 | 4 | 651 | 1 | 2023-03-13 20:38:18 |
| 137 | 137 | 40 | 1974-10-10 | 646 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
| 138 | 138 | 40 | 1974-10-10 | 1210 | 6 | 7 | 1 | 2023-03-13 20:38:18 |
| 139 | 139 | 40 | 1974-10-10 | 319 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
| 140 | 140 | 40 | 1974-10-10 | 1284 | 11 | 7 | 1 | 2023-03-13 20:38:18 |
| 141 | 141 | 40 | 1974-10-10 | 1556 | 319 | 7 | 1 | 2023-03-13 20:38:18 |
| 142 | 142 | 40 | 1974-10-10 | 311 | 3 | 7 | 1 | 2023-03-13 20:38:18 |
| 143 | 143 | 40 | 1974-10-10 | 659 | 13 | 7 | 1 | 2023-03-13 20:38:18 |
| 144 | 144 | 40 | 1974-10-10 | 1023 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
| 145 | 145 | 40 | 1974-10-10 | 773 | 277 | 7 | 1 | 2023-03-13 20:38:18 |
| 146 | 146 | 40 | 1974-10-10 | 1599 | 1 | 7 | 1 | 2023-03-13 20:38:18 |
| 173 | 173 | 48 | 1985-09-15 | 282 | 1 | 296 | 1 | 2023-03-13 20:38:18 |
| 174 | 174 | 48 | 1985-09-15 | 657 | 76 | 296 | 1 | 2023-03-13 20:38:18 |
| 175 | 175 | 48 | 1985-09-15 | 882 | 19 | 296 | 1 | 2023-03-13 20:38:18 |
| 176 | 176 | 48 | 1985-09-15 | 1461 | 43 | 296 | 1 | 2023-03-13 20:38:18 |
| 177 | 177 | 48 | 1985-09-15 | 892 | 51 | 296 | 1 | 2023-03-13 20:38:18 |
| 178 | 178 | 48 | 1985-09-15 | 904 | 159 | 296 | 1 | 2023-03-13 20:38:18 |
| 294 | 294 | 70 | 1981-05-24 | 851 | 8 | 914 | 1 | 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 |
| 297 | 297 | 70 | 1981-05-24 | 945 | 3 | 914 | 1 | 2023-03-13 20:38:18 |
| 329 | 329 | 76 | 1962-06-18 | 1392 | 30 | 619 | 1 | 2023-03-13 20:38:18 |
| 330 | 330 | 76 | 1962-06-18 | 794 | 116 | 619 | 1 | 2023-03-13 20:38:18 |
| 331 | 331 | 76 | 1962-06-18 | 368 | 99 | 619 | 1 | 2023-03-13 20:38:18 |
| 332 | 332 | 76 | 1962-06-18 | 296 | 19 | 619 | 1 | 2023-03-13 20:38:18 |
| 333 | 333 | 76 | 1962-06-18 | 2085 | 1 | 619 | 1 | 2023-03-13 20:38:18 |
| 433 | 433 | 97 | 1966-11-22 | 1478 | 4 | 825 | 1 | 2023-03-13 20:38:18 |
| 434 | 434 | 97 | 1966-11-22 | 211 | 13 | 825 | 1 | 2023-03-13 20:38:18 |
| 435 | 435 | 97 | 1966-11-22 | 1629 | 69 | 825 | 1 | 2023-03-13 20:38:18 |
| 436 | 436 | 97 | 1966-11-22 | 1634 | 4 | 825 | 1 | 2023-03-13 20:38:18 |
| 437 | 437 | 97 | 1966-11-22 | 1644 | 20 | 825 | 1 | 2023-03-13 20:38:18 |
| 438 | 438 | 97 | 1966-11-22 | 1605 | 35 | 825 | 1 | 2023-03-13 20:38:18 |
| 439 | 439 | 97 | 1966-11-22 | 590 | 34 | 825 | 1 | 2023-03-13 20:38:18 |
| 539 | 539 | 112 | 1949-06-27 | 1189 | 6 | 750 | 1 | 2023-03-13 20:38:18 |
| 540 | 540 | 112 | 1949-06-27 | 1392 | 10 | 750 | 1 | 2023-03-13 20:38:18 |
| 541 | 541 | 112 | 1949-06-27 | 794 | 41 | 750 | 1 | 2023-03-13 20:38:18 |
| 542 | 542 | 112 | 1949-06-27 | 296 | 13 | 750 | 1 | 2023-03-13 20:38:18 |
| 543 | 543 | 112 | 1949-06-27 | 368 | 190 | 750 | 1 | 2023-03-13 20:38:18 |
| 544 | 544 | 112 | 1949-06-27 | 2085 | 1 | 750 | 1 | 2023-03-13 20:38:18 |
| 545 | 545 | 112 | 1949-06-27 | 2011 | 1 | 750 | 1 | 2023-03-13 20:38:18 |
| 613 | 613 | 127 | 1985-12-08 | 851 | 16 | 913 | 1 | 2023-03-13 20:38:18 |
| 614 | 614 | 127 | 1985-12-08 | 1575 | 19 | 913 | 1 | 2023-03-13 20:38:18 |
| 615 | 615 | 127 | 1985-12-08 | 945 | 6 | 913 | 1 | 2023-03-13 20:38:18 |
| 616 | 616 | 127 | 1985-12-08 | 572 | 15 | 913 | 1 | 2023-03-13 20:38:18 |
| 628 | 628 | 135 | 1950-09-04 | 984 | 12 | 1471 | 1 | 2023-03-13 20:38:18 |
| 629 | 629 | 135 | 1950-09-04 | 1274 | 11 | 1471 | 1 | 2023-03-13 20:38:18 |
| 630 | 630 | 135 | 1950-09-04 | 1003 | 11 | 1471 | 1 | 2023-03-13 20:38:18 |
| 631 | 631 | 135 | 1950-09-04 | 1572 | 1 | 1471 | 1 | 2023-03-13 20:38:18 |
| 632 | 632 | 135 | 1950-09-04 | 816 | 1 | 1471 | 1 | 2023-03-13 20:38:18 |
| 633 | 633 | 135 | 1950-09-04 | 1033 | 4 | 1471 | 1 | 2023-03-13 20:38:18 |
| 868 | 868 | 189 | 1945-06-11 | 368 | 125 | 608 | 1 | 2023-03-13 20:38:18 |
| 869 | 869 | 189 | 1945-06-11 | 1307 | 2 | 608 | 1 | 2023-03-13 20:38:18 |
| 870 | 870 | 189 | 1945-06-11 | 1189 | 8 | 608 | 1 | 2023-03-13 20:38:18 |
| 871 | 871 | 189 | 1945-06-11 | 1392 | 13 | 608 | 1 | 2023-03-13 20:38:18 |
| 872 | 872 | 189 | 1945-06-11 | 794 | 67 | 608 | 1 | 2023-03-13 20:38:18 |
| 873 | 873 | 189 | 1945-06-11 | 296 | 28 | 608 | 1 | 2023-03-13 20:38:18 |
| 874 | 874 | 189 | 1945-06-11 | 556 | 1 | 608 | 1 | 2023-03-13 20:38:18 |
| 875 | 875 | 189 | 1945-06-11 | 2011 | 1 | 608 | 1 | 2023-03-13 20:38:18 |
| 955 | 955 | 207 | 1985-09-08 | 104 | 71 | 310 | 1 | 2023-03-13 20:38:18 |
| 956 | 956 | 207 | 1985-09-08 | 1435 | 50 | 310 | 1 | 2023-03-13 20:38:18 |
| 957 | 957 | 207 | 1985-09-08 | 702 | 12 | 310 | 1 | 2023-03-13 20:38:18 |
| 958 | 958 | 207 | 1985-09-08 | 351 | 2 | 310 | 1 | 2023-03-13 20:38:18 |
| 959 | 959 | 207 | 1985-09-08 | 1538 | 16 | 310 | 1 | 2023-03-13 20:38:18 |
| 960 | 960 | 207 | 1985-09-08 | 81 | 6 | 310 | 1 | 2023-03-13 20:38:18 |
| 961 | 961 | 208 | 2001-06-07 | 319 | 5 | 19 | 1 | 2023-03-13 20:38:18 |
| 962 | 962 | 208 | 2001-06-07 | 1556 | 412 | 19 | 1 | 2023-03-13 20:38:18 |
| 963 | 963 | 208 | 2001-06-07 | 453 | 2 | 19 | 1 | 2023-03-13 20:38:18 |
| 964 | 964 | 208 | 2001-06-07 | 1210 | 6 | 19 | 1 | 2023-03-13 20:38:18 |
| 965 | 965 | 208 | 2001-06-07 | 659 | 52 | 19 | 1 | 2023-03-13 20:38:18 |
| 966 | 966 | 208 | 2001-06-07 | 689 | 4 | 19 | 1 | 2023-03-13 20:38:18 |
| 967 | 967 | 208 | 2001-06-07 | 1023 | 3 | 19 | 1 | 2023-03-13 20:38:18 |
| 968 | 968 | 208 | 2001-06-07 | 311 | 4 | 19 | 1 | 2023-03-13 20:38:18 |
| 969 | 969 | 208 | 2001-06-07 | 773 | 166 | 19 | 1 | 2023-03-13 20:38:18 |
| 970 | 970 | 208 | 2001-06-07 | 1284 | 5 | 19 | 1 | 2023-03-13 20:38:18 |
| 997 | 997 | 213 | 1953-04-21 | 1606 | 9 | 359 | 1 | 2023-03-13 20:38:18 |
| 998 | 998 | 213 | 1953-04-21 | 590 | 26 | 359 | 1 | 2023-03-13 20:38:18 |
| 999 | 999 | 213 | 1953-04-21 | 211 | 13 | 359 | 1 | 2023-03-13 20:38:18 |
| 1000 | 1000 | 213 | 1953-04-21 | 1634 | 2 | 359 | 1 | 2023-03-13 20:38:18 |
| 1001 | 1001 | 213 | 1953-04-21 | 1629 | 61 | 359 | 1 | 2023-03-13 20:38:18 |
| 1002 | 1002 | 213 | 1953-04-21 | 1605 | 33 | 359 | 1 | 2023-03-13 20:38:18 |
| 1003 | 1003 | 213 | 1953-04-21 | 1239 | 7 | 359 | 1 | 2023-03-13 20:38:18 |
| 1013 | 1013 | 215 | 1973-09-16 | 882 | 19 | 438 | 1 | 2023-03-13 20:38:18 |
| 1014 | 1014 | 215 | 1973-09-16 | 904 | 156 | 438 | 1 | 2023-03-13 20:38:18 |
| 1015 | 1015 | 215 | 1973-09-16 | 1461 | 90 | 438 | 1 | 2023-03-13 20:38:18 |
| 1016 | 1016 | 215 | 1973-09-16 | 892 | 34 | 438 | 1 | 2023-03-13 20:38:18 |
| 1017 | 1017 | 215 | 1973-09-16 | 657 | 51 | 438 | 1 | 2023-03-13 20:38:18 |
| 1082 | 1082 | 234 | 1952-09-21 | 1461 | 26 | 781 | 1 | 2023-03-13 20:38:18 |
| 1083 | 1083 | 234 | 1952-09-21 | 904 | 110 | 781 | 1 | 2023-03-13 20:38:18 |
| 1084 | 1084 | 234 | 1952-09-21 | 882 | 5 | 781 | 1 | 2023-03-13 20:38:18 |
| 1085 | 1085 | 234 | 1952-09-21 | 892 | 58 | 781 | 1 | 2023-03-13 20:38:18 |
| 1086 | 1086 | 234 | 1952-09-21 | 657 | 31 | 781 | 1 | 2023-03-13 20:38:18 |
| 1134 | 1134 | 244 | 1951-05-06 | 1033 | 4 | 1472 | 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 );