# Motions ## Documentation The motions and amendments, with their outcome. Around 40 percent have no text; the votes per member are in MotionVotes. Read from the export of the platform, 1 000 records per request, for every selected source: a full read of every source takes over 100 minutes at the rate limit of the platform, one source of 20 000 records some 20 seconds. Narrow it with use <source>@obv. - Catalog: `OpenBesluitvorming` - Schema: `Export` - Primary Keys: `entity_id` The data in this table is partitioned per value of the `` column. This is a read-only table. The Open Besluitvorming API may not support changing the data or the Invantive UniversalSQL driver for Open Besluitvorming does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Open Besluitvorming API. ## Table Columns The columns of the table `Motions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `agenda_item_hint` | `varchar2` | | ☐ | The raw text of the source system naming the agenda item, when no reference could be made. | | `agenda_item_id` | `varchar2` | | ☐ | The agenda item it was decided under. | | `attachment_entity_id` | `varchar2` | | ☐ | The document with the text of the motion. | | `changed_at` | `datetime` | | ☑ | When the platform recorded this version, UTC. | | `classification` | `varchar2` | | ☐ | The kind as the source system names it, such as Agenda, Moties or Raadsinformatiebrieven; several separated by a comma. | | `co_proposers` | `varchar2` | | ☐ | The members who co-signed it. | | `commit_id` | `varchar2` | | ☐ | The id of this version. | | `content_hash` | `varchar2` | | ☐ | The SHA-256 of the content of this version; equal for equal content. | | `description` | `varchar2` | | ☐ | The description of the motion. | | `entity_id` | `varchar2` | | ☑ | The id of the motion, such as motion:ibabs:gemeente:houten:<id>; stable, and the argument of the functions of the schema Entities. | | `last_discussed_at` | `datetime` | | ☐ | When it was last discussed in a meeting, UTC. iBabs data before 2025 holds Dutch time marked as UTC, so a late meeting can land on the next day. | | `meeting_entity_id` | `varchar2` | | ☐ | The meeting in which it was decided; empty when the reference could not be resolved. | | `motion_date` | `datetime` | | ☐ | A date the source system gives the motion, UTC. | | `motion_type` | `varchar2` | | ☐ | Motion or amendment, as the source system words it. | | `name` | `varchar2` | | ☐ | The name of the motion as the source system gives it. | | `organization_id` | `varchar2` | | ☐ | The organisation, such as organization:nl:gemeente:houten. | | `parties` | `varchar2` | | ☐ | The parties derived from the proposers; often empty. For the party of a vote use MotionVotes.group_name. | | `proposers` | `varchar2` | | ☐ | The members who submitted it, separated by a comma. | | `result` | `varchar2` | | ☐ | The outcome normalised: aangenomen, verworpen, ingetrokken, aangehouden or overig. overig also covers a tie and a status about the follow-up. Empty with votes present: the outcome was not written down. | | `schema_version` | `varchar2` | | ☐ | The version of the record format, such as v1alpha1. | | `seq` | `int64` | | ☑ | The position of the version in the change feed of the source; a newer version has a higher number. | | `source_key` | `varchar2` | | ☑ | The source, which is also the partition. | | `status` | `varchar2` | | ☐ | The outcome as the source system words it. | | `supplier` | `varchar2` | | ☑ | The council information system it was read from. | | `vote_summary` | `varchar2` | | ☐ | A breakdown of the vote as free text, for the few sources that publish only that. | | `votes_against` | `int32` | | ☐ | The number of votes against. | | `votes_in_favour` | `int32` | | ☐ | The number of votes in favour. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `agenda_item_id` | [[Export-MeetingAgendaItems\|Export.MeetingAgendaItems]] | `agenda_item_id` | In words only: The agenda item under which the motion was decided; the key of an agenda item includes its meeting, which may differ from the meeting of the motion. | | `attachment_entity_id` | [[Export-Documents\|Export.Documents]] | `entity_id` | Declared by the connector, not enforced by the platform | | `meeting_entity_id` | [[Export-Meetings\|Export.Meetings]] | `entity_id` | Declared by the connector, not enforced by the platform | | `source_key` | [[Catalog-Sources\|Catalog.Sources]] | `source_key` | In words only: The source, which is also the partition. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Export-MotionVotes\|Export.MotionVotes]] | `motion_entity_id` | Declared by the connector, not enforced by the platform |