# MotionVotes ## Documentation The vote of every member on every motion, where the council votes digitally: 67 of 142 iBabs municipalities in July 2026, no Notubiz source. Only voor and tegen exist; a member who abstained or was absent has no row. 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: `motion_entity_id, voter_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 `MotionVotes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `group_id` | `varchar2` | | ☐ | The party of the member at the vote. | | `group_name` | `varchar2` | | ☐ | The name of that party, spelled as the source does: CDA, Fractie CDA and raadsleden cda are three spellings. | | `motion_entity_id` | `varchar2` | | ☑ | The motion. | | `source_key` | `varchar2` | | ☑ | The source. | | `vote_option` | `varchar2` | | ☑ | voor or tegen. | | `voter_id` | `varchar2` | | ☑ | The member; stable within one source, without a national register. | | `voter_name` | `varchar2` | | ☐ | The name of the member as the source writes it. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `motion_entity_id` | [[Export-Motions\|Export.Motions]] | `entity_id` | Declared by the connector, not enforced by the platform |