musiccaps_details (view)
4 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "electro" and musiccaps_aspects contains "energetic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- addictive · 4 ✖
- electro · 4 ✖
- energetic · 4 ✖
- clapping 2
- groovy bass 2
- 4 on the floor kick 1
- addictive synth lead melody 1
- echoing pulsating synth lead melody 1
- flat male vocal 1
- groovy kick hits 1
- groovy synth bass 1
- low quality 1
- male barking onomatopoeia 1
- noisy 1
- pulsating synth lead melody 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- punchy snare 1
- quiet snare roll 1
- repetitive 1
- repetitive male vocals 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- sizzling triangle 1
- sweeping sound effects 1
- tinny cowbell 1
- tinny laser percussive sound effect 1
- toms roll 1
- uptempo 1
- wide claps 1
musiccaps_names (array) 11 ✖
- Music 4
- Dance music 2
- /t/dd00032 1
- Drum and bass 1
- Electronic dance music 1
- Electronic music 1
- Funk 1
- House music 1
- Music of Africa 1
- Reggae 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
who let the dog sound | The low quality recording features an electro song that consists of flat male vocals, alongside widely spread male barking onomatopoeia, singing over shimmering shakers, sizzling triangle, tinny cowbell, punchy kick, punchy snare and groovy bass. It sounds energetic and addictive, even though it is a bit repetitive. | 2009-04-24T18:13:35Z | kaustubh18tyagi | who let the dog sound | ["Music of Africa", "Music", "Reggae"] | ["low quality", "electro", "punchy snare", "punchy kick", "groovy bass", "flat male vocal", "male barking onomatopoeia", "shimmering shakers", "sizzling triangle", "tinny cowbell", "energetic", "addictive", "repetitive"] | 4 | sZuhztdaFYA | 4961 | |
Stardust - Music sounds better with you (miami horror remix) | The Electro song features a repetitive male vocal singing over shimmering hi hats, tom rolls, wide claps, groovy kick, pulsating synth lead melody and groovy synth bass, which glues everything together. Even though the vocal is repetitive, it sounds very addictive and energetic in context. | 2013-01-26T03:00:47Z | MisterWright | I love this mix of this song! and I thought this video went well with it to. :D | ["Funk", "Music", "Dance music", "/t/dd00032"] | ["electro", "pulsating synth lead melody", "toms roll", "shimmering hi hats", "wide claps", "repetitive male vocals", "groovy kick hits", "groovy synth bass", "addictive", "energetic"] | 4 | s_BKo_1LzJM | 4963 | |
Stardust - Music Sounds Better With You (Stardust Electric Remix) | The Electro song features a punchy "4 on the floor" kick pattern perfectly complemented by groovy bass, followed by tinny laser percussive sound effects, shimmering cymbals, claps and echoing pulsating synth lead melody. Sounds energetic, a bit addictive thanks to that synth lead and something like you would hear in electronic dance music clubs. | 2011-06-06T15:30:08Z | francescoivrea | The Original 2008 Electro Remix by Stardust for his amazing single Label:Not On Label Catalog#:DUST001 Format:Vinyl, 12", White Label, Single Sided, Unofficial Release Country:UK Released:03 Dec 2008 Genre:Electronic Style:House, Electro | ["Electronic music", "House music", "Music"] | ["electro", "tinny laser percussive sound effect", "punchy \"4 on the floor\" kick pattern", "clapping", "shimmering cymbals", "echoing pulsating synth lead melody", "energetic", "addictive", "groovy bass"] | 4 | tllFsEPv7Ls | 5062 |
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;