musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro" and musiccaps_aspects contains "filtered echoing male vocal" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electro · 2 ✖
- exciting 2
- filtered echoing male vocal · 2 ✖
- addictive synth lead melody 1
- emotional 1
- filtered synth bass 1
- fun 1
- happy 1
- kick impact 1
- male chants 1
- pulsating synth bass 1
- punchy kick 1
- repetitive high pitched vocal 1
- reverberant reversed piano melody 1
- riser 1
- shimmering hi hat 1
- white noise riser 1
musiccaps_names (array) 4 ✖
- Electronic music 1
- Music 1
- Singing bowl 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
EvenS - News [Free Download] | The Electro song features a reverberant reversed piano melody and synth bass with a modulated filter effect on it, over which there is a white noise riser that leads into the short snippet of drop that consists of layered punchy kick and shimmering hi hat. Right before the drop, there is a filtered, echoing male vocal too. It sounds emotional and exciting. | 2012-03-04T16:00:07Z | 17tumba | Some fresh talent from Norway :) Utterly beautiful stuff... EvenS - News [Free Download] Follow EvenS here: http://www.facebook.com/pages/EvenS/107088966080022?ref=ts http://soundcloud.com/evens (Download) http://www.youtube.com/user/EvenSofficial The visualizer/equalizer is made by Mocarg: http://www.youtube.com/user/mocarg Stalk me: Facebook http://www.facebook.com/17tumbaMusic Twitter: https://twitter.com/#!/17tumba YouTube http://www.youtube.com/user/17tumba Soundcloud http://soundcloud.com/17tumbaFollow me on facebook: http://full.sc/1djiYtN Follow 17tumba on Goole+ https://www.google.com/+17tumbaOfficial Follow Elevate Sounds: https://www.facebook.com/17tumba https://soundcloud.com/17tumba https://plus.google.com/+17tumbaOfficial Second/backup channel: https://www.youtube.com/user/17tumbaMusic ▼All Elevate Sounds uploads in playlists▼ Latest (Uploads 600-800) https://www.youtube.com/playlist?list=PL8TWxe78E9Wvic0-RjHRzwEcaQXuaGJQn Uploads 400-600: https://www.youtube.com/playlist?list=PL71FE81BCCA633E53 Uploads 200-400: https://www.youtube.com/playlist?list=PLDF43E25745757558 Uploads 1-200: https://www.youtube.com/playlist?list=PL60038DE2D1B1A21C | ["Singing bowl"] | ["reverberant reversed piano melody", "filtered synth bass", "white noise riser", "filtered echoing male vocal", "exciting", "punchy kick", "shimmering hi hat", "emotional", "electro"] | 4 | UkqayNnk00w | 2941 | |
Dj Raaban - Drop The Bass | The electro song features a filtered echoing male vocal speaking over layered riser and kick impact, after which there is a repetitive high pitched vocal, male chants, pulsating synth bass and addictive synth lead melody. It sounds exciting, happy and fun - like something you were listening to when you were younger. | 2007-11-08T04:02:55Z | Looped- | Dj Raaban - Drop the Bass {{{{{{{ Contains Flashing }}}}}}} No more Annotations everyone so enjoy!! | ["Electronic music", "Music", "Techno"] | ["filtered echoing male vocal", "addictive synth lead melody", "exciting", "fun", "happy", "riser", "repetitive high pitched vocal", "male chants", "pulsating synth bass", "kick impact", "electro"] | 4 | B1vY7kxQ9Xg | 1195 |
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;