info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: column_number, type, comment_entry, comment
Link | rowid ▲ | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
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. |
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. |
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 | |
419 | 419 | 524 | view_variable 74 | 5 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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. |
417 | 417 | 522 | view_variable 74 | 2 | type | text | 0 | 0 | type of data (text, integer, real, binary, date) | |
416 | 416 | 521 | view_variable 74 | 3 | name | text | 0 | 0 | name of variable in ParlGov database | |
415 | 415 | 520 | view_variable 74 | 1 | table_name | text | 0 | 0 | name of table in ParlGov database | |
414 | 414 | 518 | politician_president 73 | 11 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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. |
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' | |
411 | 411 | 514 | politician_president 73 | 7 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Last party affiliation before becoming president used since several constitutions require non-partisan presidents in office. | |
410 | 410 | 513 | politician_president 73 | 6 | person_id_source | text | 0 | 0 | ||
409 | 409 | 512 | politician_president 73 | 5 | person_id | integer | 0 | 0 | ||
408 | 408 | 511 | politician_president 73 | 4 | end_date | date | 0 | 0 | ||
407 | 407 | 510 | politician_president 73 | 3 | start_date | date | 0 | 0 | ||
406 | 406 | 509 | politician_president 73 | 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. | |
405 | 405 | 508 | politician_president 73 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
404 | 404 | 507 | viewcalc_election_parameter 27 | 2 | turnout | real | 0 | 0 | voter turnout – share of 'votes cast' relative to 'electorate' | |
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. |
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. |
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) |
400 | 400 | 500 | external_commissioner_doering 20 | 22 | previous_cabinet_id | integer | 0 | 0 | ParlGov unique cabinet identifier -- cabinet in office at the time of appointment | |
399 | 399 | 499 | external_commissioner_doering 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
398 | 398 | 498 | 72 | 1 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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. |
396 | 396 | 496 | 72 | 6 | type | 0 | 0 | |||
395 | 395 | 495 | 72 | 4 | name | text | 0 | 0 | ||
394 | 394 | 494 | 72 | 5 | table_id | 0 | 0 | |||
393 | 393 | 493 | 72 | 3 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
392 | 392 | 492 | viewcalc_country_year_share 71 | 4 | share | real | 0 | 0 | share of year observation covers | |
391 | 391 | 491 | viewcalc_country_year_share 71 | 3 | id | integer | 0 | 0 | ParlGov unique identifier for cabinet, national or EP election observation in data table | |
390 | 390 | 490 | viewcalc_country_year_share 71 | 2 | year | integer | 0 | 0 | ||
389 | 389 | 488 | viewcalc_country_year_share 71 | 1 | id_type | integer | 0 | 0 | identifier for observation id variable (cabinet, national or EP election) | |
388 | 388 | 487 | view_party 52 | 2 | country_name | text | 0 | 0 | name of country | |
387 | 387 | 486 | view_election 53 | 2 | country_name | text | 0 | 0 | name of country | |
386 | 386 | 485 | view_cabinet 54 | 2 | country_name | text | 0 | 0 | name of country | |
385 | 385 | 484 | 70 | 4 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
384 | 384 | 483 | party 29 | 19 | morgan | integer | 0 | 0 | Morgan (1976) expert survey party ID -- row number of first party entry in original data set | |
383 | 383 | 482 | country 19 | 10 | morgan | text | 0 | 0 | Morgan (1976) expert survey country ID | |
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. |
381 | 381 | 480 | 70 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
380 | 380 | 478 | 70 | 6 | seats | integer | 0 | 0 | number of seats in parliament | |
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' | |
378 | 378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition parliament | |
377 | 377 | 474 | 70 | 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. | |
376 | 376 | 473 | 70 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
375 | 375 | 472 | viewcalc_parliament_composition 69 | 6 | cabinet_formation | binary | 0 | 0 | parliament composition at the date of a cabinet formation | |
374 | 374 | 471 | viewcalc_parliament_composition 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
373 | 373 | 470 | viewcalc_parliament_composition 69 | 5 | cabinet_id | integer | 0 | 0 | ParlGov unique identifier for each cabinet. Variable name 'id' in 'cabinet' table and 'cabinet_id' in all other tables. | |
372 | 372 | 469 | viewcalc_parliament_composition 69 | 4 | seats | 0 | 0 | number of seats in parliament | ||
371 | 371 | 468 | viewcalc_parliament_composition 69 | 3 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
370 | 370 | 467 | viewcalc_parliament_composition 69 | 2 | date | date | 0 | 0 | date of party composition of parliament | |
369 | 369 | 466 | viewcalc_parliament_composition 69 | 1 | 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. | |
368 | 368 | 463 | 50 | 19 | validation | binary | 0 | 0 | observation has been validated with an external source | |
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. |
366 | 366 | 460 | election 35 | 7 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
364 | 364 | 455 | country 19 | 9 | ees | text | 0 | 0 | European Election Study (2009) country ID | |
363 | 363 | 453 | 61 | comment | text | 0 | 0 | additional information about the coding of this observation | ||
362 | 362 | 451 | 68 | 11 | absent | 0 | 0 | |||
361 | 361 | 450 | 68 | 3 | date | 0 | 0 | |||
360 | 360 | 449 | 68 | 12 | total | 0 | 0 | |||
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. |
358 | 358 | 447 | 68 | 16 | comment | text | 0 | 0 | additional information about the coding of this observation | |
357 | 357 | 446 | 68 | 7 | yes | 0 | 0 | |||
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' | |
355 | 355 | 444 | 68 | 9 | abstain | 0 | 0 | |||
354 | 354 | 443 | 68 | 10 | invalid | 0 | 0 | |||
353 | 353 | 442 | 68 | 8 | no | 0 | 0 | |||
352 | 352 | 441 | 68 | 6 | passed | 0 | 0 | |||
351 | 351 | 440 | 68 | 5 | type_id | 0 | 0 | |||
350 | 350 | 439 | 68 | 4 | lower_house | 0 | 0 | |||
349 | 349 | 438 | 68 | 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. | |
348 | 348 | 437 | 68 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
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. |
346 | 346 | 434 | 67 | 8 | 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' | |
344 | 344 | 431 | 67 | 4 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
343 | 343 | 430 | 67 | 3 | type_id | integer | 0 | 1 | experimental coding type of cabinet support | |
342 | 342 | 429 | 67 | 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. | |
341 | 341 | 428 | 67 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
340 | 340 | 427 | view_election 53 | 15 | previous_cabinet_id | integer | 0 | 0 | 'cabinet_id' of incumbent government | |
339 | 339 | 426 | 65 | 4 | comment | text | 0 | 0 | additional information about the coding of this observation | |
338 | 338 | 425 | 65 | 2 | ministry_country_id | 0 | 0 | id in table 'minister_ministry_country_id' | ||
337 | 337 | 424 | 65 | 3 | salience | 0 | 0 | salience measure | ||
336 | 336 | 422 | 65 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
335 | 335 | 421 | 61 | name | text | 0 | 0 | |||
334 | 334 | 420 | 61 | short | text | 0 | 0 | |||
333 | 333 | 419 | 61 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | ||
332 | 332 | 418 | party_family 64 | 3 | type_id | integer | 0 | 0 | ParlGov unique party family identifier -- see table 'info_id' for a description | |
331 | 331 | 417 | party_family 64 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
330 | 330 | 416 | party_family 64 | 2 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
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' | |
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' | |
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. |
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' | |
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' | |
324 | 324 | 405 | external_party_ees 55 | 4 | name_english | text | 0 | 0 | EES party name english (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) |
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]) );