musiccaps_details (view)

1 row where musiccaps_aspects contains "animal sounds", musiccaps_names contains "Humming", musiccaps_names contains "Inside, large room or hall" and musiccaps_names contains "Outside, rural or natural"

✎ 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
Klingon, Dolphin, and more Rejected Coke Ad Languages [Garlic Jackson Comedy] This piece is a parody of an ad theme. There are female vocals singing at a high-pitch in the major scale, resulting in an epic atmosphere resembling an anthem. The resolution is interrupted by an implied bear attack, breaking the seriousness of the piece. 2014-02-04T17:54:12Z GarlicJacksonComedy Which other languages did they miss? Subscribe! http://bit.ly/garlicjacksonsub Like us! http://facebook.com/GarlicJacksonComedy Check us out! http://GarlicJackson.com Follow us! https://twitter.com/garlicjackson Reach us! GarlicJackson@Gmail.com We are in no way affiliated with Coca Cola. In no way do the views expressed in this video reflect the views of the Coca Cola Company. This video was made for entertainment purposes only. No copyright infringement intended. ["Humming", "Music", "Inside, large room or hall", "Outside, rural or natural"] ["female vocals", "high-pitched singing", "anthem", "comedy", "parody", "animal sounds"] 9 18mS4cLPOb8 240

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;