musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "madly in love" and musiccaps_aspects contains "passionate" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 72 ✖
- love song 5
- madly in love · 5 ✖
- passionate · 5 ✖
- romantic 5
- poor audio quality 4
- emotional 3
- female singer 3
- medium tempo 3
- guitar accompaniment 2
- guitar strumming 2
- male singer 2
- no percussion instruments 2
- soul music 2
- ambient crowd noise 1
- ambient room noises 1
- backup singers 1
- bad audio quality 1
- bad quality audio 1
- black gospel influences 1
- blues music 1
- blues turnaround 1
- bollywood music 1
- buzzing 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- deteriorated audio quality 1
- energetic 1
- euro pop hits 1
- fret noise 1
- groovy bas line 1
- groovy bass line 1
- guitar bass line 1
- guitar leads 1
- guitar notes playing 1
- guitar playing 1
- hissing ambient sound 1
- home video 1
- humming 1
- jazz music 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- lilting vocals 1
- live audience 1
- live performance 1
- longing for you 1
- modern country love songs 1
- movie soundtrack 1
- percussive bass line 1
- pop diva 1
- pop song 1
- pop super hits 1
- russian pop star 1
- say sorry 1
- singer talking 1
- slow tempo 1
- soaring vocals 1
- song introduction 1
- sonic effects 1
- soul singer 1
- soulful singing 1
- spirited 1
- steady drumming rhythm 1
- strong bass line 1
- subtle bass line 1
- tamil love songs 1
- tamil movie songs 1
- together forever 1
- violin accompaniment 1
- vocal harmony 1
- vocal vibrato 1
musiccaps_names (array) 8 ✖
- Music 5
- Humming 2
- /t/dd00004 1
- Exciting music 1
- Happy music 1
- Inside, large room or hall 1
- Singing 1
- Tender music 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 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
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 | |
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 |
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;