3.5 Contributions Tables

The current version of the Open Discourse database contains two contributions tables. Contributions are any kind of interjections and other types of reactions during a speech from the plenum that is recorded by the stenographers. There is a simplified version of the contributions table and an extended one. The simplified version only contains the raw text of the interjection and two foreign keys to map the contribution to the associated speech and the precise position in the speech where the contribution occurred.

The extended contributions table has more detailed meta information but the instances in this table can be faulty. The logic needs further refinement for better results - still we wanted to provide the current state of this approach and hence we labeled this table as being experimental.

3.5.1 Contributions Simplified

Click here for a table preview
id textPosition speechId content
0 0 2 (Der Bundespräsident leistet diesen Eid.)
1 4 5 (dem Bundespräsidenten die Hand reichend)
2 3 5 (Langanhaltender lebhafter Beifall.)
3 2 5 (Bundespräsident Dr. Heuss)
4 1 5 (Sehr richtig!)
5 0 5 (Bundespräsident Dr. Heuss)
6 7 6 (Lachen links. - Zurufe.)
7 6 6 (Ja-Rufe.)
8 5 6 (Die Ermittlung des Ergebnisses wird fortgesetzt.)
9 4 6 (Präsident Dr. Köhler)

this preview depicts the first 10 rows of the contributions simplified table.


The simplified contributions table has the following dimensions:

Feature Total
Number of observations 2153422
Number of variables 4

3.5.1.1 Simplified contributions summary table

Variable Class # unique Missing Values Description
id integer64 2153422 0.00% Primary Key
textPosition integer64 799 0.00% ID that defines the position inside the respective speech the contribution belongs to.
speechId integer64 382644 0.00% Foreign key of the speech. This ID can be used to link the observations with the speeches table.
content character 872170 0.00% Content of the contribution

3.5.2 Contributions Extended (experimental)

Click here for a table preview
id type firstName lastName politicianId content speechId textPosition factionId
0 Lachen -1 links 6 7 -1
1 Personen-Einruf hütter 11000979 Nein! 6 2 13
2 Zuruf -1 § 51! 9 3 20
3 Zuruf -1 links 11 0 -1
4 Personen-Einruf blücher 11000202 Jawohl! 12 0 13
5 Zuruf -1 links 13 8 -1
6 Zuruf -1 Das gilt auch für diese Woche! Weitere Zurufe. 13 7 -1
7 Lachen -1 rechts 13 6 -1
8 Heiterkeit -1 13 3 23
9 Zustimmung -1 13 2 23

this preview depicts the first 10 rows of the contributions extended table.


The extended contributions table has the following dimensions:

Feature Total
Number of observations 2480916
Number of variables 9

3.5.2.1 Extended contributions summary table

Variable Class # unique Missing Values Description
id integer64 2480916 0.00% Primary Key
type character 8 0.00% Type of the contribution.
firstName character 8460 77.11% First name of he politician.
lastName character 6444 66.87% Last name of the politician.
politicianId integer64 3446 67.60% Foreign key of the politician. This ID can be used to link the observations with the politicians table.
content character 592918 65.05% Content of the contribution.
speechId integer64 326438 0.00% Foreign key of the speech. This ID can be used to link the observations with the speeches table.
textPosition integer64 225 0.00% Identifier
factionId integer64 22 1.83% Foreign key of the faction. This ID can be used to link the observations with the factions table.

3.5.2.2 Additional Remarks

This extended version of the contribution table contains detailed meta information. This table is labeled experimental since the extraction of the meta information is faulty at times. This is caused by in the way of how contributions are recorded throughout the electoral periods.

This extended table also introduces a seven level category system that defines the type of the respective contribution. Following table provides an overview of these seven levels:

Contribution Types

type Description
Beifall Applause
Heiterkeit Cheerfulness
Lachen Laughter
Personen-Einruf Interjection (by a specific politician)
Unruhe Noisiness/unrest
Widerspruch Disagreement
Zuruf Interjection - not assigned to a specific politician
Zustimmung Agreement