info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by description
This data as json, CSV (advanced)
Link | rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description ▼ | comment |
---|---|---|---|---|---|---|---|---|---|---|
236 | 236 | 287 | 50 | 7 | acting | binary | 0 | 0 | acting minister | |
16 | 16 | 18 | election 35 | 15 | comment | text | 0 | 0 | additional information about the coding of this observation | |
25 | 25 | 27 | party 29 | 14 | comment | text | 0 | 0 | additional information about the coding of this observation | |
34 | 34 | 37 | cabinet 12 | 13 | comment | text | 0 | 0 | additional information about the coding of this observation | |
51 | 51 | 55 | external_commissioner_doering 20 | 20 | comment | text | 0 | 0 | additional information about the coding of this observation | |
57 | 57 | 67 | 50 | 16 | comment | text | 0 | 0 | additional information about the coding of this observation | |
83 | 83 | 97 | party_name_change 30 | 12 | comment | text | 0 | 0 | additional information about the coding of this observation | |
89 | 89 | 110 | party_change 21 | 8 | comment | text | 0 | 0 | additional information about the coding of this observation | |
101 | 101 | 124 | election_result 8 | 13 | comment | text | 0 | 0 | additional information about the coding of this observation | |
102 | 102 | 125 | cabinet_party 5 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
138 | 138 | 161 | 40 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
164 | 164 | 194 | external_party_cmp 37 | 5 | comment | text | 0 | 0 | additional information about the coding of this observation | |
165 | 165 | 196 | 38 | 7 | comment | text | 0 | 0 | additional information about the coding of this observation | |
200 | 200 | 234 | info_table 34 | 6 | comment | text | 0 | 0 | additional information about the coding of this observation | |
212 | 212 | 254 | info_variable 13 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
240 | 240 | 293 | 49 | 18 | comment | text | 0 | 0 | additional information about the coding of this observation | |
303 | 303 | 374 | country 19 | 22 | comment | text | 0 | 0 | additional information about the coding of this observation | |
339 | 339 | 426 | 65 | 4 | comment | text | 0 | 0 | additional information about the coding of this observation | |
346 | 346 | 434 | 67 | 8 | comment | text | 0 | 0 | additional information about the coding of this observation | |
358 | 358 | 447 | 68 | 16 | comment | text | 0 | 0 | additional information about the coding of this observation | |
363 | 363 | 453 | 61 | comment | text | 0 | 0 | additional information about the coding of this observation | ||
381 | 381 | 480 | 70 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
398 | 398 | 498 | 72 | 1 | comment | text | 0 | 0 | additional information about the coding of this observation | |
414 | 414 | 518 | politician_president 73 | 11 | comment | text | 0 | 0 | additional information about the coding of this observation | |
419 | 419 | 524 | view_variable 74 | 5 | comment | text | 0 | 0 | additional information about the coding of this observation | |
62 | 62 | 74 | 49 | 6 | family_name_suffix | text | 0 | 0 | additons to family name of politician (e.g. Dr., von) | |
106 | 106 | 129 | viewcalc_election_parameter 27 | 6 | advantage_ratio | real | 0 | 0 | advantage ratio (Taagepera/Shugart 1989) | |
301 | 301 | 372 | view_cabinet 54 | 7 | cabinet_party | binary | 0 | 0 | cabinet member vs. opposition party | |
197 | 197 | 231 | external_country_iso 1 | 5 | capital | text | 0 | 0 | capital name | |
47 | 47 | 51 | external_commissioner_doering 20 | 16 | elected | binary | 0 | 0 | career with political position before | |
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 | |
284 | 284 | 349 | view_cabinet 54 | 6 | caretaker | binary | 0 | 0 | caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet | |
125 | 125 | 148 | info_variable 13 | 3 | column_number | text | 0 | 0 | columnr of variable in table | |
194 | 194 | 228 | external_country_iso 1 | 2 | continent | text | 0 | 0 | continent name | |
192 | 192 | 226 | external_party_castles_mair 3 | 2 | country | text | 0 | 0 | country name | |
196 | 196 | 230 | external_country_iso 1 | 4 | country | text | 0 | 0 | country name | |
316 | 316 | 388 | external_party_ray 56 | 3 | nation | text | 0 | 0 | country name | |
97 | 97 | 119 | viewcalc_party_position 7 | 6 | calculation_date | text | 0 | 0 | date and time calculation was performed with ParlGov R script | |
104 | 104 | 127 | viewcalc_election_parameter 27 | 9 | calculation_date | text | 0 | 0 | date and time calculation was performed with ParlGov R script | |
374 | 374 | 471 | viewcalc_parliament_composition 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
2 | 2 | 3 | country 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members | |
130 | 130 | 153 | country 19 | 4 | oecd_accession_date | date | 0 | 0 | date of OECD accession for OECD members -- empty for non-members | |
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 | |
370 | 370 | 467 | viewcalc_parliament_composition 69 | 2 | date | date | 0 | 0 | date of party composition of parliament | |
378 | 378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition parliament | |
111 | 111 | 134 | party_name_change 30 | 3 | date | date | 0 | 0 | date of party naming | Coded as 1 July (yyyy-07-01) if exact day and month are unknown. |
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. |
56 | 56 | 66 | 50 | 13 | end_date | date | 0 | 0 | date person ended the position | |
55 | 55 | 65 | 50 | 12 | start_date | date | 0 | 0 | date person took up position | |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
227 | 227 | 278 | info_id 48 | 6 | description | text | 0 | 0 | description of id | |
107 | 107 | 130 | viewcalc_election_parameter 27 | 5 | disproportionality | real | 0 | 0 | disproportionality index (Gallagher 1991) | |
108 | 108 | 131 | viewcalc_election_parameter 27 | 4 | enp_seats | real | 0 | 0 | effective number of parties seats – legislative parties (Laakso/Taagepera 1979) | |
109 | 109 | 132 | viewcalc_election_parameter 27 | 3 | enp_votes | real | 0 | 0 | effective number of parties votes – elected parties (Laakso/Taagepera 1979) | |
220 | 220 | 269 | election 35 | 5 | first_round_election_id | integer | 0 | 0 | election_id of first round election -- technically, two round elections are coded as two observations in table 'election'. this variable links the two rounds | |
343 | 343 | 430 | 67 | 3 | type_id | integer | 0 | 1 | experimental coding type of cabinet support | |
61 | 61 | 73 | 49 | 3 | family_name | text | 0 | 0 | family name of politician | |
231 | 231 | 282 | info_id 48 | 3 | order | integer | 0 | 0 | field to order entries for every id type ('table_variable' entry) | |
63 | 63 | 75 | 49 | 7 | first_name | text | 0 | 0 | first name of politician | |
401 | 401 | 501 | party_name_change 30 | 4 | party_change | binary | 0 | 0 | formation of new party | new party formed that does not meet ParlGov new party coding rule (e.g. successor party) |
144 | 144 | 167 | info_data_source 41 | 4 | full | text | 0 | 0 | full reference | |
49 | 49 | 53 | external_commissioner_doering 20 | 18 | highest_position | text | 0 | 0 | highest former position | |
338 | 338 | 425 | 65 | 2 | ministry_country_id | 0 | 0 | id in table 'minister_ministry_country_id' | ||
229 | 229 | 280 | info_id 48 | 5 | name | text | 0 | 0 | id name | |
389 | 389 | 488 | viewcalc_country_year_share 71 | 1 | id_type | integer | 0 | 0 | identifier for observation id variable (cabinet, national or EP election) | |
60 | 60 | 72 | 49 | 21 | mep_id | integer | 0 | 0 | identifier on website of European Parliament | |
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 | |
72 | 72 | 84 | cabinet_party 5 | 4 | pm | binary | 0 | 0 | indicates if the party fills the prime minster position | |
298 | 298 | 369 | view_cabinet 54 | 8 | prime_minister | binary | 0 | 0 | indicates if the party fills the prime minster position | |
225 | 225 | 276 | 47 | 2 | datasource_id | integer | 0 | 0 | info_data_source ID | |
198 | 198 | 232 | external_country_iso 1 | 10 | internet | text | 0 | 0 | internet country level domain | |
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) | |
285 | 285 | 350 | view_cabinet 54 | 5 | cabinet_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) | |
172 | 172 | 203 | external_party_huber_inglehart 28 | 6 | left_right | real | 0 | 0 | left/right position | |
24 | 24 | 26 | party 29 | 9 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
35 | 35 | 38 | cabinet 12 | 10 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
65 | 65 | 77 | 49 | 11 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
234 | 234 | 285 | info_id 48 | 7 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
366 | 366 | 460 | election 35 | 7 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
173 | 173 | 204 | external_party_huber_inglehart 28 | 7 | range_left | real | 0 | 0 | lower bound of left/right position | |
188 | 188 | 222 | external_party_castles_mair 3 | 6 | range_left | real | 0 | 0 | lower bound of left/right position | |
42 | 42 | 45 | external_commissioner_doering 20 | 9 | incumbent | binary | 0 | 0 | member of previous Commission | |
53 | 53 | 59 | 50 | 6 | position_ministry_id_source | text | 0 | 0 | ministerial portfolio for person | |
399 | 399 | 499 | external_commissioner_doering 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
85 | 85 | 102 | country 19 | 2 | name | text | 0 | 0 | name of country | |
386 | 386 | 485 | view_cabinet 54 | 2 | country_name | text | 0 | 0 | name of country | |
387 | 387 | 486 | view_election 53 | 2 | country_name | text | 0 | 0 | name of country | |
388 | 388 | 487 | view_party 52 | 2 | country_name | text | 0 | 0 | name of country | |
64 | 64 | 76 | 49 | 10 | name_source | text | 0 | 0 | name of politician in data source | |
233 | 233 | 284 | info_id 48 | 2 | table_variable | text | 0 | 0 | name of table and variable (format: tablename_variablename) | |
91 | 91 | 112 | info_table 34 | 3 | name | text | 0 | 0 | name of table in ParlGov database | |
122 | 122 | 145 | info_variable 13 | 4 | name | text | 0 | 0 | name of variable in ParlGov database | |
416 | 416 | 521 | view_variable 74 | 3 | name | text | 0 | 0 | name of variable in ParlGov database | |
136 | 136 | 159 | 40 | 5 | party_id_new | integer | 0 | 0 | new party affiliation of MPs that change party group | |
15 | 15 | 17 | election 35 | 10 | electorate | integer | 0 | 0 | number citizens eligible to vote | |
176 | 176 | 207 | external_party_huber_inglehart 28 | 10 | respondents | integer | 0 | 0 | number of respondents | |
185 | 185 | 219 | external_party_castles_mair 3 | 9 | respondents | integer | 0 | 0 | number of respondents | |
139 | 139 | 162 | 40 | 6 | seats | integer | 0 | 0 | number of seats | |
304 | 304 | 375 | view_cabinet 54 | 9 | seats | integer | 0 | 0 | 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'. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE info_variable("id", "table_id", "column_number", "name", "type", "comment_entry", "incomplete", "description", "comment", FOREIGN KEY([table_id]) REFERENCES [info_table]([id]) );