musiccaps_details (view)
5 rows where musiccaps_aspects contains "drone" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- drone · 5 ✖
- audience sounds 1
- bagpipe ensemble 1
- double reed solo 1
- electronic bagpipe 1
- female singer 1
- grating 1
- harsh 1
- hypnotic 1
- low fidelity 1
- meditative 1
- microtonal 1
- ornamentation 1
- quick melody 1
- solo 1
- solo bagpipe 1
- solo sitar 1
- string bending 1
- tape hiss 1
- tape warble 1
- technically challenging melody 1
- trills 1
- unison melody 1
- world music 1
musiccaps_names (array) 9 ✖
youtube_published (date) 5 ✖
- 2006-12-30 1
- 2010-08-23 1
- 2011-03-26 1
- 2011-07-23 1
- 2011-12-02 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
jászsági népdalok (hungarian folk music) | A low fidelity recording of a drone instrument playing a chord while a female singer and double reed instrument double a technically challenging melody. | 2010-08-23T12:12:56Z | Jász Gyerek | 4 népdal | ["Traditional music", "Folk music", "Music"] | ["low fidelity", "female singer", "double reed solo", "drone", "technically challenging melody", "world music"] | 8 | RFKTlhbnfXA | 2683 | |
Pt Budhaditya Mukherjee, Raga Naaki Kanada Live 1992 Pt 1 | Solo sitar using microtonality, droning and string bending. The music is hypnotic and meditative and there is the sound of tape hiss and warble in the recording. | 2011-12-02T10:59:27Z | tripmonk0 | First part of Raga Nayaki Kanada with Partha Sarathy Mukherjee on tabla.. Made from an old VHS tape so sound & picture a bit ropey!! Sorry!! | ["Carnatic music", "Music", "Musical instrument", "Plucked string instrument", "Sitar"] | ["solo sitar", "drone", "microtonal", "string bending", "meditative", "hypnotic", "tape warble", "tape hiss"] | 8 | feC0L9MtghM | 3966 |
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;