musiccaps_details (view)
4 rows where musiccaps_author = 1 and musiccaps_names contains "Bagpipes" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 59 ✖
- instrumental music 4
- ambient crowd noise 2
- army band 2
- bad audio quality 2
- crowds cheering 2
- emotional 2
- march rhythm 2
- marching rhythm 2
- medium tempo 2
- passionate 2
- victory march 2
- ambient room noise 1
- ambient street noise 1
- bagpipe harmony 1
- bagpipers play in unison 1
- bagpipers playing 1
- bagpipes playing 1
- band arrangement 1
- celtic music 1
- crowds clapping 1
- distorted sounds 1
- drum beats 1
- drum playing percussively 1
- energetic 1
- enthusiastic 1
- exciting 1
- exciting solo 1
- female bagpiper 1
- flutes playing in unison 1
- groovy bass 1
- high gain noise 1
- homage 1
- live audience 1
- live march 1
- live performance 1
- marching band 1
- marching sounds 1
- medium fast tempo 1
- never forgotten 1
- patriotic music 1
- paying tribute 1
- people marching 1
- people talking 1
- percussions sounds 1
- performer 1
- police band 1
- poor audio quality 1
- remembrance 1
- rhythm section 1
- rousing 1
- school band 1
- sentimental 1
- social activism 1
- sorrowful 1
- spirited 1
- steady rhythm 1
- very poor audio quality 1
- victorious 1
- war cry 1
musiccaps_names (array) 2 ✖
- Bagpipes · 4 ✖
- Wind instrument, woodwind instrument 4
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julie Fowlis playing Bagpipe - Live | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | 2009-09-05T09:48:05Z | smartotrams | Live at Lüdenscheid, Germany 4th Sept 2009 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | 1 | 0NTzOtVmoiU | 154 | |
MSP 80th R.T.T Graduation Part1.flv | The song is an instrumental. The tempo is medium with bagpipers playing in unison, and rhythmic percussion play. The song is emotional and pays tributes to the fallen in remembrance and homage. The song has bad audio quality with ambient room noises. | 2012-04-02T16:28:54Z | Bob Thompson | 80th Massachusetts State Police Recruit Training Troop Graduation Ceremony March 9, 2012. Part 1 is Introduction, Troop Drill and Silent Drill Team. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipers play in unison", "police band", "march rhythm", "instrumental music", "medium tempo", "emotional", "homage", "paying tribute", "sorrowful", "rousing", "marching rhythm", "sentimental", "sorrowful", "victorious", "remembrance", "never forgotten", "ambient room noise", "bad audio quality"] | 1 | _ACyiKGpD8Y | 3449 | |
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 | |
Ross Kemp joins Orange Order Feeder Parade. 12 July 2013....5 | The music track is that of a band marching in the streets. The tempo is medium with a Band march, playing percussion in a steady rhythm accompanied by flutes playing in unison. The song has bad audio quality with ambient noises of people talking and other street noises. | 2013-07-12T12:43:57Z | william belfast | Orange Order Feeder Parade www.newsflare.com | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["live march", "marching band", "instrumental music", "flutes playing in unison", "steady rhythm", "drum beats", "marching rhythm", "percussions sounds", "people marching", "social activism", "army band", "school band", "band arrangement", "poor audio quality", "ambient street noise", "people talking"] | 1 | v9TTtjEngjY | 5159 |
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;