party_family

Table actions

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

3 rows where type_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
343 National (Country) Party | National Party of Australia 184 Agrarian 2
931 Independent – Thomas (TJ) Maher 2327 Agrarian 2
962 Landbund für Österreich 2681 Agrarian 2

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