musiccaps_details (view)
4 rows where musiccaps_aspects contains "female vocal", musiccaps_aspects contains "tabla" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- female vocal · 4 ✖
- tabla · 4 ✖
- sitar 2
- bhakti 1
- carnatic classical 1
- cymbals 1
- devotional 1
- dreamy 1
- esraj 1
- gujarati folk music 1
- harmonium 1
- haunting 1
- hindu 1
- hypnotic 1
- indian folk music 1
- lively 1
- manjira 1
- medium-to-high pitch singing 1
- percussion 1
- religious 1
- repeated theme 1
- sentimental 1
- spiritual 1
- strings 1
- trippy 1
- veena-like singing 1
- vibrant 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jagadodharana | Sudha Raghunathan Songs | Carnatic Classical Music | Idea Jalsa | Art and Artistes | This is a Carnatic classical music piece. There is a female vocalist singing melodically while shifting her voice in a veena-like manner. The sitar is playing the melody and the tabla is playing the rhythm. There is a sentimental and dreamy atmosphere to this piece. | 2014-04-30T12:47:18Z | Art And Artistes | --- Click on SUBSCRIBE to get updates, and stay tuned for the richest collection of the Traditional Music of India. Concept: Durga Jasraj, follow her at: Facebook.com/DurgaJasraj Instagram.com/DurgaJasraj Twitter.com/DurgaJasraj Producers - Durga Jasraj & Neeraj Jaitly Label: Art and Artistes, follow us at: Facebook.com/ArtAndArtistes Instagram.com/ArtAndArtistes Twitter.com/ArtAndArtistes LinkedIn.com/ArtAndArtistes YouTube.com/ArtAndArtistes | ["Carnatic music", "Folk music", "Music"] | ["carnatic classical", "female vocal", "veena-like singing", "sitar", "tabla", "sentimental", "dreamy", "vibrant"] | 9 | 1JqNiV03kog | 258 | |
Dakla Farida Meer | This is a Gujarati folk song. There is a female vocalist singing in a passionate manner. The melody is being played by a harmonium. The rhythm is being played by the tabla and little cymbals. The atmosphere is lively. | 2013-06-06T13:55:43Z | gujaratidayro | ["Singing", "Middle Eastern music"] | ["gujarati folk music", "female vocal", "harmonium", "tabla", "cymbals", "lively"] | 9 | JUwu4xOs8K4 | 2013 | ||
Hayati - Jah Wobble & Temple of sound ft.Shahin Badar | This is an Indian folk music piece. There is a haunting female vocal in the lead. There is a group of strings which sound similar to Esraj being heard playing the main tune. In the rhythmic background, there are bell percussion that sound like manjira and membranous percussion that sound like tabla. The atmosphere is trippy. This piece could be used in the soundtrack of an exotic movie or could be sampled to be used in beat-making. It could also be playing in the background of an Indian cuisine restaurant. | 2013-02-07T03:16:47Z | Shahin Badar | HAYATI - Jah Wobble & Temple of Sound Ft.Shahin Badar- Listen to the haunting vocals of Shahin Badar as you have already heard her on Prodigy's No.1 single smack my bitch up ,Tim deluxe's Mundaya & Ar Rahman's Dol Dol & many others .She was invited by the legendary Jah Wobble ( Invaders of the hearts) to collabrate on this wonderful production of Hayati (My Life) .Official music video taken from the Album Shout at the devil.Also released on various lounge Albums/compilations around the world. Video directed by John Wilmor. Actor - Vikas Bhardwarj Location - Mumbai(India) Copyright 30herts Records www.30hertzrecords.com www.shahinbadar.com | ["Music of Asia", "Music", "Middle Eastern music", "Music of Bollywood"] | ["indian folk music", "female vocal", "haunting", "strings", "esraj", "percussion", "manjira", "tabla", "repeated theme", "trippy", "hypnotic"] | 9 | OzaVvthCvtk | 2488 | |
Shri Durga Stuti Paath Vidhi By Anuradha Paudwal [Full Song] - Shri Durga Stuti | This is a Hindu music piece. There is a female vocalist singing at a medium-to-high pitch in a devotional manner. A sitar provides a melodic background. The tabla is being played in the rhythmic background. The atmosphere is spiritual. This piece could be played at religious events and online content related to Hindu religion. | 2011-05-23T12:48:02Z | T-Series Bhakti Sagar | #AnuradhaPaudwal Song: Shri Durga Stuti Paath Vidhi Title: Shri Durga Stuti Singer: Anuradha Paudwal Music Director: Shekhar Sen Lyricist: Pandit Chama Lal Bhardwaj Chaman, Music Label: T-Series If you like the video Please don't forget to share with others. Please share you views. Click To Subscribe: http://www.youtube.com/tseriesbhakti Facebook: http://www.facebook.com/tseriesmusic Twitter: http://www.twitter.com/_Tseries If You like the video don't forget to share with others & also share your views. Stay connected with us!!! ► Subscribe: http://www.youtube.com/tseriesbhakti ► Like us on Facebook: https://www.facebook.com/BhaktiSagarTseries/ ► Follow us on Twitter: https://twitter.com/tseriesbhakti For Spiritual Voice Alerts, Airtel subscribers Dial 589991 (toll free) To set popular Bhakti Dhun as your HelloTune, Airtel subscribers Dial 57878881 facebook: https://www.facebook.com/BhaktiSagarTseries/ | ["Carnatic music", "Music"] | ["hindu", "female vocal", "medium-to-high pitch singing", "sitar", "tabla", "bhakti", "spiritual", "devotional", "religious"] | 9 | cS2gRhH6it4 | 3707 |
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;