musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting" and musiccaps_aspects contains "riser"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- exciting · 3 ✖
- riser · 3 ✖
- addictive synth lead melody 2
- electro 2
- low quality 2
- addictive 1
- clapping 1
- cowbell 1
- echoing hi hats 1
- energetic 1
- filtered echoing male vocal 1
- fun 1
- groovy piano melody 1
- groovy synth bass 1
- happy 1
- instrumental 1
- kick impact 1
- male chants 1
- noisy snare hit 1
- percussive elements 1
- pop 1
- pulsating synth bass 1
- punchy "4 on the floor" kick pattern 1
- repetitive high pitched vocal 1
- repetitive percussive bass loop 1
- shimmering hi hats 1
- shimmering shakers 1
- snare roll 1
- suspenseful 1
- tinny high pitched snaps 1
musiccaps_names (array) 6 ✖
- Music 3
- Electronic music 2
- Electronic dance music 1
- House 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 | |
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;