party_family

Table actions

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

2 rows where party_id = 1496

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
330 Conservatives and National Liberals 1496 electoral alliance 27
626 Conservatives and National Liberals 1496 Liberal 6

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