party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by data_source
This data as json, CSV (advanced)
data_source (date) 0 ✖
Link | rowid | comment | data_source ▼ | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
64 | 64 | 1175 | 1193 | 2005-08-21 | 101 | |||
65 | 65 | 1313 | 917 | 2000-11-16 | 102 | |||
66 | 66 | 1313 | 774 | 2000-11-16 | 103 | |||
76 | 76 | 326 | 380 | 2007-12-10 | 113 | |||
77 | 77 | 1448 | 1257 | 1996-07-01 | 114 | |||
80 | 80 | 1120 | 1601 | 2001-01-16 | 122 | |||
81 | 81 | 1120 | 419 | 1992-04-07 | 123 | |||
85 | 85 | 382 | 809 | 2007-10-14 | 128 | |||
86 | 86 | 382 | 1005 | 2007-10-14 | 129 | |||
87 | 87 | 142 | 1633 | 1994-01-22 | 131 | |||
88 | 88 | 1005 | 142 | 2002-03-24 | 132 | |||
89 | 89 | 1005 | 630 | 2002-03-24 | 133 | |||
90 | 90 | 557 | 260 | 1999-03-24 | 134 | |||
91 | 91 | 1292 | 806 | 1990-04-29 | 135 | |||
92 | 92 | Founded in November 1985 by orthodox pro-Soviet minority faction expelled from SKP in late 1985 (Jacobs 1989, 534). | 806 | 1292 | 1985-11-13 | 136 | ||
94 | 94 | 547 | 1193 | 1993-06-23 | 143 | |||
95 | 95 | 1136 | 547 | 1994-12-10 | 144 | |||
97 | 97 | 1136 | 1327 | 1994-12-10 | 146 | |||
98 | 98 | 75% rule -- 1994 election: SI 7 MPs, PSDI 0.5% | 1278 | 242 | 1998-05-10 | 148 | ||
99 | 99 | 1661 | 1321 | 1998-10-11 | 149 | |||
104 | 104 | 399 | 1145 | 1999-05-23 | 154 | |||
107 | 107 | 191 | 1632 | 2001-12-15 | 159 | |||
108 | 108 | 191 | 1261 | 2001-12-15 | 160 | |||
109 | 109 | 910 | 1304 | 1990-12-09 | 161 | |||
110 | 110 | 910 | 325 | 1990-12-09 | 162 | |||
113 | 113 | In February 1965 the CNIP merged with the MRP to form the DC. It again left DC one year later. | 1491 | 1414 | 1966-07-01 | 167 | ||
114 | 114 | 752 | 131 | 2004-01-13 | 168 | |||
115 | 115 | 1283 | 528 | 2007-04-19 | 169 | |||
116 | 116 | 1206 | 625 | 2001-03-15 | 170 | |||
117 | 117 | 1206 | 212 | 2001-03-15 | 171 | |||
118 | 118 | 1110 | 63 | 1971-07-01 | 173 | |||
119 | 119 | 454 | 63 | 1971-07-01 | 174 | |||
121 | 121 | 139 | 200 | 1972-10-17 | 177 | |||
124 | 124 | 402 | 742 | 1970-04-04 | 181 | |||
125 | 125 | 235 | 300 | 1980-10-11 | 182 | |||
126 | 126 | 235 | 405 | 1980-10-11 | 183 | |||
127 | 127 | 235 | 451 | 1980-10-11 | 184 | |||
128 | 128 | 750 | 886 | 1971-09-22 | 185 | |||
131 | 131 | 1487 | 290 | 2001-11-11 | 189 | |||
132 | 132 | 1134 | 701 | 1970-05-02 | 192 | |||
136 | 136 | exact date of merger 1995-12-02 (wikipedia) | 846 | 552 | 1995-07-01 | 200 | ||
137 | 137 | exact date of change 1995-12-02 | 846 | 243 | 1995-07-01 | 201 | ||
138 | 138 | 773 | 1017 | 1968-07-01 | 203 | |||
139 | 139 | Founded by Konstantinos Stephanopoulos on September 6, 1985 after he left the New Democracy party in August 1985 (wikipedia) | 1374 | 47 | 1985-09-06 | 205 | ||
140 | 140 | Woolton-Teviot agreement May 1947 | 1017 | 659 | 1931-06-01 | 206 | ||
143 | 143 | 395 | 1108 | 1973-01-02 | 211 | |||
144 | 144 | 16 | 1047 | 2000-04-15 | 212 | |||
147 | 147 | 629 | 1077 | 1990-07-01 | 216 | |||
148 | 148 | 358 | 543 | 1956-02-23 | 218 | |||
149 | 149 | 912 | 358 | 1957-03-17 | 219 | |||
150 | 150 | 2 | 1245 | 2009-07-11 | 220 | |||
155 | 155 | 439 | 462 | 2003-09-26 | 226 | |||
159 | 159 | 1173 | 665 | 1990-03-31 | 231 | |||
161 | 161 | 1495 | 1142 | 1994-02-11 | 233 | |||
162 | 162 | 1228 | 1072 | 1993-12-24 | 234 | |||
164 | 164 | 143 | 1371 | 1991-10-01 | 237 | |||
166 | 166 | 278 | 32 | 1994-02-01 | 239 | |||
172 | 172 | 1701 | 912 | 1961-04-15 | 270 | |||
174 | 174 | 1255 | 794 | 2003-12-07 | 272 | |||
175 | 175 | 1255 | 897 | 2003-12-07 | 273 | |||
176 | 176 | 457 | 151 | 1999-01-30 | 274 | |||
177 | 177 | 53 | 1360 | 1968-10-01 | 275 | |||
178 | 178 | 421 | 1050 | 1954-07-01 | 276 | |||
181 | 181 | 831 | 1702 | 1972-07-10 | 279 | |||
182 | 182 | 1475 | 242 | 1966-10-30 | 280 | |||
183 | 183 | 1644 | 1239 | 1959-02-15 | 284 | |||
184 | 184 | 154 | 184 | 2008-07-26 | 285 | |||
185 | 185 | 154 | 1411 | 2008-07-26 | 286 | |||
186 | 186 | 968 | 1593 | 1972-12-01 | 287 | |||
187 | 187 | 1088 | 1593 | 1972-07-13 | 288 | |||
188 | 188 | 1593 | 1475 | 1964-01-12 | 289 | |||
189 | 189 | 242 | 1475 | 1947-01-11 | 290 | |||
194 | 194 | 462 | 1136 | 1998-01-06 | 296 | |||
199 | 199 | 955 | 50 | 1993-02-04 | 304 | |||
200 | 200 | 710 | 982 | 1997-02-22 | 305 | |||
207 | 207 | 1319 | 228 | 1938-07-01 | 314 | |||
208 | 208 | 1006 | 1360 | 2000-05-05 | 315 | |||
209 | 209 | 1006 | 228 | 2000-05-05 | 316 | |||
210 | 210 | 1006 | 147 | 2000-05-05 | 317 | |||
211 | 211 | 228 | 205 | 1996-10-02 | 318 | |||
212 | 212 | 205 | 228 | 1994-07-01 | 319 | |||
213 | 213 | 210 | 1360 | 1999-02-06 | 320 | |||
214 | 214 | 817 | 1455 | 1987-07-01 | 321 | |||
215 | 215 | 828 | 1342 | 1987-07-01 | 322 | |||
216 | 216 | 988 | 228 | 1983-07-01 | 323 | |||
219 | 219 | Election date used to set date of party change. | 1755 | 1726 | 1953-03-15 | 326 | ||
220 | 220 | 1734 | 1733 | 1950-04-01 | 328 | |||
222 | 222 | 1053 | 940 | 1960-01-24 | 330 | |||
223 | 223 | 1136 | 1053 | 1994-12-10 | 331 | |||
225 | 225 | 170 | 1193 | 1976-06-25 | 333 | |||
226 | 226 | 1193 | 170 | 1986-08-15 | 334 | |||
227 | 227 | 200 | 94 | 1959-02-09 | 335 | |||
228 | 228 | 1389 | 585 | 1973-10-24 | 336 | |||
229 | 229 | 229 | 806 | 1986-04-12 | 338 | |||
230 | 230 | 397 | 487 | 1993-05-27 | 339 | |||
231 | 231 | 1547 | 1556 | 1981-03-26 | 340 | |||
232 | 232 | 1450 | 749 | 1992-08-23 | 341 | |||
233 | 233 | 557 | 998 | 1999-03-24 | 346 | |||
235 | 235 | 81 | 1773 | 1975-03-16 | 350 | |||
241 | 241 | 47 | 463 | 1978-05-10 | 357 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");