parlgov
Data source: ParlGov · About: simonw/parlgov-datasette
rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|
229 | 280 | 48 | 5 | name | text | 0 | 0 | id name | |
232 | 283 | 48 | 4 | short | text | 0 | 0 | short name | |
233 | 284 | 48 | 2 | table_variable | text | 0 | 0 | name of table and variable (format: tablename_variablename) | |
240 | 293 | 49 | 18 | comment | text | 0 | 0 | additional information about the coding of this observation | |
252 | 306 | 52 | 3 | party_name_short | text | 0 | 0 | party abbreviation | |
253 | 307 | 52 | 4 | party_name_english | text | 0 | 0 | English name of party | |
254 | 308 | 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 | 321 | 52 | 8 | family_name | text | 0 | 0 | party family name | |
262 | 322 | 52 | 7 | family_name_short | text | 0 | 0 | party family abbreviation | |
266 | 327 | 53 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
267 | 328 | 53 | 3 | election_type | text | 0 | 0 | type of election -- 'parliament' or 'ep' election | |
275 | 336 | 53 | 8 | party_name_short | text | 0 | 0 | party abbreviation | |
276 | 338 | 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 | 339 | 53 | 10 | party_name_english | text | 0 | 0 | English name of party | |
279 | 344 | 54 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
285 | 350 | 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 | 351 | 54 | 11 | party_name_short | text | 0 | 0 | party abbreviation | |
287 | 352 | 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 | 353 | 54 | 13 | party_name_english | text | 0 | 0 | English name of party | |
290 | 355 | 52 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
291 | 356 | 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 | 374 | 19 | 22 | comment | text | 0 | 0 | additional information about the coding of this observation | |
316 | 388 | 56 | 3 | nation | text | 0 | 0 | country name | |
318 | 390 | 56 | 5 | party | text | 0 | 0 | party name short | |
319 | 391 | 56 | 6 | ename | text | 0 | 0 | party name english | |
320 | 392 | 56 | 7 | name | text | 0 | 0 | party name | |
322 | 403 | 55 | 2 | country | text | 0 | 0 | EES country name (European Parliament Election Study 2009) | |
323 | 404 | 55 | 3 | name | text | 0 | 0 | EES party name (European Parliament Election Study 2009) | |
324 | 405 | 55 | 4 | name_english | text | 0 | 0 | EES party name english (European Parliament Election Study 2009) | |
325 | 409 | 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 | 410 | 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 | 411 | 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 | 412 | 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 | 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 | 420 | 61 | short | text | 0 | 0 | |||
335 | 421 | 61 | name | text | 0 | 0 | |||
339 | 426 | 65 | 4 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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 | 434 | 67 | 8 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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 | 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 | 447 | 68 | 16 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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 | 453 | 61 | comment | text | 0 | 0 | additional information about the coding of this observation | ||
364 | 455 | 19 | 9 | ees | text | 0 | 0 | European Election Study (2009) country ID | |
367 | 462 | 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 | 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 | 480 | 70 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
382 | 481 | 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 | 482 | 19 | 10 | morgan | text | 0 | 0 | Morgan (1976) expert survey country ID | |
386 | 485 | 54 | 2 | country_name | text | 0 | 0 | name of country | |
387 | 486 | 53 | 2 | country_name | text | 0 | 0 | name of country | |
388 | 487 | 52 | 2 | country_name | text | 0 | 0 | name of country | |
395 | 495 | 72 | 4 | name | text | 0 | 0 | ||
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 | 498 | 72 | 1 | comment | text | 0 | 0 | additional information about the coding of this observation | |
399 | 499 | 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
402 | 503 | 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 | 505 | 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 | 513 | 73 | 6 | person_id_source | text | 0 | 0 | ||
412 | 516 | 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 | 517 | 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 | 518 | 73 | 11 | comment | text | 0 | 0 | additional information about the coding of this observation | |
415 | 520 | 74 | 1 | table_name | text | 0 | 0 | name of table in ParlGov database | |
416 | 521 | 74 | 3 | name | text | 0 | 0 | name of variable in ParlGov database | |
417 | 522 | 74 | 2 | type | text | 0 | 0 | type of data (text, integer, real, binary, date) | |
418 | 523 | 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 | 524 | 74 | 5 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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 | 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 | 8 | 8 | 7 | vote_share | real | 0 | 0 | percentage of votes for a party | |
48 | 52 | 20 | 17 | score_position | real | 0 | 0 | score for highest position | |
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 |
105 | 128 | 27 | 7 | polarization_vote | real | 0 | 0 | polarization index (Dalton 2008, 906) – vote share based with 'view_calc_party_position' left/right values | |
106 | 129 | 27 | 6 | advantage_ratio | real | 0 | 0 | advantage ratio (Taagepera/Shugart 1989) | |
107 | 130 | 27 | 5 | disproportionality | real | 0 | 0 | disproportionality index (Gallagher 1991) | |
108 | 131 | 27 | 4 | enp_seats | real | 0 | 0 | effective number of parties seats – legislative parties (Laakso/Taagepera 1979) | |
109 | 132 | 27 | 3 | enp_votes | real | 0 | 0 | effective number of parties votes – elected parties (Laakso/Taagepera 1979) | |
172 | 203 | 28 | 6 | left_right | real | 0 | 0 | left/right position | |
173 | 204 | 28 | 7 | range_left | real | 0 | 0 | lower bound of left/right position | |
174 | 205 | 28 | 8 | range_right | real | 0 | 0 | upper bound of left/right position | |
175 | 206 | 28 | 9 | sd | real | 0 | 0 | standard deviation of left/right position | |
186 | 220 | 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 | 221 | 3 | 7 | range_right | real | 0 | 0 | upper bound of left/right position | |
188 | 222 | 3 | 6 | range_left | real | 0 | 0 | lower bound of left/right position | |
259 | 317 | 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 | 326 | 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 | 333 | 53 | 5 | vote_share | real | 0 | 0 | percentage of votes for a party | |
278 | 340 | 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 | 354 | 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 | 365 | 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 | 366 | 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 | 367 | 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 | 492 | 71 | 4 | share | real | 0 | 0 | share of year observation covers | |
404 | 507 | 27 | 2 | turnout | real | 0 | 0 | voter turnout – share of 'votes cast' relative to 'electorate' | |
420 | 525 | 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 | 19 | 24 | old_countryID | integer | 0 | 0 | Previous country ID used versions prior to ParlGov 10/11 -- three digit iso code | |
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. |