view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
23 rows where table_name = "view_party"
This data as json, CSV (advanced)
Suggested facets: type, comment
table_name | type | name | description | comment |
---|---|---|---|---|
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_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 | real | eu_anti_pro | 0--10 scale mean value in 'EU integration' dimension with data from Ray 1999, Benoit/Laver 2006 and CHES 2010 | previously variable 'eu_pro_contra' in ParlGov 11/07 |
view_party | integer | cmp | Comparative Manifestos Project (CMP) party ID (Budge ea. 2001; Klingemann ea. 2006) | |
view_party | integer | euprofiler | EU Profiler (Trechsel/Mair 2009) party ID | |
view_party | integer | ees | European Election Study (2009) party ID | |
view_party | integer | castles_mair | Castles/Mair (1983) expert survey party ID -- combined from number of country and number of party entry in data table (pp. 75--83) | |
view_party | integer | huber_inglehart | Huber/Inglehart (1995) expert survey party ID -- combined from number of country and number of party entry in Appendix 2 (pp. 92--108) | |
view_party | integer | ray | Ray (1999) expert survey party ID -- combined country ID and party ID | |
view_party | integer | benoit_laver | Benoit/Laver (2006) expert survey party ID -- row number of first party entry in original data set | |
view_party | integer | chess | Chapel Hill expert survey series (CHESS) party ID (Hooghe ea. 2010; Marks/Steenbergen 2007) | |
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 |
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;