musiccaps_details (view)
3 rows where musiccaps_aspects contains "clapping rhythm" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- clapping rhythm · 3 ✖
- male singer · 3 ✖
- emotional 2
- groovy bass line 2
- groovy rhythm 2
- medium tempo 2
- passionate 2
- steady drumming rhythm 2
- adore you 1
- animated singing 1
- backup singers 1
- bengali pop song 1
- cheerful 1
- children’s song 1
- dance party 1
- dance song 1
- groovy music 1
- hip hop hits 1
- hip hop music 1
- hip hops love song 1
- indian music 1
- indian pop song 1
- live audience 1
- live performance 1
- love anthem 1
- love song 1
- madly in love 1
- male backup singers 1
- message of kindness 1
- people dancing 1
- piano accompaniment 1
- playful 1
- pop anthem 1
- pop dance hits 1
- pop song 1
- private music video 1
- romantic 1
- screaming vocals 1
- slick drumming rhythm 1
- spirited 1
- steady drumming line 1
- strong bass line 1
- super hits 1
- tambourine percussion 1
- together forever 1
- ukulele accompaniment 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stevie Hoang - Addicted - new music video 2009 | A male singer sings this cool hip hop love song with backup singers in vocal harmony. The tempo is medium with keyboard accompaniment, piano accompaniment, steady drumming rhythm, clapping percussion and other sonic effects. The song is emotional and romantic with a cool dance groove, | 2009-05-18T16:36:44Z | steviehoang | Buy the Physicial CD http://www.cdbaby.com/cd/steviehoang3 Official Facebook https://www.facebook.com/StevieHoangMusic Twitter https://twitter.com/steviehoang | ["Music", "Soul music"] | ["male singer", "hip hop music", "backup singers", "live performance", "live audience", "super hits", "piano accompaniment", "groovy bass line", "steady drumming line", "slick drumming rhythm", "emotional", "romantic", "passionate", "together forever", "love song", "hip hop hits", "groovy rhythm", "dance song", "hip hops love song", "clapping rhythm"] | 1 | -oP-XX28B0s | 87 | |
Hairless Dancing Nathan : "Cupid Shuffle" | A male singer sings this animated melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, clapping percussion and strong bass hits. The song is a pop dance hit with a groovy dance rhythm. | 2014-02-14T03:00:29Z | DancingNathan | Dancing Nathan is a hairless chinese crested who LOVES to chair dance. He was adopted from Bald is Beautiful Hairless & Small Breed Rescue and is quite a character. #dancingnathan #hotmessgilligan #hairlessdog #chinesecrested @dancenekkid #cupidshuffle | ["Music", "Rhythm and blues", "Hip hop music"] | ["male singer", "animated singing", "male backup singers", "dance party", "people dancing", "groovy rhythm", "strong bass line", "clapping rhythm", "steady drumming rhythm", "screaming vocals", "pop dance hits", "children’s song", "pop anthem", "playful", "cheerful", "vocal harmony", "medium tempo", "pop song"] | 1 | 9CJu43AvIds | 982 | |
Abar (আবার) Ukulele version by - Rafa | A male singer sings this delightful melody. The song is medium tempo with a ukulele accompaniment, steady drumming rhythm with various percussions like clapping and tambourine along with a keyboard accompaniment. The song is emotional and groovy. The song is a local Indian language pop song, most probably a Bengali pop song. | 2013-12-30T22:12:20Z | AvoidRafa | This song of mine is also available in Aurthohin's album Aushomapto 2. But that version is a whole lot heavier than this. This is my way of seeing into this piece of tune. Thanks a million to Bassbaba for writing the amazing words that made this song so positive. (Unlike me :P) Thanks to Nabil Khan for the insane video he pulled in just half an hour of shoot and one night of editing. I am very pleased to present you with this video. There will be more soon :) Here's the link for the song https://soundcloud.com/avoidraef/abar-ukulele-version | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Bowed string instrument"] | ["male singer", "indian music", "ukulele accompaniment", "bengali pop song", "emotional", "spirited", "message of kindness", "passionate", "love anthem", "madly in love", "adore you", "medium tempo", "groovy music", "tambourine percussion", "steady drumming rhythm", "clapping rhythm", "groovy bass line", "indian pop song", "private music video"] | 1 | x1x54MgStxQ | 5301 |
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;