musiccaps_details (view)

1 row where musiccaps_aspects contains "inspirational music", musiccaps_aspects contains "pop melody" and musiccaps_author = 0

✎ 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
Baba O'Riley - BeyondPluck This song features two harps playing a melody. In the beginning, both harps play the harp complimenting each other. After one bar, one of the harps plays the higher repetitive phrase and the other harp plays the lower register notes. This song has a happy mood. There are no other instruments in this song. There are no voices in this song. This song can be played in an inspirational video. 2014-07-19T16:03:52Z Beyond Pluck Featured in the latest TalkTalk commercial, Beyond Pluck (Rachel Miller and Paula Bressman) plays The Who's "Baba O'Riley" on two harps! Download our music here: iTunes: https://itunes.apple.com/us/album/baba-oriley-single/id902922776 Amazon: http://www.amazon.com/Baba-ORiley/dp/B00M3GN30S/ref=sr_1_1?ie=UTF8&qid=1423069080&sr=8-1&keywords=beyond+pluck CD Baby: http://www.cdbaby.com/cd/beyondpluck2 Subscribe to our channel: https://www.youtube.com/user/beyondpluck Follow us on Facebook: http://www.facebook.com/beyondpluck Follow us on Twitter: http://www.twitter.com/beyondpluck Paula on Facebook: http://www.facebook.com/nashvilleharpist Rachel on Facebook: http://www.facebook.com/rachelmillerharp Our website: Our Website: http://beyondpluck.com/ Video by Nayt Cochran Arranged by Paula Bressman Produced by Brian D. Siewert (Triple S Entertainment, Inc., Nashville) © 2014 Beyond Pluck ["Harp", "Pizzicato"] ["harp song", "no voices", "no other instruments", "instrumental", "pop melody", "happy song", "moderate tempo", "inspirational music"] 0 qutPvh6TFd8 4833

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;