> For the complete documentation index, see [llms.txt](https://knowledgebase.fabricdata.com/insights/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.fabricdata.com/insights/data-hub/schemas-by-dataset.md).

# Schemas by dataset

This page documents the **schemas** of each Data Hub dataset. Each record is a JSON object (one line per record in **JSONL** files). The join identifiers are **UID** (content) and **Global Id + Country** (platform by country).

## Common conventions

* **`UID`** (string, hash) — universal **content** identifier. Cross-dataset join key for the same movie/series/episode.
* **`PlatformId` + `PlatformCountry`** (Global Id + Country) — unique identifier of a **platform by country**. Join key for platform-level joins.
* **`PlatformCode`** — composite code `<country>.<platform>` (e.g., `us.netflix`).
* **Dates**: ISO 8601 (`YYYY-MM-DD` or timestamp with TZ).
* **`Packages`**: arrays of business models (`subscription-vod`, `transaction-vod`, `free-vod`, `validated-vod`, `tv-everywhere`).
* **`ExternalIds`**: array of `{Provider, ID}` pairs with external source (imdb, tmdb, tvdb, eidr).

Each dataset lives under `s3://<bucket-client>/<Folder>/latest/` (or the equivalent path in DigitalOcean Spaces). The `latest` subfolder is the current snapshot.

***

## Audiovisual Identifiers & Metadata

Folder: `s3://<bucket-client>/Sources/latest/`. Frequency: **weekly**.<br>

### UIDs

| Field         | Type   | Description                                         |
| ------------- | ------ | --------------------------------------------------- |
| `UID`         | string | Universal Fabric ID grouping a set of external IDs. |
| `ExternalIds` | array  | See sub-table.                                      |

#### ExternalIds (sub-table of UIDs and other datasets)

| Field       | Type   | Description                                                       |
| ----------- | ------ | ----------------------------------------------------------------- |
| `UID`       | string | Fabric UID.                                                       |
| `Provider`  | string | Source of the external ID (`imdb`, `tmdb`, `tvdb`, `eidr`, `bb`). |
| `ID`        | string | ID in the external base.                                          |
| `Type`      | string | Type assigned by the external source.                             |
| `CreatedAt` | string | ISO insertion timestamp.                                          |
| `UpdatedAt` | string | ISO last update timestamp.                                        |

### SourcesContents

| Field                     | Type    | Description                                                                          |
| ------------------------- | ------- | ------------------------------------------------------------------------------------ |
| `UID`                     | string  | Universal UID.                                                                       |
| `Source`                  | string  | Metadata source (e.g., `bb`).                                                        |
| `Id`                      | string  | ID in the external base.                                                             |
| `Title`                   | string  | Title.                                                                               |
| `OriginalTitle`           | string  | Title in original language.                                                          |
| `Year`                    | integer | Release year.                                                                        |
| `Directors`               | array   | Directors.                                                                           |
| `CreatedBy`               | array   | Creators (for series).                                                               |
| `Cast`                    | array   | Cast.                                                                                |
| `Crew`                    | array   | Technical crew. See sub-table.                                                       |
| `Akas`                    | array   | Localized titles by region. See sub-table.                                           |
| `Country`                 | array   | Production countries.                                                                |
| `Companies`               | array   | Production and distribution companies. See sub-table.                                |
| `Synopsis`                | array   | Synopsis by language. See sub-table.                                                 |
| `Images`                  | array   | Image URLs. See sub-table.                                                           |
| `Videos`                  | array   | Trailers and promos. See sub-table.                                                  |
| `Languages`               | array   | Languages of the title.                                                              |
| `ReleaseYears`            | array   | Release year by territory. See sub-table.                                            |
| `ReleaseDate`             | string  | Global release date.                                                                 |
| `Duration`                | integer | Runtime in minutes.                                                                  |
| `Genres`                  | array   | Genres.                                                                              |
| `Homepage`                | string  | Content's website.                                                                   |
| `Keywords`                | array   | Keywords.                                                                            |
| `Status`                  | string  | `null` / `Planned` / `Pilot` / `In Production` / `Returning` / `Canceled` / `Ended`. |
| `Type`                    | string  | `Movie` / `Series` / `Episode`.                                                      |
| `IsAdult`                 | boolean | Adult content.                                                                       |
| `Franchise`               | string  | Franchise.                                                                           |
| `Scripted`                | boolean | Scripted / Unscripted.                                                               |
| `Seasons`                 | array   | Seasons. See sub-table.                                                              |
| `Rating`                  | array   | Age rating (e.g., `PG-13`).                                                          |
| `CreatedAt` / `UpdatedAt` | string  | ISO timestamps.                                                                      |

#### Crew

| Field  | Type   | Description              |
| ------ | ------ | ------------------------ |
| `Name` | string | Name.                    |
| `Role` | string | Role (e.g., `Producer`). |

#### Akas

| Field      | Type   | Description            |
| ---------- | ------ | ---------------------- |
| `Language` | string | ISO Alpha2 (language). |
| `Region`   | string | ISO Alpha2 (country).  |
| `Title`    | string | Localized title.       |

#### Companies

| Field     | Type   | Description                    |
| --------- | ------ | ------------------------------ |
| `Country` | string | ISO Alpha2.                    |
| `Name`    | string | Company name.                  |
| `Type`    | string | `Production` or `Distributor`. |

#### Synopsis

| Field         | Type   | Description |
| ------------- | ------ | ----------- |
| `Region`      | string | ISO Alpha2. |
| `Language`    | string | ISO Alpha2. |
| `Description` | string | Text.       |

#### Images

| Field      | Type   | Description                                            |
| ---------- | ------ | ------------------------------------------------------ |
| `Type`     | string | `Poster` / `Backdrop` / `Thumbnail` / `Logo` / `null`. |
| `Language` | string | ISO Alpha2.                                            |
| `URL`      | string | Original URL.                                          |
| `BBURL`    | string | URL hosted by Fabric.                                  |

#### Videos

| Field      | Type   | Description         |
| ---------- | ------ | ------------------- |
| `Provider` | string | E.g., `YouTube`.    |
| `Id`       | string | Video ID.           |
| `Language` | string | ISO Alpha2.         |
| `Type`     | string | E.g., `Featurette`. |

#### ReleaseYears

| Field     | Type    | Description |
| --------- | ------- | ----------- |
| `Country` | string  | ISO Alpha2. |
| `Year`    | integer | —           |

#### Seasons (from SourcesContents)

| Field      | Type    | Description         |
| ---------- | ------- | ------------------- |
| `Number`   | integer | Season number.      |
| `Episodes` | integer | Number of episodes. |
| `Year`     | integer | Year.               |
| `SeasonId` | integer | Internal ID.        |
| `Title`    | string  | Season title.       |

### SourcesImages

| Field       | Type   | Description              |
| ----------- | ------ | ------------------------ |
| `UID`       | string | Fabric UID.              |
| `ID`        | string | Provider ID.             |
| `Type`      | string | Content type.            |
| `Provider`  | string | Source (e.g., `tmdb`).   |
| `Images`    | array  | See sub-table S-Images.  |
| `Seasons`   | array  | See sub-table S-Seasons. |
| `CreatedAt` | string | ISO timestamp.           |

> Sub-tables: `S-Images` (Type, ImageUrl); `S-Seasons` (ID, Number, Images, Episodes); `Season Images` and `Episode Images` with the same shape `{Type, ImageUrl}`.

### SourcesPopularity

| Field        | Type    | Description                         |
| ------------ | ------- | ----------------------------------- |
| `UID`        | string  | Fabric UID.                         |
| `Popularity` | integer | External provider popularity score. |
| `CreatedAt`  | string  | ISO timestamp.                      |

### SourcesRatings

| Field       | Type    | Description                           |
| ----------- | ------- | ------------------------------------- |
| `UID`       | string  | Fabric UID.                           |
| `Votes`     | integer | Number of votes in external provider. |
| `Score`     | number  | Average score.                        |
| `CreatedAt` | string  | ISO timestamp.                        |

***

## Streaming Availability & Content Pulse

Folders: `s3://<bucket-client>/Contents/latest/`, `Episodes/latest/`, `Stats/latest/`, `Platforms/latest/`. Frequency: **Daily + Weekly.**<br>

### Contents

| Field                 | Type    | Description                                         |
| --------------------- | ------- | --------------------------------------------------- |
| `PlatformId`          | integer | Platform ID.                                        |
| `PlatformCode`        | string  | Code `<country>.<platform>`.                        |
| `PlatformName`        | string  | Official name.                                      |
| `PlatformCountry`     | string  | ISO Alpha2.                                         |
| `HashUnique`          | string  | Hash identifying the title on a platform/territory. |
| `UID`                 | string  | Universal UID.                                      |
| `Id`                  | string  | Title ID on the platform.                           |
| `OtherIds`            | array   | Amazon only: ASIN, GTI, CompactGTI. See sub-table.  |
| `Title`               | string  | Title as it appears on the platform.                |
| `CleanTitle`          | string  | Title without parentheses / clarifications.         |
| `OriginalTitle`       | string  | Title in original language.                         |
| `Type`                | string  | `Movie` / `Tv Show`.                                |
| `Year`                | integer | Release year.                                       |
| `Duration`            | integer | Minutes.                                            |
| `ExternalIds`         | array   | See sub-table.                                      |
| `Deeplinks`           | object  | URLs of the title on the platform. See sub-table.   |
| `PlaybackLink`        | string  | URL that plays directly.                            |
| `Synopsis`            | string  | Synopsis.                                           |
| `Image`               | array   | Image URLs.                                         |
| `Rating`              | string  | Age rating.                                         |
| `Provider`            | array   | Producers (if reported by the platform).            |
| `Genres`              | array   | Genres normalized to English.                       |
| `GenresPlatform`      | array   | Genres as the platform shows them.                  |
| `Cast`                | array   | Cast.                                               |
| `Crew`                | array   | Technical crew. See sub-table.                      |
| `Directors`           | array   | Directors / creators.                               |
| `Download`            | boolean | Available offline.                                  |
| `IsOriginal`          | boolean | Platform original.                                  |
| `IsAdult`             | boolean | Adult content.                                      |
| `Packages`            | array   | Available business models. See sub-table.           |
| `CreatedAt`           | string  | Scraping timestamp.                                 |
| `IsBranded`           | boolean | Shows platform branding.                            |
| `IsExclusive`         | boolean | Platform exclusive.                                 |
| `IsPremium`           | boolean | Requires upgrade.                                   |
| `Seasons`             | array   | Seasons. See sub-table.                             |
| `Subtitles`           | array   | Subtitle languages (ISO 639-2).                     |
| `Dubbed`              | array   | Dubbing languages.                                  |
| `PopularityRankingBy` | array   | Ranking inside the platform. See sub-table.         |
| `UserData`            | array   | User attributes (likes/favorites). See sub-table.   |
| `NewEntry`            | boolean | New entry on this platform+region.                  |
| `FirstDetection`      | string  | First detection timestamp.                          |

#### OtherIds

| Field  | Type   | Description                 |
| ------ | ------ | --------------------------- |
| `Id`   | string | Identifier.                 |
| `Name` | string | Associated name (optional). |

#### ExternalIds (Streaming Availability)

| Field         | Type   | Description                        |
| ------------- | ------ | ---------------------------------- |
| `Provider`    | string | `imdb` / `tmdb` / `tvdb` / `eidr`. |
| `ID`          | string | External ID.                       |
| `ContentType` | string | `Tv Show` / `Episode` / `Movie`.   |

#### Deeplinks

| Field     | Type   | Description             |
| --------- | ------ | ----------------------- |
| `Web`     | string | Web URL.                |
| `Android` | string | Android URL (optional). |
| `iOS`     | string | iOS URL (optional).     |

#### Crew

| Field  | Type   | Description           |
| ------ | ------ | --------------------- |
| `Role` | string | Role on the platform. |
| `Name` | string | Name.                 |

#### Packages

| Field             | Type   | Description                                                                              |
| ----------------- | ------ | ---------------------------------------------------------------------------------------- |
| `Type`            | string | `subscription-vod` / `transaction-vod` / `free-vod` / `validated-vod` / `tv-everywhere`. |
| `Definition`      | string | `HD` / `SD` / `4K` / `8K` (optional).                                                    |
| `BuyPrice`        | number | Buy price (optional).                                                                    |
| `RentPrice`       | number | Rent price (optional).                                                                   |
| `Currency`        | string | ISO 4217 (optional).                                                                     |
| `License`         | array  | `VOD` / `EST` (optional).                                                                |
| `Plan`            | string | Special plan / channel (e.g., Amazon channel).                                           |
| `SeasonRentPrice` | number | Episodes only.                                                                           |
| `SeasonBuyPrice`  | number | Episodes only.                                                                           |

#### Seasons (Contents)

| Field      | Type    | Description                   |
| ---------- | ------- | ----------------------------- |
| `Number`   | integer | Number.                       |
| `Episodes` | integer | Number of episodes.           |
| `Year`     | integer | Year.                         |
| `SeasonId` | string  | Platform ID.                  |
| `Title`    | string  | Title.                        |
| `Deeplink` | string  | Season URL.                   |
| `OtherIds` | array   | Additional IDs.               |
| `Packages` | array   | Packages at the season level. |

#### PopularityRankingBy

| Field   | Type    | Description   |
| ------- | ------- | ------------- |
| `Top`   | string  | Ranking name. |
| `Value` | integer | Position.     |

#### UserData

| Field   | Type    | Description                    |
| ------- | ------- | ------------------------------ |
| `Name`  | string  | `Favorites` / `Likes` / ...    |
| `Value` | integer | Value at the time of scraping. |

### Episodes

| Field                                                                                                                                                                                              | Type    | Description                             |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | --------------------------------------- |
| `PlatformId`, `PlatformCode`, `PlatformName`, `PlatformCountry`                                                                                                                                    | —       | Identify the platform (see *Contents*). |
| `Season`                                                                                                                                                                                           | integer | Season number.                          |
| `Episode`                                                                                                                                                                                          | integer | Episode number.                         |
| `HashUnique`                                                                                                                                                                                       | string  | Platform+territory hash.                |
| `Id`                                                                                                                                                                                               | string  | Episode ID on the platform.             |
| `OtherIds`                                                                                                                                                                                         | array   | Same as Contents.                       |
| `ParentId`                                                                                                                                                                                         | string  | Parent series ID on the platform.       |
| `ParentTitle`                                                                                                                                                                                      | string  | Parent series title.                    |
| `ParentHashUnique`                                                                                                                                                                                 | string  | Parent series hash.                     |
| `ParentUID`                                                                                                                                                                                        | string  | Parent series universal UID.            |
| `Title`                                                                                                                                                                                            | string  | Episode title.                          |
| `OriginalTitle`                                                                                                                                                                                    | string  | Original language.                      |
| `Type`                                                                                                                                                                                             | string  | `Episode`.                              |
| `Year`                                                                                                                                                                                             | integer | Year.                                   |
| `Duration`                                                                                                                                                                                         | integer | Minutes.                                |
| `ExternalIds`, `Deeplinks`, `PlaybackLink`, `Synopsis`, `Image`, `Rating`, `Provider`, `Genres`, `GenresPlatform`, `Cast`, `Directors`, `Download`, `IsAdult`, `UserData`, `Packages`, `CreatedAt` | —       | Same sub-structures as *Contents*.      |

### Stats

| Field                                                           | Type   | Description                                                |
| --------------------------------------------------------------- | ------ | ---------------------------------------------------------- |
| `PlatformId`, `PlatformCode`, `PlatformName`, `PlatformCountry` | —      | Identify the platform.                                     |
| `NullRate`                                                      | array  | % of nulls per required variable, grouped by content type. |
| `LastUpdates`                                                   | string | Last updates timestamp.                                    |
| `Total`                                                         | array  | Total by content type.                                     |
| `Match`                                                         | array  | Match rate by external provider.                           |
| `CreatedAt`                                                     | string | Timestamp.                                                 |

### Platforms

| Field                     | Type    | Description                                |
| ------------------------- | ------- | ------------------------------------------ |
| `PlatformId`              | integer | ID.                                        |
| `PlatformCode`            | string  | Code `<country>.<platform>`.               |
| `OtherCodes`              | array   | Previous codes.                            |
| `PlatformCountry`         | string  | ISO Alpha2.                                |
| `PlatformName`            | string  | Official name.                             |
| `PlatformLaunchYear`      | integer | Launch year.                               |
| `CountryInfo`             | object  | See sub-table.                             |
| `Currencies`              | array   | See sub-table.                             |
| `CreatedAt` / `UpdatedAt` | string  | Timestamps.                                |
| `IsActive`                | boolean | Whether it's being tracked.                |
| `Owners`                  | array   | Owning companies.                          |
| `Period`                  | integer | Days between surveys.                      |
| `ContentAggregator`       | boolean | Whether it aggregates third-party content. |
| `PlatformLogo`            | string  | Logo URL.                                  |
| `Links`                   | object  | Platform URLs. See sub-table.              |
| `AndroidPackage`          | string  | Android package ID.                        |

#### CountryInfo

| Field       | Type   | Description               |
| ----------- | ------ | ------------------------- |
| `Region`    | string | E.g., `Americas`.         |
| `SubRegion` | string | E.g., `Northern America`. |
| `Name`      | string | Full name.                |
| `Code`      | string | ISO 3166-1 alpha-2.       |

#### Currencies

| Field    | Type   | Description                   |
| -------- | ------ | ----------------------------- |
| `Name`   | string | E.g., `United States dollar`. |
| `Code`   | string | ISO 4217.                     |
| `Symbol` | string | E.g., `$`.                    |

#### Links

| Field       | Type   | Description      |
| ----------- | ------ | ---------------- |
| `iOS`       | string | App Store URL.   |
| `PlayStore` | string | Google Play URL. |
| `Web`       | string | Web URL.         |

***

## Hits

Folder: `s3://<bucket-client>/Hits/latest/`. Frequency: **weekly**.<br>

### Hits

| Field              | Type    | Description                                               |
| ------------------ | ------- | --------------------------------------------------------- |
| `UID`              | string  | Universal UID.                                            |
| `IMDBId`           | string  | IMDb ID.                                                  |
| `TMDBId`           | string  | TMDB ID.                                                  |
| `DateHits`         | string  | First day of the analyzed week.                           |
| `WeekOn`           | integer | Week number of the year.                                  |
| `YearOn`           | integer | Year.                                                     |
| `Title`            | string  | Title (IMDb).                                             |
| `Year`             | integer | Release year (IMDb).                                      |
| `Country`          | string  | Country where the score is computed (ISO Alpha2).         |
| `Type`             | string  | `Movie` / `Series`.                                       |
| `Genre`            | string  | Primary genre.                                            |
| `Scores`           | array   | See sub-table.                                            |
| `Position`         | integer | Position within country+type.                             |
| `DeltaPositionInt` | integer | Position change vs. previous week.                        |
| `Average`          | number  | Average Hits within country+type.                         |
| `HitsRelative`     | number  | `(Hits/Average) - 1`.                                     |
| `HitsLocal`        | number  | Hits compared with that of the title's country of origin. |
| `ReleaseDate`      | string  | Release date in the country.                              |
| `HitsCategory`     | string  | Category assigned based on score (e.g., `Unicorn`).       |
| `TrendScore`       | number  | Relative score based on moving averages.                  |
| `TrendCategory`    | string  | Category based on trend score.                            |

#### Scores

| Field    | Type   | Description                                                                                                                                                                                                    |
| -------- | ------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `Score`  | number | Value.                                                                                                                                                                                                         |
| `Source` | string | Score source. Possible: `Piracy`, `Twitter`, `Imdb`, `Cdb` (collaborative DB), `Youtube`, `Hits` (weighted average: 20% Piracy + 15% Twitter + 10% Search + 25% CDB Votes + 20% CDB Popularity + 10% YouTube). |

***

## Awards

Folder: `s3://<bucket-client>/Awards/latest/`. Frequency: **weekly**.<br>

### Awards

| Field             | Type    | Description                                              |
| ----------------- | ------- | -------------------------------------------------------- |
| `UID`             | string  | Universal UID.                                           |
| `Event`           | string  | Award name (e.g., `AACTA Awards`).                       |
| `Territory`       | string  | Event location.                                          |
| `Year`            | integer | Year.                                                    |
| `Category`        | string  | Category.                                                |
| `Subcategory`     | string  | Subcategory.                                             |
| `WinnerOrNominee` | string  | `Nominee` / `Winner`.                                    |
| `Title`           | string  | Content title.                                           |
| `EpisodeTitle`    | string  | Episode title if applicable.                             |
| `CotentType`      | string  | `movie` / `series`. *(Sic — typo in the original wiki.)* |
| `ImdbIdContent`   | string  | Content's IMDb ID.                                       |
| `DataPerson`      | array   | See sub-table.                                           |

#### DataPerson

| Field    | Type   | Description       |
| -------- | ------ | ----------------- |
| `Name`   | string | Person's name.    |
| `ImdbId` | string | Person's IMDb ID. |

***

## Content Tracker & Coming Soon

Folders: `s3://<bucket-client>/ContentTracker/latest/` and `s3://<bucket-client>/ComingSoon/latest/`. Frequency: **weekly**.<br>

### ContentTracker

| Field                                          | Type    | Description                                                                 |
| ---------------------------------------------- | ------- | --------------------------------------------------------------------------- |
| `BASED_ON_BOOK_VIDEOGAME`                      | boolean | —                                                                           |
| `CHANNEL_OTT`                                  | array   | OTT platforms.                                                              |
| `CONTENT_NAME`                                 | string  | Content name.                                                               |
| `CONTENT_TYPE`                                 | string  | `Series` / `Movie`.                                                         |
| `COUNTRY_OF_PRODUCTION`                        | array   | Production countries.                                                       |
| `COUNTRY_OF_THE_ORIGINAL_CONTENT`              | array   | If it's an adaptation.                                                      |
| `DATE`                                         | string  | Epoch timestamp.                                                            |
| `DISTRIBUTION_COMPANY`                         | array   | Distributors.                                                               |
| `DISTRIBUTION_COMPANY_OF_THE_ORIGINAL_CONTENT` | array   | Original distributor.                                                       |
| `DISTRIBUTION_COUNTRY_IES`                     | array   | Distribution countries.                                                     |
| `EPISODES`                                     | integer | Count.                                                                      |
| `GENRE`                                        | string  | Primary genre.                                                              |
| `ID_CONTENT`                                   | integer | Internal ID.                                                                |
| `ID_IMDb`                                      | string  | IMDb ID.                                                                    |
| `ID_NEWS`                                      | integer | Related news ID.                                                            |
| `LINK`                                         | string  | News URL.                                                                   |
| `MINUTES`                                      | integer | Runtime.                                                                    |
| `MULTIPLATFORM`                                | string  | —                                                                           |
| `NAME_OF_ORIGINAL_CONTENT`                     | array   | Original name (if adaptation).                                              |
| `PRODUCTION_COMPANY`                           | array   | Production companies.                                                       |
| `PRODUCTION_COMPANY_OF_THE_ORIGINAL_CONTENT`   | array   | Original production companies.                                              |
| `PRODUCTION_TYPE`                              | string  | —                                                                           |
| `REGION`                                       | array   | Regions.                                                                    |
| `RELEASE_DATE`                                 | string  | Release date.                                                               |
| `SEASONS`                                      | array   | Seasons.                                                                    |
| `STAGE`                                        | string  | `Released` / `Distribution` / `Production` / `Sale` / `Theatrical Revival`. |
| `SUBGENRE`                                     | array   | Subgenres.                                                                  |
| `SYNOPSIS`                                     | string  | Synopsis.                                                                   |
| `TYPE_OF_AGREEMENT`                            | string  | `null` / `Individual season` / `Last season`.                               |
| `TYPE_OF_BUSINESS`                             | array   | —                                                                           |
| `TYPE_OF_PLATFORM`                             | array   | —                                                                           |
| `TYPE_OF_RELEASE`                              | string  | `null` / `All At Once` / `Daily` / `Week Over Week`.                        |

### RelevantNews

| Field               | Type    | Description                                                                                                                  |
| ------------------- | ------- | ---------------------------------------------------------------------------------------------------------------------------- |
| `COUNTRY`           | array   | Countries.                                                                                                                   |
| `DATE`              | string  | Epoch timestamp.                                                                                                             |
| `DESCRIPTION`       | string  | News summary.                                                                                                                |
| `ID_CONTENT`        | integer | Content link.                                                                                                                |
| `ID_NEWS`           | integer | News ID.                                                                                                                     |
| `LINK`              | string  | URL.                                                                                                                         |
| `NAME`              | array   | Mentioned platforms / companies.                                                                                             |
| `PARTNERED_TO`      | array   | Partners.                                                                                                                    |
| `TERRITORY`         | array   | Territory.                                                                                                                   |
| `TYPE_OF_AGREEMENT` | string  | `Acquisition` / `Industry News` / `New Channels` / `New Companies` / `New Platforms` / `Partnership-Co-production` / `null`. |

### ComingSoon

| Field                                                            | Type     | Description                                              |
| ---------------------------------------------------------------- | -------- | -------------------------------------------------------- |
| `PlatformId`                                                     | integer  | Platform ID.                                             |
| `PlatformCode`                                                   | string   | `<country>.<platform>`.                                  |
| `PlatformName`                                                   | string   | Official name.                                           |
| `PlatformCountry`                                                | string   | ISO Alpha2.                                              |
| `Title`                                                          | string   | Title.                                                   |
| `AvailabilityDay`                                                | string   | Availability date.                                       |
| `URL`                                                            | string   | Title URL.                                               |
| `Year`                                                           | integer  | Original release year.                                   |
| `Classification`                                                 | string   | `premiere` / `returning` / `library`.                    |
| `UID`                                                            | string   | Universal UID.                                           |
| `ExternalIds`                                                    | array    | See sub-table.                                           |
| `Type`                                                           | string   | Content type.                                            |
| `ReleaseType`                                                    | string   | `All At Once` / `Daily` / `Weekly` / `Weekly (Preview)`. |
| `Seasons`                                                        | array    | See sub-table.                                           |
| `Source`                                                         | string   | Source note URL.                                         |
| `Duration`                                                       | integer  | Minutes.                                                 |
| `IsOriginal`                                                     | boolean  | —                                                        |
| `Genres`, `Themes`, `ProductionCountries`, `ProductionCompanies` | array    | —                                                        |
| `CreatedAt`                                                      | datetime | —                                                        |

#### ExternalIds (ComingSoon)

| Field      | Type   | Description                |
| ---------- | ------ | -------------------------- |
| `Provider` | string | External provider.         |
| `ID`       | string | ID.                        |
| `Type`     | string | Type in the external base. |

#### Seasons (ComingSoon)

| Field      | Type    | Description |
| ---------- | ------- | ----------- |
| `Number`   | integer | Number.     |
| `Episodes` | integer | Count.      |

***

## Live Streaming & FAST Channels

Folders: `s3://<bucket-client>/LiveStreaming/{channels,contents,schedule,events,sports}/latest/`. Frequency: Daily

### channels

| Field                             | Type           | Description                             |
| --------------------------------- | -------------- | --------------------------------------- |
| `PlatformNumberId`                | integer        | Platform ID.                            |
| `PlatformCountry`, `PlatformCode` | string         | Identifiers.                            |
| `CreatedAt`, `Timestamp`          | string/date    | When it was scraped.                    |
| `Id`                              | string         | Channel ID.                             |
| `Title`                           | string         | Channel name.                           |
| `Type`                            | string         | Type (assigned, not scraped).           |
| `Deeplink`, `Broadcast`, `Number` | string/integer | URLs and channel number.                |
| `Images`                          | array          | See sub-table.                          |
| `Genres`, `Subtitles`, `Dubbed`   | array          | —                                       |
| `FullDay`                         | boolean        | 24h with no grid.                       |
| `OnlyEvents`                      | boolean        | Events only.                            |
| `IsOriginal`, `IsAdult`, `IsKids` | boolean        | Flags.                                  |
| `IsFast`, `FastBy`                | boolean/string | FAST type.                              |
| `Owner`                           | string         | Channel owner.                          |
| `Packages`                        | array          | See sub-table.                          |
| `GMT`                             | integer        | TZ offset.                              |
| `IsActive`                        | boolean        | Whether it was active at scraping time. |
| `Order`                           | integer        | Order in the grid.                      |

#### Images (Live Streaming)

| Field  | Type   | Description |
| ------ | ------ | ----------- |
| `Type` | string | Image type. |
| `Url`  | string | Direct URL. |

#### Packages (Live Streaming)

| Field  | Type   | Description                                                                              |
| ------ | ------ | ---------------------------------------------------------------------------------------- |
| `Type` | string | `Free-VOD` / `Subscription-VOD` / `TV-Everywhere` / `Validated-VOD` / `Transaction-VOD`. |

### contents

| Field                                                 | Type    | Description                                                                |
| ----------------------------------------------------- | ------- | -------------------------------------------------------------------------- |
| `PlatformNumberId`, `PlatformCountry`, `PlatformCode` | —       | Platform identifiers.                                                      |
| `CreatedAt`, `Timestamp`                              | —       | Scraping.                                                                  |
| `Id`, `Title`, `Type`, `Deeplink`, `Year`             | —       | Content metadata (`Type`: `movie`, `episode`, `undefined`, `placeholder`). |
| `Synopsis`, `Images`, `Duration`, `Genres`, `Rating`  | —       | Attributes.                                                                |
| `OnDemand`, `IsAdult`, `IsKids`                       | boolean | Flags.                                                                     |
| `SerieTitle`, `Season`, `Episode`                     | —       | If part of a series.                                                       |
| `Packages`                                            | array   | Business models.                                                           |

### schedule

| Field                                                                           | Type    | Description                             |
| ------------------------------------------------------------------------------- | ------- | --------------------------------------- |
| `PlatformNumberId`, `PlatformCountry`, `PlatformCode`, `CreatedAt`, `Timestamp` | —       | —                                       |
| `Id`                                                                            | string  | Schedule payload ID.                    |
| `ChannelId`, `ChannelTitle`                                                     | —       | Associated channel.                     |
| `ContentId`, `ContentTitle`, `ContentMetadata`                                  | —       | Associated content.                     |
| `Type`                                                                          | string  | `schedule` / `placeholder`.             |
| `Subtitles`, `Dubbed`, `ClosedCaption`, `Accessibility`                         | —       | Accessibility.                          |
| `IsFast`                                                                        | boolean | Whether the schedule's channel is FAST. |
| `StartDate`, `EndDate`                                                          | date    | Start and end.                          |
| `Duration`, `Seconds`                                                           | integer | Duration.                               |
| `GMT`                                                                           | integer | TZ offset.                              |

### events

| Field                                                                           | Type   | Description                                          |
| ------------------------------------------------------------------------------- | ------ | ---------------------------------------------------- |
| `PlatformNumberId`, `PlatformCountry`, `PlatformCode`, `CreatedAt`, `Timestamp` | —      | —                                                    |
| `Id`                                                                            | string | Event ID.                                            |
| `Title`, `Type`                                                                 | —      | `Type`: `sport` / `concert` / `program` / `unknown`. |
| `Deeplink`, `Broadcast`, `Synopsis`, `Image`                                    | —      | Metadata.                                            |
| `Season`, `ParentId`, `ParentTitle`                                             | —      | Links.                                               |
| `Genre`, `Language`, `Crew`                                                     | —      | Attributes.                                          |
| `Date`                                                                          | date   | Start.                                               |
| `Duration`, `Venue`, `Location`, `Provider`, `GMT`, `Packages`                  | —      | —                                                    |

***

## Sports

Folder: included inside Live Streaming (`s3://<bucket-client>/LiveStreaming/sports/latest/`). Schema based on **schema.org BroadcastEvent**.<br>

### BroadcastEvent (root)

| Field                 | Type    | Description                        |
| --------------------- | ------- | ---------------------------------- |
| `@context`            | string  | Schema URL (schema.org).           |
| `@type`               | string  | `BroadcastEvent`.                  |
| `event_id`            | string  | Unique event hash.                 |
| `isLiveBroadcast`     | boolean | Whether it's live.                 |
| `eventAttendanceMode` | string  | E.g., `OnlineEventAttendanceMode`. |
| `broadcastOfEvent`    | object  | See sub-table.                     |

#### broadcastOfEvent (SportsEvent)

| Field                  | Type     | Description                     |
| ---------------------- | -------- | ------------------------------- |
| `@type`                | string   | `SportsEvent`.                  |
| `sport`                | string   | Sport.                          |
| `organizer`            | object   | See sub-table.                  |
| `eventStatus`          | string   | Event status.                   |
| `name`, `description`  | string   | —                               |
| `awayTeam`, `homeTeam` | object   | See sub-table.                  |
| `startDate`            | datetime | Start.                          |
| `location`             | object   | See sub-table.                  |
| `offers`               | object   | See sub-table (AggregateOffer). |
| `audience`             | object   | Target audience.                |

#### organizer

| Field         | Type    | Description       |
| ------------- | ------- | ----------------- |
| `@type`       | string  | `Organization`.   |
| `name`        | string  | Name.             |
| `year`        | integer | Competition year. |
| `description` | string  | Description.      |
| `logo`        | string  | Logo URL.         |

#### awayTeam / homeTeam (SportsTeam)

| Field   | Type   | Description           |
| ------- | ------ | --------------------- |
| `@type` | string | `SportsTeam`.         |
| `name`  | array  | Team or player names. |
| `sport` | string | Sport.                |
| `logo`  | string | Logo URL.             |

#### location

| Field   | Type   | Description               |
| ------- | ------ | ------------------------- |
| `@type` | string | `SportsActivityLocation`. |
| `name`  | string | Venue name.               |

#### offers (AggregateOffer)

| Field                   | Type   | Description                        |
| ----------------------- | ------ | ---------------------------------- |
| `@type`                 | string | `AggregateOffer`.                  |
| `highPrice`, `lowPrice` | number | Price range.                       |
| `offerCount`            | number | Number of offers.                  |
| `offers`                | array  | Individual offers (see sub-table). |

#### Offer (individual)

| Field   | Type   | Description |
| ------- | ------ | ----------- |
| `@type` | string | `Offer`.    |
| `name`  | string | Offer name. |
| `url`   | string | URL.        |

***

## Prices, Plans & Bundles

Folder: `s3://<bucket-client>/PPB/latest/`. Frequency: weekly.<br>

### Platforms (PPB)

| Field                          | Type    | Description                       |
| ------------------------------ | ------- | --------------------------------- |
| `platform_code`                | string  | `<country>.<platform>`.           |
| `entry_date`                   | string  | Date of the first record.         |
| `country` / `country_iso_code` | string  | Country.                          |
| `owner`                        | string  | Owning company.                   |
| `platform`                     | string  | Platform name.                    |
| `bundle_access`                | boolean | Whether the platform has bundles. |
| `vpn`                          | string  | VPN used for scraping.            |

### Plans\_and\_Prices

| Field                                                                                                                                 | Type         | Description                                        |
| ------------------------------------------------------------------------------------------------------------------------------------- | ------------ | -------------------------------------------------- |
| `platform_code`                                                                                                                       | string       | —                                                  |
| `country_iso_code`                                                                                                                    | string       | —                                                  |
| `date`, `time`                                                                                                                        | string       | When it was collected (`time` is TZ offset).       |
| `plan_id`                                                                                                                             | string       | `<platform_code>+<plan_name>`.                     |
| `plan_type`                                                                                                                           | string       | `Basic` / `Additional` / `Free` / `Transactional`. |
| `tier_type`                                                                                                                           | string/float | Tier within plan\_type.                            |
| `revenue_model`                                                                                                                       | string       | —                                                  |
| `plan_name`                                                                                                                           | string       | Commercial name.                                   |
| `plan_screenshot_link`                                                                                                                | string       | Plan screenshot URL.                               |
| `svod_duration`                                                                                                                       | string       | For subscriptions, duration.                       |
| `tvod_content_type`                                                                                                                   | array        | Transactional types (Movie/Series/Season/Episode). |
| `live_channels_amount`                                                                                                                | float        | Live channels.                                     |
| `currency`                                                                                                                            | string       | ISO 4217.                                          |
| `price`                                                                                                                               | float        | Current price.                                     |
| `price_in_usd`                                                                                                                        | number       | Price in USD.                                      |
| `price_first_date` / `price_change_date`                                                                                              | string       | Dates.                                             |
| `has_commercials`, `has_downloads`                                                                                                    | boolean      | Flags.                                             |
| `max_resolution`                                                                                                                      | string       | `SD` / `HD` / `UHD` / `Full HD` / `4K`.            |
| `max_profiles`, `max_devices`, `max_streams`, `max_downloads`                                                                         | float        | Limits.                                            |
| `smart_tv_compatibility`, `external_tv_device_compatibility`, `browser_compatibility`, `tablet_compatibility`, `mobile_compatibility` | boolean      | Compatibilities.                                   |
| `devices_screenshot_link`                                                                                                             | string       | Screenshot URL.                                    |
| `plan_status`                                                                                                                         | string       | `Active` / `Inactive` / `New`.                     |
| `price_url`, `plan_url`, `devices_url`, `live_channels_url`                                                                           | string       | Source URLs.                                       |
| `week_number`                                                                                                                         | float        | Deliverable's week number.                         |
| `type_of_change`                                                                                                                      | string       | `Modified` / `Deleted`.                            |
| `inactive_plan_date`                                                                                                                  | string       | If applicable.                                     |
| `entry_barrier`, `entry_barrier_details`                                                                                              | string       | Entry barrier (what's needed to access).           |

### Offers

| Field                                                  | Type    | Description                                     |
| ------------------------------------------------------ | ------- | ----------------------------------------------- |
| `date`                                                 | string  | —                                               |
| `plan_id`                                              | string  | —                                               |
| `offer_id`                                             | string  | `<plan_id>+<offer_type>+<offer_duration>`.      |
| `offer_type`                                           | string  | `Free Trial` / `Discount` / `Amount` / `Price`. |
| `offer_amount`                                         | float   | Numeric value.                                  |
| `offer_duration`                                       | integer | Days.                                           |
| `offer_comunication`                                   | string  | `Days` / `Weeks` / `Months` / `Years`. *(Sic.)* |
| `offer_screenshot_link`                                | string  | URL.                                            |
| `offer_first_date`, `offer_change_date`                | string  | Dates.                                          |
| `offer_status`                                         | string  | `Active` / `Inactive` / `New`.                  |
| `week_number`, `type_of_change`, `inactive_offer_date` | —       | —                                               |
| `entry_barrier`, `entry_barrier_details`               | string  | —                                               |

### Bundles

| Field                                                               | Type          | Description                                                 |
| ------------------------------------------------------------------- | ------------- | ----------------------------------------------------------- |
| `country_iso_code`                                                  | string        | —                                                           |
| `date`, `time`                                                      | string        | —                                                           |
| `plan_id`                                                           | string        | Plan the bundle is associated with.                         |
| `bundle_plan_id`                                                    | string        | `<partner>+<bundle_plan_name>`.                             |
| `partner`                                                           | string        | Partner / reseller.                                         |
| `bundle_plan_name`                                                  | string        | Bundle name.                                                |
| `bundle_type`                                                       | string        | `Commercial Bundle` / `Billing Bundle` / `Deeplink Bundle`. |
| `currency`, `bundle_plan_price`, `bundle_price_in_usd`              | —             | Price.                                                      |
| `has_parent_price`, `parent_price`                                  | boolean/float | Whether the bundle requires another service.                |
| `ott_app_in_stb`                                                    | boolean       | Whether it's available in the MSO's set-top box.            |
| `bundle_offer_type`, `bundle_offer_amount`, `bundle_offer_duration` | —             | Bundle offer.                                               |
| `offer_communication`                                               | string        | `Days` / `Weeks` / `Months` / `Years`.                      |
| `bundle_screenshot_link`, `bundle_link`                             | string        | URLs.                                                       |
| `bundle_status`                                                     | string        | `Active` / `Inactive` / `New`.                              |
| `week_number`, `type_of_change`, `inactive_bundle_date`             | —             | —                                                           |
| `entry_barrier`, `entry_barrier_details`                            | string        | —                                                           |

***

## Online Audits

Folder: `s3://<bucket-client>/OnlineAudits/latest/`. Frequency: **monthly**.<br>

Files: `piracy_platforms_data.jsonl` and `piracy_scraping.jsonl`.

### Piracy Platforms Data

| Field                                        | Type           | Description                            |
| -------------------------------------------- | -------------- | -------------------------------------- |
| `Date`                                       | string         | YYYY-MM-DD.                            |
| `Platform`                                   | string         | Commercial name.                       |
| `PlatformCode`                               | string         | Code.                                  |
| `Url`                                        | string         | Platform URL.                          |
| `AccessMethod`                               | string         | How it's available.                    |
| `ContentType`                                | string         | Types (`Movies` / `Series` / `Anime`). |
| `OriginCountry`                              | string         | Country of origin.                     |
| `Domain`                                     | string         | Domain.                                |
| `GlobalRanking`                              | integer        | Global ranking by traffic.             |
| `CountryTrafficPenetration`                  | array (dict)   | % penetration by country (top 5).      |
| `TotalVisits`                                | integer        | Last-month visits.                     |
| `Dns`, `Ip`, `ServerLocation`, `HostServers` | string/integer | Infra.                                 |
| `CountryRanking`                             | array (dict)   | Ranking by country.                    |

### Piracy Platforms Scraping

| Field                    | Type    | Description                 |
| ------------------------ | ------- | --------------------------- |
| `Date`                   | string  | YYYY-MM-DD.                 |
| `PlatformCode`           | string  | Platform.                   |
| `Permalink`              | string  | Title URL.                  |
| `UID`                    | string  | Universal UID.              |
| `Title`, `OriginalTitle` | string  | Titles.                     |
| `ContentType`            | string  | `Movie` / `Series`.         |
| `Year`                   | integer | Release year.               |
| `IMDbId`                 | string  | IMDb.                       |
| `Genres`                 | string  | Genres.                     |
| `ReleaseDate`            | string  | YYYY-MM-DD.                 |
| `PrimaryCountry`         | string  | Primary production country. |

***

For query patterns and joins by **UID** and **Global Id + Country**, see [Consumption best practices](/insights/data-hub/consumption-best-practices.md).

***

<details>

<summary>Related Articles</summary>

* [Getting started](/insights/data-hub/getting-started.md)
* [Data access](/insights/data-hub/data-access.md)
* [Structure and files](/insights/data-hub/structure-and-files.md)

</details>

> We hope you found this article helpful. If you have a question this article doesn't address, reach out on the [Service Desk](https://fabric.atlassian.net/servicedesk/customer/portal/336).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://knowledgebase.fabricdata.com/insights/data-hub/schemas-by-dataset.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.