musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- easygoing · 2 ✖
- emotional · 2 ✖
- passionate · 2 ✖
- "4 on the floor" kick pattern 1
- alternative/indie 1
- country pop 1
- echoing male vocal 1
- groovy bass guitar 1
- low quality 1
- mellow 1
- offbeat acoustic rhythm guitar 1
- passionate male vocal 1
- punchy "4 on the floor" kick pattern 1
- shimmering cymbals 1
- smooth bass 1
- wide electric guitars melodies 1
musiccaps_names (array) 3 ✖
- Music 2
- Independent music 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kenn Colt - Feels Like A River (feat. Michael McCrae) [Official Music Video] | The Country Pop song features an echoing male vocal singing over offbeat acoustic rhythm guitar, punchy "4 on the floor" kick pattern and smooth bass. It sounds emotional, easygoing and passionate. | 2016-02-21T11:13:56Z | Kenn Colt | Click here to subscribe ► http://bit.ly/2stA3he Check out the official video for the debut single 'Feels Like A River (feat. Michael McCrae) from Kenn Colt on Warner Music Benelux. Stream or download here ► https://lnk.to/feelslikeariver Follow Kenn Colt on social media: https://www.facebook.com/KennColt https://twitter.com/kenncolt https://www.instagram.com/kenncolt http://kenncolt.com/spotify http://kenncolt.com/snapchat BOOKINGS WORLDWIDE: michael.harvey-bray@codaagency.com suzie.melki@codaagency.com Subscribe to Kenn Colt’s YouTube channel for the latest videos: https://www.youtube.com/user/KennColt Directors: Jesse Vulink & Erik van der Zwan Editor: Jesse Vulink Production company: Soulvizion Actors: Kenn Colt, Marrit Nicolai Music video by Kenn Colt performing Feels Like A River feat. Michael McCrae. (C) 2016 Knockout Artists, under exclusive license to Warner Music Benelux a Warner Music Group Company. | ["Music", "Sad music"] | ["country pop", "offbeat acoustic rhythm guitar", "punchy \"4 on the floor\" kick pattern", "smooth bass", "echoing male vocal", "emotional", "passionate", "easygoing"] | 4 | RlcIJsgtU58 | 2721 | |
Babyshambles - Gang of Gin | The low quality recording features an alternative/indie song that consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melodies, shimmering cymbals and "4 on the floor" kick pattern. It sounds mellow, easygoing, emotional and passionate. | 2009-01-25T10:38:31Z | ninsajala | Babyshambles Gang of Gin Lyrics: I get around to singing about That gang of gin I'm in Then you'll know most certainly The kind of game I'm in You sound around to swinging about The gang of gin I'm rolling in, oh Then you'll know The kind of state I'm in Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Oh in a nutshell Yeah in a nutshell, oh In a nutshell In a nutshell I get around to singing about That gang of gin I'm in Then you'll know The kind of game I'm in She was getting pally with a scally in the alley Giving head for gear She calls a spade a spade Got slit from ear to ear Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Well I showed no decorum Span my heart out on the forum Looked like a snapshot Of the most tragic day I'll tell you my story The treachery it bores me Carl and McGee both promised me It would not happen this way Carl is kept sedated The frontman elevated And McGee doing all he can to ruin my band And keep me out the way In this industry of fools Musclemen and ghouls If you're not a puppet or a muppet Then you might as well call it a day-ayay The truth here gets distorted The wall scrapings get snorted I'm welcome back if I give up crack But you gave me my first pipe anyway Can't show no decorum Posts left on the forum Was like a snapshot Of the most tragic day | ["Music", "Independent music"] | ["low quality", "alternative/indie", "passionate male vocal", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "\"4 on the floor\" kick pattern", "mellow", "easygoing", "emotional", "passionate"] | 4 | XI-tRuDZ6HA | 3172 |
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;