viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
12,574 rows where cabinet_formation = 1
This data as json, CSV (advanced)
Link | rowid ▼ | election_id | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
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 |
1135 | 1135 | 244 | 1951-05-06 | 984 | 15 | 1472 | 1 | 2023-03-13 20:38:18 |
1136 | 1136 | 244 | 1951-05-06 | 1003 | 14 | 1472 | 1 | 2023-03-13 20:38:18 |
1137 | 1137 | 244 | 1951-05-06 | 1274 | 7 | 1472 | 1 | 2023-03-13 20:38:18 |
1145 | 1145 | 247 | 1975-04-25 | 725 | 116 | 1477 | 1 | 2023-03-13 20:38:18 |
1146 | 1146 | 247 | 1975-04-25 | 260 | 1 | 1477 | 1 | 2023-03-13 20:38:18 |
1147 | 1147 | 247 | 1975-04-25 | 514 | 30 | 1477 | 1 | 2023-03-13 20:38:18 |
1148 | 1148 | 247 | 1975-04-25 | 1281 | 5 | 1477 | 1 | 2023-03-13 20:38:18 |
1149 | 1149 | 247 | 1975-04-25 | 1273 | 81 | 1477 | 1 | 2023-03-13 20:38:18 |
1150 | 1150 | 247 | 1975-04-25 | 2291 | 1 | 1477 | 1 | 2023-03-13 20:38:18 |
1151 | 1151 | 247 | 1975-04-25 | 251 | 16 | 1477 | 1 | 2023-03-13 20:38:18 |
1160 | 1160 | 251 | 1958-06-01 | 892 | 38 | 208 | 1 | 2023-03-13 20:38:18 |
1161 | 1161 | 251 | 1958-06-01 | 657 | 45 | 208 | 1 | 2023-03-13 20:38:18 |
1162 | 1162 | 251 | 1958-06-01 | 1461 | 32 | 208 | 1 | 2023-03-13 20:38:18 |
1163 | 1163 | 251 | 1958-06-01 | 882 | 5 | 208 | 1 | 2023-03-13 20:38:18 |
1164 | 1164 | 251 | 1958-06-01 | 904 | 111 | 208 | 1 | 2023-03-13 20:38:18 |
1205 | 1205 | 258 | 1970-09-20 | 657 | 41 | 577 | 1 | 2023-03-13 20:38:18 |
1206 | 1206 | 258 | 1970-09-20 | 904 | 163 | 577 | 1 | 2023-03-13 20:38:18 |
1207 | 1207 | 258 | 1970-09-20 | 1461 | 71 | 577 | 1 | 2023-03-13 20:38:18 |
1208 | 1208 | 258 | 1970-09-20 | 882 | 17 | 577 | 1 | 2023-03-13 20:38:18 |
1209 | 1209 | 258 | 1970-09-20 | 892 | 58 | 577 | 1 | 2023-03-13 20:38:18 |
1262 | 1262 | 272 | 1953-12-14 | 984 | 18 | 1473 | 1 | 2023-03-13 20:38:18 |
1263 | 1263 | 272 | 1953-12-14 | 1003 | 19 | 1473 | 1 | 2023-03-13 20:38:18 |
1264 | 1264 | 272 | 1953-12-14 | 1274 | 3 | 1473 | 1 | 2023-03-13 20:38:18 |
1279 | 1279 | 281 | 1980-10-05 | 251 | 46 | 328 | 1 | 2023-03-13 20:38:18 |
1280 | 1280 | 281 | 1980-10-05 | 622 | 4 | 328 | 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 );