info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by description descending
This data as json, CSV (advanced)
Link | rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description ▲ | comment |
---|---|---|---|---|---|---|---|---|---|---|
114 | 114 | 137 | party_name_change 30 | 8 | name_ascii | text | 0 | 0 | original name of party without special characters | |
131 | 131 | 154 | party 29 | 8 | name_nonlatin | text | 0 | 0 | original name of party with non-latin native characters (this field may require a change of character encodings on your local computer) | |
132 | 132 | 155 | party_name_change 30 | 9 | name_nonlatin | text | 0 | 0 | original name of party with non-latin native characters (this field may require a change of character encodings on your local computer) | |
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) | |
115 | 115 | 138 | party_name_change 30 | 7 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
119 | 119 | 142 | 38 | 4 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
153 | 153 | 179 | external_party_chess 11 | 4 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
160 | 160 | 186 | external_party_cmp 37 | 3 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
170 | 170 | 201 | external_party_huber_inglehart 28 | 4 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
190 | 190 | 224 | external_party_castles_mair 3 | 3 | name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
276 | 276 | 338 | view_election 53 | 9 | party_name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
287 | 287 | 352 | view_cabinet 54 | 12 | party_name | text | 0 | 0 | original name of party with native characters (this field may require a change of character encodings on your local computer) | |
291 | 291 | 356 | view_party 52 | 5 | party_name | text | 0 | 0 | original name of party with native characters | field may require a change of character encodings on your local computer |
43 | 43 | 46 | external_commissioner_doering 20 | 10 | one_seat | binary | 0 | 0 | one seat in Commission | |
368 | 368 | 463 | 50 | 19 | validation | binary | 0 | 0 | observation has been validated with an external source | |
14 | 14 | 16 | election 35 | 11 | votes_cast | integer | 0 | 0 | number of votes cast in an election -- including invalid and blank votes | |
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. |
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. |
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. |
273 | 273 | 334 | view_election 53 | 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. |
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'. |
372 | 372 | 469 | viewcalc_parliament_composition 69 | 4 | seats | 0 | 0 | number of seats in parliament | ||
380 | 380 | 478 | 70 | 6 | seats | integer | 0 | 0 | number of seats in parliament | |
139 | 139 | 162 | 40 | 6 | seats | integer | 0 | 0 | number of seats | |
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 | |
15 | 15 | 17 | election 35 | 10 | electorate | integer | 0 | 0 | number citizens eligible to vote | |
136 | 136 | 159 | 40 | 5 | party_id_new | integer | 0 | 0 | new party affiliation of MPs that change party group | |
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 | |
91 | 91 | 112 | info_table 34 | 3 | name | text | 0 | 0 | name of table in ParlGov database | |
233 | 233 | 284 | info_id 48 | 2 | table_variable | text | 0 | 0 | name of table and variable (format: tablename_variablename) | |
64 | 64 | 76 | 49 | 10 | name_source | text | 0 | 0 | name of politician in data source | |
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 | |
399 | 399 | 499 | external_commissioner_doering 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
53 | 53 | 59 | 50 | 6 | position_ministry_id_source | text | 0 | 0 | ministerial portfolio for person | |
42 | 42 | 45 | external_commissioner_doering 20 | 9 | incumbent | binary | 0 | 0 | member of previous Commission | |
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 | |
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 | |
172 | 172 | 203 | external_party_huber_inglehart 28 | 6 | left_right | real | 0 | 0 | left/right position | |
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) | |
198 | 198 | 232 | external_country_iso 1 | 10 | internet | text | 0 | 0 | internet country level domain | |
225 | 225 | 276 | 47 | 2 | datasource_id | integer | 0 | 0 | info_data_source ID | |
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 | |
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 | |
60 | 60 | 72 | 49 | 21 | mep_id | integer | 0 | 0 | identifier on website of European Parliament | |
389 | 389 | 488 | viewcalc_country_year_share 71 | 1 | id_type | integer | 0 | 0 | identifier for observation id variable (cabinet, national or EP election) | |
229 | 229 | 280 | info_id 48 | 5 | name | text | 0 | 0 | id name | |
338 | 338 | 425 | 65 | 2 | ministry_country_id | 0 | 0 | id in table 'minister_ministry_country_id' | ||
49 | 49 | 53 | external_commissioner_doering 20 | 18 | highest_position | text | 0 | 0 | highest former position | |
144 | 144 | 167 | info_data_source 41 | 4 | full | text | 0 | 0 | full reference | |
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) |
63 | 63 | 75 | 49 | 7 | first_name | text | 0 | 0 | first 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) | |
61 | 61 | 73 | 49 | 3 | family_name | text | 0 | 0 | family name of politician | |
343 | 343 | 430 | 67 | 3 | type_id | integer | 0 | 1 | experimental coding type of cabinet support | |
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 | |
109 | 109 | 132 | viewcalc_election_parameter 27 | 3 | enp_votes | real | 0 | 0 | effective number of parties votes – elected parties (Laakso/Taagepera 1979) | |
108 | 108 | 131 | viewcalc_election_parameter 27 | 4 | enp_seats | real | 0 | 0 | effective number of parties seats – legislative parties (Laakso/Taagepera 1979) | |
107 | 107 | 130 | viewcalc_election_parameter 27 | 5 | disproportionality | real | 0 | 0 | disproportionality index (Gallagher 1991) | |
227 | 227 | 278 | info_id 48 | 6 | description | text | 0 | 0 | description of id | |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
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 | |
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. |
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. |
378 | 378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition parliament | |
370 | 370 | 467 | viewcalc_parliament_composition 69 | 2 | date | date | 0 | 0 | date of party composition of parliament | |
68 | 68 | 80 | 49 | 14 | death_date | date | 0 | 0 | date of death | |
67 | 67 | 79 | 49 | 13 | born_date | date | 0 | 0 | date of birth | |
130 | 130 | 153 | country 19 | 4 | oecd_accession_date | date | 0 | 0 | date of OECD accession for OECD members -- empty for non-members | |
2 | 2 | 3 | country 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members | |
374 | 374 | 471 | viewcalc_parliament_composition 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
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 | |
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 | |
194 | 194 | 228 | external_country_iso 1 | 2 | continent | text | 0 | 0 | continent name | |
125 | 125 | 148 | info_variable 13 | 3 | column_number | text | 0 | 0 | columnr of variable in table | |
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 | |
47 | 47 | 51 | external_commissioner_doering 20 | 16 | elected | binary | 0 | 0 | career with political position before | |
197 | 197 | 231 | external_country_iso 1 | 5 | capital | text | 0 | 0 | capital name | |
301 | 301 | 372 | view_cabinet 54 | 7 | cabinet_party | binary | 0 | 0 | cabinet member vs. opposition party | |
106 | 106 | 129 | viewcalc_election_parameter 27 | 6 | advantage_ratio | real | 0 | 0 | advantage ratio (Taagepera/Shugart 1989) | |
62 | 62 | 74 | 49 | 6 | family_name_suffix | text | 0 | 0 | additons to family name of politician (e.g. Dr., von) | |
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 |
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]) );