musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- digital drums · 2 ✖
- energetic · 2 ✖
- medium tempo · 2 ✖
- arpeggios 1
- buoyant 1
- catchy 1
- charming 1
- drum machine 1
- dubstep 1
- enthusiastic 1
- french love song 1
- french pop 1
- french urbano 1
- male singer 1
- punchy 1
- r&b 1
- simple 1
- synth bass sound 1
- synthesiser arrangements 1
- tambourine beats 1
- urban pop 1
- voice sample 1
- youthful 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
David ramen - Amour en or | A male vocalist sings this spirited French Pop song. The tempo is medium with electronic music, synth arrangements and slick digital drumming. The song is youthful, peppy, buoyant, perky, catchy, romantic, simple and charming. This song is a contemporary French Urbano. | 2009-03-14T07:26:23Z | Rodrigue Chakode | Crédit montage: Thekknicolas ;) | ["Music of Africa", "Music"] | ["male singer", "medium tempo", "french pop", "french love song", "french pop", "urban pop", "r&b", "french urbano", "synthesiser arrangements", "digital drums", "tambourine beats", "drum machine", "catchy", "buoyant", "punchy", "energetic", "enthusiastic", "youthful", "catchy", "charming", "simple"] | 7 | CPX6f-Awx-0 | 1361 | |
Vinyl Scratch - Think Again Loosa | This song contains digital, dubstep drums with a straight hi hat playing 8th notes. An aggressive bass sound full of modulation and other samples is playing a melody with a lot of pitch shifts and stutter effects. A voice sample is being used with a lot of reverb and delay as an atmospheric element. Some sounds are being arpeggiated playing a fast melody before leaving the scenario again. This song may be playing in an extreme sports advertisement. | 2012-12-27T23:30:08Z | YourDailyMusicz | ✖ Connect with the Artist YouTube: http://www.youtube.com/user/VinylScratchDjPony Facebook: http://www.facebook.com/VinylScratchOfficial Twitter: https://twitter.com/vinyl_scratchdj ✖ Connect with YDL Network Apply for Partnership & Directorship [No View Minimum] [Music only]: http://bit.ly/OYUZWp Apply for standard Partnership: http://www.yourdailylaughz.tv/apply * Notice: YDM Channel is Not a 'non-copyright' channel. Uploading such materiel from YDM or the Artist themselves will result in infringement upon the third party. --- | ["Scratching (performance technique)", "Drum and bass", "Music"] | ["dubstep", "digital drums", "synth bass sound", "voice sample", "arpeggios", "medium tempo", "energetic"] | 6 | dsf3agfkJDY | 3823 |
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;