info_id
Data source: ParlGov · About: simonw/parlgov-datasette
8 rows where table_variable = "cabinet_termination" sorted by table_variable
This data as json, CSV (advanced)
Suggested facets: description
id | table_variable ▼ | order | short | name | description | wikipedia | old_id |
---|---|---|---|---|---|---|---|
4 | cabinet_termination | 5 | resignation-pm | resignation -- prime minister | 5 | ||
5 | cabinet_termination | 7 | change-pm | change -- prime minister | 7 | ||
10 | cabinet_termination | 2 | change-party | change -- party composition | change of coalition party composition | 2 | |
15 | cabinet_termination | 1 | election-regular | election -- regular | election at the end of a legislative period | 1 | |
21 | cabinet_termination | 3 | election-dissolution | election -- dissolution | dissolution of parliament and elections before the end of the official term | 3 | |
23 | cabinet_termination | 4 | confidence-vote | losing confidence vote -- RECODE | cabinet fails by loosing e.g. vote of confidence, investiture vote, constructive vote of no-confidence | 4 | |
24 | cabinet_termination | 6 | resignation-cabinet | resignation -- cabinet | 6 | ||
30 | cabinet_termination | 10 | other | other |
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");