musiccaps_details (view)

3 rows where musiccaps_aspects contains "accordion" and musiccaps_author = 8

✎ 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
ALBANIAN FOLK MUSIC 2013 Eastern European music featuring clean electric guitar, tambourine, two male vocalists. Could be traditional dance music. 2013-07-27T15:18:44Z Alba Gjoka Traditional Albanian Music ["Folk music", "Music"] ["two male vocalists", "eastern european", "clean electric guitar", "accordion", "tambourine", "traditional dance"] 8 MNd8CRa48Uk 2260
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
Brooklyn Elbert & Kassidy King sing "How Does She Yodel" 2011 Christmas A quiet recording of two female singers participating in a yodeling call and response section, accompanied by accordion, drum kit, bass and guitar playing a steady oompah beat. The chord progression is simple and the mood is fun and silly. 2012-01-28T00:04:23Z LilCutieBittys 10 year olds- Brooklyn Elbert and Kassidy King of Avery and The Calico Hearts perform a duet to "How Does She Yodel" in which they both show off their country twang, natural break abilities, and harmonizing yodeling skills. Brought the house down (second year in a row). Trivia fact: This is Kassidy's 4th year to sing this song at a Cactus Christmas show. Great way to see both of these girls, who usually sing back up to Avery (Winter), featured prominently. The girls are students of Terri Caldwell Music under the direction of Cami Caldwell. Intro by Terri Caldwell. Video by Johnny Busby. Taken at the Cactus Kids Christmas show December 2011 at the Cactus Theater in Lubbock, Texas. ["Singing", "Yodeling", "Music", "Music of Latin America"] ["quiet recording", "yodeling duet", "call and response", "two female vocalists", "oompah", "accordion", "simple chord progression", "drum kit", "guitar", "fun", "silly"] 8 qaQjG9SwORU 4799

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;