musiccaps_details (view)
3 rows where musiccaps_aspects contains "electro", musiccaps_names contains "Electronic music" and musiccaps_names contains "Techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- electro · 3 ✖
- exciting 3
- energetic 2
- punchy kick 2
- punchy snare 2
- shimmering hi hats 2
- addictive synth lead melody 1
- echoing stuttering vocal 1
- filter modulated synth melody 1
- filtered echoing male vocal 1
- fun 1
- groovy synth bass 1
- happy 1
- haunting synth lead 1
- high pitched riser 1
- kick impact 1
- low pitched male vocal 1
- low quality 1
- male chants 1
- pulsating synth bass 1
- repetitive high pitched vocal 1
- riser 1
- short snare roll 1
- synth down sweep 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Electronic music · 3 ✖
- Music 3
- Techno · 3 ✖
- Trance music 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 | |
Pirates of the Caribbean Theme Song Techno Remix | The low quality recording features an electro song that consists of a punchy kick, shimmering hi hats, echoing stuttering vocal, punchy snare and synth down sweep. It sounds energetic and exciting. | 2011-07-31T09:13:46Z | iRuckaz | Hit The Subs Button Please ... | ["Electronic music", "Music", "Techno", "Trance music"] | ["low quality", "punchy kick", "shimmering hi hats", "echoing stuttering vocal", "synth down sweep", "punchy snare", "energetic", "exciting", "electro"] | 4 | BUDb8YieUgU | 1244 | |
BEST TECHNO SONG 2013! | The Electro song features a filter modulated synth melody, groovy synth bass, shimmering hi hats, punchy kick and snare hits, followed by short snare roll, haunting synth lead, low pitched male vocal introducing the section and high pitched riser that builds the energy up. It sounds energetic, upbeat and exciting - like something you would hear in clubs. | 2008-12-19T15:07:54Z | Kitingnoobs | Try worlds largest FREE game: League of Legends, its for both Europe and America sign up here for double exp! http://signup.leagueoflegends.com/?ref=4d1223da0a0c3734874312 | ["Electronic music", "Music", "Techno"] | ["electro", "filter modulated synth melody", "groovy synth bass", "shimmering hi hats", "low pitched male vocal", "punchy snare", "punchy kick", "high pitched riser", "short snare roll", "energetic", "haunting synth lead", "upbeat", "exciting"] | 4 | P1Vxm_ICSG0 | 2493 |
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;