party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by date descending
This data as json, CSV (advanced)
Link | rowid | comment | data_source | description | party_id_new | party_id | date ▲ | id |
---|---|---|---|---|---|---|---|---|
748 | 748 | hurriyet | BDP MPs join HDP | 2572 | 2305 | 2014-04-28 | 985 | |
561 | 561 | apa | 2255 | 955 | 2014-01-15 | 788 | ||
563 | 563 | 2339 | 1536 | 2013-12-23 | 790 | |||
632 | 632 | 2380 | 645 | 2013-12-16 | 862 | |||
881 | 881 | 2392 | 1666 | 2013-12-15 | 1127 | |||
559 | 559 | pnbbae | 2331 | 512 | 2013-12-07 | 784 | ||
560 | 560 | pnbbae | 2331 | 528 | 2013-12-07 | 785 | ||
704 | 704 | 2567 | 211 | 2013-11-27 | 941 | |||
475 | 475 | reuters | 2268 | 596 | 2013-11-15 | 683 | ||
633 | 633 | 2382 | 1493 | 2013-10-29 | 863 | |||
634 | 634 | 2387 | 1272 | 2013-07-01 | 864 | |||
905 | 905 | Radim Fiala | 2654 | 2262 | 2013-07-01 | 1158 | ||
463 | 463 | tagbla | 2257 | 1582 | 2013-06-21 | 671 | ||
611 | 611 | 2341 | 572 | 2013-04-28 | 839 | |||
629 | 629 | 2370 | 318 | 2013-04-05 | 859 | |||
441 | 441 | 2210 | 210 | 2013-03-01 | 640 | |||
565 | 565 | pol-hu | 2349 | 403 | 2013-02-11 | 792 | ||
818 | 818 | 2153 | 693 | 2012-12-18 | 1060 | |||
436 | 436 | 2154 | 596 | 2012-12-17 | 635 | |||
882 | 882 | 2154 | 373 | 2012-12-17 | 1128 | |||
547 | 547 | knesset | MK Talab El-Sana split off from Ra'am-Ta'al and re-established the Arab Democratic Party ("Mada") parliamentary group. | 1150 | 1846 | 2012-12-12 | 771 | |
545 | 545 | knesset | 2320 | 1870 | 2012-12-03 | 769 | ||
549 | 549 | knesset | 2324 | 788 | 2012-12-03 | 773 | ||
442 | 442 | 2205 | 587 | 2012-11-24 | 642 | |||
548 | 548 | knesset | 2322 | 1357 | 2012-11-19 | 772 | ||
564 | 564 | bns | 2345 | 113 | 2012-10-24 | 791 | ||
387 | 387 | ctk | 29 | 789 | 2012-10-08 | 563 | ||
391 | 391 | 2136 | 439 | 2012-09-12 | 567 | |||
877 | 877 | 2803 | 1432 | 2012-09-02 | 1123 | |||
340 | 340 | yomiuri | 2069 | 439 | 2012-07-02 | 498 | ||
437 | 437 | 2204 | 1455 | 2012-07-01 | 636 | |||
438 | 438 | 2204 | 1006 | 2012-07-01 | 637 | |||
631 | 631 | 2372 | 528 | 2012-07-01 | 861 | |||
904 | 904 | Radim Fiala | 2262 | 829 | 2012-07-01 | 1157 | ||
738 | 738 | 2603 | 845 | 2012-06-10 | 975 | |||
368 | 368 | afp | 47 | 2094 | 2012-05-21 | 534 | ||
331 | 331 | ctk | 2042 | 336 | 2012-04-17 | 488 | ||
439 | 439 | 2206 | 587 | 2012-03-18 | 638 | |||
440 | 440 | 2206 | 506 | 2012-03-18 | 639 | |||
365 | 365 | 2091 | 47 | 2012-02-24 | 531 | |||
474 | 474 | 1448 | 2266 | 2012-02-19 | 682 | |||
386 | 386 | Artūras Zuokas, former member of the Liberal and Center Union (LiCS), founded the new party on 21 November 2011. | elta | 2122 | 983 | 2011-11-20 | 560 | |
297 | 297 | pol-hu | 1970 | 1591 | 2011-10-22 | 438 | ||
782 | 782 | 1989 | 1619 | 2011-10-01 | 1022 | |||
306 | 306 | dere | 969 | 915 | 2011-09-25 | 455 | ||
597 | 597 | 1666 | 962 | 2011-08-06 | 825 | |||
598 | 598 | 1666 | 445 | 2011-08-06 | 826 | |||
599 | 599 | 1666 | 1518 | 2011-08-06 | 827 | |||
655 | 655 | 521 | 801 | 2011-07-23 | 888 | |||
555 | 555 | 581 | 856 | 2011-07-09 | 779 | |||
907 | 907 | 2854 | 1613 | 2011-07-01 | 1160 | |||
880 | 880 | 2804 | 2325 | 2011-06-04 | 1126 | |||
290 | 290 | pr | 1945 | 512 | 2011-06-01 | 425 | ||
636 | 636 | 2391 | 1072 | 2011-05-23 | 867 | |||
903 | 903 | Valeri Simeonov. | 2211 | 535 | 2011-05-17 | 1155 | ||
630 | 630 | bta | 2379 | 982 | 2011-04-21 | 860 | ||
401 | 401 | 93 | 760 | 2011-02-28 | 594 | |||
298 | 298 | nz-parl | 1972 | 114 | 2011-02-23 | 441 | ||
544 | 544 | knesset | 2043 | 244 | 2011-01-17 | 768 | ||
366 | 366 | 2094 | 47 | 2010-11-21 | 532 | |||
170 | 170 | pr | 1679 | 528 | 2010-11-16 | 254 | ||
491 | 491 | Francescato, De Petris and Cento continued to support SL as Ecologists for Left Ecology Freedom and finally left the Greens. | 465 | 910 | 2010-10-22 | 706 | ||
322 | 322 | elta | 2007 | 983 | 2010-09-21 | 474 | ||
323 | 323 | elta | 2007 | 1502 | 2010-09-21 | 475 | ||
476 | 476 | 1477 | 596 | 2010-07-30 | 684 | |||
410 | 410 | 1656 | 500 | 2010-07-01 | 606 | |||
364 | 364 | 2093 | 1441 | 2010-06-27 | 530 | |||
302 | 302 | ager | 2002 | 1120 | 2010-05-02 | 450 | ||
432 | 432 | 2182 | 1384 | 2010-03-31 | 631 | |||
468 | 468 | 1594 | 1487 | 2009-12-19 | 676 | |||
373 | 373 | ctk | 406 | 789 | 2009-10-17 | 539 | ||
389 | 389 | 1124 | 1193 | 2009-08-08 | 565 | |||
150 | 150 | 2 | 1245 | 2009-07-11 | 220 | |||
151 | 151 | 1620 | 559 | 2009-07-01 | 221 | |||
367 | 367 | kath | 2096 | 47 | 2009-07-01 | 533 | ||
417 | 417 | 2181 | 1044 | 2009-07-01 | 614 | |||
570 | 570 | 1130 | 1582 | 2009-07-01 | 797 | |||
644 | 644 | 1100 | 1608 | 2009-07-01 | 876 | |||
354 | 354 | 2078 | 509 | 2009-06-27 | 516 | |||
538 | 538 | 2 | 1123 | 2009-06-11 | 761 | |||
778 | 778 | 2169 | 47 | 2009-05-01 | 1016 | |||
403 | 403 | 596 | 52 | 2009-03-29 | 596 | |||
421 | 421 | reuters | 596 | 373 | 2009-03-29 | 618 | ||
425 | 425 | 596 | 323 | 2009-03-29 | 623 | |||
814 | 814 | The NPSI only joined on federal level and remained independent on regional level. | 596 | 1287 | 2009-03-29 | 1056 | ||
379 | 379 | 1006 | 2115 | 2009-03-01 | 548 | |||
299 | 299 | 26 | 458 | 2009-01-01 | 446 | |||
543 | 543 | knesset | 980 | 1357 | 2008-12-23 | 767 | ||
635 | 635 | frpo | 2399 | 658 | 2008-11-23 | 866 | ||
154 | 154 | nzz | 1213 | 750 | 2008-11-01 | 225 | ||
537 | 537 | 1454 | 1532 | 2008-11-01 | 760 | |||
596 | 596 | 962 | 811 | 2008-09-06 | 824 | |||
184 | 184 | 154 | 184 | 2008-07-26 | 285 | |||
185 | 185 | 154 | 1411 | 2008-07-26 | 286 | |||
392 | 392 | 1056 | 1277 | 2008-07-01 | 574 | |||
47 | 47 | 1045 | 675 | 2008-05-17 | 73 | |||
145 | 145 | 445 | 521 | 2008-04-26 | 214 | |||
49 | 49 | 1045 | 432 | 2008-03-11 | 76 | |||
291 | 291 | sta | 1946 | 981 | 2008-03-01 | 426 | ||
67 | 67 | afp | 958 | 419 | 2007-12-15 | 104 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");