musiccaps_details (view)
5 rows where musiccaps_aspects contains "passionate", musiccaps_author = 1 and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 81 ✖
- passionate · 5 ✖
- vocal harmony 3
- devotional 2
- emotional 2
- exciting 2
- female singers 2
- groovy music 2
- inspiring 2
- medium tempo 2
- spirited 2
- steady drumming rhythm 2
- tabla playing percussively 2
- tambourine percussions 2
- ancient traditional music 1
- bells percussions 1
- boy band 1
- carnatic music 1
- choral chants 1
- classical singing style 1
- comforting 1
- congregation singing 1
- dance hit 1
- dance rhythm 1
- enthusiastic 1
- female backup singers 1
- festival 1
- flute countermelody 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- hare krishna 1
- harmonium solo 1
- heartfelt 1
- hindustaani music 1
- indian classical music 1
- indian music 1
- instrumental music 1
- instruments in unison 1
- j-pop 1
- k-pop 1
- keyboard accompaniment 1
- keyboard harmony 1
- live audience 1
- live concert 1
- live performance 1
- love song 1
- male singers 1
- me drum fats tempo 1
- meditational 1
- party all night 1
- party song 1
- people cheering 1
- people clapping 1
- poor audio quality 1
- pop dance hits 1
- pop divas 1
- pop hits 1
- pop love hits 1
- prayers 1
- relaxing 1
- religious 1
- retro pop hits 1
- romantic 1
- singing parts 1
- sitar accompaniment 1
- soothing 1
- steady bass line 1
- steady techno drumming rhythm 1
- stringed indian instruments 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- tamil devotional songs 1
- traditional indian instruments 1
- trance 1
- unison singing 1
- violin playing 1
- vocal duo 1
- whistling tones 1
- y traditional indian instruments 1
musiccaps_names (array) 10 ✖
- Music 5
- Music of Asia · 5 ✖
- Bowed string instrument 1
- Carnatic music 1
- Classical music 1
- Mantra 1
- Musical instrument 1
- Rattle (instrument) 1
- Sitar 1
- Tabla 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 | |
2NE1_0721_SBS Inkigayo_FALLING IN LOVE_No.1 of the Week | A female singer sings this cool pop melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, and keyboard accompaniment . The song is exciting and youthful. The audio quality with a lot of ambient crowd noises. | 2013-07-21T08:52:26Z | 2NE1 | Copyrightⓒ2013 SBS Contents Hub Co.,Ltd. & YG Entertainment Inc. All rights reserved. 2NE1 NEW SINGLE [FALLING IN LOVE] ▶ iTunes: http://smarturl.it/2NE1FallingInLove ▶ eBay: http://stores.ebay.com/YG-Entertainment ▶ YG-eshop: http://www.ygeshop.com ▶ YG-eshop (China): http://cn.ygeshop.com "Double Park TV" : http://smarturl.it/DoubleParkTV For More Information @ http://www.facebook.com/2ne1 http://twitter.com/ygent_official http://twitter.com/globalblackjack http://me2day.net/ygonair http://www.yg-2ne1.com App Store: http://goo.gl/l9TU6 Google Play: http://goo.gl/UiEn1 | ["Music of Asia", "Music"] | ["k-pop", "j-pop", "female singers", "female backup singers", "pop love hits", "pop dance hits", "whistling tones", "live performance", "vocal harmony", "groovy bass line", "steady drumming rhythm", "keyboard harmony", "emotional", "exciting", "enthusiastic", "passionate", "party song", "dance hit", "pop hits", "pop divas", "party all night", "people cheering", "groovy"] | 1 | 1xhwyUVSRQk | 318 | |
Parvai ondre pothume - Carnatic Fusion Tamil Kannan Song by S. J. Jananiy | Female singers sing this vocal in Tamil harmony. The song is medium tempo with a strong techno drumming rhythm, guitar accompaniment, stringed instrument accompaniment, flute countermelody, and a strong bass line. The song is devotional and highly passionate. The song is a Carnatic Hindu devotional song sung in Tamil. | 2010-02-08T22:06:22Z | Saumi Music | Sharing another beautiful carnatic fusion sung by S.J. Jananiy. Follow us on Facebook: https://www.facebook.com/pages/Gnanalayam-Berlin/246868511997333 | ["Carnatic music", "Music of Asia", "Music", "Classical music"] | ["carnatic music", "female singers", "vocal harmony", "guitar accompaniment", "stringed instrument harmony", "emotional", "passionate", "meditational", "devotional", "heartfelt", "classical singing style", "vocal duo", "tamil devotional songs", "prayers", "flute countermelody", "guitar accompaniment", "stringed instrument countermelody", "strong bass line", "steady techno drumming rhythm"] | 1 | ROA6DMBPlNM | 2695 | |
HARE KRSNA - MAHA MANTRA KIRTAN 7 | People chant and sing in unison. The song is medium fast tempo with Indian percussion playing fast, violins and other stringed instruments playing harmony along with people clapping. The song is meditational and spirited. The audio quality is poor. | 2010-04-10T10:45:05Z | mitcmantraable | HH Indradyumna Swami HARE KRSNA | ["Mantra", "Music of Asia", "Music", "Rattle (instrument)"] | ["congregation singing", "unison singing", "poor audio quality", "people clapping", "indian music", "festival", "religious", "choral chants", "me drum fats tempo", "tambourine percussions", "tabla playing percussively", "stringed indian instruments", "violin playing", "trance", "hare krishna", "inspiring", "devotional", "passionate", "spirited", "groovy music"] | 1 | ZCKzgf3QD4M | 3346 | |
Young Afghan Traditional Ensemble: Naghmadokhana; Kabul 2013 | The song is instrumental. The tempo is medium with sitars and other stringed instruments playing in unison, tabla percussions and a harmonium playing the lead. The song is a classic hindustaani instrumental. | 2015-03-11T17:09:41Z | Safar Hochschule | Comp: Ustad Mohammad Omar, Rag Bahari, Tal Dadra FazilaZamir, Rohullah Baqizada, Samihullah Sarwari, Ahmadullah Nabizada, Ahmad Samim Zafar, Mostafa Darwishi, Eraj Khorasani | ["Tabla", "Music of Asia", "Music", "Musical instrument", "Sitar", "Bowed string instrument"] | ["instrumental music", "harmonium solo", "traditional indian instruments", "indian classical music", "tabla playing percussively", "sitar accompaniment", "y traditional indian instruments", "groovy rhythm", "exciting", "instruments in unison", "dance rhythm", "ancient traditional music", "passionate", "live concert", "live audience", "medium tempo", "hindustaani music"] | 1 | qsFfUzErXqw | 4829 |
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;