musiccaps_details (view)
2 rows where musiccaps_aspects contains "clapping", musiccaps_author = 4 and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- clapping · 2 ✖
- addictive 1
- dry flat male vocal 1
- energetic 1
- groovy bass 1
- happy 1
- hip hop 1
- joyful 1
- low quality 1
- passionate male vocal 1
- pop 1
- punchy kick 1
- shimmering cymbals 1
- shimmering open hat 1
- simple hi hats 1
- soft crash cymbal 1
- soft kick hits 1
- stuttering synth chords 1
- unnatural mix 1
- wide arpeggiated synth melody 1
- wide harmonizing background vocals 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music · 2 ✖
- Dance music 1
- Funk 1
- Happy music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fortune Family - Young Hearts (Official Music Video) | The Low Quality Hip Hop song features a dry, flat male vocal rapping over punchy kick layered with shimmering open hats, punchy kick, simple hi hats, claps, syncopated snare hits, wide arpeggiated synth melody and stuttering synth chords. It sounds energetic and kind of unnatural, since the vocal is so detached from the instrumental due to the bad mixing of the song. | 2011-08-08T23:13:33Z | FortuneFam | Fortune Family is back with a new single "Young Hearts," directed by Ryan Do and presented by ThisSongIsSick.com. http://www.facebook.com/FF610 http://www.twitter.com/FortuneFamily Young Hearts samples Rod Stewart's "Young Turks." Download Link http://www.mediafire.com/?xem05efdcddgwqn For management and booking, contact Nick McCarthy at dpreppp@gmail.com | ["Funk", "Music", "Dance music", "Soul music", "Happy music"] | ["low quality", "dry flat male vocal", "punchy kick", "shimmering open hat", "simple hi hats", "soft crash cymbal", "stuttering synth chords", "wide arpeggiated synth melody", "clapping", "hip hop", "unnatural mix", "energetic"] | 4 | 2kcSUBkFbaQ | 404 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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;