TV/Digital Episodes Metadata

Episodes per season of a show are provided when available viaVW_TV_DIGITAL_EPISODES_DS.

Column Reference

Field NameTypeDescription
FTV_LUMINATE_PROJECT_IDVARCHARUnique Luminate ID pertaining to the season of the show.
TITLEVARCHARTitle of the season of the show
PROJECT_TYPEVARCHARType of project: TV/Digital
EPISODE_GUIDESARRAYArray containing episode data, including episode title, episode air date, and credits. For each episode, the below values are available:
  • air_date: The release date of the episode (YYYY-MM-DD).
  • co_starring: Array of talent credited as Co-Stars on the episode. See Episode Credits for more information.
  • directed_by: Array of talent credited as the episode's director(s). See Episode Credits for more information.
  • eidr_episode_id: Standard Entertainment Identifier Registry ID string.
  • episode_guide: Season title
  • episode_id: Unique internal identification string for the episode.
  • episode_no: Episode number. Episode numbers in Film and TV increment continuously throughout the series.
  • episode_runtime: Exact episode runtime in minutes.
  • episode_title: Title of the episode.
  • guest_stars: Array of talent credited as Guest Stars on the episode. See Episode Credits for more information.
  • synopsis: Summary of the episode's plot.
  • title_type_designation: Categorical hierarchy string, refers to the season.
  • written_by: Array of talent detailing the episode's writer(s). See Episode Credits for more information.

Additional Detail

Episode Credits

Episode Credits are provided for episode-specific credits. Credits that are more applicable to the season of the show, such as Series Regulars, will be found in VW_TV_DIGITAL_PROJECTS_DS.CASTS .

The following data is provided as applicable for the arrays of talent credits.

  • character: Name of the role. Applicable to acting credits.
  • first_name: First name of the individual.
  • last_name: Last name of the individual.
  • middle_name: Middle name or initial of the individual.
  • segment: Additional metadata about the credit
  • talent_id: Unique Luminate ID for the talent. Links to VW_TALENTS_DS .
  • co_talent_first_name: First name of a co-talent.
  • co_talent_id: Unique identifier for a co-talent. Links to VW_TALENTS_DS .
  • co_talent_last_name: Last name of a co-talent.
  • co_talent_middle_name: Middle name of a co-talent.

Did this page help you?