party_family

Table actions

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

5 rows where type_id = 96

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
682 Social Credit | Democratic Party 1636 Social credit 96
683 Social Credit Party of Canada 1392 Social credit 96
684 Ralliement créditiste 677 Social credit 96
685 Social Credit Party 1911 Social credit 96
688 Union [Candidats] des électeurs 2162 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");