party_family

Table actions

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

7 rows where type_id = 89

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
234 Liga Lombarda 1560 Autonomy 89
280 Plaid Cymru 311 Autonomy 89
281 Scottish National Party – Pàrtaidh Nàiseanta na h-Alba 1284 Autonomy 89
557 Union Valdôtaine 974 Autonomy 89
599 Esquerra Republicana de Catalunya 757 Autonomy 89
692 Ruch Autonomii Śląska 1208 Autonomy 89
1074 Candidatura d'Unitat Popular 2792 Autonomy 89

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