musiccaps_details (view)
3 rows where musiccaps_aspects contains "filtered synth bass" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- filtered synth bass · 3 ✖
- electro 2
- exciting 2
- low quality 2
- emotional 1
- filtered echoing male vocal 1
- poor mix 1
- pop 1
- punchy kick 1
- repetitive piano melody 1
- reverberant "4 on the floor" kick hits 1
- reverberant reversed piano melody 1
- shimmering hi hat 1
- short riser 1
- soulful 1
- suspenseful synth 1
- suspenseful synth stab 1
- sustained strings melody 1
- thin 1
- uplifting 1
- white noise riser 1
musiccaps_names (array) 10 ✖
- Dance music 1
- Dubstep 1
- Electric piano 1
- Electronic dance music 1
- Keyboard (musical) 1
- Music 1
- Piano 1
- Rumble 1
- Singing bowl 1
- Techno 1
youtube_published (date) 3 ✖
- 2009-09-16 1
- 2011-07-01 1
- 2012-03-04 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 | |
Jess Mills - Live For What I'd Die For | The low quality recording features a pop song that consists of suspenseful synth, repetitive piano melody, filtered synth bass and sustained strings melody located in the left channel of the stereo image. It sounds uplifting, soulful and exciting. | 2011-07-01T16:20:26Z | JessMillsVEVO | NEW SINGLE PIXELATED PEOPLE OUT FEB 12th FREE DOWNLOAD 'A FOREST' HERE - http://www.jessmills.co.uk/download www.jessmills.co.uk | ["Electric piano", "Keyboard (musical)", "Piano"] | ["pop", "low quality", "suspenseful synth", "repetitive piano melody", "filtered synth bass", "sustained strings melody", "soulful", "uplifting", "exciting"] | 4 | Zbmm_hXcrA0 | 3397 |
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;