view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where type = "integer"
This data as json, CSV (advanced)
Suggested facets: table_name, name, description, comment
table_name | type | name | description | comment |
---|---|---|---|---|
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 | |
view_election | integer | seats | number of seats won by party | Seats coded for alliance members if information available. Coded as 0 for parties that won no seats and as missing value for electoral alliances if seats are coded at the level of alliance members. |
view_election | integer | seats_total | total number of seats | |
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 | integer | seats | number of seats in parliament | In versions prior to ParlGov 11/07, the number of seats was based on seats won at the last election (table 'election_result'). It does now take into account changes in parliament -- see documentation for table 'viewcalc_parliament_composition'. |
view_cabinet | integer | election_seats_total | seats total in parliament | |
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;