musiccaps_details (view)
1 row where musiccaps_aspects contains "echoing male vocal", musiccaps_aspects contains "offbeat acoustic rhythm guitar", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 |
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;