party_family

Table actions

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

7 rows where type_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
394 Liberal-Labour 2085 Social democracy 11
479 Cristiano Sociali 1431 Social democracy 11
598 Esquerra Republicana de Catalunya 757 Social democracy 11
604 Eusko Alkartasuna 845 Social democracy 11
723 Union pour la cinquième république 2284 Social democracy 11
859 Livre – Liberdade, Esquerda, Europa e Ecologia 2374 Social democracy 11
1032 PRO România 2746 Social democracy 11

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");