viewcalc_parliament_composition

Table actions

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

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