musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive synth lead melody" and musiccaps_aspects contains "electro" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- addictive synth lead melody · 2 ✖
- electro · 2 ✖
- 4 on the floor kick 1
- addictive 1
- clapping 1
- energetic 1
- exciting 1
- filtered echoing male vocal 1
- fun 1
- happy 1
- kick impact 1
- male chants 1
- noisy 1
- pulsating synth bass 1
- quiet snare roll 1
- repetitive high pitched vocal 1
- riser 1
- sweeping sound effects 1
- uptempo 1
musiccaps_names (array) 6 ✖
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 | |
Evil Techno - Darkness and Magic | The Electro song features an addictive synth lead melody playing over quiet snare roll, some claps and sweeping sound effects. In the second half of the loop, there is a "4 on the floor" kick patter. It is uptempo and it sounds energetic and sort of addictive. | 2011-04-16T14:51:02Z | Xeyrophobic | Download Evil Techno here(The first 8 tracks) ► http://sh.st/ymf9J | ["Drum and bass", "Music", "Techno", "Electronic dance music", "Dance music"] | ["clapping", "noisy", "quiet snare roll", "addictive synth lead melody", "4 on the floor kick", "energetic", "uptempo", "electro", "addictive", "sweeping sound effects"] | 4 | CyFsI_EYFQQ | 1421 |
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;