Transcripts

Transcript

Label Transcript

Description

This label is given to nodes that also represent the written transcript of their contents. This also means that the uid is also the Foreign Key to the node’s transcript in the sqlite database. For explanation on the optional attribute, refer to the related co-label.

Co-labels:Speech | Inconsistent Timestamp | Vote | Legislative Proposition | Unexpected Vote Total

Attributes

• identifier uid: string

  Unique identifier of this object.

• language_of_text: string

  Categorical: DE, FR, IT

  The language of the transcript.

• length: integer

  Length of the transcript string.

• name: string

  Name of the transcript node. The naming scheme depends on the co-label.

• order_stamp: integer

  A number indicating the placement of the transcript node along a chain of transcript nodes ordered in a partition.

• time_end: local_date_time

• time_start: local_date_time

• (optional) datetime_end: local_date_time

• (optional) meaning_no: string

• (optional) meaning_yes: string

• (optional) registration_number: integer|string

• (optional) role: string

• (optional) subject: string

• (optional) vote_uid: integer

Connected relations

Outgoing

• NEXT to Transcript

Incoming

• CONTAINS from Partition

• GAVE from Person

• NEXT from Transcript

• VOTED from Person

Constraints

• A Transcript must contain the attributes ‘name’, ‘order_stamp’, ‘length’, ‘language_of_text’
• A Transcript must follow a defined structure:
  • It must be connected to one and only one Partition with exactly one CONTAINS relation

Visual Representation

Speech

Label Speech

Description

Speeches are given during the meetings of the Parliament. They are contained in Partitions which are themselves divisions of Discussions. Each speech is given by one MP. All nodes with the Speech label also have the Transcript co-label, which means that the uid is also the Foreign Key to the speech text in the sqlite database.

Co-labels:Transcript | Inconsistent Timestamp

Attributes

• identifier uid: string

  Unique identifier of this object.

• language_of_text: string

  Categorical: FR, DE, IT

  The language in which the speech is given.

• length: integer

  Length of the transcript string.

• name: string

  Usually the speaker’s last name + first name. In some cases the name in the speech node is slightly different from the speaker’s name; therefore make sure to write queries based on the relation between the nodes and not by the names.

• order_stamp: integer

  A number indicating the placement of the speech node along a chain of transcript nodes ordered in a partition.

• time_end: local_date_time

  End time of the speech.

• time_start: local_date_time

  Begin time of the speech.

• (optional) role: string

  Categorical: Member of the federal council, For the committee, President of the federal council, President, Federal chancellor, For the office, First vice-president, Second vice-president

  Role of the speaker in the Parliament.

Connected relations

Outgoing

• NEXT to Transcript

Incoming

• CONTAINS from Partition

• GAVE from Person

• NEXT from Transcript

Constraints

• A Speech must contain the attributes ‘role’. The attribute ‘role’ is categorical and must be one of: [None, ‘For the committee’, ‘For the office’, ‘President’, ‘First vice-president’, ‘Second vice-president’, ‘President by seniority’, ‘Member of the federal council’, ‘President of the federal council’, ‘Member of the federal council’, ‘Federal chancellor’]
• A Speech must follow a defined structure:
  • It must be connected to one and only one Person with exactly one GAVE relation

Visual Representation

Vote

Label Vote

Description

Nodes with this label are votes that happen in the discussion. They are Transcript nodes which means the text version of the voting is also stored in the sqlite database with the uid being the foreign key. There might be instances where total number of votes does match the number of members is the parliament, in which case the Unexpected Vote Total co-label is also assigned.

Co-labels:Unexpected Vote Total | Transcript | Inconsistent Timestamp

Attributes

• identifier uid: string

  Unique identifier of the object.

• language_of_text: string

  Categorical: DE, FR, IT

  The language of the vote transcript.

• length: integer

  Length of the transcript string.

• name: string

  String if the format “Vote Block [order_stamp]”

• order_stamp: integer

  A number indicating the placement of the vote node along a chain of transcript nodes ordered in a partition.

• time_end: local_date_time

  End time of voting.

• time_start: local_date_time

  Begin time of voting.

• (optional) datetime_end: local_date_time

  None

• (optional) meaning_no: string

  What a No vote implies in this voting.

• (optional) meaning_yes: string

  What a Yes vote implies in this voting.

• (optional) registration_number: integer|string

  Together with the meeting date they make a unique identifier.

• (optional) subject: string

  Usually contains the subject of the voting

• (optional) vote_uid: integer

  ID Number of vote in OData database.

Connected relations

Outgoing

• NEXT to Transcript

Incoming

• CONTAINS from Partition

• NEXT from Transcript

• VOTED from Person

Constraints

• Every vote that has explicit votings, must have 200 votes in the NR, 46 (only available after 2022) in the SR and 246 (200 before 2022) in the VB. Further every person can only vote once. If that is not the case, the vote node must have the ‘Unexpected Vote Total’ label.
• The number explicit Yes/No votings must correspond to the number given in the transcript. If the number is 0 it must not be mentioned in the transcript. If the difference between the two votings is 1, the original vote was a draw and the president had to vote. In that case the text must contain ‘Stichentscheid’.

Visual Representation

Legislative Proposition

Label Legislative Proposition

Description

[not to be confused with Proposals] Nodes with this label are propositions made during the discussions. These nodes are also Transcript nodes which means the text version of the voting is also stored in the sqlite database with the uid being the foreign key.

Co-labels:Transcript | Inconsistent Timestamp

Attributes

• identifier uid: string

  Unique identifier of this object.

• language_of_text: string

  Categorical: DE, FR, IT

  The language of the proposition.

• length: integer

  Length of the transcript string.

• name: string

  String if the format law Block [order_stamp]”

• order_stamp: integer

  A number indicating the order of the proposition node among the proposition in a meeting.

• time_end: local_date_time

  End time of the proposition.

• time_start: local_date_time

  Begin time of the proposition.

Connected relations

Outgoing

• NEXT to Transcript

Incoming

• CONTAINS from Partition

• NEXT from Transcript

Visual Representation