musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "ballad" and musiccaps_author = 3 sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- ballad · 4 ✖
- acoustic guitar arpeggio 2
- gentle male vocal 2
- mellow 2
- arabic inspired 1
- bansuri 1
- bongo drums 1
- electric bass guitar bassline 1
- electric guitar arpeggio 1
- electric guitar strumming 1
- emotional 1
- ethereal female vocal 1
- grungy electric guitar strumming 1
- live performance 1
- minor key 1
- open-mouthed humming 1
- overdrive 1
- percussive chime 1
- piano 1
- pop ballad 1
- relaxing 1
- reverb 1
- rock music 1
- rock power ballad 1
- romantic 1
- soft rock ballad 1
- soothing indian male vocal 1
- south asian ballad 1
- traditional middle eastern music 1
- vocables 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shikra Yaar - Shiv Kumar Batalvi | This feels like a romantic ballad. The bansuri plays a soothing melody and the male vocalist comes in with a beautiful and gentle voice. This is an Indian song and it is emotional and brings about stillness. The acoustic guitar plays arpeggios. | 2007-11-14T12:24:03Z | sekhon0210 | very nice song......hope u people enjoy dis :) | ["Music", "Middle Eastern music"] | ["bansuri", "soothing indian male vocal", "gentle male vocal", "acoustic guitar arpeggio", "romantic", "emotional", "ballad", "south asian ballad"] | 3 | cQWJeYfyw8Y | 3704 | |
Rasulullah - The Malay Chanting Group | This is a live performance of what sounds like a Middle Eastern. The female singer has a calm and soothing voice which she uses to sing vocables - or open mouthed humming. There are percussive chimes, and an acoustic guitar arpeggio which adds to the calm and soothing feel of the song. | 2014-09-11T13:42:13Z | Che Mat Merah Muda | sejuk nya qalbu... by Iman Farrar | ["Singing", "Chant", "Music", "Vocal music"] | ["live performance", "traditional middle eastern music", "open-mouthed humming", "vocables", "arabic inspired", "ethereal female vocal", "reverb", "ballad", "mellow", "percussive chime", "acoustic guitar arpeggio"] | 3 | AobHGHJSd-s | 1172 | |
C minor rock power ballad guitar backing track | Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. | 2012-05-13T21:33:38Z | Iain MacLeod | Hey guys! Sorry I haven't uploaded any tracks in a while. I made this one today and I hope you enjoy playing over it as much as I did :) Thanks for all the amazing support so far! Happy shreddin'! | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] | 3 | 4M0njWKFsME | 560 | |
On Your Wedding Day (A Stepdad's Song) | The song features a calm, gentle male vocalist. It feels like a soft pop ballad, with a slight rock influence. There's an electric guitar arpeggio, bongo drums, and a prominent bassline. The song feels like it would be suitable as a loving dedication to someone. | 2013-08-11T02:29:43Z | Joe M | ©Copyright 2012 Joe Manzella All Rights Reserved This song is for Melissa: Happy First Anniversary, Sweetie! - Love Joe On Your Wedding Day (A Stepdad's Song) It wasn't really long ago that you were just a girl. I came into your life by chance and slowly shared your world. Through good times and some bad, still always proud to be your stepdad. And now here on your wedding day, as you dance by my side, I'm so thrilled 'cause I get to be stepfather of the bride. So as I hold your hand, this love for you is from your stepdad. (Bridge) Just call on me anytime, it's no bother Always know you'll be my daughter and I'll be there. Wherever this life shall choose to lead us there's a bond always between us,a tie we share and I'll always care. And so here on your wedding day I'm truly blessed to be your stepdad. | ["Music", "Wedding music"] | ["soft rock ballad", "ballad", "pop ballad", "electric bass guitar bassline", "gentle male vocal", "electric guitar arpeggio", "bongo drums", "relaxing", "mellow"] | 3 | OR_YbeqV5tA | 2439 |
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;