musiccaps_details (view)

2 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "pop", musiccaps_aspects contains "soft kick hits" and musiccaps_names contains "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
Pharrell Williams - Happy (WE ARE FROM HONG KONG) Dance edition The Pop song features a passionate male vocal, alongside wide harmonizing background vocals, singing over clapping, shimmering cymbals, groovy bass and soft kick hits. It sounds addictive, happy and joyful. 2014-01-28T21:37:50Z di2dadance 今次誠邀多位跳舞前輩及好友拍攝HAPPY 希望鼓勵新一代的舞蹈員 以開心和享樂的態度跳舞 堅持不放棄！ 由於我的時間有限，未能邀請所有的朋友參與拍攝， 非常感謝幫忙拍攝的 ﹣Allen To ﹣Kinko Koo ﹣Lok Man ﹣Leung ﹣Sunny Wong ﹣Vivian ﹣Bo Sir ﹣小燕 ﹣Bowie ﹣Popping Douglee ﹣Kato ﹣榮 ﹣Maska ﹣Timothy ﹣Louis ﹣Popper 88 ﹣Virago Carmen ﹣Wh Chung ﹣Popping Lok ﹣Chu Tin ﹣Shing ﹣Danie ﹣佳 三月我會繼續拍攝繼續享受跳舞的樂趣 PLS SUPPORT～～ ["Music", "Soul music"] ["pop", "passionate male vocal", "wide harmonizing background vocals", "clapping", "shimmering cymbals", "groovy bass", "soft kick hits", "addictive", "happy", "joyful"] 4 L2-EGNKzUAQ 2146
TOKIO - ding-dong KARAOKE The Pop song features harmonizing vocals singing over energetic crash cymbals, groovy bass guitar, wide electric guitar melody, punchy snare and soft kick hits. There is a short drum break at the very beginning of the loop. It sounds happy, nostalgic and euphoric, as it gives off vibes of a Christmas song. 2015-12-24T09:53:22Z Sandra B Merry Christmas! My Christmas gift to the TOKIO-fan community is here. Thank you so much for being so welcoming even if I'm a bit late to the party. I am so glad I was able to finish this on time and I hope you like it. For those who don't know this was the first pv Mabo directed (and I really wish he still was because they are absolutely adorable). Music by: TOKIO Song: ding-dong Edited by: Sandra Bergholm Lyrics credit: JpopAsia (http://www.jpopasia.com/lyrics/15166/tokio/ding-dong.html) Program: Vegas Pro 12.0 Please note that I make no claim to the music or video footage. I only claim to be responsible for the editing and I do not or will ever make money off this video. ["Music", "Independent music"] ["harmonized vocals", "pop", "energetic crash cymbals", "short drum break", "groovy bass guitar", "wide electric guitars melody", "punchy snare", "soft kick hits", "happy", "nostalgic", "euphoric", "christmas song"] 4 _3OlK_1yQOk 3440

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;