viewcalc_parliament_composition

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

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
);
Powered by Datasette · Query took 4.499ms · Data source: ParlGov · About: simonw/parlgov-datasette