musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "love song", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "vocal harmony"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
*NSYNC - (God Must Have Spent) A Little More Time On You (Videoclip) | Male singers sing this vocal harmony. The tempo is medium with a steady drumming rhythm, various percussion tones, keyboard accompaniment, steady bass line and tambourine percussion. The song is soothing and romantic. The song is a retro pop hit. | 2009-10-25T06:55:08Z | NSYNCVEVO | 'N SYNC's official music video for '(God Must Have Spent) A Little More Time On You'. Click to listen to 'N SYNC on Spotify: http://smarturl.it/NSYNCSpot?IQid=NSYNCGMH As featured on *NSYNC: Greatest Hits. Click to buy the track or album via iTunes: http://smarturl.it/NSYNCGreatestHits?IQid=NSYNCGMH Google Play: http://smarturl.it/GMHGPlay?IQid=NSYNCGMH Amazon: http://smarturl.it/NSYGHAmazon?IQid=NSYNCGMH More From 'N SYNC It's Gonna Be Me: https://youtu.be/GQMlWwIXg3M This I Promise You: https://youtu.be/6thmPrTxBtI Pop: https://youtu.be/TWZKw_MgUPI More great 00s videos here: http://smarturl.it/Ultimate00?IQid=NSYNCGMH Follow 'N SYNC Facebook: https://www.facebook.com/nsync Twitter: https://twitter.com/nsync Subscribe to 'N SYNC on YouTube: http://smarturl.it/NSYNCSub?IQid=NSYNCGMH --------- Lyrics: Yeah.... Oh yes Ohhh..yeah.. Can this be true? Tell me, can this be real? How can I put into words what I feel? My life was complete I thought I was whole Why do I feel like I'm losing control? I never thought that love could feel like this and you've changed my world with just one kiss. How can it be that right here with me there's an angel? It's a miracle... Your love is like a river Peaceful and deep Your soul is like a secret That I never could keep When I look into your eyes I know that it's true God must have spent... A little more time On you... (A little more time, yes he did baby) | ["Music of Asia", "Music"] | ["boy band", "male singers", "vocal harmony", "retro pop hits", "singing parts", "medium tempo", "keyboard accompaniment", "steady drumming rhythm", "steady bass line", "tambourine percussions", "love song", "romantic", "passionate", "groovy music", "inspiring", "passionate", "spirited", "soothing", "relaxing", "comforting", "bells percussions"] | 1 | -fxh7jAJR8U | 73 | |
'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 | |
SHOUT - The Fabsisters [Cover Of - The Isley Brothers/Lulu] | A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. | 2012-02-22T18:56:06Z | The Fabsisters | Please watch: "The Drinks are all on him-Folake (The Fabsisters)" https://www.youtube.com/watch?v=pTs3mNrht_4 -~-~~-~~~-~~-~- Please watch: "The Fabsisters - Can't Be With You Tonight" ➨ https://www.youtube.com/watch?v=lG1ce8BrEQ4 | ["Music", "Whoop", "Yell"] | ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] | 1 | qpt3umHYfmY | 4824 |
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;