party_family

Table actions

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

2 rows where party_id = 1636

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
266 Social Credit | Democratic Party 1636 Anti-establishment 39
682 Social Credit | Democratic Party 1636 Social credit 96

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