musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "echoing male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- easygoing · 2 ✖
- echoing male vocal · 2 ✖
- country pop 1
- emotional 1
- euphoric 1
- offbeat acoustic rhythm guitar 1
- offbeat sot piano chords 1
- passionate 1
- punchy "4 on the floor" kick pattern 1
- relaxing 1
- smooth 1
- smooth bass 1
- smooth double bass 1
- swing 1
- warm 1
- wide sustained string melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Sad music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robbie Williams ft. Rufus Wainwright | Swing Both Ways (Official Audio) | The Swing song features an echoing male vocal singing over smooth double bass, offbeat soft piano chords and widely spread sustained strings melody. It sounds easygoing, relaxing, smooth, warm and euphoric as it reminds of Christmas. | 2013-11-18T09:21:38Z | Robbie Williams | Connect with Robbie Williams: Website – https://RobbieWilliams.com Newsletter – https://RobbieWilliams.lnk.to/signupID Official Robbie Williams App – https://RobbieWilliams.lnk.to/appID Apple Music – https://RobbieWilliams.lnk.to/AppleMusicID Spotify – https://RobbieWilliams.lnk.to/SpotifyID Facebook – https://www.facebook.com/robbiewilliams Instagram – https://www.instagram.com/robbiewilliams Twitter – https://twitter.com/robbiewilliams | ["Swing music", "Music"] | ["swing", "smooth double bass", "offbeat sot piano chords", "wide sustained string melody", "echoing male vocal", "easygoing", "relaxing", "smooth", "euphoric", "warm"] | 4 | L1s7KZgWXGc | 2145 | |
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;