musiccaps_details (view)

1 row where musiccaps_aspects contains "buzzy synth bass", musiccaps_aspects contains "distorted", musiccaps_aspects contains "suspenseful" and musiccaps_author = 4

✎ 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
Tell Me You Love Me The low quality recording features an electro song that consists of a widely spread stuttering synth melody, buzzy synth bass and distorted electric guitar melody. It sounds distorted, loud, suspenseful and energetic. 2012-07-16T02:20:05Z Sharon Wright After a brutal attack sustained by Sharon Wright (Co-Director/Lead Actress) she teamed up with partner, Gary C Warren, to make a film as therapy to help her deal with the post traumatic stress associated with the assault. Wright received numerous acting awards for her harrowing performance, including the Withoutabox Best Actress Award for her performance at the Action On Film Intl Film Festival. The film was also used as an Interstitial/PSA and was nominated for 3 Mid america Emmy Awards. "Tell Me You Love Me" has played festivals worldwide and has received numerous other awards including, Best Film, Best Director and Best Editing. For more details about that night - please watch Sharon's candid and emotional video where she opens up about the attack: http://www.youtube.com/watch?v=6coONebv-Qs ["Music", "Angry music"] ["loud", "distorted", "wide stuttering synth melody", "buzzy synth bass", "harsh", "energetic", "low quality", "electro", "distorted electric guitar melody", "suspenseful"] 4 2x4694ExyCU 418

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;