musiccaps_details (view)
2 rows where search matches "guitar" and musiccaps_names contains "Bagpipes" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- acoustic guitar accompaniment 1
- ambient sounds 1
- bagpipe melody 1
- bagpiper 1
- bellows 1
- clapping 1
- crowd talking 1
- double reed instrument 1
- drone pipes 1
- electric guitar lick 1
- emotional 1
- engaging 1
- exciting 1
- fast tempo 1
- high notes 1
- high-spirited 1
- instrumental 1
- live audience 1
- live performance 1
- lively 1
- low quality 1
- melody pie 1
- mesmerising 1
- mono 1
- noisy 1
- passionate 1
- piper 1
- punchy kick 1
- rich 1
- sharp sounds 1
- spirited 1
musiccaps_names (array) 2 ✖
- Bagpipes · 2 ✖
- Wind instrument, woodwind instrument 2
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 | |
The PowerPipes | The low quality recording features a bagpipe melody, layered with an electric guitar lick and followed by punchy kick hits. In the background there are some crowd talking noises and claps. It sounds exciting and the recording is noisy and in mono. | 2009-08-26T10:25:54Z | fVZD | TPP featuring at pan ulica fest špancirfest :D | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "bagpipe melody", "clapping", "punchy kick", "crowd talking", "mono", "noisy", "electric guitar lick", "exciting"] | 4 | yAvqiPL-ssU | 5390 |
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;