musiccaps_details (view)
3 rows where musiccaps_aspects contains "no other instruments" and musiccaps_names contains "Bagpipes" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- instrumental 3
- no other instruments · 3 ✖
- no voices 3
- bagpipe music 1
- bagpipes 1
- fast tempo 1
- folk music 1
- low quality audio 1
- meditation song 1
- no percussion 1
- relaxing song 1
- slow tempo 1
- solo 1
- sound of crowd 1
- synth song 1
- traditional scottish music 1
musiccaps_names (array) 2 ✖
- Bagpipes · 3 ✖
- Wind instrument, woodwind instrument 3
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johnny Bagpipes Johnston | This amateur recording clip features the bagpipes playing a melody. This tune is played at a fast tempo and at a high pitch. There are no other instruments in this song. There are no voices in this song. This song is an instrumental. This song can be played in a village fair. The sound of the crowd cheering is heard throughout the song. | 2007-03-09T05:19:02Z | BleedingM4scar4 | comedian Johnny Bagpipes Johnston @ the Calgary Stampede (July 8, 2006) | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality audio", "bagpipes", "no voices", "no other instruments", "fast tempo", "sound of crowd", "instrumental"] | 0 | 0a6uLBmqZgA | 185 | |
Chris Armstrong 10yrs | This song features an instrumental played on bagpipes. One pedal note is played continuously on the lower register while the higher notes are played to a melody. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be played at a Scottish fair. | 2009-07-27T17:04:52Z | MacNeillofTiree | Competition | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipe music", "solo", "no other instruments", "folk music", "no voices", "instrumental", "traditional scottish music"] | 0 | aDlWOvCdNMk | 3522 | |
SGPB Sleeping Tune.mpg | This song features a synth playing the main melody. The synth plays a heavenly voice with a pad like backing. There are no other instruments in this song. There is no voice in this song. The mood of this song is relaxing. This song can be played in a meditation center. | 2010-03-06T18:33:49Z | gwwoodworth | Bagpipe concert 3/5/10 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["synth song", "no other instruments", "no percussion", "no voices", "instrumental", "slow tempo", "relaxing song", "meditation song"] | 0 | w0yHqPxybQE | 5230 |
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;