viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
8,267 rows where cabinet_formation = 0 sorted by cabinet_id
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 |
---|---|---|---|---|---|---|---|---|
109 | 109 | 32 | 1991-10-13 | 1286 | 24 | 0 | 2023-03-13 20:38:18 | |
110 | 110 | 32 | 1991-10-13 | 1160 | 106 | 0 | 2023-03-13 20:38:18 | |
111 | 111 | 32 | 1991-10-13 | 423 | 110 | 0 | 2023-03-13 20:38:18 | |
147 | 147 | 42 | 1977-06-15 | 118 | 19 | 0 | 2023-03-13 20:38:18 | |
148 | 148 | 42 | 1977-06-15 | 902 | 118 | 0 | 2023-03-13 20:38:18 | |
149 | 149 | 42 | 1977-06-15 | 135 | 166 | 0 | 2023-03-13 20:38:18 | |
150 | 150 | 42 | 1977-06-15 | 62 | 2 | 0 | 2023-03-13 20:38:18 | |
151 | 151 | 42 | 1977-06-15 | 1361 | 8 | 0 | 2023-03-13 20:38:18 | |
152 | 152 | 42 | 1977-06-15 | 1221 | 1 | 0 | 2023-03-13 20:38:18 | |
153 | 153 | 42 | 1977-06-15 | 645 | 16 | 0 | 2023-03-13 20:38:18 | |
154 | 154 | 42 | 1977-06-15 | 1377 | 1 | 0 | 2023-03-13 20:38:18 | |
155 | 155 | 42 | 1977-06-15 | 894 | 11 | 0 | 2023-03-13 20:38:18 | |
156 | 156 | 42 | 1977-06-15 | 1026 | 1 | 0 | 2023-03-13 20:38:18 | |
157 | 157 | 42 | 1977-06-15 | 1790 | 6 | 0 | 2023-03-13 20:38:18 | |
158 | 158 | 42 | 1977-06-15 | 757 | 1 | 0 | 2023-03-13 20:38:18 | |
258 | 258 | 63 | 1990-06-09 | 1245 | 15 | 0 | 2023-03-13 20:38:18 | |
259 | 259 | 63 | 1990-06-09 | 665 | 32 | 0 | 2023-03-13 20:38:18 | |
260 | 260 | 63 | 1990-06-09 | 743 | 127 | 0 | 2023-03-13 20:38:18 | |
261 | 261 | 63 | 1990-06-09 | 19 | 22 | 0 | 2023-03-13 20:38:18 | |
262 | 262 | 63 | 1990-06-09 | 440 | 4 | 0 | 2023-03-13 20:38:18 | |
617 | 617 | 129 | 1990-04-12 | 65 | 1 | 0 | 2023-03-13 20:38:18 | |
618 | 618 | 129 | 1990-04-12 | 1371 | 8 | 0 | 2023-03-13 20:38:18 | |
619 | 619 | 129 | 1990-04-12 | 1252 | 12 | 0 | 2023-03-13 20:38:18 | |
620 | 620 | 129 | 1990-04-12 | 199 | 1 | 0 | 2023-03-13 20:38:18 | |
621 | 621 | 129 | 1990-04-12 | 317 | 5 | 0 | 2023-03-13 20:38:18 | |
622 | 622 | 129 | 1990-04-12 | 706 | 14 | 0 | 2023-03-13 20:38:18 | |
623 | 623 | 129 | 1990-04-12 | 179 | 6 | 0 | 2023-03-13 20:38:18 | |
624 | 624 | 129 | 1990-04-12 | 16 | 11 | 0 | 2023-03-13 20:38:18 | |
625 | 625 | 129 | 1990-04-12 | 875 | 3 | 0 | 2023-03-13 20:38:18 | |
626 | 626 | 129 | 1990-04-12 | 1047 | 11 | 0 | 2023-03-13 20:38:18 | |
627 | 627 | 129 | 1990-04-12 | 1619 | 8 | 0 | 2023-03-13 20:38:18 | |
725 | 725 | 158 | 1989-06-18 | 1216 | 27 | 0 | 2023-03-13 20:38:18 | |
726 | 726 | 158 | 1989-06-18 | 1077 | 173 | 0 | 2023-03-13 20:38:18 | |
727 | 727 | 158 | 1989-06-18 | 822 | 76 | 0 | 2023-03-13 20:38:18 | |
728 | 728 | 158 | 1989-06-18 | 1011 | 23 | 0 | 2023-03-13 20:38:18 | |
729 | 729 | 158 | 1989-06-18 | 108 | 161 | 0 | 2023-03-13 20:38:18 | |
1197 | 1197 | 257 | 1990-04-08 | 1426 | 93 | 0 | 2023-03-13 20:38:18 | |
1198 | 1198 | 257 | 1990-04-08 | 1617 | 7 | 0 | 2023-03-13 20:38:18 | |
1199 | 1199 | 257 | 1990-04-08 | 1183 | 2 | 0 | 2023-03-13 20:38:18 | |
1200 | 1200 | 257 | 1990-04-08 | 921 | 22 | 0 | 2023-03-13 20:38:18 | |
1201 | 1201 | 257 | 1990-04-08 | 870 | 44 | 0 | 2023-03-13 20:38:18 | |
1202 | 1202 | 257 | 1990-04-08 | 434 | 21 | 0 | 2023-03-13 20:38:18 | |
1203 | 1203 | 257 | 1990-04-08 | 1591 | 33 | 0 | 2023-03-13 20:38:18 | |
1204 | 1204 | 257 | 1990-04-08 | 546 | 164 | 0 | 2023-03-13 20:38:18 | |
2278 | 2278 | 503 | 1946-06-02 | 93 | 23 | 0 | 2023-03-13 20:38:18 | |
2279 | 2279 | 503 | 1946-06-02 | 618 | 1 | 0 | 2023-03-13 20:38:18 | |
2280 | 2280 | 503 | 1946-06-02 | 1330 | 7 | 0 | 2023-03-13 20:38:18 | |
2281 | 2281 | 503 | 1946-06-02 | 335 | 2 | 0 | 2023-03-13 20:38:18 | |
2282 | 2282 | 503 | 1946-06-02 | 1028 | 4 | 0 | 2023-03-13 20:38:18 | |
2283 | 2283 | 503 | 1946-06-02 | 487 | 42 | 0 | 2023-03-13 20:38:18 | |
2284 | 2284 | 503 | 1946-06-02 | 1050 | 16 | 0 | 2023-03-13 20:38:18 | |
2285 | 2285 | 503 | 1946-06-02 | 1088 | 104 | 0 | 2023-03-13 20:38:18 | |
2286 | 2286 | 503 | 1946-06-02 | 409 | 30 | 0 | 2023-03-13 20:38:18 | |
2287 | 2287 | 503 | 1946-06-02 | 1633 | 207 | 0 | 2023-03-13 20:38:18 | |
2288 | 2288 | 503 | 1946-06-02 | 1475 | 115 | 0 | 2023-03-13 20:38:18 | |
2289 | 2289 | 503 | 1946-06-02 | 2044 | 2 | 0 | 2023-03-13 20:38:18 | |
2290 | 2290 | 503 | 1946-06-02 | 2302 | 3 | 0 | 2023-03-13 20:38:18 | |
2473 | 2473 | 538 | 1990-06-09 | 1415 | 22 | 0 | 2023-03-13 20:38:18 | |
2474 | 2474 | 538 | 1990-06-09 | 559 | 14 | 0 | 2023-03-13 20:38:18 | |
2475 | 2475 | 538 | 1990-06-09 | 1072 | 22 | 0 | 2023-03-13 20:38:18 | |
2476 | 2476 | 538 | 1990-06-09 | 1432 | 31 | 0 | 2023-03-13 20:38:18 | |
2477 | 2477 | 538 | 1990-06-09 | 1000 | 7 | 0 | 2023-03-13 20:38:18 | |
2478 | 2478 | 538 | 1990-06-09 | 874 | 6 | 0 | 2023-03-13 20:38:18 | |
2479 | 2479 | 538 | 1990-06-09 | 1061 | 48 | 0 | 2023-03-13 20:38:18 | |
3026 | 3026 | 647 | 1990-04-29 | 288 | 15 | 0 | 2023-03-13 20:38:18 | |
3027 | 3027 | 647 | 1990-04-29 | 1260 | 55 | 0 | 2023-03-13 20:38:18 | |
3028 | 3028 | 647 | 1990-04-29 | 42 | 131 | 0 | 2023-03-13 20:38:18 | |
3040 | 3040 | 653 | 1974-11-17 | 1338 | 12 | 0 | 2023-03-13 20:38:18 | |
3041 | 3041 | 653 | 1974-11-17 | 489 | 60 | 0 | 2023-03-13 20:38:18 | |
3042 | 3042 | 653 | 1974-11-17 | 614 | 8 | 0 | 2023-03-13 20:38:18 | |
3043 | 3043 | 653 | 1974-11-17 | 47 | 220 | 0 | 2023-03-13 20:38:18 | |
3109 | 3109 | 670 | 1992-09-20 | 1448 | 12 | 0 | 2023-03-13 20:38:18 | |
3110 | 3110 | 670 | 1992-09-20 | 552 | 10 | 0 | 2023-03-13 20:38:18 | |
3111 | 3111 | 670 | 1992-09-20 | 1516 | 1 | 0 | 2023-03-13 20:38:18 | |
3112 | 3112 | 670 | 1992-09-20 | 1064 | 8 | 0 | 2023-03-13 20:38:18 | |
3113 | 3113 | 670 | 1992-09-20 | 486 | 17 | 0 | 2023-03-13 20:38:18 | |
3114 | 3114 | 670 | 1992-09-20 | 2631 | 1 | 0 | 2023-03-13 20:38:18 | |
3115 | 3115 | 670 | 1992-09-20 | 450 | 15 | 0 | 2023-03-13 20:38:18 | |
3116 | 3116 | 670 | 1992-09-20 | 25 | 8 | 0 | 2023-03-13 20:38:18 | |
3117 | 3117 | 670 | 1992-09-20 | 243 | 29 | 0 | 2023-03-13 20:38:18 | |
3239 | 3239 | 697 | 1946-04-10 | 1726 | 148 | 0 | 2023-03-13 20:38:18 | |
3240 | 3240 | 697 | 1946-04-10 | 1734 | 110 | 0 | 2023-03-13 20:38:18 | |
3241 | 3241 | 697 | 1946-04-10 | 940 | 96 | 0 | 2023-03-13 20:38:18 | |
3242 | 3242 | 697 | 1946-04-10 | 1733 | 45 | 0 | 2023-03-13 20:38:18 | |
3243 | 3243 | 697 | 1946-04-10 | 1540 | 6 | 0 | 2023-03-13 20:38:18 | |
3244 | 3244 | 697 | 1946-04-10 | 1055 | 33 | 0 | 2023-03-13 20:38:18 | |
3245 | 3245 | 697 | 1946-04-10 | 905 | 26 | 0 | 2023-03-13 20:38:18 | |
3926 | 3926 | 797 | 2000-01-03 | 276 | 46 | 0 | 2023-03-13 20:38:18 | |
3927 | 3927 | 797 | 2000-01-03 | 1493 | 44 | 0 | 2023-03-13 20:38:18 | |
3928 | 3928 | 797 | 2000-01-03 | 1102 | 24 | 0 | 2023-03-13 20:38:18 | |
3929 | 3929 | 797 | 2000-01-03 | 2196 | 2 | 0 | 2023-03-13 20:38:18 | |
3930 | 3930 | 797 | 2000-01-03 | 2295 | 1 | 0 | 2023-03-13 20:38:18 | |
3931 | 3931 | 797 | 2000-01-03 | 1465 | 17 | 0 | 2023-03-13 20:38:18 | |
3932 | 3932 | 797 | 2000-01-03 | 1384 | 2 | 0 | 2023-03-13 20:38:18 | |
3933 | 3933 | 797 | 2000-01-03 | 1457 | 2 | 0 | 2023-03-13 20:38:18 | |
3934 | 3934 | 797 | 2000-01-03 | 1627 | 4 | 0 | 2023-03-13 20:38:18 | |
3935 | 3935 | 797 | 2000-01-03 | 1044 | 5 | 0 | 2023-03-13 20:38:18 | |
3936 | 3936 | 797 | 2000-01-03 | 2192 | 1 | 0 | 2023-03-13 20:38:18 | |
3937 | 3937 | 797 | 2000-01-03 | 2197 | 3 | 0 | 2023-03-13 20:38:18 | |
4024 | 4024 | 813 | 1983-11-06 | 1334 | 211 | 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 );