musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "soulful" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- low quality · 3 ✖
- passionate 3
- soulful · 3 ✖
- funky 2
- passionate male vocal 2
- acoustic guitar chords 1
- acoustic rhythm guitar melody 1
- breathy flute melody 1
- choir 1
- electric guitar melody 1
- emotional 1
- energetic 1
- energetic drums 1
- funky bass guitar 1
- funky strummed electric guitar chord progression 1
- harmonizing vocals melody 1
- indie 1
- keys chords 1
- live performance 1
- mono 1
- noisy 1
- passionate female vocal 1
- rock 1
- solo brass melody 1
- traditional 1
- wooden percussions 1
musiccaps_names (array) 9 ✖
- Singing · 3 ✖
- Music 2
- Carnatic music 1
- Music of Asia 1
- Rock and roll 1
- Rock music 1
- Ska 1
- Song 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Forida Parvin - Ekta Bod Haoya | The low quality recording features a traditional song that consists of a passionate female vocal singing over breathy flute melody, wooden percussion, keys chords and acoustic guitar chords. It sounds soulful, passionate and the recording is in mono and noisy. | 2009-12-30T16:18:08Z | ChoncholaMon | Forida Parvin - Ekta Bod Haoya | ["Singing", "Carnatic music", "Music of Asia", "Music"] | ["low quality", "noisy", "mono", "breathy flute melody", "passionate female vocal", "wooden percussions", "acoustic guitar chords", "keys chords", "soulful", "traditional", "passionate"] | 4 | 6807299U5eg | 727 | |
patrice ft keziah jones - here again | The low quality recording features an indie song that consists of harmonizing vocals melody, alongside passionate vocals over acoustic rhythm guitar melody in the left channel and funky strummed electric guitar chord progression in the right channel of the stereo image. It sounds passionate, soulful, funky and emotional. | 2008-09-28T11:26:38Z | Bruno Gonzaga | LYRICS: I'm here again I'm here again singing for a brighter day Understand I understand how we ever went away (Keziah) Dreams and things yeah chains and rings yeah silver and gold from our souls The world's gotta know (x6) (Patrice) true warrior here again I feel so sorry for the ye and then and you feed your souls with it sounds like those yeah we'll be forcing I don't mean again (Keziah) everday you gotta change our ways love has it's way so don't loose your way make sure there is something left for those on the way for a brighter day those on the way, a brighter day (Chorus again) The world's gotta know (x6) And everything she says just rise my love The curve she loves you line I mean, when you say what you say when you say whay you say it happens all the time this is treat-off paradise mean the love between the girls and boys the love between me and my friends permently won't end so real I cant pretend (Keziak) everday you gotta change your ways love has it's way so don't loose your way make sure there is something left for for a brighter day those on the way, a brighter day Brighter day, brighter day.. Oh oh oh oh uh uh uh | ["Singing", "Ska"] | ["low quality", "indie", "funky strummed electric guitar chord progression", "harmonizing vocals melody", "passionate male vocal", "acoustic rhythm guitar melody", "passionate", "soulful", "funky", "emotional"] | 4 | T0uoYE12cnI | 2805 | |
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | 2010-12-07T18:15:11Z | Rock & Roll Hall of Fame | Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | 4 | VfARCp38XtA | 3018 |
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;