party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by party_id_new 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 |
---|---|---|---|---|---|---|---|---|
918 | 918 | Split by Zvi Thau and Hamor Yeshiva. | 2889 | 1357 | 2019-07-15 | 1171 | ||
916 | 916 | 2888 | 1605 | 2022-06-22 | 1169 | |||
915 | 915 | 2887 | 1605 | 2022-06-05 | 1168 | |||
913 | 913 | Aldis Gobzems | 2880 | 2715 | 2019-02-04 | 1166 | ||
912 | 912 | 2877 | 2715 | 2021-08-24 | 1165 | |||
910 | 910 | 2862 | 658 | 2017-11-26 | 1163 | |||
909 | 909 | ap | 2861 | 2155 | 2022-06-21 | 1162 | ||
911 | 911 | 2857 | 2643 | 2021-10-09 | 1164 | |||
914 | 914 | 2856 | 2337 | 2018-07-12 | 1167 | |||
917 | 917 | 2856 | 2668 | 2022-06-27 | 1170 | |||
907 | 907 | 2854 | 1613 | 2011-07-01 | 1160 | |||
900 | 900 | Gideon Sa'ar | 2835 | 678 | 2020-07-01 | 1146 | ||
906 | 906 | expulsion from ODS: Václav Klaus Jr. | 2832 | 829 | 2019-03-16 | 1159 | ||
889 | 889 | 2828 | 2069 | 2019-04-01 | 1135 | |||
887 | 887 | 2827 | 2656 | 2018-05-07 | 1133 | |||
888 | 888 | 2827 | 1734 | 2018-05-07 | 1134 | |||
896 | 896 | 2827 | 2657 | 2020-09-11 | 1142 | |||
886 | 886 | Formed as Initiatives from Osaka in October 2015 from a split in the old Japan Innovation Party (founded 2012). | 2826 | 2136 | 2015-11-02 | 1132 | ||
894 | 894 | 2823 | 2642 | 2020-12-18 | 1140 | |||
893 | 893 | 2817 | 2341 | 2019-10-30 | 1139 | |||
885 | 885 | 2816 | 351 | 2018-08-24 | 1131 | |||
890 | 890 | In 2020 GERB suffered a split, as a sizable number of members and local party organizations left alongside former second-in-command Tsvetan Tsvetanov to form the Republicans for Bulgaria party. | 2814 | 1541 | 2020-10-27 | 1136 | ||
883 | 883 | afp | 2813 | 873 | 2015-09-02 | 1129 | ||
892 | 892 | 2809 | 276 | 2020-02-29 | 1138 | |||
891 | 891 | 2805 | 482 | 2019-06-01 | 1137 | |||
880 | 880 | 2804 | 2325 | 2011-06-04 | 1126 | |||
877 | 877 | 2803 | 1432 | 2012-09-02 | 1123 | |||
873 | 873 | 2801 | 1118 | 2018-04-21 | 1119 | |||
864 | 864 | 2800 | 678 | 2017-03-12 | 1110 | |||
865 | 865 | 2797 | 220 | 2019-10-07 | 1111 | |||
863 | 863 | reuters | 2794 | 382 | 2019-09-18 | 1109 | ||
902 | 902 | Maxime Bernier | 2791 | 1255 | 2018-08-23 | 1154 | ||
866 | 866 | 2787 | 1816 | 2018-12-25 | 1112 | |||
867 | 867 | 2783 | 1432 | 2019-02-04 | 1113 | |||
868 | 868 | 2781 | 590 | 2015-10-19 | 1114 | |||
860 | 860 | 2780 | 1179 | 2016-06-28 | 1106 | |||
859 | 859 | 2770 | 276 | 2017-06-01 | 1105 | |||
858 | 858 | 2769 | 1465 | 2017-06-06 | 1104 | |||
856 | 856 | 2763 | 1277 | 2018-04-13 | 1101 | |||
857 | 857 | 2763 | 581 | 2018-04-13 | 1102 | |||
846 | 846 | 2759 | 1003 | 2016-10-21 | 1089 | |||
855 | 855 | 2756 | 1273 | 2018-10-23 | 1100 | |||
869 | 869 | 2754 | 179 | 2019-04-06 | 1115 | |||
871 | 871 | 2752 | 2624 | 2018-04-14 | 1117 | |||
854 | 854 | 2750 | 1432 | 2019-02-08 | 1099 | |||
875 | 875 | 2750 | 1759 | 2019-02-08 | 1121 | |||
853 | 853 | 2746 | 1120 | 2018-02-20 | 1098 | |||
852 | 852 | 2745 | 600 | 2018-06-23 | 1097 | |||
851 | 851 | 2744 | 2091 | 2017-03-28 | 1096 | |||
850 | 850 | 2742 | 1592 | 2018-03-27 | 1094 | |||
849 | 849 | 2741 | 851 | 2018-04-20 | 1093 | |||
848 | 848 | 2740 | 1945 | 2019-02-03 | 1091 | |||
847 | 847 | 2739 | 2263 | 2019-02-22 | 1090 | |||
878 | 878 | 2737 | 1296 | 2019-01-27 | 1124 | |||
845 | 845 | 2734 | 658 | 2007-03-25 | 1088 | |||
844 | 844 | 2732 | 1539 | 2017-07-01 | 1087 | |||
842 | 842 | 2730 | 1556 | 2019-02-18 | 1085 | |||
843 | 843 | 2730 | 773 | 2019-02-18 | 1086 | |||
841 | 841 | 2729 | 1272 | 2019-01-20 | 1084 | |||
879 | 879 | 2727 | 678 | 2015-01-05 | 1125 | |||
840 | 840 | knesset | 2718 | 214 | 2018-12-29 | 1082 | ||
837 | 837 | 2717 | 521 | 2014-05-17 | 1079 | |||
836 | 836 | 2715 | 2366 | 2016-05-03 | 1078 | |||
835 | 835 | 2714 | 2461 | 1929-07-01 | 1077 | |||
834 | 834 | wid | 2713 | 2692 | 1929-12-28 | 1076 | ||
833 | 833 | 2711 | 2692 | 1930-07-01 | 1075 | |||
832 | 832 | 2709 | 2692 | 1928-07-01 | 1074 | |||
829 | 829 | 2702 | 408 | 2017-10-25 | 1071 | |||
895 | 895 | 2700 | 2692 | 1927-01-01 | 1141 | |||
823 | 823 | 2697 | 137 | 1918-12-01 | 1065 | |||
821 | 821 | 2690 | 558 | 1917-04-06 | 1063 | |||
825 | 825 | 2681 | 2677 | 1920-06-26 | 1067 | |||
826 | 826 | 2681 | 2678 | 1920-06-26 | 1068 | |||
819 | 819 | see Mulej (2017, 138-9) | 2674 | 2673 | 1920-08-08 | 1061 | ||
820 | 820 | see Mulej (2017, 138-9) | 2674 | 2672 | 1920-08-08 | 1062 | ||
824 | 824 | see Mulej (2017, 138-9) | 2674 | 2675 | 1920-08-08 | 1066 | ||
827 | 827 | 2674 | 2679 | 1920-08-08 | 1069 | |||
828 | 828 | see Mulej (2017, 138-9) | 2674 | 2676 | 1920-08-08 | 1070 | ||
813 | 813 | 2670 | 2334 | 2017-06-24 | 1055 | |||
815 | 815 | 2670 | 2335 | 2017-06-24 | 1057 | |||
816 | 816 | 2670 | 1989 | 2017-06-24 | 1058 | |||
811 | 811 | 2657 | 1734 | 2017-10-03 | 1053 | |||
812 | 812 | 2656 | 1193 | 2017-09-25 | 1054 | |||
810 | 810 | 2655 | 1455 | 2017-09-24 | 1052 | |||
808 | 808 | 2654 | 2262 | 2015-05-05 | 1050 | |||
905 | 905 | Radim Fiala | 2654 | 2262 | 2013-07-01 | 1158 | ||
809 | 809 | 2651 | 1429 | 2017-07-26 | 1051 | |||
806 | 806 | 2648 | 1120 | 2015-04-23 | 1046 | |||
637 | 637 | 2647 | 1015 | 2014-07-03 | 869 | |||
807 | 807 | 2647 | 5 | 2015-06-19 | 1048 | |||
884 | 884 | 2646 | 2811 | 2021-04-16 | 1130 | |||
805 | 805 | 2645 | 200 | 2017-06-13 | 1045 | |||
804 | 804 | 2644 | 686 | 2016-02-10 | 1044 | |||
803 | 803 | 2643 | 1539 | 2016-04-06 | 1043 | |||
802 | 802 | Tunahan Kuzu | 2641 | 742 | 2014-11-13 | 1042 | ||
901 | 901 | Selçuk Öztürk | 2641 | 742 | 2014-11-13 | 1153 | ||
801 | 801 | 2640 | 2212 | 2014-08-02 | 1041 | |||
800 | 800 | 2639 | 1286 | 2016-04-10 | 1040 | |||
787 | 787 | 2634 | 983 | 2014-07-12 | 1027 | |||
788 | 788 | 2634 | 2122 | 2014-07-12 | 1028 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");