musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music", musiccaps_author = 0 and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mad Mike - Heartbeat Of A Groove | This techno song features a falsetto voice in the beginning. This is accompanied by 2 counts of programmed percussion. A synth plays one chord using synth strings. The voice, percussion and synth pause and only a repetitive synth loop is played. After four bars, the kick drum starts playing on every count. The mood of this song is upbeat. This song can be played in a trance party or a DJ party. | 2009-06-12T11:28:26Z | yellowidhouse | 1992 Happy Records | ["Sampler", "Disco", "Music", "Drum machine"] | ["techno song", "dj song", "falsetto voice", "synth music", "trance music", "dance music", "programmed percussion", "repetitive melody", "upbeat"] | 0 | 9Cfs00bZRCg | 983 | |
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 | |
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;