musiccaps_details (view)

1 row where musiccaps_aspects contains "harp accompaniment", musiccaps_aspects contains "no percussions" and musiccaps_aspects contains "poignant"

✎ 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
the GHOST BRIDE A female singer sings this eerie melody. The song is medium tempo with a rolling bells keyboard harmony, and other ambient echo tones and harp tones. The song is haunting and unsettling. The audio quality is very poor and not enjoyable. 2013-10-04T23:18:46Z grav3yardgirl -DON'T WORRY- makeup & hair tutorial COMING TOMORROW! SWAMP FAMILY TEA CUPS ARE BACK! https://www.etsy.com/listing/125139605/16-oz-swamp-family-tea-cup http://www.youtube.com/subscription_center?add_user=grav3yardgirl INSTAGRAM: @grav3yardgirl www.numestyle.com Coupon code: funnybunny - $115 off Curling Wands and Flat Irons Coupon code: bunny8 - $120 off all our styling sets Coupon code: bunny1 - $97 FOR the Lustrum, Couture and Argan Oil, total discount of $366 OFF! http://goo.gl/BGoya3 WANNA SEND ME MAIL? SEND IT HERE!: GRAV3YARDGIRL PO BOX #2263 PEARLAND, TEXAS 77588 follow me on twitter: http://twitter.com/grav3yardgirl LIKE ME ON FACEBOOK: http://www.facebook.com/grav3yardgirl please check out MY ETSY PAGE!!: http://www.etsy.com/shop/enmortem?ref... please take a moment to subscribe!! FTC- I am not being paid by any of the mentioned companies or designers to make this video. The views in this video are strictly my own and I am not affiliated with any of these companies. ["Music", "Scary music"] ["female singer", "faint vocals", "eerie", "haunting", "emotional", "poor audio quality", "discomforting effect", "poignant", "unsettling", "offbeat", "quirky", "amateur music production", "haunting harmony", "horror film soundtrack", "no percussions", "harp accompaniment", "keyboard harmony", "medium tempo"] 1 KoAGZ_dB8MM 2119

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;