musiccaps_details (view)
3 rows where musiccaps_aspects contains "spirited" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- emotional 3
- spirited · 3 ✖
- passionate 2
- acoustic guitar accompaniment 1
- ambient crowd noise 1
- ambient sounds 1
- army band 1
- bad audio quality 1
- bagpipe harmony 1
- bagpiper 1
- bagpipers playing 1
- bellows 1
- crowds cheering 1
- demonstration 1
- devotional 1
- distorted sounds 1
- double reed instrument 1
- drone pipes 1
- engaging 1
- fast tempo 1
- hebrew traditions 1
- high gain noise 1
- high notes 1
- high-spirited 1
- horn instrument 1
- horn instruments 1
- instrumental 1
- instrumental music 1
- instrumental solo 1
- jewish musical instruments 1
- jewish tradition 1
- life 1
- live audience 1
- live performance 1
- lively 1
- male preacher talking 1
- march rhythm 1
- marching sounds 1
- meditational 1
- medium tempo 1
- melody pie 1
- mesmerising 1
- music demo 1
- no accompaniment instruments 1
- no accompaniment is true tas 1
- patriotic music 1
- piper 1
- playing percussively 1
- rich 1
- rituals 1
- sensitive 1
- sharp sounds 1
- spirituality 1
- very poor audio quality 1
- victory march 1
youtube_published (date) 3 ✖
- 2007-06-29 1
- 2010-09-11 1
- 2012-05-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gordon Walker 4 - Glenfiddich Ceilidh 2003 | This music is a lively Bagpiper instrumental. The tempo is fast with a piper playing a cheerful harmony on the bagpiper with an enthusiastic acoustic guitar accompaniment. The music is vibrant, vivacious, vigorous, engaging, cheerful and merry. The performance is live with a live audience and ambient sounds. | 2007-06-29T17:30:17Z | Chris Eyre | The last of 4 clips of Gordon Walker giving a wonderful and entertaining display during the ceilidh at the New Scotland Hotel in Pitlochry on the evening following the Glenfiddich competition at Blair Castle. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "bagpiper", "acoustic guitar accompaniment", "live performance", "live audience", "ambient sounds", "lively", "spirited", "rich", "drone pipes", "melody pie", "bellows", "double reed instrument", "piper", "passionate", "spirited", "emotional", "high-spirited", "engaging", "mesmerising", "sharp sounds", "high notes"] | 7 | JjF1G5wgcvY | 2028 | |
Meaning of the Shofar Blast | A male preacher talks and plays horn -like instruments to explain the ritual sequence. The song is medium tempo and the small horn is played rhythmically without any accompaniment. The audio quality is bad and the movie talks about Jewish custom sequences. | 2010-09-11T19:06:15Z | Kristopher Shoemaker | Teaching live on line at the House of the Prophets at the home of Apostle Ngabo and his family in Sweden about the Shofar blast on Yom Teruah, Feast of Trumpets, Rosh HaShannah. | ["Wind instrument, woodwind instrument", "Shofar"] | ["male preacher talking", "music demo", "no accompaniment instruments", "jewish musical instruments", "bad audio quality", "horn instruments", "horn instrument", "bad audio quality", "instrumental solo", "no accompaniment is true tas", "spirituality", "devotional", "jewish tradition", "spirited", "emotional", "sensitive", "emotional", "life", "demonstration", "playing percussively", "meditational", "rituals", "hebrew traditions"] | 1 | LoTRWc9WK9Q | 2222 | |
Air Corps Pipe Band Ireland - Cornemuse à Lourdes | The song is an instrumental. The bagpipes play together in unison and march to the sounds of crowds cheering and other ambient sounds. The song is patriotic like a victory march. The song has very bad audio quality. | 2012-05-15T21:34:02Z | gpainblanc | Chaque année une délégation irlandaise participe au pélérinage militaire international à Lourdes. S'il est une musique militaire fidèle au PMI, il s'agit bien de ce Pipe band. Voici quelques enregistrements effectués lors du 54ème PMI, en mai 2012 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipers playing", "army band", "marching sounds", "instrumental music", "crowds cheering", "ambient crowd noise", "very poor audio quality", "distorted sounds", "high gain noise", "medium tempo", "spirited", "passionate", "victory march", "army band", "bagpipe harmony", "emotional", "patriotic music", "march rhythm"] | 1 | qBe_D8Gg5lA | 4762 |
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;