party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by date
This data as json, CSV (advanced)
Link | rowid | comment | data_source | description | party_id_new | party_id | date ▼ | id |
---|---|---|---|---|---|---|---|---|
768 | 768 | 2468 | 2471 | 1934-07-01 | 1006 | |||
671 | 671 | 2477 | 892 | 1934-08-05 | 904 | |||
295 | 295 | 1957 | 750 | 1935-07-01 | 436 | |||
725 | 725 | 657 | 2608 | 1935-07-01 | 962 | |||
732 | 732 | 2594 | 2617 | 1935-07-01 | 969 | |||
734 | 734 | 2594 | 2618 | 1935-07-01 | 971 | |||
699 | 699 | 2565 | 794 | 1935-10-01 | 936 | |||
702 | 702 | 997 | 2471 | 1936-05-14 | 939 | |||
703 | 703 | 997 | 2469 | 1936-05-14 | 940 | |||
685 | 685 | 1051 | 2423 | 1936-07-01 | 919 | |||
730 | 730 | 1253 | 303 | 1936-07-01 | 967 | |||
753 | 753 | 2486 | 2423 | 1936-07-01 | 990 | |||
485 | 485 | 2293 | 920 | 1936-12-20 | 695 | |||
486 | 486 | 2293 | 2292 | 1936-12-20 | 696 | |||
743 | 743 | 1539 | 2584 | 1937-01-31 | 980 | |||
695 | 695 | no-2010 | PL was led by Nicolas Mathieu, a former member of the PNI. | 2140 | 2450 | 1937-06-01 | 932 | |
697 | 697 | no-2010 | 2448 | 2527 | 1937-06-01 | 934 | ||
668 | 668 | 2539 | 2466 | 1937-07-01 | 901 | |||
207 | 207 | 1319 | 228 | 1938-07-01 | 314 | |||
700 | 700 | 794 | 2565 | 1938-07-01 | 937 | |||
679 | 679 | 2431 | 590 | 1939-07-01 | 912 | |||
296 | 296 | teara | 1968 | 878 | 1940-03-25 | 437 | ||
614 | 614 | 303 | 1253 | 1940-07-01 | 842 | |||
617 | 617 | 1908 | 1253 | 1940-07-01 | 847 | |||
618 | 618 | 1922 | 1908 | 1940-07-01 | 848 | |||
642 | 642 | 2406 | 904 | 1940-07-01 | 874 | |||
741 | 741 | 1086 | 2583 | 1940-07-10 | 978 | |||
308 | 308 | mchale | 2004 | 1342 | 1941-07-01 | 457 | ||
729 | 729 | 1253 | 303 | 1941-07-01 | 966 | |||
789 | 789 | 1927 | 1912 | 1943-04-16 | 1029 | |||
70 | 70 | 156 | 318 | 1944-07-01 | 107 | |||
687 | 687 | 1234 | 2527 | 1944-07-01 | 921 | |||
684 | 684 | 1051 | 2423 | 1945-01-18 | 918 | |||
716 | 716 | mackie | 401 | 2594 | 1945-07-01 | 953 | ||
717 | 717 | 1297 | 2581 | 1945-07-01 | 954 | |||
735 | 735 | 167 | 2422 | 1945-07-01 | 972 | |||
831 | 831 | 1180 | 2697 | 1945-07-01 | 1073 | |||
754 | 754 | 1051 | 2486 | 1945-08-18 | 991 | |||
483 | 483 | 1411 | 1912 | 1945-08-31 | 692 | |||
60 | 60 | 742 | 1451 | 1946-02-09 | 94 | |||
61 | 61 | 742 | 944 | 1946-02-09 | 95 | |||
724 | 724 | 742 | 2542 | 1946-02-09 | 961 | |||
62 | 62 | 1409 | 944 | 1946-03-23 | 96 | |||
745 | 745 | 890 | 2585 | 1946-06-02 | 982 | |||
615 | 615 | 303 | 1253 | 1946-07-01 | 844 | |||
830 | 830 | 1131 | 2697 | 1946-10-28 | 1072 | |||
189 | 189 | 242 | 1475 | 1947-01-11 | 290 | |||
202 | 202 | mackie | 1734 | 1726 | 1947-03-01 | 308 | ||
257 | 257 | 1475 | 1330 | 1947-07-01 | 378 | |||
318 | 318 | 1409 | 742 | 1948-01-24 | 470 | |||
201 | 201 | mackie | 1726 | 1734 | 1948-03-01 | 306 | ||
203 | 203 | mackie | 1737 | 940 | 1948-03-01 | 309 | ||
321 | 321 | 625 | 300 | 1948-04-01 | 473 | |||
204 | 204 | mackie | 1736 | 940 | 1948-12-01 | 310 | ||
319 | 319 | 3 | 451 | 1948-12-11 | 471 | |||
740 | 740 | 1414 | 2587 | 1949-01-06 | 977 | |||
593 | 593 | 1274 | 1003 | 1949-07-01 | 821 | |||
220 | 220 | 1734 | 1733 | 1950-04-01 | 328 | |||
74 | 74 | 318 | 156 | 1950-07-01 | 111 | |||
467 | 467 | 1414 | 1297 | 1951-02-15 | 675 | |||
190 | 190 | no-2001 | 1724 | 940 | 1951-07-01 | 292 | ||
191 | 191 | no-2001 | 1723 | 940 | 1951-07-01 | 293 | ||
264 | 264 | "Conservative Liberal minority starting a Liberal League (Vapaamielisten Liitto)" (Jacobs 1989, 540). | jacobs | 1109 | 1219 | 1951-07-01 | 386 | |
273 | 273 | knesset | 1472 | 1831 | 1951-09-10 | 400 | ||
627 | 627 | nyt | 2358 | 1094 | 1952-03-06 | 857 | ||
206 | 206 | mackie | 1738 | 1734 | 1952-07-01 | 312 | ||
377 | 377 | phb | 238 | 808 | 1952-11-29 | 546 | ||
378 | 378 | phb | 238 | 137 | 1952-11-29 | 547 | ||
219 | 219 | Election date used to set date of party change. | 1755 | 1726 | 1953-03-15 | 326 | ||
524 | 524 | 1172 | 1455 | 1953-03-15 | 745 | |||
525 | 525 | 1172 | 228 | 1953-03-15 | 746 | |||
526 | 526 | 1172 | 1319 | 1953-03-15 | 747 | |||
246 | 246 | 538 | 1605 | 1953-07-01 | 363 | |||
309 | 309 | mchale | 2005 | 1342 | 1953-07-01 | 458 | ||
393 | 393 | 217 | 1033 | 1953-10-01 | 580 | |||
178 | 178 | 421 | 1050 | 1954-07-01 | 276 | |||
628 | 628 | 1414 | 2358 | 1954-07-01 | 858 | |||
280 | 280 | knesset | 1343 | 1168 | 1954-08-23 | 411 | ||
217 | 217 | nyt | 1722 | 1755 | 1954-11-24 | 324 | ||
218 | 218 | nyt | 1722 | 1734 | 1954-11-24 | 325 | ||
268 | 268 | 1306 | 1253 | 1955-04-07 | 390 | |||
692 | 692 | 967 | 2455 | 1955-04-24 | 928 | |||
221 | 221 | mackie | 1724 | 1738 | 1955-07-01 | 329 | ||
411 | 411 | no-2010 | 967 | 2140 | 1955-07-01 | 608 | ||
195 | 195 | nyt | 940 | 1724 | 1955-10-13 | 299 | ||
196 | 196 | nyt | 940 | 1723 | 1955-10-13 | 300 | ||
320 | 320 | 451 | 3 | 1955-10-29 | 472 | |||
197 | 197 | mackie | 1193 | 1722 | 1955-11-15 | 301 | ||
198 | 198 | mackie | 1193 | 1726 | 1955-11-15 | 302 | ||
473 | 473 | 1296 | 487 | 1955-12-11 | 681 | |||
148 | 148 | 358 | 543 | 1956-02-23 | 218 | |||
380 | 380 | 1360 | 228 | 1956-04-04 | 549 | |||
277 | 277 | 214 | 1828 | 1956-07-01 | 407 | |||
278 | 278 | 214 | 1833 | 1956-07-01 | 408 | |||
522 | 522 | 2314 | 228 | 1956-07-01 | 743 | |||
205 | 205 | mackie | 940 | 1736 | 1957-01-01 | 311 | ||
383 | 383 | 1452 | 742 | 1957-01-27 | 554 | |||
384 | 384 | 1452 | 1194 | 1957-01-27 | 555 | |||
149 | 149 | 912 | 358 | 1957-03-17 | 219 | |||
142 | 142 | rferl | 1108 | 395 | 1957-04-21 | 210 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");