musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 4 ✖
- keyboard accompaniment · 4 ✖
- medium tempo · 4 ✖
- male singer 3
- passionate 3
- percussive bass line 3
- romantic 3
- backup singers 2
- emotional 2
- love song 2
- retro pop hits 2
- steady drumming rhythm 2
- vocal harmony 2
- bad audio quality 1
- cheerful 1
- classic rock band 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- cymbals crashing 1
- electric rhythm guitar plays 1
- enthusiastic 1
- ethnic percussions 1
- exciting 1
- female singer 1
- fun 1
- groovy music 1
- guitar leads 1
- guitar rhythm 1
- …
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
豬之歌 - 香香 | A female singer sings this lovely melody with a choral harmony support. The song is medium tempo with a Steady drumming rhythm, various percussion, percussive bass line, keyboard accompaniment and guitar rhythm. The song slows down at the end. The song is emotional and exciting. | 2011-11-26T13:35:07Z | TigerleoAB | 豬之歌 詞/曲:毛慧 豬 你的鼻子有兩個孔 感冒時的你 還掛著鼻涕牛牛 豬 你有著黑漆漆的眼 望呀望呀望 也看不到邊 豬 你的耳朵是那麼大 呼扇呼扇 也聽不到我在罵你傻 豬 你的尾巴是卷又捲 原來跑跑跳跳 還離不開它 哦~~~ 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙從不打架 豬 你的肚子是那麼鼓 一看就知道 受不了生活的苦 豬 你的皮膚是那麼白 上輩子一定投在 那富貴人家 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙 從不打架 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 你很像他 咳咳嗯 | ["Music", "Happy music"] | ["female singer", "backup singers", "pop music", "percussive bass line", "song ending", "medium tempo", "keyboard accompaniment", "fun", "cheerful", "positive", "emotional", "romantic", "vocal harmony", "steady drumming rhythm", "percussive bas slime", "keyboard harmony", "ethnic percussions", "exciting", "energetic", "vocal harmony", "pop hits", "retro pop hits", "video soundtrack", "various percussion hits"] | 1 | Ur8O3h8S0K4 | 2947 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;