The Database (Version: 1.0.1)

The core element of the database is the Politicians dataset. It entails one observation for every individual politician who was a member of a German state parliament or cabinet between 1990 and 2022, including their name, a unique ID, and other non-varying information like gender, birthdate, and birthplace. Shedding light on these politicians’ legislative mandates, roles and functions in state parliaments, StatePol provides the datasets Mandate, PPG, PPG-Leadership, Presidency, and Committee. Data on executive offices held in state governments can be found in the Cabinet dataset.

Following the logic of a relational database, all these datasets can be combined as desired by the individual politicians unique individual ID variable. By connecting the datasets, users can supplement members’ personal data with their affiliations in factions, cabinets, state parliament presidencies, committees, and faction leadership. In the following table the datasets are listed and the figure displays the logic of the database-structure.

The Datasets

Dataset	Description	Variables	Observations
Politician	Information on the all individual parliamentarians	15	12490
Mandate	Information on the mandates by mps	10	29553
PPG	Lists the members of the parties / parliamentary factions	8	14848
PPG-Leadership	Lists the members of the faction boards	10	2090
Presidency	Lists the members of the presidiums	8	440
Committee	Lists the members of the committees	28	26637
Cabinet	Lists the members of the cabinets	29	2104

The Structure