musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- instrumental · 4 ✖
- live performance · 4 ✖
- violin · 4 ✖
- cello 3
- orchestra 2
- profound 2
- vibrant 2
- accordion 1
- arabic 1
- baroque 1
- bass guitar 1
- bassoon 1
- cheerful 1
- cimbalom 1
- clarinet 1
- clasical music 1
- classical music 1
- compelling 1
- concert 1
- contrabass 1
- dramatic 1
- eastern sounding 1
- elegant 1
- exquisite 1
- flute 1
- french horn 1
- gloomy 1
- impressionist 1
- intense 1
- live orchestra 1
- melancholic 1
- ney 1
- oud 1
- percussion 1
- piano 1
- playful 1
- qanun 1
- rich 1
- romanian folk music 1
- slow tempo 1
- string quartet 1
- symphony 1
- trumpets 1
- viola 1
- western classic 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Galati - Petrecere cu lautari, Crama Lautarilor Galati, 25.11.2011 - Clip 2 - www.djgalati.ro | This is a Romanian folk music piece. It is a live performance. In the background, there is a contrabass and a cimbalom playing. The main melody is being played by the violin and the accordion. The atmosphere is vibrant and cheerful. This piece could be used in the soundtrack of a comedy movie that takes place in eastern Europe or the Balkans, especially during an escape scene. | 2012-01-02T00:50:03Z | Dj Galati Dj Nunta Galati | http://www.djgalati.ro - Sonorizare Echipa DjGalati - Petrecere cu lautari http://www.hotelmagnus.ro/crama.html - Crama Lautarilor Galati - 25.11.2011 *** Voce : Gicu Petrache - Clarinet\Saxofon : George Udila - Tambal : Florica Sandor - Acordeon : Costel de la Bolintin - Vioara : Dorel Zamfir - Bas : Tica | ["Wind instrument, woodwind instrument", "Accordion"] | ["romanian folk music", "live performance", "instrumental", "cimbalom", "contrabass", "violin", "accordion", "vibrant", "playful", "cheerful"] | 9 | 0ewWspUqB6Y | 195 | |
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 | |
Claude Debussy: Quartet in G Minor, Op. 10 - 4th Mvmt. | This is a live performance of a classical music piece from the impressionist school. It is being performed by a string quartet of two violins, one viola and one cello. The quartet is playing a dramatic tune. The atmosphere is gloomy. This piece could be used in the soundtrack of a drama movie during tragic scenes. | 2006-12-05T01:46:20Z | mashaskripka | Debussy Quartet in G Minor, Op. 10 Tres modere -- tres mouvemente et avec passion. First Violin - Maria Bessmeltseva, second violin - Paris Paraschoudis, Viola - Jesse Griggs, Cello - Heather Scott | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["classical music", "live performance", "impressionist", "instrumental", "string quartet", "violin", "viola", "cello", "dramatic", "profound", "gloomy"] | 9 | WSMdqFEjGXE | 3095 |
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;