musiccaps_details (view)

3 rows where musiccaps_aspects contains "male back vocals"

✎ 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
Beyblade Soundtrack - Swing Low This is a cartoon theme in the style of alternative metal. There is a male lead vocal singing loudly while there are male back vocals singing more melodically. The distorted electric guitars and heavy bass guitar are playing an aggressive tune. The rhythmic background is provided by an acoustic drum beat just as aggressive. The atmosphere is energetic and action-filled. This piece can be used in the soundtrack of an action-based cartoon or a video game. 2008-03-26T14:00:13Z Dhurak Beyblade Soundtrack - Swing Low Enjoy! ["Music", "Angry music"] ["cartoon theme", "alternative metal", "ska punk", "male lead vocal", "male back vocals", "distorted electric guitar", "bass guitar", "acoustic drums", "aggressive", "action-filled", "energetic"] 9 7muzlOrbDu8 882
MITCH RIDER & the DETROIT WHEELS - BREAKOUT This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. 2011-04-23T15:20:22Z PaulGTSE MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL ["Funk", "Music", "Soul music"] ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] 9 GQbUpJFArKI 1720
Poison- I Won't Forget you Lyrics This is a glam metal/heavy metal ballad. There is a male vocal and male back vocals singing melodically. The melody is being played on an electric guitar with a chorus effect applied alongside a bass guitar. The rhythmic background consists of a rock acoustic drum beat.The atmosphere is both hard-hitting and sentimental at the same time. This piece could be playing in the background of a rock/metal bar. It could also be included in the soundtrack of an 80s themed romance movie. 2009-08-26T19:16:57Z GenreLyrics Thank you MaSSaChRoNiC for suggesting this song to me. ["Music", "Roll", "Rock and roll"] ["glam metal", "heavy metal", "ballad", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "hard-hitting", "sentimental", "medium tempo"] 9 uiHyWdYkBvY 5133

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;