musiccaps_details (view)

2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "no singer", musiccaps_aspects contains "steady tempo" and musiccaps_names contains "Bluegrass"

✎ 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
Seán McKeon, Conor McEvoy, John Blake - Traditional Irish Music from LiveTrad.com This is an Irish folk music piece. There is no singer. The main melody is being played by the uilleann pipes and the fiddle at a high pitch. The acoustic guitar is playing a rapid procession of chords in the background. The atmosphere is lively. This piece could be playing in the background at an Irish pub. It could also be used in the soundtracks of movies and TV shows that have a theme with an Irish influence. 2012-02-17T12:56:44Z Livetrad http://www.livetrad.com Performing a number of reels during a benefit concert for 'Aid Japan for Children', a group working with survivors of the earthquake and tsunami in Japan in 2011. This video was recorded by Martin Moylan at St. Anne's Church on Dawson St., Dublin 2 and we're delighted to add it to the LiveTrad YouTube channel. For more info see 'Aid Japan for Children' on Facebook. ["Banjo", "Traditional music", "Music", "Bluegrass"] ["irish folk music", "no singer", "instrumental", "uilleann pipes", "fiddle", "acoustic guitar", "vibrant", "joyful", "lively", "steady tempo"] 9 NwA9JSlK_lM 2378
Saint Anne's Reel on Guitar and Mandolin This is an Irish folk music piece. The melody is being played by an acoustic guitar and a mandolin. The atmosphere of the piece is cozy and easygoing. It has a steady tempo. This piece could be used in the soundtrack of a documentary. It could also be playing in the background at an Irish pub or an Irish cuisine restaurant. 2010-03-04T00:29:30Z Ryan Kimm Ryan Kimm and Mike Hedding doing that old fiddle tune Saint Anne's Reel. Tabs and Practice tracks available for this tune and other fiddle tunes at http://www.musicwithryan.com Check out more fiddle tunes and free lesson videos at http://www.youtube.com/channel/UCjEo6w49rYrwFNy6cXWRe6A ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] ["irish", "folk music", "no singer", "instrumental", "acoustic guitar", "mandolin", "cozy", "lively", "easygoing", "steady tempo"] 9 Ts04bBeY1d4 2871

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;