info_id
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where table_variable = "cabinet_support"
This data as json, CSV (advanced)
Suggested facets: description, wikipedia
id ▼ | table_variable | order | short | name | description | wikipedia | old_id |
---|---|---|---|---|---|---|---|
55 | cabinet_support | 5 | promise | support promise | |||
56 | cabinet_support | 3 | agreement | formal agreement | |||
57 | cabinet_support | 11 | regular | informal regular support | |||
64 | cabinet_support | 13 | irregular | irregular support | |||
66 | cabinet_support | 2 | deputy-minister | deputy minister | |||
121 | cabinet_support | 1 | parliamentary-group | minister and parliamentary group | minister and member of cabinet parliamentary group | ||
122 | cabinet_support | 99 | arab-list | Arab lists | Arab satellite lists (Israel only) | https://en.wikipedia.org/wiki/Arab_satellite_lists |
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");