musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music" and musiccaps_aspects contains "house music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- dance music · 3 ✖
- house music · 3 ✖
- moderate tempo 2
- ambient music 1
- bass 1
- club music 1
- dance pop 1
- digital drumming 1
- dj 1
- dj mixer 1
- edm 1
- electronic music 1
- electronica 1
- fast tempo 1
- female voice 1
- hand claps 1
- hardcore 1
- high energy 1
- hypnotic 1
- instrumental 1
- latin feel 1
- no other instruments 1
- no voices 1
- party music 1
- percussion 1
- programmed percussion 1
- progressive trance 1
- psychedelic 1
- psytrance 1
- repetitive beats 1
- synth sounds 1
- synthesiser arrangement 1
- tech trance 1
- techno 1
- techno pop 1
- trance droning 1
- trance music 1
- trippy 1
- vocal riff 1
- youthful 1
musiccaps_names (array) 6 ✖
- Disco 3
- Music 3
- House music 2
- Dance music 1
- Dubstep 1
- Electronic dance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Best House Music In The World [Turn It Around] | This house music features a female voice singing the main melody. This is accompanied by programmed percussion playing a simple beat. The kick is played on every count. Hand claps are played at every alternate count. The bass plays the root notes of the chords. Synth chords are played in the background. This song can be played at a club. | 2009-07-22T20:45:27Z | ALBANIITY | The nEwW BeAtt Off BEst HoUsee MUSiiC iN ThE WOrLDD It iS FroOm A FaMouSs DJ --He LivvEEs in LA LetSSs ReAAddyy FooR HooUseee club hits my first megamix Best house music top house music top electro house best electro house top tribal house best tribal house new house music house music 4 ever hot house music new tribal house best latin house top latin house best prog house hot prog house i love house music megamix number 1 mixed by foOtBaLl7PlaYa | ["Disco", "House music", "Music"] | ["house music", "party music", "female voice", "hand claps", "programmed percussion", "synth sounds", "bass", "moderate tempo", "dance music"] | 0 | ICcASgMtIJ8 | 1879 | |
TECKTONIK vs SHUFFLE.. | This music is an electronic instrumental. The tempo is fast with synthesiser arrangements, electronic beats , Dj mixer and a repetitive vocal riff. The music is incessant, psychedelic, hypnotic, trippy and trance like with a dance groove. This music is Techno Pop/EDM. | 2010-05-01T19:39:05Z | cireduard | hermano vs hermano familia TELLO | ["Disco", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "house music", "progressive trance", "repetitive beats", "high energy", "tech trance", "ambient music", "hardcore", "psytrance", "edm", "electronica", "techno", "techno pop", "trippy", "trance droning", "dance pop", "psychedelic", "vocal riff", "dance music", "club music", "dj", "dj mixer", "digital drumming", "synthesiser arrangement", "hypnotic", "trance music", "trippy", "youthful"] | 7 | ITg9o6Gwsbo | 1910 | |
LATIN-HOUSE IN THE MIX | This house music features percussion being played to a Latin beat. There are no other instruments in this song. There are no voices in this song. This song can be played in a club. | 2007-09-19T22:33:10Z | decaderecords | LATINHOUSE MIX 01 - D-Rashid ft. Quatro+ - Entinada 02 - SUMO ft. Clarisse Muvemba - Bo Entintada 03 - The Jinx - Brazilia (gregor salto & madskillz remix) 04 - D-Rashid - Casera (vocal version) 05 - Gregor Salto & Dr Kucho - Love is my game (skitzofrenics remix) | ["Disco", "House music", "Music"] | ["house music", "latin feel", "no voices", "percussion", "no other instruments", "moderate tempo", "dance music"] | 0 | entThp930cw | 3900 |
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;