musiccaps_details (view)
3 rows where musiccaps_aspects contains "cello", musiccaps_aspects contains "classical" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- cello · 3 ✖
- classical · 3 ✖
- live performance · 3 ✖
- concert 2
- elegant 2
- exquisite 2
- fast tempo 2
- instrumental 2
- live audience 2
- orchestra 2
- allegro 1
- allergissimo 1
- baroque 1
- brass band 1
- captivating 1
- chamber music 1
- chamber orchestra 1
- compelling 1
- conductor 1
- delicate 1
- electrifying 1
- enchanting 1
- engaging 1
- english dance 1
- enthralling 1
- extravagant 1
- flute 1
- french horn 1
- full bodied 1
- intense 1
- italian classical 1
- lively 1
- lively trumpets 1
- merry 1
- movie music 1
- paino accompaniment 1
- pulsating 1
- rich 1
- smooth 1
- spectacular 1
- strings section 1
- symphony 1
- tarantella 1
- trombone 1
- vibrant 1
- vigorous 1
- vigorous clarinet solo 1
- viola 1
- violin solo 1
- violin symphony 1
- violins 1
- western classical 1
- wind instrument 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Claude Debussy Premiere Rhapsodie performed by Hakan Rosengren | This music is a Western Classical Instrumental. The music is fast tempo with a plethora of instrumentation. From a vigorous clarinet solo, flute, intense trumpets , violin symphony, cello, viola and French horns, this music is a treat to the ears. It is smooth, rich, full bodied, exquisite and elegant with an urgent and sombre vibe. | 2011-04-05T02:40:59Z | MyFullertonAccount | Hakan Rosengren in a live performance with Minas Gerais Symphony conducted by Marcelo Ramos | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "fast tempo", "orchestra", "live performance", "concert", "live audience", "full bodied", "exquisite", "rich", "smooth", "elegant", "vigorous clarinet solo", "wind instrument", "violins", "lively trumpets", "brass band", "french horn", "conductor", "trombone", "flute", "cello", "classical", "western classical", "intense", "vigorous", "engaging", "compelling"] | 7 | aPAa2sfhS7k | 3535 | |
Antonio Vivaldi Concerto for Violin in D minor 'Per Pisendel' RV 242 | This music is a rich Italian Classical Orchestra. The tempo is fast with a symphonic orchestra with a rich ,animated violin solo, complete with violin, cello viola , flute and piano accompaniment . This music is a sonic treat. It is rich, expressive, exquisite, spectacular, enthralling and captivating. This music is a Baroque classical. | 2011-12-10T06:57:27Z | Ahmed Barod | ["Orchestra"] | ["instrumental", "fast tempo", "orchestra", "allergissimo", "allegro", "symphony", "violin symphony", "violin solo", "italian classical", "violin solo", "cello", "viola", "classical", "exquisite", "delicate", "merry", "enchanting", "captivating", "enthralling", "baroque", "english dance", "chamber music", "extravagant", "spectacular", "pulsating", "electrifying", "live performance", "live audience", "concert", "paino accompaniment"] | 7 | adHhqDnyZv8 | 3561 | ||
BOTTESINI, Tarantella | Božo Paradžik & Budapesti Vonósok | This is a live performance classical music piece played by a chamber orchestra. It is in the style of a tarantella, which is a genre of Italian folk music. The strings section is playing the melody with a cello as the lead. The atmosphere is lively and elegant. It could be used in the soundtrack of a movie especially during a scene involving a pursuit, a face-off or a duel. | 2015-07-30T22:18:34Z | bozoparadzikcom | Haydn Festival in Fertöd (H), LIVE 24th July 2015 (encore piece) Eszterházy Castle, Marionett Theater Giovanni Bottesini (1821-1889), Tarantella orchestrated and edited by Božo Paradžik Božo Paradžik, soloist Budapest Strings Chamber Orchestra / artistic leader: János Pilz (concertmaster) Dear visitors, please mind that I don't use Google+ with this account, so I am since 2014 not able to answer any comments or posts here anymore. I don't want to upgrade my channel to G+. End of July 2015 Google has announced to remove the enforcing of using G+ for YouTube users, but so far without any effect. | ["Cello", "Double bass", "String section", "Bowed string instrument"] | ["classical", "tarantella", "chamber orchestra", "live performance", "strings section", "cello", "lively", "vibrant", "elegant", "movie music"] | 9 | w0A-4EbkVz8 | 5228 |
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;