info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows
This data as json, CSV (advanced)
Link | rowid ▼ | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
303 | 303 | 374 | country 19 | 22 | comment | text | 0 | 0 | additional information about the coding of this observation | |
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'. |
305 | 305 | 376 | election 35 | 18 | previous_ep_election_id | integer | 0 | 0 | 'election_id' of previous national EP election for this country | |
306 | 306 | 377 | election 35 | 17 | previous_parliament_election_id | integer | 0 | 0 | 'election_id' of previous national parliament election in the country | |
307 | 307 | 378 | cabinet 12 | 17 | previous_ep_election_id | integer | 0 | 0 | 'election_id' of previous EP election in the country | |
308 | 308 | 379 | cabinet 12 | 16 | previous_parliament_election_id | integer | 0 | 0 | 'election_id' of previous parliamentary election in the country | |
309 | 309 | 380 | cabinet 12 | 15 | previous_cabinet_id | integer | 0 | 0 | 'cabinet_id' of previous national cabinet in the country | |
310 | 310 | 381 | view_election 53 | 14 | previous_parliament_election_id | integer | 0 | 0 | 'election_id' of previous national parliament election in the country | |
311 | 311 | 382 | view_cabinet 54 | 18 | previous_cabinet_id | integer | 0 | 0 | 'cabinet_id' of previous national cabinet in the country | |
312 | 312 | 383 | election 35 | 19 | previous_cabinet_id | integer | 0 | 0 | 'cabinet_id' of incumbent government | |
313 | 313 | 384 | party 29 | 18 | ees | integer | 0 | 0 | European Election Study (2009) party ID | |
314 | 314 | 385 | view_party 52 | 15 | ees | integer | 0 | 0 | European Election Study (2009) party ID | |
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) | |
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' | |
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 | |||
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 | |
340 | 340 | 427 | view_election 53 | 15 | previous_cabinet_id | integer | 0 | 0 | 'cabinet_id' of incumbent government | |
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. |
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 | |||
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 | |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
366 | 366 | 460 | election 35 | 7 | wikipedia | url | 0 | 0 | link to wikipedia entry or other url if no wikipedia entry exists | |
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. |
368 | 368 | 463 | 50 | 19 | validation | binary | 0 | 0 | observation has been validated with an external source | |
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 | |
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 | |
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 | |
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 | |
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. | |
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 | |
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 | |
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 | |
399 | 399 | 499 | external_commissioner_doering 20 | 4 | commission_name | text | 0 | 0 | name of Commission | |
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 |
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]) );