party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by party_id descending
This data as json, CSV (advanced)
Suggested facets: description
date (date) >30 ✖
- 1993-07-01 11
- 1998-07-01 11
- 1999-07-01 11
- 1995-07-01 10
- 1996-07-01 10
- 1921-07-01 9
- 1994-07-01 8
- 1984-07-01 7
- 1989-07-01 7
- 2002-03-24 6
- 2002-07-01 6
- 1918-07-01 5
- 1920-08-08 5
- 1931-07-01 5
- 1932-07-01 5
- 1972-07-01 5
- 1977-07-01 5
- 1978-07-01 5
- 1991-07-01 5
- 2001-07-01 5
- 2003-07-01 5
- 2005-07-01 5
- 2007-07-01 5
- 2009-07-01 5
- 1909-07-01 4
- 1919-07-01 4
- 1925-02-01 4
- 1935-07-01 4
- 1940-07-01 4
- 1945-07-01 4
- …
Link | rowid | comment | data_source | description | party_id_new | party_id ▲ | date | id |
---|---|---|---|---|---|---|---|---|
884 | 884 | 2646 | 2811 | 2021-04-16 | 1130 | |||
912 | 912 | 2877 | 2715 | 2021-08-24 | 1165 | |||
913 | 913 | Aldis Gobzems | 2880 | 2715 | 2019-02-04 | 1166 | ||
830 | 830 | 1131 | 2697 | 1946-10-28 | 1072 | |||
831 | 831 | 1180 | 2697 | 1945-07-01 | 1073 | |||
832 | 832 | 2709 | 2692 | 1928-07-01 | 1074 | |||
833 | 833 | 2711 | 2692 | 1930-07-01 | 1075 | |||
834 | 834 | wid | 2713 | 2692 | 1929-12-28 | 1076 | ||
895 | 895 | 2700 | 2692 | 1927-01-01 | 1141 | |||
822 | 822 | 558 | 2690 | 1922-09-24 | 1064 | |||
862 | 862 | 649 | 2690 | 1920-12-04 | 1108 | |||
827 | 827 | 2674 | 2679 | 1920-08-08 | 1069 | |||
826 | 826 | 2681 | 2678 | 1920-06-26 | 1068 | |||
825 | 825 | 2681 | 2677 | 1920-06-26 | 1067 | |||
828 | 828 | see Mulej (2017, 138-9) | 2674 | 2676 | 1920-08-08 | 1070 | ||
824 | 824 | see Mulej (2017, 138-9) | 2674 | 2675 | 1920-08-08 | 1066 | ||
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 | ||
917 | 917 | 2856 | 2668 | 2022-06-27 | 1170 | |||
896 | 896 | 2827 | 2657 | 2020-09-11 | 1142 | |||
897 | 897 | 940 | 2657 | 2020-07-01 | 1143 | |||
887 | 887 | 2827 | 2656 | 2018-05-07 | 1133 | |||
908 | 908 | 1015 | 2647 | 2022-03-22 | 1161 | |||
911 | 911 | 2857 | 2643 | 2021-10-09 | 1164 | |||
894 | 894 | 2823 | 2642 | 2020-12-18 | 1140 | |||
871 | 871 | 2752 | 2624 | 2018-04-14 | 1117 | |||
734 | 734 | 2594 | 2618 | 1935-07-01 | 971 | |||
732 | 732 | 2594 | 2617 | 1935-07-01 | 969 | |||
725 | 725 | 657 | 2608 | 1935-07-01 | 962 | |||
716 | 716 | mackie | 401 | 2594 | 1945-07-01 | 953 | ||
739 | 739 | 2581 | 2593 | 1919-07-01 | 976 | |||
740 | 740 | 1414 | 2587 | 1949-01-06 | 977 | |||
749 | 749 | 2581 | 2586 | 1919-07-01 | 986 | |||
745 | 745 | 890 | 2585 | 1946-06-02 | 982 | |||
743 | 743 | 1539 | 2584 | 1937-01-31 | 980 | |||
741 | 741 | 1086 | 2583 | 1940-07-10 | 978 | |||
717 | 717 | 1297 | 2581 | 1945-07-01 | 954 | |||
700 | 700 | 794 | 2565 | 1938-07-01 | 937 | |||
756 | 756 | 2442 | 2563 | 1932-12-01 | 993 | |||
657 | 657 | 2441 | 2561 | 1923-07-01 | 890 | |||
660 | 660 | mchale | 1342 | 2561 | 1924-07-01 | 893 | ||
666 | 666 | 904 | 2557 | 1923-07-01 | 899 | |||
662 | 662 | 1461 | 2556 | 1921-07-01 | 895 | |||
667 | 667 | 878 | 2549 | 1916-07-01 | 900 | |||
724 | 724 | 742 | 2542 | 1946-02-09 | 961 | |||
728 | 728 | 2455 | 2535 | 1932-07-01 | 965 | |||
715 | 715 | 2455 | 2533 | 1932-07-01 | 952 | |||
687 | 687 | 1234 | 2527 | 1944-07-01 | 921 | |||
693 | 693 | no-2010 | 2529 | 2527 | 1925-02-01 | 929 | ||
696 | 696 | no-2010 | 2536 | 2527 | 1931-06-01 | 933 | ||
697 | 697 | no-2010 | 2448 | 2527 | 1937-06-01 | 934 | ||
861 | 861 | 2450 | 2527 | 1918-07-01 | 1107 | |||
686 | 686 | 2525 | 2523 | 1923-08-01 | 920 | |||
783 | 783 | 1556 | 2508 | 1922-11-15 | 1023 | |||
709 | 709 | 1017 | 2503 | 1922-07-01 | 946 | |||
785 | 785 | 2501 | 2503 | 1918-11-20 | 1025 | |||
784 | 784 | 659 | 2501 | 1923-11-13 | 1024 | |||
754 | 754 | 1051 | 2486 | 1945-08-18 | 991 | |||
670 | 670 | 892 | 2477 | 1923-05-23 | 903 | |||
722 | 722 | 904 | 2475 | 1926-07-01 | 959 | |||
673 | 673 | 104 | 2474 | 1927-07-01 | 906 | |||
702 | 702 | 997 | 2471 | 1936-05-14 | 939 | |||
768 | 768 | 2468 | 2471 | 1934-07-01 | 1006 | |||
703 | 703 | 997 | 2469 | 1936-05-14 | 940 | |||
668 | 668 | 2539 | 2466 | 1937-07-01 | 901 | |||
677 | 677 | 2461 | 2462 | 1921-07-01 | 910 | |||
835 | 835 | 2714 | 2461 | 1929-07-01 | 1077 | |||
676 | 676 | 2461 | 2459 | 1921-07-01 | 909 | |||
678 | 678 | 2461 | 2457 | 1921-07-01 | 911 | |||
691 | 691 | 2455 | 2456 | 1932-07-01 | 925 | |||
698 | 698 | 2535 | 2456 | 1928-06-30 | 935 | |||
692 | 692 | 967 | 2455 | 1955-04-24 | 928 | |||
688 | 688 | 2456 | 2453 | 1925-02-01 | 922 | |||
689 | 689 | 2531 | 2453 | 1925-02-01 | 923 | |||
690 | 690 | 2533 | 2453 | 1925-02-01 | 924 | |||
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 | |
713 | 713 | 1393 | 2447 | 1933-09-01 | 950 | |||
714 | 714 | 1393 | 2442 | 1933-09-11 | 951 | |||
658 | 658 | 1342 | 2441 | 1929-05-25 | 891 | |||
872 | 872 | mchale | 1342 | 2440 | 1924-07-01 | 1118 | ||
682 | 682 | 1219 | 2434 | 1918-07-01 | 916 | |||
683 | 683 | 1118 | 2434 | 1918-07-01 | 917 | |||
681 | 681 | 395 | 2433 | 1919-07-01 | 914 | |||
680 | 680 | 1605 | 2430 | 1909-07-01 | 913 | |||
701 | 701 | 296 | 2427 | 1932-07-01 | 938 | |||
684 | 684 | 1051 | 2423 | 1945-01-18 | 918 | |||
685 | 685 | 1051 | 2423 | 1936-07-01 | 919 | |||
753 | 753 | 2486 | 2423 | 1936-07-01 | 990 | |||
735 | 735 | 167 | 2422 | 1945-07-01 | 972 | |||
757 | 757 | 708 | 2422 | 1921-07-01 | 994 | |||
639 | 639 | 417 | 2403 | 2000-06-10 | 871 | |||
638 | 638 | 417 | 2402 | 2000-06-10 | 870 | |||
836 | 836 | 2715 | 2366 | 2016-05-03 | 1078 | |||
628 | 628 | 1414 | 2358 | 1954-07-01 | 858 | |||
573 | 573 | knesset | 2311 | 2357 | 1977-03-08 | 800 | ||
580 | 580 | knesset | 244 | 2357 | 1974-02-26 | 807 | ||
569 | 569 | knesset | 2356 | 2355 | 1995-11-27 | 796 | ||
567 | 567 | 678 | 2354 | 1988-07-01 | 794 | |||
893 | 893 | 2817 | 2341 | 2019-10-30 | 1139 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");