musiccaps_details (view)
3 rows where musiccaps_aspects contains "drone" and musiccaps_names contains "Wind instrument, woodwind instrument" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- drone · 3 ✖
- audience sounds 1
- bagpipe ensemble 1
- electronic bagpipe 1
- grating 1
- harsh 1
- ornamentation 1
- quick melody 1
- solo 1
- solo bagpipe 1
- trills 1
- unison melody 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bagpiper Angus McColl 1 | Harsh, grating sound of a solo bagpipe with audience sounds in the background. | 2006-12-30T21:44:45Z | 3DPiper | An amazing performance by Gold Medal/World Champion level piper Angus McColl at the Red River Workshop in Shreveport, LA, 2005 1 of 2 Full Playlist: http://www.youtube.com/view_play_list?p=CC4EC1A82C4245A2 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["solo bagpipe", "drone", "audience sounds", "harsh", "grating"] | 8 | 3TP1itJqv-E | 470 | |
How bagpipes are made | A bagpipe ensemble playing a quick melody in unison, employing trills to ornament it. | 2011-03-26T12:38:24Z | RGHardieandCompany | From turning blackwood billets to being played on the concert stage, watch how Bagpipes are made at R.G. Hardie & Co. - Makers of the Worlds Finest Bagpipes | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipe ensemble", "unison melody", "drone", "quick melody", "trills", "ornamentation"] | 8 | -DeAdhYKbGE | 27 | |
Ross Electronic Bagpipes | Solo electronic bagpipe. | 2011-07-23T20:35:19Z | Mississippi Mike | The video is a review for the product I have bought, the Ross Electronic Bagpipe, by William Ross, of Ross Technologies. William Ross is a great guy and he designed and built the instrument himself. Ross, you got my endorsement. I'm extremely happy with the product, it's simply amazing. The shipping was faster than greased-up lightening, the price was more than affordable and seller communication was outstanding, friendly and professional. Again, I couldn't be happier to share my experience and recommend the product, which can be found right here: http://myworld.ebay.com/ailwil/?_trksid=p4340.l2559 If you're looking for electronic bagpipes, I wouldn't hesitate at all buying this model. And the song, well, you can hear and make your own conclusions, I think it sounds awesome and it actually surprised me and blew me away of how good it is, exceeding all my expectations. Ross Technologies have a fine product for an EXCELLENT PRICE!!! Before anybody asks me I don't get commission, I don't have anything to do with the company, neither any of my views represent that of the company, I'm just an extremely happy customer that felt the need to share the experience with other potential buyers. I hope I did the product some good justice, despite my crappy beginner playing, them good Ross folk take a lot of pride in making those wonderful instruments and they rightfully deserve a good review. The tune is Scots Wha Ha'e e Wi' Wallace Bled (Scots) or Scots Who Have With Wallace Bled (English), commonly known as Scots Wha Hae.The song was played for Robert the Bruce's troops on their march to Bannockburn, where brave Scots whooped the hell out of invading English troops, securing Scottish Independence then. Robert Burns composed the lyrics and they are said to be Bruce's address to his men before the battle. A beautiful, patriotic and outstanding melody. It's been about a year since I have made this video (this paragraph is being written in July 2012) and I thought it would be nice to let people that come here know that I'… | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["electronic bagpipe", "drone", "solo"] | 8 | JNw0A8pRnsQ | 1997 |
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;