# Meetings ## Documentation The meetings of councils, states and committees, with their date and place. Not every row is a meeting held: some sources publish invitations and information sessions the same way. 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 `Meetings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `attachment_entity_ids` | `varchar2` | | ☐ | The documents attached to the meeting itself, separated by a comma. | | `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. | | `committee_entity_id` | `varchar2` | | ☐ | The committee holding the meeting. | | `content_hash` | `varchar2` | | ☐ | The SHA-256 of the content of this version; equal for equal content. | | `end_date` | `datetime` | | ☐ | The end of the meeting, UTC. | | `entity_id` | `varchar2` | | ☑ | The id of the meeting, such as meeting: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. | | `location` | `varchar2` | | ☐ | Where the meeting is held. | | `name` | `varchar2` | | ☐ | The name of the meeting as the source system gives it. | | `organization_id` | `varchar2` | | ☐ | The organisation, such as organization:nl:gemeente:houten. | | `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. | | `start_date` | `datetime` | | ☐ | The start of the meeting, UTC. | | `status` | `varchar2` | | ☐ | The status as the source system words it; every system has its own words. | | `supplier` | `varchar2` | | ☑ | The council information system it was read from. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `committee_entity_id` | [[Export-Committees\|Export.Committees]] | `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. | | `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-Documents\|Export.Documents]] | `meeting_entity_id` | Declared by the connector, not enforced by the platform | | [[Export-MeetingAgendaItems\|Export.MeetingAgendaItems]] | `meeting_entity_id` | Declared by the connector, not enforced by the platform | | [[Export-Motions\|Export.Motions]] | `meeting_entity_id` | Declared by the connector, not enforced by the platform | | [[Export-Recordings\|Export.Recordings]] | `meeting_entity_id` | Declared by the connector, not enforced by the platform |