info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by table_id descending
This data as json, CSV (advanced)
Suggested facets: column_number, type, comment_entry, incomplete, comment
Link | rowid | id | table_id ▲ | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
405 | 405 | 508 | politician_president 73 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
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. | |
407 | 407 | 510 | politician_president 73 | 3 | start_date | date | 0 | 0 | ||
408 | 408 | 511 | politician_president 73 | 4 | end_date | date | 0 | 0 | ||
409 | 409 | 512 | politician_president 73 | 5 | person_id | integer | 0 | 0 | ||
410 | 410 | 513 | politician_president 73 | 6 | person_id_source | text | 0 | 0 | ||
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. | |
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 | |
393 | 393 | 493 | 72 | 3 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
394 | 394 | 494 | 72 | 5 | table_id | 0 | 0 | |||
395 | 395 | 495 | 72 | 4 | name | text | 0 | 0 | ||
396 | 396 | 496 | 72 | 6 | type | 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 | |
389 | 389 | 488 | viewcalc_country_year_share 71 | 1 | id_type | integer | 0 | 0 | identifier for observation id variable (cabinet, national or EP election) | |
390 | 390 | 490 | viewcalc_country_year_share 71 | 2 | year | integer | 0 | 0 | ||
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 | |
392 | 392 | 492 | viewcalc_country_year_share 71 | 4 | share | real | 0 | 0 | share of year observation covers | |
376 | 376 | 473 | 70 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
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. | |
378 | 378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition 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' | |
380 | 380 | 478 | 70 | 6 | seats | integer | 0 | 0 | number of seats in parliament | |
381 | 381 | 480 | 70 | 9 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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. | |
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. |
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. | |
370 | 370 | 467 | viewcalc_parliament_composition 69 | 2 | date | date | 0 | 0 | date of party composition of 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. | |
372 | 372 | 469 | viewcalc_parliament_composition 69 | 4 | seats | 0 | 0 | number of seats in parliament | ||
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. | |
374 | 374 | 471 | viewcalc_parliament_composition 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
375 | 375 | 472 | viewcalc_parliament_composition 69 | 6 | cabinet_formation | binary | 0 | 0 | parliament composition at the date of a cabinet formation | |
348 | 348 | 437 | 68 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
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. | |
350 | 350 | 439 | 68 | 4 | lower_house | 0 | 0 | |||
351 | 351 | 440 | 68 | 5 | type_id | 0 | 0 | |||
352 | 352 | 441 | 68 | 6 | passed | 0 | 0 | |||
353 | 353 | 442 | 68 | 8 | no | 0 | 0 | |||
354 | 354 | 443 | 68 | 10 | invalid | 0 | 0 | |||
355 | 355 | 444 | 68 | 9 | abstain | 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' | |
357 | 357 | 446 | 68 | 7 | yes | 0 | 0 | |||
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. |
360 | 360 | 449 | 68 | 12 | total | 0 | 0 | |||
361 | 361 | 450 | 68 | 3 | date | 0 | 0 | |||
362 | 362 | 451 | 68 | 11 | absent | 0 | 0 | |||
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
341 | 341 | 428 | 67 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
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. | |
343 | 343 | 430 | 67 | 3 | type_id | integer | 0 | 1 | experimental coding type of cabinet support | |
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. | |
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. |
336 | 336 | 422 | 65 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
337 | 337 | 424 | 65 | 3 | salience | 0 | 0 | salience measure | ||
338 | 338 | 425 | 65 | 2 | ministry_country_id | 0 | 0 | id in table 'minister_ministry_country_id' | ||
339 | 339 | 426 | 65 | 4 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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. | |
331 | 331 | 417 | party_family 64 | 1 | 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 | |
333 | 333 | 419 | 61 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | ||
334 | 334 | 420 | 61 | short | text | 0 | 0 | |||
335 | 335 | 421 | 61 | name | text | 0 | 0 | |||
363 | 363 | 453 | 61 | comment | text | 0 | 0 | additional information about the coding of this observation | ||
315 | 315 | 387 | external_party_ray 56 | 4 | partyid | integer | 0 | 0 | Ray (1999) expert survey party ID | |
316 | 316 | 388 | external_party_ray 56 | 3 | nation | text | 0 | 0 | country name | |
317 | 317 | 389 | external_party_ray 56 | 2 | natid | integer | 0 | 0 | Ray (1999) expert survey country ID | |
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 | |
321 | 321 | 402 | external_party_ees 55 | 1 | id | integer | 0 | 0 | EES party ID (European Parliament Election Study 2009) | |
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) | |
279 | 279 | 344 | view_cabinet 54 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
280 | 280 | 345 | view_cabinet 54 | 15 | country_id | integer | 0 | 0 | ParlGov unique identifier for each country. Other tables refer to this variable as 'country_id'. | |
281 | 281 | 346 | view_cabinet 54 | 17 | cabinet_id | integer | 0 | 0 | ParlGov unique identifier for each cabinet. Variable name 'id' in 'cabinet' table and 'cabinet_id' in all other tables. | |
282 | 282 | 347 | view_cabinet 54 | 19 | party_id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
283 | 283 | 348 | view_cabinet 54 | 4 | start_date | date | 0 | 0 | start of cabinet defined as the date of the first event that determines a new cabinet | For some (continuation) caretaker cabinet, the date is set to election date. |
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 | |
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 | |
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 | |
298 | 298 | 369 | view_cabinet 54 | 8 | prime_minister | binary | 0 | 0 | indicates if the party fills the prime minster position | |
299 | 299 | 370 | view_cabinet 54 | 16 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
300 | 300 | 371 | view_cabinet 54 | 3 | election_date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
301 | 301 | 372 | view_cabinet 54 | 7 | cabinet_party | binary | 0 | 0 | cabinet member vs. opposition party | |
302 | 302 | 373 | view_cabinet 54 | 10 | election_seats_total | integer | 0 | 0 | seats total in parliament |
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]) );