musiccaps_details (view)
2 rows where musiccaps_aspects contains "filtered echoing male vocal" and musiccaps_aspects contains "punchy kick" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- filtered echoing male vocal · 2 ✖
- punchy kick · 2 ✖
- addictive 1
- doubling background male vocal 1
- echoing pitch bend riser 1
- electro 1
- emotional 1
- energetic 1
- energetic crash cymbal 1
- exciting 1
- filtered synth bass 1
- flat male vocal 1
- groovy bass 1
- low quality 1
- punchy snare 1
- reggae 1
- reverberant reversed piano melody 1
- shimmering hi hat 1
- synth keys chords 1
- tinny wooden percussions 1
- upbeat 1
- white noise riser 1
musiccaps_names (array) 3 ✖
- Music 1
- Reggae 1
- Singing bowl 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 | |
Vandal - Mr Politician (Kaotik 02) | The low quality recording features a reggae song that consists of flat male vocals, alongside filtered, echoing male vocal and doubling background vocals, singing over punchy kick and snare hits, energetic crash cymbals, tinny wooden percussions, groovy bass and synth keys chords. It sounds energetic, as it is upbeat and addictive, thanks to the cadence. | 2011-05-10T11:54:19Z | Vandal Kaotik UK | New track by VANDAL, part of the mighty Kaotik Soundsystem. Ragga Hardtek Available on vinyl on Kaotik 02 in June | ["Music", "Reggae"] | ["low quality", "reggae", "upbeat", "synth keys chords", "punchy snare", "punchy kick", "tinny wooden percussions", "filtered echoing male vocal", "flat male vocal", "doubling background male vocal", "groovy bass", "energetic crash cymbal", "echoing pitch bend riser", "energetic", "addictive"] | 4 | r5xTmK2Fq1w | 4850 |
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;