# Committees ## Documentation The committees of the organisation; published by GemeenteOplossingen and Parlaeus sources only, and not documented by the platform. 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 `Committees` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `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. | | `commit_id` | `varchar2` | | ☐ | The id of this version. | | `content_hash` | `varchar2` | | ☐ | The SHA-256 of the content of this version; equal for equal content. | | `entity_id` | `varchar2` | | ☑ | The id of the committee, such as committee: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. | | `name` | `varchar2` | | ☐ | The name of the committee as the source system gives it. | | `organization_id` | `varchar2` | | ☐ | The organisation, such as organization:nl:gemeente:houten. | | `parent_organization_id` | `varchar2` | | ☐ | The organisation it belongs to. | | `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. | | `supplier` | `varchar2` | | ☑ | The council information system it was read from. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Export-Meetings\|Export.Meetings]] | `committee_entity_id` | In words only: The committee holding the meeting. Holds only for sources that export their committees (GemeenteOplossingen, Parlaeus): Notubiz names a committee in every meeting and exports none, 1 485 of 1 485 in Putten on 2026-11-06. |