musiccaps_details (view)
5 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- passionate · 5 ✖
- passionate male vocal · 5 ✖
- sustained strings melody · 5 ✖
- low quality 4
- emotional 3
- shimmering hi hats 3
- soulful 3
- mono 2
- noisy 2
- addictive 1
- brass melody 1
- claps 1
- disco 1
- energetic crash cymbal 1
- folk 1
- funky 1
- groovy bass piano melody 1
- groovy piano melody 1
- harmonizing background female vocals 1
- harmonizing background vocals 1
- live performance 1
- muted brass melody 1
- piano chords 1
- piano melody 1
- playback 1
- punchy kick 1
- punchy snare 1
- shimmering shakers 1
- smooth bass 1
- toms roll 1
- traditional 1
- wooden percussive element 1
musiccaps_names (array) 12 ✖
- Music 4
- Bowed string instrument 1
- Carnatic music 1
- Cello 1
- Disco 1
- Double bass 1
- Inside, large room or hall 1
- Mantra 1
- Music of Asia 1
- Soul music 1
- Violin, fiddle 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RAY LEMA & JAZZ SINFÔNICA ORCHESTRA DE SAO PAULO (BRAZIL) - "TWA TAKA NINI" | The low quality recording features a passionate male vocal singing over groovy bass piano melody, muted brass melody, sustained strings melody and shimmering hi hats. It sounds passionate and soulful. | 2010-03-08T09:45:45Z | RAY LEMA | Ray Lema playing his song "Twa Taka Nini" with the Jazz Sinfônica Orquestra from São Paulo, directed by João Mauricio GALINDO - São Paulo- may 2009 | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "passionate male vocal", "groovy bass piano melody", "muted brass melody", "sustained strings melody", "shimmering hi hats", "passionate", "soulful"] | 4 | YXDHyD4HU0E | 3292 | |
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 | |
Chellak kani vaayal (“ செல்லக்கனி வாயால் ” ) by varnarameswaran | The low quality recording features a passionate male vocal singing over a wooden percussive element and sustained strings melody. It sounds emotional, passionate - like a traditional middle eastern song. | 2011-03-09T11:37:31Z | Varnarameswaran Singer & Composer | “செல்லக்கனி வாயால்” நல்லைக் கந்தன்மேல் வீரமணி ஐயர் அவர்கள் இயற்றியது. raga:Brindavani Thalam: Aathi vocal:VarnaRameshwaran, Violin: A.Jayadevan , Mirdhangam : Gowryshankar lyrics Innuvai Veeramani Iyer | ["Carnatic music", "Mantra", "Music"] | ["low quality", "wooden percussive element", "passionate male vocal", "traditional", "sustained strings melody", "passionate", "emotional", "live performance"] | 4 | e_W17jp40G4 | 3883 | |
Kaun Hai Jo Sapnon Mein Aaya | Rajendra Kumar | Saira Banu | Jhuk Gaya Aasman Songs {HD}| Mohd. Rafi | The low quality recording features a folk song that consists of passionate male vocal singing over shimmering shakers, smooth bass, sustained strings melody and groovy piano melody. It sounds emotional, soulful and passionate - like something you would hear in movies. | 2012-06-20T08:40:04Z | Shemaroo Filmi Gaane | Movie : Jhuk Gaya Aasman (1968) Song: Kaun Hai Jo Sapnon Mein Aaya Starcast: Rajendra Kumar, Saira Banu Music Director: Shanker Jaikishan Singers: Mohammad Rafi Director: Lekh Tandon SUBSCRIBE now to FilmiGaane: https://goo.gl/mx4zPe To see all the latest music playlists that we've created just for you, click here https://www.youtube.com/user/filmigaane/playlists Download FilmiGaane App - http://twd.bz/fg Connect with us on:- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle & Follow us on google.com/+filmigaane Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more: http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at connect@shemaroo.com Download the app now and share it with all the asli fans https://shemaroome.app.link/fjmW99wk3W Give a missed call on 18002665151 www.shemaroome.com Your one-stop destination for authentic Indian content now with the biggest cashback offer! Get upto 100% Paytm cashback on purchasing any pack worth Rs.129 or more! Hurry & subscribe now:https://shemaroome.app.link/Liw2f3z14bb | ["Music of Asia", "Music"] | ["low quality", "folk", "noisy", "mono", "passionate male vocal", "sustained strings melody", "shimmering shakers", "smooth bass", "groovy piano melody", "emotional", "passionate", "soulful"] | 4 | exD5okdopWc | 3911 | |
70's Disco Fever To 20 Songs | The Disco song features a passionate male vocal, alongside harmonizing background vocals, singing over sustained strings melody, piano melody, brass melody, punchy kick and snare hits, shimmering hi hats and some claps. It sounds funky, addictive and passionate - like something you would hear in clubs during the 70s. | 2010-08-16T05:53:04Z | djcrd09 | DJ CRD-These R My Top 20 Disco/Funk Groovin Songs..Enjoy..Hop U Like..Don't Forget 2 Subscribe And Comment djcrd09@yahoo.com | ["Disco", "Music", "Soul music"] | ["disco", "harmonizing background vocals", "passionate male vocal", "sustained strings melody", "piano melody", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "claps", "funky", "addictive", "passionate"] | 4 | yzjbAxCnt7U | 5451 |
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;