musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "youthful" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 86 ✖
- foreign language · 5 ✖
- youthful · 5 ✖
- energetic 4
- male singer 3
- medium tempo 3
- buoyant 2
- enthusiastic 2
- groovy bass line 2
- happy 2
- steady drumming 2
- teen pop 2
- acoustic guitar 1
- acoustic guitar lead 1
- animated 1
- animated percussions 1
- boomy bass drops 1
- boy band 1
- bright violin 1
- celebration 1
- cheerful 1
- concert 1
- congas 1
- crowd cheering 1
- crowd screaming 1
- cymbals 1
- dance groove 1
- dance music 1
- digital drums 1
- disco rap 1
- drum stick clicks 1
- duet 1
- electric guitar harmony 1
- electric guitar lead 1
- electro pop 1
- electronic sounds 1
- emphatic vocals 1
- engaging 1
- enthusiastic drumming 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- fast tempo 1
- female singer 1
- folk music 1
- folk pop 1
- folk song 1
- fresh 1
- funky bass lines 1
- groovy 1
- guitar accompaniment 1
- hip-hop 1
- hit song 1
- k-pop 1
- keyboard harmony 1
- live audience 1
- live performance 1
- lively mandolin 1
- lively piano 1
- male vocalist 1
- medium fast tempo 1
- mellow vocals 1
- melodious 1
- merry 1
- peppy 1
- perky 1
- pleasant melody 1
- pop 1
- pop hits 1
- pop rap 1
- pop song 1
- popularity 1
- punchy 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- punchy music 1
- rap 1
- regional pop 1
- rhythmic patter 1
- simple 1
- spirited 1
- synthesiser arrangements 1
- vibrant 1
- vibrant vivacious 1
- vivacious 1
- vocal harmony 1
- world music 1
musiccaps_names (array) 13 ✖
- Music 5
- Jingle (music) 2
- Rapping 2
- Rhythm and blues 2
- Afrobeat 1
- Funk 1
- Happy music 1
- Hip hop music 1
- Independent music 1
- Music of Africa 1
- Music of Asia 1
- Pop music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
Happy Music 今こそハッピーな歌を! by misc | A female vocalist sings this chirpy song. The tempo is medium with a melodic electric guitar harmony, acoustic guitar lead, sprightly drumming, funky bass lines and peppy backup. The song is youthful, perky, cheerful, vivacious ,bubbly and in a foreign language.This song is teen pop/ Pop. | 2011-03-18T23:09:55Z | happymusicX | 悩みなんか 弾け飛んで 忘れちゃって 流しちゃって 太陽が笑うよ happy music 僕らはみんな宇宙のフレンズ 何が起きても独りじゃない 笑顔の数だけのハッピー 集めたらまわり出す ほら聴こえて繰るよ happy music (歌詞の一部より) 歌タイトル:太陽と猫と私 Vocal & Violin: misc (ミスク) Music arrangement: iNA (ex hide with spread beaver) 想像を超えた大災害に心が震えるけど、そんなときこそ、口ずさみたい歌に出会ったのでアップロードしたよ。これ聞きながら、駅まで歩いたら明るい気分になれたから。 | ["Jingle (music)", "Music", "Rhythm and blues", "Happy music"] | ["female singer", "medium tempo", "foreign language", "electric guitar harmony", "funky bass lines", "acoustic guitar lead", "enthusiastic drumming", "vocal harmony", "youthful", "pleasant melody", "simple", "fresh", "happy", "perky", "cheerful", "vivacious", "buoyant", "peppy", "pop song", "teen pop"] | 7 | gBuLpP4klvI | 4012 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Busy Signal - How Dem A Talk [Clean Version] | A male vocalist sings this peppy rap. The tempo is medium fast with an enthusiastic and catchy guitar rhythm, drum stick clicks, congas, steady drumming and keyboard accompaniment. The song is simple, punchy; buoyant, youthful, animated, vibrant and has a catchy dance groove. This song is contemporary Hip-Hop/Rap. | 2015-08-20T01:50:47Z | BusySignalRealVEVO | Music video by Busy Signal performing "How Dem A Talk" (Official Visual). ©: Turf Music Entertainment /Stainless Music http://vevo.ly/nWNEGT | ["Afrobeat", "Music of Africa", "Music", "Rapping", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "spirited", "vibrant", "buoyant", "foreign language", "punchy guitar rhythm", "drum stick clicks", "disco rap", "punchy", "guitar accompaniment", "steady drumming", "congas", "keyboard harmony", "energetic", "rap", "hip-hop", "pop rap", "youthful", "spirited", "animated", "dance groove", "vibrant", "punchy guitar rhythms drum stick clicks", "rhythmic patter"] | 7 | NWL-P08eM-U | 2342 | |
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
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;