musiccaps_details (view)

1 row where musiccaps_aspects contains "eerie", musiccaps_aspects contains "irritating", musiccaps_aspects contains "soap opera soundtrack", musiccaps_aspects contains "vocoder" and musiccaps_names contains "Vocal music"

✎ 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
Barbara, Eustaquia, Melquiades, & Juan Primito || Hide & Seek This is a vocal performance from a soap opera soundtrack. There is a female vocalist that is singing with a heavily manipulated voice, most probably through the use of a vocoder. The volume of the track is unnecessarily loud and it peaks frequently. There is an unsettling atmosphere. It could be used in the soundtrack of a horror movie where the protagonist is slowly losing touch with reality. 2010-09-23T16:57:15Z VenusKaMGchannel2 RE-UPLOADED Rights reserved by Telemundo NBC. No Copyright Infringment Intended. Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. la cancion es "Hide and Seek" de Imogen Heap ["Vocal music"] ["soap opera soundtrack", "female voice", "vocoder", "eerie", "unsettling", "loud", "irritating"] 9 b6hr31Qaemg 3602

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;