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 |
---|---|---|---|---|---|---|---|---|
818 | 818 | 2153 | 693 | 2012-12-18 | 1060 | |||
817 | 817 | 1661 | 1321 | 2016-06-26 | 1059 | |||
816 | 816 | 2670 | 1989 | 2017-06-24 | 1058 | |||
815 | 815 | 2670 | 2335 | 2017-06-24 | 1057 | |||
814 | 814 | The NPSI only joined on federal level and remained independent on regional level. | 596 | 1287 | 2009-03-29 | 1056 | ||
813 | 813 | 2670 | 2334 | 2017-06-24 | 1055 | |||
812 | 812 | 2656 | 1193 | 2017-09-25 | 1054 | |||
811 | 811 | 2657 | 1734 | 2017-10-03 | 1053 | |||
810 | 810 | 2655 | 1455 | 2017-09-24 | 1052 | |||
809 | 809 | 2651 | 1429 | 2017-07-26 | 1051 | |||
808 | 808 | 2654 | 2262 | 2015-05-05 | 1050 | |||
807 | 807 | 2647 | 5 | 2015-06-19 | 1048 | |||
806 | 806 | 2648 | 1120 | 2015-04-23 | 1046 | |||
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 | ||
801 | 801 | 2640 | 2212 | 2014-08-02 | 1041 | |||
800 | 800 | 2639 | 1286 | 2016-04-10 | 1040 | |||
799 | 799 | 509 | 59 | 1978-07-01 | 1039 | |||
798 | 798 | 658 | 509 | 2002-11-17 | 1038 | |||
797 | 797 | 1752 | 1013 | 1999-07-01 | 1037 | |||
796 | 796 | 411 | 135 | 1985-07-01 | 1036 | |||
795 | 795 | 2464 | 405 | 1921-07-01 | 1035 | |||
794 | 794 | 1040 | 226 | 2005-04-30 | 1034 | |||
793 | 793 | 596 | 436 | 2014-07-01 | 1033 | |||
792 | 792 | 523 | 280 | 1958-07-01 | 1032 | |||
791 | 791 | 523 | 92 | 1958-07-01 | 1031 | |||
790 | 790 | 1720 | 543 | 1994-01-21 | 1030 | |||
789 | 789 | 1927 | 1912 | 1943-04-16 | 1029 | |||
788 | 788 | 2634 | 2122 | 2014-07-12 | 1028 | |||
787 | 787 | 2634 | 983 | 2014-07-12 | 1027 | |||
786 | 786 | 2633 | 1342 | 2016-05-24 | 1026 | |||
785 | 785 | 2501 | 2503 | 1918-11-20 | 1025 | |||
784 | 784 | 659 | 2501 | 1923-11-13 | 1024 | |||
783 | 783 | 1556 | 2508 | 1922-11-15 | 1023 | |||
782 | 782 | 1989 | 1619 | 2011-10-01 | 1022 | |||
781 | 781 | 2028 | 118 | 1985-07-01 | 1020 | |||
780 | 780 | 375 | 725 | 1976-07-01 | 1019 | |||
779 | 779 | 1680 | 1355 | 2003-06-14 | 1018 | |||
778 | 778 | 2169 | 47 | 2009-05-01 | 1016 | |||
777 | 777 | 2252 | 509 | 1999-07-01 | 1015 | |||
776 | 776 | 2252 | 138 | 1999-07-01 | 1014 | |||
775 | 775 | 2063 | 773 | 1999-07-01 | 1013 | |||
774 | 774 | 2063 | 1556 | 1999-07-01 | 1012 | |||
773 | 773 | 2063 | 659 | 1999-07-01 | 1011 | |||
772 | 772 | 1023 | 1092 | 1970-08-20 | 1010 | |||
771 | 771 | 1562 | 1782 | 1992-07-01 | 1009 | |||
770 | 770 | 1424 | 968 | 1975-07-01 | 1008 | |||
769 | 769 | 2317 | 1415 | 2005-03-05 | 1007 | |||
768 | 768 | 2468 | 2471 | 1934-07-01 | 1006 | |||
767 | 767 | 1589 | 2002 | 2006-07-01 | 1004 | |||
766 | 766 | 619 | 664 | 1991-10-01 | 1003 | |||
765 | 765 | 114 | 878 | 2004-07-07 | 1002 | |||
764 | 764 | 325 | 1424 | 1989-01-01 | 1001 | |||
763 | 763 | 1287 | 1475 | 2001-01-20 | 1000 | |||
762 | 762 | 720 | 1338 | 1995-07-01 | 999 | |||
761 | 761 | 851 | 1049 | 1999-07-01 | 998 | |||
760 | 760 | 993 | 290 | 1978-07-01 | 997 | |||
759 | 759 | 386 | 2286 | 1997-04-11 | 996 | |||
758 | 758 | 1760 | 1411 | 1969-07-01 | 995 | |||
757 | 757 | 708 | 2422 | 1921-07-01 | 994 | |||
756 | 756 | 2442 | 2563 | 1932-12-01 | 993 | |||
755 | 755 | 221 | 1110 | 2007-01-19 | 992 | |||
754 | 754 | 1051 | 2486 | 1945-08-18 | 991 | |||
753 | 753 | 2486 | 2423 | 1936-07-01 | 990 | |||
752 | 752 | 686 | 1539 | 1920-12-30 | 989 | |||
751 | 751 | 2626 | 491 | 2016-03-15 | 988 | |||
750 | 750 | 2626 | 1575 | 2016-01-15 | 987 | |||
749 | 749 | 2581 | 2586 | 1919-07-01 | 986 | |||
748 | 748 | hurriyet | BDP MPs join HDP | 2572 | 2305 | 2014-04-28 | 985 | |
747 | 747 | 1014 | 318 | 1989-07-01 | 984 | |||
746 | 746 | 242 | 1475 | 1969-07-05 | 983 | |||
745 | 745 | 890 | 2585 | 1946-06-02 | 982 | |||
744 | 744 | jt | 439 | 2136 | 2016-03-27 | 981 | ||
743 | 743 | 1539 | 2584 | 1937-01-31 | 980 | |||
742 | 742 | mackie | 2584 | 686 | 1930-12-21 | 979 | ||
741 | 741 | 1086 | 2583 | 1940-07-10 | 978 | |||
740 | 740 | 1414 | 2587 | 1949-01-06 | 977 | |||
739 | 739 | 2581 | 2593 | 1919-07-01 | 976 | |||
738 | 738 | 2603 | 845 | 2012-06-10 | 975 | |||
737 | 737 | 2620 | 1393 | 2015-03-13 | 974 | |||
736 | 736 | 669 | 973 | 2004-07-01 | 973 | |||
735 | 735 | 167 | 2422 | 1945-07-01 | 972 | |||
734 | 734 | 2594 | 2618 | 1935-07-01 | 971 | |||
733 | 733 | 2618 | 1539 | 1933-07-01 | 970 | |||
732 | 732 | 2594 | 2617 | 1935-07-01 | 969 | |||
731 | 731 | 2617 | 1539 | 1919-07-01 | 968 | |||
730 | 730 | 1253 | 303 | 1936-07-01 | 967 | |||
729 | 729 | 1253 | 303 | 1941-07-01 | 966 | |||
728 | 728 | 2455 | 2535 | 1932-07-01 | 965 | |||
727 | 727 | 2614 | 1384 | 2014-09-28 | 964 | |||
726 | 726 | 1239 | 1629 | 1918-07-01 | 963 | |||
725 | 725 | 657 | 2608 | 1935-07-01 | 962 | |||
724 | 724 | 742 | 2542 | 1946-02-09 | 961 | |||
723 | 723 | 2602 | 1549 | 2015-01-22 | 960 | |||
722 | 722 | 904 | 2475 | 1926-07-01 | 959 | |||
721 | 721 | 2475 | 882 | 1924-07-01 | 958 | |||
720 | 720 | reuters | 2596 | 1592 | 2015-08-21 | 957 | ||
719 | 719 | 439 | 163 | 1998-04-27 | 956 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");