musiccaps_details (view)

2 rows where musiccaps_aspects contains "energetic crash cymbal", musiccaps_author = 4 and musiccaps_names contains "Progressive rock"

✎ 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
MONSTER - PALLAS - OFFICIAL VIDEO The Rock song instrumental features a mellow synth pad with flanger effect on, and straight piano chords playing in the beginning. In the second part of the loop, there is an electric guitar solo melody layered with synth pad melody and electric guitar power chords layered with powerful bass guitar and energetic crash cymbal. It sounds energetic and powerful, even though it starts softly. 2011-07-21T06:36:47Z PallasOfficial The Official Video for "Monster" taken from 2011's "XXV" by Scottish progressive rock group Pallas. This is the bands first video since 1984's "Arrive Alive" Pallas are due to play at this weekends High Voltage Festival Sunday 24th July 2011 at 13:30 on the prog stage, don't miss it!! http://www.pallasxxv.com ["Background music", "Theme music", "Heavy metal", "Music", "Progressive rock"] ["rock", "energetic", "electric guitar solo melody", "electric guitar power chords", "instrumental", "flanger effect", "mellow synth pad", "straight piano chords", "energetic crash cymbal", "powerful bass guitar", "soft", "powerful"] 4 LadgIxZu8Oc 2203
AC/DC Sink The Pink (NO FLY DVD) The low quality recording features a live performance of a rock song that consists of aggressive electric guitar chord progression, punchy snare, simple kick pattern, shimmering hi hats, energetic crash cymbal and a groovy bass guitar. At the very beginning the sound is gated, leaving only the distant, reverberant guitar chords and punchy snare hits audible. There is also a short snare roll, right before the drop. This instrumental is very energetic and exciting. 2012-05-05T12:57:36Z tekka018 (Old DVD project). New project teaser and links here: https://youtu.be/nYo9WKbX0so?list=PLr3l5U7yFV_e1jVci8eAuIorhvhluA-fB ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] ["rock", "low quality", "gated", "aggressive electric guitar chords progression", "punchy snare", "simple kick pattern", "shimmering hi hats", "short snare roll", "energetic crash cymbal", "groovy bass guitar", "instrumental", "live performance", "energetic", "reverberant", "energetic"] 4 Ls6qMcgpdlM 2227

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;