musiccaps_details (view)

1 row where musiccaps_aspects contains "arpeggiated synth melody", musiccaps_aspects contains "groovy" and musiccaps_aspects contains "groovy bass"

✎ 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
Grizzly Bear "Yet Again" By Emily Kai Bock [Official Video] The Alternative/indie song features harmonizing male vocals singing over groovy bass, punchy kick and snare hits, straight piano chords, synth lead melody and arpeggiated synth melody. It sounds groovy and addictive - like something you would hear in clubs during the 80s. 2012-09-27T13:55:34Z Creators The new video for Yet Again taken from Grizzly Bear's album Shields, out now. You Should Subscribe to The Creators Project: http://bit.ly/YjRlED Executive produced by The Creators Project in partnership with Warp Records, the video was directed by Emily Kai Bock and shot in Toronto. http://grizzly-bear.net/music/albums/shields/ Artist: Grizzly Bear Track Title: "Yet Again" Director/Writer/Editor: Emily Kai Bock DP: Evan Prosofsky EP/Producer: Geoff McLean Underwater Camera Operator: Nabil Milne Line Producer: Anna Junger Prod Co: Vision Film Co / Logan & Sons 1st AC: Michael Bailey Gaffer: John Hall Key Grip: Nabil Milne SFX: Jeff Skochko PA: Jonathan Turner Lead Talent: Rebecca White Camper#1: Ted Reid Camper#2: James Turnbull Camper#3: Richard Harvey The Creators Project is a partnership between Intel and VICE: http://thecreatorsproject.com/ Grizzly Bear: http://grizzly-bear.net/ Subscribe to The Creators Project: http://bit.ly/Subscribe_to_TheCreatorsProject Check out our full video catalog: http://www.youtube.com/user/TheCreatorsProject/videos Buy Grizzly Bear - Shields: iTunes - http://glnk.it/1mo Amazon - http://glnk.it/1mq Best Buy - http://glnk.it/1mu Barnes & Noble - http://glnk.it/1mt Bleep - http://glnk.it/1ms ["Independent music"] ["alternative/indie", "harmonizing male vocals", "groovy bass", "punchy snare", "punchy kick", "synth lead melody", "straight piano chords", "arpeggiated synth melody", "groovy", "addictive"] 4 AuG9i5cwGW0 1181

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;