Database tables and variables

Documentation of all ParlGov database tables from «info_table» and «info_variable»

Short list of tables

main

primary

calculated

external

Long list of tables

Main data tables

Main tables combining data from primary tables through database queries ((views)

Table

cabinet

Description

Cabinet and opposition parties in parliament with their seat strength at each instance of government formation. (main view)

Download

· windows
· utf-8

Variables

country name short • country name • election date • start date • cabinet name • caretaker • cabinet party • prime minister • seats • election seats total • party name short • party name • party name english • left right • country id • election id • cabinet id • previous cabinet id • party id

Table

election

Description

Election results for national and European Parliament elections. (main view)

Download

· windows
· utf-8

Variables

country name short • country name • election type • election date • vote share • seats • seats total • party name short • party name • party name english • left right • country id • election id • previous parliament election id • previous cabinet id • party id

Table

party

Description

Party information and merge table for various external data sets on party positions. (main view)

Download

· windows
· utf-8

Variables

country name short • country name • party name short • party name english • party name • party name ascii • family name short • family name • left right • state market • liberty authority • eu anti pro • cmp • euprofiler • ees • castles mair • huber inglehart • ray • benoit laver • chess • country id • party id • family id

Table

variable

Description

documentation of variables in main data tables (party, election, cabinet)

Download

· windows
· utf-8

Variables

table name • type • name • description • comment

Primary data tables

Data tables as coded in ParlGov database

Table

cabinet

Description

information about cabinets

Download

· windows
· utf-8

Variables

id • country id • start date • termination id • termination date • appointment date • resignation date • name • caretaker • wikipedia • data source • description • comment • data json • previous cabinet id • previous parliament election id • previous ep election id • old countryID • old cabID

Description

list of parties that are members of a cabinet -- no party affiliation observations (party_id) are included if the prime minister is not a party member

Download

· windows
· utf-8

Variables

id • cabinet id • party id • pm • defector • party id source • data source • description • comment • data json

Table

country

Description

country data with links to other data sets

Download

· windows
· utf-8

Variables

id • name • name short • oecd accession date • eu accession date • iso numeric • cmp • euprofiler • ees • morgan • castles mair • huber inglehart • ray • chess • benoit laver • wiesehomeier benoit • hix ea • taglarsson • mp • ep hoyland • public • comment • data json • old countryID

Table

election

Description

information about a parliamentary election

Download

· windows
· utf-8

Variables

id • type id • country id • date • first round election id • early • wikipedia • dissolution date • seats total • electorate • votes cast • votes valid • data source • description • comment • data json • previous parliament election id • previous ep election id • previous cabinet id • old countryID • old parlID

Description

results of parliamentary elections at the party level

Download

· windows
· utf-8

Variables

id • election id • party id • party id source • alliance id • seats • vote share • votes • person id • person id source • data source • description • comment • data json

Table

party

Description

party information with links to data sets (ParlGov external) that contain political positons of parties

Download

· windows
· utf-8

Variables

id • country id • family id • name short • name english • name • name ascii • name nonlatin • wikipedia • foundation date • dissolution date • data source • description • comment • data json • cmp • euprofiler • ees • morgan • castles mair • huber inglehart • laver hunt • ray • benoit laver • wiesehomeier benoit • chess • hix ea • hoyland ea • old countryID • old partyID

Table

party change

Description

linking parties that evolved through changes -- observation in this table link predecessor/successor parties or party splits from 'party' table -- this information is still incomplete with updates and extensions in future ParlGov versions

Download

· windows
· utf-8

Variables

id • party id • party id new • date • type id • data source • description • comment • data json

Table

party family

Description

additional party families for a party

Download

· windows
· utf-8

Variables

id • party id • type id

Description

information on official party names in case a party was renamed or if the official name is only used in shortened form

Download

· windows
· utf-8

Variables

id • party id • date • party change • name short • name english • name • name ascii • name nonlatin • data source • description • comment • data json

Description

Download

· windows
· utf-8

Variables

id • country id • start date • end date • person id • person id source • party id • party id source • data source • description • comment • data json

Info tables

Documentation of tables and variables

Table

data source

Description

list of references for ParlGov coding

Download

· windows
· utf-8

Variables

id • key • short • full • url

Table

id

Description

definitions for all id variables without a separate table

Download

· windows
· utf-8

Variables

id • table variable • order • short • name • description • wikipedia • old id

Table

table

Description

description of ParlGov database tables

Download

· windows
· utf-8

Variables

id • type • name • data source • description • comment

Table

variable

Description

description of variables in ParlGov database tables

Download

· windows
· utf-8

Variables

id • table id • column number • name • type • comment entry • incomplete • description • comment • data json • public • replace

Calculated data tables

Tables calculating parameters from primary tables with a computer script

Description

country year weights for elections (national and EP) and cabinets -- each entry gives the share of the respective year the legislature or cabinet was in office

Download

· windows
· utf-8

Variables

id type • year • id • share

Description

calculated parameters about parliamentary elections -- see list of variables for further details

Download

· windows
· utf-8

Variables

election id • turnout • enp votes • enp seats • disproportionality • advantage ratio • polarization • calculation date

Description

compositon of parliament for changes in parliament (table 'parliament_change'), information about composition of parliament (table 'parliament_composition') and dates of cabinet formation ('start_date' from table 'cabinet')

Download

· windows
· utf-8

Variables

election id • date • party id • seats • cabinet id • cabinet formation • calculation date

Description

policy positions of political parties in important dimensions as provided through various expert surveys

Download

· windows
· utf-8

Variables

party id • left right • state market • liberty authority • eu anti pro • calculation date

External data tables

Data tables from external sources linked to ParlGov tables

Description

members of the European Union's College of Commissioners

Download

· windows
· utf-8

Variables

id • country id • commission year • commission name • person id • person id source • start date • end date • incumbent • one seat • party id • party id source • government party • president • portfolio • elected • score position • highest position • data source • comment • data json • previous cabinet id

Table

country iso

Description

ISO 3166 country codes worldwide with some additional information

Download

· windows
· utf-8

Variables

id • continent • region • country • capital • fips • iso2 • iso3 • isonumeric • internet

Description

party data (party names) from Benoit/Laver (2006)

Download

· windows
· utf-8

Variables

id • Country • Party • PartyName

Description

party position data from Castles/Mair (1983)

Download

· windows
· utf-8

Variables

id • country • name • name english • name short • range left • range right • left right • respondents

Table

party chess

Description

party names from the codebook of Chapel Hill Expert Surveys Series (CHESS) on the positioning of political parties (1996, 1999, 2002, 2006, 2010)

Download

· windows
· utf-8

Variables

id • country • name short • name • name english

Table

party cmp

Description

list of parties from the Comparative Manifestos Project (CMP) data set

Download

· windows
· utf-8

Variables

id • name short • name • name english • comment • row number • country

Table

party ees

Description

list of parties from the European Election Study (2009)

Download

· windows
· utf-8

Variables

id • country • name • name english • q39 • q47 • q81

Description

list of parties from the EU Profiler (Trechsel/Mair 2009)

Download

· windows
· utf-8

Variables

id • country • name

Description

party position data from Huber/Inglehart (1995)

Download

· windows
· utf-8

Variables

id • country • name english • name • name short • left right • range left • range right • sd • respondents

Table

party ray

Description

list of parties from Ray (1999)

Download

· windows
· utf-8

Variables

id • natid • nation • partyid • party • ename • name • cmpcode • pos84 • pos88 • pos92 • pos96 • sal84 • sal88 • sal92 • sal96