musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "electronic percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- bass guitar · 3 ✖
- electric guitar 3
- electronic percussion · 3 ✖
- electronic drums 2
- female vocal 2
- carnatic music 1
- complex 1
- eccentric 1
- indian pop music 1
- indo-european fusion 1
- keyboard 1
- live performance 1
- male vocal 1
- medium-to-high pitch singing 1
- melodic singing 1
- piano 1
- religious 1
- repeated theme 1
- sentimental 1
- simple 1
- unique 1
- virtual sounding brass 1
musiccaps_names (array) 7 ✖
- Music 3
- Carnatic music 1
- Jazz 1
- Music of Bollywood 1
- Sad music 1
- Singing 1
- Song 1
youtube_published (date) 3 ✖
- 2007-09-20 1
- 2010-10-15 1
- 2015-05-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tere Bina Official Full Music Video - Avina Shah | This is an Indian pop music piece. The female vocalist is singing in a heart-touching manner. The electric guitar is playing a gentle melody. The bass guitar is supporting the melodic background. The electronic drums and the electronic percussion provide a mid tempo rhythmic background. The overall atmosphere of the piece is sentimental. It could be used in the soundtrack of a Bollywood drama. | 2010-10-15T17:03:01Z | AvinaShah | Download on iTunes:- http://itunes.apple.com/us/album/tere-bina-single/id400736544 The Official Music Video of Avina Shah's debut single 'Tere Bina' (Without You). Lyrics & Translation: http://www.youtube.com/watch?v=mncG95MTZtw Featuring a unique combination of Avina's angelic vocals with heart-touching lyrics and a super-catchy chorus, this song raises awareness on the delicate issue of domestic violence. Proceeds from the single will be donated to West London based charity the Southall Black Sisters (SBS). Video Directed by: Carolina Voncosta (Eastern Illusion Media) Produced by: Knightstarr Productions Click Here to Subscribe :- http://bit.ly/AvinaShah Follow us on :- Facebook - https://www.facebook.com/avinashah Twitter - https://twitter.com/avinashah Instagram - https://www.instagram.com/avinashah Website - http://avinamusic.com | ["Jazz", "Music"] | ["indian pop music", "female vocal", "sentimental", "electric guitar", "bass guitar", "electronic drums", "electronic percussion", "repeated theme", "simple"] | 9 | 60OIHit4Q-M | 714 | |
LISTEN Fusion Music Indian Carnatic ERA NAPAI & RARA VENU | This is a Indo-European fusion music piece. There is a mix of Carnatic music with Western sounding elements. There is a female vocalist singing at a medium-to-high pitch. The melody consists of a variety of intertwined sounds such as a piano, an electric guitar, a bass guitar and a virtual sounding brass section. The rhythmic background is provided by electronic percussive elements. There is an eccentric atmosphere to this piece. It sounds unique. | 2007-09-20T10:42:07Z | jaikumarnargunam | LISTEN INDIAN classical music carnatic ERA NAPAI & RARA VENU set to fusion with European Western by N.JAIKUMAR Cine musician / Indo European Fusionist from Chennai INDIA. S.P.Sailaja sings | ["Carnatic music", "Music", "Song", "Music of Bollywood"] | ["indo-european fusion", "carnatic music", "female vocal", "medium-to-high pitch singing", "piano", "electric guitar", "bass guitar", "virtual sounding brass", "electronic percussion", "eccentric", "complex", "unique"] | 9 | ZLxhZcS3Ppw | 3366 | |
hebron song ''gorepilla'' sung by brp.p.suresh, music by bro.stephen | This is a live performance of a religious song. There is a male vocalist singing melodically as the lead. The main melody is being played by the keyboard with the electric guitar and the bass guitar in the background. The rhythmic background is provided by the electronic drums and the electronic percussion. The piece has movements reminiscent of Jewish music. | 2015-05-01T09:06:39Z | Dr. Suresh David | ["Singing", "Music", "Sad music"] | ["live performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "electronic percussion", "keyboard", "religious"] | 9 | teyDfFbVMSY | 5056 |
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;