musiccaps_details (view)

1 row where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "show soundtrack" and musiccaps_names contains "Scary music"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Vivienne Mackinder demonstrates the latest techniques to create short style haircuts The song is an instrumental. The tempo is medium with a keyboard accompaniment, sonic effects, various percussion hits, strong bass line and synth pad section. The song is eerie and full of tension. The song is tv show theme and has poor audio quality. 2011-08-12T02:03:07Z hikariscissors Vivienne Mackinder is one of the most highly respected international leaders and innovators in the hairdressing profession today. In her work as Artistic Director for industry 'Grand Masters' Vidal Sassoon and Trevor Sorbie, Vivienne developed an expertise for precision cutting and an eye for original hair design, from the classic and the commercial, to the avant-garde. Based in New York City, she grew up in London and subsequently opted to 'spread her wings' to the United States. She has been honoured with numerous awards, including the prestigious IBS 'Editors' Choice Awards (three times). As well as, the much coveted North American Hairstyling Awards (NAHA) (five times), including "Masters." Honouree - North American Hair Styling Awards "Life Time Achievement" 2009. For more information on Vivienne Mackinder, please visit her website www.hairdesignertv.com. ["Music", "Scary music"] ["instrumental music", "suspense", "tension", "fashion show tune", "show soundtrack", "percussive hits", "strong bass line", "synth string pads", "eerie harmonies", "fear", "stress", "medium tempo", "sonic effects", "various percussion hits", "groovy music", "poor audio quality", "competition", "medium tempo"] 1 oC0e8GXYy_4 4610

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW musiccaps_details AS select
  musiccaps.url as video,
  json_object(
    'label',
    coalesce(videos.title, 'Missing from YouTube'),
    'href',
    musiccaps.url
  ) as youtube_link,
  musiccaps.caption as musiccaps_caption,
  videos.publishedAt as youtube_published,
  videos.channelTitle as youtube_channel,
  videos.description as youtube_description,
  musiccaps.audioset_names as musiccaps_names,
  musiccaps.aspect_list as musiccaps_aspects,
  musiccaps.author_id as musiccaps_author,
  videos.id as youtube_id,
  musiccaps.rowid as musiccaps_rowid
from
  musiccaps
  left join videos on musiccaps.ytid = videos.id;