party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows
This data as json, CSV (advanced)
Link | rowid ▼ | comment | data_source | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
201 | 201 | mackie | 1726 | 1734 | 1948-03-01 | 306 | ||
202 | 202 | mackie | 1734 | 1726 | 1947-03-01 | 308 | ||
203 | 203 | mackie | 1737 | 940 | 1948-03-01 | 309 | ||
204 | 204 | mackie | 1736 | 940 | 1948-12-01 | 310 | ||
205 | 205 | mackie | 940 | 1736 | 1957-01-01 | 311 | ||
206 | 206 | mackie | 1738 | 1734 | 1952-07-01 | 312 | ||
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 | |||
217 | 217 | nyt | 1722 | 1755 | 1954-11-24 | 324 | ||
218 | 218 | nyt | 1722 | 1734 | 1954-11-24 | 325 | ||
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 | |||
221 | 221 | mackie | 1724 | 1738 | 1955-07-01 | 329 | ||
222 | 222 | 1053 | 940 | 1960-01-24 | 330 | |||
223 | 223 | 1136 | 1053 | 1994-12-10 | 331 | |||
224 | 224 | indridason | 506 | 1342 | 1998-11-28 | 332 | ||
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 | |||
234 | 234 | snl | 1773 | 104 | 1961-04-01 | 349 | ||
235 | 235 | 81 | 1773 | 1975-03-16 | 350 | |||
236 | 236 | "(...) a group called Demokratiske Sosialister -- AIK) (the now autonomous successor to the Labour Movement Information Committee, which had worked against EC membership from within the Labour Party before finally leaving it) (...)" (Jacobs 1990, 597). | jacobs | 81 | 104 | 1972-07-01 | 352 | |
237 | 237 | "A large number, led by Reidar Larsen, then left the NKP to join up with SV." (Jacobs 1990, 597) | jacobs | 81 | 27 | 1975-07-01 | 353 | |
238 | 238 | "The Norwegian Communist Party (NKP) was founded in 1923 by members of the left wing of the Labour Party, when the latter finally broke with the Comintern" (Jacobs 1990, 599). | jacobs | 27 | 104 | 1923-11-04 | 354 | |
239 | 239 | reuters | 1412 | 47 | 1993-06-30 | 355 | ||
240 | 240 | ata | 47 | 1412 | 2004-07-01 | 356 | ||
241 | 241 | 47 | 463 | 1978-05-10 | 357 | |||
242 | 242 | 1441 | 252 | 1989-07-01 | 358 | |||
243 | 243 | 252 | 489 | 1979-07-01 | 359 | |||
244 | 244 | 1311 | 614 | 1968-07-01 | 360 | |||
245 | 245 | 211 | 1605 | 1905-05-21 | 362 | |||
246 | 246 | 538 | 1605 | 1953-07-01 | 363 | |||
247 | 247 | 637 | 135 | 1982-07-29 | 366 | |||
248 | 248 | 645 | 637 | 2006-02-18 | 367 | |||
249 | 249 | 845 | 1361 | 1986-09-04 | 368 | |||
250 | 250 | elpais | 902 | 1790 | 1978-04-25 | 369 | ||
251 | 251 | 647 | 1209 | 1988-06-05 | 370 | |||
252 | 252 | eed | 851 | 1777 | 1989-07-01 | 371 | ||
253 | 253 | eed | 1575 | 1778 | 1988-07-01 | 372 | ||
254 | 254 | 1523 | 1779 | 1996-07-01 | 374 | |||
255 | 255 | 512 | 1355 | 2001-01-24 | 376 | |||
256 | 256 | 512 | 1104 | 2001-01-24 | 377 | |||
257 | 257 | 1475 | 1330 | 1947-07-01 | 378 | |||
258 | 258 | 1382 | 462 | 2000-04-03 | 379 | |||
259 | 259 | 247 | 1193 | 2002-06-01 | 380 | |||
260 | 260 | 1136 | 837 | 1994-12-10 | 381 | |||
261 | 261 | 528 | 369 | 2001-07-01 | 382 | |||
262 | 262 | 229 | 1292 | 1986-09-05 | 383 | |||
263 | 263 | mackie | 1772 | 725 | 1979-07-01 | 384 | ||
264 | 264 | "Conservative Liberal minority starting a Liberal League (Vapaamielisten Liitto)" (Jacobs 1989, 540). | jacobs | 1109 | 1219 | 1951-07-01 | 386 | |
265 | 265 | mchale | 1219 | 1109 | 1965-12-29 | 387 | ||
266 | 266 | jacobs | 94 | 1219 | 1982-07-01 | 388 | ||
267 | 267 | jacobs | 1219 | 94 | 1986-07-01 | 389 | ||
268 | 268 | 1306 | 1253 | 1955-04-07 | 390 | |||
269 | 269 | 244 | 615 | 2005-05-23 | 393 | |||
270 | 270 | knesset | 244 | 1343 | 1968-01-23 | 397 | ||
271 | 271 | knesset | 678 | 765 | 1965-05-25 | 398 | ||
272 | 272 | knesset | 678 | 1204 | 1965-05-25 | 399 | ||
273 | 273 | knesset | 1472 | 1831 | 1951-09-10 | 400 | ||
274 | 274 | knesset | 1419 | 1168 | 1992-03-09 | 401 | ||
275 | 275 | apa | 1743 | 973 | 1965-09-07 | 405 | ||
276 | 276 | knesset | 765 | 1472 | 1961-05-08 | 406 | ||
277 | 277 | 214 | 1828 | 1956-07-01 | 407 | |||
278 | 278 | 214 | 1833 | 1956-07-01 | 408 | |||
279 | 279 | knesset | 678 | 277 | 2003-03-10 | 409 | ||
280 | 280 | knesset | 1343 | 1168 | 1954-08-23 | 411 | ||
281 | 281 | knesset | 2311 | 1838 | 1977-03-08 | 412 | ||
282 | 282 | knesset | 765 | 1822 | 1961-05-08 | 413 | ||
283 | 283 | knesset | 732 | 387 | 1965-09-01 | 414 | ||
284 | 284 | knesset | 767 | 244 | 1965-07-14 | 415 | ||
285 | 285 | knesset | 188 | 765 | 1965-03-16 | 418 | ||
286 | 286 | 1841 | 767 | 1969-07-01 | 419 | |||
287 | 287 | 184 | 1929 | 1920-07-01 | 420 | |||
288 | 288 | 184 | 1913 | 1920-07-01 | 421 | |||
289 | 289 | 184 | 1913 | 1920-07-01 | 422 | |||
290 | 290 | pr | 1945 | 512 | 2011-06-01 | 425 | ||
291 | 291 | sta | 1946 | 981 | 2008-03-01 | 426 | ||
292 | 292 | stgt | 308 | 141 | 2004-07-03 | 428 | ||
293 | 293 | ho-86 | 1167 | 35 | 1921-07-01 | 429 | ||
294 | 294 | his | 35 | 1951 | 1925-07-01 | 432 | ||
295 | 295 | 1957 | 750 | 1935-07-01 | 436 | |||
296 | 296 | teara | 1968 | 878 | 1940-03-25 | 437 | ||
297 | 297 | pol-hu | 1970 | 1591 | 2011-10-22 | 438 | ||
298 | 298 | nz-parl | 1972 | 114 | 2011-02-23 | 441 | ||
299 | 299 | 26 | 458 | 2009-01-01 | 446 | |||
300 | 300 | 524 | 1180 | 1983-11-27 | 448 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");