musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar accompaniment", musiccaps_aspects contains "synth arrangement", musiccaps_author = 7 and musiccaps_names contains "Grunge"

✎ 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
Lie To Me opening theme - Music - Ryan Star - Brand New Day A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. 2009-04-17T03:37:09Z Ricardo Miranda Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT ["Music", "Grunge"] ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] 7 l9vYSBR9nio 4377

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;