musiccaps_details (view)
2 rows where musiccaps_aspects contains "chimes", musiccaps_aspects contains "pop" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- chimes · 2 ✖
- pop · 2 ✖
- ambient 1
- atmospheric synthesiser 1
- bells 1
- boomy drumming 1
- boy band 1
- catchy 1
- child’s toy 1
- dulcet 1
- electronic drone sound 1
- electronic sound 1
- emotional 1
- foreign language 1
- fun 1
- innovative 1
- instrumental 1
- interesting music 1
- k-pop 1
- k-pop hips 1
- keyboard accompaniment 1
- korean song 1
- love song 1
- male vocalist 1
- medium tempo 1
- melodic 1
- pleasant 1
- punchy bass lines 1
- recorder harmony 1
- romantic 1
- romantic piano 1
- sentimental 1
- simple 1
- soft pop 1
- soft rock 1
- soft soothing 1
- steady drumming 1
- straightforward bass lines 1
- tambourine beats 1
- unique 1
- vocal backup 1
- wind instrument 1
- wood wind 1
- world music 1
- xylophone 1
- young love 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Maraca 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 | |
DMK: "Strangelove" | This music clip is an instrumental. The tempo is medium with a simple and interesting melody with a recorder harmony, steady drumming, groovy bass lines,keyboard accompaniment ,xylophone rhythm, a constant electronic sound like that of a child’s toy gun or car , tambourine beats and chimes and bells. The music is mellow, unique, fun, simple and catchy. This music is Soft Rock/Pop. | 2011-07-08T14:49:36Z | Dicken Schrader | DMK are a Depeche Mode cover band from Bogotá, Colombia. Visit our band page http://www.facebook.com/DMKband -------------------- Dicken Schrader: Keyboard, xylophone, tambourine, soda bottle, baby rattle, little bucket, chocolate mix can and voice. Milah Schrader: Recorder, little bucket, chocolate mix can and voice. Korben Schrader: Maraca, egg maraca, toy racetrack and voice. Music and lyrics by Martin L. Gore (Depeche Mode) There'll be times when my crimes will seem almost unforgivable. I give in to sin because you have to make this life livable. But when you think I've had enough from your sea of love I'll take more than another riverful, and I'll make it all worthwhile, I'll make your heart smile. Strangelove Strange highs and strange lows. Strangelove That's how my love goes. Strangelove Will you give it to me? Will you take the pain I will give to you again and again and will you return it? There'll be days when I'll stray I may appear to be constantly out of reach. I give in to sin because I like to practice what I preach. I'm not trying to say I'll have it all my way, I'm always willing to learn when you've got something to teach, and I'll make it all worthwhile, I'll make your heart smile. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I'll say it again - pain. Pain - will you return it? I won't say it again. -------------------- Dicken Schrader: Teclado, xilófono, pandereta, botella de gaseosa, sonajero, baldecito, tarro de chocolate y voz. Milah Schrader: Flauta dulce, baldecito, tarro de chocolate y voz. Korben Schrader: Maraca, maraca de huevito, pista de carritos y voz. Música y letra de Martin L. Gore (Depeche Mode) Habrán momentos en los que mis crímenes parecerán casi imperdonables. Yo me rindo a pecar porque tienes que hacer esta vida vivible. Pero cuando creas que he tenido suficiente de tu mar de amor tomaré más de otro río entero, y haré que todo valga la pena, haré sonreír tu corazón. Amorextraño Ex… | ["Music", "Maraca"] | ["instrumental", "boomy drumming", "pop", "soft rock", "wind instrument", "fun", "simple", "catchy", "innovative", "interesting music", "unique", "wood wind", "punchy bass lines", "electronic drone sound", "tambourine beats", "bells", "child’s toy", "recorder harmony", "keyboard accompaniment", "chimes", "xylophone", "electronic sound"] | 7 | Yk2ZrS0ZS6g | 3308 |
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;