party_family

Table actions

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

5 rows where type_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
356 The Christian Party – Christian Peoples Alliance in England 2063 Christian democracy 3
651 Magyar Demokrata Fórum 546 Christian democracy 3
709 Tripartisme – Troisième force 2279 Christian democracy 3
724 Union pour la cinquième république 2284 Christian democracy 3
892 Suomen Kristillisen Työväen Liitto – Finlands kristliga arbetarförbund 2433 Christian democracy 3

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