info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by type descending
This data as json, CSV (advanced)
Link | rowid | id | table_id | column_number | name | type ▲ | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
229 | 229 | 280 | info_id 48 | 5 | name | text | 0 | 0 | id name | |
232 | 232 | 283 | info_id 48 | 4 | short | text | 0 | 0 | short name | |
233 | 233 | 284 | info_id 48 | 2 | table_variable | text | 0 | 0 | name of table and variable (format: tablename_variablename) | |
240 | 240 | 293 | 49 | 18 | comment | text | 0 | 0 | additional information about the coding of this observation | |
252 | 252 | 306 | view_party 52 | 3 | party_name_short | text | 0 | 0 | party abbreviation | |
253 | 253 | 307 | view_party 52 | 4 | party_name_english | text | 0 | 0 | English name of party | |
254 | 254 | 308 | view_party 52 | 6 | party_name_ascii | text | 0 | 0 | original name of party without special characters (this one may be easier to handle with in statistical packages) | |
261 | 261 | 321 | view_party 52 | 8 | family_name | text | 0 | 0 | party family name | |
262 | 262 | 322 | view_party 52 | 7 | family_name_short | text | 0 | 0 | party family abbreviation | |
266 | 266 | 327 | view_election 53 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
267 | 267 | 328 | view_election 53 | 3 | election_type | text | 0 | 0 | type of election -- 'parliament' or 'ep' election | |
275 | 275 | 336 | view_election 53 | 8 | party_name_short | text | 0 | 0 | party abbreviation | |
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) | |
277 | 277 | 339 | view_election 53 | 10 | party_name_english | text | 0 | 0 | English name of party | |
279 | 279 | 344 | view_cabinet 54 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
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) | |
286 | 286 | 351 | view_cabinet 54 | 11 | party_name_short | text | 0 | 0 | party abbreviation | |
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) | |
288 | 288 | 353 | view_cabinet 54 | 13 | party_name_english | text | 0 | 0 | English name of party | |
290 | 290 | 355 | view_party 52 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
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 |
303 | 303 | 374 | country 19 | 22 | comment | text | 0 | 0 | additional information about the coding of this observation | |
316 | 316 | 388 | external_party_ray 56 | 3 | nation | text | 0 | 0 | country name | |
318 | 318 | 390 | external_party_ray 56 | 5 | party | text | 0 | 0 | party name short | |
319 | 319 | 391 | external_party_ray 56 | 6 | ename | text | 0 | 0 | party name english | |
320 | 320 | 392 | external_party_ray 56 | 7 | name | text | 0 | 0 | party name | |
322 | 322 | 403 | external_party_ees 55 | 2 | country | text | 0 | 0 | EES country name (European Parliament Election Study 2009) | |
323 | 323 | 404 | external_party_ees 55 | 3 | name | text | 0 | 0 | EES party name (European Parliament Election Study 2009) | |
324 | 324 | 405 | external_party_ees 55 | 4 | name_english | text | 0 | 0 | EES party name english (European Parliament Election Study 2009) | |
325 | 325 | 409 | party_change 21 | 6 | 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' | |
326 | 326 | 410 | party_name_change 30 | 10 | 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' | |
327 | 327 | 411 | party 29 | 13 | 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. |
328 | 328 | 412 | party 29 | 12 | 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' | |
329 | 329 | 414 | 49 | 17 | 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' | |
334 | 334 | 420 | 61 | short | text | 0 | 0 | |||
335 | 335 | 421 | 61 | name | text | 0 | 0 | |||
339 | 339 | 426 | 65 | 4 | comment | text | 0 | 0 | additional information about the coding of this observation | |
345 | 345 | 433 | 67 | 6 | 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' | |
346 | 346 | 434 | 67 | 8 | comment | text | 0 | 0 | additional information about the coding of this observation | |
347 | 347 | 436 | 67 | 7 | 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. |
356 | 356 | 445 | 68 | 13 | 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' | |
358 | 358 | 447 | 68 | 16 | comment | text | 0 | 0 | additional information about the coding of this observation | |
359 | 359 | 448 | 68 | 15 | 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. |
363 | 363 | 453 | 61 | comment | text | 0 | 0 | additional information about the coding of this observation | ||
364 | 364 | 455 | country 19 | 9 | ees | text | 0 | 0 | European Election Study (2009) country ID | |
367 | 367 | 462 | election_result 8 | 12 | 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. |
379 | 379 | 477 | 70 | 7 | 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' | |
381 | 381 | 480 | 70 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
382 | 382 | 481 | cabinet_party 5 | 8 | 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. |
383 | 383 | 482 | country 19 | 10 | morgan | text | 0 | 0 | Morgan (1976) expert survey country ID | |
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 | |
395 | 395 | 495 | 72 | 4 | name | text | 0 | 0 | ||
397 | 397 | 497 | 72 | 2 | 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. |
398 | 398 | 498 | 72 | 1 | comment | text | 0 | 0 | additional information about the coding of this observation | |
399 | 399 | 499 | external_commissioner_doering 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
402 | 402 | 503 | party_name_change 30 | 11 | 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. |
403 | 403 | 505 | party_change 21 | 7 | 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. |
410 | 410 | 513 | politician_president 73 | 6 | person_id_source | text | 0 | 0 | ||
412 | 412 | 516 | politician_president 73 | 9 | 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' | |
413 | 413 | 517 | politician_president 73 | 10 | 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. |
414 | 414 | 518 | politician_president 73 | 11 | comment | text | 0 | 0 | additional information about the coding of this observation | |
415 | 415 | 520 | view_variable 74 | 1 | table_name | text | 0 | 0 | name of table in ParlGov database | |
416 | 416 | 521 | view_variable 74 | 3 | name | text | 0 | 0 | name of variable in ParlGov database | |
417 | 417 | 522 | view_variable 74 | 2 | type | text | 0 | 0 | type of data (text, integer, real, binary, date) | |
418 | 418 | 523 | view_variable 74 | 4 | 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. |
419 | 419 | 524 | view_variable 74 | 5 | comment | text | 0 | 0 | additional information about the coding of this observation | |
421 | 421 | 526 | 40 | 8 | 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. |
422 | 422 | 527 | 70 | 8 | 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. |
6 | 6 | 8 | election_result 8 | 7 | vote_share | real | 0 | 0 | percentage of votes for a party | |
48 | 48 | 52 | external_commissioner_doering 20 | 17 | score_position | real | 0 | 0 | score for highest position | |
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 |
105 | 105 | 128 | viewcalc_election_parameter 27 | 7 | polarization_vote | real | 0 | 0 | polarization index (Dalton 2008, 906) – vote share based with 'view_calc_party_position' left/right values | |
106 | 106 | 129 | viewcalc_election_parameter 27 | 6 | advantage_ratio | real | 0 | 0 | advantage ratio (Taagepera/Shugart 1989) | |
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) | |
172 | 172 | 203 | external_party_huber_inglehart 28 | 6 | left_right | real | 0 | 0 | left/right position | |
173 | 173 | 204 | external_party_huber_inglehart 28 | 7 | range_left | real | 0 | 0 | lower bound of left/right position | |
174 | 174 | 205 | external_party_huber_inglehart 28 | 8 | range_right | real | 0 | 0 | upper bound of left/right position | |
175 | 175 | 206 | external_party_huber_inglehart 28 | 9 | sd | real | 0 | 0 | standard deviation of left/right position | |
186 | 186 | 220 | external_party_castles_mair 3 | 8 | 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 | |
187 | 187 | 221 | external_party_castles_mair 3 | 7 | range_right | real | 0 | 0 | upper 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 | |
259 | 259 | 317 | view_party 52 | 9 | 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 | |
265 | 265 | 326 | viewcalc_party_position 7 | 3 | state_market | real | 0 | 0 | 0--10 scale mean value in 'regulation of the economy' dimension with data from Benoit/Laver 2006 and CHES 2010 | |
272 | 272 | 333 | view_election 53 | 5 | vote_share | real | 0 | 0 | percentage of votes for a party | |
278 | 278 | 340 | view_election 53 | 11 | 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 | |
289 | 289 | 354 | view_cabinet 54 | 14 | 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 | |
294 | 294 | 365 | view_party 52 | 10 | state_market | real | 0 | 0 | 0--10 scale mean value in 'regulation of the economy' dimension with data from Benoit/Laver 2006 and CHES 2010 | |
295 | 295 | 366 | view_party 52 | 11 | liberty_authority | real | 0 | 0 | 0--10 scale mean value in 'libertarian/authoritarian' dimension with data from Benoit/Laver 2006 and CHES 2010 | |
296 | 296 | 367 | view_party 52 | 12 | 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 |
392 | 392 | 492 | viewcalc_country_year_share 71 | 4 | share | real | 0 | 0 | share of year observation covers | |
404 | 404 | 507 | viewcalc_election_parameter 27 | 2 | turnout | real | 0 | 0 | voter turnout – share of 'votes cast' relative to 'electorate' | |
420 | 420 | 525 | viewcalc_election_parameter 27 | 8 | polarization_seats | real | 0 | 0 | polarization index (Dalton 2008, 906) – seats share based with 'view_calc_party_position' left/right values | |
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 | |
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. |
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]) );