musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "soothing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- medium tempo · 2 ✖
- passionate · 2 ✖
- soothing · 2 ✖
- bells percussions 1
- boy band 1
- captivating 1
- comforting 1
- emotional 1
- emotional punchy bass line 1
- engaging 1
- female vocal backup 1
- funky drumming 1
- groovy 1
- groovy music 1
- impactful 1
- inspirational 1
- inspiring 1
- keyboard accompaniment 1
- keyboard harmony 1
- love song 1
- male singers 1
- male vocalist 1
- melodic 1
- persuasive 1
- reggae 1
- relaxing 1
- retro pop hits 1
- romantic 1
- sentimental 1
- singing parts 1
- spirited 1
- steady bass line 1
- steady drumming rhythm 1
- tambourine percussions 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Music of Asia 1
- Reggae 1
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 | |
Bob Marley & The Wailers - One Love / People Get Ready | A male vocalist sings this beautiful Reggae song. The tempo is medium with a keyboard harmony, punchy and infectious bass line and funky drumming with harmonic vocal backup. The song talks about world peace, kindness towards humankind and unity. The song is inspirational, passionate, youthful, emotional,persuasive,impactful, melodic , engaging and captivating. | 2015-05-16T05:31:51Z | doogie Five-Four | Track 12 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "youthful", "passionate", "emotional punchy bass line", "funky drumming", "female vocal backup", "reggae", "inspirational", "emotional", "sentimental", "persuasive", "impactful", "soothing", "melodic", "engaging", "captivating", "groovy"] | 7 | opu2tXoVNKU | 4658 |
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;