musiccaps_details (view)
4 rows where musiccaps_aspects contains "foreign language", musiccaps_aspects contains "pop" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 68 ✖
- foreign language · 4 ✖
- pop · 4 ✖
- youthful · 4 ✖
- dance music 3
- club music 2
- fast tempo 2
- groovy bass line 2
- male vocalist 2
- world music 2
- acoustic guitar 1
- ambient 1
- animated percussions 1
- atmospheric synthesiser 1
- boy band 1
- bright violin 1
- celebration 1
- chimes 1
- dance groove 1
- dance pop 1
- digital drums 1
- dj 1
- dulcet 1
- electronic flute 1
- emotional 1
- emphatic vocals 1
- energetic 1
- enthusiastic 1
- enthusiastic vocals 1
- excited 1
- female singer 1
- flute 1
- folk music 1
- folk pop 1
- folk song 1
- funky 1
- groovy 1
- happy 1
- high spirited 1
- hip-hop pop 1
- k-pop 1
- k-pop hips 1
- korean song 1
- lively mandolin 1
- lively piano 1
- love song 1
- male singer 1
- medium fast 1
- medium tempo 1
- melodic 1
- merry 1
- pleasant 1
- pop hits 1
- punchy drumming 1
- regional pop 1
- romantic 1
- romantic piano 1
- sentimental 1
- soft pop 1
- soft soothing 1
- spirited 1
- steady drumming 1
- straightforward bass lines 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- upbeat 1
- vivacious 1
- vocal backup 1
- young love 1
musiccaps_names (array) 6 ✖
- Music 4
- Burst, pop 1
- Jingle (music) 1
- Music of Africa 1
- Pop music 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 |
---|---|---|---|---|---|---|---|---|---|---|
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | 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 | |
Pop Folk and Balkan hits,20.flv | A female vocalist sings this enthusiastic pop. The tempo is fast with an energetic and punchy drumming, synthesiser arrangements and flute melody. The song is youthful, enthusiastic, upbeat, vivacious, vibrant with a dance groove. This song is contemporary pop. | 2011-01-12T11:56:48Z | Fredom281 M | ["Music", "Burst, pop"] | ["female singer", "fast tempo", "flute", "electronic flute", "vivacious", "excited", "enthusiastic", "dance music", "club music", "youthful", "upbeat", "enthusiastic", "dj", "punchy drumming", "synthesiser arrangement", "enthusiastic vocals", "foreign language", "pop"] | 7 | 6VJ_auuKzss | 763 | ||
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 |
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;