viewcalc_parliament_composition
Data source: ParlGov · About: simonw/parlgov-datasette
20,841 rows sorted by election_id
This data as json, CSV (advanced)
Link | rowid | election_id ▼ | date | party_id | seats | cabinet_id | cabinet_formation | calculation_date |
---|---|---|---|---|---|---|---|---|
13099 | 13099 | 19 | 1946-08-03 | 63 | 16 | 540 | 1 | 2023-03-13 20:38:18 |
13100 | 13100 | 19 | 1946-08-03 | 708 | 23 | 540 | 1 | 2023-03-13 20:38:18 |
13101 | 13101 | 19 | 1946-08-03 | 167 | 66 | 540 | 1 | 2023-03-13 20:38:18 |
13102 | 13102 | 19 | 1946-08-03 | 1051 | 92 | 540 | 1 | 2023-03-13 20:38:18 |
61 | 61 | 20 | 1981-06-21 | 138 | 80 | 1148 | 0 | 2023-03-13 20:38:18 |
62 | 62 | 20 | 1981-06-21 | 1539 | 268 | 1148 | 0 | 2023-03-13 20:38:18 |
63 | 63 | 20 | 1981-06-21 | 509 | 59 | 1148 | 0 | 2023-03-13 20:38:18 |
64 | 64 | 20 | 1981-06-21 | 686 | 43 | 1148 | 0 | 2023-03-13 20:38:18 |
65 | 65 | 20 | 1981-06-21 | 1492 | 14 | 1148 | 0 | 2023-03-13 20:38:18 |
66 | 66 | 20 | 1981-06-21 | 1414 | 10 | 1148 | 0 | 2023-03-13 20:38:18 |
6086 | 6086 | 20 | 1981-07-02 | 1539 | 285 | 116 | 0 | 2023-03-13 20:38:18 |
6087 | 6087 | 20 | 1981-07-02 | 138 | 88 | 116 | 0 | 2023-03-13 20:38:18 |
6088 | 6088 | 20 | 1981-07-02 | 509 | 62 | 116 | 0 | 2023-03-13 20:38:18 |
6089 | 6089 | 20 | 1981-07-02 | 686 | 44 | 116 | 0 | 2023-03-13 20:38:18 |
6090 | 6090 | 20 | 1981-07-02 | 947 | 12 | 116 | 0 | 2023-03-13 20:38:18 |
10230 | 10230 | 20 | 1981-06-23 | 138 | 80 | 116 | 1 | 2023-03-13 20:38:18 |
10231 | 10231 | 20 | 1981-06-23 | 1539 | 268 | 116 | 1 | 2023-03-13 20:38:18 |
10232 | 10232 | 20 | 1981-06-23 | 509 | 59 | 116 | 1 | 2023-03-13 20:38:18 |
10233 | 10233 | 20 | 1981-06-23 | 686 | 43 | 116 | 1 | 2023-03-13 20:38:18 |
10234 | 10234 | 20 | 1981-06-23 | 1492 | 14 | 116 | 1 | 2023-03-13 20:38:18 |
10235 | 10235 | 20 | 1981-06-23 | 1414 | 10 | 116 | 1 | 2023-03-13 20:38:18 |
12310 | 12310 | 20 | 1983-03-22 | 1539 | 285 | 428 | 1 | 2023-03-13 20:38:18 |
12311 | 12311 | 20 | 1983-03-22 | 138 | 88 | 428 | 1 | 2023-03-13 20:38:18 |
12312 | 12312 | 20 | 1983-03-22 | 509 | 62 | 428 | 1 | 2023-03-13 20:38:18 |
12313 | 12313 | 20 | 1983-03-22 | 686 | 44 | 428 | 1 | 2023-03-13 20:38:18 |
12314 | 12314 | 20 | 1983-03-22 | 947 | 12 | 428 | 1 | 2023-03-13 20:38:18 |
15053 | 15053 | 20 | 1984-07-17 | 1539 | 285 | 843 | 1 | 2023-03-13 20:38:18 |
15054 | 15054 | 20 | 1984-07-17 | 138 | 88 | 843 | 1 | 2023-03-13 20:38:18 |
15055 | 15055 | 20 | 1984-07-17 | 509 | 62 | 843 | 1 | 2023-03-13 20:38:18 |
15056 | 15056 | 20 | 1984-07-17 | 686 | 44 | 843 | 1 | 2023-03-13 20:38:18 |
15057 | 15057 | 20 | 1984-07-17 | 947 | 12 | 843 | 1 | 2023-03-13 20:38:18 |
67 | 67 | 21 | 1951-10-28 | 1167 | 5 | 556 | 0 | 2023-03-13 20:38:18 |
68 | 68 | 21 | 1951-10-28 | 531 | 48 | 556 | 0 | 2023-03-13 20:38:18 |
69 | 69 | 21 | 1951-10-28 | 602 | 1 | 556 | 0 | 2023-03-13 20:38:18 |
70 | 70 | 21 | 1951-10-28 | 26 | 51 | 556 | 0 | 2023-03-13 20:38:18 |
71 | 71 | 21 | 1951-10-28 | 458 | 5 | 556 | 0 | 2023-03-13 20:38:18 |
72 | 72 | 21 | 1951-10-28 | 886 | 4 | 556 | 0 | 2023-03-13 20:38:18 |
73 | 73 | 21 | 1951-10-28 | 35 | 49 | 556 | 0 | 2023-03-13 20:38:18 |
74 | 74 | 21 | 1951-10-28 | 750 | 23 | 556 | 0 | 2023-03-13 20:38:18 |
75 | 75 | 21 | 1951-10-28 | 1264 | 10 | 556 | 0 | 2023-03-13 20:38:18 |
14839 | 14839 | 21 | 1951-12-13 | 1167 | 5 | 814 | 1 | 2023-03-13 20:38:18 |
14840 | 14840 | 21 | 1951-12-13 | 531 | 48 | 814 | 1 | 2023-03-13 20:38:18 |
14841 | 14841 | 21 | 1951-12-13 | 602 | 1 | 814 | 1 | 2023-03-13 20:38:18 |
14842 | 14842 | 21 | 1951-12-13 | 26 | 51 | 814 | 1 | 2023-03-13 20:38:18 |
14843 | 14843 | 21 | 1951-12-13 | 458 | 5 | 814 | 1 | 2023-03-13 20:38:18 |
14844 | 14844 | 21 | 1951-12-13 | 886 | 4 | 814 | 1 | 2023-03-13 20:38:18 |
14845 | 14845 | 21 | 1951-12-13 | 35 | 49 | 814 | 1 | 2023-03-13 20:38:18 |
14846 | 14846 | 21 | 1951-12-13 | 750 | 23 | 814 | 1 | 2023-03-13 20:38:18 |
14847 | 14847 | 21 | 1951-12-13 | 1264 | 10 | 814 | 1 | 2023-03-13 20:38:18 |
76 | 76 | 24 | 1995-03-19 | 94 | 44 | 206 | 0 | 2023-03-13 20:38:18 |
77 | 77 | 24 | 1995-03-19 | 1292 | 22 | 206 | 0 | 2023-03-13 20:38:18 |
78 | 78 | 24 | 1995-03-19 | 1463 | 7 | 206 | 0 | 2023-03-13 20:38:18 |
79 | 79 | 24 | 1995-03-19 | 66 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
80 | 80 | 24 | 1995-03-19 | 1062 | 9 | 206 | 0 | 2023-03-13 20:38:18 |
81 | 81 | 24 | 1995-03-19 | 200 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
82 | 82 | 24 | 1995-03-19 | 585 | 11 | 206 | 0 | 2023-03-13 20:38:18 |
83 | 83 | 24 | 1995-03-19 | 1009 | 2 | 206 | 0 | 2023-03-13 20:38:18 |
84 | 84 | 24 | 1995-03-19 | 1105 | 1 | 206 | 0 | 2023-03-13 20:38:18 |
85 | 85 | 24 | 1995-03-19 | 395 | 63 | 206 | 0 | 2023-03-13 20:38:18 |
86 | 86 | 24 | 1995-03-19 | 1118 | 39 | 206 | 0 | 2023-03-13 20:38:18 |
10123 | 10123 | 24 | 1995-04-13 | 94 | 44 | 100 | 1 | 2023-03-13 20:38:18 |
10124 | 10124 | 24 | 1995-04-13 | 1292 | 22 | 100 | 1 | 2023-03-13 20:38:18 |
10125 | 10125 | 24 | 1995-04-13 | 1463 | 7 | 100 | 1 | 2023-03-13 20:38:18 |
10126 | 10126 | 24 | 1995-04-13 | 66 | 1 | 100 | 1 | 2023-03-13 20:38:18 |
10127 | 10127 | 24 | 1995-04-13 | 1062 | 9 | 100 | 1 | 2023-03-13 20:38:18 |
10128 | 10128 | 24 | 1995-04-13 | 200 | 1 | 100 | 1 | 2023-03-13 20:38:18 |
10129 | 10129 | 24 | 1995-04-13 | 585 | 11 | 100 | 1 | 2023-03-13 20:38:18 |
10130 | 10130 | 24 | 1995-04-13 | 1009 | 2 | 100 | 1 | 2023-03-13 20:38:18 |
10131 | 10131 | 24 | 1995-04-13 | 1105 | 1 | 100 | 1 | 2023-03-13 20:38:18 |
10132 | 10132 | 24 | 1995-04-13 | 395 | 63 | 100 | 1 | 2023-03-13 20:38:18 |
10133 | 10133 | 24 | 1995-04-13 | 1118 | 39 | 100 | 1 | 2023-03-13 20:38:18 |
87 | 87 | 25 | 1990-02-18 | 1540 | 16 | 106 | 0 | 2023-03-13 20:38:18 |
88 | 88 | 25 | 1990-02-18 | 940 | 136 | 106 | 0 | 2023-03-13 20:38:18 |
89 | 89 | 25 | 1990-02-18 | 905 | 21 | 106 | 0 | 2023-03-13 20:38:18 |
90 | 90 | 25 | 1990-02-18 | 837 | 45 | 106 | 0 | 2023-03-13 20:38:18 |
91 | 91 | 25 | 1990-02-18 | 86 | 4 | 106 | 0 | 2023-03-13 20:38:18 |
92 | 92 | 25 | 1990-02-18 | 2297 | 1 | 106 | 0 | 2023-03-13 20:38:18 |
93 | 93 | 25 | 1990-02-18 | 1193 | 275 | 106 | 0 | 2023-03-13 20:38:18 |
94 | 94 | 25 | 1990-02-18 | 1053 | 14 | 106 | 0 | 2023-03-13 20:38:18 |
5955 | 5955 | 25 | 1992-07-26 | 1193 | 278 | 253 | 0 | 2023-03-13 20:38:18 |
5956 | 5956 | 25 | 1992-07-26 | 940 | 138 | 253 | 0 | 2023-03-13 20:38:18 |
5957 | 5957 | 25 | 1992-07-26 | 837 | 46 | 253 | 0 | 2023-03-13 20:38:18 |
5958 | 5958 | 25 | 1992-07-26 | 1540 | 16 | 253 | 0 | 2023-03-13 20:38:18 |
5959 | 5959 | 25 | 1992-07-26 | 1053 | 14 | 253 | 0 | 2023-03-13 20:38:18 |
5960 | 5960 | 25 | 1992-07-26 | 905 | 10 | 253 | 0 | 2023-03-13 20:38:18 |
5961 | 5961 | 25 | 1992-07-26 | 1812 | 10 | 253 | 0 | 2023-03-13 20:38:18 |
10923 | 10923 | 25 | 1990-02-28 | 1540 | 16 | 213 | 1 | 2023-03-13 20:38:18 |
10924 | 10924 | 25 | 1990-02-28 | 940 | 136 | 213 | 1 | 2023-03-13 20:38:18 |
10925 | 10925 | 25 | 1990-02-28 | 905 | 21 | 213 | 1 | 2023-03-13 20:38:18 |
10926 | 10926 | 25 | 1990-02-28 | 837 | 45 | 213 | 1 | 2023-03-13 20:38:18 |
10927 | 10927 | 25 | 1990-02-28 | 86 | 4 | 213 | 1 | 2023-03-13 20:38:18 |
10928 | 10928 | 25 | 1990-02-28 | 2297 | 1 | 213 | 1 | 2023-03-13 20:38:18 |
10929 | 10929 | 25 | 1990-02-28 | 1193 | 275 | 213 | 1 | 2023-03-13 20:38:18 |
10930 | 10930 | 25 | 1990-02-28 | 1053 | 14 | 213 | 1 | 2023-03-13 20:38:18 |
11164 | 11164 | 25 | 1991-11-05 | 1540 | 16 | 253 | 1 | 2023-03-13 20:38:18 |
11165 | 11165 | 25 | 1991-11-05 | 940 | 136 | 253 | 1 | 2023-03-13 20:38:18 |
11166 | 11166 | 25 | 1991-11-05 | 905 | 21 | 253 | 1 | 2023-03-13 20:38:18 |
11167 | 11167 | 25 | 1991-11-05 | 837 | 45 | 253 | 1 | 2023-03-13 20:38:18 |
11168 | 11168 | 25 | 1991-11-05 | 86 | 4 | 253 | 1 | 2023-03-13 20:38:18 |
11169 | 11169 | 25 | 1991-11-05 | 2297 | 1 | 253 | 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 );