party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | comment | data_source | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
718 | 718 | 1912 | 1253 | 1931-07-01 | 955 | |||
717 | 717 | 1297 | 2581 | 1945-07-01 | 954 | |||
716 | 716 | mackie | 401 | 2594 | 1945-07-01 | 953 | ||
715 | 715 | 2455 | 2533 | 1932-07-01 | 952 | |||
714 | 714 | 1393 | 2442 | 1933-09-11 | 951 | |||
713 | 713 | 1393 | 2447 | 1933-09-01 | 950 | |||
712 | 712 | 1120 | 307 | 1993-07-10 | 949 | |||
711 | 711 | no-2010 | 220 | 1415 | 2004-12-04 | 948 | ||
710 | 710 | 2504 | 773 | 1917-08-01 | 947 | |||
709 | 709 | 1017 | 2503 | 1922-07-01 | 946 | |||
708 | 708 | 1205 | 1556 | 1931-07-01 | 945 | |||
707 | 707 | 2479 | 1556 | 1931-07-01 | 944 | |||
706 | 706 | Rose and Munro 2003: 298. | 1252 | 317 | 1994-03-01 | 943 | ||
705 | 705 | 2573 | 1371 | 1991-10-01 | 942 | |||
704 | 704 | 2567 | 211 | 2013-11-27 | 941 | |||
703 | 703 | 997 | 2469 | 1936-05-14 | 940 | |||
702 | 702 | 997 | 2471 | 1936-05-14 | 939 | |||
701 | 701 | 296 | 2427 | 1932-07-01 | 938 | |||
700 | 700 | 794 | 2565 | 1938-07-01 | 937 | |||
699 | 699 | 2565 | 794 | 1935-10-01 | 936 | |||
698 | 698 | 2535 | 2456 | 1928-06-30 | 935 | |||
697 | 697 | no-2010 | 2448 | 2527 | 1937-06-01 | 934 | ||
696 | 696 | no-2010 | 2536 | 2527 | 1931-06-01 | 933 | ||
695 | 695 | no-2010 | PL was led by Nicolas Mathieu, a former member of the PNI. | 2140 | 2450 | 1937-06-01 | 932 | |
694 | 694 | no-2010 | 2538 | 2450 | 1931-06-01 | 930 | ||
693 | 693 | no-2010 | 2529 | 2527 | 1925-02-01 | 929 | ||
692 | 692 | 967 | 2455 | 1955-04-24 | 928 | |||
691 | 691 | 2455 | 2456 | 1932-07-01 | 925 | |||
690 | 690 | 2533 | 2453 | 1925-02-01 | 924 | |||
689 | 689 | 2531 | 2453 | 1925-02-01 | 923 | |||
688 | 688 | 2456 | 2453 | 1925-02-01 | 922 | |||
687 | 687 | 1234 | 2527 | 1944-07-01 | 921 | |||
686 | 686 | 2525 | 2523 | 1923-08-01 | 920 | |||
685 | 685 | 1051 | 2423 | 1936-07-01 | 919 | |||
684 | 684 | 1051 | 2423 | 1945-01-18 | 918 | |||
683 | 683 | 1118 | 2434 | 1918-07-01 | 917 | |||
682 | 682 | 1219 | 2434 | 1918-07-01 | 916 | |||
681 | 681 | 395 | 2433 | 1919-07-01 | 914 | |||
680 | 680 | 1605 | 2430 | 1909-07-01 | 913 | |||
679 | 679 | 2431 | 590 | 1939-07-01 | 912 | |||
678 | 678 | 2461 | 2457 | 1921-07-01 | 911 | |||
677 | 677 | 2461 | 2462 | 1921-07-01 | 910 | |||
676 | 676 | 2461 | 2459 | 1921-07-01 | 909 | |||
675 | 675 | 2472 | 647 | 1909-07-01 | 908 | |||
674 | 674 | 2473 | 647 | 1888-07-01 | 907 | |||
673 | 673 | 104 | 2474 | 1927-07-01 | 906 | |||
672 | 672 | 2474 | 104 | 1921-07-01 | 905 | |||
671 | 671 | 2477 | 892 | 1934-08-05 | 904 | |||
670 | 670 | 892 | 2477 | 1923-05-23 | 903 | |||
669 | 669 | 1194 | 1451 | 1909-03-14 | 902 | |||
668 | 668 | 2539 | 2466 | 1937-07-01 | 901 | |||
667 | 667 | 878 | 2549 | 1916-07-01 | 900 | |||
666 | 666 | 904 | 2557 | 1923-07-01 | 899 | |||
665 | 665 | 2557 | 882 | 1921-07-01 | 898 | |||
664 | 664 | 882 | 904 | 1917-07-01 | 897 | |||
663 | 663 | 2478 | 882 | 1929-07-01 | 896 | |||
662 | 662 | 1461 | 2556 | 1921-07-01 | 895 | |||
661 | 661 | 2437 | 228 | 1930-07-01 | 894 | |||
660 | 660 | mchale | 1342 | 2561 | 1924-07-01 | 893 | ||
659 | 659 | 2439 | 1455 | 1922-07-01 | 892 | |||
658 | 658 | 1342 | 2441 | 1929-05-25 | 891 | |||
657 | 657 | 2441 | 2561 | 1923-07-01 | 890 | |||
656 | 656 | rose | 675 | 493 | 2001-07-01 | 889 | ||
655 | 655 | 521 | 801 | 2011-07-23 | 888 | |||
654 | 654 | rose | 2417 | 1368 | 1994-07-01 | 887 | ||
653 | 653 | 1395 | 1796 | 1998-05-01 | 886 | |||
652 | 652 | 1137 | 450 | 1991-10-12 | 885 | |||
651 | 651 | rose | ASZ was absorbed by MSZP in 1998 (Rose/Munro 2009:148). | 1591 | 1183 | 1998-07-01 | 884 | |
650 | 650 | 2415 | 647 | 1900-07-01 | 883 | |||
649 | 649 | 2410 | 678 | 2014-11-27 | 882 | |||
648 | 648 | 470 | 748 | 1993-07-01 | 881 | |||
647 | 647 | 2411 | 788 | 2014-12-15 | 880 | |||
646 | 646 | 678 | 1841 | 1973-07-01 | 879 | |||
645 | 645 | 2409 | 1597 | 2014-09-20 | 877 | |||
644 | 644 | 1100 | 1608 | 2009-07-01 | 876 | |||
643 | 643 | 2407 | 1338 | 2015-01-03 | 875 | |||
642 | 642 | 2406 | 904 | 1940-07-01 | 874 | |||
641 | 641 | 2360 | 678 | 2005-07-01 | 873 | |||
640 | 640 | 2404 | 2136 | 2014-08-01 | 872 | |||
639 | 639 | 417 | 2403 | 2000-06-10 | 871 | |||
638 | 638 | 417 | 2402 | 2000-06-10 | 870 | |||
637 | 637 | 2647 | 1015 | 2014-07-03 | 869 | |||
636 | 636 | 2391 | 1072 | 2011-05-23 | 867 | |||
635 | 635 | frpo | 2399 | 658 | 2008-11-23 | 866 | ||
634 | 634 | 2387 | 1272 | 2013-07-01 | 864 | |||
633 | 633 | 2382 | 1493 | 2013-10-29 | 863 | |||
632 | 632 | 2380 | 645 | 2013-12-16 | 862 | |||
631 | 631 | 2372 | 528 | 2012-07-01 | 861 | |||
630 | 630 | bta | 2379 | 982 | 2011-04-21 | 860 | ||
629 | 629 | 2370 | 318 | 2013-04-05 | 859 | |||
628 | 628 | 1414 | 2358 | 1954-07-01 | 858 | |||
627 | 627 | nyt | 2358 | 1094 | 1952-03-06 | 857 | ||
626 | 626 | reuters | Georgi Parvanov | 2364 | 982 | 2014-07-01 | 856 | |
625 | 625 | knesset | 2361 | 678 | 1999-02-23 | 855 | ||
624 | 624 | 1151 | 851 | 1986-09-01 | 854 | |||
623 | 623 | 1225 | 1003 | 1961-07-01 | 853 | |||
622 | 622 | 1919 | 184 | 1932-07-01 | 852 | |||
621 | 621 | 2285 | 1898 | 1909-07-01 | 851 | |||
620 | 620 | 2285 | 1938 | 1909-07-01 | 850 | |||
619 | 619 | 1917 | 1898 | 1906-07-01 | 849 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");