party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by data_source descending
This data as json, CSV (advanced)
Suggested facets: description, date (date)
data_source (date) 0 ✖
Link | rowid | comment | data_source ▲ | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
340 | 340 | yomiuri | 2069 | 439 | 2012-07-02 | 498 | ||
834 | 834 | wid | 2713 | 2692 | 1929-12-28 | 1076 | ||
372 | 372 | times | 651 | 280 | 1985-12-22 | 538 | ||
296 | 296 | teara | 1968 | 878 | 1940-03-25 | 437 | ||
374 | 374 | teara | 891 | 997 | 1993-07-01 | 541 | ||
398 | 398 | tasr | 131 | 1495 | 2000-08-20 | 591 | ||
405 | 405 | 8 MPs were expelled from SNS. | tasr | 20 | 1072 | 2001-07-28 | 599 | |
406 | 406 | tasr | 1072 | 20 | 2003-05-31 | 600 | ||
463 | 463 | tagbla | 2257 | 1582 | 2013-06-21 | 671 | ||
292 | 292 | stgt | 308 | 141 | 2004-07-03 | 428 | ||
291 | 291 | sta | 1946 | 981 | 2008-03-01 | 426 | ||
562 | 562 | sta | 2337 | 1987 | 2014-05-31 | 789 | ||
234 | 234 | snl | 1773 | 104 | 1961-04-01 | 349 | ||
415 | 415 | rose | 2177 | 2175 | 1994-07-01 | 612 | ||
651 | 651 | rose | ASZ was absorbed by MSZP in 1998 (Rose/Munro 2009:148). | 1591 | 1183 | 1998-07-01 | 884 | |
654 | 654 | rose | 2417 | 1368 | 1994-07-01 | 887 | ||
656 | 656 | rose | 675 | 493 | 2001-07-01 | 889 | ||
142 | 142 | rferl | 1108 | 395 | 1957-04-21 | 210 | ||
141 | 141 | reuters | 1047 | 16 | 2000-08-04 | 209 | ||
239 | 239 | reuters | 1412 | 47 | 1993-06-30 | 355 | ||
310 | 310 | reuters | 1779 | 572 | 1990-02-01 | 459 | ||
334 | 334 | reuters | 2061 | 773 | 1999-03-10 | 491 | ||
343 | 343 | Four MP SDF party group joined JNP (Reuters 1994-04-11). | reuters | 1327 | 86 | 1994-07-01 | 502 | |
348 | 348 | reuters | 1171 | 1444 | 1997-11-23 | 508 | ||
350 | 350 | reuters | 774 | 997 | 1995-05-08 | 512 | ||
351 | 351 | reuters | 917 | 997 | 1995-06-27 | 513 | ||
371 | 371 | reuters | 1418 | 978 | 1995-10-06 | 537 | ||
421 | 421 | reuters | 596 | 373 | 2009-03-29 | 618 | ||
475 | 475 | reuters | 2268 | 596 | 2013-11-15 | 683 | ||
500 | 500 | reuters | 1315 | 1122 | 2001-07-20 | 718 | ||
626 | 626 | reuters | Georgi Parvanov | 2364 | 982 | 2014-07-01 | 856 | |
720 | 720 | reuters | 2596 | 1592 | 2015-08-21 | 957 | ||
863 | 863 | reuters | 2794 | 382 | 2019-09-18 | 1109 | ||
170 | 170 | pr | 1679 | 528 | 2010-11-16 | 254 | ||
290 | 290 | pr | 1945 | 512 | 2011-06-01 | 425 | ||
297 | 297 | pol-hu | 1970 | 1591 | 2011-10-22 | 438 | ||
565 | 565 | pol-hu | 2349 | 403 | 2013-02-11 | 792 | ||
559 | 559 | pnbbae | 2331 | 512 | 2013-12-07 | 784 | ||
560 | 560 | pnbbae | 2331 | 528 | 2013-12-07 | 785 | ||
171 | 171 | phb | 1701 | 1507 | 1961-04-15 | 269 | ||
173 | 173 | phb | 558 | 238 | 1957-05-18 | 271 | ||
192 | 192 | phb | 1537 | 187 | 1964-11-28 | 294 | ||
193 | 193 | phb | 1506 | 1537 | 1971-01-16 | 295 | ||
377 | 377 | phb | 238 | 808 | 1952-11-29 | 546 | ||
378 | 378 | phb | 238 | 137 | 1952-11-29 | 547 | ||
325 | 325 | papo | 1501 | 1409 | 2004-09-02 | 481 | ||
358 | 358 | Hans Janmaat (CP) joined CD party group on 15 October 1984. | papo | 209 | 275 | 1984-10-15 | 521 | |
154 | 154 | nzz | 1213 | 750 | 2008-11-01 | 225 | ||
337 | 337 | nzz | 267 | 1557 | 1994-11-01 | 494 | ||
349 | 349 | nzpa | 354 | 1444 | 2002-04-03 | 511 | ||
341 | 341 | nzhe | 1171 | 1761 | 1990-05-18 | 499 | ||
344 | 344 | nzhe | 930 | 878 | 1989-05-01 | 503 | ||
345 | 345 | nzhe | 1444 | 930 | 1991-12-01 | 504 | ||
346 | 346 | nzhe | 1444 | 1636 | 1991-12-01 | 505 | ||
347 | 347 | nzhe | 1444 | 1171 | 1991-12-01 | 507 | ||
298 | 298 | nz-parl | 1972 | 114 | 2011-02-23 | 441 | ||
57 | 57 | 6 SF MPs formed a new party group on 17 December 1967. | nyt | 189 | 1644 | 1967-12-17 | 90 | |
179 | 179 | nyt | 1702 | 421 | 1959-04-11 | 277 | ||
180 | 180 | nyt | 1702 | 1050 | 1959-04-11 | 278 | ||
195 | 195 | nyt | 940 | 1724 | 1955-10-13 | 299 | ||
196 | 196 | nyt | 940 | 1723 | 1955-10-13 | 300 | ||
217 | 217 | nyt | 1722 | 1755 | 1954-11-24 | 324 | ||
218 | 218 | nyt | 1722 | 1734 | 1954-11-24 | 325 | ||
627 | 627 | nyt | 2358 | 1094 | 1952-03-06 | 857 | ||
71 | 71 | no-2010 | 1580 | 433 | 1992-07-01 | 108 | ||
411 | 411 | no-2010 | 967 | 2140 | 1955-07-01 | 608 | ||
412 | 412 | no-2010 | 2174 | 423 | 1991-07-01 | 609 | ||
413 | 413 | no-2010 | 2175 | 423 | 1991-07-01 | 610 | ||
693 | 693 | no-2010 | 2529 | 2527 | 1925-02-01 | 929 | ||
694 | 694 | no-2010 | 2538 | 2450 | 1931-06-01 | 930 | ||
695 | 695 | no-2010 | PL was led by Nicolas Mathieu, a former member of the PNI. | 2140 | 2450 | 1937-06-01 | 932 | |
696 | 696 | no-2010 | 2536 | 2527 | 1931-06-01 | 933 | ||
697 | 697 | no-2010 | 2448 | 2527 | 1937-06-01 | 934 | ||
711 | 711 | no-2010 | 220 | 1415 | 2004-12-04 | 948 | ||
190 | 190 | no-2001 | 1724 | 940 | 1951-07-01 | 292 | ||
191 | 191 | no-2001 | 1723 | 940 | 1951-07-01 | 293 | ||
265 | 265 | mchale | 1219 | 1109 | 1965-12-29 | 387 | ||
308 | 308 | mchale | 2004 | 1342 | 1941-07-01 | 457 | ||
309 | 309 | mchale | 2005 | 1342 | 1953-07-01 | 458 | ||
314 | 314 | mchale | 342 | 451 | 1968-04-27 | 464 | ||
381 | 381 | mchale | 53 | 1172 | 1968-10-01 | 550 | ||
660 | 660 | mchale | 1342 | 2561 | 1924-07-01 | 893 | ||
872 | 872 | mchale | 1342 | 2440 | 1924-07-01 | 1118 | ||
197 | 197 | mackie | 1193 | 1722 | 1955-11-15 | 301 | ||
198 | 198 | mackie | 1193 | 1726 | 1955-11-15 | 302 | ||
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 | ||
221 | 221 | mackie | 1724 | 1738 | 1955-07-01 | 329 | ||
263 | 263 | mackie | 1772 | 725 | 1979-07-01 | 384 | ||
382 | 382 | mackie | 2116 | 1455 | 1987-03-01 | 551 | ||
716 | 716 | mackie | 401 | 2594 | 1945-07-01 | 953 | ||
742 | 742 | mackie | 2584 | 686 | 1930-12-21 | 979 | ||
336 | 336 | Two MPs (Maris Gulbis and Inara Ostrovska) left New Era (JL) and later formed New Democrats (JD). | leta | 1294 | 1518 | 2004-10-01 | 493 | |
338 | 338 | kyodo | 2068 | 1136 | 1998-01-05 | 495 | ||
339 | 339 | kyodo | 439 | 1146 | 1996-09-28 | 496 | ||
270 | 270 | knesset | 244 | 1343 | 1968-01-23 | 397 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");