> ## Documentation Index
> Fetch the complete documentation index at: https://docs.babbl-labs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Field Categories

Field categories organize the Core Dataset's 40+ fields into logical groupings for easier understanding and implementation.

## Channel Fields

Channel-level metadata and statistics from YouTube.

| Field                                | Type      | Description                                                   |
| ------------------------------------ | --------- | ------------------------------------------------------------- |
| **channel\_id**                      | UUID      | Primary Key - Immutable Babbl Labs internal unique identifier |
| **channel\_uri**                     | UUID      | Immutable YouTube's unique identifier for channel             |
| **channel\_custom\_url**             | STRING    | Mutable custom URL for channel                                |
| **channel\_name**                    | STRING    | Channel title from YouTube metadata                           |
| **channel\_description**             | STRING    | Channel description from YouTube metadata                     |
| **channel\_locale**                  | ENUM      | Channel geographic country (ISO 3166-1 alpha-2)               |
| **channel\_view\_count**             | INT       | Most recent channel total view count                          |
| **channel\_subscriber\_count**       | INT       | Most recent channel total subscriber count                    |
| **channel\_video\_count**            | INT       | Most recent channel total video count                         |
| **channel\_published\_at**           | TIMESTAMP | Timestamp when channel was created                            |
| **channel\_coverage\_initiated\_at** | TIMESTAMP | Timestamp when we initiated coverage                          |
| **channel\_last\_updated\_at**       | TIMESTAMP | Timestamp when we last polled YouTube metadata                |

## Video Fields

Video-level metadata and engagement metrics from YouTube.

| Field                        | Type      | Description                                    |
| ---------------------------- | --------- | ---------------------------------------------- |
| **video\_id**                | UUID      | Primary Key - Unique YouTube video identifier  |
| **video\_view\_count**       | INT       | Most recent view count recorded                |
| **video\_like\_count**       | INT       | Most recent video like count recorded          |
| **video\_comment\_count**    | INT       | Most recent video comment count recorded       |
| **video\_published\_dt**     | TIMESTAMP | Timestamp when video was originally published  |
| **video\_transcribed\_at**   | TIMESTAMP | Timestamp when we originally transcribed video |
| **video\_scored\_at**        | TIMESTAMP | Timestamp when we originally processed video   |
| **video\_last\_updated\_at** | TIMESTAMP | Timestamp when we last polled YouTube metadata |
| **video\_title**             | STRING    | Video title from YouTube metadata              |
| **video\_description**       | STRING    | Video description from YouTube metadata        |
| **video\_language**          | STRING    | Video language code (ISO 639-1)                |

## Processing Fields

Model and processing metadata for transcription and analysis.

| Field                         | Type   | Description                             |
| ----------------------------- | ------ | --------------------------------------- |
| **model\_transcription\_tag** | STRING | Identifier for transcription model used |
| **model\_scoring\_tag**       | STRING | Identifier for scoring model used       |

## Segment Fields

Transcript segment timing and content information.

| Field              | Type   | Description                                             |
| ------------------ | ------ | ------------------------------------------------------- |
| **segment\_start** | FLOAT  | Starting point of segment - seconds from start of video |
| **segment\_end**   | FLOAT  | End point of segment - seconds from start of video      |
| **segment\_text**  | STRING | Transcribed text (50 words before/after entity mention) |

## Speaker Fields

Speaker identification and context information.

| Field                           | Type   | Description                                            |
| ------------------------------- | ------ | ------------------------------------------------------ |
| **speaker\_name**               | STRING | Name of speaker in this segment                        |
| **speaker\_associated\_entity** | UUID   | Entity (company) speaker is associated with (FIGI)     |
| **speaker\_position**           | STRING | Known title of speaker in this segment                 |
| **speaker\_role\_context**      | ENUM   | Role of speaker (Host, Guest, ReferencedSource, Other) |

## Entity Fields

Named entity recognition and financial instrument mapping.

| Field                         | Type   | Description                                      |
| ----------------------------- | ------ | ------------------------------------------------ |
| **entity\_id**                | UUID   | Immutable identifier of entity referenced        |
| **entity\_symbol**            | STRING | Public company ticker symbol (ORG entities only) |
| **entity\_figi\_id**          | UUID   | Financial Instrument Global Identifier (FIGI)    |
| **entity\_type**              | ENUM   | Type of entity (ORG, PERSON, PRODUCT)            |
| **entity\_name**              | STRING | Mapped entity name from raw anchor               |
| **entity\_name\_raw\_anchor** | STRING | Raw string of named entity detected              |

## Sentiment Fields

Multi-layered sentiment analysis for entity mentions.

| Field                                   | Type | Description                                                          |
| --------------------------------------- | ---- | -------------------------------------------------------------------- |
| **entity\_sentiment\_overt\_buy\_sell** | ENUM | Overt buy/sell sentiment (POSITIVE, NEGATIVE, NONE\_EXPRESSED, NULL) |
| **entity\_sentiment\_generic**          | ENUM | General sentiment (POSITIVE, NEGATIVE, NONE\_EXPRESSED, NEUTRAL)     |

## Data Types & Constraints

| Type          | Format                  | Example                                |
| ------------- | ----------------------- | -------------------------------------- |
| **UUID**      | 36-character identifier | `550e8400-e29b-41d4-a716-446655440000` |
| **STRING**    | Variable-length text    | `"Bloomberg Technology"`               |
| **INT**       | Integer number          | `12906`                                |
| **FLOAT**     | Floating-point number   | `168.7303438`                          |
| **TIMESTAMP** | UTC timestamp           | `1747251178`                           |
| **ENUM**      | Predefined values       | `POSITIVE`, `NEGATIVE`, `NEUTRAL`      |

<Note>
  All timestamp fields use UTC timezone. Geographic codes follow ISO 3166-1 alpha-2, language codes follow ISO 639-1.
</Note>