musiccaps_details (view)
2 rows where musiccaps_aspects contains "def" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- def · 2 ✖
- bass 1
- devotional 1
- exotic 1
- female voice 1
- instrumental 1
- ney flute 1
- oriental dance 1
- oud 1
- pakistani sufi music 1
- percussion 1
- religious 1
- sensual 1
- spiritual 1
- tambourine 1
- vibrant 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shehr e Zaat Original Soundtrack - HUM TV [High Quality] | This is a Pakistani Sufi music piece. There is a female voice singing in a devoted manner. A bass tune can be heard supporting the vocals. The rhythm is performed by a membranous percussion, most probably a def. The atmosphere is religious. This piece could be played at Sufi religious events. | 2012-06-29T16:17:31Z | Abid Naseem | Amazing song by Abida Parveen Ji. This is now the official soundtrack for new HUM TV drama "Shehr-e-Zaat" Casting popular Mahira Khan (Humsafar Girl) and directed by Sarmad (Humsafar Genius). Enjoy! | ["Music", "Middle Eastern music"] | ["pakistani sufi music", "female voice", "bass", "percussion", "def", "religious", "spiritual", "devotional"] | 9 | bg_QoesbfOA | 3642 | |
Snake Dance | This is an Oriental dance music piece. It is an instrumental piece. There is an oud and a new flute playing the melody. The rhythmic background is composed of percussive elements such as the def and the tambourine. The atmosphere is exotic and sensual. This piece could be used in the soundtrack of movies that take place in the Middle East region. | 2010-10-03T09:53:01Z | Myss Foss | The Snake Dance which is part of Belly Dancing has always been liked by people of many cultures . The song is composed by Mohamed Abdel Wahab - Zeina Zeina is a great song to listening to. This Video is a tribute to all past/present women who fell in the love with the art of Belly Dancing over the ages. Hope you all enjoy... @myssfoss I would like to thank Mozar Zaryabe for telling me the name of the song and it's composer. The last seven years it's been called Snake Dance because that was the only information given to me. Now we know... "Zeina Zeina" thanks Mozar. | ["Folk music", "Music"] | ["oriental dance", "instrumental", "ney flute", "oud", "tambourine", "def", "exotic", "sensual", "vibrant"] | 9 | uRA5Ue30fsY | 5113 |
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;