party_family

Table actions

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

18 rows where type_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ party_id type_id
529 one seat 952 one seat 101
530 one seat 474 one seat 101
728 one seat 2288 one seat 101
730 one seat 2294 one seat 101
731 one seat 2295 one seat 101
733 one seat 2296 one seat 101
734 one seat 2297 one seat 101
735 one seat 2298 one seat 101
736 one seat 2299 one seat 101
737 one seat 2300 one seat 101
750 one seat 2302 one seat 101
751 one seat 2303 one seat 101
766 Reshimat HaLohmim 2309 one seat 101
848 one seat 652 one seat 101
849 one seat 441 one seat 101
881 one seat 2413 one seat 101
966 one-seat 2686 one seat 101
1163 one seat 2859 one seat 101

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