musiccaps_details (view)
3 rows where musiccaps_aspects contains "house" and musiccaps_names contains "Trance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- house · 3 ✖
- energetic 2
- "4 on the floor" kick pattern 1
- bouncy claps 1
- catchy 1
- claps on backbeat 1
- dance 1
- drum machine tom melody 1
- edm 1
- electro 1
- electronic drums 1
- four on the floor kick 1
- groovy 1
- instrumental 1
- lead synth 1
- low quality 1
- pad 1
- repeated theme 1
- repetitive echoing male vocal 1
- repetitive synth bassline 1
- repetitive synth lead melody 1
- shimmering hi hats 1
- shuffled hi hats 1
- simple 1
- sound effects 1
- synth bass 1
- synth chords with delay 1
- techno 1
musiccaps_names (array) 9 ✖
- Music 3
- Trance music · 3 ✖
- Dance music 2
- Electronic dance music 2
- Electronica 2
- Drum machine 1
- Exciting music 1
- House music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Josh The Funky 1 - Its The Music (Miles Dyson remix) | The low quality recording features a house song that contains echoing male vocal singing over shimmering hi hats, bouncy claps, "4 on the floor" kick pattern and repetitive synth lead melody. It sounds energetic and groovy. | 2008-07-20T14:21:49Z | Tomas K | ElectoBit - Summer Session vol. 1 | ["House music", "Music", "Techno", "Trance music", "Electronic dance music", "Dance music", "Electronica", "Exciting music"] | ["house", "low quality", "repetitive echoing male vocal", "shimmering hi hats", "bouncy claps", "\"4 on the floor\" kick pattern", "repetitive synth lead melody", "energetic", "groovy"] | 4 | HHTgjmgTV6c | 1787 | |
New Dance & Electro Mix || Best Electro House Mix 2014 - By Becko | This is a house music piece. It has a fuzzy synth lead playing the main melody while there is a medium-to-high pitch pad playing an arpeggio. There is a fuzzy synth bass in the background. A loud electronic drum beat provides the rhythmic background. There is a constant crowd cheering effect giving the impression of the piece being performed live. The atmosphere is energetic. This piece can be played at nightclubs and EDM venues. | 2014-11-21T13:21:44Z | Best Music | The Best Electro House Dance Mixes by Club Music!! Make sure to subscribe and like this video!! Free Download: http://bit.ly/1H4aF1M ▸Follow this Soundcloud for free downloads when it hits 10k: http://bit.ly/1Egulj1 ▸Follow CLUB MUSIC on Facebook: http://goo.gl/MSPI8q | ["Music", "Trance music", "Electronic dance music", "Dance music"] | ["dance", "electro", "house", "lead synth", "synth bass", "electronic drums", "pad", "sound effects", "repeated theme", "simple", "catchy", "energetic"] | 9 | IYtQfDsFVfA | 1916 | |
RAV4 Noise and Vibration -RAV4 Special Content- | This is an EDM inspired instrumental house/techno beat with a four on the floor kick pattern, shuffled hi hats, a repetitive synth bassline, synth chords with delay, drum machine tom melody and claps on the backbeat. | 2013-03-29T09:14:25Z | Toyota Global | Toyota Global Website http://www.toyota-global.com/ RAV4 Special Content http://www.toyota-global.com/showroom/vehicle_gallery/special/rav4/ Toyota Global Facebook http://www.facebook.com/ToyotaSpecialShowroom Toyota Global Google+ https://google.com/+toyota/ | ["Music", "Trance music", "Drum machine", "Electronica"] | ["edm", "house", "techno", "four on the floor kick", "shuffled hi hats", "repetitive synth bassline", "synth chords with delay", "instrumental", "drum machine tom melody", "claps on backbeat"] | 8 | jmPmqzxlOTY | 4282 |
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;