musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "orchestra" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- live performance · 4 ✖
- orchestra · 4 ✖
- violin · 4 ✖
- cello 2
- eastern sounding 2
- instrumental 2
- oud 2
- percussion 2
- vibrant 2
- arabic 1
- baroque 1
- bass guitar 1
- bassoon 1
- claps 1
- clarinet 1
- clasical music 1
- classical music 1
- compelling 1
- concert 1
- darbuka 1
- elegant 1
- exquisite 1
- flute 1
- french horn 1
- heart-touching 1
- intense 1
- khaliji music 1
- live orchestra 1
- melancholic 1
- ney 1
- piano 1
- profound 1
- qanun 1
- rich 1
- riq 1
- sentimental 1
- slow tempo 1
- symphony 1
- trumpets 1
- western classic 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nane Tsora | This music is a western classical. The tempo is slow with violins, trumpets, flute, cello. Viola, bassoon harmony. The music is soft, mellow, mellifluous, rich, elegant and exquisite. This is a live performance/concert. | 2007-05-23T12:20:55Z | ErnestNBE | Gipsy tradtional played by the NBE (www.nbe.nl) in the 2005 New Year's Concert in the Concertgebouw Amsterdam. Soloist on bass trombone is Brandt Attema. | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "slow tempo", "orchestra", "rich", "elegant", "exquisite", "compelling", "concert", "piano", "flute", "live performance", "live orchestra", "symphony", "rich", "melancholic", "trumpets", "violin", "cello", "clarinet", "bassoon", "french horn", "baroque", "intense", "western classic", "clasical music"] | 7 | 8y36aT4C_c0 | 961 | |
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 | |
خالد الملا على كثر | This is a live performance of a Khaliji music piece. There is an orchestra performing the piece. The melody is being played by the oud and the violin. The rhythmic background is composed of various percussive elements such as the riq, the darbuka and performers clapping their hands. The atmosphere is vibrant. This piece could be playing in the background at an Arab cuisine restaurant. | 2012-12-22T12:53:27Z | saaa64 | المطرب خالد الملا حضرميه على كثر | ["Traditional music", "Music", "Musical instrument", "Middle Eastern music", "Plucked string instrument", "Bowed string instrument"] | ["khaliji music", "live performance", "orchestra", "violin", "oud", "percussion", "riq", "darbuka", "claps", "vibrant", "eastern sounding"] | 9 | MHHshnnqyco | 2251 | |
Nicola Benedetti plays Bruch at the Last Night of the Proms 2012 | This is a live performance of a classical music piece. There is an orchestra performing the piece with a violin lead playing the main melody. The atmosphere is sentimental and heart-touching. This piece could be playing in the background at a classy restaurant. | 2012-09-10T19:04:24Z | ecodef | Violin concerto No. 1 in G minor, by Bruch soloist: Nicola Benedetti conductor: Jiri Belohlavek BBC Symphony Orchestra recorded @ the Royal Albert Hall, London (8 sept. 2012) | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["classical music", "live performance", "orchestra", "violin", "sentimental", "heart-touching"] | 9 | XmMN-6g1L8w | 3222 |
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;