musiccaps_details (view)
5 rows where musiccaps_aspects contains "cello" and musiccaps_aspects contains "compelling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- cello · 5 ✖
- compelling · 5 ✖
- instrumental 4
- orchestra 4
- concert 3
- elegant 3
- exquisite 3
- fast tempo 3
- flute 3
- live performance 3
- rich 3
- viola 3
- baroque 2
- brass band 2
- classical 2
- engaging 2
- enthralling 2
- french horn 2
- intense 2
- melancholic 2
- slow tempo 2
- symphony 2
- western classical 2
- amplified violin 1
- anxious 1
- bassoon 1
- bow stringed instrument 1
- bright 1
- bright trumpets 1
- burgeoning 1
- captivating 1
- celestial 1
- celestial music 1
- chaotic 1
- clarinet 1
- clasical music 1
- commanding 1
- complex notes 1
- conductor 1
- contrasting harmonies 1
- delicate 1
- delightful 1
- eloquent piano accompaniment 1
- enigmatic 1
- enthusiastic drumming 1
- ethereal 1
- female singer 1
- full bodied 1
- gripping 1
- harpsichord 1
- instrumental ensemble 1
- interlude in song 1
- italian composition 1
- live audience 1
- live orchestra 1
- lively trumpets 1
- loosely structured music 1
- melodious violin symphony 1
- mesmerising 1
- people talking 1
- piano 1
- piano accompaniment 1
- powerful vocals 1
- restless 1
- smooth 1
- sonic treat 1
- soothing 1
- syncopated harmony 1
- trombone 1
- trumpets 1
- vigorous 1
- vigorous clarinet solo 1
- violin 1
- violin harmony 1
- violins 1
- vocalisation in background 1
- western classic 1
- wind instrument 1
musiccaps_names (array) 10 ✖
- Brass instrument 2
- Clarinet 2
- Music 2
- Trombone 2
- Harpsichord 1
- Keyboard (musical) 1
- Orchestra 1
- Singing 1
- Tender music 1
- Theme music 1
youtube_published (date) 5 ✖
- 2007-05-23 1
- 2009-09-27 1
- 2010-01-28 1
- 2011-03-16 1
- 2011-04-05 1
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 | |
The Chris Moyles Show - Epic jingle | This music is instrumental . The tempo is fast with a burst of harmonious instrumentation. The music is orchestral with animated trumpets, melodious violin symphony, enthusiastic drumming, piano accompaniment and male vocalisation in the background. The music is bright, lively, powerful, commanding, fluent, gripping ,compelling and a delight to the ears. | 2010-01-28T16:04:32Z | LeChuckie | What a great piece of music! | ["Theme music", "Music", "Orchestra"] | ["instrumental", "fast tempo", "bright", "gripping", "compelling", "delightful", "commanding", "enthralling", "orchestra", "bright trumpets", "bow stringed instrument", "cello", "viola", "vocalisation in background", "burgeoning", "instrumental ensemble", "sonic treat", "brass band", "melodious violin symphony", "enthusiastic drumming"] | 7 | GcqCHmHXEjo | 1744 | |
Celine Dion - Live in Las Vegas 2011 - Open Arms | A female vocalist sings this enchanting song.the tempo is slow with this clip opening with the vocalist almost ending the sentence. The singer is accompanied by mesmerising Violin symphony and piano accompaniment . This song is a live performance as it is sung with an orchestra and there is the sound of people talking. The song is enchanting, ethereal, captivating, soothing and celestial. | 2011-03-16T14:38:34Z | Woodsy | 15/03/11 - Celine Dion sings "Open Arms" live in Las Vegas on her new tour. Please comment, like and subscribe, thanks! | ["Singing", "Music", "Tender music"] | ["female singer", "slow tempo", "violin harmony", "live performance", "concert", "orchestra", "celestial", "cello", "viola", "symphony", "orchestra", "celestial music", "ethereal", "soothing", "rich", "eloquent piano accompaniment", "ethereal", "compelling", "enigmatic", "mesmerising", "captivating", "interlude in song", "powerful vocals", "live performance", "people talking"] | 7 | MROotmz8a-U | 2267 | |
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 | |
Caprice - The Court of Faerie | This music is instrumental. The tempo is fast with a spirited harpsichord, contrasting melancholic violin harmony, flute, cello , viola and piano accompaniment. The music is complex, syncopated , melancholic, wistful, anxious and restless. This music is a Western Classical Piece. | 2009-09-27T14:21:26Z | 2ndhead1 | The Court of Faerie | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "amplified violin", "restless", "contrasting harmonies", "viola", "anxious", "harpsichord", "flute", "piano accompaniment", "cello", "loosely structured music", "italian composition", "classical", "western classical", "baroque", "elegant", "exquisite", "delicate", "syncopated harmony", "complex notes", "engaging", "enthralling", "compelling", "melancholic", "chaotic", "restless"] | 7 | xtllXrdFAFQ | 5361 |
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;