musiccaps_details (view)
1 row where musiccaps_aspects contains "arabic", musiccaps_aspects contains "oud", musiccaps_aspects contains "vibrant" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
National Arab Orchestra - Nay & Percussion Solos | This is an Arabic music piece being performed live by an orchestra. There is a new flute playing a solo in the lead. The melodic background consists of the violin, the oud, and the qanun while the cello and the bass guitar are playing in the lower range. The rhythmic background is provided by percussive elements that sound like the doumbek. The atmosphere is vibrant. This piece could be used as an opening theme for a drama movie or a TV series that takes place in the Middle East. | 2014-07-23T04:31:30Z | National Arab Orchestra | National Arab Orchestra May 31, 2014 Music Hall Center for the Performing Arts Directed by: Michael Ibrahim Raqsit Badi'a - Mohamed Abdel Wahab Violin: Adel Eskandar, Emad Ibrahim,Nady Benyamine, Katie Vandusen, Eddie Sleiman, Roberto Riggio, Sachi Yoshimoto, Insia Malik, Qusay Al-Ali, Hasan Minawi, Marandi Hostetter. Qanun: Ali Amr. Oud: Victor Ghannam. Cello, Peter Abadier. Nay Michael Ibrahim, Bass: Margaret Hasspacher. Electric Guitar. Percussion: Gurshuran "Yash" Singh Sandhu, Roger Kashou, Adam Maalouf, Dhafir Tawil, Sam Parsons. The NAO is a 501 c3 nonprofit organization. For more information on how you can help the NAO, contact us at info@michiganaraborchestra.org Educational program made possible by the Knight Foundation | ["Tabla", "Drum", "Percussion"] | ["arabic", "live performance", "orchestra", "instrumental", "ney", "violin", "qanun", "oud", "bass guitar", "cello", "percussion", "vibrant", "profound", "eastern sounding"] | 9 | FdvGsAq99r0 | 1658 |
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;