party_family

Table actions

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

10 rows where type_id = 19

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
290 Zaļo un Zemnieku savienība 466 Green/Ecologist 19
589 Chunta Aragonesista 1367 Green/Ecologist 19
831 Independent – Indrek Tarand 2029 Green/Ecologist 19
860 Livre – Liberdade, Esquerda, Europa e Ecologia 2374 Green/Ecologist 19
910 Compromís | A la valenciana 2607 Green/Ecologist 19
929 Independent – Luke Flanagan 2369 Green/Ecologist 19
934 Komitee Herbert Maeder 1967 Green/Ecologist 19
938 Viðreisn 2633 Green/Ecologist 19
1107 Movimento 5 Stelle 2155 Green/Ecologist 19
1153 Rakah | Hadash 732 Green/Ecologist 19

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