home / parlgov

info_variable

Data source: ParlGov

419 rows

View and edit SQL

This data as .json

Suggested facets: column_number, type, comment_entry, incomplete, comment

Link rowid id table_id column_number name type comment_entry incomplete description comment
1 1 19 24 old_countryID integer 0 0 Previous country ID used versions prior to ParlGov 10/11 -- three digit iso code
2 3 19 5 eu_accession_date date 0 0 date of EU accession for EU members -- empty for non-members  
3 4 8 2 election_id integer 0 0 ParlGov unique identifier for national and EP elections. Variable name 'id' in 'election' table and 'election_id' in all other tables.
4 5 8 3 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
5 7 8 6 seats integer 0 0 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.
6 8 8 7 vote_share real 0 0 percentage of votes for a party  
7 9 8 8 votes integer 0 1 number of votes Information for this table is not systematically coded for all countries. Please refer to wiki.parlgov.org to get further information about the detail of country codings.
8 10 8 11 data_source text 0 0 short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source'
9 11 35 20 old_countryID integer 0 0 Previous country ID used versions prior to ParlGov 10/11 -- three digit iso code
10 12 35 21 old_parlID integer 0 0 Previous election ID used versions prior to ParlGov 10/11 -- five digit number composed of the year the election took place and an ascending digit
11 13 35 4 date date 0 0 Date the election took place. If the election lasted for several days, we code the last date.
12 14 35 9 seats_total integer 0 0 total number of seats  
13 15 35 12 votes_valid integer 0 0 number of valid votes for parties and candidates -- not including blank votes Based on the number of 'votes_cast' and 'electorate'. For electoral systems with multiple votes cast by each voter a 'data_json' entry 'valid_votes' records the sum of all valid (multiple) votes.
14 16 35 11 votes_cast integer 0 0 number of votes cast in an election -- including invalid and blank votes
15 17 35 10 electorate integer 0 0 number citizens eligible to vote  
16 18 35 15 comment text 0 0 additional information about the coding of this observation
17 19 29 2 country_id integer 0 0 ParlGov unique identifier for each country. Variable name 'id' in 'country' table and 'country_id' in all other tables.
18 20 29 30 old_partyID integer 0 0 Previous party ID used versions prior to ParlGov 10/11 -- a unique number for every party in a country. IDs start at 10 and have no particular order. 990 -- no party affiliation (independent); 995 -- others; 999 -- to be coded
19 21 29 3 family_id integer 0 0 ParlGov unique party family identifier -- see table 'info_id' for a description
20 22 29 4 name_short text 0 0 party abbreviation (original name)
21 23 29 5 name_english text 0 0 English name of party  
22 24 29 7 name_ascii text 0 0 original name of party without special characters (this one may be easier to handle with in statistical packages)  
23 25 29 6 name text 0 0 original name of party with native characters (this field may require a change of character encodings on your local computer)  
24 26 29 9 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
25 27 29 14 comment text 0 0 additional information about the coding of this observation
26 28 29 16 cmp integer 0 0 Comparative Manifestos Project (CMP) party ID (Budge ea. 2001; Klingemann ea. 2006)  
27 29 29 20 castles_mair integer 0 0 Castles/Mair (1983) expert survey party ID -- combined from number of country and number of party entry in data table (pp. 75--83)  
28 31 29 21 huber_inglehart integer 0 0 Huber/Inglehart (1995) expert survey party ID -- combined from number of country and number of party entry in Appendix 2 (pp. 92--108)  
29 32 29 26 chess integer 0 0 Chapel Hill expert survey series (CHESS) party ID (Hooghe ea. 2010; Marks/Steenbergen 2007)  
30 33 29 24 benoit_laver integer 0 0 Benoit/Laver (2006) expert survey party ID -- row number of first party entry in original data set  
31 34 12 2 country_id integer 0 0 ParlGov unique identifier for each country. Variable name 'id' in 'country' table and 'country_id' in all other tables.
32 35 12 19 old_cabID integer 0 0 Previous cabinet ID used versions prior to ParlGov 10/11 -- Five digit number is composed of the year the cabinet came into office and an ascending digit for the number of the cabinet in that year starting with zero.
33 36 12 8 name text 0 0 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)  
34 37 12 13 comment text 0 0 additional information about the coding of this observation
35 38 12 10 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
36 39 20 3 commission_year integer 0 0 year Commission formed
37 40 20 2 country_id integer 0 0 ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'.
38 41 20 5 person_id integer 0 0 ParlGov unique person identifier. Other tables refer to this variable as 'person_id'.
39 42 20 6 person_id_source text 0 0 textual string with the person name in the data source of the observation
40 43 20 7 start_date date 0 0 Commissioner entered Commission  
41 44 20 8 end_date date 0 0 Commissioner left Commission  
42 45 20 9 incumbent binary 0 0 member of previous Commission
43 46 20 10 one_seat binary 0 0 one seat in Commission  
44 47 20 11 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
45 49 20 13 government_party category 0 0 party affiliation at appointment 10 government, 11 opposition, 12 other
46 50 20 15 portfolio text 0 0 Commission portfolio  
47 51 20 16 elected binary 0 0 career with political position before
48 52 20 17 score_position real 0 0 score for highest position  
49 53 20 18 highest_position text 0 0 highest former position  
50 54 20 14 president binary 0 0 president of Commission  
51 55 20 20 comment text 0 0 additional information about the coding of this observation
52 57 50 3 minister_cabinet_id integer 0 0 ParlGov ID for every cabinet in a country. The five digit number is composed of the year the cabinet came into office and an ascending digit for the number of the cabinet in that year starting with zero.  
53 59 50 6 position_ministry_id_source text 0 0 ministerial portfolio for person  
54 63 50 10 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
55 65 50 12 start_date date 0 0 date person took up position  
56 66 50 13 end_date date 0 0 date person ended the position  
57 67 50 16 comment text 0 0 additional information about the coding of this observation
58 68 50 15 data_source text 0 0 short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source'
59 69 50 18 old_rowid integer 0 0 Previous ParlGov minister ID in older versions
60 72 49 21 mep_id integer 0 0 identifier on website of European Parliament  
61 73 49 3 family_name text 0 0 family name of politician  
62 74 49 6 family_name_suffix text 0 0 additons to family name of politician (e.g. Dr., von)  
63 75 49 7 first_name text 0 0 first name of politician  
64 76 49 10 name_source text 0 0 name of politician in data source  
65 77 49 11 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
66 78 49 12 sex_male binary 0 0    
67 79 49 13 born_date date 0 0 date of birth  
68 80 49 14 death_date date 0 0 date of death  
69 81 49 15 born_place text 0 0    
70 82 5 2 cabinet_id integer 0 0 ParlGov unique identifier for each cabinet. Variable name 'id' in 'cabinet' table and 'cabinet_id' in all other tables.
71 83 5 3 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
72 84 5 4 pm binary 0 0 indicates if the party fills the prime minster position  
73 86 1 6 fips text 0 0 Federal Information Processing Standards (FIPS) country code  
74 87 12 9 caretaker binary 0 0 caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet
75 88 12 3 start_date date 0 0 start of cabinet defined as the date of the first event that determines a new cabinet For some (continuation) caretaker cabinet, the date is set to election date.
76 89 1 7 iso2 integer 0 0 ISO 3166-1 alpha-2 two-letter country code  
77 90 1 8 iso3 integer 0 0 ISO 3166-1 alpha-3 three-letter country code  
78 91 1 9 isonumeric integer 0 0 ISO 3166-1 numeric 3-digit country code  
79 92 50 14 resignation_cause text 0 0 short textual information on the cause of resignation  
80 94 21 2 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
81 95 21 3 party_id_new integer 0 0 party id of the successor party
82 96 21 4 date date 0 0 date party change took place Coded as 1 July (yyyy-07-01) if exact day and month are unknown and as first day of month if only month is known.
83 97 30 12 comment text 0 0 additional information about the coding of this observation
84 101 19 21 public binary 0 0 indicates if data for this country is included in ParlGov's stable and development version
85 102 19 2 name text 0 0 name of country
86 103 19 3 name_short text 0 0 three letter abbreviation of country -- iso alpha code
87 104 19 7 cmp integer 0 0 Comparative Manifestos Project (CMP) country ID (Budge ea. 2001 and Klingemann ea. 2006)  
88 105 19 11 castles_mair text 0 0 Castles/Mair (1983) expert survey country ID  
89 110 21 8 comment text 0 0 additional information about the coding of this observation
90 111 34 2 type text 0 0 type of the table. either table or view  
91 112 34 3 name text 0 0 name of table in ParlGov database  
92 113 34 5 description text 0 0 Information about this observation. This field should also include a short textual account of all information that is coded in the 'data_json' field.
93 114 7 1 party_id integer 0 0 ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables.
94 115 7 2 left_right real 0 0 0--10 scale mean value in left/right dimension with data from Castles/Mair 1983, Huber/Inglehart 1995, Benoit/Laver 2006 and CHES 2010
95 117 7 4 liberty_authority real 0 0 0--10 scale mean value in 'libertarian/authoritarian' dimension with data from Benoit/Laver 2006 and CHES 2010
96 118 7 5 eu_anti_pro real 0 0 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
97 119 7 6 calculation_date text 0 0 date and time calculation was performed with ParlGov R script  
98 120 19 12 huber_inglehart text 0 0 Huber/Inglehart (1995) expert survey country ID  
99 121 19 14 chess integer 0 0 Chapel Hill expert survey series (CHESS) country ID (Hooghe ea. 2010; Marks/Steenbergen 2007)  
100 122 19 15 benoit_laver text 0 0 Benoit/Laver (2006) expert survey country ID (two char iso alpha code)  

Next page

CREATE TABLE info_variable("id", "table_id", "column_number", "name", "type", "comment_entry", "incomplete", "description", "comment")
Powered by Datasette · Query took 102.14ms · Data source: ParlGov