view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
39 rows where comment = ""
This data as json, CSV (advanced)
Suggested facets: table_name, type, name, description
table_name | type | name | description | comment |
---|---|---|---|---|
view_variable | text | table_name | name of table in ParlGov database | |
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_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_party | real | left_right | 0--10 scale mean value in left/right dimension with data from Castles/Mair 1983, Huber/Inglehart 1995, Benoit/Laver 2006 and CHES 2010 | |
view_party | real | state_market | 0--10 scale mean value in 'regulation of the economy' dimension with data from Benoit/Laver 2006 and CHES 2010 | |
view_party | real | liberty_authority | 0--10 scale mean value in 'libertarian/authoritarian' dimension with data from Benoit/Laver 2006 and CHES 2010 | |
view_party | integer | ees | European Election Study (2009) party ID | |
view_party | integer | country_id | ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'. | |
view_party | integer | party_id | party id | |
view_party | integer | family_id | ParlGov unique party family identifier -- see table 'info_id' for a description | |
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 | date | election_date | Date the election took place. If the election lasted for several days, we code the last date. | |
view_election | real | left_right | 0--10 scale mean value in left/right dimension with data from Castles/Mair 1983, Huber/Inglehart 1995, Benoit/Laver 2006 and CHES 2010 | |
view_election | integer | country_id | ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'. | |
view_election | integer | election_id | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
view_election | integer | previous_parliament_election_id | 'election_id' of previous national parliament election in the country | |
view_election | integer | previous_cabinet_id | 'cabinet_id' of incumbent government | |
view_election | integer | party_id | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
view_cabinet | text | country_name_short | three letter abbreviation of country -- iso alpha code | |
view_cabinet | text | country_name | name of country | |
view_cabinet | date | election_date | Date the election took place. If the election lasted for several days, we code the last date. | |
view_cabinet | binary | caretaker | caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet | |
view_cabinet | binary | cabinet_party | cabinet member vs. opposition party | |
view_cabinet | binary | prime_minister | indicates if the party fills the prime minster position | |
view_cabinet | integer | election_seats_total | seats total in parliament | |
view_cabinet | real | left_right | 0--10 scale mean value in left/right dimension with data from Castles/Mair 1983, Huber/Inglehart 1995, Benoit/Laver 2006 and CHES 2010 | |
view_cabinet | integer | country_id | ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'. | |
view_cabinet | integer | election_id | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
view_cabinet | integer | cabinet_id | ParlGov unique identifier for each cabinet. Variable name 'id' in 'cabinet' table and 'cabinet_id' in all other tables. | |
view_cabinet | integer | previous_cabinet_id | 'cabinet_id' of previous national cabinet in the country | |
view_cabinet | integer | party_id | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. |
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;
comment 1 ✖