viewcalc_parliament_composition

Table actions

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

20,502 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
);