musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro" and musiccaps_aspects contains "filtered synth bass" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- electro · 2 ✖
- filtered synth bass · 2 ✖
- emotional 1
- exciting 1
- filtered echoing male vocal 1
- low quality 1
- poor mix 1
- punchy kick 1
- reverberant "4 on the floor" kick hits 1
- reverberant reversed piano melody 1
- shimmering hi hat 1
- short riser 1
- suspenseful synth stab 1
- thin 1
- white noise riser 1
musiccaps_names (array) 7 ✖
- Dance music 1
- Dubstep 1
- Electronic dance music 1
- Music 1
- Rumble 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 |
---|---|---|---|---|---|---|---|---|---|---|
gensan tuna fest sound system rumble | The low quality recording features an electro song that consists of a reverberant "4 on the floor" kick pattern, followed by suspenseful synth stabs. At the very end of the loop there is a short riser, after which comes the snippet of a filtered synth bass. It sounds thin, as it was poorly mixed. | 2009-09-16T08:22:06Z | ostjay26 | ["Music", "Techno", "Rumble", "Dubstep", "Electronic dance music", "Dance music"] | ["low quality", "reverberant \"4 on the floor\" kick hits", "suspenseful synth stab", "filtered synth bass", "short riser", "electro", "thin", "poor mix"] | 4 | H6rZwBc6aNM | 1776 | ||
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 |
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;