musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro", musiccaps_aspects contains "punchy "4 on the floor" kick pattern" and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- electro · 2 ✖
- punchy "4 on the floor" kick pattern · 2 ✖
- energetic 1
- exciting 1
- fade in 1
- groovy synth bass 1
- low quality 1
- repetitive synth lead melody 1
- shimmering hi hats 1
- shimmering open hat 1
- shimmering shakers 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Disco · 2 ✖
- Music 2
- Dance music 1
- Drum and bass 1
- House music 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dele Sosimi & Afrobeat Orchestra - Too Much Information (Laolu Remix (Edit) [Innervisions] | The Electro song features a punchy "4 on the floor" kick pattern, followed by shimmering hi hats and groovy synth bass. It sounds exciting and like something you would hear in clubs. | 2015-12-23T15:38:15Z | dOPE dOPA | RELEASE DATE 2015-12-11 LABELS Innervisions CATALOG # IV62 Buy Here http://classic.beatport.com/release/too-much-information-remixes/1659205 http://www.innervisions.net http://www.mutingthenoise.com https://soundcloud.com/innervisions Electronic music label, founded in 2005 by Dixon & Âme. https://soundcloud.com/laolu https://www.facebook.com/Laolu-Music-Official-173460949332578/info/ | ["Disco", "Music"] | ["electro", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "groovy synth bass", "exciting"] | 4 | IYumekd1VMg | 1917 | |
house music top 10 best techno trance dance music 2008 -DJ DDX | The low quality recording features a repetitive synth lead melody playing over shimmering shakers and open hats and punchy "4 on the floor" kick pattern. It sounds energetic, uptempo and like it is an intro section of the song, since the audio is slowly fading in, | 2008-06-28T18:47:30Z | discodevils | http://revver.com/user/djddx/ high quality perfect mastered tracks this tracks r my own creation..all r copyrighted to me..this one of my 10 songs mix..if u like this rate it and subscribe to my channel.... | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Trance music", "Dance music"] | ["low quality", "shimmering shakers", "repetitive synth lead melody", "punchy \"4 on the floor\" kick pattern", "shimmering open hat", "fade in", "uptempo", "energetic", "electro"] | 4 | UO9HtZMrbBE | 2910 |
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;