musiccaps_details (view)
3 rows where musiccaps_aspects contains "clapping" and musiccaps_aspects contains "soft kick hits" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- clapping · 3 ✖
- groovy bass 3
- soft kick hits · 3 ✖
- low quality 2
- shimmering cymbals 2
- addictive 1
- bouncy snare 1
- cool 1
- country blues 1
- energetic 1
- energetic female vocal 1
- energetic ride cymbals 1
- fruity male vocal 1
- groovy 1
- groovy electric guitar melodies 1
- happy 1
- joyful 1
- jungle 1
- mellow snare 1
- noisy 1
- passionate 1
- passionate male vocal 1
- pop 1
- shimmering shakers 1
- smooth 1
- tinny reverberant percussive element 1
- uptempo 1
- vintage 1
- wide harmonizing background vocals 1
- zipper sound effect 1
musiccaps_names (array) 9 ✖
- Music 3
- Blues 1
- Country 1
- Music of Latin America 1
- Rhythm and blues 1
- Singing 1
- Soul music 1
- Swing music 1
- Zipper (clothing) 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zipper Bracelet | The low quality recording features a jungle track that consists of bouncy snare, soft kick, shimmering shakers, energetic ride cymbal, claps and groovy bass. There are some zipping sound effects, alongside energetic female vocal phrases. It sounds energetic, but yet smooth. Sounds like a soundtrack for a commercial. | 2013-09-12T12:31:38Z | UczyibawiPL | bransoletka, suwak, biżuteria | ["Zipper (clothing)", "Music"] | ["low quality", "zipper sound effect", "jungle", "bouncy snare", "shimmering shakers", "groovy bass", "tinny reverberant percussive element", "clapping", "soft kick hits", "energetic ride cymbals", "energetic", "smooth", "energetic female vocal"] | 4 | 2YQPwRLB1s0 | 376 | |
Pharrell Williams - Happy (WE ARE FROM HONG KONG) Dance edition | The Pop song features a passionate male vocal, alongside wide harmonizing background vocals, singing over clapping, shimmering cymbals, groovy bass and soft kick hits. It sounds addictive, happy and joyful. | 2014-01-28T21:37:50Z | di2dadance | 今次誠邀多位跳舞前輩及好友拍攝HAPPY 希望鼓勵新一代的舞蹈員 以開心和享樂的態度跳舞 堅持不放棄! 由於我的時間有限,未能邀請所有的朋友參與拍攝, 非常感謝幫忙拍攝的 ﹣Allen To ﹣Kinko Koo ﹣Lok Man ﹣Leung ﹣Sunny Wong ﹣Vivian ﹣Bo Sir ﹣小燕 ﹣Bowie ﹣Popping Douglee ﹣Kato ﹣榮 ﹣Maska ﹣Timothy ﹣Louis ﹣Popper 88 ﹣Virago Carmen ﹣Wh Chung ﹣Popping Lok ﹣Chu Tin ﹣Shing ﹣Danie ﹣佳 三月我會繼續拍攝繼續享受跳舞的樂趣 PLS SUPPORT~~ | ["Music", "Soul music"] | ["pop", "passionate male vocal", "wide harmonizing background vocals", "clapping", "shimmering cymbals", "groovy bass", "soft kick hits", "addictive", "happy", "joyful"] | 4 | L2-EGNKzUAQ | 2146 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 |
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;