musiccaps_details (view)
4 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "dance" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- claps · 4 ✖
- dance · 4 ✖
- live performance 2
- acoustic drums 1
- arabian 1
- bass guitar 1
- disco 1
- easygoing 1
- eccentric 1
- electronic drums 1
- folk 1
- funk 1
- funky bass 1
- groovy 1
- happy 1
- hip 1
- human sounds 1
- hype 1
- jovial 1
- keyboard 1
- male vocal 1
- melodic 1
- organ 1
- oud 1
- percussion 1
- playful 1
- pop music 1
- rhythmic 1
- steps 1
- synth 1
- tambourine 1
- uplifting 1
musiccaps_names (array) 7 ✖
- Music 4
- Afrobeat 1
- Disco 1
- Music of Africa 1
- Pop music 1
- Tambourine 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TF2 Unusual - Hong kong Cone Disco Beat Down | This is a funk piece. It has an electronic drum beat with heavy use of claps in the rhythmic background. A synth with an organ sound is playing the melody, but it is filled with effects, so the sound is constantly changing. A fuzzy sounding bass is playing a funky groove in the background. There is an eccentric atmosphere. This piece could be used in the soundtracks of young-adult cartoons. | 2014-10-24T01:23:46Z | znoc! addme2bro | See Hong Kong Cone on all the classes for your convenience. | ["Disco", "Music"] | ["funk", "electronic drums", "claps", "organ", "synth", "funky bass", "groovy", "eccentric", "hip", "dance", "disco"] | 9 | EC_JNTVDrok | 1539 | |
جلسه شبابيه بالعليا بصوت علوي محمد العطاس | This is an Arabian folk music piece. It is meant to be an accompaniment to a folk dance. There is an oud playing the melody while a tambourine is playing as the rhythmic background. This is an amateur recording of a live performance. The atmosphere is playful. This could be playing in the background at a Middle Eastern cuisine restaurant or at a hookah place. | 2011-11-28T13:47:05Z | khaled amoudi | ["Music", "Tambourine"] | ["arabian", "folk", "dance", "oud", "tambourine", "claps", "live performance", "playful"] | 9 | LkzyG2F8mTM | 2219 | ||
Famous Ramos: Audition for Pharrell Music Video - ("Happy" - Pharrell) | This is a famous pop music piece played over a dance audition video. The male vocalist is singing melodically in one track at a medium pitch and singing the melody at a high pitch in another track. The melody is supported by a bass guitar playing a groovy bassline. A catchy acoustic drum beat and offbeat claps hold the rhythmic background. The atmosphere is jovial and very danceable. This piece could be used in a myriad of different ways from dance videos, online content, sports venues etc. | 2013-09-13T23:39:49Z | Famous Ramos | A teaser to our upcoming video to "Lose Yourself to Dance!" COMING SOON! This was my audition for the casting of Pharrell's video. I booked the job! http://youtu.be/rQD9EBCwlQc?t=56m3s :) It's all improve and a one take performance. Hope you enjoy as much as I did dancing! /Famous | ["Afrobeat", "Music of Africa", "Music", "Pop music"] | ["pop music", "male vocal", "bass guitar", "keyboard", "acoustic drums", "claps", "melodic", "happy", "jovial", "uplifting", "easygoing", "dance"] | 9 | pZgzjL5wbtA | 4721 | |
My Little Pony: Equestria Girls - Scarlet Project | This is the live recording of a dance piece. The dancer can be heard stepping her foot on the ground and clapping her hands in a rhythmic fashion. The recording is a bit poor in quality, but samples could be lifted to be used in beats. | 2014-03-24T20:55:09Z | CamRiper | ["Music", "Tap"] | ["steps", "claps", "live performance", "rhythmic", "human sounds", "percussion", "hype", "dance"] | 9 | vrxT5jhqu0Q | 5213 |
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;