musiccaps_details (view)
2 rows where musiccaps_aspects contains "joyful", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "soft kick hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass 2
- joyful · 2 ✖
- passionate male vocal · 2 ✖
- soft kick hits · 2 ✖
- addictive 1
- clapping 1
- electric guitar melody 1
- emotional 1
- happy 1
- harmonizing male vocals 1
- hopeful 1
- live performance 1
- low quality 1
- mono 1
- noisy 1
- playback instrumental 1
- pop 1
- punchy snare 1
- shimmering cymbals 1
- shimmering tambourine 1
- soul 1
- soulful 1
- toms roll 1
- wide harmonizing background vocals 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00003 1
- Soul music 1
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 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;