musiccaps_details (view)
6 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "madly in love" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- emotional · 6 ✖
- madly in love · 6 ✖
- poor audio quality · 6 ✖
- romantic 6
- guitar accompaniment 4
- medium tempo 4
- passionate 4
- love song 3
- female singer 2
- groovy music 2
- guitar strumming 2
- male singer 2
- no percussion instruments 2
- ambient room noises 1
- bad quality audio 1
- bengali hits 1
- bengali pop song 1
- black gospel influences 1
- bollywood music 1
- buzzing 1
- couples dancing 1
- courtship song 1
- crowds cheering 1
- dance rhythm 1
- deteriorated audio quality 1
- dial tone beeps 1
- erotic 1
- euro pop hits 1
- flamenco guitar style 1
- girls screaming 1
- groovy bas line 1
- groovy bass line 1
- guitar bass line 1
- guitar lead 1
- hissing noises 1
- home video 1
- humming 1
- indie music 1
- instrumental music 1
- jazz music 1
- keybiard accompaniment 1
- latin dance music 1
- latin guitar player 1
- live shows 1
- longing for you 1
- love songs 1
- modern love 1
- modern pop hits 1
- movie soundtrack 1
- music lesson ideo 1
- packed stadium 1
- pop hits 1
- pop music 1
- pop star sings live 1
- private music video 1
- retro pop song 1
- rhumba music 1
- russian pop star 1
- say sorry 1
- slow tempo 1
- soaring vocals 1
- solo instrumental 1
- song introduction 1
- sonic effects 1
- soul music 1
- soulful singing 1
- spirited 1
- spirited vocals 1
- steady drumming rhythm 1
- strong bass line 1
- strong drumming rhythm 1
- subtle bass line 1
- tamil love songs 1
- tamil movie songs 1
- tango 1
- teen heartthrob 1
- teenage romance 1
- together forever 1
- violin accompaniment 1
- vocal vibrato 1
musiccaps_names (array) 13 ✖
- Music 6
- Humming 2
- Acoustic guitar 1
- Country 1
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Singing 1
- Telephone dialing, DTMF 1
- Tender music 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
When I Loved You (interlude)/original (a YT feature) READ INFO BOX! | A female singer sings this soulful melody. The song is slow tempo with a guitar playing a subtle bass line and no other instrumentation. The song is romantic and emotional. The song is soul music with jazz and black gospel influences. The audio quality is poor as it is recorded casually at home. | 2007-07-22T20:00:02Z | mishalmooremusic | THANK YOU ALL FOR SHOWING ME LOVE!!!! You can follow me if you'd like: http://www.twitter.com/mishalmoore My single "Oh Lord" is available at: http://www.itunes.com/mishalmoore and/or any other major music site! Be sure to rate/review if you're purchasing from Itunes!! :) Myspace: http://myspace.com/mishalmmoore WARNING: All rights reserved. © 2007 Mishal Moore Cocobread Entertaiment LLC http://twitter.com/mishalmoore http://myspace.com/mishalmmoore | ["Humming", "Music"] | ["female singer", "soulful singing", "guitar bass line", "slow tempo", "home video", "ambient room noises", "poor audio quality", "jazz music", "no percussion instruments", "subtle bass line", "emotional", "romantic", "love song", "vocal vibrato", "soul music", "black gospel influences", "guitar accompaniment", "passionate", "madly in love", "together forever"] | 1 | KjMRf4egAyA | 2112 | |
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 | |
KAKHON TOMAR AASHBEY TELEPHONE - ANJAN DUTTA | A male singer sings this spirited melody. The song is medium tempo with guitar accompaniment, telephone beep tones, steady bass line, keyboard harmony and steady drumming rhythm. The song is spirited and emotional. The song has poor audio quality. | 2012-11-24T08:55:42Z | banglaekhon | KAKHON TOMAR AASHBEY TELEPHONE - ANJAN DUTTA কখন তোমার আসবে টেলিফোন - অঞ্জন দত্ত | ["Telephone dialing, DTMF", "Music"] | ["dial tone beeps", "male singer", "bengali pop song", "bengali hits", "pop music", "romantic", "emotional", "spirited vocals", "song introduction", "private music video", "madly in love", "retro pop song", "indie music", "courtship song", "poor audio quality", "medium tempo", "guitar accompaniment", "strong drumming rhythm", "groovy music"] | 1 | WsaOJT2SsPg | 3144 | |
Nenjam Pesuthey Male Humming song | A male singer sings this soaring melody. The song is medium tempo with a guitar accompaniment, strong bass line and a violin accompaniment. The song quality is poor and badly deteriorated. The song is a romantic love song from a Tamil movie. | 2014-03-17T01:41:42Z | VENGADASSALAM K | Photo Add | ["Humming", "Music"] | ["male singer", "soaring vocals", "bad quality audio", "tamil love songs", "poor audio quality", "medium tempo", "emotional", "passionate", "madly in love", "longing for you", "tamil movie songs", "movie soundtrack", "guitar accompaniment", "violin accompaniment", "no percussion instruments", "romantic", "deteriorated audio quality", "humming", "buzzing", "romantic", "love song", "spirited", "passionate", "bollywood music", "strong bass line"] | 1 | k3A5xX8yfig | 4295 | |
Harry Styles | Best Vocals [Part 2] | A male singer sings various songs in live audience situations. The songs have a different tempo and are mostly accompanied by a band. The songs are sung at live venues with people screaming and cheering. The songs are modern pop hits , recorded in poor audio quality with hissing noises. | 2013-08-20T05:03:21Z | fr0zenintimeee | follow me i follow back :) ♡ https://twitter.com/fr0zentweets ♡ Tumblr: http://http://harryfml.tumblr.com/ (1D blog) i don't own any of these videos. I don't own any rights to this song. No copyright intended. | ["Singing", "Music", "Pop music", "Whoop"] | ["poor audio quality", "hissing noises", "pop star sings live", "live shows", "emotional", "passionate", "crowds cheering", "guitar accompaniment", "pop hits", "romantic", "girls screaming", "packed stadium", "pop hits", "teen heartthrob", "modern pop hits", "love songs", "romantic", "madly in love", "modern love", "teenage romance"] | 1 | pNlrM-GhFZU | 4705 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 |
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;