viewcalc_parliament_composition

Table actions

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

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

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