musiccaps_details (view)

1 row where musiccaps_aspects contains "epic", musiccaps_aspects contains "shoe tapping" and musiccaps_names contains "Wind instrument, woodwind instrument"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Cadets Pipe Band at Edinburgh Castle The low quality recording features shoe tapping sounds alongside loud bagpipe melody and drum rolls. It sounds like it was recorded outside and therefore it is reverberant, epic and powerful. The recording is in mono and a bit noisy. 2010-06-15T23:12:57Z dronechorus 2010 marked the 150th anniversary of the UK Cadet Organisations and a special event was organised at Edinburgh Castle on Saturday 12 June 2010 to celebrate the fact. This video shows extracts from the display by the massed pipes and drums of the cadets forces. The tunes played are: Opening marches: The Steam Boat and The Bugle Horn Marches: The Barren Rocks of Aden, Highland Laddie, Mairie's Wedding Slow Air: The Skye Boat Song Reel: Itchy Fingers Closing march: The Glendaruel Highlanders Although this video only shows the pipes and drums there were also displays of highland dancing by Loretto School Combined Cadet Force, a first aid display by Lothian and Borders Battalion ACF, a drill display by Northern Area Sea Cadet Force and 2535 (Livingstone) Squadron ATC and the military bands of the Cadet Forces. There are training courses in Inverness for these young pipers and drummers and the bands parade annually in Dingwall and Inverness. I have never been able to catch them there so it was great to get to Edinburgh to see this fine display. ["Bagpipes", "Wind instrument, woodwind instrument"] ["drum rolls", "shoe tapping", "loud bagpipe melody", "epic", "powerful", "low quality", "mono", "noisy", "reverberant"] 4 NJ_Ha89QjiI 2330

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;