# Recordings ## Documentation The video and audio registrations of meetings. The transcript is in RecordingSegmentsById; the media are never stored 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 `Recordings` 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. | | `chapter_count` | `int32` | | ☐ | The number of chapters. | | `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. | | `content_type` | `varchar2` | | ☐ | The kind of file, such as video/mp4. | | `duration_seconds` | `int64` | | ☐ | The length in seconds. | | `entity_id` | `varchar2` | | ☑ | The id of the recording, such as recording: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. | | `media_type` | `varchar2` | | ☐ | video or audio. | | `media_url` | `varchar2` | | ☐ | The file of the registration at the source system. | | `meeting_entity_id` | `varchar2` | | ☐ | The meeting recorded. | | `name` | `varchar2` | | ☐ | The name of the recording as the source system gives it. | | `organization_id` | `varchar2` | | ☐ | The organisation, such as organization:nl:gemeente:houten. | | `platform` | `varchar2` | | ☐ | The system publishing the registration. | | `player_url` | `varchar2` | | ☐ | The page of the player of the source system. | | `schema_version` | `varchar2` | | ☐ | The version of the record format, such as v1alpha1. | | `segment_count` | `int32` | | ☐ | The number of fragments of the transcript. | | `seq` | `int64` | | ☑ | The position of the version in the change feed of the source; a newer version has a higher number. | | `size_bytes` | `int64` | | ☐ | The size of the file in bytes. | | `source_key` | `varchar2` | | ☑ | The source, which is also the partition. | | `start_date` | `datetime` | | ☐ | The start of the registration, UTC. | | `stream_url` | `varchar2` | | ☐ | The stream that can be played from any moment. | | `supplier` | `varchar2` | | ☑ | The council information system it was read from. | | `transcript_kind` | `varchar2` | | ☐ | asr when the transcript is speech recognition: no reliable punctuation and no speakers. | | `transcript_language` | `varchar2` | | ☐ | The language of the transcript. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `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-RecordingChapters\|Export.RecordingChapters]] | `recording_entity_id` | Declared by the connector, not enforced by the platform |