musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar strumming", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "walking bassline" and musiccaps_names contains "Swing music"

✎ 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
2013 NorthWest Western Swing Festival - The Jangles Band An instrumental western swing group featuring a violin or fiddle solo. The upright bass lays down a steady walking bassline while two jazz guitars accompanied by strumming chords. Accordion is also present, but drums are not. 2013-10-17T08:36:09Z Jeanne Yearian In this video clip, The Jangles Band performs "I'm an Old Cowhand," "Sweet Sue" and "I'm a Long, Tall Texan" at the NorthWest Western Swing Music Society's 23rd Annual Western Swing Festival, held August 8-11, 2013. Billed as Seattle's premier Western Swing Band, The Jangles entertain around the northwest. For more information, check out their website at www.mikefaast.com/bands/jangles or look for them on Facebook. The NorthWest Western Swing Music Society's annual festival and Hall of Fame induction ceremony are held on the second week-end in August, at the Auburn Eagles Club in Auburn, Washington. For more information about western swing or the western swing music societies across the United States, please visit the Society's website at www.nwwsms.com. ["Swing music", "Music", "Bowed string instrument"] ["fiddle", "guitar strumming", "western swing", "accordion", "violin solo", "upright bass", "jazz guitar", "violin solo", "jazz", "walking bassline", "no drums", "instrumental"] 8 S2u5IE0n1ws 2735

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;