info_variable

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

422 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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 1 country 19 24 old_countryID integer 0 0 Previous country ID used versions prior to ParlGov 10/11 -- three digit iso code  
2 2 3 country 19 5 eu_accession_date date 0 0 date of EU accession for EU members -- empty for non-members  
3 3 4 election_result 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 4 5 election_result 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 5 7 election_result 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 6 8 election_result 8 7 vote_share real 0 0 percentage of votes for a party  
7 7 9 election_result 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 8 10 election_result 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 9 11 election 35 20 old_countryID integer 0 0 Previous country ID used versions prior to ParlGov 10/11 -- three digit iso code  
10 10 12 election 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 11 13 election 35 4 date date 0 0 Date the election took place. If the election lasted for several days, we code the last date.  
12 12 14 election 35 9 seats_total integer 0 0 total number of seats  
13 13 15 election 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 14 16 election 35 11 votes_cast integer 0 0 number of votes cast in an election -- including invalid and blank votes  
15 15 17 election 35 10 electorate integer 0 0 number citizens eligible to vote  
16 16 18 election 35 15 comment text 0 0 additional information about the coding of this observation  
17 17 19 party 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 18 20 party 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 19 21 party 29 3 family_id integer 0 0 ParlGov unique party family identifier -- see table 'info_id' for a description  
20 20 22 party 29 4 name_short text 0 0 party abbreviation (original name)  
21 21 23 party 29 5 name_english text 0 0 English name of party  
22 22 24 party 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 23 25 party 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 24 26 party 29 9 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
25 25 27 party 29 14 comment text 0 0 additional information about the coding of this observation  
26 26 28 party 29 16 cmp integer 0 0 Comparative Manifestos Project (CMP) party ID (Budge ea. 2001; Klingemann ea. 2006)  
27 27 29 party 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 28 31 party 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 29 32 party 29 26 chess integer 0 0 Chapel Hill expert survey series (CHESS) party ID (Hooghe ea. 2010; Marks/Steenbergen 2007)  
30 30 33 party 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 31 34 cabinet 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 32 35 cabinet 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 33 36 cabinet 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 34 37 cabinet 12 13 comment text 0 0 additional information about the coding of this observation  
35 35 38 cabinet 12 10 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
36 36 39 external_commissioner_doering 20 3 commission_year integer 0 0 year Commission formed  
37 37 40 external_commissioner_doering 20 2 country_id integer 0 0 ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'.  
38 38 41 external_commissioner_doering 20 5 person_id integer 0 0 ParlGov unique person identifier. Other tables refer to this variable as 'person_id'.  
39 39 42 external_commissioner_doering 20 6 person_id_source text 0 0 textual string with the person name in the data source of the observation  
40 40 43 external_commissioner_doering 20 7 start_date date 0 0 Commissioner entered Commission  
41 41 44 external_commissioner_doering 20 8 end_date date 0 0 Commissioner left Commission  
42 42 45 external_commissioner_doering 20 9 incumbent binary 0 0 member of previous Commission  
43 43 46 external_commissioner_doering 20 10 one_seat binary 0 0 one seat in Commission  
44 44 47 external_commissioner_doering 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 45 49 external_commissioner_doering 20 13 government_party category 0 0 party affiliation at appointment 10 government, 11 opposition, 12 other
46 46 50 external_commissioner_doering 20 15 portfolio text 0 0 Commission portfolio  
47 47 51 external_commissioner_doering 20 16 elected binary 0 0 career with political position before  
48 48 52 external_commissioner_doering 20 17 score_position real 0 0 score for highest position  
49 49 53 external_commissioner_doering 20 18 highest_position text 0 0 highest former position  
50 50 54 external_commissioner_doering 20 14 president binary 0 0 president of Commission  
51 51 55 external_commissioner_doering 20 20 comment text 0 0 additional information about the coding of this observation  
52 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 53 59 50 6 position_ministry_id_source text 0 0 ministerial portfolio for person  
54 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 55 65 50 12 start_date date 0 0 date person took up position  
56 56 66 50 13 end_date date 0 0 date person ended the position  
57 57 67 50 16 comment text 0 0 additional information about the coding of this observation  
58 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 59 69 50 18 old_rowid integer 0 0 Previous ParlGov minister ID in older versions  
60 60 72 49 21 mep_id integer 0 0 identifier on website of European Parliament  
61 61 73 49 3 family_name text 0 0 family name of politician  
62 62 74 49 6 family_name_suffix text 0 0 additons to family name of politician (e.g. Dr., von)  
63 63 75 49 7 first_name text 0 0 first name of politician  
64 64 76 49 10 name_source text 0 0 name of politician in data source  
65 65 77 49 11 wikipedia url 0 0 link to wikipedia entry or other url if no wikipedia entry exists  
66 66 78 49 12 sex_male binary 0 0    
67 67 79 49 13 born_date date 0 0 date of birth  
68 68 80 49 14 death_date date 0 0 date of death  
69 69 81 49 15 born_place text 0 0    
70 70 82 cabinet_party 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 71 83 cabinet_party 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 72 84 cabinet_party 5 4 pm binary 0 0 indicates if the party fills the prime minster position  
73 73 86 external_country_iso 1 6 fips text 0 0 Federal Information Processing Standards (FIPS) country code  
74 74 87 cabinet 12 9 caretaker binary 0 0 caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet  
75 75 88 cabinet 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 76 89 external_country_iso 1 7 iso2 integer 0 0 ISO 3166-1 alpha-2 two-letter country code  
77 77 90 external_country_iso 1 8 iso3 integer 0 0 ISO 3166-1 alpha-3 three-letter country code  
78 78 91 external_country_iso 1 9 isonumeric integer 0 0 ISO 3166-1 numeric 3-digit country code  
79 79 92 50 14 resignation_cause text 0 0 short textual information on the cause of resignation  
80 80 94 party_change 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 81 95 party_change 21 3 party_id_new integer 0 0 party id of the successor party  
82 82 96 party_change 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 83 97 party_name_change 30 12 comment text 0 0 additional information about the coding of this observation  
84 84 101 country 19 21 public binary 0 0 indicates if data for this country is included in ParlGov's stable and development version  
85 85 102 country 19 2 name text 0 0 name of country  
86 86 103 country 19 3 name_short text 0 0 three letter abbreviation of country -- iso alpha code  
87 87 104 country 19 7 cmp integer 0 0 Comparative Manifestos Project (CMP) country ID (Budge ea. 2001 and Klingemann ea. 2006)  
88 88 105 country 19 11 castles_mair text 0 0 Castles/Mair (1983) expert survey country ID  
89 89 110 party_change 21 8 comment text 0 0 additional information about the coding of this observation  
90 90 111 info_table 34 2 type text 0 0 type of the table. either table or view  
91 91 112 info_table 34 3 name text 0 0 name of table in ParlGov database  
92 92 113 info_table 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 93 114 viewcalc_party_position 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 94 115 viewcalc_party_position 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 95 117 viewcalc_party_position 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 96 118 viewcalc_party_position 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 97 119 viewcalc_party_position 7 6 calculation_date text 0 0 date and time calculation was performed with ParlGov R script  
98 98 120 country 19 12 huber_inglehart text 0 0 Huber/Inglehart (1995) expert survey country ID  
99 99 121 country 19 14 chess integer 0 0 Chapel Hill expert survey series (CHESS) country ID (Hooghe ea. 2010; Marks/Steenbergen 2007)  
100 100 122 country 19 15 benoit_laver text 0 0 Benoit/Laver (2006) expert survey country ID (two char iso alpha code)  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE info_variable("id", "table_id", "column_number", "name", "type", "comment_entry", "incomplete", "description", "comment",
   FOREIGN KEY([table_id]) REFERENCES [info_table]([id])
);