musiccaps_details (view)
2 rows where search matches "opera", musiccaps_aspects contains "choir", musiccaps_aspects contains "rock opera" and musiccaps_names contains "Music" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- choir · 2 ✖
- male vocal 2
- rock opera · 2 ✖
- vibrant 2
- acoustic drums 1
- bass guitar 1
- dramatic 1
- dramatic singing 1
- electric guitar 1
- energetic 1
- no instruments 1
- passionate singing 1
- piano 1
- rising pattern 1
- uplifting 1
- vocal track 1
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
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;