musiccaps_details (view)
8 rows where musiccaps_aspects contains "madly in love", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- madly in love · 8 ✖
- passionate · 8 ✖
- romantic · 8 ✖
- love song 6
- emotional 5
- medium tempo 5
- poor audio quality 5
- female singer 3
- guitar accompaniment 3
- guitar strumming 2
- lilting vocals 2
- male singer 2
- movie soundtrack 2
- no percussion instruments 2
- soaring vocals 2
- soul music 2
- spirited 2
- together forever 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
- bossa nova 1
- buzzing 1
- cello playing 1
- …
musiccaps_names (array) 15 ✖
- Music 8
- Humming 2
- Singing 2
- /t/dd00004 1
- Exciting music 1
- Happy music 1
- Inside, large room or hall 1
- Keyboard (musical) 1
- Musical instrument 1
- Opera 1
- Piano 1
- Pop music 1
- Synthesizer 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 |
---|---|---|---|---|---|---|---|---|---|---|
'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 | |
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 | |
Korg PA900 vs Roland BK9 Keyboard | The song is an instrumental. The song is medium tempo with various Latin percussion playing groovily to the sounds of a Rhodes organ melody. The song is romantic and passionate. The soundtrack is a demonstration for a keyboard model. | 2013-10-16T18:45:43Z | A&C Hamilton Musical Instruments | http://www.achamilton.co.uk/Korg/PA900/index.htm We thought we should do a quick video comparison of the Korg PA900 and Roland BK-9. This is just a small example of similar styles and sounds in the instruments. Which would you prefer? | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["latin dance groove", "bossa nova", "giro", "madly in love", "passioante affair", "old school romance", "passionate affair", "medium tempo", "latin percussion instruments", "memdium tenpo", "rhodes organ", "various percussion hits", "latin jazz music", "latin dancers", "romantic", "party time", "fiesta", "romantic", "spirited", "passionate", "keyboard styles", "instrumental music", "music keyboard demo"] | 1 | LKVSEQCLCLo | 2177 | |
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 | |
Fifty Shades Of Grey (2013) | Teaser Trailer | A female singer sings this operatic melody. The song is medium tempo with a string section playing harmony and a piano accompaniment. The song is emotional and passionate. The song is a classic western music hit and a movie soundtrack. | 2012-06-13T15:16:41Z | JLongbone | **WATCH IN HD** (NEW!! Jamie Dornan/Dakota Johnson version: https://www.youtube.com/watch?v=ddPxOJZKQmQ) **Fan made teaser** Song from trailer: http://www.youtube.com/watch?v=YBt-9LhE8ms | ["Music", "Opera"] | ["female opera singer", "medium tempo", "lilting vocals", "madly in love", "together forever", "movie soundtrack", "soaring vocals", "string section harmony", "violins", "piano accompaniment", "cello playing", "conductor", "emotional", "tragic", "passionate", "romantic", "love song", "sensual"] | 1 | TnJE6W6Z6mM | 2865 | |
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 |
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;