musiccaps_details (view)

1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "march" and musiccaps_aspects contains "unique"

✎ 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
Steel Drum Wedding Steel Drum Wedding March Recessional by RythmTrail Steel Drum Band This is the live performance of a wedding music piece on the steel drum percussion. There is a unique feel to it. The recording has a gain issue that makes the drums give a peak noise during accented notes. If that could be resolved, it would make perfect wedding music in a tropical setting. 2011-01-21T16:44:01Z RythmTrail Steel Drum Band RythmTrail Tel 866 495 4522 Website http://www.rythmtrail.com Live Steel Drum Music for you Beach Wedding Ceremony, Our Steel Drum Players play music for Traditional and Non-Traditional wedding. This is a short steel drum sample demo video of the Wedding March Recessional being done live on the Beach at a Beach Wedding in Cocoa Beach Pier Florida Book Steel Drum players or Steel Drum Band for your Wedding, Beach Wedding, Cocktail or reception Read what other wedding clients are saying here http://www.rythmtrail.com/testimonials ["Music", "Musical instrument", "Classical music", "Steelpan"] ["live performance", "march", "instrumental", "percussion", "steel drums", "unique", "wedding music"] 9 5tRNPTLRZqI 703

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;