musiccaps_details (view)

1 row where musiccaps_aspects contains "electric guitar lead", musiccaps_aspects contains "electro pop", musiccaps_aspects contains "energetic" and musiccaps_author = 7

✎ 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
Big Mac Chant挑战 – FS Fuying & Sam 流行曲风 This song is a vocal duet of male singers in a foreign language . The tempo is medium fast with an animated electric guitar melody, boomy bass drops, digital drums and synthesiser arrangements. The music is buoyant, youthful,punchy, groovy and emphatic with mellow vocals. This song is contemporary Pop. 2016-10-13T01:58:19Z McDonaldsMalaysia 快来学唱FS Fuying&Sam版本的Big Mac Chant挑战歌曲，之后到Smule与他们合唱，再将影片上传到Facebook或Instagram，最后到www.mcdonalds.com.my/mybigmacchant报名参加，就有机会赢取高达RM10,000现金奖，以及与他们见面的机会！马上行动！ ["Music", "Vocal music"] ["male vocalist", "duet", "medium fast tempo", "foreign language", "electric guitar lead", "boomy bass drops", "synthesiser arrangements", "cymbals", "electronic sounds", "digital drums", "youthful", "energetic", "enthusiastic", "groovy", "punchy music", "mellow vocals", "electro pop"] 7 XaqVAF-ADWU 3201

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;