musiccaps_details (view)

2 rows where search matches "opera", musiccaps_aspects contains "choir" and musiccaps_aspects contains "male vocal"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_names (array) 4 ✖

musiccaps_author 1 ✖

  • 9 2
video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Queen - "We Are the Champions" Acapella (Vocals Only) Concert Mash-Up This is an isolated vocal track of a rock opera piece. There are no instruments. A passionate male vocalist is singing melodically in the lead. There is a choir in the background providing medium-to-high pitched back vocals. There is an uplifting atmosphere. This piece could be used in remixes. Vocal samples can be lifted for DJ sets or beat-making. 2015-12-30T08:49:25Z Playback.fm About video: http://playback.fm/blog/queen-we-are-the-champions-acapella/ - Follow us on Facebook: https://www.facebook.com/playbackapp We love Queen and Freddie Mercury, so we've edited 4 concert films including a rare recording session of "We Are The Champions" and synced them all up to the isolated vocals in honor of the late, great, Freddie Mercury. This video showcases his presence and consistency as the ultimate stage man. RIP Freddie. You are a rock god. ["Chant", "Music"] ["rock opera", "vocal track", "no instruments", "male vocal", "passionate singing", "choir", "dramatic", "uplifting", "vibrant"] 9 GF8QWSW0UbY 1701
Praying Mantis Eats Cricket This is a rock opera piece. There is a male vocalist singing passionately with a choir of backing vocals. The piano plays the main theme with the electric guitar while a bass guitar plays in the background. The rhythmic background is provided by the acoustic drums playing a simple rock beat. There is an energetic atmosphere to the piece. This piece could be used at sports venues. It could also be playing in the background of a bar. 2008-05-05T19:45:40Z caz50 One of my mantis nymphs munching on a cricket. ["Music", "Punk rock", "Grunge"] ["rock opera", "male vocal", "dramatic singing", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "rising pattern", "vibrant", "energetic"] 9 QqRrZzOY2xw 2642

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;