musiccaps_details (view)
1 row where musiccaps_aspects contains "western swing", musiccaps_author = 8 and musiccaps_names contains "Music"
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
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;