view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
6 rows where table_name = "view_cabinet" and type = "text"
This data as json, CSV (advanced)
table_name | type | name | description | comment |
---|---|---|---|---|
view_cabinet | text | country_name_short | three letter abbreviation of country -- iso alpha code | |
view_cabinet | text | country_name | name of country | |
view_cabinet | text | cabinet_name | label/name of cabinet consisting of the family name of the prime minister and a roman numeral if he/she headed more than one cabinet (ascii characters only) | |
view_cabinet | text | party_name_short | party abbreviation | |
view_cabinet | text | party_name | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
view_cabinet | text | party_name_english | English name of party |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_variable AS SELECT tbl.name AS table_name, var.type AS type, var.name AS name, var.description AS description, var.comment AS comment FROM info_variable var INNER JOIN (SELECT * FROM info_table) tbl ON var.table_id = tbl.id WHERE SUBSTR(tbl.name, 1, 5) ='view_' ORDER BY tbl.name DESC, var.column_number ASC;