> 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 catalogue identifiers.

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 | Identifier provider (see the provider list in your delivery). |
| `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 | Video platform.     |
| `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 | Image source.            |
| `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 | Identifier provider.             |
| `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.                                            |
| `DateHits`         | string  | First day of the analyzed week.                           |
| `WeekOn`           | integer | Week number of the year.                                  |
| `YearOn`           | integer | Year.                                                     |
| `Title`            | string  | Title.                                                    |
| `Year`             | integer | Release year.                                             |
| `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: `Hits` (composite score) and its component signals (unofficial distribution, social, search, collaborative databases, video). |

***

## 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  | External content identifier.                             |
| `DataPerson`      | array   | See sub-table.                                           |

#### DataPerson

| Field    | Type   | Description                 |
| -------- | ------ | --------------------------- |
| `Name`   | string | Person's name.              |
| `ImdbId` | string | External person identifier. |

***

## 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  | External content identifier.                                                |
| `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  | External content identifier. |
| `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).