musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "synth sounds"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- dance music · 2 ✖
- moderate tempo · 2 ✖
- programmed percussion 2
- synth sounds · 2 ✖
- backing voice 1
- bass 1
- club song 1
- dancehall 1
- dj song 1
- female voice 1
- flirty mood 1
- hand claps 1
- house music 1
- male voice 1
- party music 1
musiccaps_names (array) 4 ✖
- Disco 1
- House music 1
- Music 1
- Reggae 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 | |
SEAN PAUL - Roll wid da don - Dancehall Choreography by Aya | This dancehall song features a male voice singing the main melody. Another male voice sings backing vocals in harmony with the main melody. The voice sings at a fast pace fitting many syllables in the rhythm phrases. This is accompanied by programmed percussion playing a simple beat. Synth sounds are played in between lines. This song is flirty. This song can be played in a club. | 2012-05-06T16:13:19Z | AYA LEVEL | SUBSCRIBE to my Channel: http://bit.ly/13Cfk5G Look at my "BEST OF Choreographies": http://bit.ly/17FDs86 Visit MoveOn the dance channel: http://bit.ly/12rI6Ix BOOKING CONTACT: aya.management@gmail.com Facebook: AYA LEVEL & AYA DANCER II http://www.facebook.com/pages/Aya-Level/348371768509093 Twitter: http://twitter.com/ayadancer Instagram: aya_level | ["Reggae"] | ["dancehall", "male voice", "backing voice", "programmed percussion", "flirty mood", "synth sounds", "dance music", "moderate tempo", "dj song", "club song"] | 0 | MC0Aeu7RLSI | 2248 |
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;