party_change
Data source: ParlGov · About: simonw/parlgov-datasette
918 rows sorted by data_source
This data as json, CSV (advanced)
Link | rowid | comment | data_source ▼ | description | party_id_new | party_id | date | id |
---|---|---|---|---|---|---|---|---|
242 | 242 | 1441 | 252 | 1989-07-01 | 358 | |||
243 | 243 | 252 | 489 | 1979-07-01 | 359 | |||
244 | 244 | 1311 | 614 | 1968-07-01 | 360 | |||
245 | 245 | 211 | 1605 | 1905-05-21 | 362 | |||
246 | 246 | 538 | 1605 | 1953-07-01 | 363 | |||
247 | 247 | 637 | 135 | 1982-07-29 | 366 | |||
248 | 248 | 645 | 637 | 2006-02-18 | 367 | |||
249 | 249 | 845 | 1361 | 1986-09-04 | 368 | |||
251 | 251 | 647 | 1209 | 1988-06-05 | 370 | |||
254 | 254 | 1523 | 1779 | 1996-07-01 | 374 | |||
255 | 255 | 512 | 1355 | 2001-01-24 | 376 | |||
256 | 256 | 512 | 1104 | 2001-01-24 | 377 | |||
257 | 257 | 1475 | 1330 | 1947-07-01 | 378 | |||
258 | 258 | 1382 | 462 | 2000-04-03 | 379 | |||
259 | 259 | 247 | 1193 | 2002-06-01 | 380 | |||
260 | 260 | 1136 | 837 | 1994-12-10 | 381 | |||
261 | 261 | 528 | 369 | 2001-07-01 | 382 | |||
262 | 262 | 229 | 1292 | 1986-09-05 | 383 | |||
268 | 268 | 1306 | 1253 | 1955-04-07 | 390 | |||
269 | 269 | 244 | 615 | 2005-05-23 | 393 | |||
277 | 277 | 214 | 1828 | 1956-07-01 | 407 | |||
278 | 278 | 214 | 1833 | 1956-07-01 | 408 | |||
286 | 286 | 1841 | 767 | 1969-07-01 | 419 | |||
287 | 287 | 184 | 1929 | 1920-07-01 | 420 | |||
288 | 288 | 184 | 1913 | 1920-07-01 | 421 | |||
289 | 289 | 184 | 1913 | 1920-07-01 | 422 | |||
295 | 295 | 1957 | 750 | 1935-07-01 | 436 | |||
299 | 299 | 26 | 458 | 2009-01-01 | 446 | |||
300 | 300 | 524 | 1180 | 1983-11-27 | 448 | |||
307 | 307 | 915 | 656 | 2002-03-24 | 456 | |||
311 | 311 | 120 | 1411 | 1977-07-01 | 460 | |||
313 | 313 | 184 | 1914 | 1930-07-01 | 463 | |||
315 | 315 | 756 | 1452 | 1989-11-24 | 465 | |||
316 | 316 | 756 | 342 | 1989-11-24 | 466 | |||
317 | 317 | 756 | 1194 | 1989-11-24 | 467 | |||
318 | 318 | 1409 | 742 | 1948-01-24 | 470 | |||
319 | 319 | 3 | 451 | 1948-12-11 | 471 | |||
320 | 320 | 451 | 3 | 1955-10-29 | 472 | |||
321 | 321 | 625 | 300 | 1948-04-01 | 473 | |||
324 | 324 | New party because non of the predecessor parties dominates. | Formed as a federation of several regional parties on 8 January 1991. | 1436 | 1080 | 1991-01-08 | 478 | |
326 | 326 | 1158 | 310 | 1985-07-01 | 482 | |||
327 | 327 | 2040 | 1120 | 1997-07-01 | 484 | |||
328 | 328 | 1015 | 2040 | 2002-07-01 | 485 | |||
329 | 329 | 2041 | 1015 | 1995-07-01 | 486 | |||
330 | 330 | 1015 | 2041 | 2003-07-01 | 487 | |||
332 | 332 | 788 | 265 | 1984-07-01 | 489 | |||
333 | 333 | 360 | 1003 | 1989-07-01 | 490 | |||
335 | 335 | 2064 | 1556 | 1996-07-01 | 492 | |||
342 | 342 | Hideo Den, Yutaka Hara and Yanosuke Narazaki left JSP and formed Shakai Club. The Shakai Club formed the SDF in 1978. | 86 | 940 | 1977-07-01 | 501 | ||
352 | 352 | 306 | 189 | 1989-07-01 | 514 | |||
353 | 353 | 306 | 1239 | 1989-07-01 | 515 | |||
354 | 354 | 2078 | 509 | 2009-06-27 | 516 | |||
355 | 355 | 670 | 270 | 1974-11-01 | 518 | |||
356 | 356 | 59 | 1414 | 1962-07-01 | 519 | |||
357 | 357 | 658 | 59 | 2002-11-17 | 520 | |||
359 | 359 | 456 | 744 | 2002-02-14 | 522 | |||
360 | 360 | 645 | 2084 | 1977-07-01 | 525 | |||
361 | 361 | 135 | 2084 | 1977-07-01 | 526 | |||
362 | 362 | 1015 | 2087 | 2003-04-19 | 528 | |||
363 | 363 | 1015 | 2088 | 1998-07-01 | 529 | |||
364 | 364 | 2093 | 1441 | 2010-06-27 | 530 | |||
365 | 365 | 2091 | 47 | 2012-02-24 | 531 | |||
366 | 366 | 2094 | 47 | 2010-11-21 | 532 | |||
370 | 370 | 2099 | 1015 | 1992-05-01 | 536 | |||
375 | 375 | 475 | 896 | 1996-07-01 | 543 | |||
376 | 376 | 961 | 475 | 1999-07-01 | 544 | |||
379 | 379 | 1006 | 2115 | 2009-03-01 | 548 | |||
380 | 380 | 1360 | 228 | 1956-04-04 | 549 | |||
383 | 383 | 1452 | 742 | 1957-01-27 | 554 | |||
384 | 384 | 1452 | 1194 | 1957-01-27 | 555 | |||
385 | 385 | 212 | 300 | 1975-03-15 | 556 | |||
388 | 388 | 2143 | 1539 | 1993-07-01 | 564 | |||
389 | 389 | 1124 | 1193 | 2009-08-08 | 565 | |||
390 | 390 | 4 | 439 | 2005-08-17 | 566 | |||
391 | 391 | 2136 | 439 | 2012-09-12 | 567 | |||
392 | 392 | 1056 | 1277 | 2008-07-01 | 574 | |||
393 | 393 | 217 | 1033 | 1953-10-01 | 580 | |||
394 | 394 | 234 | 411 | 1993-07-01 | 581 | |||
395 | 395 | 1645 | 1000 | 2001-11-10 | 587 | |||
396 | 396 | 220 | 1651 | 2005-01-01 | 589 | |||
399 | 399 | 131 | 1432 | 2000-02-18 | 592 | |||
400 | 400 | 760 | 93 | 2001-03-06 | 593 | |||
401 | 401 | 93 | 760 | 2011-02-28 | 594 | |||
402 | 402 | 52 | 226 | 2005-06-25 | 595 | |||
403 | 403 | 596 | 52 | 2009-03-29 | 596 | |||
404 | 404 | PSI was dissolved and its members joined various groups. SI is not the primary PSI successor and is therefore coded as a new party. | 1278 | 1475 | 1994-11-13 | 597 | ||
407 | 407 | 2160 | 1142 | 2002-07-01 | 603 | |||
408 | 408 | 1321 | 1424 | 1991-06-09 | 604 | |||
409 | 409 | 1088 | 968 | 1984-11-25 | 605 | |||
410 | 410 | 1656 | 500 | 2010-07-01 | 606 | |||
417 | 417 | 2181 | 1044 | 2009-07-01 | 614 | |||
418 | 418 | 827 | 896 | 1993-07-01 | 615 | |||
419 | 419 | 366 | 1633 | 1991-01-24 | 616 | |||
420 | 420 | 961 | 366 | 1996-07-01 | 617 | |||
422 | 422 | 1005 | 961 | 2002-03-24 | 619 | |||
423 | 423 | 323 | 373 | 2003-11-28 | 621 | |||
424 | 424 | 373 | 323 | 2007-07-01 | 622 | |||
425 | 425 | 596 | 323 | 2009-03-29 | 623 | |||
426 | 426 | 596 | 397 | 1998-07-01 | 624 | |||
427 | 427 | 1457 | 1102 | 1998-01-24 | 625 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_change("comment", "data_source", "description", "party_id_new", "party_id", "date", "id");