Data source: ParlGov · About: simonw/parlgov-datasette

20,107 rows

View and edit SQL

Link rowid ▼ election_id date party_id seats cabinet_id cabinet_formation calculation_date
101 30 1955-10-30 1264 10 814 0 2020-10-20 18:39:58
102 30 1955-10-30 531 47 814 0 2020-10-20 18:39:58
103 30 1955-10-30 886 4 814 0 2020-10-20 18:39:58
104 30 1955-10-30 26 50 814 0 2020-10-20 18:39:58
105 30 1955-10-30 35 53 814 0 2020-10-20 18:39:58
106 30 1955-10-30 1167 4 814 0 2020-10-20 18:39:58
107 30 1955-10-30 750 22 814 0 2020-10-20 18:39:58
108 30 1955-10-30 458 5 814 0 2020-10-20 18:39:58
109 32 1991-10-13 1286 24   0 2020-10-20 18:39:58
110 32 1991-10-13 1160 106   0 2020-10-20 18:39:58
111 32 1991-10-13 423 110   0 2020-10-20 18:39:58
112 33 1998-09-20 882 43 156 0 2020-10-20 18:39:58
113 33 1998-09-20 1461 18 156 0 2020-10-20 18:39:58
114 33 1998-09-20 904 131 156 0 2020-10-20 18:39:58
115 33 1998-09-20 282 42 156 0 2020-10-20 18:39:58
116 33 1998-09-20 892 17 156 0 2020-10-20 18:39:58
117 33 1998-09-20 1154 16 156 0 2020-10-20 18:39:58
118 33 1998-09-20 657 82 156 0 2020-10-20 18:39:58
119 35 1946-06-30 1319 10 703 1 2020-10-20 18:39:58
120 35 1946-06-30 228 9 703 1 2020-10-20 18:39:58
121 35 1946-06-30 1342 20 703 1 2020-10-20 18:39:58
122 35 1946-06-30 1455 13 703 1 2020-10-20 18:39:58
123 36 2009-04-25 1455 9 651 1 2020-10-20 18:39:58
124 36 2009-04-25 1342 16 651 1 2020-10-20 18:39:58
125 36 2009-04-25 210 14 651 1 2020-10-20 18:39:58
126 36 2009-04-25 1006 20 651 1 2020-10-20 18:39:58
127 36 2009-04-25 587 4 651 1 2020-10-20 18:39:58
128 39 1992-06-06 1218 16 262 0 2020-10-20 18:39:58
129 39 1992-06-06 19 14 262 0 2020-10-20 18:39:58
130 39 1992-06-06 1245 15 262 0 2020-10-20 18:39:58
131 39 1992-06-06 1123 14 262 0 2020-10-20 18:39:58
132 39 1992-06-06 1173 35 262 0 2020-10-20 18:39:58
133 39 1992-06-06 829 66 262 0 2020-10-20 18:39:58
134 39 1992-06-06 789 16 262 0 2020-10-20 18:39:58
135 39 1992-06-06 872 14 262 0 2020-10-20 18:39:58
136 39 1992-06-06 440 10 262 0 2020-10-20 18:39:58
137 40 1974-10-10 646 3 7 1 2020-10-20 18:39:58
138 40 1974-10-10 1210 6 7 1 2020-10-20 18:39:58
139 40 1974-10-10 319 1 7 1 2020-10-20 18:39:58
140 40 1974-10-10 1284 11 7 1 2020-10-20 18:39:58
141 40 1974-10-10 1556 319 7 1 2020-10-20 18:39:58
142 40 1974-10-10 311 3 7 1 2020-10-20 18:39:58
143 40 1974-10-10 659 13 7 1 2020-10-20 18:39:58
144 40 1974-10-10 1023 1 7 1 2020-10-20 18:39:58
145 40 1974-10-10 773 277 7 1 2020-10-20 18:39:58
146 40 1974-10-10 1599 1 7 1 2020-10-20 18:39:58
147 42 1977-06-15 118 19   0 2020-10-20 18:39:58
148 42 1977-06-15 902 118   0 2020-10-20 18:39:58
149 42 1977-06-15 135 166   0 2020-10-20 18:39:58
150 42 1977-06-15 62 2   0 2020-10-20 18:39:58
151 42 1977-06-15 1361 8   0 2020-10-20 18:39:58
152 42 1977-06-15 1221 1   0 2020-10-20 18:39:58
153 42 1977-06-15 645 16   0 2020-10-20 18:39:58
154 42 1977-06-15 1377 1   0 2020-10-20 18:39:58
155 42 1977-06-15 894 11   0 2020-10-20 18:39:58
156 42 1977-06-15 1026 1   0 2020-10-20 18:39:58
157 42 1977-06-15 1790 6   0 2020-10-20 18:39:58
158 42 1977-06-15 757 1   0 2020-10-20 18:39:58
159 43 1987-02-17 379 1 867 0 2020-10-20 18:39:58
160 43 1987-02-17 1393 51 867 0 2020-10-20 18:39:58
161 43 1987-02-17 318 12 867 0 2020-10-20 18:39:58
162 43 1987-02-17 651 14 867 0 2020-10-20 18:39:58
163 43 1987-02-17 433 4 867 0 2020-10-20 18:39:58
164 43 1987-02-17 280 81 867 0 2020-10-20 18:39:58
165 43 1987-02-17 30 3 867 0 2020-10-20 18:39:58
166 47 1981-06-11 2298 1 442 0 2020-10-20 18:39:58
167 47 1981-06-11 1323 2 442 0 2020-10-20 18:39:58
168 47 1981-06-11 280 78 442 0 2020-10-20 18:39:58
169 47 1981-06-11 30 4 442 0 2020-10-20 18:39:58
170 47 1981-06-11 433 1 442 0 2020-10-20 18:39:58
171 47 1981-06-11 318 15 442 0 2020-10-20 18:39:58
172 47 1981-06-11 1393 65 442 0 2020-10-20 18:39:58
173 48 1985-09-15 282 1 296 1 2020-10-20 18:39:58
174 48 1985-09-15 657 76 296 1 2020-10-20 18:39:58
175 48 1985-09-15 882 19 296 1 2020-10-20 18:39:58
176 48 1985-09-15 1461 43 296 1 2020-10-20 18:39:58
177 48 1985-09-15 892 51 296 1 2020-10-20 18:39:58
178 48 1985-09-15 904 159 296 1 2020-10-20 18:39:58
179 50 2006-06-03 789 74 15 0 2020-10-20 18:39:58
180 50 2006-06-03 1245 13 15 0 2020-10-20 18:39:58
181 50 2006-06-03 829 81 15 0 2020-10-20 18:39:58
182 50 2006-06-03 1173 26 15 0 2020-10-20 18:39:58
183 50 2006-06-03 196 6 15 0 2020-10-20 18:39:58
184 51 1972-11-29 1452 2 291 0 2020-10-20 18:39:58
185 51 1972-11-29 342 7 291 0 2020-10-20 18:39:58
186 51 1972-11-29 1194 7 291 0 2020-10-20 18:39:58
187 51 1972-11-29 742 43 291 0 2020-10-20 18:39:58
188 51 1972-11-29 1251 3 291 0 2020-10-20 18:39:58
189 51 1972-11-29 300 14 291 0 2020-10-20 18:39:58
190 51 1972-11-29 1595 3 291 0 2020-10-20 18:39:58
191 51 1972-11-29 1409 22 291 0 2020-10-20 18:39:58
192 51 1972-11-29 405 7 291 0 2020-10-20 18:39:58
193 51 1972-11-29 625 2 291 0 2020-10-20 18:39:58
194 51 1972-11-29 402 6 291 0 2020-10-20 18:39:58
195 51 1972-11-29 345 6 291 0 2020-10-20 18:39:58
196 51 1972-11-29 451 27 291 0 2020-10-20 18:39:58
197 51 1972-11-29 2288 1 291 0 2020-10-20 18:39:58
198 52 2006-10-07 1520 6 535 0 2020-10-20 18:39:58
199 52 2006-10-07 1518 18 535 0 2020-10-20 18:39:58
200 52 2006-10-07 521 8 535 0 2020-10-20 18:39:58

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE `viewcalc_parliament_composition` (
  `election_id` INTEGER,
  `date` TEXT,
  `party_id` INTEGER,
  `seats` INTEGER,
  `cabinet_id` INTEGER,
  `cabinet_formation` INTEGER,
  `calculation_date` TEXT
);