musiccaps_details (view)
2 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "groovy synth bass" and musiccaps_aspects contains "punchy "4 on the floor" kick pattern"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- exciting · 2 ✖
- groovy synth bass · 2 ✖
- punchy "4 on the floor" kick pattern · 2 ✖
- shimmering hi hats 2
- addictive 1
- addictive synth lead melody 1
- electro 1
- energetic 1
- groovy piano melody 1
- instrumental 1
- low quality 1
- noisy snare hit 1
- pop 1
- riser 1
- tinny high pitched snaps 1
musiccaps_names (array) 4 ✖
- Music 2
- Disco 1
- Electronic music 1
- House 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 | |
I´m an albatraoz- Subtitulada Español | The low quality recording features an instrumental of a pop song that consists of an addictive synth lead melody, punchy "4 on the floor" kick pattern, shimmering hi hats, riser and groovy bass in the first half of the loop. In the second half of the loop there is a tinny, high pitched snaps and groovy piano melody playing. It sounds energetic, exciting and addictive. | 2015-03-15T21:04:41Z | Angel Valencia | La pista original fue removida por motivos derechos de autor, este remix se encuentra en este video https://www.youtube.com/watch?v=sKop9_eD5MU | ["Electronic music", "House music", "Music"] | ["low quality", "pop", "instrumental", "addictive synth lead melody", "groovy piano melody", "shimmering hi hats", "riser", "noisy snare hit", "groovy synth bass", "punchy \"4 on the floor\" kick pattern", "tinny high pitched snaps", "energetic", "addictive", "exciting"] | 4 | xxRnOYSjF64 | 5369 |
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;