musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "country pop" and musiccaps_aspects contains "easygoing" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- country pop · 2 ✖
- easygoing · 2 ✖
- acoustic drums 1
- banjo 1
- bass guitar 1
- echoing male vocal 1
- electric guitar 1
- emotional 1
- female vocal 1
- harmonica 1
- melodic singing 1
- offbeat acoustic rhythm guitar 1
- passionate 1
- punchy "4 on the floor" kick pattern 1
- simple tune 1
- smooth bass 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 | |
SHeDAISY - Don't Worry Bout a Thing - Official Video | This is a country pop music piece. There is a female vocalist singing melodically as the lead. The melody comprises various elements such as the electric guitar, the bass guitar, the harmonica and the banjo. There is a rock acoustic drum beat in the rhythmic background. The atmosphere is easygoing. This piece could be the opening theme of a teenage sit-com. | 2007-10-13T01:18:33Z | shedaisymusic | Music video. | ["Singing", "Banjo", "Music", "Mandolin", "Pop music"] | ["country pop", "female vocal", "melodic singing", "harmonica", "electric guitar", "bass guitar", "acoustic drums", "banjo", "simple tune", "easygoing"] | 9 | A8CJ4YSsUgs | 1071 |
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;