view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where type = "text"
This data as json, CSV (advanced)
Suggested facets: table_name, name, description, comment
table_name | type | name | description | comment |
---|---|---|---|---|
view_variable | text | table_name | name of table in ParlGov database | |
view_variable | text | type | type of data (text, integer, real, binary, date) | |
view_variable | text | name | name of variable in ParlGov database | |
view_variable | text | description | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
view_variable | text | comment | additional information about the coding of this observation | |
view_party | text | country_name_short | three letter abbreviation of country -- iso alpha code | |
view_party | text | country_name | name of country | |
view_party | text | party_name_short | party abbreviation | |
view_party | text | party_name_english | English name of party | |
view_party | text | party_name | original name of party with native characters | field may require a change of character encodings on your local computer |
view_party | text | party_name_ascii | original name of party without special characters (this one may be easier to handle with in statistical packages) | |
view_party | text | family_name_short | party family abbreviation | |
view_party | text | family_name | party family name | |
view_election | text | country_name_short | three letter abbreviation of country -- iso alpha code | |
view_election | text | country_name | name of country | |
view_election | text | election_type | type of election -- 'parliament' or 'ep' election | |
view_election | text | party_name_short | party abbreviation | |
view_election | text | party_name | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
view_election | text | party_name_english | English name of party | |
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;