musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "hard-hitting", musiccaps_aspects contains "melodic singing" and musiccaps_author = 9

✎ 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
Patent Pending: Douchebag (Official Music Video) This is a pop punk music piece. The male vocals are singing melodically. Initially, there is a clean sounding electric guitar playing the main melody. Then, a rising pattern starts to play and the distorted electric guitar takes the place of the clean electric guitar. The bass guitar is playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is hard-hitting. This piece can be used in the soundtrack of a teenage drama as the opening theme. 2011-12-06T21:45:34Z Patent Pending TV "Douchebag" Patent Pending's Official Music Video Directed by Built By Ninjas! http://itunes.apple.com/us/album/douchebag/id455707825?i=455707833&ign-mpt=uo%3D4 New album 'Riot Hearts Rebellion' AVAILABLE NOW! Digital: http://smarturl.it/RHRDigital Physical: http://smarturl.it/RHRPhysical Catch Patent Pending supporting Simple Plan this summer in The United States: August 18 - The Intersection - Grand Rapids, MI August 19 - Bogarts - Cincinnati, Oh August 20 - Egyptian Room at Old National Centre - Indianapolis, IN August 22 - First Avenue - Minneapolis, MN August 24 - House Of Blues - Dallas, TX August 25 - House Of Blues - Houston, TX August 26 - Emo’s East - Austin, TX August 29 - Brooklyn Bowl - Las Vegas, NV August 28 - Orpheum - Flagstaff, AZ August 30 - Ace OF Spades - Sacramento, CA September 1 - Crystal Ballroom - Portland, OR September 2 - Neptune Theater - Seattle, WA September 3 - Neptune Theater - Seattle, WA ["Music", "Independent music", "Exciting music"] ["pop punk", "male vocals", "melodic singing", "clean electric guitar", "rising pattern", "distorted electric guitar", "bass guitar", "acoustic drums", "crunchy", "hard-hitting", "rebellious"] 9 6XHdybfV5Cw 764

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;