info_id
Data source: ParlGov · About: simonw/parlgov-datasette
6 rows where table_variable = "party_change_type" sorted by table_variable
This data as json, CSV (advanced)
id | table_variable ▼ | order | short | name | description | wikipedia | old_id |
---|---|---|---|---|---|---|---|
31 | party_change_type | 4 | splinter | splinter group | New party is formed as splinter group of another party. | ||
32 | party_change_type | 3 | division | division | One party divides into two or more new parties. | ||
33 | party_change_type | 1 | merged | merger | New party is formed by merging two or more parties that cede to exist. | ||
34 | party_change_type | 2 | joined | joining larger group | Party joins a larger group without forming a new party. | ||
35 | party_change_type | 5 | successor | successor | Successor party formed by former activists of the predecessor party that ceased to exist. | ||
62 | party_change_type | 6 | politician | single politician | formed by single (prominent) politician |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "info_id" ( "id" integer NOT NULL PRIMARY KEY, "table_variable" varchar(100) NOT NULL, "order" integer unsigned NOT NULL, "short" varchar(10) NOT NULL, "name" varchar(50) NOT NULL, "description" text, "wikipedia" varchar(200), "old_id" integer unsigned, UNIQUE ("table_variable", "short") ); CREATE INDEX "info_id_67219af6" ON "info_id" ("table_variable"); CREATE INDEX "info_id_3ba08eca" ON "info_id" ("order"); CREATE INDEX "info_id_2ffcd08c" ON "info_id" ("short");