party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by data_source
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
- …
data_source (date) 0 ✖
Link | rowid | comment | data_source ▼ | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
1 | 1 | 454 | 640 | 1979-07-01 | 1 | |||
4 | 4 | 980 | 249 | 1996-07-01 | 10 | |||
6 | 6 | 226 | 128 | 2002-07-01 | 13 | |||
7 | 7 | 373 | 831 | 1995-07-01 | 14 | |||
8 | 8 | 759 | 384 | 1994-07-01 | 15 | |||
9 | 9 | 521 | 1557 | 1997-07-01 | 17 | |||
10 | 10 | 521 | 203 | 1997-07-01 | 18 | |||
11 | 11 | 519 | 1446 | 1990-07-01 | 19 | |||
13 | 13 | 838 | 18 | 1992-07-01 | 23 | |||
16 | 16 | 1029 | 167 | 1978-07-01 | 28 | |||
17 | 17 | 1378 | 167 | 1978-07-01 | 29 | |||
22 | 22 | 226 | 99 | 2002-07-01 | 40 | |||
23 | 23 | 226 | 627 | 2002-07-01 | 41 | |||
33 | 33 | 885 | 1491 | 1969-07-01 | 54 | |||
34 | 34 | 889 | 1281 | 1987-07-01 | 58 | |||
37 | 37 | 1520 | 32 | 1998-07-01 | 62 | |||
38 | 38 | 1520 | 928 | 1998-07-01 | 63 | |||
39 | 39 | 1520 | 309 | 1998-07-01 | 64 | |||
44 | 44 | 1146 | 1193 | 1993-07-01 | 69 | |||
50 | 50 | 1100 | 32 | 2005-07-01 | 77 | |||
51 | 51 | 1100 | 309 | 2005-07-01 | 78 | |||
58 | 58 | 1436 | 1560 | 1991-07-01 | 91 | |||
59 | 59 | 1058 | 509 | 2007-07-01 | 92 | |||
69 | 69 | 1485 | 1015 | 2006-07-01 | 106 | |||
70 | 70 | 156 | 318 | 1944-07-01 | 107 | |||
72 | 72 | 318 | 1580 | 1999-07-01 | 109 | |||
73 | 73 | 379 | 318 | 1972-07-01 | 110 | |||
74 | 74 | 318 | 156 | 1950-07-01 | 111 | |||
75 | 75 | 380 | 1512 | 2004-07-01 | 112 | |||
78 | 78 | 1446 | 1623 | 1989-07-01 | 115 | |||
83 | 83 | 491 | 768 | 2005-07-01 | 125 | |||
84 | 84 | 226 | 488 | 2002-07-01 | 127 | |||
93 | 93 | 829 | 743 | 1991-07-01 | 139 | |||
96 | 96 | 1327 | 1193 | 1992-07-01 | 145 | |||
100 | 100 | 1145 | 128 | 1998-07-01 | 150 | |||
101 | 101 | 1145 | 99 | 1998-07-01 | 151 | |||
102 | 102 | 1145 | 827 | 1998-07-01 | 152 | |||
103 | 103 | 1145 | 596 | 1998-07-01 | 153 | |||
105 | 105 | 662 | 1043 | 2007-07-01 | 155 | |||
106 | 106 | 662 | 526 | 2007-07-01 | 156 | |||
111 | 111 | 138 | 1094 | 1976-07-01 | 165 | |||
112 | 112 | 1491 | 1086 | 1966-07-01 | 166 | |||
120 | 120 | 176 | 831 | 1995-07-01 | 175 | |||
122 | 122 | 1250 | 1126 | 1982-07-01 | 178 | |||
129 | 129 | 1318 | 628 | 1971-07-01 | 186 | |||
130 | 130 | 564 | 628 | 1971-07-01 | 187 | |||
133 | 133 | 1339 | 701 | 1979-07-01 | 193 | |||
134 | 134 | "One of the two Popular Independent deputies joined the PCS and the rest of the party merged with the Democratic Party immediately before the 1968 election." Mackie/Rose 1991, 301 | 967 | 1462 | 1968-07-01 | 194 | ||
135 | 135 | 1295 | 11 | 1987-07-01 | 199 | |||
145 | 145 | 445 | 521 | 2008-04-26 | 214 | |||
146 | 146 | 725 | 565 | 1986-07-01 | 215 | |||
151 | 151 | 1620 | 559 | 2009-07-01 | 221 | |||
152 | 152 | 1615 | 1142 | 2003-07-01 | 222 | |||
153 | 153 | 1142 | 1061 | 1991-07-01 | 223 | |||
156 | 156 | 1277 | 1408 | 2001-07-01 | 227 | |||
157 | 157 | 1277 | 519 | 2001-07-01 | 228 | |||
158 | 158 | 57 | 423 | 2003-07-01 | 230 | |||
160 | 160 | 1624 | 1142 | 1993-07-01 | 232 | |||
163 | 163 | 906 | 1005 | 2007-07-01 | 235 | |||
165 | 165 | 526 | 42 | 1993-07-01 | 238 | |||
167 | 167 | 1608 | 1656 | 2001-07-01 | 240 | |||
168 | 168 | 309 | 1260 | 1994-07-01 | 244 | |||
169 | 169 | 32 | 1520 | 2003-07-01 | 246 | |||
2 | 2 | 501 | 290 | 2001-10-13 | 5 | |||
3 | 3 | 1360 | 1319 | 1968-11-01 | 8 | |||
5 | 5 | 809 | 1088 | 1991-02-03 | 11 | |||
12 | 12 | 983 | 887 | 2003-05-31 | 20 | |||
14 | 14 | 1104 | 1544 | 1994-04-23 | 24 | |||
15 | 15 | 645 | 135 | 1983-02-18 | 26 | |||
18 | 18 | Party established before election and previous month used for date change. | 723 | 1051 | 1968-04-01 | 30 | ||
19 | 19 | Party established before election and previous month used for date change. | 1192 | 1051 | 1968-04-01 | 31 | ||
20 | 20 | 915 | 969 | 2002-03-24 | 33 | |||
21 | 21 | 310 | 1158 | 1995-07-01 | 39 | |||
24 | 24 | 220 | 1415 | 1999-11-08 | 42 | |||
25 | 25 | 220 | 64 | 2005-01-01 | 43 | |||
26 | 26 | 658 | 138 | 2002-11-17 | 44 | |||
27 | 27 | 1292 | 229 | 1990-04-29 | 47 | |||
28 | 28 | 645 | 1224 | 1989-01-20 | 49 | |||
29 | 29 | 645 | 424 | 1989-01-20 | 50 | |||
31 | 31 | 915 | 454 | 2002-03-24 | 52 | |||
32 | 32 | 1321 | 1088 | 1991-12-12 | 53 | |||
35 | 35 | 509 | 401 | 1978-07-01 | 59 | |||
36 | 36 | 659 | 1547 | 1988-03-02 | 61 | |||
41 | 41 | 1597 | 846 | 2006-06-04 | 66 | |||
42 | 42 | 1597 | 428 | 2006-06-04 | 67 | |||
43 | 43 | 1193 | 1382 | 2003-11-21 | 68 | |||
45 | 45 | no new party because Gruene won 75% of combined votes in previous election | 772 | 255 | 1993-05-14 | 71 | ||
46 | 46 | 482 | 983 | 2006-02-25 | 72 | |||
47 | 47 | 1045 | 675 | 2008-05-17 | 73 | |||
48 | 48 | 1045 | 1447 | 2004-02-07 | 75 | |||
49 | 49 | 1045 | 432 | 2008-03-11 | 76 | |||
52 | 52 | 1209 | 647 | 1972-11-11 | 79 | |||
53 | 53 | 1478 | 1605 | 1965-09-10 | 80 | |||
54 | 54 | 131 | 1000 | 2006-01-21 | 82 | |||
55 | 55 | 1140 | 629 | 2004-03-26 | 84 | |||
56 | 56 | 326 | 1252 | 2007-10-06 | 89 | |||
60 | 60 | 742 | 1451 | 1946-02-09 | 94 | |||
61 | 61 | 742 | 944 | 1946-02-09 | 95 | |||
62 | 62 | 1409 | 944 | 1946-03-23 | 96 | |||
63 | 63 | 4 | 1193 | 2005-08-17 | 100 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");