party_family

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

26 rows where type_id = 36

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
1 Balgarska Sotsialisticheska Partiya 982 Communist Successor 36
4 Komunisticheska Partiya na Balgariya 1570 Communist Successor 36
6 Komunistická strana Cech a Moravy 1173 Communist Successor 36
9 Magyar Szocialista Párt 1591 Communist Successor 36
11 Lietuvos demokratinė darbo partija 519 Communist Successor 36
12 Lietuvos socialdemokratų partija 1277 Communist Successor 36
13 Latvijas Komunistiskā partija 1260 Communist Successor 36
15 Latvijas Sociālistiskā partija 309 Communist Successor 36
16 Par cilvēka tiesībām vienotā Latvijā 1520 Communist Successor 36
17 Polska Zjednoczone Partia Robotnicza 1077 Communist Successor 36
18 Polskie Stronnictwo Ludowe 664 Communist Successor 36
20 Sojusz Lewicy Demokratycznej 629 Communist Successor 36
22 Partidul Democrat 419 Communist Successor 36
23 Partidul Democrat-Liberal 958 Communist Successor 36
24 Partidul România Mare 713 Communist Successor 36
25 Partidul Social Democrat 1120 Communist Successor 36
26 Partidul Socialist al Muncii 562 Communist Successor 36
27 Komunistická strana Slovenska 44 Communist Successor 36
28 Strana demokratickej ľavice 1415 Communist Successor 36
29 Liberalna demokracija Slovenije 1252 Communist Successor 36
30 Združena lista – Socialni demokrati 706 Communist Successor 36
358 Latvijas Vienības Partija 1042 Communist Successor 36
466 Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" 2173 Communist Successor 36
473 Koalitsiya za Balgariya | Demokratichna Levitsa 1160 Communist Successor 36
732 PDS | Die Linke 791 Communist Successor 36
781 Magyar Munkáspárt 1202 Communist Successor 36

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "party_family" (
    "id" integer NOT NULL PRIMARY KEY,
    "party_id" integer NOT NULL REFERENCES "party" ("id"),
    "type_id" integer NOT NULL REFERENCES "info_id" ("id")
);
CREATE INDEX "party_family_764fa81" ON "party_family" ("party_id");
CREATE INDEX "party_family_777d41c8" ON "party_family" ("type_id");