musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate male vocal" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- low quality · 2 ✖
- passionate 2
- passionate male vocal · 2 ✖
- acoustic rhythm guitar melody 1
- electric guitar chords 1
- emotional 1
- funky 1
- funky strummed electric guitar chord progression 1
- groovy 1
- groovy bass 1
- harmonizing background vocals 1
- harmonizing vocals melody 1
- indie 1
- shimmering hi hats 1
- snappy rimshot 1
- soulful 1
- tinny snare 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
A Love I Can Feel Riddim (26 songs) - Beres, Sanchez, Frankie Paul, Busy Signal, etc. | The low quality recording features a passionate male vocal, alongside harmonizing background vocals, singing over tinny snares, snappy rimshots, shimmering hi hats, groovy bass and electric guitar chords. It sounds groovy and passionate. | 2012-05-24T15:52:14Z | DJ Riddim | Timeless lover's rock riddim Facebook – https://www.facebook.com/DJRiddimNYC?ref=hl Instagram - http://instagram.com/djriddim_ Twitter – https://twitter.com/DJRiddim_ | ["Music of Asia", "Funk", "Music", "Pop music", "Ska"] | ["low quality", "passionate male vocal", "harmonizing background vocals", "tinny snare", "shimmering hi hats", "snappy rimshot", "groovy bass", "electric guitar chords", "groovy", "passionate"] | 4 | c-85TtcfVSI | 3672 |
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;