musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "riser"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- electro · 2 ✖
- exciting · 2 ✖
- riser · 2 ✖
- addictive synth lead melody 1
- clapping 1
- cowbell 1
- echoing hi hats 1
- filtered echoing male vocal 1
- fun 1
- happy 1
- kick impact 1
- low quality 1
- male chants 1
- percussive elements 1
- pulsating synth bass 1
- repetitive high pitched vocal 1
- repetitive percussive bass loop 1
- shimmering shakers 1
- snare roll 1
- suspenseful 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic dance music 1
- Electronic music 1
- Rattle 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Raaban - Drop The Bass | The electro song features a filtered echoing male vocal speaking over layered riser and kick impact, after which there is a repetitive high pitched vocal, male chants, pulsating synth bass and addictive synth lead melody. It sounds exciting, happy and fun - like something you were listening to when you were younger. | 2007-11-08T04:02:55Z | Looped- | Dj Raaban - Drop the Bass {{{{{{{ Contains Flashing }}}}}}} No more Annotations everyone so enjoy!! | ["Electronic music", "Music", "Techno"] | ["filtered echoing male vocal", "addictive synth lead melody", "exciting", "fun", "happy", "riser", "repetitive high pitched vocal", "male chants", "pulsating synth bass", "kick impact", "electro"] | 4 | B1vY7kxQ9Xg | 1195 | |
Gaga, Budai: Double Door (PREVIEW) | The low quality recording features an electro song that consists of percussive elements, echoing hi hats, shimmering shakers, cowbell, claps and repetitive percussive bass loop. At the end of the loop, there are snare rolls and risers layered together, building up tension for the drop. It sounds exciting and suspenseful. | 2015-10-07T11:51:17Z | kinetikarecordsmusic | with Alberto Ruiz remix Grab it at: http://classic.beatport.com/release/double-door/1627244 www.kinetikarecords.com | ["Music", "Rattle", "Electronic dance music"] | ["low quality", "electro", "percussive elements", "echoing hi hats", "shimmering shakers", "cowbell", "clapping", "repetitive percussive bass loop", "snare roll", "riser", "exciting", "suspenseful"] | 4 | JsHTGDW5dgw | 2040 |
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;