musiccaps_details (view)
6 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 82 ✖
- female singer · 6 ✖
- passionate · 6 ✖
- steady drumming rhythm · 6 ✖
- emotional 5
- medium tempo 5
- poor audio quality 4
- romantic 4
- groovy bass line 2
- guitar accompaniment 2
- keyboard accompaniment 2
- people dancing 2
- percussive bass line 2
- adventurous 1
- ambient room noise 1
- arabic dance music sultry vocals 1
- arabic music 1
- arabic percussion 1
- beachside party 1
- brass band harmony 1
- caribbean music style 1
- caribbean percussions rhythm 1
- classic reverse hits 1
- cymbals crashing 1
- dance club 1
- dance groove 1
- dance rhythm 1
- dance tunes 1
- death metal 1
- deteriorated audio 1
- dholak percussions 1
- discotheque 1
- distorted guitar rhythm 1
- dj 1
- drum rolls 1
- electronic harmony tones 1
- electronic music 1
- energetic 1
- enjoy life 1
- euro pop hits 1
- exciting 1
- experimental 1
- groovy bas line 1
- groovy mood bass line 1
- groovy music 1
- groovy rhythm 1
- guitar strumming 1
- haunting 1
- inspiring 1
- keybiard accompaniment 1
- life is a dance 1
- life is good 1
- live audience 1
- live performance 1
- love song 1
- love songs 1
- madly in love 1
- male singer 1
- medium fast tempo 1
- moog bass 1
- music production 1
- quirky 1
- radio buzzing tones 1
- rebellious 1
- reggae groove 1
- reggae hits 1
- retro death metal hits 1
- retro pop hits 1
- retro pop music 1
- russian pop star 1
- say sorry 1
- screaming vocals 1
- sonic effects 1
- spirited 1
- spirited singing 1
- tambourine percussion 1
- teenage age angst 1
- tropical dance hit 1
- trumpets blaring 1
- various frequency tones 1
- vocal duet 1
- vocal monologue 1
- youthful 1
musiccaps_names (array) 16 ✖
- Music 6
- Grunge 2
- /t/dd00003 1
- Buzz 1
- Drum and bass 1
- Drum machine 1
- Electronica 1
- Folk music 1
- Independent music 1
- Pop music 1
- Rock music 1
- Sampler 1
- Singing 1
- Techno 1
- Tender music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
Sylwia Grzeszczak - Flirt [Official Music Video] | A female singer sings this emotional melody. The song is medium tempo with guitar strumming rhythm, strong bass line, steady drumming rhythm, keyboard accompaniment and sound effects. The song is emotional and romantic. The song is a euro pop love song and has poor audio quality. | 2013-04-16T09:57:50Z | SylwiaGrzeszczak | ✅ Subskrybuj: https://bit.ly/WMP_YT ✅ Instagram https://instagram.com/warnermusicpoland ✅ Facebook: https://fb.com/warnermusicpoland ✅ TikTok: https://www.tiktok.com/@warnermusicpoland Music video by Sylwia Grzeszczak performing Flirt. (P) 2013 The copyright in this audiovisual recording is owned by Gorgo under exclusive licence to EMI Music Poland Sp. z.o.o. | ["Music", "Tender music"] | ["female singer", "russian pop star", "medium tempo", "groovy bass line", "emotional", "passionate", "madly in love", "say sorry", "poor audio quality", "guitar strumming", "groovy bas line", "sonic effects", "keybiard accompaniment", "steady drumming rhythm", "romantic", "love song", "euro pop hits"] | 1 | ORikRIu7s1o | 2440 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 | |
KING Q4 Love Buzz | A female singer sings this vocal monologue. The song is medium tempo with a groovy moog bass line, electro mix keyboard harmony tones, steady drumming rhythm and very quirky electronic tones. The song is groovy and retro dance music. | 2011-07-16T11:15:03Z | KINGQ44 | http://kingq4.bandcamp.com/ http://itunes.apple.com/fr/album/love-buzz-ep/id357022549 King Q4 Love Buzz Help me records 2010 composed by Shocking Blue arranged by King Q4 mixed by Raphael Seguin | ["Sampler", "Drum and bass", "Music", "Techno", "Buzz", "Drum machine", "Electronica"] | ["female singer", "retro pop music", "moog bass", "medium tempo", "energetic", "experimental", "quirky", "romantic", "youthful", "passionate", "people dancing", "dance club", "dance rhythm", "discotheque", "music production", "electronic music", "steady drumming rhythm", "dj", "radio buzzing tones", "various frequency tones", "groovy mood bass line", "dance rhythm", "emotional", "vocal monologue", "electronic harmony tones"] | 1 | dAAwzwexvUQ | 3767 |
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;